select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (39842286.0207))/2457600) as latlevel, round((longitude_e6 - (-113818359.375))/2457600) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (39842286.0207)), abs(180000000- latitude_e6 - (39842286.0207))) + LEAST(abs(longitude_e6 - (-113818359.375)), abs(360000000-longitude_e6 - (-113818359.375))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('17516667:-88183333','14616667:-90516667','13700000:-89216667','25083333:-77350000','19900000:-75150000','3416667:-76500000','38750000:-27083333','6833333:-58200000','61183333:-45416667','4933333:-52450000','-1450000:-48483333','-26833333:-65166667','-3766667:-38550000','-31366667:-64250000','-15866667:-47916667','43300000:5383333','45700000:4783333','28583333:7','-8066667:-34883333','-13000000:-38500000') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37553965))/19200) as latlevel, round((longitude_e6 - (126972800))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37553965)), abs(180000000- latitude_e6 - (37553965))) + LEAST(abs(longitude_e6 - (126972800)), abs(360000000-longitude_e6 - (126972800))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37553965))/19200) as latlevel, round((longitude_e6 - (126972800))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37553965)), abs(180000000- latitude_e6 - (37553965))) + LEAST(abs(longitude_e6 - (126972800)), abs(360000000-longitude_e6 - (126972800))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37555908.8599))/19200) as latlevel, round((longitude_e6 - (126970615.874))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37555908.8599)), abs(180000000- latitude_e6 - (37555908.8599))) + LEAST(abs(longitude_e6 - (126970615.874)), abs(360000000-longitude_e6 - (126970615.874))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37555908.8599))/19200) as latlevel, round((longitude_e6 - (126970615.874))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37555908.8599)), abs(180000000- latitude_e6 - (37555908.8599))) + LEAST(abs(longitude_e6 - (126970615.874)), abs(360000000-longitude_e6 - (126970615.874))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37555908.8599))/19200) as latlevel, round((longitude_e6 - (126970615.874))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37555908.8599)), abs(180000000- latitude_e6 - (37555908.8599))) + LEAST(abs(longitude_e6 - (126970615.874)), abs(360000000-longitude_e6 - (126970615.874))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37555908.8599))/19200) as latlevel, round((longitude_e6 - (126970615.874))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37555908.8599)), abs(180000000- latitude_e6 - (37555908.8599))) + LEAST(abs(longitude_e6 - (126970615.874)), abs(360000000-longitude_e6 - (126970615.874))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37555908.8599))/2400) as latlevel, round((longitude_e6 - (126970615.874))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37555908.8599)), abs(180000000- latitude_e6 - (37555908.8599))) + LEAST(abs(longitude_e6 - (126970615.874)), abs(360000000-longitude_e6 - (126970615.874))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37554238.8598))/2400) as latlevel, round((longitude_e6 - (126977519.98))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37554238.8598)), abs(180000000- latitude_e6 - (37554238.8598))) + LEAST(abs(longitude_e6 - (126977519.98)), abs(360000000-longitude_e6 - (126977519.98))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37554274.2983))/2400) as latlevel, round((longitude_e6 - (126977405.548))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37554274.2983)), abs(180000000- latitude_e6 - (37554274.2983))) + LEAST(abs(longitude_e6 - (126977405.548)), abs(360000000-longitude_e6 - (126977405.548))) asc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37554238.8598))/2400) as latlevel, round((longitude_e6 - (126977519.98))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37554238.8598)), abs(180000000- latitude_e6 - (37554238.8598))) + LEAST(abs(longitude_e6 - (126977519.98)), abs(360000000-longitude_e6 - (126977519.98))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37553965))/19200) as latlevel, round((longitude_e6 - (126972800))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37553965)), abs(180000000- latitude_e6 - (37553965))) + LEAST(abs(longitude_e6 - (126972800)), abs(360000000-longitude_e6 - (126972800))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37554238.8598))/2400) as latlevel, round((longitude_e6 - (126977519.98))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37554238.8598)), abs(180000000- latitude_e6 - (37554238.8598))) + LEAST(abs(longitude_e6 - (126977519.98)), abs(360000000-longitude_e6 - (126977519.98))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37554238.8598))/2400) as latlevel, round((longitude_e6 - (126977519.98))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37554238.8598)), abs(180000000- latitude_e6 - (37554238.8598))) + LEAST(abs(longitude_e6 - (126977519.98)), abs(360000000-longitude_e6 - (126977519.98))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37554232.7956))/2400) as latlevel, round((longitude_e6 - (126960317.235))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37554232.7956)), abs(180000000- latitude_e6 - (37554232.7956))) + LEAST(abs(longitude_e6 - (126960317.235)), abs(360000000-longitude_e6 - (126960317.235))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37555908.8599))/19200) as latlevel, round((longitude_e6 - (126970615.874))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37555908.8599)), abs(180000000- latitude_e6 - (37555908.8599))) + LEAST(abs(longitude_e6 - (126970615.874)), abs(360000000-longitude_e6 - (126970615.874))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37554232.7956))/2400) as latlevel, round((longitude_e6 - (126960317.235))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37554232.7956)), abs(180000000- latitude_e6 - (37554232.7956))) + LEAST(abs(longitude_e6 - (126960317.235)), abs(360000000-longitude_e6 - (126960317.235))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37554232.7956))/2400) as latlevel, round((longitude_e6 - (126960317.235))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37554232.7956)), abs(180000000- latitude_e6 - (37554232.7956))) + LEAST(abs(longitude_e6 - (126960317.235)), abs(360000000-longitude_e6 - (126960317.235))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37554232.7956))/2400) as latlevel, round((longitude_e6 - (126960317.235))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37554232.7956)), abs(180000000- latitude_e6 - (37554232.7956))) + LEAST(abs(longitude_e6 - (126960317.235)), abs(360000000-longitude_e6 - (126960317.235))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37536473.3613))/19200) as latlevel, round((longitude_e6 - (126990435.381))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37536473.3613)), abs(180000000- latitude_e6 - (37536473.3613))) + LEAST(abs(longitude_e6 - (126990435.381)), abs(360000000-longitude_e6 - (126990435.381))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37536473.3613))/19200) as latlevel, round((longitude_e6 - (126990435.381))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37536473.3613)), abs(180000000- latitude_e6 - (37536473.3613))) + LEAST(abs(longitude_e6 - (126990435.381)), abs(360000000-longitude_e6 - (126990435.381))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37509231.9303))/19200) as latlevel, round((longitude_e6 - (127008175.904))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37509231.9303)), abs(180000000- latitude_e6 - (37509231.9303))) + LEAST(abs(longitude_e6 - (127008175.904)), abs(360000000-longitude_e6 - (127008175.904))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37500000:126930000','37566667:126966667','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35819999:127150001','35979999:126699996','35169998:126879997','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37548371.2009))/2400) as latlevel, round((longitude_e6 - (126943030.357))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37548371.2009)), abs(180000000- latitude_e6 - (37548371.2009))) + LEAST(abs(longitude_e6 - (126943030.357)), abs(360000000-longitude_e6 - (126943030.357))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37548371.2009))/2400) as latlevel, round((longitude_e6 - (126943030.357))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37548371.2009)), abs(180000000- latitude_e6 - (37548371.2009))) + LEAST(abs(longitude_e6 - (126943030.357)), abs(360000000-longitude_e6 - (126943030.357))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37548371.2009))/9600) as latlevel, round((longitude_e6 - (126943030.357))/9600) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37548371.2009)), abs(180000000- latitude_e6 - (37548371.2009))) + LEAST(abs(longitude_e6 - (126943030.357)), abs(360000000-longitude_e6 - (126943030.357))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37491329.8853))/614400) as latlevel, round((longitude_e6 - (126971502.811))/614400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37491329.8853)), abs(180000000- latitude_e6 - (37491329.8853))) + LEAST(abs(longitude_e6 - (126971502.811)), abs(360000000-longitude_e6 - (126971502.811))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37500000:126930000','38150001:127319999','36630001:127430000','36299999:127400001','39033333:125683333','35880001:128619995','34680000:125449996','33520000:126529998','35099998:129029998','33229999:126569999','31200000:121433333','29550000:106550000','16066667:108216667','-2:133883333','-866667:134083333','11550000:104850000','-5133333:119466667','22350000:91833333','-10166667:123566667','16783333:96150000') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37491329.8853))/614400) as latlevel, round((longitude_e6 - (126971502.811))/614400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37491329.8853)), abs(180000000- latitude_e6 - (37491329.8853))) + LEAST(abs(longitude_e6 - (126971502.811)), abs(360000000-longitude_e6 - (126971502.811))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37500000:126930000','38150001:127319999','36630001:127430000','36299999:127400001','39033333:125683333','35880001:128619995','34680000:125449996','33520000:126529998','35099998:129029998','33229999:126569999','31200000:121433333','29550000:106550000','16066667:108216667','-2:133883333','-866667:134083333','11550000:104850000','-5133333:119466667','22350000:91833333','-10166667:123566667','16783333:96150000') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37608792.036))/19200) as latlevel, round((longitude_e6 - (126927452.087))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37608792.036)), abs(180000000- latitude_e6 - (37608792.036))) + LEAST(abs(longitude_e6 - (126927452.087)), abs(360000000-longitude_e6 - (126927452.087))) asc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37610847.6353))/19200) as latlevel, round((longitude_e6 - (126923466.955))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37610847.6353)), abs(180000000- latitude_e6 - (37610847.6353))) + LEAST(abs(longitude_e6 - (126923466.955)), abs(360000000-longitude_e6 - (126923466.955))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37610847.6353))/9600) as latlevel, round((longitude_e6 - (126923466.955))/9600) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37610847.6353)), abs(180000000- latitude_e6 - (37610847.6353))) + LEAST(abs(longitude_e6 - (126923466.955)), abs(360000000-longitude_e6 - (126923466.955))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37610847.6353))/9600) as latlevel, round((longitude_e6 - (126923466.955))/9600) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37610847.6353)), abs(180000000- latitude_e6 - (37610847.6353))) + LEAST(abs(longitude_e6 - (126923466.955)), abs(360000000-longitude_e6 - (126923466.955))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37610847.6353))/9600) as latlevel, round((longitude_e6 - (126923466.955))/9600) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37610847.6353)), abs(180000000- latitude_e6 - (37610847.6353))) + LEAST(abs(longitude_e6 - (126923466.955)), abs(360000000-longitude_e6 - (126923466.955))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37610847.6353))/9600) as latlevel, round((longitude_e6 - (126923466.955))/9600) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37610847.6353)), abs(180000000- latitude_e6 - (37610847.6353))) + LEAST(abs(longitude_e6 - (126923466.955)), abs(360000000-longitude_e6 - (126923466.955))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37610847.6353))/9600) as latlevel, round((longitude_e6 - (126923466.955))/9600) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37610847.6353)), abs(180000000- latitude_e6 - (37610847.6353))) + LEAST(abs(longitude_e6 - (126923466.955)), abs(360000000-longitude_e6 - (126923466.955))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37553965))/19200) as latlevel, round((longitude_e6 - (126972800))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37553965)), abs(180000000- latitude_e6 - (37553965))) + LEAST(abs(longitude_e6 - (126972800)), abs(360000000-longitude_e6 - (126972800))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37641543.8471))/9600) as latlevel, round((longitude_e6 - (126922298.957))/9600) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37641543.8471)), abs(180000000- latitude_e6 - (37641543.8471))) + LEAST(abs(longitude_e6 - (126922298.957)), abs(360000000-longitude_e6 - (126922298.957))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37555908.8599))/19200) as latlevel, round((longitude_e6 - (126970615.874))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37555908.8599)), abs(180000000- latitude_e6 - (37555908.8599))) + LEAST(abs(longitude_e6 - (126970615.874)), abs(360000000-longitude_e6 - (126970615.874))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37641543.8471))/2400) as latlevel, round((longitude_e6 - (126922298.957))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37641543.8471)), abs(180000000- latitude_e6 - (37641543.8471))) + LEAST(abs(longitude_e6 - (126922298.957)), abs(360000000-longitude_e6 - (126922298.957))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37555908.8599))/19200) as latlevel, round((longitude_e6 - (126970615.874))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37555908.8599)), abs(180000000- latitude_e6 - (37555908.8599))) + LEAST(abs(longitude_e6 - (126970615.874)), abs(360000000-longitude_e6 - (126970615.874))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37639790.0989))/2400) as latlevel, round((longitude_e6 - (126911854.843))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37639790.0989)), abs(180000000- latitude_e6 - (37639790.0989))) + LEAST(abs(longitude_e6 - (126911854.843)), abs(360000000-longitude_e6 - (126911854.843))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37555908.8599))/19200) as latlevel, round((longitude_e6 - (126970615.874))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37555908.8599)), abs(180000000- latitude_e6 - (37555908.8599))) + LEAST(abs(longitude_e6 - (126970615.874)), abs(360000000-longitude_e6 - (126970615.874))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37639790.0989))/2400) as latlevel, round((longitude_e6 - (126911854.843))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37639790.0989)), abs(180000000- latitude_e6 - (37639790.0989))) + LEAST(abs(longitude_e6 - (126911854.843)), abs(360000000-longitude_e6 - (126911854.843))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37639790.0989))/2400) as latlevel, round((longitude_e6 - (126911854.843))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37639790.0989)), abs(180000000- latitude_e6 - (37639790.0989))) + LEAST(abs(longitude_e6 - (126911854.843)), abs(360000000-longitude_e6 - (126911854.843))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37639790.0989))/2400) as latlevel, round((longitude_e6 - (126911854.843))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37639790.0989)), abs(180000000- latitude_e6 - (37639790.0989))) + LEAST(abs(longitude_e6 - (126911854.843)), abs(360000000-longitude_e6 - (126911854.843))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37645056.7814))/2400) as latlevel, round((longitude_e6 - (126912367.245))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37645056.7814)), abs(180000000- latitude_e6 - (37645056.7814))) + LEAST(abs(longitude_e6 - (126912367.245)), abs(360000000-longitude_e6 - (126912367.245))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37652496.8885))/2400) as latlevel, round((longitude_e6 - (126894670.71))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37652496.8885)), abs(180000000- latitude_e6 - (37652496.8885))) + LEAST(abs(longitude_e6 - (126894670.71)), abs(360000000-longitude_e6 - (126894670.71))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37479999:126629997','37270000:126980003','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37652496.8885))/2400) as latlevel, round((longitude_e6 - (126894670.71))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37652496.8885)), abs(180000000- latitude_e6 - (37652496.8885))) + LEAST(abs(longitude_e6 - (126894670.71)), abs(360000000-longitude_e6 - (126894670.71))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37479999:126629997','37270000:126980003','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37652496.8885))/2400) as latlevel, round((longitude_e6 - (126894670.71))/2400) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37652496.8885)), abs(180000000- latitude_e6 - (37652496.8885))) + LEAST(abs(longitude_e6 - (126894670.71)), abs(360000000-longitude_e6 - (126894670.71))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37479999:126629997','37270000:126980003','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','35169998:126879997','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37553965))/19200) as latlevel, round((longitude_e6 - (126972800))/19200) as lonlevel from rainmap_weather group by latlevel, latlevel order by LEAST(abs(latitude_e6 - (37553965)), abs(180000000- latitude_e6 - (37553965))) + LEAST(abs(longitude_e6 - (126972800)), abs(360000000-longitude_e6 - (126972800))) asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003','37479999:126629997','37080001:127029998','38150001:127319999','37900001:127730003','37330001:127949996','36630001:127430000','36299999:127400001','35979999:126699996','35819999:127150001','36549999:128720001','39033333:125683333','35880001:128619995','34779998:126379997','35200000:128100006','36029998:129380004') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (39842286.0207))/2457600) as latlevel, round((longitude_e6 - (-113818359.375))/2457600) as lonlevel,LEAST(abs(latitude_e6 - (39842286.0207)), abs(180000000- latitude_e6 - (39842286.0207))) + LEAST(abs(longitude_e6 - (-113818359.375)), abs(360000000-longitude_e6 - (-113818359.375))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('17516667:-88183333','14616667:-90516667','13700000:-89216667','25083333:-77350000','19900000:-75150000','3416667:-76500000','38750000:-27083333','6833333:-58200000','61183333:-45416667','4933333:-52450000','-1450000:-48483333','-26833333:-65166667','-3766667:-38550000','-31366667:-64250000','-15866667:-47916667','43300000:5383333','45700000:4783333','28583333:7','-8066667:-34883333','-13000000:-38500000') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (33431441.3356))/614400) as latlevel, round((longitude_e6 - (-101909179.688))/614400) as lonlevel,LEAST(abs(latitude_e6 - (33431441.3356)), abs(180000000- latitude_e6 - (33431441.3356))) + LEAST(abs(longitude_e6 - (-101909179.688)), abs(360000000-longitude_e6 - (-101909179.688))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('20683333:-103333333','32950000:-85950000','42533333:-113766667','29183333:-81050000','27466667:-80350000','26650000:-80650000','17516667:-88183333','23133333:-82350000','14616667:-90516667','13700000:-89216667','25083333:-77350000','12166667:-86250000','19900000:-75150000','8966667:-79550000','18483333:-69900000','10983333:-74800000','3416667:-76500000','-216667:-78533333','58366667:-134583333','6833333:-58200000') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (31428663.1174))/4915200) as latlevel, round((longitude_e6 - (-95888671.875))/4915200) as lonlevel,LEAST(abs(latitude_e6 - (31428663.1174)), abs(180000000- latitude_e6 - (31428663.1174))) + LEAST(abs(longitude_e6 - (-95888671.875)), abs(360000000-longitude_e6 - (-95888671.875))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('17516667:-88183333','25083333:-77350000','4933333:-52450000','-1450000:-48483333','-26833333:-65166667','-8066667:-34883333','-19933333:-43950000','-34583333:-58483333','-22916667:-43200000','43300000:5383333','50800000:4350000','48250000:16366667','55683333:12550000','60166667:24950000','64133333:21933333','-53166667:-7','22350000:91833333','11550000:104850000','33520000:126529998','37500000:126930000') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37420909.0426))/153600) as latlevel, round((longitude_e6 - (126784540))/153600) as lonlevel,LEAST(abs(latitude_e6 - (37420909.0426)), abs(180000000- latitude_e6 - (37420909.0426))) + LEAST(abs(longitude_e6 - (126784540)), abs(360000000-longitude_e6 - (126784540))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37479999:126629997','37500000:126930000','37270000:126980003','37750000:127029998','37080001:127029998','38150001:127319999','37900001:127730003','36630001:127430000','35979999:126699996','36299999:127400001','39033333:125683333','36549999:128720001','34779998:126379997','35880001:128619995','35200000:128100006','34680000:125449996','33520000:126529998','33229999:126569999','35549999:129320007','35099998:129029998') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37341775.5021))/307200) as latlevel, round((longitude_e6 - (127257385.254))/307200) as lonlevel,LEAST(abs(latitude_e6 - (37341775.5021)), abs(180000000- latitude_e6 - (37341775.5021))) + LEAST(abs(longitude_e6 - (127257385.254)), abs(360000000-longitude_e6 - (127257385.254))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37270000:126980003','37500000:126930000','37080001:127029998','38150001:127319999','36630001:127430000','37900001:127730003','36299999:127400001','35979999:126699996','35880001:128619995','39033333:125683333','34779998:126379997','35549999:129320007','35099998:129029998','34680000:125449996','33520000:126529998','33229999:126569999','31200000:121433333','29550000:106550000','16066667:108216667','-2:133883333') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (35523285.1791))/307200) as latlevel, round((longitude_e6 - (128402709.961))/307200) as lonlevel,LEAST(abs(latitude_e6 - (35523285.1791)), abs(180000000- latitude_e6 - (35523285.1791))) + LEAST(abs(longitude_e6 - (128402709.961)), abs(360000000-longitude_e6 - (128402709.961))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('35880001:128619995','35549999:129320007','35099998:129029998','36029998:129380004','36299999:127400001') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37762029.8857))/307200) as latlevel, round((longitude_e6 - (127518310.547))/307200) as lonlevel,LEAST(abs(latitude_e6 - (37762029.8857)), abs(180000000- latitude_e6 - (37762029.8857))) + LEAST(abs(longitude_e6 - (127518310.547)), abs(360000000-longitude_e6 - (127518310.547))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37900001:127730003','38150001:127319999','37500000:126930000','37270000:126980003','36630001:127430000') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37405073.7502))/1228800) as latlevel, round((longitude_e6 - (127908325.195))/1228800) as lonlevel,LEAST(abs(latitude_e6 - (37405073.7502)), abs(180000000- latitude_e6 - (37405073.7502))) + LEAST(abs(longitude_e6 - (127908325.195)), abs(360000000-longitude_e6 - (127908325.195))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37500000:126930000','36630001:127430000','38150001:127319999','35099998:129029998','33520000:126529998') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (34234512.3624))/1228800) as latlevel, round((longitude_e6 - (136450195.312))/1228800) as lonlevel,LEAST(abs(latitude_e6 - (34234512.3624)), abs(180000000- latitude_e6 - (34234512.3624))) + LEAST(abs(longitude_e6 - (136450195.312)), abs(360000000-longitude_e6 - (136450195.312))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('35099998:129029998','33520000:126529998','34680000:125449996','37270000:126980003','37500000:126930000') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (34234512.3624))/1228800) as latlevel, round((longitude_e6 - (136450195.312))/1228800) as lonlevel,LEAST(abs(latitude_e6 - (34234512.3624)), abs(180000000- latitude_e6 - (34234512.3624))) + LEAST(abs(longitude_e6 - (136450195.312)), abs(360000000-longitude_e6 - (136450195.312))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('35099998:129029998','33520000:126529998','34680000:125449996','37270000:126980003','37500000:126930000') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37553965))/19200) as latlevel, round((longitude_e6 - (126972800))/19200) as lonlevel,LEAST(abs(latitude_e6 - (37553965)), abs(180000000- latitude_e6 - (37553965))) + LEAST(abs(longitude_e6 - (126972800)), abs(360000000-longitude_e6 - (126972800))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (37555908.8599))/19200) as latlevel, round((longitude_e6 - (126970615.874))/19200) as lonlevel,LEAST(abs(latitude_e6 - (37555908.8599)), abs(180000000- latitude_e6 - (37555908.8599))) + LEAST(abs(longitude_e6 - (126970615.874)), abs(360000000-longitude_e6 - (126970615.874))) as dist from rainmap_weather group by latlevel, latlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('37566667:126966667','37500000:126930000','37549999:126800003','37750000:127029998','37270000:126980003') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (35173808.318))/1228800) as latlevel, round((longitude_e6 - (136384277.344))/1228800) as lonlevel,LEAST(abs(latitude_e6 - (35173808.318)), abs(180000000- latitude_e6 - (35173808.318))) + LEAST(abs(longitude_e6 - (136384277.344)), abs(360000000-longitude_e6 - (136384277.344))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('35683333:139766667','35099998:129029998','33583333:130450000','37479999:130899993','35200000:128100006') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (63312682.7804))/9830400) as latlevel, round((longitude_e6 - (-102656250))/9830400) as lonlevel,LEAST(abs(latitude_e6 - (63312682.7804)), abs(180000000- latitude_e6 - (63312682.7804))) + LEAST(abs(longitude_e6 - (-102656250)), abs(360000000-longitude_e6 - (-102656250))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('48616667:-112366667','40000000:-105266667','37450000:-105866667','39116667:-108533333','41750000:-88333333') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (63154355.1966))/4915200) as latlevel, round((longitude_e6 - (-111445312.5))/4915200) as lonlevel,LEAST(abs(latitude_e6 - (63154355.1966)), abs(180000000- latitude_e6 - (63154355.1966))) + LEAST(abs(longitude_e6 - (-111445312.5)), abs(360000000-longitude_e6 - (-111445312.5))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('48616667:-112366667','48416667:-106533333','45800000:-108533333','47766667:-116816667','42533333:-113766667') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (-15284185.1141))/4915200) as latlevel, round((longitude_e6 - (-54492187.5))/4915200) as lonlevel,LEAST(abs(latitude_e6 - (-15284185.1141)), abs(180000000- latitude_e6 - (-15284185.1141))) + LEAST(abs(longitude_e6 - (-54492187.5)), abs(360000000-longitude_e6 - (-54492187.5))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('-15866667:-47916667','-25283333:-57500000','-19933333:-43950000','-25416667:-49283333','-30033333:-51216667') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (61814663.8947))/2457600) as latlevel, round((longitude_e6 - (-110214843.75))/2457600) as lonlevel,LEAST(abs(latitude_e6 - (61814663.8947)), abs(180000000- latitude_e6 - (61814663.8947))) + LEAST(abs(longitude_e6 - (-110214843.75)), abs(360000000-longitude_e6 - (-110214843.75))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('48566667:-109666667','48616667:-112366667','47483333:-111366667','45783333:-111150000','48416667:-106533333') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (61814663.8947))/2457600) as latlevel, round((longitude_e6 - (-110214843.75))/2457600) as lonlevel,LEAST(abs(latitude_e6 - (61814663.8947)), abs(180000000- latitude_e6 - (61814663.8947))) + LEAST(abs(longitude_e6 - (-110214843.75)), abs(360000000-longitude_e6 - (-110214843.75))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('48566667:-109666667','48616667:-112366667','47483333:-111366667','45783333:-111150000','48416667:-106533333') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (54749990.9702))/2457600) as latlevel, round((longitude_e6 - (571289.0625))/2457600) as lonlevel,LEAST(abs(latitude_e6 - (54749990.9702)), abs(180000000- latitude_e6 - (54749990.9702))) + LEAST(abs(longitude_e6 - (571289.0625)), abs(360000000-longitude_e6 - (571289.0625))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('54716667:2','53183333:5','52483333:-1933333','50450000:3','55916667:-3183333') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (47842657.6282))/1228800) as latlevel, round((longitude_e6 - (7338867.1875))/1228800) as lonlevel,LEAST(abs(latitude_e6 - (47842657.6282)), abs(180000000- latitude_e6 - (47842657.6282))) + LEAST(abs(longitude_e6 - (7338867.1875)), abs(360000000-longitude_e6 - (7338867.1875))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('48583333:7766667','47383333:8550000','49566667:8466667','43700000:7266667','45450000:9283333') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (47842657.6282))/1228800) as latlevel, round((longitude_e6 - (7338867.1875))/1228800) as lonlevel,LEAST(abs(latitude_e6 - (47842657.6282)), abs(180000000- latitude_e6 - (47842657.6282))) + LEAST(abs(longitude_e6 - (7338867.1875)), abs(360000000-longitude_e6 - (7338867.1875))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('48583333:7766667','47383333:8550000','49566667:8466667','43700000:7266667','45450000:9283333','48150000:11566667','45700000:4783333','48816667:2483333','50800000:4350000','43300000:5383333') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (49023461.4632))/1228800) as latlevel, round((longitude_e6 - (25620117.1875))/1228800) as lonlevel,LEAST(abs(latitude_e6 - (49023461.4632)), abs(180000000- latitude_e6 - (49023461.4632))) + LEAST(abs(longitude_e6 - (25620117.1875)), abs(360000000-longitude_e6 - (25620117.1875))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('50066667:19950000','46483333:30733333','52216667:21033333','47516667:19033333','44800000:20466667','48250000:16366667','40616667:22950000','40966667:28833333','50000000:36233333','60166667:24950000') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (48283192.8955))/1228800) as latlevel, round((longitude_e6 - (58886718.75))/1228800) as lonlevel,LEAST(abs(latitude_e6 - (48283192.8955)), abs(180000000- latitude_e6 - (48283192.8955))) + LEAST(abs(longitude_e6 - (58886718.75)), abs(360000000-longitude_e6 - (58886718.75))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('56816667:60633333','48700000:44516667','35683333:51416667','47216667:39716667','41716667:44800000','43233333:76883333','50000000:36233333','34016667:71583333','30350000:48266667','55766667:37666667') order by regdate desc select area_name,latitude_e6, longitude_e6, round((latitude_e6 - (29840643.8998))/4915200) as latlevel, round((longitude_e6 - (102744140.625))/4915200) as lonlevel,LEAST(abs(latitude_e6 - (29840643.8998)), abs(180000000- latitude_e6 - (29840643.8998))) + LEAST(abs(longitude_e6 - (102744140.625)), abs(360000000-longitude_e6 - (102744140.625))) as dist from rainmap_weather group by latlevel, lonlevel order by dist asc select * from rainmap_weather where concat(latitude_e6,':',longitude_e6) in ('29550000:106550000','21033333:105866667','22350000:91833333','16066667:108216667','16783333:96150000','31200000:121433333','11550000:104850000','22533333:88333333','25033333:121516667','5416667:100316667') order by regdate desc