units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where DES_TP = 2, MNG_AGENCY = 9 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 34 ✖
MNG_AGENCY 1
- Santa Cruz, City of · 34 ✖
DES_TP 1
- Local Park · 34 ✖
ACCESS_TYP 1
- Open Access 34
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
7107 | 7107 | 7106 | {"type": "Polygon", "coordinates": [[[-122.02773, 36.9637], [-122.0276, 36.96381], [-122.02751, 36.96396], [-122.02747, 36.9641], [-122.02747, 36.96425], [-122.02745, 36.96402], [-122.0275, 36.96347], [-122.02767, 36.96347], [-122.02773, 36.9637]]]} | Open Access 1 | 47746 | Chestnut Park | 31555 | 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.218 | Chestnut Park | 0 | Local Park 2 | 4 | |
7522 | 7522 | 7521 | {"type": "Polygon", "coordinates": [[[-122.02546, 36.95999], [-122.02535, 36.96016], [-122.02541, 36.96029], [-122.02538, 36.96047], [-122.02509, 36.96091], [-122.02489, 36.96096], [-122.0251, 36.96127], [-122.02479, 36.96101], [-122.02537, 36.95992], [-122.02546, 36.95999]]]} | Open Access 1 | 10873 | Cowell's Beach | 17729 | 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.596 | Cowell's Beach | 0 | Local Park 2 | 4 | |
8511 | 8511 | 8510 | {"type": "Polygon", "coordinates": [[[-122.02823, 36.96597], [-122.02758, 36.96621], [-122.02693, 36.96626], [-122.02678, 36.96538], [-122.02672, 36.96523], [-122.02635, 36.96471], [-122.02662, 36.96459], [-122.0266, 36.96448], [-122.02645, 36.96421], [-122.0265, 36.96417], [-122.02643, 36.96404], [-122.02651, 36.96388], [-122.02644, 36.96375], [-122.02637, 36.96364], [-122.02623, 36.96368], [-122.02591, 36.96337], [-122.02509, 36.96321], [-122.02513, 36.96311], [-122.02563, 36.96314], [-122.02591, 36.96319], [-122.02624, 36.96331], [-122.02638, 36.9634], [-122.02653, 36.96351], [-122.02688, 36.96388], [-122.02727, 36.96433], [-122.02747, 36.96426], [-122.02757, 36.96456], [-122.02796, 36.96521], [-122.02823, 36.96597]]]} | Open Access 1 | 13359 | Depot Site Park | 18102 | 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 | 7.099 | Depot Site Park | 0 | Local Park 2 | 4 | |
3717 | 3717 | 3716 | {"type": "Polygon", "coordinates": [[[-122.0257, 36.96018], [-122.02534, 36.95989], [-122.02539, 36.95983], [-122.0254, 36.95974], [-122.02549, 36.95968], [-122.02549, 36.95962], [-122.02565, 36.95962], [-122.02563, 36.95976], [-122.0257, 36.96018]]]} | Open Access 1 | 14027 | Dutra Overlook Park | 18324 | 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.26 | Dutra Overlook Park | 0 | Local Park 2 | 4 | |
1520 | 1520 | 1519 | {"type": "Polygon", "coordinates": [[[-122.00809, 36.98128], [-122.00809, 36.98128], [-122.00733, 36.98127], [-122.00796, 36.98109], [-122.00807, 36.98104], [-122.00809, 36.98128]]]} | Open Access 1 | 47747 | El Portal Park | 31556 | 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.212 | El Portal Park | 0 | Local Park 2 | 4 | |
9558 | 9558 | 9557 | {"type": "Polygon", "coordinates": [[[-122.00255, 36.97243], [-122.00094, 36.97265], [-122.0008, 36.9725], [-122.0007, 36.9721], [-122.00082, 36.9717], [-122.00235, 36.97148], [-122.00255, 36.97243]]]} | Open Access 1 | 16062 | Frederick Street Park | 19080 | 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 | 3.966 | Frederick Street Park | 0 | Local Park 2 | 4 | |
9555 | 9555 | 9554 | {"type": "Polygon", "coordinates": [[[-122.04308, 36.95834], [-122.04233, 36.95843], [-122.04218, 36.95748], [-122.04293, 36.95738], [-122.04308, 36.95834]]]} | Open Access 1 | 16414 | Garfield Park | 19216 | 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 | 1.778 | Garfield Park | 0 | Local Park 2 | 4 | |
2247 | 2247 | 2246 | {"type": "Polygon", "coordinates": [[[-122.02181, 36.98457], [-122.02176, 36.98553], [-122.02056, 36.9854], [-122.0206, 36.98468], [-122.02121, 36.98477], [-122.02119, 36.98463], [-122.02181, 36.98457]]]} | Open Access 1 | 16660 | Grant Park | 19441 | 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 | 2.364 | Grant Park | 0 | Local Park 2 | 4 | |
2270 | 2270 | 2269 | {"type": "Polygon", "coordinates": [[[-122.04268, 36.9851], [-122.04216, 36.98525], [-122.04214, 36.98529], [-122.04058, 36.98487], [-122.03975, 36.9848], [-122.03804, 36.98451], [-122.0374, 36.98438], [-122.03603, 36.98405], [-122.03515, 36.98388], [-122.0354, 36.98291], [-122.03401, 36.98267], [-122.0342, 36.98195], [-122.03441, 36.98116], [-122.03466, 36.9813], [-122.03663, 36.98229], [-122.03688, 36.98236], [-122.03717, 36.98236], [-122.03744, 36.98229], [-122.03785, 36.98207], [-122.03808, 36.98199], [-122.03804, 36.98187], [-122.03777, 36.98195], [-122.0375, 36.9821], [-122.03722, 36.98221], [-122.03691, 36.98222], [-122.03662, 36.98214], [-122.0362, 36.98191], [-122.0367, 36.98134], [-122.03689, 36.98145], [-122.0377, 36.98124], [-122.03766, 36.98111], [-122.03824, 36.98098], [-122.03817, 36.98078], [-122.03928, 36.98077], [-122.03967, 36.98112], [-122.03942, 36.98144], [-122.03976, 36.98163], [-122.04033, 36.98174], [-122.04042, 36.98198], [-122.04035, 36.98198], [-122.03991, 36.98222], [-122.0394, 36.98218], [-122.03898, 36.98231], [-122.03898, 36.98233], [-122.03905, 36.98236], [-122.0393, 36.98253], [-122.03959, 36.98268], [-122.03993, 36.98291], [-122.03978, 36.98305], [-122.04102, 36.9839], [-122.04181, 36.98436], [-122.04268, 36.9851]]]} | Open Access 1 | 16778 | Harvey West Park | 19729 | 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 | 44.086 | Harvey West Park | 0 | Local Park 2 | 4 | |
2323 | 2323 | 2322 | {"type": "Polygon", "coordinates": [[[-122.00075, 36.98632], [-122.00054, 36.98677], [-122.00016, 36.98666], [-122.00036, 36.9862], [-122.00075, 36.98632]]]} | Open Access 1 | 17039 | John Franks Park | 20441 | 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.48 | John Franks Park | 0 | Local Park 2 | 4 | |
8034 | 8034 | 8033 | {"type": "Polygon", "coordinates": [[[-122.03324, 36.962], [-122.03312, 36.96215], [-122.03268, 36.96185], [-122.03253, 36.96171], [-122.03208, 36.96143], [-122.03187, 36.96126], [-122.03135, 36.96095], [-122.03103, 36.96081], [-122.03076, 36.96073], [-122.03035, 36.96069], [-122.03006, 36.96068], [-122.02971, 36.9607], [-122.02957, 36.96075], [-122.02937, 36.96078], [-122.02923, 36.96082], [-122.02867, 36.96102], [-122.02833, 36.96126], [-122.02823, 36.96113], [-122.0285, 36.96096], [-122.02844, 36.96084], [-122.0293, 36.96053], [-122.03016, 36.96049], [-122.0308, 36.96054], [-122.03132, 36.96072], [-122.03324, 36.962]]]} | Open Access 1 | 47748 | La Barranca Park | 31557 | 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 | 2.558 | La Barranca Park | 0 | Local Park 2 | 4 | |
5145 | 5145 | 5144 | {"type": "Polygon", "coordinates": [[[-122.02849, 36.9697], [-122.02756, 36.9698], [-122.02735, 36.96901], [-122.0282, 36.96891], [-122.02849, 36.9697]]]} | Open Access 1 | 17304 | Laurel Park | 21102 | 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 | 1.769 | Laurel Park | 0 | Local Park 2 | 4 | |
2438 | 2438 | 2437 | {"type": "Polygon", "coordinates": [[[-122.02863, 36.95593], [-122.02861, 36.95596], [-122.02851, 36.956], [-122.02848, 36.95631], [-122.02793, 36.95627], [-122.02794, 36.95613], [-122.02828, 36.95611], [-122.0283, 36.95594], [-122.02856, 36.95592], [-122.02855, 36.95583], [-122.02858, 36.95589], [-122.02863, 36.95593]]]} | Open Access 1 | 17339 | Lighthouse Avenue Park | 21230 | 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.353 | Lighthouse Avenue Park | 0 | Local Park 2 | 4 | |
10192 | 10192 | 10191 | {"type": "MultiPolygon", "coordinates": [[[[-122.01868, 36.96877], [-122.01776, 36.96884], [-122.01776, 36.96884], [-122.01777, 36.96872], [-122.01868, 36.96877]]], [[[-122.02196, 36.9699], [-122.02157, 36.9693], [-122.02145, 36.96919], [-122.0213, 36.9691], [-122.02102, 36.96902], [-122.01961, 36.96879], [-122.01961, 36.96875], [-122.01964, 36.96871], [-122.01975, 36.96866], [-122.01999, 36.96861], [-122.02034, 36.96862], [-122.02092, 36.96876], [-122.02124, 36.96888], [-122.02152, 36.96905], [-122.02174, 36.96928], [-122.02185, 36.96951], [-122.02196, 36.9699]]], [[[-122.02199, 36.97037], [-122.02192, 36.97061], [-122.02192, 36.9711], [-122.02181, 36.97136], [-122.02165, 36.97155], [-122.02162, 36.97156], [-122.02157, 36.97153], [-122.0216, 36.97154], [-122.02165, 36.97153], [-122.02178, 36.97134], [-122.02185, 36.97105], [-122.02181, 36.97064], [-122.0219, 36.97038], [-122.02199, 36.97037]]]]} | Open Access 1 | 17823 | Mike Fox Park | 22212 | 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 | 1.596 | Mike Fox Park | 0 | Local Park 2 | 4 | |
8033 | 8033 | 8032 | {"type": "Polygon", "coordinates": [[[-122.02249, 36.97118], [-122.02245, 36.97129], [-122.02235, 36.97138], [-122.02232, 36.97139], [-122.02224, 36.97135], [-122.02216, 36.97136], [-122.02212, 36.97139], [-122.0221, 36.97143], [-122.02209, 36.97151], [-122.02204, 36.97153], [-122.02199, 36.97152], [-122.0221, 36.9713], [-122.02215, 36.97116], [-122.02217, 36.97098], [-122.02217, 36.97074], [-122.02221, 36.97055], [-122.02225, 36.97048], [-122.02233, 36.97054], [-122.02248, 36.971], [-122.02249, 36.97118]]]} | Open Access 1 | 47743 | Mimi De Marta Dog Park | 31552 | 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.582 | Mimi De Marta Dog Park | 0 | Local Park 2 | 4 | |
10214 | 10214 | 10213 | {"type": "Polygon", "coordinates": [[[-122.03044, 36.97831], [-122.02973, 36.97823], [-122.02988, 36.97749], [-122.03014, 36.97746], [-122.03044, 36.97831]]]} | Open Access 1 | 17863 | Mission Plaza Park | 22309 | 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.937 | Mission Plaza Park | 0 | Local Park 2 | 4 | |
10295 | 10295 | 10294 | {"type": "MultiPolygon", "coordinates": [[[[-122.03531, 36.96338], [-122.03531, 36.96359], [-122.03313, 36.96215], [-122.03324, 36.962], [-122.03531, 36.96338]]], [[[-122.03528, 36.96378], [-122.03526, 36.96405], [-122.03416, 36.96371], [-122.03415, 36.96372], [-122.03417, 36.96386], [-122.03416, 36.96406], [-122.03419, 36.96417], [-122.03422, 36.96421], [-122.03422, 36.96434], [-122.03426, 36.96446], [-122.03425, 36.96451], [-122.03421, 36.96456], [-122.03428, 36.9646], [-122.03438, 36.96459], [-122.03441, 36.96463], [-122.0344, 36.9647], [-122.03431, 36.96482], [-122.03426, 36.96494], [-122.03425, 36.96502], [-122.03427, 36.96512], [-122.03431, 36.9652], [-122.03437, 36.96529], [-122.03457, 36.96543], [-122.03465, 36.96552], [-122.03477, 36.9657], [-122.0348, 36.9658], [-122.03481, 36.96589], [-122.03478, 36.96601], [-122.03474, 36.96604], [-122.03469, 36.96605], [-122.03463, 36.96602], [-122.03449, 36.96592], [-122.0344, 36.96581], [-122.03433, 36.96577], [-122.0342, 36.96577], [-122.03414, 36.9658], [-122.03409, 36.96584], [-122.03406, 36.96596], [-122.03405, 36.96616], [-122.0341, 36.9662], [-122.03419, 36.96622], [-122.03421, 36.96624], [-122.03418, 36.96634], [-122.03411, 36.9664], [-122.03411, 36.96647], [-122.03413, 36.96653], [-122.03423, 36.96664], [-122.03429, 36.96674], [-122.03434, 36.96686], [-122.03434, 36.96695], [-122.03431, 36.96706], [-122.03423, 36.96716], [-122.03411, 36.96722], [-122.034, 36.96723], [-122.03386, 36.96721], [-122.03385, 36.96717], [-122.03369, 36.96714], [-122.03373, 36.96698], [-122.03367, 36.96648], [-122.03363, 36.96629], [-122.03361, 36.96598], [-122.03355, 36.9659], [-122.03355, 36.96563], [-122.03353, 36.96552], [-122.03358, 36.96539], [-122.03357, 36.96511], [-122.03364, 36.96505], [-122.03362, 36.96471], [-122.03311, 36.96443], [-122.03305, 36.96431], [-122.03251, 36.96408], [-122.0324, 36.96411], [-122.03209, 36.96394], [-122.03195, 36.96405], [-122.03157, 36.96414], [-122.03118, 36.96414], [-122.03073, 36.9655], [-122.03044, 36.96557], [-122.03041, 36.96549], [-122.03047, 36.96536], [-122.03046, 36.96523], [-122.03044, 36.96514], [-122.03034, 36.96505], [-122.03018, 36.96498], [-122.03003, 36.96497], [-122.02984, 36.96489], [-122.02967, 36.9648], [-122.0295, 36.96479], [-122.02935, 36.96475], [-122.02923, 36.96466], [-122.0291, 36.9645], [-122.0289, 36.96431], [-122.02876, 36.96423], [-122.02841, 36.96395], [-122.02805, 36.96355], [-122.02796, 36.96353], [-122.02789, 36.96354], [-122.02784, 36.96358], [-122.0278, 36.96366], [-122.02773, 36.9637], [-122.02767, 36.96347], [-122.0275, 36.96347], [-122.02762, 36.96289], [-122.02767, 36.96274], [-122.02812, 36.96176], [-122.02833, 36.96151], [-122.02862, 36.96125], [-122.02883, 36.96111], [-122.02911, 36.96098], [-122.02918, 36.96105], [-122.02904, 36.96118], [-122.02909, 36.96131], [-122.02909, 36.96137], [-122.02895, 36.96157], [-122.02899, 36.96167], [-122.02918, 36.96176], [-122.02938, 36.96165], [-122.02944, 36.96165], [-122.02947, 36.9617], [-122.02948, 36.9618], [-122.02954, 36.96186], [-122.02967, 36.9619], [-122.02986, 36.96204], [-122.03047, 36.96219], [-122.03077, 36.96231], [-122.03087, 36.96232], [-122.03126, 36.96248], [-122.03143, 36.96249], [-122.03162, 36.96237], [-122.03173, 36.96236], [-122.03183, 36.96238], [-122.03201, 36.96254], [-122.03213, 36.96258], [-122.03229, 36.96255], [-122.03245, 36.96243], [-122.03265, 36.96242], [-122.03279, 36.96252], [-122.03274, 36.96258], [-122.03275, 36.96259], [-122.03309, 36.96272], [-122.03319, 36.9628], [-122.03359, 36.96279], [-122.03375, 36.9628], [-122.03528, 36.96378]]]]} | Open Access 1 | 18088 | Neary Lagoon Park | 22680 | 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 | 41.943 | Neary Lagoon 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]);