units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where DES_TP = 14 and MNG_AGENCY = 483 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Yuba County Water Agency · 28 ✖
DES_TP 1
- Local Other or Unknown · 28 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3871 | 3871 | 3870 | {"type": "Polygon", "coordinates": [[[-121.2765, 39.49801], [-121.27626, 39.49834], [-121.27594, 39.49879], [-121.27582, 39.49848], [-121.27576, 39.49805], [-121.27567, 39.49769], [-121.2765, 39.49801]]]} | Unknown Access 4 | 35642 | Yuba County Water Agency 36 | 27825 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.008 | Yuba County Water Agency 36 | 0 | Local Other or Unknown 14 | 4 | |
3872 | 3872 | 3871 | {"type": "Polygon", "coordinates": [[[-121.27589, 39.49889], [-121.27563, 39.49942], [-121.27481, 39.49898], [-121.27531, 39.49782], [-121.27554, 39.49761], [-121.27564, 39.49806], [-121.27575, 39.49869], [-121.27589, 39.49889]]]} | Unknown Access 4 | 35643 | Yuba County Water Agency 35 | 27824 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 2.388 | Yuba County Water Agency 35 | 0 | Local Other or Unknown 14 | 4 | |
3873 | 3873 | 3872 | {"type": "Polygon", "coordinates": [[[-121.27655, 39.4991], [-121.2759, 39.49956], [-121.27563, 39.49942], [-121.27589, 39.49889], [-121.27615, 39.49905], [-121.27655, 39.4991]]]} | Unknown Access 4 | 35644 | Yuba County Water Agency 34 | 27823 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 0.673 | Yuba County Water Agency 34 | 0 | Local Other or Unknown 14 | 4 | |
13451 | 13451 | 13450 | {"type": "Polygon", "coordinates": [[[-121.28536, 39.46045], [-121.28531, 39.46143], [-121.28411, 39.46143], [-121.28411, 39.46113], [-121.28423, 39.46099], [-121.28459, 39.46073], [-121.28498, 39.46026], [-121.28536, 39.46045]]]} | Unknown Access 4 | 35663 | Yuba County Water Agency 4 | 27829 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 2.361 | Yuba County Water Agency 4 | 0 | Local Other or Unknown 14 | 4 | |
13453 | 13453 | 13452 | {"type": "Polygon", "coordinates": [[[-121.27315, 39.48037], [-121.27315, 39.48143], [-121.2637, 39.48142], [-121.26368, 39.48036], [-121.27315, 39.48037]]]} | Unknown Access 4 | 35664 | Yuba County Water Agency 5 | 27840 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 23.618 | Yuba County Water Agency 5 | 0 | Local Other or Unknown 14 | 4 | |
13462 | 13462 | 13461 | {"type": "Polygon", "coordinates": [[[-121.28629, 39.49959], [-121.28524, 39.49961], [-121.28526, 39.50057], [-121.28357, 39.49813], [-121.28627, 39.49819], [-121.28629, 39.49959]]]} | Unknown Access 4 | 35682 | Yuba County Water Agency 8 | 27843 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 8.198 | Yuba County Water Agency 8 | 0 | Local Other or Unknown 14 | 4 | |
13463 | 13463 | 13462 | {"type": "Polygon", "coordinates": [[[-121.27797, 39.49638], [-121.27764, 39.49672], [-121.27672, 39.49629], [-121.27702, 39.49592], [-121.27797, 39.49638]]]} | Unknown Access 4 | 35683 | Yuba County Water Agency 6 | 27841 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.137 | Yuba County Water Agency 6 | 0 | Local Other or Unknown 14 | 4 | |
3876 | 3876 | 3875 | {"type": "Polygon", "coordinates": [[[-121.28161, 39.49241], [-121.28087, 39.49553], [-121.27866, 39.49811], [-121.27864, 39.49743], [-121.27853, 39.49685], [-121.27851, 39.49655], [-121.27854, 39.4958], [-121.27841, 39.49547], [-121.27838, 39.4953], [-121.27916, 39.49462], [-121.27937, 39.49367], [-121.27955, 39.49218], [-121.27846, 39.49076], [-121.27957, 39.49017], [-121.28161, 39.49241]]]} | Unknown Access 4 | 35684 | Yuba County Water Agency 7 | 27842 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 30.672 | Yuba County Water Agency 7 | 0 | Local Other or Unknown 14 | 4 | |
3879 | 3879 | 3878 | {"type": "Polygon", "coordinates": [[[-121.19451, 39.33672], [-121.19414, 39.33949], [-121.18597, 39.3391], [-121.18689, 39.33154], [-121.18707, 39.33029], [-121.18718, 39.3303], [-121.18742, 39.3303], [-121.18842, 39.3304], [-121.18881, 39.3304], [-121.18925, 39.33042], [-121.18963, 39.33042], [-121.19002, 39.33044], [-121.19016, 39.33043], [-121.18978, 39.3321], [-121.19067, 39.33218], [-121.19105, 39.33663], [-121.1914, 39.33671], [-121.19169, 39.33661], [-121.19204, 39.33663], [-121.19255, 39.33679], [-121.19303, 39.33702], [-121.19349, 39.33708], [-121.19377, 39.33714], [-121.19405, 39.33696], [-121.19418, 39.33677], [-121.19451, 39.33672]]]} | Unknown Access 4 | 35703 | Yuba County Water Agency 25 | 27814 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 108.796 | Yuba County Water Agency 25 | 0 | Local Other or Unknown 14 | 4 | |
13468 | 13468 | 13467 | {"type": "Polygon", "coordinates": [[[-121.19416, 39.34305], [-121.18906, 39.34311], [-121.18673, 39.34309], [-121.18576, 39.34311], [-121.18597, 39.33911], [-121.19414, 39.3395], [-121.19416, 39.34305]]]} | Unknown Access 4 | 35708 | Yuba County Water Agency 26 | 27815 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 74.263 | Yuba County Water Agency 26 | 0 | Local Other or Unknown 14 | 4 | |
13469 | 13469 | 13468 | {"type": "Polygon", "coordinates": [[[-121.29311, 39.25371], [-121.29294, 39.2539], [-121.29268, 39.25388], [-121.29234, 39.2538], [-121.292, 39.25364], [-121.2917, 39.25346], [-121.29143, 39.25326], [-121.29142, 39.25285], [-121.29189, 39.25325], [-121.2921, 39.25341], [-121.29256, 39.25363], [-121.29289, 39.2537], [-121.29311, 39.25371]]]} | Unknown Access 4 | 35727 | Yuba County Water Agency 19 | 27807 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.079 | Yuba County Water Agency 19 | 0 | Local Other or Unknown 14 | 4 | |
13470 | 13470 | 13469 | {"type": "Polygon", "coordinates": [[[-121.2633, 39.4399], [-121.26298, 39.44032], [-121.26282, 39.44033], [-121.26271, 39.44023], [-121.26276, 39.43992], [-121.2633, 39.4399]]]} | Unknown Access 4 | 35728 | Yuba County Water Agency 21 | 27810 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 0.391 | Yuba County Water Agency 21 | 0 | Local Other or Unknown 14 | 4 | |
13471 | 13471 | 13470 | {"type": "Polygon", "coordinates": [[[-121.19527, 39.33087], [-121.19525, 39.331], [-121.19493, 39.33095], [-121.19451, 39.33091], [-121.19403, 39.33103], [-121.19375, 39.33106], [-121.19348, 39.33116], [-121.19335, 39.3313], [-121.19331, 39.33152], [-121.19335, 39.33192], [-121.19336, 39.3323], [-121.19349, 39.3329], [-121.19377, 39.33332], [-121.19379, 39.33342], [-121.19376, 39.33347], [-121.19354, 39.33343], [-121.19317, 39.3333], [-121.19292, 39.33314], [-121.19273, 39.33299], [-121.1926, 39.33284], [-121.19234, 39.3328], [-121.19228, 39.33282], [-121.19225, 39.33288], [-121.19225, 39.333], [-121.19234, 39.33325], [-121.19276, 39.33371], [-121.19314, 39.33458], [-121.19338, 39.33489], [-121.19348, 39.33521], [-121.19349, 39.33542], [-121.19339, 39.33563], [-121.19339, 39.33567], [-121.19341, 39.33571], [-121.19344, 39.33573], [-121.19385, 39.33582], [-121.19412, 39.33575], [-121.19442, 39.3355], [-121.19452, 39.33549], [-121.19466, 39.33552], [-121.19451, 39.33671], [-121.19418, 39.33677], [-121.19405, 39.33696], [-121.19377, 39.33714], [-121.19349, 39.33708], [-121.19303, 39.33702], [-121.19255, 39.33679], [-121.19204, 39.33663], [-121.19169, 39.33661], [-121.1914, 39.33671], [-121.19105, 39.33663], [-121.19067, 39.33218], [-121.19163, 39.33225], [-121.19187, 39.33099], [-121.19192, 39.33103], [-121.19198, 39.33104], [-121.19243, 39.33099], [-121.19268, 39.33086], [-121.193, 39.33073], [-121.19342, 39.33066], [-121.1939, 39.33064], [-121.19427, 39.33064], [-121.19476, 39.33074], [-121.19527, 39.33087]]]} | Unknown Access 4 | 35729 | Yuba County Water Agency 20 | 27809 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 35.226 | Yuba County Water Agency 20 | 0 | Local Other or Unknown 14 | 4 | |
13378 | 13378 | 13377 | {"type": "Polygon", "coordinates": [[[-121.27764, 39.49673], [-121.27738, 39.49699], [-121.2765, 39.49656], [-121.27672, 39.49629], [-121.27764, 39.49673]]]} | Unknown Access 4 | 35732 | Yuba County Water Agency 24 | 27813 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 0.817 | Yuba County Water Agency 24 | 0 | Local Other or Unknown 14 | 4 | |
3883 | 3883 | 3882 | {"type": "Polygon", "coordinates": [[[-121.26021, 39.48175], [-121.26013, 39.48186], [-121.25967, 39.48201], [-121.25908, 39.48231], [-121.25892, 39.48241], [-121.25892, 39.48267], [-121.25836, 39.48299], [-121.25892, 39.48344], [-121.25524, 39.48339], [-121.25431, 39.48275], [-121.25488, 39.48191], [-121.25549, 39.48189], [-121.25594, 39.48185], [-121.25652, 39.48175], [-121.256, 39.48003], [-121.25695, 39.47864], [-121.2589, 39.47905], [-121.25891, 39.48114], [-121.26003, 39.48142], [-121.26014, 39.48149], [-121.2602, 39.48164], [-121.26021, 39.48175]]]} | Unknown Access 4 | 35733 | Yuba County Water Agency 23 | 27812 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 35.822 | Yuba County Water Agency 23 | 0 | Local Other or Unknown 14 | 4 | |
3884 | 3884 | 3883 | {"type": "Polygon", "coordinates": [[[-121.27856, 39.49702], [-121.27829, 39.49721], [-121.2775, 39.49687], [-121.27778, 39.49658], [-121.27854, 39.49693], [-121.27856, 39.49702]]]} | Unknown Access 4 | 35734 | Yuba County Water Agency 22 | 27811 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 0.771 | Yuba County Water Agency 22 | 0 | Local Other or Unknown 14 | 4 | |
13474 | 13474 | 13473 | {"type": "Polygon", "coordinates": [[[-121.06719, 39.44088], [-121.067, 39.44107], [-121.06698, 39.44105], [-121.0669, 39.44097], [-121.06677, 39.44072], [-121.06674, 39.44058], [-121.06685, 39.44057], [-121.06683, 39.44046], [-121.06679, 39.44041], [-121.06673, 39.44036], [-121.06641, 39.44028], [-121.06619, 39.4402], [-121.06602, 39.4401], [-121.06586, 39.43999], [-121.06562, 39.43972], [-121.06549, 39.43952], [-121.06517, 39.43938], [-121.06562, 39.43937], [-121.06574, 39.43953], [-121.0658, 39.43964], [-121.06603, 39.43988], [-121.06615, 39.43997], [-121.0663, 39.44006], [-121.06684, 39.44022], [-121.06697, 39.44032], [-121.06703, 39.44041], [-121.06707, 39.44066], [-121.06712, 39.44077], [-121.06719, 39.44088]]]} | Unknown Access 4 | 35736 | Yuba County Water Agency 27 | 27816 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.231 | Yuba County Water Agency 27 | 0 | Local Other or Unknown 14 | 4 | |
3885 | 3885 | 3884 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.4958], [-121.27825, 39.4961], [-121.27743, 39.49552], [-121.2781, 39.49497], [-121.27831, 39.49492], [-121.27841, 39.49547], [-121.27854, 39.4958]]]} | Unknown Access 4 | 35737 | Yuba County Water Agency 30 | 27819 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.61 | Yuba County Water Agency 30 | 0 | Local Other or Unknown 14 | 4 | |
13475 | 13475 | 13474 | {"type": "Polygon", "coordinates": [[[-121.26491, 39.48036], [-121.25891, 39.48036], [-121.25891, 39.47936], [-121.25891, 39.47936], [-121.26491, 39.48036]]]} | Unknown Access 4 | 35738 | Yuba County Water Agency 16 | 27804 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 7.056 | Yuba County Water Agency 16 | 0 | Local Other or Unknown 14 | 4 | |
13464 | 13464 | 13463 | {"type": "Polygon", "coordinates": [[[-121.27799, 39.49761], [-121.27768, 39.49802], [-121.27678, 39.49762], [-121.27712, 39.49725], [-121.27799, 39.49761]]]} | Unknown Access 4 | 35739 | Yuba County Water Agency 33 | 27822 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.114 | Yuba County Water Agency 33 | 0 | Local Other or Unknown 14 | 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]);