superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by LAYER
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 7,441
- County Agency 1,102
- Recreation/Parks District 1,091
- State Agency 872
- Non Profit - Land Trust 511
- Federal Agency 254
- Open Space District 241
- County Agency - Parks 218
- Home Owners Association 200
- Community Services District 193
- Water District 187
- Non Profit - Conservation 119
- Flood District 94
- Cemetery District 61
- Non Profit - Other 44
- School District 38
- County Agency - Other 32
- Port/Harbor District 32
- Irrigation District 24
- Special District - Other 15
- Commercial 14
- Sanitation District 9
- Joint Powers Authority 8
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- California Department of Fish and Wildlife 394
- San Diego, City of 366
- Los Angeles, City of 362
- California Department of Parks and Recreation 276
- Mountains Recreation and Conservation Authority 181
- Los Angeles, County of 171
- San Jose, City of 170
- San Francisco, City and County of 158
- Sacramento, City of 158
- Ventura, City of 139
- East Bay Regional Park District 132
- San Diego, County of 120
- Long Beach, City of 118
- Roseville, City of 102
- Consumnes Community Services District 92
- Santa Barbara, County of 89
- Hayward Area Recreation and Park District 84
- Orange, County of 82
- Oakland, City of 79
- Irvine, City of 78
- Fresno, City of 75
- Valley-Wide Recreation and Park District 67
- United States National Park Service 65
- Los Angeles - Department of Parks and Recreation, County of 63
- Poway, City of 61
- Torrance, City of 61
- Huntington Beach, City of 60
- Stockton, City of 60
- Santa Cruz, City of 58
- Lake, County of 56
- …
ACCESS_TYP 4
- Open Access 10,829
- Restricted Access 1,020
- No Public Access 735
- Unknown Access 250
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4331 | 4331 | 4330 | {"type": "Polygon", "coordinates": [[[-117.00123, 32.56466], [-117.00121, 32.56728], [-117.00108, 32.56728], [-117.00106, 32.56732], [-117.00068, 32.56736], [-117.00055, 32.56745], [-117.00053, 32.56778], [-117.00042, 32.56807], [-116.99905, 32.56804], [-116.99908, 32.56463], [-117.00123, 32.56466]]]} | No Public Access 3 | Otay Mesa Open Space | 32281 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 17.649 | Otay Mesa OS | ||
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 | |
4335 | 4335 | 4334 | {"type": "Polygon", "coordinates": [[[-117.00987, 32.55768], [-117.00557, 32.5576], [-117.00555, 32.56025], [-117.00128, 32.56018], [-117.00126, 32.55751], [-116.99834, 32.55745], [-116.99769, 32.55743], [-116.99699, 32.55743], [-116.99699, 32.55385], [-116.99614, 32.55382], [-116.99588, 32.55353], [-116.99536, 32.55264], [-116.99513, 32.55248], [-116.99481, 32.55243], [-116.99449, 32.55257], [-116.99356, 32.55323], [-116.993, 32.55322], [-116.99287, 32.55313], [-116.99284, 32.55268], [-116.99337, 32.55212], [-116.99346, 32.55187], [-116.99337, 32.55162], [-116.99317, 32.55135], [-116.9927, 32.55115], [-116.99269, 32.55005], [-116.99912, 32.55022], [-116.99914, 32.55327], [-116.99985, 32.5533], [-116.99987, 32.55391], [-117.00986, 32.55413], [-117.00985, 32.55619], [-117.00987, 32.55768]]]} | No Public Access 3 | Otay Mitigation Site | 32285 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 200.109 | Otay Mitigation Site | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);