units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 13
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4470 | 4470 | 4469 | {"type": "Polygon", "coordinates": [[[-116.37329, 33.19965], [-116.36458, 33.19964], [-116.36453, 33.19257], [-116.37324, 33.19257], [-116.37329, 33.19965]]]} | Restricted Access 2 | 1194 | Unnamed site - Borrego Water District | 28622 | 2008 | Borrego Water District 764 | Special District 4 | Water District 13 | http://www.borregowd.org/ | Special District 4 | 2008 | Borrego Water District 745 | Special District 4 | Water District 13 | San Diego 4 | 157.534 | 0 | Local Other or Unknown 14 | 4 | ||
5970 | 5970 | 5969 | {"type": "MultiPolygon", "coordinates": [[[[-121.99687, 37.31807], [-121.99678, 37.31822], [-121.99642, 37.31835], [-121.99611, 37.31865], [-121.99601, 37.31872], [-121.99588, 37.31878], [-121.99556, 37.31886], [-121.99556, 37.31875], [-121.99594, 37.31858], [-121.99612, 37.31844], [-121.99622, 37.31829], [-121.99632, 37.31819], [-121.99663, 37.31802], [-121.99666, 37.31798], [-121.99663, 37.31789], [-121.99659, 37.31785], [-121.99643, 37.3178], [-121.99638, 37.31774], [-121.99632, 37.31768], [-121.99625, 37.31755], [-121.99623, 37.31728], [-121.9962, 37.31716], [-121.99612, 37.31705], [-121.99605, 37.31692], [-121.99602, 37.31681], [-121.99602, 37.31669], [-121.99596, 37.31648], [-121.99588, 37.31636], [-121.99583, 37.31604], [-121.99587, 37.31571], [-121.99592, 37.31548], [-121.99598, 37.31533], [-121.99607, 37.31523], [-121.99612, 37.3151], [-121.99614, 37.31487], [-121.99614, 37.31461], [-121.99619, 37.31451], [-121.99629, 37.31436], [-121.99646, 37.31417], [-121.99651, 37.31406], [-121.99652, 37.31393], [-121.99648, 37.31368], [-121.99643, 37.31354], [-121.99639, 37.31349], [-121.99635, 37.31335], [-121.99644, 37.31279], [-121.99641, 37.31262], [-121.99635, 37.31252], [-121.996, 37.31216], [-121.99612, 37.31216], [-121.99644, 37.31233], [-121.99651, 37.31254], [-121.99653, 37.31314], [-121.99661, 37.31352], [-121.99667, 37.31372], [-121.99672, 37.31414], [-121.99647, 37.31443], [-121.99636, 37.31451], [-121.99624, 37.31491], [-121.99624, 37.31506], [-121.99614, 37.3152], [-121.99606, 37.31536], [-121.99604, 37.31552], [-121.99599, 37.31568], [-121.99607, 37.316], [-121.99609, 37.31655], [-121.99643, 37.31717], [-121.99645, 37.31758], [-121.99679, 37.31778], [-121.99687, 37.31807]]], [[[-122.00337, 37.29303], [-122.00317, 37.29332], [-122.00281, 37.29389], [-122.0028, 37.29395], [-122.00282, 37.29422], [-122.00274, 37.29439], [-122.00254, 37.29474], [-122.00216, 37.29501], [-122.00201, 37.29509], [-122.0012, 37.29591], [-122.00102, 37.29636], [-122.00084, 37.2967], [-122.00028, 37.29698], [-121.99946, 37.29707], [-121.99951, 37.29722], [-121.99928, 37.29726], [-121.99905, 37.29734], [-121.9984, 37.29763], [-121.99809, 37.29789], [-121.99805, 37.29804], [-121.99813, 37.29822], [-121.99822, 37.29835], [-121.99829, 37.29841], [-121.99833, 37.29858], [-121.99833, 37.29874], [-121.99826, 37.2989], [-121.99812, 37.2994], [-121.99813, 37.29959], [-121.99821, 37.30009], [-121.99824, 37.30039], [-121.99806, 37.30077], [-121.99782, 37.30105], [-121.99741, 37.30129], [-121.99732, 37.30136], [-121.99723, 37.30147], [-121.99698, 37.30196], [-121.99678, 37.30246], [-121.99666, 37.30287], [-121.99658, 37.30323], [-121.99653, 37.30367], [-121.99652, 37.30411], [-121.99655, 37.3045], [-121.99691, 37.30659], [-121.99698, 37.30734], [-121.99693, 37.30809], [-121.99668, 37.30965], [-121.99663, 37.30983], [-121.99605, 37.30986], [-121.99605, 37.30959], [-121.99647, 37.30747], [-121.99638, 37.30649], [-121.99626, 37.30583], [-121.99625, 37.30456], [-121.99622, 37.30433], [-121.99622, 37.30398], [-121.99622, 37.30375], [-121.99626, 37.30328], [-121.99635, 37.30282], [-121.99649, 37.30233], [-121.99668, 37.30185], [-121.99701, 37.3013], [-121.99741, 37.30045], [-121.99757, 37.3], [-121.99763, 37.29967], [-121.99768, 37.29913], [-121.99769, 37.29872], [-121.99768, 37.29831], [-121.99771, 37.2983], [-121.99771, 37.29828], [-121.99769, 37.29827], [-121.99771, 37.29805], [-121.99781, 37.29757], [-121.99838, 37.29718], [-121.99912, 37.29695], [-121.99931, 37.29691], [-121.99996, 37.29683], [-122.00031, 37.29674], [-122.00058, 37.29658], [-122.00076, 37.29637], [-122.00103, 37.29582], [-122.0016, 37.29519], [-122.00175, 37.29504], [-122.00237, 37.29459], [-122.00249, 37.29444], [-122.00256, 37.29425], [-122.00259, 37.29414], [-122.00264, 37.29364], [-122.00276, 37.29335], [-122.00302, 37.29299], [-122.00337, 37.29303]]]]} | Restricted Access 2 | 554 | Saratoga Creek | 25157 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 22.283 | Saratoga Creek | 1930 | Local Other or Unknown 14 | 4 | |
6332 | 6332 | 6331 | {"type": "MultiPolygon", "coordinates": [[[[-121.79513, 37.31362], [-121.79476, 37.31367], [-121.79477, 37.3137], [-121.79469, 37.31372], [-121.79464, 37.31371], [-121.7946, 37.31372], [-121.79456, 37.31379], [-121.79447, 37.31386], [-121.79431, 37.31361], [-121.7943, 37.31344], [-121.79412, 37.313], [-121.79392, 37.31287], [-121.7937, 37.31288], [-121.79326, 37.31307], [-121.79312, 37.31309], [-121.79279, 37.31299], [-121.79261, 37.31307], [-121.79255, 37.31312], [-121.79245, 37.31317], [-121.79239, 37.31317], [-121.7922, 37.31312], [-121.79212, 37.31295], [-121.79171, 37.31263], [-121.79165, 37.31261], [-121.7913, 37.31252], [-121.79079, 37.31267], [-121.79074, 37.31254], [-121.79032, 37.31187], [-121.7896, 37.31155], [-121.78932, 37.31129], [-121.7891, 37.31138], [-121.78884, 37.31135], [-121.78875, 37.31136], [-121.78864, 37.31135], [-121.78854, 37.31142], [-121.7883, 37.31151], [-121.78815, 37.31155], [-121.78811, 37.31154], [-121.78808, 37.31152], [-121.788, 37.31142], [-121.78758, 37.31103], [-121.78743, 37.31095], [-121.78726, 37.31091], [-121.78717, 37.31087], [-121.78691, 37.31065], [-121.78661, 37.31041], [-121.78648, 37.31036], [-121.78616, 37.31027], [-121.78597, 37.3101], [-121.78579, 37.30986], [-121.78572, 37.30982], [-121.78566, 37.3098], [-121.78549, 37.30979], [-121.78546, 37.30977], [-121.7854, 37.30959], [-121.78523, 37.3095], [-121.78501, 37.30944], [-121.7849, 37.30946], [-121.78464, 37.30953], [-121.78458, 37.30953], [-121.78455, 37.30953], [-121.78452, 37.30943], [-121.78449, 37.3094], [-121.78439, 37.30934], [-121.78428, 37.30933], [-121.78418, 37.30935], [-121.7841, 37.30934], [-121.78403, 37.30934], [-121.78391, 37.30933], [-121.78382, 37.30929], [-121.7837, 37.30922], [-121.78359, 37.30908], [-121.78349, 37.309], [-121.78339, 37.309], [-121.78317, 37.30906], [-121.78306, 37.30906], [-121.78238, 37.3089], [-121.78217, 37.30878], [-121.78198, 37.30865], [-121.78179, 37.30857], [-121.78133, 37.30848], [-121.78132, 37.30834], [-121.78123, 37.30824], [-121.78115, 37.30823], [-121.78111, 37.30824], [-121.78092, 37.30824], [-121.78086, 37.30822], [-121.78069, 37.30812], [-121.78057, 37.30801], [-121.78047, 37.30785], [-121.78044, 37.30759], [-121.78046, 37.30744], [-121.78039, 37.30734], [-121.78033, 37.30729], [-121.78025, 37.30727], [-121.77989, 37.30733], [-121.77981, 37.30733], [-121.77978, 37.30734], [-121.77967, 37.30734], [-121.7796, 37.30727], [-121.77959, 37.30724], [-121.77961, 37.30722], [-121.77961, 37.30719], [-121.7797, 37.3071], [-121.77973, 37.30702], [-121.77951, 37.30661], [-121.77937, 37.30649], [-121.77921, 37.3064], [-121.77913, 37.30632], [-121.77907, 37.30629], [-121.77891, 37.30615], [-121.77889, 37.30612], [-121.77887, 37.30602], [-121.77888, 37.30599], [-121.77899, 37.3059], [-121.77904, 37.30584], [-121.77907, 37.30576], [-121.77905, 37.30567], [-121.7789, 37.30558], [-121.77878, 37.30554], [-121.77855, 37.30551], [-121.77839, 37.30551], [-121.77831, 37.30547], [-121.77831, 37.30544], [-121.77837, 37.30535], [-121.77837, 37.30529], [-121.77834, 37.30523], [-121.77824, 37.30515], [-121.77808, 37.30506], [-121.77794, 37.30501], [-121.77782, 37.30497], [-121.7777, 37.30498], [-121.77761, 37.30494], [-121.77766, 37.30485], [-121.77783, 37.30474], [-121.77789, 37.30466], [-121.77781, 37.30455], [-121.77768, 37.30447], [-121.77761, 37.30431], [-121.7776, 37.30421], [-121.77757, 37.30409], [-121.77753, 37.30405], [-121.77751, 37.30399], [-121.77754, 37.30393], [-121.77757, 37.3039], [-121.77775, 37.30391], [-121.77789, 37.30388], [-121.77789, 37.30386], [-121.77782, 37.30374], [-121.77782, 37.30369], [-121.77798, 37.30364], [-121.77798, 37.30363], [-121.77753, 37.30333], [-121.77738, 37.30328], [-121.77731, 37.30324], [-121.77723, 37.30308], [-121.77723, 37.30304], [-121.77669, 37.30253], [-121.77666, 37.30255], [-121.77657, 37.30257], [-121.7765, 37.30256], [-121.77638, 37.30245], [-121.77622, 37.3024], [-121.77608, 37.30239], [-121.77604, 37.30239], [-121.7759, 37.30246], [-121.77581, 37.30246], [-121.77574, 37.30239], [-121.77573, 37.30233], [-121.77574, 37.30222], [-121.77576, 37.30217], [-121.77574, 37.30213], [-121.7757, 37.30211], [-121.77557, 37.30209], [-121.77538, 37.30215], [-121.77527, 37.30223], [-121.77517, 37.30222], [-121.77501, 37.30216], [-121.77479, 37.30199], [-121.77461, 37.30183], [-121.77459, 37.30174], [-121.77462, 37.30166], [-121.77473, 37.30159], [-121.77499, 37.30148], [-121.77523, 37.30143], [-121.7753, 37.30137], [-121.77533, 37.30132], [-121.77532, 37.30129], [-121.77523, 37.30123], [-121.77515, 37.30123], [-121.77505, 37.30119], [-121.77502, 37.30113], [-121.77491, 37.30099], [-121.77486, 37.30094], [-121.77483, 37.30094], [-121.7748, 37.30091], [-121.77476, 37.30076], [-121.77471, 37.30074], [-121.77453, 37.30052], [-121.77436, 37.30045], [-121.77402, 37.30046], [-121.77392, 37.30043], [-121.77382, 37.30037], [-121.77377, 37.3003], [-121.77375, 37.30021], [-121.77377, 37.30012], [-121.7738, 37.30004], [-121.7738, 37.29995], [-121.77375, 37.2999], [-121.77362, 37.29982], [-121.77352, 37.2998], [-121.77343, 37.29981], [-121.77337, 37.29979], [-121.77333, 37.29972], [-121.7733, 37.29959], [-121.77323, 37.29952], [-121.77306, 37.29943], [-121.77281, 37.29936], [-121.77262, 37.29933], [-121.7724, 37.29933], [-121.77143, 37.29824], [-121.77189, 37.29826], [-121.77206, 37.29815], [-121.77208, 37.29809], [-121.77205, 37.29802], [-121.77255, 37.29797], [-121.77261, 37.29825], [-121.77222, 37.29849], [-121.77222, 37.2985], [-121.77245, 37.29874], [-121.77281, 37.29905], [-121.77299, 37.29908], [-121.77344, 37.29932], [-121.77374, 37.29968], [-121.77401, 37.29991], [-121.77458, 37.30021], [-121.77474, 37.30033], [-121.7754, 37.30097], [-121.77544, 37.30099], [-121.77545, 37.30104], [-121.77545, 37.30126], [-121.77544, 37.30138], [-121.77535, 37.30151], [-121.77525, 37.3016], [-121.77521, 37.30171], [-121.77506, 37.30181], [-121.77513, 37.3019], [-121.77521, 37.30192], [-121.77548, 37.3019], [-121.77575, 37.30195], [-121.77623, 37.30225], [-121.77646, 37.30227], [-121.77656, 37.30224], [-121.77662, 37.3022], [-121.77671, 37.3021], [-121.77693, 37.30202], [-121.77702, 37.30202], [-121.77709, 37.30206], [-121.77715, 37.30215], [-121.77712, 37.30237], [-121.77725, 37.30287], [-121.77784, 37.30328], [-121.7782, 37.30355], [-121.77825, 37.30356], [-121.77806, 37.30403], [-121.77798, 37.30435], [-121.77805, 37.30461], [-121.77807, 37.30488], [-121.77831, 37.30498], [-121.77842, 37.30521], [-121.77923, 37.30568], [-121.77927, 37.30583], [-121.77921, 37.30596], [-121.77926, 37.30619], [-121.77967, 37.30648], [-121.78001, 37.30627], [-121.78016, 37.30623], [-121.78042, 37.30665], [-121.7803, 37.30671], [-121.78061, 37.30724], [-121.78053, 37.30737], [-121.78068, 37.30746], [-121.78072, 37.3076], [-121.78063, 37.30782], [-121.7809, 37.30804], [-121.78107, 37.30816], [-121.78123, 37.30813], [-121.78152, 37.30826], [-121.782, 37.30855], [-121.78226, 37.3086], [-121.78243, 37.30861], [-121.78257, 37.30886], [-121.78363, 37.30898], [-121.78422, 37.30917], [-121.78461, 37.30939], [-121.78526, 37.30929], [-121.78687, 37.31049], [-121.78755, 37.31086], [-121.78775, 37.31104], [-121.78779, 37.31116], [-121.78809, 37.31143], [-121.78864, 37.31114], [-121.78933, 37.31114], [-121.78991, 37.31117], [-121.79097, 37.31167], [-121.79112, 37.31226], [-121.79127, 37.31243], [-121.79175, 37.31255], [-121.79217, 37.31284], [-121.79244, 37.31296], [-121.79312, 37.31288], [-121.79345, 37.3127], [-121.79379, 37.31264], [-121.79406, 37.31267], [-121.79426, 37.31275], [-121.79438, 37.31282], [-121.7945, 37.31294], [-121.79473, 37.31291], [-121.79483, 37.31335], [-121.79509, 37.3135], [-121.79513, 37.31362]]], [[[-121.79481, 37.31439], [-121.7948, 37.31438], [-121.79471, 37.31425], [-121.79459, 37.31405], [-121.79481, 37.31439]]], [[[-121.79613, 37.31524], [-121.79613, 37.31524], [-121.79552, 37.31485], [-121.79588, 37.31504], [-121.79613, 37.31524]]], [[[-121.81151, 37.32935], [-121.81079, 37.33037], [-121.81076, 37.33045], [-121.81054, 37.33075], [-121.81035, 37.33126], [-121.8103, 37.33171], [-121.81034, 37.33223], [-121.81044, 37.33254], [-121.81064, 37.33281], [-121.81066, 37.33285], [-121.80993, 37.3331], [-121.80973, 37.33296], [-121.80954, 37.33262], [-121.80947, 37.33232], [-121.80943, 37.33195], [-121.80941, 37.33192], [-121.80949, 37.3313], [-121.80969, 37.33063], [-121.81024, 37.32976], [-121.81034, 37.32966], [-121.8104, 37.32944], [-121.81038, 37.32932], [-121.81034, 37.32919], [-121.80883, 37.32715], [-121.80873, 37.32712], [-121.80867, 37.32713], [-121.80862, 37.32709], [-121.80852, 37.32708], [-121.8077, 37.32482], [-121.80725, 37.32413], [-121.80355, 37.32011], [-121.80209, 37.3185], [-121.80088, 37.31775], [-121.79936, 37.31738], [-121.79859, 37.31709], [-121.79827, 37.31694], [-121.79787, 37.31671], [-121.79678, 37.3159], [-121.79656, 37.31569], [-121.79666, 37.31563], [-121.79685, 37.3158], [-121.79706, 37.31566], [-121.79718, 37.31568], [-121.79757, 37.31567], [-121.79833, 37.31623], [-121.79881, 37.31647], [-121.79921, 37.31657], [-121.79973, 37.31676], [-121.80033, 37.31684], [-121.80091, 37.31705], [-121.80124, 37.31704], [-121.80168, 37.31721], [-121.80265, 37.31783], [-121.80336, 37.31814], [-121.80365, 37.31844], [-121.80622, 37.32093], [-121.80628, 37.3213], [-121.80715, 37.32227], [-121.80764, 37.32306], [-121.80701, 37.32343], [-121.807, 37.32344], [-121.80917, 37.3257], [-121.80976, 37.32687], [-121.81151, 37.32935]]]]} | Restricted Access 2 | 1501 | Thompson Creek | 26312 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 75.045 | Thompson Creek | 1930 | Local Other or Unknown 14 | 4 | |
7261 | 7261 | 7260 | {"type": "Polygon", "coordinates": [[[-118.83515, 34.23259], [-118.83311, 34.24265], [-118.82882, 34.24621], [-118.81532, 34.23954], [-118.81766, 34.23382], [-118.81607, 34.2271], [-118.81847, 34.22638], [-118.8202, 34.22678], [-118.82229, 34.22626], [-118.82297, 34.22618], [-118.82348, 34.22618], [-118.82412, 34.22632], [-118.82474, 34.22653], [-118.82541, 34.22649], [-118.82606, 34.22664], [-118.83021, 34.22816], [-118.8305, 34.22913], [-118.83515, 34.23259]]]} | Restricted Access 2 | 49003 | Calleguas Municipal Water District Open Space | 33702 | 2441 | Calleguas Municipal Water District 855 | Special District 4 | Water District 13 | http://www.calleguas.com/ | Special District 4 | 2441 | Calleguas Municipal Water District 833 | Special District 4 | Water District 13 | Ventura 8 | 702.738 | Calleguas Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9221 | 9221 | 9220 | {"type": "Polygon", "coordinates": [[[-116.54539, 33.87038], [-116.54531, 33.88839], [-116.52908, 33.8882], [-116.51701, 33.88079], [-116.51072, 33.87731], [-116.51072, 33.87426], [-116.52798, 33.87415], [-116.52798, 33.8741], [-116.52804, 33.87409], [-116.52804, 33.87175], [-116.52813, 33.86807], [-116.52889, 33.8684], [-116.53005, 33.86884], [-116.53122, 33.86923], [-116.53242, 33.86956], [-116.53324, 33.86975], [-116.53488, 33.87006], [-116.53571, 33.87017], [-116.53697, 33.87031], [-116.53823, 33.87039], [-116.53908, 33.87041], [-116.54539, 33.87038]]]} | Restricted Access 2 | 15339 | Whitewater Floodplain Preserve | 27469 | 2019 | Coachella Valley Water District 905 | Special District 4 | Water District 13 | http://www.cvwd.org/ | Special District 4 | 2019 | Coachella Valley Water District 880 | Special District 4 | Water District 13 | Riverside 10 | 1162.356 | Whitewater Floodplain Preserve | 0 | Local Conservation Area 4 | 2 | |
11480 | 11480 | 11479 | {"type": "MultiPolygon", "coordinates": [[[[-122.14069, 37.79837], [-122.14037, 37.79835], [-122.13991, 37.79834], [-122.13961, 37.79836], [-122.13939, 37.79835], [-122.13903, 37.79829], [-122.13886, 37.79815], [-122.13879, 37.79806], [-122.13862, 37.79779], [-122.13837, 37.79753], [-122.13832, 37.79751], [-122.13828, 37.79753], [-122.13816, 37.79765], [-122.138, 37.79788], [-122.13789, 37.79801], [-122.13779, 37.79816], [-122.13759, 37.79839], [-122.13743, 37.79852], [-122.13732, 37.79858], [-122.13715, 37.7986], [-122.13702, 37.79856], [-122.1369, 37.79845], [-122.13682, 37.79827], [-122.13675, 37.79789], [-122.13672, 37.79786], [-122.13664, 37.79782], [-122.13651, 37.79781], [-122.13588, 37.79783], [-122.13556, 37.7978], [-122.13534, 37.79773], [-122.1348, 37.79729], [-122.13471, 37.79727], [-122.13463, 37.79727], [-122.13448, 37.79732], [-122.1342, 37.79734], [-122.13397, 37.79724], [-122.13388, 37.79718], [-122.13355, 37.79692], [-122.1334, 37.79678], [-122.13325, 37.79659], [-122.13317, 37.79652], [-122.13293, 37.7964], [-122.13269, 37.79595], [-122.1326, 37.7959], [-122.13232, 37.79589], [-122.13211, 37.79586], [-122.13199, 37.7958], [-122.13144, 37.79541], [-122.13133, 37.79535], [-122.13127, 37.79535], [-122.13124, 37.7954], [-122.13124, 37.79546], [-122.13126, 37.79553], [-122.13137, 37.79586], [-122.13143, 37.796], [-122.13151, 37.79612], [-122.13178, 37.79635], [-122.132, 37.79665], [-122.1322, 37.79685], [-122.13227, 37.79692], [-122.13247, 37.79704], [-122.13274, 37.79726], [-122.13312, 37.79747], [-122.13351, 37.79772], [-122.13398, 37.79795], [-122.13426, 37.79803], [-122.13512, 37.79819], [-122.13537, 37.79827], [-122.13547, 37.79832], [-122.13554, 37.79839], [-122.13558, 37.79849], [-122.13558, 37.79858], [-122.13555, 37.79866], [-122.13547, 37.79879], [-122.13544, 37.79887], [-122.13543, 37.79896], [-122.13544, 37.79904], [-122.13559, 37.79932], [-122.13565, 37.79953], [-122.13574, 37.80012], [-122.13592, 37.80059], [-122.13596, 37.80091], [-122.13598, 37.80133], [-122.136, 37.80145], [-122.13603, 37.80152], [-122.13614, 37.80164], [-122.13652, 37.80191], [-122.13666, 37.80208], [-122.13676, 37.80225], [-122.1368, 37.80246], [-122.13686, 37.80259], [-122.13696, 37.80266], [-122.13733, 37.80281], [-122.13748, 37.80295], [-122.13757, 37.80312], [-122.13763, 37.80336], [-122.13772, 37.80345], [-122.13796, 37.8036], [-122.1381, 37.8037], [-122.13824, 37.80392], [-122.13838, 37.80424], [-122.13844, 37.80432], [-122.13869, 37.80461], [-122.13874, 37.80475], [-122.11312, 37.80286], [-122.11311, 37.80288], [-122.06152, 37.79909], [-122.06008, 37.79892], [-122.06152, 37.79781], [-122.06152, 37.79322], [-122.07027, 37.79312], [-122.0701, 37.7789], [-122.07889, 37.77897], [-122.07891, 37.77896], [-122.07891, 37.76222], [-122.07739, 37.76222], [-122.07086, 37.7634], [-122.0708, 37.75898], [-122.06231, 37.75064], [-122.0612, 37.74505], [-122.06184, 37.73976], [-122.06104, 37.73876], [-122.0615, 37.73677], [-122.06164, 37.73527], [-122.06277, 37.73329], [-122.06427, 37.72563], [-122.06447, 37.72443], [-122.06456, 37.72317], [-122.06457, 37.72313], [-122.06506, 37.7223], [-122.06534, 37.72128], [-122.0654, 37.72096], [-122.06542, 37.72054], [-122.07284, 37.72081], [-122.07484, 37.72106], [-122.07555, 37.72129], [-122.07574, 37.72145], [-122.07584, 37.72146], [-122.07738, 37.72251], [-122.07826, 37.7232], [-122.07867, 37.72358], [-122.07883, 37.72374], [-122.07892, 37.72389], [-122.07918, 37.72419], [-122.07926, 37.72432], [-122.07945, 37.72458], [-122.07956, 37.72482], [-122.0796, 37.72502], [-122.07961, 37.72522], [-122.07958, 37.72559], [-122.07966, 37.72559], [-122.07954, 37.72646], [-122.07948, 37.72718], [-122.07956, 37.72759], [-122.07979, 37.72803], [-122.08003, 37.72904], [-122.08036, 37.73027], [-122.0805, 37.7309], [-122.08067, 37.73156], [-122.08075, 37.7319], [-122.08086, 37.73283], [-122.081, 37.73344], [-122.08072, 37.73396], [-122.08003, 37.73463], [-122.07935, 37.73515], [-122.07841, 37.73558], [-122.07775, 37.73569], [-122.077, 37.7359], [-122.07617, 37.73679], [-122.07626, 37.73685], [-122.07689, 37.73628], [-122.0771, 37.73612], [-122.07724, 37.73605], [-122.07743, 37.73599], [-122.07786, 37.73593], [-122.07808, 37.73591], [-122.07842, 37.73582], [-122.07859, 37.73574], [-122.07978, 37.73508], [-122.07994, 37.73495], [-122.08018, 37.73471], [-122.08103, 37.73376], [-122.08111, 37.7336], [-122.08116, 37.7334], [-122.08117, 37.73309], [-122.08102, 37.73239], [-122.08088, 37.73158], [-122.08036, 37.72917], [-122.07985, 37.72754], [-122.07978, 37.72704], [-122.07987, 37.72635], [-122.07996, 37.72524], [-122.07995, 37.72503], [-122.0799, 37.72479], [-122.07982, 37.72456], [-122.07967, 37.72432], [-122.07905, 37.72361], [-122.07877, 37.72333], [-122.07854, 37.72312], [-122.07791, 37.72262], [-122.07828, 37.72233], [-122.07877, 37.72271], [-122.07951, 37.72337], [-122.08007, 37.72388], [-122.08061, 37.72423], [-122.08098, 37.72438], [-122.08112, 37.72443], [-122.08131, 37.72463], [-122.08133, 37.72474], [-122.08138, 37.72485], [-122.08146, 37.72518], [-122.08143, 37.72523], [-122.08117, 37.72539], [-122.08106, 37.72544], [-122.08074, 37.72572], [-122.08049, 37.72609], [-122.08038, 37.72722], [-122.08038, 37.72787], [-122.08045, 37.72822], [-122.08051, 37.72841], [-122.08086, 37.72919], [-122.08107, 37.72944], [-122.08127, 37.72972], [-122.08155, 37.72991], [-122.08178, 37.73015], [-122.08189, 37.73044], [-122.08188, 37.73074], [-122.08193, 37.73107], [-122.08191, 37.73144], [-122.08196, 37.73158], [-122.08208, 37.732], [-122.08203, 37.73227], [-122.08193, 37.73241], [-122.08168, 37.73303], [-122.08157, 37.73334], [-122.08165, 37.7335], [-122.08179, 37.73368], [-122.08166, 37.73403], [-122.08157, 37.73462], [-122.08324, 37.7353], [-122.08403, 37.73527], [-122.08462, 37.73544], [-122.08643, 37.73912], [-122.08437, 37.73867], [-122.0824, 37.73835], [-122.08113, 37.7387], [-122.07753, 37.74106], [-122.07728, 37.742], [-122.08014, 37.74531], [-122.09082, 37.75259], [-122.09117, 37.7523], [-122.09252, 37.74859], [-122.09242, 37.74852], [-122.09282, 37.74853], [-122.09294, 37.74859], [-122.09329, 37.7487], [-122.09354, 37.74881], [-122.09367, 37.74888], [-122.09384, 37.74901], [-122.09397, 37.74919], [-122.09412, 37.7496], [-122.09423, 37.74973], [-122.09434, 37.7498], [-122.0945, 37.74985], [-122.09489, 37.7499], [-122.09524, 37.74999], [-122.09547, 37.75011], [-122.09567, 37.75024], [-122.0958, 37.75036], [-122.09592, 37.7505], [-122.09598, 37.75065], [-122.09598, 37.75076], [-122.09588, 37.75117], [-122.0959, 37.75127], [-122.09595, 37.75134], [-122.09601, 37.7514], [-122.09613, 37.75145], [-122.09627, 37.75145], [-122.09697, 37.75142], [-122.09718, 37.75145], [-122.09738, 37.75151], [-122.09767, 37.7517], [-122.09786, 37.75189], [-122.09793, 37.75199], [-122.09797, 37.7521], [-122.09799, 37.7523], [-122.09795, 37.75261], [-122.09795, 37.75273], [-122.09797, 37.75286], [-122.09802, 37.75297], [-122.09808, 37.75305], [-122.09831, 37.75317], [-122.09849, 37.75319], [-122.09875, 37.75325], [-122.09888, 37.75329], [-122.09907, 37.75338], [-122.09965, 37.75379], [-122.09992, 37.75393], [-122.10041, 37.75411], [-122.1006, 37.75415], [-122.10088, 37.75417], [-122.10103, 37.7542], [-122.10117, 37.75427], [-122.10128, 37.75439], [-122.10136, 37.75455], [-122.10142, 37.75474], [-122.10191, 37.75524], [-122.10196, 37.75534], [-122.10199, 37.75551], [-122.10193, 37.75615], [-122.10195, 37.75623], [-122.102, 37.7563], [-122.10225, 37.75646], [-122.10243, 37.75663], [-122.10252, 37.75673], [-122.10258, 37.75682], [-122.10261, 37.75691], [-122.10261, 37.75701], [-122.10251, 37.7575], [-122.1025, 37.75759], [-122.10252, 37.75766], [-122.10268, 37.75788], [-122.10276, 37.75797], [-122.10342, 37.75835], [-122.10382, 37.75853], [-122.10432, 37.75873], [-122.10466, 37.75892], [-122.10481, 37.75903], [-122.10511, 37.75933], [-122.10551, 37.7598], [-122.10592, 37.76014], [-122.106, 37.76025], [-122.10614, 37.76049], [-122.10629, 37.76066], [-122.10668, 37.76107], [-122.10805, 37.76241], [-122.10835, 37.76273], [-122.10844, 37.76285], [-122.10849, 37.76297], [-122.1085, 37.76308], [-122.10845, 37.76337], [-122.10841, 37.76356], [-122.10838, 37.76378], [-122.10837, 37.76407], [-122.10839, 37.76432], [-122.10843, 37.7646], [-122.10847, 37.7647], [-122.10859, 37.76494], [-122.10821, 37.76494], [-122.1082, 37.76495], [-122.10875, 37.76606], [-122.10947, 37.76679], [-122.10953, 37.76759], [-122.10975, 37.76755], [-122.11061, 37.76953], [-122.11146, 37.77032], [-122.1153, 37.77238], [-122.11715, 37.77264], [-122.11861, 37.77323], [-122.12055, 37.77505], [-122.12175, 37.77556], [-122.12398, 37.77716], [-122.12414, 37.77743], [-122.12394, 37.77791], [-122.12367, 37.77871], [-122.12414, 37.78002], [-122.12523, 37.78106], [-122.12561, 37.78246], [-122.12671, 37.78312], [-122.12844, 37.78621], [-122.12875, 37.78782], [-122.12934, 37.78865], [-122.12974, 37.78899], [-122.13084, 37.79034], [-122.13112, 37.79097], [-122.13107, 37.7913], [-122.13081, 37.79112], [-122.13079, 37.79113], [-122.13119, 37.7921], [-122.13256, 37.79298], [-122.133, 37.79445], [-122.13392, 37.79473], [-122.13425, 37.7948], [-122.13515, 37.7957], [-122.13547, 37.79597], [-122.13588, 37.79663], [-122.13633, 37.79691], [-122.13761, 37.79697], [-122.13829, 37.79721], [-122.13873, 37.79722], [-122.13898, 37.79735], [-122.13975, 37.79818], [-122.14069, 37.79837]]], [[[-122.22148, 37.87545], [-122.22138, 37.87533], [-122.21975, 37.8739], [-122.21952, 37.87365], [-122.21853, 37.87276], [-122.21766, 37.87226], [-122.21747, 37.87181], [-122.21738, 37.87172], [-122.21657, 37.86958], [-122.21636, 37.86907], [-122.21691, 37.86879], [-122.21701, 37.86913], [-122.21716, 37.86936], [-122.21757, 37.86976], [-122.21816, 37.87022], [-122.21869, 37.87069], [-122.21874, 37.8708], [-122.21873, 37.87092], [-122.21867, 37.87104], [-122.21848, 37.87128], [-122.21844, 37.87135], [-122.21841, 37.87145], [-122.21843, 37.87154], [-122.21846, 37.87162], [-122.21854, 37.87172], [-122.21917, 37.87238], [-122.21934, 37.87247], [-122.21957, 37.8725], [-122.22023, 37.87238], [-122.22037, 37.87241], [-122.22047, 37.8725], [-122.22054, 37.87262], [-122.2206, 37.87285], [-122.22062, 37.87307], [-122.22061, 37.8735], [-122.22063, 37.87363], [-122.2207, 37.8738], [-122.22078, 37.87393], [-122.2209, 37.87405], [-122.22136, 37.8743], [-122.22143, 37.87436], [-122.22148, 37.87446], [-122.22155, 37.87473], [-122.22168, 37.875], [-122.22169, 37.87512], [-122.22167, 37.87522], [-122.2216, 37.87533], [-122.22148, 37.87545]]], [[[-122.22268, 37.86612], [-122.22268, 37.86626], [-122.22265, 37.86633], [-122.22257, 37.86641], [-122.22247, 37.86644], [-122.22234, 37.86642], [-122.22203, 37.86625], [-122.22181, 37.86618], [-122.22154, 37.86616], [-122.22137, 37.86619], [-122.22124, 37.86624], [-122.22114, 37.86629], [-122.22043, 37.86676], [-122.22027, 37.86689], [-122.22012, 37.86709], [-122.21989, 37.86763], [-122.21978, 37.86776], [-122.21964, 37.86787], [-122.21947, 37.86795], [-122.21932, 37.86799], [-122.21865, 37.86806], [-122.21808, 37.8682], [-122.21979, 37.86733], [-122.22144, 37.86547], [-122.22268, 37.86612]]]]} | Restricted Access 2 | 23060 | EBMUD | 18418 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | Alameda 17 | 7314.768 | EBMUD | None 1019 | |||
12352 | 12352 | 12351 | {"type": "MultiPolygon", "coordinates": [[[[-121.89775, 37.33349], [-121.8975, 37.33361], [-121.8974, 37.33308], [-121.89744, 37.33307], [-121.89775, 37.33349]]], [[[-121.89812, 37.33398], [-121.89762, 37.33422], [-121.89752, 37.33373], [-121.89783, 37.33359], [-121.89812, 37.33398]]], [[[-121.90026, 37.3341], [-121.89891, 37.33473], [-121.89762, 37.33298], [-121.89903, 37.33231], [-121.89928, 37.33223], [-121.90012, 37.33219], [-121.90026, 37.3341]]], [[[-121.89873, 37.33481], [-121.89853, 37.33491], [-121.89838, 37.33472], [-121.89818, 37.33481], [-121.89813, 37.33476], [-121.89775, 37.33492], [-121.89764, 37.33433], [-121.89819, 37.33408], [-121.89873, 37.33481]]]]} | Restricted Access 2 | 26060 | Arena Green | 15579 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 12.575 | Arena Green | 0 | Local Park 2 | 4 | |
12485 | 12485 | 12484 | {"type": "MultiPolygon", "coordinates": [[[[-122.11441, 37.10226], [-122.11409, 37.10244], [-122.11371, 37.10199], [-122.11403, 37.10181], [-122.11441, 37.10226]]], [[[-122.10206, 37.1056], [-122.10205, 37.10662], [-122.10085, 37.10666], [-122.10083, 37.10563], [-122.10206, 37.1056]]], [[[-122.16468, 37.13212], [-122.15252, 37.13261], [-122.14581, 37.13246], [-122.14569, 37.12926], [-122.14311, 37.1292], [-122.14338, 37.12726], [-122.13678, 37.12735], [-122.13676, 37.12855], [-122.13603, 37.12871], [-122.13549, 37.12871], [-122.13561, 37.1285], [-122.13522, 37.12837], [-122.13524, 37.12819], [-122.13533, 37.12801], [-122.13532, 37.12793], [-122.13511, 37.12776], [-122.13504, 37.12763], [-122.135, 37.1276], [-122.13485, 37.12755], [-122.13476, 37.12749], [-122.13473, 37.12741], [-122.13472, 37.12728], [-122.13466, 37.12728], [-122.13499, 37.12128], [-122.12813, 37.12158], [-122.12712, 37.12159], [-122.12698, 37.12093], [-122.127, 37.12064], [-122.12699, 37.12063], [-122.12645, 37.12088], [-122.12556, 37.121], [-122.12539, 37.1211], [-122.12524, 37.12128], [-122.12528, 37.12023], [-122.12449, 37.12028], [-122.12425, 37.11833], [-122.12323, 37.11839], [-122.12417, 37.11768], [-122.12417, 37.11766], [-122.12365, 37.11737], [-122.12335, 37.11739], [-122.12332, 37.11723], [-122.12234, 37.11731], [-122.12227, 37.11678], [-122.12313, 37.11671], [-122.12295, 37.11525], [-122.12324, 37.11502], [-122.12314, 37.11477], [-122.12295, 37.1148], [-122.12287, 37.11395], [-122.11885, 37.11407], [-122.11877, 37.1139], [-122.11865, 37.11375], [-122.1185, 37.11361], [-122.11821, 37.1134], [-122.1181, 37.11326], [-122.11948, 37.11251], [-122.1189, 37.11112], [-122.11835, 37.11113], [-122.11821, 37.10696], [-122.11869, 37.10702], [-122.11908, 37.10695], [-122.11954, 37.10703], [-122.12036, 37.10734], [-122.12128, 37.10745], [-122.12212, 37.10735], [-122.12305, 37.10783], [-122.12348, 37.10813], [-122.12513, 37.10848], [-122.12583, 37.10877], [-122.12691, 37.10917], [-122.12765, 37.10903], [-122.1287, 37.10912], [-122.12937, 37.10914], [-122.13048, 37.10893], [-122.13174, 37.10958], [-122.13245, 37.10975], [-122.13308, 37.11024], [-122.13427, 37.11124], [-122.13486, 37.11136], [-122.13583, 37.11182], [-122.13592, 37.11188], [-122.1364, 37.10575], [-122.13648, 37.10232], [-122.13679, 37.10232], [-122.13702, 37.10237], [-122.13736, 37.10248], [-122.13922, 37.1032], [-122.13928, 37.10326], [-122.13934, 37.10352], [-122.13962, 37.10384], [-122.13988, 37.10423], [-122.14015, 37.10446], [-122.14038, 37.10469], [-122.1407, 37.10491], [-122.14042, 37.1094], [-122.14502, 37.10922], [-122.14502, 37.10929], [-122.14514, 37.10934], [-122.14505, 37.11226], [-122.14421, 37.11677], [-122.14836, 37.11688], [-122.14821, 37.12076], [-122.15287, 37.12079], [-122.15296, 37.12508], [-122.15295, 37.12538], [-122.15838, 37.12532], [-122.16099, 37.12928], [-122.16001, 37.12927], [-122.16, 37.12929], [-122.16468, 37.13212]]], [[[-122.12048, 37.13608], [-122.11998, 37.1362], [-122.11989, 37.13597], [-122.1197, 37.13576], [-122.11961, 37.13571], [-122.11917, 37.13553], [-122.11914, 37.13548], [-122.11914, 37.13543], [-122.11917, 37.13539], [-122.11923, 37.13538], [-122.1195, 37.13541], [-122.11953, 37.13548], [-122.11961, 37.13554], [-122.12036, 37.13575], [-122.12048, 37.13608]]]]} | Restricted Access 2 | 28258 | San Lorenzo Valley Water District | 24928 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 1314.823 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
13177 | 13177 | 13176 | {"type": "Polygon", "coordinates": [[[-122.71557, 38.43664], [-122.7155, 38.43665], [-122.7153, 38.43673], [-122.71434, 38.43728], [-122.71363, 38.43745], [-122.71335, 38.43707], [-122.71387, 38.43698], [-122.71424, 38.43687], [-122.71426, 38.43689], [-122.71442, 38.43684], [-122.71474, 38.4367], [-122.71518, 38.43644], [-122.7155, 38.43632], [-122.71557, 38.43664]]]} | Restricted Access 2 | 35168 | Prince Memorial Greenway | 24006 | 2156 | Sonoma County Water Agency 90 | Special District 4 | Water District 13 | http://www.scwa.ca.gov/ | Special District 4 | 2156 | Sonoma County Water Agency 88 | Special District 4 | Water District 13 | Sonoma 16 | 1.868 | Prince Memorial Greenway | 0 | Local Recreation Area 3 | 4 | |
14327 | 14327 | 14326 | {"type": "Polygon", "coordinates": [[[-117.08182, 34.04338], [-117.08156, 34.0439], [-117.08109, 34.0441], [-117.08057, 34.04376], [-117.08088, 34.04306], [-117.08067, 34.04183], [-117.08074, 34.04181], [-117.08064, 34.04121], [-117.08072, 34.0412], [-117.08098, 34.04269], [-117.08168, 34.04271], [-117.08177, 34.04301], [-117.08182, 34.04338]]]} | Restricted Access 2 | 44331 | Chapman Water Storage Tank | 17135 | 2303 | Yucaipa Valley Water District 1108 | Special District 4 | Water District 13 | http://www.yvwd.dst.ca.us/ | Special District 4 | 2303 | Yucaipa Valley Water District 1062 | Special District 4 | Water District 13 | San Bernardino 22 | 3.641 | Chapman Water Storage Tank | 0 | None 1209 | ||
14450 | 14450 | 14449 | {"type": "Polygon", "coordinates": [[[-121.75129, 37.41746], [-121.71353, 37.41782], [-121.71343, 37.41754], [-121.7134, 37.41721], [-121.71337, 37.4171], [-121.71325, 37.41691], [-121.71295, 37.41659], [-121.7129, 37.41649], [-121.71289, 37.41632], [-121.71292, 37.41622], [-121.71301, 37.4161], [-121.71306, 37.41609], [-121.71333, 37.41609], [-121.71358, 37.41603], [-121.7138, 37.41592], [-121.71397, 37.41577], [-121.71405, 37.41564], [-121.71411, 37.41544], [-121.71411, 37.41515], [-121.71409, 37.41499], [-121.71403, 37.41484], [-121.71388, 37.41464], [-121.71375, 37.41453], [-121.71338, 37.41431], [-121.71319, 37.41417], [-121.71303, 37.41401], [-121.71283, 37.41375], [-121.7127, 37.41345], [-121.71265, 37.41314], [-121.71266, 37.41294], [-121.71258, 37.41271], [-121.7124, 37.41239], [-121.71219, 37.4121], [-121.71206, 37.41178], [-121.71195, 37.41155], [-121.7118, 37.41134], [-121.71154, 37.41105], [-121.71145, 37.4109], [-121.7114, 37.41075], [-121.71136, 37.41041], [-121.7113, 37.41022], [-121.7112, 37.41004], [-121.711, 37.40979], [-121.70956, 37.40776], [-121.70916, 37.40728], [-121.7087, 37.40684], [-121.70819, 37.40644], [-121.70782, 37.40619], [-121.70714, 37.40581], [-121.70696, 37.40569], [-121.7065, 37.40523], [-121.70617, 37.40494], [-121.70581, 37.40466], [-121.70537, 37.40435], [-121.70523, 37.40419], [-121.70517, 37.40407], [-121.70514, 37.40387], [-121.70517, 37.40374], [-121.70526, 37.40355], [-121.70542, 37.4034], [-121.70599, 37.40306], [-121.70635, 37.40288], [-121.70672, 37.40273], [-121.73202, 37.40241], [-121.73192, 37.40006], [-121.734, 37.40076], [-121.73402, 37.3996], [-121.74087, 37.39735], [-121.74514, 37.40143], [-121.74665, 37.40506], [-121.75046, 37.40635], [-121.75129, 37.41746]]]} | Restricted Access 2 | 47062 | Rancho Canada de Pala | 30715 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 1557.569 | Rancho Canada de Pala | 0 | None 1229 |
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]);