shp2sqlserver 用法浅析

发布时间：2023-08-05 14:44:23 所属栏目：MsSql教程来源：

导读：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 directl

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 用法：

<div class="codetitle"><a style="CURSOR: pointer" data="71822" class="copybut" id="copybut71822" onclick="doCopy('code71822')"> 代码如下:

<div class="codebody" id="code71822">

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" 作者彭金华

（编辑：聊城站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!