units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
77 rows where ACCESS_TYP = 3, DES_TP = 2 and GAP_STS = 4
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST
MNG_AGENCY 26
- East Bay Regional Park District 23
- Los Angeles, City of 16
- Santa Clara County Parks and Recreation Dept., County of 4
- San Diego, City of 3
- Napa County Regional Park and Open Space District 3
- Rolling Hills, City of 3
- Mountains Recreation and Conservation Authority 2
- San Diego, County of 2
- San Marcos, City of 2
- Napa, City of 2
- Rocklin, City of 2
- Los Angeles, County of 1
- San Mateo County Parks and Recreation Dept., County of 1
- Santee, City of 1
- Marin County Open Space District 1
- Rosemead, City of 1
- Sonoma County Regional Parks Dept., County of 1
- Palmdale, City of 1
- Norwalk, City of 1
- Bakersfield, City of 1
- Long Beach, City of 1
- La Verne, City of 1
- Agoura Hills, City of 1
- Roseville, City of 1
- South El Monte, City of 1
- San Dieguito River Park Joint Powers Authority 1
MNG_AG_TYP 5
DES_TP 1
- Local Park · 77 ✖
ACCESS_TYP 1
- No Public Access · 77 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 933 | 933 | 932 | {"type": "Polygon", "coordinates": [[[-118.35507, 33.77194], [-118.35328, 33.77337], [-118.3527, 33.77336], [-118.35236, 33.77251], [-118.35281, 33.77202], [-118.35362, 33.7711], [-118.35507, 33.77194]]]} | No Public Access 3 | 5936 | Rolling Hills City Parkland | 24574 | 1282 | Rolling Hills, City of 288 | City 2 | City Agency 2 | http://www.rolling-hills.org/ | City 2 | 1282 | Rolling Hills, City of 285 | City 2 | City Agency 2 | Los Angeles 6 | 8.192 | Rolling Hills City Parkland | 0 | Local Park 2 | 4 | |
| 1270 | 1270 | 1269 | {"type": "Polygon", "coordinates": [[[-118.56523, 34.13034], [-118.56473, 34.13106], [-118.56429, 34.13106], [-118.56418, 34.13093], [-118.56397, 34.13076], [-118.56397, 34.13019], [-118.56387, 34.13018], [-118.56387, 34.12948], [-118.5652, 34.12947], [-118.56479, 34.13017], [-118.56523, 34.13034]]]} | No Public Access 3 | 7159 | Los Angeles City Water Resource Parkland | 21477 | 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 | 4.129 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
| 1271 | 1271 | 1270 | {"type": "Polygon", "coordinates": [[[-118.44484, 34.1151], [-118.44483, 34.11604], [-118.44451, 34.11604], [-118.44418, 34.11581], [-118.44418, 34.11543], [-118.4445, 34.11515], [-118.44451, 34.1151], [-118.44484, 34.1151]]]} | No Public Access 3 | 7160 | Los Angeles City Water Resource Parkland | 21477 | 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 | 1.317 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
| 1340 | 1340 | 1339 | {"type": "Polygon", "coordinates": [[[-118.38142, 34.10854], [-118.38114, 34.10871], [-118.38103, 34.10855], [-118.38131, 34.10838], [-118.38142, 34.10854]]]} | No Public Access 3 | 12809 | Los Angeles City Water Resource Parkland | 21477 | 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 | 0.163 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
| 1411 | 1411 | 1410 | {"type": "Polygon", "coordinates": [[[-117.76876, 34.14961], [-117.76819, 34.14963], [-117.76817, 34.14987], [-117.76775, 34.14988], [-117.76775, 34.1492], [-117.76818, 34.14946], [-117.76819, 34.14957], [-117.76875, 34.14956], [-117.76876, 34.14961]]]} | No Public Access 3 | 12352 | La Verne City Parkland | 20811 | 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 | 0.671 | La Verne City Parkland | 0 | Local Park 2 | 4 | |
| 1489 | 1489 | 1488 | {"type": "Polygon", "coordinates": [[[-118.46789, 34.09611], [-118.46633, 34.09612], [-118.46623, 34.09617], [-118.46611, 34.09595], [-118.46593, 34.09571], [-118.46592, 34.09565], [-118.46593, 34.09559], [-118.46595, 34.09555], [-118.46601, 34.09548], [-118.46614, 34.09544], [-118.4678, 34.09543], [-118.46792, 34.09583], [-118.46789, 34.09611]]]} | No Public Access 3 | 12701 | Los Angeles City Water Resource Parkland | 21477 | 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 | 3.182 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
| 2803 | 2803 | 2802 | {"type": "Polygon", "coordinates": [[[-118.37097, 34.13187], [-118.37053, 34.13214], [-118.36993, 34.13183], [-118.37013, 34.13145], [-118.37097, 34.13187]]]} | No Public Access 3 | 12817 | Los Angeles City Water Resource Parkland | 21477 | 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 | 0.89 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
| 3202 | 3202 | 3201 | {"type": "MultiPolygon", "coordinates": [[[[-121.94564, 37.63101], [-121.9403, 37.63339], [-121.94035, 37.63646], [-121.93102, 37.63656], [-121.93099, 37.63583], [-121.92155, 37.63602], [-121.92155, 37.63572], [-121.92165, 37.63558], [-121.92203, 37.63535], [-121.92186, 37.63512], [-121.92191, 37.63508], [-121.92192, 37.63502], [-121.92181, 37.63473], [-121.92198, 37.63455], [-121.92215, 37.63433], [-121.92218, 37.63422], [-121.92219, 37.63403], [-121.92224, 37.63369], [-121.92219, 37.63354], [-121.92222, 37.6334], [-121.92218, 37.63337], [-121.92228, 37.6333], [-121.92269, 37.63311], [-121.92266, 37.63307], [-121.92256, 37.63311], [-121.92239, 37.63288], [-121.92193, 37.63309], [-121.92187, 37.63313], [-121.92146, 37.63291], [-121.92134, 37.63312], [-121.9207, 37.63207], [-121.91998, 37.63157], [-121.92038, 37.6315], [-121.92081, 37.63135], [-121.92111, 37.63109], [-121.92181, 37.63114], [-121.92187, 37.63073], [-121.92185, 37.63067], [-121.92209, 37.63045], [-121.92142, 37.62996], [-121.92139, 37.62996], [-121.92138, 37.62956], [-121.92101, 37.62958], [-121.92, 37.6297], [-121.91948, 37.6298], [-121.91884, 37.6299], [-121.91869, 37.62969], [-121.91875, 37.62961], [-121.91874, 37.62943], [-121.91872, 37.62941], [-121.91854, 37.62914], [-121.9183, 37.62891], [-121.91773, 37.62928], [-121.91675, 37.62942], [-121.91663, 37.62953], [-121.91639, 37.62881], [-121.91577, 37.62894], [-121.91538, 37.62912], [-121.91533, 37.62916], [-121.91509, 37.62924], [-121.91487, 37.62889], [-121.9146, 37.62864], [-121.91435, 37.62822], [-121.91409, 37.62827], [-121.91371, 37.62786], [-121.91431, 37.62742], [-121.91481, 37.62728], [-121.9147, 37.62703], [-121.91446, 37.6271], [-121.91444, 37.62706], [-121.91468, 37.62699], [-121.91489, 37.62673], [-121.91462, 37.62658], [-121.91454, 37.62667], [-121.91456, 37.62673], [-121.91387, 37.62693], [-121.91335, 37.62728], [-121.91336, 37.62711], [-121.91325, 37.62675], [-121.91283, 37.62679], [-121.9128, 37.62666], [-121.91216, 37.62673], [-121.91216, 37.62655], [-121.91209, 37.62635], [-121.91198, 37.62619], [-121.91172, 37.62591], [-121.9116, 37.62553], [-121.91146, 37.62533], [-121.91125, 37.62519], [-121.91109, 37.62513], [-121.91085, 37.62508], [-121.91077, 37.62504], [-121.91071, 37.62498], [-121.91065, 37.62474], [-121.91059, 37.62458], [-121.91049, 37.62445], [-121.91037, 37.62436], [-121.9102, 37.62429], [-121.91009, 37.62426], [-121.90983, 37.62423], [-121.90971, 37.6242], [-121.90962, 37.62413], [-121.90955, 37.624], [-121.90947, 37.6239], [-121.90926, 37.62377], [-121.90895, 37.62369], [-121.9088, 37.62368], [-121.90891, 37.6235], [-121.90866, 37.62341], [-121.90831, 37.62293], [-121.90813, 37.62247], [-121.9084, 37.62222], [-121.9084, 37.62183], [-121.90799, 37.62183], [-121.90767, 37.62191], [-121.9076, 37.62189], [-121.90754, 37.62186], [-121.90699, 37.62125], [-121.90692, 37.62114], [-121.9069, 37.62105], [-121.90691, 37.62096], [-121.90706, 37.62062], [-121.90706, 37.62056], [-121.90703, 37.6205], [-121.90697, 37.62045], [-121.90636, 37.62007], [-121.90616, 37.61984], [-121.9057, 37.61946], [-121.90569, 37.61941], [-121.90573, 37.61936], [-121.90593, 37.61934], [-121.90605, 37.61926], [-121.90608, 37.6192], [-121.90609, 37.61914], [-121.90604, 37.61904], [-121.90594, 37.61896], [-121.9058, 37.61891], [-121.90494, 37.6188], [-121.90476, 37.61871], [-121.90464, 37.61859], [-121.9046, 37.61848], [-121.90458, 37.61837], [-121.90469, 37.61771], [-121.90466, 37.61728], [-121.90454, 37.61729], [-121.9045, 37.61733], [-121.90444, 37.61733], [-121.90418, 37.61699], [-121.9041, 37.61692], [-121.90402, 37.61689], [-121.90298, 37.61664], [-121.90294, 37.61662], [-121.90289, 37.61658], [-121.90287, 37.61653], [-121.90288, 37.61647], [-121.90299, 37.61627], [-121.90304, 37.61614], [-121.90306, 37.61601], [-121.90304, 37.61588], [-121.90281, 37.61532], [-121.90232, 37.61491], [-121.90213, 37.61465], [-121.90246, 37.6145], [-121.90247, 37.61449], [-121.90245, 37.61447], [-121.90211, 37.61463], [-121.90206, 37.61455], [-121.90202, 37.61445], [-121.90201, 37.61434], [-121.90206, 37.61398], [-121.90202, 37.61389], [-121.90196, 37.61385], [-121.90176, 37.61385], [-121.9015, 37.61398], [-121.90139, 37.61401], [-121.90126, 37.61402], [-121.90064, 37.61397], [-121.89991, 37.61409], [-121.89979, 37.61407], [-121.89971, 37.614], [-121.89969, 37.61392], [-121.90052, 37.61356], [-121.90054, 37.6135], [-121.90064, 37.61348], [-121.90075, 37.61343], [-121.90091, 37.61328], [-121.90093, 37.61323], [-121.90091, 37.61316], [-121.90097, 37.6132], [-121.90105, 37.61324], [-121.9012, 37.61326], [-121.90129, 37.61322], [-121.90153, 37.61325], [-121.90166, 37.6133], [-121.90184, 37.61297], [-121.89654, 37.60588], [-121.89627, 37.60601], [-121.89625, 37.60364], [-121.8942, 37.60365], [-121.89419, 37.59988], [-121.89706, 37.59992], [-121.89707, 37.59991], [-121.89605, 37.5986], [-121.89418, 37.59857], [-121.89417, 37.59428], [-121.89645, 37.59448], [-121.89645, 37.59476], [-121.89792, 37.5949], [-121.89856, 37.59499], [-121.89904, 37.59509], [-121.89975, 37.59527], [-121.90211, 37.59598], [-121.90194, 37.59641], [-121.90179, 37.59766], [-121.9018, 37.59767], [-121.90388, 37.59749], [-121.90405, 37.59631], [-121.9048, 37.5963], [-121.90512, 37.59628], [-121.90566, 37.59621], [-121.90618, 37.5961], [-121.90807, 37.59561], [-121.90819, 37.59743], [-121.90819, 37.59978], [-121.90776, 37.60027], [-121.91431, 37.6033], [-121.91439, 37.60736], [-121.94393, 37.60721], [-121.94075, 37.61037], [-121.94126, 37.61098], [-121.94103, 37.6114], [-121.9408, 37.61149], [-121.94056, 37.61153], [-121.94024, 37.61166], [-121.94017, 37.61184], [-121.94036, 37.61205], [-121.94042, 37.61224], [-121.94009, 37.61262], [-121.94008, 37.61281], [-121.93995, 37.61324], [-121.93993, 37.61356], [-121.93978, 37.61385], [-121.93978, 37.61417], [-121.93998, 37.6144], [-121.94029, 37.61469], [-121.94007, 37.61506], [-121.94045, 37.61589], [-121.94251, 37.61604], [-121.94317, 37.6157], [-121.94392, 37.61657], [-121.94402, 37.61684], [-121.94386, 37.61723], [-121.94359, 37.61747], [-121.9433, 37.61754], [-121.94308, 37.6177], [-121.94282, 37.61795], [-121.94265, 37.61816], [-121.94267, 37.6184], [-121.94282, 37.61875], [-121.94288, 37.61895], [-121.94295, 37.6195], [-121.9429, 37.62035], [-121.94287, 37.62058], [-121.94257, 37.62081], [-121.94265, 37.62106], [-121.94245, 37.62131], [-121.9424, 37.62136], [-121.94194, 37.62136], [-121.94171, 37.62154], [-121.9414, 37.62232], [-121.9414, 37.623], [-121.94101, 37.623], [-121.941, 37.62301], [-121.94169, 37.62521], [-121.94236, 37.62526], [-121.94349, 37.62491], [-121.94356, 37.62498], [-121.94358, 37.62503], [-121.94222, 37.62544], [-121.94281, 37.62661], [-121.94252, 37.6267], [-121.94252, 37.62671], [-121.94403, 37.62821], [-121.9429, 37.62878], [-121.9429, 37.62879], [-121.9435, 37.6295], [-121.94359, 37.62945], [-121.94417, 37.63014], [-121.94447, 37.63], [-121.94513, 37.63081], [-121.94542, 37.6307], [-121.94564, 37.63101]], [[-121.91707, 37.62494], [-121.91744, 37.62531], [-121.918, 37.62497], [-121.91761, 37.62459], [-121.91715, 37.62465], [-121.91707, 37.62494]], [[-121.92269, 37.61992], [-121.92282, 37.61999], [-121.92314, 37.61967], [-121.92289, 37.6195], [-121.92261, 37.61976], [-121.92216, 37.6197], [-121.92206, 37.62015], [-121.92236, 37.62035], [-121.92254, 37.62018], [-121.92247, 37.62013], [-121.92269, 37.61992]]], [[[-121.90282, 37.61628], [-121.90277, 37.61629], [-121.90272, 37.61627], [-121.9025, 37.6159], [-121.90209, 37.61541], [-121.90118, 37.61478], [-121.90097, 37.61468], [-121.90069, 37.61461], [-121.90053, 37.6146], [-121.89999, 37.61461], [-121.89982, 37.61457], [-121.89943, 37.6143], [-121.89926, 37.61411], [-121.89956, 37.61398], [-121.8996, 37.61407], [-121.89967, 37.61413], [-121.89975, 37.61418], [-121.89985, 37.6142], [-121.89995, 37.6142], [-121.90065, 37.61408], [-121.90134, 37.61413], [-121.90154, 37.61408], [-121.90183, 37.61394], [-121.9019, 37.61395], [-121.90192, 37.614], [-121.90186, 37.61434], [-121.90187, 37.61444], [-121.9019, 37.61454], [-121.90195, 37.61464], [-121.90218, 37.61496], [-121.90266, 37.61534], [-121.9027, 37.61539], [-121.90291, 37.61596], [-121.9029, 37.61612], [-121.90282, 37.61628]]], [[[-121.90642, 37.62025], [-121.90608, 37.62061], [-121.90523, 37.62026], [-121.90517, 37.62021], [-121.90512, 37.62015], [-121.90505, 37.61987], [-121.90496, 37.61976], [-121.90443, 37.61926], [-121.90394, 37.61899], [-121.90384, 37.61885], [-121.90383, 37.61881], [-121.90396, 37.61853], [-121.90401, 37.61826], [-121.90413, 37.61786], [-121.90415, 37.61775], [-121.90413, 37.61764], [-121.90409, 37.61755], [-121.90402, 37.61746], [-121.90333, 37.61695], [-121.90331, 37.61692], [-121.90333, 37.61688], [-121.9034, 37.61686], [-121.90393, 37.61698], [-121.90401, 37.61701], [-121.90407, 37.61706], [-121.90454, 37.6177], [-121.90455, 37.61777], [-121.90444, 37.61839], [-121.90447, 37.61855], [-121.90453, 37.61867], [-121.90468, 37.61881], [-121.90489, 37.61891], [-121.90502, 37.61894], [-121.90576, 37.61902], [-121.90584, 37.61905], [-121.90592, 37.6191], [-121.90595, 37.61916], [-121.90591, 37.61922], [-121.9057, 37.61924], [-121.9056, 37.6193], [-121.90555, 37.61939], [-121.90556, 37.61949], [-121.90561, 37.61956], [-121.90605, 37.61991], [-121.90622, 37.62012], [-121.90642, 37.62025]]], [[[-121.92749, 37.65025], [-121.92749, 37.65388], [-121.92329, 37.65388], [-121.92318, 37.65373], [-121.92304, 37.65359], [-121.92238, 37.65312], [-121.92224, 37.65323], [-121.92288, 37.65369], [-121.923, 37.65381], [-121.92312, 37.65397], [-121.92319, 37.65412], [-121.92322, 37.65427], [-121.9233, 37.65511], [-121.92335, 37.65531], [-121.92342, 37.65549], [-121.92405, 37.65672], [-121.92418, 37.65687], [-121.92474, 37.65741], [-121.92292, 37.65741], [-121.92292, 37.66166], [-121.92102, 37.66158], [-121.91451, 37.6614], [-121.91451, 37.66091], [-121.9147, 37.66095], [-121.91597, 37.66095], [-121.91607, 37.66094], [-121.91609, 37.66085], [-121.91613, 37.65849], [-121.91452, 37.65833], [-121.91452, 37.6507], [-121.91472, 37.6506], [-121.91472, 37.65025], [-121.92749, 37.65025]]], [[[-121.96441, 37.6875], [-121.96038, 37.68754], [-121.96039, 37.68927], [-121.96011, 37.68917], [-121.95955, 37.6891], [-121.95904, 37.6892], [-121.95843, 37.68954], [-121.95771, 37.68964], [-121.9573, 37.68988], [-121.95635, 37.69015], [-121.95598, 37.69035], [-121.95525, 37.69033], [-121.95466, 37.69052], [-121.95412, 37.69063], [-121.95289, 37.69107], [-121.95275, 37.69108], [-121.95252, 37.69092], [-121.95151, 37.69162], [-121.95128, 37.69186], [-121.95128, 37.69151], [-121.95126, 37.6915], [-121.95085, 37.69193], [-121.95058, 37.69231], [-121.94936, 37.6933], [-121.94858, 37.6934], [-121.94753, 37.69464], [-121.94723, 37.69468], [-121.94675, 37.69479], [-121.94677, 37.69216], [-121.94731, 37.69228], [-121.94756, 37.6923], [-121.94785, 37.69235], [-121.94835, 37.69252], [-121.94873, 37.69261], [-121.94879, 37.69261], [-121.94886, 37.69259], [-121.9489, 37.69253], [-121.94891, 37.69243], [-121.94888, 37.69235], [-121.94879, 37.69225], [-121.94846, 37.69203], [-121.94851, 37.692], [-121.94867, 37.6921], [-121.94896, 37.69183], [-121.94846, 37.69147], [-121.94838, 37.69145], [-121.94797, 37.6911], [-121.94828, 37.69084], [-121.9477, 37.69042], [-121.94742, 37.69034], [-121.94714, 37.69052], [-121.94695, 37.69062], [-121.94691, 37.69066], [-121.94689, 37.6907], [-121.94688, 37.69102], [-121.94678, 37.69101], [-121.94679, 37.68993], [-121.94776, 37.68911], [-121.94776, 37.68868], [-121.9468, 37.68867], [-121.9468, 37.68764], [-121.9462, 37.68763], [-121.9462, 37.68742], [-121.95131, 37.6874], [-121.95128, 37.68015], [-121.94102, 37.67923], [-121.93387, 37.67695], [-121.93328, 37.6773], [-121.93304, 37.67753], [-121.93196, 37.6771], [-121.93196, 37.67771], [-121.93168, 37.67787], [-121.93123, 37.67792], [-121.93103, 37.67808], [-121.9309, 37.67813], [-121.93081, 37.67822], [-121.9306, 37.67831], [-121.93032, 37.67831], [-121.93014, 37.67841], [-121.92978, 37.6784], [-121.92903, 37.67892], [-121.92719, 37.67894], [-121.92718, 37.67916], [-121.92657, 37.67921], [-121.92592, 37.67946], [-121.9255, 37.67961], [-121.92369, 37.68019], [-121.9217, 37.67451], [-121.92198, 37.67444], [-121.92266, 37.67461], [-121.92267, 37.67478], [-121.92955, 37.67479], [-121.92998, 37.67444], [-121.92996, 37.67407], [-121.93029, 37.67375], [-121.93046, 37.67322], [-121.93087, 37.67313], [-121.93102, 37.67304], [-121.93139, 37.67265], [-121.93193, 37.67235], [-121.93193, 37.67511], [-121.93388, 37.67579], [-121.93465, 37.67487], [-121.9355, 37.67516], [-121.93584, 37.67455], [-121.93417, 37.67393], [-121.93415, 37.67302], [-121.95002, 37.6729], [-121.95128, 37.68015], [-121.95944, 37.67979], [-121.95946, 37.68039], [-121.9644, 37.68037], [-121.96441, 37.6875]], [[-121.92614, 37.6781], [-121.92614, 37.67811], [-121.92715, 37.67872], [-121.92785, 37.67773], [-121.92713, 37.6772], [-121.92614, 37.6781]]], [[[-121.93182, 37.6647], [-121.92747, 37.6647], [-121.92747, 37.66105], [-121.93178, 37.66107], [-121.93182, 37.6647]]], [[[-121.96916, 37.6511], [-121.96841, 37.65109], [-121.9684, 37.6511], [-121.96866, 37.66571], [-121.96719, 37.6657], [-121.96735, 37.66484], [-121.96318, 37.66293], [-121.95923, 37.66043], [-121.95777, 37.65948], [-121.95545, 37.65984], [-121.9549, 37.65834], [-121.95271, 37.65649], [-121.95038, 37.65531], [-121.9498, 37.65305], [-121.94982, 37.65085], [-121.94947, 37.63636], [-121.95623, 37.63613], [-121.95847, 37.63626], [-121.95867, 37.63629], [-121.95886, 37.63634], [-121.95934, 37.63655], [-121.95969, 37.63673], [-121.95991, 37.63688], [-121.96007, 37.63702], [-121.96069, 37.63769], [-121.96089, 37.63787], [-121.96152, 37.63824], [-121.96161, 37.63832], [-121.96177, 37.63848], [-121.96193, 37.63875], [-121.96246, 37.63982], [-121.96268, 37.64014], [-121.96312, 37.64068], [-121.96335, 37.64088], [-121.96435, 37.64164], [-121.96467, 37.64184], [-121.96563, 37.64243], [-121.96575, 37.64255], [-121.96594, 37.64289], [-121.96611, 37.64306], [-121.96626, 37.64315], [-121.96641, 37.64322], [-121.96659, 37.64327], [-121.96677, 37.64329], [-121.96695, 37.64329], [-121.96823, 37.64319], [-121.96824, 37.64358], [-121.96891, 37.64367], [-121.96892, 37.64404], [-121.96878, 37.64406], [-121.96763, 37.64406], [-121.96732, 37.64412], [-121.96709, 37.64422], [-121.96688, 37.64438], [-121.96671, 37.64458], [-121.96663, 37.64479], [-121.96661, 37.64499], [-121.96665, 37.64521], [-121.96677, 37.64543], [-121.96695, 37.64561], [-121.9672, 37.64576], [-121.96734, 37.64581], [-121.9682, 37.64602], [-121.96856, 37.64608], [-121.96899, 37.6461], [-121.96916, 37.6511]]], [[[-121.96899, 37.64598], [-121.96853, 37.64596], [-121.96818, 37.64591], [-121.96736, 37.64567], [-121.96713, 37.64557], [-121.96701, 37.64548], [-121.96691, 37.64538], [-121.96683, 37.64526], [-121.96679, 37.64515], [-121.96676, 37.64503], [-121.96676, 37.64487], [-121.9668, 37.64474], [-121.96686, 37.64462], [-121.96697, 37.64448], [-121.96709, 37.64439], [-121.96728, 37.64428], [-121.96744, 37.64423], [-121.96766, 37.6442], [-121.96892, 37.64415], [-121.96899, 37.64598]]], [[[-121.97191, 37.67624], [-121.97189, 37.6803], [-121.96896, 37.68034], [-121.96889, 37.67627], [-121.97191, 37.67624]]]]} | No Public Access 3 | 28112 | Pleasanton Ridge Regional Park | 31518 | 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 | 4792.41 | Pleasanton Ridge RP | 1990 | Local Park 2 | 4 | |
| 3303 | 3303 | 3302 | {"type": "MultiPolygon", "coordinates": [[[[-121.29299, 38.78675], [-121.29281, 38.78695], [-121.29151, 38.78601], [-121.29153, 38.7857], [-121.29165, 38.78561], [-121.29166, 38.78556], [-121.29165, 38.78546], [-121.29178, 38.78527], [-121.29243, 38.78543], [-121.29257, 38.78589], [-121.29299, 38.78675]]], [[[-121.32257, 38.76796], [-121.32255, 38.76799], [-121.32252, 38.76801], [-121.32191, 38.76817], [-121.32101, 38.76854], [-121.32076, 38.76804], [-121.32034, 38.76803], [-121.32019, 38.76737], [-121.32083, 38.76704], [-121.32074, 38.76639], [-121.31577, 38.76639], [-121.31578, 38.76596], [-121.31577, 38.76578], [-121.31572, 38.76558], [-121.31564, 38.76537], [-121.31596, 38.76536], [-121.31607, 38.76549], [-121.31619, 38.76559], [-121.31638, 38.76567], [-121.31656, 38.76571], [-121.3173, 38.76572], [-121.31743, 38.76571], [-121.31756, 38.76568], [-121.31769, 38.76562], [-121.31793, 38.76545], [-121.31798, 38.76544], [-121.31832, 38.7656], [-121.3186, 38.76569], [-121.31891, 38.76575], [-121.31922, 38.76576], [-121.31959, 38.76571], [-121.3198, 38.76566], [-121.31999, 38.76559], [-121.32028, 38.76544], [-121.32042, 38.76534], [-121.32056, 38.76522], [-121.32175, 38.76518], [-121.32181, 38.76503], [-121.32197, 38.76507], [-121.322, 38.76509], [-121.32201, 38.76513], [-121.32185, 38.76559], [-121.32182, 38.76576], [-121.32181, 38.76597], [-121.32183, 38.76617], [-121.3219, 38.76638], [-121.32224, 38.76714], [-121.32257, 38.76796]]]]} | No Public Access 3 | 29576 | Proposed Park | 24017 | 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 | 23.324 | Proposed Park | 0 | Local Park 2 | 4 | |
| 3378 | 3378 | 3377 | {"type": "Polygon", "coordinates": [[[-121.6646, 36.99929], [-121.66395, 36.99962], [-121.66372, 36.99914], [-121.6607, 36.99998], [-121.64336, 36.99825], [-121.64237, 36.99706], [-121.64103, 36.99558], [-121.63962, 36.99342], [-121.63959, 36.99328], [-121.63974, 36.99263], [-121.64976, 36.98879], [-121.64998, 36.98865], [-121.65387, 36.98718], [-121.65444, 36.98739], [-121.65526, 36.98798], [-121.65768, 36.98858], [-121.65796, 36.98868], [-121.65926, 36.98898], [-121.65924, 36.98906], [-121.65915, 36.98927], [-121.65869, 36.98944], [-121.65852, 36.98982], [-121.65814, 36.99001], [-121.65802, 36.99034], [-121.65782, 36.99051], [-121.6576, 36.99095], [-121.65718, 36.99132], [-121.657, 36.99169], [-121.65616, 36.99213], [-121.65585, 36.99264], [-121.65576, 36.9929], [-121.65573, 36.9932], [-121.65619, 36.9935], [-121.65642, 36.99384], [-121.65658, 36.99397], [-121.65726, 36.99401], [-121.65742, 36.99461], [-121.65783, 36.99478], [-121.65806, 36.99509], [-121.65843, 36.99523], [-121.65842, 36.99555], [-121.65873, 36.99572], [-121.65856, 36.99611], [-121.65867, 36.99631], [-121.65934, 36.99662], [-121.66013, 36.99723], [-121.66134, 36.99737], [-121.66267, 36.99781], [-121.66332, 36.99812], [-121.6646, 36.99929]], [[-121.65455, 36.99628], [-121.65454, 36.99626], [-121.6541, 36.99606], [-121.65394, 36.9963], [-121.65438, 36.9965], [-121.65455, 36.99628]]]} | No Public Access 3 | 24434 | Mount Madonna County Park | 29288 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/MtMadonna.aspx | Santa Clara 19 | 423.185 | Mount Madonna County Park | 0 | Local Park 2 | 4 |
| 3421 | 3421 | 3420 | {"type": "Polygon", "coordinates": [[[-116.96658, 32.84974], [-116.96647, 32.85215], [-116.96564, 32.85215], [-116.965, 32.85221], [-116.96414, 32.85224], [-116.96351, 32.8521], [-116.96347, 32.85208], [-116.96345, 32.85204], [-116.96339, 32.85204], [-116.9634, 32.85153], [-116.96338, 32.85152], [-116.9634, 32.85046], [-116.96343, 32.85045], [-116.96343, 32.84995], [-116.96658, 32.84974]]]} | No Public Access 3 | 25131 | Radio Towers Park | 24070 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | San Diego 4 | 18.699 | Radio Towers Park | 0 | Local Park 2 | 4 | |
| 3640 | 3640 | 3639 | {"type": "Polygon", "coordinates": [[[-121.25516, 38.82911], [-121.25484, 38.82931], [-121.25459, 38.82956], [-121.25447, 38.82976], [-121.25421, 38.8303], [-121.25411, 38.83044], [-121.25317, 38.82964], [-121.25338, 38.82941], [-121.25345, 38.82929], [-121.2535, 38.82917], [-121.25354, 38.82903], [-121.25355, 38.82889], [-121.25354, 38.82875], [-121.25351, 38.8286], [-121.25392, 38.82844], [-121.25515, 38.82835], [-121.25517, 38.82877], [-121.25511, 38.82902], [-121.25516, 38.82911]]]} | No Public Access 3 | 29498 | Mansion Oaks Park | 21761 | 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 | 5.751 | Mansion Oaks Park | 0 | Local Park 2 | 4 | |
| 3686 | 3686 | 3685 | {"type": "MultiPolygon", "coordinates": [[[[-122.99454, 38.50132], [-122.9944, 38.50144], [-122.99344, 38.50067], [-122.99358, 38.50056], [-122.99371, 38.50033], [-122.99373, 38.50023], [-122.99371, 38.50022], [-122.99364, 38.50027], [-122.99335, 38.50004], [-122.99363, 38.49983], [-122.99398, 38.50045], [-122.99405, 38.50043], [-122.99454, 38.50132]]], [[[-122.99558, 38.50043], [-122.99523, 38.50073], [-122.99427, 38.50011], [-122.99378, 38.49925], [-122.99395, 38.49913], [-122.99426, 38.49941], [-122.9944, 38.49964], [-122.99464, 38.4997], [-122.99558, 38.49982], [-122.99558, 38.50043]]], [[[-122.99512, 38.50083], [-122.99466, 38.50122], [-122.99406, 38.50014], [-122.99415, 38.50021], [-122.99512, 38.50083]]]]} | No Public Access 3 | 29797 | Guerneville River Park | 19563 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 5.24 | Guerneville River Park | 0 | Local Park 2 | 4 | |
| 3807 | 3807 | 3806 | {"type": "Polygon", "coordinates": [[[-122.056, 37.23144], [-122.05442, 37.23139], [-122.05437, 37.23056], [-122.0559, 37.23113], [-122.056, 37.23144]]]} | No Public Access 3 | 35126 | Sanborn County Park | 32833 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 2.136 | Sanborn County Park | 0 | Local Park 2 | 4 | |
| 3846 | 3846 | 3845 | {"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]} | No Public Access 3 | 46811 | Neighborhood 8 Neighborhood Park | 30272 | 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 | 19.773 | Neighborhood 8 Neighborhood Park | 0 | Local Park 2 | 4 | |
| 4227 | 4227 | 4226 | {"type": "Polygon", "coordinates": [[[-122.40045, 37.34619], [-122.40067, 37.34684], [-122.40105, 37.3505], [-122.40014, 37.35661], [-122.39968, 37.35684], [-122.39925, 37.35665], [-122.39846, 37.35659], [-122.39805, 37.35668], [-122.39805, 37.35669], [-122.3983, 37.35727], [-122.39762, 37.35724], [-122.39754, 37.35599], [-122.39872, 37.35471], [-122.39938, 37.35358], [-122.39954, 37.35151], [-122.39785, 37.34917], [-122.39775, 37.34869], [-122.39816, 37.34885], [-122.39834, 37.34887], [-122.39847, 37.34885], [-122.39858, 37.3488], [-122.39867, 37.34873], [-122.39873, 37.34864], [-122.39876, 37.34851], [-122.39872, 37.34735], [-122.39877, 37.34718], [-122.3989, 37.34698], [-122.39893, 37.34689], [-122.39889, 37.34672], [-122.39882, 37.34654], [-122.39848, 37.34602], [-122.39837, 37.34593], [-122.39824, 37.34586], [-122.39809, 37.34583], [-122.39794, 37.34583], [-122.39832, 37.34564], [-122.40045, 37.34619]]]} | No Public Access 3 | 47809 | Tunitas Creek Beach | 31691 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 51.984 | Tunitas Creek Beach | 0 | Local Park 2 | 4 | |
| 5168 | 5168 | 5167 | {"type": "Polygon", "coordinates": [[[-118.37164, 34.13145], [-118.37153, 34.13213], [-118.37007, 34.13142], [-118.37071, 34.1309], [-118.37084, 34.13153], [-118.37164, 34.13145]]]} | No Public Access 3 | 12818 | Los Angeles City Water Resource Parkland | 21477 | 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 | 1.768 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
| 5411 | 5411 | 5410 | {"type": "Polygon", "coordinates": [[[-118.58708, 34.13904], [-118.58568, 34.13904], [-118.58568, 34.13813], [-118.58707, 34.13866], [-118.58708, 34.13904]]]} | No Public Access 3 | 7166 | Los Angeles City Water Resource Parkland | 21477 | 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 | 2.267 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
| 5495 | 5495 | 5494 | {"type": "Polygon", "coordinates": [[[-118.38093, 34.1267], [-118.38083, 34.12681], [-118.38083, 34.12701], [-118.38061, 34.12707], [-118.38043, 34.12717], [-118.38031, 34.12721], [-118.3802, 34.12721], [-118.38011, 34.12718], [-118.38003, 34.12714], [-118.37992, 34.12701], [-118.3798, 34.12694], [-118.37975, 34.12694], [-118.37974, 34.12695], [-118.37963, 34.12692], [-118.37943, 34.1269], [-118.37939, 34.12686], [-118.37941, 34.12663], [-118.38093, 34.1267]]]} | No Public Access 3 | 12819 | Los Angeles City Water Resource Parkland | 21477 | 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 | 1.441 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
| 5496 | 5496 | 5495 | {"type": "Polygon", "coordinates": [[[-118.39301, 34.11863], [-118.39283, 34.11899], [-118.39267, 34.11881], [-118.39276, 34.11874], [-118.39271, 34.11868], [-118.3926, 34.11875], [-118.39249, 34.11863], [-118.39234, 34.11881], [-118.39226, 34.11887], [-118.39219, 34.11889], [-118.39201, 34.11889], [-118.39183, 34.11881], [-118.39175, 34.11874], [-118.39223, 34.11873], [-118.39222, 34.11808], [-118.39228, 34.11821], [-118.39284, 34.11848], [-118.39299, 34.11857], [-118.39297, 34.1186], [-118.39301, 34.11863]]]} | No Public Access 3 | 12820 | Los Angeles City Water Resource Parkland | 21477 | 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 | 0.964 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 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]);