[postgis-users] Invalid geometry when using select AsText
ramses.elisabeth at dans.knaw.nl
Tue Jul 6 06:45:52 PDT 2010
Thanks for the quick response,
This is a extract of the query AsText from the original column(before
transformation) This srid is suposed to be 4326 and I want to make it
920564.899066353,….etc etc etc ……..,-263950.345631436
btw this is a piece the geometry of norway.
Nicolas Ribot-2 wrote:
>> I am doing a GIS project where I combine shapefiles from different
>> created with different spatial reference systems.
>> What I want to achieve is that if someone has a shapefile, no matter what
>> the srs is, the data can be combined with other data. All data will be
>> tranformed to srid 900913.
>> I succeeded in combining data from my Dutch and Belgian colleagues by
>> the postgis transform function and transforming the geometries from
>> Amersfoort / RD New) and "31370"(Belge 1972 / Belgian Lambert 72) to
>> This works perfeclty, the map of the Netherlands and Belgium are
>> as they should.
>> My problem is the following. I also have some data from my colleagues
>> Spain. Their data supposedly is in "WGS1984" epsg "4326". So I
>> it to 900913 as I did with my other data. So far so good. BUT when I do a
>> SELECT AsText from one of the geometries I get the following:
>> "MULTIPOLYGON(((inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf
>> inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf
>> ...etc etc ... inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf
>> inf,inf inf,inf inf),(inf inf,inf inf,inf inf,inf inf,inf inf)))"
>> I think this means that the geometry is invalid. When I read it from my
>> application using Hibernate spatial I get an error like invalid geometry.
>> I tried transforming from 4326 to 900913 and also from 94326 to 900913
>> with no luck.
>> Has anyone ever got this problem or does anyone knows what is going on
>> Thank you,
> What the spain data look like ? Could you post some extract of it (astext)
> It seems the data range is not compatible with WGS84, thus generating
> invalid coordinates when transformed.
> postgis-users mailing list
> postgis-users at postgis.refractions.net
View this message in context: http://old.nabble.com/Invalid-geometry-when-using-select-AsText-tp29083589p29085540.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
More information about the postgis-users