mysql gis postgre_在PostgreSQL中建立GIS数据库

在PostgreSQL中建立GIS数据库

postgres=# create user gisuser password '123456';

CREATE ROLE

postgres=# create tablespace tbs_geo owner gisuser location '/tbs_postgisdb';

CREATE TABLESPACE

postgres=# create database postgisdb owner=gisuser tablespace=tbs_geo;

CREATE DATABASE

postgres=# \c postgisdb postgres

You are now connected to database "postgisdb" as user "postgres".

postgisdb=# \i /postgresql/share/contrib/postgis-2.1/postgis.sql

SET

BEGIN

CREATE FUNCTION

.

.

.

GRANT

COMMIT

postgisdb=# \i /postgresql/share/contrib/postgis-2.1/spatial_ref_sys.sql

BEGIN

INSERT 0 1

.

.

.

INSERT 0 1

COMMIT

ANALYZE

postgisdb=# \q

#

测试导入shp文件

(首先由shp生成pgsql语句)

# shp2pgsql -W 'GBK' /postgresql/testdata/testshp target_table_name > /posgresql/target_sqlfile.sql

Shapefile type: Point

Postgis type: POINT[2]

# psql -d postgisdb -U gisuser -f /postgresql/target_sqlfile.sql

SET

SET

BEGIN

CREATE TABLE

ALTER TABLE

addgeometrycolumn

---------------------------------------------------------

public.target_table_name.geom SRID:0 TYPE:POINT DIMS:2

(1 row)

INSERT 0 1

INSERT 0 1

(然后运行此pgsql语句生成target_table_name表)

# psql -d postgisdb -U gisuser -f /postgresql/target_sqlfile.sql

shp2pgsql -W 'GBK' /postgresql/testdata/testshp target_table_name > /postgresql/targ

get_sqlfile.sqlpsql -d postgisdb -U gisuser -f /postgresql/target_sqlfile.sql

在pgAdmin中查看此表的内容，若有，则导入正常。

阅读(3220) | 评论(0) | 转发(0) |