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
- San Diego, City of 338
- Los Angeles, City of 315
- California Department of Fish and Wildlife 203
- San Jose, City of 145
- San Francisco, City and County of 143
- California Department of Parks and Recreation 139
- Sacramento, City of 137
- Ventura, City of 136
- Long Beach, City of 108
- Los Angeles, County of 107
- Mountains Recreation and Conservation Authority 102
- Roseville, City of 89
- San Diego, County of 81
- Irvine, City of 74
- Fresno, City of 71
- Oakland, City of 65
- Consumnes Community Services District 64
- Poway, City of 57
- Orange, County of 55
- Santa Barbara, County of 54
- Santa Cruz, City of 51
- Lake, County of 51
- Davis, City of 50
- Los Angeles - Department of Parks and Recreation, County of 49
- Clovis, City of 48
- East Bay Regional Park District 47
- Chula Vista, City of 47
- Huntington Beach, City of 47
- Stockton, City of 47
- Hayward Area Recreation and Park District 45
- …
MNG_AG_TYP 28
- City Agency 6,436
- County Agency 659
- Recreation/Parks District 595
- State Agency 409
- County Agency - Parks 137
- Open Space District 131
- Community Services District 123
- Non Profit - Land Trust 122
- Federal Agency 97
- Water District 66
- Non Profit - Conservation 38
- Cemetery District 36
- Flood District 28
- Non Profit - Other 25
- Port/Harbor District 21
- County Agency - Other 14
- Irrigation District 6
- Special District - Other 6
- Sanitation District 5
- Non Profit - Cemetery District 4
- 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 · 8,970 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5077 | 5077 | 5076 | {"type": "MultiPolygon", "coordinates": [[[[-118.39448, 33.85549], [-118.39417, 33.85555], [-118.39408, 33.85529], [-118.39387, 33.85486], [-118.39328, 33.85395], [-118.39335, 33.85394], [-118.39338, 33.85394], [-118.39353, 33.85406], [-118.39367, 33.85413], [-118.39379, 33.85422], [-118.39392, 33.85436], [-118.39413, 33.85469], [-118.39434, 33.85508], [-118.39448, 33.85549]]], [[[-118.39374, 33.85407], [-118.39363, 33.85402], [-118.39346, 33.85391], [-118.3936, 33.85387], [-118.39374, 33.85407]]], [[[-118.39453, 33.85565], [-118.39456, 33.85576], [-118.39461, 33.85604], [-118.39464, 33.85632], [-118.39463, 33.85675], [-118.39457, 33.85718], [-118.39443, 33.85769], [-118.39418, 33.85847], [-118.39408, 33.85904], [-118.39407, 33.85951], [-118.39417, 33.8601], [-118.39386, 33.86016], [-118.3938, 33.85992], [-118.39375, 33.85956], [-118.39374, 33.85913], [-118.39376, 33.85892], [-118.39385, 33.85843], [-118.39415, 33.85749], [-118.39423, 33.85718], [-118.39429, 33.85684], [-118.39431, 33.8566], [-118.3943, 33.85627], [-118.39428, 33.85609], [-118.39417, 33.85589], [-118.39404, 33.85575], [-118.3942, 33.8557], [-118.39453, 33.85565]]], [[[-118.39536, 33.86445], [-118.39504, 33.86451], [-118.39389, 33.86032], [-118.39421, 33.86026], [-118.39536, 33.86445]]], [[[-118.40176, 33.87623], [-118.40145, 33.87635], [-118.40139, 33.87605], [-118.40129, 33.87574], [-118.40112, 33.8754], [-118.4009, 33.87508], [-118.40072, 33.87486], [-118.4003, 33.87447], [-118.39989, 33.87415], [-118.39942, 33.87374], [-118.39899, 33.87331], [-118.39879, 33.87309], [-118.39837, 33.87256], [-118.39797, 33.87194], [-118.39776, 33.87156], [-118.39764, 33.8713], [-118.39609, 33.86793], [-118.39589, 33.8674], [-118.39571, 33.86687], [-118.39512, 33.86478], [-118.3954, 33.86473], [-118.39594, 33.86669], [-118.39617, 33.86737], [-118.39642, 33.868], [-118.39798, 33.87137], [-118.39825, 33.87186], [-118.39856, 33.87234], [-118.39882, 33.87268], [-118.399, 33.87291], [-118.3995, 33.87344], [-118.39994, 33.87385], [-118.40047, 33.87427], [-118.40052, 33.87427], [-118.40074, 33.87446], [-118.401, 33.87472], [-118.40112, 33.87486], [-118.40138, 33.87522], [-118.40155, 33.87554], [-118.4017, 33.87597], [-118.40176, 33.87623]]], [[[-118.40194, 33.8771], [-118.4016, 33.87711], [-118.40149, 33.8765], [-118.40178, 33.87638], [-118.40194, 33.8771]]]]} | Open Access 1 | Hermosa Valley Greenbelt Park | 19872 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 19.082 | Hermosa Valley Greenbelt Park | ||
5078 | 5078 | 5077 | {"type": "Polygon", "coordinates": [[[-118.0783, 33.88585], [-118.07617, 33.88585], [-118.07614, 33.8841], [-118.07735, 33.8841], [-118.07753, 33.88415], [-118.07799, 33.88438], [-118.07814, 33.88441], [-118.07826, 33.88442], [-118.0783, 33.88585]]]} | Open Access 1 | Hermosillo Park | 19873 | 1225 | Norwalk, City of 235 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 9.048 | Hermosillo Park | ||
5079 | 5079 | 5078 | {"type": "Polygon", "coordinates": [[[-120.61241, 35.11026], [-120.61236, 35.11057], [-120.61232, 35.11061], [-120.61228, 35.11061], [-120.61184, 35.11056], [-120.61162, 35.11056], [-120.61162, 35.11015], [-120.61204, 35.11017], [-120.61239, 35.11023], [-120.61241, 35.11026]]]} | Open Access 1 | Hero Community Park | 19875 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 0.77 | Hero Community Park | ||
5080 | 5080 | 5079 | {"type": "Polygon", "coordinates": [[[-117.68927, 33.62278], [-117.68788, 33.62387], [-117.68692, 33.62467], [-117.6864, 33.62386], [-117.68614, 33.62354], [-117.68581, 33.62322], [-117.6855, 33.623], [-117.6855, 33.6229], [-117.68727, 33.62139], [-117.68738, 33.62148], [-117.68763, 33.62149], [-117.68788, 33.62168], [-117.68788, 33.62176], [-117.68811, 33.62195], [-117.68821, 33.62195], [-117.68867, 33.62235], [-117.68883, 33.62243], [-117.68897, 33.62244], [-117.68927, 33.62278]]]} | Open Access 1 | Heroes Park | 19876 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 15.63 | Heroes Park | ||
5081 | 5081 | 5080 | {"type": "Polygon", "coordinates": [[[-122.37626, 37.73978], [-122.37529, 37.74023], [-122.37485, 37.73989], [-122.3739, 37.73956], [-122.37326, 37.73843], [-122.3721, 37.73819], [-122.37101, 37.73817], [-122.36935, 37.7382], [-122.36848, 37.73836], [-122.36751, 37.73834], [-122.36779, 37.73814], [-122.36894, 37.73792], [-122.3698, 37.73767], [-122.37124, 37.73722], [-122.37185, 37.73715], [-122.37283, 37.73711], [-122.37388, 37.7373], [-122.37441, 37.73815], [-122.37558, 37.73862], [-122.37528, 37.73937], [-122.37626, 37.73978]]]} | Open Access 1 | Heron's Head Park | 19877 | 2198 | San Francisco, Port of 786 | Special District 4 | Port/Harbor District 14 | http://www.sfport.com/index.aspx?page=60 | Special District 4 | 19.523 | Heron's Head Park | ||
5082 | 5082 | 5081 | {"type": "Polygon", "coordinates": [[[-121.68708, 37.93859], [-121.68708, 37.93885], [-121.687, 37.9389], [-121.687, 37.9391], [-121.68708, 37.93909], [-121.68708, 37.93924], [-121.687, 37.93929], [-121.687, 37.93949], [-121.68708, 37.93948], [-121.68708, 37.9398], [-121.68705, 37.93986], [-121.68697, 37.93989], [-121.68496, 37.9399], [-121.68473, 37.93992], [-121.68441, 37.93996], [-121.68393, 37.93997], [-121.68394, 37.93831], [-121.6842, 37.93831], [-121.68421, 37.93859], [-121.68669, 37.93859], [-121.68689, 37.93859], [-121.68689, 37.93832], [-121.68694, 37.93832], [-121.68702, 37.93834], [-121.68702, 37.93858], [-121.68708, 37.93859]]]} | Open Access 1 | Heron Park | 19878 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 10.188 | Heron Park | ||
5083 | 5083 | 5082 | {"type": "Polygon", "coordinates": [[[-121.51362, 38.66933], [-121.51356, 38.66936], [-121.51352, 38.66965], [-121.51202, 38.66965], [-121.51203, 38.66902], [-121.51201, 38.66897], [-121.51196, 38.66892], [-121.51187, 38.66888], [-121.51187, 38.66863], [-121.51362, 38.66862], [-121.51363, 38.66917], [-121.5136, 38.66928], [-121.51362, 38.66933]]]} | Open Access 1 | Heron Park | 19879 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.956 | Heron Park | ||
5084 | 5084 | 5083 | {"type": "MultiPolygon", "coordinates": [[[[-122.46731, 38.28258], [-122.46729, 38.28272], [-122.46688, 38.28263], [-122.4668, 38.28253], [-122.46731, 38.28258]]], [[[-122.46815, 38.28261], [-122.4681, 38.28322], [-122.46768, 38.28297], [-122.46743, 38.2829], [-122.46745, 38.28256], [-122.46815, 38.28261]]]]} | Open Access 1 | Hertenstein Park | 19880 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 0.882 | Hertenstein Park | ||
5085 | 5085 | 5084 | {"type": "Polygon", "coordinates": [[[-117.31877, 34.42606], [-117.31834, 34.42783], [-117.31734, 34.42769], [-117.31772, 34.4259], [-117.31877, 34.42606]]]} | Open Access 1 | Hesperia Civic Plaza Park | 19881 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 4.774 | Hesperia Civic Plaza Park | ||
5086 | 5086 | 5085 | {"type": "Polygon", "coordinates": [[[-117.36386, 34.43854], [-117.36052, 34.43857], [-117.3605, 34.43824], [-117.3599, 34.43825], [-117.3599, 34.43767], [-117.36088, 34.43764], [-117.36087, 34.43676], [-117.35989, 34.43677], [-117.35988, 34.43496], [-117.36195, 34.43494], [-117.36196, 34.43583], [-117.36295, 34.43583], [-117.36386, 34.43854]]]} | Open Access 1 | Hesperia Community Park | 19882 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 26.063 | Hesperia Community Park | ||
5087 | 5087 | 5086 | {"type": "Polygon", "coordinates": [[[-122.12445, 37.69399], [-122.12425, 37.69399], [-122.12416, 37.69402], [-122.12319, 37.69335], [-122.12328, 37.69327], [-122.12338, 37.69313], [-122.12363, 37.69319], [-122.12373, 37.69323], [-122.12373, 37.6934], [-122.12384, 37.69341], [-122.12385, 37.69364], [-122.12407, 37.69364], [-122.12415, 37.6937], [-122.12445, 37.69371], [-122.12445, 37.69399]]]} | Open Access 1 | Hesperian Park | 19883 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 0.936 | Hesperian Park | ||
5088 | 5088 | 5087 | {"type": "MultiPolygon", "coordinates": [[[[-121.92618, 37.33141], [-121.92528, 37.3321], [-121.92477, 37.33166], [-121.92456, 37.33181], [-121.92442, 37.33181], [-121.92369, 37.33118], [-121.92368, 37.33108], [-121.92405, 37.33081], [-121.92415, 37.33082], [-121.92427, 37.33089], [-121.9246, 37.33088], [-121.92479, 37.33103], [-121.92494, 37.33102], [-121.92533, 37.33071], [-121.92618, 37.33141]]], [[[-121.92624, 37.33214], [-121.92612, 37.33223], [-121.92576, 37.33193], [-121.92588, 37.33184], [-121.92624, 37.33214]]]]} | Open Access 1 | Hester Park | 19884 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.697 | Hester Park | 1996 | |
5089 | 5089 | 5088 | {"type": "Polygon", "coordinates": [[[-121.98799, 36.97419], [-121.98785, 36.97463], [-121.98734, 36.97452], [-121.98747, 36.97409], [-121.98799, 36.97419]]]} | Open Access 1 | Hestwood Park | 19885 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.588 | Hestwood Park | ||
5090 | 5090 | 5089 | {"type": "Polygon", "coordinates": [[[-121.88959, 36.95741], [-121.88855, 36.95826], [-121.88843, 36.95817], [-121.88948, 36.95731], [-121.88959, 36.95741]]]} | Open Access 1 | Hidden Beach | 19901 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 0.487 | Hidden Beach | |||
5092 | 5092 | 5091 | {"type": "MultiPolygon", "coordinates": [[[[-121.00826, 37.69491], [-121.00639, 37.69546], [-121.00416, 37.6961], [-121.00417, 37.69578], [-121.00813, 37.69463], [-121.00826, 37.69491]]], [[[-121.0124, 37.69371], [-121.00845, 37.69486], [-121.00832, 37.69457], [-121.0124, 37.69339], [-121.0124, 37.69371]]], [[[-121.01761, 37.69219], [-121.01578, 37.69273], [-121.01265, 37.69363], [-121.01264, 37.69331], [-121.01377, 37.69298], [-121.01751, 37.6919], [-121.01761, 37.69219]]], [[[-121.02237, 37.69086], [-121.0216, 37.69112], [-121.02161, 37.69143], [-121.01974, 37.69157], [-121.01781, 37.69213], [-121.01771, 37.69184], [-121.02069, 37.69097], [-121.0207, 37.69137], [-121.02154, 37.69138], [-121.02155, 37.69109], [-121.02237, 37.69079], [-121.02237, 37.69086]]], [[[-121.02637, 37.68964], [-121.02317, 37.69057], [-121.02251, 37.69076], [-121.0225, 37.69044], [-121.02532, 37.68962], [-121.02637, 37.68964]]], [[[-121.03142, 37.68816], [-121.02727, 37.68937], [-121.02669, 37.68937], [-121.0267, 37.68922], [-121.03142, 37.68784], [-121.03142, 37.68816]]], [[[-121.04051, 37.68552], [-121.04051, 37.68552], [-121.03168, 37.68809], [-121.03168, 37.68777], [-121.0405, 37.6852], [-121.04051, 37.68552]]], [[[-121.04968, 37.68284], [-121.04964, 37.68286], [-121.04072, 37.68546], [-121.04071, 37.68514], [-121.04967, 37.68252], [-121.04968, 37.68284]]]]} | Open Access 1 | Hetch Hetchy Trail | 19886 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 32.987 | Hetch Hetchy Trail | ||
5093 | 5093 | 5092 | {"type": "MultiPolygon", "coordinates": [[[[-119.90427, 38.00765], [-119.90155, 38.00769], [-119.90426, 38.00763], [-119.90417, 37.99681], [-119.89503, 37.99692], [-119.90419, 37.9968], [-119.9043, 38.00737], [-119.90427, 38.00765]]], [[[-119.89967, 38.00773], [-119.89967, 38.00761], [-119.89962, 38.00049], [-119.89963, 38.00049], [-119.89967, 38.00773]]], [[[-119.91335, 38.00029], [-119.90878, 38.00036], [-119.90882, 38.00455], [-119.90877, 38.00035], [-119.91335, 38.00029]]], [[[-119.91747, 38.00745], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91747, 38.00745]]], [[[-119.91643, 38.00385], [-119.91643, 38.00385], [-119.91388, 38.00389], [-119.91641, 38.00384], [-119.91643, 38.00385]]]]} | Open Access 1 | Hetch Hetchy Water and Power | 19887 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 1.172 | Hetch Hetchy Water and Power | ||
5095 | 5095 | 5094 | {"type": "Polygon", "coordinates": [[[-118.01964, 33.79458], [-118.01964, 33.79547], [-118.01953, 33.79555], [-118.01817, 33.79554], [-118.01812, 33.79552], [-118.0181, 33.79548], [-118.0181, 33.79453], [-118.01814, 33.79451], [-118.01955, 33.79451], [-118.01961, 33.79453], [-118.01964, 33.79458]]]} | Open Access 1 | Hettinga/Manzanita Park | 19889 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 4.0 | Hettinga/Manzanita Park | ||
5096 | 5096 | 5095 | {"type": "Polygon", "coordinates": [[[-121.55295, 39.5105], [-121.55266, 39.5106], [-121.55243, 39.51027], [-121.55054, 39.51125], [-121.55008, 39.51135], [-121.54993, 39.51096], [-121.55003, 39.51093], [-121.5502, 39.51079], [-121.55026, 39.51068], [-121.55024, 39.51054], [-121.55015, 39.51055], [-121.55037, 39.51016], [-121.55053, 39.51015], [-121.55054, 39.51012], [-121.5508, 39.51003], [-121.55085, 39.50987], [-121.55084, 39.5098], [-121.55111, 39.50971], [-121.55115, 39.50965], [-121.5511, 39.50953], [-121.5517, 39.50931], [-121.55196, 39.50971], [-121.55211, 39.50965], [-121.55252, 39.50998], [-121.55261, 39.51012], [-121.5527, 39.5101], [-121.55295, 39.5105]]]} | Open Access 1 | Hewitt Park | 19890 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 6.353 | Hewitt Park | ||
5097 | 5097 | 5096 | {"type": "Polygon", "coordinates": [[[-122.63748, 41.70784], [-122.63684, 41.70871], [-122.63636, 41.70858], [-122.63561, 41.70825], [-122.63577, 41.70803], [-122.63593, 41.70785], [-122.63621, 41.70776], [-122.63657, 41.70768], [-122.63678, 41.70769], [-122.63748, 41.70784]]]} | Open Access 1 | Hibbard Field | 19892 | 365 | Siskiyou, County of 586 | County 3 | County Agency 3 | http://www.co.siskiyou.ca.us/ | County 3 | 2.666 | Hibbard Field | ||
5099 | 5099 | 5098 | {"type": "Polygon", "coordinates": [[[-119.76316, 36.37605], [-119.7586, 36.37602], [-119.75864, 36.37191], [-119.76312, 36.37188], [-119.76316, 36.37605]]]} | Open Access 1 | Hickey Park | 19894 | 304 | Kings, County of 357 | County 3 | County Agency 3 | http://www.countyofkings.com/departments/public-works | County 3 | 46.046 | Hickey 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]);