superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13,512 rows where ACCESS_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 343
- Los Angeles, City of 334
- California Department of Fish and Wildlife 208
- San Jose, City of 164
- San Francisco, City and County of 156
- Sacramento, City of 155
- California Department of Parks and Recreation 139
- Ventura, City of 139
- Los Angeles, County of 112
- Long Beach, City of 110
- Mountains Recreation and Conservation Authority 106
- Roseville, City of 95
- San Diego, County of 86
- Oakland, City of 79
- Irvine, City of 77
- Fresno, City of 72
- Consumnes Community Services District 70
- Huntington Beach, City of 60
- Poway, City of 58
- Orange, County of 58
- Santa Barbara, County of 57
- Stockton, City of 56
- Santa Cruz, City of 54
- Chula Vista, City of 53
- Hayward Area Recreation and Park District 53
- Lake, County of 53
- Davis, City of 51
- East Bay Regional Park District 50
- Tracy, City of 50
- Modesto, City of 50
- …
MNG_AG_TYP 28
- City Agency 7,015
- County Agency 695
- Recreation/Parks District 637
- State Agency 416
- County Agency - Parks 140
- Open Space District 135
- Community Services District 135
- Non Profit - Land Trust 125
- Federal Agency 97
- Water District 68
- Cemetery District 42
- Non Profit - Conservation 38
- Flood District 29
- Non Profit - Other 26
- Port/Harbor District 23
- County Agency - Other 14
- Irrigation District 6
- Special District - Other 6
- Sanitation District 5
- Non Profit - Cemetery District 4
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 9,668 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4327 | 4327 | 4326 | {"type": "Polygon", "coordinates": [[[-122.4138, 38.46446], [-122.41344, 38.465], [-122.41272, 38.46514], [-122.41239, 38.46481], [-122.41285, 38.46468], [-122.41297, 38.46463], [-122.41332, 38.46455], [-122.41347, 38.4645], [-122.41361, 38.46442], [-122.41379, 38.46439], [-122.4138, 38.46446]]]} | Open Access 1 | Rutherford Crossroad | 32278 | 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 | 1.213 | Rutherford Crossroad | ||
4328 | 4328 | 4327 | {"type": "Polygon", "coordinates": [[[-116.25716, 33.86038], [-116.25703, 33.87492], [-116.24863, 33.87494], [-116.24861, 33.87491], [-116.24427, 33.8749], [-116.24426, 33.87495], [-116.24419, 33.87497], [-116.24421, 33.88071], [-116.24243, 33.8807], [-116.23111, 33.87556], [-116.2311, 33.85639], [-116.23118, 33.84581], [-116.23109, 33.84579], [-116.23108, 33.84555], [-116.24326, 33.84564], [-116.24409, 33.84607], [-116.24408, 33.84751], [-116.24624, 33.84748], [-116.24626, 33.84744], [-116.24643, 33.84743], [-116.24644, 33.8473], [-116.24851, 33.84838], [-116.24842, 33.86042], [-116.25716, 33.86038]]]} | Open Access 1 | Sky Valley Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Sky-Valley-ER | 32310 | 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 | 1703.147 | Sky Valley ER | 2007 |
4329 | 4329 | 4328 | {"type": "Polygon", "coordinates": [[[-124.14878, 41.8907], [-124.14743, 41.89072], [-124.14735, 41.89019], [-124.14668, 41.89019], [-124.14664, 41.88979], [-124.14778, 41.88975], [-124.14829, 41.89017], [-124.14878, 41.8907]]]} | Open Access 1 | Smith River Fishing Access | 32311 | 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 | 2.709 | Smith River FA | ||
4330 | 4330 | 4329 | {"type": "Polygon", "coordinates": [[[-122.27644, 41.23646], [-122.27565, 41.23673], [-122.27558, 41.23593], [-122.27633, 41.2358], [-122.27644, 41.23646]]]} | Open Access 1 | Sacramento River -- Prospect Ave. Fishing Access | 32282 | 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 | 1.338 | Sacramento River -- Prospect Ave. FA | ||
4332 | 4332 | 4331 | {"type": "Polygon", "coordinates": [[[-121.95991, 37.53298], [-121.95978, 37.53314], [-121.95949, 37.53297], [-121.95949, 37.53297], [-121.95991, 37.53298]]]} | Open Access 1 | Irvington Plaza | 20274 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 0.081 | Irvington Plaza | 1961 | |
4337 | 4337 | 4336 | {"type": "Polygon", "coordinates": [[[-119.72154, 36.98342], [-119.72124, 36.98436], [-119.72043, 36.98505], [-119.72041, 36.98576], [-119.72081, 36.98612], [-119.71504, 36.98955], [-119.71421, 36.98877], [-119.7146, 36.98852], [-119.71382, 36.98803], [-119.71385, 36.98732], [-119.71406, 36.98693], [-119.71412, 36.9868], [-119.71485, 36.98589], [-119.7156, 36.98567], [-119.71653, 36.98603], [-119.71687, 36.98602], [-119.71851, 36.98504], [-119.7193, 36.98381], [-119.72074, 36.98281], [-119.72122, 36.98286], [-119.72154, 36.98342]]]} | Open Access 1 | San Joaquin Fish Hatchery | 32294 | 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 | 49.566 | San Joaquin Fish Hatchery | ||
4338 | 4338 | 4337 | {"type": "Polygon", "coordinates": [[[-117.90928, 33.93405], [-117.90849, 33.93406], [-117.90847, 33.93403], [-117.90831, 33.93403], [-117.90829, 33.93406], [-117.90816, 33.93406], [-117.90815, 33.93403], [-117.90798, 33.93403], [-117.90796, 33.93407], [-117.90721, 33.93407], [-117.90711, 33.93404], [-117.907, 33.93395], [-117.90697, 33.9339], [-117.90699, 33.93382], [-117.90697, 33.93374], [-117.90701, 33.93366], [-117.90706, 33.93361], [-117.90722, 33.93355], [-117.90791, 33.93354], [-117.90793, 33.93357], [-117.90812, 33.93357], [-117.90813, 33.93354], [-117.90824, 33.93354], [-117.90826, 33.93357], [-117.90842, 33.93357], [-117.90844, 33.93354], [-117.90926, 33.93354], [-117.90928, 33.93405]]]} | Open Access 1 | Founder's Park | 19018 | 1033 | Brea, City of 229 | City 2 | City Agency 2 | http://www.ci.brea.ca.us/index.aspx?NID=439 | City 2 | 2.906 | Founder's Park | ||
4339 | 4339 | 4338 | {"type": "MultiPolygon", "coordinates": [[[[-118.0454, 33.98641], [-118.0454, 33.98717], [-118.04443, 33.98717], [-118.04443, 33.9864], [-118.0454, 33.98641]]], [[[-118.04592, 33.9864], [-118.04592, 33.98717], [-118.04548, 33.98716], [-118.04548, 33.9864], [-118.04592, 33.9864]]], [[[-118.04752, 33.98641], [-118.04752, 33.98724], [-118.04609, 33.98725], [-118.0461, 33.98641], [-118.04752, 33.98641]]]]} | Open Access 1 | Founders Memorial Park | 19019 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 5.779 | Founders Memorial Park | ||
4340 | 4340 | 4339 | {"type": "Polygon", "coordinates": [[[-117.62694, 33.96631], [-117.62663, 33.96657], [-117.62629, 33.96678], [-117.62593, 33.96694], [-117.62549, 33.96707], [-117.62519, 33.96713], [-117.62483, 33.96716], [-117.62364, 33.96717], [-117.62358, 33.96712], [-117.62357, 33.96627], [-117.62355, 33.96606], [-117.62357, 33.96602], [-117.62366, 33.96593], [-117.6242, 33.96592], [-117.62421, 33.96611], [-117.62479, 33.96611], [-117.62481, 33.96633], [-117.6253, 33.96633], [-117.62531, 33.96608], [-117.62544, 33.96608], [-117.62555, 33.96605], [-117.62582, 33.96589], [-117.62593, 33.96586], [-117.62606, 33.96584], [-117.6261, 33.96579], [-117.62619, 33.96577], [-117.62694, 33.96631]]]} | Open Access 1 | Founders Park | http://www.cityofchino.org/government-services/community-services/parks/founders-park | 19020 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 7.992 | Founders Park | |
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 | |||
4349 | 4349 | 4348 | {"type": "Polygon", "coordinates": [[[-117.12293, 32.70992], [-117.12268, 32.70992], [-117.12268, 32.70958], [-117.12293, 32.70958], [-117.12293, 32.70992]]]} | Open Access 1 | J Street Mini Park | 20289 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.219 | J Street MP | ||
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 | |
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 |
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]);