GitHub - knizhnik/pg

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 73 Commits
data		data
doc		doc
expected		expected
sql		sql
testsuite		testsuite
.gitignore		.gitignore
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
gnomo.c		gnomo.c
gnomo.sql.in		gnomo.sql.in
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.control		pg_sphere.control
pg_sphere.h		pg_sphere.h
pgs_box.sql.in		pgs_box.sql.in
pgs_circle.sql.in		pgs_circle.sql.in
pgs_contains_ops.sql.in		pgs_contains_ops.sql.in
pgs_contains_ops_compat.sql.in		pgs_contains_ops_compat.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
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 an R-Tree implementation using GiST for spherical objects
like spherical points and spherical circles with 
useful functions and operators.


NOTICE:
     This version will work only with postgresql version 9.1 and above.

INSTALLATION:

  -- build and install
  gmake USE_PGXS=1 PG_CONFIG=/usr/bin/pg_config
  gmake USE_PGXS=1 PG_CONFIG=/usr/bin/pg_config install
  -- load extension
  psql -c "CREATE EXTENSION pg_sphere;" <database>

REGRESSION TEST (as the same user as the currently running postgresql server):

  make USE_PGXS=1 installcheck

LONG REGRESSION TEST:

  make USE_PGXS=1 crushtest

The 'make' program must be compatible with GNU make.

For more information, have a look at http://pgsphere.projects.postgresql.org
and https://github.com/akorotkov/pgsphere

Have a lot of fun!