手机
当前位置:查字典教程网 >编程开发 >mssql数据库 >shp2sqlserver 用法简析
shp2sqlserver 用法简析
摘要:shp2sqlserver用法简析官方说明:shp2sqlserverisacommandlinetoolforloadingshapefi...

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:dataxyz.shp"

作者 彭金华

【shp2sqlserver 用法简析】相关文章:

SqlServer常用函数

SQL Server 使用 SET FMTONLY ON 获得表的元数据

sql server删除外键约束

SQL Server 2005支持的两条新语法

SqlServer 2005的排名函数使用小结

SQL Server 常用SQL总结

Sqlserver浅谈用户定义表类型

SQL Server 2005中更改sa的用户名的方法

sqlserver内存释放

SqlServer2005 链接服务器用法

精品推荐
分类导航