"POLYGON EMPTY" when using ST.Transform

Jul 10, 2007 at 3:46 PM

I am trying to import a shapefile from Ordnance Survey (http://www.ordnancesurvey.co.uk/oswebsite/products/codepointpolygons/techinfo.html) and transform it to WGS84 coordinates:

SELECT st.astext(st.transform(thegeom, 4326)) FROM SAREGION

During import I'm setting the source SRID to 27700, which I think is correct. I've also tried using the details in the .prj file and adding a record to the SPATIALREFSYS table and importing that way.

In every case I get "POLYGON EMPTY" OR "MULTIPOLYGON EMPTY" and I can't figure out why.

Can anyone help?

Thanks, Paul.
Jul 11, 2007 at 6:05 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.