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 8,420
- County Agency 878
- Recreation/Parks District 865
- State Agency 630
- Non Profit - Land Trust 434
- Open Space District 203
- Federal Agency 181
- County Agency - Parks 176
- Water District 160
- Community Services District 159
- Home Owners Association 137
- Non Profit - Conservation 99
- Flood District 77
- Cemetery District 47
- Non Profit - Other 33
- County Agency - Other 28
- Port/Harbor District 28
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 9
- Special District - Other 9
- Joint Powers Authority 5
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Mitigation Bank 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 394
- San Diego, City of 380
- California Department of Fish and Wildlife 298
- San Jose, City of 195
- San Francisco, City and County of 185
- Sacramento, City of 180
- California Department of Parks and Recreation 163
- Mountains Recreation and Conservation Authority 157
- Los Angeles, County of 143
- Ventura, City of 142
- Long Beach, City of 128
- San Diego, County of 113
- Roseville, City of 112
- East Bay Regional Park District 107
- Oakland, City of 96
- Irvine, City of 88
- Fresno, City of 83
- Consumnes Community Services District 79
- Santa Barbara, County of 72
- Torrance, City of 70
- Orange, County of 69
- Stockton, City of 69
- Hayward Area Recreation and Park District 67
- Huntington Beach, City of 66
- Tracy, City of 66
- Modesto, City of 65
- Santa Cruz, City of 63
- Chula Vista, City of 62
- Poway, City of 61
- Santa Rosa, City of 59
- …
ACCESS_TYP 4
- Open Access 10,884
- Restricted Access 891
- No Public Access 637
- Unknown Access 236
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2991 | 2991 | 2990 | {"type": "Polygon", "coordinates": [[[-117.55805, 33.94196], [-117.55713, 33.94196], [-117.55713, 33.94109], [-117.558, 33.94108], [-117.55805, 33.94196]]]} | Open Access 1 | Clark Field | 17386 | 1395 | Norco, City of 111 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/default.asp | City 2 | 1.992 | Clark Field | ||
2992 | 2992 | 2991 | {"type": "Polygon", "coordinates": [[[-117.32935, 33.66648], [-117.32846, 33.66623], [-117.32853, 33.66509], [-117.32905, 33.66522], [-117.32919, 33.66557], [-117.32929, 33.66596], [-117.32935, 33.66648]]]} | Open Access 1 | City Park | 17342 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 2.243 | City Park | ||
2993 | 2993 | 2992 | {"type": "Polygon", "coordinates": [[[-121.94535, 37.34767], [-121.94528, 37.34773], [-121.94498, 37.34787], [-121.94446, 37.34801], [-121.94438, 37.34793], [-121.94414, 37.34745], [-121.94414, 37.34731], [-121.94418, 37.34725], [-121.94426, 37.34721], [-121.94477, 37.34704], [-121.94483, 37.34703], [-121.94492, 37.34705], [-121.94501, 37.34711], [-121.9451, 37.34725], [-121.94501, 37.34727], [-121.945, 37.34722], [-121.94489, 37.34719], [-121.94453, 37.34717], [-121.94447, 37.34719], [-121.94446, 37.34721], [-121.94455, 37.34745], [-121.94489, 37.34748], [-121.94491, 37.3474], [-121.94505, 37.34741], [-121.94516, 37.34735], [-121.94524, 37.34747], [-121.94535, 37.34767]]]} | Open Access 1 | City Plaza Park | 17344 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.542 | City Plaza Park | 1940 | |
2994 | 2994 | 2993 | {"type": "Polygon", "coordinates": [[[-121.75668, 36.91019], [-121.75601, 36.91068], [-121.75548, 36.91022], [-121.75616, 36.90974], [-121.75668, 36.91019]]]} | Open Access 1 | City Plaza Park | 17345 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1.38 | City Plaza Park | ||
2995 | 2995 | 2994 | {"type": "Polygon", "coordinates": [[[-121.83224, 39.72604], [-121.83183, 39.7262], [-121.83154, 39.72575], [-121.83165, 39.72571], [-121.83177, 39.72561], [-121.83192, 39.72555], [-121.83224, 39.72604]]]} | Open Access 1 | City Skate Park | 17346 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 0.566 | City Skate Park | ||
2996 | 2996 | 2995 | {"type": "Polygon", "coordinates": [[[-118.17981, 34.04781], [-118.1799, 34.04804], [-118.17993, 34.04818], [-118.17993, 34.04836], [-118.17989, 34.04857], [-118.17979, 34.0488], [-118.17912, 34.0497], [-118.17896, 34.05001], [-118.17886, 34.05039], [-118.17888, 34.05063], [-118.17891, 34.05082], [-118.17896, 34.05097], [-118.17895, 34.05099], [-118.17799, 34.05084], [-118.17797, 34.05082], [-118.17796, 34.05075], [-118.1774, 34.05068], [-118.17742, 34.05053], [-118.1771, 34.05045], [-118.17716, 34.05027], [-118.17718, 34.05026], [-118.17724, 34.05003], [-118.17736, 34.04927], [-118.17741, 34.0491], [-118.17757, 34.04802], [-118.17755, 34.0479], [-118.17755, 34.04782], [-118.17981, 34.04781]]]} | Open Access 1 | City Terrace Park | 17347 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 15.438 | City Terrace Park | ||
2997 | 2997 | 2996 | {"type": "Polygon", "coordinates": [[[-122.03031, 37.53412], [-122.02993, 37.53459], [-122.02988, 37.5346], [-122.02984, 37.53453], [-122.02977, 37.53448], [-122.02963, 37.53446], [-122.0295, 37.5345], [-122.02943, 37.53457], [-122.02943, 37.5346], [-122.02944, 37.53463], [-122.0294, 37.53463], [-122.02782, 37.53381], [-122.02842, 37.5331], [-122.02931, 37.53356], [-122.0293, 37.53361], [-122.03031, 37.53412]]]} | Open Access 1 | Civic Center Park | 17361 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 4.391 | Civic Ctr. Park | 1973 | |
2998 | 2998 | 2997 | {"type": "Polygon", "coordinates": [[[-118.03908, 34.13832], [-118.03855, 34.1389], [-118.03831, 34.13913], [-118.03699, 34.13828], [-118.03773, 34.13748], [-118.03908, 34.13832]]]} | Open Access 1 | Civic Center Athletic Field | 17348 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 4.348 | Civic Ctr. Athletic Field | ||
2999 | 2999 | 2998 | {"type": "Polygon", "coordinates": [[[-116.2991, 33.67725], [-116.29848, 33.67726], [-116.29819, 33.67781], [-116.29846, 33.67792], [-116.29847, 33.67807], [-116.29667, 33.67807], [-116.29668, 33.67762], [-116.29641, 33.67711], [-116.29615, 33.67709], [-116.29614, 33.67642], [-116.29865, 33.67642], [-116.29897, 33.6765], [-116.2991, 33.67651], [-116.2991, 33.67725]]]} | Open Access 1 | Civic Center Campus | 17349 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 9.694 | Civic Ctr. Campus | ||
3000 | 3000 | 2999 | {"type": "Polygon", "coordinates": [[[-121.66244, 37.12502], [-121.66156, 37.1255], [-121.66085, 37.12469], [-121.66099, 37.12461], [-121.66139, 37.12504], [-121.6616, 37.12494], [-121.66161, 37.12492], [-121.66121, 37.12449], [-121.66172, 37.12421], [-121.66186, 37.12436], [-121.6615, 37.12456], [-121.66174, 37.12484], [-121.66211, 37.12466], [-121.66244, 37.12502]]]} | Open Access 1 | Civic Centre/City Hall | 17371 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1.851 | Civic Centre/City Hall | ||
3001 | 3001 | 3000 | {"type": "Polygon", "coordinates": [[[-121.87868, 37.65679], [-121.87863, 37.65684], [-121.87856, 37.65689], [-121.87801, 37.657], [-121.87784, 37.65705], [-121.87769, 37.65714], [-121.87758, 37.65724], [-121.87752, 37.65721], [-121.87815, 37.65662], [-121.87863, 37.6567], [-121.87867, 37.65673], [-121.87868, 37.65679]]]} | Open Access 1 | Civic Park | 17372 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.563 | Civic Park | ||
3002 | 3002 | 3001 | {"type": "Polygon", "coordinates": [[[-122.06081, 37.90252], [-122.06003, 37.9032], [-122.05986, 37.90343], [-122.05938, 37.90418], [-122.05924, 37.90441], [-122.05918, 37.90453], [-122.05854, 37.90495], [-122.05803, 37.90523], [-122.05799, 37.90527], [-122.05793, 37.90525], [-122.05767, 37.90544], [-122.05749, 37.90536], [-122.05744, 37.90541], [-122.05711, 37.90439], [-122.05725, 37.90421], [-122.05742, 37.90416], [-122.0576, 37.90395], [-122.0577, 37.90364], [-122.05785, 37.90344], [-122.05781, 37.90338], [-122.05779, 37.90332], [-122.05781, 37.90326], [-122.05788, 37.90321], [-122.05788, 37.90318], [-122.05846, 37.90346], [-122.05917, 37.90345], [-122.05867, 37.90282], [-122.05863, 37.90229], [-122.05895, 37.90155], [-122.0605, 37.90153], [-122.06058, 37.90171], [-122.06061, 37.90184], [-122.06063, 37.90219], [-122.06066, 37.9023], [-122.06072, 37.90243], [-122.06081, 37.90252]]]} | Open Access 1 | Civic Park | 17373 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 15.68 | Civic Park | ||
3003 | 3003 | 3002 | {"type": "Polygon", "coordinates": [[[-122.82161, 38.40776], [-122.82136, 38.40824], [-122.82124, 38.4083], [-122.81919, 38.40823], [-122.81897, 38.40667], [-122.82004, 38.40655], [-122.8202, 38.40724], [-122.82161, 38.40776]]]} | Open Access 1 | Clahan Park | 17374 | 1331 | Sebastopol, City of 594 | City 2 | City Agency 2 | http://ci.sebastopol.ca.us/page/city-parks | City 2 | 6.784 | Clahan Park | ||
3004 | 3004 | 3003 | {"type": "Polygon", "coordinates": [[[-122.36347, 40.68196], [-122.36203, 40.68196], [-122.36202, 40.68114], [-122.36346, 40.68114], [-122.36347, 40.68196]]]} | Open Access 1 | Clair Engle Park | 17375 | 1438 | Shasta Lake, City of 321 | City 2 | City Agency 2 | http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 | City 2 | 2.752 | Clair Engle Park | ||
3005 | 3005 | 3004 | {"type": "Polygon", "coordinates": [[[-117.22285, 32.8178], [-117.22241, 32.81788], [-117.22193, 32.81697], [-117.22193, 32.81697], [-117.22285, 32.8178]]]} | Open Access 1 | Clairemont Open Space | 17377 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.56 | Clairemont OS | ||
3006 | 3006 | 3005 | {"type": "Polygon", "coordinates": [[[-122.1561, 38.05304], [-122.15563, 38.05378], [-122.15414, 38.05302], [-122.15466, 38.05235], [-122.1561, 38.05304]]]} | Open Access 1 | Civic Center Park | 17352 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 3.334 | Civic Ctr. Park | ||
3007 | 3007 | 3006 | {"type": "Polygon", "coordinates": [[[-121.13882, 41.1215], [-121.1388, 41.12256], [-121.13852, 41.12256], [-121.13851, 41.1227], [-121.13831, 41.1227], [-121.13798, 41.12334], [-121.13682, 41.12332], [-121.13678, 41.12411], [-121.13849, 41.12478], [-121.13372, 41.12466], [-121.13375, 41.12141], [-121.13483, 41.12142], [-121.1348, 41.12231], [-121.13482, 41.12232], [-121.13606, 41.12234], [-121.13611, 41.12143], [-121.13872, 41.12145], [-121.13882, 41.1215]]]} | Open Access 1 | Clara Beiber Memorial Park | 17378 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 29.384 | Clara Beiber Memorial Park | ||
3008 | 3008 | 3007 | {"type": "MultiPolygon", "coordinates": [[[[-118.18271, 33.96523], [-118.18263, 33.9657], [-118.1824, 33.96568], [-118.18235, 33.96593], [-118.18196, 33.9659], [-118.18191, 33.96622], [-118.18078, 33.96608], [-118.18094, 33.96504], [-118.18271, 33.96523]]], [[[-118.18198, 33.96283], [-118.18166, 33.96494], [-118.18167, 33.96496], [-118.18114, 33.96489], [-118.1813, 33.96386], [-118.18127, 33.96384], [-118.18143, 33.96278], [-118.18198, 33.96283]]]]} | Open Access 1 | Clara Park | 17379 | 1074 | Cudahy, City of 502 | City 2 | City Agency 2 | http://www.cityofcudahy.com/dep/parksandrec.asp | City 2 | 7.025 | Clara Park | ||
3009 | 3009 | 3008 | {"type": "Polygon", "coordinates": [[[-121.70196, 37.99361], [-121.70182, 37.99386], [-121.70141, 37.9937], [-121.701, 37.99352], [-121.7012, 37.99329], [-121.70151, 37.99345], [-121.70196, 37.99361]]]} | Open Access 1 | Claremont Bay Park | 17380 | 1229 | Oakley, City of 251 | City 2 | City Agency 2 | http://www.ci.oakley.ca.us/subpage.cfm?id=441408 | City 2 | 0.577 | Claremont Bay Park | ||
3010 | 3010 | 3009 | {"type": "Polygon", "coordinates": [[[-121.64974, 36.65505], [-121.64922, 36.65654], [-121.64854, 36.65624], [-121.64808, 36.65611], [-121.64804, 36.65608], [-121.64804, 36.65605], [-121.6485, 36.65476], [-121.64974, 36.65505]]]} | Open Access 1 | Claremont Manor Park | 17382 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 4.607 | Claremont Manor 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]);