units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
236 rows where MNG_AG_TYP = 7 sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
DES_TP 30
MNG_AGENCY 6
- Los Angeles - Department of Parks and Recreation, County of 58
- Santa Clara County Parks and Recreation Dept., County of 51
- Sonoma County Regional Parks Dept., County of 48
- Marin County Parks Department, County of 30
- San Mateo County Parks and Recreation Dept., County of 23
- Del Norte County Parks, County of 6
ACCESS_TYP 4
- Open Access 186
- No Public Access 18
- Restricted Access 11
- Unknown Access 1
MNG_AG_TYP 1
- County Agency - Parks · 216 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2626 | 2626 | 2625 | {"type": "Polygon", "coordinates": [[[-122.51197, 38.34219], [-122.51196, 38.34225], [-122.51196, 38.34231], [-122.51135, 38.34242], [-122.51119, 38.34185], [-122.51136, 38.34182], [-122.51197, 38.34219]]]} | Open Access 1 | 18036 | Moran Goodman Park | 22470 | 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.652 | Moran Goodman Park | 1990 | Local Park 2 | 4 | |
2766 | 2766 | 2765 | {"type": "Polygon", "coordinates": [[[-122.45896, 37.89379], [-122.45848, 37.89539], [-122.45674, 37.89491], [-122.45576, 37.89472], [-122.45574, 37.89382], [-122.45569, 37.89313], [-122.45551, 37.89226], [-122.45534, 37.89188], [-122.45543, 37.89186], [-122.45553, 37.89187], [-122.45574, 37.89198], [-122.45599, 37.89229], [-122.45627, 37.89245], [-122.45648, 37.89245], [-122.45694, 37.8923], [-122.45718, 37.8921], [-122.45723, 37.89207], [-122.45733, 37.89206], [-122.45743, 37.89209], [-122.45749, 37.89213], [-122.45753, 37.89219], [-122.45765, 37.8926], [-122.45817, 37.89292], [-122.45862, 37.89361], [-122.45896, 37.89379]]]} | Open Access 1 | 18478 | Paradise Beach | 23398 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 18.591 | Paradise Beach | 2000 | Local Park 2 | 4 | |
2827 | 2827 | 2826 | {"type": "Polygon", "coordinates": [[[-123.35157, 38.74579], [-123.34595, 38.75146], [-123.34467, 38.75147], [-123.34463, 38.75104], [-123.34467, 38.75081], [-123.34467, 38.75048], [-123.3446, 38.74979], [-123.34462, 38.74965], [-123.34469, 38.74948], [-123.3448, 38.74935], [-123.34489, 38.74928], [-123.34501, 38.74924], [-123.34538, 38.74919], [-123.34563, 38.74912], [-123.34655, 38.74867], [-123.34697, 38.74845], [-123.34716, 38.74831], [-123.34759, 38.74796], [-123.34798, 38.74758], [-123.34816, 38.74738], [-123.34831, 38.74715], [-123.34849, 38.74679], [-123.34856, 38.74646], [-123.34856, 38.74625], [-123.34862, 38.74602], [-123.34891, 38.74524], [-123.34929, 38.74454], [-123.34942, 38.74438], [-123.34971, 38.74414], [-123.34987, 38.74391], [-123.34991, 38.74379], [-123.34994, 38.74357], [-123.34999, 38.74332], [-123.35017, 38.74288], [-123.35041, 38.74316], [-123.35054, 38.74344], [-123.35061, 38.74351], [-123.35068, 38.74355], [-123.35115, 38.74372], [-123.35137, 38.74388], [-123.35177, 38.74439], [-123.35189, 38.7446], [-123.35193, 38.74474], [-123.3519, 38.74493], [-123.35179, 38.74512], [-123.35157, 38.74535], [-123.35157, 38.74579]]]} | Open Access 1 | 950 | Soda Springs | 25589 | 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 | 43.51 | Soda Springs | None 234 | |||
2833 | 2833 | 2832 | {"type": "Polygon", "coordinates": [[[-122.49452, 38.30454], [-122.49377, 38.3048], [-122.49335, 38.30407], [-122.49301, 38.3042], [-122.49262, 38.30344], [-122.49253, 38.30334], [-122.49242, 38.30326], [-122.49212, 38.30312], [-122.49197, 38.3031], [-122.49146, 38.30305], [-122.49093, 38.30295], [-122.49061, 38.30299], [-122.49053, 38.30297], [-122.4902, 38.30247], [-122.49055, 38.30267], [-122.49065, 38.30255], [-122.49072, 38.30255], [-122.49081, 38.3025], [-122.4909, 38.30271], [-122.49136, 38.30275], [-122.49157, 38.3027], [-122.49165, 38.30276], [-122.49171, 38.30277], [-122.49178, 38.30275], [-122.49209, 38.30285], [-122.49216, 38.30262], [-122.49206, 38.30244], [-122.49196, 38.30232], [-122.4919, 38.30221], [-122.49236, 38.30204], [-122.49326, 38.30174], [-122.49452, 38.30454]]]} | Open Access 1 | 22048 | Ernie Smith Community Park | 18699 | 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.405 | Ernie Smith Community Park | 0 | Local Park 2 | 4 | |
3106 | 3106 | 3105 | {"type": "Polygon", "coordinates": [[[-118.06276, 33.9794], [-118.06276, 33.97946], [-118.06244, 33.97978], [-118.0624, 33.97979], [-118.06229, 33.9799], [-118.06229, 33.97994], [-118.06156, 33.98068], [-118.06148, 33.98069], [-118.05955, 33.97935], [-118.06083, 33.97806], [-118.06276, 33.9794]]]} | Open Access 1 | 12858 | Sorensen Park | 32486 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 10.894 | Sorensen Park | 0 | Local Park 2 | 4 | |
3166 | 3166 | 3165 | {"type": "Polygon", "coordinates": [[[-122.64854, 38.45272], [-122.64847, 38.45267], [-122.64836, 38.45234], [-122.64825, 38.4523], [-122.64799, 38.45235], [-122.64736, 38.45268], [-122.64702, 38.45284], [-122.64642, 38.45304], [-122.64597, 38.4531], [-122.64534, 38.4531], [-122.64489, 38.45307], [-122.64496, 38.45367], [-122.64267, 38.45431], [-122.6435, 38.45134], [-122.64456, 38.45143], [-122.6482, 38.44901], [-122.64857, 38.45182], [-122.64859, 38.45262], [-122.64854, 38.45272]]]} | Open Access 1 | 21956 | Spring Lake Regional Park | 28940 | 2156 | Sonoma County Water Agency 90 | Special District 4 | Water District 13 | http://www.scwa.ca.gov/ | Special District 4 | 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 | 34.843 | Spring Lake RP | 1970 | Local Park 2 | 4 |
3251 | 3251 | 3250 | {"type": "Polygon", "coordinates": [[[-118.29179, 33.95328], [-118.2918, 33.95365], [-118.29183, 33.9538], [-118.29183, 33.9539], [-118.29183, 33.95646], [-118.29181, 33.95682], [-118.29178, 33.957], [-118.29171, 33.95701], [-118.29167, 33.95699], [-118.29163, 33.95683], [-118.29164, 33.95301], [-118.29179, 33.95328]]]} | Open Access 1 | 48155 | Vermont Median | 32692 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/vermont-median/ | Los Angeles 6 | 1.804 | Vermont Median | None 267 | ||
3601 | 3601 | 3600 | {"type": "MultiPolygon", "coordinates": [[[[-121.85226, 37.38638], [-121.8517, 37.38678], [-121.84999, 37.38813], [-121.84975, 37.38828], [-121.84945, 37.38842], [-121.84944, 37.38838], [-121.85006, 37.38798], [-121.85006, 37.38796], [-121.84987, 37.38783], [-121.85011, 37.38763], [-121.85023, 37.38778], [-121.85081, 37.38712], [-121.8512, 37.38685], [-121.85151, 37.38647], [-121.85171, 37.38635], [-121.85226, 37.38638]]], [[[-121.8717, 37.37057], [-121.87117, 37.37057], [-121.87095, 37.37043], [-121.87064, 37.37051], [-121.86992, 37.37065], [-121.86924, 37.37057], [-121.8692, 37.3705], [-121.86676, 37.37021], [-121.86657, 37.3702], [-121.86634, 37.37021], [-121.86595, 37.37028], [-121.86565, 37.37039], [-121.86544, 37.37049], [-121.86287, 37.37227], [-121.86274, 37.37237], [-121.86252, 37.3726], [-121.86243, 37.37272], [-121.86232, 37.37295], [-121.86225, 37.37319], [-121.8622, 37.37382], [-121.86203, 37.37448], [-121.86205, 37.37456], [-121.8621, 37.37463], [-121.86223, 37.3747], [-121.86221, 37.37506], [-121.86222, 37.37604], [-121.86227, 37.3762], [-121.86235, 37.37636], [-121.86312, 37.37716], [-121.86253, 37.3777], [-121.86248, 37.37771], [-121.86245, 37.37771], [-121.86128, 37.37648], [-121.86152, 37.37246], [-121.86147, 37.37241], [-121.86171, 37.37224], [-121.86176, 37.37229], [-121.86466, 37.37034], [-121.86466, 37.37032], [-121.8645, 37.37036], [-121.86575, 37.36952], [-121.86589, 37.36949], [-121.86599, 37.36949], [-121.86606, 37.3695], [-121.86615, 37.36954], [-121.86782, 37.3697], [-121.86789, 37.36974], [-121.86791, 37.36972], [-121.86851, 37.36982], [-121.86876, 37.36991], [-121.86895, 37.36995], [-121.86908, 37.37003], [-121.8692, 37.37008], [-121.8693, 37.37008], [-121.8694, 37.37001], [-121.87017, 37.37015], [-121.87028, 37.37018], [-121.87029, 37.37016], [-121.87117, 37.3698], [-121.8717, 37.37057]]]]} | Open Access 1 | 29198 | Penitencia Creek Park Chain | 23583 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 27.686 | Penitencia Creek Park Chain | None 301 | |||
3915 | 3915 | 3914 | {"type": "Polygon", "coordinates": [[[-123.05717, 38.323], [-123.05659, 38.32356], [-123.05543, 38.32636], [-123.05548, 38.31987], [-123.05563, 38.32022], [-123.05684, 38.32104], [-123.05715, 38.32178], [-123.05717, 38.323]]]} | Open Access 1 | 2027 | Westside Park | 27424 | 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 | 14.966 | Westside Park | 0 | Local Park 2 | 4 | |
3916 | 3916 | 3915 | {"type": "Polygon", "coordinates": [[[-122.51009, 38.36459], [-122.51009, 38.36459], [-122.5059, 38.36725], [-122.50542, 38.36613], [-122.50569, 38.36589], [-122.50569, 38.36502], [-122.50624, 38.36486], [-122.50574, 38.36403], [-122.50846, 38.36297], [-122.51009, 38.36459]]]} | Open Access 1 | 2030 | Bouverie Wildflower Preserve | 16304 | 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 | 24.503 | Bouverie Wildflower Preserve | 1970 | Local Conservation Area 4 | 2 | |
3956 | 3956 | 3955 | {"type": "Polygon", "coordinates": [[[-121.84533, 37.26464], [-121.84499, 37.26587], [-121.8333, 37.26597], [-121.8323, 37.26586], [-121.83182, 37.26587], [-121.83147, 37.26583], [-121.83147, 37.2658], [-121.8314, 37.26579], [-121.83136, 37.26576], [-121.83132, 37.26569], [-121.83129, 37.2657], [-121.83126, 37.26541], [-121.83111, 37.26459], [-121.83109, 37.26311], [-121.83104, 37.2625], [-121.83102, 37.2602], [-121.83107, 37.25982], [-121.83111, 37.25919], [-121.83617, 37.25916], [-121.83639, 37.25952], [-121.83773, 37.26158], [-121.8397, 37.26155], [-121.84206, 37.26469], [-121.84533, 37.26464]]]} | Open Access 1 | 46978 | Martial Cottle Park | 30611 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/martialcottle.aspx | Santa Clara 19 | 150.454 | Martial Cottle Park | 1963 | Local Park 2 | 4 |
3971 | 3971 | 3970 | {"type": "Polygon", "coordinates": [[[-121.68844, 36.99391], [-121.68834, 36.99433], [-121.68829, 36.99445], [-121.6881, 36.99477], [-121.68806, 36.99491], [-121.68805, 36.99504], [-121.68808, 36.99518], [-121.68824, 36.99549], [-121.68824, 36.99564], [-121.68821, 36.99576], [-121.68799, 36.99607], [-121.68785, 36.99624], [-121.68778, 36.99632], [-121.68747, 36.99652], [-121.68723, 36.99676], [-121.68792, 36.99542], [-121.68787, 36.99477], [-121.68815, 36.99388], [-121.68844, 36.99391]]]} | Open Access 1 | 38002 | Mount Madonna County Park | 29287 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/MtMadonna.aspx | Santa Clara 19 | 1.998 | Mount Madonna County Park | 0 | Local Park 2 | 4 |
3988 | 3988 | 3987 | {"type": "Polygon", "coordinates": [[[-122.68946, 38.01406], [-122.68941, 38.01415], [-122.68914, 38.01432], [-122.68905, 38.01435], [-122.68897, 38.01436], [-122.6889, 38.01434], [-122.68874, 38.01421], [-122.68929, 38.01378], [-122.6893, 38.01384], [-122.68938, 38.01388], [-122.68944, 38.01394], [-122.68946, 38.01399], [-122.68946, 38.01406]]]} | Open Access 1 | 38044 | Forest Knolls Park | 18995 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.526 | Forest Knolls Park | 0 | Local Park 2 | 4 | |
4164 | 4164 | 4163 | {"type": "Polygon", "coordinates": [[[-122.15709, 37.29222], [-122.15694, 37.29781], [-122.15191, 37.29801], [-122.13507, 37.29727], [-122.13513, 37.29368], [-122.12847, 37.29362], [-122.12844, 37.2829], [-122.12328, 37.28294], [-122.12327, 37.27902], [-122.13449, 37.27921], [-122.1343, 37.27166], [-122.13365, 37.26267], [-122.13387, 37.26277], [-122.13405, 37.26288], [-122.1342, 37.26301], [-122.13434, 37.26319], [-122.13528, 37.26524], [-122.13545, 37.26551], [-122.13559, 37.26569], [-122.13581, 37.26589], [-122.13604, 37.26604], [-122.13623, 37.26613], [-122.13713, 37.2665], [-122.13741, 37.26666], [-122.13763, 37.26681], [-122.13787, 37.26701], [-122.13807, 37.26723], [-122.13862, 37.26795], [-122.13881, 37.26817], [-122.13907, 37.26841], [-122.13937, 37.26865], [-122.13962, 37.26883], [-122.13992, 37.26901], [-122.14025, 37.26917], [-122.14054, 37.26929], [-122.14095, 37.26941], [-122.14327, 37.27001], [-122.14332, 37.27229], [-122.14345, 37.27662], [-122.14393, 37.2764], [-122.14422, 37.27631], [-122.1447, 37.27609], [-122.1449, 37.27609], [-122.14524, 37.27593], [-122.14558, 37.27594], [-122.14583, 37.27603], [-122.14601, 37.27617], [-122.14651, 37.27608], [-122.14667, 37.27679], [-122.1467, 37.27712], [-122.14681, 37.27748], [-122.14726, 37.27774], [-122.14746, 37.27806], [-122.14755, 37.27894], [-122.14934, 37.27891], [-122.1493, 37.27906], [-122.14923, 37.27923], [-122.14892, 37.27964], [-122.14725, 37.28033], [-122.14749, 37.28068], [-122.1475, 37.28076], [-122.14355, 37.28028], [-122.14373, 37.28652], [-122.15227, 37.2869], [-122.15248, 37.28838], [-122.1526, 37.28879], [-122.15254, 37.28883], [-122.15235, 37.28909], [-122.15337, 37.2902], [-122.15393, 37.29035], [-122.1559, 37.29165], [-122.15645, 37.29195], [-122.15709, 37.29222]]]} | Open Access 1 | 1787 | Upper Stevens Creek County Park | 29311 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/parkfinder/Pages/StevensCreek.aspx | Santa Clara 19 | 1279.701 | Upper Stevens Creek County Park | 1965 | Local Park 2 | 4 |
4255 | 4255 | 4254 | {"type": "Polygon", "coordinates": [[[-117.90325, 33.97998], [-117.90158, 33.98014], [-117.90166, 33.97993], [-117.90157, 33.97938], [-117.90144, 33.97842], [-117.90299, 33.97827], [-117.90325, 33.97998]]]} | Open Access 1 | 14365 | Carolyn Rosas Park | 32479 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 6.897 | Carolyn Rosas Park | 0 | Local Park 2 | 4 | |
4302 | 4302 | 4301 | {"type": "Polygon", "coordinates": [[[-118.1262, 34.18898], [-118.12621, 34.18904], [-118.12603, 34.18933], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898]]]} | Open Access 1 | 48153 | Ganesha Park | 32689 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.181 | Ganesha Park | 0 | Local Park 2 | 4 | |
4330 | 4330 | 4329 | {"type": "Polygon", "coordinates": [[[-118.20079, 34.47351], [-118.1974, 34.47353], [-118.19737, 34.47181], [-118.19937, 34.4718], [-118.19969, 34.47185], [-118.1999, 34.4719], [-118.20024, 34.47204], [-118.20055, 34.47224], [-118.20078, 34.47245], [-118.20079, 34.47351]]]} | Open Access 1 | 45479 | Acton Park | 32464 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Acton_Park | Los Angeles 6 | 13.925 | Acton Park | 0 | Local Park 2 | 4 |
4522 | 4522 | 4521 | {"type": "MultiPolygon", "coordinates": [[[[-121.65969, 37.166], [-121.65947, 37.16612], [-121.65923, 37.16572], [-121.65954, 37.16544], [-121.65969, 37.166]]], [[[-121.67578, 37.1769], [-121.67437, 37.17759], [-121.6743, 37.17804], [-121.66955, 37.17341], [-121.67012, 37.17305], [-121.67012, 37.17303], [-121.66909, 37.17242], [-121.666, 37.17121], [-121.66416, 37.17052], [-121.66356, 37.17158], [-121.6631, 37.17276], [-121.66129, 37.17269], [-121.65845, 37.17263], [-121.65783, 37.17259], [-121.65621, 37.17216], [-121.65615, 37.17223], [-121.64849, 37.16973], [-121.64946, 37.16814], [-121.6489, 37.16743], [-121.6478, 37.16643], [-121.64667, 37.16599], [-121.64647, 37.16628], [-121.64603, 37.16628], [-121.64596, 37.16626], [-121.64591, 37.16622], [-121.64586, 37.16614], [-121.64586, 37.16605], [-121.64577, 37.16602], [-121.64558, 37.16613], [-121.64552, 37.16613], [-121.64545, 37.16611], [-121.6454, 37.16607], [-121.64537, 37.16602], [-121.64531, 37.16583], [-121.64527, 37.16576], [-121.64519, 37.1657], [-121.645, 37.16563], [-121.64479, 37.16564], [-121.64411, 37.16547], [-121.64376, 37.16544], [-121.64284, 37.16546], [-121.64186, 37.16541], [-121.64127, 37.16553], [-121.64014, 37.16554], [-121.63957, 37.16579], [-121.63936, 37.16583], [-121.6391, 37.16591], [-121.63869, 37.16661], [-121.63819, 37.16645], [-121.63894, 37.16575], [-121.64073, 37.16495], [-121.6414, 37.16452], [-121.64192, 37.16443], [-121.64258, 37.16451], [-121.64329, 37.1645], [-121.64344, 37.16425], [-121.6435, 37.16425], [-121.64504, 37.16501], [-121.64516, 37.16484], [-121.64573, 37.16518], [-121.64572, 37.16523], [-121.64608, 37.16543], [-121.6461, 37.16542], [-121.64658, 37.16566], [-121.64666, 37.16572], [-121.64678, 37.16574], [-121.64831, 37.16652], [-121.64871, 37.16695], [-121.64954, 37.16802], [-121.6496, 37.16791], [-121.64882, 37.16689], [-121.64841, 37.16644], [-121.64689, 37.16566], [-121.6469, 37.16558], [-121.64701, 37.1654], [-121.6471, 37.16538], [-121.6494, 37.1666], [-121.64956, 37.16665], [-121.64973, 37.16669], [-121.64999, 37.16669], [-121.65024, 37.16663], [-121.65046, 37.16652], [-121.65256, 37.16316], [-121.65598, 37.16434], [-121.65635, 37.16425], [-121.65801, 37.16429], [-121.65873, 37.16453], [-121.65949, 37.1649], [-121.65976, 37.16499], [-121.66182, 37.1634], [-121.66192, 37.16344], [-121.66196, 37.16346], [-121.65897, 37.16576], [-121.6593, 37.16606], [-121.65981, 37.16687], [-121.6599, 37.16683], [-121.65952, 37.16619], [-121.6598, 37.16604], [-121.65963, 37.16537], [-121.66215, 37.16344], [-121.66267, 37.16302], [-121.66377, 37.16397], [-121.66413, 37.16431], [-121.66449, 37.16469], [-121.66743, 37.16835], [-121.66732, 37.16842], [-121.66745, 37.1686], [-121.66765, 37.16863], [-121.66807, 37.16904], [-121.66823, 37.16894], [-121.66848, 37.16918], [-121.6691, 37.16985], [-121.67038, 37.17111], [-121.67103, 37.1717], [-121.67327, 37.1736], [-121.67514, 37.17534], [-121.6753, 37.17551], [-121.67554, 37.17583], [-121.67569, 37.17618], [-121.67578, 37.17654], [-121.67578, 37.1769]], [[-121.65269, 37.16815], [-121.65244, 37.16815], [-121.65235, 37.1684], [-121.65236, 37.16841], [-121.6526, 37.16841], [-121.65252, 37.16867], [-121.65254, 37.16882], [-121.65335, 37.16857], [-121.65406, 37.16805], [-121.65335, 37.16716], [-121.65291, 37.16777], [-121.65269, 37.16815]]], [[[-121.73381, 37.2192], [-121.73317, 37.2187], [-121.73202, 37.21767], [-121.73108, 37.21694], [-121.73059, 37.21655], [-121.73, 37.21604], [-121.72793, 37.21401], [-121.72657, 37.21236], [-121.72506, 37.20979], [-121.72545, 37.20963], [-121.72504, 37.2089], [-121.72456, 37.20902], [-121.72441, 37.20903], [-121.72428, 37.209], [-121.72252, 37.20824], [-121.72199, 37.208], [-121.72146, 37.20773], [-121.721, 37.20747], [-121.71625, 37.20463], [-121.71634, 37.2042], [-121.71604, 37.20374], [-121.71649, 37.20167], [-121.7165, 37.20056], [-121.71625, 37.19987], [-121.7158, 37.19931], [-121.71425, 37.19825], [-121.71386, 37.19785], [-121.71305, 37.19739], [-121.71175, 37.19638], [-121.71111, 37.19574], [-121.7107, 37.19542], [-121.71033, 37.195], [-121.70978, 37.19453], [-121.70944, 37.19431], [-121.70904, 37.19413], [-121.70883, 37.19397], [-121.70851, 37.19365], [-121.70799, 37.19277], [-121.70733, 37.19216], [-121.70679, 37.19159], [-121.70646, 37.19133], [-121.70593, 37.19081], [-121.70542, 37.19047], [-121.70495, 37.19027], [-121.70424, 37.19013], [-121.70319, 37.18987], [-121.70219, 37.1895], [-121.7002, 37.18913], [-121.70008, 37.18887], [-121.69835, 37.18817], [-121.69654, 37.18726], [-121.69553, 37.18791], [-121.69536, 37.1878], [-121.69537, 37.18778], [-121.69515, 37.18764], [-121.69498, 37.18763], [-121.69486, 37.18756], [-121.69439, 37.18738], [-121.69102, 37.18662], [-121.6897, 37.18748], [-121.6888, 37.18698], [-121.68807, 37.18637], [-121.68655, 37.18524], [-121.68403, 37.18228], [-121.68352, 37.18194], [-121.68166, 37.1795], [-121.68118, 37.17822], [-121.68108, 37.17663], [-121.68109, 37.17654], [-121.68114, 37.17635], [-121.68128, 37.17609], [-121.68142, 37.17594], [-121.68191, 37.17556], [-121.68162, 37.17526], [-121.6809, 37.17568], [-121.6807, 37.17578], [-121.68037, 37.17587], [-121.68002, 37.1759], [-121.67757, 37.1756], [-121.67712, 37.17548], [-121.6769, 37.17539], [-121.6765, 37.17518], [-121.67632, 37.17505], [-121.67316, 37.17241], [-121.6708, 37.17028], [-121.6693, 37.16865], [-121.66858, 37.16771], [-121.66798, 37.16703], [-121.66824, 37.16684], [-121.66933, 37.16781], [-121.67049, 37.16863], [-121.67155, 37.16906], [-121.67321, 37.16944], [-121.67414, 37.16992], [-121.67532, 37.17021], [-121.67687, 37.17008], [-121.67905, 37.17014], [-121.68073, 37.17044], [-121.68284, 37.17142], [-121.68393, 37.17212], [-121.6852, 37.17316], [-121.68448, 37.17363], [-121.68448, 37.17364], [-121.68691, 37.17538], [-121.68743, 37.17572], [-121.68797, 37.17604], [-121.68853, 37.17633], [-121.68905, 37.17658], [-121.68964, 37.17683], [-121.69025, 37.17706], [-121.69087, 37.17726], [-121.6915, 37.17744], [-121.6906, 37.17802], [-121.6906, 37.17804], [-121.6928, 37.17774], [-121.69364, 37.17817], [-121.6965, 37.17863], [-121.69779, 37.18], [-121.69763, 37.18011], [-121.69762, 37.18013], [-121.7006, 37.18224], [-121.70248, 37.18103], [-121.70263, 37.18118], [-121.70095, 37.18228], [-121.70368, 37.18495], [-121.70316, 37.18549], [-121.703, 37.1854], [-121.70283, 37.1855], [-121.70319, 37.1863], [-121.70553, 37.18798], [-121.70583, 37.18919], [-121.70671, 37.18995], [-121.70638, 37.19006], [-121.70664, 37.19029], [-121.70765, 37.19096], [-121.70791, 37.19078], [-121.70862, 37.19111], [-121.70879, 37.19122], [-121.70907, 37.19146], [-121.70902, 37.19151], [-121.70976, 37.19241], [-121.71062, 37.19185], [-121.71447, 37.19556], [-121.71807, 37.19757], [-121.71922, 37.19723], [-121.72041, 37.19835], [-121.72008, 37.19856], [-121.72019, 37.19899], [-121.72013, 37.19904], [-121.72044, 37.19972], [-121.72034, 37.20098], [-121.72029, 37.20138], [-121.71985, 37.20161], [-121.71975, 37.20152], [-121.71952, 37.20168], [-121.71938, 37.20227], [-121.7194, 37.20228], [-121.7195, 37.20221], [-121.71935, 37.20273], [-121.71958, 37.20336], [-121.71973, 37.20328], [-121.72044, 37.20398], [-121.72163, 37.20418], [-121.72294, 37.20549], [-121.72325, 37.20639], [-121.72416, 37.20664], [-121.72468, 37.20682], [-121.72554, 37.20628], [-121.72654, 37.20726], [-121.72756, 37.21027], [-121.72854, 37.21223], [-121.72976, 37.21346], [-121.73141, 37.21234], [-121.73174, 37.2118], [-121.73186, 37.21165], [-121.73201, 37.21151], [-121.73217, 37.21139], [-121.73236, 37.21129], [-121.73256, 37.2112], [-121.73278, 37.21114], [-121.733, 37.21111], [-121.73322, 37.21109], [-121.73331, 37.21103], [-121.73354, 37.21125], [-121.73076, 37.21315], [-121.73076, 37.21317], [-121.7319, 37.21423], [-121.73274, 37.21428], [-121.73507, 37.2165], [-121.73572, 37.21674], [-121.73639, 37.21708], [-121.73655, 37.21697], [-121.73664, 37.21705], [-121.73648, 37.21717], [-121.73648, 37.21718], [-121.73705, 37.21727], [-121.7373, 37.21723], [-121.73794, 37.21721], [-121.7391, 37.21727], [-121.73922, 37.21731], [-121.73931, 37.21739], [-121.73933, 37.21739], [-121.73985, 37.21784], [-121.74035, 37.21751], [-121.74577, 37.22235], [-121.74328, 37.22324], [-121.74127, 37.22159], [-121.73868, 37.22296], [-121.73656, 37.22132], [-121.73449, 37.21967], [-121.73381, 37.2192]]], [[[-121.76079, 37.2328], [-121.76048, 37.23316], [-121.76029, 37.23332], [-121.76025, 37.23338], [-121.76026, 37.23346], [-121.76062, 37.23404], [-121.75796, 37.23277], [-121.75615, 37.23223], [-121.75569, 37.23329], [-121.75662, 37.23398], [-121.75703, 37.23413], [-121.75775, 37.23428], [-121.7584, 37.23479], [-121.75907, 37.23516], [-121.75949, 37.23526], [-121.75905, 37.23575], [-121.75109, 37.23121], [-121.75032, 37.23072], [-121.75002, 37.2305], [-121.7499, 37.2304], [-121.74862, 37.22912], [-121.74856, 37.22902], [-121.74852, 37.22891], [-121.74852, 37.22881], [-121.74855, 37.22871], [-121.7486, 37.22862], [-121.7489, 37.22827], [-121.74936, 37.22783], [-121.7497, 37.22756], [-121.74996, 37.22738], [-121.7506, 37.22699], [-121.75055, 37.22693], [-121.751, 37.22667], [-121.75182, 37.22702], [-121.75266, 37.22749], [-121.7535, 37.22788], [-121.75572, 37.22901], [-121.75639, 37.23002], [-121.75649, 37.23009], [-121.75688, 37.2296], [-121.75729, 37.22981], [-121.75693, 37.23026], [-121.75693, 37.23027], [-121.75934, 37.23192], [-121.76079, 37.2328]]], [[[-121.76586, 37.23951], [-121.76547, 37.23927], [-121.7649, 37.23895], [-121.76504, 37.23818], [-121.76498, 37.23727], [-121.76495, 37.23702], [-121.7649, 37.23678], [-121.76476, 37.23643], [-121.76465, 37.23622], [-121.76444, 37.23598], [-121.76415, 37.2357], [-121.76398, 37.23556], [-121.76368, 37.23538], [-121.76345, 37.2353], [-121.7631, 37.23522], [-121.76264, 37.2352], [-121.76209, 37.2351], [-121.76163, 37.235], [-121.76095, 37.2348], [-121.76087, 37.23441], [-121.76114, 37.23452], [-121.76151, 37.23463], [-121.76176, 37.23467], [-121.76214, 37.23468], [-121.76238, 37.23464], [-121.76253, 37.23459], [-121.76252, 37.23456], [-121.76261, 37.23467], [-121.76273, 37.23475], [-121.76474, 37.23558], [-121.76484, 37.23564], [-121.76507, 37.23582], [-121.76514, 37.23591], [-121.76522, 37.23632], [-121.76565, 37.23901], [-121.76586, 37.23951]]], [[[-121.77266, 37.24655], [-121.77267, 37.24709], [-121.77264, 37.24735], [-121.77255, 37.24768], [-121.7724, 37.24801], [-121.77217, 37.24837], [-121.77206, 37.2485], [-121.77059, 37.25007], [-121.77052, 37.2501], [-121.77044, 37.25009], [-121.77004, 37.24983], [-121.76944, 37.24948], [-121.76919, 37.24926], [-121.76898, 37.24901], [-121.76885, 37.24878], [-121.7687, 37.24844], [-121.76858, 37.24819], [-121.76851, 37.24807], [-121.76833, 37.24784], [-121.76688, 37.24632], [-121.76667, 37.24607], [-121.76661, 37.24596], [-121.76654, 37.24581], [-121.76645, 37.24556], [-121.7659, 37.24315], [-121.76583, 37.24294], [-121.76568, 37.24264], [-121.76549, 37.24241], [-121.76527, 37.24218], [-121.76404, 37.24114], [-121.76392, 37.24101], [-121.76351, 37.24067], [-121.76327, 37.24045], [-121.76276, 37.23975], [-121.76348, 37.23973], [-121.76452, 37.2408], [-121.76501, 37.24122], [-121.76634, 37.24203], [-121.76809, 37.24246], [-121.76886, 37.24259], [-121.76883, 37.24282], [-121.76881, 37.24305], [-121.76883, 37.24343], [-121.76889, 37.24372], [-121.76897, 37.24399], [-121.76908, 37.24425], [-121.76921, 37.2445], [-121.76938, 37.24474], [-121.76957, 37.24497], [-121.76978, 37.24519], [-121.77001, 37.24539], [-121.77029, 37.24559], [-121.7706, 37.24577], [-121.77092, 37.24593], [-121.77126, 37.24606], [-121.77266, 37.24655]]], [[[-121.79233, 37.25703], [-121.79167, 37.25701], [-121.79166, 37.25693], [-121.79145, 37.25693], [-121.79144, 37.25701], [-121.79087, 37.257], [-121.79086, 37.25698], [-121.78957, 37.25697], [-121.78961, 37.25695], [-121.78961, 37.25693], [-121.79018, 37.25678], [-121.79019, 37.25676], [-121.79015, 37.25673], [-121.79019, 37.25672], [-121.79035, 37.25676], [-121.79048, 37.25676], [-121.79062, 37.25675], [-121.7907, 37.25672], [-121.79064, 37.2566], [-121.78988, 37.25618], [-121.78954, 37.25577], [-121.78902, 37.25523], [-121.78884, 37.2549], [-121.78904, 37.2547], [-121.78831, 37.25364], [-121.78775, 37.25303], [-121.78724, 37.25266], [-121.78603, 37.25194], [-121.78407, 37.2511], [-121.78399, 37.25118], [-121.78352, 37.25109], [-121.78321, 37.25107], [-121.78247, 37.25108], [-121.78167, 37.25126], [-121.78099, 37.25129], [-121.78096, 37.25138], [-121.78098, 37.2515], [-121.78092, 37.25154], [-121.78076, 37.25146], [-121.78023, 37.25199], [-121.78002, 37.25222], [-121.77997, 37.25231], [-121.77993, 37.2524], [-121.77991, 37.25367], [-121.77986, 37.25382], [-121.77952, 37.25427], [-121.77947, 37.25432], [-121.77924, 37.25444], [-121.77914, 37.25447], [-121.77904, 37.25447], [-121.77887, 37.25443], [-121.77851, 37.25423], [-121.77837, 37.25411], [-121.77822, 37.2538], [-121.77793, 37.25333], [-121.77774, 37.25309], [-121.77772, 37.25302], [-121.77775, 37.25299], [-121.77764, 37.25273], [-121.77746, 37.25242], [-121.77734, 37.25232], [-121.77713, 37.25219], [-121.777, 37.25198], [-121.77623, 37.25108], [-121.77603, 37.25065], [-121.7759, 37.25049], [-121.77487, 37.2515], [-121.77562, 37.25215], [-121.77487, 37.25224], [-121.77393, 37.25228], [-121.77321, 37.2518], [-121.77252, 37.25106], [-121.77194, 37.25095], [-121.77097, 37.25036], [-121.77092, 37.2503], [-121.77092, 37.25021], [-121.77096, 37.25015], [-121.77226, 37.24876], [-121.77229, 37.24874], [-121.77234, 37.24875], [-121.77354, 37.24946], [-121.7752, 37.25001], [-121.77583, 37.25036], [-121.77594, 37.25045], [-121.77597, 37.25051], [-121.77632, 37.25115], [-121.77715, 37.25213], [-121.77735, 37.25228], [-121.778, 37.25263], [-121.77969, 37.25082], [-121.77973, 37.25084], [-121.77939, 37.25123], [-121.7792, 37.25141], [-121.77863, 37.25202], [-121.77806, 37.25265], [-121.77881, 37.25311], [-121.78017, 37.25165], [-121.78048, 37.25129], [-121.78308, 37.25096], [-121.78406, 37.2511], [-121.78423, 37.25092], [-121.78913, 37.25357], [-121.7898, 37.25401], [-121.78905, 37.2547], [-121.78928, 37.25513], [-121.78947, 37.25541], [-121.79071, 37.25634], [-121.79091, 37.25629], [-121.79105, 37.25628], [-121.79116, 37.25635], [-121.79123, 37.25641], [-121.79133, 37.25659], [-121.79158, 37.2566], [-121.79178, 37.25665], [-121.79173, 37.25681], [-121.79202, 37.25689], [-121.79233, 37.25703]]], [[[-121.80691, 37.28081], [-121.80667, 37.28108], [-121.80662, 37.28142], [-121.80646, 37.28138], [-121.80533, 37.28092], [-121.80514, 37.28083], [-121.8049, 37.28071], [-121.80487, 37.27996], [-121.80331, 37.27869], [-121.80276, 37.27914], [-121.80233, 37.27889], [-121.80152, 37.27823], [-121.80031, 37.27769], [-121.80002, 37.27754], [-121.80024, 37.27708], [-121.79744, 37.27504], [-121.79679, 37.27454], [-121.79656, 37.27416], [-121.79692, 37.27265], [-121.79651, 37.26969], [-121.79518, 37.26826], [-121.79545, 37.26764], [-121.79548, 37.26615], [-121.79435, 37.26522], [-121.7921, 37.26456], [-121.78943, 37.26238], [-121.7897, 37.26196], [-121.78993, 37.26165], [-121.79031, 37.261], [-121.79019, 37.2601], [-121.7901, 37.25976], [-121.78983, 37.25948], [-121.78978, 37.25936], [-121.79026, 37.25911], [-121.7902, 37.25886], [-121.79018, 37.25863], [-121.78974, 37.25731], [-121.79291, 37.25736], [-121.793, 37.25737], [-121.79305, 37.2574], [-121.79321, 37.25762], [-121.79368, 37.25832], [-121.79379, 37.25853], [-121.79405, 37.25893], [-121.79419, 37.25912], [-121.79448, 37.25972], [-121.7948, 37.26189], [-121.79494, 37.26257], [-121.79503, 37.26315], [-121.79449, 37.26319], [-121.7931, 37.26341], [-121.79169, 37.2636], [-121.79168, 37.26361], [-121.79239, 37.26413], [-121.79424, 37.26476], [-121.79521, 37.26427], [-121.79529, 37.26475], [-121.79532, 37.26486], [-121.79538, 37.26496], [-121.79555, 37.26515], [-121.79598, 37.26553], [-121.79615, 37.26574], [-121.79622, 37.26587], [-121.79634, 37.2662], [-121.79639, 37.26646], [-121.79642, 37.26677], [-121.7964, 37.26721], [-121.79625, 37.26792], [-121.79625, 37.26801], [-121.79628, 37.26816], [-121.79646, 37.26846], [-121.79731, 37.26962], [-121.79748, 37.26995], [-121.79759, 37.27034], [-121.79773, 37.27097], [-121.79795, 37.27298], [-121.79802, 37.27343], [-121.79808, 37.27358], [-121.79818, 37.27376], [-121.79876, 37.2747], [-121.79896, 37.27506], [-121.79905, 37.27517], [-121.79917, 37.27525], [-121.79931, 37.27532], [-121.79949, 37.27537], [-121.80029, 37.27548], [-121.80228, 37.27584], [-121.80269, 37.27594], [-121.80293, 37.27604], [-121.80326, 37.27619], [-121.80428, 37.27676], [-121.80486, 37.277], [-121.805, 37.27727], [-121.80543, 37.27796], [-121.8057, 37.27832], [-121.80596, 37.27846], [-121.80623, 37.27886], [-121.80692, 37.28017], [-121.80691, 37.28081]], [[-121.79057, 37.259], [-121.79098, 37.25886], [-121.79098, 37.25884], [-121.79078, 37.25865], [-121.79035, 37.25894], [-121.79027, 37.25911], [-121.79057, 37.259]]]]} | Open Access 1 | 14720 | Coyote Creek Parkway | 29183 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/parkfinder/Pages/CoyoteCreekParkway.aspx | Santa Clara 19 | 1714.076 | Coyote Creek Parkway | 0 | Local Recreation Area 3 | 4 |
4851 | 4851 | 4850 | {"type": "Polygon", "coordinates": [[[-122.74476, 38.48964], [-122.7447, 38.49267], [-122.74306, 38.49272], [-122.74163, 38.49168], [-122.74016, 38.49056], [-122.74476, 38.48964]]]} | Open Access 1 | 1772 | Unity | 26671 | 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 | 21.092 | Unity | 1996 | None 407 | ||
5080 | 5080 | 5079 | {"type": "MultiPolygon", "coordinates": [[[[-122.39586, 37.67376], [-122.39555, 37.67424], [-122.39486, 37.67389], [-122.39464, 37.67387], [-122.39468, 37.67361], [-122.39586, 37.67376]]], [[[-122.39617, 37.67549], [-122.39587, 37.67586], [-122.39486, 37.67549], [-122.39519, 37.67522], [-122.39617, 37.67549]]], [[[-122.40242, 37.67556], [-122.40236, 37.67654], [-122.40242, 37.67688], [-122.40169, 37.67703], [-122.40187, 37.67671], [-122.4018, 37.6765], [-122.4012, 37.67641], [-122.40214, 37.67556], [-122.40242, 37.67556]]], [[[-122.40496, 37.67718], [-122.40467, 37.6774], [-122.40379, 37.6776], [-122.40352, 37.67727], [-122.40485, 37.67701], [-122.40496, 37.67718]]]]} | Open Access 1 | 35105 | San Bruno Mountain State and County Park | 29293 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | https://parks.smcgov.org/san-bruno-mountain-state-county-park | San Mateo 15 | 5.359 | San Bruno Mtn. State and County Park | 2000 | 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]);