Re: [postgis-users] Shp2pgsql-gui, Save to schema other than public?

part de Ryan Dalton Envoyé : mardi 17 avril 2012 17:30 À : postgis-users@postgis.refractions.net Objet : [postgis-users] Shp2pgsql-gui, Save to schema other than public? I see that I can run the command "ALTER TABLE [name] SET SCHEMA [new_schema]" via SQL, is this what you are referring

[postgis-users] Shp2pgsql-gui, Save to schema other than public?

I see that I can run the command "ALTER TABLE [name] SET SCHEMA [new_schema]" via SQL, is this what you are referring to? Or are you suggesting an alternate way to "manually edit the schema" within the GUI that I must not be seeing...? Ryan Did you try to edit m

Re: [postgis-users] Shp2pgsql-gui, Save to schema other than public?

part de Ryan Dalton Envoyé : mardi 17 avril 2012 06:25 À : postgis-users@postgis.refractions.net Objet : [postgis-users] Shp2pgsql-gui, Save to schema other than public? I just got PostGIS 2.0 installed and was using the Shp2pgsql-gui to load some shapefiles into the database. I have created a

[postgis-users] Shp2pgsql-gui, Save to schema other than public?

I just got PostGIS 2.0 installed and was using the Shp2pgsql-gui to load some shapefiles into the database. I have created a 'data' schema where I was planning to store all of my imported data, but when I use the shapefile import GUI, it does not appear as though there is an option to specify whic

Re: [postgis-users] shp2pgsql-gui does not exist

Yes, it is working after that. Thanks a lot, On 12/04/2012 17:19, Salvatore Larosa wrote: Il giorno gio, 12/04/2012 alle 16.24 +0200, Jose Carlos Martinez ha scritto: yes but Im checking the configure out and I see some problem with GTK: checking for GTK+ - version>= 2.8.0... no *** Could not r

Re: [postgis-users] shp2pgsql-gui does not exist

Il giorno gio, 12/04/2012 alle 16.24 +0200, Jose Carlos Martinez ha scritto: > yes but Im checking the configure out and I see some problem with GTK: > checking for GTK+ - version >= 2.8.0... no > *** Could not run GTK+ test program, checking why... > *** The test program failed to compile or link.

Re: [postgis-users] shp2pgsql-gui does not exist

yes but Im checking the configure out and I see some problem with GTK: checking for GTK+ - version >= 2.8.0... no *** Could not run GTK+ test program, checking why... *** The test program failed to compile or link. See the file config.log for the *** exact error that occured. This usually means G

Re: [postgis-users] shp2pgsql-gui does not exist

On Thu, Apr 12, 2012 at 03:56:19PM +0200, Jose Carlos Martinez wrote: > Dear List, > In previous versions of PostGIS (installed from linux repository or > from source) I could find the command shp2pgsql-gui. > Now in PostGIS 2 I cant find it even when I build it from svn. > > This command does not

[postgis-users] shp2pgsql-gui does not exist

Dear List, In previous versions of PostGIS (installed from linux repository or from source) I could find the command shp2pgsql-gui. Now in PostGIS 2 I cant find it even when I build it from svn. This command does not exist anymore or Im doing something wrong? Regards, Jose ___

Re: [postgis-users] shp2pgsql-gui and option -S (Generate simple instead of MULTI geometries) / Ticket #660?

On 30/01/12 08:32, Sandro Santilli wrote: On Mon, Jan 30, 2012 at 07:40:01AM +0100, Stefan Keller wrote: 2012/1/27 Sandro Santilli: On Thu, Jan 26, 2012 at 09:50:25PM +0100, Stefan Keller wrote: ... Am I missing something? A ticket on the trac system, most likely :) So you think it's not

Re: [postgis-users] shp2pgsql-gui and option -S (Generate simple instead of MULTI geometries) / Ticket #660?

On Mon, Jan 30, 2012 at 07:40:01AM +0100, Stefan Keller wrote: > 2012/1/27 Sandro Santilli : > > On Thu, Jan 26, 2012 at 09:50:25PM +0100, Stefan Keller wrote: ... > >> Am I missing something? > > > > A ticket on the trac system, most likely :) > > So you think it's not redundant to ticket #660? O

Re: [postgis-users] shp2pgsql-gui and option -S (Generate simple instead of MULTI geometries) / Ticket #660?

So you think it's not redundant to ticket #660? Yours, Stefan 2012/1/27 Sandro Santilli : > On Thu, Jan 26, 2012 at 09:50:25PM +0100, Stefan Keller wrote: >> Hi >> >> Recent PostGIS versions come with a nifty plugin for pgAdmin3 called >> "PostGIS Shapefile and DBF Loader" (shp2pgsql-gui). I see

Re: [postgis-users] shp2pgsql-gui and option -S (Generate simple instead of MULTI geometries) / Ticket #660?

On Thu, Jan 26, 2012 at 09:50:25PM +0100, Stefan Keller wrote: > Hi > > Recent PostGIS versions come with a nifty plugin for pgAdmin3 called > "PostGIS Shapefile and DBF Loader" (shp2pgsql-gui). I see Revision > 7713 in my case. > > A common stumbling block of shp2pgsql is that Shapefile LineStri

Re: [postgis-users] shp2pgsql segment fault (trunk -r 8924 ) without .shp file

svn update, problem should be fixed now P. On Thu, Jan 26, 2012 at 12:52 PM, Min Wang wrote: > HI >   I  built the trunk version 8924  on 64 bit machine. > >   The shp2pgsql seems gave me segment fault when there is no .shp file. but > if pass -n, then it is ok. > >   Here is what I did: > >  gdb

[postgis-users] shp2pgsql segment fault (trunk -r 8924 ) without .shp file

HI I built the trunk version 8924 on 64 bit machine. The shp2pgsql seems gave me segment fault when there is no .shp file. but if pass -n, then it is ok. Here is what I did: gdb shp2pgsql (gdb) set args s 4269 -g the_geom -W latin1 ./tl_2010_11001_featnames.dbf (gdb) run Sta

[postgis-users] shp2pgsql-gui and option -S (Generate simple instead of MULTI geometries) / Ticket #660?

Hi Recent PostGIS versions come with a nifty plugin for pgAdmin3 called "PostGIS Shapefile and DBF Loader" (shp2pgsql-gui). I see Revision 7713 in my case. A common stumbling block of shp2pgsql is that Shapefile LineStrings are imported as MulitLineStrings (I'd wish the default would be the other

Re: [postgis-users] shp2pgsql - how to continue when error occurs

Hi Lauri, This is becuase PG doesn't support INSERT IGNORE/REPLACE (as in MySQL or Oracle). -Imran --- On Tue, 1/3/12, Lauri Kajan wrote: > From: Lauri Kajan > Subject: Re: [postgis-users] shp2pgsql - how to continue when error occurs > To: "PostGIS Users Discussio

Re: [postgis-users] shp2pgsql - how to continue when error occurs

etable As dup >>         GROUP BY      dup.dupcolumn1, dup.dupcolumn2, dup.dupcolum3) >> >> (http://www.postgresonline.com/journal/archives/22-Deleting-Duplicate-Records-in-a-Table.html) >> 4- Enforce UK >> >> >> -Imran >> >> >> --- On Tue,

Re: [postgis-users] shp2pgsql - how to continue when error occurs

; > -Imran > > > --- On Tue, 1/3/12, Lauri Kajan wrote: > >> From: Lauri Kajan >> Subject: [postgis-users] shp2pgsql - how to continue when error occurs >> To: postgis-users@postgis.refractions.net >> Date: Tuesday, January 3, 2012, 1:18 PM >> Hi all, &g

Re: [postgis-users] shp2pgsql - how to continue when error occurs

dup.dupcolumn1, dup.dupcolumn2, dup.dupcolum3) (http://www.postgresonline.com/journal/archives/22-Deleting-Duplicate-Records-in-a-Table.html) 4- Enforce UK -Imran --- On Tue, 1/3/12, Lauri Kajan wrote: > From: Lauri Kajan > Subject: [postgis-users] shp2pgsql - how to continue when error occur

[postgis-users] shp2pgsql - how to continue when error occurs

Hi all, I'm trying to merge multiple shapefiles to postgis table. I know that there is some duplicates in different files. I thought that I could just check duplicatiness when loading shapes with shp2pgsql. So I first created an empty table and added a unique constraint to the field that I know t

Re: [postgis-users] shp2pgsql error - current transaction is aborted...

On 12/1/2011 9:56 AM, Andy Colson wrote: On 12/1/2011 8:04 AM, jdmorgan wrote: Hello, I am attempting utilizing the shp2pgsql utility to import a shapefile.The utility reports that the shapefile is of the type MULTIPOLYGON[2] and then proceeds to through a bunch of errors for each record that i

Re: [postgis-users] shp2pgsql error - current transaction is aborted...

On 12/1/2011 8:04 AM, jdmorgan wrote: Hello, I am attempting utilizing the shp2pgsql utility to import a shapefile.The utility reports that the shapefile is of the type MULTIPOLYGON[2] and then proceeds to through a bunch of errors for each record that it can’t import “current transaction is abo

[postgis-users] shp2pgsql error - current transaction is aborted...

Hello, I am attempting utilizing the shp2pgsql utility to import a shapefile.The utility reports that the shapefile is of the type MULTIPOLYGON[2] and then proceeds to through a bunch of errors for each record that it can't import "current transaction is aborted, commands ignored until end of

Re: [postgis-users] shp2pgsql nulls

On 29/09/11 16:38, Andy Colson wrote: Oh, buggers. I had problems with this shapefile and tried several different things, and I forgot to mention an important step. Which probably takes the error out of postgis territory. See, I want to change the projection. So I ran ogr2ogr from ParcelAnnoV2

Re: [postgis-users] shp2pgsql nulls

On 9/29/2011 10:05 AM, Mark Cave-Ayland wrote: On 29/09/11 15:01, Andy Colson wrote: Hey Mark, I may have guessed wrong. I got a response from the gdal folk, who said "the null values for Date in this dbf file were indicated by a string filled with spaces". Would still be neet if something cou

Re: [postgis-users] shp2pgsql nulls

On 29/09/11 15:01, Andy Colson wrote: Hey Mark, I may have guessed wrong. I got a response from the gdal folk, who said "the null values for Date in this dbf file were indicated by a string filled with spaces". Would still be neet if something could be done so shp2pgsql could import this. The s

Re: [postgis-users] shp2pgsql nulls

On 9/29/2011 6:00 AM, Mark Cave-Ayland wrote: On 28/09/11 17:11, Andy Colson wrote: Hi List, I have a shapefile and using ogr2ogr to reproject it, then shp2pgsql to import it, but a date column has nulls in it and I'm getting invalid date errors. If I dont use ogr2ogr the nulls import fine (th

Re: [postgis-users] shp2pgsql nulls

On 28/09/11 17:11, Andy Colson wrote: Hi List, I have a shapefile and using ogr2ogr to reproject it, then shp2pgsql to import it, but a date column has nulls in it and I'm getting invalid date errors. If I dont use ogr2ogr the nulls import fine (the dest table has nulls as well). It looks like

[postgis-users] shp2pgsql nulls

Hi List, I have a shapefile and using ogr2ogr to reproject it, then shp2pgsql to import it, but a date column has nulls in it and I'm getting invalid date errors. If I dont use ogr2ogr the nulls import fine (the dest table has nulls as well). It looks like ogr2ogr is using a newer version o

Re: [postgis-users] shp2pgsql in a bash script question

tGIS Users Discussion Objet : Re: [postgis-users] shp2pgsql in a bash script question You would only have to enter the password once if you changed your script like this. #!/bin/bash ( for dir in BG CD CONCITY COUNTY COUSUB LINEARWATER PRIMARYROADS PRISECROADS RAILS ROADS STATE SUBMCD T

Re: [postgis-users] shp2pgsql in a bash script question

You would only have to enter the password once if you changed your script like this. *#!/bin/bash* * * *( * *for dir in BG CD CONCITY COUNTY COUSUB LINEARWATER PRIMARYROADS PRISECROADS RAILS ROADS STATE SUBMCD TABBLOCK* *do* *ldir="$(echo ${dir} | tr 'A-Z' 'a-z')" >> download.log* *shp2pg

Re: [postgis-users] shp2pgsql in a bash script question

Users Discussion Sent: Sat, May 7, 2011 1:12:34 PM Subject: [postgis-users] shp2pgsql in a bash script question :I have the world's dumbest question today. I am running a bash script that goes through several directories (and each of their several subdirectories) of shapefiles to run shp2pg

[postgis-users] shp2pgsql in a bash script question

:I have the world's dumbest question today. I am running a bash script that goes through several directories (and each of their several subdirectories) of shapefiles to run shp2pgsql and put them into the correct PSQL schema and table. I'd like to be able to set it and forget it, so to speak,

Re: [postgis-users] shp2pgsql - bad date formats

On Thu, Apr 14, 2011 at 12:56:33PM -0500, Jeff Dege wrote: > ERROR: date/time field value out of range: "0" > HINT: Perhaps you need a different "datestyle" setting. > > What I need is for these features to be inserted with NULL date fields, > instead of '0'. You may try to: 1) prepare the ta

[postgis-users] shp2pgsql - bad date formats

I'm trying to load a shapefile into a PostGIS database, using shp2pgsql and psql. It's failing because a couple of the sql insert statements have date fields containing '0'. ERROR: date/time field value out of range: "0" HINT: Perhaps you need a different "datestyle" setting. What I need is

Re: [postgis-users] shp2pgsql import error: invalid byte sequence forencoding "UTF8": 0x96

users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Burgholzer, Robert (DEQ) Sent: Friday, April 01, 2011 4:31 PM To: postgis-us...@refractions.net Subject: [postgis-users] shp2pgsql import error: invalid byte sequence forencoding "UTF8": 0x96 I

[postgis-users] shp2pgsql import error: invalid byte sequence for encoding "UTF8": 0x96

I am importing a file from some colleagues that is throwing an error that I have never encountered before (nor it seems, has Google).What is interesting is that this file was an update sent to me whose only supposed difference is that it is a POINT shapefile instead of a MULTIPOLYGON. The MUL

Re: [postgis-users] shp2pgsql character set conversions

On 3/12/2011 3:21 AM, Sandro Santilli wrote: On Sat, Mar 12, 2011 at 12:57:50AM -0500, Stephen Woodbridge wrote: Hi All, I am trying to load a shpfile that is in UTF8, but there is some random character that is not. This is causing a load error and rollback on the transaction. I notice looking

Re: [postgis-users] shp2pgsql character set conversions

On Sat, Mar 12, 2011 at 12:57:50AM -0500, Stephen Woodbridge wrote: > Hi All, > > I am trying to load a shpfile that is in UTF8, but there is some random > character that is not. This is causing a load error and rollback on the > transaction. > > I notice looking at: > > man 2 iconv_open > >

[postgis-users] shp2pgsql character set conversions

Hi All, I am trying to load a shpfile that is in UTF8, but there is some random character that is not. This is causing a load error and rollback on the transaction. I notice looking at: man 2 iconv_open that it is possible to add //IGNORE and/or //TRANSLIT to the tocode string. I haven't t

Re: [postgis-users] shp2pgsql encoding question

Dheeraj, Your database encoding is UTF-8. Your shape file appears to have a LATIN1 character in it. In order for the insert to work, you will need to transcode the shape file. Fortunate, shp2pgsql has a commandline option, -w. shp2pgsql -w LATIN1 -s 4326 tl_2009_us_county public.counties Happy tr

[postgis-users] shp2pgsql encoding question

Hi, everyone, I think that I can describe this as a very, very stupid encoding question. I'm getting an error in shp2pgsql about changing the encoding of the database, and when I try changing via the \encoding function, I find that the changes are not sticking. Is there a better way to do this

Re: [postgis-users] shp2pgsql

-Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Mark Cave-Ayland Sent: Wednesday, February 16, 2011 7:08 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] shp2pgsql On 16/02/11 14:29, Mehmet Erkek

Re: [postgis-users] shp2pgsql

On 16/02/11 14:29, Mehmet Erkek wrote: Hi everyone, Wishing you all a fruitful day, here is a problem we have and we are hoping to get some help: We are converting a shapefile to postgis with shp2pgsql. Conversion is done without problem. However, it produces boundaries with fewer points than

Re: [postgis-users] shp2pgsql

Hi; I prefer try also on ogr2ogr. You can find it in FwTools, you have to download it from; http://fwtools.maptools.org/ And can get help from; http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet On Wed, Feb 16, 2011 at 4:29 PM, Mehmet Erkek wrote: > Hi everyone, > > > > W

[postgis-users] shp2pgsql

Hi everyone, Wishing you all a fruitful day, here is a problem we have and we are hoping to get some help: We are converting a shapefile to postgis with shp2pgsql. Conversion is done without problem. However, it produces boundaries with fewer points than we expect, thus it produces shar

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

On 01/01/11 17:16, Paul Ramsey wrote: On 64bit machines it works. P. Does changing int to unsigned int work too? That would seem to be a more sensible change. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedo

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

Does it cause a regression for 32-bit users? Aren On Sat, Jan 1, 2011 at 11:16 AM, Paul Ramsey wrote: > On 64bit machines it works. > > P. > > On 2011-01-01, at 5:33 AM, Aren Cambre wrote: > > It was raised there 4.5 years ago: > > http://bug

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

On 64bit machines it works. P. On 2011-01-01, at 5:33 AM, Aren Cambre wrote: > It was raised there 4.5 years ago: > http://bugzilla.maptools.org/show_bug.cgi?id=1463. > > Might be nice if PostGIS maintainers could "bug" that developer about > resolution? > > The proposed local patch is cha

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

On 01/01/11 13:33, Aren Cambre wrote: It was raised there 4.5 years ago: http://bugzilla.maptools.org/show_bug.cgi?id=1463. Might be nice if PostGIS maintainers could "bug" that developer about resolution? The proposed local patch is changing int to long on three variables. While that may not

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

It was raised there 4.5 years ago: http://bugzilla.maptools.org/show_bug.cgi?id=1463. Might be nice if PostGIS maintainers could "bug" that developer about resolution? The proposed local patch is changing int to long on three variables. While that may not be graceful, could it work as a temporary

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

On 01/01/11 06:46, Paul Ramsey wrote: No workarounds. I thought there was a braindead patch on that ticket already, but it's not a patch I feel good enough to apply as a permanent fix. P. Yeah. Also since we've recently resynced with upstream shapelib, I'd much rather the issue is raised/fix

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

No workarounds. I thought there was a braindead patch on that ticket already, but it's not a patch I feel good enough to apply as a permanent fix. P. On Fri, Dec 31, 2010 at 9:49 PM, Aren Cambre wrote: > I have a DBF that's almost exactly 2 GB. I get the fseek errors as > per http://trac.osgeo.o

[postgis-users] shp2pgsql with DBF >= 2 GB?

I have a DBF that's almost exactly 2 GB. I get the fseek errors as per http://trac.osgeo.org/postgis/ticket/393 when I run *shp2pgsql* on the SHP that includes this DBF. Are there any workarounds? This 2 GB DBF is the result of opening *StratMap Trans FGDB* from http://www.tnris.org/datadownload/

Re: [postgis-users] shp2pgsql standalone?

Il 29/11/2010 09:33, Benedetto Porfidia ha scritto: > It needs only few dll to work. They should stay in the same dir. > libiconv-2.dll - ssleay32.dll - libintl-2.dll - libpq.dll - krb5_32.dll > - comerr32.dll and psql.exe pgsql2shp.exe shp.pgsql.exe > Don't know which is strictly needed, but thi

Re: [postgis-users] shp2pgsql standalone?

Il 29/11/2010 9.09, Paolo Cavallini ha scritto: Hi all. Could (or has it been) shp2pgsql be packaged in the standalone installer? Using the PostGIS Manager QGIS plugin is a very convenient way of loading layers. To be fully usable, however, users would need also the utility shp2pgsql. AFAIK, th

[postgis-users] shp2pgsql standalone?

Hi all. Could (or has it been) shp2pgsql be packaged in the standalone installer? Using the PostGIS Manager QGIS plugin is a very convenient way of loading layers. To be fully usable, however, users would need also the utility shp2pgsql. AFAIK, this cannot be installed alone on windows, but appar

Re: [postgis-users] shp2pgsql 1.5 is crashing

On 10/18/2010 5:07 AM, Sebastian E. Ovide wrote: Is there any reason why not to use gdal ogr2ogr ? Much of the time I do not need to transform the geometry so I have not loaded gdal/ogr on the system. The other reason is that I have loads of scripts that use shp2pgsql because that is all I ne

Re: [postgis-users] shp2pgsql 1.5 is crashing

Is there any reason why not to use gdal ogr2ogr ? On Thu, Oct 14, 2010 at 7:03 PM, Stephen Woodbridge wrote: > On 10/14/2010 12:02 PM, Mark Cave-Ayland wrote: > >> Stephen Woodbridge wrote: >> >> Hi all, >>> >>> I'm running into a crashing problem with shp2pgsql on 1.5 release on a >>> CentOS 5

Re: [postgis-users] shp2pgsql 1.5 is crashing

On 10/14/2010 12:02 PM, Mark Cave-Ayland wrote: Stephen Woodbridge wrote: Hi all, I'm running into a crashing problem with shp2pgsql on 1.5 release on a CentOS 5 This crashes: shp2pgsql -s 4326 -c -D Hydrants_4326.shp data.hydrants This works ok: shp2pgsql -s 4326 -c -D -N skip Hydrants_4326

Re: [postgis-users] shp2pgsql 1.5 is crashing

Stephen Woodbridge wrote: Hi all, I'm running into a crashing problem with shp2pgsql on 1.5 release on a CentOS 5 This crashes: shp2pgsql -s 4326 -c -D Hydrants_4326.shp data.hydrants This works ok: shp2pgsql -s 4326 -c -D -N skip Hydrants_4326.shp data.hydrants File loads ok in OpenEV an

[postgis-users] shp2pgsql 1.5 is crashing

Hi all, I'm running into a crashing problem with shp2pgsql on 1.5 release on a CentOS 5 This crashes: shp2pgsql -s 4326 -c -D Hydrants_4326.shp data.hydrants This works ok: shp2pgsql -s 4326 -c -D -N skip Hydrants_4326.shp data.hydrants File loads ok in OpenEV and runs through ogr2ogr witho

[postgis-users] shp2pgsql control over Z and M loading

Hi All's, I wondering if anyone has thought about adding more control over the loading of shapes with regard to Z and M values. I thinking about something like adding options to the cli: -z 0|1 -m 0|1 The behavior of these would be if they are not used then the same behavior as now. 0 - w

[postgis-users] shp2pgsql fails on malformed integer attribute

>I don't quite understand your example : > >"if the field numeric in the shapefile instead of be fill with numbers was >filled with '1', '2', '3', etc... >where the number are however not really numbers but text based, an action of >importing always 0. >Will be more confusing. The user don't und

Re: [postgis-users] shp2pgsql fails on malformed integer attribute

d conform to shapelib, which it already mostly does. At the very least, the DBF should be checked for this kind of corruption, and reported. aman From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Andrea Peri Sent: August

[postgis-users] shp2pgsql fails on malformed integer attribute

> aman.verma at mcgill.ca wrote.. >If you use shp2pgsql to upload a shapefile with an attribute table that has a malformed integer >(like a letter), shp2pgsql will not correct it, and the upload will fail. >Normally, I would view this as 'expected behaviour' (garbage in, garbage out). However, I

Re: [postgis-users] shp2pgsql fails on malformed integer attribute

Aman, Thanks for the informative post. Could you put the relevant parts and your example file into the issue tracker at http://trac.osgeo.org/postgis so we have a record of it? I can see the benefit in handling data in the "way others do" for maximum ease of use. Yours, Paul On Fri, Aug 13, 2010

[postgis-users] shp2pgsql fails on malformed integer attribute

Hi everybody, This is my first post to the list. Please let me know (flame) if this is not a suitable place to post. If you use shp2pgsql to upload a shapefile with an attribute table that has a malformed integer (like a letter), shp2pgsql will not correct it, and the upload will fail. Normal

Re: [postgis-users] shp2pgsql

f time to overcome. I applaud those who are working on them. Bob -- From: "Paragon Corporation" Sent: Friday, July 16, 2010 10:19 PM To: "'PostGIS Users Discussion'" Subject: Re: [postgis-users] shp2pgsql Bob, Copy

Re: [postgis-users] shp2pgsql

refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Bob Pawley Sent: Friday, July 16, 2010 12:46 PM To: w...@thearete.co.uk; PostGIS Users Discussion Subject: Re: [postgis-users] shp2pgsql I'm not sure what you mean by - "copy libiconv-2.dll to > libiconv2.dll.

Re: [postgis-users] shp2pgsql

I'm not sure what you mean by - "copy libiconv-2.dll to libiconv2.dll." Do you mean rename?? Bob -- From: "William Furnass" Sent: Friday, July 16, 2010 9:00 AM To: "PostGIS Users Discussion" Subject: Re:

Re: [postgis-users] shp2pgsql

n" Subject: Re: [postgis-users] shp2pgsql Bob Pawley wrote: Hi I just attempted to use shp2pgsql and received an error message about libiconv2.dll not being installed on my computer. Can anyone suggest where a clean copy can be found and instructions on how to install it?? Bob Hi Bob, It

Re: [postgis-users] shp2pgsql

Hi Bob, On 16 July 2010 16:46, Bob Pawley wrote: > > I just attempted to use shp2pgsql and received an error message about > libiconv2.dll  not being installed on my computer. If you've got PostgreSQL installed then you should already have a copy of the library. Find the 'bin' directory within

Re: [postgis-users] shp2pgsql

Bob Pawley wrote: Hi I just attempted to use shp2pgsql and received an error message about libiconv2.dll not being installed on my computer. Can anyone suggest where a clean copy can be found and instructions on how to install it?? Bob Hi Bob, It's included with the PostGIS windows i

[postgis-users] shp2pgsql

Hi I just attempted to use shp2pgsql and received an error message about libiconv2.dll not being installed on my computer. Can anyone suggest where a clean copy can be found and instructions on how to install it?? Bob___ postgis-users mailing list

Re: [postgis-users] shp2pgsql date quirk

Brian Hamlin wrote: I am importing several large shape files, into pg 8.4 postgis 1.5+ most went in fine, but the last one failed with an error regarding date fields. At least one date field entry in the shape file apparently is "0" pg complains, the conversion fails.. "Maybe you need differe

[postgis-users] shp2pgsql date quirk

I am importing several large shape files, into pg 8.4 postgis 1.5+ most went in fine, but the last one failed with an error regarding date fields. At least one date field entry in the shape file apparently is "0" pg complains, the conversion fails.. "Maybe you need different date settings" is s

Re: [postgis-users] shp2pgsql in quite mode????...(shp2pgsql -q)???

ope this helps. Nicolas De : postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] De la part de Shreerang Patwardhan Envoyé : lundi 29 mars 2010 12:44 À : Pune GNU/Linux Users Group Mailing List; PostGIS Users Discussion Objet : [postgis-us

Re: [postgis-users] shp2pgsql in quite mode????...(shp2pgsql -q)???

Shreerang Patwardhan wrote: Hey all, I do not wish to display the output of the command shp2pgsql at the terminal. I want the command to run in quite mode. But there is no -q option for shp2pgsql. How do I get around this issue? Perhaps something like: shp2pgsql ... > /dev/null or shp

[postgis-users] shp2pgsql in quite mode????...(shp2pgsql -q)???

Hey all, I do not wish to display the output of the command shp2pgsql at the terminal. I want the command to run in quite mode. But there is no -q option for shp2pgsql. How do I get around this issue? Thanx, Shreerang Patwardhan. ___ postgis-users

Re: [postgis-users] shp2pgsql

to tab1 select * from tab2; drop table tab2; HTH, Brent Wood --- On Thu, 12/10/09, MisterX wrote: > From: MisterX > Subject: [postgis-users] shp2pgsql > To: postgis-users@postgis.refractions.net > Date: Thursday, December 10, 2009, 10:23 PM > Hi, > > my problem is, that i hav

Re: [postgis-users] shp2pgsql

...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] De la part de MisterX Envoyé : jeudi 10 décembre 2009 10:23 À : postgis-users@postgis.refractions.net Objet : [postgis-users] shp2pgsql Hi, my problem is, that i have a database table with two columns with the name klassen ant

[postgis-users] shp2pgsql

Hi, my problem is, that i have a database table with two columns with the name klassen ant the_geom. In my shapefile the columns called text and the_geom. Now I want to append the shapefile on the database table, but how can I tell the shapeloader that the column text affiliate to the colum klasse

Re: [postgis-users] shp2pgsql option -k

You should be able to specify it like any of the other options. http://postgis.refractions.net/documentation/manual-1.5SVN/ch04.html#shp2pgsql_usage -- Kevin MisterX wrote: Hi everybody, I'm a question for use the shp2pgsql loader. Have anybody an example for the option -k. How can I use this

[postgis-users] shp2pgsql option -k

Hi everybody, I'm a question for use the shp2pgsql loader. Have anybody an example for the option -k. How can I use this option? Thank you very much for your answer. Greating MisterX ___ postgis-users mailing list postgis-users@postgis.refractions.net

Re: [postgis-users] shp2pgsql encoding problem - Thai Language

Thanks Mark, On 16/09/2009, at 16:30 , Mark Cave-Ayland wrote: AFAICT shp2pgsql always outputs UTF-8 encoded text whenever the input encoding is specified via the -W option. OK - I completely misunderstood that bit. Note that shp2pgsql uses its own iconv conversion routines, and not the P

Re: [postgis-users] shp2pgsql encoding problem - Thai Language

Ben Madin wrote: G'day all, I have a set of boundaries, with the locations in Thai. As best as I can tell, the encoding is ISO-8559-11 (not an official encoding, but similar to other latin/non-latin encodings) does that mean I'm stumped when it comes to importing it using shp2pgsql. I norm

Re: [postgis-users] shp2pgsql encoding problem - Thai Language

Ben Madin wrote: can tell, the encoding is ISO-8559-11 (not an official encoding, but similar to other latin/non-latin encodings) iso-8859-11 *is* an "official" encoding but depending on where you got the data, it's more likely to be windows-874 or TIS-620 codepages. or could even be mac tha

[postgis-users] shp2pgsql encoding problem - Thai Language

G'day all, I have a set of boundaries, with the locations in Thai. As best as I can tell, the encoding is ISO-8559-11 (not an official encoding, but similar to other latin/non-latin encodings) does that mean I'm stumped when it comes to importing it using shp2pgsql. I normally set -W UTF-

Re: [postgis-users] shp2pgsql not working

Ravi wrote: Hi, shp2pgsql is again not working. Just a couple of days ago I thought not using -i in the options makes it work. But in vain. shp2pgsql –D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql gives 'Access Denied'. Ravi Sorry, but if you see this with different option combinations then it's

[postgis-users] shp2pgsql not working

Hi, shp2pgsql is again not working. Just a couple of days ago I thought not using -i in the options makes it work. But in vain. shp2pgsql –D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql gives 'Access Denied'. Ravi Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. h

Re: [postgis-users] shp2pgsql Solved

Paragon Corporation wrote: Ravi, Shouldn't be. The -i in shp2pgsql is to use int4 (not the version of psql or anything of that sort). I don't believe that has changed in a while. Not quite sure how that would play a role, though could I guess if int behavior has changed between 8.2/8.4 Le

Re: [postgis-users] shp2pgsql Solved

Hi Leo, but it is a fact would like to probe why.. Data file available at http://2007.foss4g.org/workshops/W-04/data.zip bc_roads.shp Ravi --- On Wed, 29/7/09, Paragon Corporation wrote: > From: Paragon Corporation > Subject: Re: [postgis-users] shp2pgsql Solved > To: "

Re: [postgis-users] shp2pgsql Solved

al Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Ravi Sent: Tuesday, July 28, 2009 5:38 PM To: postgis Subject: Re: [postgis-users] shp2pgsql Solved Hi, shp2pgsql –i –D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql t

Re: [postgis-users] shp2pgsql Solved

Hi, shp2pgsql –i –D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql this issues an error from command prompt > Error: 'Access Denied' Removing -i makes it work.. shp2pgsql –D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql Is this because I use a much advanced Pgsql 8.3 and the exercise attempted includes p

Re: [postgis-users] shp2pgsql

It does sound like your OS username does not have write access to the current folder. Try this: echo "do I have write access?" > foo.sql If you can write to the current directory, do you have execute permissions on the shape loader?: shp2pgsql –i –D -s 3005 bc_pubs.shp bcpubs | more -- Kevin

Re: [postgis-users] shp2pgsql

gon Corporation > Subject: Re: [postgis-users] shp2pgsql > To: "'PostGIS Users Discussion'" > Date: Monday, 27 July, 2009, 6:06 AM > Ravi, > > Try specifying the full path to the .sql file.  It > sounds like its > defaulting to a location e.g the pg data folde

Re: [postgis-users] shp2pgsql

refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Ravi Sent: Sunday, July 26, 2009 6:53 PM To: postgis Subject: [postgis-users] shp2pgsql Hi, trying to create an SQL for a shape file. shp2pgsql -i -D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql this issues an error f

[postgis-users] shp2pgsql

Hi, trying to create an SQL for a shape file. shp2pgsql –i –D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql this issues an error from command prompt Error: 'Access Denied' My Vista user = Ravi PostGIS user = postgres any suggestions pl Ravi See the Web's breaking stories, chosen by people lik

  1   2   3   >