units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Rogue River NF" and MNG_AG_TYP = 1
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15743 | 15743 | 15742 | {"type": "MultiPolygon", "coordinates": [[[[-123.3504, 41.99919], [-123.3476, 41.99915], [-123.34688, 41.99918], [-123.34588, 41.99895], [-123.34583, 41.99922], [-123.33872, 41.99947], [-123.32133, 42.00023], [-123.29515, 42.00133], [-123.23127, 42.0038], [-123.21153, 42.00475], [-123.19179, 42.00561], [-123.175, 42.0066], [-123.14592, 42.00876], [-123.12617, 42.00831], [-123.12616, 42.00836], [-123.12225, 42.00813], [-123.10971, 42.00733], [-123.09773, 42.00645], [-123.08339, 42.00531], [-123.0808, 42.00514], [-123.06907, 42.00498], [-123.06911, 42.00251], [-123.06922, 42.00067], [-123.07155, 42.00059], [-123.07157, 41.99884], [-123.07401, 41.99879], [-123.07651, 41.99879], [-123.07645, 42.0006], [-123.07646, 42.00061], [-123.08129, 42.00062], [-123.08369, 42.00071], [-123.08602, 42.00072], [-123.09083, 42.00078], [-123.09097, 41.99887], [-123.08134, 41.99875], [-123.08137, 41.9969], [-123.07894, 41.9969], [-123.07655, 41.99692], [-123.07665, 41.99516], [-123.07664, 41.99515], [-123.07183, 41.99525], [-123.07174, 41.99701], [-123.06925, 41.99709], [-123.06921, 41.99888], [-123.06683, 41.99895], [-123.06671, 42.00071], [-123.0648, 42.00074], [-123.06475, 42.00257], [-123.05464, 42.00222], [-123.05468, 42.00051], [-123.05467, 42.0005], [-123.04565, 42.00039], [-123.04082, 42.00025], [-123.04081, 41.99845], [-123.03612, 41.99849], [-123.03621, 41.99681], [-123.0362, 41.9968], [-123.03121, 41.9969], [-123.03105, 42.00038], [-123.0361, 42.00027], [-123.03846, 42.00025], [-123.0385, 42.00209], [-123.02666, 42.00203], [-123.0265, 41.9878], [-123.00728, 41.98776], [-123.00727, 41.98777], [-123.00751, 42.00162], [-122.98832, 42.00195], [-122.98831, 42.00328], [-122.96855, 42.00343], [-122.9686, 42.0021], [-122.96859, 42.00209], [-122.9495, 42.00203], [-122.94944, 42.00351], [-122.93007, 42.00366], [-122.93005, 42.00366], [-122.93009, 42.00206], [-122.93008, 42.00205], [-122.9109, 42.00202], [-122.91089, 42.00203], [-122.91096, 42.00369], [-122.89683, 42.00375], [-122.89178, 42.00379], [-122.89178, 42.00199], [-122.91089, 42.00202], [-122.911, 41.98762], [-122.9304, 41.98764], [-122.9304, 41.97328], [-122.93355, 41.97328], [-122.93484, 41.97271], [-122.9385, 41.9713], [-122.94012, 41.96843], [-122.94145, 41.96618], [-122.94308, 41.96589], [-122.94466, 41.96525], [-122.94599, 41.96312], [-122.94751, 41.96141], [-122.94982, 41.95971], [-122.94984, 41.95971], [-122.95106, 41.95878], [-122.95231, 41.95753], [-122.95448, 41.95649], [-122.95569, 41.9559], [-122.95728, 41.95498], [-122.95786, 41.95418], [-122.95799, 41.95317], [-122.95774, 41.95266], [-122.95663, 41.95065], [-122.95657, 41.94993], [-122.95671, 41.94872], [-122.95814, 41.94724], [-122.95974, 41.94566], [-122.96034, 41.9447], [-122.96028, 41.94464], [-122.96037, 41.94414], [-122.9604, 41.94305], [-122.9611, 41.94101], [-122.96082, 41.93842], [-122.96097, 41.93589], [-122.96229, 41.93503], [-122.9642, 41.93308], [-122.96634, 41.93207], [-122.96679, 41.93238], [-122.9668, 41.93237], [-122.96679, 41.93219], [-122.96835, 41.93233], [-122.97146, 41.93269], [-122.97341, 41.93359], [-122.97607, 41.936], [-122.97763, 41.93705], [-122.9785, 41.93744], [-122.97971, 41.93734], [-122.9805, 41.93684], [-122.98156, 41.93576], [-122.98305, 41.93522], [-122.984, 41.93461], [-122.9854, 41.93367], [-122.98709, 41.93277], [-122.98918, 41.93136], [-122.99105, 41.93068], [-122.99279, 41.93038], [-122.99482, 41.93052], [-122.99584, 41.93086], [-122.99745, 41.93085], [-123.00115, 41.93154], [-123.00116, 41.93162], [-123.00451, 41.93167], [-123.00476, 41.93373], [-123.0054, 41.93424], [-123.00599, 41.93686], [-123.00689, 41.93911], [-123.00841, 41.94123], [-123.00993, 41.94312], [-123.01116, 41.94572], [-123.01131, 41.94587], [-123.01124, 41.94625], [-123.01156, 41.94695], [-123.01306, 41.9478], [-123.01325, 41.94774], [-123.01657, 41.94883], [-123.02006, 41.94803], [-123.02241, 41.94701], [-123.02292, 41.94697], [-123.023, 41.94688], [-123.02374, 41.94666], [-123.0248, 41.9467], [-123.02576, 41.94713], [-123.02624, 41.94757], [-123.02627, 41.9478], [-123.0271, 41.94822], [-123.02718, 41.94828], [-123.02725, 41.94828], [-123.02831, 41.94879], [-123.02873, 41.94932], [-123.02922, 41.95004], [-123.0304, 41.9503], [-123.0319, 41.95038], [-123.03456, 41.95034], [-123.03552, 41.95065], [-123.03669, 41.95086], [-123.03668, 41.95093], [-123.03688, 41.95095], [-123.03847, 41.95153], [-123.03882, 41.9515], [-123.03989, 41.95124], [-123.04123, 41.95123], [-123.04217, 41.95102], [-123.0433, 41.95134], [-123.04331, 41.95137], [-123.04403, 41.95141], [-123.04552, 41.9516], [-123.04586, 41.95187], [-123.04789, 41.95203], [-123.05029, 41.95209], [-123.05159, 41.95254], [-123.05614, 41.95423], [-123.05773, 41.95395], [-123.05882, 41.95333], [-123.06605, 41.95423], [-123.06699, 41.95373], [-123.0688, 41.95476], [-123.07155, 41.95565], [-123.07363, 41.9556], [-123.07649, 41.95505], [-123.07881, 41.95332], [-123.07904, 41.95128], [-123.08191, 41.95097], [-123.08326, 41.95141], [-123.08313, 41.95079], [-123.08535, 41.94921], [-123.0882, 41.94866], [-123.09271, 41.94939], [-123.09413, 41.94887], [-123.09664, 41.94773], [-123.09997, 41.94717], [-123.10201, 41.94616], [-123.10386, 41.94456], [-123.10694, 41.94209], [-123.1102, 41.93973], [-123.1149, 41.93746], [-123.11701, 41.93766], [-123.12104, 41.9391], [-123.1228, 41.93894], [-123.12798, 41.94049], [-123.13247, 41.94074], [-123.13475, 41.94176], [-123.13601, 41.94125], [-123.13812, 41.94192], [-123.14132, 41.94208], [-123.14467, 41.94187], [-123.14927, 41.94104], [-123.15276, 41.94059], [-123.15301, 41.93879], [-123.15521, 41.93802], [-123.15773, 41.937], [-123.15916, 41.93729], [-123.15998, 41.93742], [-123.16162, 41.93822], [-123.16407, 41.93935], [-123.165, 41.93873], [-123.16651, 41.93678], [-123.16838, 41.93565], [-123.17089, 41.93451], [-123.17358, 41.93408], [-123.17644, 41.93353], [-123.17931, 41.93346], [-123.18459, 41.92997], [-123.18565, 41.92863], [-123.18562, 41.92791], [-123.18661, 41.92501], [-123.18843, 41.9228], [-123.18911, 41.92015], [-123.19244, 41.91971], [-123.19472, 41.92049], [-123.19744, 41.92066], [-123.19916, 41.91978], [-123.20133, 41.91817], [-123.20353, 41.91751], [-123.20659, 41.91803], [-123.20854, 41.91858], [-123.20983, 41.91891], [-123.21031, 41.9189], [-123.21321, 41.91942], [-123.21464, 41.91927], [-123.21709, 41.9204], [-123.21998, 41.92057], [-123.22275, 41.92181], [-123.22496, 41.92128], [-123.22766, 41.92085], [-123.23219, 41.92205], [-123.23915, 41.92403], [-123.2409, 41.92363], [-123.24418, 41.92546], [-123.24781, 41.928], [-123.24949, 41.92964], [-123.252, 41.93221], [-123.25538, 41.93414], [-123.25964, 41.93489], [-123.26212, 41.93674], [-123.26298, 41.93804], [-123.26496, 41.93943], [-123.26681, 41.94129], [-123.26901, 41.94399], [-123.26893, 41.94428], [-123.26998, 41.94429], [-123.27014, 41.94432], [-123.27179, 41.94524], [-123.27436, 41.94553], [-123.27492, 41.9472], [-123.27658, 41.94871], [-123.27798, 41.94784], [-123.28023, 41.9479], [-123.28387, 41.9472], [-123.28869, 41.94768], [-123.29145, 41.94868], [-123.29264, 41.95009], [-123.29343, 41.94983], [-123.29515, 41.94907], [-123.29715, 41.94734], [-123.30114, 41.94723], [-123.30396, 41.94584], [-123.30286, 41.94983], [-123.30258, 41.95414], [-123.3036, 41.95544], [-123.30281, 41.95893], [-123.30216, 41.96207], [-123.30578, 41.96432], [-123.31089, 41.96759], [-123.31521, 41.96772], [-123.3204, 41.96914], [-123.3237, 41.97165], [-123.32507, 41.97321], [-123.32619, 41.97318], [-123.33095, 41.97246], [-123.33512, 41.9727], [-123.33726, 41.97397], [-123.33749, 41.97552], [-123.33802, 41.97658], [-123.34118, 41.97914], [-123.34189, 41.98044], [-123.34289, 41.98137], [-123.34294, 41.98244], [-123.3416, 41.9844], [-123.34243, 41.98522], [-123.34283, 41.98688], [-123.34295, 41.98951], [-123.34317, 41.99071], [-123.34518, 41.99134], [-123.34515, 41.99161], [-123.34643, 41.99194], [-123.34705, 41.99504], [-123.34862, 41.99775], [-123.35028, 41.99891], [-123.3504, 41.99919]], [[-122.94949, 42.00203], [-122.94977, 41.98739], [-122.9304, 41.98765], [-122.93009, 42.00205], [-122.94949, 42.00203]], [[-122.96903, 41.98733], [-122.96924, 41.97303], [-122.94976, 41.97329], [-122.94978, 41.98738], [-122.96903, 41.98733]], [[-122.98857, 41.9729], [-122.98869, 41.95849], [-122.96851, 41.95858], [-122.96925, 41.97303], [-122.98857, 41.9729]], [[-122.98838, 41.98738], [-122.98837, 41.98737], [-122.96905, 41.98733], [-122.96861, 42.00208], [-122.98831, 42.00195], [-122.98838, 41.98738]], [[-123.00741, 41.97338], [-122.98858, 41.97291], [-122.98838, 41.98737], [-123.00727, 41.98776], [-123.00741, 41.97338]], [[-123.02676, 41.97349], [-123.02706, 41.95918], [-123.00766, 41.95893], [-123.00741, 41.97336], [-123.02676, 41.97349]], [[-123.0265, 41.98779], [-123.02651, 41.9878], [-123.03129, 41.98783], [-123.03152, 41.97354], [-123.02677, 41.97349], [-123.0265, 41.98779]], [[-123.06494, 41.99069], [-123.06618, 41.99068], [-123.06622, 41.98798], [-123.065, 41.98799], [-123.06489, 41.98987], [-123.06006, 41.98979], [-123.05998, 41.99155], [-123.06241, 41.99166], [-123.06225, 41.99961], [-123.06476, 41.99959], [-123.06494, 41.99069]], [[-123.08049, 41.95939], [-123.08048, 41.95938], [-123.06599, 41.95966], [-123.06566, 41.96675], [-123.08038, 41.96667], [-123.08049, 41.95939]], [[-123.10192, 41.95555], [-123.0994, 41.95465], [-123.09925, 41.95236], [-123.09704, 41.9521], [-123.09721, 41.9544], [-123.09816, 41.95449], [-123.09829, 41.95796], [-123.10087, 41.95898], [-123.10036, 41.96017], [-123.09728, 41.96375], [-123.09885, 41.96464], [-123.09799, 41.96574], [-123.09905, 41.96656], [-123.1024, 41.96284], [-123.10114, 41.96198], [-123.10193, 41.96101], [-123.10276, 41.95894], [-123.10324, 41.9571], [-123.10436, 41.95537], [-123.10226, 41.95454], [-123.10192, 41.95555]], [[-123.11342, 41.94415], [-123.11575, 41.9406], [-123.11375, 41.9405], [-123.1112, 41.94419], [-123.11079, 41.94645], [-123.11077, 41.95448], [-123.1086, 41.95449], [-123.10854, 41.95625], [-123.10851, 41.95881], [-123.10831, 41.96012], [-123.10614, 41.96015], [-123.10624, 41.96343], [-123.10837, 41.96341], [-123.10842, 41.96423], [-123.11051, 41.96417], [-123.10949, 41.97363], [-123.10521, 41.98408], [-123.10532, 41.98587], [-123.10515, 41.98776], [-123.1042, 41.99028], [-123.10379, 41.99272], [-123.10485, 41.9948], [-123.1069, 41.99475], [-123.10583, 41.99261], [-123.10634, 41.99016], [-123.10726, 41.98757], [-123.10741, 41.9858], [-123.10731, 41.98416], [-123.11171, 41.97365], [-123.11288, 41.96416], [-123.11517, 41.96408], [-123.11521, 41.95866], [-123.11523, 41.94645], [-123.11554, 41.94416], [-123.11342, 41.94415]], [[-123.12642, 41.99942], [-123.12633, 42.00135], [-123.12629, 42.00248], [-123.13525, 42.00257], [-123.13532, 41.99945], [-123.12642, 41.99942]]], [[[-123.04563, 42.00211], [-123.0455, 42.0033], [-123.04404, 42.00315], [-123.04156, 42.00315], [-123.04166, 42.00211], [-123.04563, 42.00211]]]]} | Open Access 1 | 9516 | Rogue River National Forest | 14103 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | http://www.fs.usda.gov/rogue-siskiyou/ | Siskiyou 28 | 51518.078 | Rogue River NF | 1908 | National Forest 11 | 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]);