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 5,535
- Recreation/Parks District 630
- County Agency 599
- State Agency 559
- Non Profit - Land Trust 332
- Open Space District 168
- Federal Agency 153
- County Agency - Parks 148
- Water District 139
- Home Owners Association 116
- Community Services District 89
- Non Profit - Conservation 87
- Flood District 57
- Cemetery District 29
- Non Profit - Other 27
- County Agency - Other 22
- Port/Harbor District 20
- Irrigation District 13
- School District 13
- Commercial 10
- Sanitation District 6
- Special District - Other 5
- Other 5
- Joint Powers Authority 4
- Non Profit - Cemetery District 4
- Conservation District 4
- Transportation Agency 4
- Mitigation Bank 3
- Metropolitan Planning Organization 2
- Non Profit - Education 2
- …
MNG_AGENCY >30
- San Diego, City of 338
- Los Angeles, City of 292
- California Department of Fish and Wildlife 272
- California Department of Parks and Recreation 160
- Ventura, City of 130
- Mountains Recreation and Conservation Authority 126
- San Jose, City of 122
- San Francisco, City and County of 108
- Sacramento, City of 104
- Los Angeles, County of 102
- Long Beach, City of 97
- East Bay Regional Park District 96
- San Diego, County of 90
- Roseville, City of 86
- Fresno, City of 59
- Orange, County of 58
- Poway, City of 57
- Los Angeles - Department of Parks and Recreation, County of 56
- Santa Barbara, County of 54
- Torrance, City of 52
- Santa Cruz, City of 51
- Yuba County Water Agency 48
- Davis, City of 46
- Oakland, City of 45
- Clovis, City of 44
- Rocklin, City of 44
- Irvine, City of 43
- Napa, City of 43
- United States Fish and Wildlife Service 42
- San Ramon, City of 41
- …
ACCESS_TYP 4
- Open Access 7,349
- Restricted Access 735
- No Public Access 513
- Unknown Access 191
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6851 | 6851 | 6850 | {"type": "Polygon", "coordinates": [[[-120.04779, 36.95758], [-120.04695, 36.95815], [-120.04679, 36.95799], [-120.04678, 36.95683], [-120.04692, 36.95674], [-120.04779, 36.95758]]]} | Open Access 1 | McNally Memorial Park | 22058 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1.93 | McNally Memorial Park | ||
6852 | 6852 | 6851 | {"type": "Polygon", "coordinates": [[[-120.48826, 37.29263], [-120.4869, 37.29499], [-120.48565, 37.29453], [-120.48701, 37.29217], [-120.48826, 37.29263]]]} | Open Access 1 | McNamara Park | 22059 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 8.696 | McNamara Park | ||
6853 | 6853 | 6852 | {"type": "Polygon", "coordinates": [[[-122.62482, 38.22923], [-122.62481, 38.22929], [-122.62342, 38.22908], [-122.62223, 38.22891], [-122.62175, 38.22881], [-122.62087, 38.2285], [-122.62089, 38.22842], [-122.62177, 38.22873], [-122.62218, 38.22881], [-122.62233, 38.22877], [-122.62254, 38.22851], [-122.62255, 38.22848], [-122.62263, 38.22846], [-122.62285, 38.22854], [-122.6229, 38.2286], [-122.62284, 38.2288], [-122.6229, 38.22889], [-122.62296, 38.22894], [-122.62363, 38.22902], [-122.62482, 38.22923]]]} | Open Access 1 | Mcnear Landing | 22060 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1.221 | Mcnear Landing | ||
6854 | 6854 | 6853 | {"type": "Polygon", "coordinates": [[[-122.63904, 38.22399], [-122.63784, 38.22593], [-122.63747, 38.22579], [-122.63737, 38.22594], [-122.6369, 38.22573], [-122.63666, 38.22609], [-122.63629, 38.22594], [-122.63779, 38.2235], [-122.63904, 38.22399]]]} | Open Access 1 | McNear Park | 22061 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 8.006 | McNear Park | 2000 | |
6855 | 6855 | 6854 | {"type": "Polygon", "coordinates": [[[-122.63444, 38.23534], [-122.63418, 38.23571], [-122.63379, 38.23586], [-122.63371, 38.23586], [-122.63364, 38.23585], [-122.63289, 38.23545], [-122.63279, 38.23547], [-122.63252, 38.23569], [-122.63253, 38.23561], [-122.63232, 38.23551], [-122.63121, 38.23488], [-122.63129, 38.23469], [-122.63126, 38.23465], [-122.63166, 38.23421], [-122.63111, 38.23393], [-122.63152, 38.23326], [-122.63195, 38.23347], [-122.63287, 38.23386], [-122.63321, 38.23397], [-122.63284, 38.23465], [-122.6335, 38.23491], [-122.6336, 38.23488], [-122.63374, 38.23473], [-122.63384, 38.23468], [-122.63395, 38.23468], [-122.6342, 38.23476], [-122.63429, 38.23482], [-122.63433, 38.2349], [-122.63429, 38.23523], [-122.63444, 38.23534]]]} | Open Access 1 | McNear Peninsula Waterfront Park | 22062 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 10.156 | McNear Peninsula Waterfront Park | ||
6856 | 6856 | 6855 | {"type": "Polygon", "coordinates": [[[-122.45839, 37.98929], [-122.45809, 37.98953], [-122.45784, 37.98981], [-122.45766, 37.99012], [-122.45759, 37.99029], [-122.45465, 37.99151], [-122.45474, 37.99159], [-122.45471, 37.99167], [-122.45441, 37.99205], [-122.45432, 37.99223], [-122.45429, 37.99245], [-122.45434, 37.99267], [-122.45476, 37.99335], [-122.4548, 37.99346], [-122.4548, 37.99369], [-122.45486, 37.99386], [-122.45495, 37.99396], [-122.45505, 37.99402], [-122.4554, 37.99415], [-122.45546, 37.9942], [-122.45551, 37.99427], [-122.45552, 37.9944], [-122.45546, 37.99457], [-122.45544, 37.9947], [-122.45547, 37.99484], [-122.45552, 37.99494], [-122.45596, 37.99552], [-122.45606, 37.99562], [-122.45618, 37.99569], [-122.45623, 37.99585], [-122.45655, 37.99603], [-122.45651, 37.99606], [-122.45583, 37.99567], [-122.45547, 37.99575], [-122.45547, 37.99577], [-122.4558, 37.99614], [-122.45591, 37.99715], [-122.45356, 37.99846], [-122.4506, 37.99225], [-122.44966, 37.9914], [-122.44921, 37.99022], [-122.45009, 37.98975], [-122.45045, 37.98966], [-122.45084, 37.98983], [-122.45098, 37.98984], [-122.45142, 37.98981], [-122.45169, 37.98974], [-122.45191, 37.98966], [-122.45259, 37.98975], [-122.45273, 37.98993], [-122.45218, 37.9909], [-122.45244, 37.99108], [-122.45293, 37.99112], [-122.45354, 37.99068], [-122.45375, 37.99068], [-122.45435, 37.99101], [-122.45654, 37.99027], [-122.45739, 37.98985], [-122.45767, 37.98964], [-122.45793, 37.98942], [-122.45818, 37.98916], [-122.45839, 37.98929]]]} | Open Access 1 | McNears Beach County Park | 22063 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 74.192 | McNears Beach County Park | 2000 | |
6857 | 6857 | 6856 | {"type": "Polygon", "coordinates": [[[-118.05463, 33.98259], [-118.05463, 33.98262], [-118.05459, 33.98263], [-118.05399, 33.98263], [-118.0539, 33.9826], [-118.05387, 33.98256], [-118.05386, 33.98251], [-118.05397, 33.98223], [-118.05403, 33.98219], [-118.05411, 33.98218], [-118.05417, 33.9822], [-118.05456, 33.98246], [-118.05462, 33.98252], [-118.05463, 33.98259]]]} | Open Access 1 | McNees Park | 22064 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.604 | McNees Park | ||
6858 | 6858 | 6857 | {"type": "Polygon", "coordinates": [[[-121.78224, 38.00152], [-121.78223, 38.00289], [-121.782, 38.00291], [-121.78203, 38.00356], [-121.78215, 38.0037], [-121.782, 38.00378], [-121.78185, 38.00358], [-121.78163, 38.00341], [-121.78158, 38.00331], [-121.78173, 38.00246], [-121.78174, 38.00151], [-121.78224, 38.00152]]]} | Open Access 1 | Meadow Brook Park | 22068 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 2.404 | Meadow Brook Park | ||
6859 | 6859 | 6858 | {"type": "Polygon", "coordinates": [[[-121.75444, 37.96717], [-121.75437, 37.96758], [-121.7542, 37.96784], [-121.7539, 37.96806], [-121.75358, 37.96816], [-121.75281, 37.96822], [-121.75239, 37.96832], [-121.75206, 37.96846], [-121.75239, 37.96712], [-121.75444, 37.96717]]]} | Open Access 1 | Meadow Creek Estates Park | 22069 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 5.134 | Meadow Creek Estates Park | ||
6860 | 6860 | 6859 | {"type": "Polygon", "coordinates": [[[-122.37493, 40.51983], [-122.37441, 40.52028], [-122.374, 40.52054], [-122.37376, 40.52032], [-122.37416, 40.52006], [-122.37388, 40.51971], [-122.37427, 40.51938], [-122.37493, 40.51983]]]} | Open Access 1 | Meadow Creek Park | 22070 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.471 | Meadow Creek Park | ||
6861 | 6861 | 6860 | {"type": "MultiPolygon", "coordinates": [[[[-122.00251, 38.2696], [-122.00233, 38.26963], [-122.0022, 38.26968], [-122.00115, 38.27042], [-122.001, 38.27046], [-122.00064, 38.27045], [-122.00079, 38.26977], [-122.00083, 38.26941], [-122.00093, 38.269], [-122.00111, 38.26902], [-122.0015, 38.26897], [-122.0016, 38.26894], [-122.00174, 38.26885], [-122.00196, 38.26874], [-122.0021, 38.26877], [-122.00234, 38.26902], [-122.00237, 38.26924], [-122.00236, 38.26929], [-122.0023, 38.26936], [-122.00231, 38.26939], [-122.0023, 38.26945], [-122.00243, 38.2695], [-122.00249, 38.2695], [-122.00251, 38.2696]]], [[[-122.05196, 38.28157], [-122.05189, 38.28173], [-122.05184, 38.28197], [-122.0518, 38.28203], [-122.05173, 38.28215], [-122.05151, 38.28236], [-122.05144, 38.28239], [-122.05123, 38.2821], [-122.05113, 38.28209], [-122.05107, 38.28211], [-122.05101, 38.2821], [-122.05098, 38.28206], [-122.05103, 38.28189], [-122.05102, 38.28184], [-122.05096, 38.28181], [-122.05092, 38.28172], [-122.05091, 38.28165], [-122.05092, 38.2816], [-122.05102, 38.28151], [-122.05113, 38.28151], [-122.05133, 38.28146], [-122.05135, 38.28137], [-122.05135, 38.28127], [-122.0514, 38.28116], [-122.05148, 38.28112], [-122.05159, 38.28113], [-122.05169, 38.28118], [-122.05178, 38.28128], [-122.05196, 38.28157]]]]} | Open Access 1 | Meadow Glen Park | 22071 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 6.376 | Meadow Glen Park | ||
6862 | 6862 | 6861 | {"type": "Polygon", "coordinates": [[[-122.25797, 37.86601], [-122.25644, 37.86621], [-122.25629, 37.86549], [-122.25782, 37.86528], [-122.25797, 37.86601]]]} | Open Access 1 | Peoples Park | 23591 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 2.748 | Peoples Park | ||
6863 | 6863 | 6862 | {"type": "Polygon", "coordinates": [[[-122.04156, 37.96284], [-122.04157, 37.96319], [-122.04143, 37.9635], [-122.03856, 37.96546], [-122.03816, 37.965], [-122.03816, 37.96496], [-122.03837, 37.96482], [-122.03852, 37.96467], [-122.03862, 37.9645], [-122.0387, 37.96422], [-122.03877, 37.96408], [-122.03887, 37.96394], [-122.039, 37.96383], [-122.03921, 37.96401], [-122.04137, 37.96256], [-122.04156, 37.96284]]]} | Open Access 1 | Meadow Homes Park | 22072 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 7.702 | Meadow Homes Park | ||
6864 | 6864 | 6863 | {"type": "Polygon", "coordinates": [[[-122.30482, 38.00195], [-122.3047, 38.0025], [-122.30429, 38.00259], [-122.30396, 38.00258], [-122.30412, 38.00193], [-122.30482, 38.00195]]]} | Open Access 1 | Meadow Park | 22073 | 1252 | Pinole, City of 354 | City 2 | City Agency 2 | http://www.ci.pinole.ca.us/recreation/parks.html | City 2 | 1.081 | Meadow Park | ||
6865 | 6865 | 6864 | {"type": "Polygon", "coordinates": [[[-120.66036, 35.26938], [-120.65818, 35.26938], [-120.65817, 35.2674], [-120.65853, 35.26738], [-120.65871, 35.26733], [-120.65883, 35.26728], [-120.65901, 35.26753], [-120.66031, 35.26772], [-120.66036, 35.26938]]]} | Open Access 1 | Meadow Park | 22074 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 9.981 | Meadow Park | ||
6866 | 6866 | 6865 | {"type": "Polygon", "coordinates": [[[-120.2151, 39.32745], [-120.21477, 39.32767], [-120.21386, 39.32773], [-120.21212, 39.32774], [-120.21212, 39.32747], [-120.21163, 39.32746], [-120.21163, 39.32692], [-120.21135, 39.32691], [-120.21136, 39.32622], [-120.21306, 39.32623], [-120.21363, 39.32622], [-120.21363, 39.32692], [-120.2136, 39.32694], [-120.21363, 39.32703], [-120.21368, 39.32708], [-120.21376, 39.32714], [-120.21385, 39.32715], [-120.21456, 39.3271], [-120.21471, 39.32712], [-120.21483, 39.32718], [-120.2151, 39.32745]]]} | Open Access 1 | Meadow Park | 22075 | 2263 | Truckee-Donner Recreation and Park District 568 | Special District 4 | Recreation/Parks District 4 | http://www.tdrpd.com/ | Special District 4 | 9.077 | Meadow Park | ||
6867 | 6867 | 6866 | {"type": "Polygon", "coordinates": [[[-117.81063, 33.67059], [-117.81046, 33.67171], [-117.80973, 33.67181], [-117.80991, 33.67052], [-117.81063, 33.67059]]]} | Restricted Access 2 | Meadow Park | 22076 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.23 | Meadow Park | ||
6868 | 6868 | 6867 | {"type": "Polygon", "coordinates": [[[-116.90495, 34.24779], [-116.90474, 34.24781], [-116.90462, 34.24807], [-116.90448, 34.24827], [-116.90431, 34.24846], [-116.90403, 34.24873], [-116.90396, 34.24889], [-116.90389, 34.24891], [-116.90385, 34.24888], [-116.90384, 34.24884], [-116.90405, 34.24859], [-116.9042, 34.24846], [-116.9043, 34.24833], [-116.90447, 34.24807], [-116.90456, 34.24782], [-116.90364, 34.24786], [-116.90349, 34.24799], [-116.90332, 34.2481], [-116.90318, 34.24817], [-116.90296, 34.24825], [-116.90253, 34.24807], [-116.90234, 34.24797], [-116.90204, 34.24794], [-116.9013, 34.24797], [-116.90048, 34.24739], [-116.89837, 34.24635], [-116.89837, 34.24628], [-116.90046, 34.24631], [-116.9026, 34.24714], [-116.90378, 34.24716], [-116.90436, 34.24666], [-116.90495, 34.24714], [-116.90495, 34.24779]]]} | Open Access 1 | Meadow Park/ Ski Beach Park | 22077 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 14.963 | Meadow Park/ Ski Beach Park | ||
6869 | 6869 | 6868 | {"type": "Polygon", "coordinates": [[[-121.14493, 37.46191], [-121.14464, 37.46191], [-121.14412, 37.46212], [-121.144, 37.46199], [-121.14368, 37.46171], [-121.14316, 37.46139], [-121.14344, 37.46118], [-121.14351, 37.4612], [-121.14357, 37.4612], [-121.14365, 37.46116], [-121.1449, 37.46116], [-121.14493, 37.46191]]]} | Open Access 1 | Meadow Rue Park | 22078 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 2.784 | Meadow Rue Park | ||
6870 | 6870 | 6869 | {"type": "Polygon", "coordinates": [[[-122.64737, 38.26448], [-122.64735, 38.26461], [-122.64727, 38.26477], [-122.64616, 38.26602], [-122.64547, 38.26568], [-122.64597, 38.26509], [-122.6463, 38.26476], [-122.6466, 38.2646], [-122.64689, 38.26449], [-122.64719, 38.26443], [-122.64734, 38.26443], [-122.64737, 38.26448]]]} | Open Access 1 | Meadow View | 22079 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 3.158 | Meadow View |
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]);