calands: units_with_maps: 1 row where DES_TP = 8 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bass-Hill-WA"

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

1 row where DES_TP = 8 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bass-Hill-WA"

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
16714	16714	16713	{"type": "MultiPolygon", "coordinates": [[[[-120.56401, 40.35918], [-120.56401, 40.3614], [-120.54979, 40.36155], [-120.54033, 40.36155], [-120.54033, 40.35429], [-120.53345, 40.35428], [-120.53347, 40.35366], [-120.53494, 40.35245], [-120.53464, 40.3521], [-120.53376, 40.35256], [-120.53031, 40.35237], [-120.52381, 40.35203], [-120.52422, 40.35061], [-120.52421, 40.3506], [-120.52179, 40.3506], [-120.51175, 40.34885], [-120.51159, 40.34885], [-120.51153, 40.34697], [-120.49318, 40.34684], [-120.49313, 40.34334], [-120.49074, 40.34333], [-120.49067, 40.34169], [-120.48837, 40.34159], [-120.48831, 40.33794], [-120.4859, 40.33795], [-120.48569, 40.3363], [-120.48225, 40.33629], [-120.48195, 40.32162], [-120.49729, 40.32166], [-120.49732, 40.32901], [-120.50211, 40.329], [-120.50217, 40.33264], [-120.50679, 40.33261], [-120.50678, 40.32899], [-120.53057, 40.3289], [-120.5305, 40.32552], [-120.53434, 40.32547], [-120.53454, 40.32548], [-120.53469, 40.32553], [-120.53486, 40.32567], [-120.53493, 40.32582], [-120.53496, 40.32839], [-120.53502, 40.32875], [-120.53512, 40.32895], [-120.53527, 40.32905], [-120.53544, 40.3291], [-120.53564, 40.32911], [-120.53595, 40.32908], [-120.53623, 40.32908], [-120.54228, 40.32889], [-120.54204, 40.33065], [-120.54328, 40.33067], [-120.54463, 40.33071], [-120.54464, 40.3307], [-120.54462, 40.32913], [-120.54507, 40.32988], [-120.54558, 40.3306], [-120.54624, 40.3314], [-120.54701, 40.33221], [-120.54787, 40.33292], [-120.54875, 40.33355], [-120.54968, 40.33408], [-120.55069, 40.33452], [-120.55436, 40.33589], [-120.55499, 40.33608], [-120.55907, 40.33604], [-120.55911, 40.33967], [-120.55885, 40.33967], [-120.55884, 40.33968], [-120.55949, 40.34067], [-120.55965, 40.34207], [-120.56046, 40.34235], [-120.56004, 40.34326], [-120.55917, 40.34505], [-120.55866, 40.34626], [-120.55835, 40.34693], [-120.55441, 40.34698], [-120.55447, 40.35061], [-120.5497, 40.35067], [-120.54976, 40.35793], [-120.55925, 40.35782], [-120.55925, 40.353], [-120.55979, 40.35354], [-120.55961, 40.35364], [-120.55961, 40.35365], [-120.56007, 40.35418], [-120.56401, 40.35918]]], [[[-120.60011, 40.35417], [-120.59965, 40.3544], [-120.59914, 40.35487], [-120.59901, 40.35528], [-120.59905, 40.35573], [-120.59912, 40.35599], [-120.59926, 40.35635], [-120.5993, 40.35664], [-120.59928, 40.357], [-120.5991, 40.35785], [-120.59877, 40.35879], [-120.59868, 40.35923], [-120.59864, 40.35949], [-120.59863, 40.35971], [-120.59843, 40.36012], [-120.59812, 40.36081], [-120.59811, 40.36109], [-120.59813, 40.36139], [-120.59664, 40.36139], [-120.59667, 40.36504], [-120.58709, 40.36488], [-120.57866, 40.365], [-120.57925, 40.36323], [-120.57402, 40.36078], [-120.57438, 40.35987], [-120.5723, 40.35806], [-120.57155, 40.35839], [-120.57076, 40.35762], [-120.56837, 40.35777], [-120.56836, 40.35772], [-120.56425, 40.35777], [-120.56401, 40.35746], [-120.56227, 40.35551], [-120.56161, 40.35481], [-120.56169, 40.35458], [-120.5616, 40.35445], [-120.56126, 40.35446], [-120.55925, 40.35164], [-120.55919, 40.34633], [-120.56063, 40.34329], [-120.56127, 40.34284], [-120.56198, 40.34032], [-120.56248, 40.34019], [-120.56287, 40.34056], [-120.56322, 40.34075], [-120.56384, 40.34101], [-120.56432, 40.34111], [-120.56511, 40.34111], [-120.5655, 40.34107], [-120.56583, 40.34097], [-120.56618, 40.3408], [-120.56643, 40.3406], [-120.56669, 40.34027], [-120.5669, 40.33975], [-120.56705, 40.33931], [-120.56721, 40.33904], [-120.56834, 40.33761], [-120.56956, 40.33617], [-120.57565, 40.33623], [-120.57591, 40.33645], [-120.57606, 40.33653], [-120.57614, 40.33662], [-120.57638, 40.33671], [-120.57652, 40.33682], [-120.5766, 40.33693], [-120.57679, 40.33726], [-120.57687, 40.33733], [-120.57698, 40.33738], [-120.5772, 40.33743], [-120.57782, 40.3375], [-120.57776, 40.34132], [-120.57776, 40.34684], [-120.58715, 40.34687], [-120.59183, 40.35064], [-120.59444, 40.35068], [-120.59655, 40.35069], [-120.5966, 40.35414], [-120.60011, 40.35417]]]]}	Open Access 1	5808	Bass Hill Wildlife Area	30413	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/Bass-Hill-WA	Lassen 54	5505.421	Bass Hill Wildlife Area	1977	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]);