units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
210 rows where ACCESS_TYP = 2 and DES_TP = 2 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, COUNTY, YR_EST
MNG_AGENCY >30
- Whittier, City of 20
- Los Angeles Unified School District 15
- San Ramon, City of 13
- Los Angeles, City of 7
- East Bay Regional Park District 7
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Beverly Hills, City of 5
- San Diego, City of 4
- Fullerton, City of 4
- Vacaville, City of 4
- Hollister, City of 4
- Hayward Area Recreation and Park District 4
- Pasadena, City of 4
- Lawndale, City of 4
- Modesto, City of 4
- Azusa Unified School District 4
- Glendora, City of 3
- Carlsbad, City of 3
- Palmdale, City of 3
- Mountain View, City of 3
- Conejo Valley Unified School District 3
- Los Angeles, County of 2
- Garden Grove, City of 2
- Oceanside, City of 2
- Orange, County of 2
- Lake Elsinore, City of 2
- Cerritos, City of 2
- Bell Gardens, City of 2
- Long Beach, City of 2
- …
MNG_AG_TYP 7
DES_TP 1
- Local Park · 210 ✖
ACCESS_TYP 1
- Restricted Access · 210 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11534 | 11534 | 11533 | {"type": "Polygon", "coordinates": [[[-118.26649, 33.96746], [-118.26648, 33.96797], [-118.26529, 33.96796], [-118.26529, 33.96746], [-118.26649, 33.96746]]]} | Restricted Access 2 | 46864 | Freemont High School Wellness Center and Community Garden | 30341 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | Los Angeles 6 | 1.529 | Freemont High School Wellness Ctr. and Community Garden | 2012 | Local Park 2 | 4 | |
5761 | 5761 | 5760 | {"type": "Polygon", "coordinates": [[[-121.73224, 38.009], [-121.72985, 38.00901], [-121.72986, 38.02204], [-121.72942, 38.0223], [-121.72882, 38.02348], [-121.72786, 38.02508], [-121.7259, 38.02528], [-121.72399, 38.02519], [-121.72168, 38.02469], [-121.71852, 38.02368], [-121.71627, 38.02245], [-121.71439, 38.02186], [-121.71255, 38.02172], [-121.71147, 38.0212], [-121.71065, 38.0207], [-121.71014, 38.02044], [-121.7097, 38.02031], [-121.70885, 38.02016], [-121.70831, 38.02019], [-121.70788, 38.02032], [-121.70758, 38.02052], [-121.70735, 38.02087], [-121.70732, 38.02113], [-121.70732, 38.02145], [-121.7073, 38.02177], [-121.70713, 38.02207], [-121.70633, 38.02281], [-121.70546, 38.02315], [-121.70491, 38.02345], [-121.70413, 38.02397], [-121.70358, 38.02428], [-121.7029, 38.0245], [-121.70128, 38.02488], [-121.70062, 38.02507], [-121.69988, 38.02523], [-121.69909, 38.02534], [-121.69737, 38.02549], [-121.69672, 38.02563], [-121.69574, 38.02579], [-121.69543, 38.02581], [-121.69518, 38.02575], [-121.69395, 38.02506], [-121.69341, 38.02479], [-121.69274, 38.02442], [-121.69138, 38.02371], [-121.691, 38.02343], [-121.6908, 38.02323], [-121.69073, 38.02304], [-121.69056, 38.0221], [-121.69029, 38.02141], [-121.69007, 38.02108], [-121.68936, 38.02036], [-121.68882, 38.01995], [-121.68778, 38.0189], [-121.68732, 38.01838], [-121.68656, 38.01785], [-121.68638, 38.01768], [-121.68615, 38.01752], [-121.686, 38.01726], [-121.68594, 38.01701], [-121.68601, 38.01673], [-121.68602, 38.01649], [-121.68611, 38.01619], [-121.68619, 38.01602], [-121.68605, 38.01575], [-121.68589, 38.0156], [-121.6857, 38.01556], [-121.68534, 38.01561], [-121.68498, 38.01572], [-121.68549, 38.01535], [-121.68564, 38.01515], [-121.68575, 38.0148], [-121.68573, 38.0146], [-121.68567, 38.01441], [-121.68554, 38.01418], [-121.68499, 38.01365], [-121.68476, 38.01351], [-121.68616, 38.01353], [-121.68808, 38.0132], [-121.68885, 38.01329], [-121.68932, 38.01338], [-121.68975, 38.01329], [-121.69037, 38.01241], [-121.69042, 38.01202], [-121.69041, 38.01184], [-121.69057, 38.01169], [-121.69083, 38.01152], [-121.6909, 38.01129], [-121.69092, 38.01111], [-121.69102, 38.01082], [-121.69121, 38.01057], [-121.69104, 38.01036], [-121.69106, 38.01024], [-121.69101, 38.01008], [-121.691, 38.00933], [-121.69102, 38.00912], [-121.69114, 38.00835], [-121.69117, 38.00802], [-121.69131, 38.00698], [-121.6913, 38.00678], [-121.69134, 38.00615], [-121.69148, 38.00539], [-121.69171, 38.00536], [-121.69505, 38.00708], [-121.6968, 38.00734], [-121.69696, 38.00638], [-121.71159, 38.00658], [-121.71157, 38.00843], [-121.72312, 38.00845], [-121.72313, 38.00872], [-121.73224, 38.00873], [-121.73224, 38.009]]]} | Restricted Access 2 | 532 | Big Break Regional Shoreline | 31520 | 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 | 1604.429 | Big Break Reg. Shoreline | 2005 | Local Park 2 | 4 | |
3237 | 3237 | 3236 | {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} | Restricted Access 2 | 48110 | Sunflower Park | 32835 | 2422 | El Centro Elementary School District 602 | Special District 4 | School District 14 | www.ecesd.org | Special District 4 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 18.451 | Sunflower Park | 2000 | Local Park 2 | 4 |
9733 | 9733 | 9732 | {"type": "Polygon", "coordinates": [[[-122.20028, 37.35643], [-122.20024, 37.35647], [-122.19706, 37.35796], [-122.1956, 37.35913], [-122.19551, 37.35915], [-122.19283, 37.36128], [-122.19343, 37.364], [-122.19163, 37.36491], [-122.19121, 37.36486], [-122.18979, 37.36548], [-122.18785, 37.36605], [-122.18758, 37.36631], [-122.18746, 37.3668], [-122.18581, 37.36661], [-122.18362, 37.36568], [-122.1833, 37.36619], [-122.18307, 37.36647], [-122.18209, 37.36668], [-122.18172, 37.36693], [-122.18155, 37.3674], [-122.18133, 37.36761], [-122.18086, 37.36775], [-122.18039, 37.36775], [-122.17994, 37.36759], [-122.17931, 37.36763], [-122.17847, 37.36744], [-122.17787, 37.36834], [-122.17612, 37.3684], [-122.17396, 37.37054], [-122.17031, 37.37008], [-122.17135, 37.36699], [-122.17198, 37.36518], [-122.17335, 37.36092], [-122.17368, 37.36063], [-122.1744, 37.36062], [-122.17451, 37.36045], [-122.17473, 37.36023], [-122.17521, 37.35985], [-122.17572, 37.35871], [-122.17541, 37.35837], [-122.17478, 37.35829], [-122.1746, 37.35829], [-122.17433, 37.35832], [-122.17417, 37.35828], [-122.17865, 37.34535], [-122.18261, 37.33356], [-122.18261, 37.33335], [-122.18272, 37.333], [-122.18278, 37.33298], [-122.18293, 37.33313], [-122.18307, 37.33336], [-122.18316, 37.3336], [-122.18354, 37.33423], [-122.18396, 37.33471], [-122.18422, 37.33493], [-122.18425, 37.33503], [-122.18425, 37.33511], [-122.18433, 37.33527], [-122.18455, 37.33559], [-122.18472, 37.33589], [-122.18511, 37.33643], [-122.18569, 37.33745], [-122.18575, 37.33774], [-122.18573, 37.33808], [-122.18575, 37.33829], [-122.1858, 37.33847], [-122.18587, 37.33862], [-122.18598, 37.33872], [-122.18642, 37.33897], [-122.18674, 37.33917], [-122.18701, 37.33938], [-122.18755, 37.33983], [-122.18816, 37.34023], [-122.18896, 37.34079], [-122.18981, 37.34152], [-122.19022, 37.34193], [-122.19054, 37.34227], [-122.19063, 37.34234], [-122.19078, 37.34256], [-122.19104, 37.34304], [-122.19123, 37.34331], [-122.19132, 37.3434], [-122.19172, 37.34369], [-122.19225, 37.34397], [-122.19245, 37.34411], [-122.19334, 37.34485], [-122.19415, 37.34572], [-122.19477, 37.34656], [-122.19495, 37.34674], [-122.19507, 37.3469], [-122.19527, 37.34727], [-122.19537, 37.34737], [-122.19573, 37.34791], [-122.19587, 37.34819], [-122.19587, 37.34861], [-122.19583, 37.3488], [-122.19585, 37.34915], [-122.19597, 37.3496], [-122.19595, 37.34979], [-122.19585, 37.34997], [-122.19578, 37.35027], [-122.19576, 37.35063], [-122.19589, 37.35103], [-122.19597, 37.35123], [-122.19616, 37.35138], [-122.19628, 37.35152], [-122.19681, 37.35201], [-122.19698, 37.35212], [-122.19724, 37.35244], [-122.19734, 37.35259], [-122.19748, 37.35297], [-122.19769, 37.35325], [-122.19788, 37.35361], [-122.19802, 37.35406], [-122.19823, 37.35432], [-122.19849, 37.35445], [-122.19866, 37.35465], [-122.19887, 37.35483], [-122.1992, 37.35517], [-122.19939, 37.35529], [-122.19955, 37.35533], [-122.19972, 37.35545], [-122.19997, 37.35579], [-122.20002, 37.35596], [-122.20014, 37.35615], [-122.20028, 37.35643]]]} | Restricted Access 2 | 16498 | Foothills Park | 18984 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1303.372 | Foothills Park | 2000 | Local Park 2 | 4 | |
11333 | 11333 | 11332 | {"type": "Polygon", "coordinates": [[[-120.23597, 37.96677], [-120.23585, 37.96674], [-120.23549, 37.9667], [-120.23553, 37.96647], [-120.2356, 37.96631], [-120.2357, 37.96629], [-120.23571, 37.96618], [-120.2358, 37.96617], [-120.23586, 37.9663], [-120.23597, 37.96677]]]} | Restricted Access 2 | 48057 | Tuolumne Community Garden | 32549 | 2169 | Tuolumne Park and Recreation District 741 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | https://www.tuolumnerecreation.com/TPRD_facilities.html | Tuolumne 21 | 0.432 | Tuolumne Community Garden | 1996 | Local Park 2 | 4 |
12354 | 12354 | 12353 | {"type": "Polygon", "coordinates": [[[-121.96963, 38.04103], [-121.96963, 38.04434], [-121.96849, 38.0443], [-121.96622, 38.04318], [-121.96629, 38.04287], [-121.96269, 38.04202], [-121.96268, 38.03926], [-121.96963, 38.04103]]]} | Restricted Access 2 | 26080 | Bay Point Regional Shoreline | 31519 | 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 | 50.558 | Bay Point Reg. Shoreline | 1996 | Local Park 2 | 4 | |
672 | 672 | 671 | {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} | Restricted Access 2 | 5104 | 711 St. Mary's Road Park | 15210 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 1163 | Lafayette, City of 232 | City 2 | City Agency 2 | Contra Costa 12 | 11.502 | 711 St. Mary's Road Park | 1983 | Local Park 2 | 4 | |
16848 | 16848 | 16847 | {"type": "Polygon", "coordinates": [[[-122.19101, 38.04175], [-122.19099, 38.04178], [-122.19086, 38.04185], [-122.1906, 38.04191], [-122.19039, 38.04202], [-122.19028, 38.04212], [-122.19015, 38.04228], [-122.19005, 38.04237], [-122.18937, 38.04276], [-122.18914, 38.04295], [-122.18891, 38.04318], [-122.18882, 38.04325], [-122.18837, 38.04342], [-122.18829, 38.0435], [-122.18825, 38.04362], [-122.18808, 38.04355], [-122.18799, 38.0437], [-122.18818, 38.04379], [-122.18804, 38.04398], [-122.18768, 38.04405], [-122.18769, 38.04413], [-122.1875, 38.04418], [-122.18769, 38.0448], [-122.18742, 38.04484], [-122.18741, 38.04482], [-122.18723, 38.04488], [-122.18694, 38.04494], [-122.18693, 38.04493], [-122.18667, 38.04491], [-122.18666, 38.04492], [-122.18668, 38.04499], [-122.18634, 38.04507], [-122.18625, 38.04481], [-122.18572, 38.04491], [-122.18571, 38.04492], [-122.18579, 38.04516], [-122.18542, 38.04523], [-122.18542, 38.04526], [-122.1853, 38.04528], [-122.18525, 38.04516], [-122.18507, 38.0452], [-122.18506, 38.04523], [-122.18493, 38.04526], [-122.18496, 38.04535], [-122.18479, 38.04538], [-122.18476, 38.04529], [-122.18456, 38.04533], [-122.18445, 38.04524], [-122.18409, 38.04532], [-122.18348, 38.04481], [-122.18335, 38.04533], [-122.18362, 38.04556], [-122.18354, 38.04552], [-122.18336, 38.0457], [-122.1834, 38.04574], [-122.18317, 38.04592], [-122.18342, 38.04611], [-122.18335, 38.04616], [-122.18321, 38.04605], [-122.18297, 38.04623], [-122.1806, 38.04465], [-122.18023, 38.04434], [-122.17991, 38.044], [-122.17963, 38.04363], [-122.17904, 38.04266], [-122.18113, 38.04172], [-122.18334, 38.04281], [-122.18366, 38.04276], [-122.18375, 38.04237], [-122.18264, 38.04163], [-122.1839, 38.04107], [-122.18473, 38.04119], [-122.18494, 38.0412], [-122.18515, 38.04118], [-122.18572, 38.04105], [-122.18589, 38.04102], [-122.18624, 38.04102], [-122.18658, 38.04108], [-122.18686, 38.04117], [-122.1884, 38.04201], [-122.18853, 38.04206], [-122.18868, 38.0421], [-122.18884, 38.0421], [-122.18897, 38.04209], [-122.18959, 38.04199], [-122.18975, 38.04194], [-122.18988, 38.04186], [-122.19, 38.04177], [-122.19011, 38.04161], [-122.19016, 38.0415], [-122.19022, 38.04146], [-122.1903, 38.04144], [-122.19042, 38.04147], [-122.19071, 38.04165], [-122.19083, 38.04168], [-122.19094, 38.04168], [-122.19098, 38.04169], [-122.191, 38.04171], [-122.19101, 38.04175]]]} | Restricted Access 2 | 29402 | Carquinez Strait Regional Shoreline | 16904 | 3126 | Port Costa Conservation Society 1177 | Non Profit 6 | Non Profit - Conservation 12 | http://www.portcosta.com/newsletter.htm | Non Governmental Organization 10 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 76.447 | Carquinez Strait Reg. Shoreline | 1981 | Local Park 2 | 4 | |
12672 | 12672 | 12671 | {"type": "Polygon", "coordinates": [[[-122.1579, 38.02489], [-122.15653, 38.0249], [-122.15653, 38.02492], [-122.15716, 38.02516], [-122.14088, 38.02769], [-122.14074, 38.02715], [-122.13972, 38.02728], [-122.13935, 38.02633], [-122.13962, 38.02572], [-122.14132, 38.02522], [-122.1414, 38.02511], [-122.14103, 38.02493], [-122.14094, 38.02472], [-122.14094, 38.02428], [-122.1414, 38.0241], [-122.14146, 38.02396], [-122.1419, 38.02371], [-122.1421, 38.023], [-122.14233, 38.0228], [-122.14331, 38.0225], [-122.14464, 38.02239], [-122.14591, 38.02221], [-122.14632, 38.02195], [-122.1516, 38.02283], [-122.15255, 38.0231], [-122.1543, 38.02374], [-122.15431, 38.02375], [-122.15437, 38.02376], [-122.15483, 38.02393], [-122.15722, 38.02463], [-122.1579, 38.02489]]]} | Restricted Access 2 | 29625 | Martinez Regional Shoreline | 21927 | 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 | 140.251 | Martinez Reg. Shoreline | 1979 | Local Park 2 | 4 | |
3757 | 3757 | 3756 | {"type": "Polygon", "coordinates": [[[-122.27111, 38.04044], [-122.26883, 38.04296], [-122.26793, 38.04407], [-122.26606, 38.04552], [-122.26345, 38.04303], [-122.26441, 38.04222], [-122.26428, 38.04211], [-122.26434, 38.04207], [-122.26434, 38.04205], [-122.26428, 38.042], [-122.26421, 38.04204], [-122.26333, 38.04124], [-122.26342, 38.04109], [-122.26365, 38.0408], [-122.26384, 38.04059], [-122.26413, 38.04034], [-122.26445, 38.04011], [-122.2648, 38.03991], [-122.26517, 38.03974], [-122.26694, 38.04149], [-122.27043, 38.0391], [-122.27111, 38.04044]]]} | Restricted Access 2 | 466 | San Pablo Bay Regional Shoreline | 24966 | 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 | 57.631 | San Pablo Bay Reg. Shoreline | 1976 | Local Park 2 | 4 | |
15395 | 15395 | 15394 | {"type": "Polygon", "coordinates": [[[-118.39514, 33.8615], [-118.39468, 33.86158], [-118.39458, 33.86123], [-118.39504, 33.86114], [-118.39514, 33.8615]]]} | Restricted Access 2 | 46635 | Lawn Bowling Green | 29962 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=262 | Los Angeles 6 | 0.443 | Lawn Bowling Green | 1958 | Local Park 2 | 4 |
347 | 347 | 346 | {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} | Restricted Access 2 | 953 | George Manooshian Park | 29754 | 2312 | Glendora Unified School District 141 | Special District 4 | School District 14 | http://www.glendora.k12.ca.us/ | Special District 4 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 18.865 | George Manooshian Park | 0 | Local Park 2 | 4 | |
824 | 824 | 823 | {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.18411], [-118.29645, 34.18412], [-118.29561, 34.18351], [-118.2956, 34.18348], [-118.296, 34.18308], [-118.29685, 34.1837], [-118.29688, 34.18375]]]} | Restricted Access 2 | 5370 | Miller Park | 29568 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/miller-park | Los Angeles 6 | 1.599 | Miller Park | 0 | Local Park 2 | 4 |
1030 | 1030 | 1029 | {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} | Restricted Access 2 | 5646 | Friendship Park | 19120 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 3.848 | Friendship Park | 0 | Local Park 2 | 4 | |
2052 | 2052 | 2051 | {"type": "Polygon", "coordinates": [[[-122.05604, 37.67111], [-122.05571, 37.6729], [-122.05568, 37.67326], [-122.05563, 37.67337], [-122.05549, 37.67348], [-122.05533, 37.67354], [-122.05428, 37.67355], [-122.05406, 37.67328], [-122.0545, 37.67093], [-122.05604, 37.67111]]]} | Restricted Access 2 | 15627 | East Avenue School Park | 31952 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.509 | East Avenue School Park | 0 | Local Park 2 | 4 | |
2098 | 2098 | 2097 | {"type": "Polygon", "coordinates": [[[-121.89542, 37.75272], [-121.89511, 37.75373], [-121.89391, 37.75351], [-121.89423, 37.75248], [-121.89542, 37.75272]]]} | Restricted Access 2 | 47568 | Live Oak School Park | 31293 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 3.116 | Live Oak School Park | 0 | Local Park 2 | 4 | |
2216 | 2216 | 2215 | {"type": "Polygon", "coordinates": [[[-121.90955, 37.75216], [-121.90924, 37.75257], [-121.90894, 37.75304], [-121.90858, 37.75288], [-121.90819, 37.75274], [-121.90782, 37.75266], [-121.90741, 37.75261], [-121.90741, 37.7522], [-121.90735, 37.75209], [-121.90718, 37.752], [-121.90702, 37.75197], [-121.90676, 37.75208], [-121.9058, 37.75097], [-121.9068, 37.75041], [-121.90754, 37.75103], [-121.90769, 37.7511], [-121.90786, 37.75114], [-121.90802, 37.75114], [-121.90823, 37.75111], [-121.90845, 37.75099], [-121.90955, 37.75216]]]} | Restricted Access 2 | 47570 | Windemere Ranch School Park | 31295 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 11.225 | Windemere Ranch School Park | 0 | Local Park 2 | 4 | |
2245 | 2245 | 2244 | {"type": "Polygon", "coordinates": [[[-118.84354, 34.17707], [-118.84327, 34.17764], [-118.84313, 34.17791], [-118.84297, 34.17808], [-118.84271, 34.178], [-118.84174, 34.17697], [-118.84123, 34.17723], [-118.84141, 34.17751], [-118.84091, 34.17775], [-118.84047, 34.17714], [-118.84173, 34.17649], [-118.84228, 34.17687], [-118.84243, 34.17692], [-118.84354, 34.17707]]]} | Restricted Access 2 | 18017 | Beyer Park | 31603 | 2026 | Conejo Valley Unified School District 501 | Special District 4 | School District 14 | http://www.conejo.k12.ca.us/ | Special District 4 | 2026 | Conejo Valley Unified School District 493 | Special District 4 | School District 21 | Ventura 8 | 5.138 | Beyer Park | 0 | Local Park 2 | 4 | |
2754 | 2754 | 2753 | {"type": "Polygon", "coordinates": [[[-117.24499, 32.80093], [-117.24419, 32.8011], [-117.24283, 32.80145], [-117.24267, 32.80102], [-117.24251, 32.80051], [-117.24472, 32.80004], [-117.24499, 32.80093]]]} | Restricted Access 2 | 18441 | Pacific Beach Community Park | 33345 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.466 | Pacific Beach Community Park | 0 | Local Park 2 | 4 | |
2799 | 2799 | 2798 | {"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]} | Restricted Access 2 | 18582 | Clay Neighborhood Park | 31592 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.413 | Clay Neighborhood Park | 0 | Local Park 2 | 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]);