Question : It doesn’t seem to be a WKB, since it’s basically a string, so what is it? Answer : […]
Tag: postgis
Installing PostGIS in a different schema causes topology extension to not find geometry type
Question : I have a sql dump of the schema of an existing database that is working correctly. When I […]
Trying to create PostGIS database
Question : I am trying to create a spatially enabled PostGIS database by following the PostGIS documentation. In the short […]
Limiting number of results in a Partition using OVER(PARTITION BY)
Question : In the following query, why is it that we have to limit the results returned from each Partition […]
Is it possible to schema-qualify an operator?
Question : Let’s say I create an extension, like PostGIS, in the schema postgis, CREATE EXTENSION postgis WITH SCHEMA postgis; […]
How can I manage an exception generated by Postgis?
Question : I am running the following query on Postgres 10.3/Postgis 2.4: create table table_c as ( select A.*, B.area_name, […]
PostgreSQL Geo Spatial Query is slow
Question : After given up with MySQL i have tried Elasticsearch and now wan’t to see if I could go […]
How do I render GeoHashes with PostgreSQL?
Question : Are there any geohash implementation for PostgreSQL? I couldn’t find any. Answer : PostGIS supports it with ST_GeoHash […]
Finding road segements which are not split at intersection.(Query Optimization )
Question : I have a query in which I am trying to find the road segments which intersect but are […]
PostGIS Intersects Query takes lot of time to get the result
Question : I am developing a webmapping application in which I used PosgreSQL with PostGIS plugin as my DB. I […]