2018-10-25から1日間の記事一覧

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…