Question : The Problem I am creating a database of Countries, Regions, Cities and Postal Codes. Here’s an example to […]
Tag: postgis
Can’t get this PostgreSQL query to run faster
Question : I’m running PostgreSQL 9.6 with PostGIS 2.3.3 I’m trying to make this rather critical query go faster (looking […]
Undefined symbol when migrating to Postgres 11 [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
PostgreSQL: Cannot change directory to /root
Question : I am trying to copy a table planet_osm_polygon from one database osm to another test. I su postgres […]
Get N closest relations by distance
Question : Suppose I have the products table: create table products ( id integer primary key, name varchar(200) ); And […]
PostgreSQL query slows due to ORDER BY even with an index
Question : I have the following query to find offices that service a given area. When I run this query […]
How do I go from a PostgreSQL native point type to a PostGIS point?
Question : If I have a point SELECT point(long,lat); How do I go from that to a PostGIS point? Answer […]
How to use pg_restore in database with different postgis installation (postgis schema location)?
Question : I have database1 where postgis is installed in the public schema. And database2 where postgis is located in […]
PostGIS ERROR: operator does not exist: postgis.geometry @ geometry
Question : I have had PostgreSQL 9.3.1 and PostGIS 2.1.0 installed (via https://github.com/PostgresApp/PostgresApp/releases/tag/9.3.1.1-RC1) and working on my laptop for some […]
Finding the nearest geo points across two tables?
Question : I have two tables, both have lat/lon columns within same country (UK). Tables sizes are roughly 80M and […]