superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
187 rows where MNG_AG_TYP = 13 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AGENCY >30
- Yuba County Water Agency 50
- Olivehurst Public Utility District 23
- East Bay Municipal Utility District 11
- Santa Clara Valley Water District 8
- Metropolitan Water District of Southern California 7
- Marin Municipal Water District 6
- Tahoe City Public Utilities District 6
- Heber Public Utility District 4
- Valley Center Water District 4
- Helix Water District 4
- Las Virgenes Municipal Water District 3
- Soquel Creek Water District 3
- San Lorenzo Valley Water District 3
- North Tahoe Public Utilities District 3
- Olivenhain Municipal Water District 3
- Ramona Municipal Water District 3
- Sonoma County Water Agency 2
- Sacramento Municipal Utility District 2
- Burney Co Water District 2
- Yuima Municipal Water District 2
- Orange County Water District 2
- North Marin Water District 2
- San Diego County Water Authority 2
- Contra Costa Water District 2
- San Gabriel River Water Committee 1
- Trabuco Canyon Water District 1
- Montecito Water District 1
- North Coast Water District 1
- Scotts Valley Water District 1
- Borrego Water District 1
- …
ACCESS_TYP 4
- Open Access 93
- Unknown Access 54
- No Public Access 27
- Restricted Access 13
MNG_AG_TYP 1
- Water District · 187 ✖
MNG_AG_LEV 1 ✖
- Special District 187
LAYER 1 ✖
- Special District 187
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11289 | 11289 | 11288 | {"type": "Polygon", "coordinates": [[[-121.93307, 36.98817], [-121.93305, 36.9883], [-121.93244, 36.98822], [-121.93247, 36.98809], [-121.93307, 36.98817]]]} | Open Access 1 | Willowbrook Park - Soquel Creek Water District | 27591 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 0.197 | Willowbrook Park - Soquel Creek Water District | ||
11429 | 11429 | 11428 | {"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 | Yuba County Water Agency 15 | 27803 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.215 | Yuba County Water Agency 15 | ||
11457 | 11457 | 11456 | {"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 | Yuba County Water Agency 2 | 27808 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.291 | Yuba County Water Agency 2 | ||
1118 | 1118 | 1117 | {"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 | Alamo Pintado Creek | 15319 | 2147 | Santa Ynez River Water Conservation District 925 | Special District 4 | Water District 13 | Special District 4 | 0.321 | Alamo Pintado Creek | |||
10051 | 10051 | 10050 | {"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 | Summerfield Detention Basin | 25956 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 0.369 | Summerfield Detention Basin | ||
11459 | 11459 | 11458 | {"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 | Yuba County Water Agency 21 | 27810 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.391 | Yuba County Water Agency 21 | ||
15436 | 15436 | 15435 | {"type": "Polygon", "coordinates": [[[-120.048, 39.2394], [-120.0475, 39.23937], [-120.04744, 39.2393], [-120.04741, 39.23912], [-120.04744, 39.23907], [-120.04793, 39.23907], [-120.04799, 39.23915], [-120.048, 39.2394]]]} | Open Access 1 | Tahoe Vista Recreation Area | http://northtahoeparks.com/beaches | 30867 | 2246 | North Tahoe Public Utilities District 614 | Special District 4 | Water District 13 | http://www.ntpud.org/ | Special District 4 | 0.408 | Tahoe Vista Rec. Area | |
5008 | 5008 | 5007 | {"type": "Polygon", "coordinates": [[[-115.53155, 32.73148], [-115.53126, 32.73148], [-115.53109, 32.73143], [-115.53101, 32.73145], [-115.53086, 32.73122], [-115.53155, 32.73119], [-115.53155, 32.73148]]]} | Open Access 1 | Heber Children Park | 19788 | 2278 | Heber Public Utility District 648 | Special District 4 | Water District 13 | http://heber.ca.gov/index.php | Special District 4 | 0.421 | Heber Children Park | ||
2888 | 2888 | 2887 | {"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 | Chestnut Park | 17183 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 0.52 | Chestnut Park | ||
7748 | 7748 | 7747 | {"type": "Polygon", "coordinates": [[[-122.20297, 37.89593], [-122.20284, 37.89706], [-122.20284, 37.89706], [-122.20247, 37.89609], [-122.20297, 37.89593]]]} | Restricted Access 2 | Orinda | 23201 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 0.656 | Orinda | ||
8388 | 8388 | 8387 | {"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 | Prairie Trails Park | 23977 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 0.658 | Prairie Trails Park | ||
11471 | 11471 | 11470 | {"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 | Yuba County Water Agency 34 | 27823 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.673 | Yuba County Water Agency 34 | ||
5590 | 5590 | 5589 | {"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.53692, 39.07823], [-121.53733, 39.07823]]]} | Open Access 1 | Johnson Park | 20479 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 0.766 | Johnson Park | ||
11460 | 11460 | 11459 | {"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 | Yuba County Water Agency 22 | 27811 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.771 | Yuba County Water Agency 22 | ||
11474 | 11474 | 11473 | {"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 | Yuba County Water Agency 37 | 27826 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.771 | Yuba County Water Agency 37 | ||
11462 | 11462 | 11461 | {"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 | Yuba County Water Agency 24 | 27813 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.816 | Yuba County Water Agency 24 | ||
11486 | 11486 | 11485 | {"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 | Yuba County Water Agency 48 | 27838 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.844 | Yuba County Water Agency 48 | ||
6588 | 6588 | 6587 | {"type": "Polygon", "coordinates": [[[-121.84919, 36.922], [-121.84892, 36.9225], [-121.84829, 36.92229], [-121.84857, 36.92178], [-121.84919, 36.922]]]} | Open Access 1 | Manresa State Beach - SCWD | http://www.parks.ca.gov/?page_id=545 | 21759 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 0.931 | Manresa SB - SCWD | |
11469 | 11469 | 11468 | {"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 | Yuba County Water Agency 32 | 27821 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.95 | Yuba County Water Agency 32 | ||
11485 | 11485 | 11484 | {"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 | Yuba County Water Agency 47 | 27837 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.973 | Yuba County Water Agency 47 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);