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/?page_id=417"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15249 | 15249 | 15248 | {"type": "Polygon", "coordinates": [[[-124.16552, 41.12978], [-124.16542, 41.13007], [-124.1653, 41.13018], [-124.16507, 41.13018], [-124.16499, 41.1302], [-124.16483, 41.13033], [-124.16456, 41.13027], [-124.1642, 41.1304], [-124.16387, 41.13057], [-124.16379, 41.13073], [-124.1638, 41.13085], [-124.16379, 41.13097], [-124.16347, 41.13139], [-124.16339, 41.13142], [-124.1627, 41.13185], [-124.16247, 41.13205], [-124.16217, 41.13224], [-124.16191, 41.13257], [-124.16188, 41.13273], [-124.16184, 41.13279], [-124.16173, 41.13282], [-124.16158, 41.13278], [-124.1613, 41.13275], [-124.16115, 41.13278], [-124.16087, 41.13305], [-124.16078, 41.13317], [-124.16073, 41.1333], [-124.16071, 41.13344], [-124.16077, 41.13354], [-124.1609, 41.13363], [-124.16109, 41.13367], [-124.16123, 41.13375], [-124.16139, 41.13391], [-124.16155, 41.13397], [-124.16205, 41.13405], [-124.16219, 41.13413], [-124.16235, 41.13441], [-124.16236, 41.13454], [-124.16243, 41.13461], [-124.16241, 41.1349], [-124.16233, 41.13501], [-124.16222, 41.13501], [-124.16205, 41.13496], [-124.16195, 41.13498], [-124.16172, 41.13517], [-124.16172, 41.13542], [-124.16177, 41.13571], [-124.16196, 41.1359], [-124.16212, 41.13597], [-124.16222, 41.13604], [-124.16229, 41.13613], [-124.16245, 41.13611], [-124.16238, 41.13631], [-124.16228, 41.13641], [-124.16229, 41.13655], [-124.16245, 41.13663], [-124.16264, 41.1367], [-124.16286, 41.13683], [-124.16311, 41.13717], [-124.16337, 41.13749], [-124.16353, 41.13774], [-124.1637, 41.13813], [-124.16403, 41.13848], [-124.16403, 41.13855], [-124.1639, 41.13862], [-124.16372, 41.13867], [-124.1633, 41.13885], [-124.16318, 41.13895], [-124.16293, 41.13932], [-124.16286, 41.13936], [-124.16273, 41.1394], [-124.16266, 41.13947], [-124.16257, 41.13961], [-124.16248, 41.13968], [-124.16231, 41.13979], [-124.16224, 41.13989], [-124.16216, 41.14011], [-124.16209, 41.14013], [-124.16201, 41.14004], [-124.16195, 41.14009], [-124.16193, 41.14019], [-124.16166, 41.14023], [-124.16161, 41.14033], [-124.16163, 41.1404], [-124.1618, 41.14043], [-124.16184, 41.14052], [-124.16179, 41.14065], [-124.16196, 41.14097], [-124.16198, 41.14115], [-124.16193, 41.14123], [-124.16176, 41.14125], [-124.16164, 41.14131], [-124.1616, 41.14143], [-124.16146, 41.14149], [-124.16135, 41.14144], [-124.16113, 41.1414], [-124.16101, 41.14144], [-124.16085, 41.14152], [-124.16059, 41.14181], [-124.16047, 41.1419], [-124.16044, 41.14203], [-124.16052, 41.14225], [-124.16047, 41.14229], [-124.16033, 41.14219], [-124.16019, 41.14217], [-124.1599, 41.1422], [-124.15949, 41.14229], [-124.15931, 41.14245], [-124.15917, 41.14263], [-124.15898, 41.14266], [-124.1587, 41.14281], [-124.15862, 41.14286], [-124.15855, 41.14296], [-124.15819, 41.14279], [-124.15742, 41.14262], [-124.1571, 41.14253], [-124.15686, 41.14243], [-124.15648, 41.14206], [-124.15596, 41.14183], [-124.15492, 41.14142], [-124.15468, 41.14136], [-124.15441, 41.14132], [-124.15385, 41.14139], [-124.15363, 41.14135], [-124.15337, 41.14124], [-124.1532, 41.14101], [-124.15302, 41.14094], [-124.15283, 41.14093], [-124.1521, 41.14102], [-124.15165, 41.14104], [-124.15086, 41.14102], [-124.15051, 41.14094], [-124.15012, 41.14082], [-124.14992, 41.14078], [-124.14966, 41.14078], [-124.14918, 41.14087], [-124.14867, 41.14092], [-124.14802, 41.14112], [-124.1475, 41.14138], [-124.14733, 41.14152], [-124.1462, 41.1421], [-124.14601, 41.14228], [-124.14545, 41.14296], [-124.14507, 41.14326], [-124.1449, 41.14342], [-124.14457, 41.14385], [-124.14412, 41.14428], [-124.14389, 41.14441], [-124.14337, 41.14495], [-124.1432, 41.14518], [-124.1428, 41.14591], [-124.14242, 41.14667], [-124.14231, 41.14696], [-124.14217, 41.14724], [-124.14188, 41.14757], [-124.14175, 41.14776], [-124.14163, 41.14807], [-124.14151, 41.14828], [-124.14134, 41.14847], [-124.14117, 41.14872], [-124.14106, 41.14882], [-124.14085, 41.14923], [-124.14069, 41.14948], [-124.1405, 41.1497], [-124.1403, 41.14999], [-124.13986, 41.15091], [-124.13972, 41.15131], [-124.13908, 41.15262], [-124.13895, 41.15313], [-124.13885, 41.15332], [-124.1387, 41.15395], [-124.13842, 41.15476], [-124.13828, 41.15504], [-124.13809, 41.15534], [-124.13801, 41.15561], [-124.13779, 41.15604], [-124.13707, 41.15691], [-124.13689, 41.15718], [-124.13681, 41.15743], [-124.13674, 41.15784], [-124.13646, 41.15854], [-124.13641, 41.15887], [-124.13542, 41.15887], [-124.13575, 41.15778], [-124.13591, 41.15704], [-124.13597, 41.15672], [-124.1361, 41.15639], [-124.13617, 41.15612], [-124.1363, 41.15558], [-124.1365, 41.15504], [-124.13657, 41.15477], [-124.13672, 41.15442], [-124.13696, 41.15337], [-124.13707, 41.15307], [-124.13704, 41.15277], [-124.13737, 41.15218], [-124.13746, 41.15189], [-124.13732, 41.15148], [-124.13666, 41.15109], [-124.13616, 41.15092], [-124.1368, 41.15024], [-124.13616, 41.1487], [-124.13639, 41.14566], [-124.13699, 41.14519], [-124.13656, 41.14404], [-124.13704, 41.14264], [-124.13808, 41.14173], [-124.13849, 41.14042], [-124.13953, 41.14007], [-124.14133, 41.13848], [-124.14238, 41.13874], [-124.14333, 41.13844], [-124.14368, 41.13797], [-124.14439, 41.13777], [-124.14482, 41.13785], [-124.1454, 41.13746], [-124.14602, 41.13728], [-124.14616, 41.13737], [-124.14651, 41.13695], [-124.14768, 41.13661], [-124.14872, 41.13645], [-124.14947, 41.13629], [-124.15008, 41.13604], [-124.14973, 41.1338], [-124.15024, 41.13322], [-124.15092, 41.13252], [-124.15137, 41.1304], [-124.15443, 41.13049], [-124.15483, 41.12943], [-124.15629, 41.12941], [-124.1563, 41.12862], [-124.15517, 41.12863], [-124.15573, 41.12725], [-124.15864, 41.12728], [-124.15867, 41.12815], [-124.16119, 41.12812], [-124.16119, 41.12486], [-124.1612, 41.12482], [-124.16134, 41.12505], [-124.16146, 41.12515], [-124.16158, 41.12532], [-124.1616, 41.12545], [-124.16154, 41.12552], [-124.16154, 41.12564], [-124.16158, 41.12574], [-124.16167, 41.12586], [-124.16179, 41.12595], [-124.16198, 41.12603], [-124.16207, 41.12615], [-124.16233, 41.12638], [-124.16241, 41.12653], [-124.16241, 41.1267], [-124.16248, 41.12688], [-124.16271, 41.12719], [-124.16313, 41.1276], [-124.16331, 41.12772], [-124.16387, 41.128], [-124.16396, 41.1281], [-124.16409, 41.12842], [-124.16443, 41.1288], [-124.16462, 41.12895], [-124.16474, 41.12909], [-124.16505, 41.12928], [-124.16535, 41.12953], [-124.16552, 41.12978]]]} | Open Access 1 | Patrick's Point State Park | http://www.parks.ca.gov/?page_id=417 | 1671 | 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 | 640.555 | Patrick's Point SP | 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]);