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 9,159
- County Agency 955
- Recreation/Parks District 934
- State Agency 650
- Non Profit - Land Trust 455
- Open Space District 210
- Federal Agency 191
- County Agency - Parks 189
- Community Services District 173
- Water District 163
- Home Owners Association 145
- Non Profit - Conservation 103
- Flood District 87
- Cemetery District 58
- Non Profit - Other 33
- Port/Harbor District 30
- County Agency - Other 28
- Irrigation District 16
- School District 13
- Commercial 10
- Special District - Other 10
- Sanitation District 9
- Joint Powers Authority 5
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Mitigation Bank 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 414
- San Diego, City of 394
- California Department of Fish and Wildlife 306
- San Jose, City of 222
- San Francisco, City and County of 204
- Sacramento, City of 195
- California Department of Parks and Recreation 165
- Mountains Recreation and Conservation Authority 162
- Los Angeles, County of 151
- Ventura, City of 146
- Long Beach, City of 136
- Roseville, City of 119
- San Diego, County of 115
- East Bay Regional Park District 112
- Oakland, City of 103
- Irvine, City of 96
- Fresno, City of 90
- Consumnes Community Services District 85
- Santa Barbara, County of 75
- Hayward Area Recreation and Park District 75
- Modesto, City of 75
- Huntington Beach, City of 73
- Stockton, City of 73
- Orange, County of 71
- Torrance, City of 71
- Tracy, City of 68
- Santa Rosa, City of 66
- Chula Vista, City of 66
- Santa Cruz, City of 64
- Poway, City of 62
- …
ACCESS_TYP 4
- Open Access 11,808
- Restricted Access 935
- No Public Access 671
- Unknown Access 243
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1982 | 1982 | 1981 | {"type": "Polygon", "coordinates": [[[-119.5816, 36.67854], [-119.58049, 36.67855], [-119.58052, 36.67774], [-119.58158, 36.67773], [-119.5816, 36.6778], [-119.5816, 36.67854]]]} | Open Access 1 | Bethel Cemetery | 16047 | 2138 | Sanger/Del Rey Cemetery District 794 | Special District 4 | Cemetery District 11 | Special District 4 | 2.179 | Bethel Cemetery | |||
1983 | 1983 | 1982 | {"type": "Polygon", "coordinates": [[[-117.21966, 33.87834], [-117.21749, 33.87836], [-117.21748, 33.87735], [-117.21965, 33.87736], [-117.21966, 33.87834]]]} | Open Access 1 | Bethune Park | 16048 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 5.477 | Bethune Park | ||
1984 | 1984 | 1983 | {"type": "MultiPolygon", "coordinates": [[[[-121.44049, 38.4306], [-121.44003, 38.4306], [-121.43918, 38.43156], [-121.43899, 38.43148], [-121.43873, 38.43143], [-121.43846, 38.43139], [-121.43708, 38.43138], [-121.43685, 38.43139], [-121.43667, 38.43144], [-121.43645, 38.43151], [-121.43619, 38.43155], [-121.43418, 38.43163], [-121.43414, 38.43161], [-121.43412, 38.43158], [-121.43412, 38.43064], [-121.43409, 38.43062], [-121.43409, 38.43039], [-121.4341, 38.43035], [-121.43413, 38.43034], [-121.43492, 38.43033], [-121.43494, 38.43062], [-121.43971, 38.4306], [-121.43973, 38.43003], [-121.43984, 38.43003], [-121.44029, 38.43008], [-121.44049, 38.43016], [-121.44049, 38.4306]]], [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]]} | Open Access 1 | Betschart Park | 16049 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 13.848 | Betschart Park | ||
1985 | 1985 | 1984 | {"type": "Polygon", "coordinates": [[[-117.06676, 32.94232], [-117.06643, 32.94283], [-117.06594, 32.94275], [-117.06601, 32.94232], [-117.06676, 32.94232]]]} | Open Access 1 | Bette Bendixen Park | http://poway.org/Facilities/Facility/Details/Bette-Bendixen-Park-60 | 16050 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.773 | Bette Bendixen Park | |
1986 | 1986 | 1985 | {"type": "Polygon", "coordinates": [[[-118.4146, 34.06717], [-118.41459, 34.06739], [-118.41341, 34.06736], [-118.41217, 34.06729], [-118.41035, 34.06755], [-118.39058, 34.0811], [-118.38983, 34.08056], [-118.40966, 34.06717], [-118.4146, 34.06717]]]} | Open Access 1 | Beverly Gardens Park | 16052 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 50.414 | Beverly Gardens Park | ||
1987 | 1987 | 1986 | {"type": "Polygon", "coordinates": [[[-122.22737, 38.08113], [-122.22737, 38.08127], [-122.22732, 38.0813], [-122.22665, 38.0811], [-122.22659, 38.0812], [-122.22732, 38.08142], [-122.22736, 38.08146], [-122.22736, 38.08153], [-122.22528, 38.08137], [-122.22508, 38.0818], [-122.22533, 38.08199], [-122.22562, 38.08233], [-122.2258, 38.08248], [-122.22596, 38.08257], [-122.22615, 38.08265], [-122.22657, 38.08278], [-122.22737, 38.08289], [-122.22736, 38.08356], [-122.22733, 38.0836], [-122.22727, 38.08363], [-122.22714, 38.08359], [-122.22705, 38.08366], [-122.22731, 38.08391], [-122.22736, 38.08398], [-122.22736, 38.08407], [-122.22734, 38.08418], [-122.2273, 38.08424], [-122.22719, 38.08431], [-122.22705, 38.08411], [-122.22645, 38.08357], [-122.2252, 38.08307], [-122.22521, 38.08267], [-122.22519, 38.0825], [-122.22483, 38.08248], [-122.22482, 38.08238], [-122.22468, 38.08238], [-122.22468, 38.0822], [-122.2246, 38.08215], [-122.22442, 38.08215], [-122.22438, 38.08187], [-122.2243, 38.08155], [-122.22427, 38.08139], [-122.22417, 38.08109], [-122.22401, 38.08111], [-122.22378, 38.08066], [-122.22419, 38.08059], [-122.22434, 38.08062], [-122.22518, 38.08067], [-122.22519, 38.0808], [-122.2257, 38.08086], [-122.22572, 38.08082], [-122.22704, 38.08094], [-122.22706, 38.08112], [-122.22737, 38.08113]]]} | Open Access 1 | Beverly Hills Park | http://www.gvrd.org/?page=Beverly_Hills_Park | 16056 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 11.782 | Beverly Hills Park | |
1988 | 1988 | 1987 | {"type": "Polygon", "coordinates": [[[-122.73461, 38.46734], [-122.7346, 38.46746], [-122.73412, 38.46748], [-122.73412, 38.46903], [-122.73393, 38.46903], [-122.73392, 38.46856], [-122.73274, 38.46856], [-122.73272, 38.46715], [-122.73363, 38.46714], [-122.73415, 38.46715], [-122.73417, 38.46733], [-122.73461, 38.46734]]]} | Open Access 1 | Bicentennial Park | 16066 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 5.097 | Bicentennial Park | ||
1989 | 1989 | 1988 | {"type": "Polygon", "coordinates": [[[-120.5224, 35.17674], [-120.52095, 35.17779], [-120.52068, 35.17801], [-120.52048, 35.1782], [-120.52022, 35.1785], [-120.51996, 35.17888], [-120.51981, 35.17917], [-120.51963, 35.1796], [-120.51912, 35.1796], [-120.51887, 35.17973], [-120.51864, 35.17995], [-120.51835, 35.18017], [-120.51803, 35.18033], [-120.51772, 35.18041], [-120.51707, 35.18055], [-120.51675, 35.18072], [-120.51607, 35.18122], [-120.51547, 35.18159], [-120.5141, 35.18133], [-120.51375, 35.1813], [-120.5134, 35.1813], [-120.51361, 35.1807], [-120.51436, 35.1804], [-120.5146, 35.17859], [-120.52025, 35.17532], [-120.52083, 35.17585], [-120.52108, 35.17542], [-120.52162, 35.17528], [-120.52199, 35.17516], [-120.5224, 35.17674]]]} | Open Access 1 | Biddle Park | 16068 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 62.883 | Biddle Park | ||
1990 | 1990 | 1989 | {"type": "Polygon", "coordinates": [[[-122.04353, 37.6184], [-122.04178, 37.61966], [-122.04028, 37.61836], [-122.04197, 37.61708], [-122.04353, 37.6184]]]} | Open Access 1 | Bidwell Park | 16069 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 10.154 | Bidwell Park | ||
1991 | 1991 | 1990 | {"type": "Polygon", "coordinates": [[[-121.82502, 39.78339], [-121.80701, 39.78385], [-121.807, 39.78435], [-121.80343, 39.78447], [-121.79613, 39.77739], [-121.79301, 39.77069], [-121.79286, 39.77039], [-121.79357, 39.7699], [-121.79276, 39.76989], [-121.79367, 39.76932], [-121.79944, 39.76554], [-121.79947, 39.76534], [-121.79967, 39.76551], [-121.80032, 39.76508], [-121.80282, 39.76371], [-121.80419, 39.76528], [-121.80616, 39.76764], [-121.80643, 39.76788], [-121.80643, 39.7693], [-121.81444, 39.77535], [-121.81457, 39.77535], [-121.81481, 39.7754], [-121.81822, 39.77698], [-121.81753, 39.77771], [-121.82502, 39.78339]]]} | Open Access 1 | Bidwell Ranch Preserve | 16070 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 756.682 | Bidwell Ranch Preserve | ||
1992 | 1992 | 1991 | {"type": "Polygon", "coordinates": [[[-121.89592, 37.31933], [-121.89588, 37.32002], [-121.89304, 37.31991], [-121.89309, 37.31912], [-121.89526, 37.3192], [-121.89525, 37.3194], [-121.89529, 37.31941], [-121.89538, 37.31938], [-121.89542, 37.31931], [-121.89592, 37.31933]]]} | Open Access 1 | Biebrach Park | 16071 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.305 | Biebrach Park | 1978 | |
1993 | 1993 | 1992 | {"type": "Polygon", "coordinates": [[[-122.13412, 37.04584], [-122.12416, 37.04584], [-122.12374, 37.03804], [-122.12409, 37.03801], [-122.12439, 37.03056], [-122.12933, 37.03038], [-122.13387, 37.03032], [-122.13403, 37.04028], [-122.13408, 37.0403], [-122.13412, 37.04584]]]} | No Public Access 3 | Big Basin Cemex | 16072 | 3200 | Living Landscape Initiative Partners 1029 | Non Profit 6 | Non Profit - Conservation 12 | http://www.livinglandscapeinitiative.org/ | Non Governmental Organization 10 | 372.989 | Big Basin Cemex | ||
1994 | 1994 | 1993 | {"type": "Polygon", "coordinates": [[[-116.84618, 34.26482], [-116.84437, 34.26482], [-116.84437, 34.26376], [-116.84458, 34.26376], [-116.84475, 34.26357], [-116.84509, 34.26291], [-116.8452, 34.26282], [-116.84548, 34.26282], [-116.84618, 34.26482]]]} | Open Access 1 | Big Bear City Park | 16073 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 6.163 | Big Bear City Park | ||
1995 | 1995 | 1994 | {"type": "Polygon", "coordinates": [[[-117.88503, 33.63009], [-117.88492, 33.63054], [-117.88457, 33.63087], [-117.8844, 33.63098], [-117.88427, 33.63103], [-117.8841, 33.63106], [-117.88263, 33.63112], [-117.88253, 33.63115], [-117.88207, 33.63138], [-117.88279, 33.63178], [-117.88289, 33.63186], [-117.88295, 33.63192], [-117.883, 33.63202], [-117.88302, 33.63212], [-117.88308, 33.63273], [-117.88312, 33.63284], [-117.88322, 33.63295], [-117.88329, 33.63301], [-117.8846, 33.63364], [-117.88468, 33.63377], [-117.88483, 33.63395], [-117.88461, 33.63407], [-117.88448, 33.6339], [-117.88271, 33.63315], [-117.8824, 33.63265], [-117.88259, 33.63222], [-117.88182, 33.63176], [-117.88079, 33.63166], [-117.88049, 33.6317], [-117.88026, 33.6317], [-117.87975, 33.63121], [-117.87955, 33.63087], [-117.87928, 33.63058], [-117.87925, 33.63028], [-117.87851, 33.62913], [-117.87825, 33.629], [-117.87804, 33.62901], [-117.87801, 33.62898], [-117.87782, 33.62903], [-117.87737, 33.62921], [-117.87721, 33.62923], [-117.87699, 33.6293], [-117.87664, 33.62918], [-117.87761, 33.62757], [-117.87822, 33.62674], [-117.87836, 33.62695], [-117.87841, 33.62732], [-117.87879, 33.6275], [-117.87934, 33.62797], [-117.87967, 33.62852], [-117.88023, 33.62895], [-117.88053, 33.62966], [-117.88079, 33.62984], [-117.8811, 33.62989], [-117.8824, 33.62957], [-117.88277, 33.62964], [-117.88345, 33.63013], [-117.88367, 33.63011], [-117.8839, 33.62992], [-117.88411, 33.62992], [-117.8842, 33.62989], [-117.88503, 33.63009]]]} | Open Access 1 | Big Canyon Park | 16076 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 39.154 | Big Canyon Park | ||
1996 | 1996 | 1995 | {"type": "Polygon", "coordinates": [[[-122.28634, 37.48596], [-122.28472, 37.48714], [-122.28549, 37.4878], [-122.28485, 37.48828], [-122.28461, 37.4881], [-122.28421, 37.48815], [-122.28328, 37.48773], [-122.28282, 37.48771], [-122.28311, 37.48727], [-122.28247, 37.48628], [-122.28141, 37.48627], [-122.28131, 37.48662], [-122.28168, 37.48719], [-122.28178, 37.48757], [-122.28183, 37.48786], [-122.28129, 37.48811], [-122.28062, 37.48864], [-122.27916, 37.48914], [-122.27859, 37.48926], [-122.27825, 37.4885], [-122.27793, 37.48827], [-122.27745, 37.48828], [-122.27681, 37.48873], [-122.27653, 37.4893], [-122.27607, 37.4889], [-122.2759, 37.48934], [-122.2748, 37.4889], [-122.27501, 37.48861], [-122.2757, 37.48893], [-122.27666, 37.48835], [-122.27684, 37.48736], [-122.27618, 37.48711], [-122.27602, 37.48735], [-122.2755, 37.48713], [-122.27626, 37.48661], [-122.27647, 37.48654], [-122.27659, 37.48676], [-122.27679, 37.48672], [-122.27698, 37.48674], [-122.27772, 37.48753], [-122.27811, 37.48826], [-122.2789, 37.48833], [-122.27917, 37.48779], [-122.27871, 37.48691], [-122.27798, 37.48621], [-122.27919, 37.48539], [-122.27978, 37.48516], [-122.28022, 37.48508], [-122.28133, 37.48519], [-122.28169, 37.48544], [-122.2817, 37.48541], [-122.28214, 37.48503], [-122.2827, 37.48443], [-122.2831, 37.48388], [-122.28339, 37.48326], [-122.28342, 37.48371], [-122.28364, 37.48452], [-122.28395, 37.48505], [-122.28451, 37.48559], [-122.28504, 37.48586], [-122.28572, 37.48588], [-122.28634, 37.48596]]]} | Open Access 1 | Big Canyon Park | 16077 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 55.299 | Big Canyon Park | 1970 | |
1997 | 1997 | 1996 | {"type": "Polygon", "coordinates": [[[-121.26138, 37.79009], [-121.25703, 37.79011], [-121.25702, 37.78656], [-121.25703, 37.78652], [-121.25707, 37.78649], [-121.25712, 37.78648], [-121.26036, 37.78647], [-121.26065, 37.7865], [-121.26089, 37.78657], [-121.26113, 37.78666], [-121.26137, 37.78679], [-121.26138, 37.79009]]]} | Open Access 1 | Big League Dreams Park | 16080 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 37.836 | Big League Dreams Park | ||
1998 | 1998 | 1997 | {"type": "Polygon", "coordinates": [[[-122.30999, 40.57599], [-122.30898, 40.57599], [-122.309, 40.57833], [-122.30524, 40.57832], [-122.30525, 40.57464], [-122.30759, 40.57465], [-122.3076, 40.57428], [-122.30798, 40.57427], [-122.30831, 40.57428], [-122.30864, 40.57441], [-122.30902, 40.57469], [-122.30997, 40.57466], [-122.30999, 40.57599]]]} | Open Access 1 | Big League Dreams Sports Park | 16081 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 35.926 | Big League Dreams Sports Park | ||
1999 | 1999 | 1998 | {"type": "Polygon", "coordinates": [[[-119.79976, 36.71887], [-119.79974, 36.71947], [-119.79972, 36.71963], [-119.7977, 36.7196], [-119.79769, 36.71907], [-119.79807, 36.71906], [-119.79808, 36.71894], [-119.79909, 36.71892], [-119.79911, 36.71887], [-119.79976, 36.71887]]]} | Open Access 1 | Bigby VIlla Park | 16097 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 3.428 | Bigby VIlla Park | ||
2000 | 2000 | 1999 | {"type": "Polygon", "coordinates": [[[-121.71403, 39.41319], [-121.71349, 39.41331], [-121.71325, 39.41265], [-121.71379, 39.41253], [-121.71403, 39.41319]]]} | Open Access 1 | Biggs Family Park | 16098 | 1031 | Biggs, City of 691 | City 2 | City Agency 2 | http://www.biggs-ca.gov/public-works/parks.htm | City 2 | 0.918 | Biggs Family Park | ||
2001 | 2001 | 2000 | {"type": "Polygon", "coordinates": [[[-117.81414, 35.18511], [-117.8133, 35.18514], [-117.81245, 35.18517], [-117.81249, 35.18479], [-117.8133, 35.18474], [-117.81414, 35.18472], [-117.81414, 35.18511]]]} | Open Access 1 | California City holding 9 | 16713 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1.631 | California City holding 9 |
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]);