7,288 reputation
11223
bio website blog.jordogskog.no
location Hedmark, Norway
age
visits member for 3 years, 6 months
seen 8 hours ago

Mar
26
revised PostgreSQL : question about SELECT .. WHERE .. = max()
added 207 characters in body
Mar
26
answered PostgreSQL : question about SELECT .. WHERE .. = max()
Mar
26
answered How to speed up a query for nearest linestring to point data
Mar
16
answered PostgreSQL : total length of roads in polygon
Mar
15
revised PostgreSQL : finding all lines intersecting with a polygon
added 16 characters in body
Mar
15
answered PostgreSQL : finding all lines intersecting with a polygon
Mar
13
comment Select point with highest value within a buffer
This seams to be a work for a spatial database to do with sql.
Mar
12
comment using postgis function in pyqgis
You need a second parameter for the buffer function that tells what buffer you want.
Mar
7
comment spatial database vs spatial datastructure?
Yes, I think PostgreSQL is much faster. That is often the case :-)
Mar
7
comment spatial database vs spatial datastructure?
You don't need to do the bounding box comparassion manually. It is built into ST_Intersets.
Mar
7
answered how to Find n nearest lines for the given points from a collection of lines?
Feb
27
awarded  Nice Answer
Feb
1
revised When would a PostGIS geometry compare using ~= return true when ST_Equals returns false?
deleted 135 characters in body
Feb
1
answered When would a PostGIS geometry compare using ~= return true when ST_Equals returns false?
Jan
8
awarded  Popular Question
Jan
3
answered Intersect and MBR in POSTGIS and Mysql
Nov
20
comment How can I improve the performance and start-up time of arcgis 10.x?
If you have a bad connection to the license server that can make things very slow. Note that license servers is not needed with open source software :-)
Nov
11
revised ST_Intersection point of two 3D linestrings - how is the Z value calculated?
deleted 7 characters in body
Nov
11
comment ST_Intersection point of two 3D linestrings - how is the Z value calculated?
This will not give the right answer in all cases. example is the linestrings: LINESTRING(2 0 0, 2 6 50) and LINESTRING(0 3 0, 5 3 0)
Nov
11
answered ST_Intersection point of two 3D linestrings - how is the Z value calculated?