shp2sqlserver 用法简析

2020-10-30 19:08:42

字体：大中小

来源：转载

供稿：网友

shp2sqlserver用法简析

官方说明:
shp2sqlserver is a command line tool for loading shapefiles into Microsoft SQL Server 2008. It is modeled after PostGIS's shp2pgsql, except that it loads directly into the database instead of writing sql to stdout.

http://code.google.com/p/cumberland/wiki/shp2sqlserver

用法：

复制代码代码如下:

 
shp2sqlserver.exe -h 
Usage: shp2sqlserver.exe [OPTIONS]+ "connectionString" "path to shapefile" 
Loads a shapefile into Microsoft SQL Server 2008 

example: shp2sqlserver.exe "Data Source=./SQLExpress2008;Initial Catalog=spatialtest;Integrated Security=true" myshape.shp 

Options: 
-s, --srid=VALUE The Spatial Reference ID (SRID). If not specified it defaults to -1. 
-g, --geometry_column=VALUE The name of the geometry column 
-t, --table_name=VALUE The table name to use 
-k, --key_column=VALUE The name of the identity column to create for a primary key 
-i, --index Create a spatial index 
-l, --latlong Add spatial data as geography type 
-a, --append Append data. If not specified, table will be created 
-h, --help show this message and exit 

示例:

shp2sqlserver -g="SHAPE" -s="4326" -i "Data Source=.;Initial Catalog=largesite;Integrated Security=false;user id=sa;password=123456;" "D:/data/xyz.shp"

作者彭金华

上一篇：sqlserver2005自动创建数据表和自动添加某个字段索引

下一篇：SqlServer2005 数据库同步配置图文详解