[EMAIL PROTECTED] wrote:
Er, I hope I'm not asking the wrong question here.
I'm about to try MapServer with postGIS spatial
database. I have tried converting SHP file to postGIS
table using this guide:
http://www.bostongis.com/?content_name=postgis_tut01
And it was quite successful.
However, my real data is multiple adjacent SHPs. When
using SHP files for Map Server, I can use tile
indexing. But now I'm going to use postGIS table.
So the question is: how can I convert all those
adjacent shape files to a postGIS table? Is there any
'append' feature that I haven't been aware of?
Many thanks,
-Kresh
For the first file in a table use -c and then for all the rest use -a read:
[EMAIL PROTECTED]:~/dev$ shp2pgsql
RCSID: $Id: shp2pgsql.c,v 1.106 2006/01/16 10:42:58 strk Exp $
USAGE: shp2pgsql [<options>] <shapefile> [<schema>.]<table>
OPTIONS:
-s <srid> Set the SRID field. If not specified it defaults to -1.
(-d|a|c|p) These are mutually exclusive options:
-d Drops the table , then recreates it and populates
it with current shape file data.
-a Appends shape file into current table, must be
exactly the same table schema.
-c Creates a new table and populates it, this is the
default if you do not specify any options.
-p Prepare mode, only creates the table
-g <geometry_column> Specify the name of the geometry column
(mostly useful in append mode).
-D Use postgresql dump format (defaults to sql insert
statments.
-k Keep postgresql identifiers case.
-i Use int4 type for all integer dbf fields.
-I Create a GiST index on the geometry column.
-w Use wkt format (for postgis-0.x support - drops M - drifts
coordinates).
-W <encoding> Specify the character encoding of Shape's
attribute column. (default : "ASCII")
-N <policy> Specify NULL geometries handling policy (insert,skip,abort)
