units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

149 rows where AGNCY_TYP = 2, DES_TP = 4 and GAP_STS = 2

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL

DES_TP 1

  • Local Conservation Area · 149 ✖
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
4 4 3 {"type": "Polygon", "coordinates": [[[-120.8183, 37.79059], [-120.81762, 37.7907], [-120.81665, 37.79072], [-120.81597, 37.7907], [-120.81518, 37.79071], [-120.81444, 37.7908], [-120.81354, 37.79068], [-120.81324, 37.79069], [-120.81119, 37.79087], [-120.81012, 37.79017], [-120.80995, 37.78962], [-120.81, 37.78839], [-120.80928, 37.78757], [-120.80991, 37.78733], [-120.81064, 37.78764], [-120.8111, 37.78789], [-120.81169, 37.78776], [-120.81268, 37.78774], [-120.81358, 37.7878], [-120.81565, 37.78787], [-120.81602, 37.78793], [-120.81796, 37.78801], [-120.8183, 37.79059]]]} Restricted Access 2 24 Stanley Wakefield Wilderness Area 25790 1227 Oakdale, City of 2 City 2 City Agency 2 http://www.oakdalegov.com/#!recreation/c222d City 2 1227 Oakdale, City of 2 City 2 City Agency 2   Stanislaus 2 57.379 Stanley Wakefield Wilderness Area 0 Local Conservation Area 4 2
418 418 417 {"type": "MultiPolygon", "coordinates": [[[[-121.7791, 36.92112], [-121.77861, 36.92097], [-121.77814, 36.92117], [-121.77746, 36.9222], [-121.7769, 36.92436], [-121.77687, 36.92456], [-121.77667, 36.92366], [-121.77666, 36.92365], [-121.77613, 36.92561], [-121.77599, 36.92621], [-121.77601, 36.92699], [-121.77567, 36.92723], [-121.77534, 36.92621], [-121.77526, 36.92569], [-121.7753, 36.92516], [-121.77549, 36.92432], [-121.77552, 36.9241], [-121.77553, 36.92388], [-121.776, 36.92394], [-121.77606, 36.92283], [-121.77616, 36.92252], [-121.77623, 36.9219], [-121.77645, 36.92201], [-121.77717, 36.9225], [-121.77833, 36.91963], [-121.7791, 36.92112]]], [[[-121.77899, 36.91916], [-121.77866, 36.91936], [-121.77838, 36.91931], [-121.77842, 36.91897], [-121.77824, 36.91893], [-121.77848, 36.91836], [-121.77891, 36.91869], [-121.77899, 36.91916]]]]} Open Access 1 1666 Upper Struve Slough 28147 1373 Watsonville, City of 13 City 2 City Agency 2 http://cityofwatsonville.org/parks-community-services City 2 1373 Watsonville, City of 13 City 2 City Agency 2   Santa Cruz 5 15.625 Upper Struve Slough 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
809 809 808 {"type": "Polygon", "coordinates": [[[-118.35743, 33.73927], [-118.35609, 33.74137], [-118.35451, 33.74259], [-118.35482, 33.74403], [-118.35362, 33.74458], [-118.35252, 33.74529], [-118.35063, 33.7436], [-118.34639, 33.74233], [-118.34503, 33.74505], [-118.34344, 33.74433], [-118.33999, 33.7428], [-118.34048, 33.74141], [-118.34104, 33.74039], [-118.34184, 33.73965], [-118.34197, 33.73931], [-118.34325, 33.7401], [-118.34389, 33.74064], [-118.34434, 33.74033], [-118.34435, 33.73955], [-118.34415, 33.73943], [-118.34424, 33.73925], [-118.34391, 33.73909], [-118.3449, 33.73758], [-118.3455, 33.73785], [-118.34744, 33.73774], [-118.34871, 33.73993], [-118.34901, 33.74034], [-118.34923, 33.74059], [-118.34954, 33.74088], [-118.34981, 33.7411], [-118.35018, 33.74134], [-118.3505, 33.74153], [-118.35158, 33.74209], [-118.35168, 33.74196], [-118.35143, 33.74182], [-118.35146, 33.74177], [-118.35156, 33.74182], [-118.35157, 33.74178], [-118.35267, 33.74042], [-118.3527, 33.74039], [-118.35277, 33.74039], [-118.35284, 33.74042], [-118.35293, 33.74027], [-118.35275, 33.7402], [-118.35262, 33.7402], [-118.35329, 33.73935], [-118.35652, 33.74025], [-118.35681, 33.73955], [-118.35743, 33.73927]]]} Open Access 1 5873 Forrestal Nature Preserve 29614 1265 Rancho Palos Verdes, City of 265 City 2 City Agency 2 http://palosverdes.com/rpv/recreationparks/index.cfm City 2 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 158.035 Forrestal Nature Preserve 0 Local Conservation Area 4 2
923 923 922 {"type": "Polygon", "coordinates": [[[-118.33718, 33.76768], [-118.33635, 33.76814], [-118.33599, 33.76854], [-118.33549, 33.76865], [-118.33479, 33.76891], [-118.33421, 33.76885], [-118.33391, 33.76892], [-118.33374, 33.76913], [-118.33223, 33.76984], [-118.33131, 33.77004], [-118.3307, 33.77005], [-118.33069, 33.76988], [-118.32983, 33.76993], [-118.32914, 33.77014], [-118.32746, 33.77059], [-118.32699, 33.77124], [-118.32727, 33.77181], [-118.3271, 33.77189], [-118.32733, 33.77234], [-118.32698, 33.77247], [-118.32693, 33.77225], [-118.32676, 33.77186], [-118.32654, 33.77151], [-118.32637, 33.77132], [-118.32611, 33.77107], [-118.3259, 33.77091], [-118.32492, 33.77026], [-118.32701, 33.77025], [-118.32756, 33.76972], [-118.32885, 33.7694], [-118.33031, 33.76865], [-118.33101, 33.76955], [-118.33165, 33.76962], [-118.333, 33.76871], [-118.33343, 33.7675], [-118.33564, 33.76652], [-118.33578, 33.76691], [-118.33655, 33.7668], [-118.33718, 33.76768]]]} Open Access 1 5878 George F Canyon Nature Park and Preserve 19263 1283 Rolling Hills Estates, City of 270 City 2 City Agency 2 http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 City 2 1283 Rolling Hills Estates, City of 265 City 2 City Agency 2   Los Angeles 6 33.273 George F Canyon Nature Park and Preserve 0 Local Conservation Area 4 2
964 964 963 {"type": "Polygon", "coordinates": [[[-118.37563, 33.82957], [-118.3743, 33.83077], [-118.37429, 33.8313], [-118.37368, 33.83139], [-118.37311, 33.82856], [-118.37351, 33.82804], [-118.37387, 33.82825], [-118.37421, 33.82848], [-118.37563, 33.82957]]]} Open Access 1 6056 Hopkins Wilderness Park 20088 1270 Redondo Beach, City of 246 City 2 City Agency 2 http://www.redondo.org City 2 1270 Redondo Beach, City of 242 City 2 City Agency 2   Los Angeles 6 10.984 Hopkins Wilderness Park 0 Local Conservation Area 4 2
1011 1011 1010 {"type": "Polygon", "coordinates": [[[-117.76393, 34.14161], [-117.76342, 34.1421], [-117.76331, 34.14232], [-117.76331, 34.14243], [-117.76337, 34.14267], [-117.76337, 34.14304], [-117.76345, 34.1432], [-117.76345, 34.14348], [-117.76025, 34.14346], [-117.75906, 34.14347], [-117.75905, 34.14352], [-117.75879, 34.14355], [-117.75874, 34.14353], [-117.75869, 34.14324], [-117.75976, 34.14314], [-117.76228, 34.14231], [-117.76283, 34.14222], [-117.76319, 34.14186], [-117.76344, 34.14188], [-117.7638, 34.14152], [-117.76393, 34.14161]]]} Open Access 1 6791 Golden Hills Wilderness Park 19365 1162 La Verne, City of 305 City 2 City Agency 2 http://www.ci.la-verne.ca.us/index.php/residents/parks City 2 1162 La Verne, City of 301 City 2 City Agency 2   Los Angeles 6 9.525 Golden Hills Wilderness Park 0 Local Conservation Area 4 2
1048 1048 1047 {"type": "Polygon", "coordinates": [[[-118.51707, 34.12476], [-118.51169, 34.12287], [-118.50522, 34.11808], [-118.50208, 34.11085], [-118.50114, 34.10951], [-118.50141, 34.10932], [-118.50238, 34.11073], [-118.5055, 34.11792], [-118.50867, 34.12028], [-118.50994, 34.11967], [-118.51004, 34.12128], [-118.51187, 34.12264], [-118.51704, 34.12445], [-118.51707, 34.12476]]]} Open Access 1 6371 Westridge-Canyonback Wilderness Park of LA 27417 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 20.346 Westridge-Canyonback Wilderness Park of LA 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
1139 1139 1138 {"type": "Polygon", "coordinates": [[[-122.51189, 37.77681], [-122.51151, 37.77685], [-122.5112, 37.77653], [-122.51112, 37.77641], [-122.51112, 37.77626], [-122.51093, 37.77611], [-122.51078, 37.77588], [-122.51061, 37.77568], [-122.51028, 37.77523], [-122.51108, 37.7752], [-122.51109, 37.77541], [-122.51113, 37.77564], [-122.5112, 37.77588], [-122.51128, 37.77607], [-122.51149, 37.7764], [-122.51189, 37.77681]]]} Open Access 1 6699 Gr.hwy/balboa Natural Area 19412 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 1300 San Francisco, City and County of 21 City 2 City Agency 2   San Francisco 13 1.868 Gr.hwy/balboa Natural Area 0 Local Conservation Area 4 2
1168 1168 1167 {"type": "Polygon", "coordinates": [[[-117.16158, 33.54542], [-117.16142, 33.54573], [-117.16062, 33.54559], [-117.16033, 33.54532], [-117.16028, 33.54523], [-117.1601, 33.54511], [-117.1595, 33.54457], [-117.15987, 33.54428], [-117.15985, 33.54425], [-117.16006, 33.54409], [-117.16012, 33.54409], [-117.16126, 33.54513], [-117.16158, 33.54536], [-117.16158, 33.54542]]]} Open Access 1 48441 Vintage Reserve Park 33146 1391 Murrieta, City of 329 City 2 City Agency 2 http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA City 2 1391 Murrieta, City of 326 City 2 City Agency 2   Riverside 10 3.802 Vintage Reserve Park 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
1238 1238 1237 {"type": "Polygon", "coordinates": [[[-117.90357, 34.04177], [-117.90199, 34.04524], [-117.90201, 34.04526], [-117.90197, 34.0453], [-117.9019, 34.04545], [-117.90185, 34.04562], [-117.90185, 34.04576], [-117.90191, 34.04595], [-117.89926, 34.04592], [-117.89933, 34.04073], [-117.90357, 34.04177]]]} Open Access 1 7071 Galster Wilderness Park 19180 1374 West Covina, City of 318 City 2 City Agency 2 http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals City 2 1374 West Covina, City of 315 City 2 City Agency 2   Los Angeles 6 40.865 Galster Wilderness Park 0 Local Conservation Area 4 2
1429 1429 1428 {"type": "Polygon", "coordinates": [[[-117.00998, 32.57781], [-117.00559, 32.57765], [-117.00559, 32.57912], [-117.00537, 32.57895], [-117.00513, 32.57883], [-117.00486, 32.57878], [-117.0046, 32.57878], [-117.00434, 32.57884], [-117.00415, 32.57892], [-117.00402, 32.579], [-117.00369, 32.57861], [-117.00357, 32.57838], [-117.00352, 32.5782], [-117.0035, 32.57805], [-117.0035, 32.57572], [-117.00456, 32.57575], [-117.00457, 32.57563], [-117.00487, 32.57547], [-117.00504, 32.57543], [-117.00514, 32.57544], [-117.00571, 32.5757], [-117.00584, 32.5757], [-117.00599, 32.57551], [-117.00621, 32.57533], [-117.00643, 32.57533], [-117.00656, 32.57537], [-117.0068, 32.57512], [-117.00705, 32.57482], [-117.00727, 32.57423], [-117.00733, 32.57399], [-117.00696, 32.57363], [-117.00645, 32.57334], [-117.00621, 32.57316], [-117.00602, 32.57284], [-117.00594, 32.57263], [-117.00594, 32.57243], [-117.00626, 32.57237], [-117.00647, 32.57236], [-117.00649, 32.57158], [-117.00647, 32.57157], [-117.00652, 32.57069], [-117.0065, 32.57067], [-117.00652, 32.57059], [-117.00652, 32.57031], [-117.00654, 32.5703], [-117.00654, 32.56915], [-117.00618, 32.56914], [-117.00587, 32.56895], [-117.00586, 32.56882], [-117.00553, 32.56882], [-117.00553, 32.56854], [-117.00572, 32.56854], [-117.00575, 32.56846], [-117.00583, 32.56841], [-117.00749, 32.56842], [-117.00798, 32.56847], [-117.00925, 32.56848], [-117.00925, 32.56886], [-117.00841, 32.56886], [-117.0084, 32.56946], [-117.00888, 32.5703], [-117.00988, 32.5703], [-117.00998, 32.57781]]]} Restricted Access 2 47693 Dennery Preserve 31429 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 98.129 Dennery Preserve 0 Local Conservation Area 4 2
1582 1582 1581 {"type": "Polygon", "coordinates": [[[-117.82912, 34.14946], [-117.82885, 34.14936], [-117.82829, 34.14947], [-117.82773, 34.14985], [-117.82742, 34.15028], [-117.82749, 34.15045], [-117.82786, 34.15061], [-117.82438, 34.15057], [-117.82438, 34.14914], [-117.82357, 34.14912], [-117.82356, 34.15056], [-117.82044, 34.15052], [-117.82046, 34.14695], [-117.82316, 34.14695], [-117.82342, 34.14662], [-117.82369, 34.14649], [-117.82447, 34.14649], [-117.82481, 34.14653], [-117.8251, 34.14658], [-117.82536, 34.1467], [-117.8256, 34.14692], [-117.82593, 34.14718], [-117.82618, 34.14742], [-117.82624, 34.14755], [-117.82616, 34.14804], [-117.8262, 34.14824], [-117.82629, 34.14838], [-117.82642, 34.14844], [-117.82655, 34.14842], [-117.82667, 34.14838], [-117.82701, 34.14807], [-117.82734, 34.14792], [-117.82798, 34.14756], [-117.82833, 34.14752], [-117.82857, 34.14755], [-117.82863, 34.14754], [-117.82857, 34.14739], [-117.82859, 34.14727], [-117.82865, 34.14713], [-117.82884, 34.14698], [-117.82912, 34.14698], [-117.82912, 34.14946]]]} No Public Access 3 12131 Bluebird Preserve 32639 1120 Glendora, City of 76 City 2 City Agency 2 http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services City 2 1120 Glendora, City of 74 City 2 City Agency 2   Los Angeles 6 68.179 Bluebird Preserve 0 Local Conservation Area 4 2
1834 1834 1833 {"type": "Polygon", "coordinates": [[[-122.29139, 37.56829], [-122.29135, 37.56831], [-122.2913, 37.56829], [-122.29123, 37.56825], [-122.29109, 37.56813], [-122.29095, 37.56795], [-122.29089, 37.56778], [-122.29092, 37.56774], [-122.29111, 37.5678], [-122.29127, 37.56788], [-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829]]]} Open Access 1 14019 Marina Lagoon Wildlife Island 21829 1310 San Mateo, City of 98 City 2 City Agency 2 http://www.cityofsanmateo.org/index.aspx?nid=324 City 2 1310 San Mateo, City of 96 City 2 City Agency 2   San Mateo 15 0.388 Marina Lagoon Wildlife Island 1962 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
1904 1904 1903 {"type": "MultiPolygon", "coordinates": [[[[-121.61887, 36.71254], [-121.61886, 36.71261], [-121.6185, 36.71307], [-121.61816, 36.71343], [-121.6178, 36.71378], [-121.61758, 36.71404], [-121.61734, 36.71441], [-121.61711, 36.71491], [-121.61681, 36.71483], [-121.61679, 36.71478], [-121.61695, 36.71444], [-121.61718, 36.71404], [-121.61734, 36.71384], [-121.61755, 36.7136], [-121.61799, 36.71318], [-121.61822, 36.71293], [-121.61843, 36.71266], [-121.61858, 36.71244], [-121.61862, 36.71242], [-121.61865, 36.71242], [-121.61885, 36.71251], [-121.61887, 36.71254]]], [[[-121.62192, 36.70546], [-121.62192, 36.70572], [-121.6218, 36.70605], [-121.6214, 36.70663], [-121.62144, 36.70691], [-121.62137, 36.70731], [-121.62114, 36.70767], [-121.62112, 36.7092], [-121.62102, 36.70934], [-121.62123, 36.70991], [-121.621, 36.71038], [-121.62096, 36.71057], [-121.62093, 36.71062], [-121.62055, 36.71077], [-121.6202, 36.71094], [-121.61998, 36.71109], [-121.61976, 36.71126], [-121.61957, 36.71144], [-121.6194, 36.71167], [-121.61902, 36.71234], [-121.61894, 36.71236], [-121.61876, 36.71228], [-121.61872, 36.71224], [-121.61872, 36.7122], [-121.61887, 36.71195], [-121.61898, 36.7117], [-121.61906, 36.71143], [-121.61911, 36.71115], [-121.61925, 36.71117], [-121.61939, 36.71099], [-121.61951, 36.71087], [-121.61966, 36.71077], [-121.61984, 36.71069], [-121.61975, 36.71012], [-121.61996, 36.70925], [-121.62083, 36.70759], [-121.62127, 36.70536], [-121.62192, 36.70546]]]]} Open Access 1 16324 Gabilan Creek Wilderness Sanctuary 19165 1291 Salinas, City of 56 City 2 City Agency 2 http://www.ci.salinas.ca.us/services/recreation/recreation.cfm City 2 1291 Salinas, City of 54 City 2 City Agency 2   Monterey 14 14.845 Gabilan Creek Wilderness Sanctuary 0 Local Conservation Area 4 2
2010 2010 2009 {"type": "Polygon", "coordinates": [[[-117.70587, 34.07793], [-117.70543, 34.07964], [-117.70378, 34.07961], [-117.70378, 34.07789], [-117.70587, 34.07793]]]} Open Access 1 15358 Wilderness Basin Park 27507 1210 Montclair, City of 55 City 2 City Agency 2 http://www.ci.montclair.ca.us/ City 2 1210 Montclair, City of 53 City 2 City Agency 2   San Bernardino 22 8.148 Wilderness Basin Park 0 Local Conservation Area 4 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);