units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
55 rows where ACCESS_TYP = 4 and MNG_AG_TYP = 13 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, COUNTY
MNG_AGENCY 7
DES_TP 3
- Local Other or Unknown 53
- None 1
- None 1
MNG_AG_TYP 1
- Water District · 55 ✖
ACCESS_TYP 1
- Unknown Access · 55 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4487 | 4487 | 4486 | {"type": "Polygon", "coordinates": [[[-117.65095, 33.91007], [-117.65019, 33.91006], [-117.64981, 33.90897], [-117.65009, 33.9089], [-117.65007, 33.90881], [-117.65045, 33.90848], [-117.65044, 33.90828], [-117.64965, 33.9076], [-117.64926, 33.90648], [-117.65093, 33.90642], [-117.65095, 33.91007]]]} | Unknown Access 4 | 4844 | Unnamed site - Orange County Water District | 28653 | 2105 | Orange County Water District 768 | Special District 4 | Water District 13 | http://www.ocwd.com/ | Special District 4 | 2105 | Orange County Water District 749 | Special District 4 | Water District 13 | Riverside 10 | 9.715 | 0 | Local Other or Unknown 14 | 4 | ||
1681 | 1681 | 1680 | {"type": "Polygon", "coordinates": [[[-117.56495, 33.66821], [-117.5606, 33.66822], [-117.56061, 33.67181], [-117.55625, 33.67183], [-117.55624, 33.66465], [-117.56493, 33.66461], [-117.56495, 33.66821]]]} | Unknown Access 4 | 12688 | Trabuco Canyon Water District lands | 26502 | 2166 | Trabuco Canyon Water District 406 | Special District 4 | Water District 13 | http://www.tcwd.ca.gov/ | Special District 4 | 2166 | Trabuco Canyon Water District 400 | Special District 4 | Water District 13 | Orange 3 | 119.276 | Trabuco Canyon Water District lands | None 135 | |||
10640 | 10640 | 10639 | {"type": "Polygon", "coordinates": [[[-120.11817, 34.66507], [-120.11816, 34.66546], [-120.11783, 34.66545], [-120.11784, 34.66507], [-120.11817, 34.66507]]]} | Unknown Access 4 | 18982 | Alamo Pintado Creek | 15319 | 2147 | Santa Ynez River Water Conservation District 953 | Special District 4 | Water District 13 | Special District 4 | 2147 | Santa Ynez River Water Conservation District 925 | Special District 4 | Water District 13 | Santa Barbara 7 | 0.321 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | ||
3158 | 3158 | 3157 | {"type": "Polygon", "coordinates": [[[-121.08887, 38.32906], [-121.08872, 38.32997], [-121.0886, 38.33024], [-121.08831, 38.33059], [-121.08712, 38.33171], [-121.0868, 38.33162], [-121.08621, 38.33112], [-121.08608, 38.33088], [-121.08604, 38.33063], [-121.08614, 38.33054], [-121.08636, 38.33047], [-121.08658, 38.3303], [-121.08671, 38.33014], [-121.08694, 38.32905], [-121.08887, 38.32906]]]} | Unknown Access 4 | 21825 | Smud | 25577 | 2129 | Sacramento Municipal Utility District 591 | Special District 4 | Water District 13 | http://www.smud.org/ | Special District 4 | 2129 | Sacramento Municipal Utility District 581 | Special District 4 | Water District 13 | Sacramento 41 | 10.95 | Smud | None 258 | |||
13379 | 13379 | 13378 | {"type": "Polygon", "coordinates": [[[-121.27563, 39.49942], [-121.27246, 39.50161], [-121.27156, 39.50224], [-121.27495, 39.498], [-121.27524, 39.498], [-121.27482, 39.49898], [-121.27563, 39.49942]]]} | Unknown Access 4 | 35468 | Yuba County Water Agency 42 | 27832 | 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.399 | Yuba County Water Agency 42 | 0 | Local Other or Unknown 14 | 4 | |
13380 | 13380 | 13379 | {"type": "Polygon", "coordinates": [[[-121.47367, 39.03416], [-121.47326, 39.03431], [-121.46836, 39.02634], [-121.46836, 39.02597], [-121.4706, 39.0296], [-121.47089, 39.02975], [-121.47107, 39.02997], [-121.47103, 39.03028], [-121.47317, 39.03389], [-121.47367, 39.03416]]]} | Unknown Access 4 | 35469 | Yuba County Water Agency 10 | 27798 | 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.606 | Yuba County Water Agency 10 | 0 | Local Other or Unknown 14 | 4 | |
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 | |
13383 | 13383 | 13382 | {"type": "Polygon", "coordinates": [[[-121.46836, 39.02634], [-121.46513, 39.02109], [-121.46513, 39.02109], [-121.46532, 39.02102], [-121.46835, 39.02597], [-121.46836, 39.02634]]]} | Unknown Access 4 | 35479 | Yuba County Water Agency 17 | 27805 | 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.744 | Yuba County Water Agency 17 | 0 | Local Other or Unknown 14 | 4 | |
13384 | 13384 | 13383 | {"type": "Polygon", "coordinates": [[[-121.33233, 39.44338], [-121.33233, 39.44361], [-121.3318, 39.44361], [-121.3318, 39.44338], [-121.33233, 39.44338]]]} | Unknown Access 4 | 35480 | Yuba County Water Agency 2 | 27808 | 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.291 | Yuba County Water Agency 2 | 0 | Local Other or Unknown 14 | 4 | |
13385 | 13385 | 13384 | {"type": "Polygon", "coordinates": [[[-121.26373, 39.48345], [-121.26077, 39.48344], [-121.26057, 39.48328], [-121.25903, 39.48256], [-121.26008, 39.48202], [-121.26034, 39.4819], [-121.26043, 39.48155], [-121.26024, 39.48131], [-121.2599, 39.48119], [-121.25891, 39.48101], [-121.25891, 39.48036], [-121.26368, 39.48036], [-121.26373, 39.48345]]]} | Unknown Access 4 | 35481 | Yuba County Water Agency 1 | 27797 | 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 | 29.016 | Yuba County Water Agency 1 | 0 | Local Other or Unknown 14 | 4 | |
13386 | 13386 | 13385 | {"type": "Polygon", "coordinates": [[[-121.19523, 39.33117], [-121.19468, 39.33535], [-121.19452, 39.33532], [-121.19433, 39.33535], [-121.19414, 39.33548], [-121.194, 39.33561], [-121.19383, 39.33565], [-121.19363, 39.3356], [-121.19371, 39.33544], [-121.19369, 39.3352], [-121.19358, 39.33483], [-121.19334, 39.33452], [-121.19295, 39.33364], [-121.19253, 39.33317], [-121.19246, 39.33298], [-121.19256, 39.33309], [-121.19277, 39.33325], [-121.19307, 39.33344], [-121.19345, 39.33359], [-121.19372, 39.33364], [-121.1939, 39.33361], [-121.19393, 39.33358], [-121.194, 39.33347], [-121.194, 39.33342], [-121.19397, 39.33326], [-121.1937, 39.33285], [-121.19363, 39.33258], [-121.19357, 39.33229], [-121.19356, 39.33191], [-121.19352, 39.33153], [-121.19355, 39.33136], [-121.19361, 39.33129], [-121.1938, 39.33122], [-121.19407, 39.33119], [-121.19452, 39.33108], [-121.19489, 39.33111], [-121.19523, 39.33117]]]} | Unknown Access 4 | 35483 | Yuba County Water Agency 11 | 27799 | 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 | 14.69 | Yuba County Water Agency 11 | 0 | Local Other or Unknown 14 | 4 | |
13390 | 13390 | 13389 | {"type": "Polygon", "coordinates": [[[-121.06653, 39.43703], [-121.06571, 39.43704], [-121.06567, 39.4357], [-121.0665, 39.43569], [-121.06653, 39.43703]]]} | Unknown Access 4 | 35493 | Yuba County Water Agency 12 | 27800 | 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.613 | Yuba County Water Agency 12 | 0 | Local Other or Unknown 14 | 4 | |
13391 | 13391 | 13390 | {"type": "Polygon", "coordinates": [[[-121.2718, 39.47467], [-121.27178, 39.47519], [-121.27125, 39.47519], [-121.27123, 39.47535], [-121.27078, 39.47536], [-121.27081, 39.47451], [-121.27119, 39.47444], [-121.27138, 39.47444], [-121.27154, 39.47449], [-121.2717, 39.47457], [-121.2718, 39.47467]]]} | Unknown Access 4 | 35494 | Yuba County Water Agency 9 | 27844 | 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.824 | Yuba County Water Agency 9 | 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 | |
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 | |
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 | |
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 |
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]);