What is an SRID?

A spatial reference identifier (SRID) is a unique identifier associated with a specific coordinate system, tolerance, and resolution.

How the SRID is populated or what it represents can vary depending on what database you use to store your data. There are various recognized standard SRIDs, such as those defined by the European Petroleum Survey Group (EPSG). Some databases and spatial types, such as PostGIS geometry in PostgreSQL or the geography type in SQL Server, use a predefined subset of EPSG codes, and only spatial references with those SRIDs can be used. Others, such as the ST_Geometry type in Oracle, PostgreSQL, IBM DB2, and Informix, can use spatial references that have SRIDs defined by Esri.

How SRIDs are used in ArcGIS

The following table lists what SRID is used in the target PostgreSQL, Oracle, SQL Server, or Netezza database when importing or pasting spatial data. The words known or unknown indicate whether the spatial reference in the source data can be mapped to an existing spatial reference in the target database.

Target

Source

ST_Geometry

PostGIS Geometry

Oracle SDO_Geometry

SQL Server Geometry

SQL Server Geography

Netezza spatial

Known EPSG code with an ST_Geometry, SDEBINARY, PostGIS Geometry, SDO_Geometry, SQL Server Geometry, SQL Server Geography, or Netezza spatial column

The EPSG code is used as the spatial reference ID and stored with the geometry.

The EPSG code is used as the spatial reference ID and stored with the geometry.

The EPSG code is used as the spatial reference ID and stored with the geometry.

The EPSG code is used as the spatial reference ID and stored with the geometry.

The EPSG code is used as the spatial reference ID and stored with the geometry.

The EPSG code is used as the spatial reference ID and stored with the geometry.

Known EPSG code with custom tolerance and/or precision with an ST_Geometry, SDEBINARY, or Netezza spatial column

An SRID greater than 300,000 is added to the ArcSDE system table.

The EPSG code is used as the spatial reference ID and stored with the geometry.

The EPSG code is used as the spatial reference ID and stored with the geometry.

The EPSG code is used as the spatial reference ID and stored with the geometry.

The EPSG code is used as the spatial reference ID and stored with the geometry.

The EPSG code is used as the spatial reference ID and stored with the geometry.

Known Esri coordinate system with an ST_Geometry, SDEBINARY, or Netezza spatial column

The Esri code is used for the ID and stored with the geometry.

The ID is set to –1.

The ID is null.

The Esri code is used for the ID and stored with the geometry.

Esri coordinate systems are used for projected coordinate systems. Since projected coordinate systems cannot be used with the SQL Server Geography type, an error is returned and the data cannot be imported.

The Esri code is used as the spatial reference ID and stored with the geometry.

Unknown coordinate system with an ST_Geometry, SDEBINARY, PostGIS Geometry, SDO_Geometry, SQL Server Geometry, or Netezza spatial column

An SRID greater than 300,000 is added to the ArcSDE system table.

The ID is set to –1.

The ID is null.

The ID is set to 0.

An error is returned and the data cannot be imported.

The ID is set to 500000.

Custom Oracle coordinate system with an SDO_Geometry column

An SRID greater than 300,000 is added to the ArcSDE system table.

The ID is set to –1.

The custom Oracle ID is used if it is set in the source. If not set, the SRID is set to null in the target database.

The ID is set to 0.

An error is returned and the data cannot be imported.

An error is returned and the data cannot be imported.

Custom coordinate system with a PostGIS Geometry column

An SRID greater than 300,000 is added to the ArcSDE system table.

The custom PostGIS ID is used, if it is set in the source. If not set, the ID is set to –1 in the target database.

The ID is null.

The ID is set to 0.

An error is returned and the data cannot be imported.

An error is returned and the data cannot be imported.

When pasting or importing data to a DB2 or Informix database, ArcGIS also checks the spatial reference table for a match; if one is not found, a new record with the new information is added to the spatial references table. See your IBM documentation for more information about the IDs used.

Related Topics

6/19/2015