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));