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 204
- Los Angeles, City of 116
- San Francisco, City and County of 79
- Mountains Recreation and Conservation Authority 58
- Los Angeles, County of 31
- Conejo Open Space Conservation Agency 29
- Las Virgenes Municipal Water District 28
- East Bay Regional Park District 27
- San Luis Obispo, City of 25
- 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,422
- Recreation/Parks District 162
- 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,622
- Restricted Access 218
- No Public Access 113
- Unknown Access 16
MNG_AG_LEV 3 ✖
- City 1,422
- Special District 389
- County 158
DES_TP 1
- Local Recreation Area · 1,969 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
285 | 285 | 284 | {"type": "MultiPolygon", "coordinates": [[[[-119.69069, 34.44329], [-119.69064, 34.4434], [-119.69065, 34.44355], [-119.69068, 34.44362], [-119.69097, 34.44402], [-119.69099, 34.44413], [-119.69098, 34.44422], [-119.69094, 34.4443], [-119.69087, 34.44436], [-119.69029, 34.44464], [-119.69015, 34.44481], [-119.69015, 34.44384], [-119.68972, 34.44402], [-119.68956, 34.44406], [-119.68939, 34.44408], [-119.68783, 34.44396], [-119.68772, 34.44393], [-119.6876, 34.44389], [-119.68726, 34.44363], [-119.68703, 34.44354], [-119.68683, 34.4435], [-119.68629, 34.44347], [-119.68596, 34.4434], [-119.68596, 34.44324], [-119.68632, 34.44331], [-119.6869, 34.44334], [-119.6871, 34.44338], [-119.6873, 34.44346], [-119.68745, 34.44355], [-119.68767, 34.44372], [-119.68782, 34.44378], [-119.68937, 34.44392], [-119.68964, 34.44387], [-119.69015, 34.44364], [-119.69013, 34.44286], [-119.69069, 34.44329]]], [[[-119.69482, 34.44571], [-119.69452, 34.44628], [-119.69438, 34.44643], [-119.69253, 34.44663], [-119.69154, 34.4466], [-119.69056, 34.44614], [-119.69014, 34.44596], [-119.69015, 34.44498], [-119.69037, 34.44471], [-119.69094, 34.44446], [-119.69102, 34.4444], [-119.69109, 34.44429], [-119.69113, 34.44416], [-119.6911, 34.444], [-119.6908, 34.44353], [-119.69078, 34.44345], [-119.6908, 34.44337], [-119.69144, 34.44386], [-119.69193, 34.44417], [-119.69239, 34.44438], [-119.6932, 34.44461], [-119.69391, 34.4449], [-119.69482, 34.44571]]]]} | Unknown Access 4 | 777 | Sheffield Reservoir | 25382 | 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 | 26.245 | Sheffield Reservoir | 0 | Local Recreation Area 3 | 4 | |
294 | 294 | 293 | {"type": "Polygon", "coordinates": [[[-118.36564, 34.02332], [-118.36557, 34.02447], [-118.36551, 34.02475], [-118.36542, 34.02503], [-118.36317, 34.02482], [-118.36308, 34.02548], [-118.3629, 34.02546], [-118.36318, 34.02338], [-118.36465, 34.02338], [-118.36466, 34.02331], [-118.36564, 34.02332]]]} | Open Access 1 | 788 | Baldwin Hills Recreation Center | 15776 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 10.253 | Baldwin Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
313 | 313 | 312 | {"type": "Polygon", "coordinates": [[[-119.13591, 36.29543], [-119.13588, 36.29709], [-119.13271, 36.29702], [-119.1327, 36.29541], [-119.13591, 36.29543]]]} | Open Access 1 | 1084 | Exeter City Athletic Park | 18774 | 1103 | Exeter, City of 129 | City 2 | City Agency 2 | http://www.cityofexeter.com/ | City 2 | 1103 | Exeter, City of 126 | City 2 | City Agency 2 | Tulare 29 | 12.899 | Exeter City Athletic Park | 0 | Local Recreation Area 3 | 4 | |
354 | 354 | 353 | {"type": "Polygon", "coordinates": [[[-117.36947, 33.17694], [-117.36912, 33.17714], [-117.36883, 33.1768], [-117.3692, 33.17658], [-117.36947, 33.17694]]]} | Open Access 1 | 976 | Buccaneer Beach Access | 16467 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 0.466 | Buccaneer Beach Access | 0 | Local Recreation Area 3 | 4 | |
371 | 371 | 370 | {"type": "Polygon", "coordinates": [[[-119.131, 36.29982], [-119.13097, 36.30053], [-119.1279, 36.30049], [-119.12801, 36.2971], [-119.13018, 36.29713], [-119.13005, 36.29768], [-119.13003, 36.29832], [-119.13033, 36.29892], [-119.13082, 36.29961], [-119.131, 36.29982]]]} | Open Access 1 | 1081 | Dobson Field | 18175 | 1103 | Exeter, City of 129 | City 2 | City Agency 2 | http://www.cityofexeter.com/ | City 2 | 1103 | Exeter, City of 126 | City 2 | City Agency 2 | Tulare 29 | 20.718 | Dobson Field | 0 | Local Recreation Area 3 | 4 | |
385 | 385 | 384 | {"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67338], [-117.15342, 33.6733], [-117.15342, 33.67327], [-117.15317, 33.67312], [-117.15276, 33.67299], [-117.15275, 33.67297], [-117.15218, 33.67273], [-117.1521, 33.67268], [-117.15205, 33.67268], [-117.15209, 33.67232], [-117.15206, 33.67228], [-117.15172, 33.67207], [-117.15166, 33.67209], [-117.15161, 33.67209], [-117.15158, 33.67206], [-117.15137, 33.67206], [-117.15114, 33.67216], [-117.15096, 33.67243], [-117.15097, 33.67245], [-117.15093, 33.67262], [-117.15094, 33.67265], [-117.15089, 33.67283], [-117.15091, 33.67286], [-117.15091, 33.67306], [-117.15088, 33.67306], [-117.15083, 33.67326], [-117.15041, 33.67303], [-117.15016, 33.67299], [-117.14999, 33.67287], [-117.14973, 33.67259], [-117.14955, 33.67245], [-117.14936, 33.67232], [-117.14933, 33.67232], [-117.14914, 33.6722], [-117.14911, 33.6722], [-117.14903, 33.67215], [-117.14888, 33.67217], [-117.14849, 33.67226], [-117.1482, 33.67272], [-117.14817, 33.6727], [-117.14817, 33.67261], [-117.14814, 33.67256], [-117.1481, 33.67252], [-117.14802, 33.67247], [-117.14821, 33.67255], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14974, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15184, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]} | Open Access 1 | 48338 | Lago Vista Sports Park | 32901 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/lago-vista-sports-park | Riverside 10 | 28.451 | Lago Vista Sports Park | 0 | Local Recreation Area 3 | 4 |
414 | 414 | 413 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96794], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | 830 | Simpkins Swim Center | 25513 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
416 | 416 | 415 | {"type": "Polygon", "coordinates": [[[-117.31368, 34.12421], [-117.31368, 34.12495], [-117.31262, 34.12495], [-117.31262, 34.1242], [-117.31368, 34.12421]]]} | Open Access 1 | 1286 | Gutierrez Field | 19573 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.988 | Gutierrez Field | 0 | Local Recreation Area 3 | 4 | |
462 | 462 | 461 | {"type": "Polygon", "coordinates": [[[-119.82186, 36.78834], [-119.81967, 36.78838], [-119.81975, 36.78668], [-119.82184, 36.78661], [-119.82186, 36.78834]]]} | Open Access 1 | 1856 | Quigley Playground | 24064 | 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 | 8.955 | Quigley Playground | 0 | Local Recreation Area 3 | 4 | |
466 | 466 | 465 | {"type": "Polygon", "coordinates": [[[-119.77435, 36.73962], [-119.77432, 36.74122], [-119.7726, 36.74123], [-119.77267, 36.73961], [-119.77435, 36.73962]]]} | Open Access 1 | 922 | Holmes Playground | 20056 | 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 | 6.725 | Holmes Playground | 0 | Local Recreation Area 3 | 4 | |
500 | 500 | 499 | {"type": "Polygon", "coordinates": [[[-117.1728, 32.71668], [-117.17278, 32.71676], [-117.17262, 32.71679], [-117.17261, 32.71695], [-117.1722, 32.71685], [-117.17129, 32.71683], [-117.17128, 32.71657], [-117.17223, 32.71657], [-117.17231, 32.71653], [-117.17235, 32.71589], [-117.17279, 32.71589], [-117.1728, 32.71668]]]} | Open Access 1 | 47486 | Lane Field Park | 31204 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/parks/lane-field-park.html | San Diego 4 | 1.887 | Lane Field Park | 0 | Local Recreation Area 3 | 4 |
508 | 508 | 507 | {"type": "Polygon", "coordinates": [[[-119.77465, 36.75361], [-119.77461, 36.75365], [-119.77404, 36.75398], [-119.77404, 36.75406], [-119.7726, 36.75407], [-119.7726, 36.75242], [-119.77465, 36.75241], [-119.77465, 36.75361]]]} | Open Access 1 | 2073 | Romain Playground | 24586 | 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 | 7.876 | Romain Playground | 0 | Local Recreation Area 3 | 4 | |
532 | 532 | 531 | {"type": "Polygon", "coordinates": [[[-118.90336, 34.18406], [-118.90262, 34.18413], [-118.8993, 34.1842], [-118.89928, 34.18407], [-118.89887, 34.18356], [-118.89889, 34.18303], [-118.89872, 34.18292], [-118.89961, 34.18202], [-118.8998, 34.18225], [-118.90006, 34.18231], [-118.90027, 34.18246], [-118.90028, 34.18262], [-118.90087, 34.18263], [-118.90133, 34.18247], [-118.9018, 34.18266], [-118.9019, 34.18329], [-118.90208, 34.18388], [-118.90268, 34.18407], [-118.90324, 34.18397], [-118.90324, 34.18342], [-118.90333, 34.18327], [-118.90336, 34.18406]]]} | Open Access 1 | 1797 | Walnut Grove Equestrian Center | 27229 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 13.391 | Walnut Grove Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 | |
557 | 557 | 556 | {"type": "Polygon", "coordinates": [[[-117.10253, 33.61115], [-117.1013, 33.61115], [-117.10128, 33.60911], [-117.10251, 33.60901], [-117.10253, 33.61115]]]} | Open Access 1 | 48384 | Pourroy Fields | 32948 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/pourroy-fields | Riverside 10 | 6.552 | Pourroy Fields | 0 | Local Recreation Area 3 | 4 |
559 | 559 | 558 | {"type": "Polygon", "coordinates": [[[-117.14812, 33.12447], [-117.14555, 33.12477], [-117.14553, 33.12381], [-117.1481, 33.12381], [-117.14812, 33.12447]]]} | Open Access 1 | 1866 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 5.376 | City of San Marcos OS | 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]);