Re: [gdal-dev] Call to users and devs - ESRI .prj files needed for testing

2011-12-01 Thread Andy Colson
On 12/1/2011 12:48 PM, Etienne Tourigny wrote: Hi all, As an ongoing effort to improve ESRI .prj file compatibility, I am respectfully calling all users and devs to help in providing or pointing to existing .prj files (in ESRI WKT format). I have 2,400 .prj files, but most of them are probably

Re: [gdal-dev] PostgreSQL [RESOLVED]

2011-09-29 Thread Andy Colson
On 9/29/2011 11:28 AM, Even Rouault wrote: Selon Andy Colson: On 9/29/2011 1:36 AM, Even Rouault wrote: Le mercredi 28 septembre 2011 21:28:26, Even Rouault a écrit : Le jeudi 22 septembre 2011 17:48:29, Andy Colson a écrit : Hi List, I'm using ogr2ogr to convert (and reproject) data

Re: [gdal-dev] PostgreSQL

2011-09-29 Thread Andy Colson
On 9/29/2011 1:36 AM, Even Rouault wrote: Le mercredi 28 septembre 2011 21:28:26, Even Rouault a écrit : Le jeudi 22 septembre 2011 17:48:29, Andy Colson a écrit : Hi List, I'm using ogr2ogr to convert (and reproject) data from shapefile to PG, if I use insert statements the null date

Re: [gdal-dev] PostgreSQL

2011-09-28 Thread Andy Colson
On 9/28/2011 2:28 PM, Even Rouault wrote: > > On another layer, regardless of insert/copy, I'm getting: > > ERROR: numeric field overflow > DETAIL: A field with precision 19, scale 11 must round to an absolute > value less than 10^8. > CONTEXT: COPY poltwppoly, line 1, column shape_area:

Re: [gdal-dev] PostgreSQL

2011-09-28 Thread Andy Colson
Would a 16Meg .zip file, that extracts to 157Meg, be acceptable in Trac? I attempted to copy some records out, but it created the new shapefile with a type of ftString instead of ftDate. -Andy On 9/28/2011 2:28 PM, Even Rouault wrote: Le jeudi 22 septembre 2011 17:48:29, Andy Colson a écrit

Re: [gdal-dev] PostgreSQL

2011-09-28 Thread Andy Colson
ank text before uploading ? (you could set them back once they'r up there, as well as perform the reprojection). i've never tried to use nulls in shapes before. can sqllite be used as an intermediatry instead ? -i -Message d'origine- De : Andy Colson [mailto:a...@squeakyco

Re: [gdal-dev] PostgreSQL

2011-09-28 Thread Andy Colson
g [mailto:gdal-dev-boun...@lists.osgeo.org] De la part de Andy Colson Envoyé : Wednesday, 28 September 2011 4:50 PM À : gdal-dev@lists.osgeo.org Objet : Re: [gdal-dev] PostgreSQL Sorry to keep pestering. Is there a better place I should be seeking help? Would a $bounty$ help? -Andy On 9/22/201

Re: [gdal-dev] PostgreSQL

2011-09-28 Thread Andy Colson
Sorry to keep pestering. Is there a better place I should be seeking help? Would a $bounty$ help? -Andy On 9/22/2011 10:48 AM, Andy Colson wrote: Hi List, I'm using ogr2ogr to convert (and reproject) data from shapefile to PG, if I use insert statements the null dates are not a pr

Re: [gdal-dev] PostgreSQL

2011-09-26 Thread Andy Colson
On Thu, Sep 22, 2011 at 9:18 PM, Andy Colson mailto:a...@squeakycode.net>> wrote: Hi List, I'm using ogr2ogr to convert (and reproject) data from shapefile to PG, if I use insert statements the null dates are not a problem, but if I set PG_USE_COPY=YES, then I get errors:

[gdal-dev] PostgreSQL

2011-09-22 Thread Andy Colson
Hi List, I'm using ogr2ogr to convert (and reproject) data from shapefile to PG, if I use insert statements the null dates are not a problem, but if I set PG_USE_COPY=YES, then I get errors: ERROR 1: COPY statement failed. ERROR: date/time field value out of range: "/00/00" CONTEXT: COP