superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY
MNG_AG_TYP >30
- City Agency 7,149
- County Agency 776
- Recreation/Parks District 742
- State Agency 574
- Non Profit - Land Trust 359
- Federal Agency 209
- Open Space District 180
- Water District 161
- Home Owners Association 151
- County Agency - Parks 142
- Community Services District 133
- Non Profit - Conservation 91
- Flood District 42
- Cemetery District 42
- Non Profit - Other 38
- County Agency - Other 27
- School District 24
- Port/Harbor District 19
- Irrigation District 19
- Commercial 9
- Sanitation District 8
- Special District - Other 8
- Joint Powers Authority 6
- Other 4
- Non Profit - Cemetery District 4
- Conservation District 4
- Mitigation Bank 3
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- Transportation Agency 2
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4341 | 4341 | 4340 | {"type": "Polygon", "coordinates": [[[-122.71874, 38.48454], [-122.71869, 38.48464], [-122.71849, 38.48473], [-122.71825, 38.48472], [-122.71701, 38.48418], [-122.71617, 38.48412], [-122.71608, 38.48403], [-122.71597, 38.48385], [-122.71598, 38.48356], [-122.71586, 38.48337], [-122.71585, 38.48324], [-122.71575, 38.48311], [-122.71563, 38.48271], [-122.71578, 38.48242], [-122.71645, 38.48208], [-122.71813, 38.48189], [-122.71837, 38.48227], [-122.71839, 38.48241], [-122.71821, 38.48312], [-122.7183, 38.48367], [-122.71853, 38.48395], [-122.71869, 38.48423], [-122.71869, 38.4844], [-122.71874, 38.48454]]]} | Open Access 1 | Fountain Grove Park | 19021 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 14.017 | Fountain Grove Park | ||
4342 | 4342 | 4341 | {"type": "Polygon", "coordinates": [[[-121.44673, 38.5137], [-121.44636, 38.5137], [-121.44636, 38.51283], [-121.44672, 38.51283], [-121.44673, 38.5137]]]} | Open Access 1 | Fountain Plaza Park | 19022 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 0.771 | Fountain Plaza Park | ||
4343 | 4343 | 4342 | {"type": "MultiPolygon", "coordinates": [[[[-117.97827, 33.70839], [-117.97762, 33.70839], [-117.9776, 33.70616], [-117.97779, 33.70615], [-117.97808, 33.70608], [-117.97825, 33.70606], [-117.97827, 33.70839]]], [[[-117.97832, 33.71112], [-117.97766, 33.71113], [-117.9776, 33.70862], [-117.97826, 33.70862], [-117.97832, 33.71112]]]]} | Open Access 1 | Fountain Valley holding 1 | 19023 | 1111 | Fountain Valley, City of 268 | City 2 | City Agency 2 | http://www.fountainvalley.org/visitors/parks/ | City 2 | 7.977 | Fountain Valley holding 1 | ||
4344 | 4344 | 4343 | {"type": "Polygon", "coordinates": [[[-117.97817, 33.70112], [-117.97751, 33.70113], [-117.97747, 33.69806], [-117.9778, 33.69821], [-117.97791, 33.69824], [-117.97812, 33.69825], [-117.97817, 33.70112]]]} | Open Access 1 | Fountain Valley holding 2 | 19024 | 1111 | Fountain Valley, City of 268 | City 2 | City Agency 2 | http://www.fountainvalley.org/visitors/parks/ | City 2 | 4.938 | Fountain Valley holding 2 | ||
4345 | 4345 | 4344 | {"type": "Polygon", "coordinates": [[[-117.64302, 33.503], [-117.64253, 33.50326], [-117.64249, 33.50326], [-117.64136, 33.5029], [-117.6415, 33.50259], [-117.64157, 33.50229], [-117.64232, 33.50243], [-117.64251, 33.5025], [-117.64268, 33.50259], [-117.64283, 33.50272], [-117.64301, 33.50296], [-117.64302, 33.503]]]} | Open Access 1 | Four Oaks Park | 19025 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 2.498 | Four Oaks Park | ||
4346 | 4346 | 4345 | {"type": "Polygon", "coordinates": [[[-120.87312, 37.52606], [-120.87307, 37.5261], [-120.87207, 37.5261], [-120.87192, 37.52599], [-120.87183, 37.52596], [-120.87175, 37.52596], [-120.87168, 37.52599], [-120.87161, 37.52607], [-120.87161, 37.52545], [-120.8719, 37.52544], [-120.87198, 37.52538], [-120.87199, 37.52531], [-120.87199, 37.52526], [-120.87194, 37.52518], [-120.87194, 37.52491], [-120.87197, 37.52481], [-120.87201, 37.52475], [-120.87213, 37.52464], [-120.87231, 37.52458], [-120.87256, 37.52457], [-120.87266, 37.52459], [-120.8728, 37.52467], [-120.87295, 37.52483], [-120.87306, 37.52554], [-120.87313, 37.52583], [-120.87312, 37.52606]]]} | Open Access 1 | Four Seasons Park | 19026 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 4.273 | Four Seasons Park | ||
4347 | 4347 | 4346 | {"type": "Polygon", "coordinates": [[[-121.46014, 38.54819], [-121.4595, 38.54819], [-121.45946, 38.54749], [-121.4601, 38.54751], [-121.46014, 38.54819]]]} | Open Access 1 | Fourth Avenue Park | 19027 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.075 | Fourth Avenue Park | ||
4348 | 4348 | 4347 | {"type": "Polygon", "coordinates": [[[-119.68461, 36.60967], [-119.68459, 36.61269], [-119.68239, 36.61268], [-119.68238, 36.60964], [-119.68461, 36.60967]]]} | Open Access 1 | Fowler Cemetery | 19028 | 2035 | Fowler Cemetery District 394 | Special District 4 | Cemetery District 11 | Special District 4 | 16.465 | Fowler Cemetery | |||
4350 | 4350 | 4349 | {"type": "Polygon", "coordinates": [[[-121.76559, 37.31506], [-121.76531, 37.31511], [-121.76518, 37.31495], [-121.76504, 37.31485], [-121.76486, 37.31479], [-121.76467, 37.31476], [-121.76447, 37.31478], [-121.76431, 37.31483], [-121.76414, 37.31492], [-121.76403, 37.31502], [-121.76217, 37.31363], [-121.76214, 37.31352], [-121.76158, 37.31311], [-121.7645, 37.31267], [-121.76473, 37.31364], [-121.76477, 37.31367], [-121.76483, 37.31368], [-121.76526, 37.31361], [-121.76559, 37.31506]]]} | Open Access 1 | Fowler Creek Community Park | 19029 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 12.45 | Fowler Creek Community Park | 2004 | |
13237 | 13237 | 13236 | {"type": "MultiPolygon", "coordinates": [[[[-120.84563, 37.61895], [-120.84545, 37.61903], [-120.84473, 37.62007], [-120.84403, 37.62084], [-120.84261, 37.62181], [-120.84163, 37.62226], [-120.84153, 37.62225], [-120.84196, 37.62189], [-120.84148, 37.62063], [-120.84163, 37.61955], [-120.84195, 37.61931], [-120.84163, 37.61895], [-120.8422, 37.61857], [-120.84301, 37.61756], [-120.84275, 37.61605], [-120.84369, 37.61618], [-120.84406, 37.61629], [-120.8438, 37.61774], [-120.8443, 37.61762], [-120.84492, 37.61786], [-120.84529, 37.61767], [-120.84563, 37.61895]]], [[[-120.85093, 37.61827], [-120.84939, 37.61906], [-120.84879, 37.61899], [-120.84792, 37.6187], [-120.84729, 37.61865], [-120.84609, 37.61872], [-120.84574, 37.61743], [-120.84684, 37.61692], [-120.84745, 37.61661], [-120.84873, 37.61675], [-120.84972, 37.6172], [-120.85027, 37.61796], [-120.85068, 37.6181], [-120.85055, 37.61819], [-120.85056, 37.61821], [-120.85093, 37.61827]]]]} | Open Access 1 | Fox Grove Fishing Access | 32167 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 51.662 | Fox Grove FA | ||
4351 | 4351 | 4350 | {"type": "Polygon", "coordinates": [[[-118.3875, 33.98305], [-118.3873, 33.98371], [-118.38674, 33.98418], [-118.38415, 33.98435], [-118.38415, 33.98429], [-118.38422, 33.98402], [-118.38431, 33.98384], [-118.38452, 33.9836], [-118.38478, 33.9834], [-118.38535, 33.98313], [-118.38565, 33.98293], [-118.38592, 33.98269], [-118.38623, 33.98231], [-118.38628, 33.98228], [-118.38634, 33.98228], [-118.38654, 33.98238], [-118.38721, 33.98288], [-118.3875, 33.98305]]]} | Open Access 1 | Fox Hills Park | 19031 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 9.991 | Fox Hills Park | ||
4352 | 4352 | 4351 | {"type": "Polygon", "coordinates": [[[-118.3823, 33.98709], [-118.38228, 33.98732], [-118.38226, 33.98736], [-118.38222, 33.98737], [-118.38191, 33.98738], [-118.3823, 33.98709]]]} | Open Access 1 | Fox Hills Parkette | 19032 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 0.13 | Fox Hills Parkette | ||
4353 | 4353 | 4352 | {"type": "Polygon", "coordinates": [[[-121.66901, 37.14031], [-121.66901, 37.14031], [-121.66891, 37.14072], [-121.66879, 37.1406], [-121.66881, 37.14056], [-121.66865, 37.14041], [-121.66888, 37.14025], [-121.66894, 37.14029], [-121.66901, 37.14031]]]} | Open Access 1 | Fox Hollow Park | 19033 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.201 | Fox Hollow Park | ||
11753 | 11753 | 11752 | {"type": "Polygon", "coordinates": [[[-118.44667, 34.27166], [-118.44626, 34.27196], [-118.44604, 34.27175], [-118.44645, 34.27145], [-118.44667, 34.27166]]]} | Open Access 1 | Fox and Laurel Park | 28361 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.377 | Fox and Laurel Park | ||
14870 | 14870 | 14869 | {"type": "Polygon", "coordinates": [[[-121.97031, 38.31595], [-121.97027, 38.31703], [-121.97025, 38.31815], [-121.97026, 38.31936], [-121.97023, 38.32043], [-121.96886, 38.31754], [-121.96803, 38.31595], [-121.97008, 38.31593], [-121.97031, 38.31595]]]} | Open Access 1 | Foxboro Open Space | 19034 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 11.942 | Foxboro OS | ||
4354 | 4354 | 4353 | {"type": "Polygon", "coordinates": [[[-122.26061, 38.01443], [-122.26017, 38.01496], [-122.25964, 38.01488], [-122.25894, 38.01487], [-122.25863, 38.01494], [-122.2587, 38.01457], [-122.25859, 38.0141], [-122.26007, 38.01404], [-122.26061, 38.01443]]]} | Open Access 1 | Foxboro Park | 19035 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 3.485 | Foxboro Park | ||
4355 | 4355 | 4354 | {"type": "Polygon", "coordinates": [[[-117.71925, 33.56722], [-117.71925, 33.56736], [-117.71915, 33.56784], [-117.71894, 33.5685], [-117.71855, 33.56855], [-117.71852, 33.56887], [-117.71822, 33.56895], [-117.71714, 33.56676], [-117.71752, 33.56632], [-117.71893, 33.56711], [-117.71925, 33.56722]]]} | Open Access 1 | Foxborough Park | 19036 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 7.538 | Foxborough Park | ||
4356 | 4356 | 4355 | {"type": "Polygon", "coordinates": [[[-118.81947, 34.1388], [-118.81885, 34.13894], [-118.81893, 34.13921], [-118.81876, 34.13925], [-118.81839, 34.13851], [-118.81834, 34.13845], [-118.81827, 34.1384], [-118.81813, 34.13838], [-118.81806, 34.13839], [-118.81796, 34.13843], [-118.81782, 34.13843], [-118.81774, 34.13841], [-118.81762, 34.13841], [-118.81751, 34.13844], [-118.81733, 34.13856], [-118.81717, 34.13861], [-118.81698, 34.1386], [-118.81681, 34.13854], [-118.81671, 34.13854], [-118.81665, 34.13856], [-118.81655, 34.13865], [-118.8162, 34.13842], [-118.81601, 34.13821], [-118.81629, 34.13814], [-118.81671, 34.13813], [-118.81876, 34.13823], [-118.81896, 34.13828], [-118.81917, 34.13839], [-118.81927, 34.13847], [-118.81938, 34.13859], [-118.81945, 34.13871], [-118.81947, 34.1388]]]} | Open Access 1 | Foxfield Park | 19037 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 3.509 | Foxfield Park | ||
4357 | 4357 | 4356 | {"type": "Polygon", "coordinates": [[[-122.34472, 40.56826], [-122.34472, 40.56885], [-122.34406, 40.56885], [-122.34407, 40.56832], [-122.34426, 40.56832], [-122.34434, 40.56837], [-122.34442, 40.56839], [-122.34453, 40.56835], [-122.34458, 40.5683], [-122.34459, 40.56825], [-122.34472, 40.56826]]]} | Open Access 1 | Foxtail Park | 19038 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.807 | Foxtail Park | ||
874 | 874 | 873 | {"type": "Polygon", "coordinates": [[[-119.35977, 36.34883], [-119.35927, 36.34978], [-119.3591, 36.35014], [-119.35896, 36.35051], [-119.35885, 36.35089], [-119.35884, 36.34908], [-119.35926, 36.34907], [-119.35929, 36.34912], [-119.35936, 36.34916], [-119.35949, 36.34916], [-119.35958, 36.3491], [-119.35961, 36.34901], [-119.35958, 36.34894], [-119.35948, 36.34887], [-119.35944, 36.34882], [-119.35977, 36.34883]]]} | Open Access 1 | Foxwood Park | 32748 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.62 | Foxwood 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]);