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 ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
11263 | 11263 | 11262 | {"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 | 21696 | Kartikeya Avenue Park | 20555 | 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.182 | Kartikeya Avenue 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 | |
3292 | 3292 | 3291 | {"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 | 48725 | Burney Civic Park | 33449 | 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 | 1.411 | Burney Civic 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 | |
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 | |
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 | |
11261 | 11261 | 11260 | {"type": "Polygon", "coordinates": [[[-121.55442, 39.07704], [-121.55299, 39.07701], [-121.55298, 39.07619], [-121.55424, 39.07619], [-121.55442, 39.07704]]]} | Open Access 1 | 21694 | Lindhurst Memorial Park | 21298 | 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.661 | Lindhurst Memorial Park | 0 | Local Park 2 | 4 | |
9840 | 9840 | 9839 | {"type": "MultiPolygon", "coordinates": [[[[-121.89924, 37.3355], [-121.89884, 37.33569], [-121.89868, 37.33547], [-121.89885, 37.33538], [-121.89861, 37.33506], [-121.89884, 37.33495], [-121.89924, 37.3355]]], [[[-121.90042, 37.33596], [-121.8999, 37.33606], [-121.89902, 37.33487], [-121.89968, 37.33457], [-121.89985, 37.33495], [-121.89995, 37.33526], [-121.90009, 37.33556], [-121.90042, 37.33596]]], [[[-121.89948, 37.33581], [-121.89908, 37.336], [-121.89906, 37.33598], [-121.89912, 37.33575], [-121.8991, 37.33573], [-121.89933, 37.33562], [-121.89948, 37.33581]]]]} | Open Access 1 | 16820 | Guadalupe River Park | 11940 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | http://www.sanjoseca.gov/index.aspx?nid=2833 | Santa Clara 19 | 2.779 | Guadalupe River Park | 0 | Local Park 2 | 4 |
11876 | 11876 | 11875 | {"type": "Polygon", "coordinates": [[[-120.11571, 39.1806], [-120.11568, 39.18066], [-120.11555, 39.18075], [-120.11512, 39.18076], [-120.11498, 39.18084], [-120.11442, 39.18138], [-120.11424, 39.18139], [-120.11419, 39.1813], [-120.11437, 39.18121], [-120.11442, 39.18108], [-120.11455, 39.18091], [-120.11474, 39.18052], [-120.11432, 39.18023], [-120.11388, 39.17996], [-120.11386, 39.1799], [-120.11374, 39.17984], [-120.11375, 39.17968], [-120.11395, 39.17941], [-120.11435, 39.17916], [-120.11455, 39.17905], [-120.11478, 39.17905], [-120.11469, 39.17913], [-120.11465, 39.1793], [-120.11467, 39.17939], [-120.1146, 39.17983], [-120.11474, 39.18003], [-120.11493, 39.18017], [-120.11517, 39.18021], [-120.11555, 39.18034], [-120.11569, 39.18033], [-120.11571, 39.1806]]]} | Open Access 1 | 24329 | Lake Forest Beach Park | 20886 | 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 | 3.69 | Lake Forest Beach Park | 0 | Local Park 2 | 4 | |
7403 | 7403 | 7402 | {"type": "Polygon", "coordinates": [[[-115.52333, 32.73492], [-115.52289, 32.73493], [-115.5229, 32.73582], [-115.52163, 32.73582], [-115.52163, 32.73574], [-115.52196, 32.73573], [-115.52195, 32.73434], [-115.52214, 32.73435], [-115.52233, 32.7344], [-115.52265, 32.73459], [-115.52333, 32.73458], [-115.52333, 32.73492]]]} | Open Access 1 | 48439 | Edward "Jiggs" Johnson Park | 33143 | 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 | http://www.heber.ca.gov/content/edward-jiggs-johnson-park | Imperial 20 | 3.734 | Edward "Jiggs" Johnson Park | 0 | Local Park 2 | 4 |
11187 | 11187 | 11186 | {"type": "Polygon", "coordinates": [[[-121.54665, 38.98364], [-121.54635, 38.98387], [-121.54615, 38.98424], [-121.54615, 38.98439], [-121.54578, 38.9844], [-121.54495, 38.98436], [-121.54495, 38.98314], [-121.54499, 38.98309], [-121.54563, 38.98298], [-121.54589, 38.9829], [-121.54594, 38.98291], [-121.54631, 38.98334], [-121.54665, 38.98364]]]} | Open Access 1 | 21680 | Bear River Park | 28703 | 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.469 | Bear River 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 | |
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 | |
14930 | 14930 | 14929 | {"type": "Polygon", "coordinates": [[[-120.14308, 39.16907], [-120.14254, 39.16948], [-120.14177, 39.17015], [-120.1403, 39.17133], [-120.14004, 39.17112], [-120.14008, 39.17111], [-120.14018, 39.17102], [-120.14023, 39.17089], [-120.14024, 39.17067], [-120.14032, 39.1705], [-120.14044, 39.17038], [-120.1406, 39.17007], [-120.14074, 39.16998], [-120.14119, 39.16984], [-120.14143, 39.16975], [-120.14154, 39.16966], [-120.14166, 39.16946], [-120.14176, 39.16907], [-120.14308, 39.16907]]]} | Open Access 1 | 45515 | Commons Beach | 28348 | 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 | http://www.tahoecitypud.com/parksrec/4e3_commons_beach.shtml | Placer 35 | 4.738 | Commons Beach | 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 |
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]);