8,361 reputation
11428
bio website blog.jordogskog.no
location Hedmark, Norway
age
visits member for 4 years, 9 months
seen 10 hours ago

Jul
1
comment Mirrored shape in postgis
What do you mean by mirrored shapes? Why collections because of holes? A polygon can have holes. About eauality, why not use ST_Equals?
Jun
29
awarded  Enlightened
Jun
29
awarded  Nice Answer
Jun
18
comment Creating quadtree index on latitude, longitude data in PostGIS
Why do you want that?
Jun
16
answered postGIS st_equals function not working as expected
Jun
13
revised Converting spatial data to table of vertices using PostGIS?
added 157 characters in body
Jun
13
answered Converting spatial data to table of vertices using PostGIS?
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