meta user
network profile
| bio | website | oegeo.wordpress.com |
|---|---|---|
| location | Salt Lake City, UT | |
| age | 40 | |
| visits | member for | 2 years, 9 months |
| seen | Apr 30 at 21:56 | |
| stats | profile views | 59 |
Geospatial omnivore.
|
Mar 20 |
accepted | In PostGIS, how to count nearby points efficiently? |
|
Mar 16 |
comment |
In PostGIS, how to count nearby points efficiently? That is great feedback, thanks @diciu. Your first option is what I ended up going with, see my |
|
Mar 16 |
comment |
In PostGIS, how to count nearby points efficiently? @PaulRamsey my thought was to narrow down the search results first with ST_DWithin and then perform the final comparison on the subset with <#>, but you are saying it doesn't work like that? Hm. I will need to go back to <#> and ST_DWithin documentation and better understand what I am doing. Thanks for the feedback. |
|
Mar 16 |
comment |
In PostGIS, how to count nearby points efficiently? Thanks for the comments - I figured out soon enough that indeed operator choice was not the problem here, but the execution plan. |
|
Mar 15 |
answered | In PostGIS, how to count nearby points efficiently? |
|
Mar 15 |
asked | In PostGIS, how to count nearby points efficiently? |
|
Jan 11 |
awarded | Popular Question |
|
Jan 6 |
awarded | Popular Question |
|
Oct 8 |
awarded | Popular Question |
|
Aug 2 |
awarded | Yearling |
|
Jul 12 |
awarded | Nice Question |
|
May 22 |
accepted | How to calculate the angle at which two lines intersect in PostGIS? |
|
May 14 |
awarded | Self-Learner |
|
May 10 |
comment |
How to calculate the angle at which two lines intersect in PostGIS? I was actually surprised that it is not a PostGIS function. Thanks for your feedback on this. |
|
May 9 |
comment |
How to calculate the angle at which two lines intersect in PostGIS? Yep thanks, I use the PostgreSQL degrees() function for that. |
|
May 9 |
answered | How to calculate the angle at which two lines intersect in PostGIS? |
|
May 9 |
revised |
How to calculate the angle at which two lines intersect in PostGIS? added 246 characters in body |
|
May 9 |
comment |
How to calculate the angle at which two lines intersect in PostGIS? I redid the calculations is EPSG:3785 and it does make a difference - I'll amend the question to show the new results - but the result still does not reflect the actual angle. |
|
May 9 |
comment |
How to calculate the angle at which two lines intersect in PostGIS? It was EPSG:4326 coordinates originally, I included the ST_Translate just to be 100% sure all processing would be done in the same CRS. I will try a conformal projection, thanks. |
|
May 9 |
awarded | Announcer |
