On Thu, Jul 05, 2012 at 01:39:16PM +0800, Ben Madin wrote:
G'day all,
I'm having a problem exporting data from a utf8 database to shape files for a
client. They are receiving the data and viewing it only to find that
characters with diacritics are all messed up.
Does their system support
G'day all,
I'm having a problem exporting data from a utf8 database to shape files for a
client. They are receiving the data and viewing it only to find that characters
with diacritics are all messed up.
My understanding was that .dbf was originally ascii only (and the column
headings still
Hello,
When I run pgsql2shp like so:
pgsql2shp -u plm25 -g the_geom database table
I get the following output:
Xcolumn number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of
On 03/07/12 07:14, James Sewell wrote:
Hello,
When I run pgsql2shp like so:
pgsql2shp -u plm25 -g the_geom database table
I get the following output:
Xcolumn number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is
Hi,
I have some issues with pgsql2shp.
I am using postgis 1.5.3 over postgresql 9.0 on windows.
The database I am working with is utf8.
I have several spatial tables and I want some of them to be exported to
a shape file.
pgsql2shp seems to be working fine but when I load the generated shape
On 01/12/11 08:32, toni hernández wrote:
Hi,
I have some issues with pgsql2shp.
I am using postgis 1.5.3 over postgresql 9.0 on windows.
The database I am working with is utf8.
I have several spatial tables and I want some of them to be exported to
a shape file.
pgsql2shp seems to be working
Mark,
No, I haven't.
Right now I am preparing some material for a course and I need some
stable release but I'll keep that in mind.
Thanks.
On 01/12/2011 11:50, Mark Cave-Ayland wrote:
It's had a fairly hefty rewrite
___
postgis-users mailing
have you do this?
createlang plpgsql mydatabase
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Yes:
createlang: language plpgsql is already installed in database
I thought that this was required for a PostGIS-enabled database anyway..?
It is a very straightforward database: two tables imported from
shapefiles with shp2pgsql:
# \dt
List of relations
Schema |
Hi all,
When using the pgsql2shp the gid column is not included.
I even tried typing a select gid AS g_id to include it as a different
column name, but this did not work.
My syntax: pgsql2shp -f pgfinal2008.shp -h localhost -u user -P pass postgis
public.pgfinal2008 SELECT *, gid as g_id FROM
Denis Rykov wrote:
After editing dbf file in hex editor and set value at byte 29 to 00h
shapefile opens in ArcGIS without
encoding troubles (get codepage value from *.cpg file).
That's strange. Does anyone know what the behaviour of the
psDBF-iLanguageDriver field should be in terms of how
Andreas Forø Tollefsen wrote:
Hi all,
When using the pgsql2shp the gid column is not included.
I even tried typing a select gid AS g_id to include it as a different
column name, but this did not work.
My syntax: pgsql2shp -f pgfinal2008.shp -h localhost -u user -P pass
postgis
Hi,
I tried that, but at first it did not seem to work when loading the
shapefile into ArcGIS.
However, it seems that i had to restart ArcGIS to make it update the
attribute table for the file.
Now -r works.
Thanks.
Andreas
2010/10/26 Mark Cave-Ayland mark.cave-ayl...@siriusit.co.uk
Andreas
Denis Rykov wrote:
Try to export postgis data to shapefiles with pgsql2shp
(pgsql2shp-core.h 5870 2010-08-28 09:16:32Z mcayland)
If open *.dbf file I see the value in my dbf files at byte 29 is 0x57h.
Is the 0x57h value is default? Why not 0x00h?
With 0x57h encoding my shapefiles looks not
0x57h is the dreaded Windows-1252 codepage. I believe new versions of
shapelib allow this to be set when the shapefile is created.
Cheers,
Francis Markham
On 25 October 2010 20:05, Mark Cave-Ayland
mark.cave-ayl...@siriusit.co.uk wrote:
Denis Rykov wrote:
Try to export postgis data to
I don't quite understand why pgsql2shp is writing this encoding to our
shapes, our database is in UTF-8 and we never use win1252
On Mon, Oct 25, 2010 at 5:42 PM, Francis Markham fmark...@gmail.com wrote:
0x57h is the dreaded Windows-1252 codepage. I believe new versions of
shapelib allow this
Denis Rykov wrote:
I don't quite understand why pgsql2shp is writing this encoding to our
shapes, our database is in UTF-8 and we never use win1252
Well pgsql2shp has never contained any code to set the encoding field
(mainly because until recently the version of shapelib included with
And that DBF field dates from the Time Before UTF-8, so there won't be
a UTF8 number to put in it, in any event. DBF files with UTF in
them (OSM!) are scary scary scary (for example, should your code for
reading a CHAR(8) field in DBF expect 8 bytes, or 8 characters? yay!)
It would be nice to
Will it make sense to set 0 as a default? In the current case some software
(ArcGIS) does not override correct CPG setting with obviously incorrect 1252
from the header.
On Tue, Oct 26, 2010 at 12:03 AM, Paul Ramsey pram...@opengeo.org wrote:
And that DBF field dates from the Time Before UTF-8,
Can you hexedit it and see if it works better?
On Mon, Oct 25, 2010 at 10:25 AM, Denis Rykov ryk...@gmail.com wrote:
Will it make sense to set 0 as a default? In the current case some software
(ArcGIS) does not override correct CPG setting with obviously incorrect 1252
from the header.
On
After editing dbf file in hex editor and set value at byte 29 to 00h
shapefile opens in ArcGIS without
encoding troubles (get codepage value from *.cpg file).
On Tue, Oct 26, 2010 at 12:30 AM, Paul Ramsey pram...@opengeo.org wrote:
Can you hexedit it and see if it works better?
On Mon, Oct
Try to export postgis data to shapefiles with pgsql2shp (pgsql2shp-core.h
5870 2010-08-28 09:16:32Z mcayland)
If open *.dbf file I see the value in my dbf files at byte 29 is 0x57h. Is
the 0x57h value is default? Why not 0x00h?
With 0x57h encoding my shapefiles looks not correct in any GIS
Woodbridge wood...@swoodbridge.com
Sent: Sunday, October 10, 2010 11:14 AM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] pgsql2shp
On 10/10/2010 1:52 PM, Bob Pawley wrote:
Hi
I am using the following
pgsql2shp -f Test.shp -u postgres -P London2342 -k PDW p_id.image -g
To: PostGIS Users Discussion postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] pgsql2shp
As far as I know, all versions of pgsql2shp work just fine on Win7,
and they should do exactly what they are documented to do for the
situation you describe. What exactly are your problems
: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Bob
Pawley
Sent: Monday, October 11, 2010 6:26 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] pgsql2shp
The reason I asked is that I had tyo upgrade pgdump in order to get
Hi
I am using the following
pgsql2shp -f Test.shp -u postgres -P London2342 -k PDW p_id.image -g the_geom
to export a shape file from postgis.
Even tho I specify a single geometry column to be exported I get warnings that
column names have been truncated.
Command prompt also informs me that
On 10/10/2010 1:52 PM, Bob Pawley wrote:
Hi
I am using the following
pgsql2shp -f Test.shp -u postgres -P London2342 -k PDW p_id.image -g
the_geom
to export a shape file from postgis.
Even tho I specify a single geometry column to be exported I get
warnings that column names have been truncated.
: Sunday, October 10, 2010 11:14 AM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] pgsql2shp
On 10/10/2010 1:52 PM, Bob Pawley wrote:
Hi
I am using the following
pgsql2shp -f Test.shp -u postgres -P London2342 -k PDW p_id.image -g
the_geom
to export a shape file from postgis
strk wrote:
Perhaps we could touch the pgsql2shp-core.h file but that just seems
messy :(
Why drop the feature ?
If we want a true repository revision we should provide
that in an header file (which we'd touch) and use that when
we see fit. I wouldn't drop the file-specific one though,
you
On Fri, Sep 10, 2010 at 02:31:52PM +0100, Mark Cave-Ayland wrote:
This appears to be a feature of SVN in that the revision number
embedded in the file is the last revision that altered that particular
file, and not the latest revision of the whole repository. Since we
store the revision
Denis Rykov wrote:
Is the pgsl2shp show correct SVN version of revision?
After updated pgsql2shp from svn and start pgsql2shp without options I get:
RCSID: $Id: pgsql2shp-core.h 5870 2010-08-28 09:16:32Z mcayland $
RELEASE: 2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
But last SVN revision
Is the pgsl2shp show correct SVN version of revision?
After updated pgsql2shp from svn and start pgsql2shp without options I get:
RCSID: $Id: pgsql2shp-core.h 5870 2010-08-28 09:16:32Z mcayland $ RELEASE:
2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
But last SVN revision number is not 5870.
Yes, I convert my data using the following command UPDATE osm_line SET way
= ST_Multi(way) where geometrytype(way) = 'LINESTRING'.
time psql -U pgsql -d osm -c UPDATE osm_line SET way = ST_Multi(way) where
geometrytype(way) = 'LINESTRING';
UPDATE 914007
real 70m12.384s
user 0m0.009s
sys
Hi, I have a PostGIS table with Polygonal and Multi Polygonal types
of geometry.
I used the pgsql2shp last year and had no problems. But some days ago
I've update pgsql2shp from svn.
And now I can't convert my PostGIS data into shapefile because I get
an error : ERROR: Mixed geometry types in
I've tried to convert all my geometries to MULTI* with ST_Multi()
function but it works very slowly.
2010/9/5 Denis Rykov ryk...@gmail.com:
Hi, I have a PostGIS table with Polygonal and Multi Polygonal types
of geometry.
I used the pgsql2shp last year and had no problems. But some days ago
On 9/5/2010 10:16 PM, Denis Rykov wrote:
I've tried to convert all my geometries to MULTI* with ST_Multi()
function but it works very slowly.
2010/9/5 Denis Rykovryk...@gmail.com:
Hi, I have a PostGIS table with Polygonal and Multi Polygonal types
of geometry.
I used the pgsql2shp last year
Thanks! It works fine now.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Denis Rykov wrote:
Result of \d public.results in psql:
Table public.results
Column | Type | Modifiers
--+---+---
the_geom | geometry |
reg | character(16) |
Thanks for the bug report - should be fixed in latest SVN. Can you do an
svn
Hello, Regina. There is information about my system:
1) RCSID: $Id: pgsql2shp-core.h 5646 2010-05-27 13:19:12Z pramsey $
RELEASE: 2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
2) pgsql2shp -f $dir_output/bounds/bnd-a-osm-buf.shp -U pgsql -d osm
public.results
3) PostgreSQL 8.4
4) 2.0 r5830
5) FreeBSD 8.1
Denis Rykov wrote:
Hello, Regina. There is information about my system:
1) RCSID: $Id: pgsql2shp-core.h 5646 2010-05-27 13:19:12Z pramsey $
RELEASE: 2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
2) pgsql2shp -f $dir_output/bounds/bnd-a-osm-buf.shp -U pgsql -d osm
public.results
3) PostgreSQL 8.4
4)
Hi Jeff,
Thanks for your reply.
The data was correct when I just used the table name.
I have tried working with just the integer but I was still getting similar
errors.
I decided to just use a temp table, update that with a normal query and
output the temp table as the shapefile.
Thanks for
Thanks for the replies, the most promising command so far is:
pgsql2shp -f [path] -h [myhost] -p [port] -u [user] -P [password] [database]
SELECT * FROM table1 WHERE 'ID' '20'
Which has the output:
Preparing table for user query... Done.
Initializing... WARNING: Cannot determine spatial
Did you verify that the data in the shapefile is correct when you run the
command with just the table name?
Hang on a second... WHERE 'ID' '20' is never true. That's why you're
getting an empty table. 'ID' is a string, as is '20'. I think you mean to
say where your ID column value is less
Update: The error is the same whether the column id is lower case or
uppercase.
Using single quotes 'id' produces a different error. Possibly an
improvement:
ERROR: Cannot determine geometry type (empty table).
The dump works fine when a table is specified and there is no query, however
there
This doesn't explain or fix anything, but you could try using a temp table:
create table temp_for_export as select * from table1 where id '20'
Then
pgsql2shp -f [path] -h [myhost] -p [port] -u [user] -P [password] [database]
temp_for_export
and see what that does.
Is there any chance your
Hello, I am trying to output a shapefile from PostGIS using a command with
the following format:
pgsql2shp -f [path] -h [myhost] -p [port] -u [user] -P [password] [database]
SELECT * FROM table1 WHERE id '20'
But I receive the following error:
Preparing table for user query... Failed: ERROR:
: Monday, January 11, 2010 2:23 AM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] pgsql2shp usage
Hi,
Many thanks to all of you for bothering to reply !!
From Chris Hermansen
Anisha, why are you converting to shape file?
I failed to load the map directly from the database
Ok well it seems to me that your second step, namely pgsql2shp, is not
necessary if you have no use for a shape file in the end. So let's
focus on your osm2pgsql command
In your first e-mail, you said:
I downloaded an OSM map file namely india.osm.bz2.
I transported it in PostgreSQL
Hi,
Many thanks to all of you for bothering to reply !!
From Chris Hermansen
Anisha, why are you converting to shape file?
I failed to load the map directly from the database !
So I thought it will be a boostup for me if I manage to load the map from a
shape file, and then I can go for the
Hi,
Many thanks to all of you for bothering to reply !!
From Chris Hermansen
Anisha, why are you converting to shape file?
I failed to load the map directly from the database !
So I thought it will be a boostup for me if I manage to load the map from a
shape file, and then I can go for the
Hi,
The data was missing in my previous mails i.e.
http://postgis.refractions.net/pipermail/postgis-users/2010-January/025560.html
Many thanks to all of you for bothering to reply !!
Chris Hermansen wrote:
Anisha, why are you converting to shape file?
I failed to load the map directly from
Hello to all,
I hope this is the right mailing lists w.r.t pgsql2shp.
I downloaded an OSM map file namely india.osm.bz2.
I transported it in PostgreSQL database gis with the command :
./osm2pgsql -m -d gis india.osm.bz2
The above command resulted in the creation of the following tables filled
] On Behalf Of Anisha
Kaul
Sent: Saturday, January 09, 2010 7:37 AM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] pgsql2shp usage
Hello to all,
I hope this is the right mailing lists w.r.t pgsql2shp.
I downloaded an OSM map file namely india.osm.bz2.
I transported
-
From: Anisha Kaul anisha.k...@hitechroboticsystemz.com
Date: Sat, 9 Jan 2010 18:06:34
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] pgsql2shp usage
Hello to all,
I hope this is the right mailing lists w.r.t pgsql2shp.
I downloaded an OSM map file namely india.osm.bz2
I've tried to fix the problem with the left padding, too.
The resulting shape files open cleanly in ArcGIS and gvSIG. Also
inspection with a tool from Borland, (Database Desktop) has no
complaints about those files.
This patch inclued your fix about the rapprsentation of tha NULL date.
I've placed a ticket on this with a patch
http://trac.osgeo.org/postgis/ticket/321
If you would try and patch and see if it creates files that are more
broadly usable, that would be nice.
Thanks,
Paul
On Fri, Nov 27, 2009 at 5:28 AM, Peter Hopfgartner
peter.hopfgart...@r3-gis.com wrote:
Hi,
gvSIG opens the generated shape file without any complaint and Excel
behaves as expected.
Thanks!
Peter
(tested with PostGIS 1.4/PostgreSQL 8.2/CentOS 5.4)
Paul Ramsey wrote:
I've placed a ticket on this with a patch
http://trac.osgeo.org/postgis/ticket/321
If you would try and patch
Hi all!
I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
database. I want my shapefile to be encoded in WIN1252, and a particular
field to be in uppercase.
Since I am on windows, I don't have an iconv executable. Therefore, I am
trying to :
- dump the shapefile with
Does that last query (invoking the upper() function) actually run well when
executed in pgsql console?
Rob
2009/10/16 Arnaud Lesauvage arnaud.lis...@codata.eu
Hi all!
I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
database. I want my shapefile to be encoded in
InterRob a écrit :
Does that last query (invoking the upper() function) actually run well when
executed in pgsql console?
Hi Rob.
No, if I issue a SET client_encoding TO win1252; before running
SELECT upper(myfield) FROM mytable, I get the same error.
Arnaud
Hi all,
I tend to keep all my databases in UTF8, and I just had an occasion
where I needed to dump a postGIS table as LATIN1. Much to my surprise I
found that pgsql2shp does not appear to have an option to set the client
encoding.
This might already have a ticket, haven't looked yet.
Any
Setting an environment variable should do the trick, but a commandline
option would be an improvement
Sent from my iPod
On 25-Jan-09, at 10:33 AM, Stephen Woodbridge
wood...@swoodbridge.com wrote:
Hi all,
I tend to keep all my databases in UTF8, and I just had an occasion
where I
Hi all,
maybe this is an old issue... I´m trying to export to shapefile some
geometries, but in the result shapefile varchar fields greater than 255 are
cutted at this point. I´ve got alternatives but i´d like to know : is there any
method to export those fields directly with pgsql2shp or
...@postgis.refractions.net] On Behalf Of Gustavo Ces
Sent: Thursday, December 18, 2008 10:53 AM
To: PostGIS Users Discussion
Subject: [postgis-users] pgsql2shp cuts varchar fields
Hi all,
maybe this is an old issue... I´m trying to export to shapefile some
geometries, but in the result shapefile varchar fields
-
From: Obe, Regina
To: PostGIS Users Discussion
Sent: Thursday, December 18, 2008 5:08 PM
Subject: RE: [postgis-users] pgsql2shp cuts varchar fields
Not absolutely sure, but I think its a limit in the spec. I think fields
254 are considered to be memo fields in the dbf world and so
Message-
From: postgis-users-boun...@postgis.refractions.net on behalf of David Fawcett
Sent: Thu 12/18/2008 12:32 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] pgsql2shp cuts varchar fields
Other things that you may notice when exporting to shape is that field
names may
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On
Behalf Of David Fawcett
Sent: Thursday, December 18, 2008 9:33 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] pgsql2shp cuts varchar
RE: [postgis-users] pgsql2shp cuts varchar fieldsHi,
finally i´ve have done two varchar fields from original one and using both
fields in mapbook and the result is not so strange ... thanks for your help and
info!
Gus
- Original Message -
From: Obe, Regina
To: PostGIS Users
Hello postgis users,
I frequently have a problem when running the pgsql2shp dumper whereby
the program is executed but it does not actually complete. It only
creates an empty shapefile. The Dumping output indicates only a single
X, as shown below:
C:\Program
Murray Richardson wrote:
Hello postgis users,
I frequently have a problem when running the pgsql2shp dumper whereby
the program is executed but it does not actually complete. It only
creates an empty shapefile. The Dumping output indicates only a single
X, as shown below:
C:\Program
You need to look when You are using UPPERCASE options beacuse that matters :)
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
@postgis.refractions.net
Subject: [postgis-users] pgsql2shp help
Greetings. I am VERY new to all of this and teaching myself, but I am
attempting to convert one of the tables back to an ESRI shapefile using
the following:
pgsql2shp -f d:/shapefiles/dara -p 5432 -U dara -g the_geom postgis
invspp
[postgis
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Burgholzer,Robert
Sent: Friday, October 31, 2008 4:01 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] pgsql2shp help
Dara,
I think that it might have a problem with your file path. As I think the
previous respondent
:[EMAIL PROTECTED] On Behalf Of
Burgholzer,Robert
Sent: Friday, October 31, 2008 4:01 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] pgsql2shp help
Dara,
I think that it might have a problem with your file path. As I think the
previous respondent was indicating, it may work OK
Thanks guys! nicely done! Worked fine!!
:jumping::clap:
SenTnel wrote:
Thanks again Kishor!
The situation is that I work at a Truck Company and we keep a gps vehicle
location service using geoserver and openlayers, our shapefiles were
converted to postgis to be able to display the maps
Hi! Im working with postgres and geoserver but im just not good at sql
statements, none the less in construction sentences in postgres, and I would
like to create a shapefile from a table in postgres and don't want to make a
costly mistake, so if you help me achieve this using pgsql2shp:
SenTnel wrote:
Hi! Im working with postgres and geoserver but im just not good at sql
statements, none the less in construction sentences in postgres, and I would
like to create a shapefile from a table in postgres and don't want to make a
costly mistake, so if you help me achieve this using
Thanks Stephen!
I must admit that Im not good at this, but Im determined to mantain my
city's database correcting names and roads classifications, etc., that's why
I need to take the postgres data and convert it to shapefile, then correct
things with arcmap, then drop the old postgres data and
On 6/2/08, SenTnel [EMAIL PROTECTED] wrote:
Thanks Stephen!
I must admit that Im not good at this, but Im determined to mantain my
city's database correcting names and roads classifications, etc., that's why
I need to take the postgres data and convert it to shapefile, then correct
On 6/2/08, SenTnel [EMAIL PROTECTED] wrote:
Thanks Kishor!
If you are not changing the geometry, you can do all your attribute
updates as simple SQL updates
Some changes are just name corrections, but I need also update the maps with
new streets and roads, and that is the most
Thanks again Kishor!
The situation is that I work at a Truck Company and we keep a gps vehicle
location service using geoserver and openlayers, our shapefiles were
converted to postgis to be able to display the maps with the vehicle's
positions.
=)
P Kishor-3 wrote:
On 6/2/08, SenTnel
81 matches
Mail list logo
