units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
78 rows where DES_TP = 14 and MNG_AG_TYP = 13 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY 10
- Yuba County Water Agency 48
- Santa Clara Valley Water District 2
- Marin Municipal Water District 1
- Metropolitan Water District of Southern California 1
- Soquel Creek Water District 1
- Borrego Water District 1
- Orange County Water District 1
- Helix Water District 1
- California Reclamation District 2140 1
- Olivenhain Municipal Water District 1
ACCESS_TYP 4
MNG_AG_TYP 1
- Water District · 58 ✖
DES_TP 1
- Local Other or Unknown · 58 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8366 | 8366 | 8365 | {"type": "MultiPolygon", "coordinates": [[[[-117.18387, 33.06916], [-117.18373, 33.06922], [-117.18365, 33.06932], [-117.18344, 33.07003], [-117.18341, 33.07029], [-117.18336, 33.07037], [-117.18326, 33.07043], [-117.18318, 33.07045], [-117.18309, 33.07045], [-117.18301, 33.07043], [-117.18294, 33.07039], [-117.18275, 33.07017], [-117.18254, 33.06981], [-117.1824, 33.06968], [-117.18218, 33.06958], [-117.18192, 33.06954], [-117.18178, 33.06956], [-117.18174, 33.0696], [-117.18151, 33.0701], [-117.18141, 33.07027], [-117.18136, 33.07032], [-117.1812, 33.07042], [-117.1811, 33.07045], [-117.18043, 33.0706], [-117.18028, 33.07002], [-117.18012, 33.0692], [-117.18003, 33.06895], [-117.17992, 33.06872], [-117.17978, 33.06849], [-117.17962, 33.06828], [-117.17868, 33.06726], [-117.17963, 33.06745], [-117.18029, 33.06709], [-117.18124, 33.06728], [-117.18187, 33.06772], [-117.18368, 33.06734], [-117.18365, 33.06748], [-117.18206, 33.06821], [-117.1829, 33.06886], [-117.18303, 33.06925], [-117.18341, 33.06973], [-117.18342, 33.06972], [-117.18351, 33.06935], [-117.18357, 33.06925], [-117.18366, 33.06916], [-117.18377, 33.0691], [-117.18385, 33.0691], [-117.18387, 33.06916]]], [[[-117.19147, 33.06983], [-117.19147, 33.07279], [-117.18792, 33.07272], [-117.18861, 33.07056], [-117.18953, 33.07], [-117.18955, 33.06987], [-117.18959, 33.06977], [-117.18967, 33.06969], [-117.18991, 33.06953], [-117.18996, 33.06945], [-117.18997, 33.06936], [-117.19039, 33.06936], [-117.19051, 33.06954], [-117.19066, 33.06972], [-117.19077, 33.06983], [-117.1909, 33.06989], [-117.19107, 33.06991], [-117.19147, 33.06983]]], [[[-117.19582, 33.06557], [-117.19572, 33.07105], [-117.19575, 33.07289], [-117.19572, 33.07671], [-117.19463, 33.07669], [-117.19462, 33.07288], [-117.19238, 33.07281], [-117.19238, 33.0728], [-117.1925, 33.07226], [-117.19265, 33.0719], [-117.19286, 33.0715], [-117.19317, 33.07106], [-117.19333, 33.07088], [-117.19355, 33.07066], [-117.19383, 33.07071], [-117.1941, 33.07069], [-117.19437, 33.0706], [-117.1946, 33.07045], [-117.19473, 33.07031], [-117.19533, 33.06926], [-117.19312, 33.06831], [-117.19276, 33.06678], [-117.1915, 33.06679], [-117.19016, 33.06706], [-117.19071, 33.06551], [-117.1907, 33.0655], [-117.18733, 33.06546], [-117.18032, 33.06543], [-117.18024, 33.06347], [-117.17941, 33.06231], [-117.17797, 33.0623], [-117.17796, 33.06231], [-117.17798, 33.06244], [-117.17603, 33.06242], [-117.17442, 33.06314], [-117.17441, 33.06186], [-117.17988, 33.06189], [-117.18201, 33.06488], [-117.18723, 33.0649], [-117.18724, 33.06429], [-117.19045, 33.06383], [-117.19209, 33.06309], [-117.19233, 33.0636], [-117.19277, 33.06357], [-117.19333, 33.06389], [-117.1936, 33.0645], [-117.19346, 33.06478], [-117.19502, 33.06533], [-117.19514, 33.06543], [-117.19531, 33.06551], [-117.19539, 33.06553], [-117.19582, 33.06553], [-117.19582, 33.06557]]], [[[-117.20097, 33.07956], [-117.20047, 33.08043], [-117.19958, 33.08044], [-117.20028, 33.08074], [-117.1994, 33.08154], [-117.19938, 33.08409], [-117.19718, 33.08404], [-117.19637, 33.08404], [-117.19471, 33.08541], [-117.19466, 33.08403], [-117.1907, 33.08402], [-117.19073, 33.08041], [-117.19861, 33.08043], [-117.19921, 33.07967], [-117.19883, 33.0795], [-117.19929, 33.07918], [-117.20046, 33.07911], [-117.20097, 33.07956]]]]} | No Public Access 3 | 12964 | Second San Diego Aqueduct | 25278 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | San Diego 4 | 253.17 | Second San Diego Aqueduct | 0 | 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 | |
4777 | 4777 | 4776 | {"type": "MultiPolygon", "coordinates": [[[[-121.96433, 39.7002], [-121.95674, 39.70022], [-121.95595, 39.69996], [-121.9525, 39.69944], [-121.95205, 39.69939], [-121.94998, 39.6995], [-121.94872, 39.69951], [-121.94823, 39.69947], [-121.94758, 39.69855], [-121.94715, 39.69818], [-121.94507, 39.69813], [-121.94469, 39.69776], [-121.94423, 39.69735], [-121.9474, 39.69738], [-121.95119, 39.69737], [-121.96395, 39.69723], [-121.96396, 39.69727], [-121.96418, 39.69771], [-121.96414, 39.69802], [-121.96423, 39.69998], [-121.96426, 39.70011], [-121.9643, 39.70015], [-121.9643, 39.70019], [-121.96433, 39.7002]]], [[[-121.98853, 39.73431], [-121.98685, 39.73561], [-121.98613, 39.73628], [-121.98554, 39.73691], [-121.98496, 39.73755], [-121.98343, 39.73544], [-121.98109, 39.73383], [-121.97953, 39.7334], [-121.9777, 39.73315], [-121.97722, 39.7332], [-121.97662, 39.73314], [-121.9738, 39.73168], [-121.97187, 39.73169], [-121.97086, 39.73213], [-121.96714, 39.73021], [-121.96683, 39.72966], [-121.96893, 39.7228], [-121.96913, 39.72267], [-121.96916, 39.72244], [-121.96918, 39.72243], [-121.96919, 39.7224], [-121.96873, 39.72239], [-121.9681, 39.72198], [-121.96751, 39.721], [-121.96705, 39.7203], [-121.96639, 39.71954], [-121.96619, 39.71936], [-121.96549, 39.71886], [-121.96484, 39.71853], [-121.96345, 39.71787], [-121.9625, 39.71753], [-121.96195, 39.71746], [-121.96147, 39.71747], [-121.95959, 39.7177], [-121.95892, 39.71786], [-121.95806, 39.71817], [-121.95717, 39.71856], [-121.95665, 39.71899], [-121.95625, 39.71927], [-121.956, 39.71938], [-121.9557, 39.71924], [-121.95535, 39.71878], [-121.95533, 39.71857], [-121.95535, 39.71834], [-121.95529, 39.71806], [-121.95527, 39.71785], [-121.9552, 39.71763], [-121.95499, 39.71742], [-121.95451, 39.71729], [-121.95413, 39.71726], [-121.95397, 39.71715], [-121.95372, 39.71686], [-121.95321, 39.71645], [-121.95298, 39.7163], [-121.95238, 39.71582], [-121.9523, 39.71557], [-121.95228, 39.7154], [-121.95238, 39.71524], [-121.95257, 39.71518], [-121.95261, 39.71461], [-121.95259, 39.71428], [-121.95242, 39.71366], [-121.95226, 39.71317], [-121.95223, 39.71286], [-121.95504, 39.71284], [-121.95554, 39.71292], [-121.95668, 39.7132], [-121.95693, 39.71323], [-121.95718, 39.71321], [-121.95744, 39.71316], [-121.95895, 39.71283], [-121.95985, 39.71284], [-121.97012, 39.71278], [-121.97016, 39.71283], [-121.97084, 39.71283], [-121.97155, 39.71309], [-121.97705, 39.71513], [-121.97717, 39.71516], [-121.97735, 39.71525], [-121.97741, 39.71532], [-121.98006, 39.71721], [-121.98024, 39.71736], [-121.98033, 39.71746], [-121.98045, 39.71762], [-121.98081, 39.7183], [-121.98087, 39.71835], [-121.98095, 39.71849], [-121.98096, 39.71857], [-121.98247, 39.72141], [-121.98283, 39.72148], [-121.98287, 39.72151], [-121.98577, 39.72817], [-121.98841, 39.7341], [-121.98853, 39.73431]], [[-121.97119, 39.72095], [-121.97118, 39.72094], [-121.9709, 39.72122], [-121.97118, 39.72105], [-121.97119, 39.72095]], [[-121.97124, 39.71932], [-121.97122, 39.71933], [-121.97132, 39.72006], [-121.97135, 39.71989], [-121.97124, 39.71932]]]]} | No Public Access 3 | 47067 | Unnamed Site - California Reclamation District 2140 | 30720 | 2404 | California Reclamation District 2140 779 | Special District 4 | Water District 13 | http://www.rd2140.org/ | Special District 4 | 2404 | California Reclamation District 2140 759 | Special District 4 | Water District 13 | Glenn 55 | 1016.152 | 0 | Local Other or Unknown 14 | 4 | ||
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 | ||
4759 | 4759 | 4758 | {"type": "Polygon", "coordinates": [[[-116.89337, 32.86769], [-116.89335, 32.87083], [-116.89269, 32.87075], [-116.89171, 32.87067], [-116.89084, 32.87071], [-116.88852, 32.8713], [-116.88757, 32.87172], [-116.88715, 32.87197], [-116.88627, 32.87239], [-116.88579, 32.87264], [-116.88517, 32.87306], [-116.88341, 32.87378], [-116.88276, 32.87409], [-116.88211, 32.8745], [-116.88159, 32.87481], [-116.88042, 32.87556], [-116.87951, 32.87611], [-116.87854, 32.87675], [-116.87777, 32.87717], [-116.87882, 32.87389], [-116.88144, 32.87294], [-116.88354, 32.87188], [-116.88375, 32.87177], [-116.88407, 32.87153], [-116.88412, 32.87153], [-116.88423, 32.87144], [-116.88619, 32.86953], [-116.88642, 32.86932], [-116.88665, 32.86914], [-116.88691, 32.86897], [-116.88719, 32.86882], [-116.88743, 32.86871], [-116.88787, 32.86854], [-116.88831, 32.86843], [-116.89254, 32.868], [-116.89295, 32.86788], [-116.89337, 32.86769]]]} | Unknown Access 4 | 46690 | Unnamed site - Helix Water District | 30035 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2046 | Helix Water District 757 | Special District 4 | Water District 13 | San Diego 4 | 97.198 | 0 | Local Other or Unknown 14 | 4 | ||
12947 | 12947 | 12946 | {"type": "Polygon", "coordinates": [[[-122.7189, 38.00463], [-122.71194, 38.00951], [-122.71172, 38.00902], [-122.71158, 38.00864], [-122.71153, 38.00846], [-122.7115, 38.00822], [-122.71152, 38.00798], [-122.71149, 38.00747], [-122.71143, 38.00558], [-122.71139, 38.00545], [-122.71134, 38.00537], [-122.71121, 38.00521], [-122.7111, 38.00512], [-122.71096, 38.00504], [-122.70905, 38.00459], [-122.70878, 38.00436], [-122.70898, 38.00222], [-122.70973, 38.00241], [-122.71033, 38.00244], [-122.71077, 38.00238], [-122.71126, 38.00226], [-122.71183, 38.00224], [-122.71202, 38.00226], [-122.7122, 38.00236], [-122.71258, 38.0025], [-122.7131, 38.00264], [-122.71425, 38.00324], [-122.71522, 38.00268], [-122.7189, 38.00463]]]} | Open Access 1 | 44744 | Unnamed site - Marin Municipal Water District | 30015 | 2071 | Marin Municipal Water District 254 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | Marin 23 | 87.659 | 0 | Local Other or Unknown 14 | 4 | ||
4620 | 4620 | 4619 | {"type": "MultiPolygon", "coordinates": [[[[-117.49797, 34.15236], [-117.49796, 34.15242], [-117.4955, 34.15391], [-117.49542, 34.1537], [-117.49785, 34.15222], [-117.49797, 34.15236]]], [[[-117.50131, 34.1506], [-117.50095, 34.15068], [-117.50075, 34.15075], [-117.50056, 34.15084], [-117.49821, 34.15226], [-117.49812, 34.15225], [-117.498, 34.15212], [-117.50052, 34.1506], [-117.50131, 34.1506]]]]} | Open Access 1 | 36134 | Unnamed site - Metropolitan Water District of Southern California | 28684 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 2078 | Metropolitan Water District of Southern California 407 | Special District 4 | Water District 13 | San Bernardino 22 | 3.476 | 0 | Local Other or Unknown 14 | 4 | ||
4487 | 4487 | 4486 | {"type": "Polygon", "coordinates": [[[-117.65095, 33.91007], [-117.65019, 33.91006], [-117.64981, 33.90897], [-117.65009, 33.9089], [-117.65007, 33.90881], [-117.65045, 33.90848], [-117.65044, 33.90828], [-117.64965, 33.9076], [-117.64926, 33.90648], [-117.65093, 33.90642], [-117.65095, 33.91007]]]} | Unknown Access 4 | 4844 | Unnamed site - Orange County Water District | 28653 | 2105 | Orange County Water District 768 | Special District 4 | Water District 13 | http://www.ocwd.com/ | Special District 4 | 2105 | Orange County Water District 749 | Special District 4 | Water District 13 | Riverside 10 | 9.715 | 0 | Local Other or Unknown 14 | 4 | ||
14932 | 14932 | 14931 | {"type": "Polygon", "coordinates": [[[-121.75938, 37.40226], [-121.75072, 37.40644], [-121.74665, 37.40506], [-121.74514, 37.40143], [-121.74087, 37.39735], [-121.74693, 37.39537], [-121.75232, 37.39823], [-121.75202, 37.39839], [-121.75117, 37.39869], [-121.75076, 37.39886], [-121.75052, 37.39905], [-121.74922, 37.39947], [-121.74866, 37.39979], [-121.74921, 37.40099], [-121.7496, 37.4008], [-121.75015, 37.40085], [-121.75079, 37.40043], [-121.75107, 37.40035], [-121.75232, 37.40037], [-121.75349, 37.40049], [-121.75403, 37.40063], [-121.75477, 37.40095], [-121.75528, 37.40133], [-121.75628, 37.40129], [-121.75699, 37.40077], [-121.75938, 37.40226]]]} | Open Access 1 | 45518 | Upper Penitencia Creek Property | 28353 | 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 | 216.953 | Upper Penitencia Creek Property | 0 | Local Other or Unknown 14 | 4 | |
3178 | 3178 | 3177 | {"type": "Polygon", "coordinates": [[[-121.93307, 36.98817], [-121.93305, 36.9883], [-121.93244, 36.98822], [-121.93247, 36.98809], [-121.93307, 36.98817]]]} | Open Access 1 | 1913 | Willowbrook Park - Soquel Creek Water District | 27591 | 2157 | Soquel Creek Water District 592 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.197 | Willowbrook Park - Soquel Creek Water District | 0 | Local Other or Unknown 14 | 4 | |
13385 | 13385 | 13384 | {"type": "Polygon", "coordinates": [[[-121.26373, 39.48345], [-121.26077, 39.48344], [-121.26057, 39.48328], [-121.25903, 39.48256], [-121.26008, 39.48202], [-121.26034, 39.4819], [-121.26043, 39.48155], [-121.26024, 39.48131], [-121.2599, 39.48119], [-121.25891, 39.48101], [-121.25891, 39.48036], [-121.26368, 39.48036], [-121.26373, 39.48345]]]} | Unknown Access 4 | 35481 | Yuba County Water Agency 1 | 27797 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 29.016 | Yuba County Water Agency 1 | 0 | Local Other or Unknown 14 | 4 | |
13380 | 13380 | 13379 | {"type": "Polygon", "coordinates": [[[-121.47367, 39.03416], [-121.47326, 39.03431], [-121.46836, 39.02634], [-121.46836, 39.02597], [-121.4706, 39.0296], [-121.47089, 39.02975], [-121.47107, 39.02997], [-121.47103, 39.03028], [-121.47317, 39.03389], [-121.47367, 39.03416]]]} | Unknown Access 4 | 35469 | Yuba County Water Agency 10 | 27798 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 4.606 | Yuba County Water Agency 10 | 0 | Local Other or Unknown 14 | 4 | |
13386 | 13386 | 13385 | {"type": "Polygon", "coordinates": [[[-121.19523, 39.33117], [-121.19468, 39.33535], [-121.19452, 39.33532], [-121.19433, 39.33535], [-121.19414, 39.33548], [-121.194, 39.33561], [-121.19383, 39.33565], [-121.19363, 39.3356], [-121.19371, 39.33544], [-121.19369, 39.3352], [-121.19358, 39.33483], [-121.19334, 39.33452], [-121.19295, 39.33364], [-121.19253, 39.33317], [-121.19246, 39.33298], [-121.19256, 39.33309], [-121.19277, 39.33325], [-121.19307, 39.33344], [-121.19345, 39.33359], [-121.19372, 39.33364], [-121.1939, 39.33361], [-121.19393, 39.33358], [-121.194, 39.33347], [-121.194, 39.33342], [-121.19397, 39.33326], [-121.1937, 39.33285], [-121.19363, 39.33258], [-121.19357, 39.33229], [-121.19356, 39.33191], [-121.19352, 39.33153], [-121.19355, 39.33136], [-121.19361, 39.33129], [-121.1938, 39.33122], [-121.19407, 39.33119], [-121.19452, 39.33108], [-121.19489, 39.33111], [-121.19523, 39.33117]]]} | Unknown Access 4 | 35483 | Yuba County Water Agency 11 | 27799 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 14.69 | Yuba County Water Agency 11 | 0 | Local Other or Unknown 14 | 4 | |
13390 | 13390 | 13389 | {"type": "Polygon", "coordinates": [[[-121.06653, 39.43703], [-121.06571, 39.43704], [-121.06567, 39.4357], [-121.0665, 39.43569], [-121.06653, 39.43703]]]} | Unknown Access 4 | 35493 | Yuba County Water Agency 12 | 27800 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 2.613 | Yuba County Water Agency 12 | 0 | Local Other or Unknown 14 | 4 | |
3853 | 3853 | 3852 | {"type": "Polygon", "coordinates": [[[-121.27315, 39.48143], [-121.27314, 39.48349], [-121.26373, 39.48345], [-121.2637, 39.48142], [-121.27315, 39.48143]]]} | Unknown Access 4 | 35576 | Yuba County Water Agency 13 | 27801 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 45.633 | Yuba County Water Agency 13 | 0 | Local Other or Unknown 14 | 4 | |
3465 | 3465 | 3464 | {"type": "Polygon", "coordinates": [[[-121.27748, 39.49831], [-121.27736, 39.49848], [-121.27711, 39.49873], [-121.27626, 39.49834], [-121.27659, 39.49789], [-121.27748, 39.49831]]]} | Unknown Access 4 | 35637 | Yuba County Water Agency 14 | 27802 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.259 | Yuba County Water Agency 14 | 0 | Local Other or Unknown 14 | 4 | |
3867 | 3867 | 3866 | {"type": "Polygon", "coordinates": [[[-121.27862, 39.49732], [-121.27862, 39.49732], [-121.27803, 39.49771], [-121.27838, 39.49725], [-121.27858, 39.49713], [-121.27862, 39.49732]]]} | Unknown Access 4 | 35636 | Yuba County Water Agency 15 | 27803 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 0.215 | Yuba County Water Agency 15 | 0 | Local Other or Unknown 14 | 4 | |
13475 | 13475 | 13474 | {"type": "Polygon", "coordinates": [[[-121.26491, 39.48036], [-121.25891, 39.48036], [-121.25891, 39.47936], [-121.25891, 39.47936], [-121.26491, 39.48036]]]} | Unknown Access 4 | 35738 | Yuba County Water Agency 16 | 27804 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 7.056 | Yuba County Water Agency 16 | 0 | Local Other or Unknown 14 | 4 | |
13383 | 13383 | 13382 | {"type": "Polygon", "coordinates": [[[-121.46836, 39.02634], [-121.46513, 39.02109], [-121.46513, 39.02109], [-121.46532, 39.02102], [-121.46835, 39.02597], [-121.46836, 39.02634]]]} | Unknown Access 4 | 35479 | Yuba County Water Agency 17 | 27805 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 2.744 | Yuba County Water Agency 17 | 0 | Local Other or Unknown 14 | 4 | |
3866 | 3866 | 3865 | {"type": "Polygon", "coordinates": [[[-121.28772, 39.49953], [-121.28629, 39.49959], [-121.28627, 39.49819], [-121.28769, 39.49815], [-121.28772, 39.49953]]]} | Unknown Access 4 | 35635 | Yuba County Water Agency 18 | 27806 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 4.676 | Yuba County Water Agency 18 | 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]);