I'm trying to create a Postgis geometry from GML using ST_GeomFromGML. It results in an error message "unknown spatial reference system".

The GML has been created by Oracle function sdo_util.to_gml311geometry and looks like this:

<gml:Polygon srsName="SDO:28992" xmlns:gml="http://www.opengis.net/gml">
         <gml:posList srsDimension="2">...</gml:posList>

srsName SDO:28992 refers to the Oracle SRID 28992. What should I put in the GML so that PostGis understands this?

  • 1
    Does it have an equivalent in EPSG codes?
    – user30184
    Dec 16 '16 at 14:42
  • It should be EPSG:28992, Amersfoort / RD New. I have not see any WKIDs in Oracle's set that aren't the same as EPSG's, but Oracle does have their own definitions with their own range of values for the WKIDs.
    – mkennedy
    Dec 16 '16 at 23:45
  • 1
    I would try first by editing the GML to have "EPSG:28992" instead of "SDO:28992".
    – user30184
    Dec 19 '16 at 7:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.