units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 4
- Open Access 14,490
- Restricted Access 1,203
- No Public Access 969
- Unknown Access 386
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
616 | 616 | 615 | {"type": "Polygon", "coordinates": [[[-119.3355, 36.20739], [-119.33118, 36.20737], [-119.33122, 36.2057], [-119.33122, 36.20386], [-119.33545, 36.20385], [-119.3355, 36.20739]]]} | Open Access 1 | 964 | Tulare Cemetery | 26563 | 2167 | Tulare Cemetery District 223 | Special District 4 | Cemetery District 11 | Special District 4 | 2167 | Tulare Cemetery District 219 | Special District 4 | Cemetery District 11 | Tulare 29 | 37.023 | Tulare Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
749 | 749 | 748 | {"type": "Polygon", "coordinates": [[[-119.62108, 36.558], [-119.62104, 36.55974], [-119.62088, 36.55974], [-119.62087, 36.55979], [-119.61988, 36.55979], [-119.61991, 36.558], [-119.62036, 36.55799], [-119.62108, 36.558]]]} | Open Access 1 | 4873 | West Selma Cemetery | 27375 | 2148 | Selma Cemetery District 251 | Special District 4 | Cemetery District 11 | Special District 4 | 2148 | Selma Cemetery District 247 | Special District 4 | Cemetery District 11 | Fresno 9 | 5.109 | West Selma Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
818 | 818 | 817 | {"type": "Polygon", "coordinates": [[[-117.1878, 34.44347], [-117.18605, 34.44348], [-117.18605, 34.44269], [-117.18779, 34.44268], [-117.1878, 34.44347]]]} | Open Access 1 | 5287 | Mendel Park | 22148 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 3.478 | Mendel Park | 0 | Local Park 2 | 4 | ||
910 | 910 | 909 | {"type": "Polygon", "coordinates": [[[-117.21458, 34.53082], [-117.21419, 34.53082], [-117.21418, 34.53128], [-117.21261, 34.53128], [-117.2126, 34.53013], [-117.21265, 34.53009], [-117.21457, 34.53009], [-117.21458, 34.53082]]]} | Open Access 1 | 5810 | Thunderbird Park | 26338 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 5.461 | Thunderbird Park | 0 | Local Park 2 | 4 | ||
911 | 911 | 910 | {"type": "Polygon", "coordinates": [[[-118.51445, 34.12995], [-118.51442, 34.13004], [-118.51434, 34.1301], [-118.51426, 34.13013], [-118.51414, 34.13012], [-118.51299, 34.12951], [-118.51312, 34.12943], [-118.5133, 34.12937], [-118.51381, 34.12933], [-118.51442, 34.12983], [-118.51445, 34.12991], [-118.51445, 34.12995]]]} | No Public Access 3 | 6367 | Encino Reservoir - Federal | 18670 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 1.48 | Encino Reservoir - Federal | 0 | Resource Management Area 82 | 3 | ||
947 | 947 | 946 | {"type": "MultiPolygon", "coordinates": [[[[-118.30927, 33.77858], [-118.30758, 33.77901], [-118.3066, 33.7792], [-118.30555, 33.77935], [-118.30359, 33.77951], [-118.30379, 33.77922], [-118.30356, 33.7791], [-118.30373, 33.77882], [-118.30371, 33.77863], [-118.30258, 33.77836], [-118.30228, 33.77858], [-118.30213, 33.77866], [-118.30196, 33.77871], [-118.30179, 33.77874], [-118.30145, 33.77873], [-118.30114, 33.77863], [-118.30124, 33.77834], [-118.3011, 33.7783], [-118.30143, 33.77756], [-118.3013, 33.77738], [-118.30092, 33.7772], [-118.30093, 33.77658], [-118.30075, 33.77653], [-118.30073, 33.77656], [-118.3002, 33.77642], [-118.30015, 33.77669], [-118.30004, 33.7768], [-118.29989, 33.77685], [-118.29945, 33.77691], [-118.29942, 33.77696], [-118.29941, 33.77494], [-118.296, 33.77494], [-118.2959, 33.77466], [-118.29444, 33.77083], [-118.29424, 33.77018], [-118.29413, 33.76975], [-118.29404, 33.76934], [-118.29402, 33.76908], [-118.29401, 33.76865], [-118.29405, 33.76753], [-118.29404, 33.76724], [-118.294, 33.76667], [-118.29394, 33.76629], [-118.29718, 33.76629], [-118.29719, 33.76641], [-118.29801, 33.76687], [-118.29825, 33.76705], [-118.29891, 33.76743], [-118.29912, 33.76759], [-118.29932, 33.7677], [-118.30005, 33.76787], [-118.30059, 33.76797], [-118.30179, 33.76827], [-118.30185, 33.76825], [-118.30188, 33.76819], [-118.30407, 33.76881], [-118.30522, 33.76959], [-118.30699, 33.77065], [-118.30701, 33.77105], [-118.30741, 33.77167], [-118.30772, 33.77175], [-118.30895, 33.77159], [-118.30875, 33.77225], [-118.30863, 33.77282], [-118.30859, 33.77321], [-118.3086, 33.77377], [-118.30863, 33.77407], [-118.30927, 33.77858]]], [[[-118.30012, 33.77981], [-118.29971, 33.77989], [-118.29931, 33.78001], [-118.29894, 33.78016], [-118.29858, 33.78034], [-118.29825, 33.78056], [-118.29796, 33.78081], [-118.29759, 33.78122], [-118.2974, 33.78122], [-118.29726, 33.78129], [-118.29689, 33.78086], [-118.29719, 33.7805], [-118.29739, 33.7803], [-118.2976, 33.78013], [-118.2979, 33.77991], [-118.29838, 33.77962], [-118.29904, 33.77935], [-118.29933, 33.77926], [-118.29938, 33.77939], [-118.29967, 33.77967], [-118.29978, 33.77974], [-118.3001, 33.77979], [-118.30012, 33.77981]]]]} | Restricted Access 2 | 5975 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 18013 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 326.646 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 0 | Federal Other or Unknown 87 | 4 | ||
994 | 994 | 993 | {"type": "Polygon", "coordinates": [[[-118.25629, 33.79377], [-118.25421, 33.79388], [-118.2541, 33.79231], [-118.25461, 33.79228], [-118.25462, 33.79225], [-118.25616, 33.79216], [-118.25616, 33.79219], [-118.25618, 33.79219], [-118.25629, 33.79377]]]} | Open Access 1 | 6195 | Wilmington Cemetery | 27598 | 2182 | Wilmington Public Cemetery District 302 | Special District 4 | Cemetery District 11 | Special District 4 | 2182 | Wilmington Public Cemetery District 298 | Special District 4 | Cemetery District 11 | Los Angeles 6 | 8.461 | Wilmington Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
1165 | 1165 | 1164 | {"type": "Polygon", "coordinates": [[[-116.90615, 32.72851], [-116.90484, 32.7283], [-116.90399, 32.72803], [-116.90394, 32.72518], [-116.90608, 32.72533], [-116.90615, 32.72851]]]} | Open Access 1 | 7381 | San Diego National Wildlife Refuge | 24858 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | San Diego 4 | 16.779 | San Diego NWR | 1996 | National Wildlife Refuge 105 | 2 | ||
1200 | 1200 | 1199 | {"type": "MultiPolygon", "coordinates": [[[[-117.90541, 34.1585], [-117.90453, 34.15837], [-117.90437, 34.15839], [-117.90421, 34.15845], [-117.904, 34.15843], [-117.90408, 34.15835], [-117.90423, 34.15828], [-117.9044, 34.15824], [-117.90456, 34.15824], [-117.9054, 34.15837], [-117.90541, 34.1585]]], [[[-117.90754, 34.15868], [-117.90754, 34.15881], [-117.90649, 34.15867], [-117.90649, 34.15852], [-117.90754, 34.15868]]], [[[-117.90401, 34.15871], [-117.90397, 34.15877], [-117.90371, 34.15961], [-117.9033, 34.15961], [-117.90163, 34.16004], [-117.89984, 34.1611], [-117.89886, 34.16208], [-117.89885, 34.16256], [-117.89881, 34.16256], [-117.89882, 34.16212], [-117.89861, 34.16211], [-117.89973, 34.16101], [-117.90022, 34.1607], [-117.89901, 34.16124], [-117.89884, 34.16139], [-117.8987, 34.16156], [-117.89728, 34.16357], [-117.89714, 34.16374], [-117.89686, 34.164], [-117.89655, 34.1642], [-117.89633, 34.16431], [-117.89605, 34.16441], [-117.89461, 34.1647], [-117.89323, 34.16486], [-117.89298, 34.16493], [-117.89253, 34.16513], [-117.89224, 34.16513], [-117.89224, 34.1651], [-117.89289, 34.16481], [-117.89305, 34.16475], [-117.89459, 34.16456], [-117.89597, 34.16429], [-117.89617, 34.16423], [-117.8964, 34.16412], [-117.89668, 34.16396], [-117.89684, 34.16383], [-117.89705, 34.16361], [-117.89856, 34.16149], [-117.89868, 34.16134], [-117.8989, 34.16114], [-117.90321, 34.15912], [-117.90322, 34.1591], [-117.90317, 34.15875], [-117.90362, 34.1587], [-117.90401, 34.15871]], [[-117.90325, 34.15927], [-117.90321, 34.15927], [-117.90307, 34.15933], [-117.90229, 34.15971], [-117.90327, 34.15948], [-117.90325, 34.15927]]]]} | Open Access 1 | 6939 | San Gabriel River | 24896 | 2137 | San Gabriel River Water Committee 332 | Special District 4 | Water District 13 | Special District 4 | 2137 | San Gabriel River Water Committee 329 | Special District 4 | Water District 13 | Los Angeles 6 | 8.661 | San Gabriel River | 0 | None 106 | |||
1281 | 1281 | 1280 | {"type": "Polygon", "coordinates": [[[-117.5581, 34.18262], [-117.55072, 34.18265], [-117.5507, 34.17938], [-117.55806, 34.1794], [-117.5581, 34.18262]]]} | Open Access 1 | 9910 | Richland Mitigation | 24337 | 3089 | The Habitat Trust 340 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3089 | The Habitat Trust 337 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 60.516 | Richland Mitigation | 0 | Private Conservation 16 | 2 | ||
1307 | 1307 | 1306 | {"type": "MultiPolygon", "coordinates": [[[[-118.63657, 34.26504], [-118.63633, 34.26516], [-118.63617, 34.26526], [-118.63601, 34.2654], [-118.63587, 34.26558], [-118.6358, 34.26572], [-118.63574, 34.26588], [-118.63571, 34.26605], [-118.63569, 34.26628], [-118.63564, 34.26647], [-118.63554, 34.26667], [-118.63539, 34.26684], [-118.63447, 34.26759], [-118.63418, 34.26779], [-118.63386, 34.26798], [-118.63327, 34.26823], [-118.63273, 34.2646], [-118.63657, 34.26504]]], [[[-118.63485, 34.26765], [-118.63449, 34.26821], [-118.63372, 34.26845], [-118.63334, 34.26871], [-118.63329, 34.2684], [-118.6338, 34.26819], [-118.63416, 34.26801], [-118.63449, 34.2678], [-118.63477, 34.26758], [-118.63485, 34.26765]]], [[[-118.65762, 34.27232], [-118.65772, 34.2726], [-118.65771, 34.27281], [-118.65769, 34.27297], [-118.65755, 34.27344], [-118.65753, 34.27346], [-118.65749, 34.27338], [-118.65642, 34.27257], [-118.65573, 34.27221], [-118.6555, 34.27195], [-118.65574, 34.27169], [-118.65574, 34.27168], [-118.65499, 34.27151], [-118.65408, 34.27081], [-118.65349, 34.27065], [-118.65242, 34.27019], [-118.65185, 34.27015], [-118.65094, 34.26998], [-118.65002, 34.26966], [-118.65006, 34.26918], [-118.64922, 34.26888], [-118.64886, 34.26879], [-118.64705, 34.26807], [-118.64679, 34.26814], [-118.64604, 34.26809], [-118.6458, 34.26796], [-118.64547, 34.26785], [-118.64495, 34.26758], [-118.64462, 34.26755], [-118.64414, 34.26724], [-118.64391, 34.26694], [-118.64358, 34.26675], [-118.64244, 34.26649], [-118.64221, 34.26578], [-118.64205, 34.2657], [-118.64022, 34.26616], [-118.63857, 34.266], [-118.63825, 34.26619], [-118.63802, 34.26604], [-118.63773, 34.26595], [-118.63661, 34.26612], [-118.63614, 34.26631], [-118.6356, 34.26704], [-118.6354, 34.2672], [-118.63532, 34.26713], [-118.6356, 34.26688], [-118.6357, 34.26676], [-118.63579, 34.26662], [-118.63588, 34.26636], [-118.63591, 34.26604], [-118.63594, 34.26588], [-118.636, 34.26574], [-118.63609, 34.2656], [-118.63624, 34.26544], [-118.63642, 34.2653], [-118.63663, 34.2652], [-118.63687, 34.26513], [-118.63725, 34.26529], [-118.63763, 34.2653], [-118.63817, 34.26541], [-118.6387, 34.26529], [-118.64734, 34.26629], [-118.64784, 34.26632], [-118.6482, 34.2663], [-118.64863, 34.26625], [-118.64905, 34.26617], [-118.64946, 34.26604], [-118.64985, 34.26589], [-118.65022, 34.26569], [-118.65061, 34.26543], [-118.65172, 34.26447], [-118.65208, 34.26407], [-118.65307, 34.2632], [-118.65352, 34.26283], [-118.65404, 34.26249], [-118.65458, 34.26292], [-118.65468, 34.26296], [-118.65481, 34.26299], [-118.65467, 34.26301], [-118.65448, 34.26298], [-118.6544, 34.26301], [-118.65435, 34.26305], [-118.65433, 34.2631], [-118.65433, 34.26316], [-118.65435, 34.2632], [-118.65288, 34.26389], [-118.65201, 34.26446], [-118.65231, 34.26447], [-118.65299, 34.26403], [-118.65496, 34.2631], [-118.65568, 34.26311], [-118.6557, 34.26352], [-118.65602, 34.26352], [-118.65602, 34.26311], [-118.65619, 34.26311], [-118.65614, 34.26652], [-118.6561, 34.2667], [-118.65643, 34.26684], [-118.65636, 34.26695], [-118.65626, 34.2677], [-118.65595, 34.26773], [-118.65595, 34.26945], [-118.6562, 34.26962], [-118.65629, 34.26981], [-118.65688, 34.27019], [-118.65701, 34.27046], [-118.65718, 34.27077], [-118.65734, 34.27095], [-118.6567, 34.2711], [-118.65679, 34.2714], [-118.65666, 34.27168], [-118.65762, 34.27232]]]]} | Open Access 1 | 10485 | Corriganville Park | 8979 | 2117 | Rancho Simi Open Space Conservation Agency 345 | Special District 4 | Open Space District 6 | Special District 4 | 2117 | Rancho Simi Open Space Conservation Agency 342 | Special District 4 | Open Space District 6 | http://www.rsrpd.org/park/corrignavilleparkandtrail/corrignavilleparkandtrail.html | Ventura 8 | 178.572 | Corriganville Park | 0 | Local Park 2 | 4 | |
1625 | 1625 | 1624 | {"type": "Polygon", "coordinates": [[[-117.03443, 32.57835], [-117.03338, 32.57837], [-117.03339, 32.57655], [-117.03443, 32.57653], [-117.03443, 32.57835]]]} | No Public Access 3 | 12395 | Newport 5 Preserve | 22731 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 4.919 | Newport 5 Preserve | 0 | Private Conservation 16 | 2 | ||
1643 | 1643 | 1642 | {"type": "Polygon", "coordinates": [[[-119.68461, 36.60967], [-119.68459, 36.61269], [-119.68239, 36.61268], [-119.68238, 36.60964], [-119.68461, 36.60967]]]} | Open Access 1 | 14108 | Fowler Cemetery | 19028 | 2035 | Fowler Cemetery District 400 | Special District 4 | Cemetery District 11 | Special District 4 | 2035 | Fowler Cemetery District 394 | Special District 4 | Cemetery District 11 | Fresno 9 | 16.466 | Fowler Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
1665 | 1665 | 1664 | {"type": "Polygon", "coordinates": [[[-117.78817, 33.666], [-117.78729, 33.66687], [-117.78636, 33.66624], [-117.78725, 33.66535], [-117.78817, 33.666]]]} | Restricted Access 2 | 12583 | Royal Oak Park | 24713 | 6014 | Oak Creek Village Maintenance Association 405 | Private 7 | Home Owners Association 16 | Private 14 | 6014 | Oak Creek Village Maintenance Association 399 | Private 7 | Home Owners Association 15 | Orange 3 | 3.524 | Royal Oak Park | 0 | Private Recreation or Education 65 | 4 | ||
1753 | 1753 | 1752 | {"type": "Polygon", "coordinates": [[[-122.49925, 38.63647], [-122.49421, 38.63642], [-122.49417, 38.63271], [-122.48533, 38.63279], [-122.48527, 38.62564], [-122.47606, 38.62561], [-122.4761, 38.62202], [-122.48526, 38.62206], [-122.48527, 38.62563], [-122.48765, 38.62558], [-122.48985, 38.62546], [-122.49439, 38.62527], [-122.49434, 38.62156], [-122.49886, 38.62131], [-122.49897, 38.62494], [-122.49908, 38.62919], [-122.49915, 38.63266], [-122.49925, 38.63647]]]} | No Public Access 3 | 13101 | Cleary Reserve | 17417 | 3011 | California Biological Field Studies Association 420 | Non Profit 6 | Non Profit - Conservation 12 | Non Governmental Organization 10 | 3011 | California Biological Field Studies Association 414 | Non Profit 6 | Non Profit - Conservation 12 | Napa 11 | 406.373 | Cleary Reserve | 0 | Private Conservation 16 | 2 | ||
1942 | 1942 | 1941 | {"type": "Polygon", "coordinates": [[[-121.43074, 36.49462], [-121.42983, 36.49537], [-121.42837, 36.49418], [-121.4298, 36.49384], [-121.43074, 36.49462]]]} | Open Access 1 | 16639 | Gonzales Cemetery | 19393 | 2038 | Gonzales Cemetery District 457 | Special District 4 | Cemetery District 11 | Special District 4 | 2038 | Gonzales Cemetery District 451 | Special District 4 | Cemetery District 11 | Monterey 14 | 4.437 | Gonzales Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2049 | 2049 | 2048 | {"type": "Polygon", "coordinates": [[[-121.13879, 36.20777], [-121.1387, 36.20806], [-121.13875, 36.20846], [-121.13866, 36.20877], [-121.13851, 36.20885], [-121.13608, 36.2066], [-121.13769, 36.20538], [-121.13782, 36.20538], [-121.1382, 36.20563], [-121.13821, 36.20604], [-121.1385, 36.2066], [-121.13853, 36.2066], [-121.13879, 36.20777]]]} | Open Access 1 | 17107 | King City Cemetery | 20649 | 2052 | King City Cemetery District 471 | Special District 4 | Cemetery District 11 | Special District 4 | 2052 | King City Cemetery District 464 | Special District 4 | Cemetery District 11 | Monterey 14 | 11.815 | King City Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2104 | 2104 | 2103 | {"type": "Polygon", "coordinates": [[[-120.57389, 34.97384], [-120.57321, 34.97483], [-120.57204, 34.97432], [-120.57273, 34.97333], [-120.57389, 34.97384]]]} | Open Access 1 | 17330 | Leroy Park | 21178 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 3.784 | Leroy Park | 0 | Local Park 2 | 4 | ||
2266 | 2266 | 2265 | {"type": "Polygon", "coordinates": [[[-121.88959, 36.95741], [-121.88855, 36.95826], [-121.88843, 36.95817], [-121.88948, 36.95731], [-121.88959, 36.95741]]]} | Open Access 1 | 16858 | Hidden Beach | 19901 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.488 | Hidden Beach | None 188 | ||||
2317 | 2317 | 2316 | {"type": "Polygon", "coordinates": [[[-120.59124, 34.95777], [-120.59116, 34.96061], [-120.58835, 34.96058], [-120.58837, 34.96035], [-120.58852, 34.95999], [-120.58868, 34.9598], [-120.58886, 34.95964], [-120.5892, 34.95938], [-120.58939, 34.95916], [-120.58958, 34.95879], [-120.58962, 34.9586], [-120.58965, 34.95785], [-120.58967, 34.9578], [-120.58974, 34.95777], [-120.59124, 34.95777]]]} | Open Access 1 | 16995 | Jack O'Conell Park | 20306 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 14.461 | Jack O'Conell Park | 0 | Local Park 2 | 4 |
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]);