Paragon Corpoation PostGIS Spatial Database Engine OSGeo.org The Open Source Geospatial Foundation UMN Mapserver Boston Geographic Information Systems   
FOSS4G International 2017, August 14th-18th 2017
   PostGreSQL Object Relational Database Management System
Home   About Boston GIS   Consulting Services  Boston GIS Blog  Postgres OnLine Journal  Planet PostGIS  PostGIS Funding

Purpose of BostonGIS

BostonGIS is a testbed for GIS and Web Mapping solutions utilizing open source, freely available and/or open gis technologies. We will be using mostly Boston, Massachusetts data to provide mapping and spatial database examples.

If you have some thoughts or comments on what you would like to see covered on this site, drop us a line on our Feed Back page.


PostGIS in Action
check out book and download the first chapter and SQL Primer for free.

Tips and Tricks for PostGIS

PostgreSQL: Up and Running 2nd Edition (Amazon)
PostgreSQL: Up and Running 2nd EditionIt covers PostgreSQL 9.2-9.4 with special focus

GIS Tutorials on Opensource and OpenGIS technologies Tutorials
GIS Article comments Article and Tutorial Comments
Boston GIS BLog Rss FeedBoston GIS blog

PDF HTML All BostonGIS tutorials packaged together in an E-Book.


Boston GIS Store

Loading


Tutorial and Tip Sites
Desktop GIS
External Data
GIS Events and Groups
GIS SDKs and Frameworks
External Resources
Glossary
SRID, SRS ID: Spatial Reference System Identifiers

SRID stands for Spatial Reference Identifier and SRS ID stands for Spatial Reference System Identifier. A spatial reference system defines a projection, coordinate system, datums and ellipsoids. Morten Nielsen gives and excellent definition of What is a spatial reference system?.

The term SRID is usually used in common GIS database lingo as an integer in an OGC compliant database which is the primary key in a lookup table called spatial_ref_sys (or similarly named table or view). It is used to lookup the spatial reference details of a spatial reference system and most OGC SFQL functions simply use this SRID key defined in the table when doing projection based functions.

In other GIS usage the spatial reference identifier is usually called SRS ID (Spatial Reference System Identifier) and it is usually composed of Author Name and the unique Integer ID defined by that authority of that spatial reference system. For example the common WGS 84 long lat has an identifier EPSG:4326. Massachusetts State Plane NAD 83 meters would be referred to as EPSG:26986. In general the same integer ID part is rarely used by two different authorities so then simply saying 4326 people know what that means and a lot of database systems simply use the Authority's Integer ID for their SRID. Also in general most commonly used SRIDs have author European Petroleum Survey Goup (EPSG) so its safe to leave out the author. So in short the terms SRS ID and SRID are often used interchangeably although they have slightly different meaning.

One thing that is particular confusing is that since the database use of the term SRID is simply a pseudo-dummy id in a lookup table and even you can define your own if you are not satisfied with any of the common ones, you can conceivably have two different SRIDs that define equivalent spatial reference systems or map to the same SRS ID. The database will commonly treat them as different since they have different SRIDs and its less taxing to assume they are different. There isn't even an official rule that states your database SRIDs have to match up with official SRS IDs.

.

OGC WFS more ...
GIS: Geographic Information System more ...
OGC WMS more ...
OGC SFSQL more ...
GIS Blogs Around Boston
External GIS Blogs
External Papers Articles
GIS Quick Guides and References
OpenStreetMap and OpenLayers Tutorials
PostGIS, pgRouting, and PostgreSQL Tutorials
Part 1: Getting Started With PostGIS: An almost Idiot's Guide (PostGIS 2.2) more ...
pgRouting: Loading OpenStreetMap with Osm2Po and route querying more ...
Part 1: Getting Started With PostGIS: An almost Idiot's Guide (PostGIS 2.0) more ...
OSCON 2009: Tips and Tricks for Writing PostGIS Spatial Queries more ...
PGCon2009: PostGIS 1.4, PostgreSQL 8.4 Spatial Analysis Queries, Building Geometries, Open Jump more ...
PLR Part 3: PL/R and Geospatial Data Abstraction Library (GDAL) RGDAL more ...
PostGIS Nearest Neighbor: A Generic Solution - Much Faster than Previous Solution more ...
Solving the Nearest Neighbor Problem in PostGIS more ...
PLR Part 2: PL/R and PostGIS more ...
PLR Part 1: Up and Running with PL/R (PLR) in PostgreSQL: An almost Idiot's Guide more ...
Part 2 - PostGIS and SharpMap in ASP.NET 2.0 using VB.NET: Displaying the Maps more ... download
Part 1 - PostGIS and SharpMap in ASP.NET 2.0 using VB.NET: Compiling SharpMap with PostGIS more ...
Part 3: PostGIS Loading Data from Non-Spatial Sources more ...
Part 2: Introduction to Spatial Queries and SFSQL with PostGIS more ...
Miscellaneous Tutorials/Cheatsheets/Examples
SpatiaLite Tutorials
Boston External Map Examples
SQL Server 2008 Tutorials
UMN Mapserver Tutorials
General Commentary
Locations of visitors to BostonGIS
Boston GIS      Copyright 2017      Paragon Corporation