superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 4,895
- Recreation/Parks District 560
- State Agency 543
- County Agency 518
- Non Profit - Land Trust 307
- Open Space District 162
- Federal Agency 146
- County Agency - Parks 141
- Water District 128
- Home Owners Association 107
- Non Profit - Conservation 81
- Community Services District 78
- Flood District 53
- Cemetery District 26
- Non Profit - Other 23
- County Agency - Other 20
- Port/Harbor District 19
- School District 13
- Irrigation District 12
- Commercial 10
- Special District - Other 5
- Other 5
- Sanitation District 4
- Joint Powers Authority 4
- Conservation District 4
- Non Profit - Cemetery District 3
- Mitigation Bank 3
- Transportation Agency 3
- Metropolitan Planning Organization 2
- Non Profit - Education 2
- …
MNG_AGENCY >30
- San Diego, City of 326
- Los Angeles, City of 279
- California Department of Fish and Wildlife 263
- California Department of Parks and Recreation 160
- Ventura, City of 127
- Mountains Recreation and Conservation Authority 120
- San Jose, City of 99
- Los Angeles, County of 97
- Long Beach, City of 95
- San Francisco, City and County of 90
- East Bay Regional Park District 90
- San Diego, County of 88
- Sacramento, City of 85
- Roseville, City of 78
- Los Angeles - Department of Parks and Recreation, County of 56
- Fresno, City of 54
- Poway, City of 54
- Torrance, City of 51
- Santa Barbara, County of 49
- Yuba County Water Agency 48
- Santa Cruz, City of 45
- Davis, City of 41
- Midpeninsula Regional Open Space District 41
- United States Fish and Wildlife Service 39
- Irvine, City of 39
- Napa, City of 39
- Oakland, City of 37
- Clovis, City of 37
- Rocklin, City of 37
- Marin County Open Space District 35
- …
ACCESS_TYP 4
- Open Access 6,528
- Restricted Access 694
- No Public Access 482
- Unknown Access 176
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7759 | 7759 | 7758 | {"type": "Polygon", "coordinates": [[[-118.31904, 34.27061], [-118.31739, 34.27184], [-118.31705, 34.27189], [-118.31679, 34.27195], [-118.31654, 34.27201], [-118.31592, 34.27222], [-118.31585, 34.2722], [-118.31584, 34.27218], [-118.31584, 34.27187], [-118.3158, 34.27185], [-118.31581, 34.2706], [-118.31904, 34.27061]]]} | Open Access 1 | Oro Vista Park | 23209 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 8.225 | Oro Vista Park | ||
7760 | 7760 | 7759 | {"type": "Polygon", "coordinates": [[[-121.54941, 39.51629], [-121.54933, 39.51642], [-121.54896, 39.51664], [-121.5493, 39.51711], [-121.54902, 39.51728], [-121.54868, 39.51754], [-121.54854, 39.51757], [-121.54836, 39.5177], [-121.5483, 39.5178], [-121.54817, 39.51791], [-121.54785, 39.51803], [-121.54782, 39.51812], [-121.54772, 39.5182], [-121.54767, 39.51838], [-121.54759, 39.51845], [-121.54743, 39.51858], [-121.54739, 39.51863], [-121.54739, 39.51869], [-121.54719, 39.51869], [-121.5476, 39.51762], [-121.54795, 39.51685], [-121.54912, 39.5164], [-121.54871, 39.51678], [-121.54874, 39.51683], [-121.54926, 39.51634], [-121.54941, 39.51629]]]} | Open Access 1 | Oroville holding 1 | 23210 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 3.971 | Oroville holding 1 | ||
7761 | 7761 | 7760 | {"type": "Polygon", "coordinates": [[[-121.53317, 39.51121], [-121.53311, 39.51127], [-121.53108, 39.51186], [-121.52886, 39.51255], [-121.52864, 39.51207], [-121.52837, 39.51124], [-121.52813, 39.51073], [-121.53187, 39.50967], [-121.5326, 39.50953], [-121.53277, 39.51], [-121.53279, 39.51012], [-121.53317, 39.51121]]]} | Open Access 1 | Oroville holding 10 | 23211 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 20.471 | Oroville holding 10 | ||
7762 | 7762 | 7761 | {"type": "Polygon", "coordinates": [[[-121.52541, 39.51718], [-121.52468, 39.51729], [-121.52411, 39.51745], [-121.52356, 39.51794], [-121.52187, 39.51846], [-121.52173, 39.51838], [-121.52164, 39.51851], [-121.52173, 39.51831], [-121.52221, 39.51781], [-121.52171, 39.5173], [-121.5217, 39.51707], [-121.52276, 39.5174], [-121.52293, 39.51733], [-121.52332, 39.51693], [-121.52356, 39.51714], [-121.5238, 39.51699], [-121.52541, 39.51718]]]} | Open Access 1 | Oroville holding 11 | 23212 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 5.312 | Oroville holding 11 | ||
7763 | 7763 | 7762 | {"type": "Polygon", "coordinates": [[[-121.52601, 39.50412], [-121.52599, 39.50467], [-121.52549, 39.50504], [-121.52525, 39.50477], [-121.5233, 39.50467], [-121.52331, 39.5043], [-121.52378, 39.50423], [-121.52517, 39.50414], [-121.5253, 39.50411], [-121.52601, 39.50412]]]} | Open Access 1 | Oroville holding 12 | 23213 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 3.699 | Oroville holding 12 | ||
7764 | 7764 | 7763 | {"type": "Polygon", "coordinates": [[[-121.5358, 39.49949], [-121.53578, 39.49997], [-121.5354, 39.50006], [-121.53503, 39.50003], [-121.53502, 39.50051], [-121.5344, 39.5004], [-121.53398, 39.50037], [-121.53365, 39.50037], [-121.53365, 39.49947], [-121.5358, 39.49949]]]} | Open Access 1 | Oroville holding 2 | 23214 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 4.018 | Oroville holding 2 | ||
7765 | 7765 | 7764 | {"type": "Polygon", "coordinates": [[[-121.52095, 39.49641], [-121.52069, 39.49641], [-121.52058, 39.49653], [-121.52039, 39.49638], [-121.52021, 39.49621], [-121.52, 39.49595], [-121.51999, 39.4959], [-121.52002, 39.49587], [-121.52023, 39.49578], [-121.52068, 39.4961], [-121.52095, 39.49641]]]} | Open Access 1 | Oroville holding 3 | 23215 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 0.742 | Oroville holding 3 | ||
7766 | 7766 | 7765 | {"type": "Polygon", "coordinates": [[[-121.52014, 39.49559], [-121.51989, 39.49571], [-121.51981, 39.49571], [-121.51952, 39.49538], [-121.51921, 39.49512], [-121.5192, 39.49465], [-121.51932, 39.49478], [-121.51954, 39.49488], [-121.51973, 39.49518], [-121.52014, 39.49559]]]} | Open Access 1 | Oroville holding 5 | 23217 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 0.854 | Oroville holding 5 | ||
7767 | 7767 | 7766 | {"type": "Polygon", "coordinates": [[[-121.5518, 39.51089], [-121.55165, 39.51093], [-121.55155, 39.51092], [-121.55145, 39.51088], [-121.55137, 39.51082], [-121.55163, 39.51069], [-121.5518, 39.51089]]]} | Open Access 1 | Oroville holding 6 | 23218 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 0.134 | Oroville holding 6 | ||
7768 | 7768 | 7767 | {"type": "MultiPolygon", "coordinates": [[[[-116.97389, 33.8206], [-116.97385, 33.82061], [-116.97383, 33.82076], [-116.97369, 33.82132], [-116.97296, 33.82208], [-116.97298, 33.82244], [-116.97248, 33.82236], [-116.97231, 33.82235], [-116.97213, 33.82237], [-116.97195, 33.82241], [-116.97083, 33.8228], [-116.97083, 33.82282], [-116.97085, 33.82284], [-116.97079, 33.82283], [-116.96954, 33.8221], [-116.96917, 33.82185], [-116.96941, 33.82193], [-116.96942, 33.82191], [-116.96882, 33.82151], [-116.96728, 33.82063], [-116.96925, 33.81897], [-116.96925, 33.81895], [-116.96475, 33.81713], [-116.96418, 33.81688], [-116.96355, 33.81655], [-116.96625, 33.81654], [-116.97061, 33.81781], [-116.97216, 33.81651], [-116.97221, 33.81651], [-116.97236, 33.81694], [-116.97251, 33.81729], [-116.97379, 33.82002], [-116.97388, 33.82032], [-116.97389, 33.8206]]], [[[-116.97209, 33.8164], [-116.97063, 33.81762], [-116.9669, 33.81654], [-116.96702, 33.81653], [-116.96683, 33.81645], [-116.96679, 33.81605], [-116.97207, 33.81627], [-116.97209, 33.8164]]], [[[-116.97454, 33.82302], [-116.97444, 33.82314], [-116.97395, 33.82284], [-116.97395, 33.82281], [-116.97385, 33.82274], [-116.97377, 33.82265], [-116.9737, 33.8225], [-116.97369, 33.82241], [-116.97369, 33.8223], [-116.97398, 33.82117], [-116.97439, 33.82263], [-116.97454, 33.82302]]]]} | Open Access 1 | San Jacinto River Park | 24905 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 88.794 | San Jacinto River Park | ||
7769 | 7769 | 7768 | {"type": "Polygon", "coordinates": [[[-121.55232, 39.51149], [-121.5517, 39.51181], [-121.55101, 39.51101], [-121.55137, 39.51082], [-121.55145, 39.51088], [-121.55155, 39.51092], [-121.55165, 39.51093], [-121.5518, 39.51089], [-121.55232, 39.51149]]]} | Open Access 1 | Oroville holding 7 | 23219 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 1.552 | Oroville holding 7 | ||
7770 | 7770 | 7769 | {"type": "Polygon", "coordinates": [[[-121.56907, 39.5204], [-121.56907, 39.52046], [-121.56881, 39.52079], [-121.5668, 39.52078], [-121.56679, 39.52188], [-121.56523, 39.52187], [-121.56524, 39.52152], [-121.56519, 39.52151], [-121.56519, 39.52125], [-121.56524, 39.52123], [-121.56524, 39.52078], [-121.56552, 39.52078], [-121.56554, 39.52071], [-121.56588, 39.52072], [-121.5659, 39.52076], [-121.56728, 39.52076], [-121.56729, 39.52074], [-121.56836, 39.52074], [-121.56838, 39.5207], [-121.56877, 39.5207], [-121.56892, 39.52052], [-121.56907, 39.5204]]]} | Open Access 1 | Oroville holding 8 | 23220 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 4.465 | Oroville holding 8 | ||
7771 | 7771 | 7770 | {"type": "Polygon", "coordinates": [[[-121.56558, 39.51054], [-121.56473, 39.51083], [-121.56434, 39.51013], [-121.5652, 39.50985], [-121.56558, 39.51054]]]} | Open Access 1 | Oroville holding 9 | 23221 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 1.671 | Oroville holding 9 | ||
7772 | 7772 | 7771 | {"type": "MultiPolygon", "coordinates": [[[[-119.70584, 34.4382], [-119.70455, 34.43838], [-119.70355, 34.43837], [-119.70346, 34.43833], [-119.70343, 34.43825], [-119.70343, 34.43822], [-119.7035, 34.43807], [-119.70359, 34.43794], [-119.70368, 34.43787], [-119.70382, 34.43784], [-119.70584, 34.4382]]], [[[-119.70624, 34.43759], [-119.70606, 34.43805], [-119.70399, 34.43771], [-119.70396, 34.43769], [-119.70395, 34.43765], [-119.70396, 34.4376], [-119.7044, 34.43724], [-119.70495, 34.43742], [-119.70575, 34.43752], [-119.70576, 34.43759], [-119.70624, 34.43759]]]]} | Open Access 1 | Orpet Park | 23223 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 4.385 | Orpet Park | ||
7773 | 7773 | 7772 | {"type": "Polygon", "coordinates": [[[-117.29614, 33.0581], [-117.2955, 33.0581], [-117.29432, 33.0581], [-117.29458, 33.05748], [-117.29523, 33.05748], [-117.29525, 33.05731], [-117.29581, 33.05731], [-117.29614, 33.0581]]]} | Open Access 1 | Orpheus Park | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | 23224 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 2.742 | Orpheus Park | |
7774 | 7774 | 7773 | {"type": "Polygon", "coordinates": [[[-119.69114, 34.42502], [-119.69001, 34.42608], [-119.68889, 34.42526], [-119.69003, 34.42419], [-119.69114, 34.42502]]]} | Open Access 1 | Ortega Park | 23226 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 5.349 | Ortega Park | ||
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 | ||
7776 | 7776 | 7775 | {"type": "Polygon", "coordinates": [[[-121.98155, 37.80527], [-121.97896, 37.80538], [-121.9786, 37.80534], [-121.97827, 37.80535], [-121.97806, 37.80538], [-121.9774, 37.80533], [-121.97689, 37.80511], [-121.97665, 37.80346], [-121.97707, 37.80344], [-121.97708, 37.80338], [-121.97718, 37.80319], [-121.97732, 37.80305], [-121.97747, 37.80302], [-121.97789, 37.80301], [-121.97818, 37.80304], [-121.97876, 37.80274], [-121.97934, 37.8027], [-121.97927, 37.80133], [-121.98122, 37.80125], [-121.98133, 37.80333], [-121.98155, 37.80527]]]} | Open Access 1 | Osage Station Park | 23232 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 34.241 | Osage Station Park | 1988 | |
7777 | 7777 | 7776 | {"type": "Polygon", "coordinates": [[[-120.59246, 37.36059], [-120.59241, 37.3635], [-120.59095, 37.36273], [-120.5894, 37.36117], [-120.58928, 37.36074], [-120.58931, 37.3606], [-120.59246, 37.36059]]]} | Open Access 1 | Osborn Park | 23233 | 1014 | Atwater, City of 463 | City 2 | City Agency 2 | http://www.atwater.org/index.cfm?page=940884 | City 2 | 14.331 | Osborn Park | ||
7778 | 7778 | 7777 | {"type": "Polygon", "coordinates": [[[-119.83073, 36.81646], [-119.83073, 36.81823], [-119.82858, 36.81824], [-119.82858, 36.81647], [-119.83073, 36.81646]]]} | Open Access 1 | Oso De Oro Lake Park | 23234 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 9.315 | Oso De Oro Lake 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]);