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)
MNG_AGENCY >30
- Yuba County Water Agency 40
- Olivehurst Public Utility District 19
- East Bay Municipal Utility District 10
- Santa Clara Valley Water District 8
- Metropolitan Water District of Southern California 7
- Marin Municipal Water District 6
- Tahoe City Public Utilities District 6
- Valley Center Water District 4
- Helix Water District 4
- Las Virgenes Municipal Water District 3
- San Lorenzo Valley Water District 3
- Heber Public Utility 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
- North Tahoe Public Utilities 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
- Soquel Creek Water District 1
- Scotts Valley Water District 1
- Borrego Water District 1
- …
ACCESS_TYP 4
- Open Access 85
- Unknown Access 43
- No Public Access 27
- Restricted Access 12
MNG_AG_TYP 1
- Water District · 167 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11487 | 11487 | 11486 | {"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 | Yuba County Water Agency 49 | 27839 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.0 | Yuba County Water Agency 49 | ||
11473 | 11473 | 11472 | {"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 | Yuba County Water Agency 36 | 27825 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.008 | Yuba County Water Agency 36 | ||
8763 | 8763 | 8762 | {"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 | River Park | 24420 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 1.022 | River Park | ||
11468 | 11468 | 11467 | {"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 | Yuba County Water Agency 31 | 27820 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.044 | Yuba County Water Agency 31 | ||
11456 | 11456 | 11455 | {"type": "Polygon", "coordinates": [[[-121.29311, 39.25371], [-121.29294, 39.2539], [-121.29268, 39.25388], [-121.29234, 39.2538], [-121.292, 39.25364], [-121.29171, 39.25346], [-121.29143, 39.25326], [-121.29142, 39.25285], [-121.29189, 39.25325], [-121.29211, 39.25341], [-121.29257, 39.25363], [-121.29289, 39.2537], [-121.29311, 39.25371]]]} | Unknown Access 4 | Yuba County Water Agency 19 | 27807 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.079 | Yuba County Water Agency 19 | ||
11470 | 11470 | 11469 | {"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 | Yuba County Water Agency 33 | 27822 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.114 | Yuba County Water Agency 33 | ||
11489 | 11489 | 11488 | {"type": "Polygon", "coordinates": [[[-121.27797, 39.49638], [-121.27764, 39.49672], [-121.27672, 39.49629], [-121.27702, 39.49592], [-121.27797, 39.49638]]]} | Unknown Access 4 | Yuba County Water Agency 6 | 27841 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.136 | Yuba County Water Agency 6 | ||
11466 | 11466 | 11465 | {"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 | Yuba County Water Agency 3 | 27818 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.143 | Yuba County Water Agency 3 | ||
11465 | 11465 | 11464 | {"type": "Polygon", "coordinates": [[[-121.27825, 39.4961], [-121.27797, 39.49638], [-121.27702, 39.49592], [-121.27717, 39.49573], [-121.27743, 39.49552], [-121.27825, 39.4961]]]} | Unknown Access 4 | Yuba County Water Agency 29 | 27817 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.15 | Yuba County Water Agency 29 | ||
5657 | 5657 | 5656 | {"type": "Polygon", "coordinates": [[[-121.55363, 39.08252], [-121.55312, 39.08256], [-121.55308, 39.08148], [-121.55359, 39.08164], [-121.55363, 39.08252]]]} | Open Access 1 | Kartikeya Avenue Park | 20555 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 1.181 | Kartikeya Avenue Park | ||
9829 | 9829 | 9828 | {"type": "Polygon", "coordinates": [[[-121.06719, 39.44088], [-121.067, 39.44107], [-121.06698, 39.44105], [-121.0669, 39.44097], [-121.06677, 39.44072], [-121.06674, 39.44058], [-121.06685, 39.44056], [-121.06683, 39.44046], [-121.06679, 39.44041], [-121.06673, 39.44036], [-121.06641, 39.44028], [-121.06619, 39.4402], [-121.06602, 39.4401], [-121.06586, 39.43999], [-121.06562, 39.43972], [-121.06549, 39.43952], [-121.06517, 39.43938], [-121.06562, 39.43937], [-121.06574, 39.43953], [-121.0658, 39.43964], [-121.06602, 39.43988], [-121.06615, 39.43997], [-121.0663, 39.44006], [-121.06684, 39.44022], [-121.06697, 39.44032], [-121.06703, 39.44041], [-121.06707, 39.44066], [-121.06712, 39.44077], [-121.06719, 39.44088]]]} | Unknown Access 4 | Yuba County Water Agency 27 | 27816 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.232 | Yuba County Water Agency 27 | ||
11428 | 11428 | 11427 | {"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 | Yuba County Water Agency 14 | 27802 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.259 | Yuba County Water Agency 14 | ||
7737 | 7737 | 7736 | {"type": "Polygon", "coordinates": [[[-121.54882, 39.01498], [-121.54877, 39.01546], [-121.54875, 39.01551], [-121.54872, 39.01555], [-121.54865, 39.01556], [-121.54793, 39.01552], [-121.54787, 39.0155], [-121.54784, 39.01547], [-121.54789, 39.01494], [-121.54882, 39.01498]]]} | Open Access 1 | Orchard Glen Park | 23188 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 1.263 | Orchard Glen Park | ||
1090 | 1090 | 1089 | {"type": "Polygon", "coordinates": [[[-118.11443, 34.10438], [-118.1143, 34.10445], [-118.11408, 34.10405], [-118.11378, 34.10418], [-118.11341, 34.10321], [-118.1138, 34.10302], [-118.11397, 34.10334], [-118.11419, 34.10387], [-118.11414, 34.1039], [-118.11421, 34.10408], [-118.11434, 34.10429], [-118.11439, 34.10429], [-118.11443, 34.10438]]]} | Open Access 1 | Alhambra Wash | 15358 | 2136 | San Gabriel County Water District 836 | Special District 4 | Water District 13 | http://www.sgcwd.com/ | Special District 4 | 1.372 | Alhambra Wash | ||
13588 | 13588 | 13587 | {"type": "Polygon", "coordinates": [[[-121.6748, 40.88058], [-121.67428, 40.88107], [-121.67355, 40.88056], [-121.67413, 40.8801], [-121.6748, 40.88058]]]} | Open Access 1 | Burney Civic Park | 33449 | 2434 | Burney Co Water District 603 | Special District 4 | Water District 13 | https://www.burneywater.org/ | Special District 4 | 1.411 | Burney Civic Park | ||
11467 | 11467 | 11466 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.4958], [-121.27825, 39.4961], [-121.27743, 39.49552], [-121.2781, 39.49497], [-121.27831, 39.49492], [-121.27841, 39.49547], [-121.27854, 39.4958]]]} | Unknown Access 4 | Yuba County Water Agency 30 | 27819 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.61 | Yuba County Water Agency 30 | ||
11492 | 11492 | 11491 | {"type": "Polygon", "coordinates": [[[-121.2718, 39.47467], [-121.27178, 39.47519], [-121.27126, 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 | Yuba County Water Agency 9 | 27844 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.825 | Yuba County Water Agency 9 | ||
7158 | 7158 | 7157 | {"type": "Polygon", "coordinates": [[[-122.71557, 38.43664], [-122.7155, 38.43665], [-122.7153, 38.43673], [-122.71434, 38.43728], [-122.71363, 38.43745], [-122.71335, 38.43707], [-122.71387, 38.43698], [-122.71424, 38.43687], [-122.71426, 38.43689], [-122.71442, 38.43684], [-122.71474, 38.4367], [-122.71518, 38.43644], [-122.7155, 38.43632], [-122.71557, 38.43664]]]} | Restricted Access 2 | Prince Memorial Greenway | 24006 | 2156 | Sonoma County Water Agency 88 | Special District 4 | Water District 13 | http://www.scwa.ca.gov/ | Special District 4 | 1.868 | Prince Memorial Greenway | ||
5388 | 5388 | 5387 | {"type": "Polygon", "coordinates": [[[-121.53769, 38.97852], [-121.5373, 38.97871], [-121.53713, 38.97885], [-121.53694, 38.97905], [-121.5368, 38.97941], [-121.53681, 38.97995], [-121.53646, 38.97822], [-121.53744, 38.97812], [-121.53759, 38.97831], [-121.53769, 38.97852]]]} | Open Access 1 | Lot D Park River Oaks South | 21543 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2.017 | Lot D Park River Oaks South | ||
3587 | 3587 | 3586 | {"type": "Polygon", "coordinates": [[[-121.52367, 39.13749], [-121.52367, 39.13795], [-121.52365, 39.13801], [-121.52359, 39.13809], [-121.52354, 39.13812], [-121.52265, 39.13843], [-121.52249, 39.13814], [-121.5225, 39.13755], [-121.52367, 39.13749]]]} | Open Access 1 | Detention Pond | 18119 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2.04 | Detention Pond |
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]);