units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where ACCESS_TYP = 1 and YR_EST = 1997
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, DES_TP
MNG_AGENCY 5
MNG_AG_TYP 4
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1450 | 1450 | 1449 | {"type": "Polygon", "coordinates": [[[-121.79984, 37.29776], [-121.79995, 37.29788], [-121.80108, 37.29865], [-121.80193, 37.29927], [-121.80227, 37.29957], [-121.80229, 37.29962], [-121.80228, 37.29968], [-121.80223, 37.29972], [-121.80217, 37.29974], [-121.80167, 37.29976], [-121.80127, 37.29971], [-121.80083, 37.29959], [-121.80041, 37.29941], [-121.80028, 37.29934], [-121.79935, 37.29865], [-121.79849, 37.29807], [-121.7982, 37.29794], [-121.79762, 37.29775], [-121.79726, 37.2977], [-121.79688, 37.29768], [-121.79618, 37.29772], [-121.79586, 37.29771], [-121.79542, 37.29766], [-121.79511, 37.29759], [-121.79493, 37.29754], [-121.79489, 37.2975], [-121.79488, 37.29746], [-121.79492, 37.29733], [-121.79496, 37.2973], [-121.79501, 37.29728], [-121.79528, 37.29728], [-121.79537, 37.29731], [-121.79733, 37.29722], [-121.79798, 37.29744], [-121.79841, 37.29762], [-121.79914, 37.29778], [-121.79984, 37.29776]]]} | Open Access 1 | 9709 | Silver Creek Linear Park | 25483 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 11.638 | Silver Creek Linear Park | 1997 | Local Park 2 | 4 | |
1812 | 1812 | 1811 | {"type": "Polygon", "coordinates": [[[-121.89561, 37.25718], [-121.89547, 37.25727], [-121.89533, 37.25733], [-121.89499, 37.25756], [-121.89484, 37.2574], [-121.89484, 37.25737], [-121.89487, 37.25734], [-121.89544, 37.25705], [-121.89551, 37.25706], [-121.89561, 37.25718]]]} | Open Access 1 | 13746 | Scottsdale Park | 25216 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.386 | Scottsdale Park | 1997 | Local Park 2 | 4 | |
2823 | 2823 | 2822 | {"type": "Polygon", "coordinates": [[[-121.7916, 37.29481], [-121.79152, 37.2951], [-121.79051, 37.29593], [-121.78977, 37.29536], [-121.78935, 37.29509], [-121.7902, 37.29439], [-121.7916, 37.29481]]]} | Open Access 1 | 22000 | Silver Creek Linear Park: Picnic Meadow | 25484 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 4.532 | Silver Creek Linear Park: Picnic Meadow | 1997 | None 233 | ||
4281 | 4281 | 4280 | {"type": "Polygon", "coordinates": [[[-120.23679, 37.96123], [-120.23635, 37.96123], [-120.23635, 37.96102], [-120.23679, 37.96102], [-120.23679, 37.96123]]]} | Open Access 1 | 48059 | Reid Park | 32551 | 2169 | Tuolumne Park and Recreation District 741 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | https://www.tuolumnerecreation.com/TPRD_facilities.html | Tuolumne 21 | 0.215 | Reid Park | 1997 | Local Park 2 | 4 |
8579 | 8579 | 8578 | {"type": "Polygon", "coordinates": [[[-121.77072, 37.22196], [-121.77013, 37.22259], [-121.76976, 37.22234], [-121.76988, 37.22226], [-121.76994, 37.22218], [-121.77006, 37.22183], [-121.77011, 37.22179], [-121.77017, 37.22179], [-121.77036, 37.22183], [-121.77072, 37.22196]]]} | Open Access 1 | 13626 | Avenida Espana Park | 15723 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.924 | Avenida Espana Park | 1997 | Local Park 2 | 4 | |
8884 | 8884 | 8883 | {"type": "Polygon", "coordinates": [[[-122.032, 37.32214], [-122.032, 37.3226], [-122.03199, 37.32268], [-122.03153, 37.32232], [-122.03175, 37.32214], [-122.032, 37.32214]]]} | Open Access 1 | 14521 | Cali Mill Plaza | 16683 | 1076 | Cupertino, City of 195 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | Santa Clara 19 | 0.367 | Cali Mill Plaza | 1997 | Local Park 2 | 4 | |
9593 | 9593 | 9592 | {"type": "Polygon", "coordinates": [[[-121.86656, 37.26253], [-121.86634, 37.26259], [-121.86631, 37.26264], [-121.86612, 37.26268], [-121.86603, 37.26264], [-121.86578, 37.26271], [-121.86579, 37.26276], [-121.86552, 37.26284], [-121.86549, 37.26281], [-121.8655, 37.26279], [-121.8654, 37.26259], [-121.86514, 37.26266], [-121.86515, 37.2627], [-121.86503, 37.26273], [-121.86503, 37.26276], [-121.86487, 37.26281], [-121.86469, 37.26241], [-121.86488, 37.26235], [-121.8649, 37.26233], [-121.86488, 37.26229], [-121.86547, 37.26213], [-121.86548, 37.26206], [-121.86552, 37.26198], [-121.86559, 37.262], [-121.86566, 37.26197], [-121.86566, 37.26231], [-121.86643, 37.26232], [-121.86647, 37.26245], [-121.86656, 37.26253]]]} | Open Access 1 | 16134 | Erikson Park | 18694 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.868 | Erikson Park | 1997 | Local Park 2 | 4 | |
14700 | 14700 | 14699 | {"type": "Polygon", "coordinates": [[[-119.17097, 34.46273], [-119.16225, 34.46274], [-119.16227, 34.45928], [-119.17096, 34.45919], [-119.17097, 34.46273]]]} | Open Access 1 | 48311 | Ilvento Preserve | 32879 | 3296 | Ojai Valley Land Conservancy 1112 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | https://ovlc.org/preserves/ilvento/ | Ventura 8 | 76.715 | Ilvento Preserve | 1997 | Private Conservation 16 | 2 |
16698 | 16698 | 16697 | {"type": "Polygon", "coordinates": [[[-120.44787, 41.42527], [-120.44782, 41.42894], [-120.44775, 41.43227], [-120.44781, 41.43246], [-120.44775, 41.43252], [-120.44767, 41.43609], [-120.44282, 41.43607], [-120.44288, 41.43251], [-120.42831, 41.43248], [-120.4282, 41.44314], [-120.40862, 41.44283], [-120.40848, 41.42877], [-120.4057, 41.42856], [-120.40484, 41.42831], [-120.40443, 41.42816], [-120.4042, 41.42805], [-120.40388, 41.42803], [-120.40362, 41.42793], [-120.40324, 41.42773], [-120.40259, 41.42746], [-120.4023, 41.4274], [-120.40201, 41.42738], [-120.40166, 41.4274], [-120.40139, 41.42747], [-120.4011, 41.42748], [-120.40087, 41.42745], [-120.40069, 41.4274], [-120.40018, 41.42709], [-120.40005, 41.42679], [-120.39991, 41.42676], [-120.39983, 41.42671], [-120.39982, 41.42655], [-120.39975, 41.42646], [-120.39957, 41.42639], [-120.39921, 41.42616], [-120.39891, 41.42609], [-120.3986, 41.42605], [-120.39846, 41.42597], [-120.39828, 41.42589], [-120.39804, 41.42584], [-120.39777, 41.42554], [-120.39728, 41.42522], [-120.39708, 41.42512], [-120.39696, 41.42509], [-120.39632, 41.42507], [-120.39606, 41.42508], [-120.39511, 41.42495], [-120.39418, 41.42473], [-120.39373, 41.4247], [-120.3934, 41.42474], [-120.39316, 41.42486], [-120.39252, 41.42512], [-120.3922, 41.42521], [-120.39173, 41.4253], [-120.39148, 41.42532], [-120.39121, 41.42532], [-120.39091, 41.42529], [-120.39068, 41.42523], [-120.39045, 41.42515], [-120.39023, 41.42505], [-120.38995, 41.42498], [-120.38971, 41.42499], [-120.38884, 41.42509], [-120.3887, 41.42508], [-120.38809, 41.42477], [-120.38774, 41.4247], [-120.38749, 41.42461], [-120.38709, 41.42444], [-120.38672, 41.42432], [-120.38632, 41.42425], [-120.38548, 41.42425], [-120.38407, 41.42419], [-120.38362, 41.42412], [-120.38246, 41.42401], [-120.38166, 41.42406], [-120.38055, 41.42403], [-120.38005, 41.42398], [-120.37976, 41.42392], [-120.37909, 41.42371], [-120.37826, 41.42349], [-120.37777, 41.42335], [-120.37742, 41.42327], [-120.37705, 41.42327], [-120.37668, 41.4233], [-120.37637, 41.42335], [-120.37592, 41.42349], [-120.3757, 41.42352], [-120.37541, 41.42352], [-120.37518, 41.42348], [-120.37503, 41.42343], [-120.37465, 41.42338], [-120.37444, 41.42332], [-120.37432, 41.4232], [-120.37416, 41.42312], [-120.37398, 41.42309], [-120.37368, 41.42312], [-120.37344, 41.42311], [-120.37331, 41.42306], [-120.37316, 41.42286], [-120.37273, 41.42283], [-120.37226, 41.42271], [-120.3719, 41.42253], [-120.37145, 41.4222], [-120.37129, 41.42212], [-120.37066, 41.42197], [-120.36958, 41.42149], [-120.36914, 41.42141], [-120.36816, 41.42119], [-120.36796, 41.42119], [-120.3678, 41.42116], [-120.36764, 41.42111], [-120.36734, 41.42097], [-120.36724, 41.42088], [-120.36722, 41.42081], [-120.36709, 41.42069], [-120.3669, 41.4206], [-120.36647, 41.42049], [-120.36608, 41.42045], [-120.36573, 41.42045], [-120.36551, 41.42052], [-120.36535, 41.42054], [-120.36493, 41.4204], [-120.36463, 41.42035], [-120.36388, 41.42028], [-120.36346, 41.42026], [-120.36298, 41.42029], [-120.36224, 41.42026], [-120.36193, 41.42021], [-120.36167, 41.42013], [-120.36153, 41.42006], [-120.36135, 41.41992], [-120.36116, 41.41984], [-120.36042, 41.41964], [-120.35997, 41.41961], [-120.35941, 41.41952], [-120.35942, 41.41715], [-120.35461, 41.41713], [-120.35466, 41.41351], [-120.37011, 41.41356], [-120.37446, 41.41354], [-120.37438, 41.42113], [-120.38646, 41.42126], [-120.40888, 41.42134], [-120.40888, 41.42151], [-120.42851, 41.42161], [-120.43822, 41.42163], [-120.43815, 41.42525], [-120.44787, 41.42527]], [[-120.42407, 41.42367], [-120.42447, 41.42337], [-120.42453, 41.423], [-120.42432, 41.42243], [-120.42413, 41.42232], [-120.4235, 41.42232], [-120.42261, 41.422], [-120.42189, 41.42202], [-120.42116, 41.42223], [-120.42067, 41.42262], [-120.42064, 41.42284], [-120.42091, 41.423], [-120.42179, 41.4233], [-120.42319, 41.42405], [-120.42359, 41.42412], [-120.42401, 41.42387], [-120.42407, 41.42367]]]} | Open Access 1 | 3078 | Pine Creek Wildlife Area | 30487 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Pine-Creek-WA | Modoc 56 | 2028.632 | Pine Creek Wildlife Area | 1997 | State Conservation Area 8 | 2 |
16774 | 16774 | 16773 | {"type": "Polygon", "coordinates": [[[-120.86553, 35.31438], [-120.86552, 35.31585], [-120.8655, 35.31606], [-120.86538, 35.31654], [-120.86541, 35.31685], [-120.86529, 35.31688], [-120.865, 35.31687], [-120.86458, 35.31689], [-120.86426, 35.31697], [-120.86413, 35.31703], [-120.86404, 35.31711], [-120.86391, 35.31729], [-120.86386, 35.31743], [-120.86381, 35.31751], [-120.86374, 35.31758], [-120.86367, 35.31773], [-120.86371, 35.31817], [-120.86375, 35.31829], [-120.86383, 35.31845], [-120.86386, 35.31857], [-120.86386, 35.31868], [-120.86376, 35.31884], [-120.86369, 35.31893], [-120.86335, 35.31904], [-120.86323, 35.3191], [-120.86314, 35.31919], [-120.86311, 35.31939], [-120.86315, 35.3196], [-120.86313, 35.31975], [-120.86302, 35.31987], [-120.86294, 35.32002], [-120.8629, 35.32029], [-120.86261, 35.32054], [-120.86251, 35.32093], [-120.86242, 35.32103], [-120.86216, 35.32114], [-120.86212, 35.32118], [-120.86209, 35.32155], [-120.86207, 35.32169], [-120.86197, 35.32211], [-120.86197, 35.32222], [-120.86211, 35.32244], [-120.86224, 35.32259], [-120.86251, 35.32307], [-120.86254, 35.32317], [-120.86255, 35.32329], [-120.86251, 35.3234], [-120.86231, 35.32361], [-120.86209, 35.3238], [-120.86175, 35.32403], [-120.86141, 35.32418], [-120.86105, 35.32437], [-120.86064, 35.32461], [-120.86048, 35.32478], [-120.8603, 35.32502], [-120.86023, 35.32529], [-120.86023, 35.32547], [-120.86025, 35.32573], [-120.86025, 35.32608], [-120.86023, 35.3264], [-120.86029, 35.3266], [-120.86054, 35.32725], [-120.86053, 35.32738], [-120.86048, 35.32749], [-120.8604, 35.32755], [-120.8603, 35.32761], [-120.86002, 35.32766], [-120.85981, 35.32775], [-120.85971, 35.32784], [-120.85957, 35.32796], [-120.85952, 35.3281], [-120.8595, 35.32826], [-120.85949, 35.32841], [-120.85953, 35.32853], [-120.85973, 35.32881], [-120.85994, 35.32905], [-120.86027, 35.32933], [-120.86032, 35.32942], [-120.86029, 35.32988], [-120.86023, 35.32999], [-120.86013, 35.33006], [-120.85999, 35.33011], [-120.85992, 35.33018], [-120.85981, 35.33046], [-120.85977, 35.33064], [-120.85962, 35.33094], [-120.85953, 35.33105], [-120.85949, 35.33116], [-120.8594, 35.33124], [-120.85932, 35.33136], [-120.8593, 35.3315], [-120.85926, 35.33201], [-120.85927, 35.33237], [-120.8594, 35.33251], [-120.85945, 35.33258], [-120.85945, 35.33268], [-120.85942, 35.3328], [-120.85933, 35.33299], [-120.85931, 35.33309], [-120.85934, 35.3332], [-120.85939, 35.33327], [-120.85943, 35.33338], [-120.85953, 35.33375], [-120.85966, 35.33394], [-120.85967, 35.33403], [-120.85961, 35.33426], [-120.85952, 35.33439], [-120.8594, 35.33444], [-120.85929, 35.33447], [-120.85897, 35.33448], [-120.85886, 35.3345], [-120.85853, 35.33465], [-120.8582, 35.33472], [-120.85774, 35.3348], [-120.85744, 35.33494], [-120.85735, 35.33506], [-120.85736, 35.33511], [-120.8574, 35.33516], [-120.85742, 35.33534], [-120.85748, 35.33545], [-120.85765, 35.33565], [-120.85773, 35.33584], [-120.85774, 35.33589], [-120.85771, 35.33604], [-120.85774, 35.33615], [-120.85771, 35.33618], [-120.8577, 35.33623], [-120.85776, 35.33641], [-120.85776, 35.33646], [-120.85772, 35.33653], [-120.85771, 35.33666], [-120.85771, 35.337], [-120.85774, 35.33706], [-120.85793, 35.33727], [-120.85806, 35.33746], [-120.85814, 35.33768], [-120.8582, 35.33788], [-120.85821, 35.33798], [-120.85819, 35.33806], [-120.85813, 35.33816], [-120.85823, 35.33869], [-120.85832, 35.33894], [-120.85871, 35.33968], [-120.85897, 35.34028], [-120.85911, 35.34088], [-120.8591, 35.34092], [-120.85881, 35.34108], [-120.85861, 35.34126], [-120.85847, 35.34148], [-120.85843, 35.34157], [-120.85841, 35.34176], [-120.85842, 35.34187], [-120.85845, 35.342], [-120.85844, 35.34212], [-120.8584, 35.34214], [-120.8583, 35.34216], [-120.85818, 35.34221], [-120.85809, 35.34227], [-120.85793, 35.3426], [-120.85792, 35.34266], [-120.85793, 35.34275], [-120.85798, 35.34286], [-120.858, 35.34318], [-120.85803, 35.34323], [-120.85813, 35.34329], [-120.85818, 35.34329], [-120.8582, 35.34321], [-120.85824, 35.34321], [-120.85826, 35.34324], [-120.85826, 35.34332], [-120.85823, 35.3435], [-120.85819, 35.34361], [-120.85815, 35.34365], [-120.85782, 35.34366], [-120.85771, 35.34371], [-120.85764, 35.34377], [-120.85759, 35.34385], [-120.85757, 35.34411], [-120.85757, 35.34433], [-120.85756, 35.34443], [-120.85753, 35.3445], [-120.85725, 35.34472], [-120.85717, 35.34481], [-120.85703, 35.34506], [-120.85698, 35.34519], [-120.85696, 35.34531], [-120.85682, 35.34549], [-120.85646, 35.34586], [-120.85635, 35.34613], [-120.85631, 35.34616], [-120.85624, 35.34617], [-120.85614, 35.34639], [-120.85615, 35.34663], [-120.8561, 35.34688], [-120.85635, 35.34733], [-120.85669, 35.34759], [-120.8568, 35.3477], [-120.85706, 35.34804], [-120.85709, 35.3481], [-120.85709, 35.34823], [-120.85718, 35.34844], [-120.85737, 35.3487], [-120.85765, 35.34901], [-120.85797, 35.34927], [-120.85817, 35.34943], [-120.85836, 35.34953], [-120.85842, 35.34959], [-120.85862, 35.34983], [-120.85888, 35.3501], [-120.8593, 35.35076], [-120.85949, 35.3511], [-120.8598, 35.35285], [-120.8435, 35.34928], [-120.84339, 35.34885], [-120.84365, 35.34772], [-120.8439, 35.34737], [-120.84419, 35.34728], [-120.84433, 35.34699], [-120.84463, 35.34665], [-120.84442, 35.3464], [-120.84426, 35.3463], [-120.84344, 35.33164], [-120.84359, 35.33146], [-120.84422, 35.33056], [-120.8442, 35.33055], [-120.84479, 35.32897], [-120.84465, 35.3283], [-120.84226, 35.32727], [-120.84199, 35.32714], [-120.84115, 35.3268], [-120.84051, 35.32616], [-120.84035, 35.32593], [-120.84027, 35.32511], [-120.84041, 35.32436], [-120.84069, 35.3238], [-120.84157, 35.32248], [-120.84305, 35.32222], [-120.84319, 35.32215], [-120.84526, 35.32195], [-120.84642, 35.32149], [-120.84804, 35.32132], [-120.84815, 35.32137], [-120.84822, 35.32126], [-120.84987, 35.32176], [-120.85038, 35.32168], [-120.85046, 35.32165], [-120.85057, 35.32155], [-120.85063, 35.32158], [-120.85076, 35.32147], [-120.85092, 35.32139], [-120.85086, 35.32134], [-120.8521, 35.31941], [-120.85215, 35.3193], [-120.85317, 35.31855], [-120.85361, 35.3181], [-120.854, 35.31778], [-120.85604, 35.31827], [-120.86108, 35.31702], [-120.86109, 35.31665], [-120.86149, 35.3165], [-120.86209, 35.31614], [-120.86232, 35.31618], [-120.86299, 35.31589], [-120.86362, 35.31574], [-120.86426, 35.31556], [-120.86491, 35.31515], [-120.86527, 35.31474], [-120.86552, 35.31443], [-120.86553, 35.31438]]]} | Open Access 1 | 25324 | Morro Bay Wildlife Area | 30475 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Luis Obispo 1 | 1266.86 | Morro Bay Wildlife Area | 1997 | State Conservation Area 8 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);