units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where MNG_AGENCY = 189 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, YR_EST, GAP_STS
DES_TP 11
- Local Park 34
- Local Conservation Area 5
- Local Recreation Area 3
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- Sonoma County Regional Parks Dept., County of · 50 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16963 | 16963 | 16962 | {"type": "Polygon", "coordinates": [[[-122.58874, 38.46739], [-122.57456, 38.4674], [-122.57458, 38.47462], [-122.57935, 38.47459], [-122.57982, 38.48188], [-122.57968, 38.48187], [-122.57967, 38.48188], [-122.57529, 38.48181], [-122.57329, 38.48205], [-122.57255, 38.48576], [-122.57349, 38.48565], [-122.57394, 38.48565], [-122.57555, 38.4854], [-122.57566, 38.48664], [-122.575, 38.48674], [-122.57309, 38.48691], [-122.57311, 38.48938], [-122.57291, 38.48941], [-122.57094, 38.48959], [-122.5709, 38.48817], [-122.57066, 38.48773], [-122.57096, 38.48717], [-122.57098, 38.4857], [-122.57095, 38.48534], [-122.57095, 38.48496], [-122.57101, 38.48469], [-122.57104, 38.48421], [-122.57102, 38.48404], [-122.57107, 38.48361], [-122.57126, 38.4831], [-122.57203, 38.48234], [-122.57202, 38.48232], [-122.5722, 38.48216], [-122.57192, 38.48137], [-122.57194, 38.48087], [-122.57024, 38.47879], [-122.56995, 38.47519], [-122.56086, 38.47629], [-122.56102, 38.47197], [-122.5567, 38.47182], [-122.557, 38.46681], [-122.55275, 38.46659], [-122.55303, 38.46244], [-122.54012, 38.46228], [-122.54025, 38.45857], [-122.54461, 38.45847], [-122.5446, 38.45829], [-122.54458, 38.45828], [-122.54369, 38.44399], [-122.5446, 38.44401], [-122.54461, 38.44399], [-122.55309, 38.44393], [-122.55317, 38.44754], [-122.55758, 38.44748], [-122.55773, 38.44741], [-122.55775, 38.4439], [-122.56222, 38.44386], [-122.56223, 38.44389], [-122.5623, 38.44386], [-122.56255, 38.44386], [-122.5625, 38.44785], [-122.56247, 38.45493], [-122.56723, 38.45524], [-122.57088, 38.45577], [-122.57103, 38.45582], [-122.57115, 38.45617], [-122.57135, 38.45652], [-122.57082, 38.45677], [-122.5703, 38.45689], [-122.56973, 38.4574], [-122.57, 38.45786], [-122.56999, 38.45828], [-122.57118, 38.45832], [-122.57119, 38.45831], [-122.57108, 38.45816], [-122.5716, 38.45786], [-122.57231, 38.45767], [-122.57262, 38.45741], [-122.57312, 38.45707], [-122.57321, 38.45678], [-122.57361, 38.4566], [-122.57382, 38.45642], [-122.57437, 38.4566], [-122.57459, 38.45675], [-122.57471, 38.45676], [-122.57487, 38.45669], [-122.57512, 38.45656], [-122.57522, 38.45624], [-122.57529, 38.4561], [-122.57546, 38.45589], [-122.57543, 38.45571], [-122.57524, 38.45549], [-122.57508, 38.4547], [-122.57511, 38.45443], [-122.57493, 38.45423], [-122.57462, 38.45395], [-122.57451, 38.45388], [-122.57436, 38.45383], [-122.57419, 38.4538], [-122.5739, 38.45369], [-122.57383, 38.45356], [-122.5735, 38.45343], [-122.57344, 38.45313], [-122.57353, 38.45308], [-122.57353, 38.45304], [-122.57384, 38.45266], [-122.57376, 38.45229], [-122.57406, 38.4519], [-122.57396, 38.4512], [-122.57405, 38.45123], [-122.57409, 38.45129], [-122.57423, 38.45163], [-122.57429, 38.45187], [-122.57445, 38.45274], [-122.57442, 38.45292], [-122.57426, 38.45323], [-122.57393, 38.45348], [-122.57393, 38.4535], [-122.57473, 38.45362], [-122.57695, 38.45361], [-122.57686, 38.46012], [-122.57945, 38.46013], [-122.57949, 38.46376], [-122.58857, 38.46375], [-122.58874, 38.46739]], [[-122.57553, 38.45834], [-122.57554, 38.45833], [-122.57511, 38.45693], [-122.57482, 38.45718], [-122.57473, 38.45735], [-122.57383, 38.45766], [-122.5738, 38.45769], [-122.57377, 38.4577], [-122.57356, 38.45797], [-122.57357, 38.45799], [-122.57553, 38.45834]]]} | Open Access 1 | 5373 | Hood Mountain Regional Park and Open Space Preserve | 33694 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Hood_Mountain_Regional_Park_Open_Space_Preserve.aspx | Sonoma 16 | 1945.919 | Hood Mtn. RP and OSP | 2000 | Local Conservation Area 4 | 2 |
16962 | 16962 | 16961 | {"type": "Polygon", "coordinates": [[[-122.69916, 38.40548], [-122.69193, 38.40553], [-122.69503, 38.40897], [-122.69493, 38.40898], [-122.695, 38.41166], [-122.695, 38.4166], [-122.69593, 38.4166], [-122.69565, 38.41673], [-122.6951, 38.41708], [-122.69508, 38.41706], [-122.69481, 38.41722], [-122.69471, 38.41726], [-122.69441, 38.41732], [-122.6944, 38.41728], [-122.694, 38.41727], [-122.69318, 38.41735], [-122.69296, 38.41734], [-122.69276, 38.4173], [-122.69224, 38.41712], [-122.69203, 38.41704], [-122.69183, 38.41693], [-122.69165, 38.41681], [-122.6915, 38.41667], [-122.69134, 38.41649], [-122.69121, 38.41656], [-122.69037, 38.41631], [-122.69006, 38.41624], [-122.68991, 38.41651], [-122.68599, 38.41653], [-122.68604, 38.42007], [-122.68576, 38.42007], [-122.68574, 38.42174], [-122.68666, 38.42175], [-122.68667, 38.4218], [-122.68743, 38.4218], [-122.68714, 38.42206], [-122.68678, 38.42221], [-122.68679, 38.42222], [-122.68724, 38.42233], [-122.68653, 38.42372], [-122.68229, 38.42372], [-122.68228, 38.4237], [-122.68054, 38.42369], [-122.68053, 38.4237], [-122.68058, 38.42406], [-122.68045, 38.42408], [-122.67982, 38.42408], [-122.67982, 38.42369], [-122.67937, 38.42368], [-122.67936, 38.42329], [-122.67933, 38.42321], [-122.67919, 38.42295], [-122.67906, 38.42279], [-122.679, 38.42263], [-122.67874, 38.42234], [-122.67846, 38.42175], [-122.67811, 38.42153], [-122.67796, 38.42147], [-122.67786, 38.42147], [-122.67778, 38.42143], [-122.6776, 38.42123], [-122.67676, 38.42076], [-122.6764, 38.4207], [-122.67605, 38.42058], [-122.67598, 38.42055], [-122.67598, 38.41987], [-122.67592, 38.41634], [-122.67592, 38.41269], [-122.67433, 38.41105], [-122.67254, 38.40927], [-122.6719, 38.40891], [-122.66956, 38.40762], [-122.66908, 38.40754], [-122.66822, 38.4075], [-122.66797, 38.40756], [-122.66758, 38.40773], [-122.66738, 38.40777], [-122.66717, 38.40779], [-122.66724, 38.40768], [-122.6672, 38.40729], [-122.66747, 38.40719], [-122.66753, 38.40685], [-122.66799, 38.40646], [-122.66823, 38.40639], [-122.66884, 38.40641], [-122.6689, 38.40629], [-122.66902, 38.40631], [-122.66954, 38.40596], [-122.6695, 38.40587], [-122.66958, 38.40577], [-122.66955, 38.40571], [-122.66968, 38.40551], [-122.66986, 38.40553], [-122.66995, 38.40538], [-122.67045, 38.40543], [-122.67053, 38.4054], [-122.67075, 38.40542], [-122.67117, 38.40563], [-122.6712, 38.40566], [-122.67156, 38.40578], [-122.67213, 38.40599], [-122.67249, 38.40606], [-122.67274, 38.40601], [-122.67353, 38.40609], [-122.67414, 38.40641], [-122.6746, 38.40678], [-122.67502, 38.40708], [-122.67541, 38.4073], [-122.67882, 38.4056], [-122.67996, 38.40489], [-122.6808, 38.40391], [-122.68103, 38.40378], [-122.68113, 38.40365], [-122.68089, 38.40266], [-122.68089, 38.40246], [-122.68069, 38.4017], [-122.67586, 38.40172], [-122.67577, 38.39145], [-122.67746, 38.39144], [-122.68035, 38.39432], [-122.68374, 38.3974], [-122.68601, 38.39962], [-122.69524, 38.39956], [-122.69831, 38.40433], [-122.69916, 38.40548]], [[-122.67737, 38.41815], [-122.67736, 38.41814], [-122.67649, 38.41822], [-122.67649, 38.41895], [-122.67737, 38.41887], [-122.67737, 38.41815]], [[-122.69213, 38.41505], [-122.69218, 38.41521], [-122.69275, 38.41494], [-122.69228, 38.4136], [-122.6917, 38.41311], [-122.69125, 38.41309], [-122.69083, 38.41349], [-122.69118, 38.41457], [-122.69204, 38.41485], [-122.69213, 38.41505]]]} | Open Access 1 | 47551 | Taylor Mountain Regional Park and Open Space Preserve | 31267 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 1078.756 | Taylor Mtn. RP and OSP | 0 | Local Conservation Area 4 | 2 | |
16961 | 16961 | 16960 | {"type": "Polygon", "coordinates": [[[-122.59275, 38.35752], [-122.59758, 38.35753], [-122.60189, 38.35746], [-122.60574, 38.35731], [-122.61101, 38.35729], [-122.61111, 38.36422], [-122.61108, 38.36669], [-122.61109, 38.36808], [-122.611, 38.36814], [-122.61097, 38.3664], [-122.61084, 38.36639], [-122.61065, 38.3663], [-122.61046, 38.36632], [-122.61038, 38.36629], [-122.61025, 38.3662], [-122.60984, 38.36599], [-122.60952, 38.36596], [-122.60932, 38.36588], [-122.60887, 38.36565], [-122.60876, 38.36565], [-122.60875, 38.36475], [-122.60182, 38.36461], [-122.60176, 38.3695], [-122.60098, 38.36977], [-122.60061, 38.36985], [-122.59981, 38.36993], [-122.59942, 38.36994], [-122.59921, 38.36991], [-122.59837, 38.36947], [-122.59825, 38.36938], [-122.59804, 38.3692], [-122.5978, 38.36905], [-122.59751, 38.36897], [-122.59689, 38.36892], [-122.59674, 38.36888], [-122.5966, 38.36883], [-122.59647, 38.36876], [-122.59636, 38.36867], [-122.59626, 38.36857], [-122.59609, 38.36835], [-122.59603, 38.36823], [-122.59592, 38.3679], [-122.59588, 38.36784], [-122.5958, 38.36777], [-122.59565, 38.36761], [-122.59559, 38.36756], [-122.59522, 38.3674], [-122.59478, 38.3673], [-122.59459, 38.36719], [-122.59451, 38.36716], [-122.59435, 38.36713], [-122.59383, 38.36712], [-122.59373, 38.3671], [-122.59351, 38.36703], [-122.5934, 38.36697], [-122.59323, 38.36681], [-122.59294, 38.36634], [-122.59272, 38.36607], [-122.5927, 38.36608], [-122.5927, 38.36618], [-122.59225, 38.3658], [-122.59231, 38.3655], [-122.59231, 38.3651], [-122.59193, 38.36501], [-122.59193, 38.36485], [-122.59199, 38.36467], [-122.59225, 38.36437], [-122.59252, 38.36411], [-122.59254, 38.36338], [-122.59206, 38.36308], [-122.59215, 38.36267], [-122.59238, 38.36197], [-122.59229, 38.36157], [-122.5921, 38.36132], [-122.59191, 38.36115], [-122.58361, 38.36133], [-122.58367, 38.35773], [-122.5836, 38.35666], [-122.57355, 38.35569], [-122.57359, 38.35409], [-122.58359, 38.35396], [-122.5836, 38.35559], [-122.58583, 38.35554], [-122.58592, 38.35768], [-122.59275, 38.35752]], [[-122.59753, 38.36185], [-122.59722, 38.3625], [-122.59668, 38.3625], [-122.59601, 38.36194], [-122.59655, 38.36153], [-122.59655, 38.36151], [-122.59518, 38.36038], [-122.59438, 38.36097], [-122.5956, 38.36198], [-122.59586, 38.3618], [-122.59592, 38.36186], [-122.59533, 38.36229], [-122.59566, 38.36259], [-122.59566, 38.3632], [-122.59573, 38.3632], [-122.59574, 38.36417], [-122.59731, 38.36417], [-122.59732, 38.36406], [-122.59785, 38.36405], [-122.59785, 38.36404], [-122.59769, 38.36396], [-122.59757, 38.36387], [-122.59743, 38.36368], [-122.59735, 38.36351], [-122.59735, 38.3625], [-122.59848, 38.36249], [-122.59824, 38.36068], [-122.59739, 38.36074], [-122.59753, 38.36185]]]} | Open Access 1 | 47344 | North Sonoma Mountain Regional Park and Open Space Preserve | 31059 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/North_Sonoma_Mountain_Regional_Park_and_Open_Space_Preserve.aspx | Sonoma 16 | 544.043 | North Sonoma Mtn. RP and OSP | 1999 | Local Conservation Area 4 | 2 |
16375 | 16375 | 16374 | {"type": "MultiPolygon", "coordinates": [[[[-123.03513, 38.31417], [-123.03357, 38.31511], [-123.03504, 38.31709], [-123.03421, 38.31713], [-123.0338, 38.31748], [-123.03355, 38.31704], [-123.03326, 38.31662], [-123.03289, 38.3165], [-123.03214, 38.31519], [-123.03237, 38.31444], [-123.03432, 38.31398], [-123.0351, 38.31413], [-123.03513, 38.31417]]], [[[-123.05308, 38.30992], [-123.05115, 38.31187], [-123.0469, 38.31329], [-123.04469, 38.31382], [-123.04432, 38.31298], [-123.04776, 38.31195], [-123.05076, 38.31098], [-123.05308, 38.30992]]]]} | Open Access 1 | 22039 | Doran Regional Park | 18217 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 31.404 | Doran RP | 0 | Local Park 2 | 4 | |
16359 | 16359 | 16358 | {"type": "Polygon", "coordinates": [[[-122.79808, 38.56412], [-122.79667, 38.5642], [-122.79668, 38.56469], [-122.79808, 38.56462], [-122.79807, 38.56591], [-122.78366, 38.56593], [-122.78385, 38.56311], [-122.78471, 38.56232], [-122.7847, 38.56209], [-122.78223, 38.5621], [-122.78219, 38.55891], [-122.78692, 38.55886], [-122.78693, 38.55796], [-122.78804, 38.55718], [-122.78882, 38.55718], [-122.78861, 38.55728], [-122.78852, 38.55743], [-122.78848, 38.55791], [-122.78828, 38.55829], [-122.78866, 38.55892], [-122.7888, 38.55986], [-122.78932, 38.56006], [-122.78976, 38.56008], [-122.79011, 38.56016], [-122.7907, 38.56055], [-122.79184, 38.56065], [-122.79262, 38.56091], [-122.79305, 38.56089], [-122.79358, 38.56122], [-122.79379, 38.56121], [-122.79439, 38.56132], [-122.79454, 38.56149], [-122.79463, 38.56152], [-122.79517, 38.56143], [-122.79545, 38.56148], [-122.79605, 38.56151], [-122.79634, 38.56144], [-122.79652, 38.56132], [-122.79721, 38.56098], [-122.79763, 38.56062], [-122.79784, 38.56068], [-122.79806, 38.56119], [-122.79809, 38.56396], [-122.79808, 38.56412]]]} | Open Access 1 | 16477 | Foothill Regional Park | 29216 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Foothill_Regional_Park.aspx | Sonoma 16 | 210.538 | Foothill RP | 0 | Local Park 2 | 4 |
16356 | 16356 | 16355 | {"type": "Polygon", "coordinates": [[[-122.48498, 38.29995], [-122.48499, 38.30014], [-122.48496, 38.30023], [-122.48485, 38.30037], [-122.48477, 38.3005], [-122.48441, 38.3008], [-122.48396, 38.30112], [-122.48388, 38.30121], [-122.48383, 38.30135], [-122.48383, 38.30148], [-122.48385, 38.30158], [-122.48421, 38.30244], [-122.4842, 38.30251], [-122.48418, 38.30255], [-122.48383, 38.30261], [-122.48128, 38.30272], [-122.47925, 38.30275], [-122.47887, 38.30272], [-122.47774, 38.30275], [-122.47743, 38.30274], [-122.47727, 38.30269], [-122.477, 38.30259], [-122.47674, 38.30254], [-122.47651, 38.30253], [-122.4762, 38.30256], [-122.47609, 38.30253], [-122.47519, 38.30158], [-122.4751, 38.30145], [-122.47504, 38.30133], [-122.47498, 38.30114], [-122.47497, 38.30102], [-122.47497, 38.30081], [-122.47498, 38.30077], [-122.475, 38.30077], [-122.47502, 38.30064], [-122.47767, 38.30091], [-122.47746, 38.29989], [-122.47693, 38.29884], [-122.48187, 38.29845], [-122.48143, 38.29788], [-122.48129, 38.29749], [-122.48071, 38.29723], [-122.47973, 38.29729], [-122.48056, 38.29647], [-122.48135, 38.29698], [-122.48158, 38.29719], [-122.48184, 38.29757], [-122.48191, 38.29782], [-122.48197, 38.29811], [-122.48204, 38.29832], [-122.48217, 38.29852], [-122.48241, 38.29867], [-122.48329, 38.29884], [-122.48353, 38.2989], [-122.48374, 38.299], [-122.48401, 38.29914], [-122.48442, 38.2994], [-122.48468, 38.2996], [-122.48498, 38.29995]]]} | Open Access 1 | 17744 | Maxwell Farms Regional Park | 21969 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 78.864 | Maxwell Farms RP | 0 | Local Park 2 | 4 | |
16354 | 16354 | 16353 | {"type": "Polygon", "coordinates": [[[-122.66029, 38.21986], [-122.66026, 38.22123], [-122.65864, 38.2212], [-122.65548, 38.2198], [-122.6538, 38.21978], [-122.65369, 38.21958], [-122.65329, 38.21977], [-122.65311, 38.2196], [-122.65234, 38.21908], [-122.6527, 38.21875], [-122.65269, 38.21873], [-122.65166, 38.21821], [-122.65107, 38.21856], [-122.65112, 38.21616], [-122.6557, 38.21616], [-122.6557, 38.21981], [-122.66029, 38.21986]]]} | Open Access 1 | 16320 | Helen Putnam Regional Park | 19801 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 45.192 | Helen Putnam RP | 1975 | Local Park 2 | 4 | |
16342 | 16342 | 16341 | {"type": "Polygon", "coordinates": [[[-122.52762, 38.20438], [-122.52325, 38.20854], [-122.52325, 38.20856], [-122.52512, 38.2094], [-122.51982, 38.21673], [-122.51958, 38.21647], [-122.51926, 38.21618], [-122.51815, 38.21741], [-122.51667, 38.21364], [-122.51098, 38.21317], [-122.50883, 38.2148], [-122.50824, 38.21367], [-122.50585, 38.21091], [-122.50337, 38.21308], [-122.50291, 38.21352], [-122.50207, 38.2126], [-122.50144, 38.21335], [-122.50422, 38.21553], [-122.50528, 38.21642], [-122.50179, 38.21996], [-122.50108, 38.21932], [-122.4997, 38.21796], [-122.49899, 38.21761], [-122.49727, 38.21635], [-122.49355, 38.21056], [-122.49168, 38.20981], [-122.49141, 38.20911], [-122.49104, 38.20866], [-122.49079, 38.20864], [-122.49065, 38.20851], [-122.48982, 38.20798], [-122.48954, 38.20759], [-122.48867, 38.20715], [-122.48661, 38.20644], [-122.48646, 38.20407], [-122.48661, 38.20199], [-122.48829, 38.20128], [-122.49001, 38.20127], [-122.49121, 38.20014], [-122.49131, 38.20017], [-122.49296, 38.20041], [-122.49345, 38.20052], [-122.49471, 38.20059], [-122.49535, 38.20044], [-122.49584, 38.19983], [-122.49615, 38.19923], [-122.49699, 38.19896], [-122.49788, 38.19934], [-122.50009, 38.19971], [-122.50075, 38.19966], [-122.50117, 38.19909], [-122.50102, 38.19718], [-122.49859, 38.19435], [-122.49774, 38.19403], [-122.49642, 38.19371], [-122.49675, 38.19327], [-122.49749, 38.19298], [-122.49792, 38.19256], [-122.4978, 38.1924], [-122.49726, 38.19196], [-122.49721, 38.19188], [-122.4972, 38.19182], [-122.49723, 38.19179], [-122.49721, 38.19176], [-122.49722, 38.19166], [-122.4979, 38.1917], [-122.49852, 38.19165], [-122.49856, 38.19169], [-122.49855, 38.19173], [-122.49868, 38.1918], [-122.49954, 38.19151], [-122.50035, 38.19151], [-122.50035, 38.19147], [-122.50063, 38.19144], [-122.50129, 38.1908], [-122.50154, 38.19038], [-122.50157, 38.1901], [-122.50168, 38.18995], [-122.50186, 38.18985], [-122.50224, 38.18976], [-122.50272, 38.18956], [-122.50343, 38.18921], [-122.50568, 38.18696], [-122.50996, 38.18359], [-122.51644, 38.18887], [-122.51587, 38.18959], [-122.51482, 38.19013], [-122.51436, 38.19038], [-122.51165, 38.19146], [-122.51164, 38.19148], [-122.51377, 38.19288], [-122.51577, 38.19418], [-122.51921, 38.19581], [-122.52091, 38.19654], [-122.5191, 38.19805], [-122.5242, 38.20139], [-122.52424, 38.20149], [-122.52762, 38.20438]]]} | Open Access 1 | 9819 | Tolay Lake Regional Park | 33777 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 1760.959 | Tolay Lake RP | 0 | Local Park 2 | 4 | |
16309 | 16309 | 16308 | {"type": "Polygon", "coordinates": [[[-122.8705, 38.51272], [-122.86999, 38.51343], [-122.86999, 38.51352], [-122.86958, 38.51497], [-122.86766, 38.5152], [-122.86677, 38.51544], [-122.86557, 38.51623], [-122.86497, 38.5169], [-122.8643, 38.51739], [-122.86339, 38.51778], [-122.86351, 38.51797], [-122.86269, 38.51846], [-122.86229, 38.51951], [-122.86256, 38.52195], [-122.86282, 38.52291], [-122.86362, 38.52421], [-122.86363, 38.52487], [-122.8633, 38.52519], [-122.85421, 38.52524], [-122.85416, 38.52163], [-122.8496, 38.52163], [-122.84971, 38.52152], [-122.85392, 38.52152], [-122.85396, 38.5213], [-122.85407, 38.52129], [-122.85444, 38.51889], [-122.85439, 38.51879], [-122.85422, 38.51753], [-122.8557, 38.51605], [-122.85844, 38.51605], [-122.85921, 38.51599], [-122.85979, 38.5149], [-122.85935, 38.51436], [-122.85969, 38.51363], [-122.86151, 38.51259], [-122.86207, 38.51214], [-122.86286, 38.51144], [-122.86357, 38.51125], [-122.86546, 38.51071], [-122.86641, 38.51052], [-122.86697, 38.51046], [-122.86753, 38.51048], [-122.86818, 38.51062], [-122.86936, 38.5111], [-122.86951, 38.51122], [-122.86987, 38.5114], [-122.86995, 38.51158], [-122.87045, 38.51217], [-122.87046, 38.5125], [-122.8705, 38.51272]]]} | Open Access 1 | 5369 | Riverfront Regional Park | 12628 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Riverfront_Regional_Park.aspx | Sonoma 16 | 303.937 | Riverfront RP | 0 | Local Park 2 | 4 |
16307 | 16307 | 16306 | {"type": "Polygon", "coordinates": [[[-122.76377, 38.50404], [-122.76234, 38.50447], [-122.76224, 38.50425], [-122.76213, 38.50411], [-122.76132, 38.50347], [-122.76047, 38.50283], [-122.76003, 38.50275], [-122.76016, 38.50129], [-122.76035, 38.50129], [-122.76377, 38.50404]]]} | Open Access 1 | 17528 | Maddux Ranch Regional Park | 21647 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 10.368 | Maddux Ranch RP | 0 | Local Park 2 | 4 | |
16306 | 16306 | 16305 | {"type": "MultiPolygon", "coordinates": [[[[-122.64607, 38.45736], [-122.64388, 38.45708], [-122.64438, 38.45707], [-122.64506, 38.45703], [-122.64608, 38.45691], [-122.64721, 38.45669], [-122.64823, 38.45644], [-122.64828, 38.45644], [-122.64831, 38.45647], [-122.64848, 38.45735], [-122.64843, 38.45767], [-122.64835, 38.45774], [-122.64824, 38.45775], [-122.6469, 38.45746], [-122.64607, 38.45736]]], [[[-122.66092, 38.45518], [-122.65973, 38.45626], [-122.65975, 38.45936], [-122.65617, 38.45995], [-122.65546, 38.4601], [-122.65464, 38.46042], [-122.65457, 38.46055], [-122.65418, 38.46074], [-122.65383, 38.46065], [-122.65373, 38.46078], [-122.6537, 38.46089], [-122.65372, 38.46161], [-122.6533, 38.46124], [-122.65302, 38.46095], [-122.65167, 38.45939], [-122.65138, 38.45911], [-122.65106, 38.45885], [-122.65078, 38.45866], [-122.65049, 38.45849], [-122.64994, 38.45822], [-122.64936, 38.45801], [-122.64866, 38.45784], [-122.64862, 38.45782], [-122.64859, 38.45775], [-122.64865, 38.45749], [-122.64865, 38.45735], [-122.64848, 38.45642], [-122.64841, 38.45632], [-122.64833, 38.45627], [-122.64821, 38.45626], [-122.64716, 38.45652], [-122.64707, 38.45652], [-122.64701, 38.45649], [-122.64697, 38.45644], [-122.64697, 38.45638], [-122.64733, 38.45561], [-122.64859, 38.45566], [-122.64968, 38.455], [-122.64989, 38.45454], [-122.64988, 38.45453], [-122.649, 38.45479], [-122.64871, 38.45495], [-122.64857, 38.45478], [-122.64836, 38.45463], [-122.64792, 38.45453], [-122.64786, 38.45448], [-122.64827, 38.45362], [-122.64812, 38.45357], [-122.64859, 38.45262], [-122.64857, 38.45182], [-122.64782, 38.44613], [-122.64767, 38.44586], [-122.6476, 38.44565], [-122.64757, 38.44542], [-122.6476, 38.44518], [-122.64766, 38.44493], [-122.64761, 38.44458], [-122.64765, 38.44392], [-122.64764, 38.44359], [-122.64786, 38.44383], [-122.6481, 38.44392], [-122.64837, 38.44417], [-122.64868, 38.44435], [-122.6494, 38.44444], [-122.64969, 38.4444], [-122.64989, 38.44433], [-122.65007, 38.44418], [-122.65083, 38.44305], [-122.65083, 38.44301], [-122.65156, 38.44273], [-122.65161, 38.44288], [-122.65162, 38.44308], [-122.65159, 38.44324], [-122.6515, 38.44346], [-122.65093, 38.44418], [-122.65108, 38.44567], [-122.65145, 38.44877], [-122.65289, 38.44828], [-122.65288, 38.44824], [-122.65402, 38.44754], [-122.65408, 38.44759], [-122.65441, 38.44738], [-122.6548, 38.44829], [-122.65664, 38.44869], [-122.65663, 38.44906], [-122.6567, 38.44962], [-122.6572, 38.44987], [-122.65844, 38.45468], [-122.66092, 38.45518]]]]} | Open Access 1 | 1079 | Spring Lake Regional Park | 28940 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Spring_Lake_Regional_Park.aspx | Sonoma 16 | 317.518 | Spring Lake RP | 1970 | Local Park 2 | 4 |
16282 | 16282 | 16281 | {"type": "Polygon", "coordinates": [[[-122.52557, 38.35429], [-122.52529, 38.35427], [-122.5248, 38.35462], [-122.52536, 38.35545], [-122.52539, 38.35575], [-122.52503, 38.35602], [-122.52486, 38.35606], [-122.52475, 38.35616], [-122.52477, 38.35651], [-122.52474, 38.35681], [-122.52468, 38.35709], [-122.52456, 38.35736], [-122.52425, 38.35777], [-122.52421, 38.35787], [-122.52416, 38.35806], [-122.52425, 38.35824], [-122.52281, 38.35888], [-122.52259, 38.35915], [-122.52234, 38.35954], [-122.52236, 38.35965], [-122.52336, 38.35959], [-122.5236, 38.36051], [-122.52408, 38.36046], [-122.52412, 38.3607], [-122.52367, 38.36077], [-122.52378, 38.36121], [-122.52254, 38.36143], [-122.5227, 38.36212], [-122.5213, 38.36288], [-122.52164, 38.3638], [-122.52138, 38.36391], [-122.5212, 38.36404], [-122.52104, 38.36425], [-122.52107, 38.36436], [-122.52115, 38.36446], [-122.52119, 38.36447], [-122.52126, 38.36458], [-122.52072, 38.36467], [-122.51872, 38.36549], [-122.51876, 38.36587], [-122.51774, 38.3664], [-122.51711, 38.36563], [-122.514, 38.36719], [-122.51335, 38.36655], [-122.51271, 38.36695], [-122.51234, 38.36659], [-122.51065, 38.36488], [-122.51199, 38.36403], [-122.51199, 38.36401], [-122.51098, 38.36304], [-122.50966, 38.36392], [-122.50786, 38.36203], [-122.50409, 38.35769], [-122.5035, 38.35687], [-122.50362, 38.35661], [-122.50486, 38.35638], [-122.50626, 38.35783], [-122.50884, 38.36008], [-122.5115, 38.36128], [-122.51253, 38.36145], [-122.51698, 38.36], [-122.51733, 38.35999], [-122.52143, 38.35607], [-122.52185, 38.35259], [-122.52229, 38.35282], [-122.52313, 38.35341], [-122.52273, 38.35355], [-122.52312, 38.35407], [-122.52331, 38.35389], [-122.52472, 38.35344], [-122.52557, 38.35429]]]} | Open Access 1 | 1008 | Sonoma Valley Regional Park | 25619 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 254.384 | Sonoma Valley RP | 1978 | Local Park 2 | 4 | |
16279 | 16279 | 16278 | {"type": "Polygon", "coordinates": [[[-122.76325, 38.52529], [-122.76321, 38.52535], [-122.76317, 38.52534], [-122.76221, 38.52687], [-122.76287, 38.52797], [-122.7617, 38.52844], [-122.76152, 38.52871], [-122.76074, 38.52912], [-122.76031, 38.52925], [-122.75963, 38.52928], [-122.75759, 38.53011], [-122.75772, 38.53224], [-122.75741, 38.53247], [-122.75702, 38.53281], [-122.75696, 38.53282], [-122.75332, 38.5356], [-122.75247, 38.53564], [-122.75147, 38.53441], [-122.75058, 38.53484], [-122.75034, 38.5356], [-122.75166, 38.53629], [-122.75262, 38.53636], [-122.75226, 38.53656], [-122.75159, 38.53671], [-122.75149, 38.53692], [-122.75121, 38.53703], [-122.75108, 38.53722], [-122.75063, 38.53737], [-122.75063, 38.53784], [-122.75009, 38.53794], [-122.74977, 38.53806], [-122.7497, 38.53835], [-122.74938, 38.5385], [-122.74879, 38.5386], [-122.74697, 38.53929], [-122.74598, 38.53893], [-122.74513, 38.53843], [-122.74354, 38.53772], [-122.74167, 38.5375], [-122.74117, 38.5373], [-122.73981, 38.53663], [-122.74273, 38.53517], [-122.74277, 38.53471], [-122.742, 38.53225], [-122.74256, 38.53261], [-122.74287, 38.5323], [-122.74283, 38.53192], [-122.742, 38.53197], [-122.74256, 38.52835], [-122.74218, 38.52713], [-122.7406, 38.52132], [-122.73573, 38.51875], [-122.7351, 38.51851], [-122.73405, 38.51876], [-122.73098, 38.51855], [-122.73104, 38.51932], [-122.72968, 38.51999], [-122.72982, 38.52201], [-122.72983, 38.52248], [-122.72899, 38.52553], [-122.72951, 38.52734], [-122.72967, 38.52754], [-122.72998, 38.52782], [-122.73038, 38.52801], [-122.73074, 38.52823], [-122.7311, 38.52861], [-122.7312, 38.52902], [-122.73092, 38.52952], [-122.7281, 38.53117], [-122.72812, 38.53051], [-122.72841, 38.53041], [-122.72907, 38.53005], [-122.7294, 38.52973], [-122.72977, 38.52947], [-122.73025, 38.52923], [-122.73046, 38.52891], [-122.7299, 38.52848], [-122.72942, 38.52829], [-122.72905, 38.528], [-122.72899, 38.52769], [-122.7285, 38.52718], [-122.72841, 38.52713], [-122.72822, 38.52691], [-122.72788, 38.52666], [-122.72773, 38.52644], [-122.72768, 38.52633], [-122.72766, 38.52624], [-122.72798, 38.52624], [-122.72817, 38.52563], [-122.72815, 38.51827], [-122.73256, 38.51819], [-122.73968, 38.51821], [-122.74216, 38.51822], [-122.74689, 38.51833], [-122.7513, 38.51837], [-122.75583, 38.51837], [-122.7577, 38.51839], [-122.75757, 38.51859], [-122.75754, 38.51856], [-122.75681, 38.51874], [-122.75657, 38.51872], [-122.75619, 38.51907], [-122.75588, 38.5195], [-122.75601, 38.51958], [-122.75809, 38.52169], [-122.759, 38.52186], [-122.75947, 38.5216], [-122.76249, 38.52478], [-122.76285, 38.52506], [-122.76325, 38.52529]]]} | Open Access 1 | 750 | Shiloh Ranch Regional Park | 31718 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Shiloh_Ranch_Regional_Park.aspx | Sonoma 16 | 843.329 | Shiloh Ranch RP | 0 | Local Park 2 | 4 |
12459 | 12459 | 12458 | {"type": "Polygon", "coordinates": [[[-122.93948, 38.35579], [-122.93861, 38.35592], [-122.93857, 38.35592], [-122.93856, 38.35587], [-122.93847, 38.35577], [-122.93853, 38.35573], [-122.93849, 38.35551], [-122.93858, 38.35544], [-122.93913, 38.35514], [-122.93922, 38.35551], [-122.93948, 38.35579]]]} | Restricted Access 2 | 28220 | Watson School/ Wayside Park | 31655 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 1.062 | Watson School/ Wayside Park | 0 | Local Park 2 | 4 | |
11567 | 11567 | 11566 | {"type": "Polygon", "coordinates": [[[-123.45916, 38.71589], [-123.45775, 38.71717], [-123.45715, 38.71765], [-123.45648, 38.71675], [-123.45595, 38.71631], [-123.4566, 38.71574], [-123.45706, 38.71605], [-123.45742, 38.71585], [-123.45649, 38.71505], [-123.45634, 38.71501], [-123.45631, 38.71486], [-123.45642, 38.71479], [-123.4566, 38.71486], [-123.45662, 38.71497], [-123.45735, 38.71555], [-123.45756, 38.71542], [-123.45757, 38.71526], [-123.45657, 38.71442], [-123.45616, 38.71442], [-123.4556, 38.71483], [-123.45522, 38.71454], [-123.45545, 38.71434], [-123.45545, 38.71433], [-123.45328, 38.71253], [-123.45404, 38.7124], [-123.45461, 38.71221], [-123.45484, 38.71259], [-123.4547, 38.7131], [-123.45507, 38.71341], [-123.45618, 38.71372], [-123.45651, 38.71397], [-123.4573, 38.71397], [-123.45798, 38.71439], [-123.4584, 38.7147], [-123.45916, 38.71589]], [[-123.45789, 38.71568], [-123.45723, 38.71618], [-123.45748, 38.71643], [-123.45818, 38.71591], [-123.45841, 38.71567], [-123.4585, 38.71535], [-123.45848, 38.71506], [-123.45832, 38.71477], [-123.45776, 38.71433], [-123.45729, 38.71411], [-123.45699, 38.71407], [-123.45684, 38.71429], [-123.45715, 38.71446], [-123.45723, 38.71441], [-123.45741, 38.71443], [-123.45782, 38.71475], [-123.45794, 38.71492], [-123.458, 38.71515], [-123.458, 38.71542], [-123.45789, 38.71568]]]} | Open Access 1 | 23649 | Stengel Beach | 25827 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 17.102 | Stengel Beach | 0 | Local Park 2 | 4 | |
11566 | 11566 | 11565 | {"type": "Polygon", "coordinates": [[[-123.4743, 38.7297], [-123.47379, 38.7302], [-123.47355, 38.72996], [-123.47404, 38.72949], [-123.4743, 38.7297]]]} | Open Access 1 | 23648 | Shell Beach | 25387 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 0.556 | Shell Beach | 0 | Local Park 2 | 4 | |
11565 | 11565 | 11564 | {"type": "Polygon", "coordinates": [[[-123.4408, 38.6977], [-123.4407, 38.69783], [-123.44058, 38.69816], [-123.43903, 38.69953], [-123.43871, 38.70002], [-123.43817, 38.6997], [-123.43849, 38.6991], [-123.43785, 38.69878], [-123.43721, 38.69906], [-123.43721, 38.69908], [-123.43743, 38.69925], [-123.43732, 38.69934], [-123.43704, 38.69916], [-123.4365, 38.6996], [-123.4365, 38.69961], [-123.43704, 38.69997], [-123.43865, 38.70061], [-123.43862, 38.70064], [-123.43836, 38.70116], [-123.43828, 38.70128], [-123.43822, 38.70128], [-123.43816, 38.70126], [-123.43765, 38.70074], [-123.4373, 38.70043], [-123.43652, 38.7001], [-123.43583, 38.69956], [-123.43667, 38.69873], [-123.4386, 38.69695], [-123.4389, 38.6966], [-123.43925, 38.69631], [-123.43926, 38.69636], [-123.44016, 38.69725], [-123.4408, 38.6977]]]} | Open Access 1 | 23647 | Pebble Beach | 23550 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 20.416 | Pebble Beach | 0 | Local Park 2 | 4 | |
11130 | 11130 | 11129 | {"type": "Polygon", "coordinates": [[[-123.01186, 38.8227], [-123.01104, 38.82375], [-123.01087, 38.82436], [-123.0084, 38.8241], [-123.00953, 38.82308], [-123.01013, 38.82257], [-123.01052, 38.82207], [-123.01186, 38.8227]]]} | Open Access 1 | 21961 | Treadwell | 26516 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 9.353 | Treadwell | None 971 | |||
10632 | 10632 | 10631 | {"type": "Polygon", "coordinates": [[[-122.85866, 38.40424], [-122.85835, 38.40474], [-122.85827, 38.40507], [-122.85535, 38.4055], [-122.85439, 38.40645], [-122.85426, 38.40655], [-122.85435, 38.40673], [-122.85077, 38.40906], [-122.85048, 38.40904], [-122.84969, 38.40687], [-122.84624, 38.40761], [-122.84553, 38.40545], [-122.84464, 38.40302], [-122.84641, 38.40217], [-122.84572, 38.40031], [-122.84938, 38.39988], [-122.85041, 38.4027], [-122.85078, 38.40359], [-122.85267, 38.40301], [-122.85314, 38.40284], [-122.85608, 38.40192], [-122.85765, 38.40336], [-122.85866, 38.40424]]]} | Open Access 1 | 18950 | Ragle Ranch | 24072 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 154.859 | Ragle Ranch | 0 | Local Park 2 | 4 | |
10262 | 10262 | 10261 | {"type": "MultiPolygon", "coordinates": [[[[-122.9257, 38.51026], [-122.92386, 38.51102], [-122.92277, 38.51136], [-122.92021, 38.51004], [-122.91967, 38.50984], [-122.91966, 38.50954], [-122.91975, 38.50957], [-122.91972, 38.50976], [-122.92029, 38.5099], [-122.9206, 38.50991], [-122.9217, 38.5099], [-122.92161, 38.50996], [-122.92161, 38.51028], [-122.92368, 38.51026], [-122.92366, 38.50983], [-122.92385, 38.50982], [-122.92388, 38.51022], [-122.92535, 38.5102], [-122.92561, 38.51011], [-122.9257, 38.51026]]], [[[-122.92253, 38.50976], [-122.92199, 38.50977], [-122.922, 38.50956], [-122.92251, 38.50948], [-122.92253, 38.50976]]]]} | Open Access 1 | 17983 | Moms Beach | 22362 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 8.917 | Moms Beach | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);