superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by map
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Jose, City of 218
- San Francisco, City and County of 215
- Sacramento, City of 192
- Los Angeles, City of 181
- California Department of Fish and Wildlife 170
- Ventura, City of 148
- Oakland, City of 109
- Roseville, City of 107
- California Department of Parks and Recreation 100
- Fresno, City of 90
- Consumnes Community Services District 90
- Mountains Recreation and Conservation Authority 84
- East Bay Regional Park District 79
- Hayward Area Recreation and Park District 79
- Stockton, City of 78
- Santa Rosa, City of 76
- Modesto, City of 76
- Tracy, City of 68
- Brentwood, City of 67
- Santa Barbara, County of 60
- San Ramon, City of 57
- Los Angeles, County of 56
- Bakersfield, City of 56
- Santa Cruz, City of 55
- San Luis Obispo, City of 54
- Napa, City of 54
- Manteca, City of 54
- Fremont, City of 53
- Clovis, City of 53
- Rocklin, City of 53
- …
MNG_AG_TYP 27
- City Agency 5,580
- Recreation/Parks District 753
- County Agency 599
- State Agency 372
- Non Profit - Land Trust 309
- Community Services District 163
- County Agency - Parks 121
- Water District 114
- Federal Agency 110
- Open Space District 108
- Flood District 58
- Cemetery District 53
- Non Profit - Conservation 46
- Non Profit - Other 21
- County Agency - Other 18
- School District 12
- Home Owners Association 11
- Special District - Other 10
- Irrigation District 9
- Port/Harbor District 6
- Joint Powers Authority 6
- Sanitation District 5
- Commercial 3
- Mitigation Bank 3
- Other 2
- Airport District 1
- Home Owners Associatin 1
ACCESS_TYP 4
- Open Access 7,513
- Restricted Access 457
- No Public Access 382
- Unknown Access 142
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11198 | 11198 | 11197 | {"type": "Polygon", "coordinates": [[[-118.34102, 33.92741], [-118.34102, 33.92741], [-118.34058, 33.92712], [-118.34101, 33.92713], [-118.34102, 33.92741]]]} | Open Access 1 | 118th Street Mini Park | 29761 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 0.154 | 118th Street MP | ||
10784 | 10784 | 10783 | {"type": "Polygon", "coordinates": [[[-118.34111, 34.16569], [-118.34111, 34.16573], [-118.34108, 34.16575], [-118.3406, 34.16591], [-118.33941, 34.16346], [-118.33881, 34.16365], [-118.33869, 34.16347], [-118.33852, 34.1633], [-118.33831, 34.16318], [-118.33804, 34.16307], [-118.33802, 34.16304], [-118.33803, 34.163], [-118.33952, 34.1625], [-118.33958, 34.16251], [-118.34111, 34.16569]]]} | Open Access 1 | Verdugo Park | 26991 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 6.898 | Verdugo Park | ||
4697 | 4697 | 4696 | {"type": "Polygon", "coordinates": [[[-118.34172, 34.25537], [-118.34043, 34.2563], [-118.34044, 34.25641], [-118.34035, 34.25674], [-118.34035, 34.25683], [-118.34042, 34.25704], [-118.34042, 34.25714], [-118.34039, 34.2572], [-118.34031, 34.25726], [-118.34008, 34.25733], [-118.34002, 34.25738], [-118.3399, 34.25768], [-118.33994, 34.25797], [-118.33988, 34.25807], [-118.33974, 34.25819], [-118.3397, 34.25824], [-118.33977, 34.25865], [-118.33975, 34.25872], [-118.33969, 34.2588], [-118.33959, 34.25885], [-118.33944, 34.25885], [-118.33898, 34.2586], [-118.3389, 34.25857], [-118.33883, 34.25857], [-118.3382, 34.2587], [-118.3377, 34.25897], [-118.3376, 34.25898], [-118.33701, 34.2589], [-118.3369, 34.25893], [-118.3367, 34.25901], [-118.33652, 34.25903], [-118.33522, 34.25891], [-118.33481, 34.25879], [-118.3345, 34.25867], [-118.33443, 34.25863], [-118.33438, 34.25854], [-118.33438, 34.25848], [-118.33441, 34.25841], [-118.33441, 34.25829], [-118.33439, 34.25817], [-118.33437, 34.25814], [-118.3343, 34.2581], [-118.33423, 34.25811], [-118.33402, 34.25796], [-118.33282, 34.25776], [-118.33176, 34.25745], [-118.33175, 34.25642], [-118.33162, 34.25606], [-118.33187, 34.2553], [-118.33131, 34.25461], [-118.33174, 34.2526], [-118.33464, 34.25337], [-118.34172, 34.25537]]]} | No Public Access 3 | Green Verdugo Reservoir | 19469 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 105.013 | Green Verdugo Reservoir | ||
10992 | 10992 | 10991 | {"type": "Polygon", "coordinates": [[[-118.34178, 34.19079], [-118.34176, 34.19181], [-118.34014, 34.19178], [-118.34014, 34.19041], [-118.34023, 34.19042], [-118.34024, 34.19047], [-118.34178, 34.19079]]]} | Open Access 1 | Robert E. Gross Park | 29540 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 4.869 | Robert E. Gross Park | ||
6749 | 6749 | 6748 | {"type": "Polygon", "coordinates": [[[-118.34206, 34.0409], [-118.34198, 34.04109], [-118.34142, 34.04093], [-118.34143, 34.0409], [-118.34206, 34.0409]]]} | Open Access 1 | Mascot Park | 21941 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.171 | Mascot Park | ||
12723 | 12723 | 12722 | {"type": "Polygon", "coordinates": [[[-118.34245, 33.8418], [-118.34022, 33.84182], [-118.3402, 33.84072], [-118.34244, 33.8407], [-118.34245, 33.8418]]]} | Restricted Access 2 | Toyota Sports Complex | http://www.torranceca.gov/27330.htm | 29898 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 6.219 | Toyota Sports Complex | |
10477 | 10477 | 10476 | {"type": "Polygon", "coordinates": [[[-118.34268, 34.26987], [-118.34212, 34.26999], [-118.34206, 34.26981], [-118.34091, 34.26925], [-118.33938, 34.26836], [-118.33771, 34.26708], [-118.33809, 34.26706], [-118.33825, 34.26717], [-118.33934, 34.26732], [-118.33934, 34.26743], [-118.34229, 34.26782], [-118.34195, 34.26956], [-118.34268, 34.26987]]]} | Open Access 1 | Tujunga Ponds Wildlife Sanctuary | 26562 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 12.893 | Tujunga Ponds Wildlife Sanctuary | ||
12299 | 12299 | 12298 | {"type": "Polygon", "coordinates": [[[-118.343, 33.82914], [-118.34294, 33.82916], [-118.34283, 33.82924], [-118.34276, 33.82926], [-118.34152, 33.82927], [-118.3415, 33.82825], [-118.34253, 33.82892], [-118.343, 33.82914]]]} | Open Access 1 | Madrona Marsh Nature Center | http://www.friendsofmadronamarsh.com/index.shtml | 29332 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.986 | Madrona Marsh Nature Ctr. | |
7031 | 7031 | 7030 | {"type": "Polygon", "coordinates": [[[-118.34314, 34.39392], [-118.34303, 34.40124], [-118.32543, 34.401], [-118.32549, 34.39781], [-118.33435, 34.39794], [-118.33442, 34.39379], [-118.34314, 34.39392]]]} | Open Access 1 | Southern California Edison mitigation | https://cordobacorp.com/projects/southern-california-edison-tehachapi-renewable-transmission-project/ | 33677 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 232.435 | Southern California Edison mitigation | 2017 |
12138 | 12138 | 12137 | {"type": "Polygon", "coordinates": [[[-118.34333, 34.10414], [-118.34241, 34.10414], [-118.34241, 34.10351], [-118.34332, 34.10352], [-118.34333, 34.10414]]]} | Open Access 1 | Dorothy J. and Benjamin B. Smith Park | 29107 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1.44 | Dorothy J. and Benjamin B. Smith Park | ||
14611 | 14611 | 14610 | {"type": "Polygon", "coordinates": [[[-118.34366, 33.88545], [-118.34014, 33.88558], [-118.34029, 33.88725], [-118.33518, 33.88725], [-118.33518, 33.88623], [-118.33512, 33.88577], [-118.33502, 33.88542], [-118.33485, 33.88504], [-118.33464, 33.88473], [-118.33435, 33.88438], [-118.33446, 33.88429], [-118.33398, 33.88376], [-118.33384, 33.88384], [-118.33158, 33.88141], [-118.34006, 33.87868], [-118.34008, 33.87868], [-118.34029, 33.87861], [-118.3403, 33.8786], [-118.34353, 33.87755], [-118.34365, 33.87762], [-118.34366, 33.88545]]]} | Restricted Access 2 | Alondra Golf Course | 33106 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 187.763 | Alondra GC | ||
685 | 685 | 684 | {"type": "Polygon", "coordinates": [[[-118.34366, 33.88725], [-118.34029, 33.88725], [-118.34013, 33.88558], [-118.34366, 33.88545], [-118.34366, 33.88725]]]} | Open Access 1 | Alondra Community Regional Park | 15402 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 15.212 | Alondra Community RP | ||
5533 | 5533 | 5532 | {"type": "Polygon", "coordinates": [[[-118.34369, 33.90374], [-118.34368, 33.90549], [-118.34277, 33.90549], [-118.34276, 33.90514], [-118.34174, 33.90514], [-118.34174, 33.90338], [-118.34276, 33.90338], [-118.34277, 33.90355], [-118.34284, 33.90356], [-118.34286, 33.90373], [-118.34369, 33.90374]]]} | Open Access 1 | Jim Thorpe Park | 20414 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 8.722 | Jim Thorpe Park | ||
4976 | 4976 | 4975 | {"type": "Polygon", "coordinates": [[[-118.34374, 33.91662], [-118.34374, 33.91782], [-118.33953, 33.91782], [-118.33953, 33.91656], [-118.34366, 33.91655], [-118.34372, 33.91658], [-118.34374, 33.91662]]]} | Open Access 1 | Hawthorne Memorial Park | 19752 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 13.499 | Hawthorne Memorial Park | ||
2683 | 2683 | 2682 | {"type": "Polygon", "coordinates": [[[-118.34398, 34.10983], [-118.34396, 34.10986], [-118.34393, 34.10999], [-118.34395, 34.1101], [-118.34376, 34.11029], [-118.34363, 34.10997], [-118.34368, 34.10981], [-118.34398, 34.10983]]]} | Open Access 1 | Castilian MRCA Open Space | 16949 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.278 | Castilian MRCA OS | ||
12193 | 12193 | 12192 | {"type": "Polygon", "coordinates": [[[-118.34459, 33.81799], [-118.34451, 33.81822], [-118.34448, 33.81848], [-118.34446, 33.81849], [-118.34446, 33.81894], [-118.34443, 33.81903], [-118.34436, 33.81902], [-118.34436, 33.81829], [-118.3444, 33.81816], [-118.34436, 33.81814], [-118.34436, 33.81789], [-118.34459, 33.81799]]]} | Open Access 1 | Madrona Right of Way South | 29172 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.349 | Madrona Right of Way South | ||
15594 | 15594 | 15593 | {"type": "Polygon", "coordinates": [[[-118.34474, 33.32226], [-118.34459, 33.32254], [-118.3446, 33.32273], [-118.34452, 33.32287], [-118.3446, 33.32309], [-118.34427, 33.32358], [-118.34443, 33.32393], [-118.34426, 33.32423], [-118.3442, 33.32446], [-118.34379, 33.32439], [-118.34347, 33.32438], [-118.34308, 33.32446], [-118.3427, 33.32445], [-118.34244, 33.3245], [-118.34221, 33.3245], [-118.34188, 33.32462], [-118.34159, 33.32501], [-118.34093, 33.32616], [-118.34059, 33.32671], [-118.34044, 33.32692], [-118.3404, 33.3271], [-118.34009, 33.32721], [-118.33946, 33.32689], [-118.33948, 33.32659], [-118.33959, 33.32583], [-118.33972, 33.32552], [-118.33979, 33.32542], [-118.33979, 33.3253], [-118.33984, 33.32508], [-118.33996, 33.32488], [-118.34008, 33.32444], [-118.34, 33.3241], [-118.34057, 33.32354], [-118.3407, 33.32339], [-118.34036, 33.32293], [-118.34018, 33.32261], [-118.34014, 33.32239], [-118.34096, 33.32196], [-118.34151, 33.32158], [-118.34217, 33.32149], [-118.34226, 33.32154], [-118.34245, 33.32162], [-118.34263, 33.32167], [-118.34307, 33.32189], [-118.34323, 33.32187], [-118.34351, 33.32192], [-118.34445, 33.32198], [-118.34474, 33.32226]]]} | Open Access 1 | Santa Catalina Island Nature Center at Avalon Canyon | http://parks.lacounty.gov/santa-catalina-island-nature-center-at-avalon-canyon/ | 32677 | 3070 | Santa Catalina Island Conservancy 377 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.catalinaconservancy.org/ | Non Governmental Organization 10 | 37.766 | Santa Catalina Island Nature Ctr. at Avalon Canyon | |
12282 | 12282 | 12281 | {"type": "Polygon", "coordinates": [[[-118.3448, 33.82554], [-118.3448, 33.82767], [-118.34478, 33.828], [-118.34478, 33.82911], [-118.34473, 33.82916], [-118.3444, 33.82916], [-118.3439, 33.82912], [-118.34363, 33.82907], [-118.34337, 33.829], [-118.34312, 33.82892], [-118.34283, 33.82878], [-118.34251, 33.8286], [-118.34055, 33.82731], [-118.34005, 33.82708], [-118.34004, 33.82705], [-118.34003, 33.82566], [-118.34, 33.82541], [-118.33991, 33.82492], [-118.33989, 33.82465], [-118.33991, 33.82444], [-118.33994, 33.82441], [-118.34001, 33.8244], [-118.34081, 33.82457], [-118.34161, 33.8247], [-118.34336, 33.82505], [-118.34421, 33.82514], [-118.34421, 33.82554], [-118.3448, 33.82554]]]} | Open Access 1 | Madrona Marsh Preserve | 29331 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 42.375 | Madrona Marsh Preserve | ||
7775 | 7775 | 7774 | {"type": "Polygon", "coordinates": [[[-118.3448, 33.87548], [-118.3447, 33.8756], [-118.34443, 33.87557], [-118.34446, 33.87536], [-118.3445, 33.87534], [-118.34463, 33.87538], [-118.3448, 33.87548]]]} | Open Access 1 | Osage Park | 23231 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.164 | Osage Park | ||
12192 | 12192 | 12191 | {"type": "Polygon", "coordinates": [[[-118.34493, 33.82494], [-118.34486, 33.82494], [-118.34458, 33.82455], [-118.34448, 33.82437], [-118.34446, 33.82436], [-118.34439, 33.82415], [-118.34434, 33.82384], [-118.34436, 33.81902], [-118.34443, 33.81902], [-118.34446, 33.81894], [-118.34446, 33.81902], [-118.34452, 33.81903], [-118.34448, 33.81921], [-118.34446, 33.81938], [-118.34444, 33.82386], [-118.34446, 33.82402], [-118.34456, 33.82433], [-118.34455, 33.82435], [-118.34465, 33.82454], [-118.34493, 33.82494]]]} | Open Access 1 | Madrona Right of Way North | 29171 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.487 | Madrona Right of Way North |
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]);