PostGIS - Spatial and Geographic objects for PostgreSQL

  •        2693

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. PostGIS adds extra types (geometry, geography, raster and others) to the PostgreSQL database. It also adds functions, operators, and index enhancements that apply to these spatial types.



Its features include

  • Processing and analytic functions for both vector and raster data for splicing, dicing, morphing, reclassifying, and collecting/unioning with the power of SQL
  • raster map algebra for fine-grained raster processing
  • Spatial reprojection SQL callable functions for both vector and raster data
  • Support for importing / exporting ESRI shapefile vector data via both commandline and GUI packaged tools and support for more formats via other 3rd-party Open Source tools
  • Packaged command-line for importing raster data from many standard formats: GeoTiff, NetCDF, PNG, JPG to name a few
  • Rendering and importing vector data support functions for standard textual formats such as KML,GML, GeoJSON,GeoHash and WKT using SQL
  • Rendering raster data in various standard formats GeoTIFF, PNG, JPG, NetCDF, to name a few using SQL
  • Seamless raster/vector SQL callable functions for extrusion of pixel values by geometric region, running stats by region, clipping rasters by a geometry, and vectorizing rasters
  • 3D object support, spatial index, and functions
  • Network Topology support

http://postgis.net/
https://github.com/postgis/postgis/

Tags
Implementation
License
Platform

   




Related Projects

GeoMesa - Suite of tools for working with big geo-spatial data in a distributed fashion


GeoMesa is an open-source, distributed, spatio-temporal database built on a number of distributed cloud data storage systems, including Accumulo, HBase, Cassandra, and Kafka. Leveraging a highly parallelized indexing strategy, GeoMesa aims to provide as much of the spatial querying and data manipulation to Accumulo as PostGIS does to Postgres.

Tile38 - Geospatial database, spatial index, and realtime geofence


Tile38 is a in-memory geolocation data store, spatial index, and realtime geofence. It supports a variety of object types including lat/lon points, bounding boxes, XYZ tiles, Geohashes, and GeoJSON. It supports spatial index with search methods such as Nearby, Within, and Intersects, Realtime geofencing through persistent sockets or webhooks and lot more.

BuntDB - Embeddable, in-memory key/value database for Go with custom indexing and geospatial support


BuntDB is a low-level, in-memory, key/value store in pure Go. It persists to disk, is ACID compliant, and uses locking for multiple readers and a single writer. It supports custom indexes and geospatial data. It's ideal for projects that need a dependable database and favor speed over data size.The desire to create BuntDB stems from the need for a new embeddable database for Tile38 and SummitDB.

postgis - PostGIS spatial database extension to PostgreSQL


PostGIS spatial database extension to PostgreSQL

SummitDB - In-memory NoSQL database with ACID transactions, Raft consensus, and Redis API


SummitDB is an in-memory, NoSQL key/value database. It persists to disk, uses the Raft consensus algorithm, is ACID compliant, and built on a transactional and strongly-consistent model. It supports custom indexes, geospatial data, JSON documents, and user-defined JS scripting.Under the hood it utilizes Finn, Redcon, BuntDB, GJSON, and Otto.



Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster


Postgres-XL is a horizontally scalable open source SQL database cluster, flexible enough to handle varying database workloads like OLTP, Business Intelligence requiring MPP parallelism, Key value store, GIS Geospatial and lot more.

GeospatialIntro


Location-based applications are everywhere. From AccuWeather to Zillow, it seems that every application has some sort of geospatial integration or feature. In this talk, you will get an introduction to developing .Net applications utilizing the Bing Maps web API front-ending a geospatial database. You will learn that adding geospatial to your application is not only easy but also fun.

north-american-hipster - a geospatial hack of the DPLA metadata database


a geospatial hack of the DPLA metadata database

cartodb20 - Geospatial database for the cloud


Geospatial database for the cloud

SpatiaLite - Spatial SQL


SpatiaLite is an open source library intended to extend the SQLite core to support fully fledged Spatial SQL capabilities. SQLite is intrinsically simple and lightweight, It is a single lightweight library implementing the full SQL engine. SpatiaLite is smoothly integrated into SQLite to provide a complete and powerful Spatial DBMS (mostly OGC-SFS compliant). Using SQLite + SpatiaLite you can effectively deploy an alternative open source Spatial DBMS roughly equivalent to PostgreSQL + PostGIS.

geogig - GeoGig project


Welcome to the GeoGig project, exploring the use of distributed management of spatial data. GeoGig draws inspiration from Git, but adapts its core concepts to handle versioning of geospatial data. Users are able to import raw geospatial data (currently from Shapefiles, PostGIS or SpatiaLite) in to a repository where every change to the data is tracked. These changes can be viewed in a history, reverted to older versions, branched in to sandboxed areas, merged back in, and pushed to remote repositories. GeoGig is written in Java, available under the BSD License.Version 1.1.1 has been released and it is available for download.

spatial4j - A Geospatial Library for Java


Spatial4j is a general purpose spatial / geospatial ASL licensed open-source Java library. It's core capabilities are 3-fold: to provide common geospatially-aware shapes, to provide distance calculations and other math, and to read shape formats like WKT and GeoJSON.

iGeospatial: Spatial Schema


The Open Geospatial Library aims to provide an open source GIS library for the .NET framework. The library will implement various Open Geospatial Consortium (OGC) and ISO specifications. Currently, we are in the process of porting and enhancing the JTS Topology Suite library,...

MB-python


python utilities for MB-System. Tools for using multibeam sonar data and metadata with MB-System, including interacting with a PostGIS geospatial database.

affinitybridge-geoquery


Drupal module providing Views handlers for running geospatial queries against a PostGIS database.

geopeto - Geospatial PostGIS Toolkit


Geospatial PostGIS Toolkit

PostGIS-Arc Connector


This project produces an Extension and VBA module that allows ESRIs ArcMap (v8.x) product to access Open Source Postgresql/PostGIS spatial data tables. Includes importing tables and exporting/updating back to the database. Currently using Postgresql OD

SQL Server Geospatial Services


The SQL Server Geospatial Services project provides access to spatial data stored in SQL Server 2008 via web services.

gpx2pgsql - Store GPX dump in a PostgreSQL database with PostGIS extension


Store GPX dump in a PostgreSQL database with PostGIS extension

MongoCities


A tool that scrapes the U.S. Census website and creates a Mongo database of every city/town/CDP in the U.S. with geospatial indexing and other information. Simply install Mongo and run the code, OR just create database from the backup stored in the dump directory.