units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
96 rows where ACCESS_TYP = 3 and DES_TP = 14 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_LEV, COUNTY, YR_EST
MNG_AGENCY >30
- Los Angeles, City of 12
- Los Angeles County Flood Control District 10
- Escondido, City of 9
- San Diego, City of 8
- Napa, City of 8
- Rocklin, City of 6
- Mountains Recreation and Conservation Authority 4
- Santa Barbara Flood Control and Water Conserv. District 3
- San Diego, County of 3
- Natomas Basin Conservancy 3
- Los Angeles - Department of Water and Power, City of 2
- Rancho Palos Verdes, City of 2
- Torrance, City of 2
- Santa Barbara, County of 1
- Watsonville, City of 1
- Los Angeles, County of 1
- Monterey, County of 1
- Napa County Regional Park and Open Space District 1
- Chula Vista, City of 1
- Petaluma, City of 1
- Davis, City of 1
- San Marcos, City of 1
- Paramount, City of 1
- Diamond Bar, City of 1
- Sonoma County Agricultural Preservation and Open Space District 1
- American Canyon, City of 1
- Santa Clara Valley Open Space Authority 1
- Soledad, City of 1
- Napa, County of 1
- Sacramento, City of 1
- …
MNG_AG_TYP 6
DES_TP 1
- Local Other or Unknown · 96 ✖
ACCESS_TYP 1
- No Public Access · 96 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9628 | 9628 | 9627 | {"type": "Polygon", "coordinates": [[[-122.69582, 38.54625], [-122.69567, 38.54622], [-122.6949, 38.54581], [-122.69432, 38.54576], [-122.69338, 38.54514], [-122.69307, 38.54474], [-122.69284, 38.54396], [-122.69244, 38.5437], [-122.69183, 38.54277], [-122.69113, 38.54204], [-122.69108, 38.54018], [-122.69581, 38.54015], [-122.69582, 38.54625]]]} | No Public Access 3 | 47850 | Wendle Property | 31796 | 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 | 50.237 | Wendle Property | 2018 | Local Other or Unknown 14 | 4 | |
1216 | 1216 | 1215 | {"type": "Polygon", "coordinates": [[[-122.58991, 38.30992], [-122.57891, 38.32201], [-122.57277, 38.31852], [-122.58368, 38.30636], [-122.58991, 38.30992]]]} | No Public Access 3 | 7007 | Lafferty Ranch | 20837 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 272.49 | Lafferty Ranch | 0 | Local Other or Unknown 14 | 4 | |
7871 | 7871 | 7870 | {"type": "Polygon", "coordinates": [[[-122.39608, 37.51947], [-122.38304, 37.51947], [-122.38303, 37.51405], [-122.38073, 37.51403], [-122.3807, 37.5086], [-122.37849, 37.5086], [-122.37849, 37.50594], [-122.383, 37.50594], [-122.38301, 37.50493], [-122.3869, 37.50493], [-122.38693, 37.51585], [-122.39604, 37.51584], [-122.39608, 37.51947]]]} | No Public Access 3 | 9994 | Coastside County Water District | 17466 | 2022 | Coastside County Water District 882 | Special District 4 | Water District 13 | http://www.coastsidewater.org/ | Special District 4 | 2022 | Coastside County Water District 857 | Special District 4 | Water District 13 | San Mateo 15 | 277.163 | Coastside County Water District | 1930 | Local Other or Unknown 14 | 4 | |
4669 | 4669 | 4668 | {"type": "Polygon", "coordinates": [[[-122.34815, 38.318], [-122.34756, 38.31831], [-122.34706, 38.31768], [-122.34742, 38.31748], [-122.34791, 38.31776], [-122.34815, 38.318]]]} | No Public Access 3 | 36618 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.089 | 0 | Local Other or Unknown 14 | 4 | ||
4672 | 4672 | 4671 | {"type": "Polygon", "coordinates": [[[-122.34393, 38.31701], [-122.34317, 38.31651], [-122.34302, 38.31644], [-122.34282, 38.31622], [-122.343, 38.31604], [-122.34304, 38.31589], [-122.34292, 38.31573], [-122.34268, 38.31564], [-122.34243, 38.31559], [-122.34204, 38.31569], [-122.34134, 38.31566], [-122.34134, 38.31545], [-122.3427, 38.31551], [-122.34283, 38.31553], [-122.34294, 38.31558], [-122.34305, 38.31567], [-122.34311, 38.31575], [-122.34319, 38.31614], [-122.34327, 38.31631], [-122.34337, 38.31643], [-122.34367, 38.31671], [-122.34393, 38.31701]]]} | No Public Access 3 | 36636 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.35 | 0 | Local Other or Unknown 14 | 4 | ||
15449 | 15449 | 15448 | {"type": "Polygon", "coordinates": [[[-122.30439, 38.26326], [-122.30382, 38.2634], [-122.30362, 38.26287], [-122.30419, 38.26274], [-122.30439, 38.26326]]]} | No Public Access 3 | 36595 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.78 | 0 | Local Other or Unknown 14 | 4 | ||
6548 | 6548 | 6547 | {"type": "Polygon", "coordinates": [[[-122.27836, 38.16698], [-122.27244, 38.16694], [-122.27213, 38.16617], [-122.26881, 38.16606], [-122.26808, 38.16422], [-122.27137, 38.16431], [-122.27832, 38.16431], [-122.27836, 38.16698]]]} | No Public Access 3 | 3636 | American Canyon Property | 15448 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 55.469 | American Canyon Property | 0 | Local Other or Unknown 14 | 4 | |
4667 | 4667 | 4666 | {"type": "Polygon", "coordinates": [[[-122.26819, 38.3106], [-122.26761, 38.3104], [-122.26755, 38.31017], [-122.26748, 38.31002], [-122.26773, 38.30992], [-122.26819, 38.3106]]]} | No Public Access 3 | 36614 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.487 | 0 | Local Other or Unknown 14 | 4 | ||
7798 | 7798 | 7797 | {"type": "Polygon", "coordinates": [[[-122.26488, 38.57654], [-122.26001, 38.57628], [-122.25998, 38.57271], [-122.2502, 38.57224], [-122.24999, 38.5757], [-122.24669, 38.57566], [-122.24449, 38.57208], [-122.24579, 38.57211], [-122.24589, 38.56866], [-122.24142, 38.56847], [-122.24147, 38.56167], [-122.2507, 38.56202], [-122.25035, 38.56881], [-122.25518, 38.569], [-122.25526, 38.5656], [-122.25995, 38.56577], [-122.25998, 38.56918], [-122.26488, 38.56972], [-122.26488, 38.57654]]]} | No Public Access 3 | 47669 | Swittle Creek | 31410 | 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 | 422.914 | Swittle Creek | 0 | Local Other or Unknown 14 | 4 | |
4633 | 4633 | 4632 | {"type": "Polygon", "coordinates": [[[-122.26376, 38.30317], [-122.26366, 38.30341], [-122.26313, 38.30317], [-122.26295, 38.30314], [-122.26275, 38.30314], [-122.26311, 38.30284], [-122.26376, 38.30317]]]} | No Public Access 3 | 36317 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.57 | 0 | Local Other or Unknown 14 | 4 | ||
4616 | 4616 | 4615 | {"type": "Polygon", "coordinates": [[[-122.25499, 38.35941], [-122.25411, 38.35979], [-122.25361, 38.35995], [-122.25326, 38.35997], [-122.25289, 38.3599], [-122.25265, 38.35979], [-122.25242, 38.35946], [-122.25248, 38.35927], [-122.25284, 38.35909], [-122.2538, 38.35892], [-122.2543, 38.35893], [-122.25499, 38.35941]]]} | No Public Access 3 | 35922 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 4.386 | 0 | Local Other or Unknown 14 | 4 | ||
3141 | 3141 | 3140 | {"type": "Polygon", "coordinates": [[[-122.22656, 38.37413], [-122.20765, 38.37399], [-122.20771, 38.35953], [-122.21237, 38.35957], [-122.21237, 38.36318], [-122.22173, 38.36325], [-122.22177, 38.36686], [-122.22646, 38.3669], [-122.22656, 38.37413]]]} | No Public Access 3 | 25801 | Milliken Reservoir Property | 22251 | 311 | Napa, County of 498 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 311 | Napa, County of 489 | County 3 | County Agency 3 | Napa 11 | 489.122 | Milliken Reservoir Property | 2000 | Local Other or Unknown 14 | 4 | |
4630 | 4630 | 4629 | {"type": "Polygon", "coordinates": [[[-122.22625, 38.22568], [-122.22229, 38.22571], [-122.22225, 38.22421], [-122.22224, 38.22254], [-122.22307, 38.22433], [-122.2237, 38.22472], [-122.2237, 38.22525], [-122.22475, 38.22524], [-122.22476, 38.22438], [-122.22452, 38.22437], [-122.22415, 38.22431], [-122.22384, 38.22431], [-122.22307, 38.22385], [-122.22241, 38.22243], [-122.22242, 38.22209], [-122.22261, 38.22185], [-122.22315, 38.22161], [-122.22316, 38.22152], [-122.22322, 38.22151], [-122.22325, 38.22127], [-122.22366, 38.2211], [-122.22393, 38.22126], [-122.22421, 38.22139], [-122.22447, 38.22149], [-122.2248, 38.22157], [-122.22525, 38.22163], [-122.2262, 38.22165], [-122.22625, 38.22568]]]} | No Public Access 3 | 36293 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 35.376 | 0 | Local Other or Unknown 14 | 4 | ||
15478 | 15478 | 15477 | {"type": "Polygon", "coordinates": [[[-121.79324, 36.88092], [-121.79324, 36.88092], [-121.78808, 36.88474], [-121.78767, 36.88399], [-121.79284, 36.88016], [-121.79324, 36.88092]]]} | No Public Access 3 | 36631 | Unnamed site - Watsonville, City of | 28700 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 13.356 | 0 | Local Other or Unknown 14 | 4 | ||
4640 | 4640 | 4639 | {"type": "Polygon", "coordinates": [[[-121.76878, 36.88577], [-121.76854, 36.88632], [-121.76869, 36.88648], [-121.76648, 36.88819], [-121.76471, 36.88798], [-121.7647, 36.88784], [-121.76557, 36.88755], [-121.76873, 36.88508], [-121.76878, 36.88577]]]} | No Public Access 3 | 36489 | Unnamed site - Monterey, County of | 28701 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 10.195 | 0 | Local Other or Unknown 14 | 4 | ||
10935 | 10935 | 10934 | {"type": "Polygon", "coordinates": [[[-121.67546, 38.55795], [-121.67529, 38.56745], [-121.65712, 38.56762], [-121.65699, 38.57488], [-121.64781, 38.57492], [-121.63857, 38.57489], [-121.63885, 38.56638], [-121.66534, 38.56043], [-121.66535, 38.5608], [-121.66612, 38.5608], [-121.66614, 38.5602], [-121.66638, 38.56014], [-121.6664, 38.55998], [-121.67546, 38.55795]]]} | No Public Access 3 | 20963 | Howatt/Clayton Ranch | 20123 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 786.039 | Howatt/Clayton Ranch | 0 | Local Other or Unknown 14 | 4 | |
12720 | 12720 | 12719 | {"type": "Polygon", "coordinates": [[[-121.58519, 38.73806], [-121.5843, 38.74056], [-121.58366, 38.74229], [-121.58355, 38.74272], [-121.58352, 38.74306], [-121.58331, 38.74329], [-121.5831, 38.74338], [-121.58271, 38.74346], [-121.57806, 38.7435], [-121.57789, 38.74347], [-121.57717, 38.7431], [-121.57692, 38.74306], [-121.5769, 38.73805], [-121.58519, 38.73806]]]} | No Public Access 3 | 29736 | Ruby Ranch | 24724 | 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 | 93.99 | Ruby Ranch | 0 | Local Other or Unknown 14 | 4 | |
13175 | 13175 | 13174 | {"type": "Polygon", "coordinates": [[[-121.57686, 38.77162], [-121.57188, 38.7717], [-121.57185, 38.76445], [-121.5687, 38.76451], [-121.56867, 38.76072], [-121.57182, 38.76066], [-121.57184, 38.76246], [-121.57684, 38.76237], [-121.57686, 38.77162]]]} | No Public Access 3 | 35159 | Lucich Ranch | 21580 | 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 | 138.582 | Lucich Ranch | 0 | Local Other or Unknown 14 | 4 | |
12719 | 12719 | 12718 | {"type": "Polygon", "coordinates": [[[-121.57188, 38.7717], [-121.56259, 38.77184], [-121.56254, 38.76466], [-121.56254, 38.76083], [-121.56867, 38.76072], [-121.5687, 38.76451], [-121.57185, 38.76444], [-121.57188, 38.7717]]]} | No Public Access 3 | 29735 | Lucich Ranch | 21580 | 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 | 215.926 | Lucich Ranch | 0 | Local Other or Unknown 14 | 4 | |
4796 | 4796 | 4795 | {"type": "Polygon", "coordinates": [[[-121.38313, 38.64166], [-121.38312, 38.64229], [-121.38237, 38.64219], [-121.38248, 38.64206], [-121.38216, 38.64167], [-121.38223, 38.64159], [-121.38189, 38.64137], [-121.38288, 38.64043], [-121.38306, 38.64097], [-121.38306, 38.64164], [-121.38313, 38.64166]]]} | No Public Access 3 | 48339 | Unnamed Site - Sacramento, City of | 32902 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.149 | 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]);