units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
238 rows where MNG_AG_TYP = 13 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, PARK_URL, COUNTY, YR_EST, GAP_STS
MNG_AGENCY >30
- Yuba County Water Agency 50
- Las Virgenes Municipal Water District 28
- Olivehurst Public Utility District 23
- East Bay Municipal Utility District 17
- San Lorenzo Valley Water District 12
- Marin Municipal Water District 9
- Metropolitan Water District of Southern California 8
- Santa Clara Valley Water District 8
- Tahoe City Public Utilities District 6
- Heber Public Utility District 4
- Valley Center Water District 4
- Helix Water District 4
- Olivenhain Municipal Water District 4
- Ramona Municipal Water District 4
- Soquel Creek Water District 3
- Scotts Valley Water District 3
- North Tahoe Public Utilities District 3
- Contra Costa Water District 3
- Monterey County Water Resources Agency 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
- San Gabriel River Water Committee 1
- Trabuco Canyon Water District 1
- Montecito Water District 1
- North Coast Water District 1
- …
DES_TP >30
- Local Other or Unknown 78
- Local Recreation Area 69
- Local Park 38
- Local Resource Management Area 7
- Local Conservation Area 4
- None 1
- None 1
- None 1
- National Monument or Landmark 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 113
- No Public Access 56
- Unknown Access 55
- Restricted Access 14
AGNCY_LEV 3 ✖
- Special District 233
- County 3
- State 2
MNG_AG_TYP 1
- Water District · 238 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9013 | 9013 | 9012 | {"type": "Polygon", "coordinates": [[[-118.65507, 34.12838], [-118.65499, 34.12848], [-118.65493, 34.12846], [-118.65501, 34.12835], [-118.65507, 34.12838]]]} | No Public Access 3 | 12414 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.022 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9463 | 9463 | 9462 | {"type": "Polygon", "coordinates": [[[-118.7507, 34.16758], [-118.75065, 34.16768], [-118.75057, 34.16764], [-118.75062, 34.16755], [-118.7507, 34.16758]]]} | No Public Access 3 | 12424 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.027 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
1629 | 1629 | 1628 | {"type": "Polygon", "coordinates": [[[-118.63073, 34.13978], [-118.63062, 34.1398], [-118.63058, 34.13967], [-118.63066, 34.13966], [-118.63073, 34.13978]]]} | No Public Access 3 | 12421 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.034 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9404 | 9404 | 9403 | {"type": "Polygon", "coordinates": [[[-118.67423, 34.13343], [-118.67408, 34.13345], [-118.67407, 34.13332], [-118.67422, 34.13331], [-118.67423, 34.13343]]]} | No Public Access 3 | 12423 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.05 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
2066 | 2066 | 2065 | {"type": "Polygon", "coordinates": [[[-118.67437, 34.13917], [-118.67424, 34.13936], [-118.67408, 34.13928], [-118.67422, 34.13909], [-118.67437, 34.13917]]]} | No Public Access 3 | 12422 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.103 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9467 | 9467 | 9466 | {"type": "Polygon", "coordinates": [[[-118.79539, 34.10451], [-118.79505, 34.10457], [-118.79501, 34.10437], [-118.79516, 34.10434], [-118.79538, 34.10447], [-118.79539, 34.10451]]]} | No Public Access 3 | 12425 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.136 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
8361 | 8361 | 8360 | {"type": "MultiPolygon", "coordinates": [[[[-118.66634, 34.17078], [-118.66625, 34.17093], [-118.66609, 34.17094], [-118.66606, 34.17068], [-118.66634, 34.17078]]], [[[-118.741, 34.15444], [-118.74093, 34.15454], [-118.74084, 34.15445], [-118.74084, 34.15444], [-118.741, 34.15444]]]]} | No Public Access 3 | 12409 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.141 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
759 | 759 | 758 | {"type": "Polygon", "coordinates": [[[-122.5442, 37.91301], [-122.54403, 37.91312], [-122.54383, 37.91293], [-122.54399, 37.91283], [-122.54405, 37.91288], [-122.54417, 37.91281], [-122.5442, 37.91301]]]} | Open Access 1 | 4954 | Watershed Lands | 27306 | 2071 | Marin Municipal Water District 254 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | Marin 23 | 0.152 | Watershed Lands | None 71 | |||
3178 | 3178 | 3177 | {"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 | 1913 | Willowbrook Park - Soquel Creek Water District | 27591 | 2157 | Soquel Creek Water District 592 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.197 | Willowbrook Park - Soquel Creek Water District | 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 | |
5505 | 5505 | 5504 | {"type": "MultiPolygon", "coordinates": [[[[-118.66773, 34.17325], [-118.66736, 34.17323], [-118.66731, 34.17311], [-118.66769, 34.17301], [-118.66773, 34.17316], [-118.66773, 34.17325]]], [[[-118.70599, 34.16395], [-118.70581, 34.16401], [-118.70578, 34.16393], [-118.70589, 34.16376], [-118.70595, 34.16381], [-118.70594, 34.16384], [-118.70599, 34.16395]]]]} | No Public Access 3 | 12408 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.26 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 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 | |
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 | ||
6682 | 6682 | 6681 | {"type": "Polygon", "coordinates": [[[-122.54068, 37.913], [-122.5406, 37.91314], [-122.54045, 37.91323], [-122.54028, 37.91318], [-122.54014, 37.91304], [-122.54018, 37.91291], [-122.54046, 37.91284], [-122.54066, 37.91288], [-122.54068, 37.913]]]} | Open Access 1 | 4958 | Watershed Lands | 27306 | 2071 | Marin Municipal Water District 254 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | Marin 23 | 0.366 | Watershed Lands | None 541 | |||
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 | |
14671 | 14671 | 14670 | {"type": "Polygon", "coordinates": [[[-120.048, 39.2394], [-120.0475, 39.23937], [-120.04744, 39.2393], [-120.04741, 39.23912], [-120.04743, 39.23907], [-120.04793, 39.23907], [-120.04799, 39.23915], [-120.048, 39.2394]]]} | Open Access 1 | 45001 | Tahoe Vista Recreation Area | 30867 | 2246 | North Tahoe Public Utilities District 625 | Special District 4 | Water District 13 | http://www.ntpud.org/ | Special District 4 | 2246 | North Tahoe Public Utilities District 614 | Special District 4 | Water District 13 | http://northtahoeparks.com/beaches | Placer 35 | 0.408 | Tahoe Vista Rec. Area | 0 | Local Recreation Area 3 | 4 |
12960 | 12960 | 12959 | {"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 | 30424 | Heber Children Park | 19788 | 2278 | Heber Public Utility District 661 | Special District 4 | Water District 13 | http://heber.ca.gov/index.php | Special District 4 | 2278 | Heber Public Utility District 648 | Special District 4 | Water District 13 | Imperial 20 | 0.422 | Heber Children Park | 0 | Local Park 2 | 4 | |
9012 | 9012 | 9011 | {"type": "Polygon", "coordinates": [[[-118.78844, 34.0604], [-118.78837, 34.06053], [-118.78817, 34.06057], [-118.78799, 34.06049], [-118.78789, 34.06023], [-118.78797, 34.06012], [-118.78815, 34.06007], [-118.78835, 34.06025], [-118.78844, 34.0604]]]} | No Public Access 3 | 12413 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.461 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9469 | 9469 | 9468 | {"type": "Polygon", "coordinates": [[[-118.66968, 34.13331], [-118.66965, 34.13376], [-118.66961, 34.13403], [-118.6695, 34.13402], [-118.66949, 34.13387], [-118.66933, 34.13366], [-118.6693, 34.13358], [-118.66931, 34.1335], [-118.66934, 34.13343], [-118.6694, 34.13337], [-118.6696, 34.13328], [-118.66963, 34.13328], [-118.66968, 34.13331]]]} | No Public Access 3 | 12426 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.465 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 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]);