superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 6,023
- County Agency 628
- Recreation/Parks District 589
- State Agency 371
- Non Profit - Land Trust 224
- Federal Agency 155
- Community Services District 128
- Home Owners Association 100
- Open Space District 86
- County Agency - Parks 85
- Water District 68
- Flood District 44
- Cemetery District 43
- Non Profit - Conservation 41
- School District 25
- Non Profit - Other 21
- County Agency - Other 17
- Port/Harbor District 14
- Irrigation District 12
- Special District - Other 10
- Commercial 5
- Sanitation District 5
- Joint Powers Authority 4
- Transportation Agency 3
- Non Profit - Cemetery District 2
- Mitigation Bank 2
- Conservation District 2
- Airport District 1
- Other 1
- Non Profit - Education 1
- …
MNG_AGENCY >30
- Los Angeles, City of 208
- San Jose, City of 182
- San Francisco, City and County of 169
- Sacramento, City of 150
- California Department of Fish and Wildlife 144
- San Diego, City of 120
- California Department of Parks and Recreation 119
- Oakland, City of 92
- Los Angeles, County of 77
- Irvine, City of 70
- Mountains Recreation and Conservation Authority 67
- Modesto, City of 64
- Consumnes Community Services District 62
- Valley-Wide Recreation and Park District 60
- Santa Rosa, City of 59
- Long Beach, City of 59
- Tracy, City of 56
- Hayward Area Recreation and Park District 55
- Stockton, City of 54
- Orange, County of 53
- Butte, County of 52
- Poway, City of 50
- Roseville, City of 49
- Huntington Beach, City of 48
- Santa Barbara, County of 47
- United States National Park Service 47
- Fresno, City of 46
- East Bay Regional Park District 45
- Lake, County of 45
- Brentwood, City of 44
- …
ACCESS_TYP 4
- Open Access 7,863
- Restricted Access 463
- No Public Access 297
- Unknown Access 88
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8711 | 8711 | 8710 | {"type": "Polygon", "coordinates": [[[-122.69381, 38.48999], [-122.69379, 38.49004], [-122.69375, 38.49006], [-122.69343, 38.49011], [-122.69317, 38.49012], [-122.69239, 38.49008], [-122.69236, 38.49005], [-122.69238, 38.4897], [-122.69237, 38.48951], [-122.69231, 38.48939], [-122.69218, 38.48923], [-122.69204, 38.48914], [-122.69189, 38.48908], [-122.69146, 38.489], [-122.69126, 38.48894], [-122.69096, 38.48877], [-122.69078, 38.48865], [-122.69125, 38.48827], [-122.69152, 38.48843], [-122.69216, 38.48858], [-122.69245, 38.48857], [-122.69273, 38.48852], [-122.69314, 38.48835], [-122.69317, 38.48824], [-122.69296, 38.48806], [-122.69306, 38.48799], [-122.69316, 38.48795], [-122.69332, 38.48792], [-122.69337, 38.48793], [-122.6934, 38.48797], [-122.69343, 38.48816], [-122.6935, 38.48892], [-122.69361, 38.48938], [-122.69369, 38.48967], [-122.69381, 38.48999]]]} | Open Access 1 | Rincon Ridge Park | 24370 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 7.265 | Rincon Ridge Park | ||
8710 | 8710 | 8709 | {"type": "Polygon", "coordinates": [[[-122.03122, 36.97381], [-122.03122, 36.97381], [-122.03111, 36.97409], [-122.03105, 36.97384], [-122.03122, 36.97381]]]} | Open Access 1 | Rincon Park | 24369 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.055 | Rincon Park | ||
8709 | 8709 | 8708 | {"type": "Polygon", "coordinates": [[[-119.49113, 34.38394], [-119.49018, 34.38353], [-119.48938, 34.38524], [-119.48884, 34.38506], [-119.48848, 34.3849], [-119.48734, 34.38447], [-119.48698, 34.3843], [-119.48681, 34.38419], [-119.4865, 34.38393], [-119.48637, 34.38378], [-119.48607, 34.38336], [-119.48592, 34.38322], [-119.48576, 34.38309], [-119.48558, 34.38297], [-119.48538, 34.38288], [-119.48517, 34.38281], [-119.48484, 34.38275], [-119.48442, 34.38253], [-119.48423, 34.38229], [-119.4842, 34.3821], [-119.48407, 34.38199], [-119.4838, 34.38212], [-119.48369, 34.38198], [-119.48347, 34.38155], [-119.48354, 34.38146], [-119.48428, 34.38172], [-119.48505, 34.38194], [-119.48533, 34.38197], [-119.48544, 34.38192], [-119.48544, 34.38191], [-119.48525, 34.38189], [-119.48507, 34.38182], [-119.48461, 34.38158], [-119.48317, 34.38072], [-119.48295, 34.38057], [-119.48265, 34.38032], [-119.48257, 34.37997], [-119.48283, 34.37978], [-119.48215, 34.37935], [-119.48075, 34.37775], [-119.4785, 34.37584], [-119.47796, 34.37557], [-119.47746, 34.37548], [-119.47737, 34.37524], [-119.47812, 34.37527], [-119.47861, 34.37543], [-119.47887, 34.37564], [-119.47904, 34.37573], [-119.47969, 34.37544], [-119.48031, 34.37629], [-119.48123, 34.37728], [-119.48177, 34.37797], [-119.48233, 34.37854], [-119.48323, 34.37952], [-119.48285, 34.37977], [-119.48285, 34.37979], [-119.48341, 34.38015], [-119.4847, 34.38087], [-119.48556, 34.38134], [-119.48575, 34.3814], [-119.48586, 34.38165], [-119.48688, 34.38192], [-119.48717, 34.38203], [-119.48886, 34.3828], [-119.49112, 34.38376], [-119.49113, 34.38394]]]} | Open Access 1 | Rincon Beach Park | 24367 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 44.056 | Rincon Beach Park | ||
8708 | 8708 | 8707 | {"type": "Polygon", "coordinates": [[[-117.54466, 33.84898], [-117.54465, 33.84947], [-117.54193, 33.84944], [-117.54195, 33.84784], [-117.54276, 33.84822], [-117.54466, 33.84898]]]} | Open Access 1 | Rimpau Park | 24366 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 7.089 | Rimpau Park | ||
8707 | 8707 | 8706 | {"type": "Polygon", "coordinates": [[[-117.68051, 33.64438], [-117.67993, 33.64591], [-117.67977, 33.64586], [-117.67956, 33.64576], [-117.67878, 33.6453], [-117.67856, 33.6452], [-117.67837, 33.64514], [-117.67799, 33.64511], [-117.67797, 33.64509], [-117.67787, 33.64457], [-117.67955, 33.6437], [-117.68051, 33.64438]]]} | Open Access 1 | Rimgate Park | 24364 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 8.429 | Rimgate Park | ||
8706 | 8706 | 8705 | {"type": "Polygon", "coordinates": [[[-123.01441, 38.79804], [-123.01401, 38.79805], [-123.01398, 38.79765], [-123.01439, 38.79761], [-123.01441, 38.79804]]]} | Open Access 1 | Tarman Park | 26190 | 1059 | Cloverdale, City of 404 | City 2 | City Agency 2 | http://www.cloverdale.net/index.aspx?nid=152 | City 2 | 0.409 | Tarman Park | ||
8705 | 8705 | 8704 | {"type": "Polygon", "coordinates": [[[-117.04833, 32.60032], [-117.04833, 32.60221], [-117.04812, 32.60226], [-117.04778, 32.60325], [-117.04725, 32.60358], [-117.04733, 32.6038], [-117.04584, 32.60421], [-117.04555, 32.60345], [-117.04662, 32.60266], [-117.04703, 32.6022], [-117.04704, 32.60041], [-117.04833, 32.60032]]]} | Open Access 1 | Rienstra Sports Complex | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rienstra-sports-complex | 24363 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 13.489 | Rienstra Sports Complex | |
8704 | 8704 | 8703 | {"type": "MultiPolygon", "coordinates": [[[[-118.37159, 33.76721], [-118.37139, 33.76744], [-118.37081, 33.76795], [-118.37054, 33.76809], [-118.37028, 33.76819], [-118.36988, 33.76825], [-118.36957, 33.76825], [-118.36931, 33.76821], [-118.36905, 33.76812], [-118.36801, 33.7677], [-118.3677, 33.76761], [-118.36738, 33.76756], [-118.36695, 33.76756], [-118.36722, 33.76751], [-118.36745, 33.76751], [-118.36778, 33.76756], [-118.36792, 33.7676], [-118.3693, 33.76817], [-118.36961, 33.76824], [-118.36984, 33.76825], [-118.37, 33.76823], [-118.37022, 33.76817], [-118.37042, 33.76808], [-118.37055, 33.76799], [-118.37068, 33.76788], [-118.37138, 33.76708], [-118.37138, 33.76701], [-118.37159, 33.76714], [-118.37159, 33.76721]]], [[[-118.3718, 33.76638], [-118.3718, 33.76662], [-118.37176, 33.76685], [-118.3717, 33.7669], [-118.37163, 33.76689], [-118.37158, 33.76686], [-118.37168, 33.7667], [-118.37175, 33.76655], [-118.37178, 33.76638], [-118.37178, 33.76628], [-118.3718, 33.76638]]]]} | Open Access 1 | Ridgecrest Ranchos Open Space | 24353 | 2120 | Ridgecrest Ranchos Recreation and Park District 1105 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1.195 | Ridgecrest Ranchos OS | |||
8703 | 8703 | 8702 | {"type": "Polygon", "coordinates": [[[-122.30883, 40.14508], [-122.30881, 40.14591], [-122.30838, 40.14651], [-122.30818, 40.14666], [-122.30791, 40.14682], [-122.306, 40.14747], [-122.30603, 40.14725], [-122.30584, 40.14724], [-122.30582, 40.14753], [-122.30406, 40.1481], [-122.30412, 40.14504], [-122.30883, 40.14508]]]} | Open Access 1 | Ridgeway Park | 24362 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 24.283 | Ridgeway Park | ||
8702 | 8702 | 8701 | {"type": "Polygon", "coordinates": [[[-121.97524, 38.38991], [-121.97523, 38.38996], [-121.97491, 38.39019], [-121.97457, 38.39046], [-121.97438, 38.39066], [-121.97412, 38.391], [-121.97374, 38.39084], [-121.97236, 38.39046], [-121.97306, 38.38966], [-121.97336, 38.38929], [-121.9738, 38.38898], [-121.97412, 38.3888], [-121.97524, 38.38991]]]} | Open Access 1 | Ridgeview Park | 24361 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 7.844 | Ridgeview Park | ||
8701 | 8701 | 8700 | {"type": "Polygon", "coordinates": [[[-122.42826, 40.56759], [-122.42796, 40.56791], [-122.42804, 40.56814], [-122.42794, 40.56816], [-122.42779, 40.56783], [-122.42747, 40.56764], [-122.42634, 40.56741], [-122.42596, 40.56709], [-122.42536, 40.56709], [-122.42511, 40.56735], [-122.42509, 40.56783], [-122.42553, 40.5688], [-122.42545, 40.56879], [-122.42523, 40.56839], [-122.42492, 40.56848], [-122.42368, 40.56848], [-122.4237, 40.56621], [-122.42486, 40.56621], [-122.42486, 40.56667], [-122.42649, 40.5667], [-122.42676, 40.56621], [-122.42689, 40.56626], [-122.42734, 40.56651], [-122.42751, 40.56672], [-122.4269, 40.56671], [-122.42663, 40.56685], [-122.42641, 40.56688], [-122.4264, 40.56698], [-122.42688, 40.56732], [-122.4277, 40.56758], [-122.42826, 40.56759]]]} | Open Access 1 | Ridgeview Park | 24360 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 10.753 | Ridgeview Park | ||
8700 | 8700 | 8699 | {"type": "Polygon", "coordinates": [[[-122.14304, 38.19095], [-122.14273, 38.19111], [-122.14244, 38.19273], [-122.1424, 38.19282], [-122.14233, 38.19284], [-122.14197, 38.1927], [-122.14176, 38.19259], [-122.14156, 38.19252], [-122.14126, 38.19248], [-122.1408, 38.19248], [-122.14062, 38.19246], [-122.14051, 38.19243], [-122.14051, 38.19235], [-122.14104, 38.19081], [-122.14151, 38.19087], [-122.14213, 38.19078], [-122.14284, 38.19063], [-122.14304, 38.19095]]]} | Open Access 1 | Ridgeview Park | 24359 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 8.278 | Ridgeview Park | ||
8699 | 8699 | 8698 | {"type": "Polygon", "coordinates": [[[-121.69462, 38.15653], [-121.694, 38.15702], [-121.69336, 38.15651], [-121.69397, 38.15601], [-121.69462, 38.15653]]]} | Open Access 1 | Rio Vista Park | 24389 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 1.515 | Rio Vista Park | ||
8698 | 8698 | 8697 | {"type": "Polygon", "coordinates": [[[-121.08995, 38.67612], [-121.08966, 38.67632], [-121.08929, 38.67632], [-121.08942, 38.67576], [-121.08946, 38.67572], [-121.0895, 38.67571], [-121.08958, 38.67574], [-121.08977, 38.67585], [-121.08987, 38.67597], [-121.08995, 38.67612]]]} | Open Access 1 | Ridgeview 7 Park | 24357 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 0.632 | Ridgeview 7 Park | ||
8697 | 8697 | 8696 | {"type": "Polygon", "coordinates": [[[-121.35823, 38.701], [-121.35818, 38.70102], [-121.35718, 38.70101], [-121.35719, 38.70042], [-121.35676, 38.69988], [-121.35614, 38.69967], [-121.35646, 38.69952], [-121.35742, 38.69916], [-121.35768, 38.69907], [-121.35798, 38.69901], [-121.35812, 38.69948], [-121.35818, 38.69954], [-121.35812, 38.6996], [-121.35811, 38.69966], [-121.35815, 38.69976], [-121.35825, 38.70096], [-121.35823, 38.701]]]} | Open Access 1 | Ridgepoint Park | 24355 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 5.638 | Ridgepoint Park | ||
8696 | 8696 | 8695 | {"type": "Polygon", "coordinates": [[[-117.62492, 33.8738], [-117.62461, 33.87423], [-117.62431, 33.87461], [-117.62399, 33.87497], [-117.62385, 33.87509], [-117.62374, 33.875], [-117.62357, 33.87479], [-117.62342, 33.87455], [-117.62333, 33.87434], [-117.62326, 33.87406], [-117.62324, 33.87382], [-117.62327, 33.87346], [-117.62336, 33.87316], [-117.62344, 33.87301], [-117.62492, 33.8738]]]} | Open Access 1 | Ridgeline Park | 24354 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 5.034 | Ridgeline Park | ||
8695 | 8695 | 8694 | {"type": "Polygon", "coordinates": [[[-117.95287, 33.64312], [-117.95276, 33.64333], [-117.95271, 33.64349], [-117.95258, 33.64351], [-117.95264, 33.64375], [-117.95069, 33.65025], [-117.95032, 33.65064], [-117.95044, 33.65129], [-117.95, 33.65229], [-117.9495, 33.65229], [-117.94895, 33.65432], [-117.94797, 33.65773], [-117.94799, 33.65774], [-117.94829, 33.65774], [-117.94686, 33.66245], [-117.94601, 33.66564], [-117.94331, 33.66505], [-117.94417, 33.65804], [-117.94509, 33.65805], [-117.94565, 33.65663], [-117.9479, 33.65483], [-117.949, 33.6525], [-117.94937, 33.65235], [-117.94941, 33.65231], [-117.94949, 33.65231], [-117.94959, 33.65208], [-117.94976, 33.65186], [-117.94989, 33.65093], [-117.94928, 33.65063], [-117.94926, 33.64958], [-117.94856, 33.64958], [-117.94555, 33.64794], [-117.94592, 33.64317], [-117.95287, 33.64312]]]} | Open Access 1 | Talbert Nature Preserve | 26171 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 185.744 | Talbert Nature Preserve | ||
8694 | 8694 | 8693 | {"type": "Polygon", "coordinates": [[[-122.47841, 37.78346], [-122.47758, 37.78349], [-122.47755, 37.78308], [-122.47838, 37.78305], [-122.47841, 37.78346]]]} | Open Access 1 | Richmond Recreation Center | 24343 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.824 | Richmond Rec. Ctr. | ||
8693 | 8693 | 8692 | {"type": "Polygon", "coordinates": [[[-121.84233, 38.27135], [-121.84227, 38.27465], [-121.84193, 38.27469], [-121.842, 38.27647], [-121.84228, 38.27646], [-121.84225, 38.2783], [-121.83652, 38.27835], [-121.83656, 38.27647], [-121.83789, 38.27642], [-121.83782, 38.27469], [-121.83544, 38.27473], [-121.83532, 38.27836], [-121.82374, 38.27819], [-121.82374, 38.27777], [-121.82992, 38.27111], [-121.83175, 38.27111], [-121.83725, 38.27124], [-121.83731, 38.2729], [-121.83859, 38.27297], [-121.83861, 38.27296], [-121.83864, 38.27127], [-121.84233, 38.27135]], [[-121.83312, 38.27467], [-121.83319, 38.27276], [-121.83264, 38.27277], [-121.83262, 38.27468], [-121.83312, 38.27467]], [[-121.84012, 38.27472], [-121.84005, 38.27652], [-121.84099, 38.27645], [-121.84107, 38.27469], [-121.84012, 38.27472]]]} | Restricted Access 2 | Calhoun Cut Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Calhoun-Cut-ER | 16682 | 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 | 238.665 | Calhoun Cut ER | 1993 |
8692 | 8692 | 8691 | {"type": "Polygon", "coordinates": [[[-117.6897, 35.64033], [-117.68932, 35.64041], [-117.68889, 35.64048], [-117.68836, 35.64054], [-117.68795, 35.64054], [-117.68797, 35.63945], [-117.6881, 35.63943], [-117.68858, 35.63941], [-117.68914, 35.63934], [-117.68928, 35.63972], [-117.68928, 35.6398], [-117.68932, 35.63988], [-117.68939, 35.63995], [-117.68956, 35.64], [-117.6897, 35.64033]]]} | Open Access 1 | Ridgecrest holding 1 | 24351 | 1275 | Ridgecrest, City of 744 | City 2 | City Agency 2 | http://ridgecrest-ca.gov/recreation | City 2 | 3.929 | Ridgecrest holding 1 |
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]);