[postgis-users] Invalid geometry when using select AsText

[Nicolas Ribot]

> 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
> 900913.
>
> "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)))"
>
> btw this is a piece the geometry of norway.
>
> greetz...Ramses

These coordinates do not correspond to WGS84 (long-lat, values between
-180, +180 for longitudes, -90, +90 for latitude).
Maybe try to find a SRID for Norway (spatialreference.org may help for that)

Nicolas