Skip to main content
Geographic Information Systems

Return to Question

Bumped by Community user
Bumped by Community user
added 589 characters in body
Source Link
Abhijit Gujar
Abhijit Gujar
  • 2.8k
  • 4
  • 30
  • 44

I need a support for CRS that was not available in PostGIS 2.5 so I looked up into the EPSG site they had simple easy straight forward insert query to add EPSG so I did that now how do I check or know that all the functions that PostGIS have will run with same accuracy as they use to work or may be I should avoid use of some specific function like given here , and all reprojection will work as required?

EPSG site reference https://spatialreference.org/ref/epsg/4979/

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 94979, 'epsg', 4979, '+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs ', 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137.0,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0.0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943295],AXIS["Geodetic latitude",NORTH],AXIS["Geodetic longitude",EAST],AXIS["Ellipsoidal height",UP],AUTHORITY["EPSG","4979"]]');

I need a support for CRS that was not available in PostGIS 2.5 so I looked up into the EPSG site they had simple easy straight forward insert query to add EPSG so I did that now how do I check or know that all the functions that PostGIS have will run with same accuracy as they use to work or may be I should avoid use of some specific function like given here , and all reprojection will work as required?

I need a support for CRS that was not available in PostGIS 2.5 so I looked up into the EPSG site they had simple easy straight forward insert query to add EPSG so I did that now how do I check or know that all the functions that PostGIS have will run with same accuracy as they use to work or may be I should avoid use of some specific function like given here , and all reprojection will work as required?

EPSG site reference https://spatialreference.org/ref/epsg/4979/

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 94979, 'epsg', 4979, '+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs ', 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137.0,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0.0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943295],AXIS["Geodetic latitude",NORTH],AXIS["Geodetic longitude",EAST],AXIS["Ellipsoidal height",UP],AUTHORITY["EPSG","4979"]]');
naming
Source Link
Vince
Vince
  • 20.3k
  • 16
  • 48
  • 65

I need a support for CRS that was not available in postgisPostGIS 2.5 so I looked up into the EPSG site they had simple easy straight forward insert query to add EPSG so iI did that now how do iI check or know that all the functions that postgisPostGIS have will run with same accuracy as they use to work or may be iI should avoid use of some specific function like given here , and all reprojection will work as required  ?

I need a support for CRS that was not available in postgis 2.5 so I looked up into the EPSG site they had simple easy straight forward insert query to add EPSG so i did that now how do i check or know that all the functions that postgis have will run with same accuracy as they use to work or may be i should avoid use of some specific function like given here , and all reprojection will work as required  ?

I need a support for CRS that was not available in PostGIS 2.5 so I looked up into the EPSG site they had simple easy straight forward insert query to add EPSG so I did that now how do I check or know that all the functions that PostGIS have will run with same accuracy as they use to work or may be I should avoid use of some specific function like given here , and all reprojection will work as required?

Source Link
Abhijit Gujar
Abhijit Gujar
  • 2.8k
  • 4
  • 30
  • 44

How to check for PostGIS Function Support Matrix for new custom EPSG imported from EPSG site

I need a support for CRS that was not available in postgis 2.5 so I looked up into the EPSG site they had simple easy straight forward insert query to add EPSG so i did that now how do i check or know that all the functions that postgis have will run with same accuracy as they use to work or may be i should avoid use of some specific function like given here , and all reprojection will work as required ?