units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
123 rows where AGNCY_NAME = 89 and MNG_AGENCY = 87 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, GAP_STS
DES_TP 16
- Local Park 53
- Local Conservation Area 36
- Local Recreation Area 20
- Local Resource Management Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
- Open Access 71
- No Public Access 39
- Restricted Access 13
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 123 ✖
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 | |||
6579 | 6579 | 6578 | {"type": "Polygon", "coordinates": [[[-122.00373, 37.76975], [-122.00325, 37.76996], [-122.00269, 37.77028], [-122.00215, 37.77041], [-122.00191, 37.77061], [-122.00165, 37.77101], [-122.00127, 37.77147], [-122.00085, 37.77183], [-122.00119, 37.77061], [-122.00129, 37.7703], [-122.00161, 37.77011], [-122.00179, 37.76986], [-122.0018, 37.76926], [-122.00185, 37.7692], [-122.00178, 37.76841], [-122.00137, 37.76813], [-122.00051, 37.76805], [-121.99997, 37.76845], [-121.99925, 37.76789], [-121.99863, 37.76767], [-121.9985, 37.76746], [-121.99807, 37.76732], [-121.99787, 37.76713], [-121.99794, 37.76655], [-121.99769, 37.76609], [-121.99777, 37.76583], [-121.99772, 37.76579], [-121.99705, 37.76618], [-121.99718, 37.76706], [-121.99692, 37.76774], [-121.99579, 37.76749], [-121.99604, 37.76691], [-121.99592, 37.76624], [-121.99563, 37.76595], [-121.99481, 37.76636], [-121.99461, 37.76817], [-121.9942, 37.76856], [-121.99265, 37.76609], [-121.99661, 37.76551], [-121.99928, 37.76518], [-122.00373, 37.76975]]]} | Restricted Access 2 | 5342 | Calaveras Ridge Trail - land bank | 16671 | 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 | 43.362 | Calaveras Ridge Trail - land bank | None 529 | |||
9716 | 9716 | 9715 | {"type": "Polygon", "coordinates": [[[-122.04308, 37.68652], [-122.04287, 37.68656], [-122.04248, 37.68602], [-122.04086, 37.68619], [-122.04068, 37.68582], [-122.04091, 37.68578], [-122.04109, 37.68544], [-122.041, 37.68517], [-122.04087, 37.68423], [-122.04073, 37.68369], [-122.04069, 37.68286], [-122.04054, 37.682], [-122.04028, 37.68125], [-122.03894, 37.68066], [-122.03881, 37.68017], [-122.03817, 37.68023], [-122.03824, 37.67969], [-122.03637, 37.68023], [-122.03604, 37.67954], [-122.03614, 37.67873], [-122.03264, 37.67776], [-122.03309, 37.67686], [-122.0338, 37.67677], [-122.0343, 37.67623], [-122.03509, 37.67612], [-122.03518, 37.67667], [-122.03535, 37.67714], [-122.03573, 37.67764], [-122.03624, 37.67795], [-122.03704, 37.67824], [-122.03739, 37.67839], [-122.03772, 37.67857], [-122.03834, 37.67893], [-122.03878, 37.67871], [-122.03935, 37.679], [-122.04008, 37.67865], [-122.04036, 37.67781], [-122.04075, 37.6793], [-122.04214, 37.68386], [-122.04308, 37.68652]]]} | Restricted Access 2 | 16446 | Five Canyons trail corridor | 18933 | 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 | 50.693 | Five Canyons trail corridor | None 839 | |||
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 | |||
12425 | 12425 | 12424 | {"type": "Polygon", "coordinates": [[[-121.78716, 37.9022], [-121.78714, 37.90506], [-121.78662, 37.90505], [-121.78557, 37.90565], [-121.78226, 37.90482], [-121.78227, 37.90345], [-121.76905, 37.90344], [-121.76913, 37.89641], [-121.76972, 37.89669], [-121.76993, 37.89677], [-121.77015, 37.89683], [-121.77181, 37.89707], [-121.77214, 37.8971], [-121.77244, 37.8971], [-121.77273, 37.89708], [-121.77303, 37.89703], [-121.77331, 37.89696], [-121.77378, 37.8968], [-121.77421, 37.89671], [-121.77465, 37.89669], [-121.77509, 37.89674], [-121.7753, 37.8968], [-121.78181, 37.89908], [-121.78224, 37.89927], [-121.78336, 37.89983], [-121.7837, 37.90003], [-121.78607, 37.90182], [-121.78627, 37.90193], [-121.78648, 37.90203], [-121.78671, 37.9021], [-121.78716, 37.9022]]]} | No Public Access 3 | 27031 | Deer Valley | 18002 | 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 | 242.118 | Deer Valley | None 1078 | |||
12728 | 12728 | 12727 | {"type": "Polygon", "coordinates": [[[-122.18401, 37.84685], [-122.17947, 37.84688], [-122.17946, 37.85048], [-122.17489, 37.85051], [-122.1749, 37.84692], [-122.17435, 37.84691], [-122.17419, 37.8454], [-122.17415, 37.84419], [-122.17411, 37.84379], [-122.17363, 37.84333], [-122.17333, 37.84267], [-122.17289, 37.84198], [-122.17044, 37.84099], [-122.17043, 37.83987], [-122.17502, 37.8398], [-122.17621, 37.83749], [-122.17795, 37.83805], [-122.17809, 37.8378], [-122.17909, 37.83812], [-122.17949, 37.83827], [-122.1795, 37.83974], [-122.18065, 37.83972], [-122.18068, 37.84008], [-122.18243, 37.84034], [-122.1829, 37.84031], [-122.18397, 37.8404], [-122.18401, 37.84685]]]} | No Public Access 3 | 29754 | Sibley | 25436 | 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 | 241.744 | Sibley | None 1115 | |||
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 | |
3486 | 3486 | 3485 | {"type": "Polygon", "coordinates": [[[-122.04254, 37.69324], [-122.04258, 37.69353], [-122.04254, 37.69359], [-122.04245, 37.69363], [-122.04168, 37.69356], [-122.04021, 37.69367], [-122.04031, 37.69501], [-122.0398, 37.6962], [-122.03857, 37.69573], [-122.03373, 37.69642], [-122.03244, 37.69557], [-122.0294, 37.69336], [-122.02923, 37.6932], [-122.02911, 37.69298], [-122.02965, 37.69307], [-122.03009, 37.6934], [-122.03051, 37.69331], [-122.03084, 37.69344], [-122.03097, 37.69365], [-122.03108, 37.69367], [-122.03129, 37.69369], [-122.03163, 37.69355], [-122.03186, 37.69322], [-122.03235, 37.69309], [-122.03281, 37.69308], [-122.03302, 37.69322], [-122.03334, 37.69316], [-122.03333, 37.69293], [-122.03356, 37.69289], [-122.03402, 37.69255], [-122.03407, 37.69237], [-122.03435, 37.69371], [-122.04, 37.69298], [-122.04254, 37.69324]]]} | No Public Access 3 | 46879 | Chabot - Garin Trail Corridor | 30360 | 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 | 63.522 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
3558 | 3558 | 3557 | {"type": "Polygon", "coordinates": [[[-122.34141, 37.899], [-122.33912, 37.89903], [-122.33911, 37.89846], [-122.3414, 37.89842], [-122.34141, 37.899]]]} | No Public Access 3 | 15364 | Brooks Island Regional Preserve | 31524 | 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 | 3.177 | Brooks Island RPr | 0 | Local Conservation Area 4 | 2 | |
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 | |
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 | |
4298 | 4298 | 4297 | {"type": "MultiPolygon", "coordinates": [[[[-121.97565, 37.70051], [-121.97562, 37.70061], [-121.97543, 37.70073], [-121.97507, 37.70044], [-121.97405, 37.69985], [-121.97434, 37.69948], [-121.9747, 37.69968], [-121.975, 37.69989], [-121.97538, 37.70022], [-121.97565, 37.70051]]], [[[-121.98765, 37.73258], [-121.98688, 37.73201], [-121.97964, 37.7298], [-121.9786, 37.72967], [-121.97859, 37.72783], [-121.97863, 37.72405], [-121.9862, 37.72382], [-121.98624, 37.72657], [-121.98763, 37.72776], [-121.98761, 37.73085], [-121.98765, 37.73258]]]]} | Restricted Access 2 | 45337 | Dublin Hills Regional Park | 18292 | 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 | 142.3 | Dublin Hills RP | 0 | Local Park 2 | 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 | |
4940 | 4940 | 4939 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | 10715 | Chabot - Garin Trail Corridor | 17108 | 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 | 0.064 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
5607 | 5607 | 5606 | {"type": "Polygon", "coordinates": [[[-121.99805, 37.90236], [-121.99346, 37.90195], [-121.99291, 37.90125], [-121.99278, 37.90102], [-121.9927, 37.90078], [-121.9926, 37.9006], [-121.99246, 37.90043], [-121.99237, 37.90036], [-121.99218, 37.90024], [-121.99085, 37.89958], [-121.99095, 37.89942], [-121.99097, 37.89941], [-121.99251, 37.89731], [-121.99359, 37.8979], [-121.99572, 37.89966], [-121.99752, 37.89939], [-121.99805, 37.90236]]]} | No Public Access 3 | 46993 | Diablo Foothills Regional Park | 30631 | 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 | 46.446 | Diablo Foothills RP | 0 | Local Park 2 | 4 | |
7544 | 7544 | 7543 | {"type": "Polygon", "coordinates": [[[-122.26096, 37.96074], [-122.26068, 37.96086], [-122.2605, 37.96097], [-122.26032, 37.96109], [-122.26017, 37.96122], [-122.26003, 37.96137], [-122.25992, 37.96152], [-122.25947, 37.96216], [-122.25935, 37.96227], [-122.25923, 37.96234], [-122.25911, 37.96238], [-122.25547, 37.96311], [-122.25517, 37.9632], [-122.25478, 37.96335], [-122.25275, 37.95999], [-122.25186, 37.96017], [-122.24908, 37.95619], [-122.24757, 37.95482], [-122.25188, 37.95185], [-122.26096, 37.96074]]]} | Restricted Access 2 | 47610 | Bay Area Ridge Trail Land Bank | 31342 | 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 | 166.102 | Bay Area Ridge Trail Land Bank | 0 | Local Resource Management Area 83 | 3 |
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]);