Geometry - (Coordinate|Spatial Reference) System (SRID|EPSG)

Card Puncher Data Processing


In 1618, Rene Descartes had an idea… while lying in bed and watching a fly on the ceiling.

He could describe the location of the fly in terms of two numbers: its distance from the two walls.

He realized that this works even if the two walls were not perpendicular.

He realized that you could express geometry in algebra.

  • The walls play role of what we now call axes.
  • The two numbers are what we now call coordinates

A coordinate system (also called a spatial reference system) is a means of assigning coordinates to a location and establishing relationships between sets of such coordinates. It enables the interpretation of a set of coordinates as a representation of a position in a real world space.

The Oracle SRID 8307 (well-known name is “Longitude / Latitude (WGS 84)”) is probably the most widely used coordinate system, and it is the one used for global positioning system (GPS) devices. Google Maps uses the 3785.

SRID sometimes is called an “EPSG” code. The SRID/EPSG code is a defacto short-hand for the Well-Known-Text representations of projections.

Type of Coordinate System

Type Count Descripion
PROJECTED 3387 Projected Coordinates
GEOGRAPHIC2D 755 Geodetic Coordinates

Cartesian Coordinates

Geometry - Cartesian Coordinates

Geo coordinates


Projected Coordinates

See Spatial - Projection

Geodetic Coordinates (Geographic Coordinates)

Geodetic coordinates (sometimes called geographic coordinates) are angular coordinates (longitude and latitude), closely related to spherical polar coordinates, and are defined relative to a particular Earth geodetic datum

A geodetic datum (or datum) is a means of shifting and rotating an ellipsoid to represent the figure of the Earth, usually as an oblate spheroid, that approximates the surface of the Earth locally or globally, and is the reference for the system of geodetic coordinates.

Each geodetic coordinate system is based on a datum.

Choosing a Geodetic or Projected Coordinate System

For applications that deal with the Earth's surface, the data can be represented using:

  • a geodetic coordinate system
  • or a projected plane coordinate system.

In deciding which approach to take with the data, consider any needs related to accuracy and performance:


For many spatial applications, the area is sufficiently small to allow adequate computations on Cartesian coordinates in a local projection. For example, the New Hampshire State Plane local projection provides adequate accuracy for most spatial applications that use data for that state.

However, Cartesian computations on a plane projection will never give accurate results for a large area such as Canada or Scandinavia. For example, a query asking if Stockholm, Sweden and Helsinki, Finland are within a specified distance may return an incorrect result if the specified distance is close to the actual measured distance. Computations involving large areas or requiring very precise accuracy must account for the curvature of the Earth's surface.


Spherical computations use more computing resources than Cartesian computations. Some operations using geodetic coordinates may take longer to complete than the same operations using Cartesian coordinates.

Geodesy and Two-Dimensional Geometry (Cartesian coordinates)

A two-dimensional geometry is a surface geometry, but the important question is: What is the surface? A flat surface (plane) is accurately represented by Cartesian coordinates. However, Cartesian coordinates are not adequate for representing the surface of a solid. A commonly used surface for spatial geometry is the surface of the Earth, and the laws of geometry there are different than they are in a plane. For example, on the Earth's surface there are no parallel lines: lines are geodesics, and all geodesics intersect. Thus, closed curved surface problems cannot be done accurately with Cartesian geometry.

Local Coordinate Support

Spatial provides a level of support for local coordinate systems. Local coordinate systems are often used in :

  • CAD systems
  • the relationship between the surveyed site and the rest of the world is not important

Linear Referencing System

Linear referencing is a natural and convenient means to associate attributes or events to locations or portions of a linear feature.

It has been widely used in :

  • transportation applications (such as for highways, railroads, and transit routes)
  • utilities applications (such as for gas and oil pipelines).

The major advantage of linear referencing is its capability of locating attributes and events along a linear feature with only one parameter (usually known as measure) instead of two (such as longitude/latitude or x/y in Cartesian space). Sections of a linear feature can be referenced and created dynamically by indicating the start and end locations along the feature without explicitly storing them.


A shapefile has a prj file that can be converted to a EPSG through this web site:

Documentation / Reference

Discover More
block directioninlinedirectionverticalwriting mode中文▼ left / block-end sideright / block-start side ▼top / inline-start side ▼bottom / inline-end side ▲width / block-sizeheight / inline-size
CSS - Flow

The flow is the direction of a block and inline layout against which the elements are positioned. This layout uses the concept of containing box as coordinate system. This containing box depends...
Drive - Cylinder

cylinder is the vertical axes in the coordinate system of a disk (hard drive, flash). For instance, the Master Boot record is located at: sector 0 Cylinder 0, head 0
Card Puncher Data Processing
Geometry (Spatial, Linear Algebra)

A geometry is the geometric representation of an object in some coordinate system. A graphic is the combination of this objects in this coordinate system. Same as ! ...
Card Puncher Data Processing
Geometry - Axis

Axis are one of the primary element of an coordinate system. Same as ?
Inkscape Layout
Inkscape - Page

A page defined: the coordinate system. The origin is at the left bottom corner and is used for all transformation and the area for exporting Width and Height...: File > Document Properties...
Card Puncher Data Processing
Linear Algebra - Coordinate system

coordinate system in terms of vector. Idea of coordinate system for a vector space V: (and generalized beyond two dimensions), Coordinate system for a vector space V is specified by generators of...
Mapbuilder Preview Nl Gemeente
MapBuilder - Import of a Shapefile Map

When working with Mapviewer, you may face with the need to have map data to begin to work. The demo files come with some data but are really without utility if you work in an other country than the US....
Obiee11g Map View Component
OBIEE 11G - Map View

Map view is a new view in 11g that permit to include a mapviewer map in an answer. When you edit a map view and work with layers, you create formats for those layers. For example: the floor maps of...
Spatial General Utilisation Map
Oracle Spatial - Coordinate System

The SDO_SRID attribute identify the associated coordinate System with the geometry. Its value can be null or one of the SDO_COORD_REF_SYS table. SRID Name Type Description 8307 Longitude / Latitude...
Sql Developer Update Spatial Metadata
Oracle Spatial - Geometry Metadata Views and Index

The geometry metadata describe for each dimensions (axis): the lower bound the upper bound, and the tolerance. This data are stored in a global table owned by MDSYS (which users should never directly...

Share this page:
Follow us:
Task Runner