Opened 8 years ago
Closed 7 years ago
#3059 closed enhancement (fixed)
Allow passing per-dimension parameters in ST_Expand
|Reported by:||strk||Owned by:||dbaston|
Allow ST_Expand to take one amount for each dimension:
ST_Expand(geometry, x float8, y float8, z float8, m float8);
The current function would keep using the same amount for all of them.
Change History (7)
comment:1 by , 8 years ago
|Status:||new → assigned|
|Version:||2.1.x → trunk|
comment:2 by , 8 years ago
|Milestone:||PostGIS 2.2.0 → PostGIS Future|
comment:3 by , 7 years ago
|Milestone:||PostGIS Future → PostGIS 2.3.0|
|Status:||assigned → new|
comment:4 by , 7 years ago
I'm so glad we have you on board Daniel
comment:5 by , 7 years ago
I'm so glad too you are on board Dan, but I must scold you for using ST_Distance_Sphere instead of ST_DistanceSphere. http://postgis.net/docs/manual-2.2/ST_DistanceSphere.html
I'm surprised strk didn't pick up on that since he's the pedantic one.
comment:6 by , 7 years ago
Thanks all, and sorry if I occasionally get nostalgic for a comfortable, well-aged function name from a simpler time.
comment:7 by , 7 years ago
|Status:||new → closed|
This seems like a nice way to improve hackish
ST_DWithinqueries on WGS84 geometries stored as geometry.
So, to find polygons within 1km of a point, you could do:
where 69000 m approximates 1 degree of longitude, and 111111 m approximates 1 degree of latitude (at 52 degrees N)