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

PGer / pgsphere Public

forked from jankorichter/pgsphere

Notifications You must be signed in to change notification settings
Fork 0
Star 0

pgsphere provides spherical data types, functions, and operators for PostgreSQL

pgsphere.projects.postgresql.org/

BSD-3-Clause license

0 stars 3 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 55 Commits
data		data
doc		doc
expected		expected
sql		sql
test_top_build_dir		test_top_build_dir
testsuite		testsuite
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
crossmatch.c		crossmatch.c
crossmatch.h		crossmatch.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_contains_ops.sql.in		pgs_contains_ops.sql.in
pgs_contains_ops_compat.sql.in		pgs_contains_ops_compat.sql.in
pgs_crossmatch.sql.in		pgs_crossmatch.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:

  make USE_PGXS=1
  make USE_PGXS=1 install
  -- load functions
  psql <database> < pg_sphere.sql

REGRESSION TEST:

   sudo chown postgres .; sudo -u postgres make USE_PGXS=1 installcheck

LONG REGRESSION TEST:

   sudo chown postgres .; sudo -u postgres make USE_PGXS=1 crushtest

REGRESSION TESTS WITHIN THE SOURCE/BUILD DIRECTORY:

   make USE_PGXS=1 test
   make USE_PGXS=1 test_extented  # long test

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

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

Have a lot of fun!