units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,263 rows where AGNCY_TYP = 3 sorted by MNG_AG_LEV descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, YR_EST, 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
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 42
- Riverside, County of 38
- San Luis Obispo, County of 31
- Placer, County of 28
- 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
- Humboldt, County of 12
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- …
DES_TP >30
- Local Park 687
- Local Other or Unknown 214
- Local Recreation Area 126
- Local Conservation Area 98
- Local Historic or Cultural Area 21
- National Forest 2
- National Monument or Landmark 2
- None 1
- State Conservation Area 1
- None 1
- National Recreation Area 1
- None 1
- Local Resource Management 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
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 1,135
- Restricted Access 63
- Unknown Access 36
- No Public Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
4152 | 4152 | 4151 | {"type": "Polygon", "coordinates": [[[-117.97658, 33.91104], [-117.97658, 33.91143], [-117.97591, 33.91182], [-117.97546, 33.91214], [-117.96943, 33.91722], [-117.96887, 33.91721], [-117.97303, 33.91372], [-117.97303, 33.9137], [-117.97384, 33.91309], [-117.9751, 33.91199], [-117.97561, 33.91162], [-117.97658, 33.91104]]]} | Open Access 1 | 48288 | 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 | Orange 3 | 8.381 | Coyote Creek Bikeway | 2011 | None 358 | |
10083 | 10083 | 10082 | {"type": "MultiPolygon", "coordinates": [[[[-117.27291, 33.00739], [-117.26287, 33.00739], [-117.26203, 33.00689], [-117.26063, 33.00632], [-117.26066, 33.00626], [-117.26003, 33.00589], [-117.25972, 33.00557], [-117.25947, 33.00491], [-117.25957, 33.00483], [-117.25923, 33.00381], [-117.2588, 33.00344], [-117.25859, 33.00253], [-117.2588, 33.00172], [-117.25872, 33.00139], [-117.25829, 33.0005], [-117.25825, 33.0003], [-117.25846, 33.0003], [-117.2604, 33.00252], [-117.26197, 33.00312], [-117.26213, 33.00334], [-117.26214, 33.00387], [-117.26433, 33.00388], [-117.26433, 33.00262], [-117.26471, 33.00262], [-117.26472, 33.00248], [-117.26513, 33.00249], [-117.26513, 33.00208], [-117.26657, 33.00209], [-117.26659, 33.00211], [-117.2669, 33.00284], [-117.26699, 33.00292], [-117.26713, 33.00294], [-117.26724, 33.00291], [-117.2673, 33.00286], [-117.2678, 33.00198], [-117.26806, 33.00198], [-117.26818, 33.00279], [-117.26812, 33.00299], [-117.26835, 33.00318], [-117.26842, 33.0035], [-117.2686, 33.00363], [-117.26861, 33.00391], [-117.27039, 33.00393], [-117.2704, 33.00381], [-117.27061, 33.00383], [-117.27072, 33.00382], [-117.27089, 33.00376], [-117.27131, 33.00356], [-117.27158, 33.00354], [-117.27197, 33.00355], [-117.2721, 33.00359], [-117.27221, 33.0036], [-117.27223, 33.00361], [-117.2724, 33.00364], [-117.27248, 33.0037], [-117.27258, 33.0037], [-117.27269, 33.00406], [-117.27274, 33.00414], [-117.27287, 33.00423], [-117.27291, 33.00739]], [[-117.26716, 33.00301], [-117.26673, 33.00297], [-117.26688, 33.0036], [-117.26733, 33.00348], [-117.26726, 33.00297], [-117.26716, 33.00301]]], [[[-117.25116, 33.00742], [-117.25114, 33.00903], [-117.25115, 33.01098], [-117.24055, 33.01098], [-117.23939, 33.00941], [-117.2428, 33.00937], [-117.2428, 33.0092], [-117.24294, 33.00923], [-117.24295, 33.00922], [-117.24295, 33.00892], [-117.2428, 33.00883], [-117.24281, 33.00747], [-117.24445, 33.00745], [-117.24444, 33.00563], [-117.24552, 33.00564], [-117.24553, 33.00744], [-117.25116, 33.00742]]], [[[-117.27505, 33.0139], [-117.275, 33.01393], [-117.27475, 33.01377], [-117.27434, 33.01359], [-117.27395, 33.01348], [-117.27374, 33.01345], [-117.27352, 33.01343], [-117.27351, 33.01315], [-117.27319, 33.01314], [-117.27309, 33.01322], [-117.27307, 33.01326], [-117.27304, 33.01336], [-117.27305, 33.01344], [-117.27284, 33.01347], [-117.27256, 33.01347], [-117.27231, 33.01344], [-117.272, 33.01337], [-117.27171, 33.01326], [-117.27134, 33.01306], [-117.27104, 33.01279], [-117.27096, 33.01269], [-117.27083, 33.01249], [-117.27404, 33.01107], [-117.27469, 33.01223], [-117.27472, 33.01331], [-117.27505, 33.0139]]], [[[-117.25907, 33.01465], [-117.25889, 33.01488], [-117.25873, 33.01505], [-117.25836, 33.01536], [-117.25815, 33.0155], [-117.25784, 33.01568], [-117.25757, 33.0158], [-117.25711, 33.01597], [-117.25673, 33.01617], [-117.25651, 33.01633], [-117.25568, 33.01708], [-117.25569, 33.01468], [-117.25907, 33.01465]]], [[[-117.24895, 33.02066], [-117.24723, 33.0218], [-117.24698, 33.0218], [-117.24696, 33.02001], [-117.24894, 33.02002], [-117.24895, 33.02066]]]]} | Restricted Access 2 | 1714 | San Elijo Lagoon Ecological Reserve | 24877 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Elijo-Lagoon-ER | San Diego 4 | 268.615 | San Elijo Lagoon ER | 1983 | State Conservation Area 8 | 2 |
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 | |
3771 | 3771 | 3770 | {"type": "Polygon", "coordinates": [[[-117.40597, 34.07031], [-117.40479, 34.07031], [-117.40478, 34.06832], [-117.40534, 34.06832], [-117.40596, 34.06828], [-117.40597, 34.07031]]]} | Open Access 1 | 475 | Ayala Park | 15735 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | San Bernardino 22 | 6.002 | Ayala Park | 0 | Local Park 2 | 4 | |
6528 | 6528 | 6527 | {"type": "Polygon", "coordinates": [[[-117.40315, 34.04849], [-117.40143, 34.0485], [-117.40143, 34.04844], [-117.40084, 34.04844], [-117.40084, 34.04673], [-117.40086, 34.0467], [-117.4009, 34.04669], [-117.40132, 34.04669], [-117.40133, 34.04661], [-117.40143, 34.04659], [-117.40143, 34.04463], [-117.40146, 34.04463], [-117.40146, 34.04667], [-117.40226, 34.04668], [-117.40227, 34.04671], [-117.40315, 34.04671], [-117.40315, 34.04849]]]} | Open Access 1 | 2856 | Kessler Park | 20635 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | San Bernardino 22 | 10.676 | Kessler Park | 0 | Local Park 2 | 4 | |
6899 | 6899 | 6898 | {"type": "Polygon", "coordinates": [[[-116.93928, 34.44363], [-116.93788, 34.44365], [-116.93784, 34.44316], [-116.9372, 34.44312], [-116.93715, 34.44215], [-116.93925, 34.4421], [-116.93928, 34.44363]]]} | Open Access 1 | 5757 | Pioneer Park | 23739 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 2320 | Yuima Municipal Water District 675 | Special District 4 | Water District 13 | San Bernardino 22 | 7.116 | Pioneer Park | 0 | Local Park 2 | 4 | |
9975 | 9975 | 9974 | {"type": "Polygon", "coordinates": [[[-122.11034, 37.25814], [-122.1099, 37.25831], [-122.10963, 37.25848], [-122.10956, 37.25855], [-122.10952, 37.25863], [-122.10951, 37.25873], [-122.10953, 37.25882], [-122.10846, 37.25883], [-122.10844, 37.25755], [-122.11032, 37.25756], [-122.11034, 37.25814]]]} | No Public Access 3 | 47967 | Saratoga Gap Open Space Preserve | 31468 | 373 | Santa Clara, County of 941 | County 3 | County Agency 3 | http://www.sccgov.org/sites/scc/Pages/default.aspx | County 3 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 4.827 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
11759 | 11759 | 11758 | {"type": "Polygon", "coordinates": [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]} | Open Access 1 | 24052 | Betschart Park | 16049 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.634 | Betschart Park | 0 | Local Park 2 | 4 | |
13119 | 13119 | 13118 | {"type": "Polygon", "coordinates": [[[-117.03429, 34.05023], [-117.03428, 34.05205], [-117.02584, 34.05208], [-117.02582, 34.0496], [-117.0264, 34.04972], [-117.02709, 34.04997], [-117.0277, 34.04982], [-117.02836, 34.04976], [-117.02879, 34.04956], [-117.02917, 34.04944], [-117.02963, 34.04933], [-117.03007, 34.04927], [-117.03008, 34.04906], [-117.03226, 34.04903], [-117.03227, 34.05024], [-117.03429, 34.05023]]]} | No Public Access 3 | 35036 | Bryant St Detention Basin | 16460 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | San Bernardino 22 | 51.946 | Bryant St Detention Basin | 0 | None 1138 | ||
14089 | 14089 | 14088 | {"type": "Polygon", "coordinates": [[[-117.13888, 33.74651], [-117.13887, 33.7486], [-117.1367, 33.74859], [-117.13669, 33.74665], [-117.13673, 33.74659], [-117.13697, 33.74659], [-117.13726, 33.74664], [-117.13732, 33.74663], [-117.13738, 33.74659], [-117.13741, 33.7465], [-117.13888, 33.74651]]]} | Open Access 1 | 39121 | Marion V. Ashley Community Center | 21864 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 11.364 | Marion V. Ashley Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
14251 | 14251 | 14250 | {"type": "Polygon", "coordinates": [[[-121.42746, 38.41856], [-121.42711, 38.41877], [-121.42686, 38.41896], [-121.42672, 38.41887], [-121.42648, 38.41876], [-121.42649, 38.41867], [-121.4262, 38.41859], [-121.42594, 38.41855], [-121.42562, 38.41854], [-121.42533, 38.41857], [-121.42511, 38.41862], [-121.4248, 38.41873], [-121.42474, 38.41873], [-121.4247, 38.41871], [-121.42453, 38.41851], [-121.42447, 38.41837], [-121.42479, 38.41839], [-121.42512, 38.41828], [-121.42529, 38.41827], [-121.42576, 38.41831], [-121.42592, 38.41809], [-121.42598, 38.41807], [-121.42603, 38.41803], [-121.42605, 38.41798], [-121.42602, 38.41792], [-121.42644, 38.41746], [-121.42644, 38.41728], [-121.42651, 38.4173], [-121.42661, 38.41729], [-121.42667, 38.41726], [-121.42671, 38.41721], [-121.42671, 38.41714], [-121.42668, 38.41706], [-121.42668, 38.4167], [-121.42671, 38.41658], [-121.42669, 38.41652], [-121.42663, 38.41647], [-121.42668, 38.41641], [-121.42668, 38.41619], [-121.4271, 38.41619], [-121.42711, 38.41661], [-121.42724, 38.41698], [-121.42714, 38.41703], [-121.42715, 38.41802], [-121.42718, 38.41815], [-121.42724, 38.41828], [-121.42746, 38.41856]]]} | Open Access 1 | 44169 | Lichtenberger Park | 21225 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 6.116 | Lichtenberger Park | 0 | Local Park 2 | 4 | |
14552 | 14552 | 14551 | {"type": "Polygon", "coordinates": [[[-115.93924, 33.51824], [-115.93923, 33.52141], [-115.93904, 33.5214], [-115.9389, 33.52137], [-115.93881, 33.52131], [-115.93627, 33.51869], [-115.9362, 33.51859], [-115.93617, 33.5185], [-115.93616, 33.51822], [-115.93924, 33.51824]]]} | Open Access 1 | 48285 | North Shore Beach and Yacht Club | 32856 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | https://myrecreationdistrict.com/community-fun/north-shore | Riverside 10 | 14.99 | North Shore Beach and Yacht Club | 0 | Local Recreation Area 3 | 4 |
15886 | 15886 | 15885 | {"type": "Polygon", "coordinates": [[[-118.54781, 34.32672], [-118.54769, 34.32707], [-118.54764, 34.3273], [-118.54762, 34.32734], [-118.54752, 34.3274], [-118.54662, 34.32741], [-118.53658, 34.32729], [-118.5366, 34.33092], [-118.53429, 34.33092], [-118.53428, 34.3273], [-118.52868, 34.3273], [-118.5287, 34.32367], [-118.52187, 34.32368], [-118.5338, 34.31469], [-118.53523, 34.31592], [-118.53552, 34.31596], [-118.5357, 34.31621], [-118.53637, 34.31667], [-118.53692, 34.31712], [-118.5374, 34.31726], [-118.5377, 34.31745], [-118.53783, 34.31759], [-118.53852, 34.31805], [-118.53881, 34.31828], [-118.53911, 34.31837], [-118.53897, 34.31933], [-118.53928, 34.31997], [-118.53977, 34.32011], [-118.53998, 34.32047], [-118.54039, 34.32068], [-118.54083, 34.32078], [-118.54115, 34.32109], [-118.54136, 34.32163], [-118.54154, 34.32182], [-118.54187, 34.3219], [-118.54245, 34.32194], [-118.54218, 34.32261], [-118.54299, 34.32292], [-118.54323, 34.32325], [-118.5438, 34.32323], [-118.54434, 34.32329], [-118.54474, 34.32341], [-118.54509, 34.32341], [-118.54537, 34.3241], [-118.5464, 34.32399], [-118.54683, 34.32417], [-118.54734, 34.32472], [-118.5473, 34.32507], [-118.54732, 34.32524], [-118.54738, 34.32536], [-118.54749, 34.32549], [-118.54753, 34.32558], [-118.54752, 34.32577], [-118.54754, 34.32582], [-118.54772, 34.32625], [-118.54781, 34.32655], [-118.54781, 34.32672]]]} | Open Access 1 | 45371 | Michael D Antonovich Open Space Preserve | 7183 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=8 | Los Angeles 6 | 446.821 | Michael D Antonovich OSP | 0 | Local Conservation Area 4 | 2 |
16425 | 16425 | 16424 | {"type": "MultiPolygon", "coordinates": [[[[-118.87476, 34.32819], [-118.87476, 34.3296], [-118.87476, 34.3296], [-118.8745, 34.32941], [-118.87438, 34.32854], [-118.87476, 34.32819]]], [[[-118.87476, 34.34063], [-118.83068, 34.35903], [-118.83065, 34.35145], [-118.82257, 34.3514], [-118.81336, 34.35143], [-118.79638, 34.35155], [-118.79639, 34.33534], [-118.79708, 34.33551], [-118.79766, 34.33597], [-118.79782, 34.33615], [-118.7982, 34.33682], [-118.79853, 34.33734], [-118.79889, 34.33755], [-118.79951, 34.33766], [-118.79964, 34.3377], [-118.79977, 34.33777], [-118.79985, 34.33783], [-118.79994, 34.33793], [-118.80017, 34.33832], [-118.80083, 34.33894], [-118.80102, 34.33904], [-118.80117, 34.33908], [-118.80169, 34.33916], [-118.80201, 34.33917], [-118.8023, 34.33914], [-118.80336, 34.33892], [-118.80367, 34.3389], [-118.80402, 34.33892], [-118.80631, 34.33943], [-118.80843, 34.34012], [-118.8094, 34.34026], [-118.81059, 34.3402], [-118.81103, 34.34015], [-118.81172, 34.34013], [-118.81306, 34.34003], [-118.81336, 34.33993], [-118.81424, 34.33951], [-118.8144, 34.33947], [-118.81505, 34.33942], [-118.81527, 34.33937], [-118.81549, 34.33928], [-118.81571, 34.33914], [-118.81642, 34.33885], [-118.81661, 34.33881], [-118.81678, 34.33881], [-118.8173, 34.33863], [-118.8181, 34.33844], [-118.81881, 34.33861], [-118.81923, 34.33882], [-118.81948, 34.33886], [-118.81961, 34.33885], [-118.8197, 34.33881], [-118.81978, 34.33874], [-118.81995, 34.33839], [-118.82026, 34.33791], [-118.82043, 34.33772], [-118.8206, 34.33758], [-118.82077, 34.33748], [-118.82093, 34.33741], [-118.82199, 34.33706], [-118.82225, 34.33692], [-118.82248, 34.33685], [-118.82349, 34.33673], [-118.82375, 34.33675], [-118.82413, 34.33683], [-118.82437, 34.33684], [-118.82521, 34.33664], [-118.82566, 34.33659], [-118.82603, 34.3366], [-118.82663, 34.33668], [-118.82685, 34.33668], [-118.8282, 34.33638], [-118.82933, 34.33626], [-118.82956, 34.33627], [-118.82977, 34.33634], [-118.82991, 34.33642], [-118.83035, 34.33678], [-118.83053, 34.33683], [-118.83065, 34.33691], [-118.83084, 34.33696], [-118.83104, 34.33695], [-118.83181, 34.33698], [-118.83247, 34.33669], [-118.83293, 34.33644], [-118.83324, 34.33641], [-118.83355, 34.33632], [-118.83373, 34.33632], [-118.83389, 34.33637], [-118.83419, 34.33654], [-118.83438, 34.3366], [-118.83456, 34.33662], [-118.83517, 34.33662], [-118.83554, 34.33668], [-118.8369, 34.33709], [-118.83757, 34.33727], [-118.83784, 34.33742], [-118.83807, 34.33749], [-118.83894, 34.33741], [-118.83996, 34.33753], [-118.84067, 34.33751], [-118.84149, 34.33755], [-118.84209, 34.33737], [-118.84252, 34.33728], [-118.84265, 34.33721], [-118.84276, 34.33704], [-118.84285, 34.33697], [-118.84318, 34.33688], [-118.84337, 34.33677], [-118.84348, 34.33675], [-118.84357, 34.33678], [-118.84386, 34.33695], [-118.8451, 34.33738], [-118.84567, 34.33764], [-118.8458, 34.33769], [-118.84603, 34.33771], [-118.84651, 34.33765], [-118.84669, 34.33765], [-118.84762, 34.3378], [-118.84815, 34.33779], [-118.84824, 34.33777], [-118.84833, 34.33773], [-118.84863, 34.33751], [-118.84863, 34.33703], [-118.84938, 34.33701], [-118.85002, 34.33668], [-118.85021, 34.33662], [-118.85039, 34.33662], [-118.85119, 34.33669], [-118.85135, 34.33667], [-118.8515, 34.33664], [-118.85164, 34.33658], [-118.85293, 34.33585], [-118.85356, 34.3356], [-118.85395, 34.33535], [-118.85437, 34.33533], [-118.85474, 34.33525], [-118.85486, 34.33525], [-118.85501, 34.33528], [-118.85555, 34.33554], [-118.85574, 34.3356], [-118.85599, 34.33562], [-118.85635, 34.33555], [-118.85642, 34.33556], [-118.85649, 34.33562], [-118.85655, 34.33579], [-118.85655, 34.33591], [-118.85649, 34.33608], [-118.85656, 34.33625], [-118.85667, 34.3364], [-118.85688, 34.33658], [-118.85726, 34.33647], [-118.85734, 34.33642], [-118.85734, 34.32241], [-118.86439, 34.3224], [-118.86461, 34.32118], [-118.8643, 34.32035], [-118.8656, 34.31828], [-118.86643, 34.31659], [-118.86568, 34.31512], [-118.87466, 34.31512], [-118.87466, 34.32032], [-118.87399, 34.32033], [-118.87399, 34.32149], [-118.87366, 34.3215], [-118.87366, 34.32238], [-118.87476, 34.32239], [-118.87476, 34.32803], [-118.87424, 34.3285], [-118.87438, 34.32946], [-118.87471, 34.32972], [-118.87476, 34.32977], [-118.87476, 34.33065], [-118.87474, 34.3307], [-118.87476, 34.33071], [-118.87476, 34.34063]], [[-118.84181, 34.34823], [-118.8418, 34.34822], [-118.84069, 34.3482], [-118.84066, 34.34907], [-118.84178, 34.3491], [-118.84181, 34.34823]]]]} | Open Access 1 | 45301 | Happy Camp Canyon Regional Park | 19656 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://lamountains.com/parks.asp?parkid=18 | Ventura 8 | 3383.679 | Happy Camp Canyon RP | 0 | Local Park 2 | 4 |
7 | 7 | 6 | {"type": "Polygon", "coordinates": [[[-121.93881, 36.98905], [-121.93822, 36.98905], [-121.93821, 36.98875], [-121.93824, 36.98871], [-121.93853, 36.9887], [-121.93856, 36.98875], [-121.93875, 36.98872], [-121.93881, 36.98905]]]} | Open Access 1 | 28 | Richard Vessey Park | 24328 | 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 | 0.46 | Richard Vessey Park | 0 | Local Park 2 | 4 | |
9 | 9 | 8 | {"type": "Polygon", "coordinates": [[[-119.48323, 34.37952], [-119.48284, 34.37978], [-119.48215, 34.37935], [-119.48075, 34.37775], [-119.4785, 34.37584], [-119.47796, 34.37557], [-119.47746, 34.37548], [-119.47737, 34.37524], [-119.47812, 34.37527], [-119.47861, 34.37543], [-119.47887, 34.37564], [-119.47904, 34.37573], [-119.47969, 34.37544], [-119.48031, 34.37629], [-119.48123, 34.37728], [-119.48177, 34.37797], [-119.48233, 34.37854], [-119.48323, 34.37952]]]} | Open Access 1 | 36 | Rincon Beach Park | 24367 | 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 | 11.623 | Rincon Beach Park | 0 | Local Park 2 | 4 | |
12 | 12 | 11 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73762], [-120.70033, 35.73765], [-120.69995, 35.73853], [-120.69975, 35.73891], [-120.69913, 35.73992], [-120.6988, 35.73992], [-120.70087, 35.73565]]]} | Open Access 1 | 48 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.26 | Rios Caledonia Adobe | None 5 | |||
24 | 24 | 23 | {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15501, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | 62 | Atlantic Avenue Park | 15674 | 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 | 1.951 | Atlantic Avenue Park | 0 | Local Park 2 | 4 | |
31 | 31 | 30 | {"type": "Polygon", "coordinates": [[[-120.44007, 34.65751], [-120.44003, 34.66064], [-120.4377, 34.66062], [-120.43735, 34.65839], [-120.43399, 34.65557], [-120.43409, 34.64948], [-120.43349, 34.64835], [-120.43323, 34.648], [-120.4329, 34.64769], [-120.43272, 34.64755], [-120.43252, 34.64742], [-120.43202, 34.64716], [-120.43205, 34.64698], [-120.43156, 34.64672], [-120.4313, 34.64654], [-120.43107, 34.64633], [-120.43086, 34.64611], [-120.43007, 34.64516], [-120.42988, 34.64496], [-120.42986, 34.6449], [-120.42988, 34.64483], [-120.43012, 34.64467], [-120.43121, 34.64405], [-120.43128, 34.64412], [-120.43217, 34.6436], [-120.43226, 34.6436], [-120.43589, 34.64992], [-120.4396, 34.65676], [-120.44007, 34.65751]]]} | Open Access 1 | 80 | River Park | 24416 | 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 | 123.418 | River Park | 0 | 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]);