shp2sqlserver 用法简析
导读：收集整理的这篇文章主要介绍了shp2sqlserver 用法简析，觉得挺不错的，现在分享给大家，也给大家做个参考。 shp2SQLserver用法简析 官方说明: shp2sqlserv...
收集整理的这篇文章主要介绍了shp2sqlserver 用法简析，觉得挺不错的，现在分享给大家，也给大家做个参考。 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=.\SQLEx@R_777_1313@2008; 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"
作者 彭金华
声明：本文内容由网友自发贡献，本站不承担相应法律责任。对本内容有异议或投诉，请联系2913721942#qq.com核实处理，我们将尽快回复您，谢谢合作！
若转载请注明出处： shp2sqlserver 用法简析
本文地址： https://pptw.com/jishu/632134.html