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 LAYER
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
- 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
- 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
- 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 340
- Home Owners Association 199
- Non Profit - Land Trust 130
- State Agency 126
- Recreation/Parks District 62
- County Agency 57
- Federal Agency 48
- 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
ACCESS_TYP 1
- Restricted Access · 1,098 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
267 | 267 | 266 | {"type": "Polygon", "coordinates": [[[-118.00234, 33.92712], [-118.00162, 33.92729], [-118.0016, 33.92713], [-118.0015, 33.92688], [-118.00137, 33.92672], [-118.00117, 33.92657], [-118.00098, 33.92647], [-118.00074, 33.92575], [-118.0018, 33.92549], [-118.00234, 33.92712]]]} | Restricted Access 2 | Scott Avenue Elementary School Park | 31906 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 4.025 | Scott Avenue Elementary School Park | ||
268 | 268 | 267 | {"type": "Polygon", "coordinates": [[[-117.99819, 33.95654], [-117.99808, 33.957], [-117.99805, 33.95723], [-117.99805, 33.95742], [-117.99797, 33.95761], [-117.99795, 33.95761], [-117.99766, 33.9579], [-117.99726, 33.95842], [-117.99394, 33.95658], [-117.99393, 33.95522], [-117.99456, 33.95479], [-117.9948, 33.95469], [-117.99819, 33.95654]]]} | Restricted Access 2 | La Serna High School Park | 31907 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 22.497 | La Serna High School Park | ||
269 | 269 | 268 | {"type": "Polygon", "coordinates": [[[-118.02225, 33.94131], [-118.02046, 33.94359], [-118.01735, 33.94146], [-118.01943, 33.93937], [-118.02225, 33.94131]]]} | Restricted Access 2 | California High School Park | 31908 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 26.419 | California High School Park | ||
270 | 270 | 269 | {"type": "Polygon", "coordinates": [[[-118.04953, 33.95322], [-118.04794, 33.95479], [-118.04703, 33.95414], [-118.04711, 33.95402], [-118.04661, 33.95363], [-118.0473, 33.95299], [-118.04766, 33.95263], [-118.04765, 33.95257], [-118.04729, 33.95235], [-118.04701, 33.95253], [-118.04688, 33.95256], [-118.04672, 33.95256], [-118.04499, 33.95139], [-118.04575, 33.95062], [-118.04953, 33.95322]]]} | Restricted Access 2 | Sierra Vista Adult School Park | 31909 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 16.347 | Sierra Vista Adult School Park | ||
271 | 271 | 270 | {"type": "Polygon", "coordinates": [[[-118.04661, 33.98098], [-118.0466, 33.98257], [-118.04655, 33.98262], [-118.0434, 33.98262], [-118.04335, 33.98259], [-118.04335, 33.98089], [-118.0454, 33.98089], [-118.04542, 33.98097], [-118.04661, 33.98098]]]} | Restricted Access 2 | Whittier High School Park | 31910 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 14.027 | Whittier High 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]);