superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 465
- San Diego, City of 433
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 218
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 124
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 94
- Modesto, City of 84
- 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
- Poway, City of 67
- Newport Beach, City of 65
- Santa Barbara, City of 64
- Davis, City of 64
- San Luis Obispo, City of 63
- Napa, City of 62
- Clovis, City of 62
- Bakersfield, City of 61
- Manteca, City of 60
- Anaheim, City of 59
- …
ACCESS_TYP 4
- Open Access 9,670
- Restricted Access 356
- No Public Access 155
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,210 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12654 | 12654 | 12653 | {"type": "Polygon", "coordinates": [[[-118.3888, 33.86582], [-118.38873, 33.86578], [-118.38873, 33.86578], [-118.38878, 33.86576], [-118.3888, 33.86582]]]} | Open Access 1 | Scout Park | 29783 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 0.004 | Scout Park | ||
12655 | 12655 | 12654 | {"type": "Polygon", "coordinates": [[[-118.38594, 33.85816], [-118.38592, 33.85821], [-118.38575, 33.85816], [-118.38575, 33.85816], [-118.38594, 33.85816]]]} | Open Access 1 | Third Street & Prospect Avenue Park | 29786 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 0.012 | Third Street & Prospect Avenue Park | ||
11973 | 11973 | 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]]]} | Open Access 1 | Crescent Place Triangle | 28810 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.015 | Crescent Place Triangle | ||
13723 | 13723 | 13722 | {"type": "Polygon", "coordinates": [[[-117.87133, 33.59796], [-117.87133, 33.59796], [-117.87119, 33.59799], [-117.8713, 33.59788], [-117.87133, 33.59796]]]} | Open Access 1 | Corona del Mar Pocket Park | 31210 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.015 | Corona del Mar PP | ||
10738 | 10738 | 10737 | {"type": "Polygon", "coordinates": [[[-119.19521, 34.28644], [-119.19519, 34.28644], [-119.19511, 34.28596], [-119.19513, 34.28596], [-119.19521, 34.28644]]]} | Open Access 1 | Ventura holding 58 | 26938 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.019 | Ventura holding 58 | ||
7193 | 7193 | 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]]]} | Open Access 1 | Moorpark holding 2 | 22464 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 0.021 | Moorpark holding 2 | ||
9679 | 9679 | 9678 | {"type": "Polygon", "coordinates": [[[-119.80571, 36.72831], [-119.8057, 36.72842], [-119.80555, 36.72842], [-119.80555, 36.72842], [-119.80571, 36.72831]]]} | Open Access 1 | Merced and Pickford Pocket Park | 31025 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 0.021 | Merced and Pickford PP | ||
10717 | 10717 | 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]]]} | Open Access 1 | Ventura holding 22 | 26899 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.021 | Ventura holding 22 | ||
10741 | 10741 | 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]]]} | Open Access 1 | Ventura holding 60 | 26941 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.022 | Ventura holding 60 | ||
9460 | 9460 | 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]]]} | Open Access 1 | Seaside holding 7 | 25263 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.023 | Seaside holding 7 | ||
10715 | 10715 | 10714 | {"type": "Polygon", "coordinates": [[[-119.17309, 34.26527], [-119.17306, 34.26529], [-119.17283, 34.26503], [-119.17286, 34.26501], [-119.17309, 34.26527]]]} | Open Access 1 | Ventura holding 20 | 26897 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.027 | Ventura holding 20 | ||
11970 | 11970 | 11969 | {"type": "Polygon", "coordinates": [[[-118.45909, 33.99185], [-118.45903, 33.99195], [-118.45894, 33.99191], [-118.45901, 33.99181], [-118.45909, 33.99185]]]} | Open Access 1 | Amoroso Triangle | 28805 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.027 | Amoroso Triangle | ||
11988 | 11988 | 11987 | {"type": "Polygon", "coordinates": [[[-118.46102, 33.99278], [-118.46095, 33.99287], [-118.46087, 33.99283], [-118.46093, 33.99274], [-118.46102, 33.99278]]]} | Open Access 1 | Nowita Triangle | 28834 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.027 | Nowita Triangle | ||
9523 | 9523 | 9522 | {"type": "Polygon", "coordinates": [[[-121.95422, 37.3521], [-121.95419, 37.35217], [-121.95414, 37.3522], [-121.9539, 37.35222], [-121.95422, 37.3521]]]} | Open Access 1 | Sesquicentennial Park | 25322 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 0.032 | Sesquicentennial Park | ||
9671 | 9671 | 9670 | {"type": "Polygon", "coordinates": [[[-119.74575, 36.73906], [-119.74575, 36.73914], [-119.74558, 36.73914], [-119.74558, 36.73906], [-119.74575, 36.73906]]]} | Open Access 1 | Maple and Blach Pocket Park | 31024 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 0.032 | Maple and Blach PP | ||
2268 | 2268 | 2267 | {"type": "Polygon", "coordinates": [[[-122.41296, 37.79709], [-122.41291, 37.7971], [-122.41288, 37.79701], [-122.41284, 37.797], [-122.41282, 37.79693], [-122.41292, 37.79692], [-122.41296, 37.79709]]]} | Open Access 1 | Broadway Tunnel east Mini Park | 16410 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.033 | Broadway Tunnel east MP | ||
7143 | 7143 | 7142 | {"type": "Polygon", "coordinates": [[[-121.94543, 36.97873], [-121.9451, 36.97895], [-121.94502, 36.97897], [-121.94541, 36.9787], [-121.94543, 36.97873]]]} | Open Access 1 | Monterey Avenue Park Access | 22415 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 0.034 | Monterey Avenue Park Access | ||
9329 | 9329 | 9328 | {"type": "Polygon", "coordinates": [[[-120.44198, 34.91627], [-120.44198, 34.91649], [-120.44191, 34.91649], [-120.44191, 34.91632], [-120.44193, 34.91628], [-120.44198, 34.91627]]]} | Open Access 1 | Santa Maria holding 3 | 25107 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 0.034 | Santa Maria holding 3 | ||
10685 | 10685 | 10684 | {"type": "Polygon", "coordinates": [[[-119.1914, 34.28159], [-119.19124, 34.2816], [-119.1908, 34.28162], [-119.1912, 34.28156], [-119.1914, 34.28159]]]} | Open Access 1 | Ventura holding 107 | 26860 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.034 | Ventura holding 107 | ||
10730 | 10730 | 10729 | {"type": "Polygon", "coordinates": [[[-119.19432, 34.28316], [-119.19407, 34.28287], [-119.1938, 34.28262], [-119.19379, 34.28258], [-119.1938, 34.28256], [-119.19381, 34.28257], [-119.1938, 34.28259], [-119.19382, 34.28261], [-119.19402, 34.2828], [-119.19421, 34.283], [-119.19431, 34.28313], [-119.19432, 34.28316]]]} | Open Access 1 | Ventura holding 5 | 26929 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.034 | Ventura holding 5 |
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]);