GitHub - postgrespro/pgsphere at 4bff11bb384f0943a08173c1ed546eb061332ad7

postgrespro / pgsphere Public

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

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

pgsphere.org

BSD-3-Clause license

22 stars 15 forks Branches Tags Activity

Star

Notifications

Branches Tags

Folders and files
Name Name
Last commit message
Last commit date
Latest commit

History
77 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

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

Name	Name	Last commit message	Last commit date
Latest commit History 77 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
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

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

+ 5 contributors

Languages

C 89.9%

C++ 4.3%

PLpgSQL 2.4%

Makefile 1.5%

Perl 1.0%

Yacc 0.7%

Lex 0.2%

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

About

Uh oh!

Releases 11

Uh oh!

Contributors 19

Uh oh!

Languages

License

postgrespro/pgsphere

Repository files navigation