units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
MNG_AGENCY >30
- San Diego, City of 533
- Los Angeles, City of 491
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 101
- Fresno, City of 95
- Modesto, City of 85
- Santa Rosa, City of 83
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Torrance, City of 73
- Tracy, City of 73
- Santa Cruz, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- San Luis Obispo, City of 66
- Newport Beach, City of 65
- Davis, City of 65
- Santa Barbara, City of 64
- Clovis, City of 62
- Glendale, City of 61
- Riverside, City of 61
- Bakersfield, City of 61
- …
ACCESS_TYP 4
- Open Access 9,925
- Restricted Access 363
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,524 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5409 | 5409 | 5408 | {"type": "Polygon", "coordinates": [[[-122.70929, 38.32421], [-122.70932, 38.32439], [-122.70925, 38.32488], [-122.70801, 38.32535], [-122.70789, 38.32522], [-122.70819, 38.32474], [-122.70777, 38.32462], [-122.70797, 38.32381], [-122.70929, 38.32421]]]} | Open Access 1 | 49080 | Falleti Ranch | 33781 | 1072 | Cotati, City of 356 | City 2 | City Agency 2 | http://www.ci.cotati.ca.us/ | City 2 | 1072 | Cotati, City of 353 | City 2 | City Agency 2 | Sonoma 16 | 3.618 | Falleti Ranch | 0 | Local Park 2 | 4 | |
16940 | 16940 | 16939 | {"type": "Polygon", "coordinates": [[[-122.84377, 38.62226], [-122.84368, 38.6223], [-122.84358, 38.62231], [-122.84251, 38.62232], [-122.84195, 38.62227], [-122.84194, 38.62237], [-122.84211, 38.62239], [-122.84209, 38.62266], [-122.84173, 38.62262], [-122.84146, 38.62261], [-122.84145, 38.62289], [-122.84092, 38.62291], [-122.83988, 38.62287], [-122.83935, 38.62288], [-122.83932, 38.62261], [-122.8385, 38.62264], [-122.83877, 38.62224], [-122.83884, 38.62226], [-122.83889, 38.62219], [-122.83906, 38.62227], [-122.83918, 38.62227], [-122.83929, 38.62204], [-122.83907, 38.62196], [-122.83888, 38.62178], [-122.83872, 38.62157], [-122.83862, 38.6215], [-122.83849, 38.62145], [-122.83831, 38.62145], [-122.83813, 38.62151], [-122.83803, 38.62158], [-122.83775, 38.62188], [-122.83708, 38.62147], [-122.83713, 38.62062], [-122.83543, 38.62019], [-122.83495, 38.61921], [-122.83414, 38.61931], [-122.83411, 38.61939], [-122.83377, 38.61963], [-122.83329, 38.61974], [-122.83322, 38.61978], [-122.8331, 38.61987], [-122.83305, 38.61997], [-122.833, 38.62003], [-122.83241, 38.62041], [-122.83109, 38.62042], [-122.83098, 38.62033], [-122.83122, 38.61983], [-122.83154, 38.61989], [-122.83171, 38.61933], [-122.83183, 38.61844], [-122.83043, 38.6186], [-122.82999, 38.61855], [-122.82945, 38.61845], [-122.82937, 38.61872], [-122.8289, 38.61905], [-122.82851, 38.61911], [-122.82849, 38.6189], [-122.82854, 38.61876], [-122.82855, 38.61869], [-122.82859, 38.61857], [-122.82858, 38.61856], [-122.82873, 38.61827], [-122.82913, 38.61772], [-122.82916, 38.61763], [-122.82917, 38.61752], [-122.8292, 38.61746], [-122.82925, 38.61741], [-122.82949, 38.61732], [-122.83004, 38.61777], [-122.83039, 38.61772], [-122.83069, 38.61762], [-122.8307, 38.61761], [-122.83059, 38.61749], [-122.83074, 38.61742], [-122.83076, 38.61743], [-122.83097, 38.6173], [-122.83121, 38.61714], [-122.83145, 38.61694], [-122.83144, 38.61693], [-122.83122, 38.61677], [-122.83151, 38.61647], [-122.83123, 38.61632], [-122.83145, 38.61601], [-122.83254, 38.6164], [-122.83256, 38.61587], [-122.83507, 38.61554], [-122.83573, 38.61541], [-122.83587, 38.61568], [-122.83646, 38.61567], [-122.8367, 38.61612], [-122.83795, 38.61568], [-122.83876, 38.61654], [-122.83923, 38.61678], [-122.84085, 38.61657], [-122.84112, 38.61639], [-122.84178, 38.61646], [-122.8423, 38.61692], [-122.84344, 38.61729], [-122.84328, 38.62056], [-122.8473, 38.62055], [-122.84721, 38.62384], [-122.84713, 38.62377], [-122.84704, 38.62359], [-122.84697, 38.62351], [-122.84687, 38.62346], [-122.84648, 38.62335], [-122.84634, 38.62325], [-122.84626, 38.62314], [-122.84624, 38.62309], [-122.84622, 38.62297], [-122.84623, 38.62286], [-122.84622, 38.6228], [-122.84618, 38.62273], [-122.84611, 38.62269], [-122.84603, 38.62266], [-122.8459, 38.62267], [-122.84547, 38.62287], [-122.84526, 38.62288], [-122.84489, 38.62269], [-122.84456, 38.62257], [-122.84453, 38.62252], [-122.84477, 38.62231], [-122.84469, 38.62216], [-122.84439, 38.62229], [-122.84433, 38.62204], [-122.84427, 38.62197], [-122.84443, 38.62173], [-122.84426, 38.62168], [-122.84407, 38.62168], [-122.84393, 38.62173], [-122.84411, 38.62196], [-122.84386, 38.62221], [-122.84377, 38.62226]]]} | Open Access 1 | 49079 | Fitch Mountain Park Open Space Preserve | 33780 | 1131 | Healdsburg, City of 374 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | Sonoma 16 | 171.489 | Fitch Mtn. Park OSP | 0 | Local Conservation Area 4 | 2 | |
15695 | 15695 | 15694 | {"type": "Polygon", "coordinates": [[[-114.6039, 34.84393], [-114.60287, 34.84392], [-114.60287, 34.84339], [-114.6039, 34.84339], [-114.6039, 34.84393]]]} | Restricted Access 2 | 49074 | River's Edge Golf Course | 33774 | 2442 | Needles Unified School District 1161 | Special District 4 | School District 14 | https://www.needlesusd.org/ | Special District 4 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/services/rivers-edge-golf-course/ | San Bernardino 22 | 1.368 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
15694 | 15694 | 15693 | {"type": "MultiPolygon", "coordinates": [[[[-114.59631, 34.83806], [-114.59532, 34.8382], [-114.59333, 34.83773], [-114.59314, 34.83745], [-114.59314, 34.83673], [-114.5963, 34.83674], [-114.59631, 34.83806]]], [[[-114.60879, 34.84488], [-114.60852, 34.8454], [-114.60833, 34.84593], [-114.60824, 34.84638], [-114.60823, 34.84658], [-114.60825, 34.8468], [-114.60778, 34.84648], [-114.60754, 34.84688], [-114.60715, 34.84743], [-114.60698, 34.84729], [-114.60687, 34.8471], [-114.60647, 34.84618], [-114.60512, 34.84673], [-114.60511, 34.84524], [-114.60412, 34.84467], [-114.60242, 34.84401], [-114.60072, 34.844], [-114.60071, 34.84499], [-114.5989, 34.84409], [-114.59705, 34.84221], [-114.5969, 34.84233], [-114.59669, 34.84219], [-114.59631, 34.84203], [-114.59631, 34.8404], [-114.59716, 34.8404], [-114.59716, 34.84053], [-114.59733, 34.84053], [-114.59733, 34.84108], [-114.59825, 34.84108], [-114.59834, 34.84113], [-114.59835, 34.84131], [-114.59868, 34.84131], [-114.59868, 34.84164], [-114.59919, 34.84164], [-114.59919, 34.84197], [-114.59953, 34.84197], [-114.59953, 34.84219], [-114.59986, 34.84219], [-114.59987, 34.84275], [-114.60054, 34.84275], [-114.60055, 34.84276], [-114.60071, 34.84276], [-114.60071, 34.84321], [-114.60104, 34.84322], [-114.60125, 34.84339], [-114.60143, 34.84349], [-114.60269, 34.84401], [-114.60324, 34.84401], [-114.60415, 34.8444], [-114.6051, 34.84467], [-114.60511, 34.84466], [-114.60511, 34.84402], [-114.60767, 34.84403], [-114.60747, 34.84454], [-114.60879, 34.84488]]], [[[-114.59892, 34.841], [-114.59892, 34.84108], [-114.59868, 34.84108], [-114.59868, 34.84053], [-114.59885, 34.84052], [-114.59885, 34.84099], [-114.59892, 34.841]]], [[[-114.60348, 34.84339], [-114.60288, 34.84339], [-114.60287, 34.84369], [-114.60243, 34.84369], [-114.60193, 34.84348], [-114.60182, 34.84348], [-114.60181, 34.84336], [-114.60171, 34.84336], [-114.60138, 34.84319], [-114.60137, 34.84286], [-114.60113, 34.84285], [-114.60113, 34.84229], [-114.60171, 34.8423], [-114.60172, 34.84285], [-114.60251, 34.84286], [-114.60252, 34.84339], [-114.6026, 34.84338], [-114.6026, 34.84286], [-114.60348, 34.84286], [-114.60348, 34.84339]]], [[[-114.6039, 34.84339], [-114.60365, 34.84339], [-114.60365, 34.84286], [-114.6039, 34.84286], [-114.6039, 34.84339]]], [[[-114.60465, 34.84393], [-114.60448, 34.84393], [-114.60448, 34.84342], [-114.60465, 34.84343], [-114.60465, 34.84393]]], [[[-114.60626, 34.84312], [-114.60622, 34.84306], [-114.60616, 34.84313], [-114.60616, 34.84314], [-114.60619, 34.84314], [-114.60616, 34.84317], [-114.60563, 34.84292], [-114.60626, 34.84292], [-114.60626, 34.84312]]], [[[-114.60802, 34.84359], [-114.60776, 34.84394], [-114.60719, 34.84367], [-114.60718, 34.84368], [-114.60718, 34.84394], [-114.60701, 34.84394], [-114.60701, 34.84358], [-114.60642, 34.8433], [-114.60642, 34.84294], [-114.60648, 34.84286], [-114.60802, 34.84359]]]]} | Restricted Access 2 | 49072 | River's Edge Golf Course | 33774 | 1220 | Needles, City of 280 | City 2 | City Agency 2 | http://www.cityofneedles.com/Pages/Departments-Services/Parks/Parks.html | City 2 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/services/rivers-edge-golf-course/ | San Bernardino 22 | 64.614 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
10390 | 10390 | 10389 | {"type": "MultiPolygon", "coordinates": [[[[-114.59933, 34.8403], [-114.59817, 34.8403], [-114.59816, 34.8402], [-114.5974, 34.8402], [-114.59631, 34.83958], [-114.5963, 34.83674], [-114.59756, 34.83674], [-114.59859, 34.8376], [-114.59933, 34.83869], [-114.59933, 34.8403]]], [[[-114.60795, 34.84404], [-114.60512, 34.84402], [-114.60511, 34.84467], [-114.60415, 34.8444], [-114.60324, 34.84401], [-114.60287, 34.84401], [-114.60287, 34.84392], [-114.6039, 34.84392], [-114.6039, 34.84287], [-114.60365, 34.84287], [-114.60365, 34.84339], [-114.60348, 34.84339], [-114.60348, 34.84286], [-114.6026, 34.84286], [-114.6026, 34.84339], [-114.60251, 34.84339], [-114.60251, 34.84286], [-114.60171, 34.84285], [-114.60171, 34.8423], [-114.60114, 34.84229], [-114.60113, 34.84294], [-114.60104, 34.84294], [-114.60104, 34.84285], [-114.60095, 34.84285], [-114.60095, 34.84276], [-114.60071, 34.84255], [-114.60071, 34.84219], [-114.6002, 34.84219], [-114.6002, 34.84197], [-114.60003, 34.84197], [-114.60003, 34.84164], [-114.59969, 34.84163], [-114.59969, 34.84108], [-114.59892, 34.84108], [-114.59891, 34.841], [-114.59885, 34.841], [-114.59885, 34.84052], [-114.59986, 34.84052], [-114.59987, 34.84029], [-114.60042, 34.84029], [-114.60048, 34.84038], [-114.60071, 34.84038], [-114.60071, 34.84051], [-114.6002, 34.84053], [-114.6002, 34.84107], [-114.60054, 34.84107], [-114.60055, 34.8417], [-114.60312, 34.84171], [-114.60701, 34.84358], [-114.60702, 34.84394], [-114.60717, 34.84394], [-114.60718, 34.84366], [-114.60795, 34.84404]], [[-114.60449, 34.84342], [-114.60448, 34.84392], [-114.60464, 34.84393], [-114.60465, 34.84343], [-114.60449, 34.84342]]], [[[-114.60513, 34.84766], [-114.60318, 34.84764], [-114.60299, 34.84743], [-114.60187, 34.84686], [-114.60072, 34.84634], [-114.60071, 34.844], [-114.60242, 34.84401], [-114.60412, 34.84467], [-114.60511, 34.84523], [-114.60513, 34.84766]]]]} | Restricted Access 2 | 49071 | River's Edge Golf Course | 33774 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/services/rivers-edge-golf-course/ | San Bernardino 22 | 77.93 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
10074 | 10074 | 10073 | {"type": "Polygon", "coordinates": [[[-121.26493, 38.83074], [-121.26429, 38.83085], [-121.26318, 38.83041], [-121.26364, 38.82968], [-121.26371, 38.82953], [-121.26376, 38.8292], [-121.26378, 38.82917], [-121.26384, 38.82915], [-121.26484, 38.82927], [-121.2648, 38.82959], [-121.2648, 38.83], [-121.26485, 38.8304], [-121.26493, 38.83074]]]} | Open Access 1 | 49036 | Willard Park | 33743 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 4.813 | Willard Park | 2019 | Local Park 2 | 4 | |
10073 | 10073 | 10072 | {"type": "Polygon", "coordinates": [[[-121.28222, 38.81572], [-121.28171, 38.81595], [-121.28168, 38.81588], [-121.28158, 38.8158], [-121.28132, 38.81542], [-121.28105, 38.81507], [-121.28097, 38.81499], [-121.28084, 38.81488], [-121.2808, 38.81481], [-121.28072, 38.81477], [-121.28065, 38.81477], [-121.28057, 38.81481], [-121.28053, 38.81488], [-121.28047, 38.81488], [-121.28041, 38.8148], [-121.28124, 38.81442], [-121.28222, 38.81572]]]} | Open Access 1 | 49035 | Wickman Park | 33742 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.226 | Wickman Park | 2017 | Local Park 2 | 4 | |
16813 | 16813 | 16812 | {"type": "MultiPolygon", "coordinates": [[[[-121.24935, 38.79757], [-121.24887, 38.7976], [-121.24888, 38.79736], [-121.24862, 38.79729], [-121.2486, 38.79701], [-121.24788, 38.79639], [-121.24756, 38.79629], [-121.24638, 38.79603], [-121.24591, 38.79611], [-121.24558, 38.79621], [-121.24526, 38.79664], [-121.24512, 38.79694], [-121.24485, 38.79709], [-121.24378, 38.7975], [-121.24094, 38.79876], [-121.24094, 38.79877], [-121.24112, 38.79902], [-121.24073, 38.79922], [-121.24054, 38.79896], [-121.23974, 38.79931], [-121.23958, 38.79911], [-121.23981, 38.7985], [-121.23945, 38.79817], [-121.2406, 38.79786], [-121.24375, 38.79649], [-121.2443, 38.79581], [-121.24429, 38.7958], [-121.2442, 38.7958], [-121.24484, 38.79531], [-121.24604, 38.79445], [-121.24636, 38.79473], [-121.24652, 38.79518], [-121.24729, 38.79541], [-121.2479, 38.79543], [-121.24805, 38.79534], [-121.24878, 38.79605], [-121.24909, 38.79654], [-121.24928, 38.79708], [-121.24934, 38.79735], [-121.24935, 38.79757]]], [[[-121.25255, 38.7998], [-121.25223, 38.80002], [-121.25251, 38.80029], [-121.25098, 38.80127], [-121.24815, 38.80405], [-121.24782, 38.80431], [-121.24743, 38.80455], [-121.24494, 38.8056], [-121.24452, 38.80574], [-121.24407, 38.80574], [-121.24396, 38.80605], [-121.24361, 38.80596], [-121.2433, 38.80581], [-121.24304, 38.80562], [-121.24284, 38.80538], [-121.24271, 38.80511], [-121.24237, 38.80408], [-121.24228, 38.80386], [-121.24216, 38.80366], [-121.242, 38.80347], [-121.24184, 38.80331], [-121.24168, 38.80319], [-121.24194, 38.80296], [-121.24086, 38.80233], [-121.24045, 38.80189], [-121.24021, 38.80132], [-121.24015, 38.8003], [-121.24006, 38.80006], [-121.24075, 38.79973], [-121.24057, 38.79946], [-121.24109, 38.79923], [-121.24126, 38.79947], [-121.24142, 38.79983], [-121.24149, 38.80031], [-121.24174, 38.80044], [-121.24236, 38.80036], [-121.24253, 38.80015], [-121.2423, 38.79946], [-121.2421, 38.79913], [-121.24418, 38.79821], [-121.24535, 38.79776], [-121.24594, 38.79761], [-121.24654, 38.79765], [-121.2474, 38.79783], [-121.24743, 38.79896], [-121.24579, 38.79935], [-121.24484, 38.79916], [-121.24397, 38.7995], [-121.244, 38.80063], [-121.24357, 38.80114], [-121.24342, 38.80191], [-121.24445, 38.80209], [-121.24565, 38.80187], [-121.24573, 38.80237], [-121.24541, 38.80249], [-121.24543, 38.80279], [-121.24583, 38.80285], [-121.2465, 38.80259], [-121.24734, 38.80186], [-121.24764, 38.80162], [-121.24906, 38.80072], [-121.24952, 38.80026], [-121.25005, 38.79988], [-121.2504, 38.79967], [-121.25064, 38.79948], [-121.25112, 38.799], [-121.25148, 38.79878], [-121.25255, 38.7998]]], [[[-121.26336, 38.7949], [-121.26216, 38.79573], [-121.26081, 38.79691], [-121.25822, 38.79824], [-121.25393, 38.79935], [-121.25344, 38.79967], [-121.25314, 38.79939], [-121.25282, 38.7996], [-121.25177, 38.7986], [-121.2521, 38.7984], [-121.25393, 38.79763], [-121.25471, 38.79763], [-121.25541, 38.7972], [-121.25571, 38.79678], [-121.25665, 38.79627], [-121.25694, 38.7964], [-121.25724, 38.79647], [-121.25756, 38.79649], [-121.25786, 38.79645], [-121.25816, 38.79633], [-121.25931, 38.79573], [-121.25953, 38.79557], [-121.26037, 38.79477], [-121.26072, 38.7945], [-121.26198, 38.79366], [-121.26336, 38.7949]]]]} | Open Access 1 | 49034 | Sunset Whitney Recreation Area | 33741 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | https://www.rocklin.ca.us/news/west-trails-sunset-whitney-rec-area-now-open | Placer 35 | 178.722 | Sunset Whitney Rec. Area | 2018 | Local Recreation Area 3 | 4 |
5476 | 5476 | 5475 | {"type": "MultiPolygon", "coordinates": [[[[-121.20025, 38.80451], [-121.20011, 38.80463], [-121.19978, 38.80457], [-121.19988, 38.80436], [-121.19994, 38.80433], [-121.19999, 38.80435], [-121.20025, 38.80451]]], [[[-121.20098, 38.80218], [-121.20095, 38.80387], [-121.20031, 38.80445], [-121.20003, 38.80428], [-121.20002, 38.80423], [-121.2001, 38.80415], [-121.20041, 38.80395], [-121.20055, 38.80383], [-121.20068, 38.80368], [-121.20079, 38.80349], [-121.20086, 38.8033], [-121.2009, 38.8031], [-121.20093, 38.80218], [-121.20098, 38.80218]]]]} | Open Access 1 | 49032 | Christine Anderson Park | 33734 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.247 | Christine Anderson Park | 2018 | Local Park 2 | 4 | |
10053 | 10053 | 10052 | {"type": "Polygon", "coordinates": [[[-121.23986, 38.78689], [-121.23937, 38.78755], [-121.23887, 38.78744], [-121.23925, 38.78697], [-121.23913, 38.7869], [-121.23934, 38.78663], [-121.23986, 38.78689]]]} | Open Access 1 | 49028 | Deer Creek Park | 33729 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.051 | Deer Creek Park | 0 | Local Park 2 | 4 | |
10052 | 10052 | 10051 | {"type": "Polygon", "coordinates": [[[-121.2806, 38.8345], [-121.2806, 38.83473], [-121.28056, 38.83502], [-121.28025, 38.83498], [-121.28023, 38.83503], [-121.2799, 38.83498], [-121.27959, 38.83491], [-121.27928, 38.83482], [-121.27948, 38.83453], [-121.27856, 38.83415], [-121.27835, 38.83443], [-121.27754, 38.83414], [-121.27771, 38.83382], [-121.27721, 38.83365], [-121.27696, 38.83359], [-121.27685, 38.83363], [-121.27616, 38.8336], [-121.27605, 38.83389], [-121.2758, 38.83384], [-121.27561, 38.8339], [-121.27557, 38.83384], [-121.27549, 38.8338], [-121.27557, 38.83355], [-121.27553, 38.8335], [-121.27455, 38.83342], [-121.27431, 38.83343], [-121.27408, 38.83347], [-121.27385, 38.83353], [-121.27315, 38.83378], [-121.27279, 38.83383], [-121.27279, 38.83413], [-121.27239, 38.83417], [-121.2703, 38.83454], [-121.27029, 38.8345], [-121.27092, 38.83433], [-121.27114, 38.83421], [-121.27181, 38.83408], [-121.27269, 38.8337], [-121.27304, 38.83368], [-121.27321, 38.83342], [-121.27367, 38.83342], [-121.27472, 38.83329], [-121.2752, 38.83321], [-121.27569, 38.83345], [-121.27759, 38.83348], [-121.27893, 38.83392], [-121.28017, 38.83423], [-121.28034, 38.83441], [-121.28052, 38.83452], [-121.2806, 38.8345]]]} | Open Access 1 | 49027 | Pernu Park Trails | 33728 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 7.897 | Pernu Park Trails | None 868 | |||
10048 | 10048 | 10047 | {"type": "Polygon", "coordinates": [[[-121.2703, 38.83454], [-121.26942, 38.8347], [-121.26937, 38.83469], [-121.26934, 38.83466], [-121.26929, 38.83449], [-121.26927, 38.83431], [-121.26928, 38.83413], [-121.26933, 38.83395], [-121.26946, 38.83369], [-121.26958, 38.83354], [-121.26973, 38.8334], [-121.26991, 38.83353], [-121.27003, 38.83373], [-121.26979, 38.8341], [-121.26993, 38.83424], [-121.26995, 38.83444], [-121.27029, 38.8345], [-121.2703, 38.83454]]]} | Open Access 1 | 49026 | Pernu Park | 33727 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.676 | Pernu Park | 0 | Local Park 2 | 4 | |
9389 | 9389 | 9388 | {"type": "Polygon", "coordinates": [[[-118.83657, 34.29536], [-118.83657, 34.29613], [-118.8359, 34.29629], [-118.83565, 34.29638], [-118.83538, 34.29651], [-118.83513, 34.29664], [-118.83522, 34.29677], [-118.83504, 34.29686], [-118.83492, 34.29671], [-118.83413, 34.29688], [-118.8339, 34.2969], [-118.83353, 34.2969], [-118.83327, 34.29693], [-118.83302, 34.297], [-118.83262, 34.29715], [-118.83211, 34.29728], [-118.83196, 34.29734], [-118.83183, 34.29745], [-118.83165, 34.29778], [-118.83188, 34.29808], [-118.83255, 34.298], [-118.83327, 34.29778], [-118.83446, 34.29787], [-118.83274, 34.29841], [-118.83204, 34.29848], [-118.83186, 34.29882], [-118.83129, 34.29939], [-118.83094, 34.29989], [-118.83057, 34.29987], [-118.83049, 34.29994], [-118.83047, 34.30022], [-118.83058, 34.30062], [-118.83067, 34.30074], [-118.82259, 34.30074], [-118.82259, 34.30255], [-118.82044, 34.30255], [-118.82087, 34.30152], [-118.82109, 34.30001], [-118.82101, 34.29947], [-118.8199, 34.29764], [-118.81979, 34.29703], [-118.82033, 34.29642], [-118.82099, 34.29625], [-118.82168, 34.29571], [-118.8224, 34.295], [-118.82239, 34.2945], [-118.82176, 34.29316], [-118.82145, 34.29225], [-118.82257, 34.29252], [-118.82372, 34.29312], [-118.82398, 34.29306], [-118.82412, 34.29333], [-118.82471, 34.29332], [-118.82458, 34.29376], [-118.82506, 34.29392], [-118.82574, 34.29357], [-118.82549, 34.29323], [-118.82667, 34.29253], [-118.82714, 34.29282], [-118.82887, 34.29263], [-118.82958, 34.29264], [-118.83004, 34.29268], [-118.83041, 34.29261], [-118.83076, 34.2928], [-118.8321, 34.29285], [-118.83367, 34.29329], [-118.83395, 34.29385], [-118.83449, 34.29436], [-118.8355, 34.29416], [-118.8361, 34.29363], [-118.83645, 34.29381], [-118.83655, 34.29426], [-118.83646, 34.29535], [-118.83657, 34.29536]], [[-118.8311, 34.29578], [-118.8312, 34.29585], [-118.83136, 34.29587], [-118.83178, 34.29553], [-118.8313, 34.2952], [-118.83078, 34.29555], [-118.8311, 34.29578]]]} | Open Access 1 | 49013 | City of Moorpark Open Space | 33711 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 255.937 | City of Moorpark OS | 0 | Local Recreation Area 3 | 4 | |
16941 | 16941 | 16940 | {"type": "Polygon", "coordinates": [[[-121.01989, 39.27479], [-121.01983, 39.27487], [-121.01977, 39.2748], [-121.01976, 39.27463], [-121.01928, 39.27479], [-121.01908, 39.27487], [-121.01905, 39.27479], [-121.01644, 39.27477], [-121.01641, 39.27463], [-121.01629, 39.27443], [-121.01618, 39.27431], [-121.01604, 39.27421], [-121.0159, 39.27409], [-121.01579, 39.27395], [-121.01571, 39.2738], [-121.01567, 39.27364], [-121.01565, 39.27347], [-121.01567, 39.27331], [-121.01572, 39.27315], [-121.01586, 39.27292], [-121.01592, 39.27286], [-121.01615, 39.27267], [-121.01627, 39.27252], [-121.01636, 39.27236], [-121.01645, 39.27214], [-121.01657, 39.272], [-121.01673, 39.27189], [-121.01706, 39.27177], [-121.01731, 39.27163], [-121.01746, 39.27151], [-121.01763, 39.2713], [-121.01985, 39.27119], [-121.01989, 39.27479]]]} | Open Access 1 | 49010 | Sugarloaf Mountain Open Space Preserve | 33706 | 1425 | Nevada City, City of 991 | City 2 | City Agency 2 | http://www.nevadacityca.gov/content/parks-recreation | City 2 | 1425 | Nevada City, City of 955 | City 2 | City Agency 2 | https://www.bylt.org/trail/sugarloaf-mountain-trail/ | Nevada 30 | 29.943 | Sugarloaf Mtn. OSP | 2011 | Local Conservation Area 4 | 2 |
1725 | 1725 | 1724 | {"type": "Polygon", "coordinates": [[[-121.19542, 38.82059], [-121.19429, 38.82183], [-121.19403, 38.82168], [-121.19516, 38.82045], [-121.19542, 38.82059]]]} | Open Access 1 | 49001 | Blue Anchor Park | 33700 | 1354 | Loomis, Town of 415 | City 2 | City Agency 2 | http://www.loomis.ca.gov/ | City 2 | 1354 | Loomis, Town of 409 | City 2 | City Agency 2 | https://loomis.ca.gov/how-do-i/find-2/parks-recreation/ | Placer 35 | 1.147 | Blue Anchor Park | 0 | Local Park 2 | 4 |
1432 | 1432 | 1431 | {"type": "Polygon", "coordinates": [[[-121.88594, 37.31445], [-121.88536, 37.31483], [-121.88518, 37.31455], [-121.88449, 37.31485], [-121.88433, 37.31463], [-121.88552, 37.31397], [-121.88594, 37.31445]]]} | Open Access 1 | 48980 | Tamien Park | 33676 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ | Santa Clara 19 | 1.588 | Tamien Park | 2017 | Local Park 2 | 4 |
16331 | 16331 | 16330 | {"type": "MultiPolygon", "coordinates": [[[[-119.24297, 36.33127], [-119.24195, 36.33139], [-119.23951, 36.33153], [-119.23811, 36.33164], [-119.2372, 36.33193], [-119.23691, 36.33215], [-119.2366, 36.33228], [-119.23591, 36.33246], [-119.23541, 36.33252], [-119.23479, 36.3325], [-119.23421, 36.33281], [-119.23394, 36.33292], [-119.23392, 36.33213], [-119.23394, 36.33086], [-119.23399, 36.33085], [-119.23391, 36.32725], [-119.23517, 36.32722], [-119.23546, 36.32724], [-119.23575, 36.32727], [-119.23603, 36.32734], [-119.2363, 36.32742], [-119.23655, 36.32753], [-119.2369, 36.32772], [-119.23721, 36.32796], [-119.23841, 36.32919], [-119.23856, 36.32932], [-119.23893, 36.3293], [-119.23936, 36.32919], [-119.23997, 36.32911], [-119.24016, 36.32898], [-119.24006, 36.3285], [-119.24069, 36.32807], [-119.24185, 36.32775], [-119.24203, 36.3275], [-119.24227, 36.32731], [-119.24259, 36.32726], [-119.24262, 36.32724], [-119.24291, 36.32724], [-119.24297, 36.33127]]], [[[-119.24313, 36.34277], [-119.24142, 36.3433], [-119.24141, 36.34287], [-119.24097, 36.34288], [-119.24096, 36.34188], [-119.23752, 36.34188], [-119.23746, 36.33925], [-119.23575, 36.33923], [-119.23565, 36.33449], [-119.23398, 36.33447], [-119.23394, 36.33295], [-119.23423, 36.33284], [-119.2348, 36.33253], [-119.23541, 36.33254], [-119.23591, 36.33249], [-119.23661, 36.33231], [-119.23693, 36.33217], [-119.23723, 36.33195], [-119.23812, 36.33167], [-119.23952, 36.33156], [-119.24297, 36.33135], [-119.24313, 36.34277]]]]} | Open Access 1 | 48973 | East Side Regional Park | 33670 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | https://docs.google.com/document/d/1oNuJp2ZETkV9htPzVHlYhz1D7kD7tlzxGEYdJEtsDPg/edit | Tulare 29 | 271.524 | East Side RP | 0 | Local Park 2 | 4 |
15329 | 15329 | 15328 | {"type": "Polygon", "coordinates": [[[-117.03611, 33.78835], [-117.03606, 33.78836], [-117.03603, 33.78814], [-117.03599, 33.78803], [-117.0359, 33.78786], [-117.03583, 33.78777], [-117.03574, 33.78768], [-117.03558, 33.78755], [-117.03537, 33.78743], [-117.03604, 33.78743], [-117.03599, 33.78773], [-117.03606, 33.7878], [-117.03603, 33.78785], [-117.03602, 33.78791], [-117.03605, 33.78798], [-117.03604, 33.788], [-117.03611, 33.78835]]]} | Open Access 1 | 48972 | Pocket Park at the Cove #2 | 33669 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.446 | PP at the Cove #2 | 0 | Local Park 2 | 4 |
15540 | 15540 | 15539 | {"type": "Polygon", "coordinates": [[[-117.03786, 33.79012], [-117.03745, 33.79026], [-117.03733, 33.79002], [-117.03774, 33.78988], [-117.03786, 33.79012]]]} | Open Access 1 | 48971 | Pocket Park at the Cove #1 | 33668 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.295 | PP at the Cove #1 | 0 | Local Park 2 | 4 |
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 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]);