superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
78 rows where ACCESS_TYP = 2 and MNG_AG_LEV = 3 sorted by PARK_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, AGNCY_WEB, YR_EST
MNG_AGENCY 22
- Sacramento, County of 21
- Los Angeles, County of 14
- San Francisco - Public Utilities Commission, City and County of 8
- Los Angeles - Department of Parks and Recreation, County of 7
- Orange, County of 5
- San Diego, County of 3
- Santa Cruz, County of 2
- San Luis Obispo, County of 2
- Ventura, County of 2
- Santa Clara County Parks and Recreation Dept., County of 2
- Monterey, County of 1
- Tulare, County of 1
- Marin County Parks Department, County of 1
- Riverside, County of 1
- Sonoma County Regional Parks Dept., County of 1
- Placer, County of 1
- Fresno, County of 1
- Kern, County of 1
- Contra Costa County Public Works Dept., County of 1
- Humboldt, County of 1
- Shasta, County of 1
- Orange County Department of Education, County of 1
MNG_AG_TYP 3
ACCESS_TYP 1
- Restricted Access · 78 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14179 | 14179 | 14178 | {"type": "Polygon", "coordinates": [[[-122.93948, 38.35579], [-122.93861, 38.35592], [-122.93857, 38.35592], [-122.93856, 38.35587], [-122.93847, 38.35577], [-122.93853, 38.35573], [-122.93849, 38.35551], [-122.93858, 38.35544], [-122.93913, 38.35514], [-122.93922, 38.35551], [-122.93948, 38.35579]]]} | Restricted Access 2 | Watson School/ Wayside Park | 31655 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 1.063 | Watson School/ Wayside Park | ||
12024 | 12024 | 12023 | {"type": "Polygon", "coordinates": [[[-118.22505, 33.96758], [-118.22454, 33.96753], [-118.22448, 33.9675], [-118.22431, 33.96734], [-118.22437, 33.96694], [-118.22436, 33.96693], [-118.22415, 33.96711], [-118.22327, 33.96702], [-118.22323, 33.96723], [-118.22254, 33.96715], [-118.22254, 33.96649], [-118.22474, 33.96672], [-118.2247, 33.96704], [-118.22505, 33.96709], [-118.22505, 33.96758]]]} | Restricted Access 2 | Walnut Nature Park | 28911 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 3.592 | Walnut Nature Park | ||
5183 | 5183 | 5182 | {"type": "Polygon", "coordinates": [[[-118.27588, 33.85284], [-118.2733, 33.85587], [-118.27289, 33.85501], [-118.27131, 33.85628], [-118.27096, 33.85622], [-118.27087, 33.85665], [-118.26832, 33.85666], [-118.26831, 33.85663], [-118.26621, 33.85662], [-118.26616, 33.85657], [-118.26515, 33.84858], [-118.26738, 33.84759], [-118.26891, 33.84731], [-118.26947, 33.84787], [-118.26991, 33.84825], [-118.26994, 33.84841], [-118.27012, 33.84858], [-118.2705, 33.84889], [-118.27057, 33.84885], [-118.2725, 33.85028], [-118.2731, 33.85068], [-118.27588, 33.85284]]]} | Restricted Access 2 | Victoria Golf Course | 33008 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 167.243 | Victoria GC | ||
10790 | 10790 | 10789 | {"type": "Polygon", "coordinates": [[[-121.28865, 38.49607], [-121.27955, 38.49606], [-121.27946, 38.48155], [-121.28863, 38.48158], [-121.28865, 38.49607]]]} | Restricted Access 2 | Vernal Pool Prairie Preserve Area | 27000 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316.995 | Vernal Pool Prairie Preserve Area | ||
10592 | 10592 | 10591 | {"type": "Polygon", "coordinates": [[[-121.70684, 37.07901], [-121.70529, 37.07998], [-121.70532, 37.08003], [-121.7054, 37.08006], [-121.69439, 37.08908], [-121.69296, 37.08754], [-121.69287, 37.08753], [-121.69284, 37.08746], [-121.69272, 37.08753], [-121.6919, 37.0865], [-121.69109, 37.08617], [-121.69136, 37.08545], [-121.69189, 37.08417], [-121.69202, 37.08391], [-121.69145, 37.08331], [-121.69157, 37.08238], [-121.6916, 37.08225], [-121.6915, 37.08191], [-121.69166, 37.08042], [-121.69062, 37.07976], [-121.6885, 37.07927], [-121.68643, 37.07936], [-121.68564, 37.07935], [-121.6941, 37.07268], [-121.6941, 37.07264], [-121.6942, 37.07255], [-121.69329, 37.0711], [-121.693, 37.07097], [-121.69298, 37.07094], [-121.69291, 37.07092], [-121.68894, 37.06868], [-121.68749, 37.06792], [-121.68852, 37.0659], [-121.68819, 37.06578], [-121.68803, 37.06488], [-121.68984, 37.0656], [-121.69106, 37.06443], [-121.68984, 37.06384], [-121.69002, 37.06361], [-121.69153, 37.06397], [-121.69758, 37.06659], [-121.69778, 37.06657], [-121.69791, 37.06653], [-121.69803, 37.06656], [-121.69863, 37.06653], [-121.69934, 37.06671], [-121.70001, 37.06711], [-121.70149, 37.06837], [-121.70144, 37.06848], [-121.70136, 37.06889], [-121.70085, 37.06928], [-121.70086, 37.06935], [-121.70133, 37.06971], [-121.70148, 37.07008], [-121.70284, 37.06995], [-121.70251, 37.07023], [-121.70227, 37.0718], [-121.70207, 37.07323], [-121.70256, 37.07405], [-121.70379, 37.07478], [-121.70383, 37.07478], [-121.70579, 37.07602], [-121.70684, 37.07901]]]} | Restricted Access 2 | Uvas Reservoir | 26750 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 637.913 | Uvas Reservoir | ||
14273 | 14273 | 14272 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45596], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 1.452 | |||
10308 | 10308 | 10307 | {"type": "Polygon", "coordinates": [[[-117.6523, 33.73705], [-117.6424, 33.73701], [-117.64238, 33.73346], [-117.64935, 33.7315], [-117.65064, 33.73322], [-117.652, 33.73296], [-117.65104, 33.7339], [-117.6515, 33.73494], [-117.6523, 33.73705]]]} | Restricted Access 2 | Unnamed site - Orange County Department of Education, County of | 28651 | 313 | Orange County Department of Education, County of 751 | County 3 | County Agency - Other 8 | http://www.ocde.us/ | County 3 | 105.775 | |||
14319 | 14319 | 14318 | {"type": "Polygon", "coordinates": [[[-117.90308, 34.64234], [-117.90298, 34.64592], [-117.89442, 34.64592], [-117.89406, 34.64594], [-117.89415, 34.64234], [-117.89864, 34.64232], [-117.90308, 34.64234]]]} | Restricted Access 2 | Unnamed site - Los Angeles, County of | 29046 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 80.517 | |||
14334 | 14334 | 14333 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 19.487 | |||
4282 | 4282 | 4281 | {"type": "Polygon", "coordinates": [[[-121.62329, 36.69175], [-121.62139, 36.69475], [-121.62267, 36.69557], [-121.62305, 36.69583], [-121.62239, 36.69593], [-121.62224, 36.69599], [-121.62208, 36.69612], [-121.62156, 36.69684], [-121.62114, 36.69815], [-121.61922, 36.69881], [-121.61535, 36.69667], [-121.61886, 36.69402], [-121.61838, 36.69346], [-121.61979, 36.69213], [-121.62135, 36.69028], [-121.623, 36.69156], [-121.62329, 36.69175]]]} | Restricted Access 2 | Twin Creeks Golf Course | 32997 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 76.301 | Twin Creeks GC | ||
14177 | 14177 | 14176 | {"type": "Polygon", "coordinates": [[[-116.39879, 33.82366], [-116.39697, 33.82366], [-116.39696, 33.82193], [-116.39701, 33.82189], [-116.39701, 33.82178], [-116.39697, 33.82173], [-116.39696, 33.8216], [-116.39701, 33.82156], [-116.39701, 33.82145], [-116.39697, 33.82139], [-116.39697, 33.82105], [-116.39702, 33.821], [-116.39702, 33.8209], [-116.39697, 33.82084], [-116.39697, 33.8205], [-116.39702, 33.82045], [-116.39701, 33.82033], [-116.39697, 33.82028], [-116.39698, 33.82013], [-116.39701, 33.8201], [-116.39879, 33.8201], [-116.39879, 33.82366]]]} | Restricted Access 2 | Thousand Palms Community Park | 31650 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 16.4 | Thousand Palms Community Park | ||
10296 | 10296 | 10295 | {"type": "Polygon", "coordinates": [[[-121.20529, 38.35592], [-121.20528, 38.35682], [-121.20307, 38.35681], [-121.20308, 38.3559], [-121.20529, 38.35592]]]} | Restricted Access 2 | Terry Parker Et Al | 26269 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 4.818 | Terry Parker Et Al | ||
10113 | 10113 | 10112 | {"type": "MultiPolygon", "coordinates": [[[[-121.24893, 38.67172], [-121.2489, 38.67173], [-121.24889, 38.67164], [-121.24884, 38.67156], [-121.2486, 38.67133], [-121.24893, 38.67133], [-121.24893, 38.67172]]], [[[-121.25125, 38.67334], [-121.25049, 38.67337], [-121.25043, 38.67336], [-121.24934, 38.67255], [-121.24894, 38.67232], [-121.24893, 38.67184], [-121.24905, 38.67183], [-121.24903, 38.67201], [-121.24906, 38.67206], [-121.24937, 38.67222], [-121.24962, 38.67238], [-121.25057, 38.67308], [-121.25063, 38.67309], [-121.25112, 38.67306], [-121.25117, 38.67304], [-121.25125, 38.67298], [-121.25125, 38.67334]]]]} | Restricted Access 2 | Sunrise Recreation/parks District | 26038 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2.065 | Sunrise Rec./parks District | ||
10062 | 10062 | 10061 | {"type": "Polygon", "coordinates": [[[-122.45243, 37.75546], [-122.45204, 37.75657], [-122.45019, 37.75667], [-122.44973, 37.75638], [-122.44965, 37.75628], [-122.4496, 37.75614], [-122.4496, 37.75594], [-122.4499, 37.75586], [-122.45005, 37.75579], [-122.45019, 37.75571], [-122.45027, 37.75565], [-122.45079, 37.75511], [-122.45094, 37.755], [-122.45106, 37.75493], [-122.45121, 37.75487], [-122.45136, 37.75483], [-122.45148, 37.75484], [-122.45154, 37.75481], [-122.45158, 37.75476], [-122.45164, 37.75442], [-122.45206, 37.75443], [-122.45208, 37.75517], [-122.45243, 37.75546]]]} | Restricted Access 2 | Summit Reservoir Water Facilities | 25969 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 9.064 | Summit Reservoir Water Facilities | ||
9987 | 9987 | 9986 | {"type": "Polygon", "coordinates": [[[-121.48774, 38.4088], [-121.48772, 38.40888], [-121.48765, 38.40901], [-121.48756, 38.4091], [-121.48745, 38.40917], [-121.48727, 38.40925], [-121.48678, 38.40939], [-121.48637, 38.40956], [-121.48599, 38.40978], [-121.48562, 38.41006], [-121.48534, 38.41036], [-121.48511, 38.41068], [-121.48492, 38.41107], [-121.48483, 38.4114], [-121.48435, 38.4089], [-121.48598, 38.40887], [-121.48656, 38.40882], [-121.48774, 38.4088]]]} | Restricted Access 2 | Stone Lakes | 25873 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 7.901 | Stone Lakes | ||
9667 | 9667 | 9666 | {"type": "MultiPolygon", "coordinates": [[[[-121.17476, 38.47876], [-121.1741, 38.47839], [-121.17414, 38.47832], [-121.17425, 38.47823], [-121.1744, 38.47819], [-121.17462, 38.47819], [-121.1747, 38.47821], [-121.17479, 38.47825], [-121.17487, 38.47832], [-121.17491, 38.47838], [-121.17494, 38.47845], [-121.17494, 38.47852], [-121.17492, 38.47859], [-121.17488, 38.47866], [-121.17476, 38.47876]]], [[[-121.18136, 38.48039], [-121.17757, 38.48451], [-121.17626, 38.48377], [-121.17616, 38.48373], [-121.1764, 38.48358], [-121.17654, 38.48355], [-121.1767, 38.48368], [-121.17694, 38.48382], [-121.17721, 38.48387], [-121.17772, 38.48405], [-121.17783, 38.48404], [-121.17789, 38.4839], [-121.17787, 38.48366], [-121.17768, 38.48322], [-121.1774, 38.48282], [-121.17692, 38.48233], [-121.17676, 38.4823], [-121.17665, 38.4824], [-121.17654, 38.48285], [-121.17645, 38.48293], [-121.17635, 38.4829], [-121.17613, 38.48274], [-121.17599, 38.48253], [-121.17581, 38.48233], [-121.17552, 38.48218], [-121.17543, 38.48206], [-121.17538, 38.48182], [-121.17528, 38.48159], [-121.17534, 38.48144], [-121.17562, 38.48154], [-121.17575, 38.4815], [-121.17586, 38.4815], [-121.17601, 38.48146], [-121.17606, 38.48133], [-121.1764, 38.48101], [-121.17652, 38.48078], [-121.17658, 38.48057], [-121.17699, 38.48017], [-121.17716, 38.47992], [-121.17721, 38.47974], [-121.17708, 38.47969], [-121.17694, 38.47958], [-121.1769, 38.47949], [-121.17689, 38.47938], [-121.17685, 38.47928], [-121.17671, 38.4792], [-121.17666, 38.47914], [-121.17662, 38.47906], [-121.17661, 38.47899], [-121.17662, 38.47891], [-121.17666, 38.47882], [-121.17673, 38.47874], [-121.17688, 38.47867], [-121.17704, 38.47866], [-121.17717, 38.4787], [-121.17727, 38.47877], [-121.1774, 38.47883], [-121.17747, 38.4789], [-121.17752, 38.47901], [-121.17769, 38.47923], [-121.17773, 38.47937], [-121.17772, 38.47949], [-121.17809, 38.47959], [-121.17837, 38.47932], [-121.17837, 38.47916], [-121.17828, 38.47901], [-121.17802, 38.47876], [-121.1773, 38.47844], [-121.1772, 38.47833], [-121.17718, 38.47824], [-121.17704, 38.47828], [-121.1768, 38.47827], [-121.17663, 38.47821], [-121.1765, 38.47812], [-121.17641, 38.47801], [-121.17635, 38.47792], [-121.17632, 38.47778], [-121.17632, 38.47771], [-121.17635, 38.47764], [-121.17648, 38.47752], [-121.17741, 38.47806], [-121.17735, 38.47817], [-121.1774, 38.47817], [-121.17763, 38.47827], [-121.18136, 38.48039]]]]} | Restricted Access 2 | Silva Et Al | 25480 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 41.219 | Silva Et Al | ||
13703 | 13703 | 13702 | {"type": "Polygon", "coordinates": [[[-119.1606, 34.28232], [-119.16056, 34.28237], [-119.1576, 34.28415], [-119.15732, 34.28384], [-119.15657, 34.2843], [-119.15656, 34.28432], [-119.15682, 34.28462], [-119.15395, 34.28634], [-119.15198, 34.28407], [-119.15253, 34.28373], [-119.15218, 34.28332], [-119.15296, 34.28284], [-119.15581, 34.28113], [-119.15737, 34.28293], [-119.16005, 34.28166], [-119.16058, 34.28227], [-119.1606, 34.28232]]]} | Restricted Access 2 | Saticoy Regional Golf Course | 32989 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 48.983 | Saticoy Reg. GC | ||
15557 | 15557 | 15556 | {"type": "Polygon", "coordinates": [[[-118.65875, 34.07333], [-118.65821, 34.07334], [-118.65819, 34.07327], [-118.65765, 34.07327], [-118.65765, 34.07272], [-118.65785, 34.07272], [-118.65786, 34.0725], [-118.65875, 34.07256], [-118.65875, 34.07333]]]} | Restricted Access 2 | Santa Monica Mountains National Recreation Area | http://www.nps.gov/samo/index.htm | 29657 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 2.047 | Santa Monica Mtns. NRA | |
93 | 93 | 92 | {"type": "Polygon", "coordinates": [[[-118.04347, 34.13092], [-118.04339, 34.13133], [-118.0426, 34.13196], [-118.04287, 34.13232], [-118.04246, 34.13254], [-118.04197, 34.13285], [-118.0416, 34.13314], [-118.04112, 34.13356], [-118.04211, 34.13249], [-118.04222, 34.13228], [-118.04225, 34.13218], [-118.04223, 34.13217], [-118.03927, 34.13536], [-118.03909, 34.13561], [-118.03898, 34.13586], [-118.0383, 34.1366], [-118.03775, 34.13635], [-118.03681, 34.13613], [-118.03624, 34.13619], [-118.03571, 34.13614], [-118.0349, 34.13614], [-118.03405, 34.13627], [-118.03343, 34.13635], [-118.03292, 34.13634], [-118.03259, 34.13625], [-118.03227, 34.13601], [-118.03198, 34.13576], [-118.03151, 34.13565], [-118.03143, 34.1309], [-118.03583, 34.13086], [-118.04244, 34.13075], [-118.04347, 34.13092]], [[-118.04258, 34.13198], [-118.04251, 34.13189], [-118.04241, 34.13199], [-118.04249, 34.13207], [-118.04258, 34.13198]]]} | Restricted Access 2 | Santa Anita Golf Course | 33023 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 130.966 | Santa Anita GC | ||
9227 | 9227 | 9226 | {"type": "Polygon", "coordinates": [[[-122.1385, 37.48163], [-122.13828, 37.48212], [-122.13754, 37.48296], [-122.13725, 37.48334], [-122.13641, 37.48427], [-122.13358, 37.48639], [-122.13244, 37.48637], [-122.12668, 37.4898], [-122.12636, 37.48978], [-122.12589, 37.4898], [-122.1259, 37.48918], [-122.12601, 37.48639], [-122.12719, 37.48574], [-122.12827, 37.48519], [-122.13007, 37.48435], [-122.13119, 37.48389], [-122.13088, 37.48337], [-122.13108, 37.4829], [-122.13274, 37.48232], [-122.13331, 37.48261], [-122.1338, 37.48271], [-122.13422, 37.48259], [-122.13498, 37.48243], [-122.13544, 37.48231], [-122.13606, 37.48227], [-122.13669, 37.48211], [-122.13741, 37.48183], [-122.1385, 37.48163]]]} | Restricted Access 2 | San Mateo Properties | 24954 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 94.819 | San Mateo Properties | 1930 |
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]);