calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 1046 and LABEL

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

1 row where ACCESS_TYP = 1, DES_TP = 1046 and LABEL_NAME = "Echo Lake"

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
11893	11893	11892	{"type": "Polygon", "coordinates": [[[-120.0809, 38.84539], [-120.0794, 38.84631], [-120.07878, 38.84651], [-120.07824, 38.84641], [-120.07751, 38.84605], [-120.07698, 38.84606], [-120.07673, 38.84595], [-120.07609, 38.84541], [-120.07605, 38.84536], [-120.07617, 38.84536], [-120.07617, 38.84534], [-120.07589, 38.84498], [-120.07573, 38.84494], [-120.07558, 38.84502], [-120.07542, 38.84503], [-120.07526, 38.84494], [-120.075, 38.84462], [-120.07483, 38.84437], [-120.07463, 38.84428], [-120.07425, 38.84435], [-120.07407, 38.84449], [-120.07393, 38.84448], [-120.07289, 38.84347], [-120.07245, 38.84316], [-120.07216, 38.84289], [-120.0722, 38.84252], [-120.07185, 38.84229], [-120.07145, 38.84215], [-120.07119, 38.84195], [-120.07098, 38.84176], [-120.07086, 38.8417], [-120.07057, 38.84173], [-120.07037, 38.84165], [-120.07029, 38.84146], [-120.07011, 38.84123], [-120.06972, 38.84097], [-120.06954, 38.84082], [-120.06923, 38.84075], [-120.06852, 38.84046], [-120.06834, 38.8405], [-120.06807, 38.84071], [-120.06797, 38.84094], [-120.06794, 38.84169], [-120.06803, 38.84228], [-120.06805, 38.84262], [-120.0679, 38.84305], [-120.06782, 38.84335], [-120.06761, 38.84343], [-120.06723, 38.84336], [-120.06696, 38.84348], [-120.06694, 38.84368], [-120.06669, 38.84377], [-120.06645, 38.8437], [-120.06618, 38.84344], [-120.06593, 38.84345], [-120.06573, 38.84367], [-120.06549, 38.84385], [-120.06515, 38.84398], [-120.06467, 38.8443], [-120.06426, 38.84446], [-120.0636, 38.84447], [-120.06318, 38.8445], [-120.06261, 38.84448], [-120.06207, 38.84424], [-120.06164, 38.84418], [-120.06137, 38.84418], [-120.06084, 38.84388], [-120.06001, 38.84362], [-120.06, 38.84363], [-120.05999, 38.84371], [-120.05978, 38.84372], [-120.05961, 38.84358], [-120.05959, 38.84348], [-120.0587, 38.84307], [-120.05807, 38.84281], [-120.05738, 38.84262], [-120.05676, 38.84251], [-120.05651, 38.8425], [-120.0564, 38.84247], [-120.05612, 38.8423], [-120.05511, 38.84157], [-120.05476, 38.84126], [-120.0542, 38.84072], [-120.05347, 38.84015], [-120.05291, 38.83959], [-120.05267, 38.8394], [-120.05248, 38.83919], [-120.05229, 38.83902], [-120.05211, 38.83868], [-120.05178, 38.83835], [-120.05104, 38.83774], [-120.05039, 38.83729], [-120.04988, 38.83702], [-120.04936, 38.83691], [-120.04896, 38.83688], [-120.04876, 38.83689], [-120.04866, 38.83681], [-120.04823, 38.83661], [-120.04797, 38.83653], [-120.04777, 38.83651], [-120.04735, 38.83643], [-120.04646, 38.83611], [-120.04626, 38.83597], [-120.04601, 38.83584], [-120.04573, 38.83563], [-120.04508, 38.83539], [-120.04484, 38.83534], [-120.04482, 38.83524], [-120.04483, 38.83496], [-120.04492, 38.83477], [-120.04518, 38.83467], [-120.04526, 38.83459], [-120.04539, 38.83439], [-120.04593, 38.83429], [-120.04643, 38.83417], [-120.04757, 38.83421], [-120.04783, 38.83424], [-120.04801, 38.83418], [-120.04871, 38.8342], [-120.04953, 38.83433], [-120.05029, 38.83455], [-120.05112, 38.83466], [-120.05156, 38.83464], [-120.05198, 38.83477], [-120.05238, 38.83487], [-120.05308, 38.83491], [-120.0536, 38.83492], [-120.05386, 38.83495], [-120.05405, 38.83515], [-120.05441, 38.83526], [-120.05471, 38.83528], [-120.05538, 38.83554], [-120.05607, 38.83588], [-120.05657, 38.83616], [-120.05767, 38.8364], [-120.05799, 38.8365], [-120.05839, 38.83701], [-120.06033, 38.83774], [-120.0621, 38.83807], [-120.06219, 38.83807], [-120.06233, 38.83819], [-120.06247, 38.83824], [-120.0625, 38.83826], [-120.06255, 38.83848], [-120.06268, 38.83861], [-120.06308, 38.83878], [-120.06377, 38.83893], [-120.0643, 38.83907], [-120.0648, 38.8391], [-120.06513, 38.83916], [-120.06562, 38.83919], [-120.06596, 38.83926], [-120.06669, 38.83927], [-120.06689, 38.83937], [-120.06841, 38.83997], [-120.0694, 38.84058], [-120.07007, 38.84058], [-120.07046, 38.84047], [-120.07037, 38.84027], [-120.07019, 38.84007], [-120.07043, 38.83989], [-120.07065, 38.83985], [-120.07085, 38.83999], [-120.07103, 38.84003], [-120.07119, 38.84002], [-120.07164, 38.84029], [-120.07192, 38.84037], [-120.0721, 38.84035], [-120.07257, 38.84016], [-120.07279, 38.84017], [-120.07294, 38.84029], [-120.07326, 38.8406], [-120.07379, 38.84124], [-120.07407, 38.84134], [-120.07444, 38.84144], [-120.0746, 38.84173], [-120.07479, 38.84184], [-120.07563, 38.84183], [-120.07619, 38.84185], [-120.07642, 38.84188], [-120.0766, 38.842], [-120.0768, 38.84202], [-120.07718, 38.84194], [-120.07757, 38.84203], [-120.07807, 38.84228], [-120.07849, 38.84217], [-120.0786, 38.84225], [-120.0787, 38.84239], [-120.07874, 38.84253], [-120.07939, 38.84267], [-120.0798, 38.84251], [-120.08035, 38.84306], [-120.08027, 38.84396], [-120.07997, 38.84406], [-120.08006, 38.84433], [-120.07998, 38.84459], [-120.08014, 38.84474], [-120.08045, 38.84485], [-120.08066, 38.84507], [-120.08073, 38.84534], [-120.0809, 38.84539]], [[-120.07582, 38.84282], [-120.07618, 38.84298], [-120.07619, 38.84298], [-120.07621, 38.8429], [-120.07583, 38.84227], [-120.07542, 38.84208], [-120.07549, 38.84236], [-120.07561, 38.84261], [-120.07582, 38.84282]], [[-120.07625, 38.84416], [-120.07655, 38.84427], [-120.07658, 38.84423], [-120.07628, 38.84371], [-120.07609, 38.84353], [-120.07594, 38.84368], [-120.07614, 38.84409], [-120.07625, 38.84416]], [[-120.07674, 38.84419], [-120.07691, 38.84424], [-120.07694, 38.8441], [-120.0769, 38.84382], [-120.07658, 38.84359], [-120.07648, 38.84362], [-120.07674, 38.84419]], [[-120.07668, 38.84476], [-120.07696, 38.84494], [-120.07702, 38.84475], [-120.07678, 38.84447], [-120.07668, 38.84476]], [[-120.0771, 38.84474], [-120.07723, 38.84485], [-120.07743, 38.84474], [-120.07723, 38.84453], [-120.07711, 38.84456], [-120.0771, 38.84474]]]}	Open Access 1	24342	Echo Lake	3402	2220	El Dorado Irrigation District 890	Special District 4	Irrigation District 17	http://www.eid.org/	Special District 4	2220	El Dorado Irrigation District 965	Special District 4	Irrigation District 16		El Dorado 34	325.47	Echo Lake		None 1046

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