units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where AGNCY_NAME = 353 and DES_TP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1394 | 1394 | 1393 | {"type": "Polygon", "coordinates": [[[-117.62306, 33.42856], [-117.62324, 33.42857], [-117.62333, 33.42861], [-117.62396, 33.4291], [-117.62401, 33.42916], [-117.62405, 33.42927], [-117.62405, 33.42935], [-117.62397, 33.42949], [-117.62358, 33.42985], [-117.6235, 33.42989], [-117.62342, 33.42991], [-117.62326, 33.4299], [-117.62316, 33.42988], [-117.62306, 33.42983], [-117.62246, 33.42934], [-117.62243, 33.42928], [-117.6224, 33.42912], [-117.62241, 33.42906], [-117.62247, 33.42896], [-117.62257, 33.42885], [-117.62285, 33.42862], [-117.62292, 33.42858], [-117.62306, 33.42856]]]} | Open Access 1 | 8613 | Max Berg Plaza Park | 21965 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 3.789 | Max Berg Plaza Park | 0 | Local Park 2 | 4 | |
2349 | 2349 | 2348 | {"type": "Polygon", "coordinates": [[[-117.5977, 33.40721], [-117.59745, 33.40729], [-117.59729, 33.40699], [-117.59714, 33.40707], [-117.59581, 33.40581], [-117.59591, 33.40586], [-117.596, 33.40586], [-117.5961, 33.40585], [-117.59684, 33.40559], [-117.5975, 33.40681], [-117.5977, 33.40721]]]} | Open Access 1 | 11153 | San Luis Rey Park | 24940 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 2.947 | San Luis Rey Park | 0 | Local Park 2 | 4 | |
4890 | 4890 | 4889 | {"type": "Polygon", "coordinates": [[[-117.61198, 33.41163], [-117.61162, 33.41191], [-117.61146, 33.41186], [-117.61188, 33.41153], [-117.61198, 33.41163]]]} | Open Access 1 | 30272 | Leslie Park | 21181 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 0.173 | Leslie Park | 0 | Local Park 2 | 4 | |
5585 | 5585 | 5584 | {"type": "Polygon", "coordinates": [[[-117.61157, 33.41111], [-117.61151, 33.41115], [-117.61107, 33.41104], [-117.61083, 33.41078], [-117.61111, 33.41061], [-117.61122, 33.41075], [-117.61157, 33.41111]]]} | Open Access 1 | 44156 | Leslie Park | 21181 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 0.441 | Leslie Park | 0 | Local Park 2 | 4 | |
6614 | 6614 | 6613 | {"type": "MultiPolygon", "coordinates": [[[[-117.6224, 33.42433], [-117.62217, 33.42405], [-117.62199, 33.4241], [-117.62191, 33.4241], [-117.62169, 33.42421], [-117.62171, 33.42445], [-117.62144, 33.42439], [-117.62128, 33.42448], [-117.62125, 33.42441], [-117.62112, 33.42438], [-117.62104, 33.4244], [-117.62094, 33.42456], [-117.6208, 33.42438], [-117.6215, 33.42395], [-117.62181, 33.42362], [-117.62188, 33.42358], [-117.62229, 33.42405], [-117.62237, 33.42421], [-117.6224, 33.42433]]], [[[-117.62304, 33.42322], [-117.62301, 33.42327], [-117.62291, 33.42333], [-117.62295, 33.42346], [-117.62273, 33.42356], [-117.62279, 33.42368], [-117.62274, 33.42372], [-117.62267, 33.42364], [-117.62256, 33.42368], [-117.62238, 33.42404], [-117.62217, 33.42381], [-117.62228, 33.42374], [-117.62236, 33.42376], [-117.62256, 33.42362], [-117.62259, 33.42349], [-117.6225, 33.42333], [-117.62288, 33.42314], [-117.623, 33.42313], [-117.62304, 33.42322]]]]} | Open Access 1 | 4200 | Linda Lane Park | 21280 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 1.918 | Linda Lane Park | 0 | Local Park 2 | 4 | |
7690 | 7690 | 7689 | {"type": "Polygon", "coordinates": [[[-117.62465, 33.43337], [-117.62464, 33.43341], [-117.62435, 33.43378], [-117.62432, 33.43379], [-117.62426, 33.43376], [-117.6242, 33.43348], [-117.62417, 33.43343], [-117.62412, 33.43337], [-117.62403, 33.43332], [-117.62363, 33.43325], [-117.62358, 33.43335], [-117.62299, 33.43334], [-117.62298, 33.4334], [-117.62284, 33.43346], [-117.62278, 33.43346], [-117.62278, 33.43364], [-117.62264, 33.43373], [-117.62251, 33.43383], [-117.62226, 33.43407], [-117.62215, 33.43421], [-117.62209, 33.43424], [-117.62178, 33.43406], [-117.62173, 33.43402], [-117.62167, 33.43394], [-117.62166, 33.43387], [-117.62166, 33.43379], [-117.62169, 33.43373], [-117.62181, 33.43358], [-117.62185, 33.43348], [-117.62211, 33.43334], [-117.62207, 33.43324], [-117.62215, 33.43318], [-117.6221, 33.43308], [-117.6221, 33.43306], [-117.622, 33.43299], [-117.62196, 33.43303], [-117.62183, 33.43294], [-117.62165, 33.43315], [-117.62151, 33.4331], [-117.62088, 33.43307], [-117.61997, 33.43286], [-117.61911, 33.43277], [-117.61876, 33.4327], [-117.61874, 33.43269], [-117.61873, 33.43266], [-117.61877, 33.43263], [-117.61951, 33.43243], [-117.61989, 33.43238], [-117.62007, 33.43232], [-117.62021, 33.43232], [-117.62028, 33.43233], [-117.62021, 33.43264], [-117.62057, 33.43271], [-117.62118, 33.43278], [-117.62135, 33.43274], [-117.62159, 33.43286], [-117.62183, 33.43262], [-117.62187, 33.43261], [-117.62189, 33.43257], [-117.62194, 33.43251], [-117.62216, 33.43262], [-117.62238, 33.43228], [-117.62194, 33.43206], [-117.62196, 33.432], [-117.62172, 33.43192], [-117.62169, 33.43162], [-117.6219, 33.43182], [-117.62214, 33.43198], [-117.6224, 33.43211], [-117.62243, 33.43215], [-117.62248, 33.43245], [-117.62255, 33.43256], [-117.62263, 33.43262], [-117.62428, 33.43322], [-117.62465, 33.43337]]]} | Open Access 1 | 7680 | Bonita Canyon Park | 16257 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 8.284 | Bonita Canyon Park | 0 | Local Park 2 | 4 | |
7988 | 7988 | 7987 | {"type": "Polygon", "coordinates": [[[-117.64413, 33.45228], [-117.64406, 33.45224], [-117.64397, 33.45233], [-117.64367, 33.45216], [-117.64364, 33.45204], [-117.64236, 33.4514], [-117.64038, 33.44959], [-117.63954, 33.44907], [-117.63903, 33.44882], [-117.63922, 33.44872], [-117.63934, 33.44884], [-117.64005, 33.44927], [-117.64022, 33.44935], [-117.64042, 33.44939], [-117.64066, 33.44936], [-117.64081, 33.4493], [-117.64093, 33.44923], [-117.64139, 33.44891], [-117.64202, 33.4486], [-117.64207, 33.44861], [-117.64224, 33.44873], [-117.64237, 33.4488], [-117.64258, 33.44887], [-117.64309, 33.449], [-117.64323, 33.44907], [-117.6438, 33.44949], [-117.64392, 33.44961], [-117.64413, 33.45002], [-117.64467, 33.45092], [-117.64478, 33.45105], [-117.64502, 33.45122], [-117.64505, 33.45127], [-117.64504, 33.4513], [-117.64413, 33.45228]]]} | Open Access 1 | 10933 | San Gorgonio Park | 24902 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 22.652 | San Gorgonio Park | 0 | Local Park 2 | 4 | |
9113 | 9113 | 9112 | {"type": "Polygon", "coordinates": [[[-117.59198, 33.40952], [-117.59148, 33.40998], [-117.59172, 33.41001], [-117.59137, 33.41021], [-117.59133, 33.41029], [-117.59143, 33.41049], [-117.59172, 33.41088], [-117.59167, 33.41088], [-117.59104, 33.41109], [-117.5906, 33.41189], [-117.58959, 33.41176], [-117.59028, 33.40933], [-117.59038, 33.40938], [-117.59033, 33.40945], [-117.59054, 33.40958], [-117.59051, 33.40964], [-117.59076, 33.40978], [-117.59107, 33.40943], [-117.591, 33.40938], [-117.59129, 33.40905], [-117.59155, 33.40919], [-117.59179, 33.40888], [-117.59198, 33.40952]]]} | Open Access 1 | 15104 | Vista Bahia Park | 27164 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 9.159 | Vista Bahia Park | 0 | Local Park 2 | 4 | |
11978 | 11978 | 11977 | {"type": "Polygon", "coordinates": [[[-117.6015, 33.46911], [-117.60151, 33.46918], [-117.60125, 33.46963], [-117.60124, 33.46967], [-117.6012, 33.46971], [-117.60119, 33.46982], [-117.60113, 33.46995], [-117.60112, 33.47013], [-117.60109, 33.47021], [-117.60098, 33.47034], [-117.60062, 33.4706], [-117.60062, 33.47063], [-117.60057, 33.47068], [-117.60028, 33.47082], [-117.60016, 33.47084], [-117.60001, 33.47092], [-117.59979, 33.47098], [-117.59972, 33.47104], [-117.59965, 33.47111], [-117.59951, 33.47137], [-117.59933, 33.47157], [-117.59921, 33.47177], [-117.59917, 33.47189], [-117.59916, 33.47224], [-117.59912, 33.47239], [-117.59904, 33.4725], [-117.59906, 33.47253], [-117.59892, 33.47263], [-117.59884, 33.47278], [-117.59871, 33.47274], [-117.59876, 33.47262], [-117.59897, 33.4724], [-117.59901, 33.47229], [-117.59846, 33.47224], [-117.59844, 33.47222], [-117.59815, 33.47219], [-117.59813, 33.47215], [-117.59797, 33.47214], [-117.59795, 33.47212], [-117.59799, 33.47179], [-117.59802, 33.47175], [-117.59801, 33.47159], [-117.59793, 33.47146], [-117.59784, 33.47136], [-117.59785, 33.47128], [-117.59807, 33.47121], [-117.59836, 33.47115], [-117.59844, 33.47112], [-117.59856, 33.47105], [-117.59878, 33.47086], [-117.59882, 33.47077], [-117.59886, 33.47073], [-117.59901, 33.47065], [-117.5991, 33.47057], [-117.59919, 33.47045], [-117.59924, 33.47034], [-117.59938, 33.4703], [-117.5994, 33.47027], [-117.59954, 33.47026], [-117.59957, 33.47028], [-117.59984, 33.47024], [-117.59999, 33.47018], [-117.60018, 33.47004], [-117.60028, 33.46993], [-117.60083, 33.46963], [-117.60138, 33.46913], [-117.60145, 33.4691], [-117.6015, 33.46911]]]} | Open Access 1 | 24610 | Liberty Park | 21211 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 8.971 | Liberty Park | 0 | Local Park 2 | 4 | |
11979 | 11979 | 11978 | {"type": "Polygon", "coordinates": [[[-117.62297, 33.45112], [-117.62287, 33.45117], [-117.62287, 33.45163], [-117.62251, 33.4518], [-117.62191, 33.45218], [-117.62172, 33.45236], [-117.62166, 33.45238], [-117.6216, 33.45236], [-117.62131, 33.4521], [-117.6212, 33.45197], [-117.6211, 33.45183], [-117.62098, 33.45159], [-117.62241, 33.45091], [-117.62243, 33.45089], [-117.62243, 33.45082], [-117.62237, 33.45072], [-117.62267, 33.45059], [-117.62297, 33.45112]]]} | Open Access 1 | 24611 | Marblehead Park | 21791 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 4.316 | Marblehead Park | 0 | Local Park 2 | 4 | |
11980 | 11980 | 11979 | {"type": "Polygon", "coordinates": [[[-117.65667, 33.45327], [-117.65651, 33.45347], [-117.65636, 33.45338], [-117.65604, 33.45379], [-117.65609, 33.45383], [-117.65543, 33.45468], [-117.655, 33.4544], [-117.65575, 33.45345], [-117.6552, 33.45314], [-117.65544, 33.45275], [-117.6555, 33.45274], [-117.65588, 33.45285], [-117.65605, 33.45296], [-117.65615, 33.45296], [-117.65667, 33.45327]]]} | Open Access 1 | 24612 | Mira Costa Park | 22272 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 3.298 | Mira Costa Park | 0 | Local Park 2 | 4 | |
11981 | 11981 | 11980 | {"type": "Polygon", "coordinates": [[[-117.57858, 33.4586], [-117.57854, 33.4586], [-117.57851, 33.45863], [-117.57828, 33.45867], [-117.57795, 33.45873], [-117.57766, 33.45874], [-117.57741, 33.45883], [-117.57721, 33.45883], [-117.57703, 33.45878], [-117.57691, 33.45878], [-117.5767, 33.45882], [-117.57657, 33.45882], [-117.57641, 33.4588], [-117.5763, 33.45874], [-117.57621, 33.45873], [-117.57595, 33.45876], [-117.57583, 33.45875], [-117.57598, 33.45834], [-117.57619, 33.45797], [-117.57628, 33.45795], [-117.57676, 33.45797], [-117.57702, 33.45794], [-117.57723, 33.45796], [-117.57734, 33.45793], [-117.57737, 33.45785], [-117.57758, 33.45781], [-117.57802, 33.45781], [-117.57805, 33.45785], [-117.57804, 33.45792], [-117.5782, 33.45808], [-117.57835, 33.45819], [-117.5785, 33.45842], [-117.57855, 33.45847], [-117.57858, 33.45852], [-117.57856, 33.45856], [-117.57858, 33.4586]]]} | Open Access 1 | 24613 | Talega Park | 26174 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 5.183 | Talega Park | 0 | Local Park 2 | 4 | |
11982 | 11982 | 11981 | {"type": "Polygon", "coordinates": [[[-117.61598, 33.4374], [-117.61586, 33.43763], [-117.61566, 33.43775], [-117.61536, 33.43803], [-117.61506, 33.43819], [-117.61489, 33.43807], [-117.61481, 33.43804], [-117.61493, 33.43781], [-117.61491, 33.43744], [-117.61472, 33.43676], [-117.61457, 33.43645], [-117.61531, 33.43633], [-117.61557, 33.43647], [-117.61546, 33.43671], [-117.61551, 33.43682], [-117.61557, 33.43713], [-117.61598, 33.4374]]]} | Open Access 1 | 24614 | Verde Park | 26985 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 3.57 | Verde Park | 0 | Local Park 2 | 4 | |
12825 | 12825 | 12824 | {"type": "Polygon", "coordinates": [[[-117.626, 33.46479], [-117.62345, 33.46665], [-117.62333, 33.46657], [-117.62338, 33.46648], [-117.62337, 33.46638], [-117.6225, 33.4655], [-117.62241, 33.46543], [-117.62216, 33.46495], [-117.62214, 33.46489], [-117.62211, 33.46436], [-117.62199, 33.46422], [-117.62199, 33.46402], [-117.62286, 33.46414], [-117.62358, 33.4634], [-117.62387, 33.46361], [-117.62416, 33.4637], [-117.62445, 33.46375], [-117.62456, 33.46355], [-117.62455, 33.46341], [-117.62476, 33.46333], [-117.62484, 33.46333], [-117.62496, 33.46342], [-117.62537, 33.46397], [-117.626, 33.46479]]]} | Open Access 1 | 30274 | Forster Ranch Community Park | 19004 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 18.845 | Forster Ranch Community Park | 0 | Local Park 2 | 4 | |
12826 | 12826 | 12825 | {"type": "Polygon", "coordinates": [[[-117.58602, 33.48107], [-117.58596, 33.48118], [-117.58551, 33.48124], [-117.58522, 33.48131], [-117.58516, 33.48129], [-117.58489, 33.48145], [-117.58455, 33.48168], [-117.58447, 33.4816], [-117.58441, 33.48157], [-117.58428, 33.48158], [-117.58415, 33.4816], [-117.58395, 33.48169], [-117.58369, 33.48189], [-117.58353, 33.48194], [-117.58354, 33.48182], [-117.58352, 33.48174], [-117.58347, 33.4817], [-117.58346, 33.48155], [-117.58361, 33.48155], [-117.58381, 33.48151], [-117.58421, 33.48139], [-117.58432, 33.48127], [-117.58431, 33.48123], [-117.58426, 33.48117], [-117.58412, 33.48106], [-117.58404, 33.48097], [-117.58403, 33.48089], [-117.58405, 33.48073], [-117.58401, 33.48066], [-117.5841, 33.48054], [-117.58415, 33.48042], [-117.58413, 33.48031], [-117.5841, 33.48028], [-117.58404, 33.48013], [-117.58391, 33.48001], [-117.58392, 33.47991], [-117.58391, 33.47982], [-117.58393, 33.47977], [-117.58404, 33.47965], [-117.58415, 33.47966], [-117.58418, 33.47961], [-117.58418, 33.47956], [-117.58423, 33.47953], [-117.58437, 33.47961], [-117.58446, 33.47964], [-117.58453, 33.47965], [-117.58468, 33.47963], [-117.58475, 33.47959], [-117.58484, 33.4795], [-117.58494, 33.47934], [-117.58499, 33.47928], [-117.58511, 33.47926], [-117.58537, 33.47927], [-117.58568, 33.47939], [-117.5858, 33.4794], [-117.58568, 33.47958], [-117.58551, 33.47977], [-117.58549, 33.47988], [-117.58551, 33.47995], [-117.58548, 33.47998], [-117.58548, 33.48002], [-117.58553, 33.48008], [-117.58555, 33.48013], [-117.58559, 33.48047], [-117.58558, 33.4806], [-117.58566, 33.4807], [-117.58582, 33.48081], [-117.58599, 33.48101], [-117.58602, 33.48107]]]} | Open Access 1 | 30275 | Tierra Grande Park | 26352 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 8.536 | Tierra Grande Park | 0 | Local Park 2 | 4 | |
12827 | 12827 | 12826 | {"type": "Polygon", "coordinates": [[[-117.60155, 33.44135], [-117.60149, 33.44153], [-117.60142, 33.44166], [-117.6013, 33.44182], [-117.60113, 33.44195], [-117.60095, 33.44205], [-117.60081, 33.44211], [-117.60057, 33.44217], [-117.60021, 33.44218], [-117.59938, 33.44211], [-117.59908, 33.44204], [-117.59893, 33.44197], [-117.5988, 33.44189], [-117.59865, 33.44177], [-117.59865, 33.44168], [-117.59879, 33.44153], [-117.59891, 33.44137], [-117.59901, 33.44118], [-117.59911, 33.44088], [-117.59917, 33.44078], [-117.59918, 33.44072], [-117.59916, 33.44069], [-117.5994, 33.44092], [-117.60129, 33.44132], [-117.60147, 33.44135], [-117.60155, 33.44135]]]} | Open Access 1 | 30276 | Rancho San Clemente Park | 24171 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 6.582 | Rancho San Clemente 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]);