PostGIS spatial reference ID (SRID) for regular cartesian coordinate system?

Question

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.

I think you're lost ;-) . http://gis.stackexchange.com/ ? – Craig Ringer Jun 24 '13 at 08:16 — Craig Ringer, Jun 24 '13 at 08:16

score 1 · Answer 1 · answered Jun 24 '13 at 08:16

1

You don't have to store all data as geography related unless you will use specail postgis functions. You can store your cartesian point's x,y values as varchar or some other type available at postgres.

answered Jun 24 '13 at 08:16

Cihat Kahramna

11
1

Thanks, but as I stated in the last point of my question, I would invoke `ST_ConvexHull` on these points, which is in fact a special postgis function. – Zoltán Jun 24 '13 at 08:18

score 1 · Answer 2 · answered Jun 25 '13 at 01:51

I'm able to accomplish this using regular old EPSG:4326 (i.e., lat, lon points):

CREATE TABLE my_points (id SERIAL PRIMARY KEY, point GEOMETRY);
INSERT INTO my_points (id, point) VALUES 
  (1, ST_GeomFromText('POINT(12 23)', 4326)),
  (2, ST_GeomFromText('POINT(23 45)', 4326));
SELECT ST_AsText(ST_ConvexHull(ST_Collect(point))) FROM points;

Returns LINESTRING(12 23,23 45)

PostGIS spatial reference ID (SRID) for regular cartesian coordinate system?

2 Answers2