units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where ACCESS_TYP = 1, AGNCY_NAME = 201 and MNG_AGENCY = 197
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
541 | 541 | 540 | {"type": "Polygon", "coordinates": [[[-117.1208, 33.13775], [-117.11972, 33.13958], [-117.11943, 33.13945], [-117.11998, 33.13851], [-117.11943, 33.13827], [-117.11986, 33.13753], [-117.12047, 33.13779], [-117.12056, 33.13765], [-117.1208, 33.13775]]]} | Open Access 1 | 1805 | Knob Hill Park | 20695 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/161/1081 | San Diego 4 | 3.015 | Knob Hill Park | 0 | Local Park 2 | 4 |
556 | 556 | 555 | {"type": "Polygon", "coordinates": [[[-117.1447, 33.13509], [-117.14464, 33.13523], [-117.1444, 33.13541], [-117.14432, 33.13551], [-117.14424, 33.13563], [-117.14407, 33.13558], [-117.1439, 33.13556], [-117.14312, 33.13556], [-117.14316, 33.13525], [-117.14294, 33.13521], [-117.14277, 33.13514], [-117.14261, 33.13505], [-117.14247, 33.13493], [-117.14236, 33.13481], [-117.1423, 33.1347], [-117.142, 33.13397], [-117.14119, 33.13326], [-117.14102, 33.13308], [-117.14081, 33.13277], [-117.14074, 33.13262], [-117.14067, 33.13238], [-117.14042, 33.13241], [-117.14047, 33.13234], [-117.14048, 33.13226], [-117.14046, 33.13221], [-117.14042, 33.13217], [-117.14031, 33.13212], [-117.14034, 33.13182], [-117.14024, 33.13182], [-117.1401, 33.13185], [-117.14, 33.13189], [-117.13989, 33.13196], [-117.13973, 33.13196], [-117.13969, 33.13108], [-117.13985, 33.13107], [-117.13982, 33.12883], [-117.14036, 33.12873], [-117.14078, 33.1286], [-117.14078, 33.13108], [-117.1411, 33.13108], [-117.14111, 33.1313], [-117.14239, 33.13289], [-117.14338, 33.13365], [-117.14314, 33.13442], [-117.14387, 33.13497], [-117.14465, 33.13507], [-117.1447, 33.13509]]]} | Open Access 1 | 1865 | Jack's Pond Park | 20300 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/139/1081 | San Diego 4 | 22.284 | Jack's Pond Park | 0 | Local Park 2 | 4 |
559 | 559 | 558 | {"type": "Polygon", "coordinates": [[[-117.14812, 33.12447], [-117.14555, 33.12477], [-117.14553, 33.12381], [-117.1481, 33.12381], [-117.14812, 33.12447]]]} | Open Access 1 | 1866 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 5.376 | City of San Marcos OS | 0 | Local Recreation Area 3 | 4 | |
582 | 582 | 581 | {"type": "Polygon", "coordinates": [[[-117.18875, 33.16063], [-117.18871, 33.16066], [-117.18683, 33.16069], [-117.18645, 33.16068], [-117.18644, 33.15846], [-117.18701, 33.15859], [-117.1875, 33.15866], [-117.18752, 33.15879], [-117.18796, 33.1588], [-117.18818, 33.15884], [-117.18874, 33.15885], [-117.18876, 33.1606], [-117.18875, 33.16063]]]} | Open Access 1 | 1940 | Cerro De Las Posas Park | 17090 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/165/1081 | San Diego 4 | 11.62 | Cerro De Las Posas Park | 0 | Local Park 2 | 4 |
1430 | 1430 | 1429 | {"type": "Polygon", "coordinates": [[[-117.12984, 33.15135], [-117.1298, 33.15206], [-117.12954, 33.15205], [-117.12957, 33.15153], [-117.12968, 33.1515], [-117.12974, 33.15147], [-117.12984, 33.15135]]]} | Open Access 1 | 47696 | Fulton Community Garden | 31432 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.389 | Fulton Community Garden | 0 | Local Park 2 | 4 | |
1524 | 1524 | 1523 | {"type": "Polygon", "coordinates": [[[-117.12865, 33.15166], [-117.12863, 33.15202], [-117.12765, 33.15199], [-117.12767, 33.15133], [-117.12844, 33.15134], [-117.12843, 33.15165], [-117.12865, 33.15166]]]} | Open Access 1 | 47730 | Woodland Park Tennis Courts | 31531 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 1.518 | Woodland Park Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
2861 | 2861 | 2860 | {"type": "Polygon", "coordinates": [[[-117.13342, 33.14761], [-117.13288, 33.14884], [-117.13241, 33.14999], [-117.13211, 33.15068], [-117.12988, 33.15061], [-117.1299, 33.15021], [-117.13084, 33.15023], [-117.13094, 33.14816], [-117.13177, 33.14817], [-117.13179, 33.14755], [-117.13342, 33.14761]]]} | Open Access 1 | 1834 | Woodland Park | 27724 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/167/1081?npage=2 | San Diego 4 | 14.507 | Woodland Park | 0 | Local Park 2 | 4 |
3905 | 3905 | 3904 | {"type": "Polygon", "coordinates": [[[-117.21535, 33.1462], [-117.21466, 33.14765], [-117.21064, 33.14621], [-117.21065, 33.14618], [-117.20942, 33.14575], [-117.21011, 33.1444], [-117.2111, 33.14476], [-117.21098, 33.145], [-117.21105, 33.14506], [-117.21106, 33.14505], [-117.21116, 33.14507], [-117.21124, 33.14505], [-117.21137, 33.14479], [-117.21238, 33.14513], [-117.21535, 33.1462]]]} | Open Access 1 | 45973 | Sunset Park | 29123 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/155/1081?npage=2 | San Diego 4 | 22.101 | Sunset Park | 0 | Local Park 2 | 4 |
4179 | 4179 | 4178 | {"type": "Polygon", "coordinates": [[[-117.20456, 33.13735], [-117.20318, 33.14011], [-117.19909, 33.13865], [-117.20052, 33.13585], [-117.20456, 33.13735]]]} | Open Access 1 | 1792 | Bradley Park | 16326 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/170/1081 | San Diego 4 | 34.275 | Bradley Park | 0 | Local Park 2 | 4 |
4197 | 4197 | 4196 | {"type": "Polygon", "coordinates": [[[-117.16467, 33.14461], [-117.16462, 33.14506], [-117.16459, 33.14509], [-117.16454, 33.14511], [-117.16434, 33.14509], [-117.16425, 33.14503], [-117.16417, 33.14501], [-117.16417, 33.1448], [-117.1627, 33.14464], [-117.16275, 33.14424], [-117.16278, 33.14421], [-117.16282, 33.14419], [-117.16332, 33.14424], [-117.16381, 33.14422], [-117.16464, 33.14431], [-117.16468, 33.14433], [-117.1647, 33.14436], [-117.16467, 33.14461]]]} | Open Access 1 | 47686 | Richmar Park | 31423 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/406/1126 | San Diego 4 | 2.819 | Richmar Park | 0 | Local Park 2 | 4 |
4387 | 4387 | 4386 | {"type": "Polygon", "coordinates": [[[-117.17078, 33.14419], [-117.17069, 33.14454], [-117.16617, 33.14341], [-117.16616, 33.14322], [-117.16611, 33.14305], [-117.17078, 33.14419]]]} | Open Access 1 | 45969 | Buelow Park | 29118 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/153/1081 | San Diego 4 | 4.241 | Buelow Park | 0 | Local Park 2 | 4 |
4398 | 4398 | 4397 | {"type": "Polygon", "coordinates": [[[-117.18329, 33.14634], [-117.1828, 33.14626], [-117.17872, 33.14576], [-117.1788, 33.14537], [-117.17884, 33.14494], [-117.1789, 33.1446], [-117.17915, 33.1445], [-117.17921, 33.1445], [-117.17956, 33.14463], [-117.17994, 33.14406], [-117.18015, 33.14392], [-117.18033, 33.1437], [-117.18045, 33.1436], [-117.18329, 33.14634]]]} | Open Access 1 | 1831 | Mission Sports Park | 22312 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/163/1081 | San Diego 4 | 15.175 | Mission Sports Park | 0 | Local Recreation Area 3 | 4 |
4597 | 4597 | 4596 | {"type": "Polygon", "coordinates": [[[-117.18544, 33.1626], [-117.18544, 33.16267], [-117.18537, 33.16299], [-117.18467, 33.1629], [-117.18466, 33.16288], [-117.18471, 33.16253], [-117.18544, 33.1626]]]} | Open Access 1 | 35551 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.736 | 0 | Local Other or Unknown 14 | 4 | ||
4614 | 4614 | 4613 | {"type": "Polygon", "coordinates": [[[-117.14137, 33.15374], [-117.14114, 33.15399], [-117.1411, 33.154], [-117.14106, 33.154], [-117.14103, 33.15398], [-117.14101, 33.15395], [-117.14087, 33.15347], [-117.14094, 33.15346], [-117.14137, 33.15374]]]} | Open Access 1 | 35852 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.339 | 0 | Local Other or Unknown 14 | 4 | ||
4784 | 4784 | 4783 | {"type": "Polygon", "coordinates": [[[-117.17371, 33.15352], [-117.16952, 33.15353], [-117.16952, 33.15346], [-117.16955, 33.15327], [-117.16964, 33.15308], [-117.16977, 33.15295], [-117.1699, 33.15285], [-117.16995, 33.15283], [-117.16999, 33.15285], [-117.1703, 33.15306], [-117.17058, 33.1532], [-117.17095, 33.15333], [-117.17128, 33.15342], [-117.1718, 33.15347], [-117.17371, 33.15348], [-117.17371, 33.15352]]]} | Open Access 1 | 47624 | Unnamed San Marcos City Park 1 | 31361 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 2.05 | 0 | Local Other or Unknown 14 | 4 | ||
6362 | 6362 | 6361 | {"type": "MultiPolygon", "coordinates": [[[[-117.15494, 33.18453], [-117.15476, 33.18493], [-117.1547, 33.18503], [-117.15452, 33.18522], [-117.15437, 33.18532], [-117.15412, 33.18544], [-117.15215, 33.18622], [-117.15055, 33.18412], [-117.15249, 33.17979], [-117.15452, 33.18044], [-117.15298, 33.1839], [-117.15494, 33.18453]]], [[[-117.15956, 33.17354], [-117.15956, 33.17356], [-117.15938, 33.17397], [-117.15928, 33.17428], [-117.15912, 33.17535], [-117.15892, 33.17581], [-117.15689, 33.17517], [-117.15611, 33.17685], [-117.15513, 33.17655], [-117.15471, 33.17739], [-117.15439, 33.1787], [-117.15385, 33.18001], [-117.15258, 33.17961], [-117.15573, 33.17252], [-117.15582, 33.17242], [-117.15587, 33.17233], [-117.15593, 33.17231], [-117.15951, 33.17349], [-117.15956, 33.17354]]]]} | Open Access 1 | 1734 | Walnut Grove Park | 27232 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/166/1081?npage=2 | San Diego 4 | 85.152 | Walnut Grove Park | 0 | Local Park 2 | 4 |
6395 | 6395 | 6394 | {"type": "Polygon", "coordinates": [[[-117.13036, 33.15701], [-117.13, 33.15705], [-117.12965, 33.15704], [-117.1293, 33.15698], [-117.12927, 33.15689], [-117.12937, 33.15681], [-117.12953, 33.15667], [-117.12969, 33.15649], [-117.12985, 33.15627], [-117.12994, 33.15612], [-117.13015, 33.15566], [-117.13019, 33.15562], [-117.13025, 33.15561], [-117.13005, 33.15609], [-117.12989, 33.15633], [-117.13022, 33.15634], [-117.13023, 33.15639], [-117.13027, 33.15643], [-117.13019, 33.15653], [-117.13036, 33.15701]]]} | Open Access 1 | 1826 | Helen Bougher Park | 19796 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/149/1081 | San Diego 4 | 1.486 | Helen Bougher Park | 0 | Local Park 2 | 4 |
6472 | 6472 | 6471 | {"type": "MultiPolygon", "coordinates": [[[[-117.2022, 33.09994], [-117.20212, 33.10008], [-117.20213, 33.10011], [-117.20206, 33.10021], [-117.20207, 33.10026], [-117.20194, 33.10042], [-117.20195, 33.10047], [-117.2018, 33.10065], [-117.20182, 33.1007], [-117.20178, 33.10092], [-117.20181, 33.10096], [-117.20168, 33.10119], [-117.20133, 33.10121], [-117.20118, 33.10129], [-117.2007, 33.1013], [-117.2009, 33.10153], [-117.20138, 33.10215], [-117.20053, 33.10254], [-117.20042, 33.10245], [-117.20021, 33.10233], [-117.19979, 33.10224], [-117.19961, 33.10217], [-117.19949, 33.10209], [-117.1993, 33.10191], [-117.19931, 33.10044], [-117.199, 33.10011], [-117.19928, 33.0999], [-117.19968, 33.09957], [-117.20004, 33.09919], [-117.20015, 33.09919], [-117.20067, 33.0995], [-117.20104, 33.09967], [-117.20153, 33.09982], [-117.2022, 33.09994]]], [[[-117.19899, 33.10011], [-117.19897, 33.10169], [-117.19878, 33.10164], [-117.19829, 33.10163], [-117.19812, 33.1016], [-117.19786, 33.1015], [-117.19764, 33.10133], [-117.19756, 33.10121], [-117.19744, 33.101], [-117.19743, 33.10096], [-117.19745, 33.10092], [-117.19764, 33.10084], [-117.1983, 33.10054], [-117.19885, 33.10021], [-117.19899, 33.10011]]]]} | Open Access 1 | 2036 | San Elijo Park | 24882 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/160/1081?npage=2 | San Diego 4 | 19.897 | San Elijo Park | 0 | Local Park 2 | 4 |
7630 | 7630 | 7629 | {"type": "Polygon", "coordinates": [[[-117.17031, 33.14175], [-117.1696, 33.14194], [-117.16948, 33.14143], [-117.1694, 33.14144], [-117.16913, 33.14075], [-117.16876, 33.14084], [-117.16851, 33.14017], [-117.16966, 33.13987], [-117.17001, 33.14078], [-117.16995, 33.14081], [-117.17031, 33.14175]]]} | Open Access 1 | 47648 | Connors Park | 31392 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/151/1081 | San Diego 4 | 4.59 | Connors Park | 2014 | Local Park 2 | 4 |
9938 | 9938 | 9937 | {"type": "Polygon", "coordinates": [[[-117.18229, 33.16732], [-117.1818, 33.16767], [-117.18177, 33.16834], [-117.1747, 33.16811], [-117.17439, 33.1632], [-117.17425, 33.16054], [-117.17772, 33.16053], [-117.17791, 33.16137], [-117.17776, 33.16141], [-117.17785, 33.1618], [-117.17729, 33.16189], [-117.17689, 33.16205], [-117.17657, 33.16226], [-117.17624, 33.16257], [-117.17602, 33.1629], [-117.17589, 33.16318], [-117.17582, 33.16346], [-117.17585, 33.16381], [-117.17592, 33.16398], [-117.17601, 33.16414], [-117.17623, 33.16441], [-117.17651, 33.16424], [-117.17653, 33.16426], [-117.17626, 33.16444], [-117.17667, 33.16491], [-117.17696, 33.16515], [-117.17714, 33.16526], [-117.1774, 33.16535], [-117.17761, 33.1654], [-117.1778, 33.1654], [-117.17807, 33.16539], [-117.1786, 33.16531], [-117.17894, 33.1653], [-117.17912, 33.16533], [-117.17944, 33.16545], [-117.17959, 33.16553], [-117.18049, 33.16633], [-117.18066, 33.16645], [-117.18119, 33.16674], [-117.1816, 33.16709], [-117.18185, 33.16691], [-117.18229, 33.16732]], [[-117.1756, 33.16062], [-117.17556, 33.1606], [-117.17549, 33.16061], [-117.1751, 33.1608], [-117.17468, 33.16093], [-117.17464, 33.16099], [-117.1746, 33.16107], [-117.17459, 33.16119], [-117.17473, 33.16128], [-117.17497, 33.16138], [-117.17517, 33.16139], [-117.17528, 33.16137], [-117.1755, 33.16119], [-117.17567, 33.16088], [-117.1756, 33.16062]]]} | Open Access 1 | 1949 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 74.648 | City of San Marcos OS | 0 | Local Recreation Area 3 | 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]);