units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
47 rows where ACCESS_TYP = 2 and DES_TP = 4 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST
MNG_AGENCY 28
- Sonoma County Agricultural Preservation and Open Space District 5
- Santa Clara Valley Open Space Authority 4
- Sacramento, County of 4
- East Bay Regional Park District 3
- San Diego, County of 3
- Santa Cruz, County of 2
- Watsonville, City of 2
- Conejo Open Space Conservation Agency 2
- Midpeninsula Regional Open Space District 2
- Los Cerritos Wetland Authority 2
- Oakdale, City of 1
- San Diego, City of 1
- Mountains Recreation and Conservation Authority 1
- Santa Barbara Flood Control and Water Conserv. District 1
- Monterey Peninsula Regional Park District 1
- Carpinteria, City of 1
- Glendora, City of 1
- Tulare, County of 1
- Poway, City of 1
- Orange, County of 1
- Marin County Parks Department, County of 1
- Placer, County of 1
- Gardena, City of 1
- Livermore Area Recreation and Park District 1
- Contra Costa County Public Works Dept., County of 1
- American Canyon, City of 1
- Coachella Valley Water District 1
- Elk Grove, City of 1
AGNCY_TYP 10 ✖
MNG_AG_TYP 9
DES_TP 1
- Local Conservation Area · 47 ✖
ACCESS_TYP 1
- Restricted Access · 47 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12730 | 12730 | 12729 | {"type": "MultiPolygon", "coordinates": [[[[-122.50341, 37.89167], [-122.50335, 37.89177], [-122.50328, 37.89182], [-122.50317, 37.89189], [-122.50304, 37.89193], [-122.5031, 37.89208], [-122.50098, 37.89263], [-122.49859, 37.88632], [-122.50038, 37.88598], [-122.5004, 37.88627], [-122.5004, 37.8867], [-122.50043, 37.88684], [-122.50102, 37.88818], [-122.5012, 37.88847], [-122.5015, 37.88885], [-122.50174, 37.88906], [-122.50197, 37.88923], [-122.50288, 37.88987], [-122.50303, 37.89003], [-122.50313, 37.89022], [-122.50349, 37.89118], [-122.5035, 37.89127], [-122.50348, 37.89149], [-122.50341, 37.89167]]], [[[-122.50424, 37.89389], [-122.5042, 37.89421], [-122.50385, 37.89496], [-122.50359, 37.89515], [-122.50345, 37.89523], [-122.50326, 37.89528], [-122.50312, 37.89528], [-122.50296, 37.89524], [-122.50264, 37.89508], [-122.50245, 37.89504], [-122.50223, 37.89504], [-122.50193, 37.89512], [-122.50132, 37.89353], [-122.5033, 37.89302], [-122.50331, 37.89309], [-122.50424, 37.89389]]]]} | Restricted Access 2 | 29759 | Aramburu Wildlife Preserve | 15552 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 45.233 | Aramburu Wildlife Preserve | 0 | Local Conservation Area 4 | 2 | |
4117 | 4117 | 4116 | {"type": "Polygon", "coordinates": [[[-118.921, 34.20591], [-118.92099, 34.2097], [-118.92022, 34.20901], [-118.91855, 34.20853], [-118.91575, 34.2074], [-118.91433, 34.20701], [-118.91473, 34.20578], [-118.91189, 34.20579], [-118.9117, 34.20575], [-118.91279, 34.20491], [-118.91208, 34.20449], [-118.91277, 34.2032], [-118.9125, 34.20197], [-118.91026, 34.20222], [-118.91025, 34.20301], [-118.90929, 34.20311], [-118.90827, 34.20385], [-118.90696, 34.2037], [-118.90725, 34.20331], [-118.90673, 34.20267], [-118.90598, 34.20258], [-118.90596, 34.20197], [-118.90453, 34.20257], [-118.90433, 34.20209], [-118.90377, 34.2021], [-118.90312, 34.20204], [-118.90268, 34.20197], [-118.90262, 34.20193], [-118.90248, 34.20157], [-118.90165, 34.20139], [-118.90109, 34.20142], [-118.90064, 34.20099], [-118.9011, 34.20077], [-118.90071, 34.20017], [-118.90045, 34.19943], [-118.90145, 34.19998], [-118.90194, 34.20006], [-118.90259, 34.20052], [-118.90294, 34.20059], [-118.90276, 34.20086], [-118.90277, 34.20088], [-118.90468, 34.20126], [-118.90661, 34.20099], [-118.90665, 34.19895], [-118.90804, 34.19813], [-118.9085, 34.19838], [-118.90889, 34.19713], [-118.9089, 34.19649], [-118.90846, 34.19588], [-118.90768, 34.1956], [-118.9071, 34.19509], [-118.90751, 34.19409], [-118.90785, 34.1934], [-118.90894, 34.19318], [-118.9091, 34.19293], [-118.9093, 34.19275], [-118.90933, 34.19127], [-118.911, 34.19126], [-118.91101, 34.1914], [-118.91095, 34.19154], [-118.91103, 34.19163], [-118.91106, 34.19169], [-118.91111, 34.19186], [-118.91111, 34.192], [-118.91106, 34.19213], [-118.91116, 34.1923], [-118.91116, 34.19248], [-118.91129, 34.19264], [-118.91135, 34.19285], [-118.91127, 34.19297], [-118.91104, 34.19313], [-118.91103, 34.19338], [-118.9108, 34.19329], [-118.91064, 34.1936], [-118.91064, 34.19367], [-118.91055, 34.19375], [-118.90995, 34.19372], [-118.90974, 34.19392], [-118.90962, 34.19409], [-118.90927, 34.19439], [-118.90938, 34.19465], [-118.90922, 34.19486], [-118.90942, 34.19502], [-118.90926, 34.19514], [-118.90954, 34.19538], [-118.90995, 34.19536], [-118.91013, 34.19551], [-118.91029, 34.19567], [-118.91041, 34.19587], [-118.91035, 34.19614], [-118.91072, 34.19618], [-118.91065, 34.19663], [-118.91071, 34.19694], [-118.91087, 34.19722], [-118.91113, 34.19744], [-118.91129, 34.19763], [-118.91135, 34.19776], [-118.91142, 34.1981], [-118.91148, 34.19823], [-118.91165, 34.19849], [-118.91179, 34.19862], [-118.91205, 34.19879], [-118.9123, 34.1989], [-118.91286, 34.19901], [-118.91325, 34.19911], [-118.91352, 34.19922], [-118.91366, 34.19974], [-118.91397, 34.1999], [-118.91393, 34.20004], [-118.91396, 34.20005], [-118.91437, 34.20007], [-118.91468, 34.20014], [-118.91526, 34.20037], [-118.91563, 34.20035], [-118.91584, 34.20027], [-118.91613, 34.2], [-118.91631, 34.19948], [-118.91671, 34.20002], [-118.91669, 34.20093], [-118.91789, 34.20173], [-118.91847, 34.20202], [-118.91823, 34.20298], [-118.91848, 34.20348], [-118.91938, 34.20376], [-118.91977, 34.20424], [-118.91963, 34.2053], [-118.91977, 34.20562], [-118.92032, 34.20592], [-118.92069, 34.20595], [-118.921, 34.20591]]]} | Restricted Access 2 | 47117 | Arroyo Conejo Nature Preserve | 30793 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Arroyo Conejo | Ventura 8 | 250.878 | Arroyo Conejo Nature Preserve | 0 | Local Conservation Area 4 | 2 |
15928 | 15928 | 15927 | {"type": "Polygon", "coordinates": [[[-122.01096, 37.17045], [-122.01066, 37.17058], [-122.0105, 37.17074], [-122.0103, 37.17084], [-122.00975, 37.17124], [-122.00965, 37.17139], [-122.00932, 37.17152], [-122.00919, 37.17162], [-122.00907, 37.17163], [-122.00898, 37.17167], [-122.00854, 37.17155], [-122.00786, 37.17166], [-122.00758, 37.17183], [-122.00748, 37.17194], [-122.0073, 37.17197], [-122.00706, 37.17214], [-122.00678, 37.17245], [-122.00663, 37.1725], [-122.00652, 37.17265], [-122.00631, 37.17276], [-122.00628, 37.17289], [-122.00607, 37.17308], [-122.00594, 37.17325], [-122.00586, 37.17333], [-122.00564, 37.17343], [-122.00553, 37.17351], [-122.00539, 37.17356], [-122.00523, 37.17371], [-122.0052, 37.17384], [-122.00478, 37.17427], [-122.00493, 37.17449], [-122.00529, 37.1748], [-122.00566, 37.17501], [-122.00595, 37.17514], [-122.00624, 37.17533], [-122.00649, 37.17542], [-122.0068, 37.17558], [-122.00708, 37.17577], [-122.00746, 37.17586], [-122.00912, 37.17491], [-122.00915, 37.17502], [-122.00921, 37.17511], [-122.00935, 37.17526], [-122.00979, 37.17563], [-122.00993, 37.1757], [-122.01007, 37.17574], [-122.01035, 37.17576], [-122.01039, 37.17602], [-122.01024, 37.17631], [-122.01016, 37.17661], [-122.00971, 37.17712], [-122.00978, 37.17759], [-122.00995, 37.17776], [-122.01007, 37.17791], [-122.0101, 37.17808], [-122.01006, 37.1782], [-122.01002, 37.17823], [-122.00978, 37.17824], [-122.00927, 37.17869], [-122.00968, 37.17911], [-122.00968, 37.17931], [-122.00955, 37.17977], [-122.00931, 37.1799], [-122.00893, 37.17991], [-122.00843, 37.17999], [-122.00776, 37.17978], [-122.00713, 37.18034], [-122.00687, 37.18045], [-122.00652, 37.18045], [-122.00617, 37.18083], [-122.0057, 37.18106], [-122.0053, 37.18114], [-122.00509, 37.18109], [-122.0048, 37.18086], [-122.00442, 37.1804], [-122.00418, 37.18021], [-122.00373, 37.18015], [-122.00288, 37.18041], [-122.00259, 37.18084], [-122.00256, 37.18115], [-122.0031, 37.18184], [-122.00354, 37.18234], [-122.00452, 37.18287], [-122.00463, 37.18315], [-122.00485, 37.18341], [-122.00503, 37.18392], [-122.00501, 37.18399], [-122.00497, 37.18401], [-122.00443, 37.18397], [-122.00423, 37.18399], [-122.00388, 37.18413], [-122.00329, 37.1843], [-122.0032, 37.18431], [-122.00307, 37.18427], [-122.00275, 37.18414], [-122.00239, 37.18403], [-122.00238, 37.18429], [-122.0026, 37.1847], [-122.00273, 37.18509], [-122.0031, 37.18521], [-122.00276, 37.18561], [-122.00258, 37.18563], [-122.00218, 37.18559], [-122.00186, 37.18569], [-122.00186, 37.18571], [-122.00188, 37.18572], [-122.00154, 37.18585], [-122.00154, 37.18588], [-122.00128, 37.18594], [-122.00051, 37.18632], [-121.99863, 37.187], [-121.9984, 37.18703], [-121.99796, 37.18715], [-121.9978, 37.18717], [-121.99763, 37.18714], [-121.99731, 37.18705], [-121.99615, 37.18697], [-121.99586, 37.18703], [-121.99546, 37.18716], [-121.99524, 37.18728], [-121.9951, 37.18749], [-121.99508, 37.18772], [-121.99465, 37.18773], [-121.99471, 37.18951], [-121.99455, 37.18969], [-121.99421, 37.18993], [-121.99378, 37.19009], [-121.99339, 37.18947], [-121.99281, 37.1891], [-121.99224, 37.18819], [-121.99172, 37.18702], [-121.99235, 37.18586], [-121.99179, 37.18542], [-121.99214, 37.18481], [-121.9925, 37.18442], [-121.99327, 37.18282], [-121.99434, 37.18216], [-121.99402, 37.18107], [-121.99486, 37.17957], [-121.99613, 37.17899], [-121.99618, 37.17738], [-121.9968, 37.17713], [-121.99712, 37.17722], [-121.99772, 37.17722], [-121.99788, 37.17741], [-121.99816, 37.17741], [-121.99819, 37.1777], [-121.99827, 37.17777], [-121.99871, 37.17777], [-121.99875, 37.17773], [-121.99877, 37.17761], [-121.99923, 37.17747], [-121.99934, 37.17719], [-121.99966, 37.17714], [-121.9996, 37.17693], [-122.00016, 37.17675], [-122.00024, 37.17649], [-122.00024, 37.17631], [-122.00015, 37.176], [-122.00003, 37.17262], [-122.00092, 37.17054], [-122.00091, 37.17053], [-122.00017, 37.17054], [-122.00011, 37.16903], [-122.00007, 37.16708], [-122.0, 37.16707], [-121.9999, 37.1636], [-122.0034, 37.1636], [-122.00335, 37.15994], [-122.00784, 37.15996], [-122.008, 37.17047], [-122.01096, 37.17045]]]} | Restricted Access 2 | 18511 | Bear Creek Redwoods Open Space Preserve | 31478 | 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 Clara 19 | 577.047 | Bear Creek Redwoods OSP | 2003 | Local Conservation Area 4 | 2 | |
6086 | 6086 | 6085 | {"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]} | Restricted Access 2 | 891 | Blue Sky Ecological Reserve | 29220 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 83.938 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
15638 | 15638 | 15637 | {"type": "Polygon", "coordinates": [[[-117.02536, 33.01762], [-117.0241, 33.01851], [-117.02409, 33.01859], [-117.02226, 33.01869], [-117.02223, 33.01607], [-117.02353, 33.01605], [-117.02405, 33.01608], [-117.02415, 33.01631], [-117.02426, 33.01652], [-117.02438, 33.01672], [-117.02457, 33.01696], [-117.0249, 33.01729], [-117.02514, 33.01748], [-117.02536, 33.01762]]]} | Restricted Access 2 | 45140 | Blue Sky Ecological Reserve | 29221 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 15.494 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
16288 | 16288 | 16287 | {"type": "Polygon", "coordinates": [[[-122.35803, 37.90099], [-122.35788, 37.9011], [-122.35775, 37.90094], [-122.35773, 37.90094], [-122.35775, 37.90181], [-122.35294, 37.90189], [-122.35282, 37.89694], [-122.35278, 37.8969], [-122.35261, 37.89649], [-122.35227, 37.89631], [-122.352, 37.89603], [-122.35174, 37.89554], [-122.35149, 37.89464], [-122.35146, 37.89464], [-122.35081, 37.89382], [-122.35107, 37.89355], [-122.35136, 37.8937], [-122.35141, 37.89407], [-122.35191, 37.89435], [-122.35246, 37.8945], [-122.35306, 37.89475], [-122.35457, 37.89471], [-122.35471, 37.89435], [-122.3563, 37.89461], [-122.35659, 37.89494], [-122.35687, 37.8949], [-122.35717, 37.89509], [-122.35742, 37.89558], [-122.3575, 37.89591], [-122.35721, 37.89654], [-122.35737, 37.89693], [-122.35716, 37.89727], [-122.35749, 37.89766], [-122.35772, 37.89812], [-122.35737, 37.89887], [-122.3572, 37.89912], [-122.3574, 37.8997], [-122.3576, 37.90062], [-122.35781, 37.9007], [-122.35803, 37.90099]]]} | Restricted Access 2 | 25299 | Brooks Island Regional Preserve | 31525 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 85.832 | Brooks Island RPr | 0 | Local Conservation Area 4 | 2 | |
16295 | 16295 | 16294 | {"type": "Polygon", "coordinates": [[[-121.71059, 37.74507], [-121.71056, 37.74523], [-121.70849, 37.74993], [-121.70578, 37.74938], [-121.70493, 37.74973], [-121.70362, 37.75092], [-121.70222, 37.75251], [-121.70046, 37.75423], [-121.70019, 37.75511], [-121.69957, 37.75587], [-121.69902, 37.75662], [-121.69754, 37.75853], [-121.69725, 37.75852], [-121.69788, 37.75754], [-121.6986, 37.75645], [-121.69922, 37.75567], [-121.69983, 37.75501], [-121.70016, 37.75397], [-121.70184, 37.75238], [-121.70256, 37.75161], [-121.70307, 37.75083], [-121.70471, 37.74935], [-121.70584, 37.74899], [-121.70831, 37.74963], [-121.71036, 37.74507], [-121.71059, 37.74507]]]} | Restricted Access 2 | 45340 | Brushy Peak Regional Preserve | 16456 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 17.299 | Brushy Peak RPr | 2005 | Local Conservation Area 4 | 2 | |
15891 | 15891 | 15890 | {"type": "Polygon", "coordinates": [[[-122.51794, 38.39444], [-122.51749, 38.39489], [-122.51721, 38.39492], [-122.51628, 38.39471], [-122.51547, 38.39579], [-122.5154, 38.39625], [-122.51434, 38.39719], [-122.51404, 38.39797], [-122.51341, 38.39844], [-122.51254, 38.39839], [-122.51226, 38.3985], [-122.51155, 38.3992], [-122.51308, 38.40643], [-122.50661, 38.41063], [-122.50692, 38.41194], [-122.50623, 38.41198], [-122.49861, 38.41202], [-122.499, 38.41263], [-122.50109, 38.41614], [-122.50109, 38.4227], [-122.4944, 38.42265], [-122.49366, 38.42182], [-122.49301, 38.42133], [-122.49233, 38.42044], [-122.49132, 38.41978], [-122.49077, 38.41969], [-122.49016, 38.4195], [-122.48989, 38.41911], [-122.48945, 38.41875], [-122.48906, 38.41815], [-122.48894, 38.41773], [-122.48806, 38.41736], [-122.48745, 38.41671], [-122.48692, 38.41646], [-122.48595, 38.41633], [-122.48543, 38.41574], [-122.48421, 38.41545], [-122.4839, 38.41529], [-122.48328, 38.41467], [-122.48146, 38.41346], [-122.4811, 38.41314], [-122.48108, 38.41254], [-122.48064, 38.41238], [-122.47932, 38.41211], [-122.4788, 38.41156], [-122.47866, 38.41119], [-122.47818, 38.41075], [-122.47807, 38.41055], [-122.47739, 38.41053], [-122.47694, 38.41031], [-122.47669, 38.4101], [-122.47625, 38.40948], [-122.47575, 38.40944], [-122.47531, 38.4091], [-122.47555, 38.40877], [-122.47573, 38.40867], [-122.47772, 38.40861], [-122.47774, 38.40479], [-122.47768, 38.40149], [-122.48243, 38.4015], [-122.50109, 38.40116], [-122.50102, 38.39755], [-122.50161, 38.39707], [-122.50206, 38.39694], [-122.50251, 38.39704], [-122.50286, 38.39702], [-122.50325, 38.39686], [-122.50349, 38.39655], [-122.50409, 38.39644], [-122.50441, 38.39656], [-122.50477, 38.39656], [-122.50534, 38.39684], [-122.50555, 38.39692], [-122.50841, 38.40025], [-122.50845, 38.40022], [-122.50858, 38.40003], [-122.5087, 38.3998], [-122.50887, 38.39932], [-122.50895, 38.39919], [-122.50924, 38.39885], [-122.50945, 38.39869], [-122.5097, 38.39856], [-122.50997, 38.39851], [-122.51032, 38.39846], [-122.51077, 38.39841], [-122.51099, 38.39845], [-122.51109, 38.39849], [-122.51121, 38.39858], [-122.51136, 38.39863], [-122.51143, 38.39863], [-122.5117, 38.39849], [-122.51196, 38.39823], [-122.51224, 38.39808], [-122.51236, 38.39804], [-122.51271, 38.39798], [-122.51305, 38.39797], [-122.5133, 38.39795], [-122.51345, 38.39791], [-122.51365, 38.39776], [-122.5137, 38.39769], [-122.51377, 38.39742], [-122.51381, 38.39736], [-122.51396, 38.39708], [-122.51414, 38.3969], [-122.51426, 38.39681], [-122.51444, 38.39665], [-122.51464, 38.39643], [-122.51498, 38.39615], [-122.51522, 38.39546], [-122.51543, 38.39507], [-122.51564, 38.39478], [-122.51581, 38.3946], [-122.5161, 38.39438], [-122.51622, 38.39424], [-122.51632, 38.39416], [-122.51673, 38.39357], [-122.51702, 38.39296], [-122.51721, 38.39237], [-122.51738, 38.39236], [-122.5175, 38.39232], [-122.51754, 38.39242], [-122.51773, 38.39268], [-122.51802, 38.39328], [-122.51803, 38.39369], [-122.51796, 38.39416], [-122.51794, 38.39444]]]} | Restricted Access 2 | 8210 | Calabazas Creek Open Space Preserve | 16669 | 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 | 1283.299 | Calabazas Creek OSP | 2004 | Local Conservation Area 4 | 2 | |
770 | 770 | 769 | {"type": "MultiPolygon", "coordinates": [[[[-119.5289, 34.39581], [-119.52824, 34.3972], [-119.52811, 34.3971], [-119.52714, 34.39789], [-119.52649, 34.39736], [-119.52855, 34.39567], [-119.5289, 34.39581]]], [[[-119.52817, 34.39735], [-119.52805, 34.39762], [-119.52771, 34.39836], [-119.52732, 34.39804], [-119.52817, 34.39735]]]]} | Restricted Access 2 | 4493 | Carpinteria Salt Marsh Reserve | 16899 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 5.768 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
6661 | 6661 | 6660 | {"type": "MultiPolygon", "coordinates": [[[[-119.52905, 34.3961], [-119.52846, 34.39735], [-119.52762, 34.39923], [-119.52766, 34.39927], [-119.52741, 34.39995], [-119.5269, 34.39971], [-119.52637, 34.39941], [-119.52672, 34.39929], [-119.52671, 34.39926], [-119.52674, 34.39925], [-119.52683, 34.39932], [-119.52708, 34.39925], [-119.52717, 34.39921], [-119.52737, 34.39902], [-119.52739, 34.39902], [-119.5288, 34.39601], [-119.52905, 34.3961]]], [[[-119.53027, 34.40061], [-119.5299, 34.40115], [-119.52919, 34.40081], [-119.52943, 34.40021], [-119.53027, 34.40061]]]]} | Restricted Access 2 | 4718 | Carpinteria Salt Marsh Reserve | 16900 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 5.152 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
4940 | 4940 | 4939 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | 10715 | Chabot - Garin Trail Corridor | 17108 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.064 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
7268 | 7268 | 7267 | {"type": "Polygon", "coordinates": [[[-118.66547, 34.09257], [-118.66492, 34.09257], [-118.66491, 34.09075], [-118.66545, 34.09076], [-118.66547, 34.09257]]]} | Restricted Access 2 | 6488 | Cold Creek Canyon Preserve | 17481 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.52 | Cold Creek Canyon Preserve | 0 | Local Conservation Area 4 | 2 | |
2734 | 2734 | 2733 | {"type": "Polygon", "coordinates": [[[-121.33438, 38.34361], [-121.33319, 38.34464], [-121.33304, 38.34475], [-121.33156, 38.34376], [-121.32059, 38.34373], [-121.31587, 38.3413], [-121.31593, 38.33691], [-121.31584, 38.33662], [-121.33219, 38.33672], [-121.33217, 38.33698], [-121.33427, 38.34166], [-121.33351, 38.34218], [-121.33376, 38.3427], [-121.33414, 38.34327], [-121.33438, 38.34361]]]} | Restricted Access 2 | 21422 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 286.086 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
2735 | 2735 | 2734 | {"type": "Polygon", "coordinates": [[[-121.37929, 38.26206], [-121.37925, 38.26667], [-121.36993, 38.26662], [-121.36997, 38.26204], [-121.37929, 38.26206]]]} | Restricted Access 2 | 21423 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 102.78 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
11084 | 11084 | 11083 | {"type": "Polygon", "coordinates": [[[-121.4649, 38.3205], [-121.46195, 38.32051], [-121.44506, 38.32078], [-121.44502, 38.32049], [-121.44467, 38.32051], [-121.44283, 38.30486], [-121.46162, 38.30476], [-121.4649, 38.3205]]]} | Restricted Access 2 | 21325 | Cosumnes River Preserve | 17680 | 1097 | Elk Grove, City of 963 | City 2 | City Agency 2 | http://www.elkgrovecity.org/ | City 2 | 1097 | Elk Grove, City of 931 | City 2 | City Agency 2 | Sacramento 41 | 740.158 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
11133 | 11133 | 11132 | {"type": "Polygon", "coordinates": [[[-121.51691, 38.25947], [-121.50965, 38.26426], [-121.5083, 38.26215], [-121.50771, 38.26135], [-121.5073, 38.26083], [-121.50498, 38.25966], [-121.50269, 38.25821], [-121.5029, 38.25787], [-121.50312, 38.25794], [-121.50676, 38.25202], [-121.50862, 38.25131], [-121.50878, 38.25131], [-121.50893, 38.25149], [-121.50982, 38.25136], [-121.5103, 38.25196], [-121.51058, 38.25188], [-121.51111, 38.25283], [-121.51144, 38.25331], [-121.5121, 38.2541], [-121.51264, 38.25478], [-121.51317, 38.25533], [-121.51401, 38.25612], [-121.51486, 38.25683], [-121.51562, 38.2574], [-121.51648, 38.25796], [-121.51562, 38.25854], [-121.51691, 38.25947]]]} | Restricted Access 2 | 21424 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 229.043 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
1429 | 1429 | 1428 | {"type": "Polygon", "coordinates": [[[-117.00998, 32.57781], [-117.00559, 32.57765], [-117.00559, 32.57912], [-117.00537, 32.57895], [-117.00513, 32.57883], [-117.00486, 32.57878], [-117.0046, 32.57878], [-117.00434, 32.57884], [-117.00415, 32.57892], [-117.00402, 32.579], [-117.00369, 32.57861], [-117.00357, 32.57838], [-117.00352, 32.5782], [-117.0035, 32.57805], [-117.0035, 32.57572], [-117.00456, 32.57575], [-117.00457, 32.57563], [-117.00487, 32.57547], [-117.00504, 32.57543], [-117.00514, 32.57544], [-117.00571, 32.5757], [-117.00584, 32.5757], [-117.00599, 32.57551], [-117.00621, 32.57533], [-117.00643, 32.57533], [-117.00656, 32.57537], [-117.0068, 32.57512], [-117.00705, 32.57482], [-117.00727, 32.57423], [-117.00733, 32.57399], [-117.00696, 32.57363], [-117.00645, 32.57334], [-117.00621, 32.57316], [-117.00602, 32.57284], [-117.00594, 32.57263], [-117.00594, 32.57243], [-117.00626, 32.57237], [-117.00647, 32.57236], [-117.00649, 32.57158], [-117.00647, 32.57157], [-117.00652, 32.57069], [-117.0065, 32.57067], [-117.00652, 32.57059], [-117.00652, 32.57031], [-117.00654, 32.5703], [-117.00654, 32.56915], [-117.00618, 32.56914], [-117.00587, 32.56895], [-117.00586, 32.56882], [-117.00553, 32.56882], [-117.00553, 32.56854], [-117.00572, 32.56854], [-117.00575, 32.56846], [-117.00583, 32.56841], [-117.00749, 32.56842], [-117.00798, 32.56847], [-117.00925, 32.56848], [-117.00925, 32.56886], [-117.00841, 32.56886], [-117.0084, 32.56946], [-117.00888, 32.5703], [-117.00988, 32.5703], [-117.00998, 32.57781]]]} | Restricted Access 2 | 47693 | Dennery Preserve | 31429 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 98.129 | Dennery Preserve | 0 | Local Conservation Area 4 | 2 | |
3617 | 3617 | 3616 | {"type": "Polygon", "coordinates": [[[-122.74565, 38.48914], [-122.74561, 38.49073], [-122.74474, 38.49073], [-122.74477, 38.48913], [-122.74565, 38.48914]]]} | Restricted Access 2 | 29390 | Dogbane Preserve | 18185 | 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 | 3.337 | Dogbane Preserve | 1997 | Local Conservation Area 4 | 2 | |
9692 | 9692 | 9691 | {"type": "Polygon", "coordinates": [[[-121.82747, 36.9152], [-121.82607, 36.9168], [-121.82571, 36.91674], [-121.82537, 36.91664], [-121.82532, 36.91668], [-121.82468, 36.91634], [-121.82421, 36.91602], [-121.82368, 36.91571], [-121.82311, 36.91547], [-121.82248, 36.91531], [-121.82184, 36.91523], [-121.82145, 36.91524], [-121.82079, 36.91532], [-121.81964, 36.91555], [-121.81917, 36.91559], [-121.81862, 36.91557], [-121.81814, 36.91548], [-121.81777, 36.91537], [-121.81739, 36.91521], [-121.81705, 36.91502], [-121.81678, 36.91482], [-121.81457, 36.91299], [-121.8141, 36.91247], [-121.81373, 36.91189], [-121.81598, 36.91026], [-121.81956, 36.9132], [-121.82148, 36.91203], [-121.82242, 36.91172], [-121.82319, 36.91255], [-121.82441, 36.91278], [-121.82529, 36.91254], [-121.82747, 36.9152]]]} | Restricted Access 2 | 16377 | Gallighan Slough | 28151 | 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 | 98.834 | Gallighan Slough | 0 | Local Conservation Area 4 | 2 | |
9698 | 9698 | 9697 | {"type": "MultiPolygon", "coordinates": [[[[-121.81062, 36.91], [-121.81032, 36.90991], [-121.81001, 36.91005], [-121.80937, 36.91143], [-121.80919, 36.91137], [-121.8094, 36.9109], [-121.80963, 36.91001], [-121.80983, 36.90957], [-121.80981, 36.90862], [-121.81062, 36.91]]], [[[-121.8208, 36.91677], [-121.81946, 36.91684], [-121.8184, 36.91715], [-121.81784, 36.91788], [-121.81749, 36.91791], [-121.81589, 36.91711], [-121.81536, 36.91645], [-121.8149, 36.91595], [-121.81467, 36.91595], [-121.81398, 36.91524], [-121.81264, 36.91331], [-121.81191, 36.9127], [-121.81154, 36.9117], [-121.81148, 36.91147], [-121.81215, 36.91259], [-121.81332, 36.91179], [-121.8138, 36.91263], [-121.81399, 36.91289], [-121.81422, 36.91312], [-121.81616, 36.91481], [-121.81662, 36.91515], [-121.81714, 36.91542], [-121.8177, 36.91562], [-121.8183, 36.91574], [-121.81892, 36.91578], [-121.81954, 36.91574], [-121.82052, 36.91553], [-121.8208, 36.91677]]]]} | Restricted Access 2 | 16385 | Gallighan Slough | 28152 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 41.877 | Gallighan Slough | 0 | 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]);