GitHub - jankorichter/pgsphere: pgsphere provides spherical data types, functions, and operators for PostgreSQL

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 27 Commits
data		data
doc		doc
expected		expected
sql		sql
testsuite		testsuite
.cvsignore		.cvsignore
COPYRIGHT.pg_sphere		COPYRIGHT.pg_sphere
Makefile		Makefile
README.pg_sphere		README.pg_sphere
box.c		box.c
box.h		box.h
circle.c		circle.c
circle.h		circle.h
ellipse.c		ellipse.c
ellipse.h		ellipse.h
euler.c		euler.c
euler.h		euler.h
gist.c		gist.c
gist.h		gist.h
gq_cache.c		gq_cache.c
key.c		key.c
key.h		key.h
line.c		line.c
line.h		line.h
output.c		output.c
path.c		path.c
path.h		path.h
pg_sphere.h		pg_sphere.h
pgs_box.sql.in		pgs_box.sql.in
pgs_circle.sql.in		pgs_circle.sql.in
pgs_ellipse.sql.in		pgs_ellipse.sql.in
pgs_euler.sql.in		pgs_euler.sql.in
pgs_gist.sql.in		pgs_gist.sql.in
pgs_line.sql.in		pgs_line.sql.in
pgs_path.sql.in		pgs_path.sql.in
pgs_point.sql.in		pgs_point.sql.in
pgs_polygon.sql.in		pgs_polygon.sql.in
pgs_types.sql.in		pgs_types.sql.in
point.c		point.c
point.h		point.h
polygon.c		polygon.c
polygon.h		polygon.h
sbuffer.c		sbuffer.c
sbuffer.h		sbuffer.h
sparse.c		sparse.c
sparse.h		sparse.h
sparse.y		sparse.y
sql.awk		sql.awk
sscan.c		sscan.c
sscan.l		sscan.l
types.h		types.h
vector3d.c		vector3d.c
vector3d.h		vector3d.h

Repository files navigation

This is R-Tree implementation using GiST for spherical objects
like spherical points and spherical circles with 
useful functions and operators.


NOTICE:
     This version will works only with postgresql version 8.0 and above.

INSTALLATION:

  gmake
  gmake install
  -- load functions
  psql <database> < pg_sphere.sql

REGRESSION TEST:

   gmake installcheck

LONG REGRESSION TEST:

   gmake crushtest

For more informations have a look at http://pgsphere.projects.postgresql.org/

Have a lot of fun!