8,231 reputation
11327
bio website blog.jordogskog.no
location Hedmark, Norway
age
visits member for 4 years, 7 months
seen 58 mins ago

Apr
27
answered Problem with importing WKT to PostGIS
Apr
7
comment ST_MakePoint returns an error when using Python
Take a look at the log of the postgresql server. There you will see how the query is received from python to PostGIS.
Apr
2
comment st_length column in Postgres db and ArcGIS under WGS84
If it is PostGIS that populates that length column, the PostGIS doc is the place to look. Second sentance: postgis.net/docs/manual-2.1/ST_Length.html
Mar
23
comment Increase buffer until value is reached?
Well, 600 points to compare to 300k points is not that much. With a spatial index it is close to nothing :-). And if you combine sales points and dealers by some attribute instead of doing it spatial by distance it is even cheaper.
Mar
21
answered Increase buffer until value is reached?
Mar
19
comment How to select distinct geometries and ids with PostGIS?
And if you want to be sure to get the first occurrence in the table, you have to sort on something giving the right order. I don't think that the row order is guaranteed.
Mar
19
comment How to select distinct geometries and ids with PostGIS?
A note: This will compare the bounding box, not the actual geometry. So, two geometries that share the exactly same bounding box will be regarded as the same, and only 1 of them will be returned. It is much safer (and faster) to use id if you have.
Mar
16
comment How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
@Jay Cummins Interesting! That must more or less be considered a bug I guess?
Mar
14
revised How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
deleted 56 characters in body
Mar
14
answered How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
Mar
6
answered PostgreSQL PostGIS ST_Point_Inside_Circle() radius in meters
Feb
24
comment What's the PostGIS equivalent to Extract Nodes in fTools / QGIS?
Just a typo. It should have been "it" :-)
Feb
24
revised What's the PostGIS equivalent to Extract Nodes in fTools / QGIS?
added 1 character in body
Feb
22
answered What's the PostGIS equivalent to Extract Nodes in fTools / QGIS?
Jan
29
revised PostGIS ST within does not exist
edited body
Jan
28
answered PostGIS ST within does not exist
Dec
2
comment create spatial data on the fly for a timeline application
PostGIS can ...
Dec
2
comment finding the outermost border of a set of geomertries (circles)
St_union is what you want. It removes the interior borders. Then checking the distances to the vertexes is not enough since the correct answer might be on an edge between. St_closestpoint will check both vertex points and edges
Dec
2
revised finding the outermost border of a set of geomertries (circles)
added 8 characters in body
Dec
2
comment finding the outermost border of a set of geomertries (circles)
Right you are,thanks :-)