centos7,postgresql9.6でPostGis
# yum install postgis2_96postgres=# 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)'))
-
- ジオメトリー 世界測地系、Googlemap
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
);