PostGIS Reviews & Product Details

PostGIS is an open-source extension for the PostgreSQL relational database that enables the storage, indexing, and querying of geospatial data. By integrating geographic object support directly into the database, PostGIS allows users to perform complex spatial operations using SQL queries. This extension adheres to the Simple Features for SQL specification from the Open Geospatial Consortium (OGC), ensuring compatibility with various GIS applications. Key Features and Functionality: - Spatial Data Storage: Supports a variety of spatial data types, including points, lines, polygons, and multi-geometries, in both 2D and 3D formats. - Spatial Indexing: Utilizes GiST-based R-Tree spatial indexes to enhance the performance of spatial queries. - Spatial Functions: Offers a comprehensive suite of functions for spatial analysis, such as measuring distances and areas, determining intersections, creating buffers, and performing geometric transformations. - Raster Data Support: Provides capabilities for storing and processing raster data, facilitating operations like elevation modeling and image analysis. - Topology Management: Includes tools for managing topological relationships between spatial features, essential for applications like network analysis and cadastral management. - Geocoding and Reverse Geocoding: Features functions for converting between addresses and geographic coordinates, enhancing location-based services. Primary Value and User Solutions: PostGIS transforms PostgreSQL into a powerful spatial database, enabling users to manage and analyze geospatial data directly within their existing database infrastructure. This integration eliminates the need for separate GIS software, streamlining workflows and reducing system complexity. By providing robust spatial functions and efficient indexing, PostGIS allows for the development of sophisticated GIS applications, such as mapping services, spatial data analysis, and location-based decision-making tools. Its adherence to OGC standards ensures interoperability with other GIS platforms, making it a versatile solution for organizations handling geospatial information.

Seller

PostGIS

Discussions

PostGIS Community

Top-Rated Alternatives

View All Alternatives

User Insights

Average based on 16 real user reviews.

Log in to unlock pricing and user insights

PostGIS Integrations

(2)

Integration information sourced from real user reviews.

G2 reviews are authentic and verified.

Here's how.

UH

Verified User in Higher Education

Mid-Market (51-1000 emp.)

6/18/2021

"Learned a lot."

4.5/5

What do you like best about PostGIS?

Easy to use interface and awesome features. Review collected by and hosted on G2.com.

What do you dislike about PostGIS?

Not much to dislike, but maybe some connectivity issues. Review collected by and hosted on G2.com.

Recommendations to others considering PostGIS:

Just gather and review some resources online before starting using and everything else will be fine. It's very easy to use and learn. Review collected by and hosted on G2.com.

What problems is PostGIS solving and how is that benefiting you?

I was learning about spatial databases and how the we can use it, with different approaches and purposes. Review collected by and hosted on G2.com.

Validated ReviewerIncentivizedSource: G2 invite

AI

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

Updated 9/26/2020

Originally submitted 12/23/2019

"Best Open Source Spatial Database!"

5/5

What do you like best about PostGIS?

After using PostGIS, using any commercial database feels like an expensive solution. PostGIS has lots of users and developers. Therefore, in the case of a need or problem arising, looking for a solution in a search engine returns lots of replies from different users and use case scenarios. In daily routines, for people like me (as a GIS expert working on geospatial databases and a SQL lover), maintaining, data collecting, querying a spatial database is easier than using any GIS-related desktop software. Just typing the SQL for the desired result and BAM! Review collected by and hosted on G2.com.

What do you dislike about PostGIS?

As a new PostGIS user, the point I did not like is related to authentication. I have created a few users with limited grants for tables, views, or other objects in the database. Let's say that I have created a user with view and update rights on tables. If a new table is created after I set the rights, I expect the same rights to apply to the newly added tables or views. Review collected by and hosted on G2.com.

Recommendations to others considering PostGIS:

Anyone working with spatial data should try PostGIS. I get nearly the same performance as file-based datasets on 3rd party software. It is not so fast on other database servers. The other commercial ones look like big trucks that can complete big jobs. But in PostGIS, if you have a small dataset, you will get better performance. Review collected by and hosted on G2.com.

What problems is PostGIS solving and how is that benefiting you?

Manipulating and managing spatial data is the job I do. Therefore, I have a few alternatives for storing and using the data. PostGIS provides me faster and better performance compared to its competitors. Review collected by and hosted on G2.com.

Current UserValidated ReviewerSource: Seller invite

CU

Verified User in Utilities

Small-Business (50 or fewer emp.)

6/29/2021

"Great Open Source Platform for Scalable GIS Solution"

4/5

What do you like best about PostGIS?

Open Source Giant among all other Database Review collected by and hosted on G2.com.

What do you dislike about PostGIS?

Not a single dislike just need to be more user friendly and also required Version Management functionality for Concurrent Edits on same objects Review collected by and hosted on G2.com.