Not simply. I am receiving data from many different places, some places
send nice clean data, other's, not so much (all in different projections
which is why I'm trying to find a common ground). I have hundreds of
shapefiles, with many times that of columns, any one of which may have
nulls in it.
I could write something but I was hoping I could just get ogr2ogr fixed
so my life would be simpler. (I have other things at work I need to be
spending my time on, ya know?)
-Andy
On 9/28/2011 10:13 AM, Ivan Price wrote:
and you don't want to set the nulls to blank 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...@squeakycode.net]
Envoyé : Wednesday, 28 September 2011 5:09 PM
À : Ivan Price
Cc : gdal-dev@lists.osgeo.org
Objet : Re: [gdal-dev] PostgreSQL
They use a slightly older version of shapelib that doesnt quite work with null's.
If I ogr2ogr shapefile -> shapefile (to get it in the projection I want), then
shp2pgsql will fail with fields that are null.
Which, I could to ask them to update, yes. It was a 50/50. Ask gdal or ask
postgis.
-Andy
On 9/28/2011 9:53 AM, Ivan Price wrote:
is there a reason you don't want to use shp2pgsql ?
not sure if its better for everything but i've used it on occasion
when i had a prob in ogr2ogr
-i
-----Message d'origine-----
De : gdal-dev-boun...@lists.osgeo.org
[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/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 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: "0000/00/00"
CONTEXT: COPY parcelannov2, line 18, column recorded: "0000/00/00"
Inserts are really slow, so I'd love to use copy instead.
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:
"1005965403.24000000954"
I'm using: GDAL 1.9dev, released 2011/01/18
I can make the shapefiles available if it would be of help. Is there
anything else I can do/try/offer?
Thanks,
-Andy
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
