Skip to content

gqueiroz/pg_geoext

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

52 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

A Simple Geo-Extension for PostgreSQL

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published