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