units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where LAYER = 3 and MNG_AG_LEV = 4
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_TYP, MNG_AG_ID, COUNTY, LABEL_NAME, GAP_STS
MNG_AGENCY 9
- East Bay Regional Park District 3
- Mountains Recreation and Conservation Authority 2
- Consumnes Community Services District 2
- Midpeninsula Regional Open Space District 2
- Valley Center Water District 2
- Valley-Wide Recreation and Park District 1
- Desert Recreation District 1
- Yuima Municipal Water District 1
- San Bernardino County Flood Control District 1
MNG_AG_TYP 5
DES_TP 4
ACCESS_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3646 | 3646 | 3645 | {"type": "Polygon", "coordinates": [[[-122.09719, 37.88699], [-122.0967, 37.88654], [-122.09593, 37.88668], [-122.09517, 37.88629], [-122.09471, 37.88637], [-122.09407, 37.88659], [-122.09356, 37.88625], [-122.09322, 37.88618], [-122.0933, 37.88612], [-122.0934, 37.8861], [-122.09615, 37.88602], [-122.09669, 37.88602], [-122.09723, 37.88606], [-122.09727, 37.88609], [-122.09728, 37.88613], [-122.09719, 37.88664], [-122.09719, 37.88699]]]} | Open Access 1 | 29549 | Lafayette/Moraga Trail | 20836 | 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 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.276 | Lafayette/Moraga Trail | 0 | Local Recreation Area 3 | 4 | |
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 |
15865 | 15865 | 15864 | {"type": "MultiPolygon", "coordinates": [[[[-122.0804, 37.33059], [-122.07911, 37.33194], [-122.07887, 37.33225], [-122.07852, 37.33283], [-122.07839, 37.33296], [-122.07824, 37.33308], [-122.07806, 37.33317], [-122.0779, 37.33323], [-122.0777, 37.33327], [-122.07749, 37.33329], [-122.07719, 37.33326], [-122.07646, 37.33309], [-122.07616, 37.33298], [-122.0759, 37.33282], [-122.07512, 37.33223], [-122.07517, 37.33218], [-122.075, 37.33205], [-122.07457, 37.3319], [-122.07427, 37.33187], [-122.0741, 37.33188], [-122.07394, 37.33192], [-122.07381, 37.33196], [-122.07365, 37.33205], [-122.07206, 37.3311], [-122.07206, 37.33082], [-122.07203, 37.3306], [-122.07191, 37.3303], [-122.07159, 37.32924], [-122.07162, 37.32837], [-122.07169, 37.32817], [-122.07164, 37.32819], [-122.07199, 37.32751], [-122.07218, 37.32722], [-122.07236, 37.32698], [-122.0726, 37.32671], [-122.07293, 37.32637], [-122.07419, 37.328], [-122.07498, 37.32761], [-122.0754, 37.32786], [-122.07518, 37.32786], [-122.07498, 37.32791], [-122.07421, 37.32834], [-122.07364, 37.32859], [-122.0734, 37.32901], [-122.07399, 37.32932], [-122.0742, 37.32947], [-122.07441, 37.32968], [-122.07451, 37.32976], [-122.0749, 37.32995], [-122.07499, 37.33001], [-122.07505, 37.33011], [-122.07509, 37.33039], [-122.07516, 37.33057], [-122.07531, 37.33078], [-122.07548, 37.33094], [-122.07556, 37.33096], [-122.07568, 37.33097], [-122.07584, 37.33069], [-122.07581, 37.33049], [-122.07586, 37.33048], [-122.07591, 37.3308], [-122.07617, 37.33078], [-122.07631, 37.3307], [-122.07637, 37.33064], [-122.07641, 37.33057], [-122.0765, 37.33004], [-122.07654, 37.32995], [-122.07659, 37.32988], [-122.07717, 37.32944], [-122.07744, 37.32908], [-122.07777, 37.32876], [-122.07795, 37.32854], [-122.07806, 37.32847], [-122.07841, 37.32835], [-122.07862, 37.32865], [-122.07828, 37.32882], [-122.07805, 37.329], [-122.07792, 37.32916], [-122.07758, 37.3297], [-122.07726, 37.33003], [-122.07714, 37.33023], [-122.07707, 37.33044], [-122.07706, 37.33061], [-122.0771, 37.33083], [-122.07718, 37.33097], [-122.07727, 37.33104], [-122.07738, 37.33108], [-122.07752, 37.3311], [-122.07765, 37.33109], [-122.0788, 37.33073], [-122.07912, 37.33069], [-122.07945, 37.33069], [-122.07961, 37.33066], [-122.07971, 37.33062], [-122.0798, 37.33056], [-122.07995, 37.33039], [-122.08027, 37.33047], [-122.08037, 37.33053], [-122.0804, 37.33059]]], [[[-122.09473, 37.33238], [-122.09235, 37.33433], [-122.09064, 37.33625], [-122.09065, 37.33627], [-122.09121, 37.33637], [-122.09143, 37.33688], [-122.09264, 37.33738], [-122.09274, 37.33777], [-122.09261, 37.33784], [-122.09259, 37.33801], [-122.09264, 37.33813], [-122.09253, 37.33838], [-122.09261, 37.33856], [-122.09263, 37.33887], [-122.09236, 37.339], [-122.09235, 37.33918], [-122.09225, 37.33932], [-122.09212, 37.33941], [-122.09221, 37.33983], [-122.09233, 37.33997], [-122.09241, 37.34002], [-122.09238, 37.34017], [-122.09249, 37.34025], [-122.09218, 37.34026], [-122.09215, 37.34046], [-122.09211, 37.34046], [-122.09049, 37.34012], [-122.09059, 37.33993], [-122.09047, 37.33989], [-122.09042, 37.33999], [-122.09034, 37.34004], [-122.09024, 37.34006], [-122.09013, 37.34003], [-122.0901, 37.33986], [-122.09036, 37.33976], [-122.0905, 37.33961], [-122.09053, 37.33941], [-122.09044, 37.33903], [-122.09092, 37.33661], [-122.09047, 37.33629], [-122.09028, 37.33609], [-122.08985, 37.3355], [-122.08954, 37.33515], [-122.08932, 37.33505], [-122.08907, 37.33483], [-122.08904, 37.33463], [-122.08866, 37.33444], [-122.08801, 37.33377], [-122.08797, 37.3336], [-122.08465, 37.33407], [-122.08444, 37.33341], [-122.08436, 37.33305], [-122.0842, 37.33304], [-122.08372, 37.33307], [-122.08364, 37.333], [-122.08351, 37.33202], [-122.08345, 37.33183], [-122.08336, 37.33166], [-122.08329, 37.33156], [-122.08319, 37.33158], [-122.08283, 37.33112], [-122.08291, 37.33106], [-122.08277, 37.3309], [-122.08255, 37.33073], [-122.08228, 37.33062], [-122.08133, 37.33037], [-122.08113, 37.33035], [-122.08095, 37.33036], [-122.08089, 37.33033], [-122.08089, 37.3303], [-122.08095, 37.33011], [-122.08097, 37.32994], [-122.08133, 37.32995], [-122.08169, 37.33002], [-122.08163, 37.32923], [-122.08215, 37.32883], [-122.08309, 37.32961], [-122.08438, 37.32863], [-122.0822, 37.32546], [-122.0823, 37.32525], [-122.08187, 37.32442], [-122.08104, 37.32418], [-122.07777, 37.32433], [-122.0777, 37.32419], [-122.07865, 37.32325], [-122.08156, 37.32373], [-122.08156, 37.32393], [-122.08178, 37.32422], [-122.08245, 37.32423], [-122.08247, 37.32371], [-122.08256, 37.32371], [-122.08485, 37.32496], [-122.08863, 37.32607], [-122.09346, 37.33005], [-122.09473, 37.33238]], [[-122.08557, 37.3273], [-122.08518, 37.32711], [-122.08493, 37.32727], [-122.08497, 37.32799], [-122.08527, 37.32828], [-122.08562, 37.32905], [-122.08573, 37.32906], [-122.08596, 37.32807], [-122.08593, 37.32797], [-122.08576, 37.32776], [-122.08557, 37.3273]]]]} | Open Access 1 | 27 | Rancho San Antonio Open Space Preserve | 31458 | 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 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | https://www.sccgov.org/sites/parks/parkfinder/Pages/RanchoSanAntonio.aspx | Santa Clara 19 | 282.56 | Rancho San Antonio OSP | 0 | Local Conservation Area 4 | 2 |
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 |
16624 | 16624 | 16623 | {"type": "Polygon", "coordinates": [[[-121.87428, 37.53505], [-121.87423, 37.5359], [-121.87414, 37.53845], [-121.87396, 37.54089], [-121.87396, 37.54203], [-121.8701, 37.54196], [-121.86955, 37.54176], [-121.86885, 37.5417], [-121.86885, 37.54142], [-121.86879, 37.54132], [-121.86353, 37.54128], [-121.8583, 37.54118], [-121.85764, 37.54027], [-121.85813, 37.53995], [-121.8586, 37.53948], [-121.85881, 37.53898], [-121.85889, 37.53895], [-121.85897, 37.53881], [-121.85912, 37.53863], [-121.85894, 37.53812], [-121.85795, 37.53698], [-121.85796, 37.53576], [-121.8569, 37.53481], [-121.8564, 37.53431], [-121.85545, 37.53365], [-121.85473, 37.53091], [-121.85356, 37.53043], [-121.85308, 37.53044], [-121.85304, 37.53025], [-121.85296, 37.53001], [-121.85259, 37.52957], [-121.85242, 37.52932], [-121.85221, 37.52907], [-121.85197, 37.52883], [-121.85173, 37.52861], [-121.85152, 37.52838], [-121.85112, 37.52787], [-121.8504, 37.52725], [-121.85003, 37.52682], [-121.84984, 37.52663], [-121.84971, 37.52644], [-121.84964, 37.52623], [-121.84954, 37.526], [-121.849, 37.52561], [-121.84881, 37.52536], [-121.84845, 37.52483], [-121.84831, 37.52456], [-121.84807, 37.524], [-121.84798, 37.52372], [-121.84791, 37.52344], [-121.84793, 37.52314], [-121.8479, 37.52282], [-121.84795, 37.52218], [-121.84789, 37.52187], [-121.84773, 37.52161], [-121.84769, 37.52139], [-121.84782, 37.5212], [-121.84802, 37.52104], [-121.86052, 37.52093], [-121.8695, 37.5209], [-121.86968, 37.535], [-121.87428, 37.53505]]]} | No Public Access 3 | 46962 | Sunol Regional Wilderness | 30582 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 864.645 | Sunol Reg. Wilderness | 1962 | Local Conservation Area 4 | 2 | |
16850 | 16850 | 16849 | {"type": "MultiPolygon", "coordinates": [[[[-121.79156, 37.50476], [-121.79134, 37.51904], [-121.77329, 37.51942], [-121.77349, 37.50472], [-121.79132, 37.50475], [-121.79156, 37.50476]]], [[[-121.87405, 37.50648], [-121.87397, 37.51447], [-121.86949, 37.51447], [-121.86944, 37.51803], [-121.86487, 37.5181], [-121.86496, 37.52091], [-121.86052, 37.52093], [-121.84804, 37.52104], [-121.84802, 37.52104], [-121.84789, 37.52089], [-121.84764, 37.52114], [-121.84773, 37.52161], [-121.84789, 37.52188], [-121.84795, 37.52219], [-121.8479, 37.52282], [-121.84792, 37.52308], [-121.84791, 37.52344], [-121.84757, 37.52368], [-121.84771, 37.52423], [-121.84792, 37.52445], [-121.84807, 37.52452], [-121.84827, 37.5249], [-121.84836, 37.52516], [-121.84844, 37.52517], [-121.84862, 37.52509], [-121.849, 37.52561], [-121.84932, 37.52585], [-121.84964, 37.52624], [-121.84971, 37.52644], [-121.84984, 37.52663], [-121.85003, 37.52681], [-121.84991, 37.52694], [-121.85014, 37.52694], [-121.85003, 37.52711], [-121.85056, 37.5274], [-121.85086, 37.52788], [-121.85115, 37.52822], [-121.85145, 37.52836], [-121.85152, 37.52838], [-121.85173, 37.52861], [-121.85198, 37.52883], [-121.85229, 37.52915], [-121.85217, 37.5293], [-121.85244, 37.52935], [-121.8526, 37.52988], [-121.85281, 37.53021], [-121.85271, 37.5302], [-121.85276, 37.53032], [-121.85277, 37.53054], [-121.85263, 37.5307], [-121.85212, 37.53148], [-121.85209, 37.5316], [-121.85203, 37.53169], [-121.85168, 37.53269], [-121.85171, 37.5335], [-121.8519, 37.53405], [-121.85216, 37.53445], [-121.85237, 37.5348], [-121.85267, 37.53514], [-121.85287, 37.53547], [-121.85305, 37.53569], [-121.8528, 37.53564], [-121.85263, 37.53557], [-121.85226, 37.53555], [-121.85196, 37.53559], [-121.85142, 37.53574], [-121.85089, 37.53583], [-121.85049, 37.53588], [-121.85023, 37.5359], [-121.85, 37.53589], [-121.84978, 37.53595], [-121.8493, 37.53591], [-121.84871, 37.53615], [-121.84833, 37.53615], [-121.84796, 37.53606], [-121.84773, 37.53609], [-121.84735, 37.53629], [-121.84716, 37.53648], [-121.84685, 37.53674], [-121.84646, 37.53688], [-121.84617, 37.53694], [-121.84582, 37.53694], [-121.84552, 37.53705], [-121.84521, 37.53709], [-121.84463, 37.53699], [-121.84444, 37.53701], [-121.84434, 37.53704], [-121.84415, 37.53703], [-121.84384, 37.53693], [-121.84343, 37.5369], [-121.84339, 37.53685], [-121.84323, 37.53683], [-121.84325, 37.5352], [-121.83885, 37.5352], [-121.8389, 37.52886], [-121.83433, 37.52892], [-121.83432, 37.52138], [-121.83435, 37.51299], [-121.8282, 37.51317], [-121.82799, 37.51335], [-121.82789, 37.51329], [-121.82778, 37.51319], [-121.82478, 37.51328], [-121.82498, 37.50593], [-121.81606, 37.50569], [-121.81589, 37.50578], [-121.81578, 37.52129], [-121.80715, 37.52064], [-121.80686, 37.50545], [-121.81386, 37.50563], [-121.81415, 37.5054], [-121.81492, 37.50464], [-121.81576, 37.50409], [-121.81698, 37.5036], [-121.81907, 37.50437], [-121.81948, 37.50513], [-121.81977, 37.50495], [-121.81956, 37.50443], [-121.81987, 37.50434], [-121.82052, 37.5033], [-121.8222, 37.50333], [-121.82486, 37.50313], [-121.82524, 37.50319], [-121.82543, 37.50361], [-121.82565, 37.50399], [-121.82603, 37.50385], [-121.82641, 37.50342], [-121.82703, 37.50361], [-121.82791, 37.50396], [-121.82867, 37.50442], [-121.82899, 37.5048], [-121.83019, 37.50608], [-121.84289, 37.50646], [-121.85985, 37.50665], [-121.85999, 37.50648], [-121.86938, 37.50648], [-121.86939, 37.50649], [-121.87405, 37.50648]], [[-121.85612, 37.51725], [-121.85397, 37.51724], [-121.85395, 37.5181], [-121.85611, 37.51811], [-121.85612, 37.51725]]]]} | Open Access 1 | 29545 | Sunol Regional Wilderness | 10841 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/sunol | Alameda 17 | 2997.505 | Sunol Reg. Wilderness | 1962 | 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]);