units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 24, DES_TP = 82 and MNG_AGENCY = 142
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- United States Army Corps of Engineers · 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13002 | 13002 | 13001 | {"type": "Polygon", "coordinates": [[[-123.18969, 39.19385], [-123.18868, 39.19444], [-123.18745, 39.19594], [-123.18723, 39.19605], [-123.18768, 39.19623], [-123.18788, 39.19648], [-123.18729, 39.19717], [-123.1881, 39.19824], [-123.18711, 39.19867], [-123.18619, 39.19918], [-123.18623, 39.19956], [-123.18722, 39.19954], [-123.18724, 39.19966], [-123.18725, 39.20048], [-123.18723, 39.2011], [-123.18767, 39.20122], [-123.18819, 39.20129], [-123.18857, 39.20148], [-123.18872, 39.20174], [-123.1888, 39.20198], [-123.18878, 39.20227], [-123.18855, 39.20273], [-123.18688, 39.20339], [-123.18685, 39.20515], [-123.18808, 39.20632], [-123.18806, 39.20806], [-123.18769, 39.21058], [-123.18551, 39.21061], [-123.18568, 39.21192], [-123.18521, 39.21195], [-123.18556, 39.21298], [-123.18536, 39.21329], [-123.18485, 39.21399], [-123.18578, 39.21499], [-123.18697, 39.21652], [-123.18498, 39.21651], [-123.18565, 39.21901], [-123.18318, 39.21979], [-123.18179, 39.22083], [-123.18131, 39.22122], [-123.18292, 39.22212], [-123.18356, 39.22336], [-123.18468, 39.22568], [-123.18484, 39.22592], [-123.18496, 39.22779], [-123.18497, 39.23], [-123.18504, 39.23102], [-123.18504, 39.23139], [-123.18489, 39.23301], [-123.1848, 39.23465], [-123.18476, 39.23507], [-123.18451, 39.23522], [-123.18403, 39.23564], [-123.18216, 39.23709], [-123.18297, 39.23718], [-123.18274, 39.23902], [-123.18383, 39.23906], [-123.18469, 39.2393], [-123.18467, 39.24057], [-123.18271, 39.24068], [-123.17973, 39.24059], [-123.17686, 39.2401], [-123.1747, 39.23893], [-123.17133, 39.23855], [-123.16923, 39.2392], [-123.16719, 39.23903], [-123.1665, 39.23906], [-123.16412, 39.23877], [-123.16311, 39.23862], [-123.1631, 39.23845], [-123.16015, 39.23882], [-123.15948, 39.23875], [-123.15876, 39.23878], [-123.15489, 39.23751], [-123.15465, 39.2368], [-123.15307, 39.23719], [-123.153, 39.23736], [-123.15291, 39.23749], [-123.15289, 39.23755], [-123.1528, 39.23771], [-123.15269, 39.23783], [-123.15242, 39.23798], [-123.15232, 39.23799], [-123.15222, 39.23798], [-123.15214, 39.23793], [-123.15204, 39.23779], [-123.15202, 39.23765], [-123.15203, 39.23744], [-123.15072, 39.23776], [-123.15066, 39.23518], [-123.15065, 39.2333], [-123.16272, 39.23321], [-123.16274, 39.23021], [-123.16012, 39.22825], [-123.15878, 39.22847], [-123.1587, 39.22684], [-123.1587, 39.22437], [-123.15878, 39.22154], [-123.15875, 39.22073], [-123.16012, 39.2208], [-123.16013, 39.22017], [-123.15454, 39.2148], [-123.15502, 39.21386], [-123.15563, 39.21221], [-123.15913, 39.21217], [-123.15927, 39.20985], [-123.16014, 39.20967], [-123.16245, 39.20907], [-123.16256, 39.20874], [-123.16335, 39.20876], [-123.16426, 39.2077], [-123.16427, 39.20746], [-123.16426, 39.20746], [-123.16273, 39.20776], [-123.16014, 39.20755], [-123.15926, 39.20763], [-123.15856, 39.20697], [-123.15738, 39.20541], [-123.15661, 39.20285], [-123.15524, 39.20266], [-123.1552, 39.20336], [-123.15297, 39.20333], [-123.15306, 39.19975], [-123.15552, 39.19975], [-123.15555, 39.196], [-123.16017, 39.19594], [-123.16018, 39.19242], [-123.16047, 39.19248], [-123.16838, 39.19245], [-123.1694, 39.18962], [-123.16985, 39.18894], [-123.17206, 39.18893], [-123.17381, 39.18831], [-123.1738, 39.18951], [-123.17522, 39.18949], [-123.17523, 39.19041], [-123.17517, 39.19248], [-123.17776, 39.19251], [-123.1785, 39.19144], [-123.17799, 39.19083], [-123.17835, 39.1904], [-123.18123, 39.19038], [-123.18243, 39.19216], [-123.18258, 39.19232], [-123.18276, 39.19243], [-123.18315, 39.19252], [-123.18444, 39.19253], [-123.18488, 39.19271], [-123.18508, 39.19298], [-123.18512, 39.19315], [-123.18531, 39.19312], [-123.18549, 39.19305], [-123.18572, 39.19303], [-123.18615, 39.19307], [-123.18641, 39.19301], [-123.18685, 39.19276], [-123.18777, 39.19253], [-123.18739, 39.19398], [-123.18944, 39.1937], [-123.18969, 39.19385]]]} | Open Access 1 | 31030 | Lake Mendocino | 13566 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://corpslakes.usace.army.mil/visitors/projects.cfm?Id=L374645 | Mendocino 24 | 3201.844 | Lake Mendocino | 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]);