units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
39 rows where ACCESS_TYP = 3, AGNCY_LEV = 2 and DES_TP = 3 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY, YR_EST
MNG_AGENCY 24
- Los Angeles - Department of Water and Power, City of 5
- Vacaville, City of 4
- San Diego, City of 3
- Long Beach, City of 3
- Saint Helena, City of 3
- Chico, City of 3
- Los Angeles, City of 1
- Santa Rosa, City of 1
- Oceanside, City of 1
- Escondido, City of 1
- Poway, City of 1
- Petaluma, City of 1
- Santa Monica, City of 1
- San Marcos, City of 1
- Fairfield, City of 1
- Irvine, City of 1
- La Verne, City of 1
- West Covina, City of 1
- Redding, City of 1
- Gilroy, City of 1
- Vallejo, City of 1
- Roseville, City of 1
- Wheatland, City of 1
- Calistoga, City of 1
MNG_AG_TYP 1
- City Agency 39
DES_TP 1
- Local Recreation Area · 39 ✖
ACCESS_TYP 1
- No Public Access · 39 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6300 | 6300 | 6299 | {"type": "Polygon", "coordinates": [[[-122.00948, 38.34308], [-122.00872, 38.34467], [-122.00701, 38.34922], [-122.00683, 38.34903], [-122.00699, 38.34894], [-122.00699, 38.34892], [-122.00674, 38.34867], [-122.00658, 38.34877], [-122.00653, 38.34873], [-122.00669, 38.34811], [-122.00525, 38.34739], [-122.00384, 38.34625], [-122.00365, 38.34649], [-122.00372, 38.3469], [-122.00364, 38.34691], [-122.00347, 38.34659], [-122.00335, 38.3466], [-122.00333, 38.34675], [-122.00313, 38.34708], [-122.00328, 38.34718], [-122.0034, 38.34738], [-122.00345, 38.34758], [-122.00328, 38.34776], [-122.00331, 38.34791], [-122.00325, 38.34817], [-122.00307, 38.34857], [-122.00277, 38.34889], [-122.00279, 38.3491], [-122.00256, 38.34887], [-122.00265, 38.34871], [-122.00284, 38.34855], [-122.00297, 38.34837], [-122.00309, 38.34797], [-122.00303, 38.34764], [-122.00318, 38.34745], [-122.00312, 38.34727], [-122.00301, 38.34719], [-122.00296, 38.34712], [-122.00307, 38.3466], [-122.00299, 38.34644], [-122.00268, 38.34637], [-122.00253, 38.3462], [-122.00226, 38.34601], [-122.00198, 38.34544], [-122.00181, 38.34515], [-122.00175, 38.34498], [-122.00215, 38.34482], [-122.00702, 38.34317], [-122.00825, 38.343], [-122.00928, 38.34317], [-122.00948, 38.34308]]]} | No Public Access 3 | 1417 | Alamo Terrace Open Space | 15323 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 55.193 | Alamo Terrace OS | 2000 | Local Recreation Area 3 | 4 | |
3550 | 3550 | 3549 | {"type": "Polygon", "coordinates": [[[-122.79598, 38.68638], [-122.79593, 38.68645], [-122.79587, 38.68663], [-122.79584, 38.68702], [-122.79582, 38.68712], [-122.79577, 38.68724], [-122.79549, 38.68779], [-122.79545, 38.68786], [-122.79501, 38.68816], [-122.79483, 38.68832], [-122.79478, 38.68849], [-122.79478, 38.68903], [-122.79483, 38.68923], [-122.79486, 38.68944], [-122.79482, 38.68962], [-122.79478, 38.68969], [-122.79471, 38.68978], [-122.79457, 38.68984], [-122.79425, 38.68987], [-122.79372, 38.68983], [-122.79362, 38.68984], [-122.79311, 38.68994], [-122.79276, 38.69005], [-122.79265, 38.69012], [-122.79244, 38.6902], [-122.79194, 38.69034], [-122.79182, 38.69038], [-122.79175, 38.69043], [-122.79171, 38.6905], [-122.79168, 38.69063], [-122.79137, 38.69088], [-122.79073, 38.69135], [-122.79069, 38.69141], [-122.79067, 38.69148], [-122.7907, 38.6916], [-122.79102, 38.69195], [-122.79109, 38.69208], [-122.79115, 38.69228], [-122.79115, 38.69241], [-122.79113, 38.69252], [-122.79101, 38.69282], [-122.79094, 38.6929], [-122.79085, 38.69297], [-122.79052, 38.69312], [-122.79023, 38.69322], [-122.79012, 38.69328], [-122.78934, 38.69224], [-122.78925, 38.6893], [-122.78809, 38.68905], [-122.7847, 38.68871], [-122.78467, 38.68598], [-122.79598, 38.68638]]]} | No Public Access 3 | 28288 | Bear Canyon | 15921 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 98.229 | Bear Canyon | 0 | Local Recreation Area 3 | 4 | |
9526 | 9526 | 9525 | {"type": "Polygon", "coordinates": [[[-122.49213, 38.55407], [-122.4921, 38.55514], [-122.49007, 38.55516], [-122.49014, 38.55796], [-122.49014, 38.55878], [-122.48984, 38.5588], [-122.48659, 38.56392], [-122.48242, 38.5639], [-122.48233, 38.55908], [-122.48077, 38.55917], [-122.48076, 38.55875], [-122.47996, 38.55875], [-122.47995, 38.55606], [-122.48094, 38.55589], [-122.48093, 38.55317], [-122.48554, 38.55315], [-122.48553, 38.55216], [-122.48468, 38.55149], [-122.48316, 38.5515], [-122.48315, 38.55125], [-122.4831, 38.5512], [-122.48307, 38.55064], [-122.48356, 38.55098], [-122.48489, 38.5514], [-122.48496, 38.55146], [-122.48498, 38.55149], [-122.48552, 38.55192], [-122.48553, 38.55191], [-122.48813, 38.55396], [-122.48848, 38.5542], [-122.48872, 38.55429], [-122.48904, 38.55434], [-122.48961, 38.55429], [-122.49008, 38.55422], [-122.49213, 38.55407]]]} | No Public Access 3 | 15982 | Bell Canyon Reservoir | 15971 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 206.019 | Bell Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
16217 | 16217 | 16216 | {"type": "Polygon", "coordinates": [[[-117.14604, 33.16753], [-117.14568, 33.16832], [-117.14568, 33.16839], [-117.14137, 33.16834], [-117.1414, 33.16739], [-117.14061, 33.16658], [-117.14096, 33.16596], [-117.14048, 33.16411], [-117.14004, 33.1621], [-117.14023, 33.16217], [-117.14033, 33.16218], [-117.14079, 33.16211], [-117.1411, 33.1621], [-117.14137, 33.16215], [-117.14156, 33.16223], [-117.14169, 33.16234], [-117.14177, 33.16245], [-117.14184, 33.16259], [-117.14188, 33.16273], [-117.14187, 33.16285], [-117.14183, 33.16297], [-117.14178, 33.16306], [-117.14167, 33.16317], [-117.14168, 33.16329], [-117.14171, 33.1633], [-117.14189, 33.1633], [-117.1421, 33.16337], [-117.14218, 33.16342], [-117.1423, 33.16353], [-117.14243, 33.16362], [-117.14253, 33.16364], [-117.14279, 33.16359], [-117.14292, 33.1636], [-117.14302, 33.16367], [-117.14316, 33.16387], [-117.14335, 33.16399], [-117.14343, 33.16402], [-117.14354, 33.16401], [-117.14409, 33.16385], [-117.14429, 33.16385], [-117.14558, 33.16436], [-117.14574, 33.16445], [-117.14582, 33.16446], [-117.14584, 33.16451], [-117.14584, 33.16519], [-117.14582, 33.16537], [-117.14581, 33.166], [-117.14596, 33.16649], [-117.14598, 33.16664], [-117.14597, 33.16709], [-117.14604, 33.16753]]]} | No Public Access 3 | 44872 | City of Escondido Open Space | 17311 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 63.739 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
16219 | 16219 | 16218 | {"type": "Polygon", "coordinates": [[[-117.17233, 33.2342], [-117.17202, 33.23604], [-117.17189, 33.23648], [-117.17178, 33.23675], [-117.17165, 33.23702], [-117.17032, 33.23703], [-117.1702, 33.23718], [-117.17023, 33.23751], [-117.17011, 33.23751], [-117.16988, 33.23783], [-117.16972, 33.23784], [-117.16977, 33.2384], [-117.16849, 33.23842], [-117.16846, 33.24102], [-117.16803, 33.24124], [-117.16763, 33.24094], [-117.16776, 33.24042], [-117.16769, 33.2402], [-117.16743, 33.23991], [-117.16592, 33.23931], [-117.16579, 33.23935], [-117.16431, 33.23922], [-117.16405, 33.23994], [-117.16386, 33.23992], [-117.16381, 33.23961], [-117.16384, 33.23934], [-117.15908, 33.23938], [-117.15804, 33.23852], [-117.15919, 33.23818], [-117.15945, 33.23775], [-117.15995, 33.23749], [-117.16145, 33.23719], [-117.16196, 33.23581], [-117.1627, 33.23526], [-117.16318, 33.23561], [-117.16327, 33.23494], [-117.16638, 33.23486], [-117.16638, 33.23119], [-117.16608, 33.23118], [-117.16622, 33.2307], [-117.16638, 33.23055], [-117.16638, 33.23112], [-117.16644, 33.23112], [-117.16649, 33.23108], [-117.16651, 33.23101], [-117.16644, 33.23081], [-117.16645, 33.23065], [-117.16653, 33.23046], [-117.16659, 33.23041], [-117.16665, 33.23038], [-117.16671, 33.23037], [-117.16745, 33.2305], [-117.16762, 33.2305], [-117.16779, 33.23047], [-117.1683, 33.23026], [-117.16876, 33.22996], [-117.16893, 33.22982], [-117.16899, 33.22975], [-117.1691, 33.22972], [-117.16919, 33.22975], [-117.1693, 33.22992], [-117.16944, 33.23004], [-117.16958, 33.23012], [-117.16978, 33.23017], [-117.16979, 33.23023], [-117.16989, 33.23025], [-117.16996, 33.23029], [-117.17, 33.23033], [-117.17008, 33.23044], [-117.17016, 33.23051], [-117.17022, 33.23053], [-117.17059, 33.23058], [-117.1706, 33.23248], [-117.17094, 33.2325], [-117.17188, 33.23359], [-117.17209, 33.23384], [-117.17201, 33.23419], [-117.17233, 33.2342]]]} | No Public Access 3 | 44881 | City of Oceanside Open Space | 17323 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 175.69 | City of Oceanside OS | 0 | Local Recreation Area 3 | 4 | |
7819 | 7819 | 7818 | {"type": "Polygon", "coordinates": [[[-117.03972, 33.04402], [-117.03943, 33.0444], [-117.03888, 33.04486], [-117.03845, 33.04501], [-117.03841, 33.04513], [-117.03859, 33.04512], [-117.03865, 33.04535], [-117.03844, 33.04562], [-117.03814, 33.04572], [-117.03826, 33.04578], [-117.03836, 33.04591], [-117.03828, 33.04624], [-117.03818, 33.04641], [-117.03827, 33.04668], [-117.03823, 33.04682], [-117.03792, 33.04698], [-117.03759, 33.047], [-117.03783, 33.04722], [-117.03797, 33.04745], [-117.03789, 33.048], [-117.03771, 33.04806], [-117.0377, 33.04816], [-117.03778, 33.04815], [-117.03782, 33.04825], [-117.03805, 33.04818], [-117.03825, 33.0486], [-117.03828, 33.04894], [-117.03825, 33.04912], [-117.03773, 33.05005], [-117.03685, 33.05007], [-117.03641, 33.0508], [-117.03551, 33.05159], [-117.03526, 33.05167], [-117.03535, 33.05175], [-117.03535, 33.05196], [-117.03492, 33.05207], [-117.03493, 33.05208], [-117.03535, 33.05209], [-117.03564, 33.05265], [-117.03564, 33.05294], [-117.03546, 33.0533], [-117.03525, 33.05341], [-117.03491, 33.05349], [-117.03449, 33.05379], [-117.03405, 33.05399], [-117.03372, 33.05402], [-117.03355, 33.05395], [-117.0332, 33.0535], [-117.03299, 33.0536], [-117.03251, 33.05366], [-117.0322, 33.05358], [-117.0319, 33.05323], [-117.0317, 33.05276], [-117.03172, 33.0526], [-117.03161, 33.05254], [-117.03152, 33.05235], [-117.03142, 33.05222], [-117.03121, 33.05205], [-117.03118, 33.05189], [-117.031, 33.05176], [-117.03082, 33.05168], [-117.03078, 33.05199], [-117.03021, 33.05221], [-117.03018, 33.05235], [-117.03005, 33.05247], [-117.0298, 33.05251], [-117.02974, 33.05266], [-117.02965, 33.05275], [-117.02977, 33.05283], [-117.02994, 33.05303], [-117.02985, 33.05319], [-117.03003, 33.0532], [-117.03029, 33.05356], [-117.02997, 33.05366], [-117.03029, 33.05384], [-117.03015, 33.05422], [-117.02991, 33.05429], [-117.03009, 33.05449], [-117.0301, 33.0548], [-117.02958, 33.05524], [-117.02954, 33.05553], [-117.02843, 33.05665], [-117.02719, 33.05498], [-117.02941, 33.05187], [-117.02865, 33.05038], [-117.02823, 33.05039], [-117.02836, 33.05023], [-117.0285, 33.04996], [-117.02865, 33.04978], [-117.03273, 33.04973], [-117.03274, 33.04972], [-117.0327, 33.04686], [-117.03187, 33.04596], [-117.03187, 33.04407], [-117.0268, 33.04408], [-117.02681, 33.04403], [-117.02936, 33.04402], [-117.02925, 33.04297], [-117.02982, 33.0424], [-117.03205, 33.04177], [-117.03183, 33.03683], [-117.03128, 33.03703], [-117.03115, 33.03705], [-117.03105, 33.03702], [-117.03078, 33.03701], [-117.03029, 33.03705], [-117.03004, 33.03693], [-117.03, 33.03687], [-117.02993, 33.03669], [-117.02962, 33.03636], [-117.0295, 33.03605], [-117.02942, 33.03576], [-117.02934, 33.03565], [-117.02929, 33.03539], [-117.02918, 33.03537], [-117.0287, 33.03495], [-117.02858, 33.03483], [-117.02838, 33.03472], [-117.02919, 33.03406], [-117.02919, 33.03422], [-117.02916, 33.03453], [-117.02944, 33.03467], [-117.03002, 33.03461], [-117.03033, 33.03469], [-117.03025, 33.03518], [-117.02965, 33.03624], [-117.03035, 33.03686], [-117.03087, 33.03678], [-117.03125, 33.0362], [-117.03135, 33.03618], [-117.0315, 33.03609], [-117.03161, 33.03599], [-117.03171, 33.03587], [-117.03179, 33.03561], [-117.03179, 33.03547], [-117.03175, 33.03535], [-117.03168, 33.0352], [-117.03157, 33.03508], [-117.03066, 33.03436], [-117.03054, 33.03421], [-117.03048, 33.03405], [-117.03071, 33.034], [-117.03078, 33.03386], [-117.0313, 33.03387], [-117.03106, 33.03315], [-117.03106, 33.03288], [-117.03202, 33.03289], [-117.03187, 33.03648], [-117.03222, 33.04407], [-117.03972, 33.04402]]]} | No Public Access 3 | 45249 | City of Poway Open Space | 17327 | 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 | 193.801 | City of Poway OS | 0 | Local Recreation Area 3 | 4 | |
3230 | 3230 | 3229 | {"type": "Polygon", "coordinates": [[[-121.43883, 39.01188], [-121.4381, 39.01215], [-121.43774, 39.01233], [-121.43643, 39.01284], [-121.43618, 39.01223], [-121.4364, 39.01219], [-121.43736, 39.01183], [-121.43754, 39.01172], [-121.43786, 39.01164], [-121.43846, 39.01129], [-121.43883, 39.01188]]]} | No Public Access 3 | 22281 | City of Wheatland Open Space | 17335 | 1379 | Wheatland, City of 569 | City 2 | City Agency 2 | http://www.wheatland.ca.gov/ | City 2 | 1379 | Wheatland, City of 561 | City 2 | City Agency 2 | Yuba 25 | 3.704 | City of Wheatland OS | 0 | Local Recreation Area 3 | 4 | |
16227 | 16227 | 16226 | {"type": "Polygon", "coordinates": [[[-117.91283, 34.03821], [-117.91283, 34.03899], [-117.91275, 34.03962], [-117.9127, 34.0399], [-117.91261, 34.04022], [-117.9125, 34.04056], [-117.91237, 34.04089], [-117.91209, 34.04146], [-117.91176, 34.04199], [-117.91145, 34.04239], [-117.91062, 34.04338], [-117.9068, 34.0425], [-117.9068, 34.04242], [-117.90687, 34.04244], [-117.9069, 34.04236], [-117.90686, 34.04212], [-117.90703, 34.04191], [-117.907, 34.04164], [-117.90695, 34.04141], [-117.90686, 34.04117], [-117.90723, 34.04103], [-117.9074, 34.04095], [-117.9077, 34.04076], [-117.90797, 34.04194], [-117.9081, 34.04194], [-117.90836, 34.04217], [-117.90888, 34.0422], [-117.9092, 34.04178], [-117.9092, 34.04176], [-117.90879, 34.04158], [-117.90868, 34.04151], [-117.90863, 34.04145], [-117.90852, 34.04124], [-117.90817, 34.04033], [-117.90908, 34.03917], [-117.90866, 34.0401], [-117.90909, 34.04119], [-117.91045, 34.04181], [-117.91066, 34.04186], [-117.91145, 34.0417], [-117.912, 34.04119], [-117.91214, 34.04079], [-117.91193, 34.04047], [-117.91203, 34.04013], [-117.91245, 34.03993], [-117.91257, 34.03967], [-117.91242, 34.03907], [-117.91225, 34.0388], [-117.91189, 34.03836], [-117.91192, 34.03815], [-117.91215, 34.03816], [-117.91278, 34.03816], [-117.91283, 34.03821]]]} | No Public Access 3 | 45356 | City Open Space | 17340 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | http://www.nlc.org/Documents/Utility%20Navigation/About%20NLC/Awards/2008%20West%20Covina%20Nomination.pdf | Los Angeles 6 | 22.107 | City OS | 0 | Local Recreation Area 3 | 4 |
7194 | 7194 | 7193 | {"type": "Polygon", "coordinates": [[[-118.34172, 34.25537], [-118.34043, 34.2563], [-118.34044, 34.25641], [-118.34035, 34.25673], [-118.34035, 34.25683], [-118.34042, 34.25704], [-118.34042, 34.25714], [-118.34039, 34.2572], [-118.34031, 34.25726], [-118.34008, 34.25733], [-118.34003, 34.25738], [-118.3399, 34.25768], [-118.33994, 34.25797], [-118.33988, 34.25807], [-118.33974, 34.25819], [-118.3397, 34.25824], [-118.33977, 34.25865], [-118.33975, 34.25872], [-118.33969, 34.2588], [-118.33959, 34.25885], [-118.33944, 34.25885], [-118.33898, 34.25859], [-118.3389, 34.25857], [-118.33883, 34.25857], [-118.3382, 34.2587], [-118.3377, 34.25897], [-118.3376, 34.25898], [-118.33701, 34.2589], [-118.3369, 34.25892], [-118.3367, 34.25901], [-118.33652, 34.25903], [-118.33522, 34.25891], [-118.33481, 34.25879], [-118.3345, 34.25867], [-118.33443, 34.25863], [-118.33438, 34.25854], [-118.33438, 34.25848], [-118.33441, 34.25841], [-118.33441, 34.25829], [-118.33439, 34.25817], [-118.33437, 34.25814], [-118.3343, 34.2581], [-118.33423, 34.25811], [-118.33402, 34.25796], [-118.33282, 34.25776], [-118.33176, 34.25745], [-118.33175, 34.25642], [-118.33162, 34.25606], [-118.33187, 34.2553], [-118.33131, 34.25461], [-118.33174, 34.2526], [-118.33464, 34.25337], [-118.34172, 34.25537]]]} | No Public Access 3 | 6842 | Green Verdugo Reservoir | 19469 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 105.007 | Green Verdugo Reservoir | 0 | Local Recreation Area 3 | 4 | |
9527 | 9527 | 9526 | {"type": "Polygon", "coordinates": [[[-122.61605, 38.62512], [-122.61376, 38.62739], [-122.60677, 38.62506], [-122.60683, 38.62492], [-122.60683, 38.62491], [-122.60407, 38.62493], [-122.60408, 38.62146], [-122.59921, 38.62147], [-122.59909, 38.61781], [-122.60673, 38.61786], [-122.61018, 38.6186], [-122.61047, 38.6187], [-122.6109, 38.61796], [-122.61335, 38.61401], [-122.6132, 38.61741], [-122.61476, 38.62026], [-122.61398, 38.62097], [-122.61602, 38.62399], [-122.61605, 38.62512]]]} | No Public Access 3 | 15986 | Kimball Reservoir | 20646 | 1042 | Calistoga, City of 774 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | Napa 11 | 258.548 | Kimball Reservoir | 0 | Local Recreation Area 3 | 4 | |
8174 | 8174 | 8173 | {"type": "Polygon", "coordinates": [[[-117.7567, 34.1363], [-117.75656, 34.13663], [-117.75034, 34.13666], [-117.75036, 34.13633], [-117.7567, 34.1363]]]} | No Public Access 3 | 12354 | Live Oak Reservoir | 21375 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 5.291 | Live Oak Reservoir | 0 | Local Recreation Area 3 | 4 | |
9524 | 9524 | 9523 | {"type": "Polygon", "coordinates": [[[-122.49333, 38.50768], [-122.49296, 38.50786], [-122.49183, 38.50759], [-122.49114, 38.50768], [-122.49113, 38.50772], [-122.49114, 38.50773], [-122.49184, 38.50764], [-122.4929, 38.5079], [-122.49098, 38.5088], [-122.49102, 38.50907], [-122.491, 38.50922], [-122.49111, 38.50939], [-122.49104, 38.50958], [-122.49103, 38.50969], [-122.49109, 38.50985], [-122.49117, 38.50995], [-122.49131, 38.51002], [-122.49138, 38.51015], [-122.49154, 38.5103], [-122.49176, 38.51044], [-122.49192, 38.51051], [-122.492, 38.51069], [-122.49219, 38.51095], [-122.49231, 38.51104], [-122.49215, 38.51106], [-122.49185, 38.51078], [-122.49147, 38.5106], [-122.49134, 38.51062], [-122.49123, 38.51052], [-122.4911, 38.51045], [-122.49096, 38.51045], [-122.49034, 38.5106], [-122.49018, 38.51059], [-122.49018, 38.51015], [-122.49013, 38.50988], [-122.48998, 38.50966], [-122.48996, 38.50957], [-122.48978, 38.5094], [-122.48972, 38.5094], [-122.48965, 38.50949], [-122.48944, 38.50929], [-122.48909, 38.50891], [-122.48809, 38.50959], [-122.48786, 38.50934], [-122.48797, 38.50927], [-122.48838, 38.50825], [-122.4881, 38.50806], [-122.48589, 38.50731], [-122.48671, 38.50627], [-122.48724, 38.50668], [-122.4877, 38.50671], [-122.48799, 38.50689], [-122.4889, 38.50694], [-122.48919, 38.50685], [-122.48964, 38.50654], [-122.48983, 38.50626], [-122.48995, 38.50621], [-122.49019, 38.50616], [-122.49057, 38.50612], [-122.49087, 38.5062], [-122.49088, 38.50637], [-122.4912, 38.50642], [-122.49241, 38.50717], [-122.493, 38.50732], [-122.49333, 38.50768]]]} | No Public Access 3 | 15977 | Lower Reservoir | 21564 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 34.792 | Lower Reservoir | 0 | Local Recreation Area 3 | 4 | |
2283 | 2283 | 2282 | {"type": "Polygon", "coordinates": [[[-121.96736, 38.30157], [-121.96735, 38.30183], [-121.96664, 38.30199], [-121.96611, 38.30257], [-121.96381, 38.307], [-121.96352, 38.30736], [-121.96535, 38.3109], [-121.96492, 38.31134], [-121.96492, 38.31136], [-121.96449, 38.31183], [-121.96352, 38.31397], [-121.96367, 38.31471], [-121.96344, 38.31549], [-121.96158, 38.31549], [-121.95215, 38.31541], [-121.95186, 38.31079], [-121.95186, 38.31055], [-121.95185, 38.31054], [-121.95137, 38.30158], [-121.96736, 38.30157]]]} | No Public Access 3 | 18229 | Noonan Reservoir | 22785 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 428.883 | Noonan Reservoir | 0 | Local Recreation Area 3 | 4 | |
8240 | 8240 | 8239 | {"type": "Polygon", "coordinates": [[[-117.74572, 33.72825], [-117.74394, 33.72809], [-117.74363, 33.72833], [-117.74275, 33.72951], [-117.74213, 33.72985], [-117.74125, 33.72999], [-117.73959, 33.72991], [-117.73823, 33.73051], [-117.73759, 33.73049], [-117.73683, 33.73074], [-117.73669, 33.73143], [-117.73626, 33.73167], [-117.73626, 33.73049], [-117.73616, 33.73036], [-117.736, 33.73031], [-117.7355, 33.73039], [-117.73526, 33.73029], [-117.735, 33.7304], [-117.73438, 33.73044], [-117.73392, 33.73009], [-117.73391, 33.72963], [-117.73427, 33.72935], [-117.73452, 33.72924], [-117.73466, 33.72899], [-117.73493, 33.72868], [-117.73564, 33.72826], [-117.73635, 33.7284], [-117.73709, 33.7284], [-117.73756, 33.72741], [-117.73763, 33.72705], [-117.73785, 33.72703], [-117.73826, 33.72767], [-117.73866, 33.72748], [-117.73948, 33.72717], [-117.74028, 33.7268], [-117.74042, 33.72637], [-117.74062, 33.72625], [-117.74099, 33.72663], [-117.74151, 33.7271], [-117.74225, 33.72701], [-117.74242, 33.72904], [-117.74371, 33.72788], [-117.74569, 33.72796], [-117.74572, 33.72825]]]} | No Public Access 3 | 12575 | Rattlesnake Reservoir | 24196 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 58.86 | Rattlesnake Reservoir | 0 | Local Recreation Area 3 | 4 | |
3822 | 3822 | 3821 | {"type": "MultiPolygon", "coordinates": [[[[-117.16091, 33.13937], [-117.15846, 33.14101], [-117.15822, 33.14036], [-117.15821, 33.14035], [-117.15831, 33.14084], [-117.1584, 33.14105], [-117.15769, 33.14153], [-117.1577, 33.14159], [-117.15715, 33.14168], [-117.15661, 33.14181], [-117.15656, 33.14167], [-117.15663, 33.14161], [-117.15665, 33.14152], [-117.15663, 33.14145], [-117.15659, 33.14141], [-117.15691, 33.14112], [-117.15709, 33.14098], [-117.15796, 33.14043], [-117.16037, 33.13882], [-117.16091, 33.13937]]], [[[-117.16212, 33.13866], [-117.16175, 33.13905], [-117.16107, 33.13923], [-117.1605, 33.13865], [-117.16073, 33.13857], [-117.1615, 33.13836], [-117.16206, 33.1385], [-117.16212, 33.13866]]]]} | No Public Access 3 | 45235 | San Marcos City Open Space | 24944 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 10.993 | San Marcos City OS | 0 | Local Recreation Area 3 | 4 | |
9525 | 9525 | 9524 | {"type": "MultiPolygon", "coordinates": [[[[-122.43837, 38.49699], [-122.43988, 38.49829], [-122.44033, 38.49865], [-122.43614, 38.50173], [-122.43599, 38.50173], [-122.43555, 38.50177], [-122.43473, 38.50177], [-122.4346, 38.50175], [-122.4345, 38.5017], [-122.43442, 38.50161], [-122.43423, 38.50124], [-122.43401, 38.50105], [-122.4339, 38.50097], [-122.4338, 38.50074], [-122.4337, 38.50062], [-122.43318, 38.50009], [-122.43294, 38.49986], [-122.4327, 38.49966], [-122.4325, 38.49925], [-122.43254, 38.49869], [-122.43253, 38.49819], [-122.43249, 38.4981], [-122.4324, 38.49799], [-122.43222, 38.49783], [-122.43211, 38.49776], [-122.43189, 38.49766], [-122.43167, 38.49762], [-122.43154, 38.4976], [-122.43098, 38.49761], [-122.43134, 38.49755], [-122.43134, 38.49754], [-122.43114, 38.49743], [-122.43352, 38.49571], [-122.4369, 38.49338], [-122.43828, 38.49458], [-122.4368, 38.49571], [-122.43837, 38.49699]]], [[[-122.46464, 38.51291], [-122.46285, 38.51541], [-122.46252, 38.5151], [-122.46227, 38.51482], [-122.46185, 38.51443], [-122.46164, 38.51433], [-122.46151, 38.51431], [-122.46109, 38.51427], [-122.46078, 38.51426], [-122.46232, 38.51217], [-122.46227, 38.51226], [-122.46298, 38.51254], [-122.46311, 38.51237], [-122.46464, 38.51291]]]]} | No Public Access 3 | 15980 | St Helena Wastewater Treatment Field | 25762 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 108.217 | St Helena Wastewater Treatment Field | 0 | Local Recreation Area 3 | 4 | |
6218 | 6218 | 6217 | {"type": "Polygon", "coordinates": [[[-122.22564, 38.15293], [-122.22516, 38.15364], [-122.22485, 38.15405], [-122.22462, 38.15394], [-122.22416, 38.15388], [-122.22394, 38.15359], [-122.2239, 38.15324], [-122.22435, 38.15302], [-122.22465, 38.15275], [-122.22491, 38.15266], [-122.22559, 38.15271], [-122.22564, 38.15293]]]} | No Public Access 3 | 1275 | Summit Reservoir | 25968 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 3.617 | Summit Reservoir | 0 | Local Recreation Area 3 | 4 | |
15992 | 15992 | 15991 | {"type": "Polygon", "coordinates": [[[-121.9799, 38.37625], [-121.97978, 38.37626], [-121.97969, 38.37632], [-121.97967, 38.37636], [-121.97967, 38.37641], [-121.97972, 38.3765], [-121.97906, 38.37666], [-121.97898, 38.37672], [-121.97889, 38.3767], [-121.97882, 38.3767], [-121.97877, 38.37672], [-121.97872, 38.37667], [-121.97795, 38.37669], [-121.97733, 38.37393], [-121.97713, 38.37363], [-121.97701, 38.37346], [-121.977, 38.37339], [-121.97718, 38.37325], [-121.97737, 38.37299], [-121.97738, 38.37294], [-121.9774, 38.3729], [-121.97744, 38.37276], [-121.97745, 38.37234], [-121.9775, 38.3723], [-121.97831, 38.37233], [-121.97891, 38.37241], [-121.97913, 38.37242], [-121.97914, 38.37278], [-121.97928, 38.37297], [-121.97928, 38.37308], [-121.9793, 38.37312], [-121.97931, 38.37328], [-121.97934, 38.37343], [-121.97935, 38.37375], [-121.97943, 38.3738], [-121.97942, 38.37399], [-121.97936, 38.37423], [-121.97943, 38.37455], [-121.97952, 38.37459], [-121.9795, 38.37467], [-121.97953, 38.37474], [-121.97948, 38.37477], [-121.97954, 38.37506], [-121.97976, 38.37535], [-121.97972, 38.3754], [-121.97972, 38.37545], [-121.97975, 38.37551], [-121.97981, 38.37556], [-121.9798, 38.37594], [-121.9799, 38.37625]]]} | No Public Access 3 | 1305 | Sunrise Woodcrest Open Space | 26039 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 20.516 | Sunrise Woodcrest OS | 0 | Local Recreation Area 3 | 4 | |
16198 | 16198 | 16197 | {"type": "MultiPolygon", "coordinates": [[[[-121.34941, 38.79537], [-121.34798, 38.79538], [-121.34717, 38.79574], [-121.34689, 38.7957], [-121.3466, 38.79572], [-121.34636, 38.79581], [-121.34598, 38.79589], [-121.34575, 38.79591], [-121.34553, 38.79633], [-121.34539, 38.79642], [-121.34546, 38.79651], [-121.34533, 38.79656], [-121.34503, 38.79653], [-121.34482, 38.79647], [-121.34463, 38.79639], [-121.3443, 38.79618], [-121.34403, 38.79595], [-121.34386, 38.79578], [-121.34362, 38.79541], [-121.34649, 38.79539], [-121.34649, 38.79424], [-121.34613, 38.79383], [-121.34831, 38.79267], [-121.34883, 38.79244], [-121.3494, 38.79224], [-121.34941, 38.79537]]], [[[-121.35801, 38.79652], [-121.35705, 38.79746], [-121.35665, 38.79764], [-121.35666, 38.79765], [-121.35697, 38.79762], [-121.35696, 38.79774], [-121.35703, 38.79776], [-121.35705, 38.7978], [-121.35693, 38.79835], [-121.35683, 38.79867], [-121.35669, 38.79897], [-121.35642, 38.79941], [-121.35463, 38.7994], [-121.35463, 38.79941], [-121.3554, 38.80031], [-121.35405, 38.80103], [-121.35391, 38.8008], [-121.35328, 38.79965], [-121.3533, 38.7996], [-121.35353, 38.79945], [-121.35364, 38.79932], [-121.35372, 38.79919], [-121.35377, 38.79905], [-121.35364, 38.79904], [-121.35357, 38.7992], [-121.35348, 38.79933], [-121.35336, 38.79943], [-121.35313, 38.79954], [-121.35287, 38.7996], [-121.35269, 38.7996], [-121.35251, 38.79957], [-121.35235, 38.79951], [-121.35213, 38.79937], [-121.35199, 38.79919], [-121.35172, 38.79852], [-121.35169, 38.79835], [-121.35168, 38.79824], [-121.35161, 38.79817], [-121.3515, 38.79816], [-121.35015, 38.79832], [-121.3494, 38.79846], [-121.34939, 38.7984], [-121.3487, 38.79854], [-121.34812, 38.79871], [-121.34791, 38.79878], [-121.34731, 38.79909], [-121.34697, 38.79912], [-121.34689, 38.79916], [-121.34667, 38.79889], [-121.34614, 38.79806], [-121.34599, 38.79788], [-121.34656, 38.79754], [-121.34683, 38.79753], [-121.34706, 38.79734], [-121.34744, 38.79725], [-121.34749, 38.79719], [-121.3479, 38.79713], [-121.34798, 38.79701], [-121.34794, 38.79683], [-121.348, 38.79653], [-121.34805, 38.79653], [-121.34824, 38.79633], [-121.34851, 38.79618], [-121.34862, 38.796], [-121.34879, 38.79586], [-121.34941, 38.79566], [-121.34942, 38.79647], [-121.35801, 38.79652]]], [[[-121.3539, 38.80109], [-121.35254, 38.80165], [-121.35206, 38.80044], [-121.35202, 38.80031], [-121.35203, 38.80017], [-121.35208, 38.80001], [-121.35231, 38.79968], [-121.35239, 38.79965], [-121.35266, 38.7997], [-121.35285, 38.7997], [-121.35306, 38.79968], [-121.35311, 38.7997], [-121.35375, 38.80085], [-121.3539, 38.80109]]]]} | No Public Access 3 | 29577 | Veterans Memorial Park Open Space | 27036 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 95.757 | Veterans Memorial Park OS | 0 | Local Recreation Area 3 | 4 | |
13173 | 13173 | 13172 | {"type": "MultiPolygon", "coordinates": [[[[-122.58307, 38.22933], [-122.58238, 38.23007], [-122.57621, 38.22666], [-122.57633, 38.22647], [-122.57659, 38.22629], [-122.57685, 38.22617], [-122.5772, 38.22588], [-122.57777, 38.22573], [-122.57799, 38.2256], [-122.57872, 38.22483], [-122.57915, 38.22443], [-122.58083, 38.22535], [-122.58089, 38.22576], [-122.5804, 38.22629], [-122.58131, 38.22682], [-122.58105, 38.22709], [-122.58105, 38.22711], [-122.5828, 38.22811], [-122.58307, 38.22933]]], [[[-122.59172, 38.21766], [-122.59033, 38.21764], [-122.58878, 38.21814], [-122.58712, 38.21833], [-122.58596, 38.21827], [-122.58479, 38.21783], [-122.58391, 38.21714], [-122.58327, 38.21602], [-122.58331, 38.21486], [-122.58381, 38.21407], [-122.58571, 38.2127], [-122.58639, 38.21185], [-122.58784, 38.2134], [-122.59172, 38.21766]]]]} | No Public Access 3 | 35157 | Petaluma Marsh Acquisition, Enhancement and Access | 28158 | 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 | 112.939 | Petaluma Marsh Acquisition, Enhancement and Access | 0 | Local Recreation Area 3 | 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]);