superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP >30
- City Agency 2,528
- State Agency 423
- Recreation/Parks District 340
- County Agency 314
- Non Profit - Land Trust 251
- Home Owners Association 157
- Open Space District 118
- County Agency - Parks 113
- Water District 78
- Non Profit - Conservation 59
- Federal Agency 49
- Community Services District 48
- School District 38
- Flood District 34
- Non Profit - Other 30
- County Agency - Other 15
- Port/Harbor District 15
- Commercial 13
- Joint Powers Authority 8
- Cemetery District 7
- Other 6
- Irrigation District 3
- Sanitation District 2
- Special District - Other 2
- Metropolitan Planning Organization 2
- Non Profit - Education 2
- Mitigation Bank 1
- Utility 1
- Conservation District 1
- Home Owners Associatin 1
- …
ACCESS_TYP 4
- Open Access 3,429
- Restricted Access 716
- No Public Access 410
- Unknown Access 105
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9681 | 9681 | 9680 | {"type": "Polygon", "coordinates": [[[-121.98613, 37.54673], [-121.98584, 37.5471], [-121.98512, 37.54673], [-121.98542, 37.54636], [-121.98613, 37.54673]]]} | Open Access 1 | Williams Historical Park | 27563 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 0.894 | Williams Historical Park | 1973 | |
11234 | 11234 | 11233 | {"type": "Polygon", "coordinates": [[[-122.15135, 39.15148], [-122.15134, 39.15235], [-122.15081, 39.15256], [-122.15016, 39.15159], [-122.15049, 39.15147], [-122.15135, 39.15148]]]} | Open Access 1 | Williams holding 1 | 27564 | 1381 | Williams, City of 738 | City 2 | City Agency 2 | http://www.cityofwilliams.org/parks-rec/index.htm | City 2 | 2.144 | Williams holding 1 | ||
11235 | 11235 | 11234 | {"type": "Polygon", "coordinates": [[[-121.59687, 36.69074], [-121.59638, 36.69086], [-121.59588, 36.69102], [-121.59556, 36.69116], [-121.59504, 36.69145], [-121.59498, 36.69144], [-121.59445, 36.69082], [-121.59625, 36.68982], [-121.59673, 36.69038], [-121.59687, 36.69074]]]} | Open Access 1 | Williams Ranch Neighborhood Park | 27566 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 4.594 | Williams Ranch Neighborhood Park | ||
11252 | 11252 | 11251 | {"type": "Polygon", "coordinates": [[[-119.72248, 36.84862], [-119.72219, 36.84884], [-119.72162, 36.84836], [-119.72192, 36.84814], [-119.72231, 36.84848], [-119.72248, 36.84862]]]} | Open Access 1 | Williamsburg II Park | 27567 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.638 | Williamsburg II Park | ||
11207 | 11207 | 11206 | {"type": "Polygon", "coordinates": [[[-121.76194, 37.96045], [-121.76194, 37.96158], [-121.76011, 37.96155], [-121.76007, 37.96101], [-121.75997, 37.9605], [-121.76011, 37.96044], [-121.76194, 37.96045]]]} | Open Access 1 | Williamson Ranch Park | 27568 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 5.106 | Williamson Ranch Park | ||
11269 | 11269 | 11268 | {"type": "Polygon", "coordinates": [[[-122.38986, 37.7765], [-122.38982, 37.77659], [-122.38764, 37.77675], [-122.38752, 37.77674], [-122.38739, 37.77668], [-122.38733, 37.77661], [-122.38731, 37.77656], [-122.3873, 37.77609], [-122.38762, 37.77606], [-122.38766, 37.77631], [-122.38769, 37.77639], [-122.38775, 37.77644], [-122.38981, 37.77634], [-122.38986, 37.7765]]]} | Open Access 1 | Willie Mccovey Park | 27569 | 2198 | San Francisco, Port of 786 | Special District 4 | Port/Harbor District 14 | http://www.sfport.com/index.aspx?page=60 | Special District 4 | 1.982 | Willie Mccovey Park | ||
11270 | 11270 | 11269 | {"type": "Polygon", "coordinates": [[[-117.74296, 34.10224], [-117.74278, 34.10225], [-117.7426, 34.10228], [-117.74223, 34.10243], [-117.74204, 34.10248], [-117.74158, 34.1025], [-117.74154, 34.10249], [-117.74153, 34.10247], [-117.74153, 34.1023], [-117.74155, 34.10212], [-117.74168, 34.10174], [-117.74171, 34.10159], [-117.74174, 34.10112], [-117.74295, 34.10111], [-117.74296, 34.10224]]]} | Open Access 1 | Willie White Park | 27570 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 4.212 | Willie White Park | ||
11271 | 11271 | 11270 | {"type": "Polygon", "coordinates": [[[-123.35326, 39.41341], [-123.35233, 39.41343], [-123.35231, 39.41342], [-123.35228, 39.41253], [-123.35322, 39.41253], [-123.35324, 39.41254], [-123.35326, 39.41341]]]} | Open Access 1 | Willits City Park | 27571 | 1414 | Willits, City of 570 | City 2 | City Agency 2 | http://thecityofwillits.com/ | City 2 | 2.013 | Willits City Park | ||
11272 | 11272 | 11271 | {"type": "Polygon", "coordinates": [[[-119.72964, 36.73869], [-119.72964, 36.73915], [-119.72751, 36.73913], [-119.72751, 36.7387], [-119.72964, 36.73869]]]} | Open Access 1 | Willow-Balch Park | 27572 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 2.327 | Willow-Balch Park | ||
11273 | 11273 | 11272 | {"type": "Polygon", "coordinates": [[[-119.09318, 36.42005], [-119.09313, 36.42009], [-119.09313, 36.42107], [-119.09217, 36.42107], [-119.09218, 36.4193], [-119.09283, 36.4193], [-119.09284, 36.41953], [-119.09299, 36.41966], [-119.09299, 36.41972], [-119.09302, 36.41978], [-119.09309, 36.41983], [-119.09314, 36.41989], [-119.09317, 36.41997], [-119.09318, 36.42005]]]} | Open Access 1 | Willow Court Park | 27573 | 1383 | Woodlake, City of 171 | City 2 | City Agency 2 | http://www.cityofwoodlake.com/ | City 2 | 3.917 | Willow Court Park | ||
11274 | 11274 | 11273 | {"type": "MultiPolygon", "coordinates": [[[[-121.16924, 38.65774], [-121.16896, 38.65771], [-121.16855, 38.65678], [-121.16886, 38.65674], [-121.16896, 38.65708], [-121.16924, 38.65774]]], [[[-121.17532, 38.65773], [-121.17433, 38.65815], [-121.17418, 38.65817], [-121.17404, 38.65816], [-121.1739, 38.65812], [-121.1731, 38.65773], [-121.17294, 38.65768], [-121.17275, 38.65767], [-121.17207, 38.65774], [-121.17195, 38.65772], [-121.1719, 38.65768], [-121.17188, 38.65763], [-121.17178, 38.65702], [-121.17332, 38.65696], [-121.1745, 38.65783], [-121.17532, 38.65773]]], [[[-121.17623, 38.66259], [-121.1745, 38.66164], [-121.17445, 38.66148], [-121.17582, 38.6616], [-121.17604, 38.66229], [-121.1762, 38.66248], [-121.17623, 38.66259]]], [[[-121.17588, 38.65765], [-121.17587, 38.65767], [-121.17565, 38.65814], [-121.17558, 38.65769], [-121.17588, 38.65765]]]]} | Open Access 1 | Willow Creek | 27575 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 7.282 | Willow Creek | ||
11275 | 11275 | 11274 | {"type": "Polygon", "coordinates": [[[-121.70677, 38.54671], [-121.70675, 38.54698], [-121.7067, 38.54723], [-121.70665, 38.54741], [-121.70659, 38.54746], [-121.70654, 38.54746], [-121.70604, 38.54738], [-121.70546, 38.54733], [-121.70502, 38.54734], [-121.70456, 38.5474], [-121.70451, 38.54738], [-121.70447, 38.54734], [-121.70443, 38.54715], [-121.7044, 38.54689], [-121.70436, 38.54675], [-121.70431, 38.54664], [-121.70413, 38.54637], [-121.70448, 38.54638], [-121.70482, 38.54641], [-121.70547, 38.54642], [-121.70557, 38.5467], [-121.70677, 38.54671]]]} | Open Access 1 | Willow Creek Park | 27576 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 4.642 | Willow Creek Park | ||
11276 | 11276 | 11275 | {"type": "Polygon", "coordinates": [[[-122.16896, 38.0589], [-122.16836, 38.05972], [-122.16685, 38.05884], [-122.16731, 38.05817], [-122.16896, 38.0589]]]} | Open Access 1 | Willow Glen Park | 27578 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 3.874 | Willow Glen Park | ||
11277 | 11277 | 11276 | {"type": "Polygon", "coordinates": [[[-119.34958, 36.33435], [-119.34956, 36.33439], [-119.34951, 36.3344], [-119.34774, 36.33434], [-119.34772, 36.33358], [-119.34958, 36.33356], [-119.34958, 36.33435]]]} | Open Access 1 | Willow Glen Park | 27579 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 3.667 | Willow Glen Park | ||
11285 | 11285 | 11284 | {"type": "Polygon", "coordinates": [[[-122.29695, 37.81202], [-122.29654, 37.81255], [-122.29589, 37.81221], [-122.29631, 37.8117], [-122.29695, 37.81202]]]} | Open Access 1 | Willow Mini Park | 27580 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.135 | Willow MP | ||
11278 | 11278 | 11277 | {"type": "Polygon", "coordinates": [[[-122.16052, 37.46073], [-122.15992, 37.46148], [-122.15819, 37.46088], [-122.15834, 37.46016], [-122.15964, 37.46033], [-122.15973, 37.46057], [-122.16052, 37.46073]]]} | Open Access 1 | Willow Oaks Park | 27581 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 4.256 | Willow Oaks Park | 1940 | |
11279 | 11279 | 11278 | {"type": "Polygon", "coordinates": [[[-117.93926, 33.82344], [-117.93719, 33.82346], [-117.93718, 33.82182], [-117.93722, 33.82179], [-117.93925, 33.82178], [-117.93926, 33.82344]]]} | Open Access 1 | Willow Park | 27582 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.769 | Willow Park | ||
11280 | 11280 | 11279 | {"type": "Polygon", "coordinates": [[[-118.05437, 33.82517], [-118.0527, 33.82519], [-118.05268, 33.82431], [-118.05431, 33.82429], [-118.05436, 33.82434], [-118.05437, 33.82517]]]} | Open Access 1 | Willow Park | 27583 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 3.721 | Willow Park | ||
11281 | 11281 | 11280 | {"type": "Polygon", "coordinates": [[[-121.51585, 38.68321], [-121.51543, 38.68328], [-121.51541, 38.68332], [-121.51446, 38.68333], [-121.5144, 38.68326], [-121.51447, 38.68322], [-121.51447, 38.68257], [-121.51539, 38.68237], [-121.51546, 38.68238], [-121.51551, 38.68242], [-121.51575, 38.68292], [-121.51585, 38.68321]]]} | Open Access 1 | Willow Park | 27584 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.516 | Willow Park | ||
11282 | 11282 | 11281 | {"type": "Polygon", "coordinates": [[[-122.01104, 37.59599], [-122.01091, 37.59608], [-122.01086, 37.59604], [-122.01077, 37.59603], [-122.01072, 37.59597], [-122.01065, 37.59594], [-122.01057, 37.59593], [-122.01049, 37.59595], [-122.01006, 37.59558], [-122.0101, 37.59553], [-122.01011, 37.59548], [-122.01043, 37.59526], [-122.01068, 37.59549], [-122.0107, 37.59555], [-122.01068, 37.59564], [-122.01072, 37.59571], [-122.01082, 37.59575], [-122.01093, 37.59572], [-122.01084, 37.59581], [-122.01104, 37.59599]]]} | Open Access 1 | Willow Park | 27585 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.845 | Willow Park | 2008 |
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]);