units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where ACCESS_TYP = 3, AGNCY_NAME = 447 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, LABEL_NAME
DES_TP 4
- Local Other or Unknown 8
- Local Park 2
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 12 ✖
MNG_AGENCY 1
ACCESS_TYP 1
- No Public Access · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3570 | 3570 | 3569 | {"type": "Polygon", "coordinates": [[[-122.29827, 38.33084], [-122.29801, 38.33096], [-122.29792, 38.33085], [-122.29785, 38.33081], [-122.29739, 38.3307], [-122.2972, 38.33046], [-122.29733, 38.3304], [-122.29775, 38.33062], [-122.29795, 38.33066], [-122.29796, 38.33065], [-122.29814, 38.33067], [-122.29827, 38.33084]]]} | No Public Access 3 | 36603 | Silverado Creek Maintenance District | 30030 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.498 | Silverado Creek Maintenance District | None 299 | |||
4616 | 4616 | 4615 | {"type": "Polygon", "coordinates": [[[-122.25499, 38.35941], [-122.25411, 38.35979], [-122.25361, 38.35995], [-122.25326, 38.35997], [-122.25289, 38.3599], [-122.25265, 38.35979], [-122.25242, 38.35946], [-122.25248, 38.35927], [-122.25284, 38.35909], [-122.2538, 38.35892], [-122.2543, 38.35893], [-122.25499, 38.35941]]]} | No Public Access 3 | 35922 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 4.386 | 0 | Local Other or Unknown 14 | 4 | ||
4630 | 4630 | 4629 | {"type": "Polygon", "coordinates": [[[-122.22625, 38.22568], [-122.22229, 38.22571], [-122.22225, 38.22421], [-122.22224, 38.22254], [-122.22307, 38.22433], [-122.2237, 38.22472], [-122.2237, 38.22525], [-122.22475, 38.22524], [-122.22476, 38.22438], [-122.22452, 38.22437], [-122.22415, 38.22431], [-122.22384, 38.22431], [-122.22307, 38.22385], [-122.22241, 38.22243], [-122.22242, 38.22209], [-122.22261, 38.22185], [-122.22315, 38.22161], [-122.22316, 38.22152], [-122.22322, 38.22151], [-122.22325, 38.22127], [-122.22366, 38.2211], [-122.22393, 38.22126], [-122.22421, 38.22139], [-122.22447, 38.22149], [-122.2248, 38.22157], [-122.22525, 38.22163], [-122.2262, 38.22165], [-122.22625, 38.22568]]]} | No Public Access 3 | 36293 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 35.376 | 0 | Local Other or Unknown 14 | 4 | ||
4633 | 4633 | 4632 | {"type": "Polygon", "coordinates": [[[-122.26376, 38.30317], [-122.26366, 38.30341], [-122.26313, 38.30317], [-122.26295, 38.30314], [-122.26275, 38.30314], [-122.26311, 38.30284], [-122.26376, 38.30317]]]} | No Public Access 3 | 36317 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.57 | 0 | Local Other or Unknown 14 | 4 | ||
4667 | 4667 | 4666 | {"type": "Polygon", "coordinates": [[[-122.26819, 38.3106], [-122.26761, 38.3104], [-122.26755, 38.31017], [-122.26748, 38.31002], [-122.26773, 38.30992], [-122.26819, 38.3106]]]} | No Public Access 3 | 36614 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.487 | 0 | Local Other or Unknown 14 | 4 | ||
4669 | 4669 | 4668 | {"type": "Polygon", "coordinates": [[[-122.34815, 38.318], [-122.34756, 38.31831], [-122.34706, 38.31768], [-122.34742, 38.31748], [-122.34791, 38.31776], [-122.34815, 38.318]]]} | No Public Access 3 | 36618 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.089 | 0 | Local Other or Unknown 14 | 4 | ||
4672 | 4672 | 4671 | {"type": "Polygon", "coordinates": [[[-122.34393, 38.31701], [-122.34317, 38.31651], [-122.34302, 38.31644], [-122.34282, 38.31622], [-122.343, 38.31604], [-122.34304, 38.31589], [-122.34292, 38.31573], [-122.34268, 38.31564], [-122.34243, 38.31559], [-122.34204, 38.31569], [-122.34134, 38.31566], [-122.34134, 38.31545], [-122.3427, 38.31551], [-122.34283, 38.31553], [-122.34294, 38.31558], [-122.34305, 38.31567], [-122.34311, 38.31575], [-122.34319, 38.31614], [-122.34327, 38.31631], [-122.34337, 38.31643], [-122.34367, 38.31671], [-122.34393, 38.31701]]]} | No Public Access 3 | 36636 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.35 | 0 | Local Other or Unknown 14 | 4 | ||
8855 | 8855 | 8854 | {"type": "Polygon", "coordinates": [[[-122.28531, 38.28691], [-122.28514, 38.28692], [-122.28511, 38.287], [-122.28434, 38.2872], [-122.28414, 38.2871], [-122.28374, 38.28832], [-122.28326, 38.29009], [-122.28277, 38.29067], [-122.28216, 38.29153], [-122.28202, 38.29182], [-122.28195, 38.29231], [-122.28197, 38.29287], [-122.2822, 38.29333], [-122.28306, 38.29468], [-122.28289, 38.29523], [-122.28294, 38.29461], [-122.2822, 38.29346], [-122.28196, 38.29299], [-122.28187, 38.29258], [-122.28192, 38.29252], [-122.28185, 38.29205], [-122.28193, 38.29163], [-122.28224, 38.2912], [-122.28315, 38.29007], [-122.28331, 38.28971], [-122.28368, 38.28816], [-122.28369, 38.28793], [-122.28384, 38.28745], [-122.2841, 38.28702], [-122.28419, 38.28694], [-122.28425, 38.28696], [-122.28431, 38.28688], [-122.28471, 38.2868], [-122.2848, 38.28684], [-122.28522, 38.28671], [-122.28519, 38.2868], [-122.28528, 38.28681], [-122.28531, 38.28691]]]} | No Public Access 3 | 14477 | Riverside Park | 24457 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.668 | Riverside Park | 0 | Local Park 2 | 4 | |
10235 | 10235 | 10234 | {"type": "MultiPolygon", "coordinates": [[[[-122.24463, 38.36675], [-122.24135, 38.37065], [-122.24136, 38.37067], [-122.24174, 38.37068], [-122.24269, 38.37071], [-122.24268, 38.3709], [-122.24261, 38.37117], [-122.24256, 38.37144], [-122.24251, 38.37156], [-122.24248, 38.37182], [-122.24255, 38.37251], [-122.24262, 38.37271], [-122.24271, 38.37278], [-122.24286, 38.37324], [-122.24362, 38.37352], [-122.24399, 38.37363], [-122.244, 38.37381], [-122.24379, 38.3739], [-122.24301, 38.37397], [-122.24243, 38.37411], [-122.24202, 38.37433], [-122.24175, 38.37461], [-122.24165, 38.375], [-122.24195, 38.37565], [-122.24199, 38.37584], [-122.24197, 38.37601], [-122.2419, 38.37616], [-122.24188, 38.37625], [-122.24189, 38.37634], [-122.24202, 38.3766], [-122.24205, 38.37676], [-122.24204, 38.37718], [-122.24197, 38.37771], [-122.24194, 38.37777], [-122.24185, 38.37784], [-122.24083, 38.37907], [-122.24064, 38.37951], [-122.24064, 38.37954], [-122.24017, 38.37955], [-122.24014, 38.38], [-122.24007, 38.38019], [-122.24008, 38.3802], [-122.24069, 38.38016], [-122.24088, 38.38114], [-122.24112, 38.38194], [-122.24107, 38.38199], [-122.2404, 38.38207], [-122.2401, 38.38214], [-122.23996, 38.38223], [-122.23985, 38.38236], [-122.23986, 38.38259], [-122.23991, 38.38282], [-122.23987, 38.383], [-122.23964, 38.3833], [-122.23924, 38.38351], [-122.23882, 38.38364], [-122.23842, 38.38371], [-122.23818, 38.38363], [-122.2379, 38.38348], [-122.23764, 38.3835], [-122.2375, 38.38354], [-122.23719, 38.38369], [-122.23698, 38.38382], [-122.23667, 38.38406], [-122.23599, 38.38426], [-122.23583, 38.3838], [-122.23573, 38.38356], [-122.23563, 38.38323], [-122.23546, 38.38283], [-122.23536, 38.38248], [-122.23531, 38.38223], [-122.2353, 38.38202], [-122.2352, 38.38178], [-122.23506, 38.38167], [-122.23485, 38.38155], [-122.23472, 38.38141], [-122.2347, 38.38113], [-122.23461, 38.3808], [-122.2345, 38.38061], [-122.23425, 38.38039], [-122.23412, 38.38032], [-122.23394, 38.38025], [-122.2338, 38.38015], [-122.23368, 38.37993], [-122.23363, 38.3798], [-122.23353, 38.37959], [-122.23339, 38.3794], [-122.23328, 38.37928], [-122.233, 38.37918], [-122.23286, 38.37908], [-122.23278, 38.37895], [-122.23276, 38.37881], [-122.23278, 38.37867], [-122.23278, 38.37851], [-122.23271, 38.3784], [-122.23252, 38.37836], [-122.23236, 38.37827], [-122.23197, 38.37814], [-122.23176, 38.37798], [-122.23155, 38.37772], [-122.23139, 38.37735], [-122.23131, 38.37697], [-122.23115, 38.37661], [-122.23113, 38.37651], [-122.23104, 38.37643], [-122.23091, 38.37635], [-122.23073, 38.37633], [-122.23023, 38.37635], [-122.23002, 38.37638], [-122.22974, 38.37649], [-122.22965, 38.37663], [-122.22959, 38.37681], [-122.22959, 38.37704], [-122.22963, 38.3773], [-122.22964, 38.37753], [-122.22981, 38.37811], [-122.23021, 38.37894], [-122.23028, 38.37911], [-122.23033, 38.37932], [-122.23052, 38.37954], [-122.23086, 38.3798], [-122.23173, 38.38018], [-122.23187, 38.38028], [-122.23186, 38.3804], [-122.23174, 38.38047], [-122.2311, 38.38053], [-122.23061, 38.38074], [-122.23048, 38.38084], [-122.23043, 38.38084], [-122.23049, 38.38074], [-122.23083, 38.38054], [-122.23084, 38.38044], [-122.23074, 38.38039], [-122.23059, 38.38024], [-122.23055, 38.3804], [-122.23061, 38.38048], [-122.23057, 38.38053], [-122.23045, 38.3806], [-122.23031, 38.38075], [-122.23023, 38.38093], [-122.23021, 38.38126], [-122.23016, 38.38146], [-122.23014, 38.38187], [-122.23016, 38.38217], [-122.23031, 38.38277], [-122.23034, 38.38297], [-122.23055, 38.38347], [-122.23068, 38.38364], [-122.23085, 38.38377], [-122.23109, 38.38387], [-122.23166, 38.3845], [-122.23181, 38.38464], [-122.23191, 38.3847], [-122.23227, 38.3848], [-122.23251, 38.38481], [-122.23293, 38.38481], [-122.23336, 38.38474], [-122.23377, 38.38472], [-122.23419, 38.3847], [-122.2344, 38.3847], [-122.23456, 38.38474], [-122.2348, 38.38485], [-122.23492, 38.38489], [-122.23517, 38.38492], [-122.23533, 38.3849], [-122.2355, 38.38483], [-122.23563, 38.38474], [-122.23585, 38.3845], [-122.23602, 38.38443], [-122.23633, 38.38436], [-122.23665, 38.38426], [-122.23691, 38.38409], [-122.23708, 38.38394], [-122.23736, 38.38378], [-122.2377, 38.38367], [-122.23787, 38.3837], [-122.23816, 38.3838], [-122.23854, 38.38384], [-122.23894, 38.38377], [-122.23939, 38.3836], [-122.2397, 38.38343], [-122.23994, 38.38324], [-122.2401, 38.38309], [-122.24015, 38.38291], [-122.24014, 38.38275], [-122.2401, 38.38263], [-122.24007, 38.38241], [-122.24011, 38.38231], [-122.24023, 38.38225], [-122.24062, 38.38218], [-122.24078, 38.38218], [-122.24112, 38.38211], [-122.24121, 38.38215], [-122.2421, 38.38406], [-122.24237, 38.38472], [-122.24272, 38.3854], [-122.24295, 38.38578], [-122.24321, 38.38637], [-122.2434, 38.38666], [-122.2431, 38.387], [-122.24309, 38.38705], [-122.24316, 38.38743], [-122.24308, 38.38773], [-122.24289, 38.3883], [-122.24269, 38.38873], [-122.24256, 38.38891], [-122.24219, 38.38933], [-122.24182, 38.38963], [-122.24156, 38.38968], [-122.24134, 38.38976], [-122.24126, 38.38983], [-122.24121, 38.38995], [-122.24122, 38.3903], [-122.24117, 38.39046], [-122.24111, 38.39055], [-122.24058, 38.3911], [-122.24, 38.3915], [-122.23996, 38.3917], [-122.23999, 38.3919], [-122.24017, 38.3922], [-122.24031, 38.39239], [-122.23976, 38.39238], [-122.2397, 38.3924], [-122.23965, 38.39488], [-122.23957, 38.39508], [-122.23953, 38.39531], [-122.23954, 38.3957], [-122.23966, 38.39602], [-122.23709, 38.396], [-122.23521, 38.396], [-122.23516, 38.40366], [-122.22631, 38.4035], [-122.22627, 38.39597], [-122.22176, 38.39593], [-122.22164, 38.38869], [-122.21244, 38.38862], [-122.21238, 38.37403], [-122.22656, 38.37413], [-122.2311, 38.37409], [-122.23107, 38.36982], [-122.231, 38.36687], [-122.24463, 38.36675]]], [[[-122.23506, 38.38194], [-122.23511, 38.38212], [-122.23514, 38.38236], [-122.23526, 38.38286], [-122.23544, 38.38326], [-122.23547, 38.38344], [-122.23555, 38.38363], [-122.23571, 38.38399], [-122.23574, 38.38423], [-122.2357, 38.38438], [-122.2356, 38.3845], [-122.23537, 38.38469], [-122.23524, 38.38475], [-122.23504, 38.38477], [-122.2348, 38.38465], [-122.23468, 38.38461], [-122.23441, 38.38455], [-122.23414, 38.38455], [-122.23336, 38.38461], [-122.23279, 38.3847], [-122.23243, 38.38468], [-122.23218, 38.38463], [-122.23197, 38.38454], [-122.23184, 38.38442], [-122.23138, 38.38388], [-122.2312, 38.38371], [-122.2309, 38.38358], [-122.23073, 38.38344], [-122.23058, 38.38309], [-122.23048, 38.38257], [-122.23037, 38.38223], [-122.23035, 38.38205], [-122.23043, 38.38117], [-122.23053, 38.38103], [-122.23068, 38.3809], [-122.2309, 38.38078], [-122.23121, 38.38068], [-122.23158, 38.38063], [-122.23201, 38.38052], [-122.2321, 38.38044], [-122.23214, 38.38034], [-122.2321, 38.38024], [-122.23202, 38.38016], [-122.2315, 38.37992], [-122.23132, 38.3798], [-122.23113, 38.37973], [-122.23099, 38.37965], [-122.23086, 38.37956], [-122.23063, 38.37933], [-122.23042, 38.37894], [-122.23026, 38.37859], [-122.23019, 38.37841], [-122.23013, 38.37832], [-122.2299, 38.37769], [-122.2298, 38.37692], [-122.22981, 38.37677], [-122.22988, 38.37667], [-122.23017, 38.37654], [-122.23042, 38.3765], [-122.23076, 38.37655], [-122.23085, 38.37659], [-122.23094, 38.37667], [-122.23101, 38.37681], [-122.23128, 38.37762], [-122.2314, 38.37785], [-122.2316, 38.37809], [-122.23186, 38.37828], [-122.23257, 38.37855], [-122.23257, 38.37887], [-122.23265, 38.37905], [-122.23286, 38.37927], [-122.23298, 38.37931], [-122.23313, 38.37942], [-122.23327, 38.37957], [-122.23341, 38.3798], [-122.23357, 38.38016], [-122.23368, 38.38029], [-122.23385, 38.38039], [-122.23407, 38.38048], [-122.23423, 38.38057], [-122.23441, 38.38083], [-122.23449, 38.38104], [-122.23452, 38.38122], [-122.23452, 38.38141], [-122.23459, 38.38153], [-122.23471, 38.38169], [-122.23493, 38.3818], [-122.23506, 38.38194]]], [[[-122.24403, 38.37272], [-122.24398, 38.37358], [-122.24306, 38.37325], [-122.24305, 38.37274], [-122.24375, 38.3727], [-122.24403, 38.37272]]]]} | No Public Access 3 | 17909 | Milliken Reservoir Property | 22252 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1712.398 | Milliken Reservoir Property | 0 | Local Other or Unknown 14 | 4 | |
13960 | 13960 | 13959 | {"type": "Polygon", "coordinates": [[[-122.29905, 38.32779], [-122.29848, 38.32836], [-122.29839, 38.32842], [-122.29828, 38.32846], [-122.29818, 38.32846], [-122.29777, 38.32842], [-122.29754, 38.32853], [-122.29772, 38.32878], [-122.29763, 38.32882], [-122.29773, 38.32895], [-122.29741, 38.32886], [-122.29693, 38.32878], [-122.29676, 38.32872], [-122.29662, 38.32864], [-122.2972, 38.3285], [-122.2977, 38.32826], [-122.29767, 38.3282], [-122.29787, 38.32817], [-122.29791, 38.32814], [-122.29796, 38.32817], [-122.29801, 38.32814], [-122.29814, 38.32821], [-122.29825, 38.3282], [-122.29829, 38.32816], [-122.29829, 38.32811], [-122.29869, 38.32773], [-122.29876, 38.32764], [-122.29889, 38.32758], [-122.29905, 38.32779]]]} | No Public Access 3 | 36602 | Silverado Creek Maintenance District | 30030 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.843 | Silverado Creek Maintenance District | None 1192 | |||
13962 | 13962 | 13961 | {"type": "Polygon", "coordinates": [[[-122.26703, 38.29781], [-122.26696, 38.29802], [-122.26676, 38.29798], [-122.26667, 38.29805], [-122.26653, 38.29802], [-122.26644, 38.29812], [-122.26642, 38.29821], [-122.26621, 38.29835], [-122.26576, 38.29831], [-122.26553, 38.29825], [-122.26592, 38.29724], [-122.26623, 38.29734], [-122.26628, 38.2974], [-122.26631, 38.29747], [-122.26637, 38.29753], [-122.26643, 38.29755], [-122.2665, 38.29754], [-122.26673, 38.29762], [-122.26681, 38.29777], [-122.26703, 38.29781]]]} | No Public Access 3 | 36606 | Hidden Glen Park | 30022 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.182 | Hidden Glen Park | 0 | Local Park 2 | 4 | |
15449 | 15449 | 15448 | {"type": "Polygon", "coordinates": [[[-122.30439, 38.26326], [-122.30382, 38.2634], [-122.30362, 38.26287], [-122.30419, 38.26274], [-122.30439, 38.26326]]]} | No Public Access 3 | 36595 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.78 | 0 | Local Other or Unknown 14 | 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]);