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 7,789
- County Agency 832
- Recreation/Parks District 804
- State Agency 607
- Non Profit - Land Trust 408
- Open Space District 191
- Federal Agency 174
- County Agency - Parks 170
- Water District 154
- Community Services District 149
- Home Owners Association 131
- Non Profit - Conservation 96
- Flood District 70
- Cemetery District 46
- Non Profit - Other 33
- County Agency - Other 27
- Port/Harbor District 27
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 8
- Special District - Other 6
- Other 5
- Non Profit - Cemetery District 5
- Joint Powers Authority 4
- Mitigation Bank 4
- Conservation District 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 373
- San Diego, City of 368
- California Department of Fish and Wildlife 295
- San Jose, City of 183
- San Francisco, City and County of 167
- Sacramento, City of 166
- California Department of Parks and Recreation 162
- Mountains Recreation and Conservation Authority 145
- Ventura, City of 140
- Los Angeles, County of 136
- Long Beach, City of 119
- San Diego, County of 109
- Roseville, City of 104
- East Bay Regional Park District 102
- Oakland, City of 83
- Irvine, City of 81
- Fresno, City of 80
- Consumnes Community Services District 76
- Santa Barbara, County of 70
- Orange, County of 67
- Torrance, City of 65
- Huntington Beach, City of 61
- Poway, City of 61
- Hayward Area Recreation and Park District 61
- Stockton, City of 61
- Santa Cruz, City of 59
- Modesto, City of 58
- Chula Vista, City of 57
- Los Angeles - Department of Parks and Recreation, County of 57
- Tracy, City of 57
- …
ACCESS_TYP 4
- Open Access 10,112
- Restricted Access 848
- No Public Access 610
- Unknown Access 225
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3844 | 3844 | 3843 | {"type": "Polygon", "coordinates": [[[-122.11882, 37.69374], [-122.1188, 37.69506], [-122.11701, 37.69506], [-122.117, 37.6955], [-122.11632, 37.69548], [-122.11631, 37.6952], [-122.11528, 37.69519], [-122.11529, 37.6942], [-122.11632, 37.69421], [-122.11633, 37.69398], [-122.11716, 37.69399], [-122.11718, 37.69373], [-122.11882, 37.69374]]]} | Open Access 1 | Edendale Park | 18430 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 10.685 | Edendale Park | ||
3845 | 3845 | 3844 | {"type": "MultiPolygon", "coordinates": [[[[-123.51798, 38.7595], [-123.51777, 38.75999], [-123.51747, 38.76173], [-123.51724, 38.76379], [-123.517, 38.76481], [-123.5147, 38.7628], [-123.51458, 38.76223], [-123.51383, 38.76176], [-123.51422, 38.76094], [-123.51466, 38.76054], [-123.51426, 38.76014], [-123.51464, 38.75949], [-123.51546, 38.75936], [-123.51537, 38.75886], [-123.51594, 38.75748], [-123.51587, 38.75739], [-123.51588, 38.75718], [-123.51595, 38.75706], [-123.51595, 38.75661], [-123.51613, 38.75754], [-123.5162, 38.75775], [-123.51634, 38.75802], [-123.51687, 38.75867], [-123.5173, 38.75905], [-123.51798, 38.7595]]], [[[-123.5159, 38.75641], [-123.5158, 38.75602], [-123.51568, 38.75584], [-123.51553, 38.75569], [-123.51552, 38.7554], [-123.51572, 38.75534], [-123.5159, 38.75641]]], [[[-123.53373, 38.76863], [-123.53304, 38.7685], [-123.53278, 38.76806], [-123.53176, 38.76687], [-123.53125, 38.76681], [-123.5298, 38.76521], [-123.52981, 38.7649], [-123.53, 38.76456], [-123.52888, 38.76395], [-123.52854, 38.76395], [-123.52816, 38.7637], [-123.52777, 38.76328], [-123.52718, 38.76296], [-123.5268, 38.76258], [-123.52597, 38.76196], [-123.52541, 38.76123], [-123.52518, 38.76096], [-123.52359, 38.76001], [-123.52273, 38.75955], [-123.52194, 38.75881], [-123.52116, 38.75828], [-123.52033, 38.75798], [-123.51937, 38.75801], [-123.51883, 38.7583], [-123.51823, 38.75894], [-123.51804, 38.75936], [-123.51742, 38.75895], [-123.51701, 38.75858], [-123.5165, 38.75795], [-123.51637, 38.75771], [-123.5163, 38.75751], [-123.51587, 38.75524], [-123.51813, 38.75639], [-123.52225, 38.75787], [-123.52301, 38.75834], [-123.52387, 38.75916], [-123.52716, 38.75726], [-123.52723, 38.75729], [-123.52791, 38.75735], [-123.52818, 38.75732], [-123.5282, 38.75749], [-123.52893, 38.7578], [-123.52971, 38.75809], [-123.52966, 38.75821], [-123.53001, 38.75845], [-123.53025, 38.75845], [-123.53054, 38.75838], [-123.53055, 38.75858], [-123.53073, 38.75863], [-123.53063, 38.75878], [-123.53109, 38.75902], [-123.53166, 38.75904], [-123.53195, 38.75889], [-123.53207, 38.75901], [-123.53208, 38.75912], [-123.53231, 38.75919], [-123.53252, 38.75951], [-123.53235, 38.75947], [-123.53214, 38.75952], [-123.53196, 38.75947], [-123.5314, 38.75951], [-123.53108, 38.75975], [-123.5309, 38.76118], [-123.53091, 38.76311], [-123.53143, 38.76484], [-123.53254, 38.76689], [-123.53367, 38.76845], [-123.53373, 38.76863]]]]} | Open Access 1 | Gualala Point | 19560 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 162.361 | Gualala Point | ||
3846 | 3846 | 3845 | {"type": "Polygon", "coordinates": [[[-121.823, 37.2655], [-121.82273, 37.26566], [-121.82189, 37.26626], [-121.82172, 37.26633], [-121.82156, 37.26635], [-121.82143, 37.26634], [-121.82131, 37.2663], [-121.82003, 37.26559], [-121.8195, 37.26514], [-121.81947, 37.26509], [-121.81945, 37.26503], [-121.81942, 37.26502], [-121.81945, 37.26287], [-121.82135, 37.26289], [-121.82136, 37.26338], [-121.82176, 37.26351], [-121.82177, 37.26403], [-121.82156, 37.26429], [-121.82156, 37.26434], [-121.823, 37.2655]]]} | Open Access 1 | Edenvale Garden | 18431 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 18.981 | Edenvale Garden | 1991 | |
3847 | 3847 | 3846 | {"type": "Polygon", "coordinates": [[[-116.97601, 33.97243], [-116.97466, 33.97406], [-116.97417, 33.97481], [-116.97355, 33.97529], [-116.97366, 33.97499], [-116.97373, 33.97474], [-116.97393, 33.97458], [-116.9744, 33.97369], [-116.97557, 33.97245], [-116.97558, 33.97244], [-116.97601, 33.97243]]]} | Open Access 1 | Edgar Canyon Nature Park | 18432 | 2205 | Beaumont-Cherry Valley Recreation and Park District 636 | Special District 4 | Recreation/Parks District 4 | http://www.bcvparks.com/ | Special District 4 | 3.12 | Edgar Canyon Nature Park | ||
3848 | 3848 | 3847 | {"type": "Polygon", "coordinates": [[[-118.02716, 33.77607], [-118.02715, 33.77847], [-118.02713, 33.77851], [-118.02649, 33.77851], [-118.02651, 33.77704], [-118.02563, 33.77703], [-118.02407, 33.77705], [-118.02407, 33.77607], [-118.02716, 33.77607]]]} | Open Access 1 | Edgar Park | 18433 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 10.037 | Edgar Park | ||
3849 | 3849 | 3848 | {"type": "Polygon", "coordinates": [[[-121.43046, 37.7577], [-121.42818, 37.75771], [-121.42817, 37.75587], [-121.42952, 37.75575], [-121.42952, 37.75433], [-121.43045, 37.75433], [-121.43046, 37.7577]]]} | Open Access 1 | El Pescadero Park | 18528 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 13.777 | El Pescadero Park | ||
3850 | 3850 | 3849 | {"type": "MultiPolygon", "coordinates": [[[[-121.25745, 38.71827], [-121.25706, 38.71836], [-121.25661, 38.71824], [-121.25604, 38.71835], [-121.25531, 38.7183], [-121.25481, 38.7183], [-121.25457, 38.71785], [-121.25377, 38.71788], [-121.25328, 38.7182], [-121.25312, 38.71819], [-121.25286, 38.71813], [-121.25264, 38.71812], [-121.25257, 38.71784], [-121.25237, 38.71788], [-121.25149, 38.71703], [-121.25155, 38.71699], [-121.25163, 38.71645], [-121.25132, 38.71635], [-121.25131, 38.71616], [-121.2509, 38.71615], [-121.25093, 38.71604], [-121.25088, 38.71596], [-121.25078, 38.71592], [-121.25061, 38.71591], [-121.25061, 38.71554], [-121.25014, 38.71543], [-121.25015, 38.71537], [-121.24977, 38.71477], [-121.24969, 38.71478], [-121.24951, 38.71459], [-121.24941, 38.71442], [-121.24946, 38.71417], [-121.24989, 38.714], [-121.24981, 38.71437], [-121.25022, 38.71465], [-121.25022, 38.71501], [-121.25049, 38.71539], [-121.25132, 38.71542], [-121.25177, 38.71557], [-121.25215, 38.71577], [-121.2526, 38.71618], [-121.25276, 38.71637], [-121.25277, 38.71658], [-121.25261, 38.71688], [-121.25297, 38.71734], [-121.25333, 38.71738], [-121.25374, 38.71722], [-121.25376, 38.71752], [-121.25438, 38.71751], [-121.25463, 38.71726], [-121.2548, 38.71733], [-121.25492, 38.71737], [-121.2551, 38.7178], [-121.25531, 38.7178], [-121.25609, 38.71779], [-121.25611, 38.71739], [-121.25646, 38.71738], [-121.25695, 38.7173], [-121.25697, 38.71737], [-121.25722, 38.71769], [-121.2574, 38.71774], [-121.25738, 38.71787], [-121.25739, 38.71803], [-121.25745, 38.71827]]], [[[-121.26254, 38.71961], [-121.26116, 38.71952], [-121.26128, 38.71921], [-121.26101, 38.71881], [-121.26072, 38.71861], [-121.26024, 38.71858], [-121.26019, 38.71897], [-121.25863, 38.71886], [-121.25863, 38.71854], [-121.25823, 38.71839], [-121.25818, 38.71824], [-121.25771, 38.7182], [-121.25763, 38.71822], [-121.25758, 38.71806], [-121.25757, 38.71792], [-121.25758, 38.71779], [-121.25762, 38.71768], [-121.25763, 38.71764], [-121.25811, 38.71778], [-121.25821, 38.71765], [-121.25843, 38.7178], [-121.25868, 38.71794], [-121.25895, 38.71806], [-121.25924, 38.71814], [-121.25971, 38.71822], [-121.26008, 38.71788], [-121.2606, 38.71806], [-121.26089, 38.71821], [-121.26131, 38.71847], [-121.26162, 38.71861], [-121.26184, 38.71867], [-121.26209, 38.71872], [-121.26253, 38.71873], [-121.26254, 38.71961]]]]} | Open Access 1 | Edgecliff/Cripple Creek Open Space | 18434 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 24.526 | Edgecliff/Cripple Creek OS | ||
3851 | 3851 | 3850 | {"type": "Polygon", "coordinates": [[[-122.4606, 37.74202], [-122.46018, 37.74226], [-122.4602, 37.74231], [-122.4599, 37.74259], [-122.45924, 37.74241], [-122.45915, 37.74237], [-122.45931, 37.74181], [-122.45932, 37.74173], [-122.4593, 37.74167], [-122.45933, 37.7414], [-122.4596, 37.74141], [-122.45972, 37.74147], [-122.45971, 37.74151], [-122.45981, 37.74163], [-122.45974, 37.74167], [-122.45974, 37.74169], [-122.46007, 37.74186], [-122.46026, 37.74166], [-122.4606, 37.74202]]]} | Open Access 1 | Edgehill Mountain | 18435 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.347 | Edgehill Mtn. | ||
3852 | 3852 | 3851 | {"type": "Polygon", "coordinates": [[[-122.48783, 37.65343], [-122.48751, 37.65378], [-122.48743, 37.65376], [-122.48732, 37.65381], [-122.48696, 37.65377], [-122.48679, 37.65385], [-122.48662, 37.65364], [-122.4866, 37.65358], [-122.48666, 37.65328], [-122.48738, 37.65336], [-122.48762, 37.6533], [-122.48783, 37.65343]]]} | Open Access 1 | Edgemar Park | 18436 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1.18 | Edgemar Park | ||
3853 | 3853 | 3852 | {"type": "Polygon", "coordinates": [[[-122.27653, 37.54926], [-122.27598, 37.5498], [-122.27574, 37.54998], [-122.27545, 37.55013], [-122.27559, 37.55037], [-122.27533, 37.55047], [-122.27506, 37.55054], [-122.27479, 37.55059], [-122.27475, 37.55059], [-122.27471, 37.55057], [-122.27468, 37.55038], [-122.27467, 37.55013], [-122.2747, 37.5497], [-122.27469, 37.54944], [-122.27465, 37.54912], [-122.27457, 37.54884], [-122.27538, 37.54842], [-122.27555, 37.54861], [-122.27572, 37.54875], [-122.27653, 37.54926]]]} | Open Access 1 | Edgewater Park | 18437 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 5.907 | Edgewater Park | 1960 | |
3854 | 3854 | 3853 | {"type": "Polygon", "coordinates": [[[-121.55066, 39.11897], [-121.54817, 39.11898], [-121.54768, 39.11899], [-121.54764, 39.11781], [-121.55009, 39.11773], [-121.55015, 39.11837], [-121.5506, 39.11836], [-121.55065, 39.11874], [-121.55066, 39.11897]]]} | Open Access 1 | Edgewater Park Site | 18438 | 333 | Yuba, County of 544 | County 3 | County Agency 3 | http://www.co.yuba.ca.us/departments/community%20development/public%20works/parks/default.aspx | County 3 | 7.787 | Edgewater Park Site | ||
3855 | 3855 | 3854 | {"type": "Polygon", "coordinates": [[[-122.46028, 37.70064], [-122.46009, 37.70065], [-122.45961, 37.70111], [-122.45957, 37.70032], [-122.46026, 37.70029], [-122.46028, 37.70064]]]} | Open Access 1 | Edgewood Park | 18440 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.854 | Edgewood Park | ||
3856 | 3856 | 3855 | {"type": "Polygon", "coordinates": [[[-122.56127, 37.90272], [-122.56111, 37.90294], [-122.56104, 37.90321], [-122.56096, 37.90329], [-122.56054, 37.90341], [-122.56012, 37.90317], [-122.55964, 37.90307], [-122.55927, 37.90288], [-122.559, 37.9024], [-122.55868, 37.90221], [-122.55918, 37.90164], [-122.55976, 37.90179], [-122.55993, 37.90166], [-122.5605, 37.90226], [-122.56127, 37.90272]]]} | Open Access 1 | Edgewood Park | 18441 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 5.984 | Edgewood Park | ||
3857 | 3857 | 3856 | {"type": "Polygon", "coordinates": [[[-122.48438, 37.66358], [-122.4839, 37.66357], [-122.48388, 37.66343], [-122.48379, 37.6633], [-122.48372, 37.66324], [-122.4836, 37.66318], [-122.48347, 37.66314], [-122.48336, 37.66314], [-122.48262, 37.66222], [-122.48276, 37.66179], [-122.48259, 37.66157], [-122.48264, 37.66105], [-122.48212, 37.6607], [-122.4824, 37.66037], [-122.48259, 37.65977], [-122.48304, 37.66045], [-122.48352, 37.66124], [-122.48359, 37.66156], [-122.4837, 37.66191], [-122.48438, 37.66358]]]} | Open Access 1 | Edgewood Park | 18442 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 7.397 | Edgewood Park | 2000 | |
3858 | 3858 | 3857 | {"type": "Polygon", "coordinates": [[[-121.07928, 38.68615], [-121.07845, 38.68653], [-121.07832, 38.68668], [-121.07853, 38.68683], [-121.07853, 38.68689], [-121.07838, 38.68697], [-121.07784, 38.68651], [-121.07652, 38.68617], [-121.07596, 38.68613], [-121.07538, 38.68614], [-121.0746, 38.68624], [-121.07391, 38.68547], [-121.07383, 38.68545], [-121.07385, 38.68538], [-121.07382, 38.68531], [-121.07378, 38.68528], [-121.07385, 38.68519], [-121.07372, 38.68482], [-121.07338, 38.68436], [-121.076, 38.68331], [-121.07628, 38.68371], [-121.07675, 38.68419], [-121.07723, 38.68452], [-121.07795, 38.68496], [-121.07845, 38.68531], [-121.07902, 38.68582], [-121.07928, 38.68615]]]} | Open Access 1 | EDH Community Park | 18443 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 25.02 | EDH Community Park | ||
3859 | 3859 | 3858 | {"type": "Polygon", "coordinates": [[[-117.89577, 33.85049], [-117.8937, 33.85049], [-117.89367, 33.84909], [-117.89575, 33.84909], [-117.89577, 33.85049]]]} | Open Access 1 | Edison Park | 18445 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 7.387 | Edison Park | ||
3860 | 3860 | 3859 | {"type": "Polygon", "coordinates": [[[-118.09665, 33.77734], [-118.09664, 33.77835], [-118.09659, 33.77908], [-118.09606, 33.779], [-118.09566, 33.77902], [-118.09569, 33.77668], [-118.09574, 33.77489], [-118.09606, 33.77483], [-118.09664, 33.77485], [-118.09662, 33.77729], [-118.09665, 33.77734]]]} | Open Access 1 | Edison Park | 18446 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 9.949 | Edison Park | ||
3861 | 3861 | 3860 | {"type": "Polygon", "coordinates": [[[-118.12837, 34.0455], [-118.12829, 34.04553], [-118.12817, 34.04553], [-118.12743, 34.04535], [-118.1272, 34.04532], [-118.11801, 34.04309], [-118.11799, 34.04277], [-118.11801, 34.04266], [-118.12629, 34.04467], [-118.12828, 34.0447], [-118.12838, 34.04547], [-118.12837, 34.0455]]]} | Open Access 1 | Edison Trails Park | 18447 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 12.367 | Edison Trails Park | ||
3862 | 3862 | 3861 | {"type": "Polygon", "coordinates": [[[-121.94347, 37.27888], [-121.94328, 37.27905], [-121.94231, 37.27968], [-121.94207, 37.27977], [-121.94181, 37.2798], [-121.94163, 37.27979], [-121.94147, 37.27974], [-121.94131, 37.27967], [-121.94112, 37.27953], [-121.94097, 37.27935], [-121.94079, 37.27887], [-121.94347, 37.27888]]]} | Open Access 1 | Edith Morley Park | 18448 | 1043 | Campbell, City of 442 | City 2 | City Agency 2 | http://www.ci.campbell.ca.us/226/Recreation-Parks | City 2 | 4.003 | Edith Morley Park | ||
3863 | 3863 | 3862 | {"type": "Polygon", "coordinates": [[[-118.38718, 33.85905], [-118.38653, 33.85914], [-118.38641, 33.85852], [-118.38712, 33.85872], [-118.38718, 33.85905]]]} | Open Access 1 | Edith Rodaway Friendship Park | 18449 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 0.805 | Edith Rodaway Friendship 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]);