units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where MNG_AGENCY = 483 sorted by UNIT_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2176 | 2176 | 2175 | {"type": "Polygon", "coordinates": [[[-121.21037, 39.36811], [-121.20995, 39.36863], [-121.20974, 39.36895], [-121.20958, 39.36931], [-121.20952, 39.36954], [-121.20905, 39.36943], [-121.20895, 39.36687], [-121.20686, 39.36649], [-121.20521, 39.36728], [-121.20494, 39.36732], [-121.2048, 39.36724], [-121.20239, 39.36698], [-121.20227, 39.36726], [-121.20046, 39.36728], [-121.19985, 39.36452], [-121.19852, 39.36285], [-121.19874, 39.36145], [-121.20043, 39.36171], [-121.20125, 39.36084], [-121.20405, 39.35905], [-121.20399, 39.3574], [-121.20311, 39.35745], [-121.20343, 39.35354], [-121.20799, 39.3535], [-121.20822, 39.3587], [-121.20916, 39.35871], [-121.20929, 39.36369], [-121.20987, 39.36548], [-121.21042, 39.36706], [-121.21043, 39.36744], [-121.21037, 39.36811]]]} | Open Access 1 | 16329 | Lake Francis | 15068 | 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 | http://www.lakefrancisrv.com/about.html | Yuba 25 | 239.917 | Lake Francis | None 179 | ||
9777 | 9777 | 9776 | {"type": "MultiPolygon", "coordinates": [[[[-121.14908, 39.3982], [-121.14845, 39.3982], [-121.14844, 39.39749], [-121.14908, 39.39749], [-121.14908, 39.3982]]], [[[-121.14957, 39.40953], [-121.14851, 39.40953], [-121.14847, 39.40267], [-121.14953, 39.40266], [-121.14957, 39.40953]]], [[[-121.14852, 39.41173], [-121.14839, 39.4193], [-121.14599, 39.41938], [-121.14594, 39.42309], [-121.14832, 39.42309], [-121.14826, 39.42688], [-121.14112, 39.42671], [-121.14116, 39.42312], [-121.14115, 39.42311], [-121.13405, 39.42313], [-121.13341, 39.42375], [-121.13324, 39.424], [-121.13276, 39.42439], [-121.13246, 39.42466], [-121.13191, 39.42523], [-121.13165, 39.42552], [-121.1313, 39.42598], [-121.13118, 39.42614], [-121.131, 39.42647], [-121.13115, 39.41979], [-121.13402, 39.41971], [-121.134, 39.4129], [-121.13884, 39.41252], [-121.14126, 39.41231], [-121.14116, 39.40496], [-121.13872, 39.4052], [-121.13859, 39.39787], [-121.13367, 39.39849], [-121.1336, 39.39477], [-121.13174, 39.395], [-121.13168, 39.39584], [-121.13093, 39.39574], [-121.13109, 39.39409], [-121.13158, 39.39083], [-121.13174, 39.3886], [-121.13206, 39.38858], [-121.13232, 39.38374], [-121.14762, 39.38187], [-121.14844, 39.39661], [-121.14106, 39.39755], [-121.14111, 39.40123], [-121.14112, 39.40124], [-121.14601, 39.40067], [-121.1461, 39.41192], [-121.14852, 39.41173]], [[-121.14506, 39.41512], [-121.14504, 39.41512], [-121.14508, 39.41634], [-121.14509, 39.41635], [-121.14512, 39.41616], [-121.14514, 39.41558], [-121.14506, 39.41512]], [[-121.14478, 39.41386], [-121.14476, 39.41386], [-121.14477, 39.41388], [-121.14478, 39.41388], [-121.14478, 39.41386]], [[-121.14443, 39.41305], [-121.14442, 39.41306], [-121.14452, 39.41321], [-121.14447, 39.4131], [-121.14443, 39.41305]], [[-121.13819, 39.39742], [-121.1382, 39.39741], [-121.13815, 39.39736], [-121.13815, 39.39737], [-121.13819, 39.39742]], [[-121.13801, 39.39454], [-121.13803, 39.39455], [-121.1384, 39.39408], [-121.1384, 39.39406], [-121.1383, 39.39414], [-121.13801, 39.39454]]], [[[-121.15793, 39.42887], [-121.15592, 39.42901], [-121.15591, 39.4286], [-121.15521, 39.42865], [-121.1552, 39.42775], [-121.1538, 39.42785], [-121.15378, 39.4273], [-121.15273, 39.42738], [-121.15273, 39.42655], [-121.15791, 39.42618], [-121.15793, 39.42887]]], [[[-121.1624, 39.43019], [-121.15975, 39.43031], [-121.15971, 39.42977], [-121.16236, 39.42964], [-121.1624, 39.43019]]], [[[-121.13907, 39.43719], [-121.13439, 39.43721], [-121.13413, 39.42832], [-121.1388, 39.42841], [-121.13907, 39.43719]]], [[[-121.11225, 39.43238], [-121.1077, 39.4323], [-121.10771, 39.43582], [-121.1077, 39.43943], [-121.1031, 39.43933], [-121.1031, 39.4389], [-121.10309, 39.4389], [-121.09894, 39.44183], [-121.0969, 39.44468], [-121.09447, 39.44673], [-121.09442, 39.44755], [-121.09243, 39.44953], [-121.09173, 39.45174], [-121.08944, 39.45045], [-121.09097, 39.4491], [-121.09156, 39.44791], [-121.09212, 39.44733], [-121.09245, 39.44641], [-121.08834, 39.44644], [-121.08836, 39.44431], [-121.08716, 39.44434], [-121.08717, 39.44296], [-121.0893, 39.44293], [-121.08931, 39.43932], [-121.09238, 39.43929], [-121.09388, 39.43923], [-121.09387, 39.43657], [-121.09503, 39.43656], [-121.09504, 39.43565], [-121.09856, 39.43562], [-121.09838, 39.43215], [-121.10536, 39.43228], [-121.10528, 39.4287], [-121.11223, 39.42875], [-121.11225, 39.43238]]], [[[-121.14868, 39.44056], [-121.14837, 39.44863], [-121.14837, 39.45137], [-121.14372, 39.45138], [-121.14379, 39.44782], [-121.14378, 39.44781], [-121.13911, 39.44785], [-121.13907, 39.45183], [-121.13609, 39.45185], [-121.13611, 39.45142], [-121.1361, 39.45141], [-121.13052, 39.45148], [-121.13084, 39.44498], [-121.13085, 39.44081], [-121.13917, 39.44069], [-121.13914, 39.44427], [-121.14373, 39.44422], [-121.14369, 39.44063], [-121.14868, 39.44056]]], [[[-121.13, 39.43489], [-121.12988, 39.4453], [-121.12768, 39.44608], [-121.12772, 39.45294], [-121.12353, 39.45429], [-121.12333, 39.44772], [-121.12332, 39.44772], [-121.12117, 39.44865], [-121.12129, 39.44502], [-121.12571, 39.44326], [-121.12605, 39.43774], [-121.13, 39.43489]]], [[[-121.16173, 39.45525], [-121.15281, 39.45532], [-121.15277, 39.45453], [-121.15277, 39.45444], [-121.15284, 39.45443], [-121.1529, 39.45136], [-121.15063, 39.45136], [-121.15076, 39.44777], [-121.15763, 39.44778], [-121.15744, 39.45134], [-121.162, 39.45133], [-121.16173, 39.45525]]], [[[-121.09745, 39.45344], [-121.09743, 39.45585], [-121.09496, 39.45592], [-121.09499, 39.45701], [-121.09393, 39.45705], [-121.09369, 39.45927], [-121.09157, 39.4594], [-121.09159, 39.4555], [-121.08911, 39.45552], [-121.08923, 39.45353], [-121.09745, 39.45344]]], [[[-121.16842, 39.47934], [-121.16676, 39.47941], [-121.16668, 39.47851], [-121.16491, 39.47853], [-121.16485, 39.47775], [-121.16662, 39.47769], [-121.16642, 39.47502], [-121.16199, 39.47518], [-121.16176, 39.47089], [-121.16005, 39.47045], [-121.15891, 39.47004], [-121.15776, 39.46957], [-121.15735, 39.46928], [-121.15693, 39.46883], [-121.15673, 39.46851], [-121.15656, 39.46801], [-121.15654, 39.46739], [-121.15658, 39.46721], [-121.15671, 39.46694], [-121.15692, 39.4667], [-121.15732, 39.46643], [-121.15725, 39.45905], [-121.16169, 39.45894], [-121.16174, 39.45529], [-121.16175, 39.45528], [-121.16174, 39.45526], [-121.16635, 39.45522], [-121.16605, 39.46791], [-121.16167, 39.46809], [-121.16176, 39.47088], [-121.16302, 39.47113], [-121.16361, 39.47152], [-121.16366, 39.47158], [-121.16367, 39.47156], [-121.16616, 39.47144], [-121.16617, 39.47143], [-121.16611, 39.47056], [-121.16689, 39.47053], [-121.16733, 39.47676], [-121.16821, 39.47673], [-121.16842, 39.47934]]], [[[-121.1631, 39.47931], [-121.15328, 39.47956], [-121.15329, 39.48063], [-121.1487, 39.48076], [-121.14871, 39.48413], [-121.14862, 39.49095], [-121.14289, 39.4911], [-121.14287, 39.49192], [-121.14054, 39.492], [-121.14051, 39.49364], [-121.14168, 39.49361], [-121.14167, 39.49452], [-121.13934, 39.49459], [-121.13929, 39.49887], [-121.13941, 39.50163], [-121.13464, 39.50173], [-121.13459, 39.51227], [-121.13436, 39.52311], [-121.12956, 39.52318], [-121.12955, 39.52338], [-121.11617, 39.53014], [-121.1163, 39.52256], [-121.12971, 39.51569], [-121.12977, 39.51224], [-121.12976, 39.51223], [-121.12875, 39.51272], [-121.12864, 39.51167], [-121.1298, 39.51076], [-121.13005, 39.49836], [-121.13467, 39.4982], [-121.13485, 39.48785], [-121.14403, 39.48765], [-121.144, 39.48421], [-121.14405, 39.47735], [-121.14665, 39.47736], [-121.16209, 39.47695], [-121.16214, 39.47783], [-121.16298, 39.47781], [-121.1631, 39.47931]]]]} | Open Access 1 | 16635 | New Bullards Bar Reservoir | 15069 | 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 | http://www.ycwa.com/about/recreation | Yuba 25 | 3823.804 | New Bullards Bar Reservoir | 0 | Local Recreation Area 3 | 4 |
13379 | 13379 | 13378 | {"type": "Polygon", "coordinates": [[[-121.27563, 39.49942], [-121.27246, 39.50161], [-121.27156, 39.50224], [-121.27495, 39.498], [-121.27524, 39.498], [-121.27482, 39.49898], [-121.27563, 39.49942]]]} | Unknown Access 4 | 35468 | Yuba County Water Agency 42 | 27832 | 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 | 8.399 | Yuba County Water Agency 42 | 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 | |
3438 | 3438 | 3437 | {"type": "Polygon", "coordinates": [[[-121.27738, 39.49699], [-121.277, 39.49737], [-121.27617, 39.49697], [-121.2765, 39.49657], [-121.27738, 39.49699]]]} | Unknown Access 4 | 35476 | Yuba County Water Agency 3 | 27818 | 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.144 | Yuba County Water Agency 3 | 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 | |
13384 | 13384 | 13383 | {"type": "Polygon", "coordinates": [[[-121.33233, 39.44338], [-121.33233, 39.44361], [-121.3318, 39.44361], [-121.3318, 39.44338], [-121.33233, 39.44338]]]} | Unknown Access 4 | 35480 | Yuba County Water Agency 2 | 27808 | 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.291 | Yuba County Water Agency 2 | 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 | |
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 | |
13391 | 13391 | 13390 | {"type": "Polygon", "coordinates": [[[-121.2718, 39.47467], [-121.27178, 39.47519], [-121.27125, 39.47519], [-121.27123, 39.47535], [-121.27078, 39.47536], [-121.27081, 39.47451], [-121.27119, 39.47444], [-121.27138, 39.47444], [-121.27154, 39.47449], [-121.2717, 39.47457], [-121.2718, 39.47467]]]} | Unknown Access 4 | 35494 | Yuba County Water Agency 9 | 27844 | 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.824 | Yuba County Water Agency 9 | 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 | |
3854 | 3854 | 3853 | {"type": "Polygon", "coordinates": [[[-121.27711, 39.49874], [-121.27703, 39.49881], [-121.27655, 39.499], [-121.27626, 39.49896], [-121.27605, 39.49886], [-121.27594, 39.49879], [-121.27626, 39.49835], [-121.27711, 39.49874]]]} | Unknown Access 4 | 35578 | Yuba County Water Agency 49 | 27839 | 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.0 | Yuba County Water Agency 49 | 0 | Local Other or Unknown 14 | 4 | |
3457 | 3457 | 3456 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.49693], [-121.27778, 39.49658], [-121.27854, 39.4958], [-121.27851, 39.49654], [-121.27854, 39.49693]]]} | Unknown Access 4 | 35580 | Yuba County Water Agency 47 | 27837 | 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.973 | Yuba County Water Agency 47 | 0 | Local Other or Unknown 14 | 4 | |
3857 | 3857 | 3856 | {"type": "Polygon", "coordinates": [[[-121.27671, 39.49771], [-121.2765, 39.49801], [-121.27567, 39.49769], [-121.27565, 39.49761], [-121.27587, 39.49734], [-121.27671, 39.49771]]]} | Unknown Access 4 | 35587 | Yuba County Water Agency 48 | 27838 | 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.844 | Yuba County Water Agency 48 | 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 | |
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 | |
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 | |
3868 | 3868 | 3867 | {"type": "Polygon", "coordinates": [[[-121.2878, 39.49075], [-121.28749, 39.49816], [-121.28627, 39.49819], [-121.27875, 39.49803], [-121.27866, 39.49811], [-121.2808, 39.49561], [-121.28207, 39.49531], [-121.28583, 39.49307], [-121.27774, 39.4835], [-121.28324, 39.48882], [-121.28684, 39.4861], [-121.28687, 39.49074], [-121.2878, 39.49075]]]} | Unknown Access 4 | 35638 | Yuba County Water Agency 38 | 27827 | 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 | 121.398 | Yuba County Water Agency 38 | 0 | Local Other or Unknown 14 | 4 | |
3869 | 3869 | 3868 | {"type": "Polygon", "coordinates": [[[-121.28986, 39.50148], [-121.28872, 39.50152], [-121.28863, 39.49951], [-121.28976, 39.49949], [-121.28986, 39.50148]]]} | Unknown Access 4 | 35639 | Yuba County Water Agency 40 | 27830 | 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 | 5.364 | Yuba County Water Agency 40 | 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]);