units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 208
- Los Angeles, City of 116
- San Francisco, City and County of 80
- Mountains Recreation and Conservation Authority 58
- Los Angeles, County of 31
- Conejo Open Space Conservation Agency 29
- East Bay Regional Park District 28
- Las Virgenes Municipal Water District 28
- San Luis Obispo, City of 26
- Long Beach, City of 25
- Glendale, City of 24
- Davis, City of 23
- Santa Barbara, County of 19
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Los Angeles - Department of Parks and Recreation, County of 15
- Santa Cruz, City of 14
- Conejo Recreation and Park District 14
- San Bernardino, City of 14
- San Marcos, City of 14
- East Bay Municipal Utility District 13
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Sunrise Recreation and Park District 12
- …
MNG_AG_TYP 17
- City Agency 1,435
- Recreation/Parks District 164
- County Agency 117
- Open Space District 88
- Water District 69
- County Agency - Parks 37
- Irrigation District 23
- Community Services District 14
- Flood District 12
- Port/Harbor District 5
- School District 5
- County Agency - Other 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,636
- Restricted Access 219
- No Public Access 113
- Unknown Access 16
DES_TP 1
- Local Recreation Area · 1,984 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46 | 46 | 45 | {"type": "Polygon", "coordinates": [[[-117.08226, 32.82508], [-117.08219, 32.82527], [-117.08213, 32.82555], [-117.08203, 32.82574], [-117.08095, 32.8251], [-117.08087, 32.82511], [-117.08059, 32.82491], [-117.08031, 32.82482], [-117.07942, 32.82465], [-117.0796, 32.8244], [-117.08002, 32.82402], [-117.08018, 32.82416], [-117.08058, 32.82439], [-117.08226, 32.82508]]]} | Open Access 1 | 131 | Tierrasanta Open Space | 10608 | 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 | 4.081 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
56 | 56 | 55 | {"type": "Polygon", "coordinates": [[[-117.06137, 32.79131], [-117.06126, 32.79227], [-117.06098, 32.79279], [-117.06081, 32.79305], [-117.05968, 32.79265], [-117.05975, 32.79246], [-117.05991, 32.79163], [-117.06039, 32.7917], [-117.06047, 32.79131], [-117.06137, 32.79131]]]} | Open Access 1 | 157 | Pasatiempo Park West Open Space | 23492 | 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 | 5.178 | Pasatiempo Park West OS | 0 | Local Recreation Area 3 | 4 | |
79 | 79 | 78 | {"type": "Polygon", "coordinates": [[[-117.23873, 32.83257], [-117.23825, 32.83268], [-117.2382, 32.83254], [-117.23868, 32.83244], [-117.23873, 32.83257]]]} | Open Access 1 | 236 | La Jolla Open Space | 20766 | 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 | 0.172 | La Jolla OS | 0 | Local Recreation Area 3 | 4 | |
86 | 86 | 85 | {"type": "MultiPolygon", "coordinates": [[[[-121.14464, 37.45253], [-121.14452, 37.4562], [-121.14113, 37.45496], [-121.14118, 37.45251], [-121.14464, 37.45253]]], [[[-121.14422, 37.45628], [-121.14118, 37.45628], [-121.1412, 37.45516], [-121.1412, 37.45516], [-121.14422, 37.45628]]]]} | Open Access 1 | 225 | T.W. Patterson Sports Complex | 26158 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 29.665 | T.W. Patterson Sports Complex | 0 | Local Recreation Area 3 | 4 | |
98 | 98 | 97 | {"type": "MultiPolygon", "coordinates": [[[[-117.1681, 32.83591], [-117.16809, 32.83651], [-117.16806, 32.83679], [-117.16796, 32.83715], [-117.16778, 32.8376], [-117.1677, 32.83797], [-117.16768, 32.83814], [-117.16768, 32.83894], [-117.1651, 32.83896], [-117.16509, 32.8392], [-117.1635, 32.83922], [-117.16349, 32.83822], [-117.16255, 32.83823], [-117.16249, 32.83577], [-117.16617, 32.83574], [-117.16618, 32.83593], [-117.1681, 32.83591]]], [[[-117.16833, 32.83894], [-117.16791, 32.83894], [-117.16791, 32.83815], [-117.16794, 32.83788], [-117.16803, 32.83757], [-117.16822, 32.83706], [-117.16831, 32.83659], [-117.16833, 32.83894]]]]} | Open Access 1 | 252 | Hickman Field Athletic Complex | 19895 | 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 | 44.171 | Hickman Field Athletic Complex | 0 | Local Recreation Area 3 | 4 | |
103 | 103 | 102 | {"type": "Polygon", "coordinates": [[[-120.96209, 37.72901], [-120.96038, 37.72734], [-120.96038, 37.72548], [-120.96205, 37.72549], [-120.96209, 37.72901]]]} | Open Access 1 | 287 | Riverbank Sports Complex | 24435 | 1278 | Riverbank, City of 41 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | Stanislaus 2 | 10.966 | Riverbank Sports Complex | 0 | Local Recreation Area 3 | 4 | |
122 | 122 | 121 | {"type": "Polygon", "coordinates": [[[-119.79182, 36.7434], [-119.79182, 36.74417], [-119.7913, 36.74417], [-119.79129, 36.74413], [-119.79071, 36.74413], [-119.79072, 36.7434], [-119.79182, 36.7434]]]} | Open Access 1 | 419 | Dicky Playground | 18152 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.025 | Dicky Playground | 0 | Local Recreation Area 3 | 4 | |
134 | 134 | 133 | {"type": "Polygon", "coordinates": [[[-122.42226, 37.73435], [-122.42174, 37.73471], [-122.42177, 37.73475], [-122.42174, 37.73506], [-122.42008, 37.73497], [-122.42016, 37.73405], [-122.41919, 37.734], [-122.41925, 37.73328], [-122.41931, 37.73301], [-122.41929, 37.733], [-122.41929, 37.73252], [-122.41954, 37.73252], [-122.41956, 37.73231], [-122.42009, 37.7323], [-122.4201, 37.73232], [-122.42027, 37.73232], [-122.42079, 37.73229], [-122.42084, 37.73243], [-122.42096, 37.7324], [-122.42091, 37.73226], [-122.421, 37.73225], [-122.42145, 37.7331], [-122.4217, 37.73332], [-122.42178, 37.73343], [-122.4221, 37.73413], [-122.42226, 37.73435]]]} | Open Access 1 | 342 | Saint Mary's Playground | 24791 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 13.777 | Saint Mary's Playground | 0 | Local Recreation Area 3 | 4 | |
147 | 147 | 146 | {"type": "Polygon", "coordinates": [[[-120.67593, 35.28455], [-120.67267, 35.28527], [-120.67227, 35.28492], [-120.67159, 35.28308], [-120.67151, 35.28307], [-120.67145, 35.27945], [-120.67281, 35.27944], [-120.67281, 35.27961], [-120.67591, 35.28176], [-120.67593, 35.28455]]]} | Open Access 1 | 383 | San Luis Mountain Open Space | 24932 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 49.053 | San Luis Mtn. OS | 0 | Local Recreation Area 3 | 4 | |
177 | 177 | 176 | {"type": "Polygon", "coordinates": [[[-119.74164, 34.43295], [-119.74153, 34.43576], [-119.73893, 34.43575], [-119.73887, 34.43693], [-119.73869, 34.43693], [-119.73853, 34.43695], [-119.73837, 34.437], [-119.73822, 34.43708], [-119.73804, 34.43724], [-119.73783, 34.43753], [-119.73766, 34.43766], [-119.73751, 34.43772], [-119.73402, 34.43838], [-119.73394, 34.43798], [-119.73391, 34.43769], [-119.73392, 34.43573], [-119.73369, 34.43572], [-119.73366, 34.43384], [-119.73517, 34.43387], [-119.73518, 34.43141], [-119.73888, 34.43138], [-119.73888, 34.42908], [-119.73969, 34.42935], [-119.74016, 34.42954], [-119.74079, 34.42982], [-119.7407, 34.4325], [-119.74164, 34.43295]]]} | Restricted Access 2 | 492 | Santa Barbara Golf Club | 32988 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 110.039 | Santa Barbara Golf Club | 0 | Local Recreation Area 3 | 4 | |
187 | 187 | 186 | {"type": "Polygon", "coordinates": [[[-116.98547, 32.79471], [-116.98538, 32.79502], [-116.98401, 32.79502], [-116.98391, 32.79564], [-116.98443, 32.796], [-116.98415, 32.79631], [-116.98414, 32.79654], [-116.98415, 32.7966], [-116.98374, 32.79652], [-116.98358, 32.79629], [-116.98311, 32.79603], [-116.98248, 32.79604], [-116.98244, 32.79514], [-116.98279, 32.79507], [-116.98298, 32.79497], [-116.98319, 32.7949], [-116.98332, 32.79484], [-116.98364, 32.79465], [-116.98397, 32.79437], [-116.98416, 32.79416], [-116.98435, 32.79387], [-116.98446, 32.79365], [-116.98547, 32.79471]]]} | Open Access 1 | 590 | City of El Cajon Open Space | 17309 | 1092 | El Cajon, City of 73 | City 2 | City Agency 2 | http://www.ci.el-cajon.ca.us/dept/rec/_Parks.html | City 2 | 1092 | El Cajon, City of 71 | City 2 | City Agency 2 | San Diego 4 | 9.123 | City of El Cajon OS | 0 | Local Recreation Area 3 | 4 | |
195 | 195 | 194 | {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} | Open Access 1 | 569 | Foglesong Park/Eda Henderson Pool | 18966 | 2203 | Barstow Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2203 | Barstow Recreation and Park District 76 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 9.887 | Foglesong Park/Eda Henderson Pool | 0 | Local Recreation Area 3 | 4 | ||
210 | 210 | 209 | {"type": "Polygon", "coordinates": [[[-116.99814, 32.81621], [-116.99811, 32.81634], [-116.9979, 32.8163], [-116.99756, 32.81669], [-116.99651, 32.81635], [-116.99597, 32.8163], [-116.99567, 32.81613], [-116.99637, 32.8154], [-116.9979, 32.81596], [-116.99785, 32.81614], [-116.99814, 32.81621]]]} | Open Access 1 | 571 | City of El Cajon Open Space | 17309 | 1092 | El Cajon, City of 73 | City 2 | City Agency 2 | http://www.ci.el-cajon.ca.us/dept/rec/_Parks.html | City 2 | 1092 | El Cajon, City of 71 | City 2 | City Agency 2 | San Diego 4 | 4.188 | City of El Cajon OS | 0 | Local Recreation Area 3 | 4 | |
217 | 217 | 216 | {"type": "MultiPolygon", "coordinates": [[[[-120.18693, 34.6078], [-120.18673, 34.60817], [-120.18627, 34.608], [-120.18648, 34.60763], [-120.18693, 34.6078]]], [[[-120.1886, 34.60795], [-120.18844, 34.60825], [-120.18779, 34.608], [-120.18796, 34.6077], [-120.1886, 34.60795]]]]} | Open Access 1 | 634 | Santa Ynez River Open Space | 25147 | 1036 | Buellton, City of 88 | City 2 | City Agency 2 | http://www.cityofbuellton.com/Parks&Rec/parks.asp | City 2 | 1036 | Buellton, City of 86 | City 2 | City Agency 2 | Santa Barbara 7 | 1.105 | Santa Ynez River OS | 0 | Local Recreation Area 3 | 4 | |
218 | 218 | 217 | {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} | Open Access 1 | 586 | Quarry Lakes Regional Recreation Area | 30594 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 254.616 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
232 | 232 | 231 | {"type": "Polygon", "coordinates": [[[-115.55924, 32.80381], [-115.55717, 32.80381], [-115.55717, 32.80208], [-115.5575, 32.80209], [-115.5578, 32.80221], [-115.5592, 32.8022], [-115.55924, 32.80381]]]} | Open Access 1 | 627 | Fraizer Field | 19039 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 8.576 | Fraizer Field | 0 | Local Recreation Area 3 | 4 | |
240 | 240 | 239 | {"type": "Polygon", "coordinates": [[[-117.08384, 33.16747], [-117.08271, 33.16759], [-117.08326, 33.16655], [-117.08332, 33.16648], [-117.08345, 33.1664], [-117.08359, 33.16635], [-117.08368, 33.16634], [-117.08367, 33.16648], [-117.08368, 33.16662], [-117.08384, 33.16747]]]} | Open Access 1 | 645 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.034 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
277 | 277 | 276 | {"type": "Polygon", "coordinates": [[[-117.5615, 33.93786], [-117.56124, 33.93819], [-117.56111, 33.93847], [-117.56107, 33.93871], [-117.56106, 33.93932], [-117.55877, 33.93932], [-117.55877, 33.93876], [-117.55864, 33.93875], [-117.55864, 33.9379], [-117.55991, 33.93791], [-117.55992, 33.93787], [-117.5615, 33.93786]]]} | Open Access 1 | 47359 | Community Center Park | 31082 | 1395 | Norco, City of 114 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/default.asp | City 2 | 1395 | Norco, City of 111 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/facilities/parks/communitycenter.asp | Riverside 10 | 8.953 | Community Ctr. Park | 0 | Local Recreation Area 3 | 4 |
278 | 278 | 277 | {"type": "Polygon", "coordinates": [[[-120.66515, 35.26662], [-120.66466, 35.26653], [-120.66436, 35.26666], [-120.66427, 35.26653], [-120.66393, 35.26612], [-120.66379, 35.266], [-120.66357, 35.26587], [-120.66337, 35.26579], [-120.66315, 35.26574], [-120.66292, 35.26572], [-120.66252, 35.26572], [-120.66262, 35.26536], [-120.66261, 35.26497], [-120.66004, 35.26496], [-120.66011, 35.26356], [-120.65886, 35.26356], [-120.65883, 35.26352], [-120.65904, 35.26352], [-120.65905, 35.26351], [-120.659, 35.26347], [-120.6588, 35.26341], [-120.65852, 35.26335], [-120.65797, 35.26314], [-120.65777, 35.26304], [-120.65767, 35.26291], [-120.6573, 35.26264], [-120.65721, 35.26255], [-120.65717, 35.2625], [-120.65683, 35.26235], [-120.65661, 35.26231], [-120.6564, 35.26215], [-120.65633, 35.26207], [-120.65617, 35.26197], [-120.65608, 35.26186], [-120.65599, 35.26184], [-120.65583, 35.26163], [-120.65493, 35.26108], [-120.6544, 35.25768], [-120.65583, 35.25766], [-120.65584, 35.2577], [-120.65524, 35.25788], [-120.65526, 35.25821], [-120.65719, 35.26012], [-120.65825, 35.26135], [-120.65927, 35.26221], [-120.66054, 35.2628], [-120.66113, 35.26331], [-120.66475, 35.2634], [-120.66476, 35.26499], [-120.66513, 35.265], [-120.66515, 35.26662]], [[-120.66016, 35.26352], [-120.66016, 35.2635], [-120.66011, 35.26351], [-120.66012, 35.26352], [-120.66016, 35.26352]]]} | Open Access 1 | 946 | South Hills Open Space | 25656 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 58.628 | South Hills OS | 0 | Local Recreation Area 3 | 4 | |
282 | 282 | 281 | {"type": "Polygon", "coordinates": [[[-117.89382, 33.88608], [-117.89375, 33.8862], [-117.89366, 33.88628], [-117.89357, 33.88634], [-117.89345, 33.88638], [-117.89184, 33.88657], [-117.89171, 33.88659], [-117.89162, 33.88663], [-117.89142, 33.88677], [-117.89085, 33.88747], [-117.89075, 33.88764], [-117.89069, 33.88781], [-117.89029, 33.88783], [-117.89023, 33.8878], [-117.8901, 33.88716], [-117.89051, 33.88706], [-117.89064, 33.88674], [-117.89088, 33.88669], [-117.89106, 33.88662], [-117.89167, 33.88626], [-117.89176, 33.88622], [-117.89298, 33.88609], [-117.89312, 33.88604], [-117.89324, 33.88597], [-117.89338, 33.88584], [-117.89382, 33.88608]]]} | Open Access 1 | 756 | Fullerton Creek Greenbelt | 19143 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 4.418 | Fullerton Creek Greenbelt | 0 | Local Recreation Area 3 | 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]);