Newer
Older
osmCoverage / src / sql.txt
@hayashi hayashi on 10 Sep 2017 714 bytes FUEL
CREATE TABLE t_busstop (
	gid SERIAL PRIMARY KEY,
	osm_id bigint,
	name text,
	geom GEOMETRY(POINT, 4612)
);
CREATE INDEX ix_busstop_geom ON t_busstop USING GiST (geom);

insert into t_busstop(osm_id,name,geom) select osm_id, st_transform(way,4612) FROM planet_osm_point WHERE (highway='bus_stop');
insert into t_busstop(osm_id,name,geom) VALUES(884, 'なまえ', ST_GeomFromText('POINT(139.4110836 35.4341053)', 4612));

----
CREATE TABLE t_test (
	gid SERIAL PRIMARY KEY,
	osm_id bigint,
	name text,
	geom GEOMETRY(POINT, 4612)
);

CREATE INDEX ix_test_geom ON t_test USING GiST (geom);

insert into t_test(osm_id,name,geom) VALUES(884, 'なまえ', ST_GeomFromText('POINT(139.4110836 35.4341053)', 4612));

----