TransWikia.com

How to create custom CRS with custom SRID in PostGIS?

Geographic Information Systems Asked by jayarjo on March 1, 2021

In our app we are using several CRS – one of them is a custom one. I’d like to turn it into a proper CRS that PostGIS can fully support (e.g. administering valid transformations on it with something like ST_Transform, etc)

How would one do that?

I couldn’t find any reference on this online. I found one for Oracle here – seems to be very detailed, transparent and straightforward process. What would be an alternative of this process in case of PostGIS?

One Answer

Just add a row to the spatial_ref_sys table.

The most important column is proj4text, which describes the projection for the PROJ library. (Despite the name, the latest PostGIS uses the latest version of PROJ.)

I do not know if the srtext value is actually necessary, but you should be able to create it with gdalsrsinfo.

Also see Managing custom projections and Would it be worthwhile to use the PostGIS extension for custom planets?

Correct answer by CL. on March 1, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP