您现在的位置是：网站首页> 编程资料编程资料
shp2sqlserver 用法简析_mssql2005_
2023-05-27
377人已围观
简介 shp2sqlserver 用法简析_mssql2005_
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"
作者 彭金华
官方说明:
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 数据库同步配置图文详解_mssql2005_
- mssql2005字符串连接方法 避免无效的连接错误_mssql2005_
- sql2005 安装教程 图文_mssql2005_
- SQL Server 2005中更改sa的用户名的方法_mssql2005_
- SQL Server2005打开数据表中的XML内容时报错的解决办法_mssql2005_
- SQL2005 性能监视器计数器错误解决方法_mssql2005_
- sqlserver为标识列指定显式值_mssql2005_
- Win2008中SqlServer2008 无法打开错误日志文件导致无法启动的解决方法_mssql2005_
- sqlserver巧用row_number和partition by分组取top数据_mssql2005_
- SQLServer2005 没有日志文件(*.ldf) 只有数据文件(*.mdf) 恢复数据库的方法_mssql2005_
