superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
356 rows where ACCESS_TYP = 2 and LAYER = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 20
- Whittier, City of 20
- San Ramon, City of 15
- San Diego, City of 10
- Long Beach, City of 9
- Arcadia, City of 8
- Manhattan Beach, City of 8
- San Jose, City of 6
- Carlsbad, City of 6
- Hollister, City of 6
- Pasadena, City of 6
- Modesto, City of 6
- Santa Ana, City of 5
- Fullerton, City of 5
- Vacaville, City of 5
- San Bernardino, City of 5
- Beverly Hills, City of 5
- Lawndale, City of 5
- San Gabriel, City of 5
- Santa Cruz, City of 4
- Glendora, City of 4
- El Segundo, City of 4
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- South El Monte, City of 4
- Watsonville, City of 3
- Oceanside, City of 3
- Pomona, City of 3
- Burbank, City of 3
- …
MNG_AG_TYP 1
- City Agency 356
ACCESS_TYP 1
- Restricted Access · 356 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
622 | 622 | 621 | {"type": "Polygon", "coordinates": [[[-118.30636, 33.88501], [-118.306, 33.88501], [-118.306, 33.88495], [-118.30635, 33.88494], [-118.30636, 33.88501]]]} | Restricted Access 2 | Rush Memorial Gymnasium | https://www.facebook.com/pages/Rush-Memorial-Gymnasium/1811050155861741 | 32699 | 1117 | Gardena, City of 293 | City 2 | City Agency 2 | http://www.ci.gardena.ca.us/ | City 2 | 0.057 | Rush Memorial Gymnasium | |
8335 | 8335 | 8334 | {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} | Restricted Access 2 | South Monterey Dunes | 25664 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.069 | South Monterey Dunes | ||
12679 | 12679 | 12678 | {"type": "Polygon", "coordinates": [[[-117.74578, 34.02877], [-117.74542, 34.02878], [-117.74539, 34.02875], [-117.74539, 34.02862], [-117.74577, 34.02861], [-117.74578, 34.02877]]]} | Restricted Access 2 | Renacimiento Community Center | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/81-renacimiento-community-center | 29805 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 0.157 | Renacimiento Community Ctr. | |
6086 | 6086 | 6085 | {"type": "Polygon", "coordinates": [[[-120.97533, 37.62623], [-120.97481, 37.62623], [-120.97482, 37.62608], [-120.97533, 37.62607], [-120.97533, 37.62623]]]} | Restricted Access 2 | Legion Park | 21143 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.196 | Legion Park | ||
11957 | 11957 | 11956 | {"type": "Polygon", "coordinates": [[[-118.4631, 34.04049], [-118.4631, 34.04049], [-118.46238, 34.04081], [-118.46291, 34.04033], [-118.4631, 34.04049]]]} | Restricted Access 2 | Bundy Triangle | 28785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.22 | Bundy Triangle | ||
14087 | 14087 | 14086 | {"type": "Polygon", "coordinates": [[[-118.2036, 34.20436], [-118.2036, 34.20462], [-118.20323, 34.20462], [-118.20323, 34.20436], [-118.2036, 34.20436]]]} | Restricted Access 2 | Skate Park | http://www.lcf.ca.gov/parks/skate | 31585 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks-rec | City 2 | 0.246 | Skate Park | |
12217 | 12217 | 12216 | {"type": "Polygon", "coordinates": [[[-118.24292, 33.94311], [-118.24258, 33.94313], [-118.24261, 33.94276], [-118.24292, 33.94277], [-118.24292, 33.94311]]]} | Restricted Access 2 | Watts Historic Train Station | 29326 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | http://www.crala.org/internet-site/index.cfm | City 2 | 0.287 | Watts Historic Train Station | ||
11241 | 11241 | 11240 | {"type": "Polygon", "coordinates": [[[-118.04682, 34.05004], [-118.04634, 34.05004], [-118.04634, 34.0499], [-118.04661, 34.04989], [-118.0466, 34.04959], [-118.04682, 34.04959], [-118.04682, 34.05004]]]} | Restricted Access 2 | Mini Center | 29846 | 1402 | South El Monte, City of 595 | City 2 | City Agency 2 | http://www.ci.south-el-monte.ca.us/CITYDEPARTMENTSSERVICES/CommunityServices/ParksandRecreationDivision.aspx | City 2 | 0.338 | Mini Ctr. | ||
12607 | 12607 | 12606 | {"type": "Polygon", "coordinates": [[[-118.23026, 34.16966], [-118.23015, 34.16981], [-118.2301, 34.16985], [-118.23004, 34.16995], [-118.22998, 34.16996], [-118.2299, 34.16992], [-118.22991, 34.16982], [-118.22989, 34.16978], [-118.22982, 34.16973], [-118.22962, 34.1697], [-118.22975, 34.16956], [-118.2298, 34.16948], [-118.23026, 34.16966]]]} | Restricted Access 2 | Verdugo Skate Park | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/verdugo-skate-park | 29697 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.355 | Verdugo Skate Park | 2004 |
12612 | 12612 | 12611 | {"type": "Polygon", "coordinates": [[[-118.40261, 33.92509], [-118.40215, 33.92509], [-118.40215, 33.92477], [-118.40261, 33.92477], [-118.40261, 33.92509]]]} | Restricted Access 2 | Camp Eucalyptus | 29706 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 0.377 | Camp Eucalyptus | ||
14175 | 14175 | 14174 | {"type": "Polygon", "coordinates": [[[-118.08661, 34.0972], [-118.0861, 34.09721], [-118.0861, 34.09691], [-118.08661, 34.09691], [-118.08661, 34.0972]]]} | Restricted Access 2 | Roosevelt Park | 31646 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | http://www.sangabrielcity.com/ | City 2 | 0.38 | Roosevelt Park | ||
12705 | 12705 | 12704 | {"type": "Polygon", "coordinates": [[[-118.03194, 33.98457], [-118.03194, 33.98501], [-118.03164, 33.98513], [-118.03164, 33.98457], [-118.03194, 33.98457]]]} | Restricted Access 2 | Bailey Ranch House and Park | 29859 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 0.382 | Bailey Ranch House and Park | ||
12629 | 12629 | 12628 | {"type": "Polygon", "coordinates": [[[-118.08587, 34.09653], [-118.08587, 34.09696], [-118.08546, 34.09696], [-118.08547, 34.09653], [-118.08587, 34.09653]]]} | Restricted Access 2 | Roosevelt Elementary Tennis Courts | 29746 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | http://www.sangabrielcity.com/ | City 2 | 0.442 | Roosevelt Elementary Tennis Courts | ||
12772 | 12772 | 12771 | {"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 | Lawn Bowling Green | http://www.hermosabch.org/index.aspx?page=262 | 29962 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 0.443 | Lawn Bowling Green | 1958 |
10850 | 10850 | 10849 | {"type": "Polygon", "coordinates": [[[-118.23092, 34.19922], [-118.23089, 34.19923], [-118.23031, 34.19921], [-118.23026, 34.19919], [-118.23025, 34.19914], [-118.23034, 34.19874], [-118.23037, 34.19871], [-118.23041, 34.19871], [-118.23092, 34.19917], [-118.23092, 34.19922]]]} | Restricted Access 2 | Sparr Heights Community Center | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/sparr-heights-community-center | 29349 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.503 | Sparr Heights Community Ctr. | |
12637 | 12637 | 12636 | {"type": "Polygon", "coordinates": [[[-118.10867, 34.09787], [-118.1084, 34.09799], [-118.10834, 34.09808], [-118.10827, 34.09805], [-118.10823, 34.0981], [-118.10818, 34.09809], [-118.10813, 34.09816], [-118.10801, 34.09811], [-118.1084, 34.09743], [-118.10867, 34.09787]]]} | Restricted Access 2 | Grapevine Arbor Park and Adult Recreation Center | 29751 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | http://www.sangabrielcity.com/ | City 2 | 0.517 | Grapevine Arbor Park and Adult Rec. Ctr. | ||
12663 | 12663 | 12662 | {"type": "Polygon", "coordinates": [[[-118.35177, 33.8854], [-118.35106, 33.8854], [-118.35104, 33.88537], [-118.35099, 33.88502], [-118.35116, 33.88502], [-118.35131, 33.88511], [-118.35148, 33.88516], [-118.35162, 33.88518], [-118.35177, 33.88517], [-118.35177, 33.8854]]]} | Restricted Access 2 | Dan McKenzie Community Gardens | http://www.lawndalecity.org/html/depthtml/csd/McKenzieGarden.html | 29797 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ | City 2 | 0.544 | Dan McKenzie Community Gardens | |
13566 | 13566 | 13565 | {"type": "Polygon", "coordinates": [[[-118.17797, 33.79308], [-118.17745, 33.79307], [-118.17745, 33.79266], [-118.17796, 33.79266], [-118.17797, 33.79275], [-118.17797, 33.79308]]]} | Restricted Access 2 | Martin Luther King Jr. Park | 32772 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.547 | Martin Luther King Jr. Park | ||
14161 | 14161 | 14160 | {"type": "Polygon", "coordinates": [[[-118.35352, 34.18058], [-118.3535, 34.18106], [-118.35346, 34.18107], [-118.35306, 34.18107], [-118.35307, 34.18057], [-118.35352, 34.18058]]]} | Restricted Access 2 | Maple Street Playground | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground | 31626 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 0.55 | Maple Street Playground | |
14173 | 14173 | 14172 | {"type": "Polygon", "coordinates": [[[-118.29818, 34.06162], [-118.29617, 34.06163], [-118.29617, 34.06163], [-118.29617, 34.06159], [-118.29669, 34.06159], [-118.2967, 34.06149], [-118.29818, 34.06147], [-118.29818, 34.06162]]]} | Restricted Access 2 | Robert F Kennedy Inspiration Park | http://www.laparks.org/commissionerhtm/pdf2010/oct06/10-266.pdf | 31643 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.576 | Robert F Kennedy Inspiration 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]);