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 ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_TYP, LAYER, 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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
2068 | 2068 | 2067 | {"type": "Polygon", "coordinates": [[[-121.93333, 36.50126], [-121.93326, 36.50153], [-121.93266, 36.50142], [-121.93222, 36.50144], [-121.93206, 36.50171], [-121.93202, 36.50193], [-121.93202, 36.50211], [-121.93237, 36.50231], [-121.93186, 36.50242], [-121.93146, 36.50254], [-121.93119, 36.50253], [-121.93114, 36.50254], [-121.93127, 36.50272], [-121.93136, 36.50297], [-121.93161, 36.5032], [-121.93153, 36.50331], [-121.93128, 36.50335], [-121.93096, 36.50323], [-121.93074, 36.50311], [-121.93058, 36.50294], [-121.93043, 36.50283], [-121.93107, 36.50243], [-121.93107, 36.50242], [-121.93099, 36.50237], [-121.93084, 36.50218], [-121.93118, 36.50214], [-121.9312, 36.50217], [-121.9315, 36.50207], [-121.93171, 36.50176], [-121.93173, 36.50144], [-121.93207, 36.50111], [-121.9323, 36.50095], [-121.93268, 36.50063], [-121.93302, 36.50082], [-121.93284, 36.50113], [-121.93333, 36.50126]]]} | Restricted Access 2 | 17207 | Laidlaw-Apte Pine Forest Reserve | 20872 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 4.771 | Laidlaw-Apte Pine Forest 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 | |
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 | |
6790 | 6790 | 6789 | {"type": "Polygon", "coordinates": [[[-122.71333, 38.46711], [-122.71318, 38.46725], [-122.71299, 38.46738], [-122.71145, 38.46737], [-122.71128, 38.46696], [-122.71062, 38.46664], [-122.70973, 38.46649], [-122.7093, 38.46643], [-122.70931, 38.46509], [-122.70982, 38.46538], [-122.70965, 38.46549], [-122.70965, 38.46551], [-122.71007, 38.46572], [-122.7106, 38.46537], [-122.71017, 38.46515], [-122.71023, 38.4651], [-122.71094, 38.46545], [-122.71107, 38.46539], [-122.71143, 38.46574], [-122.71137, 38.46579], [-122.71199, 38.46668], [-122.71288, 38.46701], [-122.71318, 38.46714], [-122.71327, 38.46715], [-122.71333, 38.46711]]]} | Restricted Access 2 | 5292 | Paulin Creek Preserve | 23535 | 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 | 8.962 | Paulin Creek Preserve | 2002 | Local Conservation Area 4 | 2 | |
3134 | 3134 | 3133 | {"type": "Polygon", "coordinates": [[[-118.29541, 33.87454], [-118.2952, 33.87454], [-118.29446, 33.87479], [-118.29448, 33.87492], [-118.29473, 33.87513], [-118.29474, 33.87518], [-118.29465, 33.87522], [-118.29361, 33.87523], [-118.29362, 33.87538], [-118.29214, 33.87542], [-118.29212, 33.87485], [-118.29185, 33.87476], [-118.29157, 33.87464], [-118.29117, 33.8744], [-118.29113, 33.87355], [-118.29311, 33.87358], [-118.29312, 33.87379], [-118.29431, 33.87391], [-118.29431, 33.87396], [-118.2945, 33.87411], [-118.29539, 33.87414], [-118.29541, 33.87454]]]} | Restricted Access 2 | 48035 | Gardena Willows Wetland Preserve | 32528 | 1117 | Gardena, City of 297 | City 2 | City Agency 2 | http://www.ci.gardena.ca.us/ | City 2 | 1117 | Gardena, City of 293 | City 2 | City Agency 2 | Los Angeles 6 | 13.513 | Gardena Willows Wetland Preserve | 0 | 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 | |
3240 | 3240 | 3239 | {"type": "MultiPolygon", "coordinates": [[[[-117.84336, 34.11907], [-117.84316, 34.11904], [-117.84312, 34.11901], [-117.84308, 34.11903], [-117.84303, 34.11903], [-117.84285, 34.11899], [-117.84275, 34.11899], [-117.84267, 34.11902], [-117.84264, 34.11899], [-117.84243, 34.11892], [-117.84247, 34.11891], [-117.84267, 34.11876], [-117.84278, 34.11871], [-117.84336, 34.11907]]], [[[-117.84124, 34.12117], [-117.84054, 34.12118], [-117.84023, 34.12153], [-117.83983, 34.12152], [-117.83911, 34.12117], [-117.83763, 34.12117], [-117.83763, 34.12145], [-117.83677, 34.12145], [-117.83667, 34.12126], [-117.83634, 34.12126], [-117.83592, 34.12145], [-117.8342, 34.12145], [-117.83431, 34.12136], [-117.83509, 34.12132], [-117.83554, 34.12118], [-117.83762, 34.12117], [-117.83763, 34.12112], [-117.8384, 34.12088], [-117.8391, 34.12113], [-117.83912, 34.12094], [-117.83982, 34.12059], [-117.8403, 34.12058], [-117.84046, 34.12015], [-117.84058, 34.11995], [-117.84123, 34.11967], [-117.84124, 34.12117]]], [[[-117.84291, 34.12337], [-117.84251, 34.12387], [-117.8422, 34.12469], [-117.84138, 34.12461], [-117.84124, 34.12468], [-117.84123, 34.12321], [-117.84124, 34.12207], [-117.84207, 34.12207], [-117.84207, 34.12238], [-117.84291, 34.12337]]]]} | Restricted Access 2 | 48130 | South Hills Wilderness Area | 32652 | 1120 | Glendora, City of 76 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 15.74 | South Hills Wilderness Area | 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 | |
9135 | 9135 | 9134 | {"type": "Polygon", "coordinates": [[[-121.8062, 36.9086], [-121.80603, 36.90929], [-121.80576, 36.90997], [-121.80555, 36.91066], [-121.80541, 36.91092], [-121.80506, 36.91124], [-121.8049, 36.9115], [-121.80481, 36.91148], [-121.80472, 36.91147], [-121.80272, 36.91153], [-121.80291, 36.90858], [-121.8062, 36.9086]]]} | Restricted Access 2 | 16765 | Harkins Slough | 28149 | 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 | 20.48 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
14809 | 14809 | 14808 | {"type": "Polygon", "coordinates": [[[-117.14066, 33.25449], [-117.14028, 33.2546], [-117.14032, 33.2547], [-117.14037, 33.25475], [-117.14057, 33.25543], [-117.1406, 33.25571], [-117.14058, 33.2559], [-117.14028, 33.25665], [-117.14037, 33.25683], [-117.13807, 33.25672], [-117.13802, 33.25307], [-117.13827, 33.25307], [-117.13853, 33.25318], [-117.13868, 33.25322], [-117.13897, 33.25337], [-117.13918, 33.25314], [-117.13955, 33.25349], [-117.14011, 33.25382], [-117.14025, 33.25392], [-117.14035, 33.25403], [-117.14066, 33.25449]]]} | Restricted Access 2 | 45227 | Knollwood Preserve | 31493 | 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 | 20.712 | Knollwood Preserve | 0 | Local Conservation Area 4 | 2 | |
11385 | 11385 | 11384 | {"type": "Polygon", "coordinates": [[[-121.17077, 38.75418], [-121.16993, 38.75466], [-121.1697, 38.75468], [-121.16948, 38.75447], [-121.1688, 38.75478], [-121.16876, 38.75502], [-121.16861, 38.7552], [-121.16835, 38.75537], [-121.16788, 38.7554], [-121.16753, 38.75571], [-121.16726, 38.75588], [-121.16716, 38.75623], [-121.16677, 38.75661], [-121.16673, 38.75682], [-121.16613, 38.75708], [-121.16599, 38.75725], [-121.16577, 38.75739], [-121.16555, 38.75728], [-121.16531, 38.75748], [-121.16497, 38.75763], [-121.16483, 38.75781], [-121.16452, 38.75776], [-121.16401, 38.7578], [-121.164, 38.75736], [-121.16404, 38.75718], [-121.16409, 38.75705], [-121.16416, 38.7569], [-121.16436, 38.75666], [-121.16713, 38.75422], [-121.16735, 38.75406], [-121.16907, 38.75301], [-121.17077, 38.75418]]]} | Restricted Access 2 | 22191 | Miners Ravine Nature Reserve | 22264 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 24.569 | Miners Ravine Nature Reserve | 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 | |
2265 | 2265 | 2264 | {"type": "Polygon", "coordinates": [[[-121.80532, 36.92238], [-121.80509, 36.92259], [-121.80524, 36.92344], [-121.80501, 36.92403], [-121.80178, 36.92397], [-121.80168, 36.92488], [-121.80174, 36.92521], [-121.80015, 36.92537], [-121.7999, 36.92535], [-121.79967, 36.92527], [-121.79939, 36.92508], [-121.79917, 36.92485], [-121.79886, 36.92448], [-121.79865, 36.92435], [-121.79847, 36.92427], [-121.79754, 36.92367], [-121.79741, 36.92355], [-121.79735, 36.9234], [-121.79737, 36.92325], [-121.79743, 36.92324], [-121.79754, 36.92291], [-121.79743, 36.92286], [-121.79796, 36.92185], [-121.79855, 36.9219], [-121.80194, 36.92234], [-121.80196, 36.92219], [-121.80529, 36.92225], [-121.80532, 36.92238]]]} | Restricted Access 2 | 16755 | Harkins Slough | 28150 | 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 | 43.338 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
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 | |
15918 | 15918 | 15917 | {"type": "Polygon", "coordinates": [[[-121.85815, 37.22884], [-121.85695, 37.22901], [-121.85587, 37.22908], [-121.85461, 37.22903], [-121.85434, 37.22903], [-121.85412, 37.22913], [-121.85392, 37.22915], [-121.84989, 37.22873], [-121.84963, 37.22856], [-121.84824, 37.2282], [-121.84765, 37.22588], [-121.84714, 37.22428], [-121.84524, 37.22443], [-121.84525, 37.22462], [-121.8443, 37.22466], [-121.84366, 37.22463], [-121.84346, 37.22335], [-121.8435, 37.2233], [-121.84431, 37.22403], [-121.8454, 37.2238], [-121.84606, 37.22367], [-121.84744, 37.22335], [-121.84798, 37.22337], [-121.84832, 37.22282], [-121.84828, 37.22297], [-121.84831, 37.22313], [-121.84837, 37.22323], [-121.84843, 37.22328], [-121.84859, 37.22337], [-121.84801, 37.2235], [-121.84835, 37.22396], [-121.84894, 37.22421], [-121.84983, 37.2247], [-121.84979, 37.22477], [-121.84967, 37.22532], [-121.84947, 37.22559], [-121.84898, 37.22589], [-121.84897, 37.22613], [-121.84915, 37.22614], [-121.84856, 37.22667], [-121.84856, 37.22669], [-121.8501, 37.22725], [-121.85178, 37.22751], [-121.8518, 37.22756], [-121.85275, 37.22781], [-121.85286, 37.22778], [-121.85307, 37.22767], [-121.8534, 37.22777], [-121.85375, 37.2276], [-121.8542, 37.22755], [-121.85524, 37.22754], [-121.85548, 37.22748], [-121.85626, 37.22758], [-121.85664, 37.22779], [-121.8577, 37.22855], [-121.85815, 37.22884]]]} | Restricted Access 2 | 49045 | Santa Teresa Foothills Open Space Preserve | 33751 | 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 | 53.071 | Santa Teresa Foothills OSP | 0 | Local Conservation Area 4 | 2 | |
4 | 4 | 3 | {"type": "Polygon", "coordinates": [[[-120.8183, 37.79059], [-120.81762, 37.7907], [-120.81665, 37.79072], [-120.81597, 37.7907], [-120.81518, 37.79071], [-120.81444, 37.7908], [-120.81354, 37.79068], [-120.81324, 37.79069], [-120.81119, 37.79087], [-120.81012, 37.79017], [-120.80995, 37.78962], [-120.81, 37.78839], [-120.80928, 37.78757], [-120.80991, 37.78733], [-120.81064, 37.78764], [-120.8111, 37.78789], [-120.81169, 37.78776], [-120.81268, 37.78774], [-120.81358, 37.7878], [-120.81565, 37.78787], [-120.81602, 37.78793], [-120.81796, 37.78801], [-120.8183, 37.79059]]]} | Restricted Access 2 | 24 | Stanley Wakefield Wilderness Area | 25790 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 57.379 | Stanley Wakefield Wilderness Area | 0 | 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 |
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]);