diff --git a/database/db.log b/database/db.log new file mode 100644 index 0000000..10ad0d5 --- /dev/null +++ b/database/db.log @@ -0,0 +1,2 @@ +/*C2*/SET SCHEMA PUBLIC +DISCONNECT diff --git a/database/db.properties b/database/db.properties new file mode 100644 index 0000000..83afbb4 --- /dev/null +++ b/database/db.properties @@ -0,0 +1,4 @@ +#HSQL Database Engine 2.2.9 +#Thu Oct 05 22:18:09 JST 2017 +version=2.2.9 +modified=yes diff --git a/database/db.script b/database/db.script new file mode 100644 index 0000000..0a7bb42 --- /dev/null +++ b/database/db.script @@ -0,0 +1,47 @@ +SET DATABASE UNIQUE NAME HSQLDB5EECAFAD30 +SET DATABASE GC 0 +SET DATABASE DEFAULT RESULT MEMORY ROWS 0 +SET DATABASE EVENT LOG LEVEL 0 +SET DATABASE SQL NAMES FALSE +SET DATABASE SQL REGULAR NAMES TRUE +SET DATABASE SQL REFERENCES FALSE +SET DATABASE SQL SIZE TRUE +SET DATABASE SQL TYPES FALSE +SET DATABASE SQL TDC DELETE TRUE +SET DATABASE SQL TDC UPDATE TRUE +SET DATABASE SQL TRANSLATE TTI TYPES TRUE +SET DATABASE SQL CONCAT NULLS TRUE +SET DATABASE SQL NULLS FIRST TRUE +SET DATABASE SQL UNIQUE NULLS TRUE +SET DATABASE SQL CONVERT TRUNCATE TRUE +SET DATABASE SQL AVG SCALE 0 +SET DATABASE SQL DOUBLE NAN TRUE +SET DATABASE SQL LONGVAR IS LOB FALSE +SET DATABASE TRANSACTION CONTROL LOCKS +SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED +SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE +SET DATABASE TEXT TABLE DEFAULTS '' +SET FILES WRITE DELAY 500 MILLIS +SET FILES BACKUP INCREMENT TRUE +SET FILES CACHE SIZE 10000 +SET FILES CACHE ROWS 50000 +SET FILES SCALE 32 +SET FILES LOB SCALE 32 +SET FILES DEFRAG 0 +SET FILES NIO TRUE +SET FILES NIO SIZE 256 +SET FILES LOG TRUE +SET FILES LOG SIZE 50 +CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e' +ALTER USER SA SET LOCAL TRUE +CREATE SCHEMA PUBLIC AUTHORIZATION DBA +ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1 +SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC +GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC +GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC +GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC +GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC +GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC +GRANT DBA TO SA +SET SCHEMA SYSTEM_LOBS +INSERT INTO BLOCKS VALUES(0,2147483647,0) diff --git a/doc/busstop_00_All.qgs b/doc/busstop_00_All.qgs deleted file mode 100644 index 46253ad..0000000 --- a/doc/busstop_00_All.qgs +++ /dev/null @@ -1,11607 +0,0 @@ - - - OSM Coverage (bus_stop) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - meters - - 14106221.40676597505807877 - 3189930.56895224004983902 - 16155216.3372473306953907 - 5921719.24690994061529636 - - 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 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - OCM_Public_Transport20170108140434633 - V_busstop_0120170129215450074 - V_busstop_0320170129220705233 - V_busstop_0420170129221136114 - V_busstop_0520170129225952768 - V_busstop_0620170129230448033 - V_busstop_0720170129230743568 - V_busstop_0820170129230949555 - V_busstop_1020170129231039324 - V_busstop_1120170129231039940 - V_busstop_1220170129231040532 - V_busstop_1320170129231041031 - V_busstop_1420170129231041540 - V_busstop_1520170129231041904 - V_busstop_1620170129231042455 - V_busstop_1720170129231043072 - V_busstop_0920170129231043638 - V_busstop_1820170129233153890 - V_busstop_1920170129233154403 - V_busstop_2020170129233154937 - V_busstop_2120170129233155587 - V_busstop_2220170129233156103 - V_busstop_2320170129233156765 - V_busstop_2420170129233157292 - V_busstop_2520170129233157823 - V_busstop_2620170129233158290 - V_busstop_2720170129233158679 - V_busstop_2820170129233159135 - V_busstop_2920170129233159776 - V_busstop_3020170129233200170 - V_busstop_3120170129233200798 - V_busstop_3220170129233201206 - V_busstop_3320170129233201772 - V_busstop_3420170129233202349 - V_busstop_3520170129233202769 - V_busstop_3620170129233203252 - V_busstop_3920170129233203878 - V_busstop_4020170129233204419 - V_busstop_4120170129233204795 - V_busstop_4220170129233205173 - V_busstop_4320170129233205558 - V_busstop_4420170129233205967 - V_busstop_4620170129233206402 - V_busstop_4520170129233206879 - V_busstop_4720170129233207503 - V_busstop_3820170129233208039 - V_busstop_3720170129233208630 - V_busstop_0220170204102951027518408066 - t_busstop20170204105138137 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -20037508.33999999985098839 - -20037508.33999999985098839 - 20037508.33999999985098839 - 20037508.33999999985098839 - - OCM_Public_Transport20170108140434633 - <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 - - - - 139.41110838000000172 - 41.40978340000000202 - 145.81152428999999415 - 45.5222492299999999 - - V_busstop_0120170129215450074 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_01" (geom) sql= - - - - busstop_01北海道 - - - +proj=longlat +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +no_defs - 3465 - 4612 - EPSG:4612 - JGD2000 - longlat - GRS80 - true - - - postgres - COALESCE( "name", '<NULL>' ) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 0 - 0 - 0 - name - - - - . - - - - - - - - - - - - - - . - - 0 - . - - 0 - generatedlayout - - - - - - - - - 139.86229506000000811 - 40.25746269999999782 - 141.67989944000001401 - 41.54578668999999991 - - V_busstop_0220170204102951027518408066 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_02" (geom) sql= - - - - busstop_02青森県 - - - +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 - - - - - - - - V_busstop_0320170129220705233 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_03" (geom) sql= - - - - busstop_03岩手県 - - - +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 - - - - - - - - - 140.29717371999998932 - 37.79541712999999703 - 141.67182052999999087 - 38.97502453999999972 - - V_busstop_0420170129221136114 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_04" (geom) sql= - - - - busstop_04宮城県 - - - +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.70115709000000948 - 38.95556186999999682 - 140.89332122999999797 - 40.43573222999999928 - - V_busstop_0520170129225952768 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_05" (geom) sql= - - - - busstop_05秋田県 - - - +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.54824719999999161 - 37.77597365999999823 - 140.61607491000000891 - 39.10763379000000128 - - V_busstop_0620170129230448033 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_06" (geom) sql= - - - - busstop_06山形県 - - - +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.25175060000000826 - 36.79969708000000139 - 141.03512534000000755 - 37.92249547000000121 - - V_busstop_0720170129230743568 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_07" (geom) sql= - - - - busstop_07福島県 - - - +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.69517784999999321 - 35.74222675000000038 - 140.83968301999999539 - 36.86029898999999688 - - V_busstop_0820170129230949555 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_08" (geom) sql= - - - - busstop_08茨城県 - - - +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.37031028000001243 - 36.21134875999999991 - 140.25626435000000924 - 37.12754297000000037 - - V_busstop_0920170129231043638 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_09" (geom) sql= - - - - busstop_09栃木県 - - - +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 - - - - - - - - - 138.46049511999999027 - 36.07907708999999841 - 139.65031812000000855 - 36.89014678000000202 - - V_busstop_1020170129231039324 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_10" (geom) sql= - - - - busstop_10群馬県 - - - +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 - - - - - - - - - 138.80109727000001385 - 35.75429027999999931 - 139.89019751000000724 - 36.27153790999999927 - - V_busstop_1120170129231039940 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_11" (geom) sql= - - - - busstop_11埼玉県 - - - +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 - - - - - - - - V_busstop_1220170129231040532 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_12" (geom) sql= - - - - busstop_12千葉県 - - - +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 - - - - - - - - - 138.9876005300000088 - 27.06010979999999932 - 142.20828976999999327 - 35.84825785999999681 - - V_busstop_1320170129231041031 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_13" (geom) sql= - - - - busstop_13東京都 - - - +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 - - - - - - - - - 138.99104897999998798 - 35.1349755299999984 - 139.78637763000000405 - 35.65203447999999753 - - V_busstop_1420170129231041540 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_14" (geom) sql= - - - - busstop_14神奈川県 - - - +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 - - - - - - - - - 137.63908967000000416 - 36.78297215999999992 - 139.67309055999999146 - 38.52235715999999854 - - V_busstop_1520170129231041904 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_15" (geom) sql= - - - - busstop_15新潟県 - - - +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 - - - - - - - - - 136.78745545999998967 - 36.35236889000000104 - 137.65631131000000664 - 36.97671185000000094 - - V_busstop_1620170129231042455 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_16" (geom) sql= - - - - busstop_16富山県 - - - +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 - - - - - - - - - 136.25174881000000937 - 36.11413809999999813 - 137.36014222000000018 - 37.52886540000000082 - - V_busstop_1720170129231043072 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_17" (geom) sql= - - - - busstop_17石川県 - - - +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 - - - - - - - - - 135.45650385999999799 - 35.40321902000000165 - 136.70502577999999971 - 36.28872939000000031 - - V_busstop_1820170129233153890 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_18" (geom) sql= - - - - busstop_18福井県 - - - +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 - - - - - - - - - 138.25013122999999382 - 35.18607944000000032 - 139.1175451500000122 - 35.93938024999999925 - - V_busstop_1920170129233154403 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_19" (geom) sql= - - - - busstop_19山梨県 - - - +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 - - - - - - - - - 137.50190000000000623 - 35.23182299999999856 - 138.66850999999999772 - 36.98906999999999812 - - V_busstop_2020170129233154937 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_20" (geom) sql= - - - - busstop_20長野県 - - - +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 - - - - - - - - - 136.36269999999998959 - 35.14900200000000297 - 137.58389700000000744 - 36.45694111000000248 - - V_busstop_2120170129233155587 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_21" (geom) sql= - - - - busstop_21岐阜県 - - - +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 - - - - - - - - - 137.48499599999999532 - 34.59997299999999854 - 139.13969900000000735 - 35.42816200000000038 - - V_busstop_2220170129233156103 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_22" (geom) sql= - - - - busstop_22静岡県 - - - +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 - - - - - - - - - 136.6743460000000141 - 34.58251700000000284 - 137.8149840000000097 - 35.41753800000000041 - - V_busstop_2320170129233156765 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_23" (geom) sql= - - - - busstop_23愛知県 - - - +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 - - - - - - - - - 135.89854700000000776 - 33.72513599999999911 - 136.92288999999999533 - 35.16201999999999828 - - V_busstop_2420170129233157292 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_24" (geom) sql= - - - - busstop_24三重県 - - - +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 - - - - - - - - - 135.79227581000000669 - 34.80630242000000152 - 136.42800740000001269 - 35.66540713999999923 - - V_busstop_2520170129233157823 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_25" (geom) sql= - - - - busstop_25滋賀県 - - - +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 - - - - - - - - - 134.87735420999999292 - 34.7106414799999996 - 135.95884918999999513 - 35.76914081000000323 - - V_busstop_2620170129233158290 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_26" (geom) sql= - - - - busstop_26京都府 - - - +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 - - - - - - - - - 135.09444056000000955 - 34.27887805999999671 - 135.74459805999998707 - 35.00464000000000198 - - V_busstop_2720170129233158679 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_27" (geom) sql= - - - - busstop_27大阪府 - - - +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 - - - - - - - - - 134.30803374000001327 - 34.19589082000000246 - 135.46820632000000728 - 35.66493228000000215 - - V_busstop_2820170129233159135 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_28" (geom) sql= - - - - busstop_28兵庫県 - - - +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 - - - - - - - - - 135.63247739999999908 - 33.87854939000000343 - 136.21554800000001251 - 34.77197324000000123 - - V_busstop_2920170129233159776 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_29" (geom) sql= - - - - busstop_29奈良県 - - - +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 - - - - - - - - - 135.06742087999998603 - 33.4379206699999969 - 136.00478762000000188 - 34.37595123999999913 - - V_busstop_3020170129233200170 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_30" (geom) sql= - - - - busstop_30和歌山県 - - - +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 - - - - - - - - - 133.16610582999999224 - 35.08929528000000175 - 134.4898958299999947 - 35.60211333000000167 - - V_busstop_3120170129233200798 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_31" (geom) sql= - - - - busstop_31鳥取県 - - - +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 - - - - - - - - - 131.68980555999999638 - 34.32289972000000233 - 133.37312385000001314 - 36.33018468000000212 - - V_busstop_3220170129233201206 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_32" (geom) sql= - - - - busstop_32島根県 - - - +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 - - - - - - - - - 133.29444943999999396 - 34.43087778000000299 - 134.3877338899999927 - 35.29788125000000321 - - V_busstop_3320170129233201772 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_33" (geom) sql= - - - - busstop_33岡山県 - - - +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 - - - - - - - - - 132.07826916999999867 - 34.05273556000000212 - 133.45431528000000299 - 35.09171288999999661 - - V_busstop_3420170129233202349 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_34" (geom) sql= - - - - busstop_34広島県 - - - +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 - - - - - - - - - 130.84517805999999496 - 33.79255497999999847 - 132.43947083000000475 - 34.65528083000000237 - - V_busstop_3520170129233202769 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_35" (geom) sql= - - - - busstop_35山口県 - - - +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 - - - - - - - - - 133.69013032000000862 - 33.54718426000000164 - 134.6977639300000078 - 34.23715528999999691 - - V_busstop_3620170129233203252 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_36" (geom) sql= - - - - busstop_36徳島県 - - - +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 - - - - - - - - - 133.53352115000001277 - 34.03129457000000002 - 134.43179840999999897 - 34.56093144999999822 - - V_busstop_3720170129233208630 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_37" (geom) sql= - - - - busstop_37香川県 - - - +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 - - - - - - - - - 132.12003108999999768 - 32.91096961000000221 - 133.68765089999999418 - 34.28769584999999864 - - V_busstop_3820170129233208039 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_38" (geom) sql= - - - - busstop_38愛媛県 - - - +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 - - - - - - - - - 132.62798649000001205 - 32.72423598999999683 - 134.30480862999999658 - 33.82214788000000283 - - V_busstop_3920170129233203878 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_39" (geom) sql= - - - - busstop_39高知県 - - - +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 - - - - - - - - - 130.11069983999999522 - 33.00368463000000219 - 131.18778297000000066 - 33.96256352999999706 - - V_busstop_4020170129233204419 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_40" (geom) sql= - - - - busstop_40福岡県 - - - +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 - - - - - - - - - 129.76786003000000846 - 32.95410763000000287 - 130.54085810000000833 - 33.55826944999999739 - - V_busstop_4120170129233204795 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_41" (geom) sql= - - - - busstop_41佐賀県 - - - +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 - - - - - - - - - 128.612533180000014 - 32.56488921999999775 - 130.37364156999998954 - 34.69533950999999661 - - V_busstop_4220170129233205173 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_42" (geom) sql= - - - - busstop_42長崎県 - - - +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 - - - - - - - - - 129.97876841999999442 - 32.12306544999999858 - 131.28377947000001313 - 33.18367948000000212 - - V_busstop_4320170129233205558 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_43" (geom) sql= - - - - busstop_43熊本県 - - - +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 - - - - - - - - - 130.86243763999999601 - 32.74942441999999687 - 132.07554490999999075 - 33.68632622999999882 - - V_busstop_4420170129233205967 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_44" (geom) sql= - - - - busstop_44大分県 - - - +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 - - - - - - - - - 130.76603635000000736 - 31.36626628000000139 - 131.83930517999999665 - 32.81762049999999675 - - V_busstop_4520170129233206879 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_45" (geom) sql= - - - - busstop_45宮崎県 - - - +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 - - - - - - - - - 128.41017185000001177 - 27.0307842100000002 - 131.13289409999998725 - 32.30013135000000091 - - V_busstop_4620170129233206402 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_46" (geom) sql= - - - - busstop_46鹿児島県 - - - +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 - - - - - - - - - 123.74760050000000433 - 24.25930049999999838 - 128.31910049999999046 - 26.87180048000000099 - - V_busstop_4720170129233207503 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."V_busstop_47" (geom) sql= - - - - busstop_47沖縄県 - - - +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 - - - - - - - - - 128.32888793945301131 - 26.93836784362790127 - 145.8588256835940058 - 45.60627365112299714 - - t_busstop20170204105138137 - dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."t_busstop" (geom) sql= - osmCoverage_busstop_00 - OSM Coverage_busstop_00日本全体 - 国土数値情報（バス停データ）を指標としてOSMのカバレッジ（網羅率）地域を表現したもの - - OpenStreetMap Coverage bus_stop 国土数値情報（バス停データ） - - http://surveyor.mydns.jp/owncloud/index.php/s/I3I5DpaeFLLotdr - 国土交通省国土政策局「国土数値情報（バス停データ）」をもとにhayashiが編集・加工 - busstop_00日本全体 - - - +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 - - - - - - - - - - Ubuntu - 11 - 0 - 0 - true - 3 - MM - - #1d34c9 - - - - - - - - false - - - - - - - false - - - - - - 2 - true - MU - - - false - - - - false - - NONE - - 8 - false - - - - - - - 44 - 255 - 255 - 51 - 255 - 160 - 255 - - - 2 - - V_busstop_0120170129215450074 - V_busstop_0320170129220705233 - V_busstop_0420170129221136114 - V_busstop_0520170129225952768 - V_busstop_0620170129230448033 - V_busstop_0720170129230743568 - V_busstop_0820170129230949555 - V_busstop_0920170129231043638 - V_busstop_1020170129231039324 - V_busstop_1120170129231039940 - V_busstop_1220170129231040532 - V_busstop_1320170129231041031 - V_busstop_1420170129231041540 - V_busstop_1520170129231041904 - V_busstop_1620170129231042455 - V_busstop_1720170129231043072 - V_busstop_1820170129233153890 - V_busstop_1920170129233154403 - V_busstop_2020170129233154937 - V_busstop_2120170129233155587 - V_busstop_2220170129233156103 - V_busstop_2320170129233156765 - V_busstop_2420170129233157292 - V_busstop_2520170129233157823 - V_busstop_2620170129233158290 - V_busstop_2720170129233158679 - V_busstop_2820170129233159135 - V_busstop_2920170129233159776 - V_busstop_3020170129233200170 - V_busstop_3120170129233200798 - V_busstop_3220170129233201206 - V_busstop_3320170129233201772 - V_busstop_3420170129233202349 - V_busstop_3520170129233202769 - V_busstop_3620170129233203252 - V_busstop_3720170129233208630 - V_busstop_3820170129233208039 - V_busstop_3920170129233203878 - V_busstop_4020170129233204419 - V_busstop_4120170129233204795 - V_busstop_4220170129233205173 - V_busstop_4320170129233205558 - V_busstop_4420170129233205967 - V_busstop_4520170129233206879 - V_busstop_4620170129233206402 - V_busstop_4720170129233207503 - - - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - disabled - - current_layer - - - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - 2 - - - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - to_vertex_and_segment - - off - 0 - - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - 0.000000 - - - - - - - - - None - - - false - - - +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 - EPSG:3857 - 3857 - 1 - - - - - - true - 255 - - - conditions unknown - 90 - - meters - m2 - - - - - diff --git a/doc/busstop_All.qgs b/doc/busstop_All.qgs new file mode 100644 index 0000000..3a699e7 --- /dev/null +++ b/doc/busstop_All.qgs @@ -0,0 +1,976 @@ + + + OSM Coverage (bus_stop) + + + + + + + + + + + + + + + + + + + + + meters + + 15520612.16867611184716225 + 4222971.06070292182266712 + 15521112.41157906129956245 + 4223638.00129812397062778 + + 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 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + OCM_Public_Transport20170108140434633 + t_busstop20170204105138137 + + + + + + + + + + + + + + + -20037508.33999999985098839 + -20037508.33999999985098839 + 20037508.33999999985098839 + 20037508.33999999985098839 + + OCM_Public_Transport20170108140434633 + <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 + + + + 128.32888793945301131 + 26.93836784362790127 + 145.8588256835940058 + 45.60627365112299714 + + t_busstop20170204105138137 + dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."t_busstop" (geom) sql= + osmCoverage_busstop_00 + OSM Coverage_busstop_00日本全体 + 国土数値情報（バス停データ）を指標としてOSMのカバレッジ（網羅率）地域を表現したもの + + OpenStreetMap Coverage bus_stop 国土数値情報（バス停データ） + + http://surveyor.mydns.jp/owncloud/index.php/s/I3I5DpaeFLLotdr + 国土交通省国土政策局「国土数値情報（バス停データ）」をもとにhayashiが編集・加工 + busstop_00日本全体 + + + +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 + + + + + + + + + + + + + + + + + + + + + + + Ubuntu + 11 + 0 + 0 + true + 3 + MM + + #1d34c9 + + + false + + + + + + + false + + + + + + 2 + true + MU + + + + false + + + false + + NONE + + 8 + false + + + + + + + 44 + 255 + 255 + 51 + 255 + 160 + 255 + + + 2 + + V_busstop_0120170129215450074 + V_busstop_0320170129220705233 + V_busstop_0420170129221136114 + V_busstop_0520170129225952768 + V_busstop_0620170129230448033 + V_busstop_0720170129230743568 + V_busstop_0820170129230949555 + V_busstop_0920170129231043638 + V_busstop_1020170129231039324 + V_busstop_1120170129231039940 + V_busstop_1220170129231040532 + V_busstop_1320170129231041031 + V_busstop_1420170129231041540 + V_busstop_1520170129231041904 + V_busstop_1620170129231042455 + V_busstop_1720170129231043072 + V_busstop_1820170129233153890 + V_busstop_1920170129233154403 + V_busstop_2020170129233154937 + V_busstop_2120170129233155587 + V_busstop_2220170129233156103 + V_busstop_2320170129233156765 + V_busstop_2420170129233157292 + V_busstop_2520170129233157823 + V_busstop_2620170129233158290 + V_busstop_2720170129233158679 + V_busstop_2820170129233159135 + V_busstop_2920170129233159776 + V_busstop_3020170129233200170 + V_busstop_3120170129233200798 + V_busstop_3220170129233201206 + V_busstop_3320170129233201772 + V_busstop_3420170129233202349 + V_busstop_3520170129233202769 + V_busstop_3620170129233203252 + V_busstop_3720170129233208630 + V_busstop_3820170129233208039 + V_busstop_3920170129233203878 + V_busstop_4020170129233204419 + V_busstop_4120170129233204795 + V_busstop_4220170129233205173 + V_busstop_4320170129233205558 + V_busstop_4420170129233205967 + V_busstop_4520170129233206879 + V_busstop_4620170129233206402 + V_busstop_4720170129233207503 + + + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + + current_layer + + + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + + + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + + off + 0 + + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + + + + + + + + + None + + + false + + + +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 + EPSG:3857 + 3857 + 1 + + + + + + true + 255 + + + conditions unknown + 90 + + meters + m2 + + + + + diff --git a/doc/busstop_All.qgs~ b/doc/busstop_All.qgs~ new file mode 100644 index 0000000..72ba6e4 --- /dev/null +++ b/doc/busstop_All.qgs~ @@ -0,0 +1,976 @@ + + + OSM Coverage (bus_stop) + + + + + + + + + + + + + + + + + + + + + meters + + 15520380.05148953199386597 + 4222684.55805287044495344 + 15521380.53729543089866638 + 4224018.43924327474087477 + + 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 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + OCM_Public_Transport20170108140434633 + t_busstop20170204105138137 + + + + + + + + + + + + + + + -20037508.33999999985098839 + -20037508.33999999985098839 + 20037508.33999999985098839 + 20037508.33999999985098839 + + OCM_Public_Transport20170108140434633 + <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 + + + + 128.32888793945301131 + 26.93836784362790127 + 145.8588256835940058 + 45.60627365112299714 + + t_busstop20170204105138137 + dbname='gisdb' host=surveyor.mydns.jp port=5432 user='gisuser' password='gisuser' sslmode=disable key='gid' srid=4612 type=Point table="public"."t_busstop" (geom) sql= + osmCoverage_busstop_00 + OSM Coverage_busstop_00日本全体 + 国土数値情報（バス停データ）を指標としてOSMのカバレッジ（網羅率）地域を表現したもの + + OpenStreetMap Coverage bus_stop 国土数値情報（バス停データ） + + http://surveyor.mydns.jp/owncloud/index.php/s/I3I5DpaeFLLotdr + 国土交通省国土政策局「国土数値情報（バス停データ）」をもとにhayashiが編集・加工 + busstop_00日本全体 + + + +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 + + + + + + + + + + + + + + + + + + + + + + + Ubuntu + 11 + 0 + 0 + true + 3 + MM + + #1d34c9 + + + false + + + + + + + false + + + + + + 2 + true + MU + + + + false + + + false + + NONE + + 8 + false + + + + + + + 44 + 255 + 255 + 51 + 255 + 160 + 255 + + + 2 + + V_busstop_0120170129215450074 + V_busstop_0320170129220705233 + V_busstop_0420170129221136114 + V_busstop_0520170129225952768 + V_busstop_0620170129230448033 + V_busstop_0720170129230743568 + V_busstop_0820170129230949555 + V_busstop_0920170129231043638 + V_busstop_1020170129231039324 + V_busstop_1120170129231039940 + V_busstop_1220170129231040532 + V_busstop_1320170129231041031 + V_busstop_1420170129231041540 + V_busstop_1520170129231041904 + V_busstop_1620170129231042455 + V_busstop_1720170129231043072 + V_busstop_1820170129233153890 + V_busstop_1920170129233154403 + V_busstop_2020170129233154937 + V_busstop_2120170129233155587 + V_busstop_2220170129233156103 + V_busstop_2320170129233156765 + V_busstop_2420170129233157292 + V_busstop_2520170129233157823 + V_busstop_2620170129233158290 + V_busstop_2720170129233158679 + V_busstop_2820170129233159135 + V_busstop_2920170129233159776 + V_busstop_3020170129233200170 + V_busstop_3120170129233200798 + V_busstop_3220170129233201206 + V_busstop_3320170129233201772 + V_busstop_3420170129233202349 + V_busstop_3520170129233202769 + V_busstop_3620170129233203252 + V_busstop_3720170129233208630 + V_busstop_3820170129233208039 + V_busstop_3920170129233203878 + V_busstop_4020170129233204419 + V_busstop_4120170129233204795 + V_busstop_4220170129233205173 + V_busstop_4320170129233205558 + V_busstop_4420170129233205967 + V_busstop_4520170129233206879 + V_busstop_4620170129233206402 + V_busstop_4720170129233207503 + + + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + disabled + + current_layer + + + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + + + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + to_vertex_and_segment + + off + 0 + + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + 0.000000 + + + + + + + + + None + + + false + + + +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 + EPSG:3857 + 3857 + 1 + + + + + + true + 255 + + + conditions unknown + 90 + + meters + m2 + + + + + diff --git a/nbproject/project.properties b/nbproject/project.properties index e0da09d..8b162f9 100644 --- a/nbproject/project.properties +++ b/nbproject/project.properties @@ -64,7 +64,7 @@ javadoc.use=true javadoc.version=false javadoc.windowtitle= -main.class= +main.class=osm.jp.coverage.test.Test manifest.file=manifest.mf meta.inf.dir=${src.dir}/META-INF mkdist.disabled=false diff --git a/src/Do_to_cartoCSV.bat b/src/Do_to_cartoCSV.bat deleted file mode 100644 index e412b33..0000000 --- a/src/Do_to_cartoCSV.bat +++ /dev/null @@ -1 +0,0 @@ -java -cp .;osmCoverage.jar;hayashi_0225.jar;hsqldb_2.2.9.jar;postgresql-9.4.1212.jar osm.jp.coverage.busstop.ToCartoCSV diff --git a/src/Do_to_cartoCSV.sh b/src/Do_to_cartoCSV.sh deleted file mode 100755 index 8ae786f..0000000 --- a/src/Do_to_cartoCSV.sh +++ /dev/null @@ -1 +0,0 @@ -java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.busstop.ToCartoCSV diff --git a/src/Do_update.sh b/src/Do_update.sh deleted file mode 100755 index fde0113..0000000 --- a/src/Do_update.sh +++ /dev/null @@ -1 +0,0 @@ -java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar osm.jp.postgis.Do_sqlfiles -update diff --git a/src/coverageGML_FUEL.sh b/src/coverageGML_FUEL.sh deleted file mode 100755 index d246691..0000000 --- a/src/coverageGML_FUEL.sh +++ /dev/null @@ -1,15 +0,0 @@ -cp ../osmCoverage/dist/osmCoverage.jar . -rm -r database -mkdir database -java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.DbFuel -java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.DbExist -java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.Fuel -java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.ToPostgis -java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.ToCartoCSV -java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.Coverage coverage.fuel.csv -java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.Coverage coverage.fuel.json -git commit -a -m "coverage fuel update $(date +%Y-%m-%d_%H:%M)" -cp coverage.fuel.json ../www-root/coverage -cd ../www-root -git add . -git commit -a -m "coverage fuel update $(date +%Y-%m-%d_%H:%M)" diff --git a/src/coverage_BUSSTOP.sh b/src/coverage_BUSSTOP.sh new file mode 100755 index 0000000..93f6281 --- /dev/null +++ b/src/coverage_BUSSTOP.sh @@ -0,0 +1,19 @@ +cp ../osmCoverage/dist/osmCoverage.jar . +rm -r database +mkdir database + +rm */update.sql +#java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.DbBusstop -drop +java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.DbBusstop +#java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.DbExistBusstop -drop +java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.DbExistBusstop +java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.Busstop +java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.ToPostgis +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.busstop.Coverage coverage.busstop.csv +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.busstop.Coverage coverage.busstop.json +git commit -a -m "coverage update BUSSTOP $(date +%Y-%m-%d_%H:%M)" + +cp coverage.busstop.json ../www-root/coverage +cd ../www-root +git add . +git commit -a -m "coverage busstop update $(date +%Y-%m-%d_%H:%M)" diff --git a/src/coverage_FUEL.sh b/src/coverage_FUEL.sh new file mode 100755 index 0000000..d246691 --- /dev/null +++ b/src/coverage_FUEL.sh @@ -0,0 +1,15 @@ +cp ../osmCoverage/dist/osmCoverage.jar . +rm -r database +mkdir database +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.DbFuel +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.DbExist +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.Fuel +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.ToPostgis +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.ToCartoCSV +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.Coverage coverage.fuel.csv +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.Coverage coverage.fuel.json +git commit -a -m "coverage fuel update $(date +%Y-%m-%d_%H:%M)" +cp coverage.fuel.json ../www-root/coverage +cd ../www-root +git add . +git commit -a -m "coverage fuel update $(date +%Y-%m-%d_%H:%M)" diff --git a/src/coverage_TEST.sh b/src/coverage_TEST.sh new file mode 100644 index 0000000..c842a77 --- /dev/null +++ b/src/coverage_TEST.sh @@ -0,0 +1,20 @@ +cp ../osmCoverage/dist/osmCoverage.jar . +rm -r database +mkdir database + +rm */update.sql +#java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.test.DbTest -drop +java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.test.DbTest +#java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.test.DbExistTest -drop +java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.test.DbExistTest +java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.test.Test +java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.ToPostgis + +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.busstop.Coverage coverage.busstop.csv +java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.busstop.Coverage coverage.busstop.json +git commit -a -m "coverage update BUSSTOP $(date +%Y-%m-%d_%H:%M)" + +cp coverage.busstop.json ../www-root/coverage +cd ../www-root +git add . +git commit -a -m "coverage busstop update $(date +%Y-%m-%d_%H:%M)" diff --git a/src/coverage_busstop_update.sh b/src/coverage_busstop_update.sh deleted file mode 100755 index a9cc9f2..0000000 --- a/src/coverage_busstop_update.sh +++ /dev/null @@ -1,18 +0,0 @@ -cp ../osmCoverage/dist/osmCoverage.jar . -rm -r database -mkdir database - -rm */update.sql -#java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.DbBusstop -drop -java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.DbBusstop - -#java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.DbExistBusstop -drop -java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.DbExistBusstop - -java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.Busstop - -java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.ToPostgis - -java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar osm.jp.postgis.Do_sqlfiles -update -java -cp .:osmCoverage.jar:hayashi_0225.jar:postgresql-9.4.1212.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.Coverage coverage.csv -git commit -a -m "coverage update $(date +%Y-%m-%d_%H:%M)" diff --git a/src/osm/jp/api/Japan.java b/src/osm/jp/api/Japan.java index d226c6e..b4a1497 100644 --- a/src/osm/jp/api/Japan.java +++ b/src/osm/jp/api/Japan.java @@ -7,6 +7,38 @@ public double maxLon; public static String[] areaArgs = {"全国","北海道","青森県","岩手県","宮城県","秋田県","山形県","福島県","茨城県","栃木県","群馬県","埼玉県","千葉県","東京都","神奈川県","新潟県","富山県","石川県","福井県","山梨県","長野県","岐阜県","静岡県","愛知県","三重県","滋賀県","京都府","大阪府","兵庫県","奈良県","和歌山県","鳥取県","島根県","岡山県","広島県","山口県","徳島県","香川県","愛媛県","高知県","福岡県","佐賀県","長崎県","熊本県","大分県","宮崎県","鹿児島県","沖縄県"}; + public static final double ONE_KM_LAT = 0.009013372D; // 1km距離を表す緯度（差分） + public static final double ONE_KM_LON = 0.010966404D; // 1km距離を表す経度（差分） + static final double BIG_Y = (40000.0d / 2.0d / Math.PI); // 地球の半径(km) + static final double LAT1KM = (10000.0d / 90.0d); // 緯度１度の距離（km） + static final double KM_LAT = (90.0d / 10000.0d); // 1km距離を表す緯度数 + + /** + * 二点間の距離を取得する(単位:km) + * + * @param lat1 + * @param lon1 + * @param lat2 + * @param lon2 + * @return + */ + public static double distanceKm(double lat1, double lon1, double lat2, double lon2) { + double lat = (lat1 + lat2) / 2; + double y = Math.cos(Math.toRadians(lat)) * BIG_Y; // 緯線上の地球の半径(km) + double LON1KM = (y * 2.0d * Math.PI) / 360.0d; // 緯線上の経度１度の距離（km） + double KM_LON = 1 / LON1KM; // 緯線上の1km距離を表す経度 + + /* + double dLon = m / lon1; // 距離を表す経度（差分） + double dLat = m / LAT1KM; // 距離を表す緯度（差分） + double dlat = Math.abs(lat1 - lat2) / Japan.ONE_KM_LAT; + double dlon = Math.abs(lon1 - lon2) / Japan.ONE_KM_LON; + */ + double dlat = Math.abs(lat1 - lat2) / KM_LAT; + double dlon = Math.abs(lon1 - lon2) / KM_LON; + return Math.sqrt(Math.pow(dlat,2) + Math.pow(dlon,2)); + } + public Japan(double minLon, double minLat, double delta) { this.minLat = minLat; diff --git a/src/osm/jp/api/RectArea.java b/src/osm/jp/api/RectArea.java new file mode 100644 index 0000000..8cf577b --- /dev/null +++ b/src/osm/jp/api/RectArea.java @@ -0,0 +1,33 @@ +package osm.jp.api; + +public class RectArea { + public double minlon; // 経度（西） + public double maxlon; // 経度（東） + public double minlat; // 緯度（南） + public double maxlat; // 緯度（北） + + /** + * 矩形領域を中心点と中心点からの距離（メートル）でセットする + * + * @param lat // 中心点の緯度 + * @param lon // 中心点の経度 + * @param m // 距離　領域の一辺の長さの半分 + */ + public RectArea(double lat, double lon, int m) { + double dLat = Japan.ONE_KM_LAT * m / 1000D; // 距離を表す緯度（差分） + double dLon = Japan.ONE_KM_LON * m / 1000D; // 距離を表す経度（差分） + minlat = lat - dLat; // 底辺（緯度） + maxlat = lat + dLat; // 上辺（緯度） + minlon = lon - dLon; // 左辺 + maxlon = lon + dLon; // 右辺 + } + + /** + * 約１００ｍ四方 + * @param lat + * @param lon + */ + public RectArea(double lat, double lon) { + this(lat, lon, 50); + } +} diff --git a/src/osm/jp/coverage/busstop/Busstop.java b/src/osm/jp/coverage/busstop/Busstop.java index f976aa5..ab046e5 100644 --- a/src/osm/jp/coverage/busstop/Busstop.java +++ b/src/osm/jp/coverage/busstop/Busstop.java @@ -1,4 +1,5 @@ package osm.jp.coverage.busstop; +import osm.jp.api.RectArea; import osm.jp.api.HttpPOST; import javax.xml.parsers.*; import javax.xml.transform.TransformerException; @@ -17,7 +18,7 @@ public class Busstop { // 近くのバス停を探す範囲（バス停を中心としたNEER×２ｍ四方の領域 - static final int NEER = 150; // 150m(0.15km) + static final int NEER = 200; // 200m(0.2km) public static SimpleDateFormat timeStampFmt = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'"); @@ -70,7 +71,6 @@ System.out.println("SELECT idref,lat,lon,score FROM "+ HttpPOST.TABLE_NAME); try (ResultSet rset1 = ps1.executeQuery()) { while (rset1.next()) { - String osmid = rset1.getString("idref"); double lat = rset1.getDouble("lat"); double lon = rset1.getDouble("lon"); int score = rset1.getInt("score"); @@ -82,38 +82,26 @@ int area = 0; int fixed1 = 0; - // 指定の緯度経度を中心とする半径150x2m四方の矩形領域 - RectArea rect = new RectArea(lat, lon, NEER); // 300m 四方 + // 指定の緯度経度を中心とする半径200x2m四方の矩形領域 + RectArea rect = new RectArea(lat, lon, NEER*2); // 400m 四方 //System.out.println("SELECT gmlid,lat,lon,fixed1,area FROM "+ DbBusstop.TABLE_NAME +" WHERE (lat > ?) and (lat < ?) and (lon > ?) and (lon < ?)"); ps2.setDouble(1, rect.minlat); ps2.setDouble(2, rect.maxlat); ps2.setDouble(3, rect.minlon); ps2.setDouble(4, rect.maxlon); try (ResultSet rset2 = ps2.executeQuery()) { - double distance = 999999.9D; while (rset2.next()) { - double lat2 = rset2.getDouble("lat"); - double lon2 = rset2.getDouble("lon"); - double dd = distance(lat,lat2,lon,lon2); - if (dd < distance) { - distance = dd; - gmlid = rset2.getString("gmlid"); - area = rset2.getInt("area"); - fixed1 = rset2.getInt("fixed1"); - } + gmlid = rset2.getString("gmlid"); + area = rset2.getInt("area"); + fixed1 = rset2.getInt("fixed1"); + score += fixed1; + System.out.println("UPDATE "+ DbBusstop.TABLE_NAME +" SET fixed1="+ score +" WHERE gmlid="+ gmlid +" and area=" + area); + ps3.setInt(1, score); + ps3.setString(2, gmlid); + ps3.setInt(3, area); + ps3.executeUpdate(); } } - if (gmlid != null) { - score += fixed1; - System.out.println("UPDATE "+ DbBusstop.TABLE_NAME +" SET fixed1="+ score +" WHERE gmlid="+ gmlid +" and area=" + area); - ps3.setInt(1, score); - ps3.setString(2, gmlid); - ps3.setInt(3, area); - ps3.executeUpdate(); - } - else { - System.out.println("NOT FOUND! osmid="+ osmid); - } } } diff --git a/src/osm/jp/coverage/busstop/Coverage.java b/src/osm/jp/coverage/busstop/Coverage.java index 930c7fa..40adba0 100644 --- a/src/osm/jp/coverage/busstop/Coverage.java +++ b/src/osm/jp/coverage/busstop/Coverage.java @@ -23,7 +23,7 @@ import osm.jp.api.Japan; public class Coverage { - public ststic final String TABLE_NAME = "t_busstop"; + public static final String TABLE_NAME = "t_busstop"; public static void main(String[] args) throws FileNotFoundException, ClassNotFoundException, SQLException, IOException, ParserConfigurationException, SAXException, TransformerException { @@ -51,7 +51,7 @@ } rset2.close(); - ps2 = conPost.prepareStatement("SELECT COUNT(*) FROM t_fuel WHERE fixed > 0;"); + ps2 = conPost.prepareStatement("SELECT COUNT(*) FROM "+ TABLE_NAME +" WHERE fixed > 1;"); rset2 = ps2.executeQuery(); if (rset2.next()) { cover.molecule = rset2.getLong(1); @@ -59,7 +59,7 @@ rset2.close(); } else { - PreparedStatement ps2 = conPost.prepareStatement("SELECT COUNT(*) FROM t_fuel WHERE (area=?);"); + PreparedStatement ps2 = conPost.prepareStatement("SELECT COUNT(*) FROM "+ TABLE_NAME +" WHERE (area=?);"); ps2.setInt(1, i); ResultSet rset2 = ps2.executeQuery(); if (rset2.next()) { @@ -67,7 +67,7 @@ } rset2.close(); - ps2 = conPost.prepareStatement("SELECT COUNT(*) FROM t_fuel WHERE (fixed > 0) and (area=?);"); + ps2 = conPost.prepareStatement("SELECT COUNT(*) FROM "+ TABLE_NAME +" WHERE (fixed > 1) and (area=?);"); ps2.setInt(1, i); rset2 = ps2.executeQuery(); if (rset2.next()) { @@ -157,7 +157,7 @@ hw.newLine(); hw.write(space(level) + "\"timestamp\": \""+ LocalDate.now().format(DateTimeFormatter.ISO_DATE) +"\","); hw.newLine(); - hw.write(space(level) + "\"sourcedata\": \"国土数値情報　燃料給油所データ 平成２８年(2016)\","); + hw.write(space(level) + "\"sourcedata\": \"国土数値情報　バス停留所データ 平成２２年\","); hw.newLine(); hw.write(space(level++) + "\"coverage\": ["); hw.newLine(); diff --git a/src/osm/jp/coverage/busstop/DbExistBusstop.java b/src/osm/jp/coverage/busstop/DbExistBusstop.java index 23a43c9..403d4f3 100644 --- a/src/osm/jp/coverage/busstop/DbExistBusstop.java +++ b/src/osm/jp/coverage/busstop/DbExistBusstop.java @@ -84,13 +84,16 @@ * ( * node[highway=bus_stop](35.42,139.39,35.45,139.42); * node[highway="disused:bus_stop"](35.42,139.39,35.45,139.42); - * node[public_transport=platform](35.42,139.39,35.45,139.42); + * node[public_transport=platform]node[bus=yes](35.42,139.39,35.45,139.42); * node[public_transport=stop_position](35.42,139.39,35.45,139.42); * node[amenity=bus_station](35.42,139.39,35.45,139.42); * (way[amenity=bus_station](35.42,139.39,35.45,139.42);>;); * ); * out; * + * + * + * * } * * @param conHsql @@ -108,7 +111,7 @@ queryText.append("("); queryText.append(" node[highway=bus_stop]("+ area.getSWNE() +");"); queryText.append(" node[highway=\"disused:bus_stop\"]("+ area.getSWNE() +");"); - queryText.append(" node[public_transport=platform]("+ area.getSWNE() +");"); + queryText.append(" node[public_transport=platform][bus=yes]("+ area.getSWNE() +"););"); queryText.append(" node[public_transport=stop_position]("+ area.getSWNE() +");"); queryText.append(" node[amenity=bus_station]("+ area.getSWNE() +");"); queryText.append(" (way[amenity=bus_station]("+ area.getSWNE() +");>;);"); diff --git a/src/osm/jp/coverage/busstop/NagoyaBusstop.java b/src/osm/jp/coverage/busstop/NagoyaBusstop.java index e2079a7..58b45a8 100644 --- a/src/osm/jp/coverage/busstop/NagoyaBusstop.java +++ b/src/osm/jp/coverage/busstop/NagoyaBusstop.java @@ -1,4 +1,5 @@ package osm.jp.coverage.busstop; +import osm.jp.api.RectArea; import osm.jp.api.HttpPOST; import osm.jp.api.KatakanaToHiragana; import osm.jp.postgis.Do_sqlfiles; diff --git a/src/osm/jp/coverage/busstop/RectArea.java b/src/osm/jp/coverage/busstop/RectArea.java deleted file mode 100644 index 888d5f9..0000000 --- a/src/osm/jp/coverage/busstop/RectArea.java +++ /dev/null @@ -1,44 +0,0 @@ -package osm.jp.coverage.busstop; - -public class RectArea { - public double minlon; // 経度（西） - public double maxlon; // 経度（東） - public double minlat; // 緯度（南） - public double maxlat; // 緯度（北） - public static final double ONE_KM_LAT = 0.009013372D; // 1km距離を表す緯度（差分） - public static final double ONE_KM_LON = 0.010966404D; // 1km距離を表す経度（差分） - - /** - * 矩形領域を中心点と中心点からの距離（メートル）でセットする - * - * @param lat // 中心点の緯度 - * @param lon // 中心点の経度 - * @param m // 距離　領域の一辺の長さの半分 - */ - public RectArea(double lat, double lon, int m) { - /* - double BIG_Y = (40000000.0d / 2.0d / Math.PI); // 地球の半径 - double LAT1 = (10000000.0d / 90.0d); // 緯度１度の距離（ｍ） - double dLat = m / LAT1; // 距離を表す緯度（差分） - double y = Math.sin((90.0d - lat) / 180.0d) * BIG_Y; // 緯線上の地球の半径 - double lon1 = y * 2.0d * Math.PI; // 経度１度の距離（ｍ） - double dLon = m / lon1; // 距離を表す経度（差分） - */ - double dLat = ONE_KM_LAT * m / 1000D; // 距離を表す緯度（差分） - double dLon = ONE_KM_LON * m / 1000D; // 距離を表す経度（差分） - minlat = lat - dLat; // 底辺（緯度） - maxlat = lat + dLat; // 上辺（緯度） - minlon = lon - dLon; // 左辺 - maxlon = lon + dLon; // 右辺 - } - - /** - * 約１００ｍ四方 - * @param lat - * @param lon - * @param m - */ - public RectArea(double lat, double lon) { - this(lat, lon, 50); - } -} diff --git a/src/osm/jp/coverage/fuel/Fuel.java b/src/osm/jp/coverage/fuel/Fuel.java index 5045b3e..7f939b4 100644 --- a/src/osm/jp/coverage/fuel/Fuel.java +++ b/src/osm/jp/coverage/fuel/Fuel.java @@ -1,4 +1,5 @@ package osm.jp.coverage.fuel; +import osm.jp.api.RectArea; import osm.jp.coverage.busstop.*; import javax.xml.parsers.*; diff --git a/src/osm/jp/coverage/test/DbExistTest.java b/src/osm/jp/coverage/test/DbExistTest.java new file mode 100644 index 0000000..b2939ff --- /dev/null +++ b/src/osm/jp/coverage/test/DbExistTest.java @@ -0,0 +1,101 @@ +package osm.jp.coverage.test; + +import osm.jp.api.HttpPOST; +import osm.jp.api.Japan; + +import javax.xml.parsers.*; +import javax.xml.transform.TransformerException; +import org.xml.sax.*; + +import java.io.*; +import java.net.MalformedURLException; +import java.net.ProtocolException; +import java.sql.Connection; +import java.sql.SQLException; +import java.text.SimpleDateFormat; + +import jp.co.areaweb.tools.database.*; + +public class DbExistTest { + + String filter = ""; + String urlStr = ""; + + public static boolean DROP = false; + + // 近くのバス停を探す範囲（バス停を中心としたNEER×２ｍ四方の領域 + static final int NEER = 150; // 150m(0.15km) + static boolean update = false; // '-update'オプション postgisデータの更新を行う + static boolean noget = false; // '-noget'オプション OSM既存データのGETを行わない + + public static SimpleDateFormat timeStampFmt = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'"); + + /** + * 既存のOSMバス停を読み込む + * OSM OverPassAPI を使って、既存のOSMバス停のデータを取得して、 + * 「HSQLDB.BUSSTOP_EXIST」にSTOREする + */ + /** + * メイン + * + * java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar osm.jp.coverage.busstop.DbExistBusstop + * + * @param args + * + * @throws IOException + * @throws SQLException + * @throws ClassNotFoundException + * @throws FileNotFoundException + * @throws TransformerException + * @throws SAXException + * @throws ParserConfigurationException */ + public static void main(String[] args) throws FileNotFoundException, ClassNotFoundException, SQLException, IOException, ParserConfigurationException, SAXException, TransformerException + { + for (String arg : args) { + if (arg.toUpperCase().equals("-DROP")) { + DROP = true; + } + } + + Connection conHsql = null; + try { + conHsql = DatabaseTool.openDb("database"); + HttpPOST.create(conHsql, DROP); + + getJapanCapabilities(conHsql); + } + finally { + if (conHsql != null) { + DatabaseTool.closeDb(conHsql); + } + } + } + + /** + * + * 
{@code 
+     * 
+     *  node(35.42,139.39,35.45,139.42);
+     *  node[junction=yes]["name:en"="Ryosei"];
+     *  out;
+     * 
+     * }
+ * + * @param conHsql + * @throws MalformedURLException + * @throws ProtocolException + * @throws IOException + * @throws ClassNotFoundException + * @throws SQLException + * @throws ParserConfigurationException + * @throws SAXException + */ + public static void getJapanCapabilities(Connection conHsql) throws MalformedURLException, ProtocolException, IOException, ClassNotFoundException, SQLException, ParserConfigurationException, SAXException { + StringBuilder queryText = new StringBuilder(); + queryText.append("node(35.42,139.39,35.45,139.42);"); + queryText.append("node[junction=yes][\"name:en\"=\"Ryosei\"];"); + queryText.append("out;"); + HttpPOST.getQuery(queryText.toString()); + HttpPOST.readExistingFile(conHsql, 2); + } +} \ No newline at end of file diff --git a/src/osm/jp/coverage/test/DbTest.java b/src/osm/jp/coverage/test/DbTest.java new file mode 100644 index 0000000..712188b --- /dev/null +++ b/src/osm/jp/coverage/test/DbTest.java @@ -0,0 +1,173 @@ +package osm.jp.coverage.test; + +import java.io.*; +import java.sql.Connection; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.sql.SQLException; +import javax.xml.parsers.ParserConfigurationException; + +import jp.co.areaweb.tools.database.*; +import org.xml.sax.SAXException; +import osm.jp.api.HttpPOST; + +public class DbTest { + public static final String TABLE_NAME = "test"; + + File inputFile; + String filter = ""; + int iCounter = 0; + String urlStr = ""; + Connection con; + String timeStampStr = null; + File dir = null; + + /** メイン + * 動作条件； HSQLDBのフォルダを削除した状態で実行すること。 + * @param args + * @throws IOException + * @throws SQLException + * @throws ClassNotFoundException + * @throws FileNotFoundException + * @throws javax.xml.parsers.ParserConfigurationException + * @throws org.xml.sax.SAXException */ + public static void main(String[] args) throws FileNotFoundException, ClassNotFoundException, IOException, SQLException, ParserConfigurationException, SAXException + { + // HSQLディレクトリがなければエラー + File dbdir = new File("database"); + if (!dbdir.isDirectory()) { + throw new FileNotFoundException("Directory 'database' is not found."); + } + + Connection conHsql = null; + try { + conHsql = DatabaseTool.openDb("database"); + HttpPOST.sql(conHsql, "DROP TABLE IF EXISTS "+ TABLE_NAME +" CASCADE"); + //HttpPOST.sql(conHsql, "DROP INDEX "+ TABLE_NAME +"_index;"); + create(conHsql); + try (PreparedStatement ps = conHsql.prepareStatement("DELETE FROM "+ TABLE_NAME)) { + ps.executeUpdate(); + } + + // 対象のファイルが「数値地図情報のGMLデータファイル」の時のみ処理を行う。 + importTest(conHsql, 14); + + DbTest.export(conHsql); + } + finally { + if (conHsql != null) { + DatabaseTool.closeDb(conHsql); + } + } + } + + /** + * 数値地図情報のGMLデータファイルを読み取ってローカルベータベースへ記録する + * @param conHsql + * @param areacode + * @throws FileNotFoundException + * @throws ClassNotFoundException + * @throws SQLException + * @throws IOException + * @throws ParserConfigurationException + * @throws SAXException + */ + public static void importTest (Connection conHsql, int areacode) throws FileNotFoundException, ClassNotFoundException, SQLException, IOException, ParserConfigurationException, SAXException { + int iCounter = 0; + iCounter += showNodes(conHsql, areacode); + System.out.println("("+ areacode +") Node数["+ iCounter +"]"); + } + + static final double CENTER_LAT = 35.4342443D; + static final double CENTER_LON = 139.4092180D; + static final int LOOP = 50; + static final double SIDE = 0.015D; + + /** + * ノード: 綾西 (368434484) 35.4342443, 139.4092180 + * + * @param con + * @param areacode + * @return + * @throws IOException + * @throws SQLException + */ + public static int showNodes(Connection con, int areacode) throws IOException, SQLException { + int iCounter = 0; + double lon = CENTER_LON - SIDE; + for (int x = 0; x <= LOOP; x++) { + double lat = CENTER_LAT - SIDE; + for (int y = 0; y <= LOOP; y++) { + showGmlPoint(con, lat, lon, areacode, iCounter++); + lat += SIDE * 2 / LOOP; + } + lon += SIDE * 2 / LOOP; + } + return iCounter; + } + + /** + * + * @param con + * @param lat + * @param lon + * @param areacode + * @param id + * @throws IOException + * @throws SQLException + */ + public static void showGmlPoint(Connection con, double lat, double lon, int areacode, int id) throws IOException, SQLException { + try (PreparedStatement ps6 = con.prepareStatement("INSERT INTO "+ TABLE_NAME +" (lat,lon,fixed,fixed1,area,gmlid,up) VALUES (?,?,0,0,?,?,2)")) { + ps6.setDouble(1, lat); + ps6.setDouble(2, lon); + ps6.setInt(3, areacode); + ps6.setString(4, Integer.toString(id)); + ps6.executeUpdate(); + } + } + + + /** + * 'table.BUS_STOP'を新規に作る + * 既にテーブルが存在する時には何もしない + * @param conHsql + * @throws SQLException + */ + public static void create(Connection conHsql) throws SQLException { + String createSt; + + // 'table.TEST'を新規に作る + createSt = "CREATE TABLE "+ TABLE_NAME +" (gmlid VARCHAR(12) NOT NULL, name VARCHAR(128), lat DOUBLE, lon DOUBLE, fixed INT, fixed1 INT, area INT, ifile VARCHAR(128), up INT, CONSTRAINT "+ TABLE_NAME +"_pk PRIMARY KEY(gmlid, area));"; + HttpPOST.sql(conHsql, createSt); + + createSt = "CREATE INDEX "+ TABLE_NAME +"_index ON "+ TABLE_NAME +" (lat,lon);"; + HttpPOST.sql(conHsql, createSt); + } + + /** + * 'table.BUS_STOP'の内容をCSV形式にして標準出力に出力する + * @param con + */ + public static void export(Connection con) { + try { + System.out.println("TABLE: " + TABLE_NAME); + System.out.println("\"gmlid\",\"name\",\"lat\",\"lon\",\"fixed\",\"ifile\""); + PreparedStatement ps8 = con.prepareStatement("SELECT gmlid,name,lat,lon,fixed,ifile FROM "+ TABLE_NAME); + try (ResultSet rset8 = ps8.executeQuery()) { + while (rset8.next()) { + String gmlid = rset8.getString("gmlid"); + String name = rset8.getString("name"); + Double lat = rset8.getDouble("lat"); + Double lon = rset8.getDouble("lon"); + int fixed = rset8.getInt("fixed"); + String ifile = rset8.getString("ifile"); + System.out.println("\""+ gmlid +"\",\""+ name +"\","+ lat +","+ lon +","+ fixed +",\""+ ifile +"\""); + } + } + } + catch (SQLException e) { + e.printStackTrace(); + } + } + +} \ No newline at end of file diff --git a/src/osm/jp/coverage/test/Test.java b/src/osm/jp/coverage/test/Test.java new file mode 100644 index 0000000..0bc244a --- /dev/null +++ b/src/osm/jp/coverage/test/Test.java @@ -0,0 +1,127 @@ +package osm.jp.coverage.test; + +import javax.xml.parsers.*; +import javax.xml.transform.TransformerException; + +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.text.SimpleDateFormat; +import jp.co.areaweb.tools.database.*; +import osm.jp.api.HttpPOST; +import osm.jp.api.Japan; +import osm.jp.api.RectArea; + +public class Test { + + // 近くのノードを探す範囲（KJS2を中心としたNEER×2(ｍ)四方の領域 + static final int NEER = 1000; // 1000m x 2 = 2000m四方 + static final double DISTANCE = 1000.0D; // 1000m 以内 + + 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 [option] + * OPTION: -check OSMデータ上に既存のバス停が存在するかどうかをチェックする + * + * @param args + * @throws IOException + * @throws SQLException + * @throws ClassNotFoundException + * @throws FileNotFoundException + * @throws TransformerException + * @throws SAXException + * @throws ParserConfigurationException + */ + public static void main(String[] args) throws FileNotFoundException, ClassNotFoundException, SQLException, IOException, ParserConfigurationException, SAXException, TransformerException + { + // HSQLディレクトリがなければ作る + File dbdir = new File("database"); + if (!dbdir.isDirectory()) { + dbdir.mkdir(); + } + + Connection con = DatabaseTool.openDb("database"); + + try { + new Test(con); + } + finally { + DatabaseTool.closeDb(con); + } + } + + /** + * 個別の都道府県「GMLディレクトリ」を処理 + * + * @param con + * @throws SQLException + * @throws FileNotFoundException + * @throws ClassNotFoundException + * @throws IOException + * @throws ParserConfigurationException + * @throws SAXException + * @throws TransformerException + */ + public Test(Connection con) throws SQLException, FileNotFoundException, ClassNotFoundException, IOException, ParserConfigurationException, SAXException, TransformerException { + + String sqlStr1 = "SELECT lat,lon FROM "+ HttpPOST.TABLE_NAME; + String sqlStr2 = "SELECT gmlid,lat,lon,area FROM "+ DbTest.TABLE_NAME +" WHERE (lat > ?) and (lat < ?) and (lon > ?) and (lon < ?)"; + String sqlStr3 = "UPDATE "+ DbTest.TABLE_NAME +" SET fixed1=1 WHERE gmlid=? and area=?"; + String sqlStr4 = "UPDATE "+ DbTest.TABLE_NAME +" SET fixed1=0"; + String sqlStr5 = "UPDATE "+ DbTest.TABLE_NAME +" SET up=1 WHERE (fixed<>fixed1) and (up=0)"; + try ( PreparedStatement ps2 = con.prepareStatement(sqlStr2); + PreparedStatement ps1 = con.prepareStatement(sqlStr1); + PreparedStatement ps3 = con.prepareStatement(sqlStr3); + PreparedStatement ps4 = con.prepareStatement(sqlStr4); + PreparedStatement ps5 = con.prepareStatement(sqlStr5)) + { + System.out.println(sqlStr4); + ps4.executeUpdate(); + + try (ResultSet rset1 = ps1.executeQuery()) { + System.out.println(sqlStr1); + while (rset1.next()) { + double lat = rset1.getDouble("lat"); + double lon = rset1.getDouble("lon"); + + // 指定の緯度経度を中心とする半径1000x2m四方の矩形領域 + RectArea rect = new RectArea(lat, lon, NEER); // 1000m 四方 + ps2.setDouble(1, rect.minlat); + ps2.setDouble(2, rect.maxlat); + ps2.setDouble(3, rect.minlon); + ps2.setDouble(4, rect.maxlon); + System.out.println(sqlStr2 +" ["+ rect.minlat +", "+ rect.maxlat +", "+ rect.minlon +", "+ rect.maxlon +"]"); + try (ResultSet rset2 = ps2.executeQuery()) { + while (rset2.next()) { + String gmlid = rset2.getString("gmlid"); + double lat2 = rset2.getDouble("lat"); + double lon2 = rset2.getDouble("lon"); + int area = rset2.getInt("area"); + double dd = Japan.distanceKm(lat,lon,lat2,lon2); + System.out.println("D"+"distance = "+ dd +""); + if ((dd * 1000.0D) < DISTANCE) { + System.out.println(sqlStr3 +" ["+ gmlid +", "+ area +"]"); + ps3.setString(1, gmlid); + ps3.setInt(2, area); + ps3.executeUpdate(); + } + else { + System.out.println("out of distance "+ dd +" : NEER=1000"); + } + } + } + } + } + + System.out.println(sqlStr5); + ps5.executeUpdate(); + } + } +} \ No newline at end of file diff --git a/src/osm/jp/coverage/test/ToPostgis.java b/src/osm/jp/coverage/test/ToPostgis.java new file mode 100644 index 0000000..fb77303 --- /dev/null +++ b/src/osm/jp/coverage/test/ToPostgis.java @@ -0,0 +1,98 @@ +package osm.jp.coverage.test; + +import osm.jp.coverage.busstop.*; +import java.io.FileNotFoundException; +import java.io.IOException; +import java.math.BigDecimal; +import java.sql.Connection; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.sql.SQLException; +import javax.xml.parsers.ParserConfigurationException; +import jp.co.areaweb.tools.database.DatabaseTool; +import org.xml.sax.SAXException; +import osm.jp.api.HttpPOST; + +/** + * HSQLDB.TESTの結果をPOSTGIS.t_testへ反映させる + * テーブル名： t_test + * インデックス： ix_test_geom + * gid PostGISの識別ID + * name 名称 + * fixed OSMのバス停が周辺に存在するかどうか、存在しない場合は0,存在する場合はその数。 + * geom PostGIS形式の位置情報(4612:) + * @author yuu + * + */ +public class ToPostgis { + public static void main(String[] argv) throws Exception { + Connection conHsql = null; + Connection conPost = null; + try { + // DB.tableを作成 + conHsql = DatabaseTool.openDb("database"); + conPost = DatabaseTool.openDb("postgis"); + + transportNew(conHsql, conPost); + + } + finally { + if (conHsql != null) { + DatabaseTool.closeDb(conHsql); + } + if (conPost != null) { + DatabaseTool.closeDb(conPost); + } + } + } + + /** + * HSQLDB: "SELECT idref,area,fixed,lat,lon FROM BUS_STOP" + * POSTGIS "insert into t_busstop(idref,fixed,area,geom) VALUES('n000001',0,0, ST_GeomFromText('POINT(136.9695284611471 35.10300377075564)', 4612));" + * + * @param conHsql + * @param conPost + * @throws java.io.FileNotFoundException + * @throws java.lang.ClassNotFoundException + * @throws java.sql.SQLException + * @throws java.io.IOException + * @throws javax.xml.parsers.ParserConfigurationException + * @throws org.xml.sax.SAXException + */ + public static void transportNew (Connection conHsql, Connection conPost) throws FileNotFoundException, ClassNotFoundException, SQLException, IOException, ParserConfigurationException, SAXException { + HttpPOST.sql(conPost, "DROP TABLE IF EXISTS t_test CASCADE;"); + HttpPOST.sql(conPost, "CREATE TABLE t_test (gid SERIAL PRIMARY KEY,gmlid text,name text,fixed integer,area integer,geom GEOMETRY(POINT, 4612));"); + HttpPOST.sql(conPost, "CREATE INDEX ix_test_geom ON t_test USING GiST (geom);"); + + toInsert(conHsql, conPost); + } + + public static void toInsert (Connection conHsql, Connection conPost) throws FileNotFoundException, ClassNotFoundException, SQLException, IOException, ParserConfigurationException, SAXException { + String sql = "SELECT gmlid,lat,lon,fixed1,area FROM "+ DbTest.TABLE_NAME; + try (PreparedStatement ps1 = conHsql.prepareStatement(sql)) { + try (ResultSet rset1 = ps1.executeQuery()) { + while (rset1.next()) { + String gmlid = rset1.getString("gmlid"); + int area = rset1.getInt("area"); + int fixed1 = rset1.getInt("fixed1"); + double lat = rset1.getDouble("lat"); + double lon = rset1.getDouble("lon"); + + int fixed = 0; + if (fixed1 > 0) { + fixed = 1; + } + String geom = "ST_GeomFromText('POINT("+ BigDecimal.valueOf(lon).toPlainString() +" "+ BigDecimal.valueOf(lat).toPlainString() +")', 4612)"; + String sqlStr = "INSERT INTO t_test (gmlid,fixed,area,geom) VALUES (?,?,?,"+ geom +")"; + System.out.println(sqlStr +" ["+ gmlid +", "+ fixed +", "+ area +"]"); + try (PreparedStatement ps = conPost.prepareStatement(sqlStr)) { + ps.setString(1, gmlid); + ps.setInt(2, fixed); + ps.setInt(3, area); + ps.executeUpdate(); + } + } + } + } + } +} diff --git a/src/osm/jp/postgis/ToPostgis.java b/src/osm/jp/postgis/ToPostgis.java new file mode 100644 index 0000000..e281ecb --- /dev/null +++ b/src/osm/jp/postgis/ToPostgis.java @@ -0,0 +1,111 @@ +package osm.jp.postgis; + +import osm.jp.coverage.busstop.*; +import java.io.FileNotFoundException; +import java.io.IOException; +import java.math.BigDecimal; +import java.sql.Connection; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.sql.SQLException; +import javax.xml.parsers.ParserConfigurationException; +import jp.co.areaweb.tools.database.DatabaseTool; +import org.xml.sax.SAXException; +import osm.jp.api.HttpPOST; + +/** + * １０００ｍメッシュをPOSTGIS.t_testへ反映させる + * ノード: 綾西 (368434484) 35.4342443, 139.4092180 + * から + * ノード: 庚申供養 (1679559681) 35.4342940, 139.4207050 + * ノード: 内藤橋 (1742708189) : 35.4432806, 139.4104114 + * までが 1,000m となるはず + * + * テーブル名： t_test + * インデックス： ix_test_geom + * gid PostGISの識別ID + * fixed + * geom PostGIS形式の位置情報(4612:) + * @author yuu + * + */ +public class ToPostgis { + public static void main(String[] argv) throws Exception { + Connection conHsql = null; + Connection conPost = null; + try { + // DB.tableを作成 + conHsql = DatabaseTool.openDb("database"); + conPost = DatabaseTool.openDb("postgis"); + + transportNew(conHsql, conPost); + + } + finally { + if (conHsql != null) { + DatabaseTool.closeDb(conHsql); + } + if (conPost != null) { + DatabaseTool.closeDb(conPost); + } + } + } + + /** + * POSTGIS "insert into t_test(idref,fixed,area,geom) VALUES('n000001',0,0, ST_GeomFromText('POINT(136.9695284611471 35.10300377075564)', 4612));" + * + * @param conHsql + * @param conPost + * @throws java.io.FileNotFoundException + * @throws java.lang.ClassNotFoundException + * @throws java.sql.SQLException + * @throws java.io.IOException + * @throws javax.xml.parsers.ParserConfigurationException + * @throws org.xml.sax.SAXException + */ + public static void transportNew (Connection conHsql, Connection conPost) throws FileNotFoundException, ClassNotFoundException, SQLException, IOException, ParserConfigurationException, SAXException { + HttpPOST.sql(conPost, "DROP TABLE IF EXISTS t_test CASCADE;"); + HttpPOST.sql(conPost, "CREATE TABLE t_test (gid SERIAL PRIMARY KEY,fixed integer,area integer,geom GEOMETRY(POINT, 4612));"); + HttpPOST.sql(conPost, "CREATE INDEX ix_test_geom ON t_test USING GiST (geom);"); + + toInsert(conHsql, conPost); + } + + public static void toInsert (Connection conHsql, Connection conPost) throws FileNotFoundException, ClassNotFoundException, SQLException, IOException, ParserConfigurationException, SAXException { + String sql = "SELECT gmlid,name,lat,lon,fixed1,area FROM "+ DbBusstop.TABLE_NAME; + try (PreparedStatement ps1 = conHsql.prepareStatement(sql)) { + try (ResultSet rset1 = ps1.executeQuery()) { + while (rset1.next()) { + String gmlid = rset1.getString("gmlid"); + int area = rset1.getInt("area"); + int fixed1 = rset1.getInt("fixed1"); + double lat = rset1.getDouble("lat"); + double lon = rset1.getDouble("lon"); + String name = rset1.getString("name"); + + int fixed = 0; + if (fixed1 >= 100) { + fixed = 3; + } + else if (fixed1 >= 50) { + fixed = 2; + } + else if (fixed1 > 0) { + fixed = 1; + } + String geom = "ST_GeomFromText('POINT("+ BigDecimal.valueOf(lon).toPlainString() +" "+ BigDecimal.valueOf(lat).toPlainString() +")', 4612)"; + String sqlStr = "INSERT INTO t_busstop (gmlid,name,fixed,area,geom) VALUES ('"+ gmlid +"','"+ name +"',"+ fixed +","+ area +","+ geom +")"; + System.out.println(sqlStr); + sqlStr = "INSERT INTO t_busstop (gmlid,name,fixed,area,geom) VALUES (?,?,?,?,"+ geom +")"; + try (PreparedStatement ps = conPost.prepareStatement(sqlStr)) { + ps.setString(1, gmlid); + ps.setString(2, name); + ps.setInt(3, fixed); + ps.setInt(4, area); + ps.executeUpdate(); + } + } + } + } + } +} diff --git a/src/test.activity.violet.html b/src/test.activity.violet.html new file mode 100644 index 0000000..1e23ebc --- /dev/null +++ b/src/test.activity.violet.html @@ -0,0 +1,1691 @@ + + + + + + + + + This file was generated with Violet UML Editor 2.1.0. +   ( View Source / Download Violet ) +
+
+ +
+
+ embedded diagram image + + \ No newline at end of file