[postgis-users] Invalid geometry when using select AsText

rdelisabeth ramses.elisabeth at dans.knaw.nl
Tue Jul 6 06:49:55 PDT 2010


Hey Ben, thanks for the quick reply.

This is a piece of the geometry:

"MULTIPOLYGON(((-203203.329774775 921205.762417328,-201414.754122524
920564.899066353,….etc etc etc ……..,-263950.345631436
1215368.70793936,-263772.821121782 1216068.78335908,-263784.403196605
1216749.98205891,-263958.177279213 1216452.48684392)))"

These are the values when I query AsText from the original data, and it
represents a piece of norway.

Does this mean anything to you? I will try the 32630 and get back to you.



Ben Madin-3 wrote:
> 
> Ramses,
> 
> On 06/07/2010, at 17:37 , rdelisabeth wrote:
> 
>> My problem is the following. I also have some data from my colleagues
>> from
>> Spain. Their data supposedly is in "WGS1984" epsg "4326". So I
>> transformed
>> 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 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 wonder if you have data from a UTM Grid - do the values look like
> reasonable longitude and latitude values (in degrees) for Spain. I'm on
> the wrong side of the planet to be sure what is right, but if you have any
> values greater than about 45, I think you probably have WGS84 UTM values,
> which would be in the 10's to 100's of thousands.
> 
> instead of 4326 try something like 32630... just a guess.
> 
> cheers
> 
> Ben
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://old.nabble.com/Invalid-geometry-when-using-select-AsText-tp29083589p29085580.html
Sent from the PostGIS - User mailing list archive at Nabble.com.




More information about the postgis-users mailing list