calands: units_with_maps: 1 row where AGNCY_NAME = 890, DES_TP = 1068 and MNG_AG

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

1 row where AGNCY_NAME = 890, DES_TP = 1068 and MNG_AG_ID = 2220

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
12254	12254	12253	{"type": "Polygon", "coordinates": [[[-120.0648, 38.70268], [-120.06474, 38.70307], [-120.06469, 38.70323], [-120.06428, 38.7033], [-120.06177, 38.70296], [-120.06147, 38.70282], [-120.0604, 38.70314], [-120.05964, 38.70323], [-120.05733, 38.70323], [-120.05572, 38.70307], [-120.05298, 38.70321], [-120.05202, 38.70337], [-120.05132, 38.70318], [-120.05071, 38.7032], [-120.05053, 38.70337], [-120.05056, 38.70439], [-120.05035, 38.70476], [-120.0496, 38.70495], [-120.04965, 38.70517], [-120.05006, 38.70554], [-120.05006, 38.70588], [-120.04927, 38.70748], [-120.04854, 38.70828], [-120.04822, 38.70833], [-120.04557, 38.70723], [-120.04484, 38.70673], [-120.04405, 38.70572], [-120.04373, 38.70503], [-120.04349, 38.70485], [-120.04323, 38.70478], [-120.04404, 38.70478], [-120.04404, 38.70476], [-120.04264, 38.70463], [-120.04238, 38.70457], [-120.04194, 38.70431], [-120.04101, 38.70398], [-120.0407, 38.70379], [-120.04049, 38.70358], [-120.04034, 38.70335], [-120.04015, 38.70313], [-120.0399, 38.70301], [-120.03989, 38.70324], [-120.039, 38.70261], [-120.03725, 38.70162], [-120.03618, 38.70114], [-120.03634, 38.70113], [-120.03599, 38.7009], [-120.03577, 38.70081], [-120.03562, 38.7007], [-120.03544, 38.70041], [-120.03533, 38.70029], [-120.03512, 38.70019], [-120.0351, 38.70024], [-120.03445, 38.7], [-120.03395, 38.69954], [-120.03384, 38.69924], [-120.03349, 38.69886], [-120.03343, 38.6986], [-120.03314, 38.69828], [-120.03317, 38.6975], [-120.03327, 38.6975], [-120.03332, 38.69738], [-120.03334, 38.69715], [-120.03332, 38.697], [-120.03337, 38.69696], [-120.03353, 38.697], [-120.03359, 38.697], [-120.03368, 38.69696], [-120.03374, 38.69691], [-120.0338, 38.69667], [-120.0338, 38.69645], [-120.03369, 38.69637], [-120.03367, 38.69632], [-120.03374, 38.69617], [-120.03375, 38.6961], [-120.03372, 38.69603], [-120.03375, 38.6959], [-120.03382, 38.6959], [-120.03388, 38.69589], [-120.03391, 38.69584], [-120.03391, 38.69579], [-120.03385, 38.69571], [-120.03361, 38.69561], [-120.03353, 38.69549], [-120.03352, 38.69544], [-120.03359, 38.6953], [-120.03357, 38.69522], [-120.0335, 38.69511], [-120.03351, 38.69506], [-120.03353, 38.695], [-120.03359, 38.69498], [-120.03368, 38.69501], [-120.03376, 38.69507], [-120.03386, 38.69521], [-120.03391, 38.69524], [-120.03398, 38.69521], [-120.03407, 38.69509], [-120.03411, 38.69497], [-120.03411, 38.69478], [-120.03413, 38.69464], [-120.03417, 38.69459], [-120.03424, 38.69457], [-120.03428, 38.69459], [-120.03435, 38.69471], [-120.03439, 38.69473], [-120.03443, 38.69468], [-120.03446, 38.69456], [-120.03451, 38.69453], [-120.03457, 38.69456], [-120.03459, 38.69469], [-120.03465, 38.69471], [-120.03472, 38.69467], [-120.03492, 38.69437], [-120.03494, 38.69432], [-120.03498, 38.6943], [-120.0355, 38.69428], [-120.03612, 38.69389], [-120.0367, 38.69376], [-120.03682, 38.69357], [-120.03752, 38.69353], [-120.03777, 38.69346], [-120.03769, 38.69298], [-120.03836, 38.69188], [-120.03845, 38.69067], [-120.03836, 38.69028], [-120.03833, 38.6895], [-120.03822, 38.68932], [-120.03822, 38.68864], [-120.03813, 38.68842], [-120.03743, 38.68785], [-120.03726, 38.68753], [-120.03717, 38.68696], [-120.03678, 38.68651], [-120.03757, 38.68651], [-120.03759, 38.68647], [-120.03759, 38.68628], [-120.03755, 38.6861], [-120.03714, 38.6847], [-120.03713, 38.68452], [-120.03716, 38.68445], [-120.03722, 38.68441], [-120.03733, 38.68439], [-120.03759, 38.68438], [-120.03816, 38.68446], [-120.03829, 38.68453], [-120.03875, 38.68454], [-120.03882, 38.6846], [-120.03891, 38.68472], [-120.03904, 38.685], [-120.03907, 38.68502], [-120.03918, 38.68521], [-120.03938, 38.68539], [-120.03949, 38.68542], [-120.03955, 38.68535], [-120.03959, 38.68522], [-120.03963, 38.68517], [-120.03983, 38.6852], [-120.03999, 38.68529], [-120.04034, 38.68558], [-120.04037, 38.68591], [-120.04036, 38.68627], [-120.04033, 38.68649], [-120.04028, 38.68651], [-120.04009, 38.6865], [-120.03992, 38.68646], [-120.03978, 38.68639], [-120.03966, 38.68637], [-120.03956, 38.68639], [-120.03952, 38.68641], [-120.03951, 38.68644], [-120.03955, 38.68653], [-120.03973, 38.68655], [-120.0397, 38.68658], [-120.03949, 38.68666], [-120.03946, 38.68668], [-120.03946, 38.68672], [-120.03952, 38.68678], [-120.03981, 38.68678], [-120.03983, 38.68688], [-120.04023, 38.68719], [-120.04034, 38.68752], [-120.0404, 38.68783], [-120.04044, 38.68792], [-120.04054, 38.68799], [-120.04064, 38.68801], [-120.04094, 38.68821], [-120.04106, 38.68836], [-120.04146, 38.68903], [-120.04199, 38.69013], [-120.04219, 38.69028], [-120.04283, 38.69035], [-120.04391, 38.69165], [-120.04432, 38.69232], [-120.04469, 38.69259], [-120.04507, 38.69321], [-120.04516, 38.69365], [-120.04878, 38.69362], [-120.04855, 38.69723], [-120.04871, 38.69709], [-120.04887, 38.69703], [-120.04933, 38.69697], [-120.04992, 38.69694], [-120.05176, 38.69731], [-120.05374, 38.69806], [-120.05526, 38.69854], [-120.05859, 38.69993], [-120.05996, 38.70037], [-120.06191, 38.70087], [-120.0632, 38.70154], [-120.0648, 38.70268]], [[-120.04117, 38.69014], [-120.04128, 38.69053], [-120.04151, 38.69076], [-120.04175, 38.69074], [-120.04177, 38.69044], [-120.04131, 38.69001], [-120.04117, 38.69014]], [[-120.0509, 38.70162], [-120.05126, 38.70195], [-120.05267, 38.70223], [-120.05345, 38.70224], [-120.05343, 38.6999], [-120.05167, 38.70045], [-120.05053, 38.70028], [-120.04873, 38.70105], [-120.04766, 38.69951], [-120.04828, 38.69917], [-120.04845, 38.69887], [-120.04809, 38.69834], [-120.04661, 38.6972], [-120.04558, 38.69678], [-120.04281, 38.69842], [-120.04282, 38.70224], [-120.04353, 38.70241], [-120.04498, 38.70242], [-120.04552, 38.70297], [-120.0465, 38.70323], [-120.04678, 38.70375], [-120.04718, 38.7037], [-120.04752, 38.70329], [-120.04823, 38.70277], [-120.04882, 38.70257], [-120.04973, 38.70185], [-120.0509, 38.70162]], [[-120.04917, 38.70394], [-120.0491, 38.70423], [-120.0493, 38.70437], [-120.04983, 38.70437], [-120.04992, 38.7043], [-120.04991, 38.70414], [-120.04942, 38.70394], [-120.04917, 38.70394]]]}	Open Access 1	25794	Caples Lake	3401	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		Alpine 51	531.982	Caples Lake		None 1068

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