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

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
GEOCENTRIC 75
VERTICAL 56
ENGINEERING 49
COMPOUND 14
GEOGENTRIC 1
GEOGRAPHIC3D 89

### Geo coordinates

#### Type

##### 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:

##### Accuracy

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.

##### Performance

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 :

• 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.

### PRJ TO EPSG

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

## Documentation / Reference

Discover More
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
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 ! ...
Geometry - Axis

Axis are one of the primary element of an coordinate system. Same as ?
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...
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 - 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....
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...
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...
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...