units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 82 and MNG_AGENCY = 37
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- United States Forest Service · 1 ✖
DES_TP 1
- Resource Management Area · 1 ✖
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6009 | 6009 | 6008 | {"type": "MultiPolygon", "coordinates": [[[[-119.97265, 38.19975], [-119.97151, 38.20038], [-119.97128, 38.20049], [-119.97101, 38.20033], [-119.96999, 38.19966], [-119.97195, 38.19831], [-119.97261, 38.19962], [-119.97265, 38.19975]]], [[[-119.97067, 38.1968], [-119.97053, 38.19699], [-119.97043, 38.19716], [-119.97008, 38.19715], [-119.9701, 38.19687], [-119.97033, 38.19666], [-119.97067, 38.1968]]], [[[-119.97859, 38.19362], [-119.97835, 38.19384], [-119.97793, 38.19336], [-119.97819, 38.19316], [-119.97848, 38.19347], [-119.97859, 38.19362]]], [[[-119.98219, 38.19251], [-119.98193, 38.19258], [-119.98177, 38.19232], [-119.98208, 38.19229], [-119.98219, 38.19251]]], [[[-119.99129, 38.18838], [-119.99118, 38.18838], [-119.99077, 38.18833], [-119.99109, 38.18814], [-119.99129, 38.18838]]], [[[-119.99305, 38.19376], [-119.99224, 38.19413], [-119.99183, 38.1943], [-119.9908, 38.19375], [-119.99119, 38.19336], [-119.99142, 38.1935], [-119.99205, 38.19384], [-119.99252, 38.1938], [-119.99298, 38.19368], [-119.99305, 38.19376]]], [[[-119.99211, 38.19559], [-119.99185, 38.196], [-119.99146, 38.19556], [-119.99154, 38.19545], [-119.99182, 38.19528], [-119.99211, 38.19559]]], [[[-119.99377, 38.19211], [-119.99371, 38.19246], [-119.99368, 38.19301], [-119.9932, 38.19329], [-119.99291, 38.19273], [-119.99262, 38.19233], [-119.99212, 38.19191], [-119.99339, 38.19164], [-119.99377, 38.19211]]], [[[-119.99296, 38.18735], [-119.99283, 38.18746], [-119.99258, 38.18737], [-119.99278, 38.18716], [-119.99296, 38.18735]]], [[[-119.99449, 38.19314], [-119.99442, 38.19328], [-119.99354, 38.1936], [-119.9935, 38.19353], [-119.99372, 38.19343], [-119.99382, 38.19217], [-119.99438, 38.19239], [-119.99443, 38.19248], [-119.99443, 38.19256], [-119.99437, 38.19266], [-119.99435, 38.19282], [-119.99439, 38.19297], [-119.99449, 38.19314]]], [[[-119.99432, 38.19396], [-119.99399, 38.1941], [-119.99383, 38.19414], [-119.99354, 38.19368], [-119.99404, 38.19351], [-119.99432, 38.19396]]], [[[-120.00369, 38.19183], [-119.99976, 38.19184], [-120.00003, 38.19149], [-120.0002, 38.19133], [-120.00044, 38.1911], [-120.00063, 38.19096], [-120.00038, 38.19067], [-119.9998, 38.19113], [-119.99923, 38.19184], [-119.99908, 38.19184], [-119.9987, 38.19211], [-119.99844, 38.19238], [-119.99812, 38.19265], [-119.99795, 38.19277], [-119.99785, 38.19284], [-119.99676, 38.19329], [-119.99651, 38.19329], [-119.99546, 38.19316], [-119.99498, 38.19317], [-119.99478, 38.19315], [-119.99462, 38.19305], [-119.99453, 38.19293], [-119.99451, 38.19287], [-119.9945, 38.19272], [-119.99458, 38.19259], [-119.99471, 38.19249], [-119.99488, 38.19243], [-119.99504, 38.19242], [-119.99524, 38.1926], [-119.99561, 38.19247], [-119.9959, 38.19226], [-119.9959, 38.19225], [-119.99568, 38.19201], [-119.99594, 38.19186], [-119.99594, 38.19184], [-119.99428, 38.19189], [-119.99431, 38.19175], [-119.9943, 38.19174], [-119.99384, 38.19184], [-119.99358, 38.19148], [-119.99354, 38.19133], [-119.99401, 38.19118], [-119.9942, 38.19133], [-119.99422, 38.19133], [-119.99444, 38.18822], [-119.99489, 38.18829], [-119.99461, 38.18789], [-119.99489, 38.18779], [-119.995, 38.18803], [-119.99506, 38.18828], [-119.9952, 38.18821], [-119.99906, 38.1882], [-119.99905, 38.18989], [-119.99951, 38.18988], [-119.99928, 38.18999], [-119.99947, 38.19019], [-119.99966, 38.19022], [-119.9999, 38.19015], [-120.00023, 38.19016], [-120.00072, 38.18995], [-120.00207, 38.18999], [-120.00137, 38.19032], [-120.00066, 38.19053], [-120.00044, 38.19061], [-120.00064, 38.19095], [-120.00089, 38.19086], [-120.00155, 38.19065], [-120.00231, 38.19032], [-120.00276, 38.1901], [-120.0032, 38.18995], [-120.00368, 38.18991], [-120.00369, 38.19183]]], [[[-119.99405, 38.18735], [-119.99405, 38.18735], [-119.99362, 38.18721], [-119.99394, 38.18718], [-119.99401, 38.18725], [-119.99405, 38.18735]]], [[[-119.99908, 38.19356], [-119.99851, 38.19358], [-119.99798, 38.19356], [-119.99787, 38.19321], [-119.99795, 38.19287], [-119.99821, 38.19277], [-119.99831, 38.19301], [-119.99868, 38.1929], [-119.99886, 38.19276], [-119.99859, 38.19249], [-119.99874, 38.19233], [-119.999, 38.19262], [-119.99907, 38.19256], [-119.99908, 38.19356]]], [[[-120.00473, 38.18395], [-120.00422, 38.18422], [-120.00298, 38.18412], [-120.00185, 38.18419], [-120.00096, 38.1843], [-120.00044, 38.18406], [-120.00065, 38.18372], [-120.00166, 38.18357], [-120.00282, 38.18328], [-120.00372, 38.18327], [-120.00473, 38.18395]]], [[[-120.00292, 38.18727], [-120.0027, 38.1875], [-120.00201, 38.18725], [-120.00217, 38.18704], [-120.00292, 38.18727]]], [[[-120.00551, 38.19068], [-120.00404, 38.191], [-120.00404, 38.191], [-120.00406, 38.19069], [-120.0049, 38.19028], [-120.00537, 38.19015], [-120.00551, 38.19068]]], [[[-120.0071, 38.18991], [-120.00691, 38.19008], [-120.00657, 38.19032], [-120.0062, 38.18988], [-120.00559, 38.18985], [-120.00588, 38.18942], [-120.00618, 38.18942], [-120.00679, 38.18923], [-120.00709, 38.18929], [-120.0071, 38.18991]]]]} | Open Access 1 | 651 | Lower Strawberry Lake | 21567 | 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 | Tuolumne 21 | 99.748 | Lower Strawberry Lake | 0 | Resource Management Area 82 | 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]);