diff --git a/src/osm/jp/coverage/fuel/DbFuel.java b/src/osm/jp/coverage/fuel/DbFuel.java index 7eecd5f..cf038fb 100644 --- a/src/osm/jp/coverage/fuel/DbFuel.java +++ b/src/osm/jp/coverage/fuel/DbFuel.java @@ -402,9 +402,10 @@ public void outputRemoved(File removedFile) throws SQLException, IOException { String whereStr = "WHERE (removed=?)"; String fromStr = "FROM "+ DbFuel.TABLE_NAME; - String sql = String.format("SELECT gmlid,area,idref %s %s", fromStr, whereStr); + String sortStr = "ORDER BY area,gmlid"; + String sql = String.format("SELECT * %s %s %s", fromStr, whereStr, sortStr); - try (FileWriter fw = new FileWriter(removedFile, true); + try (FileWriter fw = new FileWriter(removedFile); PreparedStatement ps1 = hsqldb.prepareStatement(sql)) { System.out.println(sql);