units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where DES_TP = 14 and MNG_AGENCY = 129 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 35
MNG_AGENCY 1
- Poway, City of · 35 ✖
DES_TP 1
- Local Other or Unknown · 35 ✖
ACCESS_TYP 1
- Open Access 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13992 | 13992 | 13991 | {"type": "Polygon", "coordinates": [[[-117.02354, 33.00205], [-117.02349, 33.0021], [-117.02338, 33.0021], [-117.02348, 33.00185], [-117.02347, 33.00124], [-117.02325, 33.00034], [-117.02352, 33.00034], [-117.02356, 33.00132], [-117.02356, 33.00176], [-117.02354, 33.00205]]]} | Open Access 1 | 36674 | Poway holding 33 | 23958 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.628 | Poway holding 33 | 0 | Local Other or Unknown 14 | 4 | |
13953 | 13953 | 13952 | {"type": "Polygon", "coordinates": [[[-117.01467, 32.96351], [-117.01068, 32.96361], [-117.01063, 32.96125], [-117.01119, 32.96125], [-117.01145, 32.96129], [-117.01165, 32.96145], [-117.012, 32.96202], [-117.01304, 32.96183], [-117.01339, 32.96141], [-117.01338, 32.96072], [-117.01418, 32.96145], [-117.01434, 32.96161], [-117.01464, 32.96196], [-117.01467, 32.96351]]]} | Open Access 1 | 36589 | Poway holding 36 | 23961 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 20.871 | Poway holding 36 | 0 | Local Other or Unknown 14 | 4 | |
13573 | 13573 | 13572 | {"type": "Polygon", "coordinates": [[[-117.02693, 33.00207], [-117.02671, 33.00227], [-117.02652, 33.0025], [-117.02693, 33.00285], [-117.02677, 33.00296], [-117.0267, 33.00296], [-117.02655, 33.00283], [-117.02615, 33.00258], [-117.0265, 33.00173], [-117.02682, 33.00172], [-117.02693, 33.00207]]]} | Open Access 1 | 35892 | Poway holding 21 | 23945 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.303 | Poway holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13572 | 13572 | 13571 | {"type": "Polygon", "coordinates": [[[-117.02405, 33.00214], [-117.02394, 33.00214], [-117.02394, 33.00177], [-117.02401, 33.00177], [-117.02405, 33.00214]]]} | Open Access 1 | 35891 | Poway holding 22 | 23946 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.091 | Poway holding 22 | 0 | Local Other or Unknown 14 | 4 | |
13571 | 13571 | 13570 | {"type": "Polygon", "coordinates": [[[-117.03068, 33.02743], [-117.03049, 33.02762], [-117.03026, 33.02759], [-117.02995, 33.02739], [-117.02999, 33.0271], [-117.0306, 33.02717], [-117.03068, 33.02743]]]} | Open Access 1 | 35890 | Poway holding 16 | 23939 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.701 | Poway holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13570 | 13570 | 13569 | {"type": "Polygon", "coordinates": [[[-117.02761, 33.01797], [-117.0268, 33.01789], [-117.02633, 33.01779], [-117.02581, 33.01761], [-117.02556, 33.0175], [-117.02533, 33.01736], [-117.02512, 33.01722], [-117.02493, 33.01706], [-117.02462, 33.01673], [-117.02435, 33.01626], [-117.0242, 33.01588], [-117.02413, 33.01561], [-117.02411, 33.01538], [-117.02404, 33.01406], [-117.02405, 33.00967], [-117.02421, 33.00752], [-117.02423, 33.00748], [-117.02427, 33.00746], [-117.02452, 33.00747], [-117.02444, 33.00763], [-117.02428, 33.00781], [-117.02427, 33.00824], [-117.02433, 33.00874], [-117.02453, 33.00876], [-117.02567, 33.00915], [-117.02558, 33.00927], [-117.02493, 33.00904], [-117.02432, 33.00886], [-117.02415, 33.00934], [-117.02414, 33.01027], [-117.02433, 33.01055], [-117.02416, 33.01078], [-117.02428, 33.01198], [-117.02412, 33.01289], [-117.02413, 33.0135], [-117.02423, 33.01492], [-117.02433, 33.01536], [-117.02454, 33.0158], [-117.02464, 33.01648], [-117.02518, 33.01699], [-117.02543, 33.01719], [-117.02575, 33.0174], [-117.0261, 33.01757], [-117.02641, 33.01769], [-117.02668, 33.01774], [-117.02694, 33.01776], [-117.02718, 33.01774], [-117.02748, 33.01768], [-117.02761, 33.01797]]]} | Open Access 1 | 35889 | Poway holding 19 | 23942 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 5.896 | Poway holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13567 | 13567 | 13566 | {"type": "Polygon", "coordinates": [[[-117.06327, 32.94069], [-117.06306, 32.94078], [-117.06169, 32.94128], [-117.0611, 32.94144], [-117.06072, 32.9415], [-117.06022, 32.94152], [-117.05984, 32.94149], [-117.05853, 32.94129], [-117.05793, 32.94123], [-117.05736, 32.94113], [-117.05799, 32.93991], [-117.05821, 32.93985], [-117.05851, 32.93909], [-117.0584, 32.93834], [-117.0578, 32.93806], [-117.05733, 32.93674], [-117.05925, 32.93567], [-117.05995, 32.93537], [-117.05998, 32.93542], [-117.06001, 32.93541], [-117.06008, 32.93543], [-117.0604, 32.93597], [-117.06052, 32.93624], [-117.06071, 32.93649], [-117.06182, 32.93759], [-117.0621, 32.93796], [-117.06238, 32.9384], [-117.06325, 32.94015], [-117.06327, 32.94069]]]} | Open Access 1 | 35884 | Poway holding 24 | 23948 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 60.262 | Poway holding 24 | 0 | Local Other or Unknown 14 | 4 | |
13565 | 13565 | 13564 | {"type": "Polygon", "coordinates": [[[-117.02115, 33.0368], [-117.02121, 33.03705], [-117.0212, 33.03732], [-117.02117, 33.03749], [-117.02106, 33.03778], [-117.01992, 33.03762], [-117.01916, 33.03763], [-117.01847, 33.03811], [-117.01844, 33.03675], [-117.01851, 33.03601], [-117.01863, 33.03599], [-117.01867, 33.03628], [-117.01921, 33.03685], [-117.01949, 33.03686], [-117.01956, 33.03695], [-117.01967, 33.03697], [-117.01975, 33.03695], [-117.01984, 33.03688], [-117.01992, 33.03686], [-117.02016, 33.03684], [-117.02051, 33.03686], [-117.02086, 33.03683], [-117.02109, 33.03678], [-117.02115, 33.0368]]]} | Open Access 1 | 35879 | Poway holding 23 | 23947 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 6.883 | Poway holding 23 | 0 | Local Other or Unknown 14 | 4 | |
13562 | 13562 | 13561 | {"type": "Polygon", "coordinates": [[[-117.00336, 33.02647], [-117.00107, 33.02643], [-117.00114, 33.02272], [-117.00329, 33.02279], [-117.00336, 33.02647]]]} | Open Access 1 | 35877 | Poway holding 20 | 23944 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 21.006 | Poway holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13559 | 13559 | 13558 | {"type": "Polygon", "coordinates": [[[-117.04405, 32.94565], [-117.04344, 32.94627], [-117.0432, 32.94661], [-117.04302, 32.94695], [-117.04291, 32.94721], [-117.04284, 32.94748], [-117.04268, 32.94849], [-117.04261, 32.94875], [-117.04244, 32.94924], [-117.04222, 32.9497], [-117.04196, 32.95008], [-117.04164, 32.95046], [-117.04123, 32.95084], [-117.04107, 32.95104], [-117.04093, 32.95105], [-117.04101, 32.94915], [-117.04098, 32.94491], [-117.04177, 32.94509], [-117.04247, 32.94521], [-117.04364, 32.94544], [-117.04405, 32.94565]]]} | Open Access 1 | 35874 | Poway holding 25 | 23949 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 25.737 | Poway holding 25 | 0 | Local Other or Unknown 14 | 4 | |
13558 | 13558 | 13557 | {"type": "Polygon", "coordinates": [[[-117.02155, 32.96348], [-117.01891, 32.96349], [-117.01891, 32.96168], [-117.01906, 32.96168], [-117.01907, 32.9623], [-117.0192, 32.96265], [-117.0194, 32.96284], [-117.01979, 32.96292], [-117.01991, 32.9627], [-117.02, 32.96238], [-117.02, 32.96233], [-117.02056, 32.96236], [-117.02085, 32.96229], [-117.02135, 32.96256], [-117.02155, 32.96272], [-117.02155, 32.96348]]]} | Open Access 1 | 35873 | Poway holding 26 | 23950 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 6.785 | Poway holding 26 | 0 | Local Other or Unknown 14 | 4 | |
13545 | 13545 | 13544 | {"type": "Polygon", "coordinates": [[[-117.03223, 33.02732], [-117.03223, 33.0274], [-117.0322, 33.02753], [-117.03215, 33.02762], [-117.03205, 33.02772], [-117.03127, 33.02818], [-117.03061, 33.02848], [-117.0306, 33.02849], [-117.03032, 33.02863], [-117.03001, 33.0288], [-117.02974, 33.029], [-117.02938, 33.0293], [-117.02869, 33.03006], [-117.02813, 33.0297], [-117.02657, 33.03019], [-117.02603, 33.02982], [-117.0251, 33.0303], [-117.02605, 33.0314], [-117.0269, 33.03161], [-117.02686, 33.03184], [-117.02659, 33.03256], [-117.02724, 33.033], [-117.02797, 33.03252], [-117.02826, 33.03268], [-117.02924, 33.03206], [-117.0295, 33.03206], [-117.02948, 33.03383], [-117.02838, 33.03472], [-117.02818, 33.03446], [-117.0279, 33.03436], [-117.02771, 33.03419], [-117.02742, 33.03411], [-117.02694, 33.0341], [-117.02667, 33.03402], [-117.02625, 33.03381], [-117.0261, 33.03365], [-117.02591, 33.03327], [-117.0258, 33.03295], [-117.02576, 33.03258], [-117.02564, 33.03202], [-117.02522, 33.03132], [-117.025, 33.03105], [-117.02385, 33.03105], [-117.02384, 33.03093], [-117.02385, 33.03065], [-117.02391, 33.03028], [-117.02402, 33.02997], [-117.02464, 33.02858], [-117.0247, 33.0283], [-117.02472, 33.02802], [-117.02485, 33.02804], [-117.02495, 33.02809], [-117.02502, 33.02815], [-117.02554, 33.02893], [-117.02562, 33.029], [-117.02571, 33.02903], [-117.02583, 33.02904], [-117.02616, 33.0297], [-117.02722, 33.02928], [-117.02638, 33.02771], [-117.02468, 33.02715], [-117.02468, 33.02703], [-117.02471, 33.02682], [-117.0248, 33.02653], [-117.02499, 33.02615], [-117.02519, 33.0259], [-117.02544, 33.02565], [-117.02558, 33.02548], [-117.02571, 33.02529], [-117.02582, 33.02506], [-117.02599, 33.02482], [-117.02616, 33.02465], [-117.0263, 33.02454], [-117.02641, 33.02447], [-117.027, 33.02415], [-117.02723, 33.02395], [-117.02739, 33.02372], [-117.0276, 33.02315], [-117.02778, 33.02287], [-117.02823, 33.02236], [-117.02878, 33.02179], [-117.02904, 33.02156], [-117.0294, 33.02128], [-117.02955, 33.02114], [-117.02965, 33.02101], [-117.02976, 33.02083], [-117.02982, 33.02064], [-117.02983, 33.02055], [-117.03009, 33.02029], [-117.03024, 33.02009], [-117.03044, 33.02005], [-117.03062, 33.02005], [-117.03074, 33.02008], [-117.03085, 33.02012], [-117.03099, 33.02023], [-117.03117, 33.02048], [-117.03075, 33.02071], [-117.0303, 33.02441], [-117.03109, 33.02718], [-117.03195, 33.02699], [-117.03213, 33.02697], [-117.03223, 33.02732]], [[-117.02995, 33.02739], [-117.03026, 33.02759], [-117.03048, 33.02762], [-117.03068, 33.02743], [-117.0306, 33.02717], [-117.03, 33.0271], [-117.02995, 33.02739]]]} | Open Access 1 | 35856 | Poway holding 15 | 23938 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 119.11 | Poway holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13543 | 13543 | 13542 | {"type": "Polygon", "coordinates": [[[-117.05278, 33.02232], [-117.05243, 33.02356], [-117.05042, 33.02282], [-117.05057, 33.02268], [-117.05073, 33.02259], [-117.05091, 33.02252], [-117.05125, 33.02246], [-117.05136, 33.02241], [-117.05151, 33.02232], [-117.05278, 33.02232]]]} | Open Access 1 | 35855 | Poway holding 13 | 23936 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 4.433 | Poway holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13542 | 13542 | 13541 | {"type": "Polygon", "coordinates": [[[-117.02825, 33.0206], [-117.02825, 33.02204], [-117.02771, 33.02203], [-117.0277, 33.02191], [-117.02771, 33.02146], [-117.02758, 33.02145], [-117.02758, 33.02065], [-117.02643, 33.02023], [-117.02648, 33.01995], [-117.0274, 33.01995], [-117.02825, 33.0206]]]} | Open Access 1 | 35854 | Poway holding 14 | 23937 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 4.086 | Poway holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13541 | 13541 | 13540 | {"type": "Polygon", "coordinates": [[[-117.02371, 33.00922], [-117.02368, 33.00986], [-117.02367, 33.01319], [-117.02363, 33.01325], [-117.02347, 33.01326], [-117.02353, 33.013], [-117.02353, 33.01255], [-117.02357, 33.01119], [-117.02337, 33.01058], [-117.02331, 33.01021], [-117.02355, 33.00952], [-117.02355, 33.00938], [-117.02348, 33.00917], [-117.02366, 33.00918], [-117.02369, 33.00919], [-117.02371, 33.00922]]]} | Open Access 1 | 35853 | Poway holding 12 | 23935 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.944 | Poway holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13540 | 13540 | 13539 | {"type": "Polygon", "coordinates": [[[-117.02815, 33.00388], [-117.02776, 33.00411], [-117.02767, 33.0045], [-117.02735, 33.00465], [-117.02745, 33.00503], [-117.02729, 33.00571], [-117.02741, 33.00617], [-117.02718, 33.00647], [-117.02748, 33.00684], [-117.02709, 33.00695], [-117.02685, 33.00632], [-117.02636, 33.00622], [-117.02635, 33.00607], [-117.02637, 33.00592], [-117.02701, 33.00604], [-117.02713, 33.00529], [-117.02715, 33.00465], [-117.02718, 33.0044], [-117.02746, 33.00417], [-117.02761, 33.00355], [-117.02726, 33.00317], [-117.02684, 33.00317], [-117.02684, 33.00313], [-117.02686, 33.00309], [-117.02727, 33.00279], [-117.02813, 33.00347], [-117.02815, 33.00388]]]} | Open Access 1 | 35849 | Poway holding 10 | 23933 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 4.566 | Poway holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13527 | 13527 | 13526 | {"type": "Polygon", "coordinates": [[[-117.02371, 33.01452], [-117.0236, 33.01454], [-117.02354, 33.01365], [-117.02349, 33.01341], [-117.02363, 33.01341], [-117.02368, 33.01347], [-117.02367, 33.01393], [-117.02371, 33.01452]]]} | Open Access 1 | 35824 | Poway holding 31 | 23956 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.361 | Poway holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13526 | 13526 | 13525 | {"type": "Polygon", "coordinates": [[[-117.03112, 33.0179], [-117.03112, 33.01828], [-117.03018, 33.0182], [-117.02981, 33.01779], [-117.03112, 33.0179]]]} | Open Access 1 | 35823 | Poway holding 32 | 23957 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.1 | Poway holding 32 | 0 | Local Other or Unknown 14 | 4 | |
13525 | 13525 | 13524 | {"type": "Polygon", "coordinates": [[[-117.05948, 32.9619], [-117.05908, 32.96188], [-117.0591, 32.96481], [-117.05736, 32.9648], [-117.0574, 32.96441], [-117.05678, 32.96442], [-117.05736, 32.96317], [-117.0573, 32.96299], [-117.05708, 32.9631], [-117.05686, 32.9631], [-117.05685, 32.96274], [-117.057, 32.96261], [-117.05757, 32.96261], [-117.05757, 32.96294], [-117.05838, 32.96292], [-117.05838, 32.96226], [-117.05817, 32.96171], [-117.05927, 32.96123], [-117.05927, 32.96136], [-117.05948, 32.9619]]]} | Open Access 1 | 35822 | Poway holding 37 | 23962 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 13.225 | Poway holding 37 | 0 | Local Other or Unknown 14 | 4 | |
13524 | 13524 | 13523 | {"type": "Polygon", "coordinates": [[[-117.02155, 32.95986], [-117.02155, 32.95994], [-117.02103, 32.95994], [-117.02095, 32.96008], [-117.02096, 32.96039], [-117.02106, 32.96047], [-117.02091, 32.96064], [-117.02085, 32.96074], [-117.0208, 32.96091], [-117.0208, 32.96142], [-117.02082, 32.96161], [-117.0209, 32.96194], [-117.02088, 32.96203], [-117.02077, 32.96215], [-117.02066, 32.96219], [-117.02019, 32.96218], [-117.02019, 32.96179], [-117.02008, 32.96109], [-117.02, 32.96079], [-117.01987, 32.96057], [-117.01968, 32.96061], [-117.01969, 32.96053], [-117.01966, 32.96046], [-117.01972, 32.96042], [-117.01971, 32.95998], [-117.01905, 32.95999], [-117.01906, 32.96152], [-117.0189, 32.96152], [-117.01889, 32.95985], [-117.02155, 32.95986]]]} | Open Access 1 | 35821 | Poway holding 8 | 23967 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 6.389 | Poway holding 8 | 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]);