Movatterモバイル変換

postgrespro/pgspherePublic

NotificationsYou must be signed in to change notification settings
Fork15
Star22

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

pgsphere.org

License

BSD-3-Clause license

22 stars 15 forks Branches Tags Activity

Star

Notifications

You must be signed in to change notification settings

Branches Tags

Folders and files

Name		Name	Last commit message	Last commit date
Latest commit History 325 Commits
.github/workflows		.github/workflows
data		data
doc		doc
expected		expected
healpix_bare		healpix_bare
sql		sql
src		src
testsuite		testsuite
upgrade_scripts		upgrade_scripts
.editorconfig		.editorconfig
.gitignore		.gitignore
.gitlab-ci.yml		.gitlab-ci.yml
CONTRIBUTING.md		CONTRIBUTING.md
COPYRIGHT.pg_sphere		COPYRIGHT.pg_sphere
HACKING		HACKING
Makefile		Makefile
Makefile.common.mk		Makefile.common.mk
README.pg_sphere		README.pg_sphere
gnomo.sql.in		gnomo.sql.in
healpix.sql.in		healpix.sql.in
pg_sphere.control		pg_sphere.control
pg_sphere_head.sql.in		pg_sphere_head.sql.in
pgindent-excludes.list		pgindent-excludes.list
pgindent-typedefs.list		pgindent-typedefs.list
pgs_box.sql.in		pgs_box.sql.in
pgs_brin.sql.in		pgs_brin.sql.in
pgs_circle.sql.in		pgs_circle.sql.in
pgs_circle_sel.sql.in		pgs_circle_sel.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_epochprop.sql.in		pgs_epochprop.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_gist_support.sql.in		pgs_gist_support.sql.in
pgs_hash.sql.in		pgs_hash.sql.in
pgs_line.sql.in		pgs_line.sql.in
pgs_moc_geo_casts.sql.in		pgs_moc_geo_casts.sql.in
pgs_moc_ops.sql.in		pgs_moc_ops.sql.in
pgs_moc_options.sql.in		pgs_moc_options.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_types.sql.in		pgs_types.sql.in

Repository files navigation

pgSphere is a PostgreSQL extension for spherical geometry.It provides:* New data types (points, spherical polygons, paths, circles, ellipses, coordinate ranges)* Input and output of data in various formats* Membership, overlap, and other operators* Circumference and area of objects* Object rotation by Euler angles* Indexing of spherical data typesThis is an R-tree implementation using GiST for spherical objects likespherical points and spherical circles with useful functions and operators.It also supports the Block Range INdexing (BRIN) for large datasets.NOTICE:     This version will work only with PostgreSQL version 10 and above.VERSIONING:Stable versions are marked with tags containing version numbers in the GitHubrepository athttps://github.com/postgrespro/pgsphere/. Each stable versioncontains upgrade scripts for updating an existing installation to the latestversion using the ALTER EXTENSION UPDATE TO command.The master branch is intended for development purposes and may containintermediate changes. The current version in the master branch and itsfunctionality are subject to change.Note: The master branch should not be used in production because the upgradescripts and the current version number may be changed.INSTALLATION:  -- Build and install  make  make install  -- HEALPix/MOC support is included by default. If your platform does not  -- have the required libhealpix_cxx dependency, you can optionally build  -- pgSphere without HEALPix/MOC support, like this:  make USE_HEALPIX=0  make USE_HEALPIX=0 install  -- Load extension  psql -c "CREATE EXTENSION pg_sphere;" <database>UPDATING AN EXISTING INSTALLATION:  -- If you are updating from a previous version of pgSphere, perform the  -- same make and make install steps as above, but, instead of the CREATE  -- EXTENSION step, you need to do:  psql -c "ALTER EXTENSION pg_sphere UPDATE TO 'A.B.C';" <database>  -- where A.B.C is a placeholder for the current version.  -- You also may want to check what version of pgSphere is installed using     either or both of the following commands:  psql -c "SELECT pg_sphere_version();" <database>  psql -c "SELECT * FROM pg_available_extension_versions WHERE name = 'pg_sphere';"REGRESSION TEST (as the same user as the currently running PostgreSQL server):  make installcheck  -- or --  make USE_HEALPIX=0 installcheckLONG REGRESSION TEST:  make crushtest  -- or --  make USE_HEALPIX=0 crushtestThe 'make' program used in all of the above commands must be compatible withGNU make.For more information or to report issues or to help with development, pleaserefer tohttps://github.com/postgrespro/pgsphere/Original repository for pgSphere:https://github.com/akorotkov/pgsphereHave a lot of fun!