superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where LABEL_NAME = "Año Nuevo SP"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12556 | 12556 | 12555 | {"type": "Polygon", "coordinates": [[[-122.33871, 37.12078], [-122.33869, 37.12105], [-122.33865, 37.12119], [-122.3386, 37.12133], [-122.3384, 37.12172], [-122.33836, 37.12186], [-122.33837, 37.122], [-122.3384, 37.12213], [-122.33842, 37.12227], [-122.33842, 37.12255], [-122.33839, 37.12275], [-122.33828, 37.12302], [-122.3383, 37.12316], [-122.33826, 37.12344], [-122.33821, 37.12357], [-122.33818, 37.12372], [-122.33808, 37.12399], [-122.3381, 37.12414], [-122.33801, 37.12441], [-122.33799, 37.12469], [-122.33794, 37.12483], [-122.33783, 37.12566], [-122.3378, 37.12581], [-122.33783, 37.12595], [-122.33781, 37.12609], [-122.33785, 37.12665], [-122.3378, 37.12678], [-122.33777, 37.1272], [-122.33769, 37.12748], [-122.33759, 37.12789], [-122.33755, 37.12803], [-122.33755, 37.12816], [-122.33748, 37.12844], [-122.33744, 37.12872], [-122.33742, 37.12901], [-122.33738, 37.12928], [-122.33739, 37.12942], [-122.33729, 37.12971], [-122.33729, 37.12999], [-122.33725, 37.13013], [-122.33725, 37.13027], [-122.3373, 37.1304], [-122.33733, 37.13068], [-122.33743, 37.13124], [-122.33743, 37.13139], [-122.3375, 37.13166], [-122.33751, 37.1318], [-122.33755, 37.13194], [-122.33768, 37.13219], [-122.33772, 37.13233], [-122.33774, 37.13247], [-122.33772, 37.13275], [-122.33774, 37.13289], [-122.33769, 37.13317], [-122.3377, 37.13331], [-122.33759, 37.13387], [-122.3377, 37.13428], [-122.33784, 37.13452], [-122.33808, 37.13506], [-122.33812, 37.13533], [-122.33823, 37.13545], [-122.33827, 37.13559], [-122.33837, 37.13574], [-122.33782, 37.1359], [-122.33754, 37.13615], [-122.33721, 37.13637], [-122.33717, 37.13651], [-122.33708, 37.1366], [-122.33691, 37.13662], [-122.3367, 37.13657], [-122.33653, 37.13663], [-122.33631, 37.13684], [-122.33614, 37.13703], [-122.33614, 37.13714], [-122.33612, 37.13722], [-122.33602, 37.13727], [-122.3356, 37.13722], [-122.33537, 37.13723], [-122.33516, 37.13732], [-122.33502, 37.13734], [-122.33464, 37.13748], [-122.33438, 37.13764], [-122.33402, 37.13768], [-122.33367, 37.13763], [-122.33353, 37.13767], [-122.33339, 37.13769], [-122.33328, 37.13777], [-122.33283, 37.13793], [-122.33259, 37.13804], [-122.33251, 37.13803], [-122.33247, 37.13613], [-122.33432, 37.1352], [-122.33029, 37.12878], [-122.31617, 37.13441], [-122.31223, 37.12991], [-122.3293, 37.12312], [-122.32533, 37.11844], [-122.32185, 37.11978], [-122.3192, 37.1165], [-122.31935, 37.11634], [-122.31944, 37.11622], [-122.31985, 37.11595], [-122.32002, 37.11593], [-122.32019, 37.11593], [-122.32072, 37.11602], [-122.32123, 37.11595], [-122.32158, 37.11601], [-122.32178, 37.11603], [-122.32193, 37.11596], [-122.3221, 37.11592], [-122.32243, 37.11583], [-122.3226, 37.11582], [-122.32271, 37.11572], [-122.32287, 37.11566], [-122.323, 37.11557], [-122.32339, 37.11509], [-122.32369, 37.11493], [-122.32396, 37.11477], [-122.32428, 37.11467], [-122.32444, 37.1146], [-122.32477, 37.11453], [-122.32495, 37.11446], [-122.32509, 37.11438], [-122.32536, 37.1142], [-122.32581, 37.11397], [-122.32609, 37.11379], [-122.32658, 37.11363], [-122.32675, 37.11361], [-122.32723, 37.11343], [-122.3274, 37.11335], [-122.32758, 37.11331], [-122.32787, 37.11317], [-122.32801, 37.11308], [-122.32831, 37.11295], [-122.32858, 37.11274], [-122.32873, 37.11268], [-122.32887, 37.11258], [-122.32897, 37.11247], [-122.32912, 37.11239], [-122.32929, 37.11238], [-122.32942, 37.11247], [-122.32951, 37.11274], [-122.3295, 37.11289], [-122.32965, 37.11314], [-122.32971, 37.11328], [-122.3297, 37.11356], [-122.32975, 37.11383], [-122.32973, 37.11397], [-122.32982, 37.11424], [-122.3299, 37.11437], [-122.33008, 37.11461], [-122.33042, 37.11494], [-122.33066, 37.1153], [-122.33077, 37.11542], [-122.33104, 37.1158], [-122.33141, 37.11613], [-122.33149, 37.11625], [-122.33161, 37.11636], [-122.3318, 37.11658], [-122.33209, 37.11675], [-122.33221, 37.11687], [-122.33225, 37.11689], [-122.33289, 37.11736], [-122.33378, 37.11765], [-122.33429, 37.11775], [-122.33523, 37.11803], [-122.33571, 37.11791], [-122.33626, 37.1176], [-122.33702, 37.11762], [-122.33722, 37.11744], [-122.33732, 37.11756], [-122.33749, 37.1178], [-122.33761, 37.1179], [-122.3377, 37.11803], [-122.338, 37.11838], [-122.33806, 37.11851], [-122.33814, 37.11879], [-122.3382, 37.11892], [-122.33828, 37.11904], [-122.3384, 37.11915], [-122.33848, 37.11928], [-122.33852, 37.11942], [-122.33843, 37.1197], [-122.33841, 37.11998], [-122.33842, 37.12011], [-122.33851, 37.12039], [-122.33859, 37.12052], [-122.33871, 37.12078]]]} | Restricted Access 2 | Año Nuevo State Park | http://www.parks.ca.gov/?page_id=523 | 31225 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 706.44 | Año Nuevo SP | 1985 |
15280 | 15280 | 15279 | {"type": "MultiPolygon", "coordinates": [[[[-122.32185, 37.11978], [-122.30864, 37.12491], [-122.3072, 37.12226], [-122.30645, 37.12117], [-122.30636, 37.12046], [-122.30519, 37.11896], [-122.30414, 37.11695], [-122.30418, 37.11689], [-122.30424, 37.11685], [-122.3045, 37.11677], [-122.30527, 37.11646], [-122.30533, 37.11645], [-122.30541, 37.1165], [-122.30593, 37.11725], [-122.30594, 37.11732], [-122.30614, 37.11732], [-122.30614, 37.1172], [-122.30592, 37.11688], [-122.30603, 37.11691], [-122.30611, 37.11679], [-122.30589, 37.11658], [-122.30612, 37.11627], [-122.30614, 37.11604], [-122.30588, 37.11571], [-122.30607, 37.11546], [-122.30619, 37.11552], [-122.30644, 37.11572], [-122.30693, 37.11589], [-122.30708, 37.11597], [-122.3074, 37.11608], [-122.30773, 37.11616], [-122.30789, 37.11623], [-122.30822, 37.11634], [-122.30905, 37.11656], [-122.30935, 37.11673], [-122.30968, 37.11684], [-122.31003, 37.1169], [-122.31035, 37.117], [-122.31053, 37.11701], [-122.3107, 37.11707], [-122.31105, 37.11713], [-122.31119, 37.1172], [-122.31153, 37.11729], [-122.31168, 37.11735], [-122.31203, 37.11743], [-122.31236, 37.11753], [-122.31254, 37.11756], [-122.31269, 37.11764], [-122.31285, 37.11769], [-122.31336, 37.11783], [-122.31354, 37.11781], [-122.31371, 37.11785], [-122.31388, 37.11785], [-122.31405, 37.11787], [-122.31412, 37.11775], [-122.3141, 37.11761], [-122.31411, 37.11748], [-122.31423, 37.11737], [-122.31438, 37.11743], [-122.31451, 37.11753], [-122.31468, 37.11752], [-122.31468, 37.11739], [-122.31462, 37.11725], [-122.31462, 37.11712], [-122.31484, 37.1169], [-122.31487, 37.11676], [-122.31497, 37.11665], [-122.31505, 37.11653], [-122.3153, 37.11634], [-122.31537, 37.11621], [-122.31553, 37.11615], [-122.3157, 37.11621], [-122.31563, 37.11633], [-122.31538, 37.11654], [-122.31529, 37.11667], [-122.31534, 37.11679], [-122.31543, 37.1169], [-122.31559, 37.11696], [-122.31576, 37.11695], [-122.31592, 37.11689], [-122.31607, 37.11681], [-122.31624, 37.11682], [-122.3165, 37.11701], [-122.31667, 37.11704], [-122.31684, 37.11703], [-122.317, 37.11707], [-122.31717, 37.11705], [-122.31735, 37.11705], [-122.31769, 37.11701], [-122.31781, 37.11691], [-122.31782, 37.11664], [-122.31793, 37.11652], [-122.31809, 37.11648], [-122.31805, 37.11675], [-122.31817, 37.11684], [-122.31834, 37.11685], [-122.3185, 37.1168], [-122.31861, 37.11669], [-122.31866, 37.11655], [-122.31877, 37.11645], [-122.31883, 37.11647], [-122.31889, 37.11673], [-122.31903, 37.11666], [-122.3192, 37.1165], [-122.32185, 37.11978]]], [[[-122.34809, 37.18457], [-122.34803, 37.18462], [-122.34794, 37.18473], [-122.34777, 37.18498], [-122.34755, 37.1852], [-122.3473, 37.18539], [-122.34713, 37.18545], [-122.34679, 37.18552], [-122.34609, 37.1856], [-122.34594, 37.18567], [-122.34583, 37.18577], [-122.34575, 37.18589], [-122.34541, 37.18621], [-122.34526, 37.18628], [-122.34489, 37.18628], [-122.34454, 37.18623], [-122.34437, 37.18624], [-122.34402, 37.18629], [-122.34384, 37.18627], [-122.34351, 37.18618], [-122.34322, 37.18603], [-122.3431, 37.18593], [-122.34278, 37.18559], [-122.34262, 37.18552], [-122.34246, 37.18551], [-122.34229, 37.18555], [-122.342, 37.1857], [-122.34167, 37.18579], [-122.3415, 37.18579], [-122.34132, 37.18577], [-122.34116, 37.18572], [-122.34099, 37.18569], [-122.34065, 37.18569], [-122.34035, 37.18584], [-122.34019, 37.1859], [-122.34001, 37.18592], [-122.33965, 37.18587], [-122.33948, 37.1859], [-122.3393, 37.18591], [-122.33879, 37.18579], [-122.33862, 37.18579], [-122.33827, 37.18581], [-122.33811, 37.18576], [-122.33796, 37.18569], [-122.33779, 37.18565], [-122.33761, 37.18564], [-122.33708, 37.18573], [-122.33691, 37.18572], [-122.33674, 37.18569], [-122.33649, 37.18549], [-122.33638, 37.18538], [-122.33618, 37.185], [-122.33596, 37.18479], [-122.33582, 37.18471], [-122.33565, 37.18468], [-122.33548, 37.18468], [-122.33531, 37.1847], [-122.33515, 37.18475], [-122.33485, 37.1849], [-122.33473, 37.18501], [-122.33446, 37.18517], [-122.3343, 37.18523], [-122.33412, 37.18523], [-122.33377, 37.1852], [-122.3336, 37.18521], [-122.33328, 37.1853], [-122.33224, 37.18537], [-122.33122, 37.18562], [-122.33091, 37.18576], [-122.33066, 37.18595], [-122.33043, 37.18617], [-122.33018, 37.18638], [-122.32987, 37.18671], [-122.32975, 37.18681], [-122.32947, 37.18698], [-122.32931, 37.18703], [-122.32913, 37.18703], [-122.32879, 37.18697], [-122.32862, 37.18696], [-122.32844, 37.187], [-122.32797, 37.18718], [-122.3278, 37.18721], [-122.32763, 37.18726], [-122.32703, 37.18756], [-122.32685, 37.18761], [-122.32669, 37.18767], [-122.32657, 37.18776], [-122.32623, 37.18808], [-122.32609, 37.18817], [-122.32579, 37.18829], [-122.32565, 37.18839], [-122.3252, 37.18881], [-122.32499, 37.18886], [-122.32483, 37.18899], [-122.32451, 37.18933], [-122.32415, 37.18965], [-122.3239, 37.18984], [-122.32349, 37.1901], [-122.32331, 37.19034], [-122.32325, 37.19047], [-122.32321, 37.19061], [-122.3232, 37.19075], [-122.32322, 37.19089], [-122.32328, 37.19102], [-122.32368, 37.19148], [-122.32376, 37.19176], [-122.32389, 37.19202], [-122.32415, 37.19238], [-122.32422, 37.19251], [-122.32423, 37.19266], [-122.32421, 37.1928], [-122.32415, 37.19293], [-122.32384, 37.19327], [-122.32359, 37.19347], [-122.32332, 37.19365], [-122.32321, 37.19376], [-122.32307, 37.19385], [-122.32291, 37.19393], [-122.32268, 37.19411], [-122.32252, 37.1942], [-122.32219, 37.1943], [-122.32152, 37.19448], [-122.32136, 37.19455], [-122.32104, 37.19463], [-122.32093, 37.1947], [-122.31803, 37.19179], [-122.31723, 37.18673], [-122.31482, 37.17018], [-122.31417, 37.16565], [-122.31149, 37.14728], [-122.30637, 37.13942], [-122.31567, 37.13466], [-122.31577, 37.13477], [-122.31315, 37.13614], [-122.31506, 37.1383], [-122.31499, 37.13836], [-122.31556, 37.13899], [-122.31581, 37.13892], [-122.31602, 37.1392], [-122.3163, 37.13937], [-122.31672, 37.13976], [-122.31613, 37.14006], [-122.31591, 37.13998], [-122.31475, 37.13998], [-122.31468, 37.14019], [-122.3145, 37.14049], [-122.3138, 37.14092], [-122.31345, 37.14143], [-122.31418, 37.14212], [-122.31676, 37.14512], [-122.31671, 37.14585], [-122.31718, 37.14573], [-122.31721, 37.14596], [-122.31753, 37.14616], [-122.3181, 37.14764], [-122.31681, 37.14961], [-122.31745, 37.15077], [-122.32175, 37.15096], [-122.32731, 37.15387], [-122.3282, 37.1531], [-122.32932, 37.14692], [-122.32654, 37.1442], [-122.32714, 37.14347], [-122.32741, 37.14284], [-122.3331, 37.14478], [-122.34112, 37.14743], [-122.34154, 37.14754], [-122.34232, 37.1478], [-122.34372, 37.14819], [-122.34454, 37.14847], [-122.34317, 37.15008], [-122.34229, 37.15047], [-122.34179, 37.15088], [-122.33934, 37.15193], [-122.3387, 37.15203], [-122.33854, 37.15183], [-122.33769, 37.15036], [-122.33695, 37.14877], [-122.33362, 37.15059], [-122.33497, 37.1527], [-122.33268, 37.15468], [-122.33238, 37.15388], [-122.33144, 37.15461], [-122.33327, 37.15775], [-122.33148, 37.15854], [-122.33171, 37.15945], [-122.3363, 37.15998], [-122.33786, 37.16206], [-122.33987, 37.1615], [-122.34237, 37.16496], [-122.34367, 37.16464], [-122.34461, 37.16038], [-122.34583, 37.16042], [-122.34604, 37.16188], [-122.34484, 37.16395], [-122.34441, 37.16668], [-122.34429, 37.16713], [-122.34432, 37.16779], [-122.34438, 37.16818], [-122.34461, 37.16907], [-122.34459, 37.16931], [-122.34475, 37.16954], [-122.34491, 37.17009], [-122.34559, 37.17076], [-122.34561, 37.17126], [-122.34523, 37.17257], [-122.34512, 37.17322], [-122.34484, 37.17411], [-122.34476, 37.1751], [-122.34489, 37.1755], [-122.34514, 37.17594], [-122.3457, 37.1784], [-122.34643, 37.18238], [-122.34686, 37.18342], [-122.3476, 37.18395], [-122.34777, 37.18404], [-122.34795, 37.18428], [-122.34795, 37.18439], [-122.34809, 37.18457]]], [[[-122.33499, 37.15273], [-122.3342, 37.15446], [-122.33451, 37.15639], [-122.33278, 37.15493], [-122.3327, 37.15471], [-122.33499, 37.15273]]]]} | Open Access 1 | Año Nuevo State Park | http://www.parks.ca.gov/?page_id=523 | 27967 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 3043.4 | Año Nuevo SP | 1985 |
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]);