calands: units_with_maps: 3 rows where ACCESS_TYP = 1, COUNTY = 2 and MNG

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

3 rows where ACCESS_TYP = 1, COUNTY = 2 and MNG_AGENCY = 25

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	YR_EST	DES_TP	GAP_STS
5955	5955	5954	{"type": "Polygon", "coordinates": [[[-120.98655, 37.40316], [-120.98645, 37.4037], [-120.9858, 37.40327], [-120.98326, 37.4014], [-120.98204, 37.40081], [-120.98154, 37.40063], [-120.98443, 37.39949], [-120.98456, 37.39989], [-120.98467, 37.40012], [-120.98472, 37.40027], [-120.98493, 37.40061], [-120.98501, 37.40078], [-120.98513, 37.40095], [-120.98522, 37.40114], [-120.98557, 37.40154], [-120.98567, 37.40168], [-120.98599, 37.40248], [-120.98621, 37.40281], [-120.98643, 37.40306], [-120.98655, 37.40316]]]}	Open Access 1	518	West Hilmar Wildlife Area	30516	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/West-Hilmar-WA	Stanislaus 2	16.656	West Hilmar Wildlife Area	1994	State Conservation Area 8	2
7996	7996	7995	{"type": "MultiPolygon", "coordinates": [[[[-120.84563, 37.61895], [-120.84545, 37.61903], [-120.84473, 37.62007], [-120.84403, 37.62084], [-120.84261, 37.62181], [-120.84163, 37.62226], [-120.84153, 37.62225], [-120.84196, 37.62189], [-120.84148, 37.62063], [-120.84163, 37.61955], [-120.84195, 37.61932], [-120.84163, 37.61895], [-120.8422, 37.61857], [-120.84301, 37.61756], [-120.84275, 37.61605], [-120.84369, 37.61618], [-120.84406, 37.61629], [-120.84379, 37.61775], [-120.8443, 37.61762], [-120.84492, 37.61786], [-120.84529, 37.61767], [-120.84563, 37.61895]]], [[[-120.85093, 37.61827], [-120.84939, 37.61906], [-120.84879, 37.61899], [-120.84793, 37.6187], [-120.84729, 37.61865], [-120.84609, 37.61872], [-120.84574, 37.61743], [-120.84684, 37.61692], [-120.84745, 37.61661], [-120.84873, 37.61675], [-120.84972, 37.6172], [-120.85027, 37.61796], [-120.85068, 37.6181], [-120.85055, 37.61819], [-120.85055, 37.61821], [-120.85093, 37.61827]]]]}	Open Access 1	468	Fox Grove Fishing Access	32167	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Stanislaus 2	51.641	Fox Grove FA	0	State Recreation Area 39	4
16685	16685	16684	{"type": "MultiPolygon", "coordinates": [[[[-120.97841, 37.3416], [-120.97836, 37.34177], [-120.97784, 37.34216], [-120.97724, 37.34226], [-120.97631, 37.34346], [-120.97602, 37.34421], [-120.97597, 37.34438], [-120.97593, 37.34444], [-120.97592, 37.34454], [-120.97571, 37.34488], [-120.97566, 37.34507], [-120.97566, 37.34529], [-120.97585, 37.34562], [-120.97595, 37.3457], [-120.9761, 37.34578], [-120.97616, 37.34583], [-120.97623, 37.34593], [-120.97631, 37.34599], [-120.97645, 37.34618], [-120.9765, 37.34622], [-120.97653, 37.3465], [-120.97648, 37.34664], [-120.97638, 37.34675], [-120.97592, 37.34681], [-120.97522, 37.34713], [-120.97439, 37.34803], [-120.97413, 37.34834], [-120.97409, 37.349], [-120.97401, 37.34925], [-120.97384, 37.34926], [-120.9733, 37.34921], [-120.97302, 37.34913], [-120.97249, 37.34892], [-120.97213, 37.34876], [-120.97184, 37.3486], [-120.97152, 37.34829], [-120.97138, 37.34808], [-120.97134, 37.34775], [-120.97134, 37.34749], [-120.97126, 37.34733], [-120.97109, 37.34711], [-120.96997, 37.34605], [-120.96958, 37.34575], [-120.96932, 37.34557], [-120.96885, 37.34538], [-120.9684, 37.34534], [-120.96801, 37.34533], [-120.96768, 37.34541], [-120.96728, 37.34554], [-120.96644, 37.34592], [-120.966, 37.34606], [-120.9657, 37.34614], [-120.96509, 37.34611], [-120.96489, 37.34605], [-120.96472, 37.34591], [-120.96458, 37.34575], [-120.96456, 37.3457], [-120.96414, 37.34562], [-120.96368, 37.34567], [-120.96483, 37.34478], [-120.96516, 37.34488], [-120.96913, 37.34174], [-120.97186, 37.33963], [-120.97223, 37.34008], [-120.9724, 37.34033], [-120.97254, 37.34045], [-120.9729, 37.34067], [-120.97314, 37.34073], [-120.97354, 37.34078], [-120.97394, 37.34076], [-120.97433, 37.34066], [-120.97448, 37.34049], [-120.9746, 37.34029], [-120.97481, 37.34028], [-120.97511, 37.34037], [-120.97545, 37.34056], [-120.97565, 37.34081], [-120.97561, 37.34127], [-120.97572, 37.34147], [-120.97589, 37.34162], [-120.97629, 37.34168], [-120.97656, 37.34166], [-120.97675, 37.34156], [-120.97696, 37.34126], [-120.97724, 37.34099], [-120.97745, 37.34086], [-120.97767, 37.3408], [-120.97841, 37.3416]]], [[[-120.98615, 37.33757], [-120.98331, 37.3402], [-120.98007, 37.33795], [-120.97985, 37.33808], [-120.97922, 37.33829], [-120.97886, 37.33864], [-120.9787, 37.33868], [-120.97846, 37.33862], [-120.97829, 37.33845], [-120.97835, 37.33802], [-120.9782, 37.33758], [-120.97827, 37.33732], [-120.97864, 37.33699], [-120.9787, 37.33671], [-120.97849, 37.33651], [-120.97757, 37.33614], [-120.97721, 37.33617], [-120.97642, 37.33657], [-120.97703, 37.33682], [-120.97706, 37.33694], [-120.97694, 37.33726], [-120.9765, 37.3376], [-120.97605, 37.33773], [-120.97615, 37.33803], [-120.97617, 37.3384], [-120.97616, 37.33881], [-120.97622, 37.33908], [-120.97606, 37.33931], [-120.97641, 37.33963], [-120.97653, 37.33999], [-120.9768, 37.34041], [-120.97736, 37.34051], [-120.97778, 37.34046], [-120.97722, 37.34065], [-120.97696, 37.34083], [-120.97683, 37.34099], [-120.97666, 37.34109], [-120.9765, 37.34136], [-120.97641, 37.3414], [-120.9763, 37.34142], [-120.97606, 37.34137], [-120.97598, 37.34132], [-120.97594, 37.34122], [-120.97599, 37.34099], [-120.97599, 37.34083], [-120.9759, 37.34057], [-120.97565, 37.34034], [-120.97522, 37.34011], [-120.97487, 37.34], [-120.97475, 37.33999], [-120.97453, 37.34002], [-120.97436, 37.34007], [-120.9743, 37.34013], [-120.97421, 37.34031], [-120.97413, 37.3404], [-120.97404, 37.34044], [-120.97388, 37.34049], [-120.97357, 37.3405], [-120.97322, 37.34047], [-120.97311, 37.34045], [-120.97279, 37.34026], [-120.97265, 37.34015], [-120.97252, 37.33994], [-120.97224, 37.3396], [-120.97211, 37.33943], [-120.975, 37.33717], [-120.97945, 37.33371], [-120.98484, 37.33624], [-120.98615, 37.33757]]]]}	Open Access 1	493	North Grasslands Wildlife Area	30482	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/North-Grasslands-WA	Stanislaus 2	253.111	North Grasslands Wildlife Area	1992	State Conservation Area 8	2

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]);