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_TYP = 2 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 9
- Burbank, City of 7
- Chico, City of 7
- Watsonville, City of 5
- Glendora, City of 5
- Redlands, City of 5
- Los Angeles, City of 4
- Palo Alto, City of 4
- Gilroy, City of 4
- Carlsbad, City of 3
- La Verne, City of 3
- Roseville, City of 3
- Sacramento, City of 3
- Arcata, City of 3
- Claremont, City of 2
- Santa Cruz, City of 2
- Santa Barbara, City of 2
- Glendale, City of 2
- Fullerton, City of 2
- Riverside, City of 2
- Rolling Hills Estates, City of 2
- Rancho Palos Verdes, City of 2
- Long Beach, City of 2
- Sierra Madre, City of 2
- Murrieta, City of 2
- Sebastopol, City of 2
- Oakdale, City of 1
- Lancaster, City of 1
- San Francisco, City and County of 1
- San Luis Obispo, City of 1
- …
ACCESS_TYP 4
MNG_AG_TYP 1
- City Agency · 143 ✖
DES_TP 1
- Local Conservation Area · 143 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15931 | 15931 | 15930 | {"type": "Polygon", "coordinates": [[[-122.24262, 38.17617], [-122.23981, 38.17895], [-122.23986, 38.1792], [-122.23953, 38.1794], [-122.23943, 38.17962], [-122.23897, 38.17977], [-122.2389, 38.17988], [-122.23875, 38.17999], [-122.23878, 38.18009], [-122.2392, 38.18056], [-122.23904, 38.18081], [-122.23904, 38.18115], [-122.23881, 38.18129], [-122.23872, 38.18153], [-122.23844, 38.18154], [-122.23842, 38.18192], [-122.2382, 38.18229], [-122.23791, 38.18226], [-122.23767, 38.18233], [-122.23754, 38.18257], [-122.23737, 38.18259], [-122.23706, 38.18241], [-122.23686, 38.18239], [-122.23663, 38.18253], [-122.23375, 38.18254], [-122.23285, 38.18565], [-122.22446, 38.18414], [-122.22153, 38.19229], [-122.21829, 38.19216], [-122.21145, 38.19203], [-122.20969, 38.18989], [-122.21593, 38.18833], [-122.21327, 38.18417], [-122.21376, 38.1835], [-122.21378, 38.18328], [-122.21374, 38.18232], [-122.21527, 38.1799], [-122.21507, 38.17952], [-122.21507, 38.17936], [-122.21492, 38.17912], [-122.21474, 38.1789], [-122.21463, 38.17869], [-122.21238, 38.17684], [-122.21152, 38.17477], [-122.21073, 38.1741], [-122.2161, 38.17414], [-122.22476, 38.17401], [-122.22389, 38.17619], [-122.22808, 38.17781], [-122.22869, 38.17795], [-122.23028, 38.17837], [-122.23138, 38.1786], [-122.2334, 38.17948], [-122.23328, 38.17976], [-122.23328, 38.17977], [-122.23699, 38.18098], [-122.24253, 38.1755], [-122.24262, 38.17617]]]} | Restricted Access 2 | 34999 | Newell Open Space Preserve | 22722 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 639.436 | Newell OSP | 0 | Local Conservation Area 4 | 2 | |
1199 | 1199 | 1198 | {"type": "Polygon", "coordinates": [[[-118.01942, 34.17359], [-118.01845, 34.17534], [-118.01863, 34.17541], [-118.01863, 34.17681], [-118.01873, 34.17724], [-118.01775, 34.17798], [-118.01747, 34.1784], [-118.01738, 34.17903], [-118.01759, 34.17945], [-118.01268, 34.17947], [-118.01265, 34.17226], [-118.01847, 34.17224], [-118.01866, 34.17289], [-118.01942, 34.17359]]]} | Open Access 1 | 6938 | Arcadia Wilderness Park | 15567 | 1009 | Arcadia, City of 303 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | Los Angeles 6 | 105.747 | Arcadia Wilderness Park | 0 | Local Conservation Area 4 | 2 |
3641 | 3641 | 3640 | {"type": "Polygon", "coordinates": [[[-117.89406, 34.16397], [-117.89267, 34.16401], [-117.89233, 34.1637], [-117.89222, 34.16349], [-117.89221, 34.16311], [-117.89406, 34.16397]]]} | Open Access 1 | 29516 | River Wilderness Park | 24431 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 1.847 | River Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
1857 | 1857 | 1856 | {"type": "Polygon", "coordinates": [[[-119.08916, 35.30331], [-119.0891, 35.30338], [-119.08883, 35.30342], [-119.08844, 35.30351], [-119.08824, 35.30353], [-119.08751, 35.30203], [-119.08796, 35.30189], [-119.08883, 35.30171], [-119.0889, 35.30193], [-119.08916, 35.30331]]]} | Open Access 1 | 15859 | Wilderness Park | 27511 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 4.843 | Wilderness Park | 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 | |
16734 | 16734 | 16733 | {"type": "Polygon", "coordinates": [[[-122.39604, 37.5774], [-122.39547, 37.57779], [-122.39467, 37.57823], [-122.39425, 37.57863], [-122.39392, 37.57904], [-122.39327, 37.57947], [-122.39302, 37.5797], [-122.39259, 37.58019], [-122.39222, 37.58053], [-122.39203, 37.58068], [-122.39169, 37.58041], [-122.39132, 37.5807], [-122.39099, 37.58083], [-122.39091, 37.58081], [-122.39083, 37.58083], [-122.39078, 37.58086], [-122.39073, 37.58097], [-122.39067, 37.58104], [-122.39001, 37.58148], [-122.38957, 37.58188], [-122.38948, 37.58193], [-122.38931, 37.58196], [-122.38924, 37.58199], [-122.38921, 37.58205], [-122.38922, 37.58213], [-122.38876, 37.58268], [-122.38875, 37.58267], [-122.38797, 37.583], [-122.3879, 37.58342], [-122.3883, 37.58366], [-122.38849, 37.58382], [-122.38828, 37.58392], [-122.38809, 37.58392], [-122.38797, 37.58386], [-122.38776, 37.5838], [-122.38763, 37.58383], [-122.38742, 37.58377], [-122.38695, 37.58374], [-122.38686, 37.58367], [-122.38677, 37.58264], [-122.38679, 37.58255], [-122.38696, 37.58248], [-122.38704, 37.58238], [-122.38714, 37.5824], [-122.38725, 37.58252], [-122.38768, 37.58236], [-122.38778, 37.58224], [-122.38793, 37.58213], [-122.3879, 37.58187], [-122.38808, 37.58173], [-122.38817, 37.58148], [-122.38833, 37.58143], [-122.38837, 37.58122], [-122.38848, 37.58117], [-122.38854, 37.58101], [-122.38875, 37.58082], [-122.38907, 37.58075], [-122.38941, 37.5806], [-122.38959, 37.58047], [-122.38996, 37.58048], [-122.39024, 37.58041], [-122.39026, 37.58031], [-122.39052, 37.58003], [-122.39058, 37.5799], [-122.39068, 37.5798], [-122.39073, 37.57963], [-122.39083, 37.5796], [-122.38978, 37.5788], [-122.38987, 37.57874], [-122.38998, 37.57862], [-122.39006, 37.57864], [-122.39122, 37.57818], [-122.39194, 37.57892], [-122.39205, 37.57887], [-122.39214, 37.5787], [-122.39217, 37.57861], [-122.39227, 37.57854], [-122.39234, 37.57845], [-122.39243, 37.57848], [-122.39256, 37.57844], [-122.3927, 37.57855], [-122.39311, 37.57835], [-122.39321, 37.5782], [-122.39334, 37.57812], [-122.39341, 37.57805], [-122.3938, 37.57788], [-122.39394, 37.5779], [-122.39421, 37.57779], [-122.39454, 37.57775], [-122.39483, 37.57768], [-122.39489, 37.57762], [-122.39502, 37.57762], [-122.3951, 37.57756], [-122.39535, 37.57748], [-122.39578, 37.57722], [-122.39604, 37.5774]]]} | Open Access 1 | 17912 | Mills Canyon Wildlife Area | 22254 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 31.113 | Mills Canyon Wildlife Area | 1961 | Local Conservation Area 4 | 2 | |
6426 | 6426 | 6425 | {"type": "Polygon", "coordinates": [[[-117.28832, 33.16918], [-117.28816, 33.16969], [-117.288, 33.17008], [-117.28762, 33.17027], [-117.28755, 33.17053], [-117.28807, 33.17132], [-117.28817, 33.17188], [-117.28809, 33.17239], [-117.28778, 33.17235], [-117.28743, 33.17205], [-117.28705, 33.17199], [-117.287, 33.17181], [-117.28663, 33.17164], [-117.28607, 33.17149], [-117.28579, 33.17184], [-117.28571, 33.17242], [-117.2854, 33.17253], [-117.28518, 33.17298], [-117.285, 33.17422], [-117.2844, 33.17457], [-117.28428, 33.17416], [-117.28426, 33.17417], [-117.28425, 33.17447], [-117.28389, 33.17381], [-117.28389, 33.17324], [-117.28302, 33.17298], [-117.2815, 33.17354], [-117.2809, 33.17391], [-117.28089, 33.17412], [-117.28031, 33.17422], [-117.27957, 33.17406], [-117.27956, 33.17577], [-117.27527, 33.17577], [-117.27526, 33.17718], [-117.27095, 33.17716], [-117.27085, 33.1685], [-117.27953, 33.16855], [-117.27955, 33.16947], [-117.28386, 33.16947], [-117.28386, 33.16973], [-117.28435, 33.16972], [-117.28457, 33.16956], [-117.28458, 33.16946], [-117.28468, 33.16947], [-117.28473, 33.16932], [-117.28511, 33.16913], [-117.28522, 33.16882], [-117.28617, 33.16804], [-117.28832, 33.16918]]]} | Open Access 1 | 1933 | Lake Calavera Preserve | 2079 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/open/trails/talk/calavera.asp | San Diego 4 | 262.295 | Lake Calavera Preserve | 0 | Local Conservation Area 4 | 2 |
6675 | 6675 | 6674 | {"type": "Polygon", "coordinates": [[[-117.30179, 33.13802], [-117.30174, 33.13819], [-117.30151, 33.13825], [-117.30101, 33.13828], [-117.30039, 33.13846], [-117.30037, 33.13863], [-117.30055, 33.1388], [-117.29992, 33.13877], [-117.30002, 33.13674], [-117.29812, 33.13667], [-117.29824, 33.13312], [-117.29871, 33.13306], [-117.2992, 33.13303], [-117.2995, 33.13305], [-117.29988, 33.13309], [-117.30021, 33.13316], [-117.30049, 33.13324], [-117.30079, 33.13334], [-117.30047, 33.13362], [-117.30025, 33.13408], [-117.29992, 33.13447], [-117.29989, 33.13469], [-117.29968, 33.13496], [-117.29966, 33.13527], [-117.29974, 33.13534], [-117.29979, 33.13542], [-117.29986, 33.13543], [-117.30003, 33.13541], [-117.30019, 33.13536], [-117.3004, 33.13527], [-117.3005, 33.13529], [-117.30059, 33.13542], [-117.30099, 33.13627], [-117.30068, 33.13678], [-117.3007, 33.13713], [-117.30076, 33.13745], [-117.30079, 33.13778], [-117.30093, 33.13801], [-117.30114, 33.13811], [-117.30148, 33.13803], [-117.30171, 33.13794], [-117.30179, 33.13802]]]} | Open Access 1 | 48409 | Macario Canyon Preserve | 32975 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 24.84 | Macario Canyon Preserve | 0 | Local Conservation Area 4 | 2 | |
6686 | 6686 | 6685 | {"type": "Polygon", "coordinates": [[[-117.29824, 33.13313], [-117.29812, 33.13667], [-117.29552, 33.13657], [-117.29529, 33.13554], [-117.29538, 33.1353], [-117.29548, 33.13507], [-117.29561, 33.13484], [-117.29582, 33.13456], [-117.29599, 33.13436], [-117.29626, 33.13411], [-117.29655, 33.13389], [-117.29678, 33.13374], [-117.29768, 33.13329], [-117.29796, 33.13319], [-117.29824, 33.13313]]]} | Open Access 1 | 48411 | Veterans Park Preserve | 32977 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/civicax/filebank/blobdload.aspx?BlobID=37992 | San Diego 4 | 19.573 | Veterans Park Preserve | 0 | Local Conservation Area 4 | 2 |
2575 | 2575 | 2574 | {"type": "Polygon", "coordinates": [[[-121.91887, 36.54314], [-121.919, 36.54364], [-121.91893, 36.54417], [-121.91853, 36.54506], [-121.91817, 36.54548], [-121.91798, 36.54586], [-121.91789, 36.54634], [-121.91787, 36.54657], [-121.91782, 36.54777], [-121.91774, 36.54778], [-121.91773, 36.5487], [-121.91755, 36.5493], [-121.9157, 36.55127], [-121.9157, 36.55129], [-121.91551, 36.55121], [-121.91551, 36.55163], [-121.91517, 36.55138], [-121.91557, 36.54884], [-121.91556, 36.54883], [-121.91544, 36.54883], [-121.91546, 36.54866], [-121.91543, 36.54853], [-121.91562, 36.54853], [-121.91588, 36.54692], [-121.91597, 36.54691], [-121.91612, 36.54698], [-121.91619, 36.54696], [-121.91625, 36.54692], [-121.91627, 36.54686], [-121.91624, 36.54679], [-121.91663, 36.54635], [-121.91676, 36.54577], [-121.91675, 36.54576], [-121.91598, 36.54577], [-121.91609, 36.54512], [-121.91675, 36.54519], [-121.91701, 36.54506], [-121.91718, 36.54492], [-121.91745, 36.54432], [-121.91764, 36.54433], [-121.91786, 36.54412], [-121.91788, 36.54373], [-121.91768, 36.54353], [-121.91708, 36.54319], [-121.9172, 36.54304], [-121.91729, 36.54282], [-121.91737, 36.54269], [-121.91759, 36.54245], [-121.91766, 36.54245], [-121.91887, 36.54314]]]} | Open Access 1 | 17870 | Mission Trail Nature Preserve | 22313 | 1046 | Carmel-by-the-Sea, City of 535 | City 2 | City Agency 2 | http://www.carmelcalifornia.com/ | City 2 | 1046 | Carmel-by-the-Sea, City of 528 | City 2 | City Agency 2 | Monterey 14 | 33.893 | Mission Trail Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
770 | 770 | 769 | {"type": "MultiPolygon", "coordinates": [[[[-119.5289, 34.39581], [-119.52824, 34.3972], [-119.52811, 34.3971], [-119.52714, 34.39789], [-119.52649, 34.39736], [-119.52855, 34.39567], [-119.5289, 34.39581]]], [[[-119.52817, 34.39735], [-119.52805, 34.39762], [-119.52771, 34.39836], [-119.52732, 34.39804], [-119.52817, 34.39735]]]]} | Restricted Access 2 | 4493 | Carpinteria Salt Marsh Reserve | 16899 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 5.768 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
4308 | 4308 | 4307 | {"type": "Polygon", "coordinates": [[[-121.82502, 39.78339], [-121.807, 39.78385], [-121.807, 39.78435], [-121.80343, 39.78447], [-121.79613, 39.77739], [-121.79301, 39.77069], [-121.79286, 39.77039], [-121.79359, 39.76989], [-121.79276, 39.76989], [-121.79367, 39.76932], [-121.79945, 39.76553], [-121.79947, 39.76534], [-121.79967, 39.76551], [-121.80032, 39.76508], [-121.80282, 39.76371], [-121.80419, 39.76528], [-121.80616, 39.76764], [-121.80643, 39.76788], [-121.80643, 39.76929], [-121.81444, 39.77536], [-121.81457, 39.77535], [-121.81481, 39.7754], [-121.81822, 39.77698], [-121.81752, 39.77771], [-121.82502, 39.78339]]]} | Open Access 1 | 45364 | Bidwell Ranch Preserve | 16070 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 756.644 | Bidwell Ranch Preserve | 0 | Local Conservation Area 4 | 2 | |
9455 | 9455 | 9454 | {"type": "MultiPolygon", "coordinates": [[[[-121.78112, 39.7262], [-121.77809, 39.72622], [-121.77808, 39.72462], [-121.77825, 39.72467], [-121.77875, 39.72424], [-121.77911, 39.72406], [-121.77947, 39.72361], [-121.77957, 39.72373], [-121.78071, 39.7244], [-121.78111, 39.72483], [-121.78125, 39.72528], [-121.78112, 39.7262]]], [[[-121.79536, 39.73944], [-121.79055, 39.73888], [-121.79053, 39.73776], [-121.79385, 39.73726], [-121.79534, 39.73763], [-121.79536, 39.73944]]]]} | Open Access 1 | 15827 | Preserve Areas | 2238 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 33.396 | Preserve Areas | 0 | Local Conservation Area 4 | 2 | |
13707 | 13707 | 13706 | {"type": "MultiPolygon", "coordinates": [[[[-121.77899, 39.72934], [-121.77873, 39.7295], [-121.77861, 39.72949], [-121.77845, 39.72935], [-121.77833, 39.72941], [-121.77802, 39.72945], [-121.77802, 39.72992], [-121.77386, 39.73195], [-121.77333, 39.73185], [-121.77331, 39.73068], [-121.77334, 39.73068], [-121.77335, 39.73104], [-121.774, 39.73102], [-121.774, 39.73091], [-121.77429, 39.73083], [-121.77467, 39.7308], [-121.77522, 39.73068], [-121.77551, 39.73065], [-121.7756, 39.73059], [-121.77563, 39.7305], [-121.77637, 39.7305], [-121.7766, 39.73038], [-121.77672, 39.73037], [-121.77679, 39.73031], [-121.77722, 39.73031], [-121.77722, 39.72916], [-121.77802, 39.72915], [-121.77816, 39.72911], [-121.77822, 39.72906], [-121.77828, 39.72898], [-121.77839, 39.72893], [-121.779, 39.72921], [-121.77902, 39.72924], [-121.77899, 39.72934]]], [[[-121.77943, 39.72965], [-121.77914, 39.72969], [-121.77906, 39.72935], [-121.77909, 39.72928], [-121.77916, 39.72927], [-121.77929, 39.72931], [-121.77934, 39.72935], [-121.77936, 39.72938], [-121.77938, 39.72952], [-121.77943, 39.72965]]], [[[-121.78023, 39.72944], [-121.78012, 39.72956], [-121.77961, 39.72963], [-121.77955, 39.72949], [-121.77953, 39.72935], [-121.77949, 39.72928], [-121.7794, 39.7292], [-121.77925, 39.72915], [-121.77922, 39.72911], [-121.77943, 39.72877], [-121.77961, 39.7286], [-121.77975, 39.72853], [-121.77987, 39.72849], [-121.7802, 39.72843], [-121.78028, 39.7287], [-121.7802, 39.72884], [-121.78021, 39.72903], [-121.78013, 39.72912], [-121.7799, 39.72917], [-121.77988, 39.72918], [-121.78023, 39.72944]]]]} | Open Access 1 | 36082 | Hillview Preserve | 19996 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 9.976 | Hillview Preserve | 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]);