superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,118 rows where ACCESS_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 66
- University of California 39
- Woodbridge Village Association 30
- United States Fish and Wildlife Service 25
- Home Owners Association - Unknown Name 23
- Sacramento, County of 21
- Whittier, City of 20
- Los Angeles, City of 19
- East Bay Regional Park District 18
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- Sempervirens Fund 16
- San Ramon, City of 15
- Los Angeles Unified School District 15
- Land Trust of Napa County 14
- Big Sur Land Trust 14
- Los Angeles, County of 13
- 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
- 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
- United States Army Corps of Engineers 6
- …
MNG_AG_TYP 25
- City Agency 342
- Home Owners Association 184
- Non Profit - Land Trust 129
- State Agency 125
- Recreation/Parks District 62
- County Agency 56
- Federal Agency 52
- School District 35
- Non Profit - Conservation 13
- Water District 13
- County Agency - Parks 11
- County Agency - Other 10
- Commercial 9
- Open Space District 7
- Non Profit - Other 6
- 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
ACCESS_TYP 1
- Restricted Access · 1,078 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
237 | 237 | 236 | {"type": "Polygon", "coordinates": [[[-118.41726, 34.06839], [-118.41627, 34.06893], [-118.41612, 34.06875], [-118.41596, 34.06861], [-118.41582, 34.06852], [-118.41542, 34.06833], [-118.41525, 34.0682], [-118.41505, 34.068], [-118.41489, 34.06775], [-118.41483, 34.06759], [-118.41478, 34.06733], [-118.41477, 34.06722], [-118.41588, 34.06722], [-118.41602, 34.06756], [-118.41573, 34.06767], [-118.41586, 34.06795], [-118.41595, 34.06793], [-118.416, 34.06794], [-118.41609, 34.06801], [-118.41588, 34.0681], [-118.41597, 34.06832], [-118.41609, 34.0683], [-118.41627, 34.0687], [-118.41651, 34.06863], [-118.41669, 34.06851], [-118.41654, 34.06811], [-118.41696, 34.06797], [-118.41726, 34.06839]]]} | Restricted Access 2 | El Rodeo Elementary School Park | 31884 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 4.009 | El Rodeo Elementary School Park | ||
238 | 238 | 237 | {"type": "Polygon", "coordinates": [[[-118.11657, 33.91793], [-118.11657, 33.91795], [-118.11639, 33.9182], [-118.11639, 33.91832], [-118.1159, 33.91833], [-118.11589, 33.9183], [-118.11582, 33.9183], [-118.11581, 33.91828], [-118.11572, 33.91828], [-118.11571, 33.91809], [-118.11509, 33.9181], [-118.11507, 33.91806], [-118.11486, 33.91806], [-118.11484, 33.91809], [-118.11464, 33.91809], [-118.11463, 33.91875], [-118.11356, 33.91874], [-118.11419, 33.91728], [-118.11434, 33.91721], [-118.11651, 33.9172], [-118.11657, 33.91725], [-118.11657, 33.91793]]]} | Restricted Access 2 | Columbus High School Park | 31885 | 2368 | Downey Unified School District 1095 | Special District 4 | School District 21 | http://www.dusd.net/ | Special District 4 | 7.586 | Columbus High School Park | ||
239 | 239 | 238 | {"type": "Polygon", "coordinates": [[[-118.03099, 34.1252], [-118.02957, 34.12521], [-118.02955, 34.12535], [-118.02912, 34.12535], [-118.0291, 34.12542], [-118.02813, 34.12543], [-118.02812, 34.12478], [-118.02925, 34.12479], [-118.02927, 34.12465], [-118.02978, 34.12463], [-118.0298, 34.12408], [-118.02984, 34.12407], [-118.02985, 34.12371], [-118.03014, 34.12371], [-118.03015, 34.12396], [-118.03097, 34.12395], [-118.03099, 34.1252]]]} | Restricted Access 2 | Dana Middle School Park | http://da.ausd.net/ | 31886 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 6.605 | Dana Middle School Park | |
240 | 240 | 239 | {"type": "Polygon", "coordinates": [[[-118.0253, 34.15295], [-118.02529, 34.15431], [-118.02515, 34.15463], [-118.02234, 34.1547], [-118.0223, 34.1529], [-118.0231, 34.15289], [-118.02313, 34.15299], [-118.0253, 34.15295]]]} | Restricted Access 2 | Highland Oaks Middle School Park | 31887 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 12.835 | Highland Oaks Middle School Park | ||
241 | 241 | 240 | {"type": "Polygon", "coordinates": [[[-118.04253, 34.10858], [-118.04125, 34.10859], [-118.04124, 34.10783], [-118.0413, 34.1078], [-118.04245, 34.10778], [-118.04249, 34.10779], [-118.04251, 34.10784], [-118.04253, 34.10858]]]} | Restricted Access 2 | Longley Way Elementary School Park | http://lw.ausd.net/ | 31888 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 2.551 | Longley Way Elementary School Park | |
242 | 242 | 241 | {"type": "Polygon", "coordinates": [[[-118.06394, 34.13718], [-118.06273, 34.13744], [-118.06271, 34.13685], [-118.06273, 34.13669], [-118.06278, 34.1366], [-118.06286, 34.13651], [-118.06329, 34.13619], [-118.06337, 34.13619], [-118.0634, 34.13621], [-118.06394, 34.13718]]]} | Restricted Access 2 | Hugo Reid Elementary School Park | http://hr.ausd.net/ | 31889 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 2.432 | Hugo Reid Elementary School Park | |
243 | 243 | 242 | {"type": "Polygon", "coordinates": [[[-118.38508, 33.88995], [-118.38506, 33.89099], [-118.38313, 33.89099], [-118.38313, 33.88995], [-118.38508, 33.88995]]]} | Restricted Access 2 | Manhattan Beach Middle School Park | 31890 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | http://www.ci.manhattan-beach.ca.us/city-services/parks-and-recreation | City 2 | 5.093 | Manhattan Beach Middle School Park | ||
244 | 244 | 243 | {"type": "Polygon", "coordinates": [[[-118.39159, 33.87645], [-118.39051, 33.87645], [-118.39049, 33.8761], [-118.38953, 33.87609], [-118.38954, 33.87549], [-118.39085, 33.8755], [-118.39082, 33.87512], [-118.39073, 33.87508], [-118.39054, 33.87495], [-118.3902, 33.87478], [-118.39011, 33.87469], [-118.39015, 33.87372], [-118.39005, 33.8737], [-118.39005, 33.87332], [-118.39045, 33.87331], [-118.39045, 33.87294], [-118.39153, 33.87292], [-118.39158, 33.87294], [-118.39159, 33.87645]]]} | Restricted Access 2 | Mira Costa High School Park | 31891 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | http://www.ci.manhattan-beach.ca.us/city-services/parks-and-recreation | City 2 | 12.297 | Mira Costa High School Park | ||
248 | 248 | 247 | {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.337, 33.91011], [-118.33698, 33.91027], [-118.3365, 33.91027], [-118.3365, 33.90959], [-118.33727, 33.90959], [-118.33727, 33.9101]]]} | Restricted Access 2 | Zela Davis Elementary School Park | 31892 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 1.202 | Zela Davis Elementary School Park | ||
249 | 249 | 248 | {"type": "Polygon", "coordinates": [[[-117.90331, 34.11113], [-117.90329, 34.11315], [-117.90111, 34.11315], [-117.90112, 34.11113], [-117.90331, 34.11113]]]} | Restricted Access 2 | Murray Elementary School Park | http://www.ci.azusa.ca.us/index.aspx?nid=1240 | 31893 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 11.167 | Murray Elementary School Park | |
250 | 250 | 249 | {"type": "Polygon", "coordinates": [[[-117.89009, 34.11199], [-117.89009, 34.11271], [-117.88919, 34.11272], [-117.88919, 34.11399], [-117.88855, 34.11397], [-117.88454, 34.11395], [-117.88517, 34.11335], [-117.88816, 34.11197], [-117.89009, 34.11199]]]} | Restricted Access 2 | Gladstone Street School Park | http://www.ci.azusa.ca.us/index.aspx?nid=1237 | 31894 | 2365 | Azusa Unified School District 720 | Special District 4 | School District 21 | https://ausd-ca.schoolloop.com/ | Special District 4 | 17.188 | Gladstone Street School Park | |
251 | 251 | 250 | {"type": "Polygon", "coordinates": [[[-117.88794, 34.12518], [-117.88793, 34.12692], [-117.88585, 34.12692], [-117.88585, 34.12522], [-117.88586, 34.12519], [-117.8859, 34.12518], [-117.88794, 34.12518]]]} | Restricted Access 2 | Powell School Park | http://www.ci.azusa.ca.us/index.aspx?nid=1241 | 31895 | 2365 | Azusa Unified School District 720 | Special District 4 | School District 21 | https://ausd-ca.schoolloop.com/ | Special District 4 | 9.141 | Powell School Park | |
252 | 252 | 251 | {"type": "Polygon", "coordinates": [[[-118.09392, 34.57701], [-118.09376, 34.577], [-118.09353, 34.57702], [-118.09313, 34.57721], [-118.09303, 34.57728], [-118.09289, 34.57749], [-118.09283, 34.57778], [-118.09277, 34.57785], [-118.09272, 34.57787], [-118.09241, 34.57791], [-118.09207, 34.57802], [-118.09192, 34.57809], [-118.0918, 34.57819], [-118.09175, 34.57826], [-118.09175, 34.57832], [-118.09188, 34.5785], [-118.08953, 34.57851], [-118.08949, 34.57642], [-118.08727, 34.57643], [-118.08722, 34.57287], [-118.08741, 34.57287], [-118.08742, 34.57284], [-118.09051, 34.57283], [-118.09055, 34.57434], [-118.09386, 34.57433], [-118.09392, 34.57701]]]} | Restricted Access 2 | Palmdale High School Park | 31898 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | http://www.cityofpalmdale.org/Residents/Recreation-and-Culture | City 2 | 65.202 | Palmdale High School Park | ||
253 | 253 | 252 | {"type": "Polygon", "coordinates": [[[-118.01049, 34.5633], [-118.00939, 34.56331], [-118.00939, 34.56503], [-118.00932, 34.56507], [-118.00926, 34.56512], [-118.00922, 34.56518], [-118.0092, 34.56526], [-118.00928, 34.56553], [-118.00928, 34.56664], [-118.00905, 34.56665], [-118.00905, 34.56693], [-118.0051, 34.56689], [-118.0051, 34.56571], [-118.00515, 34.56527], [-118.0052, 34.56499], [-118.00528, 34.56474], [-118.00554, 34.56419], [-118.00553, 34.56417], [-118.0056, 34.56404], [-118.00577, 34.56379], [-118.00605, 34.56344], [-118.00652, 34.563], [-118.00653, 34.56298], [-118.00818, 34.56156], [-118.00851, 34.56129], [-118.00863, 34.56129], [-118.00889, 34.56144], [-118.00917, 34.56152], [-118.00936, 34.56153], [-118.01049, 34.56155], [-118.01049, 34.5633]]]} | Restricted Access 2 | Knight High School Park | 31899 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | http://www.cityofpalmdale.org/Residents/Recreation-and-Culture | City 2 | 51.04 | Knight High School Park | ||
254 | 254 | 253 | {"type": "Polygon", "coordinates": [[[-118.3891, 33.87781], [-118.38909, 33.87807], [-118.38897, 33.87812], [-118.38899, 33.87818], [-118.38896, 33.87829], [-118.38871, 33.87832], [-118.38822, 33.87867], [-118.38813, 33.87862], [-118.38785, 33.87891], [-118.38771, 33.87892], [-118.38773, 33.87889], [-118.38773, 33.87885], [-118.3877, 33.87882], [-118.38766, 33.8788], [-118.38748, 33.8788], [-118.38747, 33.87781], [-118.3891, 33.87781]]]} | Restricted Access 2 | Pennekamp Elementary School Park | 31900 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | http://www.ci.manhattan-beach.ca.us/city-services/parks-and-recreation | City 2 | 3.12 | Pennekamp Elementary School Park | ||
255 | 255 | 254 | {"type": "Polygon", "coordinates": [[[-118.39163, 33.89006], [-118.38988, 33.89005], [-118.38988, 33.88964], [-118.39022, 33.88964], [-118.39023, 33.88946], [-118.39077, 33.88939], [-118.39128, 33.88918], [-118.39162, 33.88918], [-118.39163, 33.89006]]]} | Restricted Access 2 | Meadows Elementary School Park | 31901 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | http://www.ci.manhattan-beach.ca.us/city-services/parks-and-recreation | City 2 | 2.992 | Meadows Elementary School Park | ||
256 | 256 | 255 | {"type": "MultiPolygon", "coordinates": [[[[-118.40196, 33.89025], [-118.40048, 33.89025], [-118.40048, 33.889], [-118.40097, 33.889], [-118.40099, 33.88903], [-118.40143, 33.88903], [-118.40138, 33.88955], [-118.40195, 33.88957], [-118.40196, 33.89025]]], [[[-118.40318, 33.88807], [-118.40274, 33.88807], [-118.40272, 33.88836], [-118.40218, 33.88834], [-118.40217, 33.88748], [-118.40318, 33.88748], [-118.40318, 33.88807]]]]} | Restricted Access 2 | Pacific Elementary School Park | 31902 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | http://www.ci.manhattan-beach.ca.us/city-services/parks-and-recreation | City 2 | 5.76 | Pacific Elementary School Park | ||
257 | 257 | 256 | {"type": "Polygon", "coordinates": [[[-118.40404, 33.87742], [-118.4036, 33.87826], [-118.40378, 33.87836], [-118.40366, 33.87858], [-118.40298, 33.87883], [-118.40279, 33.87846], [-118.40262, 33.87851], [-118.40236, 33.878], [-118.40404, 33.87742]]]} | Restricted Access 2 | Robinson Elementary School Park | 31903 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | http://www.ci.manhattan-beach.ca.us/city-services/parks-and-recreation | City 2 | 2.959 | Robinson Elementary School Park | ||
258 | 258 | 257 | {"type": "Polygon", "coordinates": [[[-118.41174, 33.895], [-118.41119, 33.89534], [-118.41102, 33.89519], [-118.41023, 33.89479], [-118.41014, 33.89462], [-118.41066, 33.89448], [-118.41069, 33.8945], [-118.41147, 33.8943], [-118.41174, 33.895]]]} | Restricted Access 2 | Grand View Elementary School Park | 31904 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | http://www.ci.manhattan-beach.ca.us/city-services/parks-and-recreation | City 2 | 2.292 | Grand View Elementary School Park | ||
260 | 260 | 259 | {"type": "Polygon", "coordinates": [[[-118.03121, 34.13667], [-118.0302, 34.13668], [-118.03018, 34.13643], [-118.02964, 34.13643], [-118.02962, 34.13597], [-118.03019, 34.13596], [-118.0302, 34.13575], [-118.03119, 34.13574], [-118.03121, 34.13667]]]} | Restricted Access 2 | First Avenue Middle School Park | http://fa.ausd.net/ | 31905 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 3.021 | First Avenue Middle School 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]);