superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,118 rows where ACCESS_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 67
- University of California 39
- Woodbridge Village Association 31
- United States Fish and Wildlife Service 25
- Home Owners Association - Unknown Name 25
- Sacramento, County of 21
- Los Angeles, City of 20
- Whittier, City of 20
- East Bay Regional Park District 18
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- Sempervirens Fund 16
- Los Angeles Unified School District 16
- San Ramon, City of 15
- Los Angeles, County of 14
- Land Trust of Napa County 14
- Big Sur Land Trust 14
- The Nature Conservancy 13
- California Department of Parks and Recreation 11
- San Diego, City of 10
- Long Beach, City of 9
- San Francisco - Public Utilities Commission, City and County of 8
- Sonoma Land Trust 8
- Arcadia, City of 8
- Sonoma County Agricultural Preservation and Open Space District 8
- Manhattan Beach, City of 8
- Hayward Area Recreation and Park District 7
- Amerige Heights Community Association 7
- Los Angeles - Department of Parks and Recreation, County of 7
- San Jose, City of 6
- Carlsbad, City of 6
- …
MNG_AG_TYP 25
- City Agency 356
- Home Owners Association 199
- Non Profit - Land Trust 130
- State Agency 126
- Recreation/Parks District 62
- County Agency 57
- Federal Agency 52
- School District 38
- Non Profit - Conservation 17
- Water District 13
- County Agency - Parks 11
- County Agency - Other 10
- Commercial 9
- Open Space District 7
- Non Profit - Other 7
- Joint Powers Authority 5
- Flood District 3
- Community Services District 3
- Other 3
- Conservation District 3
- Irrigation District 2
- Sanitation District 2
- Metropolitan Planning Organization 1
- Home Owners Associatin 1
- Non Profit - Education 1
LAYER 14 ✖
- City 356
- Private 212
- Non Governmental Organization 155
- Special District 139
- County 78
- California Department of Fish and Wildlife 67
- Other State 48
- US Fish and Wildlife Service 25
- Other Federal 15
- California Department of Parks and Recreation 11
- National Park Service 5
- US Bureau of Land Management 4
- US Military/Defense 2
- US Forest Service 1
ACCESS_TYP 1
- Restricted Access · 1,118 ✖
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 | |
2820 | 2820 | 2819 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | Chabot - Garin Trail Corridor | 17108 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.064 | Chabot - Garin Trail Corridor | ||
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 | ||
5150 | 5150 | 5149 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 0.079 | Hillcrest And Ocean View Lots | ||
10396 | 10396 | 10395 | {"type": "Polygon", "coordinates": [[[-121.93363, 36.54329], [-121.93317, 36.54325], [-121.93307, 36.54313], [-121.93323, 36.54306], [-121.93329, 36.54312], [-121.93337, 36.54317], [-121.93363, 36.54329]]]} | Restricted Access 2 | Tor House | 26411 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.129 | Tor House | ||
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. | |
12666 | 12666 | 12665 | {"type": "Polygon", "coordinates": [[[-118.29797, 34.03179], [-118.29758, 34.03179], [-118.29757, 34.03163], [-118.29797, 34.03162], [-118.29797, 34.03179]]]} | Restricted Access 2 | Erika J. Glazer Community Garden | 29800 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 0.165 | Erika J. Glazer Community Garden | ||
3780 | 3780 | 3779 | {"type": "Polygon", "coordinates": [[[-122.11457, 37.70147], [-122.11456, 37.70154], [-122.11451, 37.7016], [-122.11439, 37.70152], [-122.11433, 37.70151], [-122.11428, 37.70154], [-122.11413, 37.70143], [-122.11426, 37.70132], [-122.11449, 37.7013], [-122.11457, 37.70147]]]} | Restricted Access 2 | HOA Community Park | 33332 | 6126 | Marcella Renaissance Owners Association 867 | Private 7 | Home Owners Association 15 | Private 14 | 0.195 | HOA Community Park | |||
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 | |
7063 | 7063 | 7062 | {"type": "Polygon", "coordinates": [[[-121.91841, 36.54792], [-121.91818, 36.54805], [-121.91774, 36.54778], [-121.91774, 36.54777], [-121.9183, 36.54778], [-121.91841, 36.54792]]]} | Restricted Access 2 | Mission Trails/Probasco | 22315 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.255 | Mission Trails/Probasco | ||
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 | ||
13012 | 13012 | 13011 | {"type": "Polygon", "coordinates": [[[-116.95852, 32.65971], [-116.95848, 32.65998], [-116.95841, 32.66002], [-116.95813, 32.66], [-116.95816, 32.65968], [-116.95852, 32.65971]]]} | Restricted Access 2 | Kensington Road Park | 33346 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.287 | Kensington Road Park | |||
13729 | 13729 | 13728 | {"type": "Polygon", "coordinates": [[[-117.17059, 34.11122], [-117.17054, 34.11131], [-117.17047, 34.11137], [-117.17038, 34.1114], [-117.1703, 34.11142], [-117.17021, 34.11141], [-117.17011, 34.11137], [-117.17005, 34.11132], [-117.17, 34.11124], [-117.17006, 34.11117], [-117.17052, 34.11115], [-117.17059, 34.11122]]]} | Restricted Access 2 | Palm View Park | http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd | 33136 | 7031 | East Highlands Ranch MHOA 839 | Private 7 | Home Owners Association 15 | http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd | Private 14 | 0.289 | Palm View Park | |
1611 | 1611 | 1610 | {"type": "Polygon", "coordinates": [[[-117.77742, 33.72225], [-117.77734, 33.72234], [-117.77727, 33.72232], [-117.77724, 33.72236], [-117.77728, 33.7224], [-117.77727, 33.72242], [-117.77686, 33.72215], [-117.77703, 33.72199], [-117.7771, 33.72198], [-117.77741, 33.7222], [-117.77742, 33.72225]]]} | Restricted Access 2 | Bunny Park | 32251 | 6012 | Northpark Square Maintenance Association 1008 | Private 7 | Home Owners Association 15 | http://www.ch-pm.com/index.php/northpark/ | Private 14 | 0.315 | Bunny Park | ||
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 |
5091 | 5091 | 5090 | {"type": "Polygon", "coordinates": [[[-121.93865, 36.50129], [-121.93862, 36.50189], [-121.93831, 36.5019], [-121.93831, 36.50186], [-121.93839, 36.50179], [-121.93842, 36.50173], [-121.9384, 36.50165], [-121.93832, 36.5016], [-121.93831, 36.50147], [-121.93848, 36.50138], [-121.93848, 36.50133], [-121.93865, 36.50129]]]} | Restricted Access 2 | Highlands Inn turnout | 19940 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.373 | Highlands Inn turnout | ||
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 |
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]);