superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
135 rows where ACCESS_TYP = 2 and MNG_AG_LEV = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AGENCY >30
- East Bay Regional Park District 18
- Los Angeles Unified School District 16
- Sonoma County Agricultural Preservation and Open Space District 8
- Hayward Area Recreation and Park District 7
- Monterey Peninsula Regional Park District 4
- Conejo Open Space Conservation Agency 4
- Azusa Unified School District 4
- Santa Clara Valley Water District 4
- Conejo Recreation and Park District 3
- Livermore Area Recreation and Park District 3
- Santa Clara Valley Open Space Authority 3
- Conejo Valley Unified School District 3
- Watershed Conservation Authority 3
- Mountains Recreation and Conservation Authority 2
- Rancho Simi Recreation and Park District 2
- Sonoma County Water Agency 2
- East Bay Municipal Utility District 2
- Southgate Recreation and Park District 2
- Midpeninsula Regional Open Space District 2
- San Gabriel Unified School District 2
- Culver City Unified School District 2
- Los Nietos School District 2
- Santa Barbara Flood Control and Water Conserv. District 1
- Napa County Regional Park and Open Space District 1
- Valley-Wide Recreation and Park District 1
- Coalinga-Huron Recreation and Park District 1
- Desert Recreation District 1
- Los Angeles County Flood Control District 1
- Greater Vallejo Recreation and Park District 1
- Brooktrails Community Services District 1
- …
MNG_AG_TYP 11
ACCESS_TYP 1
- Restricted Access · 135 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
13956 | 13956 | 13955 | {"type": "Polygon", "coordinates": [[[-120.23597, 37.96677], [-120.23584, 37.96674], [-120.23549, 37.9667], [-120.23553, 37.96647], [-120.2356, 37.96631], [-120.2357, 37.96629], [-120.23571, 37.96618], [-120.2358, 37.96617], [-120.23586, 37.9663], [-120.23597, 37.96677]]]} | Restricted Access 2 | Tuolumne Community Garden | https://www.tuolumnerecreation.com/TPRD_facilities.html | 32549 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 0.433 | Tuolumne Community Garden | 1996 |
9 | 9 | 8 | {"type": "Polygon", "coordinates": [[[-118.28861, 34.08351], [-118.28811, 34.08351], [-118.28811, 34.08309], [-118.28861, 34.08309], [-118.28861, 34.08351]]]} | Restricted Access 2 | Dayton Heights Elementary School Park | 31937 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | http://home.lausd.net/ | Special District 4 | 0.517 | Dayton Heights Elementary School Park | ||
7748 | 7748 | 7747 | {"type": "Polygon", "coordinates": [[[-122.20297, 37.89593], [-122.20284, 37.89706], [-122.20284, 37.89706], [-122.20247, 37.89609], [-122.20297, 37.89593]]]} | Restricted Access 2 | Orinda | 23201 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 0.656 | Orinda | ||
12458 | 12458 | 12457 | {"type": "Polygon", "coordinates": [[[-118.51949, 34.4416], [-118.51896, 34.44198], [-118.51857, 34.44159], [-118.51911, 34.44123], [-118.51949, 34.4416]]]} | Restricted Access 2 | Saugus High School Joint Use Facility | 29502 | 2389 | William S. Hart Union High School District 1094 | Special District 4 | School District 21 | http://www.hartdistrict.org/ | Special District 4 | 0.881 | Saugus High School Joint Use Facility | ||
14113 | 14113 | 14112 | {"type": "Polygon", "coordinates": [[[-121.96985, 37.35893], [-121.96981, 37.35894], [-121.96977, 37.359], [-121.96974, 37.359], [-121.96972, 37.35903], [-121.96973, 37.35906], [-121.96901, 37.3589], [-121.96895, 37.35886], [-121.96892, 37.3588], [-121.96887, 37.35846], [-121.96961, 37.35847], [-121.96974, 37.35889], [-121.96985, 37.35888], [-121.96985, 37.35893]]]} | Restricted Access 2 | Santa Clara Skate Park | https://www.santaclaraca.gov/our-city/departments-g-z/parks-recreation/community-centers/skate-park | 33658 | 2440 | Santa Clara Unified School District 843 | Special District 4 | School District 21 | https://www.santaclarausd.org/ | Special District 4 | 0.965 | Santa Clara Skate Park | |
14155 | 14155 | 14154 | {"type": "Polygon", "coordinates": [[[-118.04529, 34.12614], [-118.04434, 34.12614], [-118.04434, 34.12596], [-118.04437, 34.12594], [-118.04436, 34.12564], [-118.04529, 34.12563], [-118.04529, 34.12614]]]} | Restricted Access 2 | Holly Avenue Park | http://www.ci.arcadia.ca.us/docs/park_list.pdf | 31618 | 2315 | Arcadia Unified School District 1080 | Special District 4 | School District 21 | http://site.ausd.net/ | Special District 4 | 1.202 | Holly Avenue Park | |
291 | 291 | 290 | {"type": "Polygon", "coordinates": [[[-118.24192, 34.11743], [-118.24122, 34.11792], [-118.24083, 34.11751], [-118.24084, 34.11749], [-118.24152, 34.11701], [-118.24192, 34.11743]]]} | Restricted Access 2 | Washington Irving Middle School Park | 31926 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | http://home.lausd.net/ | Special District 4 | 1.236 | Washington Irving Middle School Park | ||
292 | 292 | 291 | {"type": "Polygon", "coordinates": [[[-118.26901, 34.01254], [-118.26854, 34.01333], [-118.26797, 34.01311], [-118.26846, 34.01233], [-118.26901, 34.01254]]]} | Restricted Access 2 | Trinity Street Elementary School Park | 31927 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | http://home.lausd.net/ | Special District 4 | 1.374 | Trinity Street Elementary School Park | ||
11657 | 11657 | 11656 | {"type": "Polygon", "coordinates": [[[-118.26649, 33.96746], [-118.26648, 33.96797], [-118.26529, 33.96796], [-118.26529, 33.96746], [-118.26649, 33.96746]]]} | Restricted Access 2 | Freemont High School Wellness Center and Community Garden | 30341 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | http://home.lausd.net/ | Special District 4 | 1.529 | Freemont High School Wellness Ctr. and Community Garden | 2012 | |
304 | 304 | 303 | {"type": "Polygon", "coordinates": [[[-118.21606, 34.03198], [-118.21544, 34.03292], [-118.21488, 34.03268], [-118.21549, 34.03173], [-118.21606, 34.03198]]]} | Restricted Access 2 | Bishop Mora Salesian High School Park | 31939 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | http://home.lausd.net/ | Special District 4 | 1.732 | Bishop Mora Salesian High School Park | ||
7158 | 7158 | 7157 | {"type": "Polygon", "coordinates": [[[-122.71557, 38.43664], [-122.7155, 38.43665], [-122.7153, 38.43673], [-122.71434, 38.43728], [-122.71363, 38.43745], [-122.71335, 38.43707], [-122.71387, 38.43698], [-122.71424, 38.43687], [-122.71426, 38.43689], [-122.71442, 38.43684], [-122.71474, 38.4367], [-122.71518, 38.43644], [-122.7155, 38.43632], [-122.71557, 38.43664]]]} | Restricted Access 2 | Prince Memorial Greenway | 24006 | 2156 | Sonoma County Water Agency 88 | Special District 4 | Water District 13 | http://www.scwa.ca.gov/ | Special District 4 | 1.868 | Prince Memorial Greenway | ||
1071 | 1071 | 1070 | {"type": "Polygon", "coordinates": [[[-118.25787, 34.06135], [-118.25775, 34.06152], [-118.25763, 34.06147], [-118.2576, 34.06151], [-118.2575, 34.0615], [-118.25742, 34.06151], [-118.25733, 34.06154], [-118.25725, 34.06162], [-118.2563, 34.06121], [-118.25665, 34.06065], [-118.25715, 34.06088], [-118.25715, 34.0609], [-118.25728, 34.06101], [-118.25751, 34.06111], [-118.25749, 34.06117], [-118.25787, 34.06135]]]} | Restricted Access 2 | Vista Hermosa Soccer Field | http://www.laparks.org/dos/parks/facility/vistaHermosaPk.htm | 32839 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | http://home.lausd.net/ | Special District 4 | 1.89 | Vista Hermosa Soccer Field | |
14139 | 14139 | 14138 | {"type": "Polygon", "coordinates": [[[-121.75203, 36.76544], [-121.75137, 36.76603], [-121.75062, 36.76546], [-121.75128, 36.76489], [-121.75203, 36.76544]]]} | Restricted Access 2 | Japanese School Park | 31583 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 1.971 | Japanese School Park | ||
10866 | 10866 | 10865 | {"type": "Polygon", "coordinates": [[[-118.39361, 34.0222], [-118.39299, 34.02292], [-118.39286, 34.02283], [-118.39221, 34.02248], [-118.39279, 34.02174], [-118.39361, 34.0222]]]} | Restricted Access 2 | Linwood E. Howe Playground | 29386 | 2367 | Culver City Unified School District 768 | Special District 4 | School District 21 | http://www.ccusd.org/ | Special District 4 | 2.149 | Linwood E. Howe Playground | ||
3072 | 3072 | 3071 | {"type": "Polygon", "coordinates": [[[-118.66547, 34.09257], [-118.66492, 34.09257], [-118.66491, 34.09075], [-118.66545, 34.09076], [-118.66547, 34.09257]]]} | Restricted Access 2 | Cold Creek Canyon Preserve | 17481 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2.519 | Cold Creek Canyon Preserve | ||
12326 | 12326 | 12325 | {"type": "Polygon", "coordinates": [[[-118.10299, 34.1077], [-118.1021, 34.1077], [-118.10206, 34.10769], [-118.10203, 34.1063], [-118.10278, 34.10629], [-118.10278, 34.10727], [-118.10298, 34.10729], [-118.10299, 34.1077]]]} | Restricted Access 2 | Washington School Park | 32680 | 2393 | San Gabriel Unified School District 693 | Special District 4 | School District 21 | http://www.sgusd.k12.ca.us/ | Special District 4 | 2.828 | Washington School Park | ||
13148 | 13148 | 13147 | {"type": "Polygon", "coordinates": [[[-118.06976, 33.98789], [-118.06914, 33.98854], [-118.0683, 33.98797], [-118.06846, 33.9878], [-118.06824, 33.98766], [-118.06836, 33.98758], [-118.06832, 33.98754], [-118.06856, 33.98727], [-118.0682, 33.987], [-118.06838, 33.98685], [-118.06963, 33.98777], [-118.06963, 33.9878], [-118.06976, 33.98789]]]} | Restricted Access 2 | West Whittier Elementary School Park | 31947 | 2371 | Whittier City School District 896 | Special District 4 | School District 21 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 3.14 | West Whittier Elementary School Park | ||
3638 | 3638 | 3637 | {"type": "Polygon", "coordinates": [[[-122.74565, 38.48914], [-122.74561, 38.49073], [-122.74474, 38.49073], [-122.74477, 38.48913], [-122.74565, 38.48914]]]} | Restricted Access 2 | Dogbane Preserve | 18185 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 3.336 | Dogbane Preserve | 1997 | |
12396 | 12396 | 12395 | {"type": "Polygon", "coordinates": [[[-118.41083, 34.01373], [-118.40949, 34.01447], [-118.4092, 34.01411], [-118.40949, 34.01394], [-118.40926, 34.01364], [-118.40988, 34.01309], [-118.4101, 34.0127], [-118.41032, 34.01298], [-118.41026, 34.01312], [-118.41049, 34.01341], [-118.41056, 34.01339], [-118.41083, 34.01373]]]} | Restricted Access 2 | La Ballona Playground | 29387 | 2367 | Culver City Unified School District 768 | Special District 4 | School District 21 | http://www.ccusd.org/ | Special District 4 | 3.374 | La Ballona Playground |
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]);