superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13,512 rows where ACCESS_TYP = 1 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 326
- Los Angeles, City of 315
- California Department of Fish and Wildlife 251
- California Department of Parks and Recreation 241
- Sacramento, City of 194
- San Jose, City of 186
- Los Angeles, County of 136
- San Francisco, City and County of 125
- Mountains Recreation and Conservation Authority 122
- San Diego, County of 96
- Long Beach, City of 92
- Roseville, City of 90
- Irvine, City of 88
- Oakland, City of 86
- Consumnes Community Services District 86
- Stockton, City of 74
- Fresno, City of 71
- Modesto, City of 71
- East Bay Regional Park District 70
- Hayward Area Recreation and Park District 70
- Orange, County of 66
- Huntington Beach, City of 65
- Santa Barbara, County of 64
- Ventura, City of 62
- United States National Park Service 59
- Chula Vista, City of 59
- Bakersfield, City of 58
- Riverside, City of 54
- Santa Rosa, City of 52
- Poway, City of 52
- …
MNG_AG_TYP 29
- City Agency 7,492
- County Agency 858
- Recreation/Parks District 837
- State Agency 584
- Federal Agency 200
- Community Services District 173
- County Agency - Parks 172
- Non Profit - Land Trust 170
- Open Space District 165
- Water District 84
- Cemetery District 61
- Non Profit - Conservation 42
- Flood District 33
- Port/Harbor District 31
- Non Profit - Other 29
- County Agency - Other 16
- Irrigation District 14
- Special District - Other 14
- Non Profit - Cemetery District 5
- Commercial 4
- Sanitation District 4
- Joint Powers Authority 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Other 1
- Fire District 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 10,999 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12420 | 12420 | 12419 | {"type": "Polygon", "coordinates": [[[-118.41981, 33.98441], [-118.41791, 33.98583], [-118.41786, 33.98591], [-118.41784, 33.98601], [-118.41786, 33.98605], [-118.41782, 33.98606], [-118.41773, 33.98597], [-118.41734, 33.98624], [-118.41726, 33.98615], [-118.41972, 33.98432], [-118.41981, 33.98441]]]} | Open Access 1 | Milton Street Park | 29422 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1.031 | Milton Street Park | ||
3166 | 3166 | 3165 | {"type": "Polygon", "coordinates": [[[-117.9344, 33.93896], [-117.93383, 33.93901], [-117.93354, 33.93901], [-117.93332, 33.939], [-117.93322, 33.93896], [-117.93317, 33.93889], [-117.93316, 33.93885], [-117.93316, 33.93848], [-117.93327, 33.93813], [-117.93332, 33.93825], [-117.93342, 33.93841], [-117.93365, 33.93864], [-117.93385, 33.93877], [-117.93401, 33.93885], [-117.93423, 33.93892], [-117.9344, 33.93896]]]} | Open Access 1 | Constitution Plaza Park | 17602 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 1.032 | Constitution Plaza Park | ||
6405 | 6405 | 6404 | {"type": "Polygon", "coordinates": [[[-118.61573, 34.06931], [-118.61507, 34.06932], [-118.61506, 34.06843], [-118.61534, 34.06856], [-118.6155, 34.0687], [-118.61554, 34.06878], [-118.61559, 34.06896], [-118.61573, 34.06931]]]} | Open Access 1 | Los Angeles holding 10 | 21485 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1.032 | Los Angeles holding 10 | ||
10235 | 10235 | 10234 | {"type": "Polygon", "coordinates": [[[-121.88491, 37.74319], [-121.88485, 37.74344], [-121.88438, 37.74336], [-121.88393, 37.74334], [-121.88354, 37.74336], [-121.88309, 37.74344], [-121.88316, 37.74317], [-121.88335, 37.74314], [-121.88386, 37.7431], [-121.88391, 37.7431], [-121.88394, 37.74312], [-121.88407, 37.74312], [-121.88408, 37.7431], [-121.88414, 37.7431], [-121.88453, 37.74313], [-121.88491, 37.74319]]]} | Open Access 1 | Tassajara Ridge Staging Area | 26196 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1.033 | Tassajara Ridge Staging Area | ||
12048 | 12048 | 12047 | {"type": "Polygon", "coordinates": [[[-118.10508, 33.83028], [-118.10508, 33.83056], [-118.10362, 33.83055], [-118.10362, 33.83028], [-118.10508, 33.83028]]]} | Open Access 1 | Birdcage Park | http://www.longbeach.gov/Park/Park-and-Facilities/Directory/Birdcage-Park/ | 28957 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.033 | Birdcage Park | |
7130 | 7130 | 7129 | {"type": "Polygon", "coordinates": [[[-119.66797, 36.81743], [-119.66784, 36.818], [-119.66759, 36.81799], [-119.66734, 36.81801], [-119.6673, 36.81799], [-119.66719, 36.81776], [-119.66704, 36.8175], [-119.66706, 36.81747], [-119.66709, 36.81747], [-119.66743, 36.81742], [-119.66771, 36.81741], [-119.66797, 36.81743]]]} | Open Access 1 | Monte Vista 21 Park | 22396 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.034 | Monte Vista 21 Park | ||
4096 | 4096 | 4095 | {"type": "Polygon", "coordinates": [[[-115.56564, 32.84427], [-115.56515, 32.84427], [-115.56515, 32.84344], [-115.56564, 32.84344], [-115.56564, 32.84427]]]} | Open Access 1 | Evans Park | 18756 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1.035 | Evans Park | ||
3628 | 3628 | 3627 | {"type": "Polygon", "coordinates": [[[-121.82236, 38.44685], [-121.82236, 38.44746], [-121.82165, 38.44744], [-121.82164, 38.44684], [-121.82236, 38.44685]]]} | Open Access 1 | Dixon holding 1 | 18172 | 1087 | Dixon, City of 420 | City 2 | City Agency 2 | http://www.ci.dixon.ca.us/ | City 2 | 1.036 | Dixon holding 1 | ||
11348 | 11348 | 11347 | {"type": "Polygon", "coordinates": [[[-117.23595, 33.05083], [-117.23587, 33.05124], [-117.23545, 33.05139], [-117.23552, 33.05113], [-117.23514, 33.05103], [-117.23532, 33.05054], [-117.23565, 33.05063], [-117.23571, 33.05071], [-117.23576, 33.05074], [-117.2359, 33.05074], [-117.23595, 33.05083]]]} | Open Access 1 | Wiro Park | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | 27660 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1.037 | Wiro Park | |
7277 | 7277 | 7276 | {"type": "Polygon", "coordinates": [[[-116.20066, 33.71858], [-116.20066, 33.71881], [-116.19995, 33.71937], [-116.19949, 33.71896], [-116.20008, 33.71895], [-116.20009, 33.71858], [-116.20066, 33.71858]]]} | Open Access 1 | Mulligan Dog Park | 22598 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1.038 | Mulligan Dog Park | ||
6759 | 6759 | 6758 | {"type": "Polygon", "coordinates": [[[-117.17334, 32.68705], [-117.17323, 32.68707], [-117.17308, 32.68713], [-117.17292, 32.68722], [-117.1728, 32.68736], [-117.17264, 32.68766], [-117.17258, 32.6877], [-117.17255, 32.6877], [-117.17251, 32.68767], [-117.17245, 32.68716], [-117.17244, 32.68695], [-117.17246, 32.68669], [-117.17308, 32.68693], [-117.17334, 32.68705]]]} | Open Access 1 | Mathewson Park | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3815090 | 21953 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1.039 | Mathewson Park | |
7607 | 7607 | 7606 | {"type": "Polygon", "coordinates": [[[-118.24359, 34.19991], [-118.24357, 34.20027], [-118.24358, 34.20061], [-118.24299, 34.20061], [-118.24297, 34.20045], [-118.24299, 34.20029], [-118.24319, 34.19973], [-118.24326, 34.19984], [-118.24331, 34.19987], [-118.24359, 34.19991]]]} | Open Access 1 | Oakmont View Park | 23033 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1.039 | Oakmont View Park | ||
2302 | 2302 | 2301 | {"type": "Polygon", "coordinates": [[[-117.32697, 33.13106], [-117.32664, 33.13118], [-117.32652, 33.13085], [-117.32636, 33.13054], [-117.32613, 33.13023], [-117.32591, 33.12999], [-117.32628, 33.12989], [-117.32697, 33.13106]]]} | Open Access 1 | City Park | 17341 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1.04 | City Park | ||
4755 | 4755 | 4754 | {"type": "Polygon", "coordinates": [[[-121.6946, 39.36391], [-121.69413, 39.36403], [-121.69382, 39.36318], [-121.6943, 39.36307], [-121.6946, 39.36391]]]} | Open Access 1 | Gridley holding 2 | 19509 | 1125 | Gridley, City of 487 | City 2 | City Agency 2 | http://www.gridley.ca.us/recreation-department/facilities/parks | City 2 | 1.04 | Gridley holding 2 | ||
5007 | 5007 | 5006 | {"type": "Polygon", "coordinates": [[[-122.52926, 37.93619], [-122.52826, 37.93629], [-122.52824, 37.93617], [-122.52854, 37.93616], [-122.52856, 37.93614], [-122.52889, 37.93609], [-122.52877, 37.93523], [-122.52912, 37.93519], [-122.52926, 37.93619]]]} | Open Access 1 | Heatherwood Park | 19787 | 1170 | Larkspur, City of 444 | City 2 | City Agency 2 | http://www.ci.larkspur.ca.us/index.aspx?nid=207 | City 2 | 1.043 | Heatherwood Park | ||
428 | 428 | 427 | {"type": "Polygon", "coordinates": [[[-121.69479, 38.17202], [-121.69429, 38.17241], [-121.69389, 38.1722], [-121.69389, 38.17216], [-121.69406, 38.17166], [-121.69414, 38.17158], [-121.69421, 38.17156], [-121.69429, 38.1716], [-121.69479, 38.17202]]]} | Open Access 1 | Homecoming Park | https://www.riovistacity.com/homecoming-park/ | 33492 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 1.044 | Homecoming Park | |
7783 | 7783 | 7782 | {"type": "Polygon", "coordinates": [[[-117.92836, 33.90467], [-117.92815, 33.9048], [-117.9281, 33.90476], [-117.92804, 33.90473], [-117.92797, 33.90475], [-117.92791, 33.9048], [-117.92753, 33.90466], [-117.92763, 33.90412], [-117.92794, 33.90402], [-117.92836, 33.90467]]]} | Open Access 1 | San Juan Park | 24919 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.044 | San Juan Park | ||
10611 | 10611 | 10610 | {"type": "Polygon", "coordinates": [[[-122.05238, 37.63238], [-122.05203, 37.63263], [-122.05126, 37.63194], [-122.05159, 37.63169], [-122.05238, 37.63238]]]} | Open Access 1 | Valle Vista Park | 26774 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 1.044 | Valle Vista Park | ||
4456 | 4456 | 4455 | {"type": "Polygon", "coordinates": [[[-120.65128, 35.26695], [-120.65108, 35.26705], [-120.6498, 35.2662], [-120.64958, 35.266], [-120.64939, 35.26574], [-120.64957, 35.26564], [-120.64973, 35.26588], [-120.64997, 35.2661], [-120.65128, 35.26695]]]} | Open Access 1 | Future Railroad Area Bike Path | 19160 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1.045 | Future Railroad Area Bike Path | ||
4914 | 4914 | 4913 | {"type": "Polygon", "coordinates": [[[-117.91056, 33.6321], [-117.91, 33.63265], [-117.90957, 33.63237], [-117.91011, 33.63178], [-117.91056, 33.6321]]]} | Open Access 1 | Harper Park | 19689 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1.045 | Harper 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]);