superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 8,942
- County Agency 939
- Recreation/Parks District 910
- State Agency 646
- Non Profit - Land Trust 449
- Open Space District 209
- County Agency - Parks 186
- Federal Agency 184
- Community Services District 170
- Water District 163
- Home Owners Association 142
- Non Profit - Conservation 99
- Flood District 84
- Cemetery District 54
- Non Profit - Other 33
- Port/Harbor District 30
- County Agency - Other 28
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 9
- Special District - Other 9
- Joint Powers Authority 5
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Mitigation Bank 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 409
- San Diego, City of 391
- California Department of Fish and Wildlife 304
- San Jose, City of 214
- San Francisco, City and County of 197
- Sacramento, City of 191
- California Department of Parks and Recreation 165
- Mountains Recreation and Conservation Authority 161
- Los Angeles, County of 149
- Ventura, City of 145
- Long Beach, City of 132
- Roseville, City of 117
- San Diego, County of 115
- East Bay Regional Park District 109
- Oakland, City of 102
- Irvine, City of 95
- Fresno, City of 88
- Consumnes Community Services District 83
- Santa Barbara, County of 74
- Hayward Area Recreation and Park District 73
- Stockton, City of 73
- Modesto, City of 73
- Orange, County of 71
- Torrance, City of 71
- Huntington Beach, City of 70
- Tracy, City of 67
- Santa Rosa, City of 64
- Chula Vista, City of 64
- Santa Cruz, City of 63
- Poway, City of 61
- …
ACCESS_TYP 4
- Open Access 11,542
- Restricted Access 921
- No Public Access 658
- Unknown Access 240
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2278 | 2278 | 2277 | {"type": "Polygon", "coordinates": [[[-122.00749, 37.28292], [-122.00732, 37.28324], [-122.00725, 37.28341], [-122.00677, 37.28341], [-122.00676, 37.28291], [-122.00749, 37.28292]]]} | Open Access 1 | Brookglen Park | 16421 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 0.724 | Brookglen Park | 1972 | |
2279 | 2279 | 2278 | {"type": "Polygon", "coordinates": [[[-118.05293, 33.86585], [-118.05292, 33.86593], [-118.052, 33.86618], [-118.05162, 33.86627], [-118.05118, 33.86635], [-118.0507, 33.8664], [-118.05044, 33.86625], [-118.05003, 33.86596], [-118.05033, 33.86601], [-118.05204, 33.86599], [-118.05226, 33.86597], [-118.05245, 33.86589], [-118.05277, 33.86572], [-118.05284, 33.86574], [-118.05291, 33.86578], [-118.05293, 33.86585]]]} | Open Access 1 | Brookhaven Park | 16422 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1.761 | Brookhaven Park | ||
2280 | 2280 | 2279 | {"type": "Polygon", "coordinates": [[[-117.96637, 33.84338], [-117.96522, 33.84339], [-117.96505, 33.84338], [-117.96434, 33.84339], [-117.96128, 33.84344], [-117.96128, 33.84194], [-117.96123, 33.83994], [-117.96283, 33.83992], [-117.96287, 33.83993], [-117.9629, 33.83997], [-117.963, 33.84154], [-117.9631, 33.8417], [-117.96324, 33.84183], [-117.96353, 33.84201], [-117.96386, 33.8421], [-117.96457, 33.8421], [-117.96567, 33.84206], [-117.96602, 33.84198], [-117.96637, 33.84197], [-117.96637, 33.84338]]]} | Open Access 1 | Brookhurst Park | 16423 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 26.893 | Brookhurst Park | ||
2281 | 2281 | 2280 | {"type": "Polygon", "coordinates": [[[-121.30992, 37.99079], [-121.3096, 37.99094], [-121.3092, 37.991], [-121.30891, 37.9912], [-121.3086, 37.99132], [-121.30829, 37.99114], [-121.30829, 37.99107], [-121.30824, 37.991], [-121.30861, 37.99074], [-121.3089, 37.99012], [-121.30939, 37.99], [-121.30959, 37.98988], [-121.30979, 37.98999], [-121.30985, 37.99025], [-121.30972, 37.99029], [-121.30969, 37.99036], [-121.30971, 37.99042], [-121.30978, 37.9905], [-121.30992, 37.99079]]]} | Open Access 1 | Brooking Park | 16424 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 3.031 | Brooking Park | ||
2282 | 2282 | 2281 | {"type": "Polygon", "coordinates": [[[-117.792, 33.87101], [-117.79198, 33.87115], [-117.79198, 33.87145], [-117.79161, 33.87166], [-117.79163, 33.87218], [-117.79114, 33.8722], [-117.79107, 33.87209], [-117.7909, 33.87194], [-117.79159, 33.87124], [-117.792, 33.87101]]]} | Open Access 1 | Brookmont Park | 16425 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1.441 | Brookmont Park | ||
2283 | 2283 | 2282 | {"type": "MultiPolygon", "coordinates": [[[[-117.56368, 34.02398], [-117.56307, 34.02429], [-117.56283, 34.02486], [-117.56271, 34.02482], [-117.5627, 34.02425], [-117.56355, 34.02381], [-117.56368, 34.02398]]], [[[-117.56664, 34.02246], [-117.5638, 34.02392], [-117.56369, 34.02374], [-117.56652, 34.02229], [-117.56664, 34.02246]]], [[[-117.56797, 34.02174], [-117.56796, 34.02178], [-117.56793, 34.02181], [-117.56702, 34.02227], [-117.56683, 34.02239], [-117.56677, 34.02238], [-117.56665, 34.02222], [-117.56787, 34.0216], [-117.56797, 34.02174]]], [[[-117.57052, 34.01947], [-117.57049, 34.0196], [-117.5705, 34.02045], [-117.57048, 34.02056], [-117.57036, 34.02056], [-117.56969, 34.0209], [-117.56969, 34.02094], [-117.569, 34.0213], [-117.56875, 34.02138], [-117.5682, 34.02167], [-117.56814, 34.02167], [-117.56809, 34.02165], [-117.568, 34.02153], [-117.57022, 34.02039], [-117.57022, 34.01941], [-117.5704, 34.01945], [-117.57052, 34.01947]]]]} | Open Access 1 | City of Ontario Open Space | 17325 | 1232 | Ontario, City of 123 | City 2 | City Agency 2 | http://www.ci.ontario.ca.us/index.aspx?page=456 | City 2 | 5.372 | City of Ontario OS | ||
2284 | 2284 | 2283 | {"type": "Polygon", "coordinates": [[[-122.37728, 37.8995], [-122.37687, 37.90346], [-122.35982, 37.90125], [-122.3598, 37.90126], [-122.35981, 37.9018], [-122.35775, 37.90181], [-122.35773, 37.90092], [-122.35788, 37.90109], [-122.35803, 37.90098], [-122.35781, 37.90071], [-122.3576, 37.90062], [-122.3574, 37.8997], [-122.3572, 37.89911], [-122.35737, 37.89887], [-122.35772, 37.89812], [-122.35749, 37.89767], [-122.35716, 37.89727], [-122.35736, 37.89693], [-122.35721, 37.89654], [-122.3575, 37.89591], [-122.35742, 37.89557], [-122.35717, 37.89509], [-122.35687, 37.8949], [-122.3566, 37.89494], [-122.3563, 37.89461], [-122.35472, 37.89435], [-122.35458, 37.89471], [-122.35306, 37.89475], [-122.35246, 37.8945], [-122.35191, 37.89435], [-122.3514, 37.89407], [-122.35136, 37.8937], [-122.35107, 37.89356], [-122.35082, 37.89383], [-122.35146, 37.89463], [-122.35148, 37.89464], [-122.35174, 37.89554], [-122.35199, 37.89603], [-122.35227, 37.89631], [-122.35261, 37.89649], [-122.35277, 37.8969], [-122.35282, 37.89693], [-122.35286, 37.89882], [-122.34909, 37.89467], [-122.34902, 37.8918], [-122.35677, 37.89326], [-122.35962, 37.89378], [-122.35969, 37.89617], [-122.37728, 37.8995]]]} | Restricted Access 2 | Brooks Island | 16426 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 289.4 | Brooks Island | ||
2285 | 2285 | 2284 | {"type": "Polygon", "coordinates": [[[-122.46792, 37.71714], [-122.46758, 37.71715], [-122.46758, 37.71755], [-122.46724, 37.71756], [-122.46726, 37.71785], [-122.46669, 37.71784], [-122.46666, 37.71757], [-122.46635, 37.71757], [-122.46634, 37.71784], [-122.46613, 37.71785], [-122.46612, 37.71757], [-122.46578, 37.71757], [-122.46578, 37.71695], [-122.4661, 37.71695], [-122.46612, 37.71687], [-122.46792, 37.71687], [-122.46792, 37.71714]]]} | Open Access 1 | Brooks Park | 16429 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.742 | Brooks Park | ||
2286 | 2286 | 2285 | {"type": "Polygon", "coordinates": [[[-117.70288, 33.87817], [-117.70251, 33.87832], [-117.70206, 33.87863], [-117.70185, 33.87874], [-117.70172, 33.87879], [-117.70147, 33.87886], [-117.70108, 33.87889], [-117.70017, 33.87881], [-117.69987, 33.87873], [-117.69893, 33.87834], [-117.69873, 33.87829], [-117.69841, 33.87826], [-117.69839, 33.87801], [-117.69991, 33.8781], [-117.70086, 33.87811], [-117.70161, 33.87808], [-117.70218, 33.87803], [-117.70279, 33.87795], [-117.70288, 33.87817]]]} | Open Access 1 | Brush Canyon Park | 16452 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 6.253 | Brush Canyon Park | ||
2287 | 2287 | 2286 | {"type": "Polygon", "coordinates": [[[-122.68198, 38.46239], [-122.68133, 38.4633], [-122.68079, 38.46269], [-122.68076, 38.46258], [-122.68051, 38.46228], [-122.68082, 38.46212], [-122.68198, 38.46239]]]} | Open Access 1 | Brush Creek Park | 16453 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.058 | Brush Creek Park | ||
2288 | 2288 | 2287 | {"type": "Polygon", "coordinates": [[[-122.21848, 37.77884], [-122.21773, 37.77981], [-122.21745, 37.77956], [-122.21813, 37.77872], [-122.21826, 37.77849], [-122.21752, 37.77811], [-122.2176, 37.778], [-122.21846, 37.77842], [-122.21848, 37.77884]]]} | Open Access 1 | Cesar Chavez Park | 17097 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.525 | Cesar Chavez Park | ||
2289 | 2289 | 2288 | {"type": "Polygon", "coordinates": [[[-118.16869, 34.15351], [-118.16865, 34.15354], [-118.16836, 34.15333], [-118.16826, 34.15332], [-118.16819, 34.15335], [-118.16814, 34.1534], [-118.16812, 34.15344], [-118.16805, 34.15383], [-118.16806, 34.15393], [-118.16779, 34.15411], [-118.16776, 34.15415], [-118.16784, 34.15438], [-118.168, 34.15465], [-118.16854, 34.15527], [-118.16857, 34.15539], [-118.16858, 34.15549], [-118.16855, 34.15561], [-118.1685, 34.15571], [-118.16843, 34.1558], [-118.16832, 34.15588], [-118.16822, 34.15592], [-118.16758, 34.15606], [-118.1676, 34.15659], [-118.16753, 34.15651], [-118.16743, 34.15645], [-118.16732, 34.15641], [-118.1672, 34.15641], [-118.16632, 34.15661], [-118.16607, 34.15669], [-118.16566, 34.15687], [-118.16435, 34.15769], [-118.16411, 34.15782], [-118.16386, 34.15734], [-118.16382, 34.15729], [-118.16343, 34.15642], [-118.16335, 34.1563], [-118.16308, 34.156], [-118.16347, 34.15576], [-118.16293, 34.15456], [-118.16303, 34.15449], [-118.16323, 34.15425], [-118.1628, 34.15332], [-118.16238, 34.15345], [-118.16284, 34.15231], [-118.16271, 34.15135], [-118.16242, 34.1512], [-118.16263, 34.15103], [-118.16247, 34.15079], [-118.16268, 34.15066], [-118.1629, 34.15045], [-118.16304, 34.15034], [-118.16357, 34.15003], [-118.16381, 34.14994], [-118.16408, 34.1497], [-118.16416, 34.14967], [-118.16448, 34.14959], [-118.16455, 34.14954], [-118.16462, 34.14942], [-118.16473, 34.1494], [-118.16452, 34.14863], [-118.16443, 34.1485], [-118.16425, 34.14833], [-118.16468, 34.14833], [-118.1652, 34.14871], [-118.1653, 34.14833], [-118.16548, 34.14831], [-118.16545, 34.14792], [-118.16543, 34.14783], [-118.16538, 34.14775], [-118.1653, 34.14766], [-118.1652, 34.14759], [-118.16509, 34.14755], [-118.16495, 34.14752], [-118.16473, 34.14742], [-118.16432, 34.14709], [-118.16447, 34.14693], [-118.16422, 34.14675], [-118.16411, 34.14655], [-118.16412, 34.14645], [-118.1651, 34.1462], [-118.165, 34.14637], [-118.165, 34.14655], [-118.16541, 34.14669], [-118.16582, 34.14675], [-118.16616, 34.14688], [-118.1662, 34.14692], [-118.1661, 34.14692], [-118.1661, 34.14694], [-118.16613, 34.14696], [-118.16626, 34.14697], [-118.16679, 34.14743], [-118.16676, 34.14781], [-118.16648, 34.14813], [-118.16642, 34.14823], [-118.16635, 34.14836], [-118.16632, 34.1485], [-118.16631, 34.14864], [-118.16632, 34.14876], [-118.16643, 34.14917], [-118.1663, 34.14923], [-118.16597, 34.14903], [-118.1658, 34.14936], [-118.16591, 34.15034], [-118.1661, 34.1504], [-118.16628, 34.15052], [-118.16633, 34.15061], [-118.16656, 34.15077], [-118.16668, 34.1509], [-118.16675, 34.1509], [-118.16678, 34.15112], [-118.16683, 34.15137], [-118.16697, 34.15176], [-118.16717, 34.15215], [-118.16734, 34.15239], [-118.1675, 34.15258], [-118.16768, 34.15276], [-118.16788, 34.15294], [-118.16869, 34.15351]]]} | Open Access 1 | Brookside Park | http://www.cityofpasadena.net/PublicWorks/Brookside_Park1/ | 16431 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 94.225 | Brookside Park | |
2290 | 2290 | 2289 | {"type": "Polygon", "coordinates": [[[-117.21085, 34.04651], [-117.20865, 34.04651], [-117.20865, 34.04481], [-117.21084, 34.04481], [-117.21085, 34.0455], [-117.21085, 34.04651]]]} | Open Access 1 | Brookside Park | 16432 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 9.469 | Brookside Park | ||
2291 | 2291 | 2290 | {"type": "Polygon", "coordinates": [[[-121.88224, 37.39685], [-121.88204, 37.397], [-121.88141, 37.39766], [-121.88009, 37.39609], [-121.88041, 37.39576], [-121.88041, 37.39563], [-121.88018, 37.39546], [-121.88032, 37.3953], [-121.88029, 37.39525], [-121.87767, 37.39281], [-121.87784, 37.39266], [-121.87913, 37.39397], [-121.87945, 37.3942], [-121.88113, 37.39579], [-121.88123, 37.39593], [-121.88224, 37.39685]]]} | Open Access 1 | Brooktree park | 16434 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 7.137 | Brooktree park | 1981 | |
2292 | 2292 | 2291 | {"type": "Polygon", "coordinates": [[[-121.30691, 38.67268], [-121.3051, 38.67271], [-121.30415, 38.67288], [-121.30393, 38.67288], [-121.30394, 38.67079], [-121.3069, 38.67079], [-121.30691, 38.67268]]]} | Open Access 1 | Brooktree Park | 16435 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 13.838 | Brooktree Park | ||
2293 | 2293 | 2292 | {"type": "Polygon", "coordinates": [[[-122.02309, 37.56793], [-122.02259, 37.56859], [-122.02267, 37.56866], [-122.02253, 37.56884], [-122.02249, 37.56866], [-122.02161, 37.56762], [-122.02176, 37.56748], [-122.02192, 37.56727], [-122.02228, 37.56744], [-122.02242, 37.5676], [-122.02309, 37.56793]]]} | Open Access 1 | Brookvale Park | 16436 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2.345 | Brookvale Park | ||
2294 | 2294 | 2293 | {"type": "Polygon", "coordinates": [[[-117.65864, 33.66425], [-117.65843, 33.66496], [-117.65853, 33.665], [-117.65847, 33.66516], [-117.65837, 33.66515], [-117.65817, 33.66558], [-117.65756, 33.66544], [-117.65723, 33.66615], [-117.65658, 33.66736], [-117.65606, 33.66707], [-117.65557, 33.66674], [-117.65503, 33.6663], [-117.65502, 33.66621], [-117.65489, 33.66611], [-117.65478, 33.6661], [-117.65431, 33.66572], [-117.65377, 33.66536], [-117.65339, 33.66514], [-117.65288, 33.6649], [-117.65284, 33.66481], [-117.653, 33.66444], [-117.65313, 33.66407], [-117.65324, 33.6637], [-117.65332, 33.66332], [-117.65343, 33.66343], [-117.65379, 33.66356], [-117.65403, 33.66361], [-117.65418, 33.66354], [-117.65435, 33.6635], [-117.65449, 33.66343], [-117.65459, 33.66335], [-117.65479, 33.66312], [-117.65494, 33.66283], [-117.65495, 33.66247], [-117.65501, 33.66234], [-117.6551, 33.66185], [-117.65509, 33.6618], [-117.65506, 33.66176], [-117.65498, 33.66171], [-117.65485, 33.66168], [-117.65482, 33.66164], [-117.65481, 33.66159], [-117.65484, 33.66155], [-117.65505, 33.66138], [-117.65531, 33.66114], [-117.65554, 33.66104], [-117.65564, 33.66109], [-117.65573, 33.66102], [-117.6557, 33.66098], [-117.65577, 33.66093], [-117.65583, 33.66087], [-117.65588, 33.66078], [-117.65588, 33.66072], [-117.65586, 33.66069], [-117.65579, 33.66063], [-117.65559, 33.66053], [-117.65557, 33.66048], [-117.65568, 33.66038], [-117.65632, 33.66031], [-117.65652, 33.66013], [-117.65669, 33.66003], [-117.65696, 33.65992], [-117.65716, 33.65989], [-117.65736, 33.65988], [-117.65765, 33.65991], [-117.65784, 33.65997], [-117.65802, 33.66005], [-117.65859, 33.66037], [-117.65923, 33.66092], [-117.65931, 33.66101], [-117.65937, 33.66111], [-117.6594, 33.66122], [-117.6594, 33.66134], [-117.65934, 33.66151], [-117.65819, 33.66297], [-117.65793, 33.66386], [-117.65794, 33.66387], [-117.65837, 33.66381], [-117.65835, 33.66409], [-117.65864, 33.66425]]]} | Open Access 1 | Lake Forest Sports Park | http://lfsportspark.com/ | 32259 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 66.115 | Lake Forest Sports Park | 2014 |
2295 | 2295 | 2294 | {"type": "Polygon", "coordinates": [[[-122.02253, 37.56884], [-122.02236, 37.56904], [-122.0224, 37.56911], [-122.02235, 37.56915], [-122.02233, 37.56919], [-122.02219, 37.56917], [-122.02185, 37.56957], [-122.02192, 37.56967], [-122.02185, 37.56974], [-122.02171, 37.56972], [-122.02138, 37.57012], [-122.02144, 37.57022], [-122.0214, 37.57025], [-122.02138, 37.5703], [-122.02124, 37.57028], [-122.02088, 37.57066], [-122.02092, 37.57074], [-122.02087, 37.57077], [-122.02085, 37.57081], [-122.02068, 37.57079], [-122.02048, 37.57087], [-122.02049, 37.57091], [-122.02035, 37.5712], [-122.02028, 37.57119], [-122.02027, 37.57105], [-122.02, 37.57086], [-122.01959, 37.57085], [-122.01954, 37.57091], [-122.01947, 37.57089], [-122.0194, 37.5709], [-122.01935, 37.57084], [-122.01876, 37.57083], [-122.01871, 37.57088], [-122.01865, 37.57087], [-122.01856, 37.57088], [-122.01851, 37.57082], [-122.01792, 37.57081], [-122.01787, 37.57086], [-122.01777, 37.57085], [-122.01775, 37.57077], [-122.01752, 37.57069], [-122.01702, 37.57089], [-122.01696, 37.57104], [-122.0169, 37.57103], [-122.01686, 37.5708], [-122.01646, 37.57079], [-122.01627, 37.57074], [-122.01605, 37.57083], [-122.01568, 37.57057], [-122.01591, 37.57036], [-122.0162, 37.57057], [-122.01673, 37.57057], [-122.01685, 37.57047], [-122.01692, 37.5705], [-122.01702, 37.57049], [-122.01711, 37.57064], [-122.01739, 37.5706], [-122.01745, 37.57052], [-122.01747, 37.57062], [-122.01748, 37.57062], [-122.01775, 37.57053], [-122.01782, 37.57042], [-122.01789, 37.57043], [-122.01791, 37.57064], [-122.01856, 37.57065], [-122.01881, 37.57059], [-122.01915, 37.57061], [-122.0193, 37.57045], [-122.0194, 37.57046], [-122.01941, 37.5706], [-122.01954, 37.57067], [-122.01987, 37.57064], [-122.02005, 37.5707], [-122.02032, 37.57071], [-122.02049, 37.57062], [-122.0204, 37.57047], [-122.02045, 37.57044], [-122.02061, 37.57053], [-122.02082, 37.57047], [-122.02088, 37.57034], [-122.0211, 37.57009], [-122.02103, 37.56996], [-122.02109, 37.56993], [-122.02112, 37.56986], [-122.02121, 37.56987], [-122.02145, 37.56975], [-122.02168, 37.56955], [-122.02158, 37.56938], [-122.02163, 37.56933], [-122.02173, 37.56937], [-122.02194, 37.56925], [-122.02198, 37.56916], [-122.02214, 37.56898], [-122.02209, 37.56886], [-122.02216, 37.56883], [-122.0222, 37.56877], [-122.02226, 37.56879], [-122.02249, 37.56867], [-122.02253, 37.56884]]]} | Open Access 1 | Brookvale Trail | 16437 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 4.63 | Brookvale Trail | ||
2296 | 2296 | 2295 | {"type": "MultiPolygon", "coordinates": [[[[-120.98486, 37.63968], [-120.98485, 37.63968], [-120.98462, 37.63914], [-120.98459, 37.63898], [-120.98438, 37.63858], [-120.98435, 37.63825], [-120.98473, 37.63825], [-120.98486, 37.63968]]], [[[-120.98581, 37.64139], [-120.98592, 37.64161], [-120.98595, 37.64173], [-120.98597, 37.64196], [-120.98595, 37.64219], [-120.98591, 37.64231], [-120.9858, 37.64253], [-120.98578, 37.64254], [-120.98574, 37.64252], [-120.98569, 37.6423], [-120.98567, 37.64207], [-120.98567, 37.64185], [-120.9857, 37.64162], [-120.98575, 37.6414], [-120.98577, 37.64138], [-120.98581, 37.64139]]]]} | Open Access 1 | Brookway Park | 16438 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1.408 | Brookway Park | ||
2297 | 2297 | 2296 | {"type": "MultiPolygon", "coordinates": [[[[-118.59047, 34.28422], [-118.59029, 34.28447], [-118.58998, 34.28446], [-118.58973, 34.28468], [-118.58975, 34.28488], [-118.58941, 34.28529], [-118.58921, 34.28604], [-118.58902, 34.28613], [-118.58886, 34.28652], [-118.58885, 34.28691], [-118.58864, 34.28756], [-118.58831, 34.28837], [-118.58814, 34.28972], [-118.58765, 34.29047], [-118.58749, 34.2906], [-118.58726, 34.29087], [-118.58706, 34.29127], [-118.58691, 34.29196], [-118.58671, 34.29176], [-118.58641, 34.29151], [-118.58567, 34.29096], [-118.58565, 34.29093], [-118.58565, 34.2909], [-118.58682, 34.28977], [-118.58713, 34.2894], [-118.58744, 34.28894], [-118.5877, 34.28845], [-118.58849, 34.28659], [-118.5897, 34.28433], [-118.58985, 34.28402], [-118.58988, 34.28399], [-118.58992, 34.28399], [-118.59007, 34.28403], [-118.5903, 34.28412], [-118.59047, 34.28422]]], [[[-118.58982, 34.28252], [-118.5898, 34.28294], [-118.58974, 34.28329], [-118.58967, 34.28356], [-118.58955, 34.28389], [-118.58943, 34.28415], [-118.58818, 34.28649], [-118.58744, 34.28822], [-118.58721, 34.28656], [-118.58797, 34.28567], [-118.58799, 34.28522], [-118.58869, 34.28522], [-118.58871, 34.28467], [-118.58803, 34.28464], [-118.58812, 34.28286], [-118.58779, 34.28244], [-118.58982, 34.28252]]], [[[-118.59218, 34.28236], [-118.59084, 34.28252], [-118.5912, 34.28485], [-118.59113, 34.28466], [-118.59102, 34.28448], [-118.59091, 34.28434], [-118.59078, 34.28422], [-118.59063, 34.28411], [-118.59043, 34.28399], [-118.59022, 34.2839], [-118.59, 34.28384], [-118.58996, 34.2838], [-118.59007, 34.28337], [-118.59014, 34.28295], [-118.59032, 34.28002], [-118.5904, 34.27958], [-118.59057, 34.27904], [-118.59209, 34.27904], [-118.59201, 34.27922], [-118.59198, 34.2794], [-118.59171, 34.28027], [-118.59192, 34.2807], [-118.59199, 34.28127], [-118.59218, 34.28236]]], [[[-118.59203, 34.28678], [-118.59166, 34.28736], [-118.59172, 34.28814], [-118.5915, 34.28857], [-118.59196, 34.28922], [-118.59175, 34.28968], [-118.59185, 34.29002], [-118.59175, 34.29024], [-118.59086, 34.29024], [-118.5912, 34.28847], [-118.59138, 34.2881], [-118.59132, 34.2873], [-118.59163, 34.28681], [-118.59108, 34.28618], [-118.591, 34.28568], [-118.59133, 34.28565], [-118.59139, 34.28608], [-118.59203, 34.28678]]]]} | Open Access 1 | Brown's Creek Park | 16442 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 51.689 | Brown's Creek Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);