units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where DES_TP = 2 and MNG_AG_TYP = 13 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY
MNG_AGENCY 13
- Olivehurst Public Utility District 15
- Heber Public Utility District 4
- Tahoe City Public Utilities District 4
- Burney Co Water District 2
- North Tahoe Public Utilities District 2
- Valley Center Water District 2
- Helix Water District 2
- Santa Clara Valley Water District 2
- Metropolitan Water District of Southern California 1
- Yuima Municipal Water District 1
- Ramona Municipal Water District 1
- Malaga County Water District 1
- Padre Dam Municipal Water District 1
ACCESS_TYP 2
MNG_AG_TYP 1
- Water District · 38 ✖
DES_TP 1
- Local Park · 38 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11258 | 11258 | 11257 | {"type": "Polygon", "coordinates": [[[-121.57315, 39.06192], [-121.57181, 39.06191], [-121.5718, 39.06053], [-121.57215, 39.06041], [-121.57248, 39.06027], [-121.57278, 39.06009], [-121.573, 39.05994], [-121.57313, 39.06003], [-121.57315, 39.06192]]]} | Open Access 1 | 21691 | Wheeler Ranch Lot I Park | 27454 | 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 | 5.275 | Wheeler Ranch Lot I Park | 0 | Local Park 2 | 4 | |
11505 | 11505 | 11504 | {"type": "Polygon", "coordinates": [[[-121.6664, 40.87718], [-121.6664, 40.87718], [-121.66329, 40.87724], [-121.66432, 40.87637], [-121.66433, 40.87624], [-121.66638, 40.87621], [-121.6664, 40.87718]]]} | Open Access 1 | 48724 | Washburn Bue Park | 33448 | 2434 | Burney Co Water District 614 | Special District 4 | Water District 13 | https://www.burneywater.org/ | Special District 4 | 2434 | Burney Co Water District 603 | Special District 4 | Water District 13 | Shasta 27 | 5.679 | Washburn Bue Park | 0 | Local Park 2 | 4 | |
3353 | 3353 | 3352 | {"type": "Polygon", "coordinates": [[[-120.03475, 39.23713], [-120.03474, 39.23761], [-120.03371, 39.23746], [-120.0337, 39.23752], [-120.03184, 39.23717], [-120.03128, 39.23711], [-120.03013, 39.23705], [-120.02969, 39.23699], [-120.0297, 39.23614], [-120.03008, 39.23624], [-120.03036, 39.23635], [-120.03066, 39.23644], [-120.03163, 39.23669], [-120.0319, 39.23672], [-120.03226, 39.23667], [-120.03256, 39.23669], [-120.0329, 39.23677], [-120.03475, 39.23713]]]} | Open Access 1 | 24255 | Secline Beach | 25276 | 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 | Placer 35 | 7.066 | Secline Beach | 0 | Local Park 2 | 4 | |
16299 | 16299 | 16298 | {"type": "MultiPolygon", "coordinates": [[[[-117.00698, 32.8493], [-117.00696, 32.8538], [-117.00784, 32.85577], [-117.00829, 32.85706], [-117.00841, 32.8577], [-117.00898, 32.86045], [-117.00905, 32.86085], [-117.00751, 32.86158], [-117.00743, 32.86121], [-117.00733, 32.8609], [-117.00661, 32.85925], [-117.00645, 32.8588], [-117.00637, 32.85845], [-117.00477, 32.84968], [-117.00476, 32.84959], [-117.00497, 32.84953], [-117.00472, 32.84888], [-117.00453, 32.84889], [-117.00424, 32.84725], [-117.00411, 32.84585], [-117.00392, 32.8452], [-117.00418, 32.84515], [-117.00444, 32.84493], [-117.00432, 32.84443], [-117.00441, 32.84444], [-117.00473, 32.84442], [-117.0048, 32.84446], [-117.00484, 32.84453], [-117.00501, 32.84451], [-117.005, 32.84441], [-117.00506, 32.84436], [-117.00548, 32.84432], [-117.00554, 32.84434], [-117.00558, 32.8444], [-117.00574, 32.84438], [-117.00573, 32.84428], [-117.00587, 32.84425], [-117.00601, 32.84469], [-117.00645, 32.84462], [-117.00691, 32.84606], [-117.00698, 32.8493]]], [[[-117.00923, 32.86438], [-117.00906, 32.86491], [-117.00844, 32.86624], [-117.00817, 32.86642], [-117.0076, 32.86635], [-117.00738, 32.86624], [-117.00703, 32.86596], [-117.00697, 32.86578], [-117.00795, 32.86413], [-117.00825, 32.8639], [-117.00917, 32.8642], [-117.00923, 32.86438]]]]} | Open Access 1 | 193 | Santee Lakes Regional Park | 25150 | 2106 | Padre Dam Municipal Water District 1170 | Special District 4 | Water District 13 | http://www.padredam.org/ | Special District 4 | 2106 | Padre Dam Municipal Water District 1109 | Special District 4 | Water District 13 | http://www.santeelakes.com/ | San Diego 4 | 99.056 | Santee Lakes RP | 0 | Local Park 2 | 4 |
11243 | 11243 | 11242 | {"type": "Polygon", "coordinates": [[[-121.55374, 39.01738], [-121.55332, 39.01752], [-121.55262, 39.01726], [-121.55207, 39.01735], [-121.55172, 39.01736], [-121.55175, 39.01683], [-121.55177, 39.01677], [-121.55181, 39.01675], [-121.55212, 39.01674], [-121.55251, 39.01663], [-121.5527, 39.01678], [-121.5528, 39.01685], [-121.55292, 39.01691], [-121.55321, 39.01699], [-121.55331, 39.017], [-121.5535, 39.01697], [-121.55354, 39.01698], [-121.55358, 39.01703], [-121.55374, 39.01738]]]} | Open Access 1 | 21687 | Rolling Hills Park | 24581 | 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 | 2.47 | Rolling Hills Park | 0 | Local Park 2 | 4 | |
3137 | 3137 | 3136 | {"type": "Polygon", "coordinates": [[[-121.54977, 38.99138], [-121.54945, 38.99229], [-121.54933, 38.99267], [-121.54925, 38.99298], [-121.54919, 38.99307], [-121.54847, 38.99306], [-121.5485, 38.99143], [-121.54881, 38.99128], [-121.54944, 38.99082], [-121.54963, 38.99098], [-121.54972, 38.9912], [-121.54977, 38.99138]]]} | Open Access 1 | 21681 | Riverside Meadows Park | 24451 | 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 | 4.783 | Riverside Meadows Park | 0 | Local Park 2 | 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 | |
2797 | 2797 | 2796 | {"type": "Polygon", "coordinates": [[[-121.55314, 39.00936], [-121.55263, 39.01017], [-121.55221, 39.01115], [-121.5521, 39.01187], [-121.55057, 39.01169], [-121.55045, 39.01165], [-121.55045, 39.01154], [-121.55051, 39.01116], [-121.55068, 39.01048], [-121.55082, 39.01006], [-121.55095, 39.00982], [-121.55162, 39.0088], [-121.55167, 39.00876], [-121.55171, 39.00877], [-121.55314, 39.00936]]]} | Open Access 1 | 21685 | Rio Del Oro Park Site | 24378 | 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 | 11.671 | Rio Del Oro Park Site | 0 | Local Park 2 | 4 | |
7595 | 7595 | 7594 | {"type": "Polygon", "coordinates": [[[-116.86604, 33.04765], [-116.86554, 33.04884], [-116.86364, 33.05037], [-116.86232, 33.05145], [-116.86204, 33.05224], [-116.86159, 33.05221], [-116.86084, 33.05337], [-116.86084, 33.05339], [-116.86097, 33.0534], [-116.8608, 33.05395], [-116.86146, 33.05401], [-116.86117, 33.05486], [-116.86048, 33.05672], [-116.86059, 33.05849], [-116.85365, 33.05849], [-116.85484, 33.05303], [-116.85811, 33.05115], [-116.85865, 33.05083], [-116.85875, 33.05087], [-116.8589, 33.05087], [-116.85908, 33.05081], [-116.86068, 33.04987], [-116.86107, 33.04962], [-116.86262, 33.04877], [-116.86263, 33.04875], [-116.86255, 33.04865], [-116.86554, 33.04701], [-116.86604, 33.04765]]]} | Open Access 1 | 7305 | Ramona Community Park | 24111 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 148.594 | Ramona Community 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 | |
11841 | 11841 | 11840 | {"type": "Polygon", "coordinates": [[[-120.12168, 39.18367], [-120.12168, 39.18469], [-120.12128, 39.18475], [-120.11964, 39.1841], [-120.1189, 39.18402], [-120.1189, 39.18368], [-120.12168, 39.18367]]]} | Open Access 1 | 24253 | Pomin Park | 23878 | 2260 | Tahoe City Public Utilities District 993 | Special District 4 | Water District 13 | http://www.tahoecitypud.com/parksrec.shtml | Special District 4 | 2260 | Tahoe City Public Utilities District 658 | Special District 4 | Water District 13 | Placer 35 | 4.592 | Pomin Park | 0 | Local Park 2 | 4 | |
11247 | 11247 | 11246 | {"type": "Polygon", "coordinates": [[[-121.54721, 38.97635], [-121.54716, 38.9765], [-121.54705, 38.97668], [-121.54688, 38.97683], [-121.54666, 38.97693], [-121.54647, 38.97698], [-121.54626, 38.977], [-121.54611, 38.977], [-121.54583, 38.97695], [-121.54563, 38.97695], [-121.54565, 38.97633], [-121.54609, 38.97634], [-121.5462, 38.97636], [-121.54628, 38.97632], [-121.54632, 38.97625], [-121.54721, 38.97635]]]} | Open Access 1 | 21678 | Plumas Ranch Park | 23815 | 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 | 2.154 | Plumas Ranch Park | 0 | Local Park 2 | 4 | |
11240 | 11240 | 11239 | {"type": "Polygon", "coordinates": [[[-121.55145, 39.00046], [-121.55144, 39.00053], [-121.55108, 39.00113], [-121.55084, 39.00147], [-121.54918, 39.00085], [-121.54953, 39.00053], [-121.54965, 39.00038], [-121.54992, 38.99991], [-121.54995, 38.99989], [-121.55003, 38.99989], [-121.55139, 39.00042], [-121.55145, 39.00046]]]} | Open Access 1 | 21682 | Plumas Lake Park | 23814 | 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 | 4.689 | Plumas Lake Park | 0 | Local Park 2 | 4 | |
6899 | 6899 | 6898 | {"type": "Polygon", "coordinates": [[[-116.93928, 34.44363], [-116.93788, 34.44365], [-116.93784, 34.44316], [-116.9372, 34.44312], [-116.93715, 34.44215], [-116.93925, 34.4421], [-116.93928, 34.44363]]]} | Open Access 1 | 5757 | Pioneer Park | 23739 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 2320 | Yuima Municipal Water District 675 | Special District 4 | Water District 13 | San Bernardino 22 | 7.116 | Pioneer Park | 0 | Local Park 2 | 4 | |
11257 | 11257 | 11256 | {"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 | 21686 | Orchard Glen Park | 23188 | 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.263 | Orchard Glen Park | 0 | Local Park 2 | 4 | |
11259 | 11259 | 11258 | {"type": "Polygon", "coordinates": [[[-121.55399, 39.06615], [-121.55401, 39.06659], [-121.55396, 39.06684], [-121.5538, 39.06714], [-121.55374, 39.06733], [-121.55317, 39.06735], [-121.55295, 39.06618], [-121.55399, 39.06615]]]} | Open Access 1 | 21692 | Olivehurst Park | 23131 | 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 | 2.434 | Olivehurst Park | 0 | Local Park 2 | 4 | |
16422 | 16422 | 16421 | {"type": "Polygon", "coordinates": [[[-120.05729, 39.24573], [-120.05707, 39.24632], [-120.05712, 39.25055], [-120.05712, 39.25188], [-120.04873, 39.25194], [-120.04873, 39.25023], [-120.04876, 39.24765], [-120.05077, 39.24765], [-120.05078, 39.24697], [-120.05075, 39.24696], [-120.05077, 39.24672], [-120.05076, 39.24636], [-120.05186, 39.24607], [-120.05181, 39.2468], [-120.05157, 39.24719], [-120.05146, 39.24715], [-120.05127, 39.24726], [-120.05098, 39.24738], [-120.05134, 39.24797], [-120.05232, 39.24762], [-120.05229, 39.2473], [-120.05203, 39.24713], [-120.05181, 39.24726], [-120.0517, 39.24723], [-120.05195, 39.24683], [-120.05201, 39.24603], [-120.05249, 39.24591], [-120.0525, 39.24586], [-120.05324, 39.24586], [-120.05324, 39.24642], [-120.05337, 39.24643], [-120.05338, 39.24586], [-120.05464, 39.24586], [-120.05729, 39.24573]]]} | Open Access 1 | 44982 | North Tahoe Regional Park | 22861 | 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 | https://northtahoeparks.com/north-tahoe-regional-park | Placer 35 | 108.351 | North Tahoe RP | 0 | Local Park 2 | 4 |
3561 | 3561 | 3560 | {"type": "Polygon", "coordinates": [[[-115.5415, 32.73581], [-115.53914, 32.73583], [-115.53914, 32.73493], [-115.53916, 32.7349], [-115.5392, 32.73489], [-115.54145, 32.73486], [-115.54148, 32.73488], [-115.54149, 32.73491], [-115.5415, 32.73581]]]} | Open Access 1 | 28351 | Margarito "Tito" Huerta Jr. Park | 21805 | 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 | 5.726 | Margarito "Tito" Huerta Jr. Park | 0 | Local Park 2 | 4 | |
14980 | 14980 | 14979 | {"type": "Polygon", "coordinates": [[[-119.73138, 36.6839], [-119.73136, 36.68516], [-119.72976, 36.68517], [-119.72976, 36.68465], [-119.72974, 36.68454], [-119.72968, 36.68432], [-119.72958, 36.68412], [-119.72985, 36.68402], [-119.73002, 36.68388], [-119.7302, 36.68383], [-119.73064, 36.68393], [-119.73138, 36.6839]]]} | Open Access 1 | 45604 | Malaga Community Park | 28430 | 2350 | Malaga County Water District 1130 | Special District 4 | Water District 13 | http://www.malagacwd.org/ | Special District 4 | 2350 | Malaga County Water District 1085 | Special District 4 | Water District 13 | Fresno 9 | 5.087 | Malaga Community Park | 0 | Local Park 2 | 4 | |
1711 | 1711 | 1710 | {"type": "MultiPolygon", "coordinates": [[[[-117.75671, 34.13628], [-117.75616, 34.13503], [-117.75433, 34.13264], [-117.75496, 34.13229], [-117.75515, 34.13228], [-117.75538, 34.13231], [-117.75558, 34.13237], [-117.75577, 34.13247], [-117.7559, 34.13258], [-117.756, 34.1327], [-117.75602, 34.1327], [-117.75598, 34.13277], [-117.75599, 34.13287], [-117.75608, 34.13297], [-117.75617, 34.13316], [-117.75628, 34.13334], [-117.75649, 34.13358], [-117.75668, 34.13374], [-117.75692, 34.13388], [-117.75719, 34.13399], [-117.75749, 34.13408], [-117.75752, 34.1341], [-117.75671, 34.13628]]], [[[-117.75871, 34.13267], [-117.75854, 34.13285], [-117.75791, 34.13333], [-117.75789, 34.13339], [-117.7577, 34.13366], [-117.75762, 34.13385], [-117.75758, 34.13387], [-117.75731, 34.1338], [-117.75708, 34.1337], [-117.75687, 34.13358], [-117.75668, 34.13343], [-117.75651, 34.13324], [-117.75639, 34.13303], [-117.75634, 34.13292], [-117.75637, 34.13283], [-117.75637, 34.13278], [-117.75632, 34.1327], [-117.75737, 34.13269], [-117.75791, 34.13213], [-117.75871, 34.13267]]]]} | Open Access 1 | 12847 | Live Oak Park | 21373 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 2078 | Metropolitan Water District of Southern California 407 | Special District 4 | Water District 13 | Los Angeles 6 | 16.964 | Live Oak Park | 0 | Local Park 2 | 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]);