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 …

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 …

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.

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 …

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 …

Oct 13, 2018 · The solution is still the exact installation with the version numbers. Especially the package postgresql-XX-postgis-Y.Z-scripts provides the matching file associations. Here is the …

Feb 15, 2021 · Now, I need to add PostGIS support to the same container. Is that possible and how can I do that? I'm new to both Postgres and PostGIS so forgive my ignorance about the …

Jul 10, 2020 · The main reference about Geography datatype seems docs/using_postgis_dbmanagement: Prior to PostGIS 2.2, the geography type only supported …

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 …

how to get coordinate of a point from the map to my database (postgresql) i wanted to draw a polygon or line and get the coordinates of this polygons from the oppenstreetmap to my …