Jul 27, 2014 · I've got PostgreSQL and pgAdmin installed, but I want to add a PostGIS server so I could work on a Geographic Informations System project. I'm following this tutorial, which assumes …

Oct 3, 2024 · I want to install PostGIS with the Stack Builder 4.2.1 for PostgreSQL 17. However, I dont have the option of choosing PostGIS. The category "spatial extension" is simply missing. …

Apr 13, 2017 · I am very new to PostGIS/PostgreSQL. In fact, I downloaded it because of the answers I got to this question: Distance between centroid and farthest point of polygon I installed both …

Feb 28, 2021 · CREATE EXTENSION postgis; and it worked so i think it is a problem to do with my specific postgres user

The postgis extension does not come with vanilla postgres, which does ship with a whole bunch of more general purpose extensions, though nothing notable for geospatial.

Nov 25, 2018 · I wanted to know if there is a way to determine that PostGis was enabled on a database. I am trying to replicate my production server with my dev machine and I am not sure if the database …

I want to create an application platform based on PostGIS data. I read the documentation where I saw the prerequisite to install GEOS, GDAL and Proj4. The main problem is I am using windows platfor...

A great solution is to use QGIS as a GUI for PostGIS. QGIS is a fully-functional GIS (I prefer to think of it actually as a meta-GIS given that it is built on many GIS packages).

Jun 23, 2023 · Here's my recommendation. For just PostgreSQL with Postgis Assuming you are on Linux or Mac, create a directory called gis using mkdir gis and go into the directory by doing cd gis. …

Jun 23, 2019 · I have a PostGIS table with a geometry field of SRID 3857 data. I want to get the centroid of the geometry as lat/lon coordinates, but can't seem to convert the values correctly: SELECT ST_X(