units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
45 rows where MNG_AGENCY = 54 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5840 | 5840 | 5839 | {"type": "MultiPolygon", "coordinates": [[[[-121.66048, 36.68583], [-121.66037, 36.68604], [-121.65716, 36.68488], [-121.65716, 36.68576], [-121.65555, 36.68496], [-121.65653, 36.68427], [-121.65639, 36.68373], [-121.65615, 36.68322], [-121.65705, 36.68234], [-121.65718, 36.68239], [-121.6569, 36.68259], [-121.65636, 36.68308], [-121.65629, 36.68318], [-121.65628, 36.68325], [-121.65629, 36.68333], [-121.65644, 36.68358], [-121.65658, 36.68399], [-121.65659, 36.68411], [-121.65658, 36.68422], [-121.65652, 36.68435], [-121.65644, 36.68445], [-121.6563, 36.68455], [-121.65628, 36.68471], [-121.65676, 36.68476], [-121.65686, 36.6848], [-121.65697, 36.68478], [-121.65773, 36.68486], [-121.65774, 36.68495], [-121.65783, 36.68501], [-121.65798, 36.68503], [-121.6597, 36.68562], [-121.66027, 36.68574], [-121.66045, 36.68579], [-121.66048, 36.68583]]], [[[-121.66133, 36.68611], [-121.66121, 36.68633], [-121.66111, 36.68642], [-121.66104, 36.68645], [-121.66099, 36.68644], [-121.6608, 36.68634], [-121.66055, 36.68625], [-121.6605, 36.6862], [-121.6605, 36.68618], [-121.66067, 36.68588], [-121.66133, 36.68611]]], [[[-121.66662, 36.68802], [-121.66647, 36.68815], [-121.66626, 36.68829], [-121.66588, 36.68816], [-121.66579, 36.68819], [-121.66555, 36.68813], [-121.66537, 36.68796], [-121.66513, 36.68786], [-121.66486, 36.68779], [-121.66459, 36.68776], [-121.66439, 36.68764], [-121.66426, 36.68764], [-121.66404, 36.68766], [-121.66406, 36.68761], [-121.66405, 36.68756], [-121.66402, 36.68751], [-121.66398, 36.68748], [-121.6639, 36.68746], [-121.66383, 36.68747], [-121.66381, 36.68742], [-121.66318, 36.6872], [-121.66311, 36.68722], [-121.66303, 36.68714], [-121.66296, 36.68713], [-121.66289, 36.68714], [-121.66287, 36.68709], [-121.66228, 36.68688], [-121.66217, 36.68688], [-121.66211, 36.68681], [-121.66204, 36.68679], [-121.66197, 36.68679], [-121.66195, 36.68675], [-121.66151, 36.68658], [-121.66118, 36.68666], [-121.66116, 36.68659], [-121.66117, 36.68656], [-121.66133, 36.68643], [-121.66143, 36.68629], [-121.66148, 36.68628], [-121.66222, 36.68655], [-121.66227, 36.68659], [-121.66231, 36.68669], [-121.66238, 36.68674], [-121.66249, 36.68674], [-121.66256, 36.6867], [-121.6626, 36.68664], [-121.66272, 36.68666], [-121.66274, 36.68662], [-121.66304, 36.6867], [-121.66298, 36.68677], [-121.66297, 36.68682], [-121.66299, 36.68689], [-121.66306, 36.68694], [-121.66321, 36.68695], [-121.66551, 36.68777], [-121.66577, 36.68779], [-121.66591, 36.68777], [-121.66608, 36.68772], [-121.66662, 36.68802]]], [[[-121.67086, 36.68921], [-121.67046, 36.68961], [-121.67024, 36.68986], [-121.67035, 36.68963], [-121.67032, 36.68957], [-121.66861, 36.68909], [-121.66685, 36.68846], [-121.66681, 36.68849], [-121.66648, 36.68836], [-121.6668, 36.68809], [-121.66683, 36.68808], [-121.66723, 36.68828], [-121.66802, 36.68856], [-121.66813, 36.68863], [-121.6682, 36.68864], [-121.66826, 36.68863], [-121.6685, 36.68875], [-121.66861, 36.68878], [-121.66897, 36.68878], [-121.669, 36.68882], [-121.66905, 36.68886], [-121.66913, 36.68887], [-121.6692, 36.68885], [-121.66928, 36.68894], [-121.6695, 36.689], [-121.66978, 36.68904], [-121.6698, 36.68911], [-121.66988, 36.68917], [-121.66999, 36.68917], [-121.67007, 36.68911], [-121.67032, 36.68922], [-121.67043, 36.68924], [-121.67064, 36.68926], [-121.67086, 36.68921]]]]} | Open Access 1 | 174 | Rossi Rico Linear Parkway | 24678 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 12.435 | Rossi Rico Linear Parkway | 0 | Local Recreation Area 3 | 4 | |
5876 | 5876 | 5875 | {"type": "Polygon", "coordinates": [[[-121.66749, 36.67701], [-121.66553, 36.67727], [-121.6652, 36.67569], [-121.66716, 36.67543], [-121.66749, 36.67701]]]} | Open Access 1 | 261 | Salinas Central Park | 24797 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 7.777 | Salinas Central Park | 0 | Local Park 2 | 4 | |
15650 | 15650 | 15649 | {"type": "MultiPolygon", "coordinates": [[[[-121.61714, 36.67139], [-121.61624, 36.67188], [-121.61627, 36.67228], [-121.61205, 36.67257], [-121.60965, 36.67074], [-121.60818, 36.6702], [-121.6081, 36.6701], [-121.60753, 36.67042], [-121.60614, 36.66886], [-121.6055, 36.66922], [-121.60452, 36.66831], [-121.60718, 36.6665], [-121.60956, 36.66946], [-121.6102, 36.66988], [-121.61079, 36.66966], [-121.61136, 36.66929], [-121.6109, 36.66843], [-121.61229, 36.66778], [-121.61411, 36.66975], [-121.6152, 36.66916], [-121.61714, 36.67139]]], [[[-121.62255, 36.66852], [-121.62227, 36.66914], [-121.6224, 36.66928], [-121.62156, 36.66977], [-121.62132, 36.66952], [-121.61988, 36.67028], [-121.62003, 36.67047], [-121.61847, 36.67132], [-121.6183, 36.67128], [-121.61768, 36.67164], [-121.61417, 36.66766], [-121.61536, 36.66706], [-121.61478, 36.6664], [-121.61593, 36.66583], [-121.61652, 36.66648], [-121.61725, 36.66613], [-121.61763, 36.66655], [-121.61907, 36.66582], [-121.62035, 36.66562], [-121.62038, 36.66596], [-121.62102, 36.66665], [-121.62149, 36.6684], [-121.62172, 36.66852], [-121.62201, 36.66858], [-121.62255, 36.66852]]]]} | Restricted Access 2 | 268 | Salinas Fairways Golf Course | 32985 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 145.929 | Salinas Fairways GC | 0 | Local Recreation Area 3 | 4 | |
139 | 139 | 138 | {"type": "Polygon", "coordinates": [[[-121.62037, 36.68583], [-121.61877, 36.68675], [-121.61779, 36.68563], [-121.61818, 36.68539], [-121.61827, 36.68538], [-121.61842, 36.6853], [-121.61842, 36.68528], [-121.61852, 36.68526], [-121.6186, 36.68529], [-121.61865, 36.68536], [-121.61874, 36.68537], [-121.61916, 36.68584], [-121.61999, 36.68539], [-121.62037, 36.68583]]]} | Open Access 1 | 442 | Sanborn Neighborhood Park | 25004 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 4.539 | Sanborn Neighborhood Park | 0 | Local Park 2 | 4 | |
188 | 188 | 187 | {"type": "Polygon", "coordinates": [[[-121.65097, 36.72554], [-121.65096, 36.72568], [-121.65085, 36.72602], [-121.6503, 36.72616], [-121.64992, 36.72621], [-121.64989, 36.7262], [-121.64984, 36.72593], [-121.64986, 36.72575], [-121.65001, 36.72574], [-121.65097, 36.72554]]]} | Open Access 1 | 603 | Santa Rita Park | 25125 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.227 | Santa Rita Park | 0 | Local Park 2 | 4 | |
291 | 291 | 290 | {"type": "Polygon", "coordinates": [[[-121.65217, 36.69015], [-121.65159, 36.69783], [-121.64807, 36.6977], [-121.64676, 36.69741], [-121.64651, 36.69696], [-121.64646, 36.69678], [-121.64645, 36.6966], [-121.64683, 36.69195], [-121.6462, 36.69108], [-121.64785, 36.69036], [-121.64948, 36.69], [-121.6521, 36.69007], [-121.65215, 36.6901], [-121.65217, 36.69015]]]} | Open Access 1 | 790 | Sherwood Park | 25403 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 96.826 | Sherwood Park | 0 | Local Park 2 | 4 | |
263 | 263 | 262 | {"type": "Polygon", "coordinates": [[[-121.60427, 36.6889], [-121.60339, 36.68923], [-121.60329, 36.68903], [-121.60316, 36.68881], [-121.60301, 36.6886], [-121.60264, 36.68816], [-121.60264, 36.68811], [-121.60325, 36.68776], [-121.60427, 36.6889]]]} | Open Access 1 | 897 | Soberanes Park | 25586 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 2.722 | Soberanes Park | 0 | Local Park 2 | 4 | |
2805 | 2805 | 2804 | {"type": "Polygon", "coordinates": [[[-121.65616, 36.72516], [-121.65615, 36.7258], [-121.65563, 36.7258], [-121.65567, 36.72576], [-121.65568, 36.72571], [-121.65567, 36.72566], [-121.65564, 36.72561], [-121.6556, 36.72559], [-121.65553, 36.72558], [-121.65543, 36.7256], [-121.65542, 36.72514], [-121.65612, 36.72513], [-121.65616, 36.72516]]]} | Open Access 1 | 938 | Soto Square Park | 25632 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.073 | Soto Square Park | 0 | Local Park 2 | 4 | |
6118 | 6118 | 6117 | {"type": "Polygon", "coordinates": [[[-121.61792, 36.70759], [-121.61769, 36.70755], [-121.61611, 36.70763], [-121.61608, 36.70696], [-121.61729, 36.70692], [-121.61734, 36.70663], [-121.6174, 36.70665], [-121.61754, 36.70673], [-121.61776, 36.70699], [-121.61804, 36.70721], [-121.61805, 36.70725], [-121.61792, 36.70759]]]} | Open Access 1 | 1088 | Steinbeck Park | 25825 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 3.147 | Steinbeck Park | 0 | Local Park 2 | 4 | |
2945 | 2945 | 2944 | {"type": "Polygon", "coordinates": [[[-121.59687, 36.69074], [-121.59638, 36.69086], [-121.59588, 36.69102], [-121.59556, 36.69116], [-121.59504, 36.69145], [-121.59498, 36.69144], [-121.59445, 36.69082], [-121.59625, 36.68982], [-121.59673, 36.69038], [-121.59687, 36.69074]]]} | Open Access 1 | 1901 | Williams Ranch Neighborhood Park | 27566 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 4.595 | Williams Ranch Neighborhood Park | 0 | Local Park 2 | 4 | |
6452 | 6452 | 6451 | {"type": "Polygon", "coordinates": [[[-121.66678, 36.66216], [-121.66653, 36.6623], [-121.66633, 36.66247], [-121.66617, 36.66266], [-121.66606, 36.66289], [-121.66475, 36.66239], [-121.66498, 36.66174], [-121.66678, 36.66216]]]} | Open Access 1 | 1982 | Woodside Park | 27742 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 2.977 | Woodside Park | 0 | Local Park 2 | 4 | |
832 | 832 | 831 | {"type": "Polygon", "coordinates": [[[-121.63752, 36.67956], [-121.63746, 36.67966], [-121.63621, 36.68089], [-121.63611, 36.68096], [-121.63597, 36.68103], [-121.6358, 36.68108], [-121.63508, 36.6812], [-121.63494, 36.68121], [-121.63422, 36.68115], [-121.63433, 36.68028], [-121.63237, 36.67947], [-121.63175, 36.67992], [-121.62945, 36.68037], [-121.62906, 36.68053], [-121.6288, 36.68027], [-121.6285, 36.68005], [-121.62853, 36.68001], [-121.62833, 36.67989], [-121.62875, 36.67962], [-121.62899, 36.67954], [-121.62933, 36.6792], [-121.6294, 36.67897], [-121.62938, 36.67876], [-121.62926, 36.67865], [-121.62909, 36.67845], [-121.62997, 36.67864], [-121.62997, 36.67868], [-121.63031, 36.67883], [-121.63081, 36.67887], [-121.6314, 36.67873], [-121.63142, 36.6787], [-121.63148, 36.67869], [-121.63156, 36.67813], [-121.63279, 36.6784], [-121.63486, 36.67951], [-121.63503, 36.67953], [-121.63501, 36.67958], [-121.63502, 36.67959], [-121.6353, 36.67964], [-121.63635, 36.67962], [-121.63752, 36.67956]]]} | Open Access 1 | 5409 | Cesar Chavez Community Park | 17092 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 27.823 | Cesar Chavez Community Park | 0 | Local Park 2 | 4 | |
6850 | 6850 | 6849 | {"type": "Polygon", "coordinates": [[[-121.6295, 36.67854], [-121.62937, 36.67851], [-121.62925, 36.6784], [-121.62832, 36.67814], [-121.62813, 36.67793], [-121.6274, 36.67797], [-121.62741, 36.67795], [-121.6281, 36.6779], [-121.628, 36.67779], [-121.62827, 36.67726], [-121.62832, 36.67693], [-121.62815, 36.67652], [-121.62822, 36.67652], [-121.62839, 36.67693], [-121.62834, 36.67727], [-121.62868, 36.67723], [-121.62893, 36.67724], [-121.62893, 36.67726], [-121.62872, 36.67727], [-121.62881, 36.67758], [-121.62878, 36.67759], [-121.62867, 36.67726], [-121.62833, 36.6773], [-121.62809, 36.67778], [-121.62837, 36.67809], [-121.62932, 36.67836], [-121.6295, 36.67854]]]} | Open Access 1 | 5501 | Cesar Chavez Park Access | 17101 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.594 | Cesar Chavez Park Access | 0 | Local Recreation Area 3 | 4 | |
7535 | 7535 | 7534 | {"type": "Polygon", "coordinates": [[[-121.64974, 36.65505], [-121.64922, 36.65654], [-121.64854, 36.65624], [-121.64808, 36.65611], [-121.64804, 36.65608], [-121.64804, 36.65605], [-121.6485, 36.65476], [-121.64974, 36.65505]]]} | Open Access 1 | 7115 | Claremont Manor Park | 17382 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 4.607 | Claremont Manor Park | 0 | Local Park 2 | 4 | |
1133 | 1133 | 1132 | {"type": "Polygon", "coordinates": [[[-121.6595, 36.67057], [-121.65909, 36.67063], [-121.659, 36.67022], [-121.65942, 36.67016], [-121.6595, 36.67057]]]} | Open Access 1 | 7220 | Clay Park | 17397 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.426 | Clay Park | 0 | Local Park 2 | 4 | |
7646 | 7646 | 7645 | {"type": "Polygon", "coordinates": [[[-121.61693, 36.68094], [-121.61447, 36.68234], [-121.61441, 36.68232], [-121.61381, 36.6816], [-121.61382, 36.68156], [-121.61626, 36.68018], [-121.61693, 36.68094]]]} | Open Access 1 | 7473 | Closter Park | 17432 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 6.937 | Closter Park | 0 | Local Park 2 | 4 | |
7910 | 7910 | 7909 | {"type": "Polygon", "coordinates": [[[-121.6483, 36.67085], [-121.648, 36.67068], [-121.648, 36.67068], [-121.64825, 36.6706], [-121.6483, 36.67085]]]} | Open Access 1 | 10245 | Cornell Park | 17639 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.084 | Cornell Park | 0 | Local Park 2 | 4 | |
1537 | 1537 | 1536 | {"type": "Polygon", "coordinates": [[[-121.61028, 36.70424], [-121.61018, 36.70453], [-121.60947, 36.70555], [-121.60894, 36.70532], [-121.60905, 36.70516], [-121.60966, 36.7045], [-121.6099, 36.70418], [-121.60995, 36.70416], [-121.61001, 36.70415], [-121.61028, 36.70424]]]} | Open Access 1 | 11239 | Creekbridge Neighborhood Park | 17766 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.816 | Creekbridge Neighborhood Park | 0 | Local Park 2 | 4 | |
8718 | 8718 | 8717 | {"type": "Polygon", "coordinates": [[[-121.61997, 36.68055], [-121.61932, 36.68092], [-121.61903, 36.68059], [-121.61968, 36.68022], [-121.61997, 36.68055]]]} | Open Access 1 | 14152 | East Laurel Pocket Park | 18375 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.803 | East Laurel PP | 0 | Local Park 2 | 4 | |
8902 | 8902 | 8901 | {"type": "Polygon", "coordinates": [[[-121.63983, 36.71043], [-121.63971, 36.71072], [-121.63951, 36.71079], [-121.63948, 36.71087], [-121.6396, 36.71101], [-121.63942, 36.71147], [-121.6385, 36.71111], [-121.63788, 36.71092], [-121.63724, 36.71077], [-121.63624, 36.71061], [-121.6362, 36.71058], [-121.63686, 36.70851], [-121.6369, 36.70848], [-121.63892, 36.70898], [-121.63896, 36.7089], [-121.63939, 36.709], [-121.63935, 36.70916], [-121.63938, 36.70932], [-121.6397, 36.70941], [-121.63967, 36.70948], [-121.63961, 36.71013], [-121.63983, 36.71043]]]} | Open Access 1 | 14598 | El Dorado Park | 18507 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 17.014 | El Dorado 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]);