units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where ACCESS_TYP = 1 and MNG_AGENCY = 87 sorted by YR_EST
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
576 | 576 | 575 | {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.7433], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | 3448 | Poaks Headquarters | 23819 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.419 | Poaks Headquarters | None 57 | |||
2356 | 2356 | 2355 | {"type": "Polygon", "coordinates": [[[-121.7508, 38.02106], [-121.7506, 38.02106], [-121.75061, 38.02096], [-121.75065, 38.02095], [-121.75065, 38.01964], [-121.75066, 38.01963], [-121.75067, 38.01953], [-121.75076, 38.01953], [-121.75075, 38.02095], [-121.7508, 38.02096], [-121.7508, 38.02106]]]} | Open Access 1 | 17112 | Antioch Bridge Fishing Pier | 15522 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 0.397 | Antioch Bridge Fishing Pier | None 198 | |||
4182 | 4182 | 4181 | {"type": "Polygon", "coordinates": [[[-122.33713, 37.91103], [-122.3302, 37.90951], [-122.33019, 37.90937], [-122.32739, 37.90874], [-122.32609, 37.90838], [-122.32557, 37.9082], [-122.32557, 37.90811], [-122.32475, 37.9078], [-122.32454, 37.90774], [-122.32432, 37.90764], [-122.32317, 37.90701], [-122.32242, 37.90652], [-122.32205, 37.90627], [-122.32145, 37.90584], [-122.32094, 37.9054], [-122.32039, 37.90483], [-122.32022, 37.90468], [-122.31956, 37.90396], [-122.3163, 37.8999], [-122.31655, 37.89982], [-122.31658, 37.89984], [-122.31926, 37.90317], [-122.32457, 37.90051], [-122.32268, 37.89818], [-122.32347, 37.89776], [-122.32425, 37.89827], [-122.32452, 37.89851], [-122.32468, 37.89872], [-122.32478, 37.89891], [-122.32485, 37.89914], [-122.32487, 37.89938], [-122.32522, 37.89938], [-122.32522, 37.9011], [-122.32128, 37.90308], [-122.31988, 37.9038], [-122.3203, 37.90434], [-122.32088, 37.90498], [-122.32125, 37.90533], [-122.32159, 37.90561], [-122.32212, 37.90606], [-122.32235, 37.90632], [-122.3228, 37.9066], [-122.32313, 37.90684], [-122.3235, 37.90705], [-122.32458, 37.9076], [-122.32579, 37.90809], [-122.32594, 37.90814], [-122.3261, 37.90816], [-122.32745, 37.90855], [-122.3325, 37.90968], [-122.33251, 37.90967], [-122.33251, 37.90946], [-122.33711, 37.91047], [-122.33713, 37.91103]]]} | Open Access 1 | 3447 | Point Isabel | 23851 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 37.437 | Point Isabel | None 363 | |||
5856 | 5856 | 5855 | {"type": "Polygon", "coordinates": [[[-122.24593, 38.05452], [-122.24554, 38.05454], [-122.24552, 38.05423], [-122.24559, 38.05422], [-122.24557, 38.05413], [-122.24515, 38.05393], [-122.24465, 38.05396], [-122.24446, 38.05402], [-122.24428, 38.05419], [-122.24387, 38.05422], [-122.24323, 38.05398], [-122.24247, 38.05407], [-122.24266, 38.05471], [-122.24243, 38.05478], [-122.24254, 38.05538], [-122.24273, 38.05569], [-122.24261, 38.05587], [-122.24169, 38.05597], [-122.24148, 38.05639], [-122.23999, 38.05634], [-122.23998, 38.05584], [-122.24021, 38.05586], [-122.24054, 38.05585], [-122.24087, 38.05578], [-122.24117, 38.05566], [-122.24143, 38.0555], [-122.24155, 38.0554], [-122.24226, 38.05455], [-122.24195, 38.0544], [-122.24182, 38.05437], [-122.24148, 38.05361], [-122.24141, 38.05342], [-122.24136, 38.05321], [-122.24134, 38.05301], [-122.24135, 38.0528], [-122.24141, 38.05251], [-122.24376, 38.05319], [-122.24396, 38.05373], [-122.24385, 38.05392], [-122.24393, 38.05396], [-122.24423, 38.05395], [-122.24431, 38.05384], [-122.24459, 38.05375], [-122.24532, 38.05371], [-122.24583, 38.05396], [-122.24584, 38.05419], [-122.24593, 38.05421], [-122.24593, 38.05452]]]} | Open Access 1 | 242 | Rodeo Grounds | 24549 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 14.364 | Rodeo Grounds | None 469 | |||
10067 | 10067 | 10066 | {"type": "MultiPolygon", "coordinates": [[[[-122.2745, 38.03467], [-122.27444, 38.03503], [-122.27436, 38.03534], [-122.27424, 38.03563], [-122.27403, 38.03599], [-122.27382, 38.03626], [-122.27358, 38.03652], [-122.2733, 38.03675], [-122.27299, 38.03695], [-122.27266, 38.03714], [-122.27231, 38.03729], [-122.27194, 38.03741], [-122.27098, 38.0377], [-122.26857, 38.0384], [-122.26853, 38.03822], [-122.27101, 38.03749], [-122.27095, 38.03738], [-122.27083, 38.03724], [-122.27148, 38.03713], [-122.27143, 38.03692], [-122.2718, 38.03686], [-122.27171, 38.0365], [-122.27241, 38.03638], [-122.27232, 38.03602], [-122.27286, 38.03593], [-122.27279, 38.03563], [-122.27333, 38.03554], [-122.27318, 38.03496], [-122.27392, 38.03485], [-122.27386, 38.03459], [-122.27435, 38.03452], [-122.2745, 38.03467]]], [[[-122.27573, 38.03587], [-122.27551, 38.03742], [-122.27477, 38.0383], [-122.27289, 38.03741], [-122.27234, 38.03763], [-122.27226, 38.0376], [-122.27246, 38.03753], [-122.27285, 38.03737], [-122.27321, 38.03717], [-122.27354, 38.03694], [-122.27385, 38.03669], [-122.27411, 38.03641], [-122.27434, 38.03611], [-122.27453, 38.0358], [-122.27461, 38.03563], [-122.27475, 38.0352], [-122.27481, 38.03496], [-122.27573, 38.03587]]]]} | Open Access 1 | 17424 | Lone Tree Point | 21444 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 21.13 | Lone Tree Point | None 869 | |||
11330 | 11330 | 11329 | {"type": "Polygon", "coordinates": [[[-122.04279, 37.68931], [-122.04192, 37.68952], [-122.04197, 37.68984], [-122.0417, 37.68988], [-122.04139, 37.69003], [-122.04079, 37.69022], [-122.04109, 37.68972], [-122.04062, 37.6896], [-122.04169, 37.68901], [-122.04204, 37.68905], [-122.04279, 37.68931]]]} | Open Access 1 | 22054 | Palomares Ridge | 23369 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.611 | Palomares Ridge | None 996 | |||
16592 | 16592 | 16591 | {"type": "Polygon", "coordinates": [[[-122.32764, 37.88931], [-122.32767, 37.88943], [-122.3277, 37.88994], [-122.32777, 37.89025], [-122.32775, 37.89047], [-122.32776, 37.8908], [-122.32755, 37.89163], [-122.32748, 37.89129], [-122.3275, 37.89097], [-122.32745, 37.89074], [-122.32717, 37.89084], [-122.32691, 37.89087], [-122.3265, 37.89088], [-122.326, 37.89082], [-122.32568, 37.8908], [-122.32561, 37.89111], [-122.32559, 37.89174], [-122.32566, 37.89202], [-122.32592, 37.89206], [-122.32599, 37.89234], [-122.32573, 37.89251], [-122.32444, 37.89221], [-122.32409, 37.89132], [-122.32356, 37.89131], [-122.32311, 37.8899], [-122.31991, 37.88993], [-122.31763, 37.89086], [-122.31635, 37.8909], [-122.31625, 37.89169], [-122.31393, 37.8917], [-122.31197, 37.89022], [-122.312, 37.88997], [-122.31333, 37.88985], [-122.31333, 37.88964], [-122.31592, 37.88964], [-122.31593, 37.88793], [-122.31595, 37.88794], [-122.31602, 37.88795], [-122.31709, 37.88922], [-122.31722, 37.88925], [-122.32312, 37.8891], [-122.32321, 37.88893], [-122.32315, 37.88872], [-122.32319, 37.88833], [-122.32341, 37.88824], [-122.32374, 37.88809], [-122.32431, 37.88803], [-122.32463, 37.88788], [-122.32501, 37.88804], [-122.3254, 37.88804], [-122.32577, 37.88823], [-122.32585, 37.88825], [-122.32584, 37.88827], [-122.32619, 37.88847], [-122.32661, 37.88861], [-122.32695, 37.88868], [-122.32718, 37.88871], [-122.32763, 37.88855], [-122.32756, 37.88886], [-122.32764, 37.88931]]]} | Open Access 1 | 29694 | McLaughlin Eastshore State Park | 29199 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/eastshore | Alameda 17 | 71.308 | McLaughlin Eastshore SP | None 1414 | ||
3269 | 3269 | 3268 | {"type": "Polygon", "coordinates": [[[-122.0528, 37.99715], [-122.05267, 37.99768], [-122.05079, 37.99735], [-122.05079, 37.99734], [-122.05051, 37.99729], [-122.05017, 37.99725], [-122.05016, 37.99724], [-122.04978, 37.99725], [-122.04887, 37.99733], [-122.04817, 37.99731], [-122.04823, 37.9969], [-122.04863, 37.99694], [-122.04888, 37.99693], [-122.04913, 37.99691], [-122.04957, 37.9968], [-122.04985, 37.99676], [-122.04986, 37.99675], [-122.05003, 37.99674], [-122.0501, 37.99681], [-122.05025, 37.99683], [-122.05029, 37.99673], [-122.05066, 37.99677], [-122.0528, 37.99715]]]} | Open Access 1 | 29407 | Delta/DeAnza Trail | 18077 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.445 | Delta/DeAnza Trail | 0 | Local Recreation Area 3 | 4 | |
3624 | 3624 | 3623 | {"type": "Polygon", "coordinates": [[[-121.70748, 37.99957], [-121.7053, 37.99809], [-121.70531, 37.9979], [-121.70746, 37.99794], [-121.70748, 37.99957]]]} | Open Access 1 | 29411 | BB Delta Shoreline Trail | 15905 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.739 | BB Delta Shoreline Trail | 0 | Local Recreation Area 3 | 4 | |
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 | |
3733 | 3733 | 3732 | {"type": "MultiPolygon", "coordinates": [[[[-122.03357, 37.90414], [-122.03346, 37.90426], [-122.03345, 37.904], [-122.0335, 37.90405], [-122.03357, 37.90414]]], [[[-122.04019, 37.90842], [-122.03957, 37.90859], [-122.03754, 37.90726], [-122.03826, 37.90623], [-122.03875, 37.90662], [-122.03905, 37.9069], [-122.03939, 37.90741], [-122.03961, 37.90803], [-122.04019, 37.90842]]]]} | Open Access 1 | 31016 | Briones to Mount Diablo Trail | 33752 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.904 | Briones to Mount Diablo Trail | 0 | Local Recreation Area 3 | 4 | |
4299 | 4299 | 4298 | {"type": "Polygon", "coordinates": [[[-121.7518, 38.01968], [-121.75091, 38.01969], [-121.7509, 38.01962], [-121.75076, 38.01962], [-121.75075, 38.01954], [-121.75067, 38.01953], [-121.75068, 38.01915], [-121.75068, 38.01845], [-121.75062, 38.01784], [-121.75069, 38.01749], [-121.75069, 38.01643], [-121.75071, 38.01657], [-121.7508, 38.01673], [-121.7509, 38.01684], [-121.75104, 38.01693], [-121.75122, 38.01701], [-121.75137, 38.01703], [-121.75179, 38.01704], [-121.7518, 38.01968]]]} | Open Access 1 | 45338 | Antioch / Oakley Regional Shoreline | 15521 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 7.375 | Antioch / Oakley Reg. Shoreline | 0 | Local Park 2 | 4 | |
9237 | 9237 | 9236 | {"type": "Polygon", "coordinates": [[[-121.71401, 38.0024], [-121.71401, 38.00331], [-121.71393, 38.00334], [-121.7134, 38.00283], [-121.71283, 38.00253], [-121.71206, 38.00177], [-121.71201, 38.00107], [-121.71333, 38.00191], [-121.71401, 38.0024]]]} | Open Access 1 | 15373 | Big Break Regional Trail | 16075 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.138 | Big Break Reg. Trail | 0 | Local Recreation Area 3 | 4 | |
9474 | 9474 | 9473 | {"type": "MultiPolygon", "coordinates": [[[[-122.30915, 37.84566], [-122.30817, 37.84588], [-122.30821, 37.8476], [-122.30107, 37.84921], [-122.30081, 37.84913], [-122.30112, 37.84812], [-122.30117, 37.84744], [-122.30225, 37.84718], [-122.30225, 37.84437], [-122.29844, 37.84436], [-122.29811, 37.84292], [-122.29818, 37.84243], [-122.29797, 37.84227], [-122.29795, 37.84217], [-122.29789, 37.8416], [-122.29789, 37.84144], [-122.29792, 37.84125], [-122.29802, 37.84093], [-122.29939, 37.84074], [-122.30721, 37.84074], [-122.30856, 37.84072], [-122.30857, 37.84074], [-122.30914, 37.84075], [-122.30915, 37.84566]]], [[[-122.31153, 37.86418], [-122.31141, 37.86454], [-122.31122, 37.86464], [-122.31104, 37.86465], [-122.3106, 37.86471], [-122.30591, 37.86568], [-122.30577, 37.86572], [-122.30563, 37.86572], [-122.30537, 37.86541], [-122.30393, 37.86453], [-122.30218, 37.85889], [-122.3003, 37.85163], [-122.30027, 37.85145], [-122.30027, 37.85121], [-122.30025, 37.85105], [-122.30068, 37.84959], [-122.30208, 37.84924], [-122.30822, 37.84786], [-122.30848, 37.85877], [-122.31153, 37.86418]]], [[[-122.31316, 37.8691], [-122.30903, 37.86998], [-122.30548, 37.87079], [-122.30529, 37.87011], [-122.30499, 37.86879], [-122.30499, 37.86853], [-122.30507, 37.86831], [-122.30574, 37.86731], [-122.30583, 37.86703], [-122.30579, 37.8668], [-122.30572, 37.8666], [-122.30575, 37.86651], [-122.30584, 37.86647], [-122.31099, 37.86543], [-122.3112, 37.8655], [-122.31316, 37.8691]]], [[[-122.31846, 37.87579], [-122.31005, 37.87748], [-122.30873, 37.87383], [-122.30661, 37.87435], [-122.30561, 37.87119], [-122.31326, 37.86954], [-122.31446, 37.87081], [-122.31516, 37.87171], [-122.31566, 37.87224], [-122.31846, 37.87579]]], [[[-122.33944, 37.89058], [-122.32869, 37.8935], [-122.32262, 37.89493], [-122.32444, 37.89221], [-122.32573, 37.89251], [-122.32599, 37.89234], [-122.32592, 37.89206], [-122.32566, 37.89202], [-122.32559, 37.89173], [-122.32561, 37.89111], [-122.32568, 37.8908], [-122.326, 37.89082], [-122.3265, 37.89088], [-122.32691, 37.89087], [-122.32717, 37.89084], [-122.32745, 37.89074], [-122.3275, 37.89097], [-122.32748, 37.89129], [-122.32754, 37.89159], [-122.32756, 37.8916], [-122.32776, 37.8908], [-122.32775, 37.89047], [-122.32777, 37.89024], [-122.3277, 37.88994], [-122.32767, 37.88943], [-122.32756, 37.88886], [-122.32763, 37.88856], [-122.32718, 37.88871], [-122.32695, 37.88868], [-122.32661, 37.88861], [-122.32619, 37.88847], [-122.3258, 37.88824], [-122.3254, 37.88804], [-122.32501, 37.88804], [-122.32463, 37.88788], [-122.32431, 37.88803], [-122.32374, 37.88809], [-122.32341, 37.88824], [-122.32319, 37.88832], [-122.32315, 37.88872], [-122.32321, 37.88893], [-122.32312, 37.8891], [-122.31722, 37.88925], [-122.3171, 37.88922], [-122.31602, 37.88795], [-122.31595, 37.88794], [-122.31593, 37.88793], [-122.31594, 37.88071], [-122.31252, 37.88139], [-122.31236, 37.88109], [-122.31217, 37.88081], [-122.31211, 37.88068], [-122.31185, 37.88037], [-122.31159, 37.88009], [-122.3108, 37.8791], [-122.31005, 37.87812], [-122.3099, 37.8779], [-122.30983, 37.87775], [-122.31024, 37.87767], [-122.31046, 37.87778], [-122.31051, 37.87772], [-122.31053, 37.87761], [-122.31588, 37.87656], [-122.31865, 37.87593], [-122.32167, 37.87952], [-122.32559, 37.88405], [-122.33014, 37.88463], [-122.3307, 37.88919], [-122.33944, 37.89058]]]]} | Open Access 1 | 15869 | McLaughlin Eastshore State Park | 29199 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/eastshore | Alameda 17 | 1084.173 | McLaughlin Eastshore SP | 0 | None 785 | |
11576 | 11576 | 11575 | {"type": "Polygon", "coordinates": [[[-122.21582, 37.7497], [-122.2122, 37.75089], [-122.21219, 37.7509], [-122.21281, 37.75156], [-122.21461, 37.75149], [-122.21142, 37.75331], [-122.21104, 37.75277], [-122.21118, 37.75272], [-122.21131, 37.75252], [-122.21132, 37.75241], [-122.21105, 37.75174], [-122.21078, 37.75094], [-122.21108, 37.75075], [-122.21072, 37.75029], [-122.2115, 37.74985], [-122.21127, 37.74958], [-122.21182, 37.74903], [-122.21102, 37.74812], [-122.21109, 37.74794], [-122.2099, 37.74658], [-122.20975, 37.74657], [-122.20956, 37.74634], [-122.20952, 37.74636], [-122.20871, 37.74544], [-122.20851, 37.74554], [-122.20847, 37.7455], [-122.20866, 37.74539], [-122.20866, 37.74538], [-122.20713, 37.74363], [-122.20579, 37.74437], [-122.20566, 37.74422], [-122.20795, 37.74294], [-122.20849, 37.74357], [-122.2085, 37.74356], [-122.20844, 37.74313], [-122.21245, 37.74313], [-122.21582, 37.7497]]]} | Open Access 1 | 23671 | Oakport Field | 23035 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 92.032 | Oakport Field | 0 | Local Recreation Area 3 | 4 | |
11889 | 11889 | 11888 | {"type": "Polygon", "coordinates": [[[-122.12119, 37.99183], [-122.12094, 37.99183], [-122.12073, 37.99142], [-122.12067, 37.99123], [-122.12053, 37.99101], [-122.12036, 37.99083], [-122.11953, 37.99054], [-122.11898, 37.99054], [-122.11859, 37.9907], [-122.11803, 37.99083], [-122.11755, 37.99121], [-122.11756, 37.99136], [-122.11778, 37.99163], [-122.11775, 37.99168], [-122.11747, 37.99159], [-122.11728, 37.99155], [-122.11673, 37.99148], [-122.11634, 37.99146], [-122.11635, 37.99047], [-122.11127, 37.99041], [-122.11081, 37.9904], [-122.1108, 37.99035], [-122.10885, 37.99033], [-122.10834, 37.98908], [-122.10817, 37.98839], [-122.10786, 37.98789], [-122.10639, 37.98388], [-122.10672, 37.98297], [-122.10679, 37.98298], [-122.10647, 37.98388], [-122.10794, 37.98791], [-122.10823, 37.98838], [-122.10839, 37.98906], [-122.10889, 37.99028], [-122.11086, 37.9903], [-122.11088, 37.99035], [-122.11116, 37.99036], [-122.12051, 37.99046], [-122.12055, 37.99051], [-122.12119, 37.99183]]]} | Open Access 1 | 24446 | CA State Riding & Hiking Trail | 28138 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/Page161.aspx | Contra Costa 12 | 8.246 | CA State Riding & Hiking Trail | 0 | Local Recreation Area 3 | 4 |
12258 | 12258 | 12257 | {"type": "Polygon", "coordinates": [[[-122.29218, 38.01568], [-122.29031, 38.01802], [-122.28912, 38.01718], [-122.28922, 38.01688], [-122.28938, 38.0167], [-122.28977, 38.01698], [-122.29009, 38.01702], [-122.29019, 38.01671], [-122.2906, 38.0165], [-122.2905, 38.01637], [-122.29193, 38.01586], [-122.29218, 38.01568]]]} | Open Access 1 | 25796 | San Pablo Bay Regional Shoreline | 24965 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.337 | San Pablo Bay Reg. Shoreline | 0 | Local Park 2 | 4 | |
12616 | 12616 | 12615 | {"type": "Polygon", "coordinates": [[[-122.11236, 37.89111], [-122.11234, 37.89111], [-122.11224, 37.89126], [-122.11214, 37.89136], [-122.11187, 37.89146], [-122.11178, 37.89161], [-122.11167, 37.89192], [-122.11167, 37.89221], [-122.1114, 37.89225], [-122.11132, 37.89205], [-122.11155, 37.89177], [-122.11166, 37.89144], [-122.11195, 37.89118], [-122.1122, 37.89108], [-122.1122, 37.89103], [-122.11235, 37.89102], [-122.11236, 37.89111]]]} | Open Access 1 | 29415 | Briones/Las Trampas Trail | 16396 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 0.765 | Briones/Las Trampas Trail | 0 | Local Recreation Area 3 | 4 | |
12621 | 12621 | 12620 | {"type": "MultiPolygon", "coordinates": [[[[-122.10336, 37.88915], [-122.10325, 37.88929], [-122.09952, 37.88684], [-122.09906, 37.88657], [-122.09871, 37.8864], [-122.09832, 37.88626], [-122.09812, 37.88621], [-122.09789, 37.88617], [-122.09798, 37.88599], [-122.09846, 37.88612], [-122.09878, 37.88625], [-122.09907, 37.88638], [-122.09965, 37.88671], [-122.10336, 37.88915]]], [[[-122.1019, 37.86205], [-122.09983, 37.86557], [-122.09945, 37.86633], [-122.09932, 37.86665], [-122.0991, 37.8673], [-122.09905, 37.86718], [-122.09902, 37.86708], [-122.09902, 37.86693], [-122.09904, 37.86683], [-122.09942, 37.86591], [-122.09959, 37.86561], [-122.10171, 37.86198], [-122.1019, 37.86205]]], [[[-122.10312, 37.8574], [-122.10291, 37.8578], [-122.10264, 37.85858], [-122.10249, 37.85922], [-122.10222, 37.86073], [-122.10215, 37.86103], [-122.10202, 37.8614], [-122.10184, 37.86175], [-122.10186, 37.86166], [-122.10186, 37.86153], [-122.10177, 37.86092], [-122.10174, 37.86061], [-122.10175, 37.86053], [-122.1018, 37.86052], [-122.10189, 37.85867], [-122.10206, 37.85862], [-122.1022, 37.85863], [-122.10237, 37.85834], [-122.10243, 37.85804], [-122.10203, 37.85798], [-122.10216, 37.85747], [-122.10262, 37.85738], [-122.10272, 37.85714], [-122.10312, 37.8574]]], [[[-122.11101, 37.89088], [-122.11069, 37.89095], [-122.11037, 37.89099], [-122.11005, 37.89101], [-122.10971, 37.89099], [-122.10651, 37.89056], [-122.10567, 37.89038], [-122.10492, 37.89015], [-122.10424, 37.88986], [-122.10384, 37.88965], [-122.10339, 37.88938], [-122.10349, 37.88924], [-122.10392, 37.88949], [-122.10446, 37.88977], [-122.10501, 37.89], [-122.1057, 37.89022], [-122.1066, 37.8904], [-122.10953, 37.89081], [-122.10981, 37.89083], [-122.1101, 37.89084], [-122.1104, 37.89082], [-122.11069, 37.89078], [-122.11099, 37.89072], [-122.11101, 37.89088]]]]} | Open Access 1 | 29414 | Lafayette/Moraga Trail | 20836 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 14.096 | Lafayette/Moraga Trail | 0 | Local Recreation Area 3 | 4 | |
12665 | 12665 | 12664 | {"type": "MultiPolygon", "coordinates": [[[[-121.75466, 37.48358], [-121.75464, 37.49061], [-121.75106, 37.49064], [-121.74118, 37.49056], [-121.74099, 37.48351], [-121.75466, 37.48358]]], [[[-121.73671, 37.50434], [-121.7455, 37.50444], [-121.74546, 37.5122], [-121.74547, 37.51221], [-121.75448, 37.51217], [-121.75469, 37.50453], [-121.7734, 37.50472], [-121.77329, 37.51942], [-121.75448, 37.51942], [-121.73649, 37.51935], [-121.73199, 37.51914], [-121.72291, 37.51887], [-121.71856, 37.51888], [-121.7186, 37.53496], [-121.72901, 37.5349], [-121.72899, 37.53782], [-121.72994, 37.53781], [-121.72998, 37.53675], [-121.73454, 37.53678], [-121.73495, 37.54954], [-121.71664, 37.54945], [-121.71673, 37.56404], [-121.69836, 37.564], [-121.69849, 37.5495], [-121.69851, 37.53502], [-121.68259, 37.53485], [-121.68293, 37.51917], [-121.70083, 37.51921], [-121.70993, 37.51904], [-121.70991, 37.51179], [-121.71852, 37.51173], [-121.71847, 37.50456], [-121.72814, 37.50453], [-121.73671, 37.50434]]]]} | Open Access 1 | 29544 | Ohlone Regional Wilderness | 10826 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/ohlone | Alameda 17 | 5442.916 | Ohlone Reg. Wilderness | 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]);