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

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

2 rows where ACCESS_TYP = 3, COUNTY = 41 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
5300	5300	5299	{"type": "MultiPolygon", "coordinates": [[[[-121.18376, 38.65361], [-121.18399, 38.65391], [-121.18416, 38.6543], [-121.18413, 38.65478], [-121.1838, 38.65551], [-121.18292, 38.65658], [-121.18294, 38.65671], [-121.18263, 38.65677], [-121.18258, 38.65676], [-121.18253, 38.65672], [-121.18241, 38.65632], [-121.18252, 38.6563], [-121.18297, 38.65581], [-121.18297, 38.65579], [-121.18327, 38.65543], [-121.18339, 38.65523], [-121.18347, 38.65505], [-121.18351, 38.65489], [-121.18353, 38.65459], [-121.18351, 38.65442], [-121.18347, 38.65426], [-121.18341, 38.65411], [-121.18332, 38.65395], [-121.18376, 38.65361]]], [[[-121.1775, 38.65766], [-121.17724, 38.65766], [-121.17681, 38.65767], [-121.17695, 38.6573], [-121.17699, 38.65723], [-121.17727, 38.6573], [-121.1775, 38.65766]]], [[[-121.18181, 38.6564], [-121.18133, 38.65641], [-121.18118, 38.65638], [-121.18154, 38.65764], [-121.17965, 38.65765], [-121.17951, 38.65699], [-121.17964, 38.65691], [-121.17978, 38.6568], [-121.17998, 38.65658], [-121.18023, 38.6566], [-121.18049, 38.65647], [-121.18085, 38.65634], [-121.18106, 38.65628], [-121.18174, 38.65614], [-121.18181, 38.6564]]], [[[-121.16883, 38.65782], [-121.16836, 38.65788], [-121.16795, 38.65796], [-121.1624, 38.65959], [-121.16182, 38.65971], [-121.16065, 38.65986], [-121.16031, 38.65992], [-121.15986, 38.66003], [-121.1592, 38.66024], [-121.15812, 38.66065], [-121.15819, 38.66028], [-121.15832, 38.65994], [-121.15854, 38.65957], [-121.15879, 38.65927], [-121.1591, 38.659], [-121.15945, 38.65877], [-121.15984, 38.65858], [-121.16031, 38.65842], [-121.1607, 38.65833], [-121.16104, 38.65829], [-121.16214, 38.65827], [-121.16277, 38.65822], [-121.1634, 38.65812], [-121.16389, 38.65802], [-121.16461, 38.65781], [-121.16519, 38.65759], [-121.16574, 38.65734], [-121.16634, 38.657], [-121.16673, 38.65683], [-121.1672, 38.6567], [-121.16753, 38.65664], [-121.1678, 38.65661], [-121.16833, 38.65659], [-121.1684, 38.65662], [-121.16854, 38.65713], [-121.16883, 38.65782]]], [[[-121.17581, 38.6616], [-121.17428, 38.66147], [-121.17177, 38.65885], [-121.17157, 38.65867], [-121.1714, 38.65854], [-121.17118, 38.65839], [-121.17093, 38.65825], [-121.17067, 38.65813], [-121.1704, 38.65803], [-121.16989, 38.6579], [-121.16954, 38.65784], [-121.16927, 38.65782], [-121.16894, 38.65702], [-121.16886, 38.65674], [-121.16884, 38.65663], [-121.16885, 38.65659], [-121.16892, 38.65655], [-121.1708, 38.65644], [-121.17123, 38.65639], [-121.17176, 38.65628], [-121.17197, 38.65661], [-121.17204, 38.65701], [-121.17178, 38.65703], [-121.17187, 38.65762], [-121.17193, 38.6577], [-121.17199, 38.65773], [-121.17206, 38.65774], [-121.17272, 38.65767], [-121.17294, 38.65768], [-121.1731, 38.65773], [-121.17393, 38.65813], [-121.17408, 38.65817], [-121.1742, 38.65817], [-121.17433, 38.65815], [-121.17525, 38.65775], [-121.17525, 38.65774], [-121.17491, 38.65778], [-121.17502, 38.65771], [-121.17522, 38.65753], [-121.17547, 38.65753], [-121.17523, 38.65863], [-121.17581, 38.6616]]]]}	No Public Access 3	5033	Willow Creek	32350	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/Willow-Creek-WA	Sacramento 41	78.145	Willow Creek	0	State Resource Management Area 55	3
6527	6527	6526	{"type": "Polygon", "coordinates": [[[-121.21611, 38.65634], [-121.21517, 38.65635], [-121.2144, 38.65533], [-121.21395, 38.65428], [-121.21608, 38.65427], [-121.21611, 38.65634]]]}	No Public Access 3	2848	Phoenix Field Ecological Reserve	32261	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		Sacramento 41	8.007	Phoenix Field ER	0	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]);