units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,454 rows where AGNCY_LEV = 3 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, GAP_STS
MNG_AGENCY >30
- Los Angeles, County of 155
- Santa Barbara, County of 117
- San Diego, County of 117
- Orange, County of 91
- Los Angeles - Department of Parks and Recreation, County of 60
- Lake, County of 56
- Sacramento, County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Sonoma County Regional Parks Dept., County of 49
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 42
- Santa Clara County Parks and Recreation Dept., County of 41
- Riverside, County of 38
- Marin County Parks Department, County of 33
- San Luis Obispo, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 24
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- Yolo, County of 18
- Fresno, County of 17
- San Bernardino, County of 17
- Merced, County of 16
- Tulare, County of 15
- San Francisco - Public Utilities Commission, City and County of 14
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 11
- …
DES_TP >30
- Local Park 798
- Local Other or Unknown 221
- Local Recreation Area 146
- Local Conservation Area 114
- Local Historic or Cultural Area 21
- Local Resource Management Area 8
- National Forest 2
- National Monument or Landmark 2
- None 1
- State Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 13
ACCESS_TYP 4
- Open Access 1,290
- Restricted Access 78
- No Public Access 49
- Unknown Access 37
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16430 | 16430 | 16429 | {"type": "MultiPolygon", "coordinates": [[[[-117.09275, 32.55093], [-117.08419, 32.55089], [-117.08418, 32.54718], [-117.0885, 32.54724], [-117.08851, 32.54815], [-117.09275, 32.54817], [-117.09274, 32.54879], [-117.09275, 32.55093]]], [[[-117.10589, 32.55459], [-117.10142, 32.55462], [-117.0993, 32.55461], [-117.09923, 32.55817], [-117.09713, 32.55816], [-117.09714, 32.55461], [-117.09632, 32.5546], [-117.09634, 32.55816], [-117.09383, 32.55815], [-117.09383, 32.55778], [-117.09285, 32.55777], [-117.09287, 32.54879], [-117.09289, 32.5476], [-117.09288, 32.54732], [-117.1016, 32.54732], [-117.10155, 32.54367], [-117.10156, 32.53999], [-117.10318, 32.53998], [-117.10318, 32.54033], [-117.10459, 32.54111], [-117.1046, 32.54365], [-117.10584, 32.54365], [-117.10585, 32.54377], [-117.10576, 32.54378], [-117.10576, 32.54731], [-117.10584, 32.54732], [-117.10583, 32.55098], [-117.10589, 32.55459]]], [[[-117.11232, 32.54729], [-117.11231, 32.55095], [-117.11011, 32.55096], [-117.11016, 32.54731], [-117.11232, 32.54729]]]]} | Open Access 1 | 45291 | Tijuana River Valley Regional Park | 26362 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 451.08 | Tijuana River Valley RP | None 1401 | ||
15741 | 15741 | 15740 | {"type": "Polygon", "coordinates": [[[-117.67117, 33.83107], [-117.66201, 33.83106], [-117.66204, 33.81651], [-117.67006, 33.81655], [-117.67117, 33.83107]]]} | Open Access 1 | 17813 | Cleveland National Forest, Exp 1 | 8049 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 316.667 | Cleveland NF, Exp 1 | None 1368 | |||
15086 | 15086 | 15085 | {"type": "Polygon", "coordinates": [[[-118.59334, 34.29692], [-118.59288, 34.29636], [-118.59275, 34.29613], [-118.59187, 34.29638], [-118.5913, 34.29686], [-118.59115, 34.29672], [-118.5903, 34.29651], [-118.58963, 34.29617], [-118.59055, 34.2929], [-118.59249, 34.29293], [-118.59294, 34.2935], [-118.593, 34.29362], [-118.59302, 34.29375], [-118.59298, 34.29408], [-118.59299, 34.29418], [-118.5931, 34.29447], [-118.59311, 34.29458], [-118.5931, 34.29469], [-118.59291, 34.29525], [-118.59332, 34.29526], [-118.59334, 34.29692]]]} | Unknown Access 4 | 45869 | Browns Canyon | 28917 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 27.196 | Browns Canyon | None 1309 | |||
15084 | 15084 | 15083 | {"type": "Polygon", "coordinates": [[[-118.25293, 33.92759], [-118.25261, 33.92765], [-118.25157, 33.92387], [-118.2519, 33.92387], [-118.25293, 33.92759]]]} | Open Access 1 | 45866 | Compton Creek Walking Path Phase I | 28915 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.181 | Compton Creek Walking Path Phase I | None 1308 | |||
15081 | 15081 | 15080 | {"type": "MultiPolygon", "coordinates": [[[[-118.18119, 34.01648], [-118.18066, 34.01648], [-118.18065, 34.01554], [-118.18118, 34.01554], [-118.18119, 34.01648]]], [[[-118.1819, 34.01593], [-118.18139, 34.01594], [-118.18139, 34.01566], [-118.1819, 34.01566], [-118.1819, 34.01593]]]]} | Open Access 1 | 45861 | Parque de los Suenos | 28908 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Parque_de_los_Suenos | Los Angeles 6 | 1.61 | Parque de los Suenos | None 1307 | ||
15074 | 15074 | 15073 | {"type": "Polygon", "coordinates": [[[-118.11482, 34.19575], [-118.11463, 34.19638], [-118.11441, 34.19634], [-118.11429, 34.1954], [-118.11451, 34.19531], [-118.11449, 34.19545], [-118.11455, 34.19559], [-118.11466, 34.19569], [-118.11471, 34.19569], [-118.11482, 34.19575]]]} | No Public Access 3 | 45853 | Casa Del Caballero | 28900 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.819 | Casa Del Caballero | None 1306 | |||
15041 | 15041 | 15040 | {"type": "Polygon", "coordinates": [[[-117.79158, 34.70472], [-117.79153, 34.70476], [-117.77431, 34.7053], [-117.77425, 34.70526], [-117.77425, 34.69802], [-117.78289, 34.69778], [-117.78289, 34.69592], [-117.7873, 34.6958], [-117.78731, 34.69468], [-117.78841, 34.69465], [-117.78842, 34.69539], [-117.78952, 34.69536], [-117.78952, 34.69759], [-117.79156, 34.69753], [-117.79158, 34.70472]]]} | Open Access 1 | 45703 | Butte Valley Wildflower Sanctuary | 32690 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/butte-valley-wildflower-sanctuary/ | Los Angeles 6 | 350.624 | Butte Valley Wildflower Sanctuary | None 1300 | ||
14937 | 14937 | 14936 | {"type": "Polygon", "coordinates": [[[-118.24398, 33.98243], [-118.24382, 33.9825], [-118.24369, 33.98261], [-118.24358, 33.98273], [-118.24352, 33.98286], [-118.24352, 33.98212], [-118.24397, 33.98212], [-118.24398, 33.98243]]]} | Open Access 1 | 45533 | El Parque Nuestro | 28364 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/El_Parque_Nuestro | Los Angeles 6 | 0.536 | El Parque Nuestro | None 1288 | ||
14690 | 14690 | 14689 | {"type": "MultiPolygon", "coordinates": [[[[-118.07693, 33.72934], [-118.0768, 33.72967], [-118.07605, 33.7304], [-118.06997, 33.73039], [-118.071, 33.72955], [-118.07185, 33.72959], [-118.07242, 33.72965], [-118.07248, 33.72963], [-118.07273, 33.72967], [-118.07272, 33.72961], [-118.07273, 33.72957], [-118.07283, 33.72939], [-118.07291, 33.7293], [-118.07302, 33.72921], [-118.07321, 33.72907], [-118.07344, 33.72896], [-118.07363, 33.72888], [-118.07386, 33.72881], [-118.0741, 33.72877], [-118.07429, 33.729], [-118.07423, 33.72927], [-118.07389, 33.72947], [-118.07379, 33.7298], [-118.07483, 33.72994], [-118.07603, 33.72987], [-118.07624, 33.7297], [-118.07617, 33.7294], [-118.07616, 33.72921], [-118.0763, 33.72904], [-118.07693, 33.72934]]], [[[-118.08125, 33.72954], [-118.08108, 33.72965], [-118.08084, 33.72973], [-118.08082, 33.72994], [-118.08091, 33.73], [-118.08074, 33.73008], [-118.08067, 33.7302], [-118.08049, 33.73035], [-118.08026, 33.73039], [-118.07999, 33.73038], [-118.07968, 33.7304], [-118.07691, 33.7304], [-118.07732, 33.73003], [-118.07773, 33.72887], [-118.0786, 33.72857], [-118.07912, 33.72844], [-118.08014, 33.72894], [-118.08047, 33.7293], [-118.08064, 33.72946], [-118.08073, 33.72938], [-118.08114, 33.72944], [-118.08125, 33.72954]]]]} | Open Access 1 | 45012 | Sunset Harbor | 26046 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 27.07 | Sunset Harbor | None 1259 | |||
14677 | 14677 | 14676 | {"type": "MultiPolygon", "coordinates": [[[[-122.49119, 37.8781], [-122.48776, 37.88368], [-122.48737, 37.88444], [-122.48336, 37.88288], [-122.48238, 37.8846], [-122.48632, 37.88604], [-122.4838, 37.89047], [-122.48247, 37.88939], [-122.48215, 37.88917], [-122.48181, 37.88898], [-122.48152, 37.88884], [-122.47989, 37.88823], [-122.47913, 37.88787], [-122.48029, 37.8859], [-122.48068, 37.88606], [-122.4814, 37.88629], [-122.48237, 37.8846], [-122.48122, 37.88414], [-122.48609, 37.87599], [-122.48677, 37.87623], [-122.49119, 37.8781]]], [[[-122.48654, 37.88697], [-122.49182, 37.87837], [-122.49434, 37.87888], [-122.49609, 37.88349], [-122.4939, 37.88719], [-122.49252, 37.88934], [-122.48979, 37.89388], [-122.48955, 37.89379], [-122.4886, 37.89402], [-122.48778, 37.89409], [-122.48771, 37.89414], [-122.4843, 37.8909], [-122.48654, 37.88697]]]]} | Restricted Access 2 | 44955 | Richardson Bay Audubon Center & Sanctuary | 24330 | 353 | Marin, County of 1034 | County 3 | County Agency 3 | http://www.marincounty.org/recreation/parks-in-marin | County 3 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 382.054 | Richardson Bay Audubon Ctr. & Sanctuary | 0 | None 1253 | ||
14635 | 14635 | 14634 | {"type": "Polygon", "coordinates": [[[-117.10501, 33.01145], [-117.10485, 33.01158], [-117.10476, 33.01169], [-117.10473, 33.01183], [-117.10471, 33.01203], [-117.10476, 33.01243], [-117.10474, 33.01289], [-117.1046, 33.01309], [-117.1044, 33.01313], [-117.10431, 33.01325], [-117.1041, 33.01314], [-117.10388, 33.01304], [-117.10297, 33.01276], [-117.10268, 33.01265], [-117.10215, 33.01241], [-117.10125, 33.01195], [-117.09931, 33.01118], [-117.09888, 33.011], [-117.09844, 33.0108], [-117.09802, 33.01057], [-117.09748, 33.01024], [-117.09709, 33.00997], [-117.09672, 33.00969], [-117.0966, 33.00959], [-117.09698, 33.00811], [-117.1048, 33.00837], [-117.10477, 33.00869], [-117.10481, 33.00874], [-117.10454, 33.00943], [-117.10481, 33.00975], [-117.10482, 33.01], [-117.10492, 33.01018], [-117.10484, 33.01029], [-117.1048, 33.01076], [-117.1047, 33.01099], [-117.10468, 33.01115], [-117.10469, 33.01122], [-117.10471, 33.01127], [-117.10475, 33.01131], [-117.105, 33.01142], [-117.10501, 33.01145]], [[-117.10204, 33.01004], [-117.10213, 33.01005], [-117.10226, 33.01004], [-117.10237, 33.01001], [-117.10247, 33.00996], [-117.10255, 33.00989], [-117.10262, 33.0098], [-117.10265, 33.0097], [-117.10266, 33.0096], [-117.10261, 33.00944], [-117.10255, 33.00937], [-117.10247, 33.0093], [-117.10235, 33.00924], [-117.10222, 33.00922], [-117.10207, 33.00922], [-117.10198, 33.00925], [-117.10193, 33.00914], [-117.10174, 33.00924], [-117.10161, 33.00939], [-117.10154, 33.00955], [-117.10153, 33.0098], [-117.10156, 33.00992], [-117.10162, 33.01005], [-117.10168, 33.01013], [-117.10183, 33.01027], [-117.10191, 33.01037], [-117.10192, 33.01036], [-117.10204, 33.01004]]]} | Open Access 1 | 44867 | Christopher Hill Holding | 29230 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 69.353 | Christopher Hill Holding | None 1248 | |||
14544 | 14544 | 14543 | {"type": "Polygon", "coordinates": [[[-117.97916, 33.9094], [-117.97859, 33.91001], [-117.97804, 33.91048], [-117.9775, 33.91087], [-117.97658, 33.91143], [-117.97658, 33.91103], [-117.97694, 33.91084], [-117.97741, 33.91054], [-117.97784, 33.91022], [-117.97802, 33.91008], [-117.97805, 33.91001], [-117.97841, 33.90968], [-117.9788, 33.90926], [-117.97904, 33.90937], [-117.97916, 33.9094]]]} | Open Access 1 | 48309 | Coyote Creek Bikeway | 32861 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.lhcm.org/386/Bikeways | Los Angeles 6 | 2.63 | Coyote Creek Bikeway | 2011 | None 1239 | |
14531 | 14531 | 14530 | {"type": "Polygon", "coordinates": [[[-122.52652, 37.87708], [-122.52628, 37.87758], [-122.52614, 37.87781], [-122.52606, 37.87788], [-122.52594, 37.87794], [-122.52584, 37.87793], [-122.52544, 37.87771], [-122.525, 37.87763], [-122.52478, 37.87769], [-122.5243, 37.87785], [-122.52414, 37.87787], [-122.52404, 37.87789], [-122.52378, 37.87805], [-122.52371, 37.87811], [-122.52362, 37.87824], [-122.52358, 37.87837], [-122.5236, 37.87853], [-122.5236, 37.87872], [-122.52357, 37.87889], [-122.5235, 37.87909], [-122.52339, 37.87925], [-122.52324, 37.87942], [-122.52355, 37.87957], [-122.52351, 37.87964], [-122.52329, 37.87952], [-122.52317, 37.87948], [-122.52315, 37.87958], [-122.52307, 37.87969], [-122.52284, 37.87971], [-122.52206, 37.88056], [-122.52193, 37.88066], [-122.5211, 37.88119], [-122.52, 37.88186], [-122.5199, 37.88191], [-122.51964, 37.88199], [-122.51908, 37.88231], [-122.51901, 37.88266], [-122.51887, 37.88256], [-122.51894, 37.88244], [-122.51895, 37.88233], [-122.51917, 37.88215], [-122.5212, 37.88106], [-122.52189, 37.88062], [-122.522, 37.88052], [-122.5228, 37.87966], [-122.52288, 37.87964], [-122.52302, 37.87964], [-122.52308, 37.87957], [-122.52307, 37.87954], [-122.52285, 37.87949], [-122.52289, 37.87943], [-122.52317, 37.87926], [-122.52336, 37.87909], [-122.52349, 37.87876], [-122.52351, 37.87863], [-122.52349, 37.87846], [-122.52338, 37.87825], [-122.52343, 37.87815], [-122.52349, 37.87808], [-122.52352, 37.87808], [-122.52379, 37.87783], [-122.52394, 37.87774], [-122.52433, 37.87777], [-122.52458, 37.87772], [-122.52487, 37.87761], [-122.52494, 37.8776], [-122.52546, 37.87767], [-122.52584, 37.87761], [-122.5261, 37.87748], [-122.52634, 37.87725], [-122.52647, 37.87704], [-122.52652, 37.87708]]]} | Open Access 1 | 47198 | Charles F. McGlashan Pathway | 30897 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.726 | Charles F. McGlashan Pathway | None 1237 | |||
14465 | 14465 | 14464 | {"type": "Polygon", "coordinates": [[[-121.1883, 38.72061], [-121.18821, 38.72077], [-121.18793, 38.72141], [-121.18783, 38.72158], [-121.18709, 38.72158], [-121.18709, 38.72083], [-121.1883, 38.72061]]]} | Open Access 1 | 47083 | Baldwin Reservoir Trailhead | 30737 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks/parks-content/trails/baldwin-reservoir-trail | Placer 35 | 1.941 | Baldwin Reservoir Trailhead | None 1232 | ||
14423 | 14423 | 14422 | {"type": "Polygon", "coordinates": [[[-118.89503, 35.43798], [-118.8932, 35.43744], [-118.8921, 35.43698], [-118.89108, 35.43666], [-118.88971, 35.43648], [-118.88774, 35.43601], [-118.88634, 35.43587], [-118.8853, 35.43568], [-118.88447, 35.43566], [-118.88384, 35.43552], [-118.88345, 35.43532], [-118.88285, 35.43512], [-118.8823, 35.43512], [-118.88181, 35.43521], [-118.88064, 35.43561], [-118.87884, 35.43595], [-118.87878, 35.43599], [-118.87872, 35.436], [-118.87859, 35.4361], [-118.87849, 35.43613], [-118.87832, 35.43627], [-118.87806, 35.4364], [-118.87778, 35.43659], [-118.87743, 35.43674], [-118.87721, 35.43681], [-118.87713, 35.4368], [-118.87708, 35.43682], [-118.87701, 35.43694], [-118.8769, 35.43695], [-118.87683, 35.437], [-118.8768, 35.43705], [-118.87664, 35.43711], [-118.87656, 35.43717], [-118.87648, 35.43722], [-118.87638, 35.43724], [-118.87625, 35.43734], [-118.87623, 35.43739], [-118.87605, 35.43746], [-118.87595, 35.43756], [-118.87576, 35.43766], [-118.87559, 35.43768], [-118.87553, 35.43767], [-118.87541, 35.43771], [-118.87532, 35.43785], [-118.87517, 35.43791], [-118.87508, 35.43799], [-118.87493, 35.43804], [-118.87444, 35.4383], [-118.87429, 35.43835], [-118.87399, 35.43851], [-118.87393, 35.43852], [-118.87375, 35.43861], [-118.87368, 35.43867], [-118.87354, 35.43872], [-118.87335, 35.43885], [-118.87325, 35.43889], [-118.87313, 35.439], [-118.87291, 35.43912], [-118.87277, 35.43913], [-118.87248, 35.43931], [-118.87229, 35.43937], [-118.87152, 35.43985], [-118.87145, 35.43988], [-118.87128, 35.44002], [-118.87106, 35.4401], [-118.87095, 35.44019], [-118.87085, 35.44021], [-118.87072, 35.44029], [-118.87053, 35.44045], [-118.87019, 35.44063], [-118.86968, 35.44099], [-118.86945, 35.44112], [-118.86932, 35.44123], [-118.86906, 35.44134], [-118.86895, 35.44143], [-118.86885, 35.44145], [-118.86875, 35.44151], [-118.8677, 35.44167], [-118.86747, 35.4419], [-118.86394, 35.44271], [-118.86275, 35.44311], [-118.86178, 35.44324], [-118.86038, 35.44326], [-118.8596, 35.44317], [-118.85867, 35.44332], [-118.8579, 35.44322], [-118.85729, 35.4433], [-118.8594, 35.44002], [-118.85983, 35.4394], [-118.86002, 35.43896], [-118.86016, 35.4381], [-118.86048, 35.43724], [-118.86031, 35.43629], [-118.86022, 35.43526], [-118.85964, 35.43288], [-118.86038, 35.43265], [-118.86056, 35.43256], [-118.86067, 35.43249], [-118.8608, 35.43236], [-118.86089, 35.43221], [-118.86095, 35.43204], [-118.86099, 35.43182], [-118.86108, 35.432], [-118.86119, 35.43216], [-118.86133, 35.43231], [-118.8614, 35.43232], [-118.8614, 35.43253], [-118.86408, 35.43304], [-118.86534, 35.43316], [-118.86558, 35.43321], [-118.86576, 35.43326], [-118.86597, 35.43336], [-118.86725, 35.43416], [-118.8674, 35.43424], [-118.86756, 35.43429], [-118.86785, 35.43433], [-118.86986, 35.43433], [-118.87018, 35.43437], [-118.87037, 35.43443], [-118.87054, 35.43452], [-118.87154, 35.4353], [-118.87178, 35.43542], [-118.87199, 35.43542], [-118.87434, 35.43556], [-118.87453, 35.43553], [-118.8747, 35.43547], [-118.87484, 35.43537], [-118.87493, 35.43526], [-118.87499, 35.43512], [-118.87518, 35.43422], [-118.87523, 35.43411], [-118.87532, 35.43399], [-118.87706, 35.43257], [-118.87726, 35.43245], [-118.87745, 35.43238], [-118.87884, 35.43214], [-118.88119, 35.43152], [-118.88136, 35.43149], [-118.88157, 35.43149], [-118.88183, 35.43153], [-118.88199, 35.43159], [-118.88242, 35.43183], [-118.88258, 35.4319], [-118.8828, 35.43195], [-118.88302, 35.43196], [-118.88371, 35.43187], [-118.88569, 35.43167], [-118.88774, 35.43136], [-118.88827, 35.43089], [-118.88977, 35.43097], [-118.8905, 35.43106], [-118.89101, 35.43118], [-118.8915, 35.43133], [-118.89386, 35.43222], [-118.89387, 35.43251], [-118.89375, 35.4332], [-118.89361, 35.4339], [-118.89361, 35.43438], [-118.89384, 35.43522], [-118.8939, 35.43612], [-118.89446, 35.43696], [-118.89497, 35.4379], [-118.89503, 35.43798]]]} | Open Access 1 | 44539 | Lake Ming | 20954 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ming.asp | Kern 36 | 496.587 | Lake Ming | None 1227 | ||
14360 | 14360 | 14359 | {"type": "Polygon", "coordinates": [[[-118.15988, 34.03624], [-118.15906, 34.03626], [-118.15743, 34.03622], [-118.15728, 34.03626], [-118.15722, 34.03383], [-118.15715, 34.03383], [-118.15715, 34.03355], [-118.15977, 34.03352], [-118.15977, 34.03385], [-118.15987, 34.03386], [-118.15988, 34.03624]]]} | Open Access 1 | 44425 | Belvedere Park Lake | 16000 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 17.954 | Belvedere Park Lake | None 1215 | |||
14034 | 14034 | 14033 | {"type": "Polygon", "coordinates": [[[-121.69411, 37.07267], [-121.68238, 37.08191], [-121.6822, 37.08137], [-121.68045, 37.08172], [-121.68, 37.08104], [-121.6793, 37.08081], [-121.67872, 37.08093], [-121.6786, 37.08055], [-121.67826, 37.08012], [-121.67817, 37.07986], [-121.67894, 37.0799], [-121.6789, 37.07971], [-121.67915, 37.07951], [-121.67954, 37.07942], [-121.67967, 37.07905], [-121.67962, 37.07891], [-121.67914, 37.0788], [-121.67899, 37.07882], [-121.67879, 37.07893], [-121.67878, 37.07877], [-121.6803, 37.07818], [-121.6803, 37.07816], [-121.67944, 37.07798], [-121.67945, 37.07768], [-121.67982, 37.07744], [-121.68089, 37.0773], [-121.68045, 37.07591], [-121.6819, 37.07239], [-121.68248, 37.07238], [-121.68265, 37.07221], [-121.6828, 37.07178], [-121.68173, 37.07179], [-121.68155, 37.07221], [-121.68139, 37.0724], [-121.6799, 37.07242], [-121.67587, 37.06768], [-121.67961, 37.06434], [-121.67993, 37.06465], [-121.68032, 37.06479], [-121.68214, 37.0653], [-121.68384, 37.0655], [-121.68497, 37.06567], [-121.68562, 37.06584], [-121.68626, 37.06586], [-121.68595, 37.07096], [-121.69299, 37.07094], [-121.69411, 37.07267]]]} | No Public Access 3 | 38032 | Seven Oaks Hill | 25326 | 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 | Santa Clara 19 | 359.083 | Seven Oaks Hill | None 1200 | |||
13276 | 13276 | 13275 | {"type": "Polygon", "coordinates": [[[-120.63883, 34.95912], [-120.63659, 34.95879], [-120.63662, 34.9577], [-120.6378, 34.9583], [-120.63834, 34.95875], [-120.63883, 34.95912]]]} | Open Access 1 | 45324 | Rancho Guadalupe Dunes | 24146 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.499 | Rancho Guadalupe Dunes | None 1151 | |||
13184 | 13184 | 13183 | {"type": "Polygon", "coordinates": [[[-121.63003, 37.09382], [-121.62959, 37.09476], [-121.62429, 37.09699], [-121.62074, 37.09602], [-121.61842, 37.09695], [-121.61794, 37.09662], [-121.61745, 37.0962], [-121.61705, 37.09581], [-121.61665, 37.09534], [-121.61682, 37.09538], [-121.61766, 37.09533], [-121.61827, 37.09536], [-121.61953, 37.09527], [-121.6201, 37.09509], [-121.62004, 37.09495], [-121.62148, 37.09416], [-121.6231, 37.09378], [-121.6234, 37.09367], [-121.62425, 37.09432], [-121.62484, 37.09445], [-121.62657, 37.09444], [-121.62737, 37.09439], [-121.62902, 37.09414], [-121.62919, 37.09402], [-121.62931, 37.09387], [-121.62935, 37.09385], [-121.62971, 37.09387], [-121.63003, 37.09382]]]} | Open Access 1 | 35167 | Silveira | 25482 | 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 | Santa Clara 19 | 53.381 | Silveira | None 1149 | |||
13163 | 13163 | 13162 | {"type": "Polygon", "coordinates": [[[-122.00274, 37.90517], [-122.00231, 37.90516], [-122.00213, 37.90513], [-122.00195, 37.90508], [-122.0017, 37.90499], [-121.99863, 37.90492], [-121.9986, 37.90475], [-121.99682, 37.90477], [-121.99628, 37.90372], [-121.994, 37.90374], [-121.99403, 37.90335], [-121.99401, 37.90309], [-121.99395, 37.90283], [-121.99387, 37.90259], [-121.99375, 37.90235], [-121.9936, 37.90213], [-121.99346, 37.90195], [-121.99811, 37.90237], [-121.99812, 37.90236], [-121.99811, 37.90229], [-122.00015, 37.90249], [-122.0002, 37.90249], [-122.0002, 37.90255], [-122.00096, 37.90262], [-122.00103, 37.90334], [-122.00094, 37.90336], [-122.00101, 37.90354], [-122.00107, 37.90407], [-122.00116, 37.90431], [-122.00123, 37.90442], [-122.00141, 37.90462], [-122.00151, 37.90471], [-122.00176, 37.90486], [-122.0019, 37.90492], [-122.00219, 37.905], [-122.00235, 37.90503], [-122.00268, 37.90503], [-122.00274, 37.90517]]]} | No Public Access 3 | 35113 | Mount Diablo Gateway | 28139 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 38.137 | Mount Diablo Gateway | None 1142 |
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]);