units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
143 rows where DES_TP = 4 and MNG_AG_TYP = 2 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, COUNTY, YR_EST
MNG_AGENCY >30
- San Diego, City of 9
- Burbank, City of 7
- Chico, City of 7
- Watsonville, City of 5
- Glendora, City of 5
- Redlands, City of 5
- Los Angeles, City of 4
- Palo Alto, City of 4
- Gilroy, City of 4
- Carlsbad, City of 3
- La Verne, City of 3
- Roseville, City of 3
- Sacramento, City of 3
- Arcata, City of 3
- Claremont, City of 2
- Santa Cruz, City of 2
- Santa Barbara, City of 2
- Glendale, City of 2
- Fullerton, City of 2
- Riverside, City of 2
- Rolling Hills Estates, City of 2
- Rancho Palos Verdes, City of 2
- Long Beach, City of 2
- Sierra Madre, City of 2
- Murrieta, City of 2
- Sebastopol, City of 2
- Oakdale, City of 1
- Lancaster, City of 1
- San Francisco, City and County of 1
- San Luis Obispo, City of 1
- …
ACCESS_TYP 4
MNG_AG_TYP 1
- City Agency · 143 ✖
DES_TP 1
- Local Conservation Area · 143 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16781 | 16781 | 16780 | {"type": "Polygon", "coordinates": [[[-124.08173, 40.85366], [-124.08205, 40.85795], [-124.08204, 40.85906], [-124.08207, 40.86057], [-124.08202, 40.86085], [-124.08195, 40.86105], [-124.08189, 40.86114], [-124.08163, 40.8614], [-124.08149, 40.86151], [-124.0813, 40.86161], [-124.08108, 40.8617], [-124.08089, 40.86176], [-124.08045, 40.86184], [-124.08038, 40.85941], [-124.08034, 40.85885], [-124.0789, 40.85886], [-124.07895, 40.86166], [-124.07872, 40.86161], [-124.07846, 40.86153], [-124.07833, 40.86147], [-124.07833, 40.86145], [-124.07796, 40.86131], [-124.07763, 40.86114], [-124.07732, 40.86104], [-124.07701, 40.86099], [-124.07685, 40.86113], [-124.07634, 40.86087], [-124.07601, 40.86066], [-124.07575, 40.86044], [-124.07555, 40.86025], [-124.07351, 40.85798], [-124.07422, 40.85762], [-124.07362, 40.85567], [-124.07233, 40.85574], [-124.07226, 40.85358], [-124.07302, 40.85358], [-124.07299, 40.85048], [-124.07303, 40.84968], [-124.06907, 40.84969], [-124.06897, 40.84952], [-124.06746, 40.84753], [-124.07029, 40.84629], [-124.07029, 40.84627], [-124.06941, 40.8451], [-124.06943, 40.84508], [-124.06847, 40.8444], [-124.06704, 40.84256], [-124.0661, 40.84234], [-124.06497, 40.84145], [-124.06591, 40.84078], [-124.06643, 40.8412], [-124.06667, 40.84104], [-124.06696, 40.84128], [-124.06731, 40.84104], [-124.06894, 40.84233], [-124.07297, 40.8423], [-124.07297, 40.84018], [-124.07238, 40.84001], [-124.07216, 40.83988], [-124.07148, 40.83966], [-124.07063, 40.83907], [-124.07057, 40.83901], [-124.07033, 40.83899], [-124.07015, 40.83906], [-124.07008, 40.83903], [-124.07005, 40.83901], [-124.07005, 40.83896], [-124.07009, 40.83875], [-124.07015, 40.83869], [-124.07016, 40.83864], [-124.07016, 40.83859], [-124.07009, 40.83846], [-124.07041, 40.83803], [-124.07088, 40.8378], [-124.07057, 40.83747], [-124.07097, 40.83718], [-124.07299, 40.83865], [-124.07384, 40.83503], [-124.07993, 40.83507], [-124.08014, 40.83513], [-124.08081, 40.83521], [-124.08097, 40.83527], [-124.08109, 40.83536], [-124.08113, 40.83541], [-124.08122, 40.83563], [-124.08142, 40.83776], [-124.08153, 40.83871], [-124.08151, 40.84041], [-124.08148, 40.84617], [-124.0813, 40.84616], [-124.08129, 40.84617], [-124.0813, 40.84716], [-124.08128, 40.84882], [-124.08144, 40.8506], [-124.08146, 40.8506], [-124.08152, 40.85053], [-124.08161, 40.85091], [-124.08164, 40.85242], [-124.08173, 40.85366]], [[-124.07898, 40.84969], [-124.07899, 40.84968], [-124.07896, 40.8489], [-124.07788, 40.84904], [-124.07788, 40.8497], [-124.07898, 40.84969]]]} | Open Access 1 | 46882 | Jacoby Creek-Gannon Slough Wildlife Area | 30363 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 587.76 | Jacoby Creek-Gannon Slough Wildlife Area | 0 | Local Conservation Area 4 | 2 | |
12219 | 12219 | 12218 | {"type": "Polygon", "coordinates": [[[-123.79557, 39.44475], [-123.79553, 39.44475], [-123.79546, 39.44488], [-123.79492, 39.44513], [-123.79494, 39.4454], [-123.79333, 39.4454], [-123.79327, 39.4443], [-123.79328, 39.44402], [-123.79347, 39.44402], [-123.79348, 39.44405], [-123.79384, 39.44405], [-123.79385, 39.4441], [-123.79413, 39.44409], [-123.79414, 39.44415], [-123.79491, 39.44414], [-123.79491, 39.44408], [-123.79531, 39.44407], [-123.79532, 39.4442], [-123.79557, 39.4442], [-123.79557, 39.44475]]]} | Open Access 1 | 25413 | Otis R. Johnson Wilderness Park | 23267 | 1412 | Fort Bragg, City of 889 | City 2 | City Agency 2 | http://city.fortbragg.com/ | City 2 | 1412 | Fort Bragg, City of 864 | City 2 | City Agency 2 | Mendocino 24 | 6.276 | Otis R. Johnson Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
16940 | 16940 | 16939 | {"type": "Polygon", "coordinates": [[[-122.84377, 38.62226], [-122.84368, 38.6223], [-122.84358, 38.62231], [-122.84251, 38.62232], [-122.84195, 38.62227], [-122.84194, 38.62237], [-122.84211, 38.62239], [-122.84209, 38.62266], [-122.84173, 38.62262], [-122.84146, 38.62261], [-122.84145, 38.62289], [-122.84092, 38.62291], [-122.83988, 38.62287], [-122.83935, 38.62288], [-122.83932, 38.62261], [-122.8385, 38.62264], [-122.83877, 38.62224], [-122.83884, 38.62226], [-122.83889, 38.62219], [-122.83906, 38.62227], [-122.83918, 38.62227], [-122.83929, 38.62204], [-122.83907, 38.62196], [-122.83888, 38.62178], [-122.83872, 38.62157], [-122.83862, 38.6215], [-122.83849, 38.62145], [-122.83831, 38.62145], [-122.83813, 38.62151], [-122.83803, 38.62158], [-122.83775, 38.62188], [-122.83708, 38.62147], [-122.83713, 38.62062], [-122.83543, 38.62019], [-122.83495, 38.61921], [-122.83414, 38.61931], [-122.83411, 38.61939], [-122.83377, 38.61963], [-122.83329, 38.61974], [-122.83322, 38.61978], [-122.8331, 38.61987], [-122.83305, 38.61997], [-122.833, 38.62003], [-122.83241, 38.62041], [-122.83109, 38.62042], [-122.83098, 38.62033], [-122.83122, 38.61983], [-122.83154, 38.61989], [-122.83171, 38.61933], [-122.83183, 38.61844], [-122.83043, 38.6186], [-122.82999, 38.61855], [-122.82945, 38.61845], [-122.82937, 38.61872], [-122.8289, 38.61905], [-122.82851, 38.61911], [-122.82849, 38.6189], [-122.82854, 38.61876], [-122.82855, 38.61869], [-122.82859, 38.61857], [-122.82858, 38.61856], [-122.82873, 38.61827], [-122.82913, 38.61772], [-122.82916, 38.61763], [-122.82917, 38.61752], [-122.8292, 38.61746], [-122.82925, 38.61741], [-122.82949, 38.61732], [-122.83004, 38.61777], [-122.83039, 38.61772], [-122.83069, 38.61762], [-122.8307, 38.61761], [-122.83059, 38.61749], [-122.83074, 38.61742], [-122.83076, 38.61743], [-122.83097, 38.6173], [-122.83121, 38.61714], [-122.83145, 38.61694], [-122.83144, 38.61693], [-122.83122, 38.61677], [-122.83151, 38.61647], [-122.83123, 38.61632], [-122.83145, 38.61601], [-122.83254, 38.6164], [-122.83256, 38.61587], [-122.83507, 38.61554], [-122.83573, 38.61541], [-122.83587, 38.61568], [-122.83646, 38.61567], [-122.8367, 38.61612], [-122.83795, 38.61568], [-122.83876, 38.61654], [-122.83923, 38.61678], [-122.84085, 38.61657], [-122.84112, 38.61639], [-122.84178, 38.61646], [-122.8423, 38.61692], [-122.84344, 38.61729], [-122.84328, 38.62056], [-122.8473, 38.62055], [-122.84721, 38.62384], [-122.84713, 38.62377], [-122.84704, 38.62359], [-122.84697, 38.62351], [-122.84687, 38.62346], [-122.84648, 38.62335], [-122.84634, 38.62325], [-122.84626, 38.62314], [-122.84624, 38.62309], [-122.84622, 38.62297], [-122.84623, 38.62286], [-122.84622, 38.6228], [-122.84618, 38.62273], [-122.84611, 38.62269], [-122.84603, 38.62266], [-122.8459, 38.62267], [-122.84547, 38.62287], [-122.84526, 38.62288], [-122.84489, 38.62269], [-122.84456, 38.62257], [-122.84453, 38.62252], [-122.84477, 38.62231], [-122.84469, 38.62216], [-122.84439, 38.62229], [-122.84433, 38.62204], [-122.84427, 38.62197], [-122.84443, 38.62173], [-122.84426, 38.62168], [-122.84407, 38.62168], [-122.84393, 38.62173], [-122.84411, 38.62196], [-122.84386, 38.62221], [-122.84377, 38.62226]]]} | Open Access 1 | 49079 | Fitch Mountain Park Open Space Preserve | 33780 | 1131 | Healdsburg, City of 374 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | Sonoma 16 | 171.489 | Fitch Mtn. Park OSP | 0 | Local Conservation Area 4 | 2 | |
10422 | 10422 | 10421 | {"type": "Polygon", "coordinates": [[[-122.81981, 38.39889], [-122.81869, 38.39931], [-122.8173, 38.39755], [-122.81649, 38.39755], [-122.81648, 38.39669], [-122.81743, 38.39647], [-122.8176, 38.39628], [-122.818, 38.39615], [-122.818, 38.39613], [-122.81924, 38.39752], [-122.81891, 38.39753], [-122.81981, 38.39889]]]} | No Public Access 3 | 18463 | Laguna de Santa Rosa Wetlands Preserve | 20852 | 1331 | Sebastopol, City of 605 | City 2 | City Agency 2 | http://ci.sebastopol.ca.us/page/city-parks | City 2 | 1331 | Sebastopol, City of 594 | City 2 | City Agency 2 | Sonoma 16 | 11.785 | Laguna de Santa Rosa Wetlands Preserve | 0 | Local Conservation Area 4 | 2 | |
12368 | 12368 | 12367 | {"type": "Polygon", "coordinates": [[[-122.81825, 38.40854], [-122.81815, 38.40879], [-122.81802, 38.40903], [-122.81771, 38.40944], [-122.81761, 38.40955], [-122.81723, 38.40989], [-122.81689, 38.41011], [-122.81676, 38.41022], [-122.81642, 38.41022], [-122.8171, 38.40934], [-122.81709, 38.40932], [-122.81257, 38.40934], [-122.81258, 38.40564], [-122.81277, 38.40543], [-122.81323, 38.40525], [-122.81293, 38.4047], [-122.81573, 38.4037], [-122.81636, 38.40354], [-122.81639, 38.40358], [-122.81665, 38.40373], [-122.8168, 38.40416], [-122.81718, 38.40598], [-122.81793, 38.40805], [-122.81792, 38.40819], [-122.81763, 38.40819], [-122.81772, 38.40847], [-122.81769, 38.40854], [-122.81825, 38.40854]]]} | Open Access 1 | 26070 | Laguna de Santa Rosa Wetlands Preserve | 20853 | 1331 | Sebastopol, City of 605 | City 2 | City Agency 2 | http://ci.sebastopol.ca.us/page/city-parks | City 2 | 1331 | Sebastopol, City of 594 | City 2 | City Agency 2 | Sonoma 16 | 61.2 | Laguna de Santa Rosa Wetlands Preserve | 0 | Local Conservation Area 4 | 2 | |
3337 | 3337 | 3336 | {"type": "Polygon", "coordinates": [[[-122.727, 38.40276], [-122.72699, 38.40298], [-122.72678, 38.40342], [-122.72676, 38.40361], [-122.7267, 38.40366], [-122.72629, 38.40366], [-122.72613, 38.40368], [-122.72613, 38.40277], [-122.727, 38.40276]]]} | Open Access 1 | 29791 | Colgan Creek Park and Preserve | 17496 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.602 | Colgan Creek Park and Preserve | 0 | Local Conservation Area 4 | 2 | |
1139 | 1139 | 1138 | {"type": "Polygon", "coordinates": [[[-122.51189, 37.77681], [-122.51151, 37.77685], [-122.5112, 37.77653], [-122.51112, 37.77641], [-122.51112, 37.77626], [-122.51093, 37.77611], [-122.51078, 37.77588], [-122.51061, 37.77568], [-122.51028, 37.77523], [-122.51108, 37.7752], [-122.51109, 37.77541], [-122.51113, 37.77564], [-122.5112, 37.77588], [-122.51128, 37.77607], [-122.51149, 37.7764], [-122.51189, 37.77681]]]} | Open Access 1 | 6699 | Gr.hwy/balboa Natural Area | 19412 | 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 | 1.868 | Gr.hwy/balboa Natural Area | 0 | Local Conservation Area 4 | 2 | |
16734 | 16734 | 16733 | {"type": "Polygon", "coordinates": [[[-122.39604, 37.5774], [-122.39547, 37.57779], [-122.39467, 37.57823], [-122.39425, 37.57863], [-122.39392, 37.57904], [-122.39327, 37.57947], [-122.39302, 37.5797], [-122.39259, 37.58019], [-122.39222, 37.58053], [-122.39203, 37.58068], [-122.39169, 37.58041], [-122.39132, 37.5807], [-122.39099, 37.58083], [-122.39091, 37.58081], [-122.39083, 37.58083], [-122.39078, 37.58086], [-122.39073, 37.58097], [-122.39067, 37.58104], [-122.39001, 37.58148], [-122.38957, 37.58188], [-122.38948, 37.58193], [-122.38931, 37.58196], [-122.38924, 37.58199], [-122.38921, 37.58205], [-122.38922, 37.58213], [-122.38876, 37.58268], [-122.38875, 37.58267], [-122.38797, 37.583], [-122.3879, 37.58342], [-122.3883, 37.58366], [-122.38849, 37.58382], [-122.38828, 37.58392], [-122.38809, 37.58392], [-122.38797, 37.58386], [-122.38776, 37.5838], [-122.38763, 37.58383], [-122.38742, 37.58377], [-122.38695, 37.58374], [-122.38686, 37.58367], [-122.38677, 37.58264], [-122.38679, 37.58255], [-122.38696, 37.58248], [-122.38704, 37.58238], [-122.38714, 37.5824], [-122.38725, 37.58252], [-122.38768, 37.58236], [-122.38778, 37.58224], [-122.38793, 37.58213], [-122.3879, 37.58187], [-122.38808, 37.58173], [-122.38817, 37.58148], [-122.38833, 37.58143], [-122.38837, 37.58122], [-122.38848, 37.58117], [-122.38854, 37.58101], [-122.38875, 37.58082], [-122.38907, 37.58075], [-122.38941, 37.5806], [-122.38959, 37.58047], [-122.38996, 37.58048], [-122.39024, 37.58041], [-122.39026, 37.58031], [-122.39052, 37.58003], [-122.39058, 37.5799], [-122.39068, 37.5798], [-122.39073, 37.57963], [-122.39083, 37.5796], [-122.38978, 37.5788], [-122.38987, 37.57874], [-122.38998, 37.57862], [-122.39006, 37.57864], [-122.39122, 37.57818], [-122.39194, 37.57892], [-122.39205, 37.57887], [-122.39214, 37.5787], [-122.39217, 37.57861], [-122.39227, 37.57854], [-122.39234, 37.57845], [-122.39243, 37.57848], [-122.39256, 37.57844], [-122.3927, 37.57855], [-122.39311, 37.57835], [-122.39321, 37.5782], [-122.39334, 37.57812], [-122.39341, 37.57805], [-122.3938, 37.57788], [-122.39394, 37.5779], [-122.39421, 37.57779], [-122.39454, 37.57775], [-122.39483, 37.57768], [-122.39489, 37.57762], [-122.39502, 37.57762], [-122.3951, 37.57756], [-122.39535, 37.57748], [-122.39578, 37.57722], [-122.39604, 37.5774]]]} | Open Access 1 | 17912 | Mills Canyon Wildlife Area | 22254 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 31.113 | Mills Canyon Wildlife Area | 1961 | Local Conservation Area 4 | 2 | |
13669 | 13669 | 13668 | {"type": "Polygon", "coordinates": [[[-122.32205, 40.55148], [-122.32199, 40.55645], [-122.3148, 40.55648], [-122.31478, 40.55437], [-122.31469, 40.55436], [-122.31468, 40.55392], [-122.31465, 40.55367], [-122.31461, 40.55302], [-122.31457, 40.55291], [-122.31451, 40.55278], [-122.31431, 40.55258], [-122.3141, 40.55241], [-122.31391, 40.55227], [-122.31346, 40.55207], [-122.31328, 40.55193], [-122.31297, 40.55162], [-122.31212, 40.55114], [-122.31165, 40.55096], [-122.31126, 40.55071], [-122.31081, 40.55051], [-122.3106, 40.55038], [-122.30834, 40.54925], [-122.31485, 40.54923], [-122.31486, 40.54926], [-122.31508, 40.54926], [-122.31556, 40.54969], [-122.31615, 40.54982], [-122.31622, 40.54973], [-122.31576, 40.54931], [-122.31848, 40.54931], [-122.31848, 40.54977], [-122.31852, 40.54977], [-122.31852, 40.55097], [-122.31848, 40.55102], [-122.31848, 40.55103], [-122.32024, 40.552], [-122.32066, 40.55188], [-122.32067, 40.55147], [-122.32205, 40.55148]]]} | Open Access 1 | 36037 | Clover Creek Preserve | 17436 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 127.579 | Clover Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
1834 | 1834 | 1833 | {"type": "Polygon", "coordinates": [[[-122.29139, 37.56829], [-122.29135, 37.56831], [-122.2913, 37.56829], [-122.29123, 37.56825], [-122.29109, 37.56813], [-122.29095, 37.56795], [-122.29089, 37.56778], [-122.29092, 37.56774], [-122.29111, 37.5678], [-122.29127, 37.56788], [-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829]]]} | Open Access 1 | 14019 | Marina Lagoon Wildlife Island | 21829 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.388 | Marina Lagoon Wildlife Island | 1962 | Local Conservation Area 4 | 2 | |
13794 | 13794 | 13793 | {"type": "Polygon", "coordinates": [[[-122.28173, 38.30282], [-122.28177, 38.30281], [-122.28187, 38.30284], [-122.28199, 38.30295], [-122.28213, 38.30313], [-122.2823, 38.30365], [-122.28241, 38.30419], [-122.2824, 38.30431], [-122.28236, 38.30442], [-122.28231, 38.3047], [-122.28223, 38.305], [-122.28213, 38.30518], [-122.28199, 38.30533], [-122.28194, 38.30541], [-122.2816, 38.30576], [-122.2815, 38.30588], [-122.28044, 38.3068], [-122.28003, 38.30667], [-122.2801, 38.3057], [-122.28032, 38.30569], [-122.28044, 38.30503], [-122.28063, 38.30497], [-122.28081, 38.30483], [-122.28096, 38.30459], [-122.28097, 38.30452], [-122.28111, 38.30437], [-122.28133, 38.30392], [-122.28154, 38.30356], [-122.28157, 38.30317], [-122.28173, 38.30282]]]} | Open Access 1 | 36362 | Oxbow Preserve | 28577 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 10.376 | Oxbow Preserve | 0 | Local Conservation Area 4 | 2 | |
14656 | 14656 | 14655 | {"type": "Polygon", "coordinates": [[[-122.26076, 38.07691], [-122.26064, 38.0769], [-122.26063, 38.07694], [-122.25758, 38.07677], [-122.2557, 38.07638], [-122.25595, 38.07779], [-122.2569, 38.07836], [-122.25772, 38.0818], [-122.25793, 38.08285], [-122.25917, 38.08302], [-122.25879, 38.08349], [-122.25825, 38.08339], [-122.25824, 38.0834], [-122.25873, 38.08378], [-122.25901, 38.08386], [-122.26016, 38.08403], [-122.25886, 38.0844], [-122.26004, 38.08473], [-122.25888, 38.08472], [-122.2582, 38.08463], [-122.25799, 38.08463], [-122.25783, 38.08472], [-122.25682, 38.08369], [-122.25648, 38.08233], [-122.25642, 38.0818], [-122.25625, 38.08136], [-122.25608, 38.08105], [-122.2553, 38.08068], [-122.25544, 38.08059], [-122.25543, 38.08058], [-122.25322, 38.07996], [-122.25387, 38.0795], [-122.25321, 38.07877], [-122.25264, 38.07903], [-122.2507, 38.07665], [-122.25133, 38.0765], [-122.25284, 38.0755], [-122.25368, 38.07531], [-122.25483, 38.0753], [-122.25564, 38.07534], [-122.25591, 38.07527], [-122.25604, 38.07515], [-122.25659, 38.07432], [-122.25704, 38.07441], [-122.25737, 38.07472], [-122.25771, 38.07484], [-122.25796, 38.07497], [-122.25807, 38.07533], [-122.25857, 38.07549], [-122.25899, 38.07592], [-122.25921, 38.076], [-122.25952, 38.0763], [-122.26039, 38.07621], [-122.26043, 38.07599], [-122.2605, 38.07594], [-122.26059, 38.07596], [-122.26042, 38.07647], [-122.26076, 38.07691]]]} | Open Access 1 | 44916 | Mare Island Shoreline Heritage Preserve | 21800 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 83.482 | Mare Island Shoreline Heritage Preserve | 0 | Local Conservation Area 4 | 2 | |
15931 | 15931 | 15930 | {"type": "Polygon", "coordinates": [[[-122.24262, 38.17617], [-122.23981, 38.17895], [-122.23986, 38.1792], [-122.23953, 38.1794], [-122.23943, 38.17962], [-122.23897, 38.17977], [-122.2389, 38.17988], [-122.23875, 38.17999], [-122.23878, 38.18009], [-122.2392, 38.18056], [-122.23904, 38.18081], [-122.23904, 38.18115], [-122.23881, 38.18129], [-122.23872, 38.18153], [-122.23844, 38.18154], [-122.23842, 38.18192], [-122.2382, 38.18229], [-122.23791, 38.18226], [-122.23767, 38.18233], [-122.23754, 38.18257], [-122.23737, 38.18259], [-122.23706, 38.18241], [-122.23686, 38.18239], [-122.23663, 38.18253], [-122.23375, 38.18254], [-122.23285, 38.18565], [-122.22446, 38.18414], [-122.22153, 38.19229], [-122.21829, 38.19216], [-122.21145, 38.19203], [-122.20969, 38.18989], [-122.21593, 38.18833], [-122.21327, 38.18417], [-122.21376, 38.1835], [-122.21378, 38.18328], [-122.21374, 38.18232], [-122.21527, 38.1799], [-122.21507, 38.17952], [-122.21507, 38.17936], [-122.21492, 38.17912], [-122.21474, 38.1789], [-122.21463, 38.17869], [-122.21238, 38.17684], [-122.21152, 38.17477], [-122.21073, 38.1741], [-122.2161, 38.17414], [-122.22476, 38.17401], [-122.22389, 38.17619], [-122.22808, 38.17781], [-122.22869, 38.17795], [-122.23028, 38.17837], [-122.23138, 38.1786], [-122.2334, 38.17948], [-122.23328, 38.17976], [-122.23328, 38.17977], [-122.23699, 38.18098], [-122.24253, 38.1755], [-122.24262, 38.17617]]]} | Restricted Access 2 | 34999 | Newell Open Space Preserve | 22722 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 639.436 | Newell OSP | 0 | Local Conservation Area 4 | 2 | |
1433 | 1433 | 1432 | {"type": "Polygon", "coordinates": [[[-122.17854, 37.34566], [-122.17621, 37.35241], [-122.17291, 37.35273], [-122.17289, 37.35278], [-122.17225, 37.35279], [-122.17206, 37.34613], [-122.17207, 37.34577], [-122.17854, 37.34566]]]} | Open Access 1 | 47698 | Foothills Open Space Preserve | 31434 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 86.854 | Foothills OSP | 1975 | Local Conservation Area 4 | 2 | |
6730 | 6730 | 6729 | {"type": "Polygon", "coordinates": [[[-122.1629, 37.36432], [-122.16229, 37.3647], [-122.16191, 37.36476], [-122.16185, 37.36454], [-122.16027, 37.36435], [-122.16046, 37.36512], [-122.15953, 37.36527], [-122.15962, 37.36576], [-122.15884, 37.36605], [-122.15821, 37.36623], [-122.15804, 37.36625], [-122.15788, 37.36621], [-122.15731, 37.36594], [-122.15714, 37.36581], [-122.15695, 37.36561], [-122.15689, 37.36552], [-122.15686, 37.36542], [-122.15684, 37.36518], [-122.15681, 37.36505], [-122.15673, 37.3649], [-122.15666, 37.36479], [-122.15564, 37.36365], [-122.15552, 37.36353], [-122.1553, 37.36338], [-122.15454, 37.36294], [-122.15444, 37.36285], [-122.15435, 37.36275], [-122.15391, 37.36215], [-122.1548, 37.36189], [-122.15486, 37.3613], [-122.15455, 37.36088], [-122.15433, 37.36066], [-122.15462, 37.35983], [-122.15468, 37.3598], [-122.15598, 37.36056], [-122.15779, 37.36015], [-122.15749, 37.35841], [-122.1567, 37.35775], [-122.15615, 37.35772], [-122.15574, 37.35834], [-122.15479, 37.35873], [-122.15459, 37.35836], [-122.15412, 37.35852], [-122.15396, 37.35773], [-122.15471, 37.35722], [-122.1545, 37.35675], [-122.15406, 37.3564], [-122.15371, 37.35589], [-122.15195, 37.35513], [-122.15199, 37.35454], [-122.15207, 37.35431], [-122.15222, 37.35412], [-122.15234, 37.35377], [-122.15211, 37.35335], [-122.15238, 37.35351], [-122.15435, 37.35486], [-122.15491, 37.3554], [-122.1555, 37.35525], [-122.15595, 37.35548], [-122.15607, 37.35557], [-122.15665, 37.3561], [-122.15686, 37.35627], [-122.1573, 37.35678], [-122.15757, 37.35701], [-122.15821, 37.35746], [-122.15835, 37.35753], [-122.15881, 37.35765], [-122.15879, 37.35799], [-122.15874, 37.35816], [-122.15869, 37.35844], [-122.15867, 37.35892], [-122.1587, 37.35929], [-122.15866, 37.35963], [-122.15841, 37.36001], [-122.15833, 37.36025], [-122.15816, 37.36059], [-122.15812, 37.36084], [-122.1582, 37.36124], [-122.15844, 37.36166], [-122.15871, 37.36199], [-122.15885, 37.362], [-122.15894, 37.36236], [-122.15932, 37.36231], [-122.15937, 37.36237], [-122.15941, 37.36238], [-122.15954, 37.3627], [-122.16023, 37.36295], [-122.16124, 37.36311], [-122.16158, 37.36318], [-122.16226, 37.36325], [-122.16236, 37.36364], [-122.1629, 37.36432]]]} | No Public Access 3 | 5074 | Byrne Reserve | 16619 | 1187 | Los Altos Hills, Town of 842 | City 2 | City Agency 2 | http://www.losaltoshills.ca.gov/parks-and-recreation/parks-and-recreation | City 2 | 1187 | Los Altos Hills, Town of 819 | City 2 | City Agency 2 | Santa Clara 19 | 100.121 | Byrne Reserve | 1968 | Local Conservation Area 4 | 2 | |
8947 | 8947 | 8946 | {"type": "Polygon", "coordinates": [[[-122.15409, 37.85875], [-122.15382, 37.85912], [-122.15332, 37.8589], [-122.15259, 37.85923], [-122.15174, 37.85981], [-122.15113, 37.86013], [-122.15036, 37.86072], [-122.15004, 37.86052], [-122.14988, 37.86078], [-122.14943, 37.86126], [-122.14924, 37.86109], [-122.14906, 37.86095], [-122.14886, 37.86083], [-122.14741, 37.86019], [-122.147, 37.85999], [-122.14641, 37.85974], [-122.14369, 37.85838], [-122.14335, 37.85825], [-122.14317, 37.85821], [-122.14295, 37.85818], [-122.14268, 37.85816], [-122.1426, 37.85264], [-122.14422, 37.85365], [-122.14541, 37.85435], [-122.14541, 37.85462], [-122.14521, 37.85491], [-122.14526, 37.85503], [-122.14528, 37.85512], [-122.14538, 37.85516], [-122.14542, 37.85521], [-122.14572, 37.85545], [-122.14665, 37.85597], [-122.14686, 37.8567], [-122.14772, 37.85662], [-122.14768, 37.85637], [-122.14785, 37.85571], [-122.14886, 37.85549], [-122.1493, 37.85542], [-122.15037, 37.85557], [-122.15096, 37.85579], [-122.15188, 37.85642], [-122.15363, 37.85749], [-122.15347, 37.85824], [-122.15354, 37.85835], [-122.15365, 37.85847], [-122.15409, 37.85875]]]} | Open Access 1 | 44957 | Mulholland Open Space Preserve | 22595 | 1235 | Orinda, City of 392 | City 2 | City Agency 2 | http://www.cityoforinda.org/index.asp?Type=B_BASIC&SEC={DF30AA31-A638-4650-A63E-8E4033089DBE} | City 2 | 1235 | Orinda, City of 386 | City 2 | City Agency 2 | Contra Costa 12 | 113.073 | Mulholland OSP | 1991 | Local Conservation Area 4 | 2 | |
15949 | 15949 | 15948 | {"type": "Polygon", "coordinates": [[[-122.14268, 37.85816], [-122.14235, 37.85815], [-122.14204, 37.85809], [-122.14178, 37.85803], [-122.14081, 37.85772], [-122.13915, 37.85695], [-122.13895, 37.85687], [-122.1385, 37.85675], [-122.13797, 37.85644], [-122.13789, 37.85641], [-122.13737, 37.85627], [-122.13684, 37.85603], [-122.13597, 37.85559], [-122.13559, 37.85538], [-122.13499, 37.85501], [-122.1347, 37.85482], [-122.13427, 37.85445], [-122.13341, 37.85359], [-122.13318, 37.85341], [-122.13276, 37.85316], [-122.13262, 37.85304], [-122.13226, 37.8527], [-122.13148, 37.85184], [-122.13125, 37.85145], [-122.13077, 37.8505], [-122.13068, 37.85042], [-122.13059, 37.85038], [-122.13043, 37.85037], [-122.13031, 37.85041], [-122.13023, 37.85047], [-122.12693, 37.84989], [-122.12656, 37.84953], [-122.12664, 37.84925], [-122.12664, 37.84898], [-122.1267, 37.84885], [-122.12668, 37.84843], [-122.12852, 37.84839], [-122.12881, 37.84814], [-122.12743, 37.84726], [-122.12754, 37.84707], [-122.12862, 37.84718], [-122.12969, 37.84772], [-122.1304, 37.84876], [-122.13019, 37.84901], [-122.13064, 37.84986], [-122.13107, 37.85023], [-122.13172, 37.85002], [-122.13187, 37.84988], [-122.13228, 37.85019], [-122.13235, 37.85041], [-122.13229, 37.85079], [-122.1325, 37.85138], [-122.13265, 37.85212], [-122.13301, 37.85271], [-122.13421, 37.85275], [-122.13436, 37.85203], [-122.13483, 37.85169], [-122.13519, 37.85167], [-122.13524, 37.85145], [-122.13544, 37.85143], [-122.13582, 37.85128], [-122.13606, 37.85101], [-122.1382, 37.853], [-122.139, 37.85303], [-122.13957, 37.85319], [-122.13971, 37.85326], [-122.13974, 37.85323], [-122.14011, 37.85336], [-122.14028, 37.85321], [-122.14042, 37.85312], [-122.14058, 37.85297], [-122.14043, 37.85206], [-122.14032, 37.85195], [-122.1407, 37.85102], [-122.14152, 37.8514], [-122.14169, 37.8513], [-122.14178, 37.85127], [-122.14206, 37.85231], [-122.1426, 37.85264], [-122.14268, 37.85816]], [[-122.13781, 37.85395], [-122.13781, 37.85397], [-122.13851, 37.85438], [-122.13875, 37.85413], [-122.13867, 37.85394], [-122.13807, 37.85365], [-122.13781, 37.85395]]]} | Open Access 1 | 44956 | Mulholland Open Space Preserve | 22594 | 1215 | Moraga, Town of 731 | City 2 | City Agency 2 | http://www.ci.moraga.ca.us/dept/park-rec/home | City 2 | 1215 | Moraga, Town of 715 | City 2 | City Agency 2 | Contra Costa 12 | 122.086 | Mulholland OSP | 0 | Local Conservation Area 4 | 2 | |
3277 | 3277 | 3276 | {"type": "Polygon", "coordinates": [[[-122.1276, 37.47289], [-122.1263, 37.47477], [-122.12365, 37.4757], [-122.12364, 37.4744], [-122.12355, 37.47442], [-122.12354, 37.47435], [-122.12325, 37.47442], [-122.12322, 37.47422], [-122.1232, 37.47247], [-122.1217, 37.47234], [-122.12044, 37.47011], [-122.11894, 37.46936], [-122.1178, 37.46885], [-122.1166, 37.46744], [-122.11616, 37.46674], [-122.11562, 37.46613], [-122.11646, 37.46595], [-122.11693, 37.46561], [-122.11769, 37.46539], [-122.11935, 37.4644], [-122.12374, 37.46164], [-122.12382, 37.46146], [-122.12483, 37.46429], [-122.12594, 37.46698], [-122.1276, 37.47289]]]} | Open Access 1 | 23137 | Baylands Preserve | 8356 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/gov/depts/csd/parks/preserves/baylands.asp | San Mateo 15 | 193.549 | Baylands Preserve | 1944 | Local Conservation Area 4 | 2 |
10365 | 10365 | 10364 | {"type": "Polygon", "coordinates": [[[-122.12408, 37.46084], [-122.12374, 37.46164], [-122.11935, 37.4644], [-122.11769, 37.46539], [-122.11693, 37.46561], [-122.11658, 37.46587], [-122.11625, 37.46581], [-122.11519, 37.46611], [-122.11576, 37.46572], [-122.11475, 37.46553], [-122.11433, 37.46476], [-122.11345, 37.46405], [-122.11261, 37.46368], [-122.1113, 37.46352], [-122.1105, 37.46337], [-122.10985, 37.46312], [-122.10952, 37.4632], [-122.10928, 37.46328], [-122.10889, 37.46296], [-122.10834, 37.46278], [-122.10812, 37.46256], [-122.10757, 37.46235], [-122.10736, 37.46233], [-122.10725, 37.46222], [-122.10685, 37.46171], [-122.10649, 37.46131], [-122.10608, 37.46135], [-122.10527, 37.46138], [-122.10402, 37.46218], [-122.10226, 37.4632], [-122.1018, 37.4633], [-122.10126, 37.46319], [-122.10098, 37.46294], [-122.10071, 37.46253], [-122.10066, 37.46145], [-122.10107, 37.45993], [-122.10165, 37.4583], [-122.10191, 37.45772], [-122.1019, 37.45759], [-122.10245, 37.45725], [-122.10271, 37.4567], [-122.10332, 37.4562], [-122.10383, 37.45594], [-122.10514, 37.45586], [-122.10573, 37.45593], [-122.10622, 37.45633], [-122.10628, 37.45633], [-122.10637, 37.45661], [-122.10494, 37.45838], [-122.10546, 37.4587], [-122.1055, 37.45818], [-122.10592, 37.45767], [-122.10678, 37.45759], [-122.10727, 37.457], [-122.10743, 37.45668], [-122.10806, 37.4566], [-122.10853, 37.45619], [-122.10906, 37.45529], [-122.10904, 37.45416], [-122.10883, 37.45339], [-122.10839, 37.45256], [-122.10764, 37.45168], [-122.10639, 37.45119], [-122.10575, 37.45124], [-122.10522, 37.45126], [-122.10521, 37.45158], [-122.10548, 37.45141], [-122.10699, 37.4515], [-122.10783, 37.45239], [-122.10745, 37.45215], [-122.10749, 37.45244], [-122.10764, 37.45269], [-122.10772, 37.45296], [-122.10755, 37.45305], [-122.10702, 37.45306], [-122.10701, 37.45308], [-122.10706, 37.45312], [-122.10693, 37.45311], [-122.10652, 37.45334], [-122.10653, 37.45361], [-122.10665, 37.4543], [-122.10687, 37.45471], [-122.10684, 37.45506], [-122.10633, 37.45524], [-122.10503, 37.45524], [-122.10483, 37.45521], [-122.10412, 37.4552], [-122.10391, 37.45536], [-122.1036, 37.45537], [-122.10316, 37.45548], [-122.10295, 37.4556], [-122.1024, 37.45547], [-122.10235, 37.45543], [-122.10225, 37.45545], [-122.10223, 37.45564], [-122.10214, 37.456], [-122.10156, 37.45642], [-122.10132, 37.45653], [-122.10114, 37.45629], [-122.10093, 37.45616], [-122.10067, 37.45634], [-122.10041, 37.45604], [-122.09929, 37.45514], [-122.0981, 37.45412], [-122.09636, 37.45391], [-122.09434, 37.4535], [-122.09258, 37.45305], [-122.09196, 37.45269], [-122.091, 37.45188], [-122.09012, 37.45011], [-122.09029, 37.44924], [-122.09122, 37.44893], [-122.09042, 37.44854], [-122.0905, 37.44753], [-122.09066, 37.44711], [-122.09103, 37.44667], [-122.09223, 37.4464], [-122.09357, 37.44607], [-122.09397, 37.44552], [-122.09425, 37.44469], [-122.09396, 37.44398], [-122.09305, 37.44337], [-122.09255, 37.4428], [-122.0925, 37.44239], [-122.09285, 37.44131], [-122.09333, 37.44089], [-122.09553, 37.44083], [-122.09715, 37.43923], [-122.09918, 37.43701], [-122.09965, 37.4364], [-122.09969, 37.436], [-122.0998, 37.43564], [-122.0998, 37.4355], [-122.10018, 37.43557], [-122.10019, 37.43556], [-122.10006, 37.4354], [-122.1001, 37.43531], [-122.10106, 37.43533], [-122.10258, 37.43481], [-122.10378, 37.43414], [-122.10433, 37.43342], [-122.10499, 37.43275], [-122.1057, 37.43256], [-122.10844, 37.4359], [-122.10958, 37.43713], [-122.11012, 37.43778], [-122.11126, 37.43851], [-122.11217, 37.43924], [-122.11304, 37.44003], [-122.11302, 37.44005], [-122.11359, 37.44054], [-122.11739, 37.44412], [-122.11749, 37.44449], [-122.11804, 37.44586], [-122.11777, 37.44584], [-122.11711, 37.44585], [-122.11748, 37.44685], [-122.11766, 37.44682], [-122.11759, 37.44731], [-122.11715, 37.44736], [-122.1175, 37.44882], [-122.11718, 37.44923], [-122.11654, 37.44865], [-122.11557, 37.44926], [-122.11545, 37.44916], [-122.11483, 37.44924], [-122.11448, 37.44933], [-122.11407, 37.4498], [-122.11383, 37.45016], [-122.11381, 37.45016], [-122.1138, 37.45022], [-122.10998, 37.45019], [-122.10969, 37.45038], [-122.10901, 37.45087], [-122.10828, 37.45134], [-122.10992, 37.45311], [-122.11009, 37.45376], [-122.1101, 37.45553], [-122.11017, 37.45576], [-122.11022, 37.45576], [-122.11214, 37.45712], [-122.11216, 37.45795], [-122.11225, 37.45803], [-122.11196, 37.45831], [-122.11299, 37.45945], [-122.11389, 37.46038], [-122.11464, 37.46157], [-122.11564, 37.46253], [-122.1163, 37.46273], [-122.11742, 37.46398], [-122.11792, 37.46396], [-122.11832, 37.46354], [-122.11764, 37.46218], [-122.11629, 37.46125], [-122.11517, 37.45988], [-122.11526, 37.45802], [-122.11581, 37.45719], [-122.11601, 37.45604], [-122.11685, 37.45317], [-122.11807, 37.45279], [-122.11917, 37.45274], [-122.12014, 37.45298], [-122.12098, 37.45357], [-122.12209, 37.45477], [-122.12256, 37.45551], [-122.123, 37.45633], [-122.12307, 37.45771], [-122.12408, 37.46084]]]} | Open Access 1 | 18298 | Baylands Preserve | 8356 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/gov/depts/csd/parks/preserves/baylands.asp | Santa Clara 19 | 1311.915 | Baylands Preserve | 1944 | Local Conservation Area 4 | 2 |
14022 | 14022 | 14021 | {"type": "Polygon", "coordinates": [[[-121.96133, 37.4083], [-121.96132, 37.40834], [-121.96127, 37.4084], [-121.961, 37.40863], [-121.96084, 37.4088], [-121.96041, 37.4094], [-121.9599, 37.40918], [-121.95662, 37.40804], [-121.95591, 37.40775], [-121.9554, 37.40749], [-121.95485, 37.40715], [-121.95433, 37.40676], [-121.95376, 37.40626], [-121.95343, 37.40591], [-121.95318, 37.4056], [-121.95296, 37.40528], [-121.95273, 37.40489], [-121.9525, 37.40458], [-121.95219, 37.40423], [-121.95183, 37.4039], [-121.95371, 37.4031], [-121.95399, 37.40346], [-121.95417, 37.40364], [-121.95436, 37.40379], [-121.95467, 37.404], [-121.95566, 37.40454], [-121.95582, 37.40464], [-121.95597, 37.40478], [-121.95617, 37.405], [-121.95649, 37.40543], [-121.95668, 37.40565], [-121.95757, 37.40687], [-121.95772, 37.40703], [-121.95789, 37.40717], [-121.95815, 37.40732], [-121.95945, 37.40794], [-121.95971, 37.40801], [-121.96001, 37.40806], [-121.96075, 37.40805], [-121.96095, 37.40806], [-121.96106, 37.4081], [-121.96124, 37.4082], [-121.9613, 37.40825], [-121.96133, 37.4083]]]} | Open Access 1 | 38013 | Ulistac Natural Area | 26648 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 42.464 | Ulistac Natural Area | 0 | Local Conservation Area 4 | 2 |
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]);