superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 3 and YR_EST = 2019
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, MNG_AG_ID, MNG_AG_LEV, AGNCY_WEB, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
887 | 887 | 886 | {"type": "Polygon", "coordinates": [[[-122.3147, 37.2008], [-122.3146, 37.20787], [-122.29692, 37.20784], [-122.29705, 37.20079], [-122.3147, 37.2008]]]} | No Public Access 3 | Gazos Creek Redwoods | 32791 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 303.493 | Gazos Creek Redwoods | 2019 | |
14211 | 14211 | 14210 | {"type": "Polygon", "coordinates": [[[-119.26746, 38.0173], [-119.26604, 38.01765], [-119.2661, 38.02012], [-119.26378, 38.02017], [-119.26375, 38.01876], [-119.26369, 38.01876], [-119.26184, 38.01544], [-119.26395, 38.01469], [-119.26413, 38.01498], [-119.26414, 38.01497], [-119.26391, 38.01438], [-119.26612, 38.01383], [-119.26746, 38.0173]]]} | No Public Access 3 | Upper Lundy Lake | https://wildernesslandtrust.org/ | 33768 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 49.362 | Upper Lundy Lake | 2019 |
14212 | 14212 | 14211 | {"type": "MultiPolygon", "coordinates": [[[[-118.82069, 38.08273], [-118.82054, 38.09732], [-118.81189, 38.09727], [-118.81223, 38.0826], [-118.82069, 38.08273]]], [[[-118.87556, 38.16989], [-118.86641, 38.16985], [-118.85724, 38.16984], [-118.85689, 38.16263], [-118.8752, 38.16264], [-118.87556, 38.16989]]], [[[-118.88403, 38.15542], [-118.87029, 38.15541], [-118.87027, 38.14451], [-118.87944, 38.14448], [-118.87945, 38.1481], [-118.88402, 38.14809], [-118.88403, 38.15542]]]]} | No Public Access 3 | Bodie Wilderness Study Area | https://wildernesslandtrust.org/ | 33769 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 940.53 | Bodie Wilderness Study Area | 2019 |
14442 | 14442 | 14441 | {"type": "Polygon", "coordinates": [[[-119.08127, 38.33235], [-119.08003, 38.33237], [-119.06214, 38.33233], [-119.06226, 38.32142], [-119.06691, 38.32144], [-119.06684, 38.3177], [-119.08127, 38.31766], [-119.08127, 38.33235]]]} | No Public Access 3 | Flying M Ranch | https://wildernesslandtrust.org/ | 33745 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 628.874 | Flying M Ranch | 2019 |
14447 | 14447 | 14446 | {"type": "Polygon", "coordinates": [[[-121.77698, 37.19018], [-121.77606, 37.19071], [-121.77474, 37.19393], [-121.77467, 37.19393], [-121.77461, 37.19397], [-121.77404, 37.19385], [-121.77291, 37.19382], [-121.77018, 37.19433], [-121.76547, 37.19019], [-121.76591, 37.18769], [-121.76748, 37.18612], [-121.76883, 37.18636], [-121.7694, 37.18663], [-121.76982, 37.18699], [-121.77041, 37.18722], [-121.77089, 37.18757], [-121.77138, 37.18806], [-121.77205, 37.18841], [-121.77271, 37.18868], [-121.77352, 37.18889], [-121.77487, 37.18905], [-121.77558, 37.18925], [-121.77597, 37.18908], [-121.77698, 37.19018]]]} | No Public Access 3 | Calero Lakeview | 33758 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 136.152 | Calero Lakeview | 2019 | |
14449 | 14449 | 14448 | {"type": "Polygon", "coordinates": [[[-122.19844, 37.08505], [-122.19589, 37.09598], [-122.18131, 37.09355], [-122.18161, 37.09318], [-122.18191, 37.09258], [-122.18188, 37.09228], [-122.18217, 37.09181], [-122.18315, 37.09157], [-122.18419, 37.09108], [-122.18439, 37.08985], [-122.18596, 37.08895], [-122.18583, 37.08726], [-122.18513, 37.08703], [-122.18457, 37.0866], [-122.18408, 37.085], [-122.18439, 37.08286], [-122.19844, 37.08505]]]} | No Public Access 3 | Filice Ranch | 33761 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 358.112 | Filice Ranch | 2019 | |
14452 | 14452 | 14451 | {"type": "MultiPolygon", "coordinates": [[[[-119.13528, 38.16303], [-119.13526, 38.17024], [-119.1261, 38.17018], [-119.12606, 38.1738], [-119.12147, 38.17378], [-119.1214, 38.18101], [-119.11686, 38.181], [-119.11697, 38.17014], [-119.1215, 38.17014], [-119.12148, 38.16654], [-119.1219, 38.16675], [-119.12224, 38.16696], [-119.12246, 38.16712], [-119.12263, 38.16729], [-119.1228, 38.16755], [-119.12322, 38.16839], [-119.12351, 38.16892], [-119.12372, 38.16914], [-119.12389, 38.16928], [-119.1243, 38.16946], [-119.12455, 38.16952], [-119.12505, 38.16955], [-119.12531, 38.16948], [-119.12559, 38.1694], [-119.12724, 38.16864], [-119.12793, 38.16827], [-119.12902, 38.16759], [-119.12944, 38.16743], [-119.12995, 38.16729], [-119.13039, 38.1671], [-119.13076, 38.16682], [-119.13131, 38.16619], [-119.13161, 38.16595], [-119.1322, 38.16561], [-119.13249, 38.16547], [-119.13282, 38.16523], [-119.13528, 38.16303]]], [[[-119.13078, 38.13756], [-119.13069, 38.14481], [-119.12151, 38.14476], [-119.12161, 38.13753], [-119.11706, 38.13751], [-119.11716, 38.13028], [-119.1263, 38.1303], [-119.1262, 38.13753], [-119.13078, 38.13756]]], [[[-119.15351, 38.1593], [-119.15349, 38.1643], [-119.15309, 38.16441], [-119.15247, 38.16469], [-119.15217, 38.16481], [-119.15192, 38.16485], [-119.15166, 38.16483], [-119.15127, 38.16475], [-119.15084, 38.16462], [-119.15041, 38.16439], [-119.15011, 38.16413], [-119.14986, 38.16383], [-119.14956, 38.16355], [-119.14923, 38.16333], [-119.14888, 38.16316], [-119.14842, 38.16296], [-119.148, 38.16283], [-119.14761, 38.16275], [-119.14675, 38.16264], [-119.14611, 38.16249], [-119.1456, 38.16228], [-119.14539, 38.16218], [-119.14495, 38.16188], [-119.14471, 38.16178], [-119.14402, 38.16162], [-119.14324, 38.16138], [-119.14254, 38.16113], [-119.14185, 38.1608], [-119.14143, 38.16063], [-119.14047, 38.16042], [-119.14004, 38.16036], [-119.13964, 38.16033], [-119.13921, 38.16034], [-119.13875, 38.16037], [-119.13808, 38.16045], [-119.13779, 38.16053], [-119.13732, 38.16075], [-119.13708, 38.16096], [-119.13669, 38.1614], [-119.13628, 38.16179], [-119.13608, 38.16196], [-119.13535, 38.16264], [-119.13319, 38.16455], [-119.13284, 38.16489], [-119.13262, 38.16508], [-119.13232, 38.16529], [-119.13204, 38.16543], [-119.13142, 38.16579], [-119.1311, 38.16605], [-119.13055, 38.16668], [-119.13022, 38.16693], [-119.12984, 38.16709], [-119.12933, 38.16723], [-119.12888, 38.1674], [-119.12777, 38.16809], [-119.12708, 38.16845], [-119.12547, 38.1692], [-119.12502, 38.16933], [-119.12459, 38.1693], [-119.12441, 38.16926], [-119.12407, 38.16911], [-119.12393, 38.169], [-119.12375, 38.16882], [-119.12348, 38.1683], [-119.12306, 38.16746], [-119.12287, 38.16717], [-119.12265, 38.16696], [-119.12207, 38.16658], [-119.12197, 38.16652], [-119.12606, 38.16655], [-119.12604, 38.16293], [-119.13062, 38.16295], [-119.1306, 38.15934], [-119.13978, 38.1594], [-119.15351, 38.1593]]], [[[-119.15348, 38.16453], [-119.15347, 38.16654], [-119.1444, 38.16658], [-119.14437, 38.16296], [-119.1398, 38.16302], [-119.13533, 38.16299], [-119.13671, 38.16173], [-119.1373, 38.1611], [-119.1375, 38.16092], [-119.13791, 38.16073], [-119.13815, 38.16067], [-119.13846, 38.16062], [-119.13923, 38.16055], [-119.13963, 38.16055], [-119.14, 38.16057], [-119.14041, 38.16063], [-119.14133, 38.16083], [-119.14171, 38.16099], [-119.14241, 38.16132], [-119.14313, 38.16158], [-119.14393, 38.16183], [-119.1446, 38.16199], [-119.1448, 38.16207], [-119.14524, 38.16236], [-119.14546, 38.16248], [-119.146, 38.16269], [-119.14669, 38.16285], [-119.14756, 38.16297], [-119.14792, 38.16304], [-119.14831, 38.16316], [-119.14874, 38.16335], [-119.14907, 38.16351], [-119.14937, 38.16371], [-119.14964, 38.16397], [-119.1499, 38.16427], [-119.15022, 38.16454], [-119.15073, 38.16482], [-119.15118, 38.16496], [-119.15161, 38.16504], [-119.15195, 38.16507], [-119.15228, 38.16501], [-119.1526, 38.16489], [-119.1532, 38.16461], [-119.15348, 38.16453]]]]} | No Public Access 3 | Mormon Meadows | https://wildernesslandtrust.org/ | 33767 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 934.973 | Mormon Meadows | 2019 |
15130 | 15130 | 15129 | {"type": "MultiPolygon", "coordinates": [[[[-121.96819, 37.97315], [-121.96792, 37.97337], [-121.96771, 37.97352], [-121.96741, 37.97369], [-121.96718, 37.9738], [-121.96144, 37.97591], [-121.96093, 37.97613], [-121.96063, 37.97632], [-121.95394, 37.98082], [-121.95365, 37.98098], [-121.95276, 37.98141], [-121.95259, 37.98152], [-121.95245, 37.98166], [-121.95234, 37.98181], [-121.95228, 37.98197], [-121.95225, 37.98215], [-121.95226, 37.98228], [-121.95229, 37.9824], [-121.95235, 37.98253], [-121.95251, 37.98279], [-121.95259, 37.98316], [-121.95254, 37.98366], [-121.95238, 37.98411], [-121.95187, 37.98476], [-121.95185, 37.98489], [-121.95179, 37.98503], [-121.95175, 37.98523], [-121.95169, 37.98588], [-121.95165, 37.98601], [-121.95162, 37.98632], [-121.95151, 37.98667], [-121.95124, 37.98704], [-121.93914, 37.97988], [-121.93914, 37.9716], [-121.94048, 37.96768], [-121.94552, 37.96345], [-121.94855, 37.96307], [-121.95269, 37.96447], [-121.95349, 37.96501], [-121.95518, 37.96584], [-121.95556, 37.96638], [-121.95649, 37.96675], [-121.95688, 37.96703], [-121.95717, 37.96715], [-121.95749, 37.96718], [-121.95808, 37.96705], [-121.95893, 37.96768], [-121.95921, 37.96766], [-121.95901, 37.96816], [-121.95854, 37.96857], [-121.95854, 37.96858], [-121.96076, 37.97003], [-121.96122, 37.97051], [-121.9639, 37.97284], [-121.96754, 37.973], [-121.96819, 37.97315]]], [[[-121.99781, 38.00868], [-121.9971, 38.01085], [-121.99703, 38.01085], [-121.99695, 38.01109], [-121.99692, 38.0111], [-121.99652, 38.01104], [-121.99628, 38.01104], [-121.99603, 38.01105], [-121.99572, 38.0111], [-121.99549, 38.01116], [-121.9952, 38.01126], [-121.99492, 38.0114], [-121.99474, 38.01152], [-121.99451, 38.01171], [-121.99432, 38.01191], [-121.99303, 38.01354], [-121.99295, 38.01375], [-121.99216, 38.01458], [-121.9904, 38.01478], [-121.98772, 38.01583], [-121.96871, 37.99738], [-121.9514, 37.98714], [-121.95163, 37.98688], [-121.95172, 37.98674], [-121.95179, 37.98658], [-121.95186, 37.98631], [-121.95191, 37.9858], [-121.95193, 37.98573], [-121.95198, 37.98528], [-121.95213, 37.9849], [-121.95238, 37.98472], [-121.95261, 37.98437], [-121.95262, 37.98417], [-121.95272, 37.9839], [-121.95283, 37.98343], [-121.95285, 37.98318], [-121.9528, 37.98294], [-121.95272, 37.98276], [-121.95252, 37.98242], [-121.95247, 37.98227], [-121.95246, 37.98215], [-121.95247, 37.98203], [-121.95255, 37.98185], [-121.95265, 37.98171], [-121.95283, 37.98157], [-121.95376, 37.98112], [-121.95414, 37.9809], [-121.96076, 37.97644], [-121.96103, 37.97628], [-121.96226, 37.97633], [-121.96351, 37.9763], [-121.96527, 37.97638], [-121.96611, 37.97652], [-121.96659, 37.97666], [-121.96688, 37.9768], [-121.96709, 37.97692], [-121.9674, 37.97715], [-121.96801, 37.97773], [-121.96869, 37.97735], [-121.96963, 37.97587], [-121.97008, 37.97606], [-121.97034, 37.97639], [-121.97058, 37.9766], [-121.97089, 37.97697], [-121.97086, 37.97711], [-121.9709, 37.97729], [-121.97111, 37.97754], [-121.97113, 37.9778], [-121.97108, 37.97796], [-121.97081, 37.97796], [-121.97079, 37.97851], [-121.9707, 37.9791], [-121.9717, 37.97942], [-121.97243, 37.97979], [-121.97247, 37.97986], [-121.97214, 37.98039], [-121.97152, 37.98099], [-121.97133, 37.98123], [-121.97113, 37.98165], [-121.97099, 37.98176], [-121.9706, 37.98254], [-121.97055, 37.98271], [-121.97056, 37.98285], [-121.9706, 37.98295], [-121.97068, 37.98308], [-121.97077, 37.98316], [-121.97088, 37.98323], [-121.97099, 37.98328], [-121.97133, 37.98335], [-121.97133, 37.98344], [-121.97136, 37.98351], [-121.97211, 37.98492], [-121.97218, 37.98509], [-121.97235, 37.98519], [-121.97252, 37.98496], [-121.97222, 37.9847], [-121.97157, 37.98348], [-121.97159, 37.98345], [-121.9719, 37.98363], [-121.97219, 37.9837], [-121.97235, 37.98403], [-121.9725, 37.98423], [-121.97266, 37.98437], [-121.97298, 37.98457], [-121.97335, 37.98489], [-121.97365, 37.98547], [-121.97371, 37.98574], [-121.97374, 37.98583], [-121.97395, 37.98608], [-121.97422, 37.98616], [-121.97445, 37.98617], [-121.97457, 37.98615], [-121.97477, 37.98608], [-121.97492, 37.98597], [-121.97496, 37.98602], [-121.97498, 37.98615], [-121.97484, 37.98668], [-121.97495, 37.98683], [-121.97504, 37.98691], [-121.97515, 37.98696], [-121.97563, 37.98712], [-121.97576, 37.98714], [-121.97597, 37.98713], [-121.97618, 37.98705], [-121.97651, 37.98704], [-121.9766, 37.98721], [-121.97703, 37.98766], [-121.97746, 37.98795], [-121.97798, 37.98808], [-121.9786, 37.98814], [-121.97919, 37.98842], [-121.97926, 37.98855], [-121.97969, 37.98883], [-121.97984, 37.98889], [-121.98007, 37.98877], [-121.98013, 37.9887], [-121.98051, 37.98881], [-121.98046, 37.98917], [-121.98047, 37.98928], [-121.9805, 37.98938], [-121.98056, 37.98949], [-121.98064, 37.98958], [-121.98077, 37.98968], [-121.98089, 37.98974], [-121.98111, 37.98981], [-121.98139, 37.98981], [-121.98182, 37.98963], [-121.98222, 37.98972], [-121.98264, 37.99022], [-121.98319, 37.99064], [-121.98302, 37.99113], [-121.98314, 37.99139], [-121.98316, 37.99177], [-121.98324, 37.99202], [-121.98339, 37.9924], [-121.98354, 37.99258], [-121.9837, 37.9927], [-121.98444, 37.99317], [-121.98473, 37.99345], [-121.98495, 37.99387], [-121.9852, 37.99424], [-121.98533, 37.99438], [-121.98554, 37.99452], [-121.98596, 37.99466], [-121.98643, 37.99476], [-121.98666, 37.99477], [-121.98683, 37.99482], [-121.98685, 37.99487], [-121.98695, 37.99481], [-121.98764, 37.99504], [-121.98781, 37.99505], [-121.98809, 37.99502], [-121.98852, 37.99505], [-121.98883, 37.99501], [-121.9878, 37.99775], [-121.98801, 37.99832], [-121.98857, 37.99946], [-121.98924, 38.00038], [-121.98988, 38.00106], [-121.99044, 38.00195], [-121.99085, 38.0025], [-121.99136, 38.00283], [-121.99268, 38.00346], [-121.99265, 38.00375], [-121.99288, 38.00377], [-121.99291, 38.00358], [-121.99364, 38.00396], [-121.99425, 38.00623], [-121.99277, 38.00685], [-121.99226, 38.00758], [-121.9918, 38.00787], [-121.99061, 38.00794], [-121.99012, 38.00769], [-121.98971, 38.00741], [-121.98936, 38.00697], [-121.98873, 38.0065], [-121.98803, 38.00489], [-121.98734, 38.00583], [-121.98926, 38.00726], [-121.98955, 38.00766], [-121.99041, 38.00811], [-121.99115, 38.00821], [-121.99144, 38.00835], [-121.99241, 38.00773], [-121.99342, 38.00749], [-121.99448, 38.00649], [-121.99659, 38.00754], [-121.99756, 38.00863], [-121.99781, 38.00868]], [[-121.98279, 37.99643], [-121.98236, 37.99557], [-121.98228, 37.99546], [-121.98156, 37.99483], [-121.98144, 37.99478], [-121.98052, 37.99451], [-121.98047, 37.99447], [-121.98005, 37.99393], [-121.97969, 37.9925], [-121.97964, 37.99241], [-121.97907, 37.9917], [-121.97873, 37.99046], [-121.97869, 37.99038], [-121.97758, 37.98903], [-121.97562, 37.98747], [-121.97463, 37.98685], [-121.97482, 37.98669], [-121.97482, 37.98667], [-121.97264, 37.98559], [-121.97204, 37.98527], [-121.97197, 37.98536], [-121.97198, 37.98538], [-121.9745, 37.98696], [-121.9745, 37.98698], [-121.97545, 37.98757], [-121.97743, 37.98915], [-121.97853, 37.99051], [-121.97887, 37.99175], [-121.9795, 37.99255], [-121.97982, 37.99391], [-121.97988, 37.99403], [-121.9803, 37.99455], [-121.98038, 37.99463], [-121.98052, 37.99469], [-121.98144, 37.99496], [-121.98212, 37.99556], [-121.98217, 37.99563], [-121.98272, 37.99673], [-121.9852, 37.99886], [-121.98615, 38.00003], [-121.98621, 38.00011], [-121.98684, 38.00138], [-121.98703, 38.00264], [-121.98701, 38.00285], [-121.98716, 38.00363], [-121.9878, 38.005], [-121.98782, 38.00501], [-121.98794, 38.00483], [-121.98739, 38.00364], [-121.98705, 38.00135], [-121.98639, 38.00002], [-121.98536, 37.99876], [-121.98292, 37.99666], [-121.98288, 37.99662], [-121.98279, 37.99643]]]]} | No Public Access 3 | Concord Hills Regional Park | https://www.ebparks.org/parks/concord_hills/ | 33747 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2544.356 | Concord Hills RP | 2019 |
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]);