superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
241 rows where MNG_AG_TYP = 6
This data as json, copyable, CSV (advanced)
MNG_AGENCY 7
- Mountains Recreation and Conservation Authority 161
- Conejo Open Space Conservation Agency 31
- Riverside County Habitat Conservation Agency 8
- Western Riverside County Regional Conservation Authority 4
- Solano Tri-City and County Cooperative Planning Group 2
- San Dieguito River Park Joint Powers Authority 2
- Rancho Simi Open Space Conservation Agency 1
ACCESS_TYP 4
- Open Access 150
- Unknown Access 37
- No Public Access 15
- Restricted Access 7
MNG_AG_TYP 1
- Open Space District · 209 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2335 | 2335 | 2334 | {"type": "Polygon", "coordinates": [[[-117.302, 33.50915], [-117.30196, 33.50937], [-117.30152, 33.51056], [-117.30148, 33.51086], [-117.29504, 33.51202], [-117.29427, 33.50925], [-117.302, 33.50915]]]} | Open Access 1 | Clark/Tran | 17388 | 2179 | Western Riverside County Regional Conservation Authority 927 | Special District 4 | Open Space District 6 | http://www.wrc-rca.org/ | Special District 4 | 40.588 | Clark/Tran | ||
2476 | 2476 | 2475 | {"type": "MultiPolygon", "coordinates": [[[[-118.75742, 34.17567], [-118.75707, 34.17573], [-118.75691, 34.17574], [-118.75619, 34.17573], [-118.75599, 34.1757], [-118.75601, 34.17562], [-118.75621, 34.17564], [-118.75699, 34.17566], [-118.75718, 34.17563], [-118.7574, 34.17562], [-118.75742, 34.17567]]], [[[-118.81386, 34.17415], [-118.81282, 34.17421], [-118.81276, 34.17421], [-118.8138, 34.17382], [-118.81386, 34.17415]]], [[[-118.85352, 34.14608], [-118.85298, 34.14609], [-118.85268, 34.14624], [-118.85243, 34.146], [-118.85177, 34.14609], [-118.85156, 34.14605], [-118.85189, 34.14599], [-118.85311, 34.14584], [-118.85352, 34.14608]]], [[[-118.88309, 34.19376], [-118.88277, 34.19389], [-118.88271, 34.19392], [-118.88286, 34.19372], [-118.88309, 34.19376]]], [[[-118.93629, 34.16271], [-118.93619, 34.16328], [-118.93611, 34.16342], [-118.936, 34.16386], [-118.93569, 34.16383], [-118.93521, 34.16336], [-118.93529, 34.16303], [-118.93566, 34.16288], [-118.93619, 34.16269], [-118.93629, 34.16271]]]]} | Open Access 1 | Conejo Open Space Conservation Agency | 17584 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 3.507 | Conejo OS Conservation Agency | ||
2477 | 2477 | 2476 | {"type": "Polygon", "coordinates": [[[-118.35844, 34.12826], [-118.35816, 34.12829], [-118.35778, 34.12819], [-118.35737, 34.1283], [-118.35721, 34.12842], [-118.35729, 34.12852], [-118.3572, 34.12855], [-118.357, 34.12837], [-118.35633, 34.1287], [-118.35623, 34.12854], [-118.35641, 34.12844], [-118.35626, 34.12804], [-118.35678, 34.12806], [-118.35679, 34.12694], [-118.35496, 34.12692], [-118.35452, 34.12712], [-118.35418, 34.12695], [-118.35401, 34.12696], [-118.35403, 34.12666], [-118.35355, 34.12668], [-118.35355, 34.12658], [-118.35332, 34.12659], [-118.35333, 34.12656], [-118.35356, 34.12655], [-118.35358, 34.12643], [-118.3538, 34.12642], [-118.3538, 34.12633], [-118.35384, 34.12627], [-118.35486, 34.12551], [-118.35707, 34.12561], [-118.35844, 34.12826]]]} | Open Access 1 | Cahuenga Pass-Oakshire Open Space | 16658 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 17.014 | Cahuenga Pass-Oakshire OS | ||
2490 | 2490 | 2489 | {"type": "MultiPolygon", "coordinates": [[[[-118.64741, 34.12906], [-118.64387, 34.12905], [-118.64383, 34.12532], [-118.64738, 34.12533], [-118.64741, 34.12906]]], [[[-118.64813, 34.12927], [-118.64791, 34.12927], [-118.64791, 34.12906], [-118.64813, 34.12906], [-118.64813, 34.12927]]]]} | Open Access 1 | Calabasas Highlands Open Space | 16666 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 33.525 | Calabasas Highlands OS | ||
2683 | 2683 | 2682 | {"type": "Polygon", "coordinates": [[[-118.34398, 34.10983], [-118.34396, 34.10986], [-118.34393, 34.10999], [-118.34395, 34.1101], [-118.34376, 34.11029], [-118.34363, 34.10997], [-118.34368, 34.10981], [-118.34398, 34.10983]]]} | Open Access 1 | Castilian MRCA Open Space | 16949 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.278 | Castilian MRCA OS | ||
2956 | 2956 | 2955 | {"type": "MultiPolygon", "coordinates": [[[[-118.00435, 34.00067], [-118.00072, 34.00684], [-117.99905, 34.00616], [-117.99864, 34.00604], [-117.99812, 34.00594], [-117.99769, 34.00592], [-117.9972, 34.00594], [-117.99674, 34.00602], [-117.99655, 34.00606], [-117.99617, 34.00619], [-117.99577, 34.00638], [-117.99538, 34.00662], [-117.995, 34.00693], [-117.99481, 34.00713], [-117.99462, 34.00739], [-117.99442, 34.00773], [-117.99436, 34.00788], [-117.99402, 34.00902], [-117.99395, 34.00922], [-117.99391, 34.0093], [-117.99494, 34.00555], [-117.99575, 34.0047], [-117.99784, 34.0031], [-117.99943, 34.00314], [-118.00071, 34.00186], [-118.00161, 34.00193], [-118.00239, 34.00178], [-118.00309, 34.0011], [-118.00371, 34.00108], [-118.00435, 34.00067]]], [[[-118.01134, 34.00416], [-118.00978, 34.00681], [-118.00888, 34.00585], [-118.0079, 34.00194], [-118.00768, 34.00148], [-118.00739, 34.00133], [-118.00716, 34.00114], [-118.00703, 34.00099], [-118.00639, 34.00009], [-118.00618, 33.99988], [-118.00592, 33.9997], [-118.00515, 33.99931], [-118.00612, 33.99766], [-118.01134, 34.00416]]]]} | Unknown Access 4 | Hacienda Hills Open Space | 29675 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 102.314 | Hacienda Hills OS | ||
3071 | 3071 | 3070 | {"type": "Polygon", "coordinates": [[[-118.65872, 34.1181], [-118.65875, 34.11954], [-118.65875, 34.12258], [-118.65825, 34.12362], [-118.65788, 34.12454], [-118.65762, 34.12537], [-118.65719, 34.12711], [-118.65578, 34.12716], [-118.65575, 34.12658], [-118.6557, 34.12636], [-118.65558, 34.12611], [-118.65547, 34.12595], [-118.65536, 34.12584], [-118.65651, 34.12484], [-118.65513, 34.1243], [-118.65576, 34.12316], [-118.65511, 34.12151], [-118.65413, 34.12123], [-118.65451, 34.12027], [-118.6545, 34.12025], [-118.65205, 34.12026], [-118.65206, 34.12208], [-118.65154, 34.12208], [-118.65153, 34.1222], [-118.65159, 34.12225], [-118.65173, 34.12241], [-118.6518, 34.12246], [-118.65205, 34.12249], [-118.65206, 34.12236], [-118.65273, 34.12262], [-118.65218, 34.12362], [-118.65248, 34.12468], [-118.65252, 34.12476], [-118.65226, 34.1249], [-118.65214, 34.125], [-118.65203, 34.12512], [-118.65194, 34.12508], [-118.65088, 34.12498], [-118.65014, 34.12534], [-118.65024, 34.11939], [-118.65025, 34.1181], [-118.65872, 34.1181]]]} | Open Access 1 | Cold Creek - Secret Valley | 17480 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 118.962 | Cold Creek - Secret Valley | 2011 | |
3072 | 3072 | 3071 | {"type": "Polygon", "coordinates": [[[-118.66547, 34.09257], [-118.66492, 34.09257], [-118.66491, 34.09075], [-118.66545, 34.09076], [-118.66547, 34.09257]]]} | Restricted Access 2 | Cold Creek Canyon Preserve | 17481 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2.519 | Cold Creek Canyon Preserve | ||
3181 | 3181 | 3180 | {"type": "Polygon", "coordinates": [[[-118.57098, 34.15161], [-118.5709, 34.1527], [-118.57041, 34.15261], [-118.57021, 34.15331], [-118.56909, 34.15367], [-118.56414, 34.15241], [-118.56436, 34.1514], [-118.56346, 34.15075], [-118.56364, 34.14998], [-118.566, 34.15044], [-118.57098, 34.15161]]]} | Open Access 1 | Corbin Canyon Open Space | 17634 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 40.221 | Corbin Canyon OS | ||
3185 | 3185 | 3184 | {"type": "Polygon", "coordinates": [[[-118.7411, 34.05749], [-118.74092, 34.05786], [-118.74082, 34.05816], [-118.7408, 34.05841], [-118.74084, 34.05873], [-118.74079, 34.05887], [-118.74055, 34.05913], [-118.73983, 34.05963], [-118.73941, 34.06002], [-118.73937, 34.06002], [-118.73904, 34.06036], [-118.73898, 34.06039], [-118.73862, 34.06049], [-118.73861, 34.05982], [-118.73646, 34.0598], [-118.73647, 34.06711], [-118.73223, 34.0671], [-118.73221, 34.06341], [-118.72799, 34.06337], [-118.72376, 34.06341], [-118.72377, 34.05968], [-118.72801, 34.05966], [-118.72798, 34.05257], [-118.72792, 34.04546], [-118.72794, 34.04433], [-118.73349, 34.04417], [-118.73627, 34.04415], [-118.73629, 34.04573], [-118.73777, 34.04574], [-118.73779, 34.04734], [-118.7393, 34.04735], [-118.73952, 34.04825], [-118.73953, 34.04839], [-118.73935, 34.05001], [-118.73932, 34.05014], [-118.73921, 34.05037], [-118.73918, 34.05049], [-118.73917, 34.05129], [-118.73918, 34.05141], [-118.73935, 34.05186], [-118.73936, 34.052], [-118.73935, 34.05232], [-118.73936, 34.05244], [-118.73941, 34.05256], [-118.73968, 34.05298], [-118.73967, 34.05303], [-118.73958, 34.05331], [-118.73958, 34.0534], [-118.73962, 34.05346], [-118.7398, 34.05362], [-118.73985, 34.05369], [-118.73995, 34.0541], [-118.74, 34.05421], [-118.74006, 34.05428], [-118.74035, 34.05451], [-118.74036, 34.05475], [-118.74041, 34.05488], [-118.74047, 34.05495], [-118.74069, 34.05514], [-118.74072, 34.0552], [-118.74072, 34.05529], [-118.74051, 34.05566], [-118.74049, 34.05575], [-118.74049, 34.05584], [-118.74053, 34.05595], [-118.74083, 34.05651], [-118.74084, 34.05659], [-118.74081, 34.05699], [-118.74082, 34.05709], [-118.7411, 34.05749]]]} | No Public Access 3 | Corral Canyon | 17653 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 607.914 | Corral Canyon | ||
3341 | 3341 | 3340 | {"type": "Polygon", "coordinates": [[[-118.00977, 34.00681], [-118.00047, 34.02256], [-117.99322, 34.01961], [-117.99553, 34.01569], [-117.99582, 34.01579], [-117.99633, 34.01493], [-117.99605, 34.0148], [-118.00515, 33.99931], [-118.00592, 33.99969], [-118.00608, 33.99979], [-118.00624, 33.99992], [-118.00635, 34.00003], [-118.00702, 34.00098], [-118.00716, 34.00115], [-118.00742, 34.00135], [-118.00767, 34.00147], [-118.0079, 34.00193], [-118.00888, 34.00585], [-118.00977, 34.00681]]]} | Unknown Access 4 | Hacienda Hills Open Space - Sanitation District | 29676 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 419.345 | Hacienda Hills OS - Sanitation District | ||
3345 | 3345 | 3344 | {"type": "Polygon", "coordinates": [[[-118.44985, 34.49555], [-118.44095, 34.49537], [-118.44088, 34.48111], [-118.44536, 34.48112], [-118.44538, 34.48475], [-118.44984, 34.48473], [-118.44985, 34.49555]]]} | Unknown Access 4 | Texas Canyon Open Space | 29702 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 281.452 | Texas Canyon OS | ||
3354 | 3354 | 3353 | {"type": "MultiPolygon", "coordinates": [[[[-118.27963, 34.43891], [-118.27942, 34.44], [-118.27919, 34.43986], [-118.27895, 34.43975], [-118.27854, 34.4396], [-118.27563, 34.4389], [-118.27528, 34.43884], [-118.27503, 34.43882], [-118.27478, 34.43883], [-118.27453, 34.43886], [-118.27415, 34.43895], [-118.2739, 34.43904], [-118.27307, 34.43944], [-118.27278, 34.43957], [-118.27249, 34.43966], [-118.27218, 34.43973], [-118.27214, 34.43775], [-118.27694, 34.43776], [-118.27882, 34.43867], [-118.2793, 34.43883], [-118.27963, 34.43891]]], [[[-118.27986, 34.44135], [-118.27222, 34.44131], [-118.2722, 34.44029], [-118.2726, 34.44021], [-118.27309, 34.44005], [-118.2734, 34.43992], [-118.27412, 34.43956], [-118.27445, 34.43944], [-118.2748, 34.43938], [-118.27503, 34.43937], [-118.27527, 34.43939], [-118.27822, 34.44009], [-118.27858, 34.44021], [-118.27891, 34.44037], [-118.27921, 34.44059], [-118.27947, 34.44086], [-118.27986, 34.44135]]]]} | Open Access 1 | Bird's Nest | 33245 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 51.382 | Bird's Nest | 2018 | |
3422 | 3422 | 3421 | {"type": "Polygon", "coordinates": [[[-118.80384, 34.13634], [-118.80042, 34.13935], [-118.78741, 34.13631], [-118.777, 34.13531], [-118.77703, 34.1303], [-118.77642, 34.13028], [-118.77627, 34.13026], [-118.77606, 34.13018], [-118.77593, 34.1301], [-118.77583, 34.13001], [-118.77548, 34.12953], [-118.77573, 34.1294], [-118.77599, 34.12923], [-118.77622, 34.12905], [-118.77644, 34.12884], [-118.77663, 34.12862], [-118.77679, 34.12839], [-118.77694, 34.12813], [-118.77704, 34.12788], [-118.77712, 34.12763], [-118.77717, 34.12737], [-118.77785, 34.12235], [-118.77798, 34.12189], [-118.77811, 34.1216], [-118.77826, 34.12131], [-118.77855, 34.12091], [-118.77877, 34.12065], [-118.77951, 34.12141], [-118.79034, 34.12722], [-118.79411, 34.13556], [-118.80384, 34.13634]]]} | Unknown Access 4 | Truinfo Canyon Open Space | 29730 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 525.543 | Truinfo Canyon OS | ||
3423 | 3423 | 3422 | {"type": "Polygon", "coordinates": [[[-118.71787, 34.45684], [-118.71569, 34.45684], [-118.71568, 34.46041], [-118.71122, 34.4604], [-118.70698, 34.46033], [-118.70695, 34.45676], [-118.70268, 34.45668], [-118.70267, 34.45669], [-118.70272, 34.46026], [-118.69843, 34.46019], [-118.6982, 34.45301], [-118.70692, 34.45318], [-118.70696, 34.44953], [-118.71123, 34.44959], [-118.71339, 34.44958], [-118.71341, 34.45326], [-118.71611, 34.45327], [-118.71787, 34.45684]]]} | Unknown Access 4 | Holser Canyon Open Space | 29737 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 345.905 | Holser Canyon OS | ||
3504 | 3504 | 3503 | {"type": "Polygon", "coordinates": [[[-118.97218, 34.08094], [-118.96782, 34.08094], [-118.96786, 34.08027], [-118.96938, 34.08025], [-118.96951, 34.08007], [-118.97, 34.08001], [-118.97217, 34.08], [-118.97218, 34.08094]]]} | Open Access 1 | Deer Creek - Denman | 17992 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 9.161 | Deer Creek - Denman | ||
3509 | 3509 | 3508 | {"type": "MultiPolygon", "coordinates": [[[[-118.59473, 34.28578], [-118.59293, 34.28578], [-118.59293, 34.285], [-118.59312, 34.285], [-118.59312, 34.28575], [-118.59472, 34.28575], [-118.59473, 34.28578]]], [[[-118.59361, 34.28526], [-118.59361, 34.28556], [-118.59351, 34.28556], [-118.59352, 34.28526], [-118.59361, 34.28526]]], [[[-118.59668, 34.28578], [-118.59486, 34.28578], [-118.59486, 34.28575], [-118.59668, 34.28575], [-118.59668, 34.28578]]], [[[-118.60597, 34.28577], [-118.60597, 34.28579], [-118.59688, 34.28578], [-118.59688, 34.28575], [-118.60597, 34.28577]]], [[[-118.60374, 34.28244], [-118.60374, 34.28248], [-118.60327, 34.28222], [-118.59971, 34.28221], [-118.59971, 34.28219], [-118.60328, 34.28219], [-118.60374, 34.28244]]], [[[-118.60598, 34.2846], [-118.6054, 34.2846], [-118.60471, 34.2841], [-118.60429, 34.28329], [-118.6043, 34.28325], [-118.60474, 34.28409], [-118.60541, 34.28457], [-118.60598, 34.28457], [-118.60598, 34.2846]]]]} | Open Access 1 | Deer Lake Highlands | 17998 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1.803 | Deer Lake Highlands | ||
3623 | 3623 | 3622 | {"type": "MultiPolygon", "coordinates": [[[[-118.52781, 34.12892], [-118.52765, 34.12897], [-118.52752, 34.12899], [-118.52699, 34.12889], [-118.5269, 34.12887], [-118.52682, 34.12882], [-118.52674, 34.12872], [-118.52724, 34.12879], [-118.52781, 34.12892]]], [[[-118.52963, 34.12976], [-118.52948, 34.12986], [-118.5294, 34.12995], [-118.52935, 34.12974], [-118.52925, 34.12956], [-118.52963, 34.12976]]]]} | Open Access 1 | Dirt Mulholland | 18160 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.435 | Dirt Mulholland | ||
3970 | 3970 | 3969 | {"type": "Polygon", "coordinates": [[[-118.50435, 34.35233], [-118.50411, 34.3598], [-118.50187, 34.35977], [-118.50122, 34.35577], [-118.50113, 34.35579], [-118.50065, 34.35976], [-118.49677, 34.35971], [-118.49673, 34.35931], [-118.49638, 34.35751], [-118.49516, 34.35161], [-118.4988, 34.35155], [-118.49896, 34.35224], [-118.50417, 34.35214], [-118.50435, 34.35233]]]} | Open Access 1 | Elsmere Canyon Park | 18606 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 155.062 | Elsmere Canyon Park | ||
3971 | 3971 | 3970 | {"type": "MultiPolygon", "coordinates": [[[[-118.22626, 34.10083], [-118.2251, 34.10204], [-118.2248, 34.10191], [-118.2246, 34.10211], [-118.2248, 34.10235], [-118.22469, 34.10246], [-118.22448, 34.10225], [-118.22414, 34.10259], [-118.22434, 34.10283], [-118.22328, 34.10393], [-118.22546, 34.10544], [-118.22513, 34.10557], [-118.2228, 34.10398], [-118.22289, 34.10389], [-118.22288, 34.10387], [-118.22041, 34.10391], [-118.22088, 34.1022], [-118.22161, 34.10217], [-118.22172, 34.10212], [-118.2218, 34.10203], [-118.22179, 34.10197], [-118.22173, 34.10193], [-118.22175, 34.10164], [-118.22162, 34.10134], [-118.2215, 34.10138], [-118.22152, 34.10147], [-118.22133, 34.10152], [-118.22133, 34.10135], [-118.22132, 34.10134], [-118.22045, 34.1016], [-118.22027, 34.1012], [-118.22067, 34.10102], [-118.2211, 34.10072], [-118.22167, 34.10122], [-118.22188, 34.10015], [-118.2227, 34.10039], [-118.22367, 34.10062], [-118.22387, 34.10034], [-118.22417, 34.10045], [-118.2244, 34.1001], [-118.22503, 34.10036], [-118.22514, 34.10036], [-118.22626, 34.10083]]], [[[-118.2272, 34.10176], [-118.22703, 34.10209], [-118.22661, 34.10185], [-118.22601, 34.10163], [-118.22614, 34.10138], [-118.2272, 34.10176]]], [[[-118.22675, 34.10103], [-118.22654, 34.10144], [-118.22607, 34.10127], [-118.22603, 34.10123], [-118.22605, 34.10118], [-118.22635, 34.10087], [-118.22675, 34.10103]]]]} | Open Access 1 | Elyria Canyon Park | 18607 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 37.644 | Elyria Canyon Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);