units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 5 and MNG_AG_LEV = 3 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
DES_TP 10
- Local Park 33
- Local Recreation Area 5
- Local Other or Unknown 4
- Local Conservation Area 3
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Cruz, County of · 51 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6363 | 6363 | 6362 | {"type": "Polygon", "coordinates": [[[-121.9128, 36.9767], [-121.91215, 36.97675], [-121.91216, 36.97584], [-121.91275, 36.97583], [-121.91271, 36.97616], [-121.9128, 36.9767]]]} | Open Access 1 | 48892 | Seacliff Village Park (McGregor) | 33609 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/Home/Parks/ListofAllCountyParks.aspx | Santa Cruz 5 | 1.282 | Seacliff Village Park (McGregor) | None 516 | ||
17031 | 17031 | 17030 | {"type": "Polygon", "coordinates": [[[-121.94388, 36.98798], [-121.94332, 36.99061], [-121.94267, 36.99058], [-121.94267, 36.99056], [-121.94276, 36.99045], [-121.94269, 36.99022], [-121.94259, 36.99013], [-121.94264, 36.98993], [-121.94279, 36.98973], [-121.9428, 36.98959], [-121.94286, 36.98949], [-121.94287, 36.98945], [-121.94242, 36.98943], [-121.94249, 36.98922], [-121.94269, 36.98889], [-121.94279, 36.98867], [-121.94289, 36.98833], [-121.94293, 36.98807], [-121.94297, 36.98802], [-121.94302, 36.98799], [-121.9433, 36.98804], [-121.94345, 36.98801], [-121.94346, 36.98799], [-121.94388, 36.98798]]]} | Open Access 1 | 48177 | The Farm Park & Community Center | 32712 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/Home/Parks/TheFarmPark-CommunityMeetings.aspx | Santa Cruz 5 | 5.534 | The Farm Park & Community Ctr. | 0 | Local Recreation Area 3 | 4 |
15469 | 15469 | 15468 | {"type": "Polygon", "coordinates": [[[-121.98479, 36.95999], [-121.98474, 36.96002], [-121.98461, 36.96034], [-121.98443, 36.96068], [-121.98393, 36.96052], [-121.98353, 36.96036], [-121.98386, 36.96002], [-121.98431, 36.95983], [-121.98479, 36.95999]]]} | Open Access 1 | 36562 | Unnamed site - Santa Cruz, County of | 28666 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.486 | 0 | Local Other or Unknown 14 | 4 | ||
4577 | 4577 | 4576 | {"type": "Polygon", "coordinates": [[[-121.85444, 36.9225], [-121.85412, 36.92319], [-121.85376, 36.92307], [-121.85374, 36.9231], [-121.85269, 36.92275], [-121.85271, 36.92271], [-121.85333, 36.92292], [-121.85334, 36.92288], [-121.85364, 36.92288], [-121.85392, 36.92281], [-121.85385, 36.92265], [-121.85379, 36.92263], [-121.85393, 36.92259], [-121.8539, 36.92263], [-121.85399, 36.92279], [-121.85421, 36.92268], [-121.85444, 36.9225]]]} | Open Access 1 | 35238 | Unknown park - Santa Cruz, County of | 28665 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.741 | 0 | Local Other or Unknown 14 | 4 | ||
5638 | 5638 | 5637 | {"type": "Polygon", "coordinates": [[[-122.06767, 37.07161], [-122.06612, 37.07145], [-122.06525, 37.07244], [-122.06498, 37.0733], [-122.06239, 37.07328], [-122.06241, 37.06957], [-122.06378, 37.06958], [-122.06746, 37.07014], [-122.06767, 37.07161]]]} | Open Access 1 | 29800 | Quail Hollow Quarry Conservation Areas | 24044 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 34.79 | Quail Hollow Quarry Conservation Areas | None 456 | |||
3080 | 3080 | 3079 | {"type": "Polygon", "coordinates": [[[-121.95533, 36.98673], [-121.95482, 36.98678], [-121.95473, 36.98618], [-121.95489, 36.98615], [-121.95533, 36.98673]]]} | Open Access 1 | 25004 | Lions Park | 21317 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.517 | Lions Park | 0 | Local Park 2 | 4 | |
2868 | 2868 | 2867 | {"type": "Polygon", "coordinates": [[[-122.06456, 37.08051], [-122.06575, 37.08186], [-122.06516, 37.08188], [-122.06511, 37.08397], [-122.06795, 37.08404], [-122.06788, 37.08414], [-122.06787, 37.08425], [-122.06814, 37.08465], [-122.06759, 37.08465], [-122.06753, 37.08556], [-122.06777, 37.08559], [-122.0675, 37.09096], [-122.0622, 37.09094], [-122.05739, 37.09066], [-122.05741, 37.08554], [-122.06002, 37.08555], [-122.06005, 37.07987], [-122.0576, 37.07982], [-122.05766, 37.07656], [-122.05927, 37.07841], [-122.06113, 37.07958], [-122.06188, 37.07978], [-122.06215, 37.07992], [-122.06335, 37.0792], [-122.06456, 37.08051]]]} | Open Access 1 | 18850 | Quail Hollow Ranch Park | 12092 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/quail_hollow.html | Santa Cruz 5 | 227.323 | Quail Hollow Ranch Park | 0 | Local Park 2 | 4 |
10543 | 10543 | 10542 | {"type": "MultiPolygon", "coordinates": [[[[-121.8835, 36.97893], [-121.88331, 36.97947], [-121.88316, 36.97975], [-121.88196, 36.98072], [-121.88189, 36.98075], [-121.88181, 36.98077], [-121.88125, 36.98065], [-121.88096, 36.98068], [-121.88071, 36.98079], [-121.88026, 36.98105], [-121.88021, 36.98107], [-121.88013, 36.98106], [-121.87992, 36.98133], [-121.87975, 36.98142], [-121.87919, 36.98229], [-121.87872, 36.98226], [-121.87821, 36.98272], [-121.87793, 36.98253], [-121.87787, 36.98236], [-121.87805, 36.98216], [-121.87789, 36.98198], [-121.87786, 36.98181], [-121.8777, 36.98183], [-121.87745, 36.98209], [-121.87697, 36.98284], [-121.87663, 36.98278], [-121.87654, 36.98282], [-121.87645, 36.9831], [-121.87615, 36.98336], [-121.87587, 36.98373], [-121.87554, 36.98396], [-121.87482, 36.98371], [-121.87456, 36.98364], [-121.87431, 36.98366], [-121.87389, 36.98414], [-121.87344, 36.98398], [-121.87253, 36.98125], [-121.87492, 36.98126], [-121.88113, 36.97826], [-121.88151, 36.97884], [-121.88172, 36.97876], [-121.88212, 36.97864], [-121.88254, 36.9786], [-121.88296, 36.97862], [-121.88337, 36.97873], [-121.88348, 36.97881], [-121.8835, 36.97893]]], [[[-121.88406, 36.97913], [-121.88403, 36.97919], [-121.88359, 36.9791], [-121.88361, 36.97903], [-121.88406, 36.97913]]]]} | Open Access 1 | 18757 | Polo Grounds Park | 23875 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 61.312 | Polo Grounds Park | 0 | Local Park 2 | 4 | |
10497 | 10497 | 10496 | {"type": "Polygon", "coordinates": [[[-121.85845, 36.92895], [-121.85841, 36.9293], [-121.85822, 36.92941], [-121.8581, 36.92954], [-121.85786, 36.92946], [-121.85754, 36.93007], [-121.85696, 36.92982], [-121.85766, 36.92846], [-121.8577, 36.92845], [-121.85774, 36.92846], [-121.85764, 36.92869], [-121.85845, 36.92895]]]} | Open Access 1 | 18621 | Place de Mer Park | 23760 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.659 | Place de Mer Park | 0 | Local Park 2 | 4 | |
10478 | 10478 | 10477 | {"type": "Polygon", "coordinates": [[[-121.78052, 36.96318], [-121.77845, 36.96386], [-121.77285, 36.96386], [-121.77286, 36.96497], [-121.76764, 36.965], [-121.76763, 36.96507], [-121.76721, 36.96507], [-121.76719, 36.96458], [-121.76511, 36.96457], [-121.76511, 36.96371], [-121.7679, 36.96373], [-121.76868, 36.9632], [-121.76904, 36.96274], [-121.76886, 36.96189], [-121.76851, 36.96134], [-121.768, 36.96075], [-121.7678, 36.96029], [-121.77036, 36.95751], [-121.77175, 36.95749], [-121.77176, 36.95734], [-121.77403, 36.95659], [-121.77841, 36.95854], [-121.7789, 36.95964], [-121.78052, 36.96318]]]} | Open Access 1 | 18562 | Pinto Lake Park | 23706 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 186.068 | Pinto Lake Park | 0 | Local Park 2 | 4 | |
10310 | 10310 | 10309 | {"type": "Polygon", "coordinates": [[[-121.74548, 36.91252], [-121.74543, 36.91258], [-121.74506, 36.91341], [-121.74351, 36.91547], [-121.7433, 36.91528], [-121.74403, 36.91429], [-121.74416, 36.91385], [-121.74483, 36.91341], [-121.74512, 36.91263], [-121.74548, 36.91252]]]} | Open Access 1 | 18353 | Pajaro River | 28154 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.421 | Pajaro River | None 901 | |||
9887 | 9887 | 9886 | {"type": "MultiPolygon", "coordinates": [[[[-122.07465, 37.09388], [-122.07452, 37.0943], [-122.07432, 37.0947], [-122.07404, 37.09507], [-122.07345, 37.09551], [-122.07319, 37.09568], [-122.07298, 37.09588], [-122.07282, 37.09611], [-122.06231, 37.09602], [-122.06222, 37.09358], [-122.07465, 37.09388]]], [[[-122.07657, 37.09618], [-122.0732, 37.09611], [-122.0731, 37.09611], [-122.07328, 37.09589], [-122.07427, 37.09516], [-122.07455, 37.09477], [-122.07476, 37.09435], [-122.07489, 37.09389], [-122.07653, 37.09393], [-122.07657, 37.09618]]]]} | Open Access 1 | 18330 | Pace Family Wilderness Park | 23289 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 79.551 | Pace Family Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
2608 | 2608 | 2607 | {"type": "MultiPolygon", "coordinates": [[[[-121.97832, 36.95705], [-121.97828, 36.95709], [-121.9783, 36.95711], [-121.97787, 36.95759], [-121.97783, 36.95757], [-121.97775, 36.95765], [-121.97718, 36.95745], [-121.97667, 36.9574], [-121.97609, 36.95755], [-121.97595, 36.95809], [-121.97577, 36.9583], [-121.97571, 36.95895], [-121.97546, 36.95939], [-121.97509, 36.95967], [-121.97488, 36.95987], [-121.97474, 36.95987], [-121.97499, 36.95918], [-121.97528, 36.95862], [-121.97554, 36.95745], [-121.9757, 36.95715], [-121.97617, 36.9566], [-121.97634, 36.95646], [-121.97646, 36.95645], [-121.97691, 36.95656], [-121.97758, 36.95608], [-121.97784, 36.95626], [-121.97797, 36.95666], [-121.97791, 36.95672], [-121.97828, 36.95698], [-121.97832, 36.95705]]], [[[-121.97827, 36.95625], [-121.97813, 36.95638], [-121.97809, 36.95638], [-121.97801, 36.95612], [-121.97812, 36.95614], [-121.97827, 36.95625]]]]} | Open Access 1 | 17987 | Moran Lake Park | 22471 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 8.942 | Moran Lake Park | 0 | Local Park 2 | 4 | |
10210 | 10210 | 10209 | {"type": "Polygon", "coordinates": [[[-121.82055, 36.97299], [-121.81716, 36.97618], [-121.81662, 36.97634], [-121.81537, 36.97315], [-121.81532, 36.97306], [-121.81525, 36.97298], [-121.81716, 36.97213], [-121.81729, 36.9723], [-121.8174, 36.9724], [-121.81753, 36.97247], [-121.81777, 36.9725], [-121.81817, 36.97252], [-121.81837, 36.97245], [-121.81846, 36.97233], [-121.81851, 36.9722], [-121.81858, 36.97178], [-121.81871, 36.97143], [-121.81877, 36.97133], [-121.81885, 36.97126], [-121.8192, 36.97109], [-121.81943, 36.97142], [-121.81996, 36.97239], [-121.82016, 36.97266], [-121.82041, 36.97289], [-121.82055, 36.97299]]]} | Open Access 1 | 17847 | Bert Scott Estate Park | 16037 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 32.194 | Bert Scott Estate Park | 0 | Local Park 2 | 4 | |
10200 | 10200 | 10199 | {"type": "MultiPolygon", "coordinates": [[[[-122.12695, 37.15886], [-122.12688, 37.15908], [-122.12693, 37.15949], [-122.12686, 37.1596], [-122.12676, 37.15972], [-122.12663, 37.15982], [-122.12646, 37.15991], [-122.12603, 37.16008], [-122.12577, 37.16023], [-122.12556, 37.16043], [-122.12542, 37.16067], [-122.12536, 37.16093], [-122.12534, 37.16109], [-122.1253, 37.16125], [-122.12469, 37.16238], [-122.12442, 37.16276], [-122.12403, 37.16305], [-122.12382, 37.16311], [-122.12368, 37.16339], [-122.12366, 37.16406], [-122.12331, 37.16443], [-122.12297, 37.16476], [-122.12282, 37.16546], [-122.11806, 37.16587], [-122.11653, 37.16016], [-122.11657, 37.15906], [-122.12571, 37.15915], [-122.12695, 37.15886]]], [[[-122.13103, 37.16474], [-122.13043, 37.16479], [-122.12301, 37.16544], [-122.12314, 37.16482], [-122.12374, 37.16422], [-122.12388, 37.164], [-122.12399, 37.16337], [-122.12412, 37.16317], [-122.12456, 37.16284], [-122.12467, 37.16271], [-122.12485, 37.16244], [-122.1251, 37.162], [-122.12546, 37.16129], [-122.1255, 37.16116], [-122.12553, 37.16093], [-122.12561, 37.16064], [-122.12581, 37.16039], [-122.12611, 37.1602], [-122.12648, 37.16009], [-122.1268, 37.15992], [-122.12704, 37.15968], [-122.12714, 37.15952], [-122.12708, 37.15901], [-122.12714, 37.15882], [-122.13035, 37.15808], [-122.13103, 37.16474]]]]} | Open Access 1 | 17835 | Miller Property County Park | 22248 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 208.728 | Miller Property County Park | 0 | Local Other or Unknown 14 | 4 | |
10179 | 10179 | 10178 | {"type": "Polygon", "coordinates": [[[-122.0518, 37.04316], [-122.05171, 37.04325], [-122.05136, 37.04307], [-122.05098, 37.04293], [-122.04999, 37.04275], [-122.05026, 37.04347], [-122.04925, 37.04495], [-122.0486, 37.04622], [-122.04469, 37.04114], [-122.04518, 37.04088], [-122.04547, 37.04119], [-122.04567, 37.04136], [-122.04589, 37.04151], [-122.04612, 37.04165], [-122.04637, 37.04178], [-122.04664, 37.04188], [-122.04719, 37.04204], [-122.05101, 37.04281], [-122.05123, 37.04287], [-122.05152, 37.04299], [-122.0518, 37.04316]]]} | Open Access 1 | 17811 | Michael Gray Field Park | 22195 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 27.906 | Michael Gray Field Park | 0 | Local Recreation Area 3 | 4 | |
2692 | 2692 | 2691 | {"type": "MultiPolygon", "coordinates": [[[[-122.08941, 37.08847], [-122.08867, 37.0882], [-122.0887, 37.08805], [-122.0888, 37.08808], [-122.08909, 37.08823], [-122.08938, 37.08835], [-122.08941, 37.08847]]], [[[-122.09254, 37.08896], [-122.0925, 37.08902], [-122.09228, 37.08886], [-122.09149, 37.08889], [-122.09142, 37.08887], [-122.09137, 37.08877], [-122.09012, 37.08881], [-122.09009, 37.08845], [-122.09002, 37.08845], [-122.09019, 37.08817], [-122.09026, 37.08819], [-122.09035, 37.08816], [-122.09053, 37.08823], [-122.09047, 37.08832], [-122.09038, 37.08833], [-122.09042, 37.08845], [-122.09038, 37.08844], [-122.09039, 37.08849], [-122.09058, 37.08852], [-122.09111, 37.08856], [-122.09112, 37.08855], [-122.09111, 37.08848], [-122.09135, 37.08849], [-122.09136, 37.08857], [-122.09139, 37.08858], [-122.09176, 37.08858], [-122.09193, 37.08861], [-122.09225, 37.08874], [-122.09234, 37.08883], [-122.09245, 37.08889], [-122.09254, 37.08896]]]]} | Open Access 1 | 17802 | Ben Lomond Park | 16002 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.953 | Ben Lomond Park | 0 | Local Park 2 | 4 | |
10146 | 10146 | 10145 | {"type": "Polygon", "coordinates": [[[-121.76493, 36.96594], [-121.76442, 36.96592], [-121.76403, 36.96472], [-121.76492, 36.96472], [-121.76493, 36.96594]]]} | Open Access 1 | 17782 | Mesa Village Park | 22182 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.066 | Mesa Village Park | 0 | Local Park 2 | 4 | |
10113 | 10113 | 10112 | {"type": "Polygon", "coordinates": [[[-121.85358, 36.92094], [-121.85322, 36.92159], [-121.85317, 36.92157], [-121.85338, 36.92118], [-121.85334, 36.92115], [-121.85347, 36.92092], [-121.85358, 36.92094]]]} | Open Access 1 | 17544 | Manresa State Beach Access | 21760 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.parks.ca.gov/?page_id=545 | Santa Cruz 5 | 0.136 | Manresa SB Access | 0 | Local Recreation Area 3 | 4 |
9927 | 9927 | 9926 | {"type": "Polygon", "coordinates": [[[-121.99187, 36.9749], [-121.99092, 36.97662], [-121.99045, 36.97644], [-121.99045, 36.97637], [-121.99042, 36.97632], [-121.99082, 36.97556], [-121.9899, 36.97523], [-121.98986, 36.97527], [-121.9895, 36.97539], [-121.98912, 36.97532], [-121.98942, 36.97511], [-121.98952, 36.97507], [-121.9896, 36.97494], [-121.99007, 36.97503], [-121.99003, 36.97493], [-121.99018, 36.97471], [-121.99049, 36.97461], [-121.99079, 36.9743], [-121.99187, 36.9749]]]} | Open Access 1 | 17068 | Jose Avenue Park | 20491 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 5.839 | Jose Avenue Park | 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]);