gqueiroz/pg_geoext

A Simple Geo-Extension for PostgreSQL

A Simple Geo-Extension for PostgreSQL

pg_geoext is a spatial extension prototype for teaching spatial database classes.

Status

---

Requeriments

---

Building & Installation

---

Usage

---

For more information read the doc

CREATE EXTENSION geoext;
SELECT geo_point_to_str('POINT (22.2 33.2);SRID = 4356'::geo_point)
SELECT 'POLYGON ((1 2),(12 6 ),(5 9),(1 2));SRID = 4556'::geo_polygon

Types:

• point(x,y)
• polygon((x1 y1), (x2 y3) .... (x1 y1))

Functions:

geo_point_to_str();
geo_point_from_text();
geo_point_distance();

geo_polygon_area();
geo_polygon_perimeter();

Observation:

The input and output of geo_point is hex

pg_geoext's Issues

Implementation of function geo_polygon_from_text

Implementation of function geo_linestring_send

Implementation of function geo_polygon_to_str

Implementation of function geo_linestring_intersection_points

The suport for this function must be included in "algorithms.h/algorithms.c".
We are going to use a an x-ordering strategy for this implementation.

Implementation of function geo_polygon_recv

Implementation of function geo_polygon_send

Implementation of function geo_polygon_out

Implementation of function geo_polygon_perimeter

Implementation of function geo_polygon_contains_point

Implementation of function geo_linestring_recv

Implementation of function geo_linestring_is_closed

Implementation of function geo_polygon_from_text

Implementation of function geo_polygon_area

Implementation of function geo_linestring_length

Add a function named "length" in "algorithms.h/c".

Implementation of function geo_polygon_in