superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and PARK_URL = "http://nidwater.com/recreation/"
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 611 | 611 | 610 | {"type": "Polygon", "coordinates": [[[-120.6546, 39.44323], [-120.65422, 39.44362], [-120.65392, 39.44405], [-120.65283, 39.44476], [-120.65272, 39.4449], [-120.65239, 39.446], [-120.65224, 39.44623], [-120.65142, 39.44696], [-120.65142, 39.44719], [-120.65118, 39.44744], [-120.6511, 39.44763], [-120.65174, 39.44801], [-120.65209, 39.44833], [-120.65242, 39.4485], [-120.65186, 39.44851], [-120.65182, 39.45203], [-120.65171, 39.45259], [-120.65003, 39.45332], [-120.64917, 39.45341], [-120.64823, 39.45373], [-120.64752, 39.45378], [-120.64628, 39.45437], [-120.64563, 39.45455], [-120.64525, 39.45458], [-120.64413, 39.45439], [-120.6439, 39.45448], [-120.64304, 39.45578], [-120.64233, 39.45578], [-120.64231, 39.45668], [-120.64133, 39.45737], [-120.64047, 39.45753], [-120.64014, 39.45771], [-120.63935, 39.45851], [-120.63725, 39.45949], [-120.63664, 39.45954], [-120.63637, 39.4597], [-120.63539, 39.45982], [-120.63377, 39.46057], [-120.63103, 39.461], [-120.62979, 39.46069], [-120.62914, 39.46036], [-120.62803, 39.45997], [-120.62802, 39.45937], [-120.62657, 39.45936], [-120.6246, 39.45849], [-120.62376, 39.45831], [-120.62306, 39.45833], [-120.62238, 39.45851], [-120.62188, 39.45831], [-120.62161, 39.45831], [-120.62117, 39.45847], [-120.6205, 39.45892], [-120.6203, 39.45933], [-120.61831, 39.45932], [-120.61813, 39.4591], [-120.61798, 39.4586], [-120.61722, 39.45817], [-120.61727, 39.45763], [-120.6168, 39.45721], [-120.61562, 39.45679], [-120.61518, 39.45679], [-120.61492, 39.45693], [-120.615, 39.45762], [-120.61427, 39.45775], [-120.61367, 39.45794], [-120.61294, 39.45798], [-120.61208, 39.45833], [-120.61159, 39.45826], [-120.61128, 39.45876], [-120.61117, 39.45881], [-120.61084, 39.45853], [-120.61055, 39.45849], [-120.61034, 39.45833], [-120.60984, 39.45759], [-120.60904, 39.45702], [-120.60825, 39.4567], [-120.60822, 39.45654], [-120.60934, 39.45643], [-120.60957, 39.45634], [-120.60996, 39.45595], [-120.61067, 39.45567], [-120.61106, 39.45564], [-120.61859, 39.45568], [-120.61862, 39.45511], [-120.61899, 39.45529], [-120.62037, 39.45563], [-120.62088, 39.45602], [-120.62212, 39.45677], [-120.6228, 39.45689], [-120.62427, 39.45675], [-120.62474, 39.45647], [-120.62489, 39.45627], [-120.62492, 39.4559], [-120.62533, 39.45529], [-120.62566, 39.45517], [-120.62663, 39.45547], [-120.62705, 39.45546], [-120.62731, 39.4549], [-120.62731, 39.45438], [-120.62666, 39.45368], [-120.62663, 39.45348], [-120.62677, 39.45313], [-120.62642, 39.45293], [-120.62604, 39.45304], [-120.62539, 39.45304], [-120.62536, 39.45284], [-120.62604, 39.45231], [-120.6262, 39.45207], [-120.62814, 39.45206], [-120.62819, 39.44899], [-120.62873, 39.44897], [-120.63058, 39.44918], [-120.63088, 39.44895], [-120.6325, 39.44895], [-120.633, 39.44886], [-120.63359, 39.44897], [-120.63392, 39.44888], [-120.63421, 39.44847], [-120.63431, 39.44844], [-120.6348, 39.44844], [-120.63577, 39.44865], [-120.63611, 39.44845], [-120.64242, 39.44846], [-120.64244, 39.4463], [-120.6433, 39.44593], [-120.64383, 39.44538], [-120.64413, 39.44462], [-120.64481, 39.44371], [-120.6456, 39.44337], [-120.64672, 39.44309], [-120.64743, 39.4425], [-120.64846, 39.44188], [-120.64938, 39.44154], [-120.65317, 39.44157], [-120.65322, 39.44165], [-120.65353, 39.44167], [-120.65373, 39.44157], [-120.65421, 39.44157], [-120.65436, 39.44243], [-120.65407, 39.44266], [-120.6541, 39.44288], [-120.65457, 39.44314], [-120.6546, 39.44323]], [[-120.61046, 39.45745], [-120.6114, 39.45755], [-120.61155, 39.45745], [-120.61152, 39.4572], [-120.61108, 39.45691], [-120.61028, 39.45693], [-120.60996, 39.45702], [-120.60996, 39.45716], [-120.61046, 39.45745]], [[-120.65068, 39.44649], [-120.65047, 39.44637], [-120.64994, 39.44657], [-120.64941, 39.44666], [-120.64918, 39.44693], [-120.64926, 39.44762], [-120.64958, 39.44796], [-120.64985, 39.44796], [-120.6502, 39.44783], [-120.65056, 39.44737], [-120.65071, 39.44689], [-120.65068, 39.44649]]]} | Open Access 1 | Bowman Reservoir | http://nidwater.com/recreation/ | 7534 | 2245 | Nevada Irrigation District 961 | Special District 4 | Irrigation District 16 | http://www.nid.dst.ca.us/recreation.cfm | Special District 4 | 748.979 | Bowman Reservoir | |
| 806 | 806 | 805 | {"type": "MultiPolygon", "coordinates": [[[[-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.92397, 39.15796], [-120.92465, 39.1589], [-120.92183, 39.15891], [-120.92178, 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.92425, 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]]], [[[-120.9576, 39.16766], [-120.95746, 39.1679], [-120.95712, 39.16787], [-120.95653, 39.1679], [-120.95613, 39.16785], [-120.95572, 39.16751], [-120.95489, 39.16694], [-120.95444, 39.16654], [-120.95424, 39.16611], [-120.95363, 39.16575], [-120.95358, 39.16547], [-120.9532, 39.16511], [-120.95299, 39.16478], [-120.95298, 39.1643], [-120.95275, 39.16404], [-120.95215, 39.16356], [-120.95144, 39.16323], [-120.95096, 39.16297], [-120.95058, 39.163], [-120.95033, 39.16332], [-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.94605, 39.16377], [-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.94966, 39.16321], [-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.15961], [-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.15718], [-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.1464], [-120.94832, 39.14617], [-120.94799, 39.14563], [-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.14682], [-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.14794], [-120.9409, 39.14834], [-120.94083, 39.14888], [-120.94109, 39.14919], [-120.94123, 39.14945], [-120.94133, 39.14984], [-120.94147, 39.15023], [-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.1542], [-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.93777, 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.93398, 39.15184], [-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.15021], [-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.14602], [-120.9369, 39.14595], [-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.93774, 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.9437, 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.94741, 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.95294, 39.13606], [-120.95372, 39.13651], [-120.95415, 39.13661], [-120.95444, 39.13665], [-120.95475, 39.13687], [-120.95511, 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.95047, 39.14339], [-120.95061, 39.1438], [-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.94945, 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.95386, 39.15443], [-120.95422, 39.15455], [-120.9542, 39.15479], [-120.95427, 39.15533], [-120.95427, 39.15574], [-120.95441, 39.15618], [-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.95247, 39.15869], [-120.95195, 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.95278, 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.95528, 39.16486], [-120.95601, 39.16575], [-120.95627, 39.16599], [-120.95663, 39.16668], [-120.95717, 39.16704], [-120.9576, 39.16766]]]]} | Open Access 1 | Rollins Lake | http://nidwater.com/recreation/ | 7538 | 2245 | Nevada Irrigation District 961 | Special District 4 | Irrigation District 16 | http://www.nid.dst.ca.us/recreation.cfm | Special District 4 | 596.318 | Rollins Lake |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);