units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
52 rows where MNG_AGENCY = 142 and MNG_AG_TYP = 1 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, PARK_URL, COUNTY, GAP_STS
DES_TP 11
- Recreation Management Area 29
- Resource Management Area 14
- Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- Federal Agency · 52 ✖
MNG_AGENCY 1
- United States Army Corps of Engineers · 52 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
356 | 356 | 355 | {"type": "Polygon", "coordinates": [[[-122.49396, 38.11519], [-122.49396, 38.11668], [-122.49389, 38.11699], [-122.49376, 38.11735], [-122.49339, 38.11788], [-122.49311, 38.11825], [-122.49275, 38.11856], [-122.49241, 38.1189], [-122.49231, 38.1192], [-122.49228, 38.11936], [-122.49071, 38.12038], [-122.48879, 38.12141], [-122.48651, 38.12238], [-122.47257, 38.12807], [-122.47183, 38.12772], [-122.48389, 38.1232], [-122.49205, 38.11836], [-122.49375, 38.11703], [-122.49245, 38.11561], [-122.4906, 38.11561], [-122.49396, 38.11519]]]} | Restricted Access 2 | 982 | Sonoma Baylands | 25608 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Sonoma 16 | 37.517 | Sonoma Baylands | None 36 | |||
465 | 465 | 464 | {"type": "Polygon", "coordinates": [[[-118.48671, 34.16591], [-118.48664, 34.16649], [-118.48663, 34.16717], [-118.48664, 34.16724], [-118.48669, 34.16733], [-118.48656, 34.1675], [-118.48638, 34.16753], [-118.48622, 34.16759], [-118.48616, 34.16766], [-118.48614, 34.16773], [-118.4862, 34.16804], [-118.48623, 34.16809], [-118.48628, 34.16811], [-118.48608, 34.16815], [-118.4861, 34.1681], [-118.48604, 34.16774], [-118.48591, 34.16777], [-118.48581, 34.1677], [-118.48557, 34.16772], [-118.48516, 34.16783], [-118.48494, 34.16787], [-118.48445, 34.16789], [-118.48418, 34.16787], [-118.48385, 34.1678], [-118.48369, 34.16772], [-118.48359, 34.1676], [-118.48357, 34.16755], [-118.48351, 34.1671], [-118.48355, 34.16638], [-118.48357, 34.16623], [-118.48362, 34.16609], [-118.48368, 34.16599], [-118.48374, 34.16594], [-118.48387, 34.1659], [-118.4853, 34.16589], [-118.48633, 34.16583], [-118.48634, 34.16591], [-118.48639, 34.16594], [-118.48671, 34.16591]]]} | Open Access 1 | 1861 | Hjelte Sports Center | 20010 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 14.721 | Hjelte Sports Ctr. | 0 | Recreation Management Area 49 | 4 | |
710 | 710 | 709 | {"type": "Polygon", "coordinates": [[[-122.49778, 38.11503], [-122.49513, 38.11705], [-122.49391, 38.11801], [-122.49231, 38.1192], [-122.49241, 38.1189], [-122.49275, 38.11856], [-122.49311, 38.11825], [-122.49339, 38.11787], [-122.49376, 38.11735], [-122.49389, 38.11699], [-122.49396, 38.11668], [-122.49396, 38.11519], [-122.49778, 38.11503]]]} | No Public Access 3 | 4004 | Sonoma Baylands | 25607 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Sonoma 16 | 14.555 | Sonoma Baylands | None 66 | |||
1162 | 1162 | 1161 | {"type": "Polygon", "coordinates": [[[-117.68625, 34.15373], [-117.68578, 34.15427], [-117.68557, 34.15448], [-117.68493, 34.15499], [-117.6846, 34.15528], [-117.6843, 34.15564], [-117.68412, 34.15595], [-117.684, 34.15622], [-117.6839, 34.1566], [-117.68388, 34.15675], [-117.68382, 34.15766], [-117.68376, 34.15794], [-117.68368, 34.15812], [-117.68357, 34.15832], [-117.68344, 34.15847], [-117.68287, 34.15907], [-117.68274, 34.15924], [-117.68258, 34.15954], [-117.68245, 34.15995], [-117.68242, 34.16023], [-117.68245, 34.16069], [-117.68245, 34.16105], [-117.68208, 34.16106], [-117.68184, 34.16148], [-117.68206, 34.16189], [-117.68218, 34.16224], [-117.68202, 34.16262], [-117.6817, 34.16279], [-117.68157, 34.16302], [-117.68115, 34.16313], [-117.68121, 34.16295], [-117.68133, 34.1628], [-117.68117, 34.1626], [-117.68101, 34.16231], [-117.68074, 34.16231], [-117.68054, 34.16287], [-117.6798, 34.16408], [-117.6797, 34.16453], [-117.67949, 34.16491], [-117.67921, 34.16514], [-117.67876, 34.1658], [-117.67853, 34.1662], [-117.67814, 34.16752], [-117.67796, 34.16804], [-117.67739, 34.17048], [-117.67647, 34.17048], [-117.67648, 34.17002], [-117.67851, 34.16199], [-117.68171, 34.15583], [-117.68322, 34.15063], [-117.68362, 34.15063], [-117.68354, 34.15367], [-117.68625, 34.15373]]]} | No Public Access 3 | 6785 | San Antonio Channel & Dam | 24827 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 102.402 | San Antonio Channel & Dam | 0 | Resource Management Area 82 | 3 | |
1526 | 1526 | 1525 | {"type": "Polygon", "coordinates": [[[-118.50099, 34.17906], [-118.49854, 34.17803], [-118.49442, 34.17649], [-118.48937, 34.17455], [-118.47912, 34.17066], [-118.48, 34.17022], [-118.48079, 34.16993], [-118.48155, 34.16969], [-118.48232, 34.16949], [-118.48336, 34.16927], [-118.48464, 34.16886], [-118.48587, 34.16861], [-118.48659, 34.16843], [-118.48732, 34.16823], [-118.48784, 34.16822], [-118.48841, 34.16791], [-118.48987, 34.16748], [-118.49042, 34.16735], [-118.49087, 34.16727], [-118.49143, 34.16721], [-118.492, 34.1672], [-118.49256, 34.16722], [-118.49313, 34.16728], [-118.49369, 34.16739], [-118.49412, 34.1675], [-118.49465, 34.16768], [-118.49526, 34.16794], [-118.49583, 34.16825], [-118.49636, 34.16861], [-118.49669, 34.16888], [-118.49692, 34.16909], [-118.49738, 34.16963], [-118.49767, 34.1701], [-118.49815, 34.17079], [-118.49842, 34.17144], [-118.49856, 34.17168], [-118.49871, 34.17186], [-118.49887, 34.17201], [-118.49905, 34.17213], [-118.49927, 34.17223], [-118.49953, 34.17249], [-118.50001, 34.17249], [-118.50089, 34.17236], [-118.50092, 34.17238], [-118.50093, 34.17592], [-118.50098, 34.17593], [-118.50099, 34.17906]]]} | Restricted Access 2 | 12883 | Balboa Golf Course & Encino Golf Course | 33032 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 320.852 | Balboa GC & Encino GC | 0 | Recreation Management Area 49 | 4 | |
3129 | 3129 | 3128 | {"type": "MultiPolygon", "coordinates": [[[[-120.20207, 37.13415], [-120.20207, 37.13449], [-120.20152, 37.13451], [-120.20131, 37.13451], [-120.20105, 37.13446], [-120.20079, 37.13437], [-120.19586, 37.13211], [-120.19264, 37.1301], [-120.19236, 37.12991], [-120.19219, 37.12982], [-120.19198, 37.12974], [-120.1916, 37.12964], [-120.19133, 37.12962], [-120.19109, 37.12962], [-120.18887, 37.12995], [-120.18886, 37.12996], [-120.18902, 37.13022], [-120.18406, 37.13106], [-120.18407, 37.12916], [-120.18436, 37.12914], [-120.18504, 37.12897], [-120.18623, 37.12879], [-120.18751, 37.12855], [-120.18812, 37.1284], [-120.1887, 37.12966], [-120.19099, 37.12929], [-120.19127, 37.12928], [-120.19151, 37.1293], [-120.19175, 37.12933], [-120.19202, 37.12939], [-120.19235, 37.12951], [-120.19259, 37.12963], [-120.19617, 37.13183], [-120.201, 37.13407], [-120.20111, 37.13414], [-120.20121, 37.13417], [-120.20134, 37.13418], [-120.20207, 37.13415]]], [[[-120.18786, 37.12782], [-120.18688, 37.1281], [-120.18514, 37.12848], [-120.18407, 37.12864], [-120.18407, 37.12724], [-120.18761, 37.12726], [-120.18786, 37.12782]]], [[[-120.19316, 37.12631], [-120.19316, 37.12665], [-120.1915, 37.12715], [-120.18701, 37.12712], [-120.18727, 37.12685], [-120.191, 37.1269], [-120.19192, 37.12674], [-120.19316, 37.12631]]]]} | Open Access 1 | 25780 | Berenda Reservoir | 16018 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Madera 48 | 47.282 | Berenda Reservoir | 0 | Resource Management Area 82 | 3 | |
4053 | 4053 | 4052 | {"type": "Polygon", "coordinates": [[[-120.63426, 37.85934], [-120.63377, 37.86008], [-120.63222, 37.86096], [-120.63246, 37.86129], [-120.63243, 37.86133], [-120.63134, 37.86171], [-120.63, 37.86242], [-120.62992, 37.8625], [-120.6297, 37.8621], [-120.62844, 37.86263], [-120.62838, 37.86143], [-120.62837, 37.86142], [-120.62757, 37.86181], [-120.627, 37.86214], [-120.62667, 37.86238], [-120.62626, 37.86279], [-120.62597, 37.86317], [-120.62588, 37.86306], [-120.62646, 37.86246], [-120.62671, 37.86225], [-120.62838, 37.86135], [-120.62883, 37.86124], [-120.62922, 37.86146], [-120.62971, 37.86134], [-120.63001, 37.86097], [-120.63166, 37.86028], [-120.6323, 37.85981], [-120.63255, 37.85869], [-120.63325, 37.85868], [-120.63426, 37.85934]]]} | Open Access 1 | 44370 | Goodwin Dam Recreation Area | 19404 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Tuolumne 21 | 18.684 | Goodwin Dam Rec. Area | 0 | Recreation Management Area 49 | 4 | |
4884 | 4884 | 4883 | {"type": "MultiPolygon", "coordinates": [[[[-118.08173, 34.04994], [-118.0805, 34.04993], [-118.07751, 34.04834], [-118.07751, 34.04837], [-118.08049, 34.04996], [-118.08013, 34.04996], [-118.08012, 34.04997], [-118.08074, 34.05031], [-118.08073, 34.05157], [-118.07969, 34.05156], [-118.07753, 34.05168], [-118.07752, 34.05165], [-118.07733, 34.05166], [-118.07732, 34.05169], [-118.07317, 34.05171], [-118.07316, 34.05168], [-118.07307, 34.05168], [-118.07312, 34.04139], [-118.07467, 34.04125], [-118.07526, 34.04117], [-118.07525, 34.04275], [-118.07528, 34.04276], [-118.07529, 34.04116], [-118.07647, 34.04099], [-118.07643, 34.0414], [-118.07572, 34.04156], [-118.07534, 34.04238], [-118.07559, 34.04268], [-118.0763, 34.04268], [-118.07649, 34.04247], [-118.07747, 34.04247], [-118.07748, 34.04209], [-118.07802, 34.04182], [-118.07839, 34.04182], [-118.0791, 34.04225], [-118.07943, 34.04272], [-118.07964, 34.04272], [-118.07965, 34.04362], [-118.08009, 34.04362], [-118.0801, 34.04407], [-118.08087, 34.04407], [-118.08088, 34.04451], [-118.08114, 34.04452], [-118.08114, 34.04512], [-118.0817, 34.04512], [-118.08173, 34.04994]], [[-118.07717, 34.04812], [-118.07728, 34.04818], [-118.0773, 34.04818], [-118.07729, 34.04815], [-118.07602, 34.04748], [-118.07556, 34.04718], [-118.07541, 34.04706], [-118.07513, 34.04677], [-118.07499, 34.04658], [-118.07485, 34.04634], [-118.07471, 34.04603], [-118.07464, 34.04577], [-118.07528, 34.04458], [-118.07528, 34.04449], [-118.07525, 34.04449], [-118.07524, 34.04457], [-118.07434, 34.04628], [-118.07421, 34.04779], [-118.07318, 34.04991], [-118.07318, 34.04997], [-118.0732, 34.04997], [-118.07425, 34.0478], [-118.07437, 34.04628], [-118.07462, 34.04582], [-118.07468, 34.04603], [-118.07475, 34.04621], [-118.0749, 34.0465], [-118.07504, 34.0467], [-118.07538, 34.04707], [-118.07565, 34.04729], [-118.07595, 34.04747], [-118.07717, 34.04812]]], [[[-118.08027, 34.05174], [-118.08023, 34.05182], [-118.07834, 34.05181], [-118.07833, 34.05424], [-118.07813, 34.05438], [-118.07758, 34.05533], [-118.07756, 34.05534], [-118.07753, 34.05542], [-118.07671, 34.05543], [-118.07671, 34.05634], [-118.07648, 34.05719], [-118.0757, 34.05687], [-118.07535, 34.05699], [-118.07486, 34.05751], [-118.07467, 34.05792], [-118.07424, 34.05812], [-118.07362, 34.05794], [-118.07302, 34.05794], [-118.07301, 34.05872], [-118.0719, 34.05755], [-118.07222, 34.05543], [-118.073, 34.05542], [-118.07299, 34.0519], [-118.07318, 34.0519], [-118.07318, 34.05187], [-118.07743, 34.05185], [-118.07965, 34.05174], [-118.08027, 34.05174]]]]} | Restricted Access 2 | 6566 | Whittier Narrows Golf Course | 33010 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 268.099 | Whittier Narrows GC | 0 | Recreation Management Area 49 | 4 | |
5413 | 5413 | 5412 | {"type": "MultiPolygon", "coordinates": [[[[-118.22858, 33.88759], [-118.22857, 33.88759], [-118.22835, 33.88727], [-118.22846, 33.88739], [-118.22858, 33.88759]]], [[[-118.24226, 33.90419], [-118.24209, 33.90423], [-118.24193, 33.90397], [-118.24191, 33.9036], [-118.24216, 33.90405], [-118.24226, 33.90419]]], [[[-118.24858, 33.91176], [-118.24841, 33.91176], [-118.24735, 33.91049], [-118.24755, 33.9105], [-118.24857, 33.91171], [-118.24858, 33.91176]]]]} | Open Access 1 | 7202 | Compton Creek & Bike Path | 17571 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 0.849 | Compton Creek & Bike Path | 0 | Recreation Management Area 49 | 4 | |
6010 | 6010 | 6009 | {"type": "Polygon", "coordinates": [[[-118.50547, 34.18013], [-118.50135, 34.18014], [-118.50135, 34.17454], [-118.5013, 34.17234], [-118.50547, 34.17239], [-118.50547, 34.18013]]]} | Open Access 1 | 665 | Balboa Sports Center | 15773 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 81.108 | Balboa Sports Ctr. | 0 | Recreation Management Area 49 | 4 | |
6412 | 6412 | 6411 | {"type": "MultiPolygon", "coordinates": [[[[-118.49126, 34.18526], [-118.49096, 34.18527], [-118.48979, 34.1852], [-118.48979, 34.18557], [-118.48918, 34.18558], [-118.48917, 34.18609], [-118.48587, 34.18609], [-118.48586, 34.18521], [-118.48387, 34.1852], [-118.48387, 34.18494], [-118.48458, 34.18493], [-118.48647, 34.18422], [-118.48811, 34.18393], [-118.48813, 34.18462], [-118.49122, 34.18458], [-118.49126, 34.18526]]], [[[-118.50099, 34.18172], [-118.50093, 34.18174], [-118.50079, 34.18175], [-118.50064, 34.18171], [-118.50016, 34.18144], [-118.50004, 34.18139], [-118.49962, 34.18137], [-118.49941, 34.18129], [-118.49856, 34.18058], [-118.49842, 34.18053], [-118.49826, 34.18052], [-118.49761, 34.18051], [-118.49763, 34.18229], [-118.49715, 34.18294], [-118.49679, 34.18321], [-118.49347, 34.18436], [-118.49351, 34.18461], [-118.49351, 34.18487], [-118.49344, 34.18507], [-118.49331, 34.18519], [-118.49305, 34.18528], [-118.49246, 34.18527], [-118.49251, 34.1807], [-118.49249, 34.18068], [-118.4925, 34.17711], [-118.49395, 34.17767], [-118.49604, 34.17826], [-118.50099, 34.18021], [-118.50099, 34.18172]]]]} | Open Access 1 | 3334 | Lake Balboa Park | 20875 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 110.991 | Lake Balboa Park | 0 | Recreation Management Area 49 | 4 | |
7058 | 7058 | 7057 | {"type": "Polygon", "coordinates": [[[-118.06181, 34.02017], [-118.06089, 34.02054], [-118.06107, 34.02082], [-118.06117, 34.02082], [-118.06121, 34.02141], [-118.05671, 34.02154], [-118.0577, 34.02122], [-118.05703, 34.01992], [-118.05747, 34.01907], [-118.05897, 34.01802], [-118.06078, 34.01739], [-118.06033, 34.01796], [-118.05961, 34.01857], [-118.0607, 34.02026], [-118.06181, 34.02017]]]} | Restricted Access 2 | 6569 | Pico Rivera Golf Course | 33017 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 26.31 | Pico Rivera GC | 0 | Recreation Management Area 49 | 4 | |
7280 | 7280 | 7279 | {"type": "MultiPolygon", "coordinates": [[[[-118.07223, 34.05905], [-118.07151, 34.05982], [-118.07104, 34.06086], [-118.07094, 34.06104], [-118.06981, 34.06232], [-118.06997, 34.06256], [-118.06964, 34.06256], [-118.07093, 34.06059], [-118.07092, 34.06052], [-118.06959, 34.06256], [-118.06763, 34.06256], [-118.06906, 34.06137], [-118.06934, 34.06104], [-118.06956, 34.06068], [-118.06965, 34.06049], [-118.06976, 34.06012], [-118.07026, 34.05725], [-118.07195, 34.05724], [-118.0719, 34.05755], [-118.07187, 34.05754], [-118.07164, 34.05893], [-118.07223, 34.05893], [-118.07223, 34.05905]]], [[[-118.06908, 34.06284], [-118.06876, 34.06313], [-118.06883, 34.06321], [-118.06867, 34.06332], [-118.06859, 34.06326], [-118.0681, 34.06363], [-118.06805, 34.06415], [-118.06797, 34.06422], [-118.06775, 34.06427], [-118.06774, 34.06391], [-118.06773, 34.0639], [-118.06717, 34.06433], [-118.06717, 34.06434], [-118.06721, 34.06437], [-118.06718, 34.06438], [-118.06632, 34.06357], [-118.06714, 34.06297], [-118.06715, 34.06292], [-118.06725, 34.06284], [-118.06908, 34.06284]]], [[[-118.06672, 34.06464], [-118.06662, 34.06466], [-118.06572, 34.06519], [-118.0656, 34.06508], [-118.06526, 34.06526], [-118.0646, 34.06571], [-118.06381, 34.06571], [-118.06493, 34.06491], [-118.06518, 34.06471], [-118.06559, 34.06431], [-118.06572, 34.06421], [-118.06605, 34.064], [-118.06672, 34.06464]]], [[[-118.06408, 34.06584], [-118.06348, 34.06628], [-118.06328, 34.06608], [-118.06362, 34.06584], [-118.06408, 34.06584]]]]} | Open Access 1 | 6565 | Rio Hondo | 24379 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 33.327 | Rio Hondo | 0 | None 601 | ||
7289 | 7289 | 7288 | {"type": "MultiPolygon", "coordinates": [[[[-118.06004, 34.01551], [-118.05873, 34.0164], [-118.05805, 34.01692], [-118.0576, 34.0173], [-118.05827, 34.01767], [-118.05897, 34.01802], [-118.05747, 34.01907], [-118.05703, 34.01992], [-118.05593, 34.02051], [-118.0549, 34.02084], [-118.05395, 34.02158], [-118.05387, 34.02199], [-118.05295, 34.02135], [-118.05295, 34.02132], [-118.05137, 34.02026], [-118.05138, 34.02024], [-118.05053, 34.01967], [-118.0522, 34.01846], [-118.05317, 34.01829], [-118.05338, 34.01842], [-118.054, 34.01837], [-118.05434, 34.01784], [-118.0559, 34.01773], [-118.0575, 34.01641], [-118.05641, 34.01534], [-118.05752, 34.01455], [-118.05859, 34.01559], [-118.05927, 34.01514], [-118.06004, 34.01551]]], [[[-118.07861, 34.01711], [-118.07843, 34.01748], [-118.07832, 34.01765], [-118.07816, 34.01788], [-118.07791, 34.01819], [-118.07766, 34.01848], [-118.07744, 34.01869], [-118.0769, 34.01914], [-118.07637, 34.01948], [-118.07315, 34.02126], [-118.07286, 34.02143], [-118.07234, 34.02179], [-118.07178, 34.02229], [-118.0715, 34.02259], [-118.07118, 34.023], [-118.07101, 34.02324], [-118.06794, 34.02829], [-118.06785, 34.02831], [-118.06734, 34.02812], [-118.06696, 34.02802], [-118.06645, 34.02795], [-118.05777, 34.02462], [-118.05458, 34.02336], [-118.05406, 34.02414], [-118.0539, 34.02251], [-118.05402, 34.02209], [-118.05438, 34.02235], [-118.05503, 34.02278], [-118.05571, 34.02199], [-118.05622, 34.0217], [-118.05671, 34.02154], [-118.0612, 34.02141], [-118.06117, 34.02082], [-118.06902, 34.02046], [-118.06905, 34.02101], [-118.07253, 34.02084], [-118.07409, 34.02003], [-118.07431, 34.02006], [-118.07583, 34.01928], [-118.07629, 34.01901], [-118.07663, 34.01877], [-118.07688, 34.01858], [-118.07712, 34.01838], [-118.07748, 34.01803], [-118.0779, 34.01751], [-118.07825, 34.01698], [-118.07858, 34.01705], [-118.07861, 34.01711]]], [[[-118.061, 34.01708], [-118.06078, 34.01739], [-118.06049, 34.01666], [-118.06078, 34.01689], [-118.061, 34.01708]]], [[[-118.08765, 34.02294], [-118.08759, 34.02301], [-118.08732, 34.02322], [-118.08691, 34.02347], [-118.086, 34.02381], [-118.08518, 34.02419], [-118.08318, 34.02537], [-118.08275, 34.02555], [-118.08236, 34.02565], [-118.08211, 34.02568], [-118.08176, 34.02568], [-118.08063, 34.02561], [-118.07954, 34.02604], [-118.07683, 34.02666], [-118.0758, 34.02683], [-118.07506, 34.02709], [-118.07491, 34.02727], [-118.07484, 34.02752], [-118.07463, 34.02807], [-118.07407, 34.02903], [-118.07397, 34.02927], [-118.07388, 34.02937], [-118.07209, 34.02923], [-118.07201, 34.02963], [-118.07129, 34.02955], [-118.07151, 34.02914], [-118.07279, 34.02772], [-118.07565, 34.0256], [-118.07771, 34.02455], [-118.07809, 34.02411], [-118.07806, 34.02411], [-118.07769, 34.02454], [-118.07562, 34.02558], [-118.07277, 34.0277], [-118.07148, 34.02913], [-118.07125, 34.02954], [-118.07048, 34.02946], [-118.06906, 34.02892], [-118.06911, 34.02881], [-118.06831, 34.0285], [-118.06828, 34.02844], [-118.07138, 34.02337], [-118.07188, 34.02273], [-118.07241, 34.02222], [-118.07283, 34.02189], [-118.07328, 34.02159], [-118.07651, 34.0198], [-118.0769, 34.01956], [-118.07735, 34.01924], [-118.07785, 34.0188], [-118.07822, 34.0184], [-118.07842, 34.01815], [-118.07872, 34.01772], [-118.07888, 34.01744], [-118.07908, 34.01704], [-118.08031, 34.01676], [-118.07951, 34.017], [-118.07938, 34.01705], [-118.07918, 34.01749], [-118.07892, 34.01793], [-118.07893, 34.01794], [-118.07958, 34.01783], [-118.08009, 34.01779], [-118.08078, 34.0178], [-118.08127, 34.01786], [-118.08179, 34.01797], [-118.08204, 34.01804], [-118.08267, 34.01828], [-118.08318, 34.01854], [-118.08365, 34.01886], [-118.08493, 34.01795], [-118.08599, 34.019], [-118.08475, 34.01988], [-118.08504, 34.0202], [-118.08531, 34.02055], [-118.08551, 34.02088], [-118.08549, 34.0209], [-118.08553, 34.02092], [-118.08567, 34.02118], [-118.08582, 34.02151], [-118.08594, 34.02187], [-118.08602, 34.02218], [-118.08572, 34.02214], [-118.0858, 34.02267], [-118.08609, 34.02274], [-118.08612, 34.02311], [-118.08728, 34.02311], [-118.08744, 34.02298], [-118.08754, 34.02288], [-118.08765, 34.02294]]], [[[-118.07973, 34.01611], [-118.07954, 34.01674], [-118.07924, 34.01681], [-118.07921, 34.0168], [-118.0792, 34.01676], [-118.07931, 34.01638], [-118.07934, 34.01637], [-118.07936, 34.01633], [-118.07933, 34.01631], [-118.07936, 34.01624], [-118.07946, 34.01618], [-118.07973, 34.01611]]], [[[-118.08786, 34.02308], [-118.08756, 34.02334], [-118.08718, 34.02359], [-118.08683, 34.02375], [-118.08612, 34.02401], [-118.08548, 34.02438], [-118.08553, 34.02444], [-118.08495, 34.02492], [-118.0853, 34.02531], [-118.08535, 34.02563], [-118.08466, 34.02594], [-118.08411, 34.02502], [-118.08516, 34.0244], [-118.08556, 34.02419], [-118.08598, 34.02401], [-118.08684, 34.02369], [-118.08711, 34.02357], [-118.08748, 34.02334], [-118.08781, 34.02305], [-118.08786, 34.02308]]]]} | Restricted Access 2 | 6568 | Whittier Narrows Dam | 27479 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 568.969 | Whittier Narrows Dam | 0 | Resource Management Area 82 | 3 | |
7939 | 7939 | 7938 | {"type": "Polygon", "coordinates": [[[-117.95634, 33.63093], [-117.95288, 33.64311], [-117.95175, 33.64313], [-117.95345, 33.63665], [-117.95199, 33.63459], [-117.95135, 33.63437], [-117.95087, 33.63372], [-117.95103, 33.63333], [-117.94856, 33.63291], [-117.94753, 33.63218], [-117.94809, 33.6321], [-117.94897, 33.63202], [-117.94984, 33.6315], [-117.95035, 33.63024], [-117.95123, 33.6295], [-117.95193, 33.62931], [-117.9528, 33.62956], [-117.95343, 33.62978], [-117.95493, 33.63058], [-117.95634, 33.63093]]]} | Open Access 1 | 10770 | Salt Marsh Restoration | 24811 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Orange 3 | 101.681 | Salt Marsh Restoration | None 660 | |||
8001 | 8001 | 8000 | {"type": "Polygon", "coordinates": [[[-122.51612, 38.78782], [-122.51607, 38.78848], [-122.51598, 38.78899], [-122.51594, 38.7894], [-122.5158, 38.78991], [-122.51562, 38.79035], [-122.51537, 38.7908], [-122.51516, 38.79114], [-122.51473, 38.79152], [-122.51393, 38.79201], [-122.51347, 38.79227], [-122.51293, 38.79235], [-122.51216, 38.79226], [-122.51186, 38.79219], [-122.51069, 38.79201], [-122.51012, 38.79196], [-122.51012, 38.79106], [-122.50107, 38.79096], [-122.49151, 38.7907], [-122.49123, 38.79432], [-122.48652, 38.7942], [-122.48671, 38.79057], [-122.48194, 38.79044], [-122.48188, 38.79214], [-122.48129, 38.79189], [-122.48107, 38.79177], [-122.48088, 38.79164], [-122.4807, 38.79145], [-122.48046, 38.79125], [-122.48022, 38.7911], [-122.48001, 38.79093], [-122.47977, 38.79071], [-122.47962, 38.79051], [-122.47943, 38.79033], [-122.47741, 38.79023], [-122.47748, 38.7866], [-122.48204, 38.78678], [-122.48216, 38.78314], [-122.49496, 38.77032], [-122.49673, 38.7718], [-122.50565, 38.77269], [-122.50628, 38.77324], [-122.51133, 38.77737], [-122.51504, 38.78693], [-122.51612, 38.78782]]]} | Open Access 1 | 11115 | Department of Defense | 18095 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Lake 40 | 1307.764 | Department of Defense | None 668 | |||
8114 | 8114 | 8113 | {"type": "MultiPolygon", "coordinates": [[[[-118.49444, 34.16485], [-118.49256, 34.16484], [-118.49252, 34.16479], [-118.49252, 34.16402], [-118.49444, 34.16402], [-118.49444, 34.16485]]], [[[-118.49868, 34.16866], [-118.49868, 34.16878], [-118.49696, 34.16775], [-118.49431, 34.16604], [-118.49381, 34.16578], [-118.4935, 34.16564], [-118.49295, 34.16543], [-118.49252, 34.1653], [-118.49253, 34.16504], [-118.49257, 34.16501], [-118.49601, 34.16502], [-118.49602, 34.16639], [-118.49867, 34.16641], [-118.49868, 34.16866]]]]} | Open Access 1 | 12239 | Sepulveda Garden Center | 25304 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 24.1 | Sepulveda Garden Ctr. | None 677 | |||
8199 | 8199 | 8198 | {"type": "MultiPolygon", "coordinates": [[[[-118.41192, 34.30466], [-118.41068, 34.30557], [-118.40898, 34.30398], [-118.40892, 34.30416], [-118.41053, 34.30568], [-118.40755, 34.30785], [-118.40753, 34.3079], [-118.40684, 34.30791], [-118.40702, 34.30699], [-118.40687, 34.30638], [-118.40668, 34.30644], [-118.40655, 34.30641], [-118.40685, 34.30618], [-118.40733, 34.30605], [-118.40767, 34.3052], [-118.40766, 34.30519], [-118.40753, 34.30518], [-118.40761, 34.30442], [-118.40774, 34.30388], [-118.40879, 34.30236], [-118.40906, 34.30219], [-118.40936, 34.30229], [-118.40954, 34.30196], [-118.40968, 34.30176], [-118.41031, 34.30204], [-118.41001, 34.30253], [-118.41191, 34.30338], [-118.4117, 34.30415], [-118.41192, 34.30466]]], [[[-118.41297, 34.30697], [-118.41202, 34.30909], [-118.41195, 34.30938], [-118.41166, 34.30947], [-118.4113, 34.30955], [-118.41094, 34.3096], [-118.41057, 34.30961], [-118.40749, 34.3094], [-118.40745, 34.30938], [-118.40743, 34.30868], [-118.40746, 34.30848], [-118.4076, 34.30811], [-118.40756, 34.30807], [-118.41066, 34.3058], [-118.41184, 34.30691], [-118.41185, 34.30691], [-118.41187, 34.30669], [-118.41081, 34.30569], [-118.41208, 34.30477], [-118.4123, 34.30503], [-118.4125, 34.30531], [-118.41297, 34.30697]]], [[[-118.412, 34.31043], [-118.41147, 34.31141], [-118.4113, 34.31165], [-118.41041, 34.31081], [-118.4119, 34.30973], [-118.412, 34.31043]]], [[[-118.41175, 34.30962], [-118.4109, 34.31024], [-118.40853, 34.31197], [-118.40856, 34.30964], [-118.41057, 34.30978], [-118.41115, 34.30974], [-118.41141, 34.3097], [-118.41175, 34.30962]]], [[[-118.4089, 34.31192], [-118.40887, 34.31212], [-118.40862, 34.31212], [-118.4089, 34.31192], [-118.4089, 34.31192]]]]} | No Public Access 3 | 12454 | Lopez Reservoir and Dam | 21465 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 92.431 | Lopez Reservoir and Dam | 0 | Resource Management Area 82 | 3 | |
9292 | 9292 | 9291 | {"type": "Polygon", "coordinates": [[[-118.48334, 34.18454], [-118.48156, 34.18453], [-118.48146, 34.18002], [-118.47682, 34.18003], [-118.4768, 34.18277], [-118.47502, 34.18278], [-118.47502, 34.1843], [-118.47497, 34.18431], [-118.47497, 34.18582], [-118.4748, 34.18577], [-118.47414, 34.18547], [-118.47379, 34.18465], [-118.47356, 34.18422], [-118.47335, 34.18389], [-118.47311, 34.18357], [-118.47286, 34.18327], [-118.47009, 34.17951], [-118.47255, 34.17833], [-118.47407, 34.17877], [-118.47488, 34.17867], [-118.47491, 34.17728], [-118.47636, 34.17727], [-118.47652, 34.17755], [-118.47764, 34.17695], [-118.47783, 34.17716], [-118.4782, 34.17745], [-118.47851, 34.17758], [-118.48012, 34.17868], [-118.48017, 34.17865], [-118.48195, 34.17984], [-118.48198, 34.17982], [-118.48274, 34.18035], [-118.48301, 34.18063], [-118.48315, 34.1808], [-118.48328, 34.18103], [-118.48335, 34.1812], [-118.48343, 34.18154], [-118.48344, 34.18362], [-118.48335, 34.18389], [-118.48334, 34.18454]]]} | Open Access 1 | 15480 | Woodley Avenue Park | 27729 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 119.888 | Woodley Avenue Park | 0 | Recreation Management Area 49 | 4 | |
9903 | 9903 | 9902 | {"type": "Polygon", "coordinates": [[[-120.7739, 37.7927], [-120.77322, 37.79285], [-120.77164, 37.79236], [-120.76957, 37.7921], [-120.76865, 37.79188], [-120.76749, 37.79128], [-120.76755, 37.79123], [-120.76755, 37.79122], [-120.76728, 37.79108], [-120.76722, 37.79113], [-120.767, 37.79101], [-120.76646, 37.79083], [-120.76346, 37.79052], [-120.76278, 37.79031], [-120.7628, 37.79023], [-120.7623, 37.79007], [-120.76196, 37.78989], [-120.76187, 37.78981], [-120.7618, 37.78973], [-120.76168, 37.78963], [-120.76164, 37.78954], [-120.76156, 37.78946], [-120.76149, 37.78928], [-120.76187, 37.78901], [-120.76279, 37.78841], [-120.76306, 37.7888], [-120.76333, 37.78906], [-120.76406, 37.78952], [-120.76436, 37.78977], [-120.76462, 37.79011], [-120.76495, 37.7903], [-120.76532, 37.79038], [-120.76563, 37.79056], [-120.76598, 37.79061], [-120.7663, 37.79063], [-120.76685, 37.79076], [-120.76706, 37.79086], [-120.76727, 37.79091], [-120.76769, 37.79094], [-120.76799, 37.79105], [-120.76824, 37.79119], [-120.76868, 37.79131], [-120.76899, 37.79142], [-120.76932, 37.79152], [-120.76973, 37.79158], [-120.77008, 37.79175], [-120.77082, 37.79188], [-120.77112, 37.79192], [-120.77182, 37.79208], [-120.77211, 37.79209], [-120.77259, 37.7922], [-120.77319, 37.79236], [-120.77374, 37.79233], [-120.7739, 37.7927]]]} | Open Access 1 | 18350 | Orange Blossom Recreation Area | 23150 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Stanislaus 2 | 17.472 | Orange Blossom Rec. Area | 0 | Recreation Management Area 49 | 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]);