calands: units_with_maps: 7 rows where ACCESS_TYP = 1, DES_TP = 83 and YR

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

7 rows where ACCESS_TYP = 1, DES_TP = 83 and YR_EST = 0

Search:

descending

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	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	Local Resource Management Area 83	3
3221	3221	3220	{"type": "MultiPolygon", "coordinates": [[[[-122.05636, 37.06805], [-122.05632, 37.06826], [-122.05628, 37.06839], [-122.05403, 37.06845], [-122.05426, 37.06687], [-122.05508, 37.06687], [-122.05633, 37.06758], [-122.05637, 37.06781], [-122.05636, 37.06805]]], [[[-122.05697, 37.06801], [-122.05695, 37.06828], [-122.05687, 37.06839], [-122.0566, 37.06838], [-122.05663, 37.06831], [-122.05683, 37.06804], [-122.05697, 37.06801]]]]}	Open Access 1	28263	Olympia Watershed	23140	2277	San Lorenzo Valley Water District 598	Special District 4	Water District 13	http://www.slvwd.com/	Special District 4	2277	San Lorenzo Valley Water District 588	Special District 4	Water District 13		Santa Cruz 5	7.404	Olympia Watershed	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	Local Resource Management Area 83	3
12488	12488	12487	{"type": "MultiPolygon", "coordinates": [[[[-122.05633, 37.06758], [-122.05508, 37.06687], [-122.05426, 37.06688], [-122.05391, 37.06928], [-122.0539, 37.07086], [-122.05482, 37.07089], [-122.05476, 37.07121], [-122.05471, 37.07121], [-122.05466, 37.07168], [-122.0546, 37.07198], [-122.0545, 37.07228], [-122.05438, 37.07257], [-122.05431, 37.07272], [-122.05415, 37.07268], [-122.05385, 37.07305], [-122.05376, 37.07321], [-122.05304, 37.07303], [-122.05303, 37.07316], [-122.05276, 37.07333], [-122.05239, 37.07369], [-122.05098, 37.07334], [-122.05101, 37.07281], [-122.05094, 37.07198], [-122.04375, 37.07205], [-122.04368, 37.06849], [-122.0439, 37.06847], [-122.04404, 37.06485], [-122.04573, 37.06487], [-122.0461, 37.06672], [-122.04763, 37.06707], [-122.05087, 37.06648], [-122.05087, 37.06611], [-122.05593, 37.06624], [-122.05633, 37.06758]]], [[[-122.05723, 37.06835], [-122.05686, 37.06905], [-122.05675, 37.06984], [-122.05542, 37.06988], [-122.05554, 37.06972], [-122.05564, 37.06975], [-122.05575, 37.06975], [-122.05585, 37.06972], [-122.05593, 37.06967], [-122.05638, 37.06912], [-122.05693, 37.06831], [-122.05711, 37.06832], [-122.05723, 37.06835]]]]}	Open Access 1	28262	Olympia Watershed	23140	2277	San Lorenzo Valley Water District 598	Special District 4	Water District 13	http://www.slvwd.com/	Special District 4	2277	San Lorenzo Valley Water District 588	Special District 4	Water District 13		Santa Cruz 5	162.806	Olympia Watershed	Local Resource Management Area 83	3
12489	12489	12488	{"type": "MultiPolygon", "coordinates": [[[[-122.05628, 37.06839], [-122.0562, 37.06856], [-122.0561, 37.06872], [-122.05578, 37.06911], [-122.05556, 37.06931], [-122.05536, 37.06954], [-122.0551, 37.06989], [-122.05391, 37.06994], [-122.05391, 37.06928], [-122.05403, 37.06845], [-122.05628, 37.06839]]], [[[-122.05687, 37.06839], [-122.05638, 37.06912], [-122.05593, 37.06967], [-122.05585, 37.06972], [-122.05575, 37.06975], [-122.05564, 37.06975], [-122.05554, 37.06972], [-122.0562, 37.06899], [-122.05643, 37.0687], [-122.05653, 37.06854], [-122.0566, 37.06838], [-122.05687, 37.06839]]]]}	Open Access 1	28264	Olympia Watershed	23140	2277	San Lorenzo Valley Water District 598	Special District 4	Water District 13	http://www.slvwd.com/	Special District 4	2277	San Lorenzo Valley Water District 588	Special District 4	Water District 13		Santa Cruz 5	7.33	Olympia Watershed	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	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	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]);