units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
363 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 2 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, GAP_STS
MNG_AGENCY >30
- Los Angeles, City of 20
- Whittier, City of 20
- San Ramon, City of 15
- San Diego, City of 10
- Long Beach, City of 9
- Arcadia, City of 8
- Manhattan Beach, City of 8
- Santa Cruz, City of 7
- Modesto, City of 7
- San Jose, City of 6
- Carlsbad, City of 6
- Hollister, City of 6
- Pasadena, City of 6
- Santa Ana, City of 5
- Fullerton, City of 5
- Vacaville, City of 5
- San Bernardino, City of 5
- Beverly Hills, City of 5
- Lawndale, City of 5
- San Gabriel, City of 5
- Glendora, City of 4
- El Segundo, City of 4
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- South El Monte, City of 4
- Watsonville, City of 3
- San Luis Obispo, City of 3
- Oceanside, City of 3
- Pomona, City of 3
- …
DES_TP >30
- Local Recreation Area 168
- Local Park 151
- Local Conservation Area 10
- Local Other or Unknown 6
- Local Historic or Cultural Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 1
- City Agency · 363 ✖
ACCESS_TYP 1
- Restricted Access · 363 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5465 | 5465 | 5464 | {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.33699, 33.91011], [-118.33698, 33.91027], [-118.3365, 33.91027], [-118.3365, 33.90959], [-118.33727, 33.90959], [-118.33727, 33.9101]]]} | Restricted Access 2 | 6273 | Zela Davis Elementary School Park | 31892 | 2044 | Hawthorne School District 808 | Special District 4 | School District 14 | http://www.hawthorne.k12.ca.us/ | Special District 4 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 1.201 | Zela Davis Elementary School Park | 0 | Local Park 2 | 4 | |
3049 | 3049 | 3048 | {"type": "Polygon", "coordinates": [[[-118.16091, 34.13982], [-118.15954, 34.13982], [-118.15942, 34.13859], [-118.16072, 34.13858], [-118.16072, 34.13907], [-118.16084, 34.13908], [-118.16091, 34.13982]]]} | Restricted Access 2 | 24522 | Wrigley Gardens | 32656 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 4.163 | Wrigley Gardens | 0 | Local Park 2 | 4 | |
7658 | 7658 | 7657 | {"type": "MultiPolygon", "coordinates": [[[[-121.33318, 38.77738], [-121.33108, 38.77841], [-121.33128, 38.77895], [-121.32992, 38.7806], [-121.32992, 38.78173], [-121.32873, 38.78173], [-121.32872, 38.78055], [-121.32156, 38.78053], [-121.32156, 38.78087], [-121.31946, 38.7809], [-121.31879, 38.78159], [-121.31752, 38.78178], [-121.31706, 38.78176], [-121.3164, 38.78152], [-121.31639, 38.78104], [-121.3168, 38.78104], [-121.3168, 38.7806], [-121.31722, 38.7806], [-121.31721, 38.78027], [-121.31757, 38.78019], [-121.31786, 38.78005], [-121.31832, 38.77973], [-121.31895, 38.77946], [-121.31997, 38.77946], [-121.32051, 38.77928], [-121.32092, 38.77882], [-121.32092, 38.77742], [-121.32062, 38.77657], [-121.32031, 38.77607], [-121.32023, 38.77564], [-121.32045, 38.77546], [-121.32045, 38.77538], [-121.32093, 38.77498], [-121.32143, 38.77515], [-121.32183, 38.77515], [-121.3221, 38.77615], [-121.32251, 38.77655], [-121.32444, 38.77695], [-121.32498, 38.77669], [-121.3249, 38.77644], [-121.32469, 38.77602], [-121.32503, 38.7745], [-121.32453, 38.77439], [-121.32468, 38.77396], [-121.32476, 38.7738], [-121.32488, 38.77368], [-121.32526, 38.77338], [-121.32555, 38.77359], [-121.32614, 38.77315], [-121.32665, 38.77183], [-121.32719, 38.77085], [-121.3268, 38.77069], [-121.32705, 38.77029], [-121.32804, 38.77073], [-121.32803, 38.77237], [-121.3275, 38.77302], [-121.32701, 38.77395], [-121.32698, 38.77427], [-121.32751, 38.77437], [-121.32754, 38.77479], [-121.32806, 38.77504], [-121.32944, 38.775], [-121.32978, 38.77527], [-121.3301, 38.77531], [-121.33058, 38.77524], [-121.33095, 38.77505], [-121.33119, 38.77532], [-121.33147, 38.7756], [-121.33217, 38.77619], [-121.33252, 38.77653], [-121.33288, 38.77695], [-121.33318, 38.77738]]], [[[-121.32686, 38.77028], [-121.32641, 38.77099], [-121.32599, 38.77096], [-121.32596, 38.77099], [-121.3258, 38.77099], [-121.32524, 38.7708], [-121.32443, 38.77075], [-121.32303, 38.77032], [-121.32255, 38.77025], [-121.32223, 38.7704], [-121.3222, 38.77056], [-121.32222, 38.77062], [-121.32204, 38.77086], [-121.32161, 38.77117], [-121.32166, 38.77172], [-121.32211, 38.77178], [-121.3224, 38.77186], [-121.32331, 38.77204], [-121.32351, 38.77226], [-121.32406, 38.77263], [-121.32457, 38.77327], [-121.32485, 38.77349], [-121.3247, 38.77361], [-121.32459, 38.77376], [-121.32404, 38.77348], [-121.32353, 38.77337], [-121.32313, 38.77319], [-121.32279, 38.77313], [-121.32193, 38.77286], [-121.32157, 38.77278], [-121.32101, 38.77276], [-121.32085, 38.77268], [-121.32073, 38.77252], [-121.3205, 38.77187], [-121.32023, 38.77153], [-121.31978, 38.77114], [-121.3196, 38.77066], [-121.31904, 38.77035], [-121.31941, 38.76996], [-121.31985, 38.76957], [-121.32034, 38.76922], [-121.32088, 38.76892], [-121.32141, 38.76868], [-121.32202, 38.76846], [-121.32265, 38.7683], [-121.32326, 38.76819], [-121.32342, 38.76966], [-121.32506, 38.76974], [-121.32589, 38.76986], [-121.32631, 38.77008], [-121.32686, 38.77028]]]]} | Restricted Access 2 | 20863 | Woodcreek Oaks Golf Course | 33075 | 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 | 208.072 | Woodcreek Oaks GC | 0 | Local Recreation Area 3 | 4 | |
2216 | 2216 | 2215 | {"type": "Polygon", "coordinates": [[[-121.90955, 37.75216], [-121.90924, 37.75257], [-121.90894, 37.75304], [-121.90858, 37.75288], [-121.90819, 37.75274], [-121.90782, 37.75266], [-121.90741, 37.75261], [-121.90741, 37.7522], [-121.90735, 37.75209], [-121.90718, 37.752], [-121.90702, 37.75197], [-121.90676, 37.75208], [-121.9058, 37.75097], [-121.9068, 37.75041], [-121.90754, 37.75103], [-121.90769, 37.7511], [-121.90786, 37.75114], [-121.90802, 37.75114], [-121.90823, 37.75111], [-121.90845, 37.75099], [-121.90955, 37.75216]]]} | Restricted Access 2 | 47570 | Windemere Ranch School Park | 31295 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 11.225 | Windemere Ranch School Park | 0 | Local Park 2 | 4 | |
3663 | 3663 | 3662 | {"type": "Polygon", "coordinates": [[[-118.35756, 33.87843], [-118.35626, 33.87843], [-118.35625, 33.87755], [-118.3565, 33.87755], [-118.35651, 33.87731], [-118.35663, 33.87731], [-118.35663, 33.87709], [-118.35756, 33.87709], [-118.35756, 33.87843]]]} | Restricted Access 2 | 44123 | William Green Park | 27544 | 2396 | Lawndale Elementary School District 670 | Special District 4 | School District 14 | http://www.lawndale.k12.ca.us/ | Special District 4 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ASSETS/PDF/Parks/williamgreenpark.pdf | Los Angeles 6 | 4.064 | William Green Park | 0 | Local Park 2 | 4 |
15369 | 15369 | 15368 | {"type": "Polygon", "coordinates": [[[-118.04661, 33.98098], [-118.0466, 33.98257], [-118.04655, 33.98262], [-118.0434, 33.98262], [-118.04335, 33.98259], [-118.04335, 33.98089], [-118.0454, 33.98089], [-118.04541, 33.98097], [-118.04661, 33.98098]]]} | Restricted Access 2 | 46565 | Whittier High School Park | 31910 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 14.027 | Whittier High School Park | 0 | Local Park 2 | 4 | |
4432 | 4432 | 4431 | {"type": "Polygon", "coordinates": [[[-118.04648, 33.97899], [-118.04609, 33.979], [-118.04611, 33.97832], [-118.04619, 33.97833], [-118.04619, 33.97795], [-118.04624, 33.97795], [-118.04625, 33.97792], [-118.04643, 33.97792], [-118.04646, 33.97897], [-118.04648, 33.97899]]]} | Restricted Access 2 | 46559 | Whittier Dog Park | 29862 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 0.849 | Whittier Dog Park | 0 | Local Park 2 | 4 | |
14196 | 14196 | 14195 | {"type": "Polygon", "coordinates": [[[-122.06953, 37.40119], [-122.06593, 37.40177], [-122.06494, 37.40163], [-122.06507, 37.40148], [-122.06547, 37.40118], [-122.06561, 37.401], [-122.0657, 37.40083], [-122.06605, 37.39986], [-122.06654, 37.39998], [-122.06639, 37.40042], [-122.06652, 37.40052], [-122.06689, 37.40049], [-122.06693, 37.40043], [-122.06762, 37.40032], [-122.06767, 37.40038], [-122.06797, 37.40032], [-122.06799, 37.40034], [-122.0684, 37.40029], [-122.06841, 37.40028], [-122.06838, 37.40019], [-122.06951, 37.40004], [-122.06955, 37.40046], [-122.06955, 37.40081], [-122.06953, 37.40119]]]} | Restricted Access 2 | 44037 | Whisman School Park | 27456 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 12.378 | Whisman School Park | 0 | Local Park 2 | 4 | |
4160 | 4160 | 4159 | {"type": "Polygon", "coordinates": [[[-120.88662, 35.44856], [-120.88637, 35.45027], [-120.88645, 35.45032], [-120.88642, 35.4505], [-120.88586, 35.45105], [-120.88586, 35.45146], [-120.88525, 35.45142], [-120.88432, 35.45064], [-120.88407, 35.45064], [-120.88393, 35.45085], [-120.88399, 35.45208], [-120.88455, 35.45256], [-120.88418, 35.45304], [-120.88415, 35.45371], [-120.8839, 35.45439], [-120.88401, 35.45467], [-120.88424, 35.45492], [-120.88421, 35.45504], [-120.88376, 35.45517], [-120.88362, 35.45533], [-120.8834, 35.45535], [-120.88331, 35.45503], [-120.88303, 35.45467], [-120.88301, 35.45368], [-120.88275, 35.45334], [-120.88275, 35.45295], [-120.88194, 35.45233], [-120.88186, 35.45206], [-120.88152, 35.45174], [-120.88105, 35.4519], [-120.88038, 35.45242], [-120.87968, 35.45347], [-120.8799, 35.45437], [-120.87906, 35.45428], [-120.87895, 35.45419], [-120.87878, 35.45309], [-120.87901, 35.45229], [-120.8792, 35.45201], [-120.87923, 35.45156], [-120.87886, 35.45137], [-120.87705, 35.45132], [-120.87688, 35.45142], [-120.87671, 35.45221], [-120.87649, 35.45251], [-120.87599, 35.4526], [-120.87548, 35.45263], [-120.87517, 35.45288], [-120.87456, 35.45298], [-120.87445, 35.45309], [-120.87433, 35.45364], [-120.87372, 35.45389], [-120.87347, 35.4538], [-120.87299, 35.45394], [-120.8728, 35.45449], [-120.87207, 35.45554], [-120.87193, 35.45584], [-120.87196, 35.45686], [-120.87224, 35.45712], [-120.87232, 35.45737], [-120.8721, 35.45788], [-120.87235, 35.45902], [-120.87246, 35.45911], [-120.87235, 35.45989], [-120.87221, 35.46014], [-120.8721, 35.46064], [-120.87196, 35.4608], [-120.87199, 35.46101], [-120.87249, 35.46145], [-120.8728, 35.46193], [-120.87275, 35.46245], [-120.87213, 35.46328], [-120.87213, 35.46352], [-120.87255, 35.46362], [-120.87263, 35.46371], [-120.87263, 35.46422], [-120.87247, 35.46431], [-120.8718, 35.46419], [-120.87138, 35.4638], [-120.87124, 35.46378], [-120.8704, 35.46435], [-120.87003, 35.46447], [-120.86979, 35.46441], [-120.86964, 35.46413], [-120.86987, 35.46408], [-120.87003, 35.46392], [-120.87006, 35.46374], [-120.86975, 35.4636], [-120.86953, 35.46305], [-120.86969, 35.46262], [-120.8695, 35.46245], [-120.86955, 35.46099], [-120.87, 35.46051], [-120.87003, 35.45989], [-120.86905, 35.459], [-120.86894, 35.45849], [-120.86849, 35.45829], [-120.86804, 35.45776], [-120.86782, 35.45758], [-120.86734, 35.45756], [-120.86703, 35.45772], [-120.86684, 35.45771], [-120.86687, 35.45751], [-120.86698, 35.45737], [-120.86748, 35.45714], [-120.86776, 35.45671], [-120.86785, 35.45618], [-120.8681, 35.45584], [-120.86874, 35.45584], [-120.86899, 35.45561], [-120.86924, 35.4549], [-120.86924, 35.45431], [-120.86905, 35.4541], [-120.86905, 35.45373], [-120.86924, 35.45339], [-120.86941, 35.45215], [-120.86997, 35.45099], [-120.87061, 35.45085], [-120.87114, 35.45041], [-120.87226, 35.4489], [-120.87237, 35.44762], [-120.87251, 35.44739], [-120.87324, 35.44691], [-120.87374, 35.44675], [-120.87486, 35.44663], [-120.87562, 35.44682], [-120.87599, 35.44713], [-120.87683, 35.44766], [-120.87803, 35.44766], [-120.8787, 35.44789], [-120.87918, 35.44787], [-120.87965, 35.44771], [-120.88021, 35.44775], [-120.88192, 35.44819], [-120.8827, 35.44819], [-120.88343, 35.44796], [-120.88662, 35.44856]]]} | Restricted Access 2 | 44743 | Whale Rock Reservoir | 27446 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 282.826 | Whale Rock Reservoir | 0 | Local Recreation Area 3 | 4 | |
6410 | 6410 | 6409 | {"type": "MultiPolygon", "coordinates": [[[[-120.85781, 35.47038], [-120.8576, 35.47052], [-120.85741, 35.47067], [-120.85723, 35.47086], [-120.8571, 35.47104], [-120.85699, 35.47122], [-120.85691, 35.47142], [-120.85681, 35.47178], [-120.85678, 35.47199], [-120.85565, 35.47199], [-120.85497, 35.47201], [-120.85379, 35.47197], [-120.8534, 35.47197], [-120.85344, 35.47036], [-120.85781, 35.47038]]], [[[-120.86826, 35.4694], [-120.86824, 35.47331], [-120.85682, 35.47326], [-120.85741, 35.47321], [-120.85761, 35.47316], [-120.85778, 35.47306], [-120.85828, 35.47261], [-120.85842, 35.47254], [-120.85857, 35.4725], [-120.85953, 35.47248], [-120.86111, 35.47272], [-120.86124, 35.47273], [-120.86386, 35.47235], [-120.86401, 35.47228], [-120.86412, 35.4722], [-120.86534, 35.47097], [-120.86548, 35.47086], [-120.86571, 35.47079], [-120.86695, 35.4706], [-120.8672, 35.47052], [-120.86744, 35.47039], [-120.86758, 35.47029], [-120.86772, 35.47015], [-120.86816, 35.46951], [-120.86826, 35.4694]]], [[[-120.88945, 35.45158], [-120.88818, 35.45144], [-120.88838, 35.45703], [-120.88624, 35.45705], [-120.88624, 35.4588], [-120.88128, 35.45883], [-120.87823, 35.46], [-120.87683, 35.45728], [-120.87511, 35.45676], [-120.87526, 35.46117], [-120.8775, 35.46112], [-120.87771, 35.46723], [-120.87532, 35.46729], [-120.87531, 35.4673], [-120.87557, 35.47469], [-120.87588, 35.47622], [-120.87722, 35.47508], [-120.87721, 35.47908], [-120.8759, 35.47975], [-120.87565, 35.47989], [-120.87539, 35.47989], [-120.87537, 35.47973], [-120.87514, 35.47898], [-120.87509, 35.47819], [-120.87504, 35.47807], [-120.87487, 35.47783], [-120.87482, 35.47768], [-120.87482, 35.47754], [-120.87491, 35.47734], [-120.87494, 35.47718], [-120.87493, 35.47704], [-120.87487, 35.47688], [-120.87474, 35.47671], [-120.87457, 35.47659], [-120.87438, 35.47654], [-120.87411, 35.47653], [-120.87405, 35.47651], [-120.874, 35.47647], [-120.87384, 35.47606], [-120.87366, 35.47572], [-120.87348, 35.47545], [-120.8729, 35.47469], [-120.87233, 35.47337], [-120.87221, 35.47316], [-120.87208, 35.47299], [-120.87195, 35.47286], [-120.87108, 35.47216], [-120.87052, 35.47141], [-120.87047, 35.47132], [-120.87046, 35.47124], [-120.87035, 35.46989], [-120.8703, 35.46968], [-120.87019, 35.46948], [-120.87003, 35.46929], [-120.86978, 35.46912], [-120.86953, 35.46901], [-120.86934, 35.46897], [-120.86918, 35.46895], [-120.86892, 35.46896], [-120.86862, 35.46902], [-120.86835, 35.46914], [-120.86819, 35.46926], [-120.86805, 35.4694], [-120.86762, 35.47002], [-120.86752, 35.47013], [-120.86733, 35.47029], [-120.8671, 35.47041], [-120.86682, 35.47049], [-120.86564, 35.47066], [-120.86539, 35.47075], [-120.86521, 35.47088], [-120.86402, 35.47209], [-120.86392, 35.47217], [-120.86379, 35.47222], [-120.86123, 35.47259], [-120.86113, 35.47259], [-120.85956, 35.47235], [-120.85857, 35.47236], [-120.85837, 35.47241], [-120.85818, 35.4725], [-120.85766, 35.47296], [-120.85755, 35.47303], [-120.85738, 35.47308], [-120.85686, 35.47312], [-120.85691, 35.47285], [-120.85694, 35.47257], [-120.85694, 35.47207], [-120.85696, 35.4719], [-120.85707, 35.47146], [-120.85718, 35.47122], [-120.85734, 35.47097], [-120.85759, 35.47071], [-120.85783, 35.47054], [-120.85806, 35.47042], [-120.85832, 35.47032], [-120.85864, 35.47026], [-120.8589, 35.47024], [-120.85915, 35.47025], [-120.86032, 35.47052], [-120.86065, 35.47058], [-120.86112, 35.4706], [-120.86141, 35.47058], [-120.86171, 35.47054], [-120.86194, 35.47047], [-120.86212, 35.47039], [-120.86231, 35.47027], [-120.86245, 35.47014], [-120.86254, 35.47002], [-120.86269, 35.46954], [-120.86271, 35.46939], [-120.86271, 35.46928], [-120.86268, 35.46913], [-120.86264, 35.469], [-120.86251, 35.46881], [-120.86227, 35.46857], [-120.86216, 35.46842], [-120.86209, 35.46828], [-120.86204, 35.46809], [-120.86203, 35.46792], [-120.86206, 35.46778], [-120.86233, 35.46702], [-120.86237, 35.46683], [-120.86238, 35.4667], [-120.86236, 35.46654], [-120.86228, 35.46627], [-120.86219, 35.46612], [-120.8621, 35.466], [-120.85959, 35.46311], [-120.85948, 35.46296], [-120.85933, 35.46265], [-120.85926, 35.46246], [-120.85924, 35.46231], [-120.85923, 35.46197], [-120.85927, 35.46173], [-120.86041, 35.45914], [-120.86057, 35.45894], [-120.8615, 35.45803], [-120.86159, 35.4579], [-120.86191, 35.45736], [-120.86203, 35.45721], [-120.86221, 35.45707], [-120.86294, 35.45662], [-120.86308, 35.45652], [-120.86421, 35.45532], [-120.86577, 35.45403], [-120.86593, 35.45386], [-120.86605, 35.4537], [-120.86614, 35.4535], [-120.86668, 35.45126], [-120.86676, 35.45107], [-120.86688, 35.45089], [-120.86819, 35.44942], [-120.86849, 35.44915], [-120.8689, 35.4489], [-120.86862, 35.44885], [-120.86915, 35.44846], [-120.86948, 35.44897], [-120.86973, 35.449], [-120.87005, 35.44868], [-120.87066, 35.44904], [-120.8713, 35.44837], [-120.87072, 35.448], [-120.87483, 35.44385], [-120.87733, 35.44296], [-120.87844, 35.44296], [-120.88138, 35.44564], [-120.88726, 35.44384], [-120.88744, 35.44401], [-120.88666, 35.44476], [-120.88671, 35.44593], [-120.88675, 35.44609], [-120.88685, 35.44609], [-120.88701, 35.44604], [-120.88715, 35.44596], [-120.88727, 35.44585], [-120.88734, 35.4457], [-120.88738, 35.44549], [-120.88738, 35.44535], [-120.88743, 35.44522], [-120.88749, 35.44511], [-120.88773, 35.44489], [-120.8882, 35.44523], [-120.88945, 35.45158]], [[-120.88637, 35.45027], [-120.88661, 35.44856], [-120.88343, 35.44796], [-120.8827, 35.44819], [-120.88192, 35.44819], [-120.88021, 35.44775], [-120.87965, 35.44771], [-120.87918, 35.44787], [-120.8787, 35.44789], [-120.87803, 35.44766], [-120.87683, 35.44766], [-120.87599, 35.44713], [-120.87562, 35.44682], [-120.87486, 35.44663], [-120.87374, 35.44675], [-120.87324, 35.44691], [-120.87251, 35.44739], [-120.87237, 35.44762], [-120.87226, 35.4489], [-120.87114, 35.45041], [-120.87061, 35.45085], [-120.86997, 35.45099], [-120.86941, 35.45215], [-120.86924, 35.45339], [-120.86905, 35.45373], [-120.86905, 35.4541], [-120.86924, 35.4543], [-120.86924, 35.4549], [-120.86899, 35.45561], [-120.86874, 35.45584], [-120.86809, 35.45584], [-120.86785, 35.45618], [-120.86776, 35.45671], [-120.86748, 35.45714], [-120.86698, 35.45737], [-120.86687, 35.45751], [-120.86684, 35.4577], [-120.86685, 35.45772], [-120.86703, 35.45772], [-120.86734, 35.45756], [-120.86782, 35.45758], [-120.86804, 35.45776], [-120.86849, 35.45829], [-120.86894, 35.45849], [-120.86905, 35.459], [-120.87003, 35.45989], [-120.87, 35.46051], [-120.86955, 35.46099], [-120.8695, 35.46245], [-120.86969, 35.46261], [-120.86953, 35.46305], [-120.86975, 35.4636], [-120.87006, 35.46374], [-120.87003, 35.46392], [-120.86987, 35.46408], [-120.86965, 35.46413], [-120.86979, 35.46441], [-120.87003, 35.46447], [-120.87039, 35.46435], [-120.87124, 35.46378], [-120.87137, 35.4638], [-120.8718, 35.46419], [-120.87247, 35.46431], [-120.87263, 35.46421], [-120.87263, 35.46371], [-120.87255, 35.46362], [-120.87213, 35.46353], [-120.87213, 35.46328], [-120.87275, 35.46245], [-120.8728, 35.46193], [-120.87249, 35.46145], [-120.87199, 35.46101], [-120.87196, 35.4608], [-120.8721, 35.46064], [-120.87221, 35.46014], [-120.87235, 35.45989], [-120.87246, 35.45911], [-120.87235, 35.45902], [-120.8721, 35.45787], [-120.87232, 35.45737], [-120.87224, 35.45712], [-120.87196, 35.45687], [-120.87193, 35.45584], [-120.87207, 35.45554], [-120.8728, 35.45449], [-120.87299, 35.45394], [-120.87347, 35.4538], [-120.87372, 35.45389], [-120.87433, 35.45364], [-120.87445, 35.45309], [-120.87456, 35.45298], [-120.87517, 35.45288], [-120.87548, 35.45263], [-120.87599, 35.4526], [-120.87649, 35.45251], [-120.87671, 35.45221], [-120.87688, 35.45141], [-120.87705, 35.45132], [-120.87887, 35.45137], [-120.87923, 35.45155], [-120.8792, 35.45201], [-120.87901, 35.45229], [-120.87878, 35.45309], [-120.87895, 35.45419], [-120.87906, 35.45428], [-120.87989, 35.45436], [-120.87968, 35.45347], [-120.88038, 35.45242], [-120.88105, 35.4519], [-120.88152, 35.45174], [-120.88186, 35.45206], [-120.88195, 35.45233], [-120.88275, 35.45295], [-120.88275, 35.45334], [-120.88301, 35.45368], [-120.88303, 35.45467], [-120.88331, 35.45503], [-120.8834, 35.45535], [-120.88362, 35.45533], [-120.88376, 35.45517], [-120.88421, 35.45503], [-120.88423, 35.45492], [-120.88401, 35.45467], [-120.8839, 35.4544], [-120.88415, 35.45371], [-120.88418, 35.45304], [-120.88454, 35.45256], [-120.88399, 35.45208], [-120.88393, 35.45085], [-120.88407, 35.45064], [-120.88432, 35.45064], [-120.88525, 35.45142], [-120.88585, 35.45146], [-120.88586, 35.45105], [-120.88642, 35.4505], [-120.88645, 35.45032], [-120.88637, 35.45027]]], [[[-120.86618, 35.45263], [-120.86596, 35.4535], [-120.8659, 35.45364], [-120.86578, 35.4538], [-120.86565, 35.45393], [-120.8641, 35.45522], [-120.86296, 35.45642], [-120.86284, 35.45652], [-120.86209, 35.45697], [-120.86188, 35.45714], [-120.86175, 35.45731], [-120.86143, 35.45786], [-120.86135, 35.45797], [-120.86044, 35.45885], [-120.86029, 35.45902], [-120.8602, 35.45918], [-120.85971, 35.4603], [-120.85972, 35.45707], [-120.86166, 35.45708], [-120.86208, 35.45655], [-120.86321, 35.45569], [-120.86444, 35.45449], [-120.86519, 35.45416], [-120.86614, 35.45262], [-120.86618, 35.45263]]], [[[-120.87522, 35.47989], [-120.87432, 35.4799], [-120.87421, 35.47782], [-120.87294, 35.47949], [-120.87296, 35.47504], [-120.87333, 35.47552], [-120.87351, 35.47578], [-120.87365, 35.47605], [-120.87383, 35.47648], [-120.87387, 35.47656], [-120.87396, 35.47663], [-120.87406, 35.47666], [-120.87436, 35.47667], [-120.87447, 35.4767], [-120.8746, 35.47679], [-120.87472, 35.47695], [-120.87476, 35.47707], [-120.87477, 35.47718], [-120.87474, 35.47731], [-120.87466, 35.47752], [-120.87465, 35.47772], [-120.87471, 35.47786], [-120.8749, 35.47815], [-120.87493, 35.47823], [-120.87497, 35.47898], [-120.8752, 35.47976], [-120.87522, 35.47989]]], [[[-120.88888, 35.44363], [-120.8874, 35.44494], [-120.8872, 35.44475], [-120.88722, 35.44433], [-120.88762, 35.44398], [-120.88832, 35.4437], [-120.8887, 35.44344], [-120.88888, 35.44363]]]]} | Restricted Access 2 | 1848 | Whale Rock Reservoir | 27446 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1098.807 | Whale Rock Reservoir | 0 | Local Recreation Area 3 | 4 | |
12760 | 12760 | 12759 | {"type": "Polygon", "coordinates": [[[-121.5371, 38.58568], [-121.53598, 38.58568], [-121.53599, 38.58453], [-121.53471, 38.58454], [-121.53471, 38.58397], [-121.5371, 38.58383], [-121.5371, 38.58568]]]} | Restricted Access 2 | 29861 | Westifield School Playsite | 31656 | 1376 | West Sacramento, City of 548 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | Yolo 33 | 6.689 | Westifield School Playsite | None 1117 | |||
15687 | 15687 | 15686 | {"type": "Polygon", "coordinates": [[[-118.41363, 33.95967], [-118.40927, 33.95968], [-118.40927, 33.95722], [-118.40942, 33.95725], [-118.40951, 33.95722], [-118.40956, 33.95713], [-118.40956, 33.95708], [-118.40953, 33.95704], [-118.40948, 33.957], [-118.40942, 33.95699], [-118.40928, 33.95702], [-118.4057, 33.95703], [-118.40454, 33.95711], [-118.40449, 33.95706], [-118.4045, 33.95483], [-118.40456, 33.95479], [-118.41077, 33.95416], [-118.41233, 33.95399], [-118.41264, 33.95412], [-118.41314, 33.95437], [-118.41362, 33.95468], [-118.41363, 33.95967]]]} | Restricted Access 2 | 15279 | Westchester Golf Course | 33047 | 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 | http://lacity.org/ | Los Angeles 6 | 90.203 | Westchester GC | 0 | Local Recreation Area 3 | 4 |
7127 | 7127 | 7126 | {"type": "Polygon", "coordinates": [[[-118.24292, 33.94311], [-118.24258, 33.94313], [-118.24261, 33.94276], [-118.24292, 33.94277], [-118.24292, 33.94311]]]} | Restricted Access 2 | 6216 | Watts Historic Train Station | 29326 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Watts Historic Train Station | 0 | Local Historic or Cultural Area 19 | 4 | |
14009 | 14009 | 14008 | {"type": "Polygon", "coordinates": [[[-116.3736, 33.7155], [-116.3736, 33.71665], [-116.37357, 33.71669], [-116.37171, 33.71671], [-116.37166, 33.71668], [-116.37165, 33.7155], [-116.3736, 33.7155]]]} | Restricted Access 2 | 39070 | Washington Charter School Park | 31654 | 1240 | Palm Desert, City of 215 | City 2 | City Agency 2 | http://www.cityofpalmdesert.org/Index.aspx?page=174 | City 2 | 1240 | Palm Desert, City of 211 | City 2 | City Agency 2 | Riverside 10 | 5.945 | Washington Charter School Park | 0 | Local Park 2 | 4 | |
14234 | 14234 | 14233 | {"type": "Polygon", "coordinates": [[[-121.9381, 37.74068], [-121.93767, 37.74085], [-121.93742, 37.74094], [-121.93721, 37.74099], [-121.93699, 37.74102], [-121.93652, 37.74105], [-121.93627, 37.74109], [-121.93549, 37.7397], [-121.93684, 37.73917], [-121.9381, 37.74068]]]} | Restricted Access 2 | 44112 | Walt Disney School Park | 27245 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 6.985 | Walt Disney School Park | 0 | Local Park 2 | 4 | |
14842 | 14842 | 14841 | {"type": "Polygon", "coordinates": [[[-117.84195, 34.02681], [-117.84059, 34.02721], [-117.84053, 34.02714], [-117.84053, 34.02709], [-117.84065, 34.02697], [-117.841, 34.02667], [-117.84138, 34.02642], [-117.84171, 34.02625], [-117.84195, 34.02681]]]} | Restricted Access 2 | 48150 | Walnut Senior Center | 32683 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 1.479 | Walnut Senior Ctr. | 0 | Local Recreation Area 3 | 4 | |
16194 | 16194 | 16193 | {"type": "Polygon", "coordinates": [[[-117.83355, 34.08758], [-117.83349, 34.08776], [-117.83351, 34.08798], [-117.83313, 34.08799], [-117.83269, 34.08803], [-117.83225, 34.08809], [-117.83181, 34.08819], [-117.83139, 34.08831], [-117.83098, 34.08845], [-117.83059, 34.08863], [-117.83024, 34.08881], [-117.82997, 34.08875], [-117.82981, 34.08893], [-117.82968, 34.08891], [-117.82925, 34.08877], [-117.82931, 34.08857], [-117.82933, 34.08826], [-117.83341, 34.08717], [-117.83355, 34.08758]]]} | Restricted Access 2 | 29519 | Walnut Creek Habitat & Open Space | 27224 | 1298 | San Dimas, City of 237 | City 2 | City Agency 2 | http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 | City 2 | 1298 | San Dimas, City of 233 | City 2 | City Agency 2 | Los Angeles 6 | 7.17 | Walnut Creek Habitat & OS | 0 | Local Recreation Area 3 | 4 | |
9130 | 9130 | 9129 | {"type": "Polygon", "coordinates": [[[-118.1982, 34.0513], [-118.19807, 34.0515], [-118.19808, 34.05158], [-118.19791, 34.05157], [-118.19774, 34.05153], [-118.19725, 34.05132], [-118.19747, 34.05098], [-118.1982, 34.0513]]]} | Restricted Access 2 | 15135 | Wabash Recreation Center | 28866 | 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.784 | Wabash Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
2998 | 2998 | 2997 | {"type": "Polygon", "coordinates": [[[-117.78863, 34.0562], [-117.78469, 34.05669], [-117.78406, 34.05571], [-117.78833, 34.05518], [-117.78863, 34.0562]]]} | Restricted Access 2 | 20562 | Veterans Park Soccer Complex | 29804 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/84-veterans-park | Los Angeles 6 | 10.986 | Veterans Park Soccer Complex | 0 | Local Recreation Area 3 | 4 |
15294 | 15294 | 15293 | {"type": "Polygon", "coordinates": [[[-118.23026, 34.16966], [-118.23015, 34.16981], [-118.2301, 34.16985], [-118.23004, 34.16995], [-118.22998, 34.16996], [-118.2299, 34.16992], [-118.22991, 34.16982], [-118.22989, 34.16978], [-118.22982, 34.16973], [-118.22962, 34.1697], [-118.22975, 34.16956], [-118.2298, 34.16948], [-118.23026, 34.16966]]]} | Restricted Access 2 | 46426 | Verdugo Skate Park | 29697 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/verdugo-skate-park | Los Angeles 6 | 0.355 | Verdugo Skate Park | 2004 | 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]);