diff --git a/doc/sql/Nagoya_busstop.sql b/doc/sql/Nagoya_busstop.sql
new file mode 100644
index 0000000..f31d20d
--- /dev/null
+++ b/doc/sql/Nagoya_busstop.sql
@@ -0,0 +1,17 @@
+DROP TABLE nagoya_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);
+select count(*) from nagoya_busstop;
+select count(*) from nagoya_busstop where fixed=0;
+select count(*) from nagoya_busstop where fixed>=50 and fixed<100;
+select count(*) from nagoya_busstop where fixed>=100;
+
+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/doc/sql/create_busstop.sql b/doc/sql/create_busstop.sql
new file mode 100644
index 0000000..044efcf
--- /dev/null
+++ b/doc/sql/create_busstop.sql
@@ -0,0 +1,74 @@
+-- DROP TABLE t_busstop;
+CREATE TABLE t_busstop (gid SERIAL PRIMARY KEY,name text,fixed integer,area integer,geom GEOMETRY(POINT, 4612));
+CREATE INDEX ix_busstop_geom ON t_busstop USING GiST (geom);
+
+-- DROP VIEW public."V_14kanagawa_busstop";
+CREATE OR REPLACE VIEW public."V_14kanagawa_busstop" AS
+ SELECT admarea.gid,
+ (( SELECT fixed FROM t_busstop WHERE st_within(t_busstop.geom, admarea.geom)))::integer AS stncnt,
+ admarea.geom,
+ admarea.n03_004 AS name
+ FROM admarea;
+
+-- DROP VIEW public."V_busstop_0";
+CREATE OR REPLACE VIEW public."V_busstop_0" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE fixed=0;
+CREATE OR REPLACE VIEW public."V_busstop_1" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE fixed>0 AND fixed<50;
+CREATE OR REPLACE VIEW public."V_busstop_2" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE fixed>49;
+
+-- DROP VIEW public."V_busstop_14";
+CREATE OR REPLACE VIEW public."V_busstop_01" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=1;
+CREATE OR REPLACE VIEW public."V_busstop_02" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=2;
+CREATE OR REPLACE VIEW public."V_busstop_03" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=3;
+CREATE OR REPLACE VIEW public."V_busstop_04" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=4;
+CREATE OR REPLACE VIEW public."V_busstop_05" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=5;
+CREATE OR REPLACE VIEW public."V_busstop_06" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=6;
+CREATE OR REPLACE VIEW public."V_busstop_07" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=7;
+CREATE OR REPLACE VIEW public."V_busstop_08" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=8;
+CREATE OR REPLACE VIEW public."V_busstop_09" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=9;
+CREATE OR REPLACE VIEW public."V_busstop_10" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=10;
+CREATE OR REPLACE VIEW public."V_busstop_11" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=11;
+CREATE OR REPLACE VIEW public."V_busstop_12" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=12;
+CREATE OR REPLACE VIEW public."V_busstop_13" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=13;
+CREATE OR REPLACE VIEW public."V_busstop_14" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=14;
+CREATE OR REPLACE VIEW public."V_busstop_15" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=15;
+CREATE OR REPLACE VIEW public."V_busstop_16" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=16;
+CREATE OR REPLACE VIEW public."V_busstop_17" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=17;
+CREATE OR REPLACE VIEW public."V_busstop_18" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=18;
+CREATE OR REPLACE VIEW public."V_busstop_19" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=19;
+CREATE OR REPLACE VIEW public."V_busstop_20" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=20;
+CREATE OR REPLACE VIEW public."V_busstop_21" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=21;
+CREATE OR REPLACE VIEW public."V_busstop_22" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=22;
+CREATE OR REPLACE VIEW public."V_busstop_23" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=23;
+CREATE OR REPLACE VIEW public."V_busstop_24" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=24;
+CREATE OR REPLACE VIEW public."V_busstop_25" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=25;
+CREATE OR REPLACE VIEW public."V_busstop_26" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=26;
+CREATE OR REPLACE VIEW public."V_busstop_27" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=27;
+CREATE OR REPLACE VIEW public."V_busstop_28" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=28;
+CREATE OR REPLACE VIEW public."V_busstop_29" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=29;
+CREATE OR REPLACE VIEW public."V_busstop_30" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=30;
+CREATE OR REPLACE VIEW public."V_busstop_31" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=31;
+CREATE OR REPLACE VIEW public."V_busstop_32" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=32;
+CREATE OR REPLACE VIEW public."V_busstop_33" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=33;
+CREATE OR REPLACE VIEW public."V_busstop_34" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=34;
+CREATE OR REPLACE VIEW public."V_busstop_35" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=35;
+CREATE OR REPLACE VIEW public."V_busstop_36" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=36;
+CREATE OR REPLACE VIEW public."V_busstop_37" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=37;
+CREATE OR REPLACE VIEW public."V_busstop_38" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=38;
+CREATE OR REPLACE VIEW public."V_busstop_39" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=39;
+CREATE OR REPLACE VIEW public."V_busstop_40" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=40;
+CREATE OR REPLACE VIEW public."V_busstop_41" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=41;
+CREATE OR REPLACE VIEW public."V_busstop_42" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=42;
+CREATE OR REPLACE VIEW public."V_busstop_43" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=43;
+CREATE OR REPLACE VIEW public."V_busstop_44" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=44;
+CREATE OR REPLACE VIEW public."V_busstop_45" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=45;
+CREATE OR REPLACE VIEW public."V_busstop_46" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=46;
+CREATE OR REPLACE VIEW public."V_busstop_47" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=47;
+
+
+
+-- ADMAREA
+ SELECT t_busstop.gid, t_busstop.geom FROM t_busstop,admarea WHERE st_within(rail.c_geom, admarea.geom);
+
+
+ALTER TABLE public."V_kanagawa"
+ OWNER TO yuu;
diff --git a/doc/sql/t_BUSSTOP.sql b/doc/sql/t_BUSSTOP.sql
new file mode 100644
index 0000000..7b1f5bb
--- /dev/null
+++ b/doc/sql/t_BUSSTOP.sql
@@ -0,0 +1,66 @@
+---<< postgis: postgres >>---
+db_driver=org.postgresql.Driver
+db_url=jdbc:postgresql://surveyor.mydns.jp:5432/gisdb
+db_user=gisuser
+db_passwd=gisuser
+-------------------------
+CREATE TABLE t_busstop (
+ gid SERIAL PRIMARY KEY,
+ gmlid text,
+ name text,
+ fixed integer,
+ area integer,
+ geom GEOMETRY(POINT, 4612)
+);
+CREATE INDEX ix_busstop_geom ON t_busstop USING GiST (geom);
+
+insert into t_busstop(osm_id,name,geom) select osm_id, st_transform(way,4612) FROM planet_osm_point WHERE (highway='bus_stop');
+insert into t_busstop(osm_id,name,geom) VALUES(884, 'なまえ', ST_GeomFromText('POINT(139.4110836 35.4341053)', 4612));
+
+----
+CREATE TABLE t_test (
+ gid SERIAL PRIMARY KEY,
+ osm_id bigint,
+ name text,
+ geom GEOMETRY(POINT, 4612)
+);
+
+CREATE INDEX ix_test_geom ON t_test USING GiST (geom);
+
+insert into t_test(osm_id,name,geom) VALUES(884, 'なまえ', ST_GeomFromText('POINT(139.4110836 35.4341053)', 4612));
+
+----
+GRANT SELECT ON t_BUSSTOP TO gisuser;
+
+---<< database: hsqldb >>---
+CREATE TABLE bus_stop (
+ gmlid VARCHAR(12) NOT NULL,
+ name VARCHAR(128),
+ lat DOUBLE,
+ lon DOUBLE,
+ fixed INT,
+ fixed1 INT,
+ area INT,
+ ifile VARCHAR(128),
+ up INT,
+ CONSTRAINT bus_stop_pk PRIMARY KEY(gmlid,area));
+CREATE INDEX bus_stop_index ON bus_stop(lat,lon);
+SELECT gmlid,name,lat,lon,fixed1,area FROM bus_stop;
+
+CREATE TABLE OSM_EXIST (
+ osmid VARCHAR(12) NOT NULL,
+ name VARCHAR(128),
+ lat DOUBLE,
+ lon DOUBLE,
+ score INT,
+ CONSTRAINT existing_pk PRIMARY KEY(osmid, lat, lon));
+
+CREATE TABLE coverage (
+ area INT,
+ name VARCHAR(128),
+ denominator BIGINT,
+ lv1 BIGINT,
+ lv2 BIGINT,
+ lv3 BIGINT);
+
+-------------------------
\ No newline at end of file
diff --git a/doc/sql/t_FUEL.sql b/doc/sql/t_FUEL.sql
new file mode 100644
index 0000000..cf25ecc
--- /dev/null
+++ b/doc/sql/t_FUEL.sql
@@ -0,0 +1,67 @@
+---<< postgis: postgres >>---
+db_driver=org.postgresql.Driver
+db_url=jdbc:postgresql://surveyor.mydns.jp:5432/gisdb
+db_user=gisuser
+db_passwd=gisuser
+---<< osmdb: postgres >>---
+db_driver=org.postgresql.Driver
+db_url=jdbc:postgresql://localhost:5432/osmdb
+db_user=postgres
+db_passwd=*******
+-------------------------
+DROP TABLE t_FUEL;
+CREATE TABLE t_FUEL (
+ gid SERIAL PRIMARY KEY,
+ idref text,
+ gmlid text,
+ area integer,
+ fixed integer,
+ geom GEOMETRY(POINT, 4612)
+);
+CREATE INDEX ix_t_FUEL_geom ON t_fuel USING GiST (geom);
+DELETE FROM t_FUEL;
+insert into t_FUEL (gmlid,fixed,area,geom) VALUES('n000001',0,0, ST_GeomFromText('POINT(136.9695284611471 35.10300377075564)', 4612));
+insert into t_FUEL (gmlid,fixed,area,geom) VALUES('n000002',0,0, ST_GeomFromText('POINT(136.969047121627 35.102834616747685)', 4612));
+insert into t_FUEL (gmlid,fixed,area,geom) VALUES('n000003',0,0, ST_GeomFromText('POINT(136.9743151095072 35.10462957171922)', 4612));
+-------------------------
+GRANT SELECT ON t_fuel TO gisuser;
+
+---<< database: hsqldb >>---
+-------------------------
+
+CREATE TABLE FUEL_EXIST (
+ idref VARCHAR(12) NOT NULL,
+ lat DOUBLE,
+ lon DOUBLE,
+ score INT,
+ PRIMARY KEY(idref)
+);
+CREATE INDEX FUEL_EXIST_index ON FUEL_EXIST (lat, lon);
+
+----
+CREATE TABLE FUEL (
+ gid INT,
+ idref VARCHAR(12) NOT NULL,
+ lat DOUBLE,
+ lon DOUBLE,
+ fixed INT,
+ area INT,
+ up INT,
+ fixed1 INT
+)
+
+// new data
+INSERT INTO FUEL (gid,lat,lon,fixed,idref,area,up,fixed1) VALUES(0,?,?,0,?,?,2,0)
+
+// read PostGIS
+INSERT INTO FUEL (gid,lat,lon,fixed,idref,area,up,fixed1) VALUES(?,?,?,?,?,?,0,0)
+
+----
+CREATE TABLE AREA_NODE (
+ idref VARCHAR(12) NOT NULL,
+ pid VARCHAR(12),
+ lat DOUBLE,
+ lon DOUBLE
+)
+
+----
\ No newline at end of file
diff --git a/doc/uml/HSQLDB_DUEL_UP.state.violet.html b/doc/uml/HSQLDB_DUEL_UP.state.violet.html
new file mode 100644
index 0000000..f089e72
--- /dev/null
+++ b/doc/uml/HSQLDB_DUEL_UP.state.violet.html
@@ -0,0 +1,725 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/doc/uml/busstop.activity.violet.html b/doc/uml/busstop.activity.violet.html
new file mode 100644
index 0000000..e16948d
--- /dev/null
+++ b/doc/uml/busstop.activity.violet.html
@@ -0,0 +1,1848 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/doc/uml/db.busstop.class.violet.html b/doc/uml/db.busstop.class.violet.html
new file mode 100644
index 0000000..d97d2b0
--- /dev/null
+++ b/doc/uml/db.busstop.class.violet.html
@@ -0,0 +1,1364 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/doc/uml/db.fuel.class.violet.html b/doc/uml/db.fuel.class.violet.html
new file mode 100644
index 0000000..80a9737
--- /dev/null
+++ b/doc/uml/db.fuel.class.violet.html
@@ -0,0 +1,1072 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/doc/uml/db.police.class.violet.html b/doc/uml/db.police.class.violet.html
new file mode 100644
index 0000000..5192442
--- /dev/null
+++ b/doc/uml/db.police.class.violet.html
@@ -0,0 +1,918 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/doc/uml/fuel.activity.violet.html b/doc/uml/fuel.activity.violet.html
new file mode 100644
index 0000000..ed4fc0e
--- /dev/null
+++ b/doc/uml/fuel.activity.violet.html
@@ -0,0 +1,2536 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/doc/uml/ksj_police.class.violet.html b/doc/uml/ksj_police.class.violet.html
new file mode 100644
index 0000000..b551130
--- /dev/null
+++ b/doc/uml/ksj_police.class.violet.html
@@ -0,0 +1,586 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/doc/uml/osmdb.class.violet.html b/doc/uml/osmdb.class.violet.html
new file mode 100644
index 0000000..1ba7f80
--- /dev/null
+++ b/doc/uml/osmdb.class.violet.html
@@ -0,0 +1,1634 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/doc/uml/police.activity.violet.html b/doc/uml/police.activity.violet.html
new file mode 100644
index 0000000..a01d0bc
--- /dev/null
+++ b/doc/uml/police.activity.violet.html
@@ -0,0 +1,1937 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/doc/uml/postoffice.activity.violet.html b/doc/uml/postoffice.activity.violet.html
new file mode 100644
index 0000000..365a59f
--- /dev/null
+++ b/doc/uml/postoffice.activity.violet.html
@@ -0,0 +1,2250 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/doc/uml/test.activity.violet.html b/doc/uml/test.activity.violet.html
new file mode 100644
index 0000000..80ba074
--- /dev/null
+++ b/doc/uml/test.activity.violet.html
@@ -0,0 +1,1224 @@
+
+
+
+
+
+
+
+
+ This file was generated with Violet UML Editor 2.1.0.
+ ( View Source / Download Violet )
+
+
+
+
+
+ 
+
+
\ No newline at end of file
diff --git a/src/HSQLDB_DUEL_UP.state.violet.html b/src/HSQLDB_DUEL_UP.state.violet.html
deleted file mode 100644
index f089e72..0000000
--- a/src/HSQLDB_DUEL_UP.state.violet.html
+++ /dev/null
@@ -1,725 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file
diff --git a/src/Nagoya_busstop.sql b/src/Nagoya_busstop.sql
deleted file mode 100644
index f31d20d..0000000
--- a/src/Nagoya_busstop.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-DROP TABLE nagoya_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);
-select count(*) from nagoya_busstop;
-select count(*) from nagoya_busstop where fixed=0;
-select count(*) from nagoya_busstop where fixed>=50 and fixed<100;
-select count(*) from nagoya_busstop where fixed>=100;
-
-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/busstop.activity.violet.html b/src/busstop.activity.violet.html
deleted file mode 100644
index e16948d..0000000
--- a/src/busstop.activity.violet.html
+++ /dev/null
@@ -1,1848 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file
diff --git a/src/create_busstop.sql b/src/create_busstop.sql
deleted file mode 100644
index 044efcf..0000000
--- a/src/create_busstop.sql
+++ /dev/null
@@ -1,74 +0,0 @@
--- DROP TABLE t_busstop;
-CREATE TABLE t_busstop (gid SERIAL PRIMARY KEY,name text,fixed integer,area integer,geom GEOMETRY(POINT, 4612));
-CREATE INDEX ix_busstop_geom ON t_busstop USING GiST (geom);
-
--- DROP VIEW public."V_14kanagawa_busstop";
-CREATE OR REPLACE VIEW public."V_14kanagawa_busstop" AS
- SELECT admarea.gid,
- (( SELECT fixed FROM t_busstop WHERE st_within(t_busstop.geom, admarea.geom)))::integer AS stncnt,
- admarea.geom,
- admarea.n03_004 AS name
- FROM admarea;
-
--- DROP VIEW public."V_busstop_0";
-CREATE OR REPLACE VIEW public."V_busstop_0" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE fixed=0;
-CREATE OR REPLACE VIEW public."V_busstop_1" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE fixed>0 AND fixed<50;
-CREATE OR REPLACE VIEW public."V_busstop_2" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE fixed>49;
-
--- DROP VIEW public."V_busstop_14";
-CREATE OR REPLACE VIEW public."V_busstop_01" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=1;
-CREATE OR REPLACE VIEW public."V_busstop_02" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=2;
-CREATE OR REPLACE VIEW public."V_busstop_03" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=3;
-CREATE OR REPLACE VIEW public."V_busstop_04" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=4;
-CREATE OR REPLACE VIEW public."V_busstop_05" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=5;
-CREATE OR REPLACE VIEW public."V_busstop_06" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=6;
-CREATE OR REPLACE VIEW public."V_busstop_07" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=7;
-CREATE OR REPLACE VIEW public."V_busstop_08" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=8;
-CREATE OR REPLACE VIEW public."V_busstop_09" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=9;
-CREATE OR REPLACE VIEW public."V_busstop_10" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=10;
-CREATE OR REPLACE VIEW public."V_busstop_11" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=11;
-CREATE OR REPLACE VIEW public."V_busstop_12" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=12;
-CREATE OR REPLACE VIEW public."V_busstop_13" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=13;
-CREATE OR REPLACE VIEW public."V_busstop_14" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=14;
-CREATE OR REPLACE VIEW public."V_busstop_15" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=15;
-CREATE OR REPLACE VIEW public."V_busstop_16" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=16;
-CREATE OR REPLACE VIEW public."V_busstop_17" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=17;
-CREATE OR REPLACE VIEW public."V_busstop_18" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=18;
-CREATE OR REPLACE VIEW public."V_busstop_19" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=19;
-CREATE OR REPLACE VIEW public."V_busstop_20" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=20;
-CREATE OR REPLACE VIEW public."V_busstop_21" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=21;
-CREATE OR REPLACE VIEW public."V_busstop_22" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=22;
-CREATE OR REPLACE VIEW public."V_busstop_23" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=23;
-CREATE OR REPLACE VIEW public."V_busstop_24" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=24;
-CREATE OR REPLACE VIEW public."V_busstop_25" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=25;
-CREATE OR REPLACE VIEW public."V_busstop_26" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=26;
-CREATE OR REPLACE VIEW public."V_busstop_27" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=27;
-CREATE OR REPLACE VIEW public."V_busstop_28" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=28;
-CREATE OR REPLACE VIEW public."V_busstop_29" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=29;
-CREATE OR REPLACE VIEW public."V_busstop_30" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=30;
-CREATE OR REPLACE VIEW public."V_busstop_31" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=31;
-CREATE OR REPLACE VIEW public."V_busstop_32" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=32;
-CREATE OR REPLACE VIEW public."V_busstop_33" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=33;
-CREATE OR REPLACE VIEW public."V_busstop_34" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=34;
-CREATE OR REPLACE VIEW public."V_busstop_35" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=35;
-CREATE OR REPLACE VIEW public."V_busstop_36" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=36;
-CREATE OR REPLACE VIEW public."V_busstop_37" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=37;
-CREATE OR REPLACE VIEW public."V_busstop_38" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=38;
-CREATE OR REPLACE VIEW public."V_busstop_39" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=39;
-CREATE OR REPLACE VIEW public."V_busstop_40" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=40;
-CREATE OR REPLACE VIEW public."V_busstop_41" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=41;
-CREATE OR REPLACE VIEW public."V_busstop_42" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=42;
-CREATE OR REPLACE VIEW public."V_busstop_43" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=43;
-CREATE OR REPLACE VIEW public."V_busstop_44" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=44;
-CREATE OR REPLACE VIEW public."V_busstop_45" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=45;
-CREATE OR REPLACE VIEW public."V_busstop_46" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=46;
-CREATE OR REPLACE VIEW public."V_busstop_47" AS SELECT gid,name,fixed,area,geom FROM t_busstop WHERE area=47;
-
-
-
--- ADMAREA
- SELECT t_busstop.gid, t_busstop.geom FROM t_busstop,admarea WHERE st_within(rail.c_geom, admarea.geom);
-
-
-ALTER TABLE public."V_kanagawa"
- OWNER TO yuu;
diff --git a/src/db.busstop.class.violet.html b/src/db.busstop.class.violet.html
deleted file mode 100644
index d97d2b0..0000000
--- a/src/db.busstop.class.violet.html
+++ /dev/null
@@ -1,1364 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file
diff --git a/src/db.fuel.class.violet.html b/src/db.fuel.class.violet.html
deleted file mode 100644
index 80a9737..0000000
--- a/src/db.fuel.class.violet.html
+++ /dev/null
@@ -1,1072 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file
diff --git a/src/db.police.class.violet.html b/src/db.police.class.violet.html
deleted file mode 100644
index 5192442..0000000
--- a/src/db.police.class.violet.html
+++ /dev/null
@@ -1,918 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file
diff --git a/src/fuel.activity.violet.html b/src/fuel.activity.violet.html
deleted file mode 100644
index ed4fc0e..0000000
--- a/src/fuel.activity.violet.html
+++ /dev/null
@@ -1,2536 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file
diff --git a/src/ksj_police.class.violet.html b/src/ksj_police.class.violet.html
deleted file mode 100644
index b551130..0000000
--- a/src/ksj_police.class.violet.html
+++ /dev/null
@@ -1,586 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file
diff --git a/src/osmdb.class.violet.html b/src/osmdb.class.violet.html
deleted file mode 100644
index 1ba7f80..0000000
--- a/src/osmdb.class.violet.html
+++ /dev/null
@@ -1,1634 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file
diff --git a/src/police.activity.violet.html b/src/police.activity.violet.html
deleted file mode 100644
index a01d0bc..0000000
--- a/src/police.activity.violet.html
+++ /dev/null
@@ -1,1937 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file
diff --git a/src/postoffice.activity.violet.html b/src/postoffice.activity.violet.html
deleted file mode 100644
index 365a59f..0000000
--- a/src/postoffice.activity.violet.html
+++ /dev/null
@@ -1,2250 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file
diff --git a/src/t_BUSSTOP.sql b/src/t_BUSSTOP.sql
deleted file mode 100644
index 7b1f5bb..0000000
--- a/src/t_BUSSTOP.sql
+++ /dev/null
@@ -1,66 +0,0 @@
----<< postgis: postgres >>---
-db_driver=org.postgresql.Driver
-db_url=jdbc:postgresql://surveyor.mydns.jp:5432/gisdb
-db_user=gisuser
-db_passwd=gisuser
--------------------------
-CREATE TABLE t_busstop (
- gid SERIAL PRIMARY KEY,
- gmlid text,
- name text,
- fixed integer,
- area integer,
- geom GEOMETRY(POINT, 4612)
-);
-CREATE INDEX ix_busstop_geom ON t_busstop USING GiST (geom);
-
-insert into t_busstop(osm_id,name,geom) select osm_id, st_transform(way,4612) FROM planet_osm_point WHERE (highway='bus_stop');
-insert into t_busstop(osm_id,name,geom) VALUES(884, 'なまえ', ST_GeomFromText('POINT(139.4110836 35.4341053)', 4612));
-
-----
-CREATE TABLE t_test (
- gid SERIAL PRIMARY KEY,
- osm_id bigint,
- name text,
- geom GEOMETRY(POINT, 4612)
-);
-
-CREATE INDEX ix_test_geom ON t_test USING GiST (geom);
-
-insert into t_test(osm_id,name,geom) VALUES(884, 'なまえ', ST_GeomFromText('POINT(139.4110836 35.4341053)', 4612));
-
-----
-GRANT SELECT ON t_BUSSTOP TO gisuser;
-
----<< database: hsqldb >>---
-CREATE TABLE bus_stop (
- gmlid VARCHAR(12) NOT NULL,
- name VARCHAR(128),
- lat DOUBLE,
- lon DOUBLE,
- fixed INT,
- fixed1 INT,
- area INT,
- ifile VARCHAR(128),
- up INT,
- CONSTRAINT bus_stop_pk PRIMARY KEY(gmlid,area));
-CREATE INDEX bus_stop_index ON bus_stop(lat,lon);
-SELECT gmlid,name,lat,lon,fixed1,area FROM bus_stop;
-
-CREATE TABLE OSM_EXIST (
- osmid VARCHAR(12) NOT NULL,
- name VARCHAR(128),
- lat DOUBLE,
- lon DOUBLE,
- score INT,
- CONSTRAINT existing_pk PRIMARY KEY(osmid, lat, lon));
-
-CREATE TABLE coverage (
- area INT,
- name VARCHAR(128),
- denominator BIGINT,
- lv1 BIGINT,
- lv2 BIGINT,
- lv3 BIGINT);
-
--------------------------
\ No newline at end of file
diff --git a/src/t_FUEL.sql b/src/t_FUEL.sql
deleted file mode 100644
index cf25ecc..0000000
--- a/src/t_FUEL.sql
+++ /dev/null
@@ -1,67 +0,0 @@
----<< postgis: postgres >>---
-db_driver=org.postgresql.Driver
-db_url=jdbc:postgresql://surveyor.mydns.jp:5432/gisdb
-db_user=gisuser
-db_passwd=gisuser
----<< osmdb: postgres >>---
-db_driver=org.postgresql.Driver
-db_url=jdbc:postgresql://localhost:5432/osmdb
-db_user=postgres
-db_passwd=*******
--------------------------
-DROP TABLE t_FUEL;
-CREATE TABLE t_FUEL (
- gid SERIAL PRIMARY KEY,
- idref text,
- gmlid text,
- area integer,
- fixed integer,
- geom GEOMETRY(POINT, 4612)
-);
-CREATE INDEX ix_t_FUEL_geom ON t_fuel USING GiST (geom);
-DELETE FROM t_FUEL;
-insert into t_FUEL (gmlid,fixed,area,geom) VALUES('n000001',0,0, ST_GeomFromText('POINT(136.9695284611471 35.10300377075564)', 4612));
-insert into t_FUEL (gmlid,fixed,area,geom) VALUES('n000002',0,0, ST_GeomFromText('POINT(136.969047121627 35.102834616747685)', 4612));
-insert into t_FUEL (gmlid,fixed,area,geom) VALUES('n000003',0,0, ST_GeomFromText('POINT(136.9743151095072 35.10462957171922)', 4612));
--------------------------
-GRANT SELECT ON t_fuel TO gisuser;
-
----<< database: hsqldb >>---
--------------------------
-
-CREATE TABLE FUEL_EXIST (
- idref VARCHAR(12) NOT NULL,
- lat DOUBLE,
- lon DOUBLE,
- score INT,
- PRIMARY KEY(idref)
-);
-CREATE INDEX FUEL_EXIST_index ON FUEL_EXIST (lat, lon);
-
-----
-CREATE TABLE FUEL (
- gid INT,
- idref VARCHAR(12) NOT NULL,
- lat DOUBLE,
- lon DOUBLE,
- fixed INT,
- area INT,
- up INT,
- fixed1 INT
-)
-
-// new data
-INSERT INTO FUEL (gid,lat,lon,fixed,idref,area,up,fixed1) VALUES(0,?,?,0,?,?,2,0)
-
-// read PostGIS
-INSERT INTO FUEL (gid,lat,lon,fixed,idref,area,up,fixed1) VALUES(?,?,?,?,?,?,0,0)
-
-----
-CREATE TABLE AREA_NODE (
- idref VARCHAR(12) NOT NULL,
- pid VARCHAR(12),
- lat DOUBLE,
- lon DOUBLE
-)
-
-----
\ No newline at end of file
diff --git a/src/test.activity.violet.html b/src/test.activity.violet.html
deleted file mode 100644
index 80ba074..0000000
--- a/src/test.activity.violet.html
+++ /dev/null
@@ -1,1224 +0,0 @@
-
-
-
-
-
-
-
-
- This file was generated with Violet UML Editor 2.1.0.
- ( View Source / Download Violet )
-
-
-
-
-
- 
-
-
\ No newline at end of file