PostGIS Extension

Giriş 

Açıklaması şöyle

PostGIS is the spatial database extension for PostgreSQL. It has over 300 different built-ins and functions to make it easier to work with spatial data.

PostgreSQL bir sürü şeyi daha destekliyor. Açıklaması şöyle

- OLTP (Online Transaction Processing)

We can use PostgreSQL for CRUD (Create-Read-Update-Delete) operations.

- OLAP (Online Analytical Processing)

We can use PostgreSQL for analytical processing. PostgreSQL is based on 𝐇𝐓𝐀𝐏 (Hybrid transactional/analytical processing) architecture, so it can handle both OLTP and OLAP well.

- FDW (Foreign Data Wrapper)

A FDW is an extension available in PostgreSQL that allows us to access a table or schema in one database from another.

- Streaming

PipelineDB is a PostgreSQL extension for high-performance time-series aggregation, designed to power real-time reporting and analytics applications.

- Geospatial

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects, allowing location queries to be run in SQL.

- Time Series

Timescale extends PostgreSQL for time series and analytics. For example, developers can combine relentless streams of financial and tick data with other business data to build new apps and uncover unique insights.

- Distributed Tables

CitusData scales Postgres by distributing data & queries. 

Şeklen şöyle

Spatial Data Nedir?

Açıklaması şöyle. Konum bilgisi taşıyan veridir.

Spatial Data, often referred to as geospatial data, is any data that contains information about a specific location. In layman's terms, spatial data is data about location.

Spatial Data Types Nedir?

Açıklaması şöyle. 

The two primary spatial data types are Geometric and Geographic data.

Geographic data is data that can be mapped to a sphere (the sphere in question is usually planet earth). Geographic data typically refers to longitude and latitude related to the location of an object on earth. GPS data is a good example of geographic data.

Geometric data is data that can be mapped to a two-dimensional flat surface. A good example of geometric data would be the floor plan of a building.

Açıklaması şöyle

PostgreSQL natively supports NoSQL as well as a rich set of data types, including Numeric Types, Boolean Type, Network Address, Bit String Types, Arrays, Composite Types, Object Identifier Types, Pseudo-Types, and even Geometric Types like Points, Line Segments, Boxes, Paths, Polygons, and Circles. It also supports JSON, hstore, and XML, and users can even add new types using the CREATE TYPE command. Postgres also supports a lot of SQL syntaxes, such as common table expressions, Windows functions, and table inheritance.

PostGIS Kurulumunu Kontrol Etmek

Şu iki komuttan birisini çalıştırırız

SELECT PostGIS_version();
SELECT PostGIS_full_version();

Eğer kurulu değilse çıktı olarak Türkçe şunu alırız

HATA: postgis_full_version() fonksiyonu mevcut değildir

İngilizcesi şöyle

ERROR:  function postgis_full_version() does not exist

Diğer

Bazı diğer yazılar şöyle

ST_Contains

ST_MakePoint

ST_Union

ST_Distance

ST_Dwithin

ST_MakeValid