I would like to store a polygon as a set of 2D points represented as x, y coordinates of a Cartesian coordinate system.

Which spatial reference can I use? Looking at my spatial_ref_sys table, all the spatial references seem to be geography related.

The points of the polygon would represent satellite measurements which I would invoke ST_ConvexHull on to get the shape of the satellite footprint.

  • You could just keep the srid as -1. Jun 24 '13 at 9:06
  • Are you sure I could store points with an invalid SRID? I don't think that the ST_ConvexHull function would work.
    – Zoltán
    Jun 24 '13 at 9:15
  • I have just tested with a layer having srid=-1, and ST_ConvexHull can be used without any issues. Jun 24 '13 at 9:51

If you do no reprojection with the data, it does not really matter what projected CRS you are using.

You can use EPSG:3857 (Google Mercator), if your data does not exceed the bounds of


(Not sure what happens if the data is outside those bounds)

  • Yes, I ended up deciding to use something like this, only I chose EPSG:3395 (World Mercator). Any reason why I should prefer Google Mercator? My positions are in the range -250000 to 250000, so I should be safe.
    – Zoltán
    Jun 24 '13 at 11:46
  • EPSG:3395 should do as well.
    – AndreJ
    Jun 24 '13 at 11:53

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.