Menu
My company is looking at different database providers, and how they implement Geospatial queries to get distances from a Lat/Long for a number of records.
We are going to investigate PostgreSQL as a potential database platform.
535
PostgreSQL has several extensions so spatial and geometry data can be treated as first-class objects within your PostgreSQL database. PostgreSQL has several extensions so spatial and geometry data can be treated as first-class objects within your PostgreSQL database.
In order to support spatial data in PostgreSQL, we need to perform the following steps: Install the PostgreSQL database on your local. Install PGAdmin or a GUI to manage the local PostgreSQL database server. Install the PostGIS extension to provide support for the spatial data types like points, lines, geometry etc.
Robust, reliable open source relational database PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying.
PostGIS adds spatial capabilities to the PostgreSQL relational database. It extends PostgreSQL so it can store, query, and manipulate spatial data.
It's PostGIS. For reference you have manual, wiki and more...
71
If you want to spatially enable a PostgreSQL database you can do so with PostGIS, it's compliant with the Open Geospatial Consortium's Simple Features Interface Standard for SQL too.
35
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
