units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where COUNTY = 25, MNG_AGENCY = 483 and MNG_AG_TYP = 13
This data as json, copyable, CSV (advanced)
DES_TP 3
ACCESS_TYP 2
MNG_AG_TYP 1
- Water District · 50 ✖
MNG_AGENCY 1
- Yuba County Water Agency · 50 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2176 | 2176 | 2175 | {"type": "Polygon", "coordinates": [[[-121.21037, 39.36811], [-121.20995, 39.36863], [-121.20974, 39.36895], [-121.20958, 39.36931], [-121.20952, 39.36954], [-121.20905, 39.36943], [-121.20895, 39.36687], [-121.20686, 39.36649], [-121.20521, 39.36728], [-121.20494, 39.36732], [-121.2048, 39.36724], [-121.20239, 39.36698], [-121.20227, 39.36726], [-121.20046, 39.36728], [-121.19985, 39.36452], [-121.19852, 39.36285], [-121.19874, 39.36145], [-121.20043, 39.36171], [-121.20125, 39.36084], [-121.20405, 39.35905], [-121.20399, 39.3574], [-121.20311, 39.35745], [-121.20343, 39.35354], [-121.20799, 39.3535], [-121.20822, 39.3587], [-121.20916, 39.35871], [-121.20929, 39.36369], [-121.20987, 39.36548], [-121.21042, 39.36706], [-121.21043, 39.36744], [-121.21037, 39.36811]]]} | Open Access 1 | 16329 | Lake Francis | 15068 | 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 | http://www.lakefrancisrv.com/about.html | Yuba 25 | 239.917 | Lake Francis | None 179 | ||
3438 | 3438 | 3437 | {"type": "Polygon", "coordinates": [[[-121.27738, 39.49699], [-121.277, 39.49737], [-121.27617, 39.49697], [-121.2765, 39.49657], [-121.27738, 39.49699]]]} | Unknown Access 4 | 35476 | Yuba County Water Agency 3 | 27818 | 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.144 | Yuba County Water Agency 3 | 0 | Local Other or Unknown 14 | 4 | |
3457 | 3457 | 3456 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.49693], [-121.27778, 39.49658], [-121.27854, 39.4958], [-121.27851, 39.49654], [-121.27854, 39.49693]]]} | Unknown Access 4 | 35580 | Yuba County Water Agency 47 | 27837 | 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.973 | Yuba County Water Agency 47 | 0 | Local Other or Unknown 14 | 4 | |
3465 | 3465 | 3464 | {"type": "Polygon", "coordinates": [[[-121.27748, 39.49831], [-121.27736, 39.49848], [-121.27711, 39.49873], [-121.27626, 39.49834], [-121.27659, 39.49789], [-121.27748, 39.49831]]]} | Unknown Access 4 | 35637 | Yuba County Water Agency 14 | 27802 | 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.259 | Yuba County Water Agency 14 | 0 | Local Other or Unknown 14 | 4 | |
3583 | 3583 | 3582 | {"type": "Polygon", "coordinates": [[[-121.28103, 39.50008], [-121.27996, 39.49892], [-121.27995, 39.49806], [-121.28102, 39.49808], [-121.28103, 39.50008]]]} | Unknown Access 4 | 36690 | Yuba County Water Agency 39 | 27828 | 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 | 3.618 | Yuba County Water Agency 39 | 0 | Local Other or Unknown 14 | 4 | |
3853 | 3853 | 3852 | {"type": "Polygon", "coordinates": [[[-121.27315, 39.48143], [-121.27314, 39.48349], [-121.26373, 39.48345], [-121.2637, 39.48142], [-121.27315, 39.48143]]]} | Unknown Access 4 | 35576 | Yuba County Water Agency 13 | 27801 | 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 | 45.633 | Yuba County Water Agency 13 | 0 | Local Other or Unknown 14 | 4 | |
3854 | 3854 | 3853 | {"type": "Polygon", "coordinates": [[[-121.27711, 39.49874], [-121.27703, 39.49881], [-121.27655, 39.499], [-121.27626, 39.49896], [-121.27605, 39.49886], [-121.27594, 39.49879], [-121.27626, 39.49835], [-121.27711, 39.49874]]]} | Unknown Access 4 | 35578 | Yuba County Water Agency 49 | 27839 | 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.0 | Yuba County Water Agency 49 | 0 | Local Other or Unknown 14 | 4 | |
3857 | 3857 | 3856 | {"type": "Polygon", "coordinates": [[[-121.27671, 39.49771], [-121.2765, 39.49801], [-121.27567, 39.49769], [-121.27565, 39.49761], [-121.27587, 39.49734], [-121.27671, 39.49771]]]} | Unknown Access 4 | 35587 | Yuba County Water Agency 48 | 27838 | 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.844 | Yuba County Water Agency 48 | 0 | Local Other or Unknown 14 | 4 | |
3866 | 3866 | 3865 | {"type": "Polygon", "coordinates": [[[-121.28772, 39.49953], [-121.28629, 39.49959], [-121.28627, 39.49819], [-121.28769, 39.49815], [-121.28772, 39.49953]]]} | Unknown Access 4 | 35635 | Yuba County Water Agency 18 | 27806 | 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 | 4.676 | Yuba County Water Agency 18 | 0 | Local Other or Unknown 14 | 4 | |
3867 | 3867 | 3866 | {"type": "Polygon", "coordinates": [[[-121.27862, 39.49732], [-121.27862, 39.49732], [-121.27803, 39.49771], [-121.27838, 39.49725], [-121.27858, 39.49713], [-121.27862, 39.49732]]]} | Unknown Access 4 | 35636 | Yuba County Water Agency 15 | 27803 | 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.215 | Yuba County Water Agency 15 | 0 | Local Other or Unknown 14 | 4 | |
3868 | 3868 | 3867 | {"type": "Polygon", "coordinates": [[[-121.2878, 39.49075], [-121.28749, 39.49816], [-121.28627, 39.49819], [-121.27875, 39.49803], [-121.27866, 39.49811], [-121.2808, 39.49561], [-121.28207, 39.49531], [-121.28583, 39.49307], [-121.27774, 39.4835], [-121.28324, 39.48882], [-121.28684, 39.4861], [-121.28687, 39.49074], [-121.2878, 39.49075]]]} | Unknown Access 4 | 35638 | Yuba County Water Agency 38 | 27827 | 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 | 121.398 | Yuba County Water Agency 38 | 0 | Local Other or Unknown 14 | 4 | |
3869 | 3869 | 3868 | {"type": "Polygon", "coordinates": [[[-121.28986, 39.50148], [-121.28872, 39.50152], [-121.28863, 39.49951], [-121.28976, 39.49949], [-121.28986, 39.50148]]]} | Unknown Access 4 | 35639 | Yuba County Water Agency 40 | 27830 | 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 | 5.364 | Yuba County Water Agency 40 | 0 | Local Other or Unknown 14 | 4 | |
3870 | 3870 | 3869 | {"type": "Polygon", "coordinates": [[[-121.27768, 39.49802], [-121.27748, 39.49831], [-121.27659, 39.49789], [-121.27678, 39.49762], [-121.27768, 39.49802]]]} | Unknown Access 4 | 35641 | Yuba County Water Agency 37 | 27826 | 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.772 | Yuba County Water Agency 37 | 0 | Local Other or Unknown 14 | 4 | |
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 | |
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 | |
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 |
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]);