[DATABASE] 2020 02 28 , fill in where coordinates are not in order

Locally

Where latitude is broken (longitude was inserted)

update collectioninfos set decimallatitude=60.7849336298687 where collectioninfoid= 1069;
update collectioninfos set decimallatitude=61.4372075395225 where collectioninfoid= 1070;
update collectioninfos set decimallatitude=60.4077784505899 where collectioninfoid= 1071;
update collectioninfos set decimallatitude=61.3742932970342 where collectioninfoid= 1072;
update collectioninfos set decimallatitude=61.5639384221818 where collectioninfoid= 1073;
update collectioninfos set decimallatitude=60.8544106848223 where collectioninfoid= 1074;
update collectioninfos set decimallatitude=61.3048034971938 where collectioninfoid= 1075;
update collectioninfos set decimallatitude=61.2916666670566 where collectioninfoid= 1076;
update collectioninfos set decimallatitude=61.9951405618007 where collectioninfoid= 1077;
update collectioninfos set decimallatitude=61.095163580337 where collectioninfoid= 1078;
update collectioninfos set decimallatitude=62.0520708557442 where collectioninfoid= 1079;
update collectioninfos set decimallatitude=60.572580433029 where collectioninfoid= 1080;
update collectioninfos set decimallatitude=61.3768464457527 where collectioninfoid= 1081;
update collectioninfos set decimallatitude=60.8527864265336 where collectioninfoid= 1082;
update collectioninfos set decimallatitude=60.7458463598759 where collectioninfoid= 1083;
update collectioninfos set decimallatitude=60.9511873677717 where collectioninfoid= 1084;
update collectioninfos set decimallatitude=61.141020724968 where collectioninfoid= 1085;
update collectioninfos set decimallatitude=60.3485478311856 where collectioninfoid= 1086;
update collectioninfos set decimallatitude=60.8729681585723 where collectioninfoid= 1087;
update collectioninfos set decimallatitude=62.0330600596035 where collectioninfoid= 1088;
update collectioninfos set decimallatitude=61.121532890979 where collectioninfoid= 1089;
update collectioninfos set decimallatitude=60.8150873753101 where collectioninfoid= 1090;
update collectioninfos set decimallatitude=61.740685922506 where collectioninfoid= 1091;
update collectioninfos set decimallatitude=61.6229007387014 where collectioninfoid= 1092;
update collectioninfos set decimallatitude=61.7867325738548 where collectioninfoid= 1093;
update collectioninfos set decimallatitude=61.2883334337743 where collectioninfoid= 1094;
update collectioninfos set decimallatitude=61.723823343535 where collectioninfoid= 1095;
update collectioninfos set decimallatitude=61.5838493358247 where collectioninfoid= 1096;
update collectioninfos set decimallatitude=61.7568032578102 where collectioninfoid= 1097;
update collectioninfos set decimallatitude=60.5419573851824 where collectioninfoid= 1098;
update collectioninfos set decimallatitude=61.1784791828948 where collectioninfoid= 1099;
update collectioninfos set decimallatitude=61.3082563783984 where collectioninfoid= 1100;
update collectioninfos set decimallatitude=60.5546072085212 where collectioninfoid= 1101;
update collectioninfos set decimallatitude=61.66127824171 where collectioninfoid= 1102;
update collectioninfos set decimallatitude=61.1307785173818 where collectioninfoid= 1103;
update collectioninfos set decimallatitude=60.853797278258 where collectioninfoid= 1104;
update collectioninfos set decimallatitude=60.6255790172457 where collectioninfoid= 1105;
update collectioninfos set decimallatitude=61.1551306016774 where collectioninfoid= 1106;
update collectioninfos set decimallatitude=61.410272972932 where collectioninfoid= 1107;
update collectioninfos set decimallatitude=61.4818997443274 where collectioninfoid= 1108;
update collectioninfos set decimallatitude=61.7204862748054 where collectioninfoid= 1109;
update collectioninfos set decimallatitude=61.6180396827106 where collectioninfoid= 1110;
update collectioninfos set decimallatitude=61.6442954832637 where collectioninfoid= 1111;
update collectioninfos set decimallatitude=61.6670383282357 where collectioninfoid= 1112;
update collectioninfos set decimallatitude=60.7849148927138 where collectioninfoid= 1113;
update collectioninfos set decimallatitude=61.0977006849604 where collectioninfoid= 1114;
update collectioninfos set decimallatitude=61.8659997445618 where collectioninfoid= 1115;
update collectioninfos set decimallatitude=61.0979042681315 where collectioninfoid= 1116;
update collectioninfos set decimallatitude=61.1032850644097 where collectioninfoid= 1117;
update collectioninfos set decimallatitude=60.8665976741944 where collectioninfoid= 1118;
update collectioninfos set decimallatitude=61.7201943407846 where collectioninfoid= 1119;
update collectioninfos set decimallatitude=61.7285509665891 where collectioninfoid= 1120;
update collectioninfos set decimallatitude=60.7856694406971 where collectioninfoid= 1121;
update collectioninfos set decimallatitude=62.1719939907949 where collectioninfoid= 1122;
update collectioninfos set decimallatitude=61.855567765422 where collectioninfoid= 1123;
update collectioninfos set decimallatitude=61.6389268906257 where collectioninfoid= 1124;
update collectioninfos set decimallatitude=61.6355122925613 where collectioninfoid= 1125;
update collectioninfos set decimallatitude=61.6851605520501 where collectioninfoid= 1126;
update collectioninfos set decimallatitude=60.9220564373234 where collectioninfoid= 1127;
update collectioninfos set decimallatitude=61.6107807673878 where collectioninfoid= 1128;
update collectioninfos set decimallatitude=61.1433153695749 where collectioninfoid= 1129;
update collectioninfos set decimallatitude=61.7244403008667 where collectioninfoid= 1130;
update collectioninfos set decimallatitude=61.0023552699022 where collectioninfoid= 1131;
update collectioninfos set decimallatitude=61.0135058115109 where collectioninfoid= 1132;
update collectioninfos set decimallatitude=61.0146022911073 where collectioninfoid= 1133;
update collectioninfos set decimallatitude=61.8734992134774 where collectioninfoid= 1134;
update collectioninfos set decimallatitude=61.8094141452484 where collectioninfoid= 1135;
update collectioninfos set decimallatitude=61.3541302921672 where collectioninfoid= 1136;
update collectioninfos set decimallatitude=61.2883334337743 where collectioninfoid= 1137;
update collectioninfos set decimallatitude=61.3546022150322 where collectioninfoid= 1138;
update collectioninfos set decimallatitude=61.7731012005978 where collectioninfoid= 1139;
update collectioninfos set decimallatitude=61.7303525197062 where collectioninfoid= 1140;
update collectioninfos set decimallatitude=61.3750265516904 where collectioninfoid= 1141;
update collectioninfos set decimallatitude=61.5126634688158 where collectioninfoid= 1142;
update collectioninfos set decimallatitude=61.0656598835747 where collectioninfoid= 1143;
update collectioninfos set decimallatitude=61.7539045036392 where collectioninfoid= 1144;
update collectioninfos set decimallatitude=61.6855324334973 where collectioninfoid= 1145;
update collectioninfos set decimallatitude=60.7933762709305 where collectioninfoid= 1146;
update collectioninfos set decimallatitude=61.3541926359577 where collectioninfoid= 1147;
update collectioninfos set decimallatitude=60.8928840770803 where collectioninfoid= 1148;
update collectioninfos set decimallatitude=61.6368045474304 where collectioninfoid= 1149;
update collectioninfos set decimallatitude=61.8101198487179 where collectioninfoid= 1150;
update collectioninfos set decimallatitude=61.3550454260699 where collectioninfoid= 1151;
update collectioninfos set decimallatitude=60.8032394945137 where collectioninfoid= 1152;
update collectioninfos set decimallatitude=61.2411443654809 where collectioninfoid= 1153;
update collectioninfos set decimallatitude=61.0926570261736 where collectioninfoid= 1154;
update collectioninfos set decimallatitude=60.8804959447697 where collectioninfoid= 1155;
update collectioninfos set decimallatitude=60.40604 where collectioninfoid= 1156;
update collectioninfos set decimallatitude=61.14743 where collectioninfoid= 1157;
update collectioninfos set decimallatitude=61.2878334760064 where collectioninfoid= 1158;
update collectioninfos set decimallatitude=61.741707480884 where collectioninfoid= 1159;
update collectioninfos set decimallatitude=61.015620123256 where collectioninfoid= 1160;
update collectioninfos set decimallatitude=61.5643511779647 where collectioninfoid= 1161;
update collectioninfos set decimallatitude=62.0458753409561 where collectioninfoid= 1162;
update collectioninfos set decimallatitude=61.7174773748609 where collectioninfoid= 1163;
update collectioninfos set decimallatitude=61.2219181404027 where collectioninfoid= 1164;

both are broken, lat and long

update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1165;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1166;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1167;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1168;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1169;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1170;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1171;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1172;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1173;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1174;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1175;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1176;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1177;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1178;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1179;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1180;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1181;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1182;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1183;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1184;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1185;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1186;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1187;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1188;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1189;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1190;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1191;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1192;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1193;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1194;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1195;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1196;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1197;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1198;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1199;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1200;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1201;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1202;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1203;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1204;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1205;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1206;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1207;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1208;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1209;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1210;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1211;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1212;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1213;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1214;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1215;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1216;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1217;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1218;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1219;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1220;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1221;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1222;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1223;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1224;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1225;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1226;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1227;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1228;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1229;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1230;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1231;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1232;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1233;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1234;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1235;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1236;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1237;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1238;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1239;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1240;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1241;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1242;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1243;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1244;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1245;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1246;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1247;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1248;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1249;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1250;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1251;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1252;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1253;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1254;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1255;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1256;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1257;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1258;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1259;
update collectioninfos set decimallatitude=57.6348, decimallongitude=18.2948 where collectioninfoid=1260;

select *

1. select * from vw_combinew1 order by tubeid;
2. select count(*) from vw_combinew1; // 480