units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 22, DES_TP = 18 and PARK_URL = "http://www.nps.gov/jotr/index.htm"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15785 | 15785 | 15784 | {"type": "MultiPolygon", "coordinates": [[[[-115.64872, 34.10288], [-115.62981, 34.09846], [-115.62864, 34.09827], [-115.61718, 34.09818], [-115.61307, 34.09736], [-115.60576, 34.09603], [-115.59934, 34.09451], [-115.59504, 34.09318], [-115.58376, 34.09016], [-115.58277, 34.08938], [-115.57851, 34.08365], [-115.57438, 34.08051], [-115.57097, 34.07826], [-115.56924, 34.07732], [-115.56703, 34.07595], [-115.56544, 34.0752], [-115.56376, 34.07519], [-115.56208, 34.07506], [-115.5593, 34.07459], [-115.55718, 34.07402], [-115.55385, 34.07334], [-115.55151, 34.07301], [-115.55055, 34.07304], [-115.54942, 34.07351], [-115.54848, 34.07438], [-115.54501, 34.08144], [-115.53972, 34.09256], [-115.53615, 34.1006], [-115.53285, 34.10685], [-115.53085, 34.11012], [-115.52915, 34.11344], [-115.5279, 34.11511], [-115.52722, 34.11586], [-115.5262, 34.11662], [-115.52558, 34.11696], [-115.52437, 34.1174], [-115.50995, 34.11569], [-115.50566, 34.11503], [-115.50081, 34.11449], [-115.48023, 34.11157], [-115.47623, 34.11072], [-115.46401, 34.10745], [-115.46017, 34.10668], [-115.45908, 34.10622], [-115.45456, 34.10481], [-115.44336, 34.10177], [-115.42025, 34.09219], [-115.42021, 34.0777], [-115.41541, 34.0777], [-115.41518, 34.09205], [-115.41497, 34.09205], [-115.40906, 34.09204], [-115.40909, 34.07848], [-115.40909, 34.07769], [-115.40298, 34.07768], [-115.40296, 34.09204], [-115.40278, 34.09204], [-115.39744, 34.09168], [-115.39133, 34.09107], [-115.38681, 34.09024], [-115.37564, 34.08759], [-115.35794, 34.08369], [-115.3523, 34.08223], [-115.33353, 34.07716], [-115.31606, 34.07254], [-115.31613, 34.03415], [-115.3507, 34.03445], [-115.35071, 34.03446], [-115.35076, 34.03446], [-115.36818, 34.03472], [-115.36819, 34.03475], [-115.3693, 34.03477], [-115.39721, 34.03457], [-115.46039, 34.03462], [-115.46617, 34.03468], [-115.46617, 34.03478], [-115.46675, 34.03458], [-115.47473, 34.03463], [-115.47492, 34.03478], [-115.47493, 34.03476], [-115.51785, 34.03515], [-115.56167, 34.03519], [-115.56165, 34.04948], [-115.56166, 34.0495], [-115.57952, 34.04951], [-115.57941, 34.03515], [-115.62573, 34.03511], [-115.62609, 34.03533], [-115.63122, 34.03524], [-115.63123, 34.0352], [-115.63141, 34.0352], [-115.63136, 34.0705], [-115.64828, 34.10157], [-115.64872, 34.10288]], [[-115.52712, 34.08559], [-115.52713, 34.08558], [-115.5271, 34.07833], [-115.51805, 34.07831], [-115.51825, 34.08544], [-115.52712, 34.08559]], [[-115.61424, 34.07851], [-115.61423, 34.07852], [-115.61425, 34.09309], [-115.63139, 34.0931], [-115.63138, 34.07854], [-115.61424, 34.07851]]], [[[-116.45762, 34.07597], [-116.44025, 34.07603], [-116.42477, 34.07591], [-116.42042, 34.07593], [-116.40544, 34.0761], [-116.33559, 34.07608], [-116.33558, 34.07589], [-116.31821, 34.07607], [-116.3182, 34.07623], [-116.3008, 34.07621], [-116.30079, 34.07756], [-116.28328, 34.07779], [-116.26572, 34.0777], [-116.26576, 34.09222], [-116.26575, 34.09223], [-116.26576, 34.10335], [-116.26583, 34.12052], [-116.18366, 34.12052], [-116.15956, 34.12055], [-116.13325, 34.12044], [-116.12454, 34.12042], [-116.10708, 34.12044], [-116.10707, 34.12041], [-116.09694, 34.12041], [-116.09693, 34.12042], [-116.08903, 34.1204], [-116.08893, 34.12041], [-116.08892, 34.12069], [-116.05873, 34.1211], [-116.05877, 34.12011], [-116.05779, 34.12018], [-116.0578, 34.11846], [-116.0544, 34.118], [-116.05438, 34.10701], [-116.03851, 34.10701], [-116.03867, 34.10502], [-116.03677, 34.10499], [-116.03676, 34.10434], [-116.03865, 34.10435], [-116.03851, 34.10353], [-116.04096, 34.10345], [-116.04094, 34.10064], [-116.03674, 34.10052], [-116.03658, 34.07831], [-116.01903, 34.0781], [-116.00151, 34.07792], [-116.0015, 34.04893], [-116.00143, 34.03493], [-116.00192, 34.03481], [-116.10139, 34.03399], [-116.10663, 34.03377], [-116.12388, 34.03364], [-116.17615, 34.03364], [-116.25207, 34.03394], [-116.29969, 34.03465], [-116.30031, 34.03253], [-116.42123, 34.03299], [-116.42283, 34.03274], [-116.44022, 34.03275], [-116.44174, 34.03278], [-116.45702, 34.03291], [-116.45749, 34.04727], [-116.45762, 34.07597]], [[-116.24841, 34.0434], [-116.24843, 34.04161], [-116.24734, 34.04161], [-116.24733, 34.0434], [-116.24841, 34.0434]], [[-116.33019, 34.07516], [-116.33128, 34.07517], [-116.33129, 34.07433], [-116.3302, 34.07433], [-116.33019, 34.07516]]], [[[-116.04537, 34.12923], [-116.03689, 34.12934], [-116.03684, 34.1293], [-116.03684, 34.12681], [-116.03686, 34.12672], [-116.03695, 34.12655], [-116.0371, 34.12644], [-116.03728, 34.12637], [-116.03756, 34.12635], [-116.03789, 34.12636], [-116.03821, 34.12641], [-116.03844, 34.12647], [-116.03903, 34.12666], [-116.03949, 34.12677], [-116.03997, 34.12684], [-116.04045, 34.12687], [-116.04102, 34.12685], [-116.0415, 34.12679], [-116.04196, 34.12668], [-116.04277, 34.12644], [-116.04318, 34.12638], [-116.04346, 34.12636], [-116.04378, 34.12638], [-116.0441, 34.12642], [-116.04432, 34.12648], [-116.04466, 34.12659], [-116.04501, 34.12677], [-116.04519, 34.12694], [-116.04531, 34.12714], [-116.04536, 34.12734], [-116.04537, 34.12923]]]]} | Open Access 1 | 2571 | Joshua Tree National Park | 14236 | 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/jotr/index.htm | San Bernardino 22 | 120785.418 | Joshua Tree NP | 1994 | National Park 18 | 2 |
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]);