units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
261 rows where ACCESS_TYP = 3 and AGNCY_LEV = 4 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, MNG_AG_LEV, PARK_URL, COUNTY, GAP_STS
MNG_AGENCY >30
- East Bay Regional Park District 41
- Las Virgenes Municipal Water District 28
- Natomas Basin Conservancy 22
- Midpeninsula Regional Open Space District 18
- Santa Clara Valley Open Space Authority 17
- Fresno Metropolitan Flood Control District 16
- Los Angeles County Flood Control District 13
- Kinneloa Irrigation District 13
- Littlerock Creek Irrigation District 13
- Sonoma County Agricultural Preservation and Open Space District 11
- Riverside County Habitat Conservation Agency 8
- Mountains Recreation and Conservation Authority 7
- Napa County Regional Park and Open Space District 7
- Metropolitan Water District of Southern California 6
- East Bay Municipal Utility District 6
- Santa Barbara Flood Control and Water Conserv. District 3
- San Bernardino County Flood Control District 3
- Monterey Peninsula Regional Park District 2
- San Marcos, City of 2
- Conejo Open Space Conservation Agency 2
- Valley Center Water District 2
- Olivenhain Municipal Water District 2
- San Diego County Water Authority 2
- La Verne, City of 1
- La Canada Irrigation District 1
- Livermore Area Recreation and Park District 1
- Sanitation Districts of Los Angeles County 1
- Montecito Water District 1
- North Coast Water District 1
- Yuima Municipal Water District 1
- …
DES_TP >30
MNG_AG_TYP 7
ACCESS_TYP 1
- No Public Access · 261 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7804 | 7804 | 7803 | {"type": "Polygon", "coordinates": [[[-122.42274, 38.39449], [-122.41856, 38.39451], [-122.4184, 38.39435], [-122.41835, 38.39431], [-122.41799, 38.39415], [-122.4177, 38.39404], [-122.41652, 38.39341], [-122.41618, 38.39306], [-122.41604, 38.39295], [-122.41586, 38.39286], [-122.4159, 38.39281], [-122.41587, 38.39273], [-122.41593, 38.39256], [-122.41485, 38.39153], [-122.4144, 38.39119], [-122.41397, 38.39091], [-122.41853, 38.39089], [-122.41855, 38.39111], [-122.4213, 38.39198], [-122.42177, 38.39216], [-122.42274, 38.39449]]]} | No Public Access 3 | 47687 | Amy's Grove | 31415 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 46.448 | Amy's Grove | 0 | Local Park 2 | 4 | |
12717 | 12717 | 12716 | {"type": "MultiPolygon", "coordinates": [[[[-121.6007, 38.7384], [-121.59981, 38.74049], [-121.59115, 38.74058], [-121.59023, 38.74346], [-121.58935, 38.74635], [-121.58496, 38.74644], [-121.58503, 38.74523], [-121.58488, 38.74496], [-121.58336, 38.74324], [-121.58352, 38.74306], [-121.58355, 38.74272], [-121.58366, 38.74229], [-121.5843, 38.74056], [-121.58581, 38.73629], [-121.59247, 38.73626], [-121.59185, 38.73841], [-121.59185, 38.73842], [-121.6007, 38.7384]]], [[[-121.58903, 38.7474], [-121.58849, 38.74926], [-121.58654, 38.7493], [-121.5865, 38.74746], [-121.58903, 38.7474]]]]} | No Public Access 3 | 29732 | Atkinson | 15671 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 207.413 | Atkinson | None 1113 | |||
6036 | 6036 | 6035 | {"type": "Polygon", "coordinates": [[[-122.55459, 38.44131], [-122.55309, 38.44393], [-122.54848, 38.44397], [-122.54843, 38.43733], [-122.55269, 38.43912], [-122.5535, 38.43944], [-122.55459, 38.44131]]]} | No Public Access 3 | 47347 | Auberge Ceanothus Preserve | 31063 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 71.713 | Auberge Ceanothus Preserve | 2011 | Local Conservation Area 4 | 2 | |
11521 | 11521 | 11520 | {"type": "MultiPolygon", "coordinates": [[[[-121.84156, 37.15629], [-121.82926, 37.15028], [-121.83063, 37.15028], [-121.83065, 37.14667], [-121.83978, 37.1467], [-121.83977, 37.15017], [-121.84132, 37.15017], [-121.84156, 37.15629]]], [[[-121.83961, 37.14302], [-121.83061, 37.14311], [-121.83054, 37.13592], [-121.83954, 37.1359], [-121.83961, 37.14302]]]]} | No Public Access 3 | 48232 | Barrett Canyon | 32789 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 325.464 | Barrett Canyon | 2018 | None 1026 | ||
14814 | 14814 | 14813 | {"type": "Polygon", "coordinates": [[[-119.86682, 36.82496], [-119.86666, 36.82512], [-119.86489, 36.82512], [-119.86489, 36.82462], [-119.86486, 36.82455], [-119.86479, 36.8245], [-119.8648, 36.82365], [-119.86682, 36.82496]]]} | No Public Access 3 | 47256 | Basin AC | 30967 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 3.873 | Basin AC | None 1270 | ||
14816 | 14816 | 14815 | {"type": "Polygon", "coordinates": [[[-119.86929, 36.80535], [-119.86893, 36.80535], [-119.86892, 36.80515], [-119.86875, 36.80487], [-119.86867, 36.80472], [-119.86867, 36.80459], [-119.86928, 36.80459], [-119.86929, 36.80535]]]} | No Public Access 3 | 47259 | Basin AH1 | 30969 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 0.889 | Basin AH1 | None 1271 | ||
14828 | 14828 | 14827 | {"type": "Polygon", "coordinates": [[[-119.77928, 36.83923], [-119.77927, 36.84098], [-119.77919, 36.84098], [-119.77919, 36.8411], [-119.77899, 36.84134], [-119.77869, 36.84135], [-119.77852, 36.84129], [-119.77843, 36.84127], [-119.77794, 36.84127], [-119.77769, 36.84134], [-119.77708, 36.84133], [-119.77708, 36.83933], [-119.77713, 36.83927], [-119.77713, 36.83909], [-119.77918, 36.83909], [-119.77921, 36.83917], [-119.77928, 36.83923]]]} | No Public Access 3 | 47261 | Basin CN | 30972 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 11.783 | Basin CN | None 1272 | ||
14830 | 14830 | 14829 | {"type": "Polygon", "coordinates": [[[-119.90644, 36.84421], [-119.90559, 36.8442], [-119.90545, 36.84133], [-119.90629, 36.8413], [-119.90644, 36.84421]]]} | No Public Access 3 | 47265 | Basin EG | 30975 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 5.959 | Basin EG | None 1273 | ||
14835 | 14835 | 14834 | {"type": "Polygon", "coordinates": [[[-119.79715, 36.81665], [-119.79715, 36.81715], [-119.79707, 36.81714], [-119.79699, 36.81716], [-119.79694, 36.8172], [-119.79691, 36.81726], [-119.79692, 36.81734], [-119.79702, 36.81743], [-119.79704, 36.8175], [-119.79612, 36.8175], [-119.79612, 36.81744], [-119.79608, 36.81739], [-119.79603, 36.81735], [-119.79596, 36.81733], [-119.795, 36.81734], [-119.79501, 36.81601], [-119.79543, 36.81601], [-119.7955, 36.81624], [-119.79565, 36.81644], [-119.79577, 36.81654], [-119.7959, 36.81662], [-119.79602, 36.81668], [-119.79629, 36.81674], [-119.79642, 36.81675], [-119.79656, 36.81674], [-119.79715, 36.81665]]]} | No Public Access 3 | 47268 | Basin F | 30977 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 4.638 | Basin F | None 1275 | ||
14847 | 14847 | 14846 | {"type": "Polygon", "coordinates": [[[-119.82653, 36.72499], [-119.8265, 36.72733], [-119.82652, 36.72779], [-119.82393, 36.72781], [-119.82393, 36.72836], [-119.82325, 36.72836], [-119.8233, 36.72501], [-119.82653, 36.72499]]]} | No Public Access 3 | 47270 | Basin FF | 30979 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 23.139 | Basin FF | None 1276 | ||
14848 | 14848 | 14847 | {"type": "Polygon", "coordinates": [[[-119.73175, 36.7576], [-119.73175, 36.7591], [-119.73157, 36.75909], [-119.73139, 36.75904], [-119.73131, 36.75898], [-119.73118, 36.75885], [-119.73101, 36.75863], [-119.73094, 36.75851], [-119.73087, 36.75827], [-119.73086, 36.75791], [-119.73095, 36.75784], [-119.73104, 36.75782], [-119.73145, 36.7576], [-119.73175, 36.7576]]]} | No Public Access 3 | 47271 | Basin G | 30980 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 2.587 | Basin G | None 1277 | ||
14850 | 14850 | 14849 | {"type": "Polygon", "coordinates": [[[-119.82072, 36.82239], [-119.82071, 36.82268], [-119.81965, 36.82268], [-119.81966, 36.8217], [-119.81991, 36.8217], [-119.81997, 36.82167], [-119.82072, 36.82239]]]} | No Public Access 3 | 47275 | Basin I | 30983 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 1.938 | Basin I | None 1278 | ||
14546 | 14546 | 14545 | {"type": "Polygon", "coordinates": [[[-119.68934, 36.79579], [-119.68898, 36.7962], [-119.68816, 36.7969], [-119.68789, 36.79661], [-119.68767, 36.79635], [-119.68747, 36.79603], [-119.68723, 36.79556], [-119.68708, 36.79508], [-119.68701, 36.79458], [-119.68699, 36.79421], [-119.6883, 36.79422], [-119.68907, 36.79478], [-119.68923, 36.79555], [-119.68934, 36.79579]]]} | No Public Access 3 | 47277 | Basin IE | 30985 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 10.257 | Basin IE | None 1240 | ||
14882 | 14882 | 14881 | {"type": "Polygon", "coordinates": [[[-119.77005, 36.80943], [-119.77005, 36.81043], [-119.7689, 36.81042], [-119.76891, 36.80944], [-119.77005, 36.80943]]]} | No Public Access 3 | 47279 | Basin M | 30987 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 2.777 | Basin M | None 1283 | ||
14883 | 14883 | 14882 | {"type": "Polygon", "coordinates": [[[-119.71801, 36.79454], [-119.71712, 36.79489], [-119.71655, 36.79496], [-119.71417, 36.79586], [-119.71379, 36.79605], [-119.71346, 36.79608], [-119.71303, 36.7959], [-119.71246, 36.79556], [-119.71181, 36.79498], [-119.71149, 36.79491], [-119.7115, 36.79474], [-119.71144, 36.79469], [-119.71143, 36.79428], [-119.71146, 36.79424], [-119.71146, 36.79416], [-119.71194, 36.79411], [-119.71678, 36.7941], [-119.71759, 36.79416], [-119.71801, 36.79416], [-119.71801, 36.79454]]]} | No Public Access 3 | 47280 | Basin S | 30989 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 20.076 | Basin S | None 1284 | ||
15014 | 15014 | 15013 | {"type": "Polygon", "coordinates": [[[-119.81224, 36.70995], [-119.81224, 36.71035], [-119.81186, 36.71035], [-119.81187, 36.71015], [-119.81185, 36.71008], [-119.81178, 36.70994], [-119.81224, 36.70995]]]} | No Public Access 3 | 47284 | Basin TT2 | 30991 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 0.396 | Basin TT2 | None 1294 | ||
15019 | 15019 | 15018 | {"type": "Polygon", "coordinates": [[[-119.74079, 36.7657], [-119.74078, 36.76666], [-119.7402, 36.76665], [-119.74007, 36.76659], [-119.73981, 36.76632], [-119.73979, 36.76623], [-119.73982, 36.76611], [-119.73984, 36.7657], [-119.74079, 36.7657]]]} | No Public Access 3 | 47285 | Basin V | 30992 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 2.119 | Basin V | None 1297 | ||
15015 | 15015 | 15014 | {"type": "Polygon", "coordinates": [[[-119.83993, 36.76288], [-119.83956, 36.76288], [-119.83955, 36.76281], [-119.83778, 36.76281], [-119.83777, 36.76164], [-119.83992, 36.76164], [-119.83993, 36.76288]]]} | No Public Access 3 | 47288 | Basin XX | 30994 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 6.232 | Basin XX | None 1295 | ||
15158 | 15158 | 15157 | {"type": "Polygon", "coordinates": [[[-119.72501, 36.73776], [-119.72501, 36.73865], [-119.72424, 36.73868], [-119.72396, 36.73853], [-119.72369, 36.73841], [-119.72327, 36.73837], [-119.72318, 36.73827], [-119.72285, 36.73828], [-119.72286, 36.73784], [-119.72306, 36.73768], [-119.72476, 36.73768], [-119.72487, 36.73776], [-119.72501, 36.73776]]]} | No Public Access 3 | 47289 | Basin Y | 30995 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 4.281 | Basin Y | None 1320 | ||
13064 | 13064 | 13063 | {"type": "MultiPolygon", "coordinates": [[[[-122.02211, 37.16716], [-122.02181, 37.16714], [-122.02139, 37.16702], [-122.02125, 37.1668], [-122.02112, 37.16668], [-122.02064, 37.16671], [-122.02042, 37.16667], [-122.02024, 37.16654], [-122.02003, 37.16633], [-122.01976, 37.16613], [-122.01938, 37.16608], [-122.01899, 37.16611], [-122.0187, 37.16607], [-122.01833, 37.16613], [-122.01808, 37.16614], [-122.0176, 37.16589], [-122.01726, 37.16575], [-122.01713, 37.16564], [-122.01698, 37.16541], [-122.01615, 37.16587], [-122.01583, 37.16587], [-122.01564, 37.16573], [-122.01541, 37.16551], [-122.01493, 37.16491], [-122.01477, 37.16457], [-122.01453, 37.16441], [-122.01416, 37.16401], [-122.01399, 37.16368], [-122.01368, 37.16348], [-122.01368, 37.16286], [-122.01335, 37.1628], [-122.01318, 37.16264], [-122.01294, 37.16251], [-122.01261, 37.1624], [-122.01231, 37.16235], [-122.0123, 37.16215], [-122.01282, 37.16227], [-122.01344, 37.16262], [-122.01379, 37.16278], [-122.01377, 37.1628], [-122.01377, 37.16281], [-122.01407, 37.16287], [-122.0141, 37.16277], [-122.0145, 37.16291], [-122.01475, 37.16297], [-122.01532, 37.16332], [-122.0155, 37.16327], [-122.0219, 37.16346], [-122.02198, 37.16698], [-122.02186, 37.16706], [-122.02211, 37.16716]]], [[[-122.0222, 37.16716], [-122.0222, 37.16716], [-122.0222, 37.16716], [-122.0222, 37.16716], [-122.0222, 37.16716]]]]} | No Public Access 3 | 34926 | Bear Creek Redwoods Open Space Preserve | 31479 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 51.35 | Bear Creek Redwoods OSP | 2000 | Local Conservation Area 4 | 2 |
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]);