calands: units_with_maps: 1 row where ACCESS_TYP = 1, AGNCY_TYP = 17 and DES

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

1 row where ACCESS_TYP = 1, AGNCY_TYP = 17 and DES_TP = 1043

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
11875	11875	11874	{"type": "MultiPolygon", "coordinates": [[[[-120.95269, 39.13588], [-120.95265, 39.13596], [-120.95253, 39.13629], [-120.95241, 39.13648], [-120.95229, 39.13657], [-120.95204, 39.13668], [-120.95187, 39.1368], [-120.95168, 39.13687], [-120.95151, 39.13689], [-120.95119, 39.13682], [-120.95093, 39.13661], [-120.95072, 39.13654], [-120.9506, 39.13645], [-120.95043, 39.13642], [-120.95024, 39.13645], [-120.94996, 39.13657], [-120.94977, 39.13668], [-120.94947, 39.137], [-120.94927, 39.13733], [-120.94914, 39.13766], [-120.94909, 39.13804], [-120.94916, 39.13831], [-120.94925, 39.13849], [-120.94941, 39.13873], [-120.94954, 39.13903], [-120.94954, 39.13923], [-120.94946, 39.1394], [-120.94928, 39.13959], [-120.94907, 39.13973], [-120.94887, 39.13992], [-120.94861, 39.14013], [-120.94816, 39.14077], [-120.94802, 39.14121], [-120.94817, 39.14203], [-120.94817, 39.14217], [-120.94814, 39.14229], [-120.948, 39.14254], [-120.94793, 39.14286], [-120.94779, 39.14318], [-120.94762, 39.14338], [-120.94713, 39.14368], [-120.94687, 39.14387], [-120.94597, 39.14457], [-120.94533, 39.14509], [-120.94482, 39.14543], [-120.94467, 39.14546], [-120.94451, 39.14546], [-120.94439, 39.14541], [-120.94416, 39.14523], [-120.94401, 39.14513], [-120.94373, 39.14504], [-120.94348, 39.14492], [-120.9429, 39.14481], [-120.9426, 39.14483], [-120.94237, 39.14479], [-120.94185, 39.1448], [-120.94154, 39.14485], [-120.94116, 39.14493], [-120.94062, 39.14522], [-120.9402, 39.14549], [-120.94003, 39.14568], [-120.93991, 39.14588], [-120.93979, 39.14618], [-120.93968, 39.14719], [-120.93973, 39.1479], [-120.93973, 39.14816], [-120.9397, 39.14829], [-120.93946, 39.14854], [-120.93892, 39.14875], [-120.9384, 39.14911], [-120.93823, 39.14929], [-120.93784, 39.15025], [-120.93749, 39.15083], [-120.93699, 39.1514], [-120.93675, 39.15161], [-120.93654, 39.15171], [-120.93633, 39.15179], [-120.93619, 39.15181], [-120.93583, 39.15191], [-120.93558, 39.15193], [-120.93533, 39.15198], [-120.93435, 39.15225], [-120.93396, 39.15234], [-120.93398, 39.15183], [-120.93389, 39.15182], [-120.93407, 39.15176], [-120.93445, 39.15157], [-120.93478, 39.15124], [-120.93488, 39.15074], [-120.93505, 39.15043], [-120.93531, 39.15022], [-120.93571, 39.14972], [-120.93602, 39.14948], [-120.93638, 39.14898], [-120.93638, 39.1485], [-120.93626, 39.14812], [-120.93578, 39.14774], [-120.93547, 39.14741], [-120.93514, 39.1471], [-120.93493, 39.14703], [-120.93488, 39.14691], [-120.935, 39.14662], [-120.93514, 39.14646], [-120.9355, 39.14636], [-120.93597, 39.14641], [-120.9369, 39.14603], [-120.9369, 39.14596], [-120.93671, 39.14543], [-120.93621, 39.14503], [-120.93676, 39.14489], [-120.93699, 39.1447], [-120.93688, 39.14448], [-120.93657, 39.14403], [-120.93669, 39.14367], [-120.93702, 39.14327], [-120.93721, 39.14284], [-120.93742, 39.14184], [-120.93761, 39.14217], [-120.93773, 39.14291], [-120.93809, 39.14358], [-120.93861, 39.14427], [-120.93907, 39.14455], [-120.93959, 39.1447], [-120.94011, 39.14474], [-120.94076, 39.14446], [-120.94311, 39.14391], [-120.94325, 39.14351], [-120.94316, 39.14329], [-120.94325, 39.14291], [-120.94371, 39.14315], [-120.94416, 39.14329], [-120.94458, 39.14332], [-120.94475, 39.14315], [-120.94537, 39.14279], [-120.94582, 39.14277], [-120.94625, 39.14265], [-120.94637, 39.14264], [-120.9464, 39.14203], [-120.94666, 39.14165], [-120.9468, 39.14125], [-120.94713, 39.14079], [-120.94739, 39.14003], [-120.94742, 39.1397], [-120.94701, 39.13941], [-120.94689, 39.13889], [-120.94671, 39.13863], [-120.94635, 39.13863], [-120.94589, 39.13887], [-120.94516, 39.13889], [-120.94485, 39.13877], [-120.94361, 39.13813], [-120.94311, 39.13751], [-120.94271, 39.13734], [-120.94204, 39.13691], [-120.9413, 39.13663], [-120.94121, 39.13644], [-120.9412, 39.13618], [-120.94076, 39.1362], [-120.9403, 39.13589], [-120.93954, 39.13582], [-120.94002, 39.1357], [-120.94092, 39.13484], [-120.94176, 39.13382], [-120.94228, 39.13339], [-120.94221, 39.13415], [-120.94211, 39.13461], [-120.94218, 39.13511], [-120.9424, 39.1358], [-120.94275, 39.13632], [-120.94332, 39.13668], [-120.94366, 39.13696], [-120.94413, 39.13727], [-120.94454, 39.13739], [-120.94485, 39.13741], [-120.94566, 39.13682], [-120.94618, 39.13661], [-120.9469, 39.13649], [-120.94742, 39.13625], [-120.9482, 39.13596], [-120.94896, 39.13544], [-120.94937, 39.13503], [-120.94989, 39.13465], [-120.95034, 39.13456], [-120.95077, 39.13468], [-120.95132, 39.13492], [-120.9518, 39.13518], [-120.95244, 39.1357], [-120.95269, 39.13588]]], [[[-120.92922, 39.15493], [-120.92916, 39.15679], [-120.92805, 39.15624], [-120.92719, 39.15605], [-120.92691, 39.15631], [-120.92643, 39.15702], [-120.92527, 39.15776], [-120.92465, 39.15781], [-120.92424, 39.15767], [-120.92396, 39.15797], [-120.92465, 39.1589], [-120.92183, 39.15891], [-120.92179, 39.1584], [-120.92127, 39.15819], [-120.92041, 39.15812], [-120.91996, 39.15759], [-120.91998, 39.157], [-120.92055, 39.15667], [-120.92136, 39.15667], [-120.92198, 39.15674], [-120.92241, 39.15666], [-120.9231, 39.15662], [-120.92355, 39.1565], [-120.92424, 39.15652], [-120.92469, 39.15595], [-120.92484, 39.15528], [-120.92457, 39.15471], [-120.924, 39.1545], [-120.92355, 39.15407], [-120.92417, 39.15419], [-120.92517, 39.15447], [-120.92581, 39.1549], [-120.92619, 39.15486], [-120.92646, 39.15478], [-120.92674, 39.15476], [-120.92707, 39.15464], [-120.92764, 39.15464], [-120.92803, 39.15467], [-120.92841, 39.15476], [-120.92881, 39.15476], [-120.92922, 39.15493]]]]}	Open Access 1	24328	Rollins Lake	7538	2245	Nevada Irrigation District 998	Special District 4	Irrigation District 17	http://www.nid.dst.ca.us/recreation.cfm	Special District 4	2245	Nevada Irrigation District 961	Special District 4	Irrigation District 16	http://nidwater.com/recreation/	Placer 35	201.19	Rollins Lake	0	None 1043

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