units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
103 rows where DES_TP = 4 and MNG_AG_TYP = 3 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY, YR_EST
MNG_AGENCY 15
- San Diego, County of 37
- Orange, County of 19
- Los Angeles, County of 15
- Santa Barbara, County of 5
- San Luis Obispo, County of 5
- Riverside, County of 5
- Sacramento, County of 4
- Santa Cruz, County of 3
- Monterey, County of 2
- Placer, County of 2
- San Bernardino, County of 2
- Tulare, County of 1
- Lake, County of 1
- San Joaquin, County of 1
- Napa, County of 1
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 103 ✖
DES_TP 1
- Local Conservation Area · 103 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16904 | 16904 | 16903 | {"type": "Polygon", "coordinates": [[[-116.60256, 33.11614], [-116.60251, 33.11629], [-116.6025, 33.11642], [-116.60251, 33.11657], [-116.60257, 33.11685], [-116.60258, 33.117], [-116.60257, 33.11722], [-116.60255, 33.11743], [-116.60256, 33.11766], [-116.6026, 33.11791], [-116.60279, 33.1185], [-116.60283, 33.11883], [-116.60281, 33.11911], [-116.60275, 33.11936], [-116.60235, 33.12066], [-116.60203, 33.12176], [-116.60181, 33.12225], [-116.60156, 33.12264], [-116.60149, 33.12276], [-116.60141, 33.12304], [-116.60137, 33.12331], [-116.59729, 33.12338], [-116.59745, 33.12582], [-116.59836, 33.12606], [-116.59831, 33.12672], [-116.5984, 33.12723], [-116.59856, 33.12787], [-116.59827, 33.12788], [-116.59829, 33.13385], [-116.59825, 33.13386], [-116.59825, 33.13536], [-116.58954, 33.13585], [-116.58956, 33.13743], [-116.58955, 33.1398], [-116.58984, 33.13987], [-116.59018, 33.1399], [-116.59043, 33.13989], [-116.59079, 33.13982], [-116.59097, 33.1399], [-116.59121, 33.14015], [-116.59132, 33.14024], [-116.59159, 33.14032], [-116.59206, 33.14036], [-116.59243, 33.14035], [-116.59276, 33.14024], [-116.59288, 33.14015], [-116.59301, 33.14001], [-116.59345, 33.1396], [-116.59359, 33.1396], [-116.5936, 33.13971], [-116.59354, 33.14001], [-116.59345, 33.14023], [-116.59334, 33.14043], [-116.59327, 33.14068], [-116.59366, 33.14037], [-116.59393, 33.14029], [-116.59414, 33.1403], [-116.59458, 33.14038], [-116.59477, 33.14049], [-116.59483, 33.14054], [-116.5949, 33.14068], [-116.59491, 33.1408], [-116.59498, 33.14091], [-116.59525, 33.14098], [-116.59573, 33.141], [-116.59628, 33.14097], [-116.59669, 33.1409], [-116.59708, 33.14078], [-116.59736, 33.14068], [-116.59629, 33.14299], [-116.59195, 33.14333], [-116.58527, 33.14393], [-116.58532, 33.14793], [-116.58097, 33.14827], [-116.58088, 33.14433], [-116.58525, 33.14393], [-116.58518, 33.14049], [-116.58576, 33.14155], [-116.58742, 33.1409], [-116.58577, 33.13801], [-116.58564, 33.13639], [-116.58331, 33.13704], [-116.58474, 33.13967], [-116.58504, 33.13966], [-116.58504, 33.14001], [-116.58079, 33.14029], [-116.5807, 33.13633], [-116.58033, 33.12927], [-116.58004, 33.12054], [-116.56782, 33.12137], [-116.56788, 33.12522], [-116.55932, 33.12575], [-116.55915, 33.12187], [-116.55967, 33.12183], [-116.55962, 33.1184], [-116.56364, 33.11824], [-116.56349, 33.10731], [-116.56766, 33.10716], [-116.56736, 33.09696], [-116.57145, 33.09689], [-116.57146, 33.09366], [-116.57968, 33.09373], [-116.58547, 33.09423], [-116.5858, 33.09441], [-116.58605, 33.09451], [-116.58624, 33.09454], [-116.58652, 33.09455], [-116.58676, 33.09458], [-116.58702, 33.09465], [-116.58731, 33.09478], [-116.58752, 33.09499], [-116.58772, 33.09551], [-116.58782, 33.09571], [-116.58796, 33.09586], [-116.58811, 33.09594], [-116.5883, 33.09599], [-116.58849, 33.096], [-116.589, 33.09591], [-116.58913, 33.10051], [-116.59584, 33.10112], [-116.59835, 33.10378], [-116.59974, 33.10508], [-116.59986, 33.10509], [-116.59991, 33.10863], [-116.60027, 33.10864], [-116.60031, 33.11052], [-116.59823, 33.11055], [-116.59823, 33.10864], [-116.58933, 33.10776], [-116.58917, 33.11307], [-116.59824, 33.11415], [-116.59825, 33.115], [-116.60256, 33.11614]], [[-116.57991, 33.09966], [-116.58453, 33.10009], [-116.58442, 33.09705], [-116.5798, 33.09663], [-116.57991, 33.09966]]]} | Open Access 1 | 10653 | Volcan Mountain Wilderness Preserve | 29261 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/VolcanMountain.html | San Diego 4 | 3013.276 | Volcan Mtn. Wilderness Preserve | 0 | Local Conservation Area 4 | 2 |
16300 | 16300 | 16299 | {"type": "Polygon", "coordinates": [[[-121.31549, 38.16334], [-121.31531, 38.16334], [-121.31523, 38.16345], [-121.31476, 38.16386], [-121.3135, 38.16385], [-121.31336, 38.16368], [-121.31335, 38.16359], [-121.31338, 38.16349], [-121.31374, 38.163], [-121.31386, 38.16277], [-121.3141, 38.16245], [-121.31416, 38.16237], [-121.31418, 38.1623], [-121.31417, 38.16211], [-121.31414, 38.16205], [-121.31396, 38.1618], [-121.31384, 38.16167], [-121.31377, 38.16162], [-121.3136, 38.16147], [-121.3133, 38.16128], [-121.31285, 38.16112], [-121.31259, 38.16107], [-121.31208, 38.16107], [-121.31085, 38.16126], [-121.31056, 38.16127], [-121.31033, 38.16126], [-121.31021, 38.16124], [-121.31015, 38.16078], [-121.31019, 38.15968], [-121.31067, 38.15967], [-121.31194, 38.15973], [-121.31208, 38.15969], [-121.31234, 38.15953], [-121.31297, 38.15966], [-121.31414, 38.16067], [-121.31442, 38.16097], [-121.3147, 38.16131], [-121.31514, 38.16195], [-121.31519, 38.16209], [-121.31529, 38.16229], [-121.31549, 38.16293], [-121.31549, 38.16334]]]} | Open Access 1 | 17364 | Woodbridge Wilderness Area Regional Park | 27697 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 22.347 | Woodbridge Wilderness Area RP | 0 | Local Conservation Area 4 | 2 | |
15953 | 15953 | 15952 | {"type": "MultiPolygon", "coordinates": [[[[-117.124, 33.02413], [-117.12257, 33.02413], [-117.12257, 33.02322], [-117.124, 33.02355], [-117.124, 33.02413]]], [[[-117.13535, 33.02536], [-117.13525, 33.02933], [-117.13012, 33.02935], [-117.13012, 33.02888], [-117.12976, 33.02888], [-117.12976, 33.02694], [-117.12954, 33.02684], [-117.12933, 33.02663], [-117.12881, 33.02639], [-117.12849, 33.0263], [-117.12825, 33.02611], [-117.12803, 33.02617], [-117.12759, 33.02615], [-117.12683, 33.02594], [-117.12697, 33.02576], [-117.12691, 33.02569], [-117.12678, 33.02585], [-117.12597, 33.02557], [-117.12573, 33.02631], [-117.12505, 33.02622], [-117.12441, 33.02566], [-117.12413, 33.02585], [-117.12413, 33.02513], [-117.12463, 33.02513], [-117.12549, 33.02508], [-117.12609, 33.02509], [-117.1261, 33.02455], [-117.12475, 33.0242], [-117.12512, 33.02389], [-117.12563, 33.02406], [-117.12575, 33.02402], [-117.1259, 33.02408], [-117.12601, 33.02406], [-117.12607, 33.02423], [-117.1261, 33.02424], [-117.12689, 33.02403], [-117.12791, 33.02407], [-117.12785, 33.02453], [-117.12792, 33.02502], [-117.12834, 33.02606], [-117.12851, 33.02619], [-117.12893, 33.02618], [-117.12934, 33.02647], [-117.12986, 33.02668], [-117.13013, 33.02675], [-117.13114, 33.02674], [-117.1319, 33.02662], [-117.1321, 33.02653], [-117.13217, 33.02657], [-117.13251, 33.02641], [-117.13264, 33.02673], [-117.13301, 33.027], [-117.13325, 33.02706], [-117.13334, 33.02696], [-117.13342, 33.0267], [-117.13415, 33.02595], [-117.13498, 33.02538], [-117.13535, 33.02536]]], [[[-117.13541, 33.02216], [-117.13536, 33.02509], [-117.13519, 33.02509], [-117.13423, 33.02439], [-117.13423, 33.02404], [-117.13391, 33.02364], [-117.13391, 33.02355], [-117.13422, 33.02335], [-117.13425, 33.02292], [-117.13427, 33.02218], [-117.13541, 33.02216]]]]} | Open Access 1 | 44866 | Santa Fe Valley Open Space Preserve | 25091 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 67.159 | Santa Fe Valley OSP | 0 | Local Conservation Area 4 | 2 | |
15587 | 15587 | 15586 | {"type": "Polygon", "coordinates": [[[-117.25406, 33.55451], [-117.25253, 33.56096], [-117.24683, 33.5616], [-117.24552, 33.56023], [-117.24566, 33.55849], [-117.24724, 33.55612], [-117.24602, 33.55264], [-117.24327, 33.55101], [-117.24324, 33.54786], [-117.24168, 33.54458], [-117.24149, 33.54456], [-117.24152, 33.54438], [-117.24157, 33.54416], [-117.24171, 33.54383], [-117.24191, 33.54353], [-117.24204, 33.54337], [-117.24225, 33.54317], [-117.2408, 33.54033], [-117.23339, 33.54632], [-117.22864, 33.54271], [-117.22887, 33.54253], [-117.22887, 33.54252], [-117.22643, 33.54067], [-117.22561, 33.54005], [-117.22537, 33.54023], [-117.2253, 33.54017], [-117.226, 33.53963], [-117.22419, 33.53825], [-117.22281, 33.53721], [-117.22209, 33.53775], [-117.21106, 33.52939], [-117.21102, 33.52829], [-117.21103, 33.52817], [-117.21106, 33.528], [-117.21112, 33.52783], [-117.2112, 33.52767], [-117.21131, 33.5275], [-117.21143, 33.52738], [-117.21158, 33.52724], [-117.21173, 33.52713], [-117.21191, 33.52704], [-117.21221, 33.52692], [-117.21278, 33.52679], [-117.213, 33.5267], [-117.21319, 33.52659], [-117.21335, 33.52648], [-117.2135, 33.52634], [-117.21363, 33.52619], [-117.21374, 33.52601], [-117.21385, 33.52572], [-117.21409, 33.52468], [-117.21437, 33.52406], [-117.21445, 33.52382], [-117.21448, 33.52363], [-117.21448, 33.52344], [-117.21445, 33.52325], [-117.21439, 33.52308], [-117.21866, 33.52143], [-117.22166, 33.51869], [-117.21882, 33.51411], [-117.21989, 33.51229], [-117.22153, 33.51238], [-117.22236, 33.50986], [-117.22285, 33.5099], [-117.22321, 33.50995], [-117.22368, 33.51004], [-117.22428, 33.51022], [-117.22491, 33.51048], [-117.22532, 33.5107], [-117.22566, 33.51092], [-117.22599, 33.51116], [-117.22692, 33.51191], [-117.22726, 33.51215], [-117.22766, 33.51238], [-117.22809, 33.5126], [-117.22861, 33.51281], [-117.22889, 33.51291], [-117.23077, 33.51346], [-117.23127, 33.51364], [-117.2316, 33.51379], [-117.23215, 33.51409], [-117.23256, 33.51437], [-117.23298, 33.51471], [-117.23341, 33.51513], [-117.2337, 33.51489], [-117.23662, 33.51215], [-117.23969, 33.51163], [-117.24188, 33.50703], [-117.24828, 33.50454], [-117.25383, 33.51734], [-117.25377, 33.5195], [-117.24323, 33.52422], [-117.24132, 33.52305], [-117.24029, 33.52069], [-117.23797, 33.5209], [-117.23768, 33.51976], [-117.23719, 33.51948], [-117.23606, 33.52001], [-117.23536, 33.51836], [-117.23254, 33.52021], [-117.2309, 33.51924], [-117.23011, 33.51651], [-117.22905, 33.51536], [-117.22688, 33.51494], [-117.22433, 33.51347], [-117.22264, 33.51402], [-117.2206, 33.51356], [-117.22059, 33.51357], [-117.22518, 33.51826], [-117.22448, 33.51937], [-117.22218, 33.51968], [-117.2206, 33.52139], [-117.22061, 33.5214], [-117.22413, 33.52116], [-117.224, 33.52437], [-117.22322, 33.52492], [-117.2242, 33.52581], [-117.22559, 33.5261], [-117.22588, 33.52645], [-117.22633, 33.52759], [-117.22621, 33.52965], [-117.22676, 33.53007], [-117.2286, 33.52873], [-117.23179, 33.5306], [-117.2308, 33.53201], [-117.23041, 33.53267], [-117.23223, 33.53295], [-117.23305, 33.53376], [-117.23405, 33.53327], [-117.23607, 33.53089], [-117.2367, 33.53318], [-117.23592, 33.53433], [-117.23733, 33.53479], [-117.23864, 33.53444], [-117.23992, 33.53463], [-117.23958, 33.53654], [-117.24223, 33.53693], [-117.25139, 33.55059], [-117.25406, 33.55451]]]} | Open Access 1 | 12823 | Santa Rosa Plateau Ecological Reserve | 9507 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/education/santa-rosa-plateau/santa-rosa-plateau/ | Riverside 10 | 1994.248 | Santa Rosa Plateau ER | 1994 | Local Conservation Area 4 | 2 |
15152 | 15152 | 15151 | {"type": "Polygon", "coordinates": [[[-117.02397, 33.1489], [-117.0239, 33.14891], [-117.0239, 33.1525], [-117.02365, 33.15577], [-117.02352, 33.15771], [-117.02307, 33.16317], [-117.01963, 33.16302], [-117.01956, 33.16279], [-117.01479, 33.16263], [-117.01268, 33.16299], [-117.00684, 33.16413], [-117.00685, 33.16376], [-117.00731, 33.16309], [-117.00787, 33.16232], [-117.00813, 33.16193], [-117.00823, 33.1618], [-117.00842, 33.16163], [-117.00899, 33.16133], [-117.0092, 33.16115], [-117.00963, 33.16057], [-117.01, 33.16016], [-117.0109, 33.15901], [-117.011, 33.15891], [-117.01118, 33.15879], [-117.01141, 33.15874], [-117.01164, 33.15874], [-117.01189, 33.15882], [-117.01208, 33.15849], [-117.01212, 33.15834], [-117.01213, 33.1582], [-117.01201, 33.15618], [-117.01198, 33.15605], [-117.01192, 33.15593], [-117.01179, 33.15576], [-117.01168, 33.15567], [-117.01173, 33.15501], [-117.01431, 33.15464], [-117.01429, 33.15444], [-117.01429, 33.15428], [-117.0145, 33.15332], [-117.01455, 33.15225], [-117.01465, 33.15223], [-117.01927, 33.15236], [-117.01936, 33.14882], [-117.02397, 33.1489]]]} | Open Access 1 | 45997 | Bottle Peak Preserve | 29192 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 373.609 | Bottle Peak Preserve | 0 | Local Conservation Area 4 | 2 | |
15151 | 15151 | 15150 | {"type": "MultiPolygon", "coordinates": [[[[-116.88037, 32.99665], [-116.88033, 33.00055], [-116.87994, 33.00357], [-116.87945, 33.00359], [-116.87922, 33.00355], [-116.87884, 33.00359], [-116.87877, 33.00394], [-116.87546, 33.00405], [-116.87055, 33.0041], [-116.87056, 33.00098], [-116.87153, 33.00056], [-116.87167, 32.99946], [-116.87084, 32.99878], [-116.8659, 33.00008], [-116.86399, 33.00124], [-116.8635, 33.0014], [-116.86286, 32.99999], [-116.86269, 32.99974], [-116.86258, 32.99962], [-116.86244, 32.9995], [-116.8621, 32.99929], [-116.86006, 32.99861], [-116.85989, 32.99857], [-116.85935, 32.99846], [-116.85932, 32.99844], [-116.85743, 32.99818], [-116.85603, 32.99774], [-116.85585, 32.9977], [-116.85536, 32.99764], [-116.85323, 32.99762], [-116.85199, 32.99755], [-116.85178, 32.99756], [-116.85167, 32.99754], [-116.85119, 32.99758], [-116.85076, 32.99767], [-116.85055, 32.99772], [-116.84987, 32.99795], [-116.8499, 32.99391], [-116.85022, 32.9938], [-116.85051, 32.99367], [-116.85421, 32.99372], [-116.85422, 32.99384], [-116.85844, 32.99388], [-116.86869, 32.99391], [-116.8686, 32.98563], [-116.87533, 32.9856], [-116.87565, 32.99388], [-116.87771, 32.99389], [-116.87771, 32.99394], [-116.87778, 32.99394], [-116.87782, 32.99776], [-116.88037, 32.99665]]], [[[-116.86534, 33.00441], [-116.86282, 33.00443], [-116.86282, 33.00121], [-116.86091, 33.0005], [-116.86091, 33.0012], [-116.85836, 33.00125], [-116.85837, 32.99956], [-116.85825, 32.9995], [-116.84987, 33.00111], [-116.84989, 32.99819], [-116.85052, 32.9981], [-116.85507, 32.99781], [-116.85584, 32.99791], [-116.85649, 32.99809], [-116.85689, 32.99825], [-116.85706, 32.9983], [-116.85783, 32.99844], [-116.85827, 32.99849], [-116.85841, 32.99848], [-116.85929, 32.9986], [-116.8596, 32.99867], [-116.85999, 32.99877], [-116.86204, 32.99945], [-116.8623, 32.99961], [-116.86242, 32.99972], [-116.86256, 32.99987], [-116.86268, 33.00006], [-116.86378, 33.00245], [-116.86398, 33.00279], [-116.86425, 33.00308], [-116.86476, 33.0035], [-116.86507, 33.00383], [-116.86517, 33.00399], [-116.86525, 33.00417], [-116.86534, 33.00441]]], [[[-116.85006, 32.99368], [-116.85, 32.9937], [-116.84991, 32.99373], [-116.8499, 32.99368], [-116.85006, 32.99368]]], [[[-116.85253, 32.99779], [-116.85146, 32.99786], [-116.85061, 32.99791], [-116.85093, 32.99781], [-116.85141, 32.99774], [-116.85174, 32.99773], [-116.85253, 32.99779]]]]} | Open Access 1 | 45995 | Barnett Ranch Preserve | 29189 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/BarnettRanch.html | San Diego 4 | 717.785 | Barnett Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
14998 | 14998 | 14997 | {"type": "Polygon", "coordinates": [[[-117.7039, 34.48398], [-117.69522, 34.48397], [-117.69519, 34.47942], [-117.70386, 34.47942], [-117.7039, 34.48398]]]} | Open Access 1 | 45645 | Mescal Wildlife Sanctuary | 28461 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Mescal_Wildlife_Sanctuary | Los Angeles 6 | 99.463 | Mescal Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
14997 | 14997 | 14996 | {"type": "Polygon", "coordinates": [[[-117.87909, 34.49356], [-117.87907, 34.49911], [-117.87035, 34.49907], [-117.87035, 34.49729], [-117.87253, 34.49729], [-117.87254, 34.49548], [-117.87036, 34.49547], [-117.87036, 34.49183], [-117.87701, 34.49185], [-117.87701, 34.49356], [-117.87909, 34.49356]]]} | Open Access 1 | 45644 | Blalock Wildlife Sanctuary | 28460 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Blalock_Sanctuary | Los Angeles 6 | 140.426 | Blalock Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
14996 | 14996 | 14995 | {"type": "Polygon", "coordinates": [[[-117.8878, 34.49186], [-117.87909, 34.49185], [-117.8791, 34.48458], [-117.8878, 34.48459], [-117.8878, 34.48641], [-117.88345, 34.48641], [-117.88345, 34.48821], [-117.8878, 34.48823], [-117.8878, 34.49186]]]} | Open Access 1 | 45643 | Longview Wildlife Sanctuary | 28459 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Longview_Sanctuary | Los Angeles 6 | 139.449 | Longview Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
14914 | 14914 | 14913 | {"type": "Polygon", "coordinates": [[[-118.49285, 34.73463], [-118.48412, 34.7347], [-118.48404, 34.73108], [-118.48392, 34.72747], [-118.48613, 34.72744], [-118.48616, 34.73106], [-118.49279, 34.73101], [-118.49285, 34.73463]]]} | Open Access 1 | 45483 | George R. Bones Wildlife Sanctuary | 33369 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Desert_Pines_Sanctuary | Los Angeles 6 | 99.197 | George R. Bones Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
14809 | 14809 | 14808 | {"type": "Polygon", "coordinates": [[[-117.14066, 33.25449], [-117.14028, 33.2546], [-117.14032, 33.2547], [-117.14037, 33.25475], [-117.14057, 33.25543], [-117.1406, 33.25571], [-117.14058, 33.2559], [-117.14028, 33.25665], [-117.14037, 33.25683], [-117.13807, 33.25672], [-117.13802, 33.25307], [-117.13827, 33.25307], [-117.13853, 33.25318], [-117.13868, 33.25322], [-117.13897, 33.25337], [-117.13918, 33.25314], [-117.13955, 33.25349], [-117.14011, 33.25382], [-117.14025, 33.25392], [-117.14035, 33.25403], [-117.14066, 33.25449]]]} | Restricted Access 2 | 45227 | Knollwood Preserve | 31493 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 20.712 | Knollwood Preserve | 0 | Local Conservation Area 4 | 2 | |
14638 | 14638 | 14637 | {"type": "Polygon", "coordinates": [[[-116.84781, 32.81671], [-116.84748, 32.81672], [-116.84777, 32.8198], [-116.84467, 32.81979], [-116.84438, 32.81976], [-116.84405, 32.81984], [-116.84368, 32.82], [-116.84367, 32.82002], [-116.84416, 32.82064], [-116.84341, 32.8209], [-116.84061, 32.82312], [-116.84059, 32.82714], [-116.83973, 32.82708], [-116.83905, 32.82696], [-116.83843, 32.82681], [-116.83748, 32.82646], [-116.83725, 32.82644], [-116.83711, 32.82646], [-116.83698, 32.82651], [-116.83686, 32.82658], [-116.83677, 32.82668], [-116.83669, 32.82685], [-116.83667, 32.82721], [-116.83661, 32.82732], [-116.83661, 32.82663], [-116.83504, 32.82663], [-116.83441, 32.82619], [-116.83421, 32.82601], [-116.83404, 32.82583], [-116.83249, 32.82342], [-116.83244, 32.82331], [-116.83263, 32.81992], [-116.83284, 32.81992], [-116.83334, 32.8206], [-116.83363, 32.82031], [-116.83325, 32.81993], [-116.83383, 32.81994], [-116.83503, 32.81942], [-116.83545, 32.81932], [-116.83687, 32.81933], [-116.83688, 32.81895], [-116.83764, 32.81876], [-116.83867, 32.81899], [-116.83951, 32.81796], [-116.83905, 32.81756], [-116.83911, 32.81748], [-116.83955, 32.81767], [-116.83971, 32.81649], [-116.83921, 32.81568], [-116.84772, 32.81572], [-116.84781, 32.81671]]]} | Open Access 1 | 44876 | Stoneridge Preserve | 25897 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/AboutUs/Plans/MSCP.html | San Diego 4 | 246.46 | Stoneridge Preserve | 0 | Local Conservation Area 4 | 2 |
14637 | 14637 | 14636 | {"type": "Polygon", "coordinates": [[[-116.90222, 32.84651], [-116.90218, 32.84649], [-116.90213, 32.84651], [-116.9021, 32.84659], [-116.90205, 32.84692], [-116.9019, 32.84712], [-116.89878, 32.84713], [-116.89877, 32.84549], [-116.89944, 32.84553], [-116.90108, 32.84593], [-116.90178, 32.84602], [-116.90196, 32.84615], [-116.9022, 32.84643], [-116.90222, 32.84651]]]} | Open Access 1 | 44871 | Lakeside Linkage Preserve | 20976 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LakesideLinkage.html | San Diego 4 | 11.424 | Lakeside Linkage Preserve | 0 | Local Conservation Area 4 | 2 |
14610 | 14610 | 14609 | {"type": "MultiPolygon", "coordinates": [[[[-117.18723, 33.06546], [-117.18548, 33.06687], [-117.18548, 33.06687], [-117.1855, 33.06545], [-117.18723, 33.06546]]], [[[-117.19071, 33.0655], [-117.18965, 33.06846], [-117.18937, 33.06842], [-117.18924, 33.06843], [-117.18905, 33.06849], [-117.18895, 33.06856], [-117.18842, 33.06661], [-117.18836, 33.06649], [-117.18808, 33.06547], [-117.19071, 33.0655]]], [[[-117.18728, 33.0727], [-117.1848, 33.07266], [-117.18489, 33.07234], [-117.18501, 33.07155], [-117.18506, 33.0713], [-117.18494, 33.07096], [-117.18482, 33.07042], [-117.18453, 33.06973], [-117.18441, 33.06953], [-117.18417, 33.06924], [-117.18403, 33.06917], [-117.18387, 33.06916], [-117.18385, 33.0691], [-117.18541, 33.06911], [-117.18638, 33.06908], [-117.18726, 33.06908], [-117.18728, 33.0727]]], [[[-117.17423, 33.07671], [-117.17417, 33.0784], [-117.17415, 33.07845], [-117.17348, 33.07833], [-117.17312, 33.0783], [-117.17248, 33.07829], [-117.17227, 33.07826], [-117.17207, 33.0782], [-117.17154, 33.07797], [-117.17111, 33.07773], [-117.17073, 33.07743], [-117.16999, 33.07663], [-117.17001, 33.07636], [-117.17294, 33.07642], [-117.17294, 33.0767], [-117.17423, 33.07671]]], [[[-117.19572, 33.07672], [-117.1957, 33.0794], [-117.19324, 33.07923], [-117.19334, 33.07904], [-117.19314, 33.07854], [-117.19205, 33.07829], [-117.19191, 33.07822], [-117.19179, 33.07814], [-117.19161, 33.07794], [-117.19153, 33.07779], [-117.19149, 33.07761], [-117.19143, 33.0776], [-117.19146, 33.07717], [-117.19145, 33.07663], [-117.18855, 33.07658], [-117.18857, 33.07545], [-117.19146, 33.07551], [-117.19146, 33.07663], [-117.19572, 33.07672]]], [[[-117.17416, 33.07869], [-117.17408, 33.08036], [-117.16976, 33.08034], [-117.16984, 33.07885], [-117.16998, 33.07701], [-117.17052, 33.07759], [-117.17088, 33.07786], [-117.17113, 33.07803], [-117.1714, 33.07817], [-117.17195, 33.07841], [-117.17216, 33.07848], [-117.17237, 33.07851], [-117.17326, 33.07855], [-117.1736, 33.07859], [-117.17416, 33.07869]]], [[[-117.15319, 33.08571], [-117.15294, 33.08582], [-117.15251, 33.08596], [-117.15219, 33.08602], [-117.15183, 33.08606], [-117.15133, 33.08605], [-117.14956, 33.08587], [-117.14844, 33.0858], [-117.14823, 33.0858], [-117.14805, 33.08584], [-117.14803, 33.08027], [-117.15231, 33.08034], [-117.15223, 33.08571], [-117.15319, 33.08571]]], [[[-117.14475, 33.08745], [-117.1439, 33.08753], [-117.1439, 33.08753], [-117.1439, 33.08751], [-117.14394, 33.08751], [-117.14414, 33.08745], [-117.14475, 33.08745]]], [[[-117.15649, 33.08564], [-117.15649, 33.08741], [-117.15009, 33.08746], [-117.15012, 33.08937], [-117.14806, 33.0894], [-117.14808, 33.09109], [-117.1522, 33.09107], [-117.15221, 33.09471], [-117.1507, 33.09472], [-117.15069, 33.09473], [-117.1529, 33.09685], [-117.1533, 33.09789], [-117.15372, 33.09849], [-117.15353, 33.09873], [-117.15287, 33.09997], [-117.15245, 33.10051], [-117.15247, 33.10086], [-117.15329, 33.10166], [-117.15378, 33.10215], [-117.15386, 33.10237], [-117.15388, 33.10252], [-117.15386, 33.10266], [-117.15379, 33.10284], [-117.15365, 33.10304], [-117.15361, 33.10318], [-117.15363, 33.10332], [-117.15381, 33.10356], [-117.15382, 33.10365], [-117.15376, 33.10382], [-117.15357, 33.10398], [-117.15352, 33.10411], [-117.15351, 33.10421], [-117.15356, 33.10433], [-117.1537, 33.10449], [-117.15383, 33.10459], [-117.15398, 33.10468], [-117.15435, 33.10482], [-117.15455, 33.10504], [-117.15475, 33.10519], [-117.15482, 33.1053], [-117.15484, 33.10539], [-117.15488, 33.10548], [-117.15495, 33.10555], [-117.15522, 33.10568], [-117.15528, 33.10574], [-117.15536, 33.10597], [-117.15542, 33.10607], [-117.15567, 33.10631], [-117.15573, 33.10641], [-117.1558, 33.10661], [-117.15591, 33.10672], [-117.156, 33.10677], [-117.15617, 33.10681], [-117.15621, 33.10686], [-117.15622, 33.10691], [-117.1562, 33.10696], [-117.15615, 33.10699], [-117.15615, 33.10711], [-117.15609, 33.10712], [-117.15602, 33.10951], [-117.15534, 33.10922], [-117.15424, 33.10859], [-117.15415, 33.1086], [-117.15418, 33.10894], [-117.15418, 33.11015], [-117.15412, 33.11003], [-117.15402, 33.10997], [-117.15375, 33.1091], [-117.15355, 33.10862], [-117.1534, 33.10836], [-117.15337, 33.10821], [-117.1534, 33.10809], [-117.15344, 33.10805], [-117.15356, 33.10797], [-117.15383, 33.10784], [-117.15404, 33.10777], [-117.15451, 33.10766], [-117.15487, 33.10749], [-117.15514, 33.10743], [-117.15544, 33.10728], [-117.15566, 33.10722], [-117.15596, 33.10708], [-117.15596, 33.10706], [-117.15425, 33.10641], [-117.15282, 33.10651], [-117.15056, 33.10608], [-117.14915, 33.10526], [-117.14816, 33.10531], [-117.14802, 33.09843], [-117.13961, 33.09842], [-117.13962, 33.09474], [-117.14391, 33.09473], [-117.14393, 33.09378], [-117.1439, 33.09109], [-117.1396, 33.09109], [-117.13961, 33.09282], [-117.13652, 33.09281], [-117.13649, 33.0927], [-117.13649, 33.09251], [-117.13651, 33.0923], [-117.13645, 33.09202], [-117.13643, 33.09161], [-117.13651, 33.09136], [-117.13665, 33.0911], [-117.13685, 33.09077], [-117.13738, 33.09003], [-117.13755, 33.08972], [-117.13766, 33.08945], [-117.13778, 33.08925], [-117.13793, 33.08906], [-117.13802, 33.08897], [-117.13817, 33.08887], [-117.13835, 33.08879], [-117.13851, 33.08877], [-117.1387, 33.08878], [-117.13924, 33.08898], [-117.13943, 33.08902], [-117.13959, 33.08903], [-117.1396, 33.08909], [-117.14002, 33.08903], [-117.1404, 33.08901], [-117.14066, 33.08897], [-117.14123, 33.08882], [-117.14372, 33.08787], [-117.14407, 33.08772], [-117.14433, 33.08764], [-117.14518, 33.08757], [-117.14537, 33.08753], [-117.14561, 33.08744], [-117.148, 33.08744], [-117.14801, 33.08748], [-117.14803, 33.08747], [-117.14806, 33.08608], [-117.14818, 33.08605], [-117.1483, 33.08603], [-117.14876, 33.08605], [-117.14953, 33.08611], [-117.1514, 33.0863], [-117.15187, 33.08631], [-117.15239, 33.08624], [-117.15292, 33.0861], [-117.15339, 33.08588], [-117.15366, 33.0857], [-117.15649, 33.08564]]]]} | No Public Access 3 | 44822 | Escondido Creek Preserve | 29232 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 625.018 | Escondido Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
14608 | 14608 | 14607 | {"type": "MultiPolygon", "coordinates": [[[[-117.14468, 32.93894], [-117.14052, 32.93899], [-117.14057, 32.93988], [-117.13978, 32.93993], [-117.13697, 32.94021], [-117.13424, 32.94028], [-117.13399, 32.94024], [-117.13382, 32.94026], [-117.13366, 32.94039], [-117.13345, 32.94061], [-117.13322, 32.94079], [-117.13311, 32.94085], [-117.13284, 32.94094], [-117.13257, 32.94096], [-117.13182, 32.9409], [-117.131, 32.9409], [-117.13065, 32.94087], [-117.13032, 32.94074], [-117.13004, 32.94058], [-117.12976, 32.9405], [-117.12959, 32.94047], [-117.12929, 32.94047], [-117.12927, 32.94039], [-117.12922, 32.94039], [-117.12887, 32.93931], [-117.12873, 32.93902], [-117.12858, 32.93879], [-117.12808, 32.93813], [-117.12695, 32.93676], [-117.12904, 32.93619], [-117.12976, 32.93634], [-117.13003, 32.93637], [-117.13116, 32.93622], [-117.13225, 32.93618], [-117.13369, 32.93583], [-117.13409, 32.93549], [-117.13406, 32.93501], [-117.13567, 32.93494], [-117.13568, 32.93482], [-117.13675, 32.93478], [-117.13631, 32.93532], [-117.13604, 32.9357], [-117.13604, 32.93572], [-117.13916, 32.93565], [-117.13942, 32.93485], [-117.14136, 32.93576], [-117.14268, 32.93569], [-117.14408, 32.93456], [-117.14434, 32.93456], [-117.14467, 32.93605], [-117.14468, 32.93894]]], [[[-117.16982, 32.94862], [-117.16683, 32.94859], [-117.16682, 32.94854], [-117.16512, 32.94853], [-117.1651, 32.94814], [-117.1651, 32.94682], [-117.16714, 32.94686], [-117.16715, 32.94642], [-117.16771, 32.94614], [-117.16748, 32.94568], [-117.16713, 32.94559], [-117.16713, 32.94514], [-117.16961, 32.94511], [-117.16982, 32.94862]]], [[[-117.20536, 32.90698], [-117.20535, 32.90716], [-117.20503, 32.90727], [-117.20468, 32.90741], [-117.20434, 32.90758], [-117.20409, 32.90773], [-117.20365, 32.90805], [-117.20281, 32.9088], [-117.20259, 32.90878], [-117.20241, 32.90878], [-117.20204, 32.90881], [-117.20188, 32.90885], [-117.2017, 32.90891], [-117.20152, 32.90899], [-117.20141, 32.90907], [-117.20137, 32.90907], [-117.20022, 32.9076], [-117.20351, 32.90659], [-117.20536, 32.90698]]], [[[-117.21151, 32.90728], [-117.21058, 32.90768], [-117.20851, 32.90765], [-117.20853, 32.90715], [-117.20941, 32.90736], [-117.2101, 32.90743], [-117.21034, 32.90744], [-117.21078, 32.90741], [-117.21102, 32.90738], [-117.21151, 32.90728]]], [[[-117.21354, 32.90559], [-117.21337, 32.90582], [-117.21319, 32.90601], [-117.21282, 32.90632], [-117.21267, 32.90643], [-117.21224, 32.9067], [-117.21204, 32.90679], [-117.21184, 32.90688], [-117.21139, 32.90702], [-117.2109, 32.90712], [-117.21041, 32.90716], [-117.21014, 32.90717], [-117.20989, 32.90715], [-117.20934, 32.90707], [-117.20855, 32.90687], [-117.2086, 32.90558], [-117.21354, 32.90559]]], [[[-117.21547, 32.9056], [-117.2135, 32.90694], [-117.21235, 32.90695], [-117.21262, 32.90681], [-117.21289, 32.90664], [-117.21336, 32.90626], [-117.21351, 32.90611], [-117.21364, 32.90594], [-117.21378, 32.90576], [-117.21389, 32.90559], [-117.21547, 32.9056]]]]} | Open Access 1 | 44831 | Los Penasquitos Canyon Preserve | 21528 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LosPenasquitos.html | San Diego 4 | 255.079 | Los Penasquitos Canyon Preserve | 0 | Local Conservation Area 4 | 2 |
13205 | 13205 | 13204 | {"type": "MultiPolygon", "coordinates": [[[[-116.92352, 32.60821], [-116.9235, 32.61195], [-116.91216, 32.61202], [-116.91078, 32.61199], [-116.91094, 32.61568], [-116.90658, 32.61567], [-116.90666, 32.61927], [-116.90219, 32.61927], [-116.90214, 32.61198], [-116.91078, 32.61199], [-116.9108, 32.60449], [-116.91928, 32.60446], [-116.91928, 32.6082], [-116.92352, 32.60821]]], [[[-116.91632, 32.65562], [-116.91629, 32.65938], [-116.91356, 32.65931], [-116.91311, 32.65864], [-116.91287, 32.65836], [-116.91254, 32.65791], [-116.91207, 32.65716], [-116.91169, 32.65659], [-116.91154, 32.65645], [-116.91128, 32.65626], [-116.91056, 32.65556], [-116.91239, 32.65554], [-116.91632, 32.65562]]]]} | Open Access 1 | 45236 | Otay Ranch Preserve | 10734 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/pds/mscp/or.html | San Diego 4 | 368.875 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
12511 | 12511 | 12510 | {"type": "Polygon", "coordinates": [[[-122.88176, 39.1186], [-122.88175, 39.11912], [-122.87917, 39.11957], [-122.87867, 39.11973], [-122.87835, 39.11987], [-122.8781, 39.12], [-122.87511, 39.12088], [-122.87443, 39.11976], [-122.87471, 39.11976], [-122.87471, 39.11945], [-122.87507, 39.11939], [-122.87554, 39.11916], [-122.87568, 39.11893], [-122.87573, 39.11877], [-122.87571, 39.11844], [-122.87566, 39.11801], [-122.87569, 39.11746], [-122.87738, 39.11623], [-122.87753, 39.11618], [-122.87832, 39.11638], [-122.87874, 39.11687], [-122.87937, 39.11686], [-122.87941, 39.11692], [-122.87975, 39.1171], [-122.88022, 39.11721], [-122.88119, 39.1179], [-122.88155, 39.11829], [-122.88158, 39.11856], [-122.88166, 39.11861], [-122.88176, 39.1186]]]} | Open Access 1 | 28342 | Rodman Slough | 24551 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 43.698 | Rodman Slough | 0 | Local Conservation Area 4 | 2 | |
12242 | 12242 | 12241 | {"type": "MultiPolygon", "coordinates": [[[[-117.18634, 33.08768], [-117.18422, 33.08768], [-117.18424, 33.08862], [-117.1842, 33.09134], [-117.18211, 33.09133], [-117.18197, 33.09493], [-117.17742, 33.09493], [-117.17755, 33.08762], [-117.17527, 33.08759], [-117.17541, 33.08587], [-117.17429, 33.08585], [-117.17445, 33.08402], [-117.17778, 33.08404], [-117.17803, 33.08039], [-117.17905, 33.08039], [-117.18143, 33.08206], [-117.18122, 33.08316], [-117.17997, 33.08494], [-117.1802, 33.08476], [-117.18126, 33.08458], [-117.18138, 33.08479], [-117.18209, 33.08429], [-117.1826, 33.08426], [-117.1827, 33.08451], [-117.18264, 33.08506], [-117.18284, 33.08558], [-117.18309, 33.08538], [-117.18327, 33.08488], [-117.18313, 33.08447], [-117.18316, 33.08417], [-117.18324, 33.08408], [-117.18445, 33.08407], [-117.18504, 33.08445], [-117.18538, 33.08469], [-117.18565, 33.08491], [-117.18581, 33.08507], [-117.18633, 33.08568], [-117.18634, 33.08768]]], [[[-117.18635, 33.08529], [-117.186, 33.08489], [-117.18581, 33.08472], [-117.18524, 33.08429], [-117.18491, 33.08407], [-117.18633, 33.08407], [-117.18635, 33.08529]]]]} | No Public Access 3 | 25447 | Sage Hill Preserve | 29254 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 231.523 | Sage Hill Preserve | 0 | Local Conservation Area 4 | 2 | |
11421 | 11421 | 11420 | {"type": "Polygon", "coordinates": [[[-121.28865, 38.49607], [-121.27955, 38.49606], [-121.27946, 38.48155], [-121.28863, 38.48158], [-121.28865, 38.49607]]]} | Restricted Access 2 | 22240 | Vernal Pool Prairie Preserve Area | 27000 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 317.004 | Vernal Pool Prairie Preserve Area | 0 | Local Conservation Area 4 | 2 | |
11385 | 11385 | 11384 | {"type": "Polygon", "coordinates": [[[-121.17077, 38.75418], [-121.16993, 38.75466], [-121.1697, 38.75468], [-121.16948, 38.75447], [-121.1688, 38.75478], [-121.16876, 38.75502], [-121.16861, 38.7552], [-121.16835, 38.75537], [-121.16788, 38.7554], [-121.16753, 38.75571], [-121.16726, 38.75588], [-121.16716, 38.75623], [-121.16677, 38.75661], [-121.16673, 38.75682], [-121.16613, 38.75708], [-121.16599, 38.75725], [-121.16577, 38.75739], [-121.16555, 38.75728], [-121.16531, 38.75748], [-121.16497, 38.75763], [-121.16483, 38.75781], [-121.16452, 38.75776], [-121.16401, 38.7578], [-121.164, 38.75736], [-121.16404, 38.75718], [-121.16409, 38.75705], [-121.16416, 38.7569], [-121.16436, 38.75666], [-121.16713, 38.75422], [-121.16735, 38.75406], [-121.16907, 38.75301], [-121.17077, 38.75418]]]} | Restricted Access 2 | 22191 | Miners Ravine Nature Reserve | 22264 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 24.569 | Miners Ravine Nature 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]);