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 …

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...

Jul 18, 2015 · I'm importing many sets of geodata into PostGIS, and they have different SRID's. (Some have EPSG:3857, some EPSG:4326, some something else). I'd like to create an additional geometry …

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.

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. …

Jul 16, 2024 · Here's a quick summary about what I'm trying to do: I have 3 tables in Postgres, 'a' and 'b', each have a Polygon column, and 'c' has a Point column. What I'm trying to do here is to get the …

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. …

May 22, 2023 · sudo apt-get remove libboost-serialization1.71.0 libgmpxx4ldbl libprotobuf-c1 libsfcgal1 postgis-doc postgresql-15 postgresql-15-postgis-3 postgresql-15-postgis-3-scripts postgresql-client …

Nov 15, 2014 · The postGIS page gives a near identical example: SELECT ST_PointFromText('POINT(-71.064544 42.28787)', 4326); These previous two example just seem to show you how to generate a …

I have created one table in my PostGIS nut I cannot insert point. What is wrong with my query? CREATE TABLE app ( p_id INTEGER PRIMARY KEY ); SELECT …