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 -- View this message in context: http://old.nabble.com/Invalid-geometry-when-using-select-AsText-tp29083589p29083589.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
