units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
74 rows where COUNTY = 25 and MNG_AG_TYP = 13 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID
DES_TP 10
- Local Other or Unknown 49
- Local Park 15
- Local Recreation Area 3
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 3
ACCESS_TYP 2
- Unknown Access 48
- Open Access 26
MNG_AG_TYP 1
- Water District · 74 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
11260 | 11260 | 11259 | {"type": "Polygon", "coordinates": [[[-121.53871, 39.07389], [-121.5384, 39.07389], [-121.53837, 39.07383], [-121.53834, 39.0738], [-121.53824, 39.07377], [-121.53827, 39.07352], [-121.5387, 39.07352], [-121.53871, 39.07389]]]} | Open Access 1 | 21693 | Summerfield Detention Basin | 25956 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 0.369 | Summerfield Detention Basin | None 983 | |||
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 | |
3149 | 3149 | 3148 | {"type": "Polygon", "coordinates": [[[-121.55129, 39.10154], [-121.55129, 39.10208], [-121.55128, 39.10252], [-121.55114, 39.1024], [-121.55101, 39.10223], [-121.55098, 39.10215], [-121.55097, 39.10202], [-121.55102, 39.10186], [-121.5512, 39.1015], [-121.55129, 39.10154]]]} | Open Access 1 | 21674 | Chestnut Park | 17183 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 0.52 | Chestnut Park | 0 | Local Park 2 | 4 | |
11236 | 11236 | 11235 | {"type": "Polygon", "coordinates": [[[-121.56747, 39.0595], [-121.56741, 39.05964], [-121.56737, 39.05981], [-121.5668, 39.05982], [-121.56678, 39.05978], [-121.56673, 39.05974], [-121.56662, 39.05971], [-121.56675, 39.05938], [-121.56747, 39.0595]]]} | Open Access 1 | 21690 | Prairie Trails Park | 23977 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 0.658 | Prairie Trails Park | 0 | Local Park 2 | 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 | |
11262 | 11262 | 11261 | {"type": "Polygon", "coordinates": [[[-121.53733, 39.07823], [-121.53719, 39.07869], [-121.537, 39.07865], [-121.53637, 39.07861], [-121.53637, 39.07855], [-121.53649, 39.07851], [-121.53653, 39.07843], [-121.53649, 39.07833], [-121.53646, 39.07831], [-121.53646, 39.07826], [-121.53669, 39.07826], [-121.53692, 39.07823], [-121.53733, 39.07823]]]} | Open Access 1 | 21695 | Johnson Park | 20479 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 0.76 | Johnson Park | 0 | Local Park 2 | 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 | |
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 | |
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 | |
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 | |
13465 | 13465 | 13464 | {"type": "Polygon", "coordinates": [[[-121.277, 39.49738], [-121.27682, 39.49756], [-121.27671, 39.49771], [-121.27587, 39.49733], [-121.27617, 39.49697], [-121.277, 39.49738]]]} | Unknown Access 4 | 35740 | Yuba County Water Agency 32 | 27821 | 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.951 | Yuba County Water Agency 32 | 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 | |
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 | |
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 | |
11244 | 11244 | 11243 | {"type": "Polygon", "coordinates": [[[-121.55377, 39.0223], [-121.55374, 39.02233], [-121.55363, 39.02233], [-121.55302, 39.02231], [-121.55288, 39.02229], [-121.55285, 39.02225], [-121.55286, 39.02204], [-121.55284, 39.02189], [-121.55376, 39.02182], [-121.55378, 39.02219], [-121.55377, 39.0223]]]} | Open Access 1 | 21688 | River Park | 24420 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 1.022 | River Park | 0 | Local Park 2 | 4 | |
13466 | 13466 | 13465 | {"type": "Polygon", "coordinates": [[[-121.27829, 39.49721], [-121.27799, 39.49761], [-121.27712, 39.49725], [-121.2775, 39.49687], [-121.27829, 39.49721]]]} | Unknown Access 4 | 35741 | Yuba County Water Agency 31 | 27820 | 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.044 | Yuba County Water Agency 31 | 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 | |
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]);