Live briefing
Everything about PostGIS
Geospatial extension for the PostgreSQL Database
PostGIS is an open source software program that adds support for geographic objects to the PostgreSQL object-relational database. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC). Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: PostGISA 5-minute orientation
- Skim a recent paper: DEVELOPMENT OF A POSTGIS-BASED METHOD FOR CREATING RISK MAPS OF NATURAL DISASTERS USING THE EXAMPLE OF GEORGIAInfluential work since 2022
- Pick up a classic book: Web Mapping IllustratedThe most-reprinted book on the subject
- Read the landmark paper: Performance analysis of MongoDB versus PostGIS/PostGreSQL databases for line intersection and point containment spatial queriesCited 26 times
- Go sideways: Spatial databaseA closely related topic
- Go sideways: TerraLibA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🏆 Landmark papers (most cited)
Performance analysis of MongoDB versus PostGIS/PostGreSQL databases for line intersection and point containment spatial queries
Parallel algorithm for improving the performance of spatial queries in SQL: The use cases of SQLite/SpatiaLite and PostgreSQL/PostGIS databases
Developing an Intelligent PostGIS Database to Support Accessibility Tools for Urban Pedestrians
GeoSQL-Eval: first evaluation of LLMs on PostGIS-based NL2GeoSQL queries
rpostgis: Linking R with a PostGIS Spatial Database
Evaluating Spatio-temporal Data Models for Trajectories in PostGIS Databases
Comparing speed of Web Map Service with GeoServer on ESRI Shapefile and PostGIS
UrbanWater: Integrating EPANET 2 in a PostgreSQL/PostGIS-Based Geospatial Database Management System
🆕 Influential since 2022
DEVELOPMENT OF A POSTGIS-BASED METHOD FOR CREATING RISK MAPS OF NATURAL DISASTERS USING THE EXAMPLE OF GEORGIA
PostGISer: The first end-to-end fine-tuned large language model for PostGIS GeoSQL query generation
Sistematización de la información de catastro utilizando POSTGRESQL-POSTGIS. Aplicación al análisis de usos del suelo urbano en Alcalá de Henares, España
Empirical Post-Generation Correctness Assessment for Natural-Language Access to Urban PostGIS Databases
Geospatial Data Warehousing: A Case Study on PostGIS, QGIS, and Apache Solr Integration
📚 Books worth reading
Web Mapping IllustratedTyler Mitchell · 2005
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Spatial database A spatial database is a general-purpose database (usually a relational database) that has been enhanced to include spatial data that represents objects…
- TerraLib TerraLib is an open-source geographic information system (GIS) software library. It extends object-relational database management systems (DBMS) to handle…
- GeoSPARQL GeoSPARQL is a model for representing and querying geospatial linked data for the Semantic Web. It is standardized by the Open Geospatial Consortium as…
- Simple Features Simple Features (officially Simple Feature Access) is a set of standards that specify a common storage and access model of geographic features made of…
- JTS Topology Suite JTS Topology Suite (Java Topology Suite) is an open-source Java software library that provides an object model for Euclidean planar linear geometry together…
- Well-known text representation of geometry Well-known text (WKT) is a text markup language for representing vector geometry objects. A binary equivalent, known as well-known binary (WKB), is used…
- Mapbender Mapbender is a graduated project of the Open Source Geospatial Foundation. It was awarded OGC web site of the month in 2008. It is used by PortalU and…
- DE-9IM The Dimensionally Extended 9-Intersection Model (DE-9IM) is a topological model and a standard used to describe the spatial relations of two regions (two…