Questions about postgis
Read more about postgis
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Select kNN nearest point not already joined in table
Think of this as a low-sophistication routing strategy.
Is there a way to select the nearest point from a table that has not already been processed through a kNN query?
What I have is this:
SELECT *
F...
afs76
Votes: 0
Answers: 1
Update columns' values in CTE
I have three CTEs and I want to update two columns in the last CTE, but I get an error that "the relation does not exist". I am using the CTEs, because, I want to store the whole process in ...
GeoBeez
Votes: 0
Answers: 2
I am getting: No function matches the given name and argument types when executing poytgis function with psycopg2
I am trying to execute a function which comes from an extension (postgis) with psycopg2.
import psycopg2
AFRICA = "africa"
ANTARCTICA = "antarctica"
ASIA = "asia"
AUSTRA...
four-eyes
Votes: 0
Answers: 1
How can I increase the maximum displayed points on Geometry Viewer?
I would like to know how to display more than 100 000 geometries on Geometry Viewer (I'm using PgAdmin 4 & PostgreSQL 9.6).
I have already tried this, which gives the advice to create a config_local....
user18665749
Votes: 0
Answers: 0