centos7,postgresql9.6でPostGis


# yum install postgis2_96

postgres=# create database geodb owner iyo;
postgres=# \c geodb
postgres=# create extension postgis;
geodb=> CREATE TABLE geotable (
id SERIAL NOT NULL PRIMARY KEY,
name varchar (255) NOT NULL,
geom geography(POINT, 4612) NOT NULL -- SRID 4612 googlemapだと900913
);
geodb=> select * from geometry_columns ;
geodb=> CREATE INDEX geom_idx ON geotable using GiST(geom);


geodb=> INSERT INTO geotable (name, geom) VALUES
('駅', ST_GeographyFromText('SRID=4326;POINT(139.777254 35.713768)'))

geodb=> CREATE TABLE gmaptable (
id SERIAL NOT NULL PRIMARY KEY,
name varchar (255) NOT NULL,
geom geometry(POINT, 900913) NOT NULL -- SRID 4612 googlemapだと900913
);