Mar 30, 2017 · PG::InternalError: ERROR: GetProj4StringSPI: Cannot find SRID (4326) in spatial_ref_sys I know that I enabled the PostGIS extension. How do I fix this?

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.

For ubuntu 20.04, postgresql 13.1, run sudo apt install postgis postgresql-13-postgis-3-scripts. After which you can run create extension postgis; postgresql query.

May 8, 2025 · 1 I work with geospatial data and want to put it into a (postgres) database with the postgis plugin installed. I know I need the geozero, geo and sqlx crate and also found an example here …

Jun 11, 2012 · I have a table with some geometry types in and need to be able to return the SRID of a given field. How can I do this. I have had a search but all I can find is the function to alter a SRID. In …

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 database using javascript

Jan 6, 2017 · While PostGIS does have it's own rtree-on-gist implementation it's very similar to the one used by PgSQL for its core support of graphical objects for the simple reason that originally we …

Jan 17, 2024 · It's in PostGIS but I'm happy to work in R or QGIS too. I was thinking about snapping each vertex to a 5 m grid but really I want to snap the vertices to the line of the adjacent polygon... or …

Since PostGIS is database-specific, it must be enabled per database. Sometimes, when working with multiple databases, we might run the query in the wrong one, which causes errors like "type …

Jan 20, 2021 · I am trying to add PostGIS extension to a postgresql database on my WSL2 (with Ubuntu 20.04) for a django project. I have already installed postgresql, postgis and all dependencies with the …