superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13,512 rows where ACCESS_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 392
- San Diego, City of 376
- San Jose, City of 227
- California Department of Fish and Wildlife 211
- San Francisco, City and County of 210
- Sacramento, City of 197
- Ventura, City of 146
- California Department of Parks and Recreation 139
- Los Angeles, County of 132
- Long Beach, City of 127
- Mountains Recreation and Conservation Authority 121
- Roseville, City of 112
- Oakland, City of 109
- San Diego, County of 98
- Irvine, City of 95
- Consumnes Community Services District 91
- Fresno, City of 89
- Huntington Beach, City of 75
- Hayward Area Recreation and Park District 74
- Modesto, City of 74
- Tracy, City of 70
- Stockton, City of 70
- Orange, County of 66
- Chula Vista, City of 64
- Santa Barbara, County of 63
- Newport Beach, City of 63
- Santa Cruz, City of 62
- Santa Rosa, City of 62
- Clovis, City of 60
- Poway, City of 59
- …
MNG_AG_TYP 28
- City Agency 8,927
- County Agency 867
- Recreation/Parks District 815
- State Agency 433
- Community Services District 180
- County Agency - Parks 162
- Open Space District 152
- Non Profit - Land Trust 142
- Federal Agency 111
- Water District 73
- Cemetery District 60
- Non Profit - Conservation 40
- Flood District 35
- Port/Harbor District 32
- Non Profit - Other 27
- County Agency - Other 15
- Special District - Other 12
- Irrigation District 6
- Sanitation District 6
- Non Profit - Cemetery District 5
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 12,112 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1662 | 1662 | 1661 | {"type": "Polygon", "coordinates": [[[-121.02582, 38.9373], [-121.02254, 38.93856], [-121.02232, 38.93981], [-121.02046, 38.94222], [-121.01715, 38.94306], [-121.01682, 38.93948], [-121.01802, 38.9396], [-121.01941, 38.93915], [-121.02, 38.93743], [-121.02141, 38.93616], [-121.02233, 38.93553], [-121.02281, 38.93501], [-121.0258, 38.93502], [-121.02575, 38.93638], [-121.02582, 38.9373]]]} | Open Access 1 | Auburn State Recreation Area | http://www.parks.ca.gov/?page_id=502 | 15701 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 76.198 | Auburn SRA | 1966 |
1663 | 1663 | 1662 | {"type": "Polygon", "coordinates": [[[-121.10884, 38.95035], [-121.10789, 38.95042], [-121.10787, 38.95046], [-121.10748, 38.95048], [-121.10748, 38.94927], [-121.1088, 38.94923], [-121.10884, 38.95035]]]} | Open Access 1 | Auburn Recreation District 1 | 15695 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 3.704 | Auburn Rec. District 1 | ||
1664 | 1664 | 1663 | {"type": "Polygon", "coordinates": [[[-121.07768, 38.92039], [-121.07754, 38.9204], [-121.07755, 38.92127], [-121.0773, 38.92127], [-121.07736, 38.92103], [-121.07735, 38.92101], [-121.0772, 38.92103], [-121.07719, 38.92109], [-121.07713, 38.92111], [-121.07714, 38.92128], [-121.07702, 38.92128], [-121.07712, 38.92095], [-121.07715, 38.92092], [-121.0773, 38.92087], [-121.07735, 38.92082], [-121.07736, 38.92077], [-121.07735, 38.92072], [-121.0773, 38.92066], [-121.07722, 38.92063], [-121.07711, 38.92064], [-121.07708, 38.92058], [-121.07713, 38.92045], [-121.07718, 38.92044], [-121.07722, 38.92033], [-121.07727, 38.92032], [-121.07731, 38.92022], [-121.07709, 38.92016], [-121.07684, 38.92039], [-121.07669, 38.92065], [-121.0765, 38.92135], [-121.07674, 38.9214], [-121.07666, 38.92146], [-121.07611, 38.92137], [-121.07608, 38.92142], [-121.07598, 38.92134], [-121.07617, 38.92133], [-121.07623, 38.92106], [-121.07624, 38.92093], [-121.07627, 38.92081], [-121.07643, 38.92046], [-121.07624, 38.92037], [-121.07635, 38.9203], [-121.07639, 38.92021], [-121.07634, 38.92012], [-121.07623, 38.92006], [-121.07768, 38.92011], [-121.07768, 38.92039]]]} | Open Access 1 | Auburn holding 15 | 15687 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 2.44 | Auburn holding 15 | ||
1665 | 1665 | 1664 | {"type": "Polygon", "coordinates": [[[-121.08677, 38.89466], [-121.08652, 38.89464], [-121.08619, 38.89452], [-121.08587, 38.89452], [-121.0854, 38.89474], [-121.0851, 38.89477], [-121.08481, 38.89497], [-121.0847, 38.89492], [-121.0847, 38.89455], [-121.0849, 38.89462], [-121.08509, 38.89464], [-121.08529, 38.89461], [-121.08582, 38.89446], [-121.08602, 38.89446], [-121.08627, 38.89452], [-121.08642, 38.89454], [-121.08661, 38.89453], [-121.08677, 38.89448], [-121.08677, 38.89466]]]} | Open Access 1 | Auburn holding 2 | 15688 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 0.645 | Auburn holding 2 | ||
1666 | 1666 | 1665 | {"type": "Polygon", "coordinates": [[[-121.07622, 38.92006], [-121.07609, 38.92012], [-121.07601, 38.92022], [-121.07595, 38.92022], [-121.07591, 38.92017], [-121.07559, 38.92029], [-121.07548, 38.9206], [-121.07546, 38.921], [-121.07543, 38.92102], [-121.0752, 38.92085], [-121.07501, 38.92076], [-121.0748, 38.92069], [-121.07445, 38.92065], [-121.07443, 38.92062], [-121.07603, 38.92005], [-121.07622, 38.92006]]]} | Open Access 1 | Auburn holding 3 | 15689 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1.047 | Auburn holding 3 | ||
1667 | 1667 | 1666 | {"type": "Polygon", "coordinates": [[[-121.07732, 38.92248], [-121.07544, 38.92192], [-121.07547, 38.92184], [-121.07521, 38.92155], [-121.0753, 38.9215], [-121.07565, 38.9219], [-121.07606, 38.92204], [-121.07615, 38.92189], [-121.07599, 38.92182], [-121.07585, 38.92174], [-121.07553, 38.92138], [-121.07557, 38.92136], [-121.07588, 38.92171], [-121.07602, 38.92179], [-121.07619, 38.92184], [-121.07644, 38.92185], [-121.07663, 38.92181], [-121.07679, 38.92172], [-121.0769, 38.92161], [-121.07689, 38.92174], [-121.07681, 38.92176], [-121.07683, 38.92182], [-121.07675, 38.92184], [-121.07667, 38.92184], [-121.07657, 38.92187], [-121.07657, 38.92192], [-121.07644, 38.92194], [-121.07636, 38.92194], [-121.07635, 38.9219], [-121.07628, 38.9219], [-121.07628, 38.92208], [-121.0767, 38.92208], [-121.07688, 38.92201], [-121.07687, 38.92228], [-121.07732, 38.92248]]]} | Open Access 1 | Auburn holding 4 | 15690 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 0.863 | Auburn holding 4 | ||
1668 | 1668 | 1667 | {"type": "Polygon", "coordinates": [[[-121.0847, 38.89492], [-121.08439, 38.89476], [-121.08419, 38.89442], [-121.08415, 38.89417], [-121.08429, 38.89401], [-121.08458, 38.89399], [-121.0847, 38.89432], [-121.0847, 38.89492]]]} | Open Access 1 | Auburn holding 6 | 15692 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 0.853 | Auburn holding 6 | ||
1669 | 1669 | 1668 | {"type": "Polygon", "coordinates": [[[-121.07756, 38.92258], [-121.07732, 38.92248], [-121.07742, 38.92234], [-121.07742, 38.92232], [-121.077, 38.9222], [-121.07694, 38.92231], [-121.07687, 38.92227], [-121.07688, 38.92201], [-121.07707, 38.92191], [-121.0772, 38.92173], [-121.0771, 38.92156], [-121.07695, 38.92161], [-121.07699, 38.92173], [-121.07689, 38.92174], [-121.0769, 38.92159], [-121.07696, 38.92151], [-121.07702, 38.92128], [-121.07714, 38.92128], [-121.07707, 38.92131], [-121.0771, 38.92143], [-121.07725, 38.92142], [-121.0773, 38.92128], [-121.07755, 38.92127], [-121.07756, 38.92258]]]} | Open Access 1 | Auburn holding 8 | 15693 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1.37 | Auburn holding 8 | ||
1670 | 1670 | 1669 | {"type": "Polygon", "coordinates": [[[-117.75749, 33.9912], [-117.75744, 33.99133], [-117.7574, 33.99136], [-117.757, 33.99131], [-117.75656, 33.99132], [-117.75622, 33.99138], [-117.75574, 33.99153], [-117.75569, 33.99151], [-117.75558, 33.99134], [-117.75574, 33.99128], [-117.75586, 33.99126], [-117.75615, 33.99124], [-117.7563, 33.99121], [-117.7567, 33.9911], [-117.75681, 33.99109], [-117.75704, 33.9911], [-117.75749, 33.9912]]]} | Open Access 1 | Autumn Hill Park | 15716 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 0.897 | Autumn Hill Park | ||
1671 | 1671 | 1670 | {"type": "Polygon", "coordinates": [[[-121.51727, 38.6794], [-121.51682, 38.67957], [-121.51652, 38.67972], [-121.51614, 38.67998], [-121.51586, 38.68024], [-121.5158, 38.68025], [-121.51564, 38.68016], [-121.5155, 38.68003], [-121.5148, 38.67896], [-121.51483, 38.67892], [-121.51502, 38.67885], [-121.51578, 38.67857], [-121.51597, 38.67854], [-121.5167, 38.67847], [-121.51727, 38.6794]]]} | Open Access 1 | Autumn Meadow Park | 15717 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.067 | Autumn Meadow Park | ||
1672 | 1672 | 1671 | {"type": "Polygon", "coordinates": [[[-121.1459, 37.47051], [-121.14458, 37.47106], [-121.14385, 37.46995], [-121.14391, 37.4699], [-121.1459, 37.47051]]]} | Open Access 1 | Autumn Royal Park | 15718 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 2.417 | Autumn Royal Park | ||
1673 | 1673 | 1672 | {"type": "MultiPolygon", "coordinates": [[[[-118.32595, 33.34398], [-118.32585, 33.34407], [-118.3252, 33.34351], [-118.32485, 33.34328], [-118.32455, 33.34312], [-118.32418, 33.34297], [-118.32388, 33.34298], [-118.3238, 33.34291], [-118.32394, 33.34286], [-118.3242, 33.34286], [-118.32432, 33.34289], [-118.32457, 33.343], [-118.32503, 33.34324], [-118.32521, 33.34336], [-118.32595, 33.34398]]], [[[-118.32731, 33.3462], [-118.32731, 33.34622], [-118.32747, 33.34655], [-118.3275, 33.3467], [-118.32748, 33.34699], [-118.32739, 33.34739], [-118.32732, 33.3476], [-118.32716, 33.34796], [-118.32701, 33.34824], [-118.32695, 33.34832], [-118.32682, 33.34842], [-118.32639, 33.34863], [-118.32638, 33.3486], [-118.32673, 33.34843], [-118.32693, 33.34827], [-118.327, 33.34817], [-118.32728, 33.3476], [-118.3274, 33.34719], [-118.32744, 33.34699], [-118.32745, 33.34667], [-118.32742, 33.34652], [-118.32719, 33.34608], [-118.3272, 33.34606], [-118.32712, 33.34586], [-118.32715, 33.34584], [-118.32731, 33.3462]]], [[[-118.32702, 33.34561], [-118.32698, 33.34562], [-118.3268, 33.34531], [-118.32662, 33.34507], [-118.32651, 33.34495], [-118.32664, 33.34486], [-118.32702, 33.34561]]]]} | Open Access 1 | Avalon City Beach | 15719 | 1016 | Avalon, City of 327 | City 2 | City Agency 2 | http://www.cityofavalon.com/ | City 2 | 1.268 | Avalon City Beach | ||
1674 | 1674 | 1673 | {"type": "Polygon", "coordinates": [[[-120.47471, 34.6314], [-120.4747, 34.63191], [-120.47317, 34.6319], [-120.47317, 34.63139], [-120.47471, 34.6314]]]} | Open Access 1 | Westvale Street Park | 27431 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1.963 | Westvale Street Park | ||
1676 | 1676 | 1675 | {"type": "Polygon", "coordinates": [[[-120.83864, 35.3316], [-120.83864, 35.33176], [-120.83843, 35.33176], [-120.83823, 35.33167], [-120.83823, 35.33139], [-120.83864, 35.3316]]]} | Open Access 1 | Audubon Overlook | 15703 | 3043 | Morro Coast Audubon Society 461 | Non Profit 6 | Non Profit - Conservation 12 | http://www.morrocoastaudubon.org/ | Non Governmental Organization 10 | 0.256 | Audubon Overlook | ||
1677 | 1677 | 1676 | {"type": "MultiPolygon", "coordinates": [[[[-122.4357, 37.64138], [-122.43492, 37.64176], [-122.43465, 37.64187], [-122.43415, 37.64152], [-122.4342, 37.64132], [-122.43419, 37.64112], [-122.43532, 37.64093], [-122.43563, 37.64078], [-122.4357, 37.64138]]], [[[-122.43587, 37.64316], [-122.43586, 37.64319], [-122.43584, 37.64321], [-122.43484, 37.64375], [-122.43477, 37.64373], [-122.43458, 37.64348], [-122.4354, 37.6431], [-122.43528, 37.64292], [-122.43557, 37.64278], [-122.43587, 37.64316]]]]} | Open Access 1 | Avalon Park | http://www.ssf.net/377/Parks-Recreation | 15720 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 3.591 | Avalon Park | |
1678 | 1678 | 1677 | {"type": "Polygon", "coordinates": [[[-117.30816, 34.53759], [-117.30716, 34.53889], [-117.30693, 34.53907], [-117.30671, 34.53892], [-117.30646, 34.53843], [-117.30645, 34.53754], [-117.30753, 34.53753], [-117.30754, 34.5372], [-117.30789, 34.5372], [-117.30789, 34.53752], [-117.30816, 34.53759]]]} | Open Access 1 | Avalon Park | http://www.ssf.net/377/Parks-Recreation | 15721 | 1367 | Victorville, City of 39 | City 2 | City Agency 2 | http://ci.victorville.ca.us/Site/CityDepartments2.aspx?id=522 | City 2 | 4.453 | Avalon Park | |
1679 | 1679 | 1678 | {"type": "Polygon", "coordinates": [[[-117.39388, 34.01558], [-117.39303, 34.01723], [-117.39281, 34.01754], [-117.39105, 34.01644], [-117.39205, 34.01531], [-117.39226, 34.01542], [-117.39256, 34.01509], [-117.39254, 34.01505], [-117.39262, 34.0148], [-117.39388, 34.01558]]]} | Open Access 1 | Avalon Park | http://www.ssf.net/377/Parks-Recreation | 15722 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 10.01 | Avalon Park | |
1680 | 1680 | 1679 | {"type": "Polygon", "coordinates": [[[-121.77072, 37.22196], [-121.77013, 37.22259], [-121.76976, 37.22234], [-121.76988, 37.22226], [-121.76994, 37.22218], [-121.77006, 37.22183], [-121.77011, 37.22179], [-121.77017, 37.22179], [-121.77036, 37.22183], [-121.77072, 37.22196]]]} | Open Access 1 | Avenida Espana Park | 15723 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.924 | Avenida Espana Park | 1997 | |
1681 | 1681 | 1680 | {"type": "Polygon", "coordinates": [[[-117.03793, 34.0333], [-117.03774, 34.0333], [-117.03772, 34.03306], [-117.03753, 34.03312], [-117.03753, 34.0329], [-117.03793, 34.0329], [-117.03793, 34.0333]]]} | Open Access 1 | Avenue A Park | 15724 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 0.292 | Avenue A Park | ||
1682 | 1682 | 1681 | {"type": "Polygon", "coordinates": [[[-117.0606, 34.00857], [-117.06059, 34.00958], [-117.05997, 34.00973], [-117.05876, 34.01027], [-117.05774, 34.01012], [-117.05774, 34.00862], [-117.05777, 34.00858], [-117.0606, 34.00857]]]} | Open Access 1 | Avenue I Park | 15725 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 10.26 | Avenue I 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]);