diff --git a/doc/NagoyaBusstop.qgs b/doc/NagoyaBusstop.qgs
new file mode 100644
index 0000000..f2a8276
--- /dev/null
+++ b/doc/NagoyaBusstop.qgs
@@ -0,0 +1,572 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ meters
+
+ 15233446.85589521564543247
+ 4183206.5351748620159924
+ 15234360.58094646222889423
+ 4184210.3740612999536097
+
+ 0
+ 1
+
+
+ +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs
+ 3857
+ 3857
+ EPSG:3857
+ WGS 84 / Pseudo Mercator
+ merc
+ WGS84
+ false
+
+
+ 0
+
+
+
+
+
+
+
+ - nagoya_busstop20170225161030940
+ - OCM_Public_Transport20170225161054008
+
+
+
+
+
+
+ -20037508.33999999985098839
+ -20037508.33999999985098839
+ 20037508.33999999985098839
+ 20037508.33999999985098839
+
+ OCM_Public_Transport20170225161054008
+ <GDAL_WMS>
+ <Service name="TMS">
+ <ServerUrl>http://tile.opencyclemap.org/transport/${z}/${x}/${y}.png</ServerUrl>
+ </Service>
+ <DataWindow>
+ <UpperLeftX>-20037508.34</UpperLeftX>
+ <UpperLeftY>20037508.34</UpperLeftY>
+ <LowerRightX>20037508.34</LowerRightX>
+ <LowerRightY>-20037508.34</LowerRightY>
+ <TileLevel>18</TileLevel>
+ <TileCountX>1</TileCountX>
+ <TileCountY>1</TileCountY>
+ <YOrigin>top</YOrigin>
+ </DataWindow>
+ <Projection>EPSG:3857</Projection>
+ <BlockSizeX>256</BlockSizeX>
+ <BlockSizeY>256</BlockSizeY>
+ <BandsCount>3</BandsCount>
+ <Cache />
+</GDAL_WMS>
+
+
+
+
+ OCM Public Transport
+
+
+ +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs
+ 3857
+ 3857
+ EPSG:3857
+ WGS 84 / Pseudo Mercator
+ merc
+ WGS84
+ false
+
+
+
+
+
+
+ gdal
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+
+
+
+ 136.794921875
+ 35.04031753540039773
+ 137.04507446289099448
+ 35.26501846313480115
+
+ nagoya_busstop20170225161030940
+ dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."nagoya_busstop" (geom) sql=
+
+
+
+ nagoya_busstop
+
+
+ +proj=longlat +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +no_defs
+ 3465
+ 4612
+ EPSG:4612
+ JGD2000
+ longlat
+ GRS80
+ true
+
+
+ postgres
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ 0
+ 0
+ name
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ .
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ .
+
+ 0
+ .
+
+ 0
+ generatedlayout
+
+
+
+
+
+
+
+
+
+ meters
+ m2
+
+
+ +proj=longlat +datum=WGS84 +no_defs
+ EPSG:4326
+ 3452
+ 1
+
+
+ false
+
+
+ 0
+ 255
+ 255
+ 255
+ 255
+ 255
+ 255
+
+
+ 2
+ current_layer
+ off
+ 0
+
+
+ 2
+ true
+
+
+
+
+
diff --git a/doc/station_kanagawa.qgs b/doc/station_kanagawa.qgs
new file mode 100644
index 0000000..8459b76
--- /dev/null
+++ b/doc/station_kanagawa.qgs
@@ -0,0 +1,793 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ degrees
+
+ 139.27223793996034829
+ 35.32758340004136954
+ 139.75527656263534482
+ 35.61339554781637418
+
+ 0
+ 0
+
+
+ +proj=longlat +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +no_defs
+ 3465
+ 4612
+ EPSG:4612
+ JGD2000
+ longlat
+ GRS80
+ true
+
+
+ 0
+
+
+
+
+ - V_kanagawa20170106130334171
+ - V_stastion_kanagawa20170106135543840
+
+
+
+
+
+
+ 138.91576791200000685
+ 35.12849244099999879
+ 139.83584147900000971
+ 35.67289653200000288
+
+ V_kanagawa20170106130334171
+ dbname='pgis' port=5432 user='yuu' password='yuu8844' sslmode=disable key='gid' srid=4612 type=MultiPolygon table="public"."V_kanagawa" (geom) sql=
+
+
+
+ V_kanagawa
+
+
+ +proj=longlat +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +no_defs
+ 3465
+ 4612
+ EPSG:4612
+ JGD2000
+ longlat
+ GRS80
+ true
+
+
+ postgres
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ 0
+ 0
+ name
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ .
+
+
+
+ .
+
+ 0
+ .
+
+ 0
+ generatedlayout
+
+
+
+
+
+
+
+
+ 139.03542999999999097
+ 35.14535000000000053
+ 139.747950000000003
+ 35.63472999999999757
+
+ V_stastion_kanagawa20170106135543840
+ dbname='pgis' port=5432 user='yuu' password='yuu8844' sslmode=disable key='gid' srid=4612 type=MultiLineString table="public"."V_stastion_kanagawa" (geom) sql=
+
+
+
+ V_stastion_kanagawa
+
+
+ +proj=longlat +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +no_defs
+ 3465
+ 4612
+ EPSG:4612
+ JGD2000
+ longlat
+ GRS80
+ true
+
+
+ postgres
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ 0
+ 0
+ gid
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+
+
+ 0
+ generatedlayout
+
+
+
+
+
+
+
+
+
+
+
+
+
+ +proj=longlat +datum=WGS84 +no_defs
+ EPSG:4326
+ 3452
+
+
+ false
+
+
+ 0
+ 255
+ 255
+ 255
+ 255
+ 255
+ 255
+
+
+ 2
+
+ V_kanagawa20170106130334171
+
+
+ disabled
+
+ current_layer
+
+
+ 2
+
+
+ to_vertex_and_segment
+
+ off
+ 0
+
+ 0.000000
+
+
+
+ 2
+ true
+
+
+
+
+
diff --git a/src/Nagoya_busstop.sql b/src/Nagoya_busstop.sql
new file mode 100644
index 0000000..6d9d472
--- /dev/null
+++ b/src/Nagoya_busstop.sql
@@ -0,0 +1,13 @@
+-- DROP TABLE t_busstop;
+CREATE TABLE nagoya_busstop (gid SERIAL PRIMARY KEY, name text, kana text, fixed integer, area integer, geom GEOMETRY(POINT, 4612));
+CREATE INDEX ix_nagoya_busstop_geom ON nagoya_busstop USING GiST (geom);
+
+insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相川一丁目','アイカワイッチョウメ',0,0, ST_GeomFromText('POINT(136.9695284611471 35.10300377075564)', 4612));
+insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相川一丁目','アイカワイッチョウメ',0,0, ST_GeomFromText('POINT(136.969047121627 35.102834616747685)', 4612));
+insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相生山住宅','アイオイヤマジュウタク',0,0, ST_GeomFromText('POINT(136.9743151095072 35.10462957171922)', 4612));
+insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相生山住宅','アイオイヤマジュウタク',0,0, ST_GeomFromText('POINT(136.97421198072038 35.10334076583495)', 4612));
+insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相生山住宅','アイオイヤマジュウタク',0,0, ST_GeomFromText('POINT(136.9744339059364 35.10354449054206)', 4612));
+insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相生山住宅南','アイオイヤマジュウタクミナミ',0,0, ST_GeomFromText('POINT(136.97261499203069 35.102706336248744)', 4612));
+insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相生山住宅南','アイオイヤマジュウタクミナミ',0,0, ST_GeomFromText('POINT(136.97317171870043 35.10254162416889)', 4612));
+
+
diff --git a/src/nagoya.sh b/src/nagoya.sh
new file mode 100755
index 0000000..cd9042e
--- /dev/null
+++ b/src/nagoya.sh
@@ -0,0 +1 @@
+java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.NagoyaBusstop
diff --git a/src/osm/jp/coverage/busstop/DbBusstop.java b/src/osm/jp/coverage/busstop/DbBusstop.java
index 684ba76..42a3488 100644
--- a/src/osm/jp/coverage/busstop/DbBusstop.java
+++ b/src/osm/jp/coverage/busstop/DbBusstop.java
@@ -48,7 +48,7 @@
// 'table.BUS_STOP'を新規に作る
drop(con, "bus_stop");
- createSt = "CREATE TABLE bus_stop (idref VARCHAR(12) NOT NULL, name VARCHAR(128), lat DOUBLE, lon DOUBLE, fixed INT, area INT, ifile VARCHAR(128), CONSTRAINT bus_stop_pk PRIMARY KEY(idref));";
+ createSt = "CREATE TABLE bus_stop (idref VARCHAR(12) NOT NULL, name VARCHAR(128), kana VARCHAR(128), lat DOUBLE, lon DOUBLE, fixed INT, area INT, ifile VARCHAR(128), CONSTRAINT bus_stop_pk PRIMARY KEY(idref));";
create(con, createSt);
drop(con, "existing_data");
diff --git a/src/osm/jp/coverage/busstop/NagoyaBusstop.java b/src/osm/jp/coverage/busstop/NagoyaBusstop.java
new file mode 100644
index 0000000..b3d5dc3
--- /dev/null
+++ b/src/osm/jp/coverage/busstop/NagoyaBusstop.java
@@ -0,0 +1,443 @@
+package osm.jp.coverage.busstop;
+import osm.jp.api.HttpPOST;
+import javax.xml.parsers.*;
+import org.w3c.dom.*;
+import org.xml.sax.*;
+
+import java.io.*;
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+import java.text.SimpleDateFormat;
+import java.util.Iterator;
+
+import jp.co.areaweb.tools.csv.CsvFile;
+import jp.co.areaweb.tools.csv.CsvRecord;
+import jp.co.areaweb.tools.database.*;
+
+public class NagoyaBusstop {
+
+ String filter = "";
+ String urlStr = "";
+
+ public static final boolean DB_INIT = false;
+
+ // 近くのバス停を探す範囲（バス停を中心としたNEERｍ四方の領域
+ static final int NEER = 25; // 20m
+
+ public static SimpleDateFormat timeStampFmt = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'");
+
+ /**
+ * メイン
+ *
+ * java -cp .:ConvBusstop.jar:hayashi_0225.jar:hsqldb_2.2.9.jar osm.jp.ConvBusstop