.refractions.net] On Behalf Of Ralf
> Suhr
> Sent: Monday, March 15, 2010 4:38 AM
> To: postgis-users@postgis.refractions.net
> Subject: Re: [postgis-users] Changing transaction behaviour in shp2pgsql
> -summary
>
> Hello Ben,
>
> I'm doing recoding of shapefiles
postgis.us
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Ralf
Suhr
Sent: Monday, March 15, 2010 4:38 AM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] Changing transaction be
Hello Ben,
I'm doing recoding of shapefiles without postgres when postgres can not do so.
shp2pgsql [...] | recode shapefile_encoding..utf8 | psql database.
Gr Ralf
Am Montag 15 März 2010 00:51:00 schrieb Ben Madin:
> Thanks all for the feedback - to summarise :
>
> shp2pgsql - Currently, all
Thanks all for the feedback - to summarise :
shp2pgsql - Currently, all output is 'chunked' transactions - changing this
behaviour not currently supported.
- A patch could be provided to shp2pgsql to do this.
- The suggestion is a -T switch with options such as single, chunked, no
transaction
On Sun, Mar 14, 2010 at 04:58:02PM +0700, Ben Madin wrote:
> in the event I can't work out the encoding, is there any way to turn off the
> transaction behaviour, ie I'm happy to miss 4 records, but not 1000 as a
> result of the transactions being aborted. (short of putting it all into a
> text
7;s/BEGIN//' | sed 's/COMMIT//' psql australia
If this fails, or you want to try ogr2ogr, ask again :-)
Cheers,
Brent
--- On Sun, 3/14/10, Ben Madin wrote:
> From: Ben Madin
> Subject: [postgis-users] Changing transaction behaviour in shp2pgsql
> To: "PostGIS Users
Ben,
You can probably just strip the BEGIN and COMMIT lines like
shp2pgsql ... | grep -v BEGIN | grep -v COMMIT | psql australia
You might also want to look at the file:
shp2pgsql ... > data.sql
vi data.sql
HTH,
-Steve
Ben Madin wrote:
G'day all,
I'm using shp2pgsql to import a road netw
G'day all,
I'm using shp2pgsql to import a road network, of which the fine detail is not
so important.
Mac OS X 10.6.2 POSTGIS="1.4.1" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23
September 2009" USE_STATS (thanks William K)
$ shp2pgsql -s 28350 /Users/owner/Spatial/country/AUS/WA/MRWA/mrwa
