8000 GitHub - postgrespro/pgsphere at d16eda931c0d618face2ee3cb7cf590df94e95fc
[go: up one dir, main page]
Skip to content

postgrespro/pgsphere

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

58 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
 
 
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
 
 
gnomo.c
gnomo.c
 
 
gnomo.sql.in
gnomo.sql.in
 
 
gq_cache.c
gq_cache.c
 
 
init.c
init.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
8000
 
 
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!

About

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

pgsphere.org

Resources

Readme

License

BSD-3-Clause license
Activity
Custom properties

Stars

22 stars

Watchers

12 watching

Forks

15 forks
Report repository

Releases 11

1.5.1 Latest
May 1, 2024
+ 10 releases

Contributors 19

  • 45E1
+ 5 contributors

Languages
0