[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