units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where DES_TP = 3 and MNG_AGENCY = 87 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, COUNTY, LABEL_NAME, YR_EST
SUID_NMA 24 ✖
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 28 ✖
DES_TP 1
- Local Recreation Area · 28 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 |
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 | |
12726 | 12726 | 12725 | {"type": "MultiPolygon", "coordinates": [[[[-121.93312, 37.96917], [-121.93309, 37.9762], [-121.92397, 37.97636], [-121.92389, 37.98339], [-121.91481, 37.9835], [-121.91485, 37.97467], [-121.91541, 37.97455], [-121.91619, 37.97432], [-121.91638, 37.97432], [-121.91684, 37.97403], [-121.917, 37.97372], [-121.91739, 37.97344], [-121.91795, 37.97331], [-121.91823, 37.97315], [-121.91876, 37.97249], [-121.91908, 37.97226], [-121.91945, 37.97219], [-121.91991, 37.97201], [-121.92004, 37.97193], [-121.92076, 37.97121], [-121.92124, 37.97103], [-121.92209, 37.97065], [-121.92264, 37.97037], [-121.92271, 37.9702], [-121.9229, 37.97006], [-121.92356, 37.96996], [-121.92384, 37.9698], [-121.9245, 37.96925], [-121.93312, 37.96917]]], [[[-121.92264, 37.96928], [-121.922, 37.96996], [-121.92175, 37.97005], [-121.92152, 37.97027], [-121.92122, 37.97042], [-121.9205, 37.9709], [-121.91988, 37.97127], [-121.91761, 37.97247], [-121.91709, 37.97284], [-121.91631, 37.97367], [-121.91588, 37.97391], [-121.91493, 37.9742], [-121.91489, 37.96938], [-121.92264, 37.96928]]]]} | No Public Access 3 | 29753 | CNWS to Black Diamond | 17451 | 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 | 449.119 | CNWS to Black Diamond | 0 | Local Recreation Area 3 | 4 | |
14183 | 14183 | 14182 | {"type": "Polygon", "coordinates": [[[-122.37623, 37.95851], [-122.37478, 37.95896], [-122.37476, 37.95894], [-122.37382, 37.95922], [-122.37381, 37.95841], [-122.37423, 37.95841], [-122.37437, 37.95838], [-122.37438, 37.95836], [-122.37421, 37.95812], [-122.37426, 37.95805], [-122.37534, 37.95758], [-122.3757, 37.95745], [-122.37611, 37.9574], [-122.3762, 37.95742], [-122.37623, 37.95851]]]} | Open Access 1 | 43104 | Wildcat Creek Trail | 27503 | 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 | 6.212 | Wildcat Creek Trail | 0 | Local Recreation Area 3 | 4 | |
16665 | 16665 | 16664 | {"type": "Polygon", "coordinates": [[[-122.0161, 37.83947], [-122.01592, 37.83969], [-122.01594, 37.83971], [-122.01576, 37.83994], [-122.01475, 37.84015], [-122.01362, 37.84097], [-122.01307, 37.84201], [-122.01332, 37.84594], [-122.01281, 37.84602], [-122.01282, 37.84625], [-122.01252, 37.84626], [-122.01243, 37.84633], [-122.01035, 37.84636], [-122.01015, 37.84633], [-122.01004, 37.84636], [-122.00938, 37.84638], [-122.00738, 37.8457], [-122.00703, 37.84551], [-122.00622, 37.84524], [-122.00475, 37.84479], [-122.00478, 37.84468], [-122.00627, 37.84515], [-122.00735, 37.84552], [-122.00735, 37.84562], [-122.00938, 37.8463], [-122.01245, 37.84625], [-122.0128, 37.84594], [-122.0125, 37.84132], [-122.01337, 37.83979], [-122.01386, 37.83993], [-122.01417, 37.83899], [-122.0151, 37.83896], [-122.01558, 37.83916], [-122.0161, 37.83947]]]} | No Public Access 3 | 15340 | Las Trampas/Diablo Regional Trail | 21068 | 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 | 16.575 | Las Trampas/Diablo Reg. Trail | 0 | Local Recreation Area 3 | 4 | |
16860 | 16860 | 16859 | {"type": "MultiPolygon", "coordinates": [[[[-121.60916, 37.93276], [-121.60904, 37.93276], [-121.60902, 37.93271], [-121.6081, 37.93272], [-121.60864, 37.93598], [-121.60795, 37.93658], [-121.60834, 37.93867], [-121.60825, 37.93905], [-121.59819, 37.93913], [-121.5981, 37.93466], [-121.59229, 37.93078], [-121.59228, 37.92974], [-121.60063, 37.92967], [-121.60064, 37.92938], [-121.60198, 37.92936], [-121.60206, 37.92927], [-121.60211, 37.91785], [-121.60386, 37.91775], [-121.60391, 37.91959], [-121.6042, 37.92372], [-121.60742, 37.92337], [-121.6077, 37.92498], [-121.60431, 37.92535], [-121.60458, 37.92936], [-121.60442, 37.92964], [-121.60866, 37.92961], [-121.60872, 37.92983], [-121.60916, 37.93276]]], [[[-121.6409, 37.95462], [-121.64089, 37.96179], [-121.63483, 37.96181], [-121.63484, 37.9688], [-121.63566, 37.96881], [-121.6353, 37.96884], [-121.62825, 37.96876], [-121.62721, 37.96876], [-121.62716, 37.9654], [-121.62013, 37.96544], [-121.61998, 37.95458], [-121.62267, 37.95456], [-121.64086, 37.95454], [-121.64086, 37.95461], [-121.6409, 37.95462]]], [[[-121.63638, 37.96886], [-121.63635, 37.97242], [-121.62718, 37.97244], [-121.62709, 37.96887], [-121.62825, 37.96887], [-121.6353, 37.96895], [-121.63638, 37.96886]]]]} | No Public Access 3 | 46995 | Delta Access Regional Recreation Area | 30632 | 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 | 986.689 | Delta Access Reg. Rec. Area | 0 | Local Recreation Area 3 | 4 | |
16861 | 16861 | 16860 | {"type": "Polygon", "coordinates": [[[-122.23423, 37.84806], [-122.23387, 37.84811], [-122.23133, 37.84855], [-122.23093, 37.84854], [-122.23092, 37.84849], [-122.23072, 37.84844], [-122.23046, 37.84833], [-122.22978, 37.84732], [-122.22937, 37.84681], [-122.2272, 37.84436], [-122.22702, 37.84396], [-122.22653, 37.84358], [-122.22626, 37.84324], [-122.22763, 37.84318], [-122.22763, 37.84316], [-122.22741, 37.843], [-122.22768, 37.84299], [-122.2279, 37.84337], [-122.22902, 37.8442], [-122.22949, 37.84395], [-122.23023, 37.84486], [-122.23105, 37.84504], [-122.23144, 37.84543], [-122.23117, 37.8456], [-122.23142, 37.84586], [-122.23376, 37.84711], [-122.2341, 37.84738], [-122.23415, 37.84776], [-122.23423, 37.84806]]]} | Open Access 1 | 1433 | Temescal Regional Recreation Area | 26233 | 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 | 38.546 | Temescal Reg. Rec. Area | 1936 | Local Recreation Area 3 | 4 | |
16852 | 16852 | 16851 | {"type": "Polygon", "coordinates": [[[-122.06054, 37.71153], [-122.06043, 37.71157], [-122.0603, 37.71167], [-122.06017, 37.71178], [-122.06019, 37.71182], [-122.06007, 37.71189], [-122.06019, 37.7124], [-122.06032, 37.71239], [-122.06038, 37.71255], [-122.06024, 37.71258], [-122.06036, 37.71312], [-122.06053, 37.71317], [-122.0601, 37.71443], [-122.0581, 37.71415], [-122.05794, 37.71437], [-122.0578, 37.71435], [-122.0574, 37.71481], [-122.05788, 37.71593], [-122.05643, 37.71632], [-122.05602, 37.7164], [-122.0559, 37.71652], [-122.05385, 37.71618], [-122.05385, 37.71614], [-122.05389, 37.716], [-122.05378, 37.71565], [-122.05375, 37.71565], [-122.05376, 37.71549], [-122.05383, 37.71522], [-122.05398, 37.71503], [-122.0545, 37.71473], [-122.05467, 37.7146], [-122.0548, 37.71446], [-122.05495, 37.7143], [-122.05504, 37.71406], [-122.05507, 37.71391], [-122.05507, 37.71358], [-122.05504, 37.71326], [-122.05504, 37.71298], [-122.05499, 37.71279], [-122.05499, 37.71255], [-122.05496, 37.71232], [-122.05497, 37.71216], [-122.05505, 37.71182], [-122.05508, 37.71139], [-122.05507, 37.71111], [-122.05478, 37.71026], [-122.05465, 37.70995], [-122.05453, 37.70953], [-122.05449, 37.70925], [-122.05449, 37.70908], [-122.05454, 37.70883], [-122.05467, 37.70849], [-122.05467, 37.70834], [-122.0548, 37.70793], [-122.05491, 37.70744], [-122.05486, 37.70718], [-122.05481, 37.70703], [-122.05475, 37.70686], [-122.05466, 37.70675], [-122.0545, 37.70637], [-122.05446, 37.70615], [-122.05441, 37.70602], [-122.05441, 37.70586], [-122.05443, 37.70571], [-122.05453, 37.70544], [-122.05472, 37.7052], [-122.05496, 37.70468], [-122.05515, 37.70402], [-122.05517, 37.70387], [-122.05687, 37.70404], [-122.05721, 37.7049], [-122.05741, 37.7059], [-122.05671, 37.70631], [-122.05715, 37.70716], [-122.0571, 37.70749], [-122.05861, 37.70765], [-122.05855, 37.7082], [-122.05813, 37.70821], [-122.05771, 37.70818], [-122.05763, 37.70871], [-122.0579, 37.70874], [-122.05791, 37.70878], [-122.05803, 37.7088], [-122.05824, 37.70892], [-122.05839, 37.70898], [-122.05855, 37.70912], [-122.05853, 37.70915], [-122.05849, 37.70913], [-122.0584, 37.70923], [-122.05843, 37.70926], [-122.05789, 37.70988], [-122.05846, 37.71022], [-122.05884, 37.7105], [-122.05906, 37.71074], [-122.05911, 37.71084], [-122.05922, 37.71098], [-122.05924, 37.7111], [-122.05982, 37.71124], [-122.05994, 37.71115], [-122.06051, 37.71121], [-122.06054, 37.71153]]]} | Open Access 1 | 43107 | Cull Canyon Regional Recreation Area | 3247 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/cull_canyon | Alameda 17 | 109.685 | Cull Canyon Reg. Rec. Area | 1964 | Local Recreation Area 3 | 4 |
16864 | 16864 | 16863 | {"type": "MultiPolygon", "coordinates": [[[[-122.0584, 37.72949], [-122.05756, 37.72994], [-122.05711, 37.7304], [-122.05695, 37.73082], [-122.05697, 37.73149], [-122.05711, 37.73173], [-122.05651, 37.73213], [-122.05596, 37.73273], [-122.05588, 37.73327], [-122.05611, 37.73362], [-122.05153, 37.73277], [-122.05151, 37.73254], [-122.05146, 37.73241], [-122.05134, 37.73217], [-122.05116, 37.7319], [-122.05095, 37.73149], [-122.05095, 37.73138], [-122.05102, 37.7312], [-122.05116, 37.73105], [-122.05124, 37.73094], [-122.05128, 37.73076], [-122.05127, 37.73027], [-122.05131, 37.73012], [-122.05149, 37.72987], [-122.05164, 37.72972], [-122.05182, 37.72958], [-122.05206, 37.72933], [-122.05215, 37.72921], [-122.0523, 37.72893], [-122.05227, 37.72871], [-122.05216, 37.72828], [-122.05215, 37.72812], [-122.05216, 37.728], [-122.05221, 37.72786], [-122.05227, 37.72782], [-122.05224, 37.72773], [-122.05227, 37.72757], [-122.0524, 37.72727], [-122.05243, 37.72712], [-122.05243, 37.72684], [-122.0524, 37.72669], [-122.05217, 37.7262], [-122.05208, 37.72588], [-122.05206, 37.72575], [-122.05208, 37.72561], [-122.05206, 37.72545], [-122.05209, 37.72517], [-122.05208, 37.72489], [-122.05203, 37.72443], [-122.05198, 37.72426], [-122.05193, 37.72387], [-122.05192, 37.72366], [-122.05198, 37.72344], [-122.05206, 37.72332], [-122.05218, 37.72325], [-122.05227, 37.72307], [-122.0524, 37.72291], [-122.05276, 37.72232], [-122.05309, 37.72159], [-122.05344, 37.72061], [-122.05363, 37.7199], [-122.05385, 37.71914], [-122.05391, 37.71901], [-122.05395, 37.71878], [-122.05393, 37.71867], [-122.05395, 37.71855], [-122.05396, 37.71836], [-122.05412, 37.71801], [-122.05428, 37.71772], [-122.05428, 37.71748], [-122.05426, 37.71736], [-122.05404, 37.71695], [-122.05396, 37.71684], [-122.05388, 37.71659], [-122.05385, 37.71647], [-122.05385, 37.71618], [-122.0559, 37.71652], [-122.05547, 37.71699], [-122.05608, 37.71786], [-122.05547, 37.71815], [-122.05684, 37.72014], [-122.05642, 37.72051], [-122.05628, 37.722], [-122.05645, 37.72212], [-122.05645, 37.72222], [-122.05726, 37.72286], [-122.0576, 37.72411], [-122.05735, 37.7244], [-122.05726, 37.72432], [-122.0571, 37.7242], [-122.05681, 37.72404], [-122.05663, 37.72398], [-122.05648, 37.72397], [-122.05634, 37.72394], [-122.05602, 37.72396], [-122.05596, 37.72399], [-122.05581, 37.72398], [-122.05544, 37.72452], [-122.0554, 37.72496], [-122.05572, 37.72534], [-122.05606, 37.72545], [-122.0574, 37.72649], [-122.05731, 37.72704], [-122.05716, 37.72713], [-122.05728, 37.72726], [-122.05726, 37.72737], [-122.057, 37.72753], [-122.05702, 37.72767], [-122.05825, 37.72891], [-122.05833, 37.72907], [-122.0584, 37.72949]]], [[[-122.06542, 37.72054], [-122.0654, 37.72096], [-122.06534, 37.72128], [-122.06506, 37.7223], [-122.06455, 37.72316], [-122.06456, 37.72317], [-122.06447, 37.72443], [-122.06427, 37.72563], [-122.06277, 37.73329], [-122.06164, 37.73527], [-122.0615, 37.73677], [-122.06103, 37.73876], [-122.05812, 37.7351], [-122.05844, 37.73494], [-122.05835, 37.7345], [-122.05929, 37.73498], [-122.06011, 37.73458], [-122.06077, 37.73415], [-122.06095, 37.7338], [-122.06111, 37.73371], [-122.06191, 37.73334], [-122.06174, 37.73312], [-122.06178, 37.73309], [-122.06135, 37.73234], [-122.06151, 37.73229], [-122.06155, 37.7318], [-122.0608, 37.73048], [-122.06077, 37.73048], [-122.06075, 37.73045], [-122.06043, 37.7305], [-122.0599, 37.73053], [-122.05982, 37.73028], [-122.0598, 37.7301], [-122.06009, 37.72989], [-122.06059, 37.72963], [-122.06069, 37.72943], [-122.06054, 37.72924], [-122.06042, 37.72903], [-122.06065, 37.72872], [-122.0608, 37.72861], [-122.06144, 37.72907], [-122.06173, 37.72895], [-122.06234, 37.72862], [-122.06262, 37.72843], [-122.06281, 37.72824], [-122.06289, 37.72811], [-122.06293, 37.72799], [-122.06291, 37.72798], [-122.06282, 37.72807], [-122.06241, 37.7268], [-122.06174, 37.72609], [-122.06212, 37.72514], [-122.06172, 37.72455], [-122.06176, 37.72453], [-122.06176, 37.72451], [-122.0612, 37.72441], [-122.06174, 37.72444], [-122.06265, 37.724], [-122.06262, 37.72394], [-122.06222, 37.72347], [-122.06226, 37.72343], [-122.06218, 37.72332], [-122.06246, 37.72329], [-122.06268, 37.72312], [-122.06267, 37.72327], [-122.06431, 37.72316], [-122.06484, 37.7208], [-122.06484, 37.72078], [-122.06479, 37.72078], [-122.06487, 37.72049], [-122.06491, 37.72049], [-122.06492, 37.72052], [-122.06542, 37.72054]]]]} | Open Access 1 | 15150 | Cull Canyon Regional Recreation Area | 3247 | 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/cull_canyon | Alameda 17 | 245.944 | Cull Canyon Reg. Rec. Area | 1964 | Local Recreation Area 3 | 4 |
9983 | 9983 | 9982 | {"type": "Polygon", "coordinates": [[[-122.26941, 37.95602], [-122.26837, 37.95734], [-122.26599, 37.95498], [-122.26344, 37.95587], [-122.26117, 37.9548], [-122.25983, 37.95454], [-122.25946, 37.95486], [-122.25818, 37.95369], [-122.25423, 37.94996], [-122.25637, 37.94855], [-122.25637, 37.94854], [-122.25595, 37.94817], [-122.25938, 37.94547], [-122.25949, 37.94554], [-122.2597, 37.94571], [-122.25984, 37.94571], [-122.25994, 37.94566], [-122.26004, 37.94558], [-122.2666, 37.94626], [-122.26733, 37.94758], [-122.26754, 37.94784], [-122.26408, 37.94964], [-122.26424, 37.94986], [-122.26431, 37.95017], [-122.26465, 37.95013], [-122.2647, 37.95039], [-122.26638, 37.95045], [-122.26638, 37.95097], [-122.26555, 37.95135], [-122.26489, 37.95103], [-122.26445, 37.95156], [-122.26422, 37.95236], [-122.26577, 37.95294], [-122.26736, 37.95407], [-122.26771, 37.95451], [-122.26812, 37.95439], [-122.26893, 37.95492], [-122.26888, 37.95506], [-122.26876, 37.95561], [-122.26941, 37.95602]]]} | Open Access 1 | 17172 | Kennedy Grove Regional Recreation Area | 3271 | 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/kennedy | Contra Costa 12 | 217.875 | Kennedy Grove Reg. Rec. Area | 1967 | Local Recreation Area 3 | 4 |
16638 | 16638 | 16637 | {"type": "MultiPolygon", "coordinates": [[[[-121.68009, 37.56802], [-121.68007, 37.57196], [-121.67069, 37.57206], [-121.67068, 37.57153], [-121.67092, 37.56801], [-121.68009, 37.56802]]], [[[-121.75246, 37.62111], [-121.7509, 37.62112], [-121.74958, 37.62186], [-121.74837, 37.62184], [-121.74806, 37.62246], [-121.74691, 37.62312], [-121.74699, 37.62353], [-121.74526, 37.62599], [-121.74283, 37.62803], [-121.74131, 37.62789], [-121.74099, 37.62211], [-121.73255, 37.62201], [-121.72876, 37.61978], [-121.72583, 37.61775], [-121.72459, 37.61429], [-121.72235, 37.60768], [-121.72202, 37.60661], [-121.71757, 37.60609], [-121.71465, 37.60075], [-121.70746, 37.60051], [-121.70274, 37.60031], [-121.69821, 37.60029], [-121.6969, 37.60016], [-121.69481, 37.60002], [-121.68929, 37.59975], [-121.68806, 37.60524], [-121.68772, 37.60502], [-121.68755, 37.60487], [-121.68735, 37.60465], [-121.68719, 37.60441], [-121.6871, 37.60422], [-121.68703, 37.60403], [-121.68698, 37.60376], [-121.68698, 37.60355], [-121.687, 37.60335], [-121.68705, 37.60315], [-121.68712, 37.60296], [-121.68722, 37.60277], [-121.68734, 37.60259], [-121.68749, 37.60242], [-121.68852, 37.60137], [-121.68868, 37.60116], [-121.68882, 37.60093], [-121.68895, 37.60057], [-121.68905, 37.59996], [-121.68916, 37.59976], [-121.68915, 37.59974], [-121.68908, 37.59974], [-121.68907, 37.59964], [-121.68913, 37.5994], [-121.68924, 37.59917], [-121.68967, 37.59852], [-121.68977, 37.5983], [-121.68982, 37.59812], [-121.68983, 37.59793], [-121.68982, 37.59774], [-121.68977, 37.59756], [-121.68966, 37.59734], [-121.68921, 37.59661], [-121.69368, 37.59664], [-121.69366, 37.59323], [-121.68823, 37.59339], [-121.68825, 37.59314], [-121.68843, 37.59202], [-121.68842, 37.59178], [-121.68836, 37.59155], [-121.68825, 37.59133], [-121.68805, 37.59109], [-121.68789, 37.59095], [-121.68733, 37.59055], [-121.68714, 37.59037], [-121.68705, 37.59023], [-121.68698, 37.59009], [-121.68694, 37.58997], [-121.68691, 37.5898], [-121.68693, 37.58959], [-121.68763, 37.58629], [-121.68796, 37.58607], [-121.68796, 37.58606], [-121.68035, 37.58639], [-121.68036, 37.56411], [-121.6895, 37.56405], [-121.68904, 37.56571], [-121.68899, 37.56577], [-121.69498, 37.56996], [-121.70798, 37.57891], [-121.71095, 37.58324], [-121.71589, 37.5859], [-121.71967, 37.58835], [-121.72581, 37.59067], [-121.73422, 37.59831], [-121.7459, 37.60902], [-121.74736, 37.61049], [-121.74896, 37.61319], [-121.74962, 37.61621], [-121.74793, 37.61702], [-121.74793, 37.61704], [-121.74834, 37.61757], [-121.74891, 37.61788], [-121.75182, 37.61916], [-121.7518, 37.6192], [-121.7515, 37.62024], [-121.75246, 37.62111]], [[-121.74972, 37.62053], [-121.75031, 37.61969], [-121.74918, 37.6192], [-121.7486, 37.62004], [-121.74972, 37.62053]]]]} | Open Access 1 | 47527 | Lake Del Valle State Recreation Area | 31232 | 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.parks.ca.gov/?page_id=537 | Alameda 17 | 3851.412 | Lake Del Valle SRA | 1967 | Local Recreation Area 3 | 4 |
16865 | 16865 | 16864 | {"type": "Polygon", "coordinates": [[[-122.05729, 37.69054], [-122.05732, 37.69085], [-122.05729, 37.69148], [-122.05633, 37.69209], [-122.05634, 37.6921], [-122.05717, 37.69218], [-122.05717, 37.69221], [-122.05697, 37.6922], [-122.05678, 37.69223], [-122.05659, 37.69231], [-122.05652, 37.6924], [-122.05651, 37.69247], [-122.05681, 37.69276], [-122.05683, 37.69285], [-122.054, 37.69283], [-122.05267, 37.69268], [-122.05186, 37.69251], [-122.05066, 37.6925], [-122.04958, 37.69254], [-122.04867, 37.69261], [-122.04792, 37.69283], [-122.04737, 37.69305], [-122.04695, 37.69323], [-122.04462, 37.69495], [-122.04445, 37.69518], [-122.0443, 37.69495], [-122.04441, 37.69486], [-122.0444, 37.69484], [-122.04436, 37.69484], [-122.04435, 37.69471], [-122.04447, 37.69457], [-122.04474, 37.69442], [-122.04516, 37.69407], [-122.04494, 37.69362], [-122.04498, 37.69344], [-122.04451, 37.69339], [-122.0444, 37.69311], [-122.04449, 37.69281], [-122.04454, 37.69281], [-122.04455, 37.6928], [-122.04437, 37.69253], [-122.04448, 37.69232], [-122.04501, 37.69184], [-122.0468, 37.69227], [-122.04681, 37.69226], [-122.04649, 37.69079], [-122.04436, 37.68999], [-122.0459, 37.68885], [-122.04634, 37.68978], [-122.04766, 37.69015], [-122.04857, 37.69003], [-122.04902, 37.69009], [-122.04925, 37.69005], [-122.04971, 37.68979], [-122.0496, 37.68951], [-122.05131, 37.68901], [-122.05114, 37.68863], [-122.05124, 37.68858], [-122.05202, 37.69024], [-122.0525, 37.69017], [-122.05276, 37.68967], [-122.05267, 37.6895], [-122.05299, 37.6894], [-122.05313, 37.68929], [-122.05364, 37.68902], [-122.05376, 37.68926], [-122.05485, 37.68961], [-122.05486, 37.6896], [-122.05485, 37.68952], [-122.05486, 37.68945], [-122.05493, 37.68947], [-122.05512, 37.68946], [-122.05515, 37.6897], [-122.05513, 37.6897], [-122.05511, 37.68989], [-122.0562, 37.68985], [-122.05698, 37.69056], [-122.05729, 37.69054]]]} | Open Access 1 | 49046 | Don Castro Regional Recreation Area | 18199 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | https://www.ebparks.org/parks/don_castro/ | Alameda 17 | 91.383 | Don Castro Reg. Rec. Area | 1969 | Local Recreation Area 3 | 4 |
6007 | 6007 | 6006 | {"type": "Polygon", "coordinates": [[[-121.85372, 37.67067], [-121.84528, 37.67162], [-121.84527, 37.67159], [-121.83346, 37.67283], [-121.83347, 37.66804], [-121.83003, 37.6675], [-121.83007, 37.66576], [-121.83764, 37.66573], [-121.84017, 37.66573], [-121.84066, 37.66594], [-121.84179, 37.66599], [-121.84221, 37.66575], [-121.84532, 37.66574], [-121.84531, 37.66757], [-121.84781, 37.6683], [-121.84917, 37.6683], [-121.85004, 37.66837], [-121.85104, 37.66906], [-121.85107, 37.66961], [-121.85181, 37.66963], [-121.8524, 37.66936], [-121.85336, 37.66841], [-121.85372, 37.67067]]]} | Open Access 1 | 690 | Shadow Cliffs Regional Recreation Area | 3312 | 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/shadow_cliffs | Alameda 17 | 253.728 | Shadow Cliffs Reg. Rec. Area | 1971 | Local Recreation Area 3 | 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]);