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 Nicolas Ribot-2 wrote: > >> >> I am doing a GIS project where I combine shapefiles from different >> sources, >> 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 >> using >> the postgis transform function and transforming the geometries from >> "28992"( >> Amersfoort / RD New) and "31370"(Belge 1972 / Belgian Lambert 72) to >> 900913. >> This works perfeclty, the map of the Netherlands and Belgium are >> displayed >> as they should. >> >> 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 tried transforming from 4326 to 900913 and also from 94326 to 900913 >> but >> with no luck. >> >> Has anyone ever got this problem or does anyone knows what is going on >> here? >> >> Thank you, >> >> Ramses > > Hi, > 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. > > Nicolas > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- 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. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
