From the course: Hands-On PostgreSQL Project: Spatial Data Science

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Spatial ref sys table explained

Spatial ref sys table explained

From the course: Hands-On PostgreSQL Project: Spatial Data Science

Start my 1-month free trial Buy for my team

Spatial ref sys table explained

“

- [Instructor] When we installed Post GIS extension in our Postgres database, you may have noticed a table has been added to the database called spatial references. This is a very important table as it stores information on all the different spatial reference systems supported by Post GIS. It contains the SRID, projections and related parameters. You might remember SRID and EPSG from the previous video. In practice, they're often used interchangeably, but they do have distinct meanings. SRID stands for Spatial Reference Identifier, which is a general term used in various geospatial databases to reference a specific spatial reference system. It's a unique identifier that tells the database how to interpret and project the geometric data. EPSG, on the other hand, is a specific namespace within the SRID system. EPSG codes are SRIDs defined by the European Petroleum Survey Group, and they're the most commonly used standard. So when we say an SRID like 4326, it's technically an EPSG code…

Contents