units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where COUNTY = 35 and DES_TP = 49
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, YR_EST
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3264 | 3264 | 3263 | {"type": "MultiPolygon", "coordinates": [[[[-120.13722, 39.30839], [-120.13608, 39.3084], [-120.13428, 39.30937], [-120.13187, 39.30826], [-120.13015, 39.30797], [-120.12753, 39.30817], [-120.12579, 39.30885], [-120.12528, 39.31032], [-120.12629, 39.31563], [-120.12641, 39.31634], [-120.12368, 39.31634], [-120.12367, 39.31637], [-120.12356, 39.31637], [-120.10961, 39.31629], [-120.10961, 39.31389], [-120.11192, 39.31385], [-120.11204, 39.30943], [-120.11186, 39.30942], [-120.11185, 39.30922], [-120.11095, 39.30922], [-120.11095, 39.30757], [-120.11431, 39.30759], [-120.1143, 39.30237], [-120.12362, 39.30317], [-120.13021, 39.30383], [-120.13091, 39.30393], [-120.13148, 39.30406], [-120.13215, 39.30426], [-120.13257, 39.30442], [-120.13288, 39.30456], [-120.13347, 39.30487], [-120.1341, 39.30528], [-120.13435, 39.30548], [-120.13617, 39.30735], [-120.13722, 39.30839]]], [[[-120.14227, 39.28641], [-120.14222, 39.28995], [-120.14215, 39.29354], [-120.142, 39.29907], [-120.14199, 39.30079], [-120.13337, 39.30099], [-120.12359, 39.30112], [-120.12361, 39.303], [-120.1143, 39.3022], [-120.1143, 39.30215], [-120.11425, 39.30215], [-120.11425, 39.30112], [-120.11658, 39.30112], [-120.11658, 39.29738], [-120.11791, 39.29736], [-120.11795, 39.29646], [-120.12369, 39.29655], [-120.12367, 39.29728], [-120.12368, 39.29729], [-120.12849, 39.29724], [-120.12841, 39.2938], [-120.12843, 39.29195], [-120.12842, 39.2899], [-120.13331, 39.28995], [-120.1333, 39.28652], [-120.14227, 39.28641]]]]} | Open Access 1 | 23086 | Martis Creek Lake Recreation Area | 13574 | 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://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/MartisCreekLake.aspx | Placer 35 | 1112.337 | Martis Creek Lake Rec. Area | 0 | Recreation Management Area 49 | 4 |
| 10057 | 10057 | 10056 | {"type": "MultiPolygon", "coordinates": [[[[-120.15944, 39.11112], [-120.15898, 39.11163], [-120.15858, 39.11216], [-120.15822, 39.11273], [-120.15808, 39.113], [-120.158, 39.11325], [-120.15795, 39.11346], [-120.15792, 39.11367], [-120.15792, 39.11389], [-120.15794, 39.1141], [-120.15798, 39.11431], [-120.15813, 39.11475], [-120.1579, 39.11475], [-120.15779, 39.11452], [-120.1577, 39.11413], [-120.15768, 39.11388], [-120.15768, 39.11367], [-120.15773, 39.11321], [-120.15776, 39.1131], [-120.1578, 39.113], [-120.15783, 39.11279], [-120.15793, 39.11248], [-120.15795, 39.11229], [-120.15806, 39.11206], [-120.1583, 39.11158], [-120.1586, 39.11111], [-120.15944, 39.11112]]], [[[-120.16538, 39.11475], [-120.16269, 39.11475], [-120.15978, 39.11469], [-120.1595, 39.11469], [-120.15843, 39.11474], [-120.15829, 39.11437], [-120.15822, 39.11406], [-120.1582, 39.11379], [-120.15823, 39.11348], [-120.1583, 39.11322], [-120.1584, 39.11296], [-120.15873, 39.1124], [-120.15878, 39.11236], [-120.15908, 39.11237], [-120.15926, 39.11234], [-120.15943, 39.11227], [-120.15957, 39.11215], [-120.15957, 39.11245], [-120.16153, 39.1125], [-120.16154, 39.11117], [-120.16208, 39.1112], [-120.16538, 39.11475]]]]} | Open Access 1 | 49029 | Kaspian Recreation Area | 33730 | 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 | https://www.fs.usda.gov/Internet/FSE_DOCUMENTS/fseprd632577.pdf | Placer 35 | 39.38 | Kaspian Rec. Area | 0 | Recreation Management Area 49 | 4 |
| 14548 | 14548 | 14547 | {"type": "Polygon", "coordinates": [[[-121.02582, 38.9373], [-121.02254, 38.93856], [-121.02232, 38.93981], [-121.02046, 38.94222], [-121.01715, 38.94306], [-121.01682, 38.93948], [-121.01802, 38.9396], [-121.01942, 38.93915], [-121.02, 38.93743], [-121.02141, 38.93616], [-121.02233, 38.93553], [-121.02281, 38.93501], [-121.0258, 38.93502], [-121.02575, 38.93638], [-121.02582, 38.9373]]]} | Open Access 1 | 47511 | Auburn State Recreation Area | 15701 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.parks.ca.gov/?page_id=502 | Placer 35 | 76.191 | Auburn SRA | 1966 | Recreation Management Area 49 | 4 |
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]);