[postgis-users] Calculation of Radius in PostGIS
Diego Roberto
diegorrborges at gmail.com
Fri Jul 5 10:06:56 PDT 2013
Hello,
I need to generate a calculation of lightning and I'm not getting. I have
the following situation. I have a point with the coordinates -16.675297,
-49.260196 and was stored in the database in spatial format with SRID 4326.
Need to generate a buffer of 100 meters from this point and check which
other points are within this buffer to return to the user.
Realize the following conversion to make this calculation:
http://spatialreference.org/ref/epsg/2163/
SELECT i.id_impediments
FROM THE impediments i
WHERE st_dwithin (transform (i.geometry_data, 2163),
transform (GeomFromText ('POINT (-16.675297 -49.260196)', 4326), 2163),
100)
My questions are:
This is the best way to calculate a buffer and from the moment I work with
the conversion to SRID 2163 SELECT can do this only for the range of
coordinates described in this link:
I believe that this conversion also realize that is not the correct way.
Could help me transferring any material or link so I can study?
I know there's no way I generate a buffer with WGS84 (4326) so I convert to
2163. Working with this?
Thank you.
And I appreciate the attention.
--
________________________________________________
Diego Roberto
________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130705/22df1496/attachment.html>
More information about the postgis-users
mailing list