units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV
MNG_AGENCY >30
- Los Angeles, City of 314
- San Diego, City of 281
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 118
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 95
- Consumnes Community Services District 92
- Fresno, City of 83
- East Bay Regional Park District 76
- Modesto, City of 76
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Mountains Recreation and Conservation Authority 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- …
MNG_AG_TYP 16
- City Agency 7,486
- Recreation/Parks District 704
- County Agency 651
- Community Services District 173
- County Agency - Parks 154
- Open Space District 75
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
AGNCY_LEV 8 ✖
- City 7,352
- Special District 1,139
- County 798
- State 36
- Private 36
- Federal 8
- Non Profit 5
- Joint 2
ACCESS_TYP 4
- Open Access 9,084
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,376 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2232 | 2232 | 2231 | {"type": "Polygon", "coordinates": [[[-121.88455, 38.68187], [-121.88395, 38.68408], [-121.88098, 38.68409], [-121.88058, 38.68408], [-121.88163, 38.68168], [-121.88308, 38.68183], [-121.88416, 38.68178], [-121.88455, 38.68187]]]} | Open Access 1 | 47879 | Wild Wings Park | 31823 | 380 | Yolo County Parks, County of 497 | County 3 | County Agency - Parks 7 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 380 | Yolo County Parks, County of 488 | County 3 | County Agency - Parks 7 | https://www.yolocounty.org/general-government/general-government-departments/parks/parks-information/wild-wings-park | Yolo 33 | 17.528 | Wild Wings Park | 0 | Local Park 2 | 4 |
3110 | 3110 | 3109 | {"type": "Polygon", "coordinates": [[[-118.368, 34.09588], [-118.36753, 34.09588], [-118.36753, 34.09577], [-118.36799, 34.09577], [-118.368, 34.09588]]]} | Open Access 1 | 47991 | Havenhurst Park | 32412 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/19/773 | Los Angeles 6 | 0.129 | Havenhurst Park | 0 | Local Park 2 | 4 | |
11164 | 11164 | 11163 | {"type": "Polygon", "coordinates": [[[-118.34615, 34.09177], [-118.34615, 34.09186], [-118.34569, 34.09186], [-118.3457, 34.09177], [-118.34615, 34.09177]]]} | Open Access 1 | 47993 | Formosa Park | 32414 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/17/773 | Los Angeles 6 | 0.105 | Formosa Park | 2008 | Local Park 2 | 4 | |
10599 | 10599 | 10598 | {"type": "Polygon", "coordinates": [[[-122.44502, 37.45285], [-122.44494, 37.45344], [-122.44494, 37.45451], [-122.445, 37.45532], [-122.44411, 37.45541], [-122.44406, 37.4546], [-122.44284, 37.45476], [-122.4428, 37.4546], [-122.44263, 37.45462], [-122.44257, 37.45432], [-122.44041, 37.4546], [-122.43992, 37.4531], [-122.43998, 37.45304], [-122.43987, 37.4527], [-122.44219, 37.45241], [-122.44233, 37.45225], [-122.44492, 37.45192], [-122.44504, 37.4527], [-122.44502, 37.45285]]]} | Open Access 1 | 48637 | Poplar Beach | 33340 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 1128 | Half Moon Bay, City of 433 | City 2 | City Agency 2 | https://www.visithalfmoonbay.org/discover/poplar-beach | San Mateo 15 | 28.39 | Poplar Beach | 0 | Local Park 2 | 4 |
10621 | 10621 | 10620 | {"type": "Polygon", "coordinates": [[[-122.44604, 37.46514], [-122.44474, 37.46502], [-122.4448, 37.46461], [-122.44379, 37.46451], [-122.44452, 37.45959], [-122.44451, 37.45958], [-122.44382, 37.45967], [-122.44354, 37.45826], [-122.44345, 37.45827], [-122.44343, 37.45813], [-122.44351, 37.45811], [-122.44284, 37.45476], [-122.44407, 37.4546], [-122.44411, 37.45541], [-122.445, 37.45532], [-122.44514, 37.45654], [-122.44514, 37.45732], [-122.44526, 37.45784], [-122.44528, 37.45827], [-122.44461, 37.45834], [-122.4446, 37.45835], [-122.44481, 37.45961], [-122.445, 37.45984], [-122.4452, 37.46089], [-122.44544, 37.46227], [-122.44546, 37.46308], [-122.44557, 37.46346], [-122.44573, 37.46377], [-122.44593, 37.46432], [-122.44604, 37.46514]]]} | Open Access 1 | 48636 | Poplar Beach | 33340 | 1128 | Half Moon Bay, City of 439 | City 2 | City Agency 2 | http://www.half-moon-bay.ca.us/ | City 2 | 1128 | Half Moon Bay, City of 433 | City 2 | City Agency 2 | https://www.visithalfmoonbay.org/discover/poplar-beach | San Mateo 15 | 35.36 | Poplar Beach | 0 | Local Park 2 | 4 |
11453 | 11453 | 11452 | {"type": "Polygon", "coordinates": [[[-119.64146, 36.86082], [-119.64061, 36.86083], [-119.64054, 36.86081], [-119.64033, 36.86071], [-119.64039, 36.86063], [-119.64038, 36.86058], [-119.64034, 36.86054], [-119.64039, 36.86048], [-119.64043, 36.86049], [-119.64051, 36.8604], [-119.64048, 36.86038], [-119.64055, 36.86031], [-119.64068, 36.86025], [-119.64076, 36.86015], [-119.64076, 36.86006], [-119.64074, 36.85999], [-119.64069, 36.85994], [-119.6406, 36.85989], [-119.64045, 36.85988], [-119.64032, 36.85992], [-119.64025, 36.86], [-119.64022, 36.8601], [-119.64016, 36.86016], [-119.64014, 36.86015], [-119.64003, 36.86026], [-119.64004, 36.86027], [-119.63998, 36.86031], [-119.63993, 36.86029], [-119.63989, 36.86028], [-119.63977, 36.86035], [-119.63963, 36.86019], [-119.63964, 36.86015], [-119.64081, 36.85949], [-119.64109, 36.85938], [-119.64137, 36.85932], [-119.64141, 36.85934], [-119.64141, 36.85936], [-119.64144, 36.85937], [-119.64146, 36.86082]]]} | Open Access 1 | 48696 | Harlan Ranch Community Park | 33431 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | https://www.visitclovis.com/clovis-parks/ | Fresno 9 | 3.576 | Harlan Ranch Community Park | 0 | Local Park 2 | 4 |
1062 | 1062 | 1061 | {"type": "MultiPolygon", "coordinates": [[[[-118.45673, 35.11371], [-118.45597, 35.11371], [-118.45593, 35.11377], [-118.45581, 35.11377], [-118.45578, 35.11371], [-118.45496, 35.11372], [-118.45493, 35.11377], [-118.45481, 35.11377], [-118.45478, 35.11372], [-118.45396, 35.11372], [-118.45393, 35.11377], [-118.45381, 35.11378], [-118.45377, 35.11372], [-118.4533, 35.11373], [-118.4533, 35.11405], [-118.45325, 35.1142], [-118.45294, 35.11456], [-118.45264, 35.11437], [-118.45246, 35.11418], [-118.45238, 35.11404], [-118.45233, 35.11388], [-118.45231, 35.11363], [-118.45234, 35.11342], [-118.45246, 35.11307], [-118.45265, 35.11274], [-118.45281, 35.11254], [-118.45313, 35.11274], [-118.45334, 35.11296], [-118.45335, 35.11356], [-118.45376, 35.11356], [-118.45378, 35.11354], [-118.45388, 35.11355], [-118.45395, 35.11353], [-118.45397, 35.11355], [-118.45476, 35.11355], [-118.45478, 35.11353], [-118.45488, 35.11355], [-118.45495, 35.11353], [-118.45497, 35.11355], [-118.45573, 35.11355], [-118.45575, 35.11353], [-118.45582, 35.11354], [-118.45592, 35.11353], [-118.45594, 35.11354], [-118.45672, 35.11354], [-118.45673, 35.11371]]], [[[-118.45822, 35.1139], [-118.45803, 35.11388], [-118.45779, 35.11378], [-118.45764, 35.11374], [-118.45703, 35.11373], [-118.45698, 35.11369], [-118.45698, 35.11358], [-118.45822, 35.11358], [-118.45822, 35.1139]]]]} | Open Access 1 | 48916 | Warrior Park | 33637 | 1467 | Tehachapi, City of 310 | City 2 | City Agency 2 | http://www.tehachapicityhall.com/ | City 2 | 1467 | Tehachapi, City of 307 | City 2 | City Agency 2 | https://www.tvrpd.org/ | Kern 36 | 5.909 | Warrior Park | 0 | Local Park 2 | 4 |
14220 | 14220 | 14219 | {"type": "Polygon", "coordinates": [[[-117.81871, 33.70241], [-117.81877, 33.70265], [-117.81878, 33.70282], [-117.81875, 33.70298], [-117.81862, 33.70333], [-117.81797, 33.70315], [-117.81755, 33.70299], [-117.81691, 33.70264], [-117.81689, 33.70253], [-117.81721, 33.70226], [-117.81758, 33.70204], [-117.81798, 33.70187], [-117.8183, 33.70178], [-117.8184, 33.70183], [-117.81843, 33.70182], [-117.81845, 33.70186], [-117.81843, 33.70189], [-117.81854, 33.70221], [-117.81852, 33.70225], [-117.81856, 33.70238], [-117.81863, 33.70238], [-117.81865, 33.70242], [-117.81871, 33.70241]]]} | Open Access 1 | 48852 | Victory Park | 33572 | 1360 | Tustin, City of 278 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | https://www.tustinca.org/Facilities/Facility/Details/Victory-Park-6 | Orange 3 | 4.505 | Victory Park | 0 | Local Park 2 | 4 |
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 |
11317 | 11317 | 11316 | {"type": "Polygon", "coordinates": [[[-120.23851, 37.96089], [-120.23752, 37.96088], [-120.23752, 37.96072], [-120.2376, 37.96065], [-120.23851, 37.96065], [-120.23851, 37.96089]]]} | Open Access 1 | 48053 | Depot Park | 32547 | 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.547 | Depot Park | 1993 | Local Park 2 | 4 |
11333 | 11333 | 11332 | {"type": "Polygon", "coordinates": [[[-120.23597, 37.96677], [-120.23585, 37.96674], [-120.23549, 37.9667], [-120.23553, 37.96647], [-120.2356, 37.96631], [-120.2357, 37.96629], [-120.23571, 37.96618], [-120.2358, 37.96617], [-120.23586, 37.9663], [-120.23597, 37.96677]]]} | Restricted Access 2 | 48057 | Tuolumne Community Garden | 32549 | 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.432 | Tuolumne Community Garden | 1996 | Local Park 2 | 4 |
14702 | 14702 | 14701 | {"type": "Polygon", "coordinates": [[[-118.24012, 33.93118], [-118.24012, 33.93118], [-118.2401, 33.93246], [-118.23934, 33.931], [-118.23943, 33.93111], [-118.23957, 33.93117], [-118.24012, 33.93118]]]} | Open Access 1 | 45057 | Watts Serenity Park | 28919 | 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 | https://www.tpl.org/our-work/parks-for-people/fitness-zones/monitor-avenue-park | Los Angeles 6 | 1.147 | Watts Serenity Park | 0 | Local Park 2 | 4 |
15050 | 15050 | 15049 | {"type": "Polygon", "coordinates": [[[-118.31903, 34.101], [-118.31887, 34.101], [-118.31887, 34.10054], [-118.31903, 34.10054], [-118.31903, 34.101]]]} | Open Access 1 | 45719 | Carlton Way Pocket Park | 28612 | 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 | https://www.tpl.org/our-work/parks-for-people/carlton-way-pocket-park | Los Angeles 6 | 0.191 | Carlton Way PP | 0 | Local Park 2 | 4 |
4131 | 4131 | 4130 | {"type": "Polygon", "coordinates": [[[-118.54299, 34.19064], [-118.54284, 34.19074], [-118.54242, 34.19049], [-118.54196, 34.1903], [-118.54174, 34.19014], [-118.54291, 34.18966], [-118.54291, 34.19054], [-118.54299, 34.19064]]]} | Open Access 1 | 47400 | Los Angeles River and Aliso Creek Confluence Park | 31121 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/los-angeles-river-aliso-creek-confluence-project | Los Angeles 6 | 1.682 | Los Angeles River and Aliso Creek Confluence Park | 2016 | Local Park 2 | 4 |
14970 | 14970 | 14969 | {"type": "Polygon", "coordinates": [[[-120.15795, 39.13429], [-120.15786, 39.13569], [-120.15552, 39.13559], [-120.15642, 39.13422], [-120.15795, 39.13429]]]} | Open Access 1 | 45583 | Kilner Park | 28409 | 2260 | Tahoe City Public Utilities District 993 | Special District 4 | Water District 13 | http://www.tahoecitypud.com/parksrec.shtml | Special District 4 | 2260 | Tahoe City Public Utilities District 658 | Special District 4 | Water District 13 | https://www.tcpud.org/parks-recreation/facilities-parks-and-rentals/parks/kilner-park | Placer 35 | 6.423 | Kilner Park | 0 | Local Park 2 | 4 |
11165 | 11165 | 11164 | {"type": "Polygon", "coordinates": [[[-118.15596, 34.11789], [-118.15596, 34.11836], [-118.15571, 34.11836], [-118.15572, 34.11789], [-118.15596, 34.11789]]]} | Open Access 1 | 47994 | South Pasadena Community Garden and Demonstration Garden | 32415 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/community-garden | Los Angeles 6 | 0.293 | South Pasadena Community Garden and Demonstration Garden | 2015 | Local Park 2 | 4 |
11232 | 11232 | 11231 | {"type": "Polygon", "coordinates": [[[-118.46481, 34.02853], [-118.4639, 34.02872], [-118.46352, 34.02864], [-118.46131, 34.02909], [-118.46102, 34.02931], [-118.46054, 34.02941], [-118.46045, 34.02911], [-118.46466, 34.02825], [-118.46471, 34.02825], [-118.46473, 34.02828], [-118.46481, 34.02853]]]} | Open Access 1 | 48030 | Ishihara Park | 32517 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | https://www.smgov.net/Departments/CCS/content.aspx?id=53687098200 | Los Angeles 6 | 2.358 | Ishihara Park | 2017 | Local Park 2 | 4 |
1746 | 1746 | 1745 | {"type": "Polygon", "coordinates": [[[-119.2751, 35.50217], [-119.2748, 35.50242], [-119.27445, 35.50212], [-119.27474, 35.50188], [-119.2751, 35.50217]]]} | Open Access 1 | 48487 | Town Square Park | 33197 | 1668 | Shafter, City of 418 | City 2 | City Agency 2 | http://www.shafter.com/73/Parks | City 2 | 1668 | Shafter, City of 412 | City 2 | City Agency 2 | https://www.shafter.com/73/Parks | Kern 36 | 0.43 | Town Square Park | 0 | Local Park 2 | 4 |
3956 | 3956 | 3955 | {"type": "Polygon", "coordinates": [[[-121.84533, 37.26464], [-121.84499, 37.26587], [-121.8333, 37.26597], [-121.8323, 37.26586], [-121.83182, 37.26587], [-121.83147, 37.26583], [-121.83147, 37.2658], [-121.8314, 37.26579], [-121.83136, 37.26576], [-121.83132, 37.26569], [-121.83129, 37.2657], [-121.83126, 37.26541], [-121.83111, 37.26459], [-121.83109, 37.26311], [-121.83104, 37.2625], [-121.83102, 37.2602], [-121.83107, 37.25982], [-121.83111, 37.25919], [-121.83617, 37.25916], [-121.83639, 37.25952], [-121.83773, 37.26158], [-121.8397, 37.26155], [-121.84206, 37.26469], [-121.84533, 37.26464]]]} | Open Access 1 | 46978 | Martial Cottle Park | 30611 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/martialcottle.aspx | Santa Clara 19 | 150.454 | Martial Cottle Park | 1963 | Local Park 2 | 4 |
13921 | 13921 | 13920 | {"type": "Polygon", "coordinates": [[[-121.84833, 37.25563], [-121.84663, 37.25985], [-121.84562, 37.26362], [-121.84547, 37.26412], [-121.84533, 37.26464], [-121.84206, 37.26469], [-121.8397, 37.26156], [-121.83774, 37.26159], [-121.83639, 37.25952], [-121.83617, 37.25916], [-121.84291, 37.25912], [-121.84291, 37.25868], [-121.84339, 37.2577], [-121.84335, 37.2575], [-121.8432, 37.2571], [-121.84276, 37.25508], [-121.84294, 37.25507], [-121.84294, 37.25502], [-121.84498, 37.25499], [-121.84601, 37.25529], [-121.84678, 37.25546], [-121.84741, 37.25556], [-121.84833, 37.25563]]]} | Open Access 1 | 46977 | Martial Cottle Park | 30611 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/martialcottle.aspx | Santa Clara 19 | 137.123 | Martial Cottle Park | 1963 | 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]);