units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 13 and MNG_AG_TYP = 2 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10385 | 10385 | 10384 | {"type": "MultiPolygon", "coordinates": [[[[-121.75798, 36.90047], [-121.75609, 36.90223], [-121.75611, 36.90226], [-121.75499, 36.90323], [-121.75435, 36.90281], [-121.75745, 36.9], [-121.75798, 36.90047]]], [[[-121.7549, 36.90335], [-121.75398, 36.90403], [-121.75397, 36.90404], [-121.75404, 36.9041], [-121.75393, 36.90419], [-121.75385, 36.90412], [-121.75302, 36.90471], [-121.75302, 36.90473], [-121.75318, 36.90486], [-121.75303, 36.90498], [-121.75285, 36.90484], [-121.75274, 36.90492], [-121.75192, 36.90572], [-121.75129, 36.90516], [-121.75418, 36.90287], [-121.7549, 36.90335]]], [[[-121.7517, 36.90586], [-121.75102, 36.90635], [-121.75031, 36.90574], [-121.75107, 36.9053], [-121.7517, 36.90586]]], [[[-121.75087, 36.90647], [-121.74933, 36.90761], [-121.7488, 36.90796], [-121.74787, 36.90716], [-121.75014, 36.90584], [-121.75087, 36.90647]]], [[[-121.74869, 36.90807], [-121.74724, 36.90915], [-121.74657, 36.90856], [-121.74774, 36.90725], [-121.74869, 36.90807]]], [[[-121.74709, 36.90922], [-121.7468, 36.90943], [-121.74689, 36.90952], [-121.74659, 36.90974], [-121.74637, 36.90955], [-121.74681, 36.90897], [-121.74709, 36.90922]]], [[[-121.74659, 36.90991], [-121.7464, 36.91005], [-121.74623, 36.90976], [-121.7463, 36.90965], [-121.74659, 36.90991]]], [[[-121.74673, 36.9089], [-121.7461, 36.90975], [-121.74647, 36.91034], [-121.74647, 36.91042], [-121.74633, 36.91063], [-121.74615, 36.91048], [-121.74624, 36.91032], [-121.74568, 36.90954], [-121.74647, 36.90867], [-121.74673, 36.9089]]], [[[-121.74633, 36.9108], [-121.74559, 36.9118], [-121.74559, 36.91223], [-121.74523, 36.91234], [-121.74523, 36.91163], [-121.74575, 36.91113], [-121.74609, 36.91058], [-121.74633, 36.9108]]], [[[-121.7435, 36.91546], [-121.74276, 36.91643], [-121.74016, 36.91708], [-121.74036, 36.91663], [-121.74123, 36.91631], [-121.74227, 36.91632], [-121.74311, 36.91554], [-121.7433, 36.91528], [-121.7435, 36.91546]]]]} | Open Access 1 | 18349 | Pajaro River | 28155 | 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 | 34.942 | Pajaro River | 0 | None 908 | ||
5185 | 5185 | 5184 | {"type": "MultiPolygon", "coordinates": [[[[-121.75815, 36.92276], [-121.75776, 36.92297], [-121.75768, 36.92257], [-121.75788, 36.92246], [-121.75815, 36.92276]]], [[[-121.75848, 36.92319], [-121.75834, 36.92327], [-121.75787, 36.92353], [-121.75779, 36.92313], [-121.75822, 36.92289], [-121.75848, 36.92319]]]]} | Open Access 1 | 15866 | Flodberg Park | 18951 | 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.89 | Flodberg Park | 0 | Local Park 2 | 4 | |
418 | 418 | 417 | {"type": "MultiPolygon", "coordinates": [[[[-121.7791, 36.92112], [-121.77861, 36.92097], [-121.77814, 36.92117], [-121.77746, 36.9222], [-121.7769, 36.92436], [-121.77687, 36.92456], [-121.77667, 36.92366], [-121.77666, 36.92365], [-121.77613, 36.92561], [-121.77599, 36.92621], [-121.77601, 36.92699], [-121.77567, 36.92723], [-121.77534, 36.92621], [-121.77526, 36.92569], [-121.7753, 36.92516], [-121.77549, 36.92432], [-121.77552, 36.9241], [-121.77553, 36.92388], [-121.776, 36.92394], [-121.77606, 36.92283], [-121.77616, 36.92252], [-121.77623, 36.9219], [-121.77645, 36.92201], [-121.77717, 36.9225], [-121.77833, 36.91963], [-121.7791, 36.92112]]], [[[-121.77899, 36.91916], [-121.77866, 36.91936], [-121.77838, 36.91931], [-121.77842, 36.91897], [-121.77824, 36.91893], [-121.77848, 36.91836], [-121.77891, 36.91869], [-121.77899, 36.91916]]]]} | Open Access 1 | 1666 | Upper Struve Slough | 28147 | 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 | 15.625 | Upper Struve Slough | 0 | Local Conservation Area 4 | 2 | |
2761 | 2761 | 2760 | {"type": "MultiPolygon", "coordinates": [[[[-121.78027, 36.92425], [-121.77998, 36.92476], [-121.77963, 36.92443], [-121.77936, 36.92413], [-121.7793, 36.924], [-121.77934, 36.92398], [-121.77937, 36.92383], [-121.77941, 36.92379], [-121.77917, 36.92354], [-121.77935, 36.92341], [-121.77944, 36.92329], [-121.77945, 36.92315], [-121.7794, 36.92301], [-121.77936, 36.92297], [-121.77953, 36.92285], [-121.77928, 36.92161], [-121.77991, 36.92169], [-121.77994, 36.92184], [-121.77953, 36.92189], [-121.77952, 36.9219], [-121.77987, 36.92359], [-121.78027, 36.92425]]], [[[-121.78093, 36.92531], [-121.78051, 36.92531], [-121.78039, 36.92531], [-121.78065, 36.92488], [-121.78093, 36.92531]]]]} | Open Access 1 | 18460 | Peace Drive Park | 23538 | 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 | 3.458 | Peace Drive Park | 0 | Local Park 2 | 4 | |
6156 | 6156 | 6155 | {"type": "MultiPolygon", "coordinates": [[[[-121.78291, 36.91621], [-121.78256, 36.91719], [-121.78052, 36.91505], [-121.78046, 36.91505], [-121.78046, 36.91507], [-121.78205, 36.91673], [-121.7818, 36.91671], [-121.78152, 36.91672], [-121.78124, 36.91665], [-121.78115, 36.91624], [-121.78093, 36.91599], [-121.78049, 36.91589], [-121.78022, 36.9166], [-121.77992, 36.91692], [-121.78009, 36.91729], [-121.77988, 36.91746], [-121.77968, 36.91742], [-121.77949, 36.91735], [-121.77903, 36.91738], [-121.77991, 36.91507], [-121.7799, 36.91506], [-121.77903, 36.91506], [-121.77873, 36.91504], [-121.77879, 36.91477], [-121.77937, 36.91429], [-121.77963, 36.91378], [-121.77971, 36.91357], [-121.77975, 36.91322], [-121.77974, 36.9128], [-121.77975, 36.91269], [-121.77989, 36.91225], [-121.77985, 36.91009], [-121.77896, 36.91009], [-121.77856, 36.91033], [-121.77857, 36.91154], [-121.77852, 36.91173], [-121.77837, 36.91188], [-121.77817, 36.91197], [-121.77786, 36.91206], [-121.77758, 36.9122], [-121.7774, 36.91233], [-121.77715, 36.91221], [-121.77673, 36.91208], [-121.77722, 36.91156], [-121.77745, 36.91053], [-121.77591, 36.91037], [-121.77598, 36.91021], [-121.77805, 36.91048], [-121.77883, 36.90994], [-121.77934, 36.90977], [-121.7796, 36.90977], [-121.78003, 36.90997], [-121.78058, 36.90929], [-121.78185, 36.907], [-121.7823, 36.9077], [-121.78239, 36.90796], [-121.78242, 36.90824], [-121.78217, 36.90875], [-121.78208, 36.90927], [-121.7822, 36.90995], [-121.78191, 36.91045], [-121.78182, 36.91067], [-121.78188, 36.91089], [-121.78216, 36.91114], [-121.78196, 36.9113], [-121.78219, 36.91146], [-121.78236, 36.91136], [-121.78246, 36.91149], [-121.78202, 36.91206], [-121.7822, 36.91288], [-121.78242, 36.91344], [-121.78232, 36.91347], [-121.7823, 36.91365], [-121.78234, 36.9139], [-121.78209, 36.91426], [-121.78216, 36.91444], [-121.78204, 36.91461], [-121.78163, 36.91485], [-121.7812, 36.91487], [-121.7812, 36.91492], [-121.78121, 36.91493], [-121.78122, 36.91508], [-121.78205, 36.91593], [-121.78248, 36.91614], [-121.78291, 36.91621]], [[-121.78034, 36.91495], [-121.78035, 36.91493], [-121.78023, 36.91483], [-121.78019, 36.91496], [-121.78034, 36.91495]]], [[[-121.79241, 36.9166], [-121.79041, 36.91742], [-121.79014, 36.91691], [-121.7892, 36.91776], [-121.78899, 36.91741], [-121.78853, 36.91653], [-121.78866, 36.91621], [-121.78868, 36.91587], [-121.7886, 36.91553], [-121.78842, 36.91523], [-121.78815, 36.91497], [-121.78755, 36.91451], [-121.78726, 36.91412], [-121.78726, 36.91403], [-121.78733, 36.91397], [-121.78833, 36.91355], [-121.78831, 36.91349], [-121.7893, 36.91306], [-121.79027, 36.91424], [-121.7912, 36.9153], [-121.79144, 36.91551], [-121.79186, 36.91583], [-121.79198, 36.91594], [-121.79241, 36.9166]]], [[[-121.79536, 36.91187], [-121.79513, 36.91547], [-121.79465, 36.91567], [-121.79471, 36.91597], [-121.79454, 36.91611], [-121.79442, 36.91627], [-121.7944, 36.91634], [-121.79399, 36.91474], [-121.79383, 36.91475], [-121.79366, 36.91474], [-121.7935, 36.91467], [-121.79335, 36.91457], [-121.79305, 36.9141], [-121.79301, 36.91397], [-121.79295, 36.9137], [-121.79292, 36.91343], [-121.79291, 36.91315], [-121.79294, 36.91288], [-121.79309, 36.91235], [-121.79316, 36.91222], [-121.79337, 36.912], [-121.79355, 36.91177], [-121.7937, 36.91153], [-121.79374, 36.9114], [-121.79375, 36.91127], [-121.79364, 36.91115], [-121.79406, 36.91097], [-121.79536, 36.91187]]], [[[-121.79504, 36.91694], [-121.79497, 36.91818], [-121.79447, 36.91813], [-121.79454, 36.91704], [-121.79447, 36.91679], [-121.79469, 36.91689], [-121.79504, 36.91694]]]]} | Open Access 1 | 1166 | Struve Slough | 28148 | 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 | 105.317 | Struve Slough | 0 | Local Conservation Area 4 | 2 | |
9929 | 9929 | 9928 | {"type": "Polygon", "coordinates": [[[-121.74128, 36.92456], [-121.7412, 36.92483], [-121.7392, 36.9245], [-121.73918, 36.92428], [-121.7392, 36.92424], [-121.73925, 36.92422], [-121.74038, 36.92433], [-121.74123, 36.9245], [-121.74128, 36.92452], [-121.74128, 36.92456]]]} | Open Access 1 | 17073 | Joyce-McKenzie Park | 20510 | 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 | 1.692 | Joyce-McKenzie 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 | |
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 | |
9517 | 9517 | 9516 | {"type": "Polygon", "coordinates": [[[-121.74449, 36.92636], [-121.74449, 36.9264], [-121.74408, 36.92774], [-121.74406, 36.92788], [-121.74408, 36.92802], [-121.74191, 36.92759], [-121.74172, 36.92765], [-121.74168, 36.9276], [-121.74157, 36.92751], [-121.74143, 36.92745], [-121.74077, 36.92731], [-121.74115, 36.92581], [-121.74106, 36.92571], [-121.7411, 36.92569], [-121.74444, 36.92634], [-121.74449, 36.92636]]]} | Open Access 1 | 15972 | Franich Park | 19047 | 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 | 14.039 | Franich 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 | |
529 | 529 | 528 | {"type": "Polygon", "coordinates": [[[-121.74601, 36.9207], [-121.74537, 36.92053], [-121.74531, 36.92051], [-121.74535, 36.92045], [-121.74541, 36.92044], [-121.74598, 36.92066], [-121.74601, 36.9207]]]} | Open Access 1 | 1747 | Victorian Park | 27085 | 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.111 | Victorian Park | 0 | Local Park 2 | 4 | |
20 | 20 | 19 | {"type": "Polygon", "coordinates": [[[-121.7511, 36.90667], [-121.74954, 36.9078], [-121.74933, 36.90761], [-121.75087, 36.90647], [-121.7511, 36.90667]]]} | Open Access 1 | 76 | River Park | 24419 | 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 | 1.349 | River Park | 0 | Local Park 2 | 4 | |
5813 | 5813 | 5812 | {"type": "Polygon", "coordinates": [[[-121.75218, 36.90885], [-121.75199, 36.90899], [-121.75154, 36.90859], [-121.75172, 36.90846], [-121.75218, 36.90885]]]} | Open Access 1 | 86 | Riverside Mini Park | 24452 | 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.338 | Riverside MP | 0 | Local Park 2 | 4 | |
10268 | 10268 | 10267 | {"type": "Polygon", "coordinates": [[[-121.75376, 36.90563], [-121.75326, 36.90599], [-121.75273, 36.90552], [-121.75312, 36.90514], [-121.75316, 36.90512], [-121.75321, 36.90512], [-121.75376, 36.90563]]]} | Open Access 1 | 18057 | Muzzio Pocket Park | 22618 | 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 | 1.117 | Muzzio PP | 0 | Local Park 2 | 4 | |
4215 | 4215 | 4214 | {"type": "Polygon", "coordinates": [[[-121.7549, 36.91849], [-121.7545, 36.91871], [-121.75429, 36.91848], [-121.75388, 36.91869], [-121.75349, 36.91824], [-121.75322, 36.91838], [-121.75291, 36.91799], [-121.75268, 36.91773], [-121.75158, 36.91849], [-121.75102, 36.91787], [-121.7528, 36.91657], [-121.75302, 36.91683], [-121.75341, 36.91661], [-121.7542, 36.91753], [-121.7549, 36.91849]]]} | Restricted Access 2 | 44966 | E.A. Hall School Park | 32705 | 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 | 9.82 | E.A. Hall School Park | 0 | Local Park 2 | 4 | |
13303 | 13303 | 13302 | {"type": "Polygon", "coordinates": [[[-121.75571, 36.90633], [-121.75551, 36.90647], [-121.75541, 36.90638], [-121.75541, 36.90638], [-121.75571, 36.90633]]]} | Open Access 1 | 35365 | Watsonville holding 1 | 27309 | 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.04 | Watsonville holding 1 | 0 | Local Other or Unknown 14 | 4 | |
7477 | 7477 | 7476 | {"type": "Polygon", "coordinates": [[[-121.75668, 36.91019], [-121.75601, 36.91068], [-121.75548, 36.91022], [-121.75616, 36.90974], [-121.75668, 36.91019]]]} | Open Access 1 | 6993 | City Plaza Park | 17345 | 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 | 1.381 | City Plaza Park | 0 | Local Park 2 | 4 | |
9341 | 9341 | 9340 | {"type": "Polygon", "coordinates": [[[-121.75749, 36.9143], [-121.75695, 36.9146], [-121.75683, 36.91447], [-121.75737, 36.91417], [-121.75749, 36.9143]]]} | Open Access 1 | 15609 | Emmett Courts Park | 18632 | 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.262 | Emmett Courts Park | 0 | Local Park 2 | 4 | |
10144 | 10144 | 10143 | {"type": "Polygon", "coordinates": [[[-121.75842, 36.90801], [-121.75787, 36.9084], [-121.7574, 36.90798], [-121.75794, 36.90759], [-121.75842, 36.90801]]]} | Open Access 1 | 17665 | Marinovich Park | 21860 | 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 | 1.007 | Marinovich Park | 0 | Local Park 2 | 4 | |
8022 | 8022 | 8021 | {"type": "Polygon", "coordinates": [[[-121.76021, 36.92854], [-121.75889, 36.92892], [-121.75862, 36.92828], [-121.75968, 36.92797], [-121.75973, 36.92797], [-121.75976, 36.92799], [-121.75992, 36.92823], [-121.76013, 36.92843], [-121.76021, 36.92854]]]} | Open Access 1 | 11355 | Crestview Park | 17813 | 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.145 | Crestview 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]);