units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where DES_TP = 80 and MNG_AG_TYP = 1 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Federal Agency · 4 ✖
MNG_AGENCY 1
DES_TP 1
- National Monument or Landmark · 4 ✖
ACCESS_TYP 1
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL ▼ | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15773 | 15773 | 15772 | {"type": "Polygon", "coordinates": [[[-119.09289, 37.59811], [-119.09289, 37.59811], [-119.09173, 37.63532], [-119.08305, 37.63394], [-119.08363, 37.59717], [-119.09289, 37.59811]]]} | Open Access 1 | 16776 | Devils Postpile National Monument | 14212 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/depo/index.htm | Madera 48 | 805.97 | Devils Postpile NM | 1911 | National Monument or Landmark 80 | 3 |
15487 | 15487 | 15486 | {"type": "Polygon", "coordinates": [[[-121.45722, 41.83736], [-121.44849, 41.83465], [-121.4401, 41.83555], [-121.43784, 41.83475], [-121.43789, 41.8342], [-121.43758, 41.83366], [-121.43771, 41.81959], [-121.43761, 41.80509], [-121.43784, 41.79055], [-121.43798, 41.77602], [-121.44655, 41.77602], [-121.44949, 41.77604], [-121.45196, 41.77595], [-121.45718, 41.77594], [-121.45722, 41.83736]]]} | Open Access 1 | 10121 | Lava Beds National Monument | 14250 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/labe/index.htm | Modoc 56 | 2641.853 | Lava Beds NM | 1925 | National Monument or Landmark 80 | 3 |
15730 | 15730 | 15729 | {"type": "Polygon", "coordinates": [[[-121.60522, 41.69165], [-121.60511, 41.70627], [-121.60479, 41.73534], [-121.60403, 41.76443], [-121.60396, 41.77595], [-121.58813, 41.77602], [-121.58456, 41.77601], [-121.56898, 41.77609], [-121.56908, 41.81943], [-121.56907, 41.8339], [-121.5529, 41.8342], [-121.55288, 41.82887], [-121.55095, 41.82937], [-121.5496, 41.82915], [-121.54923, 41.82844], [-121.5492, 41.82643], [-121.54712, 41.82637], [-121.54423, 41.82549], [-121.54289, 41.82596], [-121.5422, 41.8257], [-121.54188, 41.82493], [-121.54181, 41.82425], [-121.54119, 41.82378], [-121.54113, 41.8233], [-121.53976, 41.82232], [-121.54001, 41.82165], [-121.53975, 41.82073], [-121.54001, 41.81962], [-121.54235, 41.81798], [-121.54205, 41.8173], [-121.54106, 41.81697], [-121.53988, 41.81779], [-121.53708, 41.81694], [-121.53554, 41.81671], [-121.53375, 41.81571], [-121.5337, 41.8157], [-121.53233, 41.81357], [-121.53151, 41.81282], [-121.53108, 41.81266], [-121.53041, 41.81284], [-121.52976, 41.81347], [-121.52954, 41.81409], [-121.52923, 41.81514], [-121.52889, 41.81605], [-121.52815, 41.81705], [-121.52781, 41.81732], [-121.52698, 41.81787], [-121.52533, 41.81882], [-121.52484, 41.81919], [-121.52419, 41.82007], [-121.52363, 41.82112], [-121.52269, 41.82413], [-121.52149, 41.8262], [-121.52111, 41.8277], [-121.52114, 41.82834], [-121.52171, 41.82914], [-121.52149, 41.82971], [-121.5206, 41.83014], [-121.51984, 41.83044], [-121.51941, 41.83078], [-121.51928, 41.83124], [-121.5197, 41.83224], [-121.51914, 41.8341], [-121.51908, 41.83442], [-121.51436, 41.83442], [-121.51433, 41.82912], [-121.51169, 41.82761], [-121.50843, 41.82826], [-121.50666, 41.82558], [-121.50332, 41.82563], [-121.50099, 41.82522], [-121.4992, 41.82829], [-121.4969, 41.82934], [-121.49793, 41.83142], [-121.49495, 41.83208], [-121.49492, 41.83409], [-121.47774, 41.83412], [-121.47657, 41.83333], [-121.47549, 41.83378], [-121.47492, 41.83413], [-121.47292, 41.83502], [-121.46271, 41.83784], [-121.45722, 41.837], [-121.45718, 41.77594], [-121.44944, 41.77596], [-121.44955, 41.74988], [-121.44964, 41.74987], [-121.44964, 41.72052], [-121.44946, 41.69158], [-121.45951, 41.69157], [-121.48824, 41.69147], [-121.5074, 41.69151], [-121.52757, 41.69143], [-121.54613, 41.69144], [-121.54676, 41.69143], [-121.54681, 41.6896], [-121.55168, 41.68957], [-121.55165, 41.6914], [-121.55166, 41.69141], [-121.56643, 41.69136], [-121.58579, 41.69163], [-121.60522, 41.69165]]]} | Open Access 1 | 10119 | Lava Beds National Monument | 14250 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/labe/index.htm | Siskiyou 28 | 43621.479 | Lava Beds NM | 1925 | National Monument or Landmark 80 | 3 |
15780 | 15780 | 15779 | {"type": "MultiPolygon", "coordinates": [[[[-122.56517, 37.89013], [-122.56502, 37.89019], [-122.56474, 37.89038], [-122.56387, 37.89083], [-122.56353, 37.8913], [-122.56354, 37.8914], [-122.56331, 37.8916], [-122.56306, 37.89183], [-122.56293, 37.89173], [-122.56263, 37.89169], [-122.56228, 37.89177], [-122.56183, 37.89176], [-122.56161, 37.89181], [-122.56147, 37.89182], [-122.56183, 37.89152], [-122.56198, 37.89147], [-122.56229, 37.89147], [-122.5625, 37.89141], [-122.56272, 37.89119], [-122.56326, 37.89052], [-122.56325, 37.89043], [-122.56319, 37.89029], [-122.56302, 37.89007], [-122.56288, 37.88998], [-122.56293, 37.88995], [-122.56318, 37.88984], [-122.56346, 37.88983], [-122.56371, 37.88995], [-122.564, 37.88987], [-122.56422, 37.88973], [-122.5645, 37.88958], [-122.5648, 37.88965], [-122.56517, 37.89013]]], [[[-122.5691, 37.89149], [-122.56853, 37.89143], [-122.56812, 37.89149], [-122.56792, 37.89158], [-122.56773, 37.89174], [-122.56769, 37.89174], [-122.56767, 37.89163], [-122.56752, 37.89117], [-122.56679, 37.89087], [-122.56606, 37.89078], [-122.56569, 37.89078], [-122.56505, 37.8911], [-122.56493, 37.89138], [-122.56489, 37.89158], [-122.56477, 37.89151], [-122.56454, 37.89152], [-122.56394, 37.89183], [-122.56356, 37.89224], [-122.56321, 37.89248], [-122.56327, 37.89283], [-122.56335, 37.89308], [-122.56334, 37.89319], [-122.56321, 37.89345], [-122.5632, 37.89352], [-122.56318, 37.89345], [-122.56304, 37.89328], [-122.56289, 37.89318], [-122.56272, 37.89294], [-122.56267, 37.89296], [-122.56285, 37.89322], [-122.56298, 37.89331], [-122.5631, 37.89347], [-122.56316, 37.89364], [-122.56307, 37.89361], [-122.5629, 37.89346], [-122.56268, 37.89339], [-122.56234, 37.89345], [-122.56202, 37.8936], [-122.5619, 37.8938], [-122.56196, 37.89355], [-122.56213, 37.89336], [-122.56224, 37.89313], [-122.5623, 37.89297], [-122.56224, 37.89295], [-122.56208, 37.89332], [-122.56191, 37.89352], [-122.56174, 37.89395], [-122.56171, 37.8937], [-122.56173, 37.89331], [-122.56171, 37.89319], [-122.56174, 37.89308], [-122.5619, 37.89282], [-122.56194, 37.89264], [-122.5619, 37.89242], [-122.56174, 37.89219], [-122.56175, 37.892], [-122.56172, 37.8919], [-122.56159, 37.89186], [-122.56184, 37.89181], [-122.56213, 37.89183], [-122.56229, 37.89182], [-122.56264, 37.89174], [-122.56291, 37.89179], [-122.56306, 37.8919], [-122.56357, 37.89145], [-122.56405, 37.89097], [-122.56524, 37.89043], [-122.56589, 37.89026], [-122.5668, 37.89016], [-122.56734, 37.89045], [-122.56823, 37.89119], [-122.5691, 37.89149]]], [[[-122.56548, 37.88924], [-122.56542, 37.88933], [-122.56513, 37.88945], [-122.56483, 37.88955], [-122.56448, 37.88947], [-122.56419, 37.88962], [-122.56396, 37.88977], [-122.56374, 37.88983], [-122.56351, 37.88973], [-122.56316, 37.88974], [-122.56287, 37.88988], [-122.5626, 37.88994], [-122.56226, 37.88944], [-122.56279, 37.8892], [-122.56282, 37.88922], [-122.5649, 37.8887], [-122.56535, 37.88873], [-122.56548, 37.88924]]], [[[-122.56485, 37.89054], [-122.56399, 37.89093], [-122.56392, 37.89087], [-122.56474, 37.89044], [-122.56485, 37.89054]]], [[[-122.56614, 37.8872], [-122.56575, 37.8881], [-122.56563, 37.88805], [-122.56512, 37.88821], [-122.56482, 37.88826], [-122.56454, 37.88819], [-122.56446, 37.88815], [-122.56444, 37.88808], [-122.56463, 37.888], [-122.5651, 37.88789], [-122.56529, 37.88775], [-122.56566, 37.88733], [-122.56599, 37.88722], [-122.56614, 37.8872]]], [[[-122.56671, 37.89011], [-122.56589, 37.89021], [-122.56522, 37.89038], [-122.5649, 37.89052], [-122.56479, 37.89042], [-122.56506, 37.89024], [-122.56548, 37.89006], [-122.56582, 37.88998], [-122.56626, 37.88981], [-122.56642, 37.88971], [-122.56642, 37.88985], [-122.56671, 37.89011]]], [[[-122.5666, 37.88799], [-122.56641, 37.88964], [-122.56623, 37.88976], [-122.56579, 37.88992], [-122.56545, 37.89001], [-122.56519, 37.89012], [-122.56484, 37.88966], [-122.56518, 37.88955], [-122.56551, 37.8894], [-122.56563, 37.88925], [-122.56552, 37.88878], [-122.56581, 37.88865], [-122.56588, 37.88839], [-122.56587, 37.88815], [-122.56578, 37.88811], [-122.56617, 37.88721], [-122.56628, 37.88729], [-122.5666, 37.88799]]], [[[-122.56716, 37.8885], [-122.56707, 37.88852], [-122.56689, 37.88861], [-122.56674, 37.88873], [-122.56665, 37.88886], [-122.56668, 37.88862], [-122.56696, 37.88843], [-122.56714, 37.88844], [-122.56716, 37.8885]]], [[[-122.60125, 37.89745], [-122.59062, 37.90249], [-122.58578, 37.90239], [-122.58266, 37.90128], [-122.5796, 37.90151], [-122.5752, 37.90393], [-122.57224, 37.89663], [-122.57202, 37.89405], [-122.57248, 37.89347], [-122.5724, 37.89296], [-122.57289, 37.89265], [-122.57347, 37.89311], [-122.57679, 37.89115], [-122.57679, 37.89114], [-122.57076, 37.89116], [-122.57044, 37.89173], [-122.56853, 37.89109], [-122.56835, 37.89102], [-122.56819, 37.89093], [-122.56752, 37.89039], [-122.567, 37.89011], [-122.56692, 37.89002], [-122.56688, 37.88996], [-122.56682, 37.88975], [-122.5668, 37.88961], [-122.56688, 37.88892], [-122.56715, 37.88908], [-122.56748, 37.8889], [-122.56757, 37.88899], [-122.56764, 37.8892], [-122.5681, 37.88958], [-122.57257, 37.89027], [-122.57501, 37.89004], [-122.57774, 37.89059], [-122.58434, 37.89507], [-122.58635, 37.89495], [-122.58614, 37.89551], [-122.587, 37.89554], [-122.58961, 37.89712], [-122.59019, 37.89777], [-122.59394, 37.89558], [-122.59453, 37.89505], [-122.59533, 37.89528], [-122.59659, 37.89601], [-122.59733, 37.89584], [-122.59844, 37.89589], [-122.60027, 37.89664], [-122.60125, 37.89745]]], [[[-122.56972, 37.89179], [-122.56915, 37.89309], [-122.56793, 37.89272], [-122.56819, 37.89213], [-122.56779, 37.89185], [-122.56801, 37.89166], [-122.56817, 37.89159], [-122.56853, 37.89154], [-122.56908, 37.8916], [-122.56972, 37.89179]]]]} | Open Access 1 | 18121 | Muir Woods National Monument | 14259 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/muwo/index.htm | Marin 23 | 529.327 | Muir Woods NM | 1908 | National Monument or Landmark 80 | 3 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);