GitHub - credativ/pgsphere: PgSphere provides spherical data types, functions, operators, and indexing for PostgreSQL.

credativ / pgsphere Public

forked from pgsphere/pgsphere

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

PgSphere provides spherical data types, functions, operators, and indexing for PostgreSQL.

BSD-3-Clause license

2 stars 6 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 153 Commits
data		data
doc		doc
expected		expected
healpix_bare		healpix_bare
sql		sql
test_top_build_dir		test_top_build_dir
testsuite		testsuite
upgrade_scripts		upgrade_scripts
.gitignore		.gitignore
.gitlab-ci.yml		.gitlab-ci.yml
.travis.yml		.travis.yml
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.h		gnomo.h
gnomo.sql.in		gnomo.sql.in
gq_cache.c		gq_cache.c
healpix.c		healpix.c
healpix.sql.in		healpix.sql.in
index_9.5		index_9.5
key.c		key.c
key.h		key.h
line.c		line.c
line.h		line.h
moc.c		moc.c
output.c		output.c
path.c		path.c
path.h		path.h
pg_sphere--1.2.0.sql.in		pg_sphere--1.2.0.sql.in
pg_sphere.control		pg_sphere.control
pg_sphere.h		pg_sphere.h
pgs_9.5.sql.in		pgs_9.5.sql.in
pgs_box.sql.in		pgs_box.sql.in
pgs_chealpix.h		pgs_chealpix.h
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_gist_pointkey.sql.in		pgs_gist_pointkey.sql.in
pgs_gist_spoint3.sql.in		pgs_gist_spoint3.sql.in
pgs_healpix.h		pgs_healpix.h
pgs_line.sql.in		pgs_line.sql.in
pgs_moc.h		pgs_moc.h
pgs_moc_compat.sql.in		pgs_moc_compat.sql.in
pgs_moc_ops.sql.in		pgs_moc_ops.sql.in
pgs_moc_type.sql.in		pgs_moc_type.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_process_moc.h		pgs_process_moc.h
pgs_types.sql.in		pgs_types.sql.in
pgs_util.h		pgs_util.h
point.c		point.c
point.h		point.h
polygon.c		polygon.c
polygon.h		polygon.h
process_moc.cpp		process_moc.cpp
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!