superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,178
- County Agency 1,098
- Recreation/Parks District 1,090
- State Agency 872
- Non Profit - Land Trust 511
- Federal Agency 289
- Open Space District 240
- County Agency - Parks 218
- Home Owners Association 200
- Community Services District 192
- Water District 187
- Non Profit - Conservation 119
- Flood District 93
- Cemetery District 61
- Non Profit - Other 44
- School District 38
- County Agency - Other 32
- Port/Harbor District 32
- Irrigation District 24
- Special District - Other 15
- Commercial 14
- Sanitation District 9
- Joint Powers Authority 8
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 459
- San Diego, City of 432
- California Department of Fish and Wildlife 394
- California Department of Parks and Recreation 276
- San Jose, City of 253
- San Francisco, City and County of 238
- Sacramento, City of 218
- Mountains Recreation and Conservation Authority 180
- Los Angeles, County of 171
- Long Beach, City of 148
- Ventura, City of 143
- East Bay Regional Park District 132
- Roseville, City of 124
- Oakland, City of 122
- San Diego, County of 120
- Irvine, City of 98
- Fresno, City of 92
- Consumnes Community Services District 92
- Santa Barbara, County of 89
- Hayward Area Recreation and Park District 84
- Modesto, City of 84
- Orange, County of 82
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- …
ACCESS_TYP 4
- Open Access 13,473
- Restricted Access 1,118
- No Public Access 754
- Unknown Access 253
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11981 | 11981 | 11980 | {"type": "Polygon", "coordinates": [[[-118.42279, 34.08006], [-118.42271, 34.08009], [-118.4227, 34.0798], [-118.42279, 34.07993], [-118.42279, 34.08006]]]} | Open Access 1 | Gateway Triangle | 28822 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.044 | Gateway Triangle | ||
12462 | 12462 | 12461 | {"type": "Polygon", "coordinates": [[[-118.30925, 34.17173], [-118.30908, 34.1716], [-118.30919, 34.17149], [-118.30919, 34.17149], [-118.30925, 34.17173]]]} | Open Access 1 | Compass Tree Park | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/compass-tree-park | 29556 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 0.044 | Compass Tree Park | |
5128 | 5128 | 5127 | {"type": "Polygon", "coordinates": [[[-118.18446, 34.11514], [-118.1843, 34.11529], [-118.18412, 34.11522], [-118.1843, 34.11518], [-118.18446, 34.11514]]]} | Open Access 1 | Highland Park | 19932 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.045 | Highland Park | ||
10733 | 10733 | 10732 | {"type": "Polygon", "coordinates": [[[-119.15826, 34.27089], [-119.15766, 34.27124], [-119.15716, 34.27146], [-119.15714, 34.27145], [-119.15759, 34.27126], [-119.15821, 34.2709], [-119.15826, 34.27089]]]} | Open Access 1 | Ventura holding 53 | 26933 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.045 | Ventura holding 53 | ||
2391 | 2391 | 2390 | {"type": "Polygon", "coordinates": [[[-121.55987, 37.00582], [-121.55987, 37.00582], [-121.55949, 37.00582], [-121.55983, 37.00572], [-121.55987, 37.00582]]]} | Open Access 1 | Butcher Park | 16546 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 0.046 | Butcher Park | ||
10684 | 10684 | 10683 | {"type": "Polygon", "coordinates": [[[-119.17467, 34.27812], [-119.17461, 34.27816], [-119.17442, 34.27794], [-119.17446, 34.27792], [-119.1745, 34.27793], [-119.17467, 34.27812]]]} | Open Access 1 | Ventura holding 106 | 26859 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.046 | Ventura holding 106 | ||
2897 | 2897 | 2896 | {"type": "Polygon", "coordinates": [[[-122.40734, 37.80463], [-122.40687, 37.80468], [-122.40687, 37.80464], [-122.40733, 37.80459], [-122.40734, 37.80463]]]} | Open Access 1 | Chesnut/kearny Mini Park | 17178 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.047 | Chesnut/kearny MP | ||
7954 | 7954 | 7953 | {"type": "Polygon", "coordinates": [[[-122.42592, 37.73641], [-122.42567, 37.73661], [-122.42567, 37.73661], [-122.42574, 37.7364], [-122.42592, 37.73641]]]} | Open Access 1 | Park St. Garden | 23439 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.047 | Park St. Garden | ||
9650 | 9650 | 9649 | {"type": "Polygon", "coordinates": [[[-119.8072, 36.72725], [-119.80719, 36.72742], [-119.80696, 36.72742], [-119.80696, 36.72742], [-119.8072, 36.72725]]]} | Open Access 1 | Merced & Stevens Pocket Park | 31009 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 0.047 | Merced & Stevens PP | ||
12618 | 12618 | 12617 | {"type": "Polygon", "coordinates": [[[-123.9855, 40.88189], [-123.98541, 40.88195], [-123.98525, 40.88184], [-123.98534, 40.88177], [-123.9855, 40.88189]]]} | Open Access 1 | City of Blue Lake Tot Lot | 30684 | 1443 | Blue Lake, City of 699 | City 2 | City Agency 2 | http://bluelake.ca.gov/ | City 2 | 0.047 | City of Blue Lake Tot Lot | ||
13646 | 13646 | 13645 | {"type": "Polygon", "coordinates": [[[-117.89511, 33.61062], [-117.89508, 33.61063], [-117.89507, 33.61067], [-117.89499, 33.61066], [-117.89481, 33.61061], [-117.89479, 33.61058], [-117.89492, 33.61057], [-117.89511, 33.61061], [-117.89511, 33.61062]]]} | Open Access 1 | Myrtle Park | 31137 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.047 | Myrtle Park | ||
10752 | 10752 | 10751 | {"type": "Polygon", "coordinates": [[[-119.19623, 34.28781], [-119.19547, 34.28778], [-119.19543, 34.28773], [-119.19535, 34.28731], [-119.19537, 34.28731], [-119.19544, 34.28773], [-119.19547, 34.28777], [-119.19623, 34.2878], [-119.19623, 34.28781]]]} | Open Access 1 | Ventura holding 71 | 26953 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.048 | Ventura holding 71 | ||
13932 | 13932 | 13931 | {"type": "Polygon", "coordinates": [[[-118.15703, 34.11042], [-118.15701, 34.11047], [-118.15695, 34.1105], [-118.1569, 34.11048], [-118.15687, 34.11042], [-118.15688, 34.11037], [-118.15695, 34.11034], [-118.157, 34.11035], [-118.15703, 34.11042]]]} | Open Access 1 | El Cerrito Circle Park | 32533 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 0.048 | El Cerrito Circle Park | ||
6770 | 6770 | 6769 | {"type": "Polygon", "coordinates": [[[-118.43173, 33.99148], [-118.43157, 33.99155], [-118.43154, 33.99132], [-118.43154, 33.99132], [-118.43173, 33.99148]]]} | Open Access 1 | Maxella Parkette | 21967 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 0.051 | Maxella Parkette | ||
10682 | 10682 | 10681 | {"type": "Polygon", "coordinates": [[[-119.15969, 34.27006], [-119.15962, 34.2701], [-119.15848, 34.27077], [-119.15851, 34.27073], [-119.15963, 34.27008], [-119.15969, 34.27006]]]} | Open Access 1 | Ventura holding 104 | 26857 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.051 | Ventura holding 104 | ||
10695 | 10695 | 10694 | {"type": "Polygon", "coordinates": [[[-119.17705, 34.27796], [-119.17699, 34.27793], [-119.17693, 34.27794], [-119.17623, 34.27829], [-119.17578, 34.27854], [-119.17577, 34.27853], [-119.17622, 34.27828], [-119.17693, 34.27792], [-119.177, 34.27792], [-119.17705, 34.27796]]]} | Open Access 1 | Ventura holding 115 | 26869 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.051 | Ventura holding 115 | ||
10836 | 10836 | 10835 | {"type": "Polygon", "coordinates": [[[-116.98167, 33.93103], [-116.98167, 33.93103], [-116.98149, 33.93126], [-116.98149, 33.93103], [-116.98167, 33.93103]]]} | Open Access 1 | Veterans Park | 27054 | 1415 | Beaumont, City of 782 | City 2 | City Agency 2 | http://www.ci.beaumont.ca.us/index.aspx?nid=33 | City 2 | 0.051 | Veterans Park | ||
12530 | 12530 | 12529 | {"type": "Polygon", "coordinates": [[[-118.38992, 33.85746], [-118.38985, 33.85749], [-118.38978, 33.85725], [-118.38985, 33.85722], [-118.38992, 33.85746]]]} | Open Access 1 | Ocean View Parkette | 29776 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 0.051 | Ocean View Parkette | ||
781 | 781 | 780 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 0.053 | Kensington PP | ||
13714 | 13714 | 13713 | {"type": "Polygon", "coordinates": [[[-118.518, 34.05167], [-118.51753, 34.05174], [-118.51751, 34.0517], [-118.51798, 34.05163], [-118.518, 34.05167]]]} | No Public Access 3 | Chautauqua Blvd Access to Will Rogers State Historic Preserve | 31212 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.053 | Chautauqua Blvd Access to Will Rogers SHPr |
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]);