calands: units_with_maps: 2 rows where ACCESS_TYP = 2, MNG_AGENCY = 44 and UNIT_NAME = "Butte Sink Wildlife Management Area"

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

2 rows where ACCESS_TYP = 2, MNG_AGENCY = 44 and UNIT_NAME = "Butte Sink Wildlife Management Area"

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
12172	12172	12171	{"type": "MultiPolygon", "coordinates": [[[[-122.0023, 39.55714], [-122.00067, 39.55738], [-122.00004, 39.55733], [-121.99786, 39.55722], [-121.9962, 39.55706], [-121.99474, 39.55668], [-121.99225, 39.55686], [-121.99091, 39.55726], [-121.99068, 39.55729], [-121.99098, 39.55403], [-121.99099, 39.55127], [-121.99048, 39.54485], [-121.98916, 39.54105], [-121.98522, 39.53903], [-121.9855, 39.53688], [-121.9834, 39.53577], [-121.98269, 39.53511], [-121.98042, 39.53448], [-121.9785, 39.53391], [-121.97608, 39.53414], [-121.97452, 39.53396], [-121.9725, 39.53286], [-121.97036, 39.53075], [-121.97013, 39.53024], [-121.97103, 39.53], [-121.97405, 39.52928], [-121.97381, 39.52965], [-121.9734, 39.53036], [-121.97335, 39.53079], [-121.97343, 39.53115], [-121.97367, 39.5314], [-121.9739, 39.53157], [-121.97541, 39.53246], [-121.97657, 39.53298], [-121.97737, 39.53321], [-121.97795, 39.53328], [-121.9787, 39.5333], [-121.97964, 39.53321], [-121.98059, 39.53305], [-121.98156, 39.53294], [-121.98245, 39.53293], [-121.98298, 39.53304], [-121.98325, 39.53318], [-121.9842, 39.5333], [-121.98464, 39.53314], [-121.9849, 39.53293], [-121.98493, 39.53272], [-121.9849, 39.53229], [-121.98511, 39.53188], [-121.98573, 39.53154], [-121.9862, 39.53149], [-121.98676, 39.53169], [-121.98777, 39.53231], [-121.98854, 39.53256], [-121.98931, 39.53279], [-121.99005, 39.53316], [-121.99155, 39.53382], [-121.99238, 39.53423], [-121.99333, 39.53491], [-121.99387, 39.53547], [-121.995, 39.5373], [-121.99688, 39.54166], [-121.99885, 39.54825], [-122.0023, 39.55714]]], [[[-122.00208, 39.55937], [-122.00124, 39.56031], [-121.99906, 39.56057], [-121.99884, 39.5608], [-121.99772, 39.56184], [-121.99751, 39.56216], [-121.99678, 39.56214], [-121.99612, 39.56208], [-121.99553, 39.56205], [-121.99479, 39.56198], [-121.99405, 39.56205], [-121.99334, 39.56225], [-121.99307, 39.56201], [-121.99299, 39.5624], [-121.99267, 39.56255], [-121.99254, 39.56256], [-121.99223, 39.56206], [-121.99223, 39.56278], [-121.99202, 39.5629], [-121.99105, 39.56295], [-121.99048, 39.56269], [-121.99049, 39.56174], [-121.99005, 39.56026], [-121.99016, 39.55991], [-121.99107, 39.55867], [-121.99143, 39.55837], [-121.99224, 39.55796], [-121.99316, 39.55774], [-121.99448, 39.55786], [-121.99569, 39.55781], [-121.99659, 39.55806], [-121.99659, 39.55849], [-121.99763, 39.5587], [-121.99784, 39.55903], [-121.99897, 39.55913], [-121.99977, 39.55929], [-122.00167, 39.5595], [-122.00208, 39.55937]]]]}	Restricted Access 2	25275	Butte Sink Wildlife Management Area	16605	106	United States Fish and Wildlife Service 45	Federal 1	Federal Agency 1	http://www.fws.gov/	US Fish and Wildlife Service 8	106	United States Fish and Wildlife Service 44	Federal 1	Federal Agency 1		Butte 42	655.167	Butte Sink WMA	1980	Conservation Area 13	2
16776	16776	16775	{"type": "MultiPolygon", "coordinates": [[[[-121.98913, 39.63463], [-121.98831, 39.63516], [-121.98797, 39.6354], [-121.98776, 39.63558], [-121.98765, 39.63558], [-121.98749, 39.6358], [-121.98755, 39.63615], [-121.98734, 39.63669], [-121.98688, 39.63727], [-121.9863, 39.63822], [-121.98608, 39.63885], [-121.98592, 39.63988], [-121.98601, 39.64065], [-121.98631, 39.6418], [-121.98624, 39.64203], [-121.98624, 39.64253], [-121.98601, 39.64333], [-121.98612, 39.64348], [-121.98607, 39.64397], [-121.98652, 39.64403], [-121.98688, 39.6436], [-121.98761, 39.64346], [-121.98865, 39.64425], [-121.98794, 39.64442], [-121.98673, 39.64509], [-121.98542, 39.64584], [-121.98493, 39.64621], [-121.98419, 39.64662], [-121.98339, 39.64702], [-121.9828, 39.64725], [-121.98205, 39.64712], [-121.98178, 39.64703], [-121.98158, 39.64694], [-121.98098, 39.64676], [-121.98063, 39.64671], [-121.98033, 39.64664], [-121.97991, 39.64649], [-121.97959, 39.64641], [-121.97929, 39.64631], [-121.97908, 39.64626], [-121.97838, 39.64628], [-121.9781, 39.64627], [-121.97779, 39.64631], [-121.97737, 39.64639], [-121.97718, 39.64637], [-121.97465, 39.64655], [-121.97397, 39.64654], [-121.9728, 39.64632], [-121.97186, 39.64627], [-121.97155, 39.64611], [-121.97104, 39.64611], [-121.97061, 39.64618], [-121.97054, 39.64621], [-121.9702, 39.64641], [-121.96981, 39.64641], [-121.96931, 39.64637], [-121.95954, 39.63596], [-121.94593, 39.6374], [-121.94593, 39.63729], [-121.96613, 39.63515], [-121.97408, 39.63512], [-121.98913, 39.63463]]], [[[-121.99123, 39.75232], [-121.99, 39.75229], [-121.98999, 39.75234], [-121.98506, 39.75224], [-121.98404, 39.75224], [-121.98309, 39.75228], [-121.97719, 39.75269], [-121.97711, 39.75211], [-121.9764, 39.75237], [-121.97545, 39.7526], [-121.97547, 39.75281], [-121.97116, 39.75311], [-121.971, 39.75288], [-121.97049, 39.7526], [-121.97054, 39.75137], [-121.9704, 39.75094], [-121.96994, 39.7503], [-121.9693, 39.74961], [-121.96879, 39.74862], [-121.96846, 39.7478], [-121.96795, 39.74694], [-121.96753, 39.74646], [-121.9668, 39.74587], [-121.96646, 39.74517], [-121.96496, 39.74394], [-121.96459, 39.74317], [-121.96501, 39.74308], [-121.96556, 39.74391], [-121.96597, 39.74414], [-121.96624, 39.74453], [-121.96704, 39.74499], [-121.9671, 39.74545], [-121.96732, 39.74577], [-121.96763, 39.74605], [-121.96783, 39.74617], [-121.9683, 39.74667], [-121.96866, 39.74703], [-121.96905, 39.74725], [-121.96987, 39.747], [-121.97061, 39.74684], [-121.97208, 39.74673], [-121.97208, 39.74672], [-121.97032, 39.74409], [-121.97098, 39.74429], [-121.97197, 39.74384], [-121.972, 39.74316], [-121.97183, 39.74314], [-121.97049, 39.74113], [-121.97132, 39.74041], [-121.97284, 39.73962], [-121.97339, 39.74061], [-121.97416, 39.74024], [-121.97586, 39.73968], [-121.97714, 39.73933], [-121.97804, 39.73881], [-121.98153, 39.73829], [-121.98383, 39.73861], [-121.98411, 39.73877], [-121.98426, 39.73892], [-121.98435, 39.73919], [-121.98518, 39.74006], [-121.9855, 39.74045], [-121.98572, 39.74075], [-121.98578, 39.7408], [-121.98585, 39.74081], [-121.98589, 39.74085], [-121.98586, 39.74091], [-121.98636, 39.74153], [-121.98678, 39.74197], [-121.98577, 39.7422], [-121.98576, 39.74221], [-121.98689, 39.74383], [-121.98885, 39.74673], [-121.98861, 39.74682], [-121.98861, 39.74683], [-121.99123, 39.75232]]], [[[-121.97773, 39.64853], [-121.97603, 39.64885], [-121.97523, 39.64892], [-121.97472, 39.64892], [-121.97359, 39.64858], [-121.97173, 39.64826], [-121.97128, 39.64822], [-121.97152, 39.64786], [-121.97218, 39.64738], [-121.97261, 39.64717], [-121.97322, 39.64712], [-121.97362, 39.64721], [-121.97413, 39.64739], [-121.97509, 39.6476], [-121.97548, 39.64763], [-121.97617, 39.64778], [-121.97666, 39.64795], [-121.97728, 39.64824], [-121.97773, 39.64853]]], [[[-121.99226, 39.63886], [-121.99217, 39.6388], [-121.99202, 39.63862], [-121.99216, 39.63863], [-121.99226, 39.63886]]], [[[-122.03253, 39.7796], [-122.03181, 39.78056], [-122.03077, 39.78182], [-122.03027, 39.78147], [-122.02994, 39.78126], [-122.02965, 39.78102], [-122.02921, 39.78045], [-122.02898, 39.78008], [-122.02888, 39.77978], [-122.02882, 39.77941], [-122.02881, 39.7791], [-122.02883, 39.77883], [-122.02887, 39.77872], [-122.02892, 39.77865], [-122.02899, 39.77864], [-122.02913, 39.77872], [-122.02917, 39.77871], [-122.02936, 39.77803], [-122.02952, 39.77773], [-122.02973, 39.77756], [-122.0315, 39.77754], [-122.03199, 39.7782], [-122.03253, 39.7796]]]]}	Restricted Access 2	8354	Butte Sink Wildlife Management Area	16605	106	United States Fish and Wildlife Service 45	Federal 1	Federal Agency 1	http://www.fws.gov/	US Fish and Wildlife Service 8	106	United States Fish and Wildlife Service 44	Federal 1	Federal Agency 1		Butte 42	1202.727	Butte Sink WMA	1980	Conservation Area 13	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]);