Re: [postgis-users] pgsql2shp dbf file encoding

2010-10-25 Thread Mark Cave-Ayland
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

Re: [postgis-users] pgsql2shp dbf file encoding

2010-10-25 Thread Francis Markham
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

[postgis-users] WKT Raster Error

2010-10-25 Thread Andreas Forø Tollefsen
Anyone familiar with the below error? I have never experienced it before when importing rasters: C:\Python25c:\Python25\python c:\wktraster_pg84\bin\gdal2wktraster.py -r c:\pri o_grid\source\forest\fcworld.img -t forest -s 4326 -I C:\prio_grid\source\gpw\ forest.sql

Re: [postgis-users] pgsql2shp dbf file encoding

2010-10-25 Thread Denis Rykov
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

Re: [postgis-users] pgsql2shp dbf file encoding

2010-10-25 Thread Mark Cave-Ayland
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

Re: [postgis-users] pgsql2shp dbf file encoding

2010-10-25 Thread Paul Ramsey
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

Re: [postgis-users] pgsql2shp dbf file encoding

2010-10-25 Thread Denis Rykov
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,

Re: [postgis-users] pgsql2shp dbf file encoding

2010-10-25 Thread Paul Ramsey
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

Re: [postgis-users] pgsql2shp dbf file encoding

2010-10-25 Thread Denis Rykov
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

Re: [postgis-users] WKT Raster Error

2010-10-25 Thread Paragon Corporation
Andreas, Nope haven't seen that error before. I take it this used to work for you - gdal2wtraster.py. Which version of gdal are you running under python? FWIW -- we don't run it like that -- we run with the -o output file swithin. I'm not sure the way you are running it works or not So try