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 2,272
- State Agency 460
- Recreation/Parks District 331
- County Agency 328
- Non Profit - Land Trust 225
- Open Space District 129
- County Agency - Parks 105
- Federal Agency 103
- Water District 86
- Home Owners Association 85
- Non Profit - Conservation 64
- Community Services District 42
- Flood District 35
- Non Profit - Other 20
- Port/Harbor District 12
- School District 12
- County Agency - Other 10
- Cemetery District 8
- Irrigation District 8
- Commercial 8
- Other 5
- Joint Powers Authority 4
- Sanitation District 3
- Special District - Other 3
- Metropolitan Planning Organization 2
- Conservation District 2
- Non Profit - Education 2
- Transportation Agency 2
- Non Profit - Cemetery District 1
- Mitigation Bank 1
- …
MNG_AGENCY >30
- San Diego, City of 286
- California Department of Fish and Wildlife 240
- Los Angeles, City of 172
- California Department of Parks and Recreation 153
- Mountains Recreation and Conservation Authority 97
- East Bay Regional Park District 83
- Los Angeles, County of 78
- San Diego, County of 69
- Long Beach, City of 62
- Los Angeles - Department of Parks and Recreation, County of 56
- Yuba County Water Agency 46
- Midpeninsula Regional Open Space District 39
- United States Fish and Wildlife Service 34
- Torrance, City of 34
- The Nature Conservancy 33
- San Francisco, City and County of 31
- Marin County Open Space District 30
- San Jose, City of 28
- Davis, City of 27
- Fresno Metropolitan Flood Control District 27
- Napa, City of 25
- Santa Cruz, City of 24
- Santa Clarita, City of 24
- Conejo Open Space Conservation Agency 24
- San Ramon, City of 23
- Home Owners Association - Unknown Name 23
- Santa Barbara, County of 22
- University of California 22
- San Jacinto, City of 22
- Glendale, City of 19
- …
ACCESS_TYP 4
- Open Access 3,344
- Restricted Access 543
- No Public Access 369
- Unknown Access 113
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |
11283 | 11283 | 11282 | {"type": "MultiPolygon", "coordinates": [[[[-122.02054, 37.98502], [-122.01997, 37.98528], [-122.01976, 37.9854], [-122.01948, 37.98561], [-122.01903, 37.98604], [-122.01742, 37.98529], [-122.01715, 37.98514], [-122.01703, 37.98505], [-122.01682, 37.98483], [-122.01587, 37.98356], [-122.01718, 37.98295], [-122.0186, 37.98485], [-122.01994, 37.98422], [-122.02054, 37.98502]]], [[[-122.02351, 37.99321], [-122.0232, 37.99333], [-122.02241, 37.99272], [-122.02243, 37.99268], [-122.02224, 37.99248], [-122.02216, 37.99237], [-122.0221, 37.99225], [-122.02204, 37.99207], [-122.02132, 37.98904], [-122.02126, 37.98885], [-122.02119, 37.9887], [-122.02109, 37.98856], [-122.01954, 37.98648], [-122.01938, 37.9863], [-122.01924, 37.98618], [-122.01969, 37.98576], [-122.01993, 37.98557], [-122.02068, 37.98522], [-122.02264, 37.98785], [-122.02208, 37.98863], [-122.02247, 37.98882], [-122.02351, 37.99321]]]]} | Open Access 1 | Willow Pass Community Park | 27586 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 40.406 | Willow Pass Community Park | ||
11284 | 11284 | 11283 | {"type": "Polygon", "coordinates": [[[-117.84322, 34.1438], [-117.84321, 34.14457], [-117.84258, 34.14457], [-117.84258, 34.14384], [-117.84259, 34.14382], [-117.84263, 34.1438], [-117.84294, 34.14381], [-117.84301, 34.14386], [-117.84308, 34.14388], [-117.84317, 34.14385], [-117.84322, 34.1438]]]} | Open Access 1 | Willow Springs Park | 27588 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1.209 | Willow Springs 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 | ||
11286 | 11286 | 11285 | {"type": "Polygon", "coordinates": [[[-118.40895, 34.028], [-118.40843, 34.0283], [-118.40795, 34.02768], [-118.40848, 34.0274], [-118.40895, 34.028]]]} | Open Access 1 | Woodbine Park | 27680 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.165 | Woodbine Park | ||
11287 | 11287 | 11286 | {"type": "Polygon", "coordinates": [[[-121.93328, 36.98717], [-121.93307, 36.98817], [-121.93247, 36.98809], [-121.93247, 36.98801], [-121.93215, 36.98797], [-121.93234, 36.98705], [-121.93328, 36.98717]]]} | Open Access 1 | Willowbrook Park | 27589 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 2.301 | Willowbrook Park | ||
11288 | 11288 | 11287 | {"type": "Polygon", "coordinates": [[[-118.77667, 34.26941], [-118.77558, 34.26918], [-118.77558, 34.26902], [-118.77622, 34.26902], [-118.77633, 34.26914], [-118.77635, 34.26922], [-118.77638, 34.26926], [-118.77645, 34.2693], [-118.77658, 34.26932], [-118.77667, 34.26937], [-118.77667, 34.26941]]]} | Open Access 1 | Willowbrook Park | 27590 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 0.49 | Willowbrook Park | ||
11289 | 11289 | 11288 | {"type": "Polygon", "coordinates": [[[-121.93307, 36.98817], [-121.93305, 36.9883], [-121.93244, 36.98822], [-121.93247, 36.98809], [-121.93307, 36.98817]]]} | Open Access 1 | Willowbrook Park - Soquel Creek Water District | 27591 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 0.197 | Willowbrook Park - Soquel Creek Water District |
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]);