units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14 sorted by AGNCY_WEB descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, PARK_URL, YR_EST
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 152
- Ventura, City of 106
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Santa Barbara, County of 39
- Lake, County of 36
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Napa, City of 21
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Los Angeles County Flood Control District 13
- Santa Cruz, City of 12
- Santa Barbara Flood Control and Water Conserv. District 12
- Oroville, City of 12
- Los Angeles, County of 11
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- …
MNG_AG_TYP 15
- City Agency 663
- County Agency 214
- Open Space District 155
- Water District 78
- Flood District 32
- Recreation/Parks District 28
- County Agency - Other 6
- Irrigation District 4
- Sanitation District 3
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 859
- Unknown Access 204
- No Public Access 96
- Restricted Access 31
DES_TP 1
- Local Other or Unknown · 1,190 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7380 | 7380 | 7379 | {"type": "MultiPolygon", "coordinates": [[[[-118.02362, 34.03786], [-118.02295, 34.03812], [-118.02142, 34.03872], [-118.02185, 34.03849], [-118.02227, 34.03822], [-118.02267, 34.03795], [-118.02315, 34.03758], [-118.02362, 34.03786]]], [[[-118.02425, 34.03824], [-118.01421, 34.04219], [-118.01399, 34.04191], [-118.02388, 34.03802], [-118.02425, 34.03824]]], [[[-118.01723, 34.04177], [-118.01626, 34.04227], [-118.01533, 34.04283], [-118.01464, 34.04327], [-118.0137, 34.04395], [-118.01315, 34.04438], [-118.01261, 34.04483], [-118.01196, 34.04542], [-118.01122, 34.04617], [-118.01112, 34.0462], [-118.01097, 34.0462], [-118.01088, 34.04618], [-118.01064, 34.04602], [-118.01062, 34.04603], [-118.01055, 34.04599], [-118.01434, 34.04296], [-118.01442, 34.04302], [-118.01471, 34.04276], [-118.01723, 34.04177]]], [[[-118.00813, 34.04674], [-118.00572, 34.05101], [-118.00492, 34.05209], [-118.0047, 34.05243], [-118.0044, 34.0526], [-118.00459, 34.05168], [-118.00483, 34.05171], [-118.00497, 34.05149], [-118.00512, 34.0508], [-118.00515, 34.05058], [-118.00476, 34.0505], [-118.0049, 34.04995], [-118.0053, 34.05002], [-118.00522, 34.05038], [-118.00569, 34.05046], [-118.00621, 34.04858], [-118.00572, 34.04847], [-118.00597, 34.04755], [-118.00643, 34.04763], [-118.00676, 34.04715], [-118.00676, 34.0471], [-118.00614, 34.04697], [-118.00621, 34.04672], [-118.00813, 34.04674]]], [[[-118.01108, 34.04633], [-118.01063, 34.04683], [-118.01023, 34.0473], [-118.00996, 34.04766], [-118.00948, 34.04832], [-118.00896, 34.04913], [-118.00849, 34.04996], [-118.00809, 34.05077], [-118.00783, 34.05135], [-118.00756, 34.05209], [-118.00753, 34.05213], [-118.00733, 34.05273], [-118.00733, 34.05251], [-118.00732, 34.0525], [-118.00646, 34.054], [-118.0063, 34.05548], [-118.00608, 34.05535], [-118.00619, 34.05523], [-118.00629, 34.055], [-118.00632, 34.05481], [-118.0063, 34.05459], [-118.00622, 34.05439], [-118.00584, 34.0537], [-118.00577, 34.05354], [-118.00572, 34.05337], [-118.00571, 34.05316], [-118.00576, 34.05288], [-118.00613, 34.05187], [-118.00634, 34.05139], [-118.00709, 34.04998], [-118.00954, 34.04563], [-118.00964, 34.04567], [-118.00967, 34.04563], [-118.01026, 34.04597], [-118.0095, 34.04674], [-118.00951, 34.04683], [-118.01046, 34.04607], [-118.01087, 34.0463], [-118.01098, 34.04633], [-118.01108, 34.04633]]], [[[-118.00544, 34.05569], [-118.00531, 34.05604], [-118.00476, 34.05566], [-118.00479, 34.05563], [-118.00491, 34.05568], [-118.00516, 34.05571], [-118.00544, 34.05569]]]]} | Restricted Access 2 | 6780 | Duck Farm Property | 18295 | 2177 | Watershed Conservation Authority 860 | Special District 4 | Conservation District 31 | https://www.wca.ca.gov/ | Special District 4 | 2177 | Watershed Conservation Authority 838 | Special District 4 | Conservation District 30 | Los Angeles 6 | 59.863 | Duck Farm Property | 0 | Local Other or Unknown 14 | 4 | |
4756 | 4756 | 4755 | {"type": "Polygon", "coordinates": [[[-118.1743, 33.90349], [-118.17321, 33.9035], [-118.17318, 33.89977], [-118.17427, 33.89978], [-118.1743, 33.90349]]]} | No Public Access 3 | 46526 | Unnamed site - Paramount, City of | 29815 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | Los Angeles 6 | 10.254 | 0 | Local Other or Unknown 14 | 4 | ||
13218 | 13218 | 13217 | {"type": "Polygon", "coordinates": [[[-119.18391, 34.16307], [-119.18388, 34.16515], [-119.18338, 34.16516], [-119.18325, 34.16511], [-119.18315, 34.16513], [-119.18312, 34.16516], [-119.18312, 34.16559], [-119.18135, 34.16558], [-119.18132, 34.16526], [-119.18123, 34.16495], [-119.18107, 34.16461], [-119.1808, 34.1642], [-119.18072, 34.16402], [-119.18067, 34.16387], [-119.18063, 34.16355], [-119.18063, 34.16304], [-119.18389, 34.16305], [-119.18391, 34.16307]]]} | Open Access 1 | 35262 | Oxnard holding 1 | 23282 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 18.2 | Oxnard holding 1 | 0 | Local Other or Unknown 14 | 4 | |
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 0 | Local Other or Unknown 14 | 4 | ||
4821 | 4821 | 4820 | {"type": "Polygon", "coordinates": [[[-122.03058, 38.69336], [-122.03047, 38.69379], [-122.02642, 38.69321], [-122.02628, 38.69316], [-122.02622, 38.69315], [-122.02613, 38.69318], [-122.02608, 38.69321], [-122.02606, 38.69327], [-122.02575, 38.69323], [-122.02592, 38.69252], [-122.03058, 38.69336]]]} | Open Access 1 | 48895 | Unknown park - Yolo, County of | 33612 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 6.063 | 0 | Local Other or Unknown 14 | 4 | ||
3438 | 3438 | 3437 | {"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 | 35476 | Yuba County Water Agency 3 | 27818 | 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 | 1.144 | Yuba County Water Agency 3 | 0 | Local Other or Unknown 14 | 4 | |
3457 | 3457 | 3456 | {"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 | 35580 | Yuba County Water Agency 47 | 27837 | 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.973 | Yuba County Water Agency 47 | 0 | Local Other or Unknown 14 | 4 | |
3465 | 3465 | 3464 | {"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 | 35637 | Yuba County Water Agency 14 | 27802 | 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 | 1.259 | Yuba County Water Agency 14 | 0 | Local Other or Unknown 14 | 4 | |
3583 | 3583 | 3582 | {"type": "Polygon", "coordinates": [[[-121.28103, 39.50008], [-121.27996, 39.49892], [-121.27995, 39.49806], [-121.28102, 39.49808], [-121.28103, 39.50008]]]} | Unknown Access 4 | 36690 | Yuba County Water Agency 39 | 27828 | 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 | 3.618 | Yuba County Water Agency 39 | 0 | Local Other or Unknown 14 | 4 | |
3853 | 3853 | 3852 | {"type": "Polygon", "coordinates": [[[-121.27315, 39.48143], [-121.27314, 39.48349], [-121.26373, 39.48345], [-121.2637, 39.48142], [-121.27315, 39.48143]]]} | Unknown Access 4 | 35576 | Yuba County Water Agency 13 | 27801 | 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 | 45.633 | Yuba County Water Agency 13 | 0 | Local Other or Unknown 14 | 4 | |
3854 | 3854 | 3853 | {"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 | 35578 | Yuba County Water Agency 49 | 27839 | 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 | 1.0 | Yuba County Water Agency 49 | 0 | Local Other or Unknown 14 | 4 | |
3857 | 3857 | 3856 | {"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 | 35587 | Yuba County Water Agency 48 | 27838 | 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.844 | Yuba County Water Agency 48 | 0 | Local Other or Unknown 14 | 4 | |
3866 | 3866 | 3865 | {"type": "Polygon", "coordinates": [[[-121.28772, 39.49953], [-121.28629, 39.49959], [-121.28627, 39.49819], [-121.28769, 39.49815], [-121.28772, 39.49953]]]} | Unknown Access 4 | 35635 | Yuba County Water Agency 18 | 27806 | 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 | 4.676 | Yuba County Water Agency 18 | 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 | |
3868 | 3868 | 3867 | {"type": "Polygon", "coordinates": [[[-121.2878, 39.49075], [-121.28749, 39.49816], [-121.28627, 39.49819], [-121.27875, 39.49803], [-121.27866, 39.49811], [-121.2808, 39.49561], [-121.28207, 39.49531], [-121.28583, 39.49307], [-121.27774, 39.4835], [-121.28324, 39.48882], [-121.28684, 39.4861], [-121.28687, 39.49074], [-121.2878, 39.49075]]]} | Unknown Access 4 | 35638 | Yuba County Water Agency 38 | 27827 | 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 | 121.398 | Yuba County Water Agency 38 | 0 | Local Other or Unknown 14 | 4 | |
3869 | 3869 | 3868 | {"type": "Polygon", "coordinates": [[[-121.28986, 39.50148], [-121.28872, 39.50152], [-121.28863, 39.49951], [-121.28976, 39.49949], [-121.28986, 39.50148]]]} | Unknown Access 4 | 35639 | Yuba County Water Agency 40 | 27830 | 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 | 5.364 | Yuba County Water Agency 40 | 0 | Local Other or Unknown 14 | 4 | |
3870 | 3870 | 3869 | {"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 | 35641 | Yuba County Water Agency 37 | 27826 | 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.772 | Yuba County Water Agency 37 | 0 | Local Other or Unknown 14 | 4 | |
3871 | 3871 | 3870 | {"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 | 35642 | Yuba County Water Agency 36 | 27825 | 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 | 1.008 | Yuba County Water Agency 36 | 0 | Local Other or Unknown 14 | 4 | |
3872 | 3872 | 3871 | {"type": "Polygon", "coordinates": [[[-121.27589, 39.49889], [-121.27563, 39.49942], [-121.27481, 39.49898], [-121.27531, 39.49782], [-121.27554, 39.49761], [-121.27564, 39.49806], [-121.27575, 39.49869], [-121.27589, 39.49889]]]} | Unknown Access 4 | 35643 | Yuba County Water Agency 35 | 27824 | 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 | 2.388 | Yuba County Water Agency 35 | 0 | Local Other or Unknown 14 | 4 | |
3873 | 3873 | 3872 | {"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 | 35644 | Yuba County Water Agency 34 | 27823 | 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.673 | Yuba County Water Agency 34 | 0 | Local Other or Unknown 14 | 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]);