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,265
- County Agency 791
- Recreation/Parks District 762
- State Agency 591
- Non Profit - Land Trust 388
- Open Space District 184
- Federal Agency 171
- County Agency - Parks 164
- Water District 153
- Community Services District 134
- Home Owners Association 126
- Non Profit - Conservation 95
- Flood District 66
- Cemetery District 40
- Non Profit - Other 28
- County Agency - Other 27
- Port/Harbor District 23
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 8
- Special District - Other 6
- Other 5
- Joint Powers Authority 4
- Non Profit - Cemetery District 4
- Mitigation Bank 4
- Conservation District 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 363
- Los Angeles, City of 361
- California Department of Fish and Wildlife 286
- San Jose, City of 169
- California Department of Parks and Recreation 162
- San Francisco, City and County of 156
- Sacramento, City of 147
- Mountains Recreation and Conservation Authority 138
- Ventura, City of 138
- Los Angeles, County of 131
- Long Beach, City of 118
- San Diego, County of 104
- East Bay Regional Park District 101
- Roseville, City of 99
- Irvine, City of 78
- Fresno, City of 75
- Oakland, City of 74
- Santa Barbara, County of 68
- Consumnes Community Services District 68
- Orange, County of 62
- Torrance, City of 61
- Poway, City of 60
- Huntington Beach, City of 59
- Santa Cruz, City of 57
- Los Angeles - Department of Parks and Recreation, County of 57
- Hayward Area Recreation and Park District 55
- Chula Vista, City of 54
- Stockton, City of 54
- Davis, City of 53
- Lake, County of 53
- …
ACCESS_TYP 4
- Open Access 9,468
- Restricted Access 822
- No Public Access 586
- Unknown Access 218
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4545 | 4545 | 4544 | {"type": "Polygon", "coordinates": [[[-118.22958, 34.6528], [-118.22758, 34.6528], [-118.22752, 34.65275], [-118.22746, 34.65017], [-118.22952, 34.65016], [-118.22958, 34.6528]]]} | Open Access 1 | George Lane Park | 19270 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 13.664 | George Lane Park | ||
4546 | 4546 | 4545 | {"type": "Polygon", "coordinates": [[[-121.79518, 37.23742], [-121.79515, 37.23746], [-121.79513, 37.23751], [-121.79514, 37.2387], [-121.79513, 37.23879], [-121.7951, 37.23884], [-121.79504, 37.23888], [-121.79496, 37.23889], [-121.79468, 37.23884], [-121.79447, 37.23881], [-121.79399, 37.2388], [-121.79393, 37.23878], [-121.79391, 37.23873], [-121.79387, 37.23693], [-121.79388, 37.2369], [-121.79394, 37.23688], [-121.79461, 37.23701], [-121.79518, 37.23708], [-121.79518, 37.23742]]]} | Open Access 1 | George Page Park | 19272 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.627 | George Page Park | 1984 | |
4547 | 4547 | 4546 | {"type": "Polygon", "coordinates": [[[-121.41515, 38.51494], [-121.41466, 38.51496], [-121.41407, 38.51503], [-121.41356, 38.51513], [-121.41332, 38.51521], [-121.41296, 38.51529], [-121.41284, 38.5153], [-121.41283, 38.51274], [-121.41469, 38.51273], [-121.41471, 38.51291], [-121.41515, 38.51292], [-121.41515, 38.51494]]]} | Open Access 1 | George Sim Park | 19273 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 12.775 | George Sim Park | ||
4548 | 4548 | 4547 | {"type": "Polygon", "coordinates": [[[-117.91259, 33.83804], [-117.91258, 33.83808], [-117.91185, 33.83823], [-117.91182, 33.83819], [-117.91156, 33.83744], [-117.91234, 33.83726], [-117.91259, 33.83804]]]} | Open Access 1 | George Washington Park | 19275 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1.678 | George Washington Park | ||
4549 | 4549 | 4548 | {"type": "Polygon", "coordinates": [[[-121.93038, 36.61794], [-121.92852, 36.62223], [-121.92799, 36.6234], [-121.92674, 36.62304], [-121.92671, 36.62301], [-121.92672, 36.62298], [-121.92906, 36.61756], [-121.93038, 36.61794]]]} | Open Access 1 | George Washington Park | 19276 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 19.857 | George Washington Park | ||
4550 | 4550 | 4549 | {"type": "Polygon", "coordinates": [[[-120.67776, 38.19598], [-120.67773, 38.19625], [-120.6773, 38.1967], [-120.67696, 38.19652], [-120.67708, 38.19638], [-120.67705, 38.19633], [-120.67708, 38.19628], [-120.67679, 38.19615], [-120.67673, 38.19622], [-120.67652, 38.19613], [-120.67628, 38.19594], [-120.67581, 38.19539], [-120.67607, 38.19531], [-120.6771, 38.19587], [-120.67776, 38.19598]]]} | Open Access 1 | Gerald Turner Park | 19277 | 2257 | San Andreas Recreation and Park District 1061 | Special District 4 | Recreation/Parks District 4 | http://sanandreasmerchants.com/SARP.htm | Special District 4 | 2.325 | Gerald Turner Park | ||
4551 | 4551 | 4550 | {"type": "Polygon", "coordinates": [[[-122.53788, 37.96488], [-122.53788, 37.96491], [-122.53737, 37.96486], [-122.53734, 37.965], [-122.53728, 37.9654], [-122.53779, 37.96546], [-122.53766, 37.96625], [-122.5356, 37.96604], [-122.53582, 37.96468], [-122.53788, 37.96488]]]} | Open Access 1 | Gerstle Park | 19279 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 6.207 | Gerstle Park | ||
4552 | 4552 | 4551 | {"type": "Polygon", "coordinates": [[[-119.67634, 36.79757], [-119.67634, 36.7984], [-119.67531, 36.79843], [-119.67412, 36.79843], [-119.67412, 36.79823], [-119.67405, 36.79822], [-119.67406, 36.79755], [-119.67595, 36.79757], [-119.67634, 36.79757]]]} | Open Access 1 | Gettysburg Park | 19281 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 4.763 | Gettysburg Park | ||
4553 | 4553 | 4552 | {"type": "Polygon", "coordinates": [[[-121.63325, 39.13444], [-121.63323, 39.1362], [-121.63228, 39.13617], [-121.63229, 39.13444], [-121.63325, 39.13444]]]} | Open Access 1 | Geweke Field | 19282 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 3.951 | Geweke Field | ||
4554 | 4554 | 4553 | {"type": "Polygon", "coordinates": [[[-122.29825, 38.2744], [-122.29823, 38.27446], [-122.29817, 38.2745], [-122.29809, 38.27452], [-122.29236, 38.27449], [-122.29235, 38.2745], [-122.29237, 38.27463], [-122.28394, 38.27458], [-122.2846, 38.27391], [-122.2848, 38.27382], [-122.28533, 38.27354], [-122.28611, 38.27308], [-122.28657, 38.27278], [-122.28722, 38.27196], [-122.28745, 38.27119], [-122.28741, 38.27072], [-122.28736, 38.27048], [-122.28684, 38.26916], [-122.28654, 38.26744], [-122.29799, 38.26741], [-122.29799, 38.26749], [-122.29805, 38.2675], [-122.29798, 38.26871], [-122.29796, 38.27054], [-122.29799, 38.27137], [-122.29805, 38.27227], [-122.29825, 38.2744]]]} | No Public Access 3 | Ghisleta - South Wetlands | 19283 | 311 | Napa, County of 489 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 196.863 | Ghisleta - South Wetlands | ||
4555 | 4555 | 4554 | {"type": "MultiPolygon", "coordinates": [[[[-117.00001, 33.75093], [-116.99805, 33.75095], [-116.99798, 33.75094], [-116.99796, 33.75088], [-116.99794, 33.74935], [-116.99795, 33.74933], [-116.99799, 33.7493], [-116.99803, 33.7493], [-116.99999, 33.74928], [-117.00001, 33.75093]]], [[[-116.99999, 33.74911], [-116.99803, 33.74912], [-116.99797, 33.74911], [-116.99795, 33.74908], [-116.99794, 33.74755], [-116.99795, 33.74752], [-116.998, 33.7475], [-116.99998, 33.74749], [-116.99999, 33.74911]]]]} | Open Access 1 | Gibbel Park | 19285 | 1132 | Hemet, City of 139 | City 2 | City Agency 2 | http://www.cityofhemet.org/index.aspx?nid=95 | City 2 | 16.986 | Gibbel Park | ||
4556 | 4556 | 4555 | {"type": "Polygon", "coordinates": [[[-121.33843, 38.02211], [-121.33576, 38.02212], [-121.33575, 38.02155], [-121.33596, 38.0216], [-121.3361, 38.02161], [-121.33628, 38.02159], [-121.33665, 38.02149], [-121.33684, 38.02146], [-121.33841, 38.02147], [-121.33843, 38.02211]]]} | Open Access 1 | Gibbons Park | 19286 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 3.948 | Gibbons Park | ||
4557 | 4557 | 4556 | {"type": "Polygon", "coordinates": [[[-121.35466, 38.63562], [-121.35466, 38.63734], [-121.35236, 38.63732], [-121.35235, 38.63558], [-121.35466, 38.63562]]]} | Open Access 1 | Gibbons Park | 19287 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 9.542 | Gibbons Park | ||
4558 | 4558 | 4557 | {"type": "Polygon", "coordinates": [[[-122.86697, 38.63065], [-122.86595, 38.63077], [-122.86592, 38.63004], [-122.86626, 38.63003], [-122.86628, 38.62997], [-122.86694, 38.62996], [-122.86697, 38.63065]]]} | Open Access 1 | Gibbs Park | 19288 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1.767 | Gibbs Park | ||
4559 | 4559 | 4558 | {"type": "Polygon", "coordinates": [[[-118.036, 33.71978], [-118.0359, 33.71996], [-118.03581, 33.72025], [-118.03579, 33.72045], [-118.03583, 33.72074], [-118.0358, 33.72076], [-118.03539, 33.72084], [-118.0353, 33.72088], [-118.03522, 33.7208], [-118.03495, 33.7208], [-118.03493, 33.72083], [-118.03282, 33.72084], [-118.0328, 33.72002], [-118.0349, 33.72], [-118.03491, 33.71978], [-118.036, 33.71978]]]} | Open Access 1 | Gibbs Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/gibbs-park.cfm | 19289 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 6.858 | Gibbs Park | |
4560 | 4560 | 4559 | {"type": "Polygon", "coordinates": [[[-119.6934, 34.52036], [-119.6934, 34.52221], [-119.69115, 34.52218], [-119.69114, 34.52754], [-119.68866, 34.52752], [-119.68705, 34.52781], [-119.68501, 34.52953], [-119.68622, 34.53066], [-119.68472, 34.53039], [-119.68386, 34.53133], [-119.67969, 34.53036], [-119.67781, 34.52923], [-119.67491, 34.5293], [-119.67149, 34.52698], [-119.6681, 34.52496], [-119.66732, 34.52538], [-119.66722, 34.52689], [-119.66577, 34.52756], [-119.6666, 34.52867], [-119.66618, 34.53081], [-119.66796, 34.53221], [-119.66763, 34.53302], [-119.6658, 34.53325], [-119.66514, 34.53309], [-119.6664, 34.53236], [-119.66561, 34.53143], [-119.66599, 34.5291], [-119.66389, 34.52704], [-119.65995, 34.52669], [-119.65741, 34.52878], [-119.65352, 34.52894], [-119.65144, 34.5286], [-119.64741, 34.52629], [-119.64605, 34.52516], [-119.64503, 34.52343], [-119.64467, 34.52235], [-119.64306, 34.52303], [-119.6413, 34.52278], [-119.63968, 34.52275], [-119.63712, 34.52172], [-119.63329, 34.52084], [-119.63247, 34.52217], [-119.63085, 34.52238], [-119.6296, 34.52313], [-119.6276, 34.52426], [-119.62715, 34.52608], [-119.63044, 34.52831], [-119.63085, 34.52999], [-119.63081, 34.53046], [-119.63135, 34.53015], [-119.63372, 34.5296], [-119.63515, 34.52996], [-119.63677, 34.53112], [-119.63734, 34.53289], [-119.6381, 34.53317], [-119.6361, 34.53433], [-119.63548, 34.53505], [-119.63983, 34.53544], [-119.63879, 34.53598], [-119.63742, 34.53615], [-119.63701, 34.53779], [-119.63555, 34.53873], [-119.63561, 34.53934], [-119.6374, 34.53989], [-119.63713, 34.54123], [-119.63743, 34.54178], [-119.63795, 34.54182], [-119.63831, 34.54016], [-119.63944, 34.53981], [-119.6405, 34.53968], [-119.64324, 34.54248], [-119.64332, 34.54352], [-119.6421, 34.5457], [-119.64226, 34.54683], [-119.64087, 34.54775], [-119.63885, 34.54829], [-119.63962, 34.54694], [-119.63881, 34.5462], [-119.64091, 34.5437], [-119.64035, 34.54314], [-119.63909, 34.54288], [-119.63751, 34.54389], [-119.63537, 34.54242], [-119.63522, 34.54072], [-119.63257, 34.53804], [-119.63146, 34.53994], [-119.63076, 34.54023], [-119.63073, 34.54045], [-119.63118, 34.54086], [-119.63118, 34.54213], [-119.62993, 34.54216], [-119.62822, 34.54156], [-119.62802, 34.54172], [-119.62753, 34.54121], [-119.62715, 34.54119], [-119.62678, 34.54203], [-119.62777, 34.54251], [-119.62947, 34.54367], [-119.6322, 34.54523], [-119.62972, 34.54491], [-119.6297, 34.54575], [-119.62938, 34.54761], [-119.62813, 34.54806], [-119.62443, 34.54676], [-119.62415, 34.54673], [-119.62367, 34.54769], [-119.6237, 34.54853], [-119.62276, 34.54962], [-119.62247, 34.54963], [-119.62297, 34.54569], [-119.62344, 34.54558], [-119.62792, 34.54657], [-119.62826, 34.54627], [-119.62775, 34.54505], [-119.62729, 34.54435], [-119.62493, 34.54437], [-119.62428, 34.5438], [-119.62417, 34.54201], [-119.62251, 34.54055], [-119.62356, 34.53906], [-119.6255, 34.5396], [-119.62721, 34.53891], [-119.62817, 34.53927], [-119.62953, 34.53924], [-119.62954, 34.53923], [-119.62905, 34.53753], [-119.62803, 34.53661], [-119.62703, 34.53618], [-119.62609, 34.53623], [-119.6254, 34.53552], [-119.62507, 34.53642], [-119.62395, 34.53587], [-119.62331, 34.53588], [-119.62223, 34.53672], [-119.62191, 34.53556], [-119.62608, 34.53399], [-119.6265, 34.53111], [-119.63041, 34.53065], [-119.63054, 34.53006], [-119.63016, 34.52838], [-119.62687, 34.52621], [-119.62739, 34.52412], [-119.62832, 34.52354], [-119.62979, 34.5228], [-119.63073, 34.52222], [-119.63239, 34.52191], [-119.63266, 34.52094], [-119.63222, 34.51907], [-119.63374, 34.51892], [-119.63539, 34.51883], [-119.63861, 34.51929], [-119.64019, 34.5204], [-119.64043, 34.51992], [-119.6408, 34.52076], [-119.64154, 34.52053], [-119.64505, 34.52033], [-119.64689, 34.52171], [-119.64839, 34.5232], [-119.65019, 34.52639], [-119.65259, 34.52569], [-119.65348, 34.5265], [-119.65703, 34.5285], [-119.65783, 34.52777], [-119.65784, 34.52672], [-119.65832, 34.52706], [-119.66009, 34.52521], [-119.66441, 34.52522], [-119.66858, 34.52383], [-119.67364, 34.526], [-119.67425, 34.52593], [-119.67374, 34.52267], [-119.66995, 34.51894], [-119.67134, 34.51923], [-119.67499, 34.52215], [-119.67562, 34.52267], [-119.67459, 34.52272], [-119.67473, 34.52671], [-119.68073, 34.52912], [-119.68307, 34.52908], [-119.68434, 34.52755], [-119.68433, 34.52753], [-119.68241, 34.52753], [-119.68242, 34.52388], [-119.68457, 34.52388], [-119.68458, 34.52035], [-119.6934, 34.52036]]]} | Unknown Access 4 | Gibraltar Reservoir | https://www.santabarbaraca.gov/gov/depts/pw/resources/system/sources/gibraltar.asp | 19290 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 925.866 | Gibraltar Reservoir | |
4561 | 4561 | 4560 | {"type": "Polygon", "coordinates": [[[-122.24487, 38.10479], [-122.24365, 38.10479], [-122.24368, 38.1036], [-122.24461, 38.10363], [-122.24487, 38.10479]]]} | Open Access 1 | Gibson Park | 19291 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 3.05 | Gibson Park | ||
4562 | 4562 | 4561 | {"type": "Polygon", "coordinates": [[[-117.96739, 33.85816], [-117.96643, 33.85817], [-117.96643, 33.85902], [-117.96532, 33.85904], [-117.96531, 33.85817], [-117.96617, 33.85817], [-117.96618, 33.85792], [-117.96625, 33.85787], [-117.96627, 33.85779], [-117.96642, 33.85778], [-117.9664, 33.85667], [-117.96737, 33.85666], [-117.96739, 33.85816]]]} | Open Access 1 | Gilbert Park | 19293 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 6.329 | Gilbert Park | ||
4563 | 4563 | 4562 | {"type": "Polygon", "coordinates": [[[-117.63849, 33.59798], [-117.6378, 33.59939], [-117.63741, 33.59992], [-117.6371, 33.60025], [-117.63629, 33.60087], [-117.63581, 33.6012], [-117.63527, 33.60069], [-117.63504, 33.60059], [-117.63493, 33.60058], [-117.63489, 33.60055], [-117.63485, 33.60045], [-117.63485, 33.60032], [-117.63495, 33.60022], [-117.63499, 33.60011], [-117.6351, 33.59996], [-117.63537, 33.59984], [-117.6354, 33.5998], [-117.63534, 33.59972], [-117.63486, 33.59924], [-117.63488, 33.59917], [-117.63494, 33.59913], [-117.63502, 33.59913], [-117.63542, 33.59918], [-117.63594, 33.59903], [-117.63608, 33.59904], [-117.6362, 33.59885], [-117.63623, 33.59849], [-117.63624, 33.59847], [-117.63633, 33.5985], [-117.63656, 33.59865], [-117.63658, 33.59864], [-117.63662, 33.59851], [-117.63662, 33.59835], [-117.63676, 33.59803], [-117.63678, 33.59774], [-117.63735, 33.59739], [-117.63742, 33.59737], [-117.63766, 33.59737], [-117.63783, 33.59745], [-117.63792, 33.59757], [-117.63829, 33.59778], [-117.63849, 33.59791], [-117.63849, 33.59798]]]} | Open Access 1 | Gilleran Park | 19294 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 17.014 | Gilleran Park | ||
4564 | 4564 | 4563 | {"type": "Polygon", "coordinates": [[[-121.96308, 37.29872], [-121.96265, 37.29819], [-121.96239, 37.29789], [-121.96265, 37.2979], [-121.96266, 37.29797], [-121.9628, 37.29824], [-121.96308, 37.29872]]]} | Open Access 1 | Gleason Park | 19311 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.215 | Gleason 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]);