diff --git a/src/osm/jp/coverage/busstop/ToPostgis.java b/src/osm/jp/coverage/busstop/ToPostgis.java index 12e16b6..84218ed 100644 --- a/src/osm/jp/coverage/busstop/ToPostgis.java +++ b/src/osm/jp/coverage/busstop/ToPostgis.java @@ -17,6 +17,7 @@ * テーブル名: t_busstop * インデックス: ix_busstop_geom * gid PostGISの識別ID + * gmlid 国土数値情報のID(areaと合わせてKEYとなる) * name バス停名称 * fixed OSMのバス停が周辺に存在するかどうか、存在しない場合は0,存在する場合はその数。 * geom PostGIS形式の位置情報(4612:) @@ -61,7 +62,7 @@ public static void transportNew (Connection conHsql, Connection conPost) throws FileNotFoundException, ClassNotFoundException, SQLException, IOException, ParserConfigurationException, SAXException { HttpPOST httpPOST = new HttpPOST(conPost, null); httpPOST.sql("DROP TABLE IF EXISTS t_busstop CASCADE;"); - httpPOST.sql("CREATE TABLE t_busstop (gid SERIAL PRIMARY KEY,gmlid text,name text,fixed integer,area integer,geom GEOMETRY(POINT, 4612));"); + httpPOST.sql("CREATE TABLE t_busstop (gid SERIAL PRIMARY KEY, gmlid text, idref text, name text, fixed integer, area integer, geom GEOMETRY(POINT, 4612));"); httpPOST.sql("CREATE INDEX ix_busstop_geom ON t_busstop USING GiST (geom);"); toInsert(conHsql, conPost); } diff --git a/src/osmdb.properties b/src/osmdb.properties new file mode 100644 index 0000000..bdedd56 --- /dev/null +++ b/src/osmdb.properties @@ -0,0 +1,7 @@ +# for Docker +# +db_driver=org.postgresql.Driver +db_url=jdbc:postgresql://172.17.0.1:5432/osmdb +db_user=postgres +db_passwd=yuu8844 +