units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AGENCY = 87 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 24 ✖
DES_TP 1
- Local Recreation Area · 24 ✖
ACCESS_TYP 1
- Open Access · 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
218 | 218 | 217 | {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} | Open Access 1 | 586 | Quarry Lakes Regional Recreation Area | 30594 | 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 | 254.616 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
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 | |
9475 | 9475 | 9474 | {"type": "Polygon", "coordinates": [[[-121.99706, 37.85874], [-121.99272, 37.85889], [-121.99271, 37.85879], [-121.99179, 37.85882], [-121.99177, 37.85859], [-121.99113, 37.85861], [-121.99114, 37.85894], [-121.98799, 37.85902], [-121.98802, 37.85534], [-121.98347, 37.85552], [-121.9834, 37.85198], [-121.98093, 37.85206], [-121.98203, 37.84983], [-121.98481, 37.84974], [-121.98472, 37.84989], [-121.98475, 37.85233], [-121.98792, 37.85218], [-121.98792, 37.85182], [-121.99283, 37.85166], [-121.99236, 37.85244], [-121.99237, 37.8527], [-121.99281, 37.85361], [-121.99269, 37.85461], [-121.9942, 37.85475], [-121.99566, 37.85534], [-121.99601, 37.85511], [-121.997, 37.85504], [-121.99706, 37.85874]]]} | Open Access 1 | 17309 | Las Trampas/Diablo Regional Trail | 21069 | 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 | 174.441 | Las Trampas/Diablo Reg. Trail | 1976 | Local Recreation Area 3 | 4 | |
11508 | 11508 | 11507 | {"type": "Polygon", "coordinates": [[[-122.00857, 37.57719], [-122.00838, 37.57734], [-122.00814, 37.57765], [-122.00798, 37.57795], [-122.00791, 37.57818], [-122.00786, 37.57854], [-122.00788, 37.57885], [-122.00793, 37.5791], [-122.0079, 37.57918], [-122.00795, 37.57921], [-122.00802, 37.57938], [-122.00812, 37.57947], [-122.00685, 37.57917], [-122.00706, 37.57859], [-122.00718, 37.57861], [-122.00735, 37.57827], [-122.0076, 37.57793], [-122.00781, 37.57772], [-122.008, 37.57756], [-122.00857, 37.57719]]]} | Open Access 1 | 29555 | Quarry Lakes Regional Recreation Area | 30594 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.872 | Quarry Lakes Reg. Rec. Area | 2001 | 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 | |
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 | |
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 | |
16858 | 16858 | 16857 | {"type": "MultiPolygon", "coordinates": [[[[-121.98493, 37.5708], [-121.98481, 37.57087], [-121.98262, 37.57146], [-121.98203, 37.57131], [-121.98023, 37.57119], [-121.97789, 37.57078], [-121.9779, 37.5707], [-121.97775, 37.57068], [-121.97773, 37.57078], [-121.977, 37.57083], [-121.97696, 37.57073], [-121.98405, 37.56827], [-121.98493, 37.5708]]], [[[-121.99743, 37.56696], [-121.99723, 37.57285], [-121.99477, 37.57234], [-121.99378, 37.57157], [-121.99365, 37.57126], [-121.99304, 37.57095], [-121.99247, 37.57058], [-121.99015, 37.56877], [-121.99037, 37.56856], [-121.99004, 37.56832], [-121.99026, 37.56812], [-121.99056, 37.56788], [-121.99081, 37.56771], [-121.99114, 37.56752], [-121.9911, 37.56747], [-121.99154, 37.56722], [-121.99207, 37.56699], [-121.99205, 37.56693], [-121.99208, 37.56692], [-121.99227, 37.56709], [-121.99486, 37.56652], [-121.99505, 37.56755], [-121.99743, 37.56696]]], [[[-121.99115, 37.57124], [-121.991, 37.57166], [-121.99084, 37.57163], [-121.99073, 37.57183], [-121.99048, 37.5721], [-121.99009, 37.57282], [-121.98985, 37.57304], [-121.98934, 37.57292], [-121.98923, 37.57292], [-121.98838, 37.57274], [-121.98724, 37.5731], [-121.98639, 37.57303], [-121.98538, 37.57299], [-121.9853, 37.57301], [-121.98483, 37.5721], [-121.98514, 37.57196], [-121.98552, 37.57177], [-121.98587, 37.57157], [-121.98621, 37.57134], [-121.98653, 37.5711], [-121.98856, 37.56942], [-121.99115, 37.57124]]], [[[-122.01114, 37.57138], [-122.00593, 37.5763], [-122.00588, 37.57674], [-122.00424, 37.57807], [-122.003, 37.57733], [-122.00399, 37.57753], [-122.00402, 37.57742], [-122.00241, 37.57709], [-122.00243, 37.57698], [-122.00088, 37.57663], [-122.00167, 37.57417], [-122.00486, 37.57485], [-122.00562, 37.57243], [-122.00581, 37.57271], [-122.00605, 37.57247], [-122.00876, 37.57006], [-122.01114, 37.57138]]]]} | Open Access 1 | 46968 | Quarry Lakes Regional Recreation Area | 30594 | 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 | Alameda 17 | 204.467 | Quarry Lakes Reg. Rec. Area | 2001 | 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 | |
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 |
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 |
16857 | 16857 | 16856 | {"type": "Polygon", "coordinates": [[[-122.16525, 37.78676], [-122.16506, 37.78688], [-122.16491, 37.78714], [-122.16476, 37.78733], [-122.16457, 37.78752], [-122.16421, 37.78766], [-122.16373, 37.78763], [-122.16354, 37.78767], [-122.1629, 37.78754], [-122.16274, 37.78736], [-122.16258, 37.78761], [-122.16245, 37.78776], [-122.16234, 37.78786], [-122.16203, 37.78835], [-122.16177, 37.78857], [-122.16157, 37.78861], [-122.16137, 37.78923], [-122.16043, 37.78943], [-122.16001, 37.78928], [-122.15824, 37.78893], [-122.15759, 37.78815], [-122.15745, 37.78804], [-122.15629, 37.78755], [-122.15559, 37.78706], [-122.15504, 37.78605], [-122.15448, 37.78564], [-122.15416, 37.78575], [-122.15443, 37.78605], [-122.15217, 37.78722], [-122.15125, 37.78633], [-122.15082, 37.7865], [-122.1481, 37.78385], [-122.14729, 37.78418], [-122.14632, 37.78324], [-122.14717, 37.78258], [-122.14639, 37.78191], [-122.14535, 37.7826], [-122.1441, 37.78144], [-122.14443, 37.78126], [-122.14444, 37.78011], [-122.14421, 37.77962], [-122.14389, 37.77932], [-122.14361, 37.7788], [-122.14269, 37.77805], [-122.14293, 37.77764], [-122.14312, 37.77694], [-122.14214, 37.77641], [-122.14156, 37.77587], [-122.14158, 37.77572], [-122.14071, 37.77463], [-122.14364, 37.77317], [-122.14385, 37.77327], [-122.1436, 37.77386], [-122.14447, 37.77466], [-122.14494, 37.7756], [-122.14548, 37.77601], [-122.14569, 37.77594], [-122.14746, 37.77701], [-122.14792, 37.77762], [-122.14793, 37.77761], [-122.14774, 37.77684], [-122.14723, 37.7765], [-122.14726, 37.77641], [-122.14726, 37.77617], [-122.14639, 37.77551], [-122.14603, 37.77537], [-122.14643, 37.77506], [-122.14682, 37.77504], [-122.14742, 37.77574], [-122.15095, 37.77612], [-122.15046, 37.77682], [-122.15219, 37.77819], [-122.15346, 37.77871], [-122.15343, 37.77878], [-122.15164, 37.78013], [-122.15253, 37.78086], [-122.15355, 37.78118], [-122.15398, 37.78099], [-122.15464, 37.78148], [-122.1556, 37.78194], [-122.1555, 37.78278], [-122.15631, 37.78297], [-122.15682, 37.78317], [-122.15727, 37.78351], [-122.1581, 37.78461], [-122.15869, 37.784], [-122.1589, 37.78419], [-122.15953, 37.78446], [-122.16022, 37.78487], [-122.16076, 37.78526], [-122.16109, 37.78562], [-122.16157, 37.78596], [-122.16184, 37.7862], [-122.16259, 37.78645], [-122.16331, 37.78679], [-122.16337, 37.78696], [-122.1634, 37.78749], [-122.16382, 37.78749], [-122.16415, 37.78742], [-122.16454, 37.78728], [-122.16467, 37.78702], [-122.16473, 37.78683], [-122.16519, 37.78661], [-122.16525, 37.78676]]]} | Open Access 1 | 17344 | Leona Heights Regional Open Space | 3282 | 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/leona | Alameda 17 | 297.093 | Leona Heights Reg. OS | 1986 | 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]);