units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
172 rows where DES_TP = 4 and MNG_AG_TYP = 4 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AGENCY 14
- Midpeninsula Regional Open Space District 47
- East Bay Regional Park District 35
- Marin County Open Space District 31
- Santa Clara Valley Open Space Authority 19
- Monterey Peninsula Regional Park District 3
- Riverside County Regional Park and Open Space District 3
- Sonoma County Agricultural Preservation and Open Space District 3
- Livermore Area Recreation and Park District 3
- Napa County Regional Park and Open Space District 2
- Greater Vallejo Recreation and Park District 2
- Sunrise Recreation and Park District 1
- Carmichael Recreation and Park District 1
- Arcade Creek Recreation and Park District 1
- Orangevale Recreation and Park District 1
ACCESS_TYP 3
- Open Access 94
- No Public Access 47
- Restricted Access 11
MNG_AG_TYP 1
- Recreation/Parks District · 152 ✖
DES_TP 1
- Local Conservation Area · 152 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7208 | 7208 | 7207 | {"type": "Polygon", "coordinates": [[[-117.10388, 33.94678], [-117.10311, 33.9613], [-117.10328, 33.96486], [-117.09472, 33.96481], [-117.09502, 33.97011], [-117.09504, 33.97163], [-117.09403, 33.97124], [-117.09293, 33.97167], [-117.09235, 33.97324], [-117.09284, 33.97395], [-117.09131, 33.97423], [-117.09078, 33.97429], [-117.08999, 33.9743], [-117.08919, 33.97422], [-117.08867, 33.97412], [-117.08842, 33.97405], [-117.08817, 33.97398], [-117.08778, 33.97384], [-117.0875, 33.97368], [-117.08738, 33.97359], [-117.08683, 33.97309], [-117.08655, 33.97287], [-117.08636, 33.97278], [-117.08619, 33.97272], [-117.08598, 33.97267], [-117.08584, 33.9726], [-117.0857, 33.97255], [-117.08546, 33.97252], [-117.08522, 33.97254], [-117.08141, 33.9704], [-117.0813, 33.97052], [-117.07767, 33.96848], [-117.07698, 33.96806], [-117.07633, 33.9676], [-117.07622, 33.96769], [-117.07616, 33.96765], [-117.07555, 33.96719], [-117.0692, 33.96178], [-117.06634, 33.95929], [-117.06639, 33.95924], [-117.06504, 33.95806], [-117.06498, 33.9581], [-117.05297, 33.94762], [-117.05237, 33.94712], [-117.05212, 33.94737], [-117.05116, 33.94668], [-117.05045, 33.94621], [-117.04969, 33.94575], [-117.04886, 33.9453], [-117.048, 33.94489], [-117.04708, 33.94451], [-117.04621, 33.94419], [-117.04528, 33.9439], [-117.04544, 33.94348], [-117.04373, 33.94302], [-117.04357, 33.94344], [-117.04236, 33.94316], [-117.04139, 33.94298], [-117.04021, 33.94283], [-117.03937, 33.94277], [-117.03882, 33.94277], [-117.03819, 33.9428], [-117.03417, 33.94319], [-117.03415, 33.93543], [-117.03667, 33.93645], [-117.03667, 33.9365], [-117.03716, 33.93672], [-117.03739, 33.93686], [-117.03761, 33.93701], [-117.03802, 33.93735], [-117.03904, 33.93845], [-117.03922, 33.93862], [-117.0396, 33.93895], [-117.04001, 33.93925], [-117.04023, 33.93939], [-117.04091, 33.93977], [-117.04165, 33.94008], [-117.04528, 33.94134], [-117.05005, 33.94303], [-117.05085, 33.94334], [-117.05162, 33.94369], [-117.05238, 33.94406], [-117.05432, 33.94511], [-117.0581, 33.94722], [-117.05866, 33.94746], [-117.05916, 33.94764], [-117.05965, 33.94777], [-117.06022, 33.94788], [-117.06069, 33.94794], [-117.06124, 33.94797], [-117.06171, 33.94797], [-117.06222, 33.94794], [-117.06276, 33.94786], [-117.0688, 33.94677], [-117.06881, 33.9469], [-117.06967, 33.9469], [-117.08583, 33.94427], [-117.08584, 33.94339], [-117.08648, 33.94321], [-117.08707, 33.94299], [-117.09015, 33.94194], [-117.0904, 33.94184], [-117.09064, 33.94171], [-117.09217, 33.94072], [-117.09288, 33.94034], [-117.09363, 33.94003], [-117.09416, 33.93986], [-117.09476, 33.93969], [-117.09465, 33.9429], [-117.10384, 33.9428], [-117.10373, 33.94677], [-117.10388, 33.94678]]]} | Open Access 1 | 48560 | Norton Younglove Reserve | 33274 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 2643.455 | Norton Younglove Reserve | 0 | Local Conservation Area 4 | 2 | |
7802 | 7802 | 7801 | {"type": "Polygon", "coordinates": [[[-122.23302, 38.23444], [-122.22473, 38.23495], [-122.22472, 38.2385], [-122.22301, 38.23789], [-122.22249, 38.23785], [-122.22244, 38.23808], [-122.22103, 38.23794], [-122.22104, 38.23774], [-122.21889, 38.23751], [-122.21854, 38.23663], [-122.21725, 38.23663], [-122.21747, 38.23776], [-122.21783, 38.23793], [-122.2181, 38.23813], [-122.21801, 38.23828], [-122.21814, 38.23842], [-122.218, 38.23846], [-122.21825, 38.23871], [-122.21804, 38.23877], [-122.21718, 38.23894], [-122.21686, 38.2391], [-122.21605, 38.23966], [-122.21593, 38.23976], [-122.21586, 38.23986], [-122.21527, 38.23979], [-122.21505, 38.24], [-122.21506, 38.24011], [-122.21554, 38.24033], [-122.21525, 38.24068], [-122.21519, 38.24085], [-122.21532, 38.24101], [-122.21567, 38.2411], [-122.21583, 38.24122], [-122.216, 38.24152], [-122.21604, 38.24172], [-122.21582, 38.2421], [-122.21638, 38.24252], [-122.21645, 38.24266], [-122.21683, 38.24294], [-122.21684, 38.24323], [-122.21911, 38.24384], [-122.22215, 38.24284], [-122.22559, 38.24302], [-122.22664, 38.24305], [-122.22869, 38.24297], [-122.22911, 38.2429], [-122.22996, 38.24319], [-122.23067, 38.24333], [-122.23094, 38.24343], [-122.23094, 38.2436], [-122.23062, 38.24461], [-122.23024, 38.24536], [-122.22976, 38.24612], [-122.22941, 38.24631], [-122.22467, 38.24747], [-122.22482, 38.24825], [-122.22452, 38.24835], [-122.22408, 38.24925], [-122.22489, 38.25021], [-122.22476, 38.25048], [-122.22304, 38.2527], [-122.22038, 38.25284], [-122.22022, 38.25141], [-122.21965, 38.25116], [-122.21813, 38.25139], [-122.21792, 38.2521], [-122.21831, 38.25257], [-122.21749, 38.25377], [-122.21768, 38.25501], [-122.21668, 38.25515], [-122.21607, 38.25493], [-122.21522, 38.25486], [-122.21355, 38.25427], [-122.21354, 38.25119], [-122.20989, 38.25119], [-122.2099, 38.24916], [-122.20859, 38.24823], [-122.20828, 38.2481], [-122.20819, 38.24804], [-122.20813, 38.24796], [-122.20808, 38.24787], [-122.20807, 38.24777], [-122.20758, 38.24574], [-122.20472, 38.2453], [-122.20419, 38.24387], [-122.2098, 38.24385], [-122.20966, 38.23501], [-122.21005, 38.23498], [-122.21061, 38.23476], [-122.21084, 38.23471], [-122.21144, 38.23474], [-122.21189, 38.2347], [-122.21246, 38.23484], [-122.21259, 38.23497], [-122.21274, 38.23506], [-122.21291, 38.23507], [-122.21303, 38.23505], [-122.21311, 38.23507], [-122.21319, 38.23512], [-122.21332, 38.23515], [-122.2138, 38.23538], [-122.21407, 38.23549], [-122.21421, 38.23546], [-122.21436, 38.23538], [-122.21462, 38.23528], [-122.21462, 38.23542], [-122.21514, 38.23578], [-122.21689, 38.23472], [-122.21689, 38.23454], [-122.21717, 38.23419], [-122.21735, 38.23392], [-122.21759, 38.23368], [-122.21796, 38.23346], [-122.21818, 38.23329], [-122.21844, 38.2332], [-122.21881, 38.23316], [-122.21896, 38.23312], [-122.21943, 38.23305], [-122.21974, 38.23293], [-122.21995, 38.23272], [-122.22006, 38.23264], [-122.2203, 38.23222], [-122.2204, 38.23197], [-122.22045, 38.2319], [-122.22072, 38.2316], [-122.22091, 38.2315], [-122.22109, 38.23133], [-122.22123, 38.2309], [-122.22133, 38.23029], [-122.22137, 38.23026], [-122.22632, 38.23028], [-122.22559, 38.23174], [-122.22506, 38.2333], [-122.22763, 38.234], [-122.22771, 38.23329], [-122.22877, 38.23166], [-122.23193, 38.23165], [-122.23302, 38.23444]]]} | No Public Access 3 | 47675 | Suscol Headwaters Preserve | 31417 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 712.089 | Suscol Headwaters Preserve | 0 | Local Conservation Area 4 | 2 | |
7826 | 7826 | 7825 | {"type": "MultiPolygon", "coordinates": [[[[-122.17414, 37.35839], [-122.17377, 37.35959], [-122.17318, 37.35959], [-122.17282, 37.35966], [-122.17244, 37.35966], [-122.17177, 37.35953], [-122.17142, 37.35942], [-122.17098, 37.35936], [-122.17043, 37.35937], [-122.17018, 37.35931], [-122.16985, 37.35928], [-122.16942, 37.3593], [-122.16893, 37.35925], [-122.1685, 37.35908], [-122.16818, 37.35901], [-122.16761, 37.35885], [-122.16904, 37.35688], [-122.16666, 37.35557], [-122.16533, 37.35439], [-122.16529, 37.35349], [-122.17225, 37.35279], [-122.17289, 37.35278], [-122.17286, 37.35291], [-122.1729, 37.35304], [-122.17298, 37.35314], [-122.17344, 37.35354], [-122.17356, 37.35368], [-122.17363, 37.35379], [-122.17373, 37.35409], [-122.17373, 37.35424], [-122.17372, 37.35435], [-122.17365, 37.35444], [-122.17322, 37.3547], [-122.17298, 37.35491], [-122.17267, 37.35504], [-122.17235, 37.35523], [-122.17228, 37.35534], [-122.17227, 37.35552], [-122.17216, 37.35582], [-122.17215, 37.35594], [-122.17216, 37.35598], [-122.17222, 37.35605], [-122.17237, 37.35614], [-122.17255, 37.35616], [-122.17297, 37.35613], [-122.17303, 37.35614], [-122.17309, 37.35617], [-122.17312, 37.35619], [-122.17315, 37.35627], [-122.17312, 37.35664], [-122.17316, 37.35677], [-122.17325, 37.35683], [-122.17334, 37.35687], [-122.17375, 37.35698], [-122.17391, 37.35708], [-122.17399, 37.35715], [-122.17404, 37.35724], [-122.17407, 37.35732], [-122.17408, 37.35737], [-122.17406, 37.35745], [-122.17402, 37.35751], [-122.17387, 37.3576], [-122.17373, 37.35772], [-122.17368, 37.35786], [-122.17368, 37.35802], [-122.17371, 37.35812], [-122.17381, 37.35822], [-122.17394, 37.3583], [-122.17414, 37.35839]]], [[[-122.17397, 37.33315], [-122.17355, 37.33447], [-122.17235, 37.33447], [-122.17235, 37.33809], [-122.16717, 37.33822], [-122.16716, 37.33438], [-122.1683, 37.33438], [-122.16832, 37.33421], [-122.17235, 37.33446], [-122.17235, 37.33079], [-122.17248, 37.33092], [-122.17263, 37.33115], [-122.17315, 37.33166], [-122.17354, 37.33188], [-122.17339, 37.33235], [-122.17395, 37.33315], [-122.17397, 37.33315]]]]} | Open Access 1 | 47697 | Foothills Open Space Preserve | 31433 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 153.066 | Foothills OSP | 0 | Local Conservation Area 4 | 2 | |
8898 | 8898 | 8897 | {"type": "Polygon", "coordinates": [[[-122.52547, 37.9169], [-122.52399, 37.91714], [-122.52152, 37.91744], [-122.51978, 37.91764], [-122.51843, 37.91775], [-122.51683, 37.9144], [-122.5159, 37.91255], [-122.51541, 37.91147], [-122.51529, 37.91104], [-122.51738, 37.91101], [-122.51611, 37.91171], [-122.51629, 37.91205], [-122.51625, 37.91235], [-122.51631, 37.91252], [-122.51667, 37.91262], [-122.51683, 37.91279], [-122.51665, 37.91315], [-122.51681, 37.91348], [-122.51714, 37.91371], [-122.51765, 37.91363], [-122.5177, 37.91378], [-122.51736, 37.91408], [-122.5174, 37.91475], [-122.51757, 37.91517], [-122.5178, 37.91532], [-122.51803, 37.91572], [-122.51803, 37.91604], [-122.51973, 37.91502], [-122.52, 37.91497], [-122.52007, 37.91502], [-122.52017, 37.91503], [-122.52019, 37.91506], [-122.52011, 37.91508], [-122.52019, 37.91545], [-122.52049, 37.91553], [-122.52067, 37.91612], [-122.52094, 37.91597], [-122.52143, 37.91605], [-122.52183, 37.91591], [-122.5219, 37.9156], [-122.5219, 37.91532], [-122.52329, 37.91562], [-122.52341, 37.91572], [-122.52362, 37.91556], [-122.52371, 37.91544], [-122.52427, 37.91542], [-122.52465, 37.91552], [-122.52547, 37.9169]]]} | Open Access 1 | 14563 | Alta Bowl Open Space Preserve | 15411 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | Marin 23 | 39.648 | Alta Bowl OSP | 0 | Local Conservation Area 4 | 2 | |
9644 | 9644 | 9643 | {"type": "MultiPolygon", "coordinates": [[[[-121.83229, 36.59101], [-121.83109, 36.59345], [-121.82792, 36.59165], [-121.82894, 36.58888], [-121.83229, 36.59101]]], [[[-121.83618, 36.59396], [-121.83613, 36.594], [-121.83596, 36.594], [-121.83578, 36.59403], [-121.83555, 36.59412], [-121.83537, 36.59425], [-121.8349, 36.59477], [-121.83327, 36.59564], [-121.83323, 36.59544], [-121.83299, 36.59497], [-121.83342, 36.5945], [-121.83343, 36.59375], [-121.83318, 36.59311], [-121.83187, 36.5925], [-121.83257, 36.59107], [-121.83287, 36.59145], [-121.83319, 36.59179], [-121.8335, 36.59208], [-121.83383, 36.59237], [-121.83434, 36.59275], [-121.83618, 36.59396]]]]} | Open Access 1 | 16267 | Frog Pond Wetland Preserve | 19130 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 43.011 | Frog Pond Wetland Preserve | 0 | Local Conservation Area 4 | 2 | |
10198 | 10198 | 10197 | {"type": "Polygon", "coordinates": [[[-121.85903, 36.36976], [-121.85515, 36.36987], [-121.85527, 36.37368], [-121.85075, 36.37381], [-121.85089, 36.37715], [-121.84711, 36.37728], [-121.84693, 36.37392], [-121.84353, 36.37402], [-121.84363, 36.37741], [-121.82097, 36.37768], [-121.82074, 36.37357], [-121.82012, 36.36611], [-121.8216, 36.3661], [-121.82098, 36.35867], [-121.84327, 36.3589], [-121.84339, 36.36607], [-121.84726, 36.36604], [-121.84713, 36.35909], [-121.85092, 36.35929], [-121.85093, 36.35928], [-121.85093, 36.35901], [-121.85097, 36.35901], [-121.85106, 36.36251], [-121.85878, 36.36245], [-121.85903, 36.36976]], [[-121.83075, 36.36977], [-121.83517, 36.36973], [-121.83501, 36.36609], [-121.82607, 36.36611], [-121.82634, 36.3698], [-121.83075, 36.36977]]]} | No Public Access 3 | 17827 | Mill Creek Redwood Preserve | 22227 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 1387.391 | Mill Creek Redwood Preserve | 0 | Local Conservation Area 4 | 2 | |
11283 | 11283 | 11282 | {"type": "MultiPolygon", "coordinates": [[[[-121.81535, 37.09979], [-121.80309, 37.09987], [-121.80308, 37.09892], [-121.80307, 37.09891], [-121.8017, 37.09894], [-121.79263, 37.09906], [-121.79233, 37.08564], [-121.79413, 37.08608], [-121.79463, 37.08629], [-121.79596, 37.08665], [-121.79604, 37.08665], [-121.79689, 37.08693], [-121.81035, 37.08688], [-121.81049, 37.09054], [-121.81499, 37.09054], [-121.81535, 37.09979]]], [[[-121.84127, 37.09951], [-121.83675, 37.09956], [-121.83668, 37.09718], [-121.84118, 37.09709], [-121.84127, 37.09951]]]]} | No Public Access 3 | 21948 | Upper Uvas Creek Open Space Preserve | 26738 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 684.186 | Upper Uvas Creek OSP | 2001 | Local Conservation Area 4 | 2 | |
11621 | 11621 | 11620 | {"type": "Polygon", "coordinates": [[[-121.26212, 38.68889], [-121.26212, 38.68892], [-121.26177, 38.68897], [-121.26135, 38.6891], [-121.26129, 38.68913], [-121.26129, 38.68956], [-121.26014, 38.68957], [-121.25979, 38.68906], [-121.25915, 38.68886], [-121.25901, 38.68874], [-121.25871, 38.68871], [-121.25849, 38.68884], [-121.2581, 38.689], [-121.25809, 38.68917], [-121.25802, 38.68917], [-121.25802, 38.689], [-121.25767, 38.689], [-121.25759, 38.68872], [-121.25757, 38.68853], [-121.25749, 38.68838], [-121.25768, 38.68856], [-121.25794, 38.68867], [-121.25809, 38.6884], [-121.25827, 38.68844], [-121.25846, 38.68846], [-121.25862, 38.68844], [-121.25883, 38.68839], [-121.25894, 38.68857], [-121.25913, 38.68859], [-121.25926, 38.68854], [-121.25968, 38.6882], [-121.25974, 38.68796], [-121.25972, 38.68785], [-121.25986, 38.68785], [-121.26012, 38.68755], [-121.26018, 38.68757], [-121.26016, 38.68776], [-121.26041, 38.68801], [-121.26059, 38.6879], [-121.26115, 38.6879], [-121.26119, 38.68764], [-121.26125, 38.68765], [-121.26125, 38.68794], [-121.26146, 38.688], [-121.26174, 38.68788], [-121.26211, 38.68785], [-121.26208, 38.688], [-121.26208, 38.68818], [-121.26211, 38.68828], [-121.26209, 38.68847], [-121.26209, 38.68888], [-121.26212, 38.68889]]]} | Open Access 1 | 23902 | Sundance Park Natural Area | 25989 | 2248 | Orangevale Recreation and Park District 928 | Special District 4 | Recreation/Parks District 4 | http://www.orangevalecommunitycenter.com/ | Special District 4 | 2248 | Orangevale Recreation and Park District 901 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 10.407 | Sundance Park Natural Area | 0 | Local Conservation Area 4 | 2 | |
11662 | 11662 | 11661 | {"type": "Polygon", "coordinates": [[[-121.29784, 38.64354], [-121.29782, 38.64548], [-121.29476, 38.64548], [-121.29472, 38.64378], [-121.29511, 38.64377], [-121.29526, 38.64369], [-121.29575, 38.64368], [-121.29575, 38.64338], [-121.29616, 38.64337], [-121.29631, 38.64333], [-121.29688, 38.64333], [-121.2969, 38.64339], [-121.29732, 38.6433], [-121.29733, 38.64306], [-121.29776, 38.64306], [-121.29775, 38.64353], [-121.29784, 38.64354]]]} | Open Access 1 | 23954 | Schweitzer Grove Nature Area | 25198 | 2306 | Carmichael Recreation and Park District 671 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 15.105 | Schweitzer Grove Nature Area | 0 | Local Conservation Area 4 | 2 | |
11852 | 11852 | 11851 | {"type": "Polygon", "coordinates": [[[-121.3458, 38.65498], [-121.34511, 38.65498], [-121.3451, 38.65518], [-121.34476, 38.65518], [-121.34476, 38.65451], [-121.34502, 38.6545], [-121.3458, 38.65451], [-121.3458, 38.65498]]]} | Open Access 1 | 24287 | Holyoke Nature Area | 20058 | 2201 | Arcade Creek Recreation and Park District 739 | Special District 4 | Recreation/Parks District 4 | http://www.acrpd.com/ | Special District 4 | 2201 | Arcade Creek Recreation and Park District 724 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.344 | Holyoke Nature Area | 0 | Local Conservation Area 4 | 2 | |
12369 | 12369 | 12368 | {"type": "Polygon", "coordinates": [[[-122.8295, 38.42575], [-122.82842, 38.4255], [-122.82654, 38.42518], [-122.82585, 38.42504], [-122.82581, 38.4245], [-122.82568, 38.4232], [-122.82723, 38.42319], [-122.82787, 38.42348], [-122.82792, 38.42344], [-122.82827, 38.42365], [-122.82852, 38.42382], [-122.82874, 38.42402], [-122.82893, 38.42424], [-122.82918, 38.42458], [-122.82935, 38.42495], [-122.82946, 38.42528], [-122.82949, 38.42548], [-122.8295, 38.42575]]]} | No Public Access 3 | 26071 | Occidental Road Wetlands | 31262 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 15.729 | Occidental Road Wetlands | 2008 | Local Conservation Area 4 | 2 | |
13020 | 13020 | 13019 | {"type": "Polygon", "coordinates": [[[-121.84279, 37.09464], [-121.84249, 37.09949], [-121.84127, 37.09951], [-121.84118, 37.09709], [-121.83668, 37.09718], [-121.83675, 37.09956], [-121.81535, 37.09979], [-121.81499, 37.09054], [-121.81889, 37.09054], [-121.83285, 37.09024], [-121.83333, 37.09051], [-121.83344, 37.09063], [-121.83349, 37.09077], [-121.83358, 37.0909], [-121.83411, 37.09126], [-121.83427, 37.0913], [-121.83439, 37.0913], [-121.8349, 37.09112], [-121.83504, 37.09108], [-121.83518, 37.09109], [-121.83526, 37.09112], [-121.83532, 37.09117], [-121.83545, 37.09139], [-121.83554, 37.09149], [-121.83565, 37.09157], [-121.83585, 37.09164], [-121.83651, 37.0918], [-121.83658, 37.09366], [-121.83961, 37.09362], [-121.8398, 37.0936], [-121.84008, 37.09352], [-121.84015, 37.09351], [-121.84021, 37.09354], [-121.84025, 37.09359], [-121.84035, 37.09392], [-121.84049, 37.09418], [-121.84059, 37.09429], [-121.84071, 37.09439], [-121.84092, 37.0945], [-121.84134, 37.09462], [-121.84172, 37.09467], [-121.84189, 37.09466], [-121.84215, 37.09462], [-121.84236, 37.09461], [-121.84279, 37.09464]]]} | No Public Access 3 | 31211 | Upper Uvas Creek Open Space Preserve | 26738 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 531.708 | Upper Uvas Creek OSP | 2001 | Local Conservation Area 4 | 2 | |
13064 | 13064 | 13063 | {"type": "MultiPolygon", "coordinates": [[[[-122.02211, 37.16716], [-122.02181, 37.16714], [-122.02139, 37.16702], [-122.02125, 37.1668], [-122.02112, 37.16668], [-122.02064, 37.16671], [-122.02042, 37.16667], [-122.02024, 37.16654], [-122.02003, 37.16633], [-122.01976, 37.16613], [-122.01938, 37.16608], [-122.01899, 37.16611], [-122.0187, 37.16607], [-122.01833, 37.16613], [-122.01808, 37.16614], [-122.0176, 37.16589], [-122.01726, 37.16575], [-122.01713, 37.16564], [-122.01698, 37.16541], [-122.01615, 37.16587], [-122.01583, 37.16587], [-122.01564, 37.16573], [-122.01541, 37.16551], [-122.01493, 37.16491], [-122.01477, 37.16457], [-122.01453, 37.16441], [-122.01416, 37.16401], [-122.01399, 37.16368], [-122.01368, 37.16348], [-122.01368, 37.16286], [-122.01335, 37.1628], [-122.01318, 37.16264], [-122.01294, 37.16251], [-122.01261, 37.1624], [-122.01231, 37.16235], [-122.0123, 37.16215], [-122.01282, 37.16227], [-122.01344, 37.16262], [-122.01379, 37.16278], [-122.01377, 37.1628], [-122.01377, 37.16281], [-122.01407, 37.16287], [-122.0141, 37.16277], [-122.0145, 37.16291], [-122.01475, 37.16297], [-122.01532, 37.16332], [-122.0155, 37.16327], [-122.0219, 37.16346], [-122.02198, 37.16698], [-122.02186, 37.16706], [-122.02211, 37.16716]]], [[[-122.0222, 37.16716], [-122.0222, 37.16716], [-122.0222, 37.16716], [-122.0222, 37.16716], [-122.0222, 37.16716]]]]} | No Public Access 3 | 34926 | Bear Creek Redwoods Open Space Preserve | 31479 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 51.35 | Bear Creek Redwoods OSP | 2000 | Local Conservation Area 4 | 2 | |
13086 | 13086 | 13085 | {"type": "Polygon", "coordinates": [[[-121.8416, 37.74721], [-121.82304, 37.75175], [-121.82343, 37.73824], [-121.83817, 37.73833], [-121.84157, 37.73832], [-121.8416, 37.74721]]]} | No Public Access 3 | 35002 | Doolan Canyon Regional Preserve | 33749 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 495.161 | Doolan Canyon RPr | 2010 | Local Conservation Area 4 | 2 | |
13650 | 13650 | 13649 | {"type": "MultiPolygon", "coordinates": [[[[-121.33733, 38.65608], [-121.33726, 38.65614], [-121.33675, 38.65624], [-121.33626, 38.65622], [-121.33625, 38.65614], [-121.33611, 38.65614], [-121.33612, 38.65605], [-121.33626, 38.65605], [-121.33626, 38.65586], [-121.33595, 38.65586], [-121.33594, 38.65596], [-121.33567, 38.65597], [-121.33544, 38.656], [-121.33528, 38.65609], [-121.33507, 38.65607], [-121.3349, 38.65612], [-121.33473, 38.65611], [-121.33473, 38.65602], [-121.33503, 38.65542], [-121.33588, 38.65516], [-121.33664, 38.65615], [-121.33685, 38.65592], [-121.33686, 38.65596], [-121.3369, 38.65595], [-121.337, 38.65602], [-121.33708, 38.65596], [-121.33714, 38.65588], [-121.33712, 38.65577], [-121.33701, 38.65573], [-121.33713, 38.6556], [-121.33733, 38.65608]]], [[[-121.34277, 38.65129], [-121.3424, 38.65235], [-121.34226, 38.65268], [-121.3423, 38.65301], [-121.34224, 38.65322], [-121.34218, 38.65329], [-121.34119, 38.65388], [-121.34097, 38.65419], [-121.34028, 38.65443], [-121.34023, 38.65451], [-121.34015, 38.65456], [-121.33895, 38.65492], [-121.33851, 38.65508], [-121.33812, 38.65534], [-121.33759, 38.65583], [-121.33737, 38.65531], [-121.33768, 38.65521], [-121.33764, 38.65509], [-121.33794, 38.65502], [-121.33797, 38.65507], [-121.33997, 38.65418], [-121.33999, 38.65419], [-121.34003, 38.65419], [-121.34057, 38.65396], [-121.34096, 38.65375], [-121.34127, 38.65348], [-121.34133, 38.65336], [-121.34178, 38.65282], [-121.34199, 38.65245], [-121.34206, 38.6523], [-121.34193, 38.65232], [-121.34204, 38.65212], [-121.34207, 38.65191], [-121.34226, 38.65143], [-121.34184, 38.65078], [-121.34162, 38.6506], [-121.34115, 38.64998], [-121.34119, 38.64993], [-121.34115, 38.64975], [-121.34121, 38.6493], [-121.34129, 38.64906], [-121.3418, 38.64906], [-121.34176, 38.64925], [-121.34156, 38.64955], [-121.34175, 38.64992], [-121.34179, 38.65006], [-121.34183, 38.65041], [-121.34215, 38.65048], [-121.34264, 38.65089], [-121.34277, 38.65129]]]]} | Open Access 1 | 36015 | Arcade Creek Nature Area | 15562 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 12.32 | Arcade Creek Nature Area | 0 | Local Conservation Area 4 | 2 | |
14182 | 14182 | 14181 | {"type": "Polygon", "coordinates": [[[-122.3732, 37.97143], [-122.37282, 37.97158], [-122.37227, 37.97224], [-122.37225, 37.97251], [-122.37217, 37.97255], [-122.37148, 37.97255], [-122.37238, 37.97143], [-122.3732, 37.97143]]]} | No Public Access 3 | 43103 | North Richmond Wetlands | 22856 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 1.61 | North Richmond Wetlands | 0 | Local Conservation Area 4 | 2 | |
14222 | 14222 | 14221 | {"type": "Polygon", "coordinates": [[[-122.20351, 38.11873], [-122.20328, 38.11883], [-122.20313, 38.11904], [-122.20284, 38.11927], [-122.20219, 38.11961], [-122.20174, 38.11972], [-122.20122, 38.12015], [-122.20077, 38.1204], [-122.20056, 38.12044], [-122.20036, 38.12056], [-122.20022, 38.12088], [-122.19972, 38.12162], [-122.19969, 38.12201], [-122.19851, 38.12033], [-122.19912, 38.12062], [-122.20048, 38.12015], [-122.2031, 38.11852], [-122.20351, 38.11873]]]} | Open Access 1 | 44102 | Blue Rock Springs Corridor | 16188 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | Solano 26 | 6.569 | Blue Rock Springs Corridor | 0 | Local Conservation Area 4 | 2 | |
14439 | 14439 | 14438 | {"type": "Polygon", "coordinates": [[[-121.88684, 36.56638], [-121.88579, 36.56882], [-121.88447, 36.56806], [-121.88298, 36.56977], [-121.88077, 36.57012], [-121.88067, 36.57106], [-121.88099, 36.57107], [-121.88129, 36.57113], [-121.88148, 36.5712], [-121.8825, 36.57166], [-121.88356, 36.57192], [-121.88366, 36.57197], [-121.88374, 36.57203], [-121.88381, 36.5721], [-121.88386, 36.57219], [-121.88248, 36.57266], [-121.88214, 36.57274], [-121.87951, 36.57304], [-121.87925, 36.57303], [-121.87801, 36.57293], [-121.87758, 36.57294], [-121.87728, 36.57299], [-121.87646, 36.57322], [-121.87536, 36.57347], [-121.87507, 36.57358], [-121.87481, 36.57373], [-121.87458, 36.57391], [-121.87438, 36.57412], [-121.87424, 36.57432], [-121.87415, 36.57451], [-121.87395, 36.57522], [-121.87297, 36.57501], [-121.872, 36.57488], [-121.87169, 36.57486], [-121.87132, 36.5749], [-121.87238, 36.57088], [-121.8705, 36.57068], [-121.86855, 36.57129], [-121.86953, 36.57336], [-121.86903, 36.574], [-121.86868, 36.57384], [-121.86791, 36.57342], [-121.86761, 36.57333], [-121.86731, 36.5733], [-121.86713, 36.57331], [-121.86695, 36.57334], [-121.86678, 36.57339], [-121.86662, 36.57346], [-121.86635, 36.57363], [-121.8659, 36.5741], [-121.86569, 36.57425], [-121.86553, 36.57434], [-121.86534, 36.57441], [-121.86515, 36.57445], [-121.86497, 36.57447], [-121.86468, 36.57446], [-121.86173, 36.57413], [-121.8615, 36.57414], [-121.8613, 36.57418], [-121.86111, 36.57423], [-121.86085, 36.57433], [-121.86066, 36.57438], [-121.86047, 36.57441], [-121.86027, 36.57441], [-121.86008, 36.57438], [-121.85796, 36.57397], [-121.85773, 36.57394], [-121.85748, 36.57396], [-121.85741, 36.57394], [-121.85735, 36.57389], [-121.85728, 36.57366], [-121.85725, 36.57345], [-121.85724, 36.5731], [-121.85716, 36.57283], [-121.85702, 36.57258], [-121.85664, 36.57216], [-121.85651, 36.57199], [-121.8564, 36.5718], [-121.8563, 36.57156], [-121.85575, 36.57005], [-121.85571, 36.56984], [-121.8557, 36.56967], [-121.85574, 36.56933], [-121.8558, 36.56913], [-121.85586, 36.56896], [-121.85595, 36.56881], [-121.85607, 36.56862], [-121.85622, 36.56846], [-121.85696, 36.56777], [-121.85723, 36.56756], [-121.85747, 36.56743], [-121.85773, 36.56732], [-121.858, 36.56725], [-121.85829, 36.5672], [-121.85947, 36.56715], [-121.85999, 36.56714], [-121.86013, 36.56718], [-121.86024, 36.56727], [-121.86028, 36.56736], [-121.86027, 36.56745], [-121.86022, 36.56754], [-121.86014, 36.5676], [-121.85997, 36.56764], [-121.85933, 36.5676], [-121.8591, 36.56764], [-121.85898, 36.5677], [-121.85844, 36.56806], [-121.85835, 36.56817], [-121.85829, 36.56829], [-121.85827, 36.56841], [-121.8583, 36.56854], [-121.85837, 36.56866], [-121.85847, 36.56875], [-121.85856, 36.56881], [-121.85954, 36.56925], [-121.85965, 36.56929], [-121.85978, 36.5693], [-121.85992, 36.5693], [-121.86005, 36.56927], [-121.86016, 36.56922], [-121.86025, 36.56916], [-121.86032, 36.56908], [-121.86058, 36.56866], [-121.8607, 36.56855], [-121.86086, 36.56847], [-121.86171, 36.56825], [-121.86186, 36.56805], [-121.86185, 36.56804], [-121.86081, 36.56831], [-121.86065, 36.56837], [-121.86053, 36.56845], [-121.86043, 36.56855], [-121.86017, 36.56897], [-121.8601, 36.56905], [-121.86002, 36.5691], [-121.85991, 36.56913], [-121.85981, 36.56914], [-121.85971, 36.56913], [-121.85862, 36.56864], [-121.85855, 36.56858], [-121.8585, 36.56849], [-121.85848, 36.56841], [-121.85849, 36.56831], [-121.85857, 36.56819], [-121.85911, 36.56783], [-121.85921, 36.56778], [-121.85936, 36.56776], [-121.86001, 36.5678], [-121.86015, 36.56778], [-121.86028, 36.56772], [-121.86041, 36.5676], [-121.86048, 36.56745], [-121.86047, 36.56729], [-121.86039, 36.56715], [-121.86031, 36.56708], [-121.8602, 36.56702], [-121.8601, 36.56699], [-121.85998, 36.56697], [-121.85839, 36.56703], [-121.85815, 36.56705], [-121.85791, 36.56709], [-121.85761, 36.56718], [-121.85733, 36.5673], [-121.85707, 36.56745], [-121.85686, 36.56761], [-121.85597, 36.56844], [-121.85574, 36.56877], [-121.85559, 36.56912], [-121.85552, 36.56937], [-121.8555, 36.56964], [-121.85552, 36.56993], [-121.85558, 36.57019], [-121.8561, 36.57161], [-121.85622, 36.57186], [-121.85644, 36.57222], [-121.85684, 36.57266], [-121.85696, 36.57288], [-121.85703, 36.57313], [-121.85704, 36.57343], [-121.85706, 36.5736], [-121.85716, 36.57398], [-121.85712, 36.57405], [-121.85692, 36.57416], [-121.85675, 36.57428], [-121.85662, 36.57441], [-121.85653, 36.57453], [-121.85643, 36.57471], [-121.85637, 36.57486], [-121.85617, 36.57563], [-121.8561, 36.57578], [-121.85601, 36.57592], [-121.85589, 36.57607], [-121.85512, 36.57681], [-121.85436, 36.57782], [-121.85402, 36.57778], [-121.85436, 36.57733], [-121.85436, 36.57731], [-121.85396, 36.57741], [-121.85353, 36.57745], [-121.85173, 36.57738], [-121.85149, 36.57739], [-121.8512, 36.57743], [-121.84357, 36.57649], [-121.85025, 36.56484], [-121.85225, 36.56574], [-121.85356, 36.56573], [-121.85772, 36.56392], [-121.85964, 36.56526], [-121.86305, 36.56647], [-121.86549, 36.56549], [-121.8718, 36.56602], [-121.87463, 36.56583], [-121.87583, 36.56517], [-121.87583, 36.56515], [-121.87787, 36.56477], [-121.87811, 36.56469], [-121.87828, 36.56458], [-121.87841, 36.56444], [-121.87867, 36.5639], [-121.87871, 36.56384], [-121.87884, 36.56376], [-121.879, 36.56374], [-121.87916, 36.56377], [-121.88057, 36.56452], [-121.88076, 36.56457], [-121.88093, 36.56457], [-121.88109, 36.56452], [-121.88121, 36.56445], [-121.88139, 36.56426], [-121.88149, 36.56421], [-121.8816, 36.56417], [-121.88173, 36.56415], [-121.88214, 36.56414], [-121.88236, 36.56417], [-121.88246, 36.56422], [-121.88256, 36.56429], [-121.88303, 36.56481], [-121.88331, 36.56503], [-121.88346, 36.56511], [-121.88426, 36.56548], [-121.8844, 36.56553], [-121.88468, 36.56558], [-121.88489, 36.56567], [-121.88502, 36.56576], [-121.88568, 36.56633], [-121.88583, 36.56643], [-121.88608, 36.56651], [-121.88633, 36.56653], [-121.88658, 36.56649], [-121.88684, 36.56638]], [[-121.866, 36.57097], [-121.86585, 36.57122], [-121.86624, 36.57135], [-121.86637, 36.57111], [-121.866, 36.57097]]]} | Open Access 1 | 47035 | Joyce Stevens Monterey Pine Forest Preserve | 30687 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 825.702 | Joyce Stevens Monterey Pine Forest Preserve | 0 | Local Conservation Area 4 | 2 | |
15409 | 15409 | 15408 | {"type": "Polygon", "coordinates": [[[-121.74686, 37.21397], [-121.74675, 37.21408], [-121.74406, 37.21175], [-121.74273, 37.21269], [-121.74273, 37.2127], [-121.74574, 37.2153], [-121.74476, 37.21633], [-121.74487, 37.21644], [-121.74242, 37.21804], [-121.73356, 37.21042], [-121.73299, 37.2099], [-121.73292, 37.20993], [-121.72971, 37.20676], [-121.73058, 37.20587], [-121.73123, 37.20514], [-121.73217, 37.20435], [-121.73262, 37.20404], [-121.73268, 37.20403], [-121.73275, 37.20405], [-121.73301, 37.20386], [-121.733, 37.2038], [-121.73303, 37.20375], [-121.73596, 37.20169], [-121.73672, 37.20173], [-121.74017, 37.2049], [-121.74035, 37.2051], [-121.74145, 37.20611], [-121.74142, 37.20618], [-121.74165, 37.20638], [-121.74173, 37.20637], [-121.7461, 37.21033], [-121.74654, 37.21065], [-121.74691, 37.21362], [-121.74686, 37.21397]]]} | Restricted Access 2 | 49043 | Northern Coyote Valley Conservation Area | 33748 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 326.66 | Northern Coyote Valley Conservation Area | 0 | Local Conservation Area 4 | 2 | |
15522 | 15522 | 15521 | {"type": "MultiPolygon", "coordinates": [[[[-121.76287, 37.21275], [-121.76286, 37.21293], [-121.76232, 37.21425], [-121.76156, 37.21457], [-121.75906, 37.21586], [-121.75756, 37.21692], [-121.75681, 37.21661], [-121.75677, 37.2165], [-121.75526, 37.21583], [-121.75502, 37.2157], [-121.75509, 37.21561], [-121.75502, 37.21557], [-121.75493, 37.21565], [-121.75319, 37.21469], [-121.75016, 37.21265], [-121.74665, 37.2101], [-121.74643, 37.20993], [-121.7455, 37.20914], [-121.74074, 37.20483], [-121.74055, 37.20464], [-121.74057, 37.20462], [-121.73814, 37.20241], [-121.73713, 37.20145], [-121.73718, 37.20083], [-121.73835, 37.20002], [-121.73913, 37.20073], [-121.73972, 37.20031], [-121.73945, 37.1997], [-121.73921, 37.19949], [-121.73914, 37.19948], [-121.74116, 37.19815], [-121.74122, 37.1982], [-121.74157, 37.19796], [-121.74319, 37.20032], [-121.74378, 37.20104], [-121.74407, 37.20122], [-121.74544, 37.20166], [-121.74641, 37.20203], [-121.74615, 37.20311], [-121.74637, 37.20329], [-121.7467, 37.20335], [-121.74933, 37.20352], [-121.74953, 37.20417], [-121.74961, 37.20654], [-121.75096, 37.20684], [-121.75129, 37.20723], [-121.75125, 37.20755], [-121.75157, 37.20836], [-121.75306, 37.20872], [-121.75332, 37.20916], [-121.75357, 37.20931], [-121.7554, 37.20946], [-121.75584, 37.20998], [-121.75725, 37.21072], [-121.75917, 37.21126], [-121.76136, 37.21145], [-121.76287, 37.21275]]], [[[-121.74608, 37.21559], [-121.74531, 37.21653], [-121.7452, 37.21672], [-121.74475, 37.21634], [-121.74574, 37.2153], [-121.74608, 37.21559]]], [[[-121.75111, 37.21385], [-121.75028, 37.21433], [-121.74959, 37.21442], [-121.74862, 37.21468], [-121.74773, 37.21479], [-121.74709, 37.21504], [-121.74681, 37.21488], [-121.74704, 37.21434], [-121.74675, 37.21408], [-121.74686, 37.21397], [-121.74691, 37.21362], [-121.74654, 37.21065], [-121.74935, 37.21263], [-121.75111, 37.21385]]]]} | Restricted Access 2 | 49042 | Northern Coyote Valley Conservation Area | 33748 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 374.267 | Northern Coyote Valley Conservation Area | 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]);