units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 1199, MNG_AGENCY = 961 and MNG_AG_LEV = 4
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14032 | 14032 | 14031 | {"type": "Polygon", "coordinates": [[[-120.9576, 39.16766], [-120.95746, 39.1679], [-120.95713, 39.16787], [-120.95653, 39.1679], [-120.95613, 39.16785], [-120.95572, 39.16751], [-120.95489, 39.16694], [-120.95444, 39.16654], [-120.95425, 39.16611], [-120.95363, 39.16575], [-120.95358, 39.16547], [-120.9532, 39.16511], [-120.95299, 39.16478], [-120.95299, 39.1643], [-120.95275, 39.16404], [-120.95215, 39.16356], [-120.95144, 39.16323], [-120.95096, 39.16297], [-120.95058, 39.16299], [-120.95032, 39.16333], [-120.95044, 39.16352], [-120.95054, 39.16387], [-120.95075, 39.16416], [-120.95068, 39.16466], [-120.95034, 39.16466], [-120.94875, 39.16499], [-120.94837, 39.16523], [-120.94808, 39.16523], [-120.94742, 39.16497], [-120.94725, 39.16492], [-120.94711, 39.16466], [-120.94687, 39.1644], [-120.94673, 39.16445], [-120.94651, 39.16456], [-120.94604, 39.16459], [-120.94552, 39.16466], [-120.94516, 39.16475], [-120.94461, 39.16473], [-120.94452, 39.16449], [-120.94492, 39.16395], [-120.9453, 39.16385], [-120.94606, 39.16378], [-120.9459, 39.16333], [-120.94601, 39.16295], [-120.94675, 39.16345], [-120.94718, 39.16361], [-120.94806, 39.16383], [-120.94849, 39.16352], [-120.94867, 39.16323], [-120.94967, 39.16322], [-120.94968, 39.16163], [-120.9503, 39.16149], [-120.95037, 39.16128], [-120.95037, 39.161], [-120.95018, 39.16052], [-120.9497, 39.15983], [-120.9497, 39.1596], [-120.94967, 39.15959], [-120.94966, 39.15945], [-120.94973, 39.15852], [-120.94958, 39.15805], [-120.94916, 39.1574], [-120.94873, 39.15704], [-120.94842, 39.15655], [-120.94794, 39.15619], [-120.94818, 39.15586], [-120.94842, 39.15583], [-120.9487, 39.156], [-120.9493, 39.15647], [-120.9498, 39.15683], [-120.95013, 39.15688], [-120.95056, 39.15671], [-120.95099, 39.15671], [-120.95151, 39.15683], [-120.9522, 39.15719], [-120.95258, 39.15688], [-120.95289, 39.15607], [-120.9527, 39.15526], [-120.95244, 39.15495], [-120.95206, 39.15436], [-120.95172, 39.15409], [-120.95087, 39.15388], [-120.9503, 39.15371], [-120.94996, 39.15369], [-120.94992, 39.15326], [-120.9497, 39.15262], [-120.94934, 39.15226], [-120.94884, 39.15222], [-120.94832, 39.15283], [-120.94799, 39.15331], [-120.94766, 39.1539], [-120.94739, 39.15381], [-120.9473, 39.15352], [-120.94749, 39.15286], [-120.94746, 39.15226], [-120.94661, 39.15148], [-120.94599, 39.1511], [-120.94535, 39.15081], [-120.94563, 39.15031], [-120.94544, 39.14983], [-120.94552, 39.14938], [-120.94585, 39.14902], [-120.94589, 39.14834], [-120.94544, 39.14798], [-120.94516, 39.1476], [-120.94604, 39.14741], [-120.94647, 39.14746], [-120.94699, 39.14762], [-120.9476, 39.14762], [-120.94787, 39.14736], [-120.94799, 39.14736], [-120.94806, 39.14715], [-120.94811, 39.14679], [-120.94835, 39.14641], [-120.94832, 39.14617], [-120.94799, 39.14562], [-120.94766, 39.14558], [-120.94735, 39.14567], [-120.94687, 39.14622], [-120.94644, 39.14658], [-120.94613, 39.1467], [-120.94594, 39.14686], [-120.94566, 39.14686], [-120.94497, 39.14681], [-120.94463, 39.14698], [-120.94416, 39.14731], [-120.94359, 39.14724], [-120.94356, 39.14698], [-120.94295, 39.14672], [-120.94252, 39.14677], [-120.94225, 39.1466], [-120.94195, 39.14665], [-120.94178, 39.14684], [-120.9414, 39.14715], [-120.94126, 39.14731], [-120.94125, 39.14767], [-120.94088, 39.14793], [-120.9409, 39.14834], [-120.94083, 39.14888], [-120.94109, 39.14919], [-120.94123, 39.14945], [-120.94133, 39.14984], [-120.94147, 39.15024], [-120.9418, 39.15034], [-120.94159, 39.15079], [-120.94159, 39.15112], [-120.94171, 39.15134], [-120.94159, 39.15169], [-120.94161, 39.15238], [-120.94216, 39.15267], [-120.94278, 39.15286], [-120.94311, 39.15298], [-120.94313, 39.15314], [-120.94307, 39.1536], [-120.9433, 39.15383], [-120.94354, 39.15417], [-120.9439, 39.15431], [-120.94423, 39.15455], [-120.94454, 39.15467], [-120.94473, 39.15471], [-120.94509, 39.15464], [-120.94513, 39.15505], [-120.9448, 39.15495], [-120.9443, 39.15488], [-120.94378, 39.15483], [-120.9435, 39.15493], [-120.94352, 39.15512], [-120.94349, 39.1554], [-120.94349, 39.15562], [-120.94352, 39.15598], [-120.94364, 39.15638], [-120.94387, 39.15664], [-120.94373, 39.15676], [-120.94354, 39.15678], [-120.94335, 39.1569], [-120.94309, 39.15676], [-120.94321, 39.15647], [-120.94325, 39.15588], [-120.94301, 39.15557], [-120.94271, 39.15536], [-120.94252, 39.15531], [-120.94235, 39.15507], [-120.94209, 39.15478], [-120.94178, 39.15436], [-120.94157, 39.15419], [-120.94137, 39.15436], [-120.94092, 39.15405], [-120.94054, 39.15393], [-120.94033, 39.15402], [-120.94019, 39.15421], [-120.94018, 39.15462], [-120.93995, 39.15464], [-120.93949, 39.15443], [-120.93923, 39.15452], [-120.93907, 39.15469], [-120.93902, 39.15495], [-120.93926, 39.15574], [-120.93859, 39.15545], [-120.93795, 39.15514], [-120.93778, 39.15464], [-120.9374, 39.15459], [-120.93697, 39.15467], [-120.93671, 39.15462], [-120.93624, 39.15471], [-120.93581, 39.15471], [-120.93581, 39.15448], [-120.93567, 39.15419], [-120.93547, 39.15405], [-120.93521, 39.1539], [-120.93464, 39.15355], [-120.93414, 39.15345], [-120.93393, 39.15343], [-120.93396, 39.15234], [-120.93435, 39.15225], [-120.93533, 39.15198], [-120.93558, 39.15193], [-120.93583, 39.15191], [-120.93619, 39.15181], [-120.93633, 39.15179], [-120.93654, 39.15171], [-120.93675, 39.15161], [-120.93699, 39.1514], [-120.93749, 39.15083], [-120.93784, 39.15025], [-120.93822, 39.1493], [-120.9384, 39.14911], [-120.93892, 39.14875], [-120.93946, 39.14854], [-120.9397, 39.14829], [-120.93973, 39.14816], [-120.93973, 39.1479], [-120.93968, 39.14719], [-120.93979, 39.14618], [-120.93991, 39.14588], [-120.94003, 39.14568], [-120.9402, 39.14549], [-120.94062, 39.14522], [-120.94116, 39.14493], [-120.94154, 39.14485], [-120.94185, 39.1448], [-120.94237, 39.14479], [-120.9426, 39.14483], [-120.94289, 39.14481], [-120.94348, 39.14492], [-120.94373, 39.14504], [-120.94401, 39.14513], [-120.94416, 39.14523], [-120.94439, 39.14541], [-120.94451, 39.14546], [-120.94466, 39.14546], [-120.94482, 39.14543], [-120.94533, 39.14509], [-120.94597, 39.14457], [-120.94687, 39.14387], [-120.94713, 39.14368], [-120.94762, 39.14338], [-120.94779, 39.14317], [-120.94793, 39.14286], [-120.948, 39.14254], [-120.94814, 39.14229], [-120.94817, 39.14217], [-120.94817, 39.14203], [-120.94802, 39.14121], [-120.94816, 39.14077], [-120.94861, 39.14013], [-120.94887, 39.13992], [-120.94907, 39.13973], [-120.94928, 39.13959], [-120.94946, 39.1394], [-120.94954, 39.13923], [-120.94954, 39.13903], [-120.94941, 39.13873], [-120.94925, 39.13849], [-120.94916, 39.13831], [-120.94909, 39.13804], [-120.94914, 39.13766], [-120.94927, 39.13733], [-120.94947, 39.137], [-120.94977, 39.13668], [-120.94996, 39.13657], [-120.95024, 39.13645], [-120.95043, 39.13642], [-120.9506, 39.13645], [-120.95073, 39.13654], [-120.95093, 39.13661], [-120.95119, 39.13682], [-120.95151, 39.13689], [-120.95168, 39.13687], [-120.95187, 39.1368], [-120.95204, 39.13668], [-120.95229, 39.13657], [-120.95241, 39.13648], [-120.95253, 39.13629], [-120.95265, 39.13596], [-120.9527, 39.13588], [-120.95294, 39.13606], [-120.95372, 39.13651], [-120.95415, 39.13661], [-120.95444, 39.13665], [-120.95475, 39.13687], [-120.9551, 39.13701], [-120.95548, 39.13708], [-120.95544, 39.13744], [-120.95522, 39.13777], [-120.95439, 39.13803], [-120.95391, 39.13792], [-120.95351, 39.13813], [-120.95263, 39.13868], [-120.95215, 39.13872], [-120.95178, 39.13891], [-120.95161, 39.13913], [-120.95092, 39.13909], [-120.95099, 39.13941], [-120.95089, 39.13984], [-120.95099, 39.14003], [-120.95144, 39.14037], [-120.95144, 39.14082], [-120.95156, 39.14117], [-120.95142, 39.14158], [-120.95142, 39.14198], [-120.9508, 39.14234], [-120.95087, 39.14255], [-120.95118, 39.14277], [-120.95099, 39.14289], [-120.95061, 39.14294], [-120.95046, 39.14339], [-120.95061, 39.14379], [-120.95103, 39.1442], [-120.95149, 39.14455], [-120.95163, 39.14508], [-120.95156, 39.1456], [-120.95211, 39.14605], [-120.95215, 39.14636], [-120.9518, 39.1465], [-120.95123, 39.14665], [-120.95096, 39.14684], [-120.95059, 39.14719], [-120.95056, 39.14767], [-120.94999, 39.14831], [-120.94963, 39.1491], [-120.94937, 39.14939], [-120.94944, 39.14976], [-120.9498, 39.14986], [-120.95054, 39.15019], [-120.95096, 39.15043], [-120.95146, 39.15081], [-120.95172, 39.15114], [-120.95173, 39.15159], [-120.95201, 39.1516], [-120.9523, 39.15186], [-120.95208, 39.1521], [-120.95208, 39.15243], [-120.95215, 39.15269], [-120.95246, 39.15293], [-120.9528, 39.15326], [-120.95327, 39.15345], [-120.95323, 39.15358], [-120.95337, 39.15383], [-120.95356, 39.1541], [-120.95387, 39.15443], [-120.95422, 39.15455], [-120.9542, 39.15479], [-120.95427, 39.15533], [-120.95427, 39.15574], [-120.95441, 39.15619], [-120.95494, 39.15638], [-120.9551, 39.15647], [-120.95479, 39.15683], [-120.95403, 39.15743], [-120.9537, 39.15807], [-120.9532, 39.15871], [-120.95246, 39.15869], [-120.95194, 39.1588], [-120.95194, 39.15914], [-120.9522, 39.15954], [-120.9526, 39.15973], [-120.95291, 39.16021], [-120.95287, 39.16076], [-120.9528, 39.16126], [-120.95277, 39.16197], [-120.9532, 39.16235], [-120.95363, 39.16264], [-120.9542, 39.16295], [-120.95451, 39.16318], [-120.95425, 39.16352], [-120.95437, 39.16399], [-120.95484, 39.16404], [-120.95541, 39.16416], [-120.95556, 39.1644], [-120.95527, 39.16485], [-120.95601, 39.16575], [-120.95627, 39.16599], [-120.95663, 39.16668], [-120.95717, 39.16704], [-120.9576, 39.16766]]]} | Open Access 1 | 37028 | 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/ | Nevada 30 | 394.979 | Rollins Lake | None 1199 |
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]);