superunits_with_maps_view (view)
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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12653 | {"type": "Polygon", "coordinates": [[[-118.3888, 33.86582], [-118.38873, 33.86578], [-118.38873, 33.86578], [-118.38878, 33.86576], [-118.3888, 33.86582]]]} | 1 | Scout Park | 29783 | 1134 | 290 | 2 | 2 | http://www.hermosabch.org/index.aspx?page=115 | 2 | 0.004 | Scout Park | ||
12654 | {"type": "Polygon", "coordinates": [[[-118.38594, 33.85816], [-118.38592, 33.85821], [-118.38575, 33.85816], [-118.38575, 33.85816], [-118.38594, 33.85816]]]} | 1 | Third Street & Prospect Avenue Park | 29786 | 1134 | 290 | 2 | 2 | http://www.hermosabch.org/index.aspx?page=115 | 2 | 0.012 | Third Street & Prospect Avenue Park | ||
11972 | {"type": "Polygon", "coordinates": [[[-118.46109, 33.99132], [-118.46107, 33.99134], [-118.46103, 33.99134], [-118.461, 33.99132], [-118.461, 33.99129], [-118.46103, 33.99127], [-118.46106, 33.99127], [-118.46109, 33.99128], [-118.46109, 33.99132]]]} | 1 | Crescent Place Triangle | 28810 | 1188 | 24 | 2 | 2 | http://lacity.org/ | 2 | 0.015 | Crescent Place Triangle | ||
13722 | {"type": "Polygon", "coordinates": [[[-117.87133, 33.59796], [-117.87133, 33.59796], [-117.87119, 33.59799], [-117.8713, 33.59788], [-117.87133, 33.59796]]]} | 1 | Corona del Mar Pocket Park | 31210 | 1224 | 52 | 2 | 2 | http://www.newportbeachca.gov/index.aspx?page=66 | 2 | 0.015 | Corona del Mar PP | ||
10737 | {"type": "Polygon", "coordinates": [[[-119.19521, 34.28644], [-119.19519, 34.28644], [-119.19511, 34.28596], [-119.19513, 34.28596], [-119.19521, 34.28644]]]} | 1 | Ventura holding 58 | 26938 | 1366 | 110 | 2 | 2 | http://www.cityofventura.net/prcp | 2 | 0.019 | Ventura holding 58 | ||
2456 | {"type": "Polygon", "coordinates": [[[-118.23627, 33.89605], [-118.23616, 33.89604], [-118.23608, 33.89598], [-118.2362, 33.89598], [-118.23627, 33.89605]]]} | 1 | Compton Creek & Bike Path | 17572 | 2272 | 284 | 4 | 9 | http://dpw.lacounty.gov/lacfcd/ | 4 | 0.02 | Compton Creek & Bike Path | ||
14114 | {"type": "Polygon", "coordinates": [[[-120.94993, 40.13923], [-120.94987, 40.13929], [-120.94983, 40.13929], [-120.94982, 40.13916], [-120.94993, 40.13923]]]} | 1 | Triangle Park | http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf | 33659 | 2229 | 848 | 4 | 17 | 4 | 0.02 | Triangle Park | ||
7192 | {"type": "Polygon", "coordinates": [[[-118.88253, 34.28657], [-118.88237, 34.28657], [-118.88234, 34.28652], [-118.88242, 34.28649], [-118.88245, 34.28653], [-118.88247, 34.28653], [-118.88253, 34.28657]]]} | 1 | Moorpark holding 2 | 22464 | 1214 | 168 | 2 | 2 | http://www.moorparkca.gov/199/Recreation | 2 | 0.021 | Moorpark holding 2 | ||
9678 | {"type": "Polygon", "coordinates": [[[-119.80571, 36.72831], [-119.8057, 36.72842], [-119.80555, 36.72842], [-119.80555, 36.72842], [-119.80571, 36.72831]]]} | 1 | Merced and Pickford Pocket Park | 31025 | 1114 | 14 | 2 | 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | 2 | 0.021 | Merced and Pickford PP | ||
10716 | {"type": "Polygon", "coordinates": [[[-119.19475, 34.28398], [-119.19474, 34.28399], [-119.19465, 34.28374], [-119.19455, 34.28353], [-119.19456, 34.28346], [-119.19456, 34.28351], [-119.19469, 34.28379], [-119.19475, 34.28398]]]} | 1 | Ventura holding 22 | 26899 | 1366 | 110 | 2 | 2 | http://www.cityofventura.net/prcp | 2 | 0.021 | Ventura holding 22 | ||
10740 | {"type": "Polygon", "coordinates": [[[-119.1911, 34.28234], [-119.19106, 34.28236], [-119.19083, 34.28244], [-119.19075, 34.28238], [-119.19073, 34.28229], [-119.19076, 34.28229], [-119.19078, 34.28238], [-119.19083, 34.28242], [-119.1911, 34.28234]]]} | 1 | Ventura holding 60 | 26941 | 1366 | 110 | 2 | 2 | http://www.cityofventura.net/prcp | 2 | 0.022 | Ventura holding 60 | ||
9459 | {"type": "Polygon", "coordinates": [[[-121.82508, 36.6128], [-121.82474, 36.61287], [-121.82474, 36.61287], [-121.82474, 36.61284], [-121.82507, 36.61277], [-121.82508, 36.6128]]]} | 1 | Seaside holding 7 | 25263 | 1330 | 112 | 2 | 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | 2 | 0.023 | Seaside holding 7 | ||
5662 | {"type": "Polygon", "coordinates": [[[-122.87408, 39.00329], [-122.87407, 39.0034], [-122.87395, 39.0034], [-122.874, 39.00329], [-122.87408, 39.00329]]]} | 1 | Lake holding 44 | 20933 | 345 | 275 | 3 | 3 | http://parks.lakecountyca.gov/ | 3 | 0.025 | Lake holding 44 | ||
8258 | {"type": "Polygon", "coordinates": [[[-119.01469, 34.22393], [-119.01462, 34.2239], [-119.01463, 34.22384], [-119.01461, 34.22379], [-119.01469, 34.22376], [-119.01469, 34.22393]]]} | 1 | Pleasant Valley Recreation and Park District | 23802 | 2113 | 145 | 4 | 4 | http://www.pvrpd.org/ | 4 | 0.025 | Pleasant Valley Rec. and Park District | ||
10714 | {"type": "Polygon", "coordinates": [[[-119.17309, 34.26527], [-119.17306, 34.26529], [-119.17283, 34.26503], [-119.17286, 34.26501], [-119.17309, 34.26527]]]} | 1 | Ventura holding 20 | 26897 | 1366 | 110 | 2 | 2 | http://www.cityofventura.net/prcp | 2 | 0.027 | Ventura holding 20 | ||
11969 | {"type": "Polygon", "coordinates": [[[-118.45909, 33.99185], [-118.45903, 33.99195], [-118.45894, 33.99191], [-118.45901, 33.99181], [-118.45909, 33.99185]]]} | 1 | Amoroso Triangle | 28805 | 1188 | 24 | 2 | 2 | http://lacity.org/ | 2 | 0.027 | Amoroso Triangle | ||
11987 | {"type": "Polygon", "coordinates": [[[-118.46102, 33.99278], [-118.46095, 33.99287], [-118.46087, 33.99283], [-118.46093, 33.99274], [-118.46102, 33.99278]]]} | 1 | Nowita Triangle | 28834 | 1188 | 24 | 2 | 2 | http://lacity.org/ | 2 | 0.027 | Nowita Triangle | ||
1550 | {"type": "Polygon", "coordinates": [[[-121.53081, 39.5272], [-121.53065, 39.5272], [-121.53066, 39.52703], [-121.53072, 39.5271], [-121.53081, 39.5272]]]} | 1 | Butte holding 35 | 16579 | 342 | 692 | 3 | 3 | http://www.buttecounty.net/ | 3 | 0.031 | Butte holding 35 | ||
9522 | {"type": "Polygon", "coordinates": [[[-121.95422, 37.3521], [-121.95419, 37.35217], [-121.95414, 37.3522], [-121.9539, 37.35222], [-121.95422, 37.3521]]]} | 1 | Sesquicentennial Park | 25322 | 1318 | 395 | 2 | 2 | http://santaclaraca.gov/index.aspx?page=123 | 2 | 0.032 | Sesquicentennial Park | ||
9670 | {"type": "Polygon", "coordinates": [[[-119.74575, 36.73906], [-119.74575, 36.73914], [-119.74558, 36.73914], [-119.74558, 36.73906], [-119.74575, 36.73906]]]} | 1 | Maple and Blach Pocket Park | 31024 | 1114 | 14 | 2 | 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | 2 | 0.032 | Maple and Blach PP |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW superunits_with_maps_view AS select id, AsGeoJSON(geometry) as 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 from CPAD_2020a_SuperUnits order by id;