units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
143 rows where DES_TP = 4 and MNG_AG_LEV = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 9
- Burbank, City of 7
- Chico, City of 6
- Watsonville, City of 5
- Redlands, City of 5
- Los Angeles, City of 3
- Glendora, City of 3
- Carlsbad, City of 3
- La Verne, City of 3
- Gilroy, City of 3
- Roseville, City of 3
- Santa Cruz, City of 2
- Glendale, City of 2
- Fullerton, City of 2
- Palo Alto, City of 2
- Riverside, City of 2
- Rolling Hills Estates, City of 2
- Rancho Palos Verdes, City of 2
- Long Beach, City of 2
- Murrieta, City of 2
- Sacramento, City of 2
- Arcata, City of 2
- Sebastopol, City of 2
- Oakdale, City of 1
- Claremont, City of 1
- Lancaster, City of 1
- San Francisco, City and County of 1
- San Luis Obispo, City of 1
- Santa Barbara, City of 1
- Santa Rosa, City of 1
- …
ACCESS_TYP 4
MNG_AG_TYP 1
- City Agency 123
DES_TP 1
- Local Conservation Area · 123 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6546 | 6546 | 6545 | {"type": "MultiPolygon", "coordinates": [[[[-118.6467, 34.22402], [-118.64665, 34.22403], [-118.64665, 34.2272], [-118.6466, 34.22721], [-118.64656, 34.22771], [-118.64649, 34.22806], [-118.64641, 34.22834], [-118.6463, 34.2286], [-118.64607, 34.22904], [-118.64582, 34.2294], [-118.64562, 34.22963], [-118.64468, 34.23065], [-118.64445, 34.23094], [-118.64421, 34.2313], [-118.64399, 34.23168], [-118.64381, 34.23206], [-118.64329, 34.23342], [-118.64315, 34.23368], [-118.64296, 34.23399], [-118.64268, 34.23434], [-118.64241, 34.23461], [-118.64149, 34.23539], [-118.64139, 34.2354], [-118.64086, 34.23576], [-118.64044, 34.23599], [-118.64007, 34.23616], [-118.63968, 34.2363], [-118.63928, 34.23641], [-118.63557, 34.2373], [-118.63146, 34.23702], [-118.62888, 34.23963], [-118.62634, 34.24009], [-118.62578, 34.24024], [-118.62532, 34.24041], [-118.62497, 34.24057], [-118.62456, 34.24079], [-118.6216, 34.24258], [-118.62013, 34.24258], [-118.62014, 34.23907], [-118.61818, 34.23906], [-118.61258, 34.23907], [-118.61257, 34.23817], [-118.61039, 34.23817], [-118.61038, 34.23763], [-118.60821, 34.23763], [-118.6082, 34.2374], [-118.60754, 34.2374], [-118.60754, 34.23544], [-118.61117, 34.23545], [-118.61126, 34.23512], [-118.61261, 34.2335], [-118.61336, 34.2329], [-118.61413, 34.23253], [-118.6146, 34.23214], [-118.61493, 34.23205], [-118.61531, 34.23217], [-118.61565, 34.23212], [-118.61603, 34.23091], [-118.61605, 34.23031], [-118.61412, 34.22937], [-118.61412, 34.22622], [-118.61914, 34.22621], [-118.61915, 34.2269], [-118.62489, 34.22757], [-118.6249, 34.22625], [-118.62933, 34.22512], [-118.63594, 34.2245], [-118.63875, 34.22216], [-118.64669, 34.22215], [-118.6467, 34.22402]], [[-118.62348, 34.23391], [-118.62349, 34.23391], [-118.62348, 34.22964], [-118.62339, 34.22967], [-118.6227, 34.22962], [-118.61691, 34.22804], [-118.61658, 34.22816], [-118.61581, 34.22896], [-118.61564, 34.22928], [-118.6157, 34.22956], [-118.61606, 34.23026], [-118.61606, 34.23031], [-118.62348, 34.23391]], [[-118.62864, 34.23645], [-118.62865, 34.23643], [-118.6266, 34.23543], [-118.6235, 34.23544], [-118.6235, 34.23842], [-118.62352, 34.23842], [-118.62356, 34.23837], [-118.62395, 34.23807], [-118.62502, 34.23766], [-118.62597, 34.23704], [-118.62663, 34.23684], [-118.62864, 34.23645]], [[-118.6298, 34.23696], [-118.62979, 34.23698], [-118.62982, 34.23699], [-118.62983, 34.23697], [-118.6298, 34.23696]]], [[[-118.62351, 34.24261], [-118.62351, 34.24261], [-118.62188, 34.24261], [-118.62351, 34.24163], [-118.62351, 34.24261]]]]} | Open Access 1 | 3262 | Chatsworth Nature Preserve and Reservoir | 29089 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 1025.916 | Chatsworth Nature Preserve and Reservoir | 0 | Local Conservation Area 4 | 2 | |
1122 | 1122 | 1121 | {"type": "Polygon", "coordinates": [[[-118.29627, 34.19919], [-118.29609, 34.19935], [-118.29614, 34.19953], [-118.29511, 34.19897], [-118.2953, 34.19878], [-118.29525, 34.19874], [-118.29588, 34.19813], [-118.29595, 34.19818], [-118.29627, 34.19919]]]} | Open Access 1 | 7138 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 2.037 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
1123 | 1123 | 1122 | {"type": "Polygon", "coordinates": [[[-118.33773, 34.21146], [-118.33771, 34.21259], [-118.33604, 34.21431], [-118.33641, 34.21457], [-118.33522, 34.21539], [-118.33454, 34.21562], [-118.33424, 34.21502], [-118.33435, 34.21492], [-118.33456, 34.21461], [-118.3353, 34.21399], [-118.33455, 34.21358], [-118.33456, 34.21235], [-118.33503, 34.21195], [-118.3351, 34.21143], [-118.33773, 34.21146]]]} | Open Access 1 | 7140 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 21.658 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
5109 | 5109 | 5108 | {"type": "MultiPolygon", "coordinates": [[[[-118.29581, 34.19337], [-118.29578, 34.19349], [-118.29574, 34.19378], [-118.29561, 34.19383], [-118.29556, 34.19372], [-118.29574, 34.19353], [-118.29579, 34.19336], [-118.29581, 34.19337]]], [[[-118.29591, 34.19347], [-118.29593, 34.19378], [-118.29591, 34.19396], [-118.29586, 34.19409], [-118.29577, 34.19426], [-118.29568, 34.19436], [-118.29567, 34.1944], [-118.29568, 34.19442], [-118.29562, 34.19442], [-118.29578, 34.19411], [-118.29582, 34.19399], [-118.29591, 34.19347]]], [[[-118.29599, 34.19529], [-118.29577, 34.19538], [-118.29565, 34.19511], [-118.2956, 34.19497], [-118.29561, 34.1948], [-118.29564, 34.19469], [-118.29564, 34.19491], [-118.29577, 34.19517], [-118.29585, 34.19514], [-118.29592, 34.19518], [-118.29599, 34.19529]]], [[[-118.29578, 34.1959], [-118.29571, 34.19612], [-118.2955, 34.19549], [-118.29547, 34.1951], [-118.29542, 34.19493], [-118.29542, 34.19481], [-118.29545, 34.19468], [-118.29552, 34.19452], [-118.2956, 34.19443], [-118.29549, 34.19467], [-118.29545, 34.19486], [-118.29545, 34.19494], [-118.29551, 34.19516], [-118.29561, 34.19532], [-118.2957, 34.19573], [-118.29578, 34.19584], [-118.29578, 34.1959]]]]} | Open Access 1 | 7136 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 0.75 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
7547 | 7547 | 7546 | {"type": "Polygon", "coordinates": [[[-118.29839, 34.19579], [-118.2995, 34.19476], [-118.30044, 34.19544], [-118.29978, 34.19606], [-118.30029, 34.19644], [-118.29984, 34.19685], [-118.30005, 34.19702], [-118.29761, 34.19929], [-118.29695, 34.19855], [-118.29699, 34.1982], [-118.29759, 34.19823], [-118.2977, 34.19668], [-118.29741, 34.19646], [-118.29744, 34.19612], [-118.29755, 34.19631], [-118.29753, 34.19634], [-118.29771, 34.19649], [-118.29839, 34.19579]]]} | Open Access 1 | 7135 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 17.751 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
16946 | 16946 | 16945 | {"type": "MultiPolygon", "coordinates": [[[[-118.33598, 34.22132], [-118.31003, 34.22152], [-118.30999, 34.21116], [-118.31309, 34.21287], [-118.31571, 34.21444], [-118.31845, 34.21185], [-118.31831, 34.21169], [-118.31831, 34.21164], [-118.31929, 34.21212], [-118.31951, 34.21208], [-118.32007, 34.2121], [-118.32019, 34.21265], [-118.3204, 34.21278], [-118.32252, 34.21395], [-118.32179, 34.21543], [-118.32215, 34.21562], [-118.32351, 34.2145], [-118.33598, 34.22132]]], [[[-118.30136, 34.22159], [-118.29278, 34.22166], [-118.29251, 34.21842], [-118.29251, 34.21604], [-118.30011, 34.21602], [-118.30009, 34.21172], [-118.30133, 34.2117], [-118.30136, 34.22159]]]]} | Open Access 1 | 6832 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 533.688 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
16951 | 16951 | 16950 | {"type": "MultiPolygon", "coordinates": [[[[-118.28323, 34.19245], [-118.28229, 34.19194], [-118.2825, 34.19062], [-118.28224, 34.19058], [-118.28228, 34.19031], [-118.28261, 34.19035], [-118.28259, 34.19045], [-118.28272, 34.19051], [-118.28284, 34.19067], [-118.28288, 34.1907], [-118.28294, 34.19068], [-118.28303, 34.19061], [-118.28306, 34.19056], [-118.28311, 34.19056], [-118.2831, 34.19062], [-118.28295, 34.19074], [-118.28285, 34.19074], [-118.28281, 34.19072], [-118.2827, 34.19057], [-118.28268, 34.19058], [-118.28281, 34.19141], [-118.28323, 34.19245]]], [[[-118.29576, 34.19667], [-118.29576, 34.19676], [-118.2955, 34.19748], [-118.29519, 34.19784], [-118.2947, 34.19862], [-118.29467, 34.19873], [-118.29346, 34.19802], [-118.29187, 34.19717], [-118.29185, 34.19884], [-118.2904, 34.20014], [-118.29112, 34.20069], [-118.29097, 34.20077], [-118.29081, 34.20089], [-118.29075, 34.20097], [-118.29068, 34.2011], [-118.29062, 34.20116], [-118.29053, 34.20117], [-118.29024, 34.20097], [-118.28959, 34.20057], [-118.28947, 34.20054], [-118.28933, 34.20053], [-118.28919, 34.20059], [-118.28864, 34.20095], [-118.28838, 34.20095], [-118.28831, 34.20101], [-118.2882, 34.20091], [-118.28806, 34.20101], [-118.28827, 34.20122], [-118.28809, 34.20134], [-118.28792, 34.20115], [-118.28772, 34.20128], [-118.28769, 34.20126], [-118.28747, 34.20142], [-118.28716, 34.20135], [-118.28714, 34.20144], [-118.28762, 34.20168], [-118.28761, 34.20169], [-118.28719, 34.20151], [-118.2868, 34.20125], [-118.28695, 34.20131], [-118.28707, 34.20114], [-118.28707, 34.20112], [-118.28681, 34.20098], [-118.28666, 34.20116], [-118.28678, 34.20123], [-118.28677, 34.20125], [-118.2868, 34.20128], [-118.28717, 34.20153], [-118.28747, 34.20184], [-118.28739, 34.20195], [-118.28736, 34.20206], [-118.28736, 34.20218], [-118.28744, 34.20229], [-118.28758, 34.20239], [-118.28796, 34.20251], [-118.28812, 34.20259], [-118.28821, 34.20265], [-118.28867, 34.20312], [-118.28858, 34.20323], [-118.28848, 34.2032], [-118.2884, 34.20322], [-118.28841, 34.20334], [-118.28845, 34.20351], [-118.28834, 34.20353], [-118.28831, 34.20357], [-118.28833, 34.20363], [-118.28837, 34.20366], [-118.28856, 34.20367], [-118.28882, 34.2035], [-118.28891, 34.20337], [-118.2889, 34.20329], [-118.28884, 34.20316], [-118.28853, 34.20285], [-118.28891, 34.20258], [-118.28872, 34.2024], [-118.28834, 34.20266], [-118.28821, 34.20255], [-118.28829, 34.20248], [-118.28831, 34.20243], [-118.28771, 34.20214], [-118.28752, 34.20226], [-118.28747, 34.20218], [-118.28745, 34.20211], [-118.28746, 34.20203], [-118.28749, 34.20195], [-118.28758, 34.20184], [-118.28789, 34.20156], [-118.28837, 34.20124], [-118.28875, 34.20097], [-118.28923, 34.20066], [-118.28939, 34.2006], [-118.28946, 34.2006], [-118.28955, 34.20063], [-118.28996, 34.20089], [-118.28982, 34.20104], [-118.28981, 34.20121], [-118.28995, 34.20133], [-118.28992, 34.20136], [-118.29019, 34.20173], [-118.29011, 34.20179], [-118.2903, 34.20215], [-118.29095, 34.20191], [-118.29086, 34.20173], [-118.29126, 34.20092], [-118.29149, 34.20071], [-118.29184, 34.20056], [-118.29185, 34.2014], [-118.29255, 34.20097], [-118.29252, 34.20743], [-118.2805, 34.20747], [-118.28068, 34.20771], [-118.28668, 34.2146], [-118.2759, 34.21455], [-118.27584, 34.21423], [-118.27541, 34.21291], [-118.27526, 34.21112], [-118.27513, 34.211], [-118.27514, 34.20974], [-118.27511, 34.20744], [-118.28049, 34.20746], [-118.28041, 34.20191], [-118.28033, 34.19262], [-118.28347, 34.19258], [-118.28941, 34.19581], [-118.29023, 34.19627], [-118.29017, 34.19642], [-118.29034, 34.19671], [-118.29049, 34.19641], [-118.29163, 34.19704], [-118.29349, 34.19524], [-118.29366, 34.19528], [-118.29383, 34.19539], [-118.29495, 34.19644], [-118.29514, 34.19655], [-118.29527, 34.19658], [-118.29543, 34.19658], [-118.29552, 34.19656], [-118.29559, 34.19652], [-118.29566, 34.19652], [-118.29574, 34.1966], [-118.29576, 34.19667]], [[-118.28814, 34.20485], [-118.28833, 34.20546], [-118.28875, 34.20618], [-118.28899, 34.2063], [-118.28921, 34.20622], [-118.28939, 34.20575], [-118.28899, 34.20469], [-118.28836, 34.20392], [-118.28767, 34.20359], [-118.2875, 34.20371], [-118.2875, 34.20373], [-118.28792, 34.20394], [-118.28773, 34.20421], [-118.2864, 34.20497], [-118.28585, 34.20587], [-118.28617, 34.2063], [-118.2873, 34.20643], [-118.28732, 34.20549], [-118.28749, 34.20504], [-118.28814, 34.20485]], [[-118.28481, 34.20449], [-118.28444, 34.20504], [-118.2844, 34.20503], [-118.2842, 34.20522], [-118.28428, 34.20529], [-118.28375, 34.20608], [-118.28375, 34.20609], [-118.28432, 34.20619], [-118.28439, 34.20565], [-118.28515, 34.20506], [-118.28532, 34.205], [-118.28524, 34.20435], [-118.28493, 34.20432], [-118.28481, 34.20449]]]]} | Open Access 1 | 7137 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 537.626 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
16952 | 16952 | 16951 | {"type": "Polygon", "coordinates": [[[-118.32434, 34.20868], [-118.32341, 34.20908], [-118.32321, 34.20874], [-118.32219, 34.20891], [-118.32109, 34.20898], [-118.32103, 34.20889], [-118.32052, 34.2089], [-118.32042, 34.20911], [-118.32008, 34.20912], [-118.31942, 34.20921], [-118.31922, 34.20895], [-118.31852, 34.20902], [-118.31848, 34.20944], [-118.31807, 34.20967], [-118.3173, 34.21012], [-118.31708, 34.20984], [-118.31631, 34.21054], [-118.31452, 34.20957], [-118.31648, 34.20773], [-118.31682, 34.20737], [-118.31792, 34.20636], [-118.318, 34.20638], [-118.31782, 34.20696], [-118.31795, 34.207], [-118.31788, 34.20727], [-118.31789, 34.20728], [-118.31934, 34.20697], [-118.31928, 34.20676], [-118.3198, 34.20665], [-118.31984, 34.20662], [-118.31989, 34.20657], [-118.31985, 34.2057], [-118.32036, 34.20518], [-118.32063, 34.20503], [-118.32095, 34.20509], [-118.32129, 34.20506], [-118.32156, 34.20492], [-118.32209, 34.20419], [-118.32217, 34.204], [-118.32244, 34.20375], [-118.32313, 34.20425], [-118.32308, 34.2045], [-118.32303, 34.20493], [-118.32304, 34.20527], [-118.3229, 34.20558], [-118.32267, 34.20596], [-118.32242, 34.20625], [-118.32183, 34.20669], [-118.32212, 34.20699], [-118.32205, 34.20704], [-118.322, 34.20711], [-118.32172, 34.20708], [-118.32129, 34.20748], [-118.32137, 34.20756], [-118.32228, 34.20745], [-118.32262, 34.20766], [-118.32284, 34.20776], [-118.32302, 34.20781], [-118.32326, 34.20828], [-118.32358, 34.20834], [-118.32369, 34.20794], [-118.32418, 34.20801], [-118.32423, 34.20851], [-118.32434, 34.20868]]]} | Open Access 1 | 7139 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 60.689 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
7398 | 7398 | 7397 | {"type": "MultiPolygon", "coordinates": [[[[-117.70118, 34.1502], [-117.7012, 34.15034], [-117.70118, 34.15042], [-117.70089, 34.15087], [-117.7009, 34.15098], [-117.70097, 34.15118], [-117.70094, 34.15125], [-117.70088, 34.15131], [-117.70076, 34.15136], [-117.70063, 34.15136], [-117.70052, 34.15131], [-117.70024, 34.15091], [-117.70002, 34.15063], [-117.70037, 34.15049], [-117.70051, 34.15027], [-117.70033, 34.15003], [-117.70114, 34.14996], [-117.70118, 34.1502]]], [[[-117.70126, 34.15184], [-117.70124, 34.15196], [-117.70124, 34.15207], [-117.70115, 34.15174], [-117.70095, 34.15145], [-117.70098, 34.15144], [-117.70102, 34.15143], [-117.70108, 34.15154], [-117.70119, 34.15166], [-117.70125, 34.15178], [-117.70126, 34.15184]]], [[[-117.70225, 34.15348], [-117.7022, 34.15361], [-117.70214, 34.15367], [-117.70208, 34.15372], [-117.70209, 34.15334], [-117.70102, 34.15333], [-117.70096, 34.15425], [-117.69856, 34.15422], [-117.69182, 34.15425], [-117.69315, 34.15377], [-117.69327, 34.15359], [-117.69456, 34.15285], [-117.69491, 34.15289], [-117.69556, 34.15255], [-117.69591, 34.1519], [-117.69716, 34.15136], [-117.69747, 34.15136], [-117.69768, 34.15192], [-117.6986, 34.15193], [-117.6987, 34.15179], [-117.70037, 34.15261], [-117.70101, 34.15263], [-117.70126, 34.15242], [-117.70125, 34.15227], [-117.70133, 34.15241], [-117.70142, 34.15251], [-117.7017, 34.1527], [-117.70216, 34.15319], [-117.70223, 34.15329], [-117.70225, 34.15335], [-117.70225, 34.15348]]], [[[-117.70189, 34.16216], [-117.70165, 34.16216], [-117.70162, 34.16208], [-117.70187, 34.16208], [-117.70189, 34.16216]]], [[[-117.70149, 34.16216], [-117.70123, 34.16217], [-117.70122, 34.16208], [-117.70147, 34.16208], [-117.70149, 34.16216]]], [[[-117.74177, 34.13634], [-117.74166, 34.14359], [-117.74167, 34.1448], [-117.73318, 34.1449], [-117.73323, 34.15091], [-117.72878, 34.15088], [-117.72887, 34.15814], [-117.72452, 34.15812], [-117.72455, 34.16539], [-117.71586, 34.16538], [-117.71576, 34.15964], [-117.70706, 34.1596], [-117.70263, 34.15951], [-117.70273, 34.15794], [-117.70291, 34.15427], [-117.70205, 34.15426], [-117.70207, 34.15402], [-117.70209, 34.15397], [-117.70215, 34.1539], [-117.70228, 34.15379], [-117.70236, 34.15371], [-117.70241, 34.15361], [-117.70245, 34.15352], [-117.70246, 34.15343], [-117.70244, 34.15332], [-117.70235, 34.15313], [-117.70192, 34.15265], [-117.70182, 34.15256], [-117.70154, 34.15237], [-117.70145, 34.15224], [-117.70143, 34.15215], [-117.70142, 34.15204], [-117.70146, 34.15192], [-117.70144, 34.15174], [-117.70136, 34.15158], [-117.70127, 34.15148], [-117.70117, 34.15131], [-117.70111, 34.15133], [-117.70115, 34.15125], [-117.70117, 34.15117], [-117.70108, 34.15091], [-117.70134, 34.15053], [-117.70138, 34.15042], [-117.70139, 34.15027], [-117.70131, 34.14981], [-117.70199, 34.14979], [-117.70197, 34.14892], [-117.70198, 34.14887], [-117.70211, 34.1487], [-117.70365, 34.14682], [-117.70389, 34.14636], [-117.70409, 34.14568], [-117.70453, 34.14437], [-117.70446, 34.14425], [-117.70414, 34.14415], [-117.70421, 34.144], [-117.70424, 34.14397], [-117.7043, 34.14394], [-117.70491, 34.14396], [-117.70504, 34.14393], [-117.70514, 34.14388], [-117.70528, 34.14377], [-117.70536, 34.14366], [-117.70539, 34.14352], [-117.70539, 34.14331], [-117.7068, 34.14332], [-117.70707, 34.1435], [-117.70719, 34.14366], [-117.70722, 34.14375], [-117.70726, 34.14377], [-117.70748, 34.14367], [-117.70772, 34.14361], [-117.70779, 34.14352], [-117.70783, 34.14333], [-117.70829, 34.14333], [-117.7083, 34.14322], [-117.70828, 34.1431], [-117.70821, 34.14294], [-117.70812, 34.14284], [-117.70801, 34.14277], [-117.70788, 34.14271], [-117.7077, 34.14266], [-117.70756, 34.14258], [-117.70746, 34.14245], [-117.70743, 34.14231], [-117.7074, 34.13991], [-117.70749, 34.13947], [-117.70778, 34.13956], [-117.70811, 34.13889], [-117.70823, 34.13872], [-117.70817, 34.13863], [-117.70813, 34.13847], [-117.71095, 34.13672], [-117.71576, 34.13672], [-117.71577, 34.13594], [-117.71604, 34.13572], [-117.71625, 34.13552], [-117.71636, 34.13536], [-117.71645, 34.13512], [-117.71644, 34.1351], [-117.7169, 34.13389], [-117.71723, 34.13324], [-117.7175, 34.13282], [-117.71796, 34.13222], [-117.7185, 34.13166], [-117.71943, 34.13089], [-117.71966, 34.13067], [-117.72096, 34.12957], [-117.72108, 34.12948], [-117.72138, 34.12933], [-117.72217, 34.1291], [-117.72334, 34.12886], [-117.72484, 34.12858], [-117.7263, 34.12826], [-117.72679, 34.12817], [-117.72679, 34.12889], [-117.72531, 34.12888], [-117.72531, 34.13083], [-117.72641, 34.13121], [-117.72712, 34.13278], [-117.72758, 34.13282], [-117.72763, 34.13291], [-117.72769, 34.13295], [-117.72796, 34.13303], [-117.72798, 34.13304], [-117.72837, 34.13383], [-117.72711, 34.13373], [-117.72708, 34.13622], [-117.72446, 34.13619], [-117.72445, 34.13638], [-117.72708, 34.13638], [-117.72812, 34.1364], [-117.72816, 34.13646], [-117.72823, 34.13649], [-117.72833, 34.13647], [-117.72845, 34.13638], [-117.73311, 34.13638], [-117.73313, 34.13629], [-117.74177, 34.13634]], [[-117.73183, 34.14505], [-117.73183, 34.14503], [-117.73114, 34.14503], [-117.73115, 34.14504], [-117.73183, 34.14505]]]]} | Open Access 1 | 6803 | Claremont Hills Wilderness Park | 2385 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=2286 | Los Angeles 6 | 2088.64 | Claremont Hills Wilderness Park | 0 | Local Conservation Area 4 | 2 |
13669 | 13669 | 13668 | {"type": "Polygon", "coordinates": [[[-122.32205, 40.55148], [-122.32199, 40.55645], [-122.3148, 40.55648], [-122.31478, 40.55437], [-122.31469, 40.55436], [-122.31468, 40.55392], [-122.31465, 40.55367], [-122.31461, 40.55302], [-122.31457, 40.55291], [-122.31451, 40.55278], [-122.31431, 40.55258], [-122.3141, 40.55241], [-122.31391, 40.55227], [-122.31346, 40.55207], [-122.31328, 40.55193], [-122.31297, 40.55162], [-122.31212, 40.55114], [-122.31165, 40.55096], [-122.31126, 40.55071], [-122.31081, 40.55051], [-122.3106, 40.55038], [-122.30834, 40.54925], [-122.31485, 40.54923], [-122.31486, 40.54926], [-122.31508, 40.54926], [-122.31556, 40.54969], [-122.31615, 40.54982], [-122.31622, 40.54973], [-122.31576, 40.54931], [-122.31848, 40.54931], [-122.31848, 40.54977], [-122.31852, 40.54977], [-122.31852, 40.55097], [-122.31848, 40.55102], [-122.31848, 40.55103], [-122.32024, 40.552], [-122.32066, 40.55188], [-122.32067, 40.55147], [-122.32205, 40.55148]]]} | Open Access 1 | 36037 | Clover Creek Preserve | 17436 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 127.579 | Clover Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
3337 | 3337 | 3336 | {"type": "Polygon", "coordinates": [[[-122.727, 38.40276], [-122.72699, 38.40298], [-122.72678, 38.40342], [-122.72676, 38.40361], [-122.7267, 38.40366], [-122.72629, 38.40366], [-122.72613, 38.40368], [-122.72613, 38.40277], [-122.727, 38.40276]]]} | Open Access 1 | 29791 | Colgan Creek Park and Preserve | 17496 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.602 | Colgan Creek Park and Preserve | 0 | Local Conservation Area 4 | 2 | |
2261 | 2261 | 2260 | {"type": "Polygon", "coordinates": [[[-117.16881, 34.01125], [-117.16838, 34.01129], [-117.16782, 34.01144], [-117.16755, 34.01148], [-117.16731, 34.0115], [-117.16648, 34.0115], [-117.16609, 34.01146], [-117.1658, 34.01139], [-117.16548, 34.01128], [-117.16517, 34.01113], [-117.16494, 34.01106], [-117.16469, 34.01101], [-117.16441, 34.011], [-117.16443, 34.00773], [-117.16879, 34.00774], [-117.16881, 34.01125]]]} | Open Access 1 | 18112 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 40.004 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
2619 | 2619 | 2618 | {"type": "Polygon", "coordinates": [[[-117.1821, 34.08725], [-117.18128, 34.08703], [-117.18018, 34.08677], [-117.17906, 34.08653], [-117.17808, 34.08635], [-117.17695, 34.08618], [-117.17596, 34.08605], [-117.17374, 34.08583], [-117.17372, 34.08457], [-117.17353, 34.08458], [-117.17353, 34.08585], [-117.1693, 34.08535], [-117.16496, 34.08491], [-117.16496, 34.08457], [-117.16604, 34.08457], [-117.16605, 34.084], [-117.1679, 34.08417], [-117.16813, 34.08397], [-117.16825, 34.08405], [-117.16839, 34.0841], [-117.16853, 34.08413], [-117.1687, 34.08414], [-117.16887, 34.08412], [-117.1693, 34.08401], [-117.1693, 34.08386], [-117.16932, 34.08392], [-117.16935, 34.08396], [-117.16946, 34.084], [-117.16955, 34.08399], [-117.16964, 34.08391], [-117.1697, 34.08389], [-117.17071, 34.08389], [-117.17097, 34.08392], [-117.1712, 34.08397], [-117.17226, 34.08433], [-117.17259, 34.0844], [-117.17288, 34.08442], [-117.17321, 34.08441], [-117.1735, 34.08437], [-117.17464, 34.08411], [-117.175, 34.08405], [-117.17538, 34.08402], [-117.17581, 34.08401], [-117.17649, 34.08404], [-117.17769, 34.08419], [-117.17801, 34.08425], [-117.17801, 34.08454], [-117.17901, 34.08454], [-117.18012, 34.08486], [-117.18019, 34.0847], [-117.18019, 34.08453], [-117.182, 34.08452], [-117.182, 34.08648], [-117.18209, 34.08649], [-117.1821, 34.08725]]]} | Open Access 1 | 17996 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 69.264 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
2621 | 2621 | 2620 | {"type": "Polygon", "coordinates": [[[-117.08214, 34.06252], [-117.08207, 34.06611], [-117.0778, 34.06609], [-117.0777, 34.06889], [-117.07683, 34.0689], [-117.07676, 34.06892], [-117.07668, 34.06897], [-117.07663, 34.06904], [-117.07661, 34.0691], [-117.07661, 34.06918], [-117.07669, 34.06943], [-117.0767, 34.06959], [-117.07662, 34.06982], [-117.07647, 34.07007], [-117.07643, 34.07022], [-117.07644, 34.07033], [-117.07663, 34.0708], [-117.07668, 34.07113], [-117.07663, 34.0718], [-117.07657, 34.07206], [-117.07324, 34.07204], [-117.07332, 34.06978], [-117.06898, 34.06982], [-117.06948, 34.06263], [-117.07792, 34.06244], [-117.08214, 34.06252]]]} | Open Access 1 | 18000 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 212.802 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
2624 | 2624 | 2623 | {"type": "MultiPolygon", "coordinates": [[[[-117.19854, 34.02575], [-117.19635, 34.02695], [-117.19532, 34.02687], [-117.19497, 34.0266], [-117.19476, 34.02702], [-117.19456, 34.02719], [-117.19447, 34.02762], [-117.19412, 34.028], [-117.19395, 34.0284], [-117.19398, 34.02878], [-117.19341, 34.02895], [-117.19323, 34.02854], [-117.1931, 34.02837], [-117.19298, 34.02835], [-117.19255, 34.0284], [-117.19242, 34.02855], [-117.19233, 34.02856], [-117.19223, 34.02855], [-117.19215, 34.0285], [-117.19214, 34.02841], [-117.1922, 34.02835], [-117.19239, 34.02823], [-117.19225, 34.02803], [-117.19205, 34.02797], [-117.1918, 34.02806], [-117.19133, 34.02801], [-117.19089, 34.02806], [-117.19039, 34.02805], [-117.19009, 34.02783], [-117.18976, 34.02763], [-117.19092, 34.02605], [-117.19091, 34.02579], [-117.18914, 34.0258], [-117.18913, 34.02674], [-117.18877, 34.02664], [-117.18836, 34.02662], [-117.18793, 34.02652], [-117.18733, 34.02627], [-117.18723, 34.02635], [-117.18712, 34.02627], [-117.18747, 34.0258], [-117.18877, 34.02396], [-117.18701, 34.02293], [-117.1865, 34.02323], [-117.18655, 34.02456], [-117.18531, 34.02563], [-117.18535, 34.02332], [-117.18437, 34.02189], [-117.18309, 34.02085], [-117.18206, 34.01949], [-117.18201, 34.01857], [-117.182, 34.01791], [-117.17812, 34.01793], [-117.17832, 34.0177], [-117.17844, 34.01721], [-117.17874, 34.01673], [-117.17894, 34.01615], [-117.17947, 34.01615], [-117.18199, 34.0175], [-117.18198, 34.01578], [-117.1823, 34.01599], [-117.18264, 34.01627], [-117.18289, 34.01652], [-117.18312, 34.01679], [-117.18335, 34.01713], [-117.18415, 34.01856], [-117.18419, 34.01856], [-117.18443, 34.01899], [-117.18474, 34.01942], [-117.185, 34.01971], [-117.18529, 34.01997], [-117.18561, 34.02022], [-117.18806, 34.02188], [-117.18837, 34.02205], [-117.1887, 34.0222], [-117.18904, 34.02232], [-117.18933, 34.0224], [-117.18984, 34.02251], [-117.19116, 34.02267], [-117.19145, 34.02273], [-117.19175, 34.02282], [-117.19221, 34.02301], [-117.19309, 34.02349], [-117.19346, 34.02368], [-117.19386, 34.02384], [-117.19436, 34.02401], [-117.19478, 34.02412], [-117.19522, 34.02421], [-117.19671, 34.0244], [-117.19676, 34.02576], [-117.19854, 34.02575]]], [[[-117.20834, 34.03384], [-117.205, 34.03385], [-117.20447, 34.03258], [-117.20334, 34.03192], [-117.20321, 34.03195], [-117.203, 34.03155], [-117.20231, 34.03087], [-117.20146, 34.03041], [-117.20066, 34.03015], [-117.19976, 34.02997], [-117.19941, 34.03018], [-117.19936, 34.03004], [-117.19839, 34.02994], [-117.1984, 34.03017], [-117.19797, 34.03008], [-117.19747, 34.02964], [-117.19737, 34.02944], [-117.19712, 34.0295], [-117.1966, 34.02953], [-117.19621, 34.02949], [-117.1964, 34.02848], [-117.19655, 34.0283], [-117.19662, 34.02799], [-117.19654, 34.02776], [-117.19657, 34.02749], [-117.19652, 34.02696], [-117.19776, 34.02705], [-117.19932, 34.02855], [-117.20389, 34.02934], [-117.20411, 34.02959], [-117.20425, 34.02988], [-117.20458, 34.03014], [-117.20472, 34.03035], [-117.20498, 34.03066], [-117.20536, 34.03088], [-117.20558, 34.03115], [-117.20567, 34.03139], [-117.20563, 34.0316], [-117.20611, 34.03225], [-117.20645, 34.03245], [-117.20692, 34.03256], [-117.20719, 34.0327], [-117.20772, 34.0329], [-117.20831, 34.03305], [-117.20834, 34.03384]]]]} | Open Access 1 | 18015 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 214.718 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
10275 | 10275 | 10274 | {"type": "Polygon", "coordinates": [[[-117.06052, 34.07702], [-117.06036, 34.0806], [-117.05242, 34.08066], [-117.0524, 34.077], [-117.06052, 34.07702]]]} | Open Access 1 | 18004 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 73.577 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
11084 | 11084 | 11083 | {"type": "Polygon", "coordinates": [[[-121.4649, 38.3205], [-121.46195, 38.32051], [-121.44506, 38.32078], [-121.44502, 38.32049], [-121.44467, 38.32051], [-121.44283, 38.30486], [-121.46162, 38.30476], [-121.4649, 38.3205]]]} | Restricted Access 2 | 21325 | Cosumnes River Preserve | 17680 | 1097 | Elk Grove, City of 963 | City 2 | City Agency 2 | http://www.elkgrovecity.org/ | City 2 | 1097 | Elk Grove, City of 931 | City 2 | City Agency 2 | Sacramento 41 | 740.158 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
8077 | 8077 | 8076 | {"type": "Polygon", "coordinates": [[[-117.83152, 33.67279], [-117.83133, 33.67315], [-117.83052, 33.67296], [-117.83016, 33.67265], [-117.82986, 33.67252], [-117.82273, 33.67034], [-117.823, 33.6703], [-117.82332, 33.6703], [-117.82367, 33.67033], [-117.8246, 33.67054], [-117.83152, 33.67279]]]} | Open Access 1 | 12290 | Culverdale Wilderness Park | 17856 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 7.092 | Culverdale Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
14366 | 14366 | 14365 | {"type": "MultiPolygon", "coordinates": [[[[-124.0907, 40.87504], [-124.09043, 40.87498], [-124.09043, 40.87491], [-124.09035, 40.87489], [-124.0905, 40.87451], [-124.0907, 40.87504]]], [[[-124.09106, 40.87533], [-124.09096, 40.87542], [-124.09102, 40.87562], [-124.09096, 40.87576], [-124.09097, 40.87604], [-124.09089, 40.87657], [-124.09081, 40.8764], [-124.09075, 40.8762], [-124.09062, 40.87551], [-124.09044, 40.87505], [-124.09103, 40.87517], [-124.09106, 40.87533]]], [[[-124.09083, 40.87428], [-124.09074, 40.87443], [-124.09073, 40.87459], [-124.09067, 40.87467], [-124.09055, 40.87437], [-124.0906, 40.87423], [-124.09083, 40.87428]]]]} | Open Access 1 | 47025 | Dellanina Nature Preserve | 30674 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.331 | Dellanina Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10477 | 10477 | 10476 | {"type": "Polygon", "coordinates": [[[-117.00881, 32.57966], [-117.00877, 32.57945], [-117.00873, 32.5794], [-117.00866, 32.57937], [-117.00856, 32.57938], [-117.00848, 32.57945], [-117.00848, 32.57952], [-117.0085, 32.57956], [-117.00862, 32.57962], [-117.00863, 32.57965], [-117.00559, 32.57952], [-117.00558, 32.57773], [-117.0088, 32.57781], [-117.00881, 32.57966]]]} | Open Access 1 | 18561 | Dennery Canyon Vernal Pool Reserve | 18086 | 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 | 14.897 | Dennery Canyon Vernal Pool Reserve | 0 | Local Conservation Area 4 | 2 |
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]);