units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, DES_TP = 83 and LAYER = 2
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1645 | 1645 | 1644 | {"type": "Polygon", "coordinates": [[[-121.27757, 37.98952], [-121.27753, 37.98957], [-121.27653, 37.98983], [-121.2759, 37.98828], [-121.27639, 37.98797], [-121.27641, 37.98792], [-121.27642, 37.98777], [-121.27646, 37.98766], [-121.2765, 37.9876], [-121.2766, 37.98751], [-121.27663, 37.98751], [-121.27678, 37.98768], [-121.2769, 37.98789], [-121.27757, 37.98952]]]} | Open Access 1 | 47779 | Shady Forest | 31579 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 4.969 | Shady Forest | 0 | Local Resource Management Area 83 | 3 | |
| 12311 | 12311 | 12310 | {"type": "Polygon", "coordinates": [[[-124.06293, 40.8633], [-124.06168, 40.86382], [-124.06167, 40.86462], [-124.05849, 40.86458], [-124.05808, 40.86461], [-124.05816, 40.86823], [-124.05666, 40.86826], [-124.05695, 40.86793], [-124.056, 40.86703], [-124.05661, 40.86662], [-124.05655, 40.86628], [-124.05593, 40.86594], [-124.05562, 40.86552], [-124.05559, 40.8648], [-124.05405, 40.86469], [-124.05273, 40.86514], [-124.05237, 40.86543], [-124.05212, 40.86571], [-124.05251, 40.86676], [-124.05205, 40.86678], [-124.05186, 40.86676], [-124.05124, 40.86658], [-124.0522, 40.8645], [-124.05184, 40.86447], [-124.05103, 40.86453], [-124.05046, 40.86427], [-124.05034, 40.86406], [-124.04936, 40.86388], [-124.04936, 40.86398], [-124.04909, 40.86398], [-124.04906, 40.86381], [-124.0482, 40.86377], [-124.04815, 40.86218], [-124.04621, 40.86218], [-124.0462, 40.86111], [-124.04623, 40.8611], [-124.04619, 40.86003], [-124.04329, 40.86005], [-124.04329, 40.85365], [-124.04388, 40.85362], [-124.04389, 40.85358], [-124.05275, 40.85358], [-124.05275, 40.85386], [-124.05268, 40.85387], [-124.05261, 40.8544], [-124.05296, 40.85444], [-124.05292, 40.85476], [-124.05565, 40.855], [-124.05558, 40.8563], [-124.05483, 40.85629], [-124.0548, 40.8571], [-124.05575, 40.85701], [-124.05572, 40.85733], [-124.05572, 40.85752], [-124.0561, 40.85751], [-124.05611, 40.85765], [-124.05672, 40.85764], [-124.05673, 40.85781], [-124.05783, 40.8578], [-124.05794, 40.86208], [-124.06258, 40.86195], [-124.06259, 40.86217], [-124.06228, 40.8623], [-124.06293, 40.8633]]]} | Open Access 1 | 46883 | Sunny Brae Forest | 30365 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/190/City-Forests | Humboldt 45 | 342.381 | Sunny Brae Forest | 0 | Local Resource Management Area 83 | 3 |
| 13180 | 13180 | 13179 | {"type": "Polygon", "coordinates": [[[-124.07492, 40.87037], [-124.07461, 40.87119], [-124.07397, 40.87105], [-124.0737, 40.87112], [-124.07367, 40.87137], [-124.07234, 40.87141], [-124.07235, 40.8723], [-124.07129, 40.87238], [-124.07056, 40.87281], [-124.0682, 40.87301], [-124.06744, 40.87317], [-124.06677, 40.87295], [-124.06378, 40.87317], [-124.06381, 40.87372], [-124.06444, 40.87406], [-124.06534, 40.87462], [-124.06537, 40.87559], [-124.06714, 40.87566], [-124.06821, 40.87656], [-124.06822, 40.87759], [-124.0653, 40.87896], [-124.06241, 40.87839], [-124.06239, 40.8784], [-124.0624, 40.87901], [-124.06237, 40.88], [-124.06555, 40.88184], [-124.06606, 40.88233], [-124.06712, 40.88074], [-124.06768, 40.8814], [-124.06846, 40.88182], [-124.06902, 40.88199], [-124.07094, 40.88148], [-124.07235, 40.88141], [-124.0722, 40.88199], [-124.07224, 40.88215], [-124.07251, 40.88258], [-124.07253, 40.88301], [-124.07212, 40.88302], [-124.0721, 40.88305], [-124.06825, 40.883], [-124.06812, 40.88314], [-124.06791, 40.88307], [-124.06779, 40.88306], [-124.06763, 40.88299], [-124.06229, 40.88293], [-124.0575, 40.88284], [-124.05761, 40.87934], [-124.0432, 40.87927], [-124.04326, 40.8719], [-124.04336, 40.86838], [-124.04635, 40.86837], [-124.05141, 40.86833], [-124.05143, 40.86674], [-124.0518, 40.86688], [-124.05202, 40.86692], [-124.0521, 40.86691], [-124.05214, 40.86695], [-124.05213, 40.86832], [-124.05283, 40.86832], [-124.05285, 40.87227], [-124.05337, 40.87223], [-124.06248, 40.87221], [-124.06249, 40.87019], [-124.06309, 40.86987], [-124.06369, 40.86962], [-124.06409, 40.86941], [-124.06445, 40.86926], [-124.06465, 40.86922], [-124.06486, 40.86915], [-124.06589, 40.86866], [-124.06606, 40.86862], [-124.06629, 40.86862], [-124.06665, 40.86874], [-124.0669, 40.86879], [-124.06714, 40.86879], [-124.06781, 40.86875], [-124.06879, 40.86889], [-124.06915, 40.8689], [-124.06946, 40.86887], [-124.06977, 40.8688], [-124.0709, 40.86834], [-124.07478, 40.86835], [-124.07413, 40.87001], [-124.0745, 40.87028], [-124.07492, 40.87037]]]} | Open Access 1 | 35163 | Arcata Community Forest | 295 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/departments/environmental-services/city-forests/trail-map | Humboldt 45 | 635.854 | Arcata Community Forest | 0 | Local Resource Management Area 83 | 3 |
| 14362 | 14362 | 14361 | {"type": "MultiPolygon", "coordinates": [[[[-123.96881, 40.76594], [-123.96843, 40.77321], [-123.96403, 40.77343], [-123.96412, 40.76959], [-123.95934, 40.76956], [-123.95942, 40.76594], [-123.96881, 40.76594]]], [[[-124.02575, 40.80099], [-124.0257, 40.80435], [-124.0238, 40.80431], [-124.02377, 40.80399], [-124.02352, 40.8035], [-124.01846, 40.80341], [-124.01846, 40.80343], [-124.01876, 40.8037], [-124.02005, 40.80424], [-124.01847, 40.8042], [-124.01839, 40.80273], [-124.01563, 40.8027], [-124.01563, 40.79911], [-124.01105, 40.79908], [-124.01102, 40.7955], [-124.00601, 40.79549], [-124.006, 40.7955], [-124.00618, 40.80264], [-124.00165, 40.80259], [-124.00144, 40.79549], [-123.99235, 40.79551], [-123.99251, 40.79172], [-123.98774, 40.79175], [-123.98815, 40.78049], [-123.96805, 40.78043], [-123.96824, 40.77693], [-123.9731, 40.77694], [-123.97319, 40.77324], [-123.98792, 40.77331], [-123.98804, 40.777], [-123.99277, 40.777], [-123.99283, 40.78058], [-124.00117, 40.78074], [-124.00195, 40.78074], [-124.00191, 40.78596], [-124.00542, 40.78861], [-124.00615, 40.78861], [-124.00608, 40.79181], [-124.00847, 40.79184], [-124.01352, 40.79551], [-124.01594, 40.79552], [-124.01841, 40.79731], [-124.01843, 40.79731], [-124.01843, 40.79552], [-124.02091, 40.79553], [-124.02089, 40.79914], [-124.02336, 40.79915], [-124.02336, 40.80097], [-124.02575, 40.80099]]]]} | Open Access 1 | 47021 | Jacoby Creek Forest | 30669 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1249.576 | Jacoby Creek Forest | 0 | Local Resource Management Area 83 | 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]);