# pgGEOS

**Repository Path**: leitl/pggeos

## Basic Information

- **Project Name**: pgGEOS
- **Description**: A PostgreSQL extension for exposing certain GEOS functions
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-05-30
- **Last Updated**: 2024-11-25

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# pgGEOS: A postgres extension with customized GEOS functions to support geospatial data conflation

The conflation process is described in the following article:

Lei, T.L. (2020, in press). Geospatial data conflation: a formal approach based on optimization and relational databases. International Journal of Geographical Information Science.

Copyright (c) 2020 Ting Lei (leiting@gmail.com) and Zhen Lei (leizhen@whut.edu.cn)


## Detail

    This repository contains:
    1. a customized version of GEOS (https://trac.osgeo.org/geos/) with certain new distance functions.
    2. a postgres extension to expose the new geos function to PostgreSQL.

## Directories

    geos/        customized geos (based on 3.8.0)
    src/         code for the C++ PostgreSQL extension to expose the new distance functions


## Install instructions

The following instructions have been tested on Ubuntu 18.04, and should work with other Linux distributions with standard compliant C++ compilers.

To compile the customized GEOS:

    (cd geos && mkdir -p build/ && cd build/ && cmake -DCMAKE_CXX_STANDARD:STRING=20 -DCMAKE_INSTALL_PREFIX:PATH=/opt/geos .. && sudo cmake --build . --target install)
    
Then, to compile the pgGEOS extension:

    sudo make with_llvm=no -C src/ clean && make with_llvm=no -C src/ && sudo make with_llvm=no -C src/ install
    
And then, as a PostgreSQL database superuser, execute the following SQL statement:

    CREATE EXTENSION pggeos;

## License

These functions are released under the [LGPL v2.1 License](https://www.gnu.org/licenses/old-licenses/lgpl-2.1.en.html), same as [GEOS](https://trac.osgeo.org/geos/).