units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where AGNCY_LEV = 4 and YR_EST = 1930
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_TYP, MNG_AG_ID, COUNTY, GAP_STS
MNG_AGENCY 3
ACCESS_TYP 3
MNG_AG_TYP 2
DES_TP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
7871 | 7871 | 7870 | {"type": "Polygon", "coordinates": [[[-122.39608, 37.51947], [-122.38304, 37.51947], [-122.38303, 37.51405], [-122.38073, 37.51403], [-122.3807, 37.5086], [-122.37849, 37.5086], [-122.37849, 37.50594], [-122.383, 37.50594], [-122.38301, 37.50493], [-122.3869, 37.50493], [-122.38693, 37.51585], [-122.39604, 37.51584], [-122.39608, 37.51947]]]} | No Public Access 3 | 9994 | Coastside County Water District | 17466 | 2022 | Coastside County Water District 882 | Special District 4 | Water District 13 | http://www.coastsidewater.org/ | Special District 4 | 2022 | Coastside County Water District 857 | Special District 4 | Water District 13 | San Mateo 15 | 277.163 | Coastside County Water District | 1930 | Local Other or Unknown 14 | 4 | |
15809 | 15809 | 15808 | {"type": "MultiPolygon", "coordinates": [[[[-115.63163, 33.19095], [-115.6144, 33.191], [-115.61443, 33.2056], [-115.59713, 33.20562], [-115.5972, 33.19108], [-115.5972, 33.18382], [-115.61447, 33.18381], [-115.61454, 33.17663], [-115.62301, 33.17662], [-115.62302, 33.16938], [-115.63151, 33.16937], [-115.63147, 33.17661], [-115.63163, 33.19095]]], [[[-115.66647, 33.19104], [-115.66645, 33.2056], [-115.64891, 33.20566], [-115.6489, 33.20569], [-115.64885, 33.2057], [-115.64879, 33.22008], [-115.63179, 33.22008], [-115.63178, 33.22013], [-115.63178, 33.23461], [-115.61433, 33.23471], [-115.61437, 33.22014], [-115.62588, 33.2201], [-115.63177, 33.22012], [-115.63169, 33.20562], [-115.64885, 33.20569], [-115.64877, 33.19098], [-115.66647, 33.19104]]], [[[-115.7311, 33.08957], [-115.73106, 33.09675], [-115.73101, 33.09684], [-115.72246, 33.09683], [-115.72244, 33.10411], [-115.70084, 33.10413], [-115.70083, 33.1186], [-115.68339, 33.11864], [-115.68339, 33.13303], [-115.68349, 33.14739], [-115.69213, 33.14742], [-115.69213, 33.15473], [-115.68349, 33.15472], [-115.68348, 33.1474], [-115.66632, 33.14745], [-115.6663, 33.13299], [-115.66633, 33.12578], [-115.6706, 33.12579], [-115.67062, 33.11859], [-115.68339, 33.11863], [-115.68355, 33.10408], [-115.68354, 33.10044], [-115.68787, 33.10044], [-115.68787, 33.08953], [-115.69223, 33.08954], [-115.69223, 33.09318], [-115.7009, 33.0932], [-115.70094, 33.08956], [-115.71774, 33.08956], [-115.71816, 33.08953], [-115.7311, 33.08957]]], [[[-115.71804, 33.16202], [-115.70088, 33.16204], [-115.70087, 33.16205], [-115.70076, 33.16206], [-115.70072, 33.17656], [-115.68364, 33.17653], [-115.68363, 33.17655], [-115.68352, 33.17655], [-115.68349, 33.16204], [-115.70075, 33.16205], [-115.70077, 33.14743], [-115.71803, 33.14745], [-115.71804, 33.16202]]], [[[-115.75251, 33.23471], [-115.75249, 33.24929], [-115.75081, 33.24922], [-115.73556, 33.24917], [-115.73553, 33.23463], [-115.7355, 33.23461], [-115.71832, 33.2346], [-115.71831, 33.23462], [-115.71822, 33.23463], [-115.71817, 33.24918], [-115.70103, 33.24913], [-115.70107, 33.23468], [-115.71821, 33.23462], [-115.71822, 33.2346], [-115.71831, 33.23459], [-115.71827, 33.22006], [-115.73548, 33.22009], [-115.73543, 33.20556], [-115.75235, 33.20575], [-115.75237, 33.22024], [-115.75082, 33.22017], [-115.73548, 33.2201], [-115.73553, 33.2346], [-115.73559, 33.23462], [-115.75246, 33.23475], [-115.75247, 33.23471], [-115.75251, 33.23471]]], [[[-115.77013, 33.17658], [-115.75241, 33.17654], [-115.75236, 33.16205], [-115.75229, 33.16205], [-115.75228, 33.16202], [-115.75142, 33.16202], [-115.75082, 33.16201], [-115.73539, 33.16202], [-115.73536, 33.14746], [-115.73529, 33.14745], [-115.73529, 33.14742], [-115.73536, 33.14742], [-115.73537, 33.14745], [-115.75242, 33.14742], [-115.75236, 33.16205], [-115.7701, 33.162], [-115.77008, 33.16923], [-115.77013, 33.17658]]], [[[-115.83922, 33.2347], [-115.82193, 33.23467], [-115.82184, 33.25008], [-115.8218, 33.25074], [-115.80456, 33.25072], [-115.80458, 33.25007], [-115.80462, 33.2347], [-115.78738, 33.23468], [-115.78737, 33.22012], [-115.77008, 33.22014], [-115.77008, 33.20569], [-115.78738, 33.2057], [-115.78738, 33.22013], [-115.80464, 33.22014], [-115.80465, 33.22013], [-115.80464, 33.20572], [-115.80463, 33.20569], [-115.822, 33.20566], [-115.82195, 33.22014], [-115.83921, 33.22016], [-115.83922, 33.2347]], [[-115.82195, 33.22015], [-115.80465, 33.22014], [-115.80462, 33.23469], [-115.82192, 33.23467], [-115.82195, 33.22015]]], [[[-115.78737, 33.23469], [-115.78727, 33.25067], [-115.77001, 33.25062], [-115.76999, 33.25005], [-115.77008, 33.23472], [-115.78737, 33.23469]]], [[[-115.82198, 33.1766], [-115.82196, 33.17661], [-115.82195, 33.19107], [-115.80467, 33.19122], [-115.80478, 33.17658], [-115.78742, 33.17653], [-115.78748, 33.16924], [-115.7875, 33.16199], [-115.80481, 33.16192], [-115.80479, 33.17657], [-115.82198, 33.1766]]]]} | Open Access 1 | 12950 | Sonny Bono Salton Sea National Wildlife Refuge | 4597 | 2048 | Imperial Irrigation District 379 | Special District 4 | Irrigation District 17 | http://www.iid.com/ | Special District 4 | 2048 | Imperial Irrigation District 374 | Special District 4 | Irrigation District 16 | http://www.fws.gov/refuge/sonny_bono_salton_sea/ | Imperial 20 | 17446.028 | Sonny Bono Salton Sea NWR | 1930 | National Wildlife Refuge 105 | 2 |
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]);