diff --git a/src/osm/jp/coverage/busstop/ToGeoJSON.java b/src/osm/jp/coverage/busstop/ToGeoJSON.java index ee628cb..40503ef 100644 --- a/src/osm/jp/coverage/busstop/ToGeoJSON.java +++ b/src/osm/jp/coverage/busstop/ToGeoJSON.java @@ -31,7 +31,7 @@ + "ST_AsGeoJSON(ST_Transform(t_%s.geom,4326))::json As geometry, " + "row_to_json((" + "SELECT p FROM (SELECT t_%s.gmlid, t_%s.fixed) AS p" - + ")) AS properties From t_%s %s order by area,idref) As feature"; + + ")) AS properties From t_%s %s order by area,gmlid) As feature"; Connection con = DatabaseTool.openDb("postgis"); obj.outputDb(con, "", new File("GML_BUSSTOP", "busstop.json"), false); obj.outputDb(con, "WHERE fixed=0", new File("GML_BUSSTOP", "busstop0.json"), false);