units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where DES_TP = 3, MNG_AGENCY = 961 and MNG_AG_LEV = 4
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, COUNTY, LABEL_NAME
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Nevada Irrigation District · 3 ✖
DES_TP 1
- Local Recreation Area · 3 ✖
| 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 |
| 11882 | 11882 | 11881 | {"type": "Polygon", "coordinates": [[[-121.06068, 39.01094], [-121.05988, 39.01093], [-121.05987, 39.01207], [-121.05892, 39.01208], [-121.05891, 39.01094], [-121.05828, 39.01095], [-121.05827, 39.01054], [-121.05765, 39.01054], [-121.05743, 39.0107], [-121.05703, 39.0109], [-121.05603, 39.01104], [-121.05574, 39.01112], [-121.05479, 39.01106], [-121.05391, 39.01097], [-121.05334, 39.011], [-121.05232, 39.01164], [-121.0509, 39.01261], [-121.05055, 39.01301], [-121.0503, 39.01319], [-121.05038, 39.0134], [-121.05033, 39.01335], [-121.05028, 39.01337], [-121.04953, 39.01386], [-121.04948, 39.01397], [-121.04949, 39.01413], [-121.04956, 39.01428], [-121.04963, 39.01435], [-121.05001, 39.01456], [-121.04994, 39.01478], [-121.04994, 39.01499], [-121.05008, 39.01534], [-121.05021, 39.0155], [-121.05051, 39.0157], [-121.05062, 39.01586], [-121.05059, 39.01594], [-121.04995, 39.01624], [-121.04968, 39.01604], [-121.04924, 39.01581], [-121.04869, 39.01514], [-121.04822, 39.01493], [-121.04806, 39.01513], [-121.04803, 39.01546], [-121.04805, 39.01639], [-121.04814, 39.01663], [-121.04826, 39.01674], [-121.04837, 39.01699], [-121.04837, 39.01707], [-121.048, 39.01747], [-121.04747, 39.01782], [-121.04738, 39.01801], [-121.04708, 39.01788], [-121.04654, 39.01789], [-121.04623, 39.01797], [-121.04565, 39.01773], [-121.04534, 39.01721], [-121.04555, 39.01682], [-121.04552, 39.01669], [-121.04545, 39.01658], [-121.04531, 39.0165], [-121.04518, 39.01649], [-121.04499, 39.01652], [-121.04482, 39.0166], [-121.04468, 39.01673], [-121.04395, 39.01679], [-121.04405, 39.01634], [-121.04405, 39.01595], [-121.04398, 39.01569], [-121.04426, 39.01551], [-121.0444, 39.01532], [-121.04448, 39.01508], [-121.04448, 39.01491], [-121.04445, 39.01481], [-121.04428, 39.01467], [-121.0439, 39.01465], [-121.04362, 39.01459], [-121.04334, 39.01462], [-121.04296, 39.01478], [-121.04264, 39.01507], [-121.04227, 39.01531], [-121.04168, 39.01544], [-121.04104, 39.01561], [-121.04071, 39.01609], [-121.04081, 39.01649], [-121.04066, 39.01709], [-121.04051, 39.01713], [-121.04039, 39.01693], [-121.03998, 39.01683], [-121.03961, 39.017], [-121.03948, 39.0177], [-121.03918, 39.01802], [-121.03868, 39.01831], [-121.03859, 39.01863], [-121.03881, 39.01893], [-121.03901, 39.01939], [-121.03954, 39.01991], [-121.03959, 39.02042], [-121.03972, 39.02058], [-121.03945, 39.0209], [-121.03932, 39.02101], [-121.03926, 39.02115], [-121.03925, 39.02136], [-121.03928, 39.02161], [-121.03933, 39.02183], [-121.03941, 39.02201], [-121.03942, 39.02208], [-121.03905, 39.02208], [-121.0388, 39.02211], [-121.03859, 39.02215], [-121.03851, 39.0222], [-121.03845, 39.02233], [-121.03828, 39.02282], [-121.03824, 39.02327], [-121.03746, 39.02334], [-121.03744, 39.02335], [-121.03743, 39.02341], [-121.03738, 39.02345], [-121.03714, 39.02357], [-121.03647, 39.02372], [-121.03615, 39.0238], [-121.03523, 39.02412], [-121.03504, 39.02454], [-121.03488, 39.02534], [-121.0348, 39.02553], [-121.03468, 39.0257], [-121.03459, 39.02581], [-121.03443, 39.02591], [-121.0343, 39.02596], [-121.03399, 39.02604], [-121.03382, 39.02612], [-121.03369, 39.02621], [-121.03361, 39.02633], [-121.03358, 39.02643], [-121.03356, 39.02662], [-121.03354, 39.02789], [-121.03284, 39.02786], [-121.03263, 39.02791], [-121.03235, 39.02811], [-121.03213, 39.0284], [-121.03199, 39.02869], [-121.03188, 39.02902], [-121.03176, 39.02951], [-121.03132, 39.03307], [-121.03224, 39.03726], [-121.03043, 39.0373], [-121.03057, 39.03721], [-121.03061, 39.03708], [-121.03054, 39.0369], [-121.03042, 39.03685], [-121.0305, 39.03655], [-121.03052, 39.03624], [-121.03038, 39.0354], [-121.03034, 39.03471], [-121.03022, 39.03345], [-121.03014, 39.03232], [-121.03012, 39.0311], [-121.03029, 39.02956], [-121.03066, 39.02798], [-121.0308, 39.02761], [-121.03116, 39.02687], [-121.03149, 39.02628], [-121.03222, 39.02545], [-121.03243, 39.02517], [-121.03267, 39.025], [-121.03297, 39.02471], [-121.03328, 39.02445], [-121.03567, 39.02255], [-121.036, 39.02225], [-121.03623, 39.02209], [-121.03644, 39.02191], [-121.03673, 39.02173], [-121.03734, 39.02127], [-121.03776, 39.02083], [-121.03783, 39.02068], [-121.03779, 39.02021], [-121.03765, 39.01965], [-121.03746, 39.01936], [-121.03719, 39.01878], [-121.03698, 39.01816], [-121.03698, 39.01792], [-121.03701, 39.01758], [-121.03713, 39.01716], [-121.03734, 39.01676], [-121.03758, 39.0164], [-121.03842, 39.01578], [-121.03989, 39.01492], [-121.04015, 39.0147], [-121.04078, 39.01429], [-121.04107, 39.01411], [-121.04146, 39.01394], [-121.04172, 39.01388], [-121.04236, 39.01364], [-121.04269, 39.01354], [-121.04297, 39.01352], [-121.04349, 39.01339], [-121.04422, 39.01324], [-121.04484, 39.01323], [-121.04543, 39.01332], [-121.0463, 39.01325], [-121.04668, 39.01329], [-121.04713, 39.01324], [-121.04748, 39.01323], [-121.04864, 39.01302], [-121.04899, 39.0129], [-121.04972, 39.01253], [-121.04991, 39.01233], [-121.05038, 39.01202], [-121.05121, 39.0114], [-121.05191, 39.01094], [-121.0525, 39.01061], [-121.05274, 39.0105], [-121.05309, 39.01041], [-121.05375, 39.01036], [-121.05439, 39.01028], [-121.05475, 39.01029], [-121.05503, 39.01027], [-121.05559, 39.01031], [-121.05651, 39.01025], [-121.0572, 39.01014], [-121.05748, 39.01003], [-121.05772, 39.00999], [-121.05807, 39.00987], [-121.05826, 39.00988], [-121.05866, 39.00981], [-121.05889, 39.00979], [-121.05942, 39.00994], [-121.05972, 39.01004], [-121.06052, 39.0101], [-121.06064, 39.01012], [-121.06068, 39.01094]]]} | Restricted Access 2 | 24331 | Combie Reservoir | 30307 | 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 | 189.225 | Combie Reservoir | 0 | Local Recreation Area 3 | 4 |
| 11897 | 11897 | 11896 | {"type": "Polygon", "coordinates": [[[-121.05843, 39.00899], [-121.05808, 39.00958], [-121.05802, 39.00979], [-121.05803, 39.00989], [-121.05772, 39.00999], [-121.05748, 39.01003], [-121.0572, 39.01014], [-121.05651, 39.01025], [-121.05559, 39.01031], [-121.05503, 39.01027], [-121.05475, 39.01029], [-121.05438, 39.01028], [-121.05375, 39.01036], [-121.05309, 39.01041], [-121.05274, 39.0105], [-121.0525, 39.01061], [-121.05191, 39.01094], [-121.05121, 39.0114], [-121.05038, 39.01202], [-121.04991, 39.01233], [-121.04972, 39.01253], [-121.04899, 39.0129], [-121.04864, 39.01302], [-121.04748, 39.01323], [-121.04713, 39.01324], [-121.04668, 39.01329], [-121.0463, 39.01325], [-121.04543, 39.01332], [-121.04484, 39.01323], [-121.04422, 39.01324], [-121.04349, 39.01339], [-121.04297, 39.01352], [-121.04269, 39.01354], [-121.04236, 39.01364], [-121.04172, 39.01388], [-121.04146, 39.01394], [-121.04107, 39.01411], [-121.04078, 39.01429], [-121.04015, 39.0147], [-121.03989, 39.01492], [-121.03842, 39.01578], [-121.03758, 39.0164], [-121.03734, 39.01676], [-121.03713, 39.01716], [-121.03701, 39.01758], [-121.03698, 39.01792], [-121.03698, 39.01816], [-121.03719, 39.01878], [-121.03746, 39.01936], [-121.03765, 39.01965], [-121.03779, 39.02021], [-121.03783, 39.02068], [-121.03776, 39.02083], [-121.03734, 39.02127], [-121.03673, 39.02173], [-121.03644, 39.02191], [-121.03623, 39.02209], [-121.036, 39.02225], [-121.03567, 39.02255], [-121.03328, 39.02445], [-121.03297, 39.02471], [-121.03267, 39.025], [-121.03243, 39.02517], [-121.03149, 39.02628], [-121.03116, 39.02687], [-121.0308, 39.02761], [-121.03066, 39.02798], [-121.03029, 39.02956], [-121.03012, 39.0311], [-121.03014, 39.03233], [-121.03035, 39.03508], [-121.02979, 39.03495], [-121.02953, 39.03461], [-121.02938, 39.03406], [-121.02915, 39.03134], [-121.02894, 39.03104], [-121.029, 39.03019], [-121.02868, 39.0298], [-121.02789, 39.02964], [-121.0278, 39.02951], [-121.02783, 39.02944], [-121.02868, 39.02914], [-121.02927, 39.02875], [-121.02947, 39.02843], [-121.0295, 39.02808], [-121.02982, 39.02742], [-121.02982, 39.02664], [-121.03006, 39.02607], [-121.03082, 39.02539], [-121.03123, 39.02477], [-121.03326, 39.02294], [-121.03367, 39.02242], [-121.03352, 39.02223], [-121.03344, 39.02186], [-121.03364, 39.02177], [-121.03443, 39.02157], [-121.0352, 39.02157], [-121.03555, 39.02145], [-121.03575, 39.02115], [-121.03575, 39.02079], [-121.03564, 39.02052], [-121.03572, 39.02003], [-121.03575, 39.01953], [-121.03546, 39.01914], [-121.03537, 39.01843], [-121.03446, 39.01816], [-121.03335, 39.01822], [-121.03109, 39.01811], [-121.03006, 39.01825], [-121.03015, 39.01802], [-121.03042, 39.01788], [-121.03159, 39.01759], [-121.03226, 39.01699], [-121.03399, 39.01685], [-121.03432, 39.01669], [-121.03543, 39.01674], [-121.03602, 39.01633], [-121.03619, 39.01599], [-121.03631, 39.01551], [-121.03617, 39.01511], [-121.03625, 39.015], [-121.03784, 39.01461], [-121.03834, 39.01431], [-121.0391, 39.01335], [-121.0391, 39.01317], [-121.03828, 39.01278], [-121.0374, 39.01219], [-121.03705, 39.01187], [-121.03713, 39.01162], [-121.03754, 39.01164], [-121.03843, 39.01202], [-121.03878, 39.01203], [-121.03901, 39.01182], [-121.03927, 39.01173], [-121.03963, 39.012], [-121.03989, 39.012], [-121.04018, 39.01182], [-121.04039, 39.0115], [-121.0408, 39.01113], [-121.04106, 39.01118], [-121.04124, 39.01191], [-121.04147, 39.01214], [-121.04188, 39.01225], [-121.04279, 39.01232], [-121.04344, 39.01216], [-121.04388, 39.01194], [-121.04409, 39.01164], [-121.04432, 39.01155], [-121.04497, 39.01205], [-121.04538, 39.01223], [-121.04587, 39.01228], [-121.0464, 39.01193], [-121.04687, 39.01184], [-121.04764, 39.01203], [-121.04816, 39.01196], [-121.04875, 39.01173], [-121.05083, 39.01013], [-121.05112, 39.00969], [-121.05109, 39.00917], [-121.05086, 39.00882], [-121.05016, 39.00853], [-121.04869, 39.00855], [-121.04722, 39.00846], [-121.04578, 39.00818], [-121.0445, 39.00827], [-121.0442, 39.00804], [-121.04373, 39.00733], [-121.0425, 39.00681], [-121.04215, 39.00658], [-121.042, 39.00601], [-121.0423, 39.00605], [-121.04312, 39.00633], [-121.04467, 39.00647], [-121.04532, 39.00667], [-121.04632, 39.00729], [-121.04816, 39.00766], [-121.04896, 39.00763], [-121.05018, 39.00729], [-121.05089, 39.0077], [-121.05151, 39.00784], [-121.05253, 39.00859], [-121.05321, 39.00921], [-121.05364, 39.00933], [-121.05476, 39.00919], [-121.05535, 39.00935], [-121.05646, 39.00921], [-121.05746, 39.00883], [-121.05843, 39.00899]]]} | Restricted Access 2 | 24349 | Combie Reservoir | 30307 | 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 | 191.693 | Combie Reservoir | 0 | Local Recreation Area 3 | 4 |
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]);