superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/default.asp?page_id=430"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15264 | 15264 | 15263 | {"type": "MultiPolygon", "coordinates": [[[[-124.21283, 41.86941], [-124.21284, 41.86964], [-124.21249, 41.87073], [-124.21256, 41.87123], [-124.21221, 41.87207], [-124.21204, 41.87312], [-124.21175, 41.87377], [-124.2117, 41.87446], [-124.20984, 41.88274], [-124.20978, 41.88428], [-124.20958, 41.8851], [-124.20909, 41.88594], [-124.20824, 41.89093], [-124.20779, 41.89258], [-124.20573, 41.91003], [-124.20564, 41.91017], [-124.20552, 41.91052], [-124.20556, 41.91075], [-124.20563, 41.91087], [-124.2057, 41.91112], [-124.20557, 41.9115], [-124.20568, 41.91168], [-124.20563, 41.91198], [-124.20553, 41.91211], [-124.20549, 41.91228], [-124.20557, 41.91255], [-124.20561, 41.91281], [-124.20554, 41.91311], [-124.20551, 41.91363], [-124.20541, 41.91402], [-124.20523, 41.91452], [-124.20524, 41.91485], [-124.20514, 41.915], [-124.20511, 41.91524], [-124.20503, 41.91542], [-124.20491, 41.9156], [-124.20488, 41.91597], [-124.20495, 41.9162], [-124.20491, 41.91645], [-124.2048, 41.91666], [-124.20481, 41.91682], [-124.20466, 41.91722], [-124.20465, 41.91835], [-124.20461, 41.91885], [-124.20453, 41.91921], [-124.2047, 41.92024], [-124.2047, 41.92058], [-124.20456, 41.92087], [-124.20449, 41.9212], [-124.20442, 41.9213], [-124.20436, 41.92179], [-124.20422, 41.92199], [-124.20418, 41.92223], [-124.2042, 41.92245], [-124.20429, 41.92254], [-124.20424, 41.92297], [-124.2043, 41.92304], [-124.20432, 41.92334], [-124.20428, 41.92358], [-124.20414, 41.9239], [-124.20413, 41.92427], [-124.20429, 41.92495], [-124.20437, 41.92509], [-124.20434, 41.92727], [-124.20492, 41.92768], [-124.20475, 41.93013], [-124.20275, 41.93015], [-124.20276, 41.9293], [-124.20253, 41.92417], [-124.20218, 41.92416], [-124.20186, 41.9229], [-124.2016, 41.92177], [-124.20135, 41.92088], [-124.20099, 41.91983], [-124.20071, 41.91922], [-124.19908, 41.91664], [-124.19786, 41.91518], [-124.19711, 41.91466], [-124.19692, 41.91423], [-124.19648, 41.9139], [-124.19526, 41.9133], [-124.19436, 41.91294], [-124.19377, 41.91272], [-124.19285, 41.91271], [-124.19131, 41.91259], [-124.19072, 41.91245], [-124.19083, 41.90832], [-124.18569, 41.90834], [-124.18573, 41.8873], [-124.19038, 41.88739], [-124.1904, 41.87985], [-124.19168, 41.8798], [-124.19163, 41.87529], [-124.19531, 41.87526], [-124.19535, 41.86945], [-124.19591, 41.86945], [-124.19626, 41.86959], [-124.19703, 41.86969], [-124.20025, 41.86966], [-124.20797, 41.86949], [-124.21283, 41.86941]]], [[[-124.21706, 41.84384], [-124.21602, 41.84638], [-124.21539, 41.84637], [-124.21455, 41.84654], [-124.21417, 41.84669], [-124.21352, 41.84734], [-124.21331, 41.84796], [-124.21332, 41.84815], [-124.21288, 41.84812], [-124.21326, 41.85224], [-124.21329, 41.85401], [-124.21329, 41.85566], [-124.2134, 41.85635], [-124.21339, 41.85668], [-124.21364, 41.85715], [-124.2135, 41.85742], [-124.21006, 41.85742], [-124.20923, 41.8578], [-124.20871, 41.85855], [-124.20855, 41.85945], [-124.20869, 41.86075], [-124.20891, 41.86178], [-124.20814, 41.86204], [-124.20782, 41.86229], [-124.20751, 41.86207], [-124.20745, 41.86256], [-124.20537, 41.86235], [-124.20587, 41.85936], [-124.20731, 41.85945], [-124.20736, 41.85898], [-124.20595, 41.8589], [-124.20612, 41.85793], [-124.20754, 41.85802], [-124.20873, 41.84976], [-124.20872, 41.84975], [-124.20625, 41.84954], [-124.20626, 41.84891], [-124.2058, 41.84663], [-124.20604, 41.84457], [-124.20472, 41.84453], [-124.20396, 41.8435], [-124.20176, 41.84422], [-124.1998, 41.84126], [-124.19701, 41.84214], [-124.19645, 41.84127], [-124.19368, 41.84213], [-124.19363, 41.84167], [-124.19093, 41.84162], [-124.19091, 41.84049], [-124.19943, 41.84041], [-124.20262, 41.84237], [-124.20516, 41.8429], [-124.20792, 41.84205], [-124.21492, 41.84402], [-124.21706, 41.84384]]], [[[-124.19888, 41.86709], [-124.1985, 41.86729], [-124.19803, 41.86682], [-124.19842, 41.8666], [-124.19888, 41.86709]]], [[[-124.21502, 41.85872], [-124.21497, 41.86119], [-124.21478, 41.86184], [-124.21468, 41.86246], [-124.21415, 41.86442], [-124.21404, 41.86525], [-124.21328, 41.86723], [-124.21319, 41.86807], [-124.21156, 41.8682], [-124.21116, 41.86925], [-124.20524, 41.86938], [-124.20514, 41.86759], [-124.20456, 41.86756], [-124.20457, 41.86707], [-124.20511, 41.86705], [-124.20507, 41.8657], [-124.2101, 41.86583], [-124.21006, 41.85866], [-124.21502, 41.85872]]], [[[-124.24573, 41.79085], [-124.24526, 41.79165], [-124.24383, 41.7938], [-124.24304, 41.79447], [-124.24315, 41.79481], [-124.24223, 41.79632], [-124.2416, 41.79735], [-124.24107, 41.7981], [-124.24076, 41.79832], [-124.24057, 41.79851], [-124.24058, 41.79853], [-124.24003, 41.7997], [-124.23982, 41.80034], [-124.23947, 41.80095], [-124.23869, 41.80221], [-124.23817, 41.80344], [-124.23727, 41.80461], [-124.23664, 41.80571], [-124.23616, 41.80677], [-124.23546, 41.80786], [-124.23517, 41.80858], [-124.2345, 41.8098], [-124.23413, 41.81068], [-124.23386, 41.81105], [-124.23319, 41.81264], [-124.23209, 41.8151], [-124.23076, 41.81785], [-124.23045, 41.81862], [-124.21555, 41.81879], [-124.21558, 41.81742], [-124.21606, 41.81659], [-124.21653, 41.81588], [-124.21658, 41.81561], [-124.21659, 41.81533], [-124.21662, 41.8151], [-124.21685, 41.81475], [-124.21713, 41.81441], [-124.21755, 41.81409], [-124.21787, 41.8138], [-124.21826, 41.81339], [-124.21852, 41.81304], [-124.21863, 41.81257], [-124.2188, 41.81151], [-124.2188, 41.81079], [-124.2189, 41.81049], [-124.21895, 41.81023], [-124.21946, 41.80954], [-124.21971, 41.80865], [-124.21965, 41.80807], [-124.21957, 41.80757], [-124.21965, 41.80653], [-124.21966, 41.8059], [-124.21963, 41.80547], [-124.21941, 41.80516], [-124.21911, 41.80488], [-124.21896, 41.80462], [-124.21883, 41.80434], [-124.21878, 41.80396], [-124.2186, 41.80324], [-124.21848, 41.80266], [-124.21824, 41.80144], [-124.21815, 41.80105], [-124.21818, 41.80082], [-124.21826, 41.80056], [-124.21827, 41.80038], [-124.21742, 41.79911], [-124.21661, 41.79823], [-124.22285, 41.79824], [-124.22296, 41.79462], [-124.22441, 41.79461], [-124.2245, 41.78724], [-124.21943, 41.78725], [-124.21946, 41.78859], [-124.21767, 41.78857], [-124.21769, 41.78956], [-124.21618, 41.78959], [-124.21605, 41.79454], [-124.21327, 41.79454], [-124.21292, 41.79442], [-124.21252, 41.79441], [-124.21228, 41.79437], [-124.21024, 41.79365], [-124.2101, 41.79362], [-124.20906, 41.79275], [-124.20725, 41.7912], [-124.20531, 41.78963], [-124.20528, 41.78719], [-124.21462, 41.78725], [-124.21463, 41.78646], [-124.21534, 41.78644], [-124.21533, 41.78591], [-124.21461, 41.78591], [-124.21463, 41.78366], [-124.21717, 41.78362], [-124.21718, 41.77994], [-124.22196, 41.77999], [-124.22202, 41.78081], [-124.22261, 41.78079], [-124.22261, 41.77997], [-124.22283, 41.77997], [-124.22284, 41.78044], [-124.22303, 41.78046], [-124.22305, 41.78053], [-124.2232, 41.78051], [-124.2232, 41.77997], [-124.22436, 41.77998], [-124.23156, 41.77997], [-124.23161, 41.78178], [-124.23402, 41.78178], [-124.23403, 41.78724], [-124.23417, 41.79097], [-124.24573, 41.79085]], [[-124.21943, 41.78361], [-124.21944, 41.78359], [-124.21945, 41.78268], [-124.21832, 41.78269], [-124.21834, 41.78358], [-124.21943, 41.78361]], [[-124.2189, 41.78553], [-124.21843, 41.78553], [-124.21845, 41.78623], [-124.21891, 41.78622], [-124.2189, 41.78553]], [[-124.22003, 41.78362], [-124.21944, 41.78362], [-124.21947, 41.78446], [-124.22004, 41.78445], [-124.22003, 41.78362]], [[-124.22012, 41.78151], [-124.22012, 41.78076], [-124.21957, 41.78075], [-124.21958, 41.78153], [-124.22012, 41.78151]], [[-124.22261, 41.78397], [-124.22194, 41.78396], [-124.22195, 41.78449], [-124.22261, 41.78449], [-124.22261, 41.78397]], [[-124.2223, 41.78144], [-124.22228, 41.78125], [-124.22207, 41.78125], [-124.22209, 41.78161], [-124.2223, 41.78161], [-124.2223, 41.78144]], [[-124.2231, 41.78256], [-124.22309, 41.78255], [-124.22258, 41.78255], [-124.22257, 41.78266], [-124.22308, 41.78267], [-124.2231, 41.78256]], [[-124.22301, 41.78125], [-124.22259, 41.78124], [-124.22261, 41.78165], [-124.22301, 41.78164], [-124.22301, 41.78125]]], [[[-124.21562, 41.84761], [-124.21495, 41.84764], [-124.21471, 41.84737], [-124.2153, 41.84711], [-124.21562, 41.84761]]], [[[-124.21531, 41.78115], [-124.2153, 41.78159], [-124.2149, 41.7816], [-124.21486, 41.78115], [-124.21531, 41.78115]]], [[[-124.21644, 41.78099], [-124.21585, 41.78098], [-124.21583, 41.77991], [-124.21642, 41.77991], [-124.21644, 41.78099]]], [[[-124.25585, 41.78295], [-124.25585, 41.783], [-124.25571, 41.78306], [-124.2556, 41.78316], [-124.25531, 41.78329], [-124.25517, 41.78344], [-124.2552, 41.78366], [-124.25519, 41.78374], [-124.25522, 41.78383], [-124.25507, 41.78412], [-124.25507, 41.7843], [-124.2551, 41.78436], [-124.2551, 41.78443], [-124.25517, 41.78461], [-124.25505, 41.78473], [-124.25498, 41.78476], [-124.25484, 41.78484], [-124.25475, 41.78502], [-124.25448, 41.78524], [-124.25439, 41.78529], [-124.25421, 41.78527], [-124.25401, 41.78521], [-124.25363, 41.78531], [-124.25357, 41.78536], [-124.25344, 41.78036], [-124.25349, 41.78042], [-124.25359, 41.78064], [-124.2538, 41.78089], [-124.25444, 41.7813], [-124.25479, 41.78146], [-124.25512, 41.78159], [-124.25496, 41.78177], [-124.25493, 41.78184], [-124.25491, 41.7819], [-124.25496, 41.7821], [-124.25524, 41.78227], [-124.2555, 41.78235], [-124.25566, 41.78246], [-124.25576, 41.78258], [-124.25574, 41.78271], [-124.25568, 41.78278], [-124.25566, 41.78286], [-124.25585, 41.78295]]], [[[-124.25493, 41.77875], [-124.25489, 41.77882], [-124.25465, 41.77898], [-124.25446, 41.77897], [-124.25435, 41.77899], [-124.25423, 41.77897], [-124.25408, 41.77904], [-124.25398, 41.77906], [-124.25397, 41.77913], [-124.2539, 41.77931], [-124.25378, 41.77943], [-124.25371, 41.77945], [-124.25364, 41.77943], [-124.25352, 41.77945], [-124.25346, 41.7795], [-124.25344, 41.77854], [-124.25349, 41.77857], [-124.25374, 41.77865], [-124.25385, 41.77863], [-124.25394, 41.77867], [-124.25413, 41.77866], [-124.2543, 41.7786], [-124.25439, 41.77863], [-124.25453, 41.77852], [-124.25457, 41.77852], [-124.25467, 41.77828], [-124.25475, 41.77832], [-124.25491, 41.77847], [-124.25489, 41.77868], [-124.25493, 41.77875]]]]} | Open Access 1 | Tolowa Dunes State Park | http://www.parks.ca.gov/default.asp?page_id=430 | 1769 | 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 | 4199.646 | Tolowa Dunes SP | 1983 |
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]);