units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by AGNCY_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 533
- Los Angeles, City of 491
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 101
- Fresno, City of 95
- Modesto, City of 85
- Santa Rosa, City of 83
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Torrance, City of 73
- Tracy, City of 73
- Santa Cruz, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- San Luis Obispo, City of 66
- Newport Beach, City of 65
- Davis, City of 65
- Santa Barbara, City of 64
- Clovis, City of 62
- Glendale, City of 61
- Riverside, City of 61
- Bakersfield, City of 61
- …
DES_TP >30
- Local Park 7,470
- Local Recreation Area 1,438
- Local Other or Unknown 663
- Local Conservation Area 142
- Local Historic or Cultural Area 36
- Local Resource Management Area 6
- National Monument or Landmark 5
- None 1
- None 1
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 9,907
- Restricted Access 361
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,504 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13783 | 13783 | 13782 | {"type": "Polygon", "coordinates": [[[-120.86505, 37.75339], [-120.86502, 37.75345], [-120.86242, 37.75402], [-120.86235, 37.75399], [-120.8622, 37.75369], [-120.86223, 37.75363], [-120.86306, 37.75346], [-120.86339, 37.75335], [-120.86362, 37.75324], [-120.86446, 37.7527], [-120.86456, 37.75272], [-120.86505, 37.75339]]]} | Open Access 1 | 36339 | Oakdale holding 1 | 23024 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.574 | Oakdale holding 1 | 0 | Local Other or Unknown 14 | 4 | |
14001 | 14001 | 14000 | {"type": "Polygon", "coordinates": [[[-120.87498, 37.75001], [-120.87494, 37.75005], [-120.8733, 37.75089], [-120.87321, 37.7509], [-120.87317, 37.75088], [-120.87276, 37.75033], [-120.87275, 37.75029], [-120.8728, 37.75023], [-120.87334, 37.74997], [-120.87362, 37.74989], [-120.87425, 37.74979], [-120.87439, 37.74975], [-120.87467, 37.74963], [-120.87473, 37.74963], [-120.87498, 37.74997], [-120.87498, 37.75001]]]} | Open Access 1 | 48841 | Blue Park | 33561 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.353 | Blue Park | 0 | Local Park 2 | 4 | |
14727 | 14727 | 14726 | {"type": "Polygon", "coordinates": [[[-120.84534, 37.76425], [-120.84499, 37.7644], [-120.84425, 37.76329], [-120.8441, 37.76323], [-120.84388, 37.76304], [-120.84364, 37.76284], [-120.84337, 37.76265], [-120.84308, 37.76247], [-120.84379, 37.76218], [-120.84386, 37.76217], [-120.84393, 37.7622], [-120.84412, 37.76241], [-120.84534, 37.76425]]]} | Open Access 1 | 45079 | Oakdale Community Park | 32025 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.067 | Oakdale Community Park | 0 | Local Park 2 | 4 | |
5 | 5 | 4 | {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} | Open Access 1 | 25 | Eisenhower Park | 18475 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.46 | Eisenhower Park | 0 | Local Park 2 | 4 | |
674 | 674 | 673 | {"type": "Polygon", "coordinates": [[[-118.111, 33.74554], [-118.11097, 33.74555], [-118.10971, 33.74629], [-118.10972, 33.74521], [-118.11008, 33.74524], [-118.11037, 33.7453], [-118.11059, 33.74537], [-118.111, 33.74554]]]} | Open Access 1 | 5111 | Marina Park | 21837 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.915 | Marina Park | 0 | Local Park 2 | 4 | |
2278 | 2278 | 2277 | {"type": "Polygon", "coordinates": [[[-118.0508, 33.77469], [-118.0507, 33.77474], [-118.05066, 33.77481], [-118.05066, 33.77506], [-118.05064, 33.77513], [-118.05061, 33.77515], [-118.05051, 33.77515], [-118.04961, 33.77506], [-118.04924, 33.77506], [-118.04919, 33.77501], [-118.04919, 33.77486], [-118.04917, 33.77481], [-118.04913, 33.77476], [-118.04903, 33.77471], [-118.0508, 33.77469]]]} | Open Access 1 | 16839 | Almond Park | 15398 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.507 | Almond Park | 0 | Local Park 2 | 4 | |
2473 | 2473 | 2472 | {"type": "Polygon", "coordinates": [[[-118.09665, 33.77734], [-118.09664, 33.77835], [-118.09659, 33.77908], [-118.09606, 33.779], [-118.09566, 33.77902], [-118.09569, 33.77668], [-118.09574, 33.77489], [-118.09606, 33.77483], [-118.09664, 33.77485], [-118.09662, 33.77729], [-118.09665, 33.77734]]]} | Open Access 1 | 18958 | Edison Park | 18446 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 9.949 | Edison Park | 0 | Local Park 2 | 4 | |
3722 | 3722 | 3721 | {"type": "Polygon", "coordinates": [[[-118.06595, 33.77472], [-118.06558, 33.77479], [-118.06521, 33.7749], [-118.06481, 33.77506], [-118.06449, 33.77523], [-118.06408, 33.77551], [-118.06382, 33.77574], [-118.06343, 33.77613], [-118.06332, 33.77613], [-118.06287, 33.77585], [-118.0627, 33.77578], [-118.06252, 33.77572], [-118.06235, 33.77569], [-118.06217, 33.77568], [-118.06212, 33.77564], [-118.06212, 33.77508], [-118.06219, 33.77491], [-118.06217, 33.77476], [-118.06595, 33.77472]]]} | Open Access 1 | 30350 | Seal Beach Tennis Center | 25242 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 6.797 | Seal Beach Tennis Ctr. | 0 | Local Recreation Area 3 | 4 | |
5349 | 5349 | 5348 | {"type": "Polygon", "coordinates": [[[-118.0526, 33.78098], [-118.05249, 33.78107], [-118.05209, 33.78107], [-118.05186, 33.78077], [-118.05193, 33.78071], [-118.05195, 33.78065], [-118.05193, 33.78054], [-118.05193, 33.78014], [-118.05195, 33.78009], [-118.05199, 33.78008], [-118.05252, 33.78009], [-118.05256, 33.78009], [-118.05259, 33.78012], [-118.0526, 33.78098]]]} | Open Access 1 | 24616 | Heather Park | 19785 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.615 | Heather Park | 0 | Local Park 2 | 4 | |
5350 | 5350 | 5349 | {"type": "Polygon", "coordinates": [[[-118.09593, 33.74451], [-118.09565, 33.74437], [-118.09567, 33.74429], [-118.09478, 33.74377], [-118.09476, 33.74327], [-118.09514, 33.74279], [-118.0966, 33.74354], [-118.0966, 33.74357], [-118.09593, 33.74451]]]} | Open Access 1 | 24617 | McGaugh Gymnasium, Pool, Tennis Courts & Fields | 22033 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 4.455 | McGaugh Gymnasium, Pool, Tennis Courts & Fields | 0 | Local Recreation Area 3 | 4 | |
6220 | 6220 | 6219 | {"type": "Polygon", "coordinates": [[[-118.10036, 33.74943], [-118.10034, 33.74971], [-118.10013, 33.74989], [-118.09978, 33.74999], [-118.09918, 33.74999], [-118.09748, 33.74977], [-118.09567, 33.74976], [-118.09489, 33.75005], [-118.0943, 33.75006], [-118.09404, 33.75021], [-118.09393, 33.7505], [-118.09274, 33.75002], [-118.09208, 33.7498], [-118.09206, 33.74981], [-118.09182, 33.74974], [-118.09161, 33.74966], [-118.09078, 33.74928], [-118.09059, 33.74923], [-118.0904, 33.74923], [-118.09024, 33.74927], [-118.09011, 33.74934], [-118.08996, 33.74946], [-118.08988, 33.74958], [-118.0898, 33.74978], [-118.09, 33.74998], [-118.09008, 33.75003], [-118.08995, 33.75016], [-118.08991, 33.75016], [-118.08987, 33.75014], [-118.0898, 33.75007], [-118.08968, 33.75005], [-118.08939, 33.74991], [-118.08937, 33.74987], [-118.08938, 33.74984], [-118.0904, 33.74833], [-118.09168, 33.7494], [-118.10036, 33.74943]]]} | Open Access 1 | 1278 | Gum Grove Park | 19568 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 14.952 | Gum Grove Park | 0 | Local Park 2 | 4 | |
9297 | 9297 | 9296 | {"type": "Polygon", "coordinates": [[[-118.10221, 33.74239], [-118.10162, 33.7432], [-118.10041, 33.74259], [-118.10094, 33.74186], [-118.10181, 33.7423], [-118.10187, 33.74222], [-118.10221, 33.74239]]]} | Open Access 1 | 15520 | Zoeter Field | 27867 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 3.137 | Zoeter Field | 0 | Local Recreation Area 3 | 4 | |
11983 | 11983 | 11982 | {"type": "MultiPolygon", "coordinates": [[[[-118.09836, 33.73752], [-118.09788, 33.7375], [-118.09784, 33.73745], [-118.09801, 33.7372], [-118.09836, 33.73752]]], [[[-118.10024, 33.73925], [-118.10001, 33.73945], [-118.09809, 33.73769], [-118.09857, 33.73772], [-118.10024, 33.73925]]], [[[-118.10169, 33.74058], [-118.10152, 33.74083], [-118.10011, 33.73954], [-118.10034, 33.73934], [-118.10169, 33.74058]]], [[[-118.10382, 33.74254], [-118.10364, 33.74278], [-118.1024, 33.74164], [-118.10162, 33.74093], [-118.1018, 33.74068], [-118.10382, 33.74254]]], [[[-118.10525, 33.74384], [-118.10503, 33.74405], [-118.10381, 33.74293], [-118.10401, 33.74271], [-118.10525, 33.74384]]], [[[-118.10603, 33.74458], [-118.10599, 33.74466], [-118.10595, 33.7449], [-118.10517, 33.74419], [-118.1054, 33.74399], [-118.10603, 33.74458]]], [[[-118.10648, 33.74497], [-118.10612, 33.74497], [-118.1061, 33.74486], [-118.10613, 33.74465], [-118.10648, 33.74497]]]]} | Open Access 1 | 24615 | Electric Ave Greenbelt | 18557 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 7.723 | Electric Ave Greenbelt | 0 | Local Recreation Area 3 | 4 | |
12341 | 12341 | 12340 | {"type": "Polygon", "coordinates": [[[-118.06195, 33.77555], [-118.0613, 33.77555], [-118.06131, 33.77488], [-118.06133, 33.77485], [-118.06137, 33.77484], [-118.06186, 33.77484], [-118.06194, 33.77488], [-118.06196, 33.77493], [-118.06195, 33.77555]]]} | Open Access 1 | 26034 | Bluebell Park | 16192 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.171 | Bluebell Park | 0 | Local Park 2 | 4 | |
12517 | 12517 | 12516 | {"type": "Polygon", "coordinates": [[[-118.05123, 33.78279], [-118.05121, 33.78401], [-118.04864, 33.78403], [-118.04753, 33.78326], [-118.0475, 33.78274], [-118.05123, 33.78279]]]} | Open Access 1 | 29000 | Arbor Park | 15559 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 10.752 | Arbor Park | 0 | Local Park 2 | 4 | |
13902 | 13902 | 13901 | {"type": "Polygon", "coordinates": [[[-118.10808, 33.74807], [-118.10744, 33.74844], [-118.1074, 33.74793], [-118.10733, 33.74748], [-118.10727, 33.74736], [-118.1072, 33.74729], [-118.10708, 33.74722], [-118.10708, 33.74717], [-118.10709, 33.74716], [-118.10808, 33.74807]]]} | Open Access 1 | 36524 | Seal Beach holding 1 | 25240 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 0.923 | Seal Beach holding 1 | 0 | Local Other or Unknown 14 | 4 | |
6 | 6 | 5 | {"type": "MultiPolygon", "coordinates": [[[[-117.11089, 32.73295], [-117.11088, 32.73298], [-117.11086, 32.73286], [-117.1107, 32.73261], [-117.11037, 32.73248], [-117.10993, 32.73245], [-117.10979, 32.73242], [-117.10919, 32.73273], [-117.10874, 32.73272], [-117.10872, 32.73247], [-117.10818, 32.73272], [-117.10811, 32.73272], [-117.10788, 32.73308], [-117.10775, 32.73295], [-117.10773, 32.73295], [-117.1074, 32.73315], [-117.10734, 32.73317], [-117.10705, 32.7334], [-117.10683, 32.73321], [-117.10705, 32.73283], [-117.10727, 32.73261], [-117.10691, 32.73234], [-117.10697, 32.73229], [-117.10703, 32.73226], [-117.10776, 32.73211], [-117.10766, 32.73176], [-117.10765, 32.73157], [-117.10769, 32.73139], [-117.10774, 32.73124], [-117.10782, 32.73111], [-117.10802, 32.73089], [-117.10797, 32.73062], [-117.10803, 32.73067], [-117.10847, 32.7309], [-117.10876, 32.73109], [-117.10866, 32.73109], [-117.10858, 32.73107], [-117.10849, 32.73117], [-117.10866, 32.73138], [-117.10875, 32.73158], [-117.10881, 32.73182], [-117.10883, 32.73208], [-117.10939, 32.73195], [-117.10985, 32.73194], [-117.10996, 32.73191], [-117.11035, 32.73217], [-117.11072, 32.73258], [-117.11089, 32.73286], [-117.11089, 32.73295]]], [[[-117.10995, 32.73399], [-117.10989, 32.73404], [-117.10985, 32.734], [-117.10991, 32.73395], [-117.10995, 32.73399]]]]} | Open Access 1 | 26 | Azalea Neighborhood Park | 30115 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.138 | Azalea Neighborhood Park | 0 | Local Park 2 | 4 | |
10 | 10 | 9 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73849], [-117.09279, 32.73755], [-117.09339, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.0936, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09321, 32.73912], [-117.09324, 32.74037], [-117.09385, 32.74037], [-117.09387, 32.74118], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 31 | 47th Street Canyon | 15202 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.994 | 47th Street Canyon | 0 | Local Recreation Area 3 | 4 | |
11 | 11 | 10 | {"type": "Polygon", "coordinates": [[[-117.08431, 32.9339], [-117.08421, 32.93398], [-117.08411, 32.93375], [-117.08393, 32.93344], [-117.08356, 32.93329], [-117.08306, 32.93325], [-117.08297, 32.9331], [-117.08313, 32.93271], [-117.08313, 32.93246], [-117.08292, 32.93223], [-117.08257, 32.9321], [-117.08257, 32.93151], [-117.08386, 32.93278], [-117.08402, 32.93297], [-117.08415, 32.93318], [-117.08425, 32.93342], [-117.0843, 32.93368], [-117.08431, 32.9339]]]} | Open Access 1 | 46738 | Butterfly Mini-Park | 30187 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.079 | Butterfly Mini-Park | 0 | Local Park 2 | 4 | |
19 | 19 | 18 | {"type": "Polygon", "coordinates": [[[-117.08916, 32.92533], [-117.08917, 32.92536], [-117.08915, 32.92627], [-117.08884, 32.92626], [-117.08902, 32.92612], [-117.08902, 32.926], [-117.08877, 32.92601], [-117.08855, 32.92613], [-117.08872, 32.92567], [-117.0877, 32.92529], [-117.08912, 32.92531], [-117.08916, 32.92533]]]} | Open Access 1 | 46740 | Dry Creek Mini-Park | 30190 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.479 | Dry Creek Mini-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]);