units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, COUNTY = 30 and MNG_AGENCY = 961
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11881 | 11881 | 11880 | {"type": "Polygon", "coordinates": [[[-120.6546, 39.44323], [-120.65422, 39.44362], [-120.65392, 39.44405], [-120.65283, 39.44476], [-120.65271, 39.4449], [-120.65239, 39.446], [-120.65224, 39.44623], [-120.65142, 39.44696], [-120.65142, 39.44719], [-120.65118, 39.44744], [-120.65109, 39.44764], [-120.65174, 39.44801], [-120.65209, 39.44833], [-120.65242, 39.4485], [-120.65186, 39.4485], [-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.62803, 39.45937], [-120.62657, 39.45936], [-120.62459, 39.45849], [-120.62377, 39.45831], [-120.62306, 39.45833], [-120.62238, 39.45851], [-120.62188, 39.45831], [-120.62161, 39.45831], [-120.62117, 39.45847], [-120.62049, 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.45764], [-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.61158, 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.6186, 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.45437], [-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.45207], [-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.63578, 39.44865], [-120.63611, 39.44845], [-120.64243, 39.44846], [-120.64244, 39.4463], [-120.6433, 39.44593], [-120.64383, 39.44538], [-120.64413, 39.44463], [-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.65354, 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.45746], [-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.45746]], [[-120.65068, 39.44648], [-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.65021, 39.44783], [-120.65056, 39.44737], [-120.65071, 39.44689], [-120.65068, 39.44648]]]} | Open Access 1 | 24330 | Bowman Reservoir | 7534 | 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 | 748.864 | Bowman Reservoir | 0 | Local Recreation Area 3 | 4 |
| 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]);