4,824 reputation
940
bio website
location
age
visits member for 2 years, 11 months
seen 14 mins ago

Mar
24
revised Getting incorrect coordinates for ortho photo using GDAL libraries
added 12 characters in body
Mar
24
comment Is a multi-database select possible with DB Manager?
I can't provide a specific answer, but the thing you are looking for is called "Foreign Data Wrapper".I've only read about it and not used it so far.
Mar
23
comment How to use the multiprocessing module on python to execute a spatial join?
multiprocessing or multithreading? take some time to familiarize yourself with the difference between those two and I believe the answer will come
Mar
18
comment Finding the Center Line from a set of 3D Points
can you provide an example?
Mar
13
comment PG::UndefinedFunction: ERROR: operator does not exist: point = unknown
it seems that it is postgres' Point type. postgis.net/docs/AddGeometryColumn.html
Mar
13
comment PG::UndefinedFunction: ERROR: operator does not exist: point = unknown
if you are asking about the pros/cons of using postgis datatypes over the native geometry datatypes that is another question that I cannot fully answer. The second part is pretty straight forward. If you change something in a production server you are going to break something somewhere else, and your service will be halted until you find it and fix it. Your boss wont like that at all
Mar
13
revised PG::UndefinedFunction: ERROR: operator does not exist: point = unknown
added 539 characters in body
Mar
13
revised PG::UndefinedFunction: ERROR: operator does not exist: point = unknown
added 99 characters in body
Mar
13
revised PG::UndefinedFunction: ERROR: operator does not exist: point = unknown
added 99 characters in body
Mar
13
answered PG::UndefinedFunction: ERROR: operator does not exist: point = unknown
Mar
13
comment GDAL build from source throwing OpenSSL errors on Ubuntu
try ubuntugis-unstable channel sudo sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
Mar
13
comment Determine which points are contained inside a given polygon
no harm done, we are all friends here :D
Mar
13
comment Determine which points are contained inside a given polygon
@JohnBarça For this particular case yes, but is very common to have a database with field measurmetns taken from a point, and the need for polygon came much later.
Mar
13
revised Determine which points are contained inside a given polygon
sql typos
Mar
13
revised Determine which points are contained inside a given polygon
edited body
Mar
13
comment Determine which points are contained inside a given polygon
after you have confirm that the querry that transforms points to polygon is to you liking it is very advisable to convert the query to function: region(region_id) - > region_polygon postgresql.org/docs/9.3/static/sql-createfunction.html
Mar
13
answered Determine which points are contained inside a given polygon
Mar
13
comment Postgis identify points on the polygon border
combines well with gis.stackexchange.com/questions/54661/…
Mar
13
comment Count Points in Polygon with Postgis
The querry does not utilize spatial indexes: explain.depesz.com/s/U6Iy. Nicklas answer does : explain.depesz.com/s/nhH
Mar
4
comment How to create folders from shapefile attributes using ArcPy/Python?
why the hell esri is offering a replacement for makedirs?