units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where DES_TP = 3 and MNG_AGENCY = 16 sorted by AGNCY_TYP
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Los Angeles, County of · 11 ✖
DES_TP 1
- Local Recreation Area · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15093 | 15093 | 15092 | {"type": "Polygon", "coordinates": [[[-118.35888, 34.0023], [-118.35743, 34.00713], [-118.35738, 34.00743], [-118.35738, 34.00774], [-118.35748, 34.00863], [-118.35748, 34.0089], [-118.35745, 34.00922], [-118.35735, 34.00958], [-118.3572, 34.00992], [-118.35699, 34.01024], [-118.35679, 34.01046], [-118.35569, 34.01157], [-118.35549, 34.01187], [-118.35536, 34.01217], [-118.35532, 34.01209], [-118.35533, 34.01207], [-118.35526, 34.01193], [-118.35528, 34.01188], [-118.35527, 34.01183], [-118.35522, 34.01178], [-118.35514, 34.01177], [-118.35511, 34.01134], [-118.35633, 34.01], [-118.35645, 34.00919], [-118.35645, 34.00848], [-118.35623, 34.00788], [-118.35572, 34.00731], [-118.35564, 34.00709], [-118.35667, 34.00655], [-118.35688, 34.00626], [-118.35711, 34.00508], [-118.35786, 34.00369], [-118.3579, 34.00348], [-118.35835, 34.00266], [-118.35849, 34.00227], [-118.35868, 34.00215], [-118.35877, 34.0022], [-118.35888, 34.0023]]]} | Open Access 1 | 45877 | La Brea Greenbelt | 28950 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 21.818 | La Brea Greenbelt | 0 | Local Recreation Area 3 | 4 | |
15663 | 15663 | 15662 | {"type": "Polygon", "coordinates": [[[-118.40577, 33.76235], [-118.40543, 33.76277], [-118.40476, 33.76288], [-118.40115, 33.76183], [-118.40043, 33.76139], [-118.39873, 33.75821], [-118.39882, 33.75812], [-118.3989, 33.758], [-118.39899, 33.7578], [-118.39901, 33.75768], [-118.39901, 33.75754], [-118.39898, 33.75742], [-118.39888, 33.75722], [-118.39883, 33.75706], [-118.39879, 33.75691], [-118.39878, 33.75667], [-118.39884, 33.75634], [-118.39895, 33.75609], [-118.39942, 33.7554], [-118.39929, 33.75534], [-118.3988, 33.75604], [-118.39865, 33.75639], [-118.39861, 33.75662], [-118.39862, 33.7568], [-118.39833, 33.75685], [-118.3983, 33.75674], [-118.39837, 33.75604], [-118.39856, 33.7544], [-118.40003, 33.75192], [-118.39994, 33.75125], [-118.39987, 33.75101], [-118.39978, 33.75086], [-118.39962, 33.75068], [-118.39956, 33.75063], [-118.3993, 33.75049], [-118.39909, 33.75043], [-118.3989, 33.75041], [-118.39871, 33.75041], [-118.39843, 33.75047], [-118.3983, 33.75051], [-118.39609, 33.75167], [-118.3959, 33.75181], [-118.3958, 33.75191], [-118.39569, 33.75208], [-118.3957, 33.75216], [-118.3956, 33.75209], [-118.39539, 33.752], [-118.39546, 33.75197], [-118.39555, 33.75184], [-118.39507, 33.75161], [-118.39476, 33.7508], [-118.39504, 33.75018], [-118.39573, 33.74968], [-118.39552, 33.74935], [-118.39672, 33.74876], [-118.39875, 33.74843], [-118.39979, 33.74782], [-118.40117, 33.74652], [-118.40172, 33.74643], [-118.40231, 33.74691], [-118.40191, 33.74915], [-118.403, 33.75085], [-118.40334, 33.75309], [-118.404, 33.75374], [-118.40391, 33.75506], [-118.40227, 33.75588], [-118.40141, 33.75658], [-118.40141, 33.75804], [-118.40296, 33.76003], [-118.40533, 33.76169], [-118.40577, 33.76235]]]} | Restricted Access 2 | 5866 | Los Verdes Golf Course | 33003 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 162.838 | Los Verdes GC | 0 | Local Recreation Area 3 | 4 | |
15666 | 15666 | 15665 | {"type": "Polygon", "coordinates": [[[-118.31767, 33.91768], [-118.31766, 33.92154], [-118.31756, 33.92157], [-118.31241, 33.9237], [-118.3092, 33.9237], [-118.30923, 33.91674], [-118.30926, 33.91673], [-118.30926, 33.91662], [-118.30931, 33.91658], [-118.31432, 33.91659], [-118.31444, 33.91781], [-118.3146, 33.91784], [-118.31459, 33.91818], [-118.31461, 33.91853], [-118.31533, 33.91853], [-118.31681, 33.91768], [-118.31767, 33.91768]]]} | Restricted Access 2 | 6207 | Chester L Washington Golf Course | 33007 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 125.616 | Chester L Washington GC | 0 | Local Recreation Area 3 | 4 | |
15719 | 15719 | 15718 | {"type": "Polygon", "coordinates": [[[-118.34366, 33.88545], [-118.34013, 33.88558], [-118.34029, 33.88725], [-118.33518, 33.88725], [-118.33518, 33.88623], [-118.33512, 33.88577], [-118.33502, 33.88542], [-118.33485, 33.88504], [-118.33464, 33.88473], [-118.33435, 33.88438], [-118.33447, 33.88429], [-118.33398, 33.88376], [-118.33384, 33.88384], [-118.33158, 33.88141], [-118.34006, 33.87868], [-118.34007, 33.87869], [-118.3403, 33.87861], [-118.3403, 33.8786], [-118.34353, 33.87755], [-118.34365, 33.87762], [-118.34366, 33.88545]]]} | Restricted Access 2 | 44523 | Alondra Golf Course | 33106 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 187.746 | Alondra GC | 0 | Local Recreation Area 3 | 4 | |
16033 | 16033 | 16032 | {"type": "Polygon", "coordinates": [[[-118.50024, 34.11059], [-118.49993, 34.11127], [-118.49951, 34.11125], [-118.49902, 34.11151], [-118.49904, 34.11211], [-118.49949, 34.11201], [-118.49966, 34.11289], [-118.49928, 34.11331], [-118.49883, 34.11314], [-118.49839, 34.1135], [-118.49848, 34.11373], [-118.49303, 34.11661], [-118.49324, 34.11737], [-118.49254, 34.11879], [-118.4918, 34.11907], [-118.49155, 34.11941], [-118.49164, 34.11959], [-118.49304, 34.11978], [-118.49374, 34.11932], [-118.49489, 34.11912], [-118.49555, 34.11945], [-118.49509, 34.12066], [-118.49438, 34.12149], [-118.4947, 34.12181], [-118.49536, 34.12163], [-118.49601, 34.122], [-118.49503, 34.1225], [-118.49549, 34.12327], [-118.49705, 34.12272], [-118.49721, 34.12285], [-118.49699, 34.1232], [-118.49699, 34.12321], [-118.49721, 34.12332], [-118.49793, 34.12307], [-118.4981, 34.12327], [-118.49774, 34.12355], [-118.4981, 34.12408], [-118.49847, 34.12381], [-118.49903, 34.1256], [-118.49701, 34.12626], [-118.49906, 34.12798], [-118.49735, 34.1281], [-118.49684, 34.12796], [-118.49635, 34.12924], [-118.49626, 34.12906], [-118.49521, 34.12845], [-118.4949, 34.12743], [-118.4943, 34.12742], [-118.49344, 34.12714], [-118.49245, 34.12805], [-118.49227, 34.12901], [-118.49102, 34.12884], [-118.49048, 34.12842], [-118.49021, 34.12845], [-118.4902, 34.12842], [-118.48997, 34.12692], [-118.49011, 34.1268], [-118.48988, 34.12643], [-118.48988, 34.1264], [-118.49024, 34.12607], [-118.49032, 34.12523], [-118.49012, 34.1251], [-118.48979, 34.12508], [-118.48887, 34.12535], [-118.48808, 34.1259], [-118.48716, 34.12628], [-118.48673, 34.12707], [-118.48767, 34.12855], [-118.4876, 34.12939], [-118.48775, 34.12941], [-118.4877, 34.12979], [-118.48658, 34.12973], [-118.48627, 34.12909], [-118.48584, 34.1272], [-118.4852, 34.1272], [-118.48511, 34.12649], [-118.4842, 34.12659], [-118.48371, 34.12717], [-118.48319, 34.12747], [-118.48337, 34.12612], [-118.48367, 34.12521], [-118.48318, 34.12485], [-118.4832, 34.12456], [-118.48353, 34.12423], [-118.48337, 34.12375], [-118.48247, 34.1235], [-118.48231, 34.12307], [-118.48235, 34.12295], [-118.48217, 34.12149], [-118.48259, 34.12109], [-118.48269, 34.11949], [-118.48241, 34.11902], [-118.48253, 34.11889], [-118.48265, 34.1187], [-118.48275, 34.11835], [-118.48277, 34.11821], [-118.48277, 34.11801], [-118.48275, 34.11782], [-118.48273, 34.11776], [-118.48272, 34.11573], [-118.48425, 34.11628], [-118.48501, 34.11684], [-118.4854, 34.1166], [-118.48601, 34.11697], [-118.48643, 34.1167], [-118.48705, 34.11702], [-118.48719, 34.11693], [-118.48705, 34.11654], [-118.48791, 34.11631], [-118.48742, 34.11571], [-118.48791, 34.11531], [-118.48844, 34.11531], [-118.48874, 34.11564], [-118.48895, 34.11524], [-118.48942, 34.11523], [-118.48953, 34.11507], [-118.48886, 34.11464], [-118.48853, 34.11425], [-118.48824, 34.11418], [-118.48799, 34.11381], [-118.48819, 34.11317], [-118.48867, 34.11287], [-118.48897, 34.11314], [-118.48947, 34.11301], [-118.48961, 34.11329], [-118.49137, 34.11401], [-118.49139, 34.11368], [-118.49179, 34.11353], [-118.49132, 34.11316], [-118.49141, 34.11286], [-118.49169, 34.11264], [-118.49189, 34.1128], [-118.49241, 34.11285], [-118.49271, 34.1127], [-118.49233, 34.11256], [-118.49209, 34.11176], [-118.49327, 34.1113], [-118.49327, 34.11129], [-118.49318, 34.11118], [-118.49626, 34.11118], [-118.49627, 34.11007], [-118.4981, 34.10916], [-118.49927, 34.10917], [-118.49905, 34.10959], [-118.49922, 34.10962], [-118.49963, 34.10977], [-118.49969, 34.10978], [-118.49963, 34.11008], [-118.50002, 34.11021], [-118.4999, 34.11047], [-118.50024, 34.11059]]]} | Open Access 1 | 6368 | Mission Canyon Open Space | 6051 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.lamountains.com/parks.asp?parkid=64 | Los Angeles 6 | 480.167 | Mission Canyon OS | 0 | Local Recreation Area 3 | 4 |
16051 | 16051 | 16050 | {"type": "Polygon", "coordinates": [[[-118.29278, 34.22166], [-118.2774, 34.22176], [-118.27738, 34.21871], [-118.2773, 34.21531], [-118.27834, 34.21531], [-118.27835, 34.21456], [-118.28057, 34.21456], [-118.28668, 34.2146], [-118.29156, 34.2202], [-118.29278, 34.22166]], [[-118.28164, 34.21533], [-118.28164, 34.21532], [-118.28095, 34.21457], [-118.27956, 34.21495], [-118.27872, 34.21549], [-118.27971, 34.21654], [-118.28164, 34.21533]]]} | Open Access 1 | 6829 | Henderson Canyon Open Space | 19812 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 214.059 | Henderson Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16062 | 16062 | 16061 | {"type": "Polygon", "coordinates": [[[-118.21741, 34.23745], [-118.21722, 34.24452], [-118.21284, 34.2442], [-118.21294, 34.24101], [-118.21293, 34.241], [-118.20852, 34.24092], [-118.20841, 34.24387], [-118.20398, 34.24355], [-118.20426, 34.23723], [-118.20431, 34.23366], [-118.20649, 34.23369], [-118.2083, 34.23106], [-118.20982, 34.22811], [-118.21084, 34.22869], [-118.21091, 34.22868], [-118.21098, 34.22864], [-118.21133, 34.22834], [-118.21139, 34.22827], [-118.21146, 34.22812], [-118.21187, 34.22837], [-118.21208, 34.22823], [-118.21233, 34.22814], [-118.21242, 34.22809], [-118.21258, 34.22789], [-118.21276, 34.22776], [-118.2129, 34.22771], [-118.21311, 34.22768], [-118.21319, 34.22762], [-118.21328, 34.22765], [-118.21332, 34.22758], [-118.21332, 34.22747], [-118.21328, 34.2274], [-118.21321, 34.22733], [-118.21319, 34.22729], [-118.21321, 34.22707], [-118.21362, 34.2272], [-118.21387, 34.22687], [-118.21432, 34.22655], [-118.21681, 34.22656], [-118.21612, 34.22701], [-118.21663, 34.22744], [-118.21527, 34.22884], [-118.21313, 34.23018], [-118.2131, 34.23379], [-118.21162, 34.23378], [-118.21159, 34.23734], [-118.21741, 34.23745]]]} | Open Access 1 | 6943 | Winery Canyon Open Space | 6117 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 342.872 | Winery Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16105 | 16105 | 16104 | {"type": "MultiPolygon", "coordinates": [[[[-118.58817, 34.10259], [-118.58778, 34.10269], [-118.58765, 34.10265], [-118.58748, 34.1025], [-118.58813, 34.1025], [-118.58817, 34.10259]]], [[[-118.59194, 34.11026], [-118.59184, 34.11026], [-118.59189, 34.11007], [-118.59189, 34.11009], [-118.59194, 34.11026]]], [[[-118.59261, 34.10389], [-118.59255, 34.10406], [-118.59244, 34.10418], [-118.59221, 34.10403], [-118.59261, 34.10381], [-118.59261, 34.10389]]], [[[-118.59325, 34.10862], [-118.59325, 34.10862], [-118.59278, 34.10857], [-118.59282, 34.10848], [-118.59325, 34.10852], [-118.59325, 34.10862]]], [[[-118.5948, 34.10377], [-118.59468, 34.10378], [-118.59439, 34.10389], [-118.59425, 34.10384], [-118.59396, 34.10385], [-118.59371, 34.10394], [-118.59364, 34.10394], [-118.59358, 34.10367], [-118.59325, 34.10342], [-118.59479, 34.10343], [-118.5948, 34.10377]]], [[[-118.5944, 34.10418], [-118.59438, 34.10445], [-118.59427, 34.10438], [-118.59408, 34.10457], [-118.59412, 34.10471], [-118.59421, 34.1048], [-118.5942, 34.10482], [-118.59417, 34.10483], [-118.59392, 34.10454], [-118.59403, 34.10413], [-118.59406, 34.10419], [-118.5944, 34.10418]]], [[[-118.59516, 34.10385], [-118.59512, 34.10419], [-118.59459, 34.10419], [-118.59461, 34.10385], [-118.59469, 34.10383], [-118.59497, 34.1038], [-118.59516, 34.10385]]], [[[-118.59643, 34.10682], [-118.59624, 34.10711], [-118.59621, 34.1071], [-118.59594, 34.10727], [-118.59594, 34.10729], [-118.59577, 34.10729], [-118.59581, 34.10727], [-118.59609, 34.107], [-118.59614, 34.10674], [-118.596, 34.1067], [-118.59526, 34.10636], [-118.59503, 34.10636], [-118.59501, 34.10609], [-118.59528, 34.10609], [-118.59516, 34.10588], [-118.59545, 34.10588], [-118.59567, 34.10601], [-118.59604, 34.10628], [-118.59629, 34.10655], [-118.5962, 34.10666], [-118.59643, 34.10682]]], [[[-118.59552, 34.10731], [-118.59529, 34.10784], [-118.59516, 34.10784], [-118.59512, 34.10781], [-118.59509, 34.10771], [-118.59506, 34.10767], [-118.59531, 34.10723], [-118.59552, 34.10731]]], [[[-118.59592, 34.10562], [-118.59563, 34.10593], [-118.59545, 34.10584], [-118.59512, 34.10582], [-118.59535, 34.10549], [-118.59546, 34.10556], [-118.59568, 34.1056], [-118.59592, 34.10562]]], [[[-118.59609, 34.10677], [-118.59605, 34.10697], [-118.59583, 34.10719], [-118.59529, 34.10697], [-118.59555, 34.10654], [-118.59598, 34.10675], [-118.59609, 34.10677]]], [[[-118.59762, 34.10679], [-118.59762, 34.10734], [-118.59735, 34.10733], [-118.59731, 34.10683], [-118.59762, 34.10679]]]]} | Open Access 1 | 12771 | Los Angeles County Open Space | 21481 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 6.522 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
16106 | 16106 | 16105 | {"type": "Polygon", "coordinates": [[[-118.60065, 34.08186], [-118.60046, 34.08215], [-118.60015, 34.08199], [-118.60027, 34.08183], [-118.60041, 34.08174], [-118.60065, 34.08186]]]} | Open Access 1 | 12772 | Los Angeles County Open Space | 21481 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.276 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
16928 | 16928 | 16927 | {"type": "Polygon", "coordinates": [[[-117.78685, 34.08806], [-117.78682, 34.08835], [-117.78544, 34.08847], [-117.78504, 34.08832], [-117.78493, 34.08852], [-117.78422, 34.08859], [-117.78404, 34.08903], [-117.78041, 34.08809], [-117.78037, 34.08814], [-117.77867, 34.08717], [-117.77694, 34.08623], [-117.77698, 34.0862], [-117.77697, 34.08618], [-117.77522, 34.08526], [-117.77486, 34.08403], [-117.77477, 34.08386], [-117.77462, 34.08372], [-117.77291, 34.08262], [-117.77288, 34.08258], [-117.77288, 34.08254], [-117.77302, 34.08229], [-117.77324, 34.08205], [-117.77352, 34.08184], [-117.77384, 34.08168], [-117.77419, 34.08158], [-117.77412, 34.08161], [-117.77412, 34.08163], [-117.77559, 34.08135], [-117.77669, 34.08111], [-117.77718, 34.08098], [-117.77767, 34.08079], [-117.77822, 34.08051], [-117.77878, 34.08014], [-117.77903, 34.07993], [-117.77937, 34.07959], [-117.77961, 34.07928], [-117.77973, 34.07925], [-117.7799, 34.07934], [-117.78382, 34.08108], [-117.78097, 34.08373], [-117.78204, 34.08539], [-117.78408, 34.0849], [-117.78541, 34.08509], [-117.78685, 34.08806]]]} | Restricted Access 2 | 46285 | Mountain Meadows Golf Course | 33118 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Mountain_Meadows_Golf_Course | Los Angeles 6 | 165.184 | Mtn. Meadows GC | 0 | Local Recreation Area 3 | 4 |
7180 | 7180 | 7179 | {"type": "MultiPolygon", "coordinates": [[[[-118.4334, 33.97487], [-118.43334, 33.97494], [-118.43267, 33.97532], [-118.43253, 33.97541], [-118.4325, 33.97537], [-118.43335, 33.97488], [-118.43335, 33.97486], [-118.4334, 33.97487]]], [[[-118.4549, 33.9631], [-118.45487, 33.96311], [-118.45486, 33.96309], [-118.45459, 33.96321], [-118.45466, 33.96334], [-118.45351, 33.96386], [-118.45343, 33.96376], [-118.45281, 33.96407], [-118.45287, 33.96416], [-118.45163, 33.96472], [-118.45097, 33.96374], [-118.45201, 33.96315], [-118.45278, 33.96275], [-118.45277, 33.96271], [-118.45305, 33.96258], [-118.45376, 33.96368], [-118.45391, 33.96362], [-118.45391, 33.9636], [-118.45319, 33.96251], [-118.45385, 33.96218], [-118.45391, 33.96225], [-118.45421, 33.96211], [-118.4549, 33.9631]]]]} | Open Access 1 | 6316 | Ballona Creek Trail and Bike Path | 30329 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 11.277 | Ballona Creek Trail and Bike Path | 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]);