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 7,739
- County Agency 828
- Recreation/Parks District 797
- State Agency 606
- Non Profit - Land Trust 407
- Open Space District 191
- Federal Agency 174
- County Agency - Parks 169
- Water District 154
- Community Services District 146
- Home Owners Association 131
- Non Profit - Conservation 96
- Flood District 69
- Cemetery District 45
- Non Profit - Other 33
- County Agency - Other 27
- Port/Harbor District 27
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 8
- Special District - Other 6
- Other 5
- Joint Powers Authority 4
- Non Profit - Cemetery District 4
- Mitigation Bank 4
- Conservation District 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 372
- San Diego, City of 368
- California Department of Fish and Wildlife 295
- San Jose, City of 182
- San Francisco, City and County of 166
- Sacramento, City of 163
- California Department of Parks and Recreation 162
- Mountains Recreation and Conservation Authority 145
- Ventura, City of 140
- Los Angeles, County of 136
- Long Beach, City of 119
- San Diego, County of 108
- Roseville, City of 104
- East Bay Regional Park District 102
- Oakland, City of 83
- Irvine, City of 81
- Fresno, City of 78
- Consumnes Community Services District 75
- Santa Barbara, County of 69
- Orange, County of 67
- Torrance, City of 64
- Huntington Beach, City of 61
- Poway, City of 61
- Stockton, City of 61
- Santa Cruz, City of 59
- Hayward Area Recreation and Park District 59
- Chula Vista, City of 57
- Los Angeles - Department of Parks and Recreation, County of 57
- Modesto, City of 57
- Tracy, City of 56
- …
ACCESS_TYP 4
- Open Access 10,045
- Restricted Access 848
- No Public Access 608
- Unknown Access 224
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3914 | 3914 | 3913 | {"type": "Polygon", "coordinates": [[[-121.89538, 37.67097], [-121.89482, 37.67152], [-121.89403, 37.67123], [-121.89309, 37.67062], [-121.89239, 37.66998], [-121.8933, 37.66949], [-121.89367, 37.66993], [-121.89538, 37.67097]]]} | Open Access 1 | Hansen Park | 19650 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 5.897 | Hansen Park | ||
3915 | 3915 | 3914 | {"type": "Polygon", "coordinates": [[[-120.39086, 36.50214], [-120.39079, 36.50243], [-120.39079, 36.50283], [-120.39059, 36.50287], [-120.39032, 36.50283], [-120.39015, 36.50274], [-120.38996, 36.50251], [-120.38987, 36.50246], [-120.38984, 36.5023], [-120.38984, 36.50215], [-120.38985, 36.50208], [-120.3899, 36.502], [-120.39023, 36.50191], [-120.39072, 36.50197], [-120.39086, 36.50214]]]} | Open Access 1 | El Parque de la Communida El Porvenir | 18524 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 1.861 | El Parque de la Communida El Porvenir | ||
3916 | 3916 | 3915 | {"type": "Polygon", "coordinates": [[[-118.84318, 34.17165], [-118.84311, 34.1721], [-118.84216, 34.17297], [-118.84216, 34.17295], [-118.84101, 34.17208], [-118.84133, 34.17181], [-118.84163, 34.17167], [-118.8419, 34.1716], [-118.84222, 34.17156], [-118.84268, 34.17158], [-118.84318, 34.17165]]]} | Open Access 1 | El Parque de la Paz | 18525 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 4.571 | El Parque de la Paz | ||
3917 | 3917 | 3916 | {"type": "MultiPolygon", "coordinates": [[[[-117.21301, 33.87552], [-117.21265, 33.8756], [-117.21258, 33.87543], [-117.21246, 33.87526], [-117.2123, 33.87511], [-117.21214, 33.87501], [-117.21187, 33.87491], [-117.21099, 33.87478], [-117.2109, 33.87468], [-117.21098, 33.87391], [-117.21278, 33.87393], [-117.21279, 33.8744], [-117.21285, 33.87488], [-117.21287, 33.87501], [-117.21289, 33.87505], [-117.21301, 33.87552]]], [[[-117.21735, 33.87448], [-117.21724, 33.87454], [-117.21542, 33.87452], [-117.21529, 33.87448], [-117.21519, 33.87448], [-117.21508, 33.87454], [-117.21502, 33.87462], [-117.21502, 33.87471], [-117.21505, 33.87477], [-117.21504, 33.87503], [-117.21332, 33.87502], [-117.21325, 33.87454], [-117.21324, 33.87428], [-117.21325, 33.87393], [-117.21468, 33.87393], [-117.2147, 33.87379], [-117.21734, 33.8738], [-117.21735, 33.87448]]]]} | Open Access 1 | El Potrero Park | 18530 | 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 | 14.763 | El Potrero Park | ||
3918 | 3918 | 3917 | {"type": "Polygon", "coordinates": [[[-122.4529, 38.2874], [-122.4529, 38.28742], [-122.45253, 38.28738], [-122.45247, 38.28767], [-122.45244, 38.28767], [-122.45247, 38.28737], [-122.45148, 38.28727], [-122.45139, 38.28757], [-122.45136, 38.28757], [-122.45142, 38.28728], [-122.45114, 38.28724], [-122.45117, 38.28695], [-122.45122, 38.28695], [-122.45126, 38.28705], [-122.4513, 38.28711], [-122.45143, 38.2872], [-122.45159, 38.28701], [-122.45161, 38.28702], [-122.45149, 38.28722], [-122.45163, 38.28726], [-122.45176, 38.28726], [-122.4519, 38.28723], [-122.45207, 38.28711], [-122.4521, 38.28706], [-122.45215, 38.28692], [-122.45217, 38.28681], [-122.45247, 38.28684], [-122.45245, 38.28703], [-122.45245, 38.2871], [-122.45247, 38.28715], [-122.45254, 38.28725], [-122.45262, 38.2873], [-122.45281, 38.28713], [-122.45283, 38.28714], [-122.45265, 38.28733], [-122.45277, 38.28739], [-122.4529, 38.2874]]]} | Open Access 1 | El Prado Common | 18531 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 0.875 | El Prado Common | ||
3919 | 3919 | 3918 | {"type": "MultiPolygon", "coordinates": [[[[-118.31874, 33.83299], [-118.3174, 33.83403], [-118.31715, 33.83381], [-118.31849, 33.83277], [-118.31874, 33.83299]]], [[[-118.32028, 33.83181], [-118.31891, 33.83287], [-118.31866, 33.83264], [-118.32004, 33.83159], [-118.32028, 33.83181]]], [[[-118.32091, 33.83125], [-118.32091, 33.83125], [-118.32024, 33.83126], [-118.3206, 33.83097], [-118.32091, 33.83125]]], [[[-118.32096, 33.83147], [-118.32058, 33.83176], [-118.32027, 33.83147], [-118.32027, 33.83147], [-118.32096, 33.83147]]]]} | Open Access 1 | El Prado Park | 18532 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 3.356 | El Prado Park | ||
3920 | 3920 | 3919 | {"type": "Polygon", "coordinates": [[[-122.00048, 37.28115], [-121.99895, 37.28263], [-121.99808, 37.28248], [-121.99763, 37.28235], [-121.99816, 37.28112], [-122.00037, 37.28108], [-122.00048, 37.28115]]]} | Open Access 1 | El Quito Park | 18533 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 6.63 | El Quito Park | 1973 | |
3921 | 3921 | 3920 | {"type": "Polygon", "coordinates": [[[-118.37986, 33.81559], [-118.37947, 33.8157], [-118.37941, 33.81576], [-118.37708, 33.81546], [-118.37702, 33.81542], [-118.37673, 33.81482], [-118.37681, 33.81477], [-118.37702, 33.81473], [-118.37726, 33.8147], [-118.37777, 33.8147], [-118.3781, 33.81476], [-118.37848, 33.81488], [-118.37879, 33.81503], [-118.37914, 33.81529], [-118.37933, 33.81549], [-118.37968, 33.81529], [-118.37975, 33.81538], [-118.37986, 33.81559]]]} | Open Access 1 | El Retiro Park | 18536 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 4.788 | El Retiro Park | ||
3922 | 3922 | 3921 | {"type": "Polygon", "coordinates": [[[-121.58635, 37.00494], [-121.58633, 37.00581], [-121.58592, 37.00581], [-121.5859, 37.00577], [-121.58462, 37.00576], [-121.58463, 37.00523], [-121.58456, 37.00497], [-121.58495, 37.00492], [-121.58635, 37.00494]]]} | Open Access 1 | El Roble Park | 18537 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 3.551 | El Roble Park | ||
3923 | 3923 | 3922 | {"type": "Polygon", "coordinates": [[[-117.89558, 33.75242], [-117.89529, 33.75244], [-117.89531, 33.75329], [-117.8936, 33.75333], [-117.89359, 33.75197], [-117.89397, 33.75194], [-117.89398, 33.75162], [-117.89558, 33.75161], [-117.89558, 33.75242]]]} | Open Access 1 | El Salvador Park | 18538 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 7.574 | El Salvador Park | ||
3924 | 3924 | 3923 | {"type": "Polygon", "coordinates": [[[-118.42983, 33.91628], [-118.4284, 33.91628], [-118.4259, 33.91134], [-118.42605, 33.91129], [-118.42606, 33.91127], [-118.42358, 33.90637], [-118.42295, 33.90501], [-118.42323, 33.90492], [-118.42451, 33.90742], [-118.42615, 33.91031], [-118.42632, 33.9105], [-118.4267, 33.91083], [-118.42692, 33.91098], [-118.4275, 33.91078], [-118.42757, 33.91145], [-118.42767, 33.91175], [-118.42983, 33.91628]]]} | Open Access 1 | El Segundo Beach | 18539 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 27.601 | El Segundo Beach | ||
3925 | 3925 | 3924 | {"type": "Polygon", "coordinates": [[[-118.41119, 33.93127], [-118.40819, 33.93129], [-118.40416, 33.93127], [-118.404, 33.93105], [-118.40398, 33.93097], [-118.41118, 33.93095], [-118.41119, 33.93127]]]} | Open Access 1 | El Segundo Dog Park | 18540 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 5.668 | El Segundo Dog Park | ||
3926 | 3926 | 3925 | {"type": "Polygon", "coordinates": [[[-118.16836, 34.09707], [-118.16833, 34.09818], [-118.16828, 34.0982], [-118.16756, 34.09819], [-118.16751, 34.09817], [-118.16748, 34.09812], [-118.16751, 34.09648], [-118.16794, 34.09648], [-118.16793, 34.09706], [-118.16836, 34.09707]]]} | Open Access 1 | El Sereno North Park | 18541 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.075 | El Sereno North Park | ||
3927 | 3927 | 3926 | {"type": "Polygon", "coordinates": [[[-117.68379, 33.64177], [-117.68361, 33.64242], [-117.68314, 33.64365], [-117.68303, 33.64446], [-117.68101, 33.64482], [-117.68049, 33.64436], [-117.67955, 33.6437], [-117.68281, 33.64044], [-117.68379, 33.64177]]]} | Open Access 1 | El Toro Memorial Park Cemetery | 18544 | 2104 | Orange County Cemetery District 861 | Special District 4 | Cemetery District 11 | http://www.occemeterydistrict.com/ | Special District 4 | 25.359 | El Toro Memorial Park Cemetery | ||
3928 | 3928 | 3927 | {"type": "Polygon", "coordinates": [[[-117.69609, 33.61357], [-117.69569, 33.61418], [-117.6956, 33.61436], [-117.69548, 33.6154], [-117.69545, 33.61558], [-117.69515, 33.6161], [-117.69455, 33.617], [-117.69455, 33.61708], [-117.69458, 33.61712], [-117.69462, 33.61712], [-117.69418, 33.61781], [-117.69372, 33.61814], [-117.69289, 33.61725], [-117.69478, 33.61459], [-117.69567, 33.61338], [-117.69609, 33.61357]]]} | Open Access 1 | El Toro Park | 18546 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 12.738 | El Toro Park | ||
3929 | 3929 | 3928 | {"type": "Polygon", "coordinates": [[[-118.20783, 34.07667], [-118.20782, 34.07673], [-118.20742, 34.07716], [-118.20736, 34.07718], [-118.20729, 34.07716], [-118.20726, 34.07711], [-118.20727, 34.07706], [-118.20766, 34.07664], [-118.20772, 34.07661], [-118.20779, 34.07663], [-118.20783, 34.07667]]]} | Open Access 1 | Ela Park | 18548 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.315 | Ela Park | ||
3930 | 3930 | 3929 | {"type": "Polygon", "coordinates": [[[-117.96021, 33.73828], [-117.95756, 33.7383], [-117.95755, 33.7378], [-117.95909, 33.73779], [-117.95911, 33.73774], [-117.96021, 33.73773], [-117.96021, 33.73828]]]} | Open Access 1 | Elden F Gillespie Park | 18549 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 3.524 | Elden F Gillespie Park | ||
3931 | 3931 | 3930 | {"type": "Polygon", "coordinates": [[[-121.52527, 38.67891], [-121.52528, 38.67894], [-121.52528, 38.67945], [-121.52525, 38.67979], [-121.52524, 38.67981], [-121.52518, 38.67983], [-121.5248, 38.67981], [-121.52421, 38.67972], [-121.52433, 38.67886], [-121.52475, 38.67888], [-121.52521, 38.67888], [-121.52527, 38.67891]]]} | Open Access 1 | Elderberry Park | 18550 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.183 | Elderberry Park | ||
3932 | 3932 | 3931 | {"type": "Polygon", "coordinates": [[[-120.67829, 35.15698], [-120.67828, 35.15699], [-120.67707, 35.15525], [-120.67652, 35.15489], [-120.67589, 35.15455], [-120.67538, 35.1543], [-120.67549, 35.15415], [-120.67567, 35.15418], [-120.6758, 35.1543], [-120.67597, 35.15431], [-120.67605, 35.15433], [-120.67608, 35.15437], [-120.67604, 35.15449], [-120.67606, 35.15454], [-120.6764, 35.15476], [-120.67645, 35.15477], [-120.67668, 35.15476], [-120.67699, 35.15469], [-120.67707, 35.15469], [-120.67708, 35.15473], [-120.67704, 35.15479], [-120.67704, 35.15487], [-120.67712, 35.15506], [-120.67706, 35.15515], [-120.67706, 35.15517], [-120.6773, 35.15533], [-120.67731, 35.15539], [-120.67729, 35.1555], [-120.67729, 35.15555], [-120.67737, 35.1556], [-120.6774, 35.1557], [-120.67746, 35.15575], [-120.67751, 35.15583], [-120.67765, 35.15599], [-120.67774, 35.15614], [-120.6779, 35.1562], [-120.67802, 35.15627], [-120.67803, 35.15632], [-120.67801, 35.15635], [-120.67801, 35.15637], [-120.67811, 35.15644], [-120.67813, 35.15648], [-120.67812, 35.15667], [-120.67825, 35.15685], [-120.67829, 35.15698]]]} | Open Access 1 | Eldwayen Ocean Park | 18555 | 1253 | Pismo Beach, City of 417 | City 2 | City Agency 2 | http://www.pismobeach.org/69/Parks-Halls | City 2 | 1.351 | Eldwayen Ocean Park | ||
3933 | 3933 | 3932 | {"type": "Polygon", "coordinates": [[[-122.1431, 37.44885], [-122.14308, 37.45144], [-122.14138, 37.4509], [-122.14138, 37.44884], [-122.1431, 37.44885]]]} | Open Access 1 | Eleanor Pardee Park | 18556 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 9.674 | Eleanor Pardee Park | 1920 |
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]);