units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
113 rows where COUNTY = 5 and DES_TP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL
MNG_AGENCY 6
MNG_AG_TYP 3
ACCESS_TYP 2
- Open Access 112
- Restricted Access 1
DES_TP 1
- Local Park · 113 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6135 | 6135 | 6134 | {"type": "Polygon", "coordinates": [[[-121.81009, 36.98721], [-121.80994, 36.98711], [-121.80897, 36.98712], [-121.80907, 36.98747], [-121.80915, 36.98801], [-121.80804, 36.98783], [-121.80804, 36.98741], [-121.80794, 36.98713], [-121.80693, 36.98714], [-121.80692, 36.98712], [-121.80828, 36.9871], [-121.8081, 36.98657], [-121.80874, 36.98643], [-121.80896, 36.98709], [-121.81004, 36.98708], [-121.81009, 36.98721]]]} | Open Access 1 | 1127 | Aldridge Lane Park | 15351 | 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 | 3.265 | Aldridge Lane Park | 0 | Local Park 2 | 4 | |
8423 | 8423 | 8422 | {"type": "Polygon", "coordinates": [[[-121.96911, 36.99374], [-121.96911, 36.9956], [-121.96692, 36.99562], [-121.96309, 36.99562], [-121.96246, 36.9956], [-121.96244, 36.99562], [-121.95684, 36.99562], [-121.95676, 36.99559], [-121.95674, 36.99553], [-121.95703, 36.99446], [-121.95713, 36.99403], [-121.96285, 36.99402], [-121.96285, 36.99302], [-121.96101, 36.99209], [-121.9608, 36.99165], [-121.9608, 36.99137], [-121.96112, 36.99083], [-121.96101, 36.99058], [-121.96049, 36.99024], [-121.96035, 36.98998], [-121.96042, 36.9898], [-121.96029, 36.98928], [-121.96046, 36.98905], [-121.96139, 36.98912], [-121.9614, 36.98894], [-121.962, 36.98898], [-121.96253, 36.98888], [-121.96344, 36.98837], [-121.9639, 36.98815], [-121.96463, 36.98842], [-121.96478, 36.9936], [-121.96911, 36.99374]]]} | Open Access 1 | 13052 | Anna Jean Cummings Park | 15503 | 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 | 95.411 | Anna Jean Cummings Park | 0 | Local Park 2 | 4 | |
8578 | 8578 | 8577 | {"type": "MultiPolygon", "coordinates": [[[[-121.9012, 36.97535], [-121.90104, 36.97554], [-121.9009, 36.97565], [-121.90022, 36.97565], [-121.9, 36.97562], [-121.89997, 36.97558], [-121.89973, 36.97546], [-121.89978, 36.97517], [-121.90053, 36.97515], [-121.90119, 36.97534], [-121.9012, 36.97535]]], [[[-121.90391, 36.97622], [-121.90364, 36.97625], [-121.90357, 36.9762], [-121.90345, 36.97617], [-121.90284, 36.97609], [-121.9025, 36.97598], [-121.90204, 36.97598], [-121.90206, 36.97594], [-121.90199, 36.97591], [-121.90206, 36.97533], [-121.90205, 36.97559], [-121.90211, 36.97585], [-121.90219, 36.97584], [-121.90231, 36.97592], [-121.90246, 36.97591], [-121.9026, 36.97592], [-121.90263, 36.97583], [-121.90276, 36.97582], [-121.9032, 36.97591], [-121.90382, 36.97612], [-121.90391, 36.97622]]], [[[-121.90494, 36.97742], [-121.90501, 36.97777], [-121.90491, 36.97835], [-121.90452, 36.97864], [-121.90473, 36.97891], [-121.90466, 36.97907], [-121.90448, 36.97926], [-121.90426, 36.97969], [-121.90428, 36.98012], [-121.90472, 36.9802], [-121.90476, 36.98033], [-121.90457, 36.98062], [-121.90442, 36.98093], [-121.90434, 36.98123], [-121.90412, 36.98134], [-121.90415, 36.98094], [-121.90432, 36.98034], [-121.9041, 36.98031], [-121.90404, 36.98008], [-121.90367, 36.97979], [-121.9036, 36.97965], [-121.90358, 36.97936], [-121.90366, 36.97924], [-121.90361, 36.979], [-121.90385, 36.97865], [-121.90359, 36.97852], [-121.90359, 36.97849], [-121.90346, 36.9784], [-121.90303, 36.97822], [-121.90278, 36.97807], [-121.90277, 36.97809], [-121.90296, 36.97834], [-121.90299, 36.97854], [-121.90288, 36.97856], [-121.90286, 36.97847], [-121.90276, 36.97827], [-121.90259, 36.97804], [-121.9025, 36.97783], [-121.9025, 36.97762], [-121.90257, 36.97739], [-121.90268, 36.97731], [-121.90277, 36.97721], [-121.90309, 36.97701], [-121.9038, 36.97673], [-121.90381, 36.97671], [-121.90375, 36.97664], [-121.90393, 36.97654], [-121.90398, 36.97662], [-121.90399, 36.97708], [-121.90452, 36.97704], [-121.90494, 36.97742]]]]} | Open Access 1 | 13614 | Aptos Village Park | 15547 | 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 | 14.362 | Aptos Village Park | 0 | Local Park 2 | 4 | |
8798 | 8798 | 8797 | {"type": "Polygon", "coordinates": [[[-121.76555, 36.93039], [-121.76552, 36.93052], [-121.76555, 36.93069], [-121.7655, 36.93072], [-121.76538, 36.93075], [-121.76533, 36.93074], [-121.76526, 36.93064], [-121.76515, 36.93064], [-121.76509, 36.93057], [-121.76509, 36.93054], [-121.76526, 36.93038], [-121.76549, 36.93037], [-121.76555, 36.93039]]]} | Open Access 1 | 14315 | Arista Park | 15585 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.301 | Arista Park | 0 | Local Park 2 | 4 | |
9857 | 9857 | 9856 | {"type": "Polygon", "coordinates": [[[-121.74155, 36.91676], [-121.74127, 36.91714], [-121.7408, 36.91692], [-121.74152, 36.91674], [-121.74155, 36.91676]]]} | Open Access 1 | 16873 | Atri Park | 15677 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.316 | Atri Park | 0 | Local Park 2 | 4 | |
13188 | 13188 | 13187 | {"type": "Polygon", "coordinates": [[[-122.11963, 37.1255], [-122.11902, 37.12573], [-122.11902, 37.12573], [-122.11903, 37.12536], [-122.11963, 37.1255]]]} | Open Access 1 | 35178 | Barbara Day Park | 28528 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.272 | Barbara Day Park | 0 | Local Park 2 | 4 | |
10045 | 10045 | 10044 | {"type": "Polygon", "coordinates": [[[-122.01725, 36.96579], [-122.01685, 36.96565], [-122.0168, 36.9655], [-122.01713, 36.96543], [-122.01725, 36.96579]]]} | Open Access 1 | 17442 | Beach Flats Park | 15906 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.216 | Beach Flats Park | 0 | Local Park 2 | 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 | |
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 | |
1436 | 1436 | 1435 | {"type": "Polygon", "coordinates": [[[-122.01137, 36.9919], [-122.01132, 36.9921], [-122.0113, 36.99239], [-122.01115, 36.99208], [-122.01115, 36.99183], [-122.01137, 36.9919]]]} | Open Access 1 | 47745 | Branciforte Dog Park | 31554 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.175 | Branciforte Dog Park | 0 | Local Park 2 | 4 | |
87 | 87 | 86 | {"type": "Polygon", "coordinates": [[[-121.74459, 36.92013], [-121.74445, 36.92037], [-121.74431, 36.92032], [-121.74415, 36.92034], [-121.744, 36.92028], [-121.74398, 36.92024], [-121.74411, 36.92], [-121.74416, 36.91997], [-121.7442, 36.91998], [-121.74459, 36.92013]]]} | Open Access 1 | 247 | Brentwood Park | 16362 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.377 | Brentwood Park | 0 | Local Park 2 | 4 | |
144 | 144 | 143 | {"type": "Polygon", "coordinates": [[[-121.97587, 36.97007], [-121.9757, 36.97077], [-121.97566, 36.97132], [-121.97552, 36.9716], [-121.97389, 36.9716], [-121.97365, 36.97101], [-121.9733, 36.97101], [-121.97331, 36.97038], [-121.97438, 36.97017], [-121.97457, 36.97011], [-121.97587, 36.97007]]]} | Open Access 1 | 363 | Brommer Park | 16416 | 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 | 7.663 | Brommer Park | 0 | Local Park 2 | 4 | |
155 | 155 | 154 | {"type": "Polygon", "coordinates": [[[-121.7428, 36.9182], [-121.74279, 36.91824], [-121.7426, 36.9185], [-121.74256, 36.91853], [-121.7425, 36.91852], [-121.74237, 36.91846], [-121.74233, 36.91842], [-121.74234, 36.91838], [-121.74253, 36.91813], [-121.74258, 36.9181], [-121.74265, 36.9181], [-121.74277, 36.91816], [-121.7428, 36.9182]]]} | Open Access 1 | 417 | Bronte Park | 16417 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.287 | Bronte Park | 0 | Local Park 2 | 4 | |
6103 | 6103 | 6102 | {"type": "Polygon", "coordinates": [[[-121.803, 36.93287], [-121.80054, 36.93485], [-121.80069, 36.93581], [-121.80042, 36.94027], [-121.79899, 36.9403], [-121.79906, 36.93611], [-121.79906, 36.93551], [-121.79912, 36.93392], [-121.80104, 36.93237], [-121.80218, 36.93152], [-121.80231, 36.93209], [-121.80248, 36.93249], [-121.803, 36.93287]]]} | Open Access 1 | 1018 | Buena Vista Park | 16497 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 35.267 | Buena Vista Park | 0 | Local Park 2 | 4 | |
6358 | 6358 | 6357 | {"type": "Polygon", "coordinates": [[[-121.7604, 36.91664], [-121.75986, 36.918], [-121.75986, 36.918], [-121.75903, 36.91704], [-121.76019, 36.91639], [-121.7604, 36.91664]]]} | Open Access 1 | 1764 | Callaghan Park | 16732 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 2.53 | Callaghan Park | 0 | Local Park 2 | 4 | |
610 | 610 | 609 | {"type": "Polygon", "coordinates": [[[-122.01752, 37.02001], [-122.01724, 37.02045], [-122.01717, 37.02042], [-122.01712, 37.02034], [-122.01683, 37.0203], [-122.01655, 37.02012], [-122.01641, 37.02009], [-122.01665, 37.0197], [-122.01675, 37.01958], [-122.01686, 37.01955], [-122.01698, 37.01966], [-122.01727, 37.01988], [-122.01752, 37.02001]]]} | Open Access 1 | 2139 | Camp Evers Fishing Park | 16774 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 1.271 | Camp Evers Fishing Park | 0 | Local Park 2 | 4 | |
5744 | 5744 | 5743 | {"type": "Polygon", "coordinates": [[[-121.95634, 36.96909], [-121.95598, 36.96939], [-121.95522, 36.97019], [-121.95526, 36.97], [-121.95536, 36.96979], [-121.95537, 36.96963], [-121.95551, 36.96958], [-121.95555, 36.96953], [-121.95557, 36.9693], [-121.95562, 36.96928], [-121.95576, 36.96934], [-121.95585, 36.96935], [-121.9559, 36.96935], [-121.95603, 36.96927], [-121.9562, 36.96905], [-121.95625, 36.96902], [-121.95634, 36.96909]]]} | Open Access 1 | 3076 | Capitola Beach | 16838 | 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.609 | Capitola Beach | 0 | Local Park 2 | 4 | |
6537 | 6537 | 6536 | {"type": "MultiPolygon", "coordinates": [[[[-121.95378, 36.97115], [-121.95372, 36.97116], [-121.95349, 36.9702], [-121.95355, 36.97019], [-121.95378, 36.97115]]], [[[-121.95523, 36.97011], [-121.95522, 36.97019], [-121.95469, 36.97073], [-121.95445, 36.97105], [-121.95417, 36.97097], [-121.95406, 36.97105], [-121.95392, 36.97123], [-121.95385, 36.97083], [-121.95402, 36.97083], [-121.9547, 36.97048], [-121.95504, 36.97024], [-121.95517, 36.97016], [-121.95523, 36.97011]]], [[[-121.95043, 36.97171], [-121.95043, 36.97188], [-121.95024, 36.97188], [-121.94991, 36.97193], [-121.94988, 36.97181], [-121.9499, 36.9718], [-121.95043, 36.97171]]], [[[-121.95364, 36.97121], [-121.95352, 36.97127], [-121.95318, 36.97153], [-121.95304, 36.97178], [-121.95298, 36.97194], [-121.95297, 36.97199], [-121.95298, 36.97211], [-121.95304, 36.97218], [-121.95318, 36.97224], [-121.95328, 36.9722], [-121.9532, 36.97224], [-121.95318, 36.97227], [-121.95271, 36.9725], [-121.95268, 36.97249], [-121.95295, 36.97237], [-121.95295, 36.97235], [-121.95279, 36.9722], [-121.95246, 36.97228], [-121.95234, 36.97188], [-121.95217, 36.97191], [-121.95195, 36.97179], [-121.95181, 36.97174], [-121.95148, 36.97167], [-121.95143, 36.97181], [-121.95066, 36.97183], [-121.95066, 36.97162], [-121.95075, 36.97158], [-121.95149, 36.97136], [-121.95179, 36.97125], [-121.95289, 36.97102], [-121.95337, 36.97102], [-121.95352, 36.97103], [-121.9536, 36.97101], [-121.95364, 36.97121]]], [[[-121.94981, 36.97222], [-121.94971, 36.97209], [-121.94938, 36.97217], [-121.94886, 36.97235], [-121.94889, 36.97258], [-121.94876, 36.9726], [-121.94872, 36.97241], [-121.94836, 36.97253], [-121.94835, 36.97254], [-121.94838, 36.97259], [-121.94676, 36.97342], [-121.94536, 36.97429], [-121.94521, 36.97409], [-121.94546, 36.97398], [-121.94575, 36.9737], [-121.94605, 36.97359], [-121.94616, 36.97353], [-121.94642, 36.97332], [-121.94683, 36.97313], [-121.94708, 36.97295], [-121.94756, 36.97276], [-121.94779, 36.97258], [-121.94824, 36.97244], [-121.94858, 36.97225], [-121.9488, 36.9722], [-121.949, 36.9721], [-121.94911, 36.97208], [-121.94918, 36.97222], [-121.9495, 36.97211], [-121.94979, 36.97206], [-121.94981, 36.97222]]]]} | Open Access 1 | 2964 | Capitola Beach | 16839 | 1044 | Capitola, City of 112 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | Santa Cruz 5 | 8.129 | Capitola Beach | 0 | Local Park 2 | 4 | |
709 | 709 | 708 | {"type": "Polygon", "coordinates": [[[-122.01909, 36.97734], [-122.01892, 36.97736], [-122.01872, 36.97737], [-122.01879, 36.97715], [-122.01894, 36.97709], [-122.01909, 36.97734]]]} | Open Access 1 | 5334 | Central Park | 17062 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.156 | Central Park | 0 | Local Park 2 | 4 | |
6985 | 6985 | 6984 | {"type": "Polygon", "coordinates": [[[-121.77997, 36.93361], [-121.77981, 36.9337], [-121.7796, 36.93345], [-121.77976, 36.93336], [-121.77997, 36.93361]]]} | Open Access 1 | 5908 | Cherry Blossom Pocket Park | 17165 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.151 | Cherry Blossom PP | 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]);