Newer
Older
osmCoverage / src / Nagoya_busstop.sql
@yuu yuu on 18 Mar 2017 1 KB NagoyaBusstop
  1. DROP TABLE nagoya_busstop;
  2. CREATE TABLE nagoya_busstop (gid SERIAL PRIMARY KEY, name text, kana text, fixed integer, area integer, geom GEOMETRY(POINT, 4612));
  3. CREATE INDEX ix_nagoya_busstop_geom ON nagoya_busstop USING GiST (geom);
  4. select count(*) from nagoya_busstop;
  5. select count(*) from nagoya_busstop where fixed=0;
  6. select count(*) from nagoya_busstop where fixed>=50 and fixed<100;
  7. select count(*) from nagoya_busstop where fixed>=100;
  8.  
  9. insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相川一丁目','アイカワイッチョウメ',0,0, ST_GeomFromText('POINT(136.9695284611471 35.10300377075564)', 4612));
  10. insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相川一丁目','アイカワイッチョウメ',0,0, ST_GeomFromText('POINT(136.969047121627 35.102834616747685)', 4612));
  11. insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相生山住宅','アイオイヤマジュウタク',0,0, ST_GeomFromText('POINT(136.9743151095072 35.10462957171922)', 4612));
  12. insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相生山住宅','アイオイヤマジュウタク',0,0, ST_GeomFromText('POINT(136.97421198072038 35.10334076583495)', 4612));
  13. insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相生山住宅','アイオイヤマジュウタク',0,0, ST_GeomFromText('POINT(136.9744339059364 35.10354449054206)', 4612));
  14. insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相生山住宅南','アイオイヤマジュウタクミナミ',0,0, ST_GeomFromText('POINT(136.97261499203069 35.102706336248744)', 4612));
  15. insert into nagoya_busstop(name,kana,fixed,area,geom) VALUES('相生山住宅南','アイオイヤマジュウタクミナミ',0,0, ST_GeomFromText('POINT(136.97317171870043 35.10254162416889)', 4612));
  16.  
  17.