on 06-30-2015 4:39 PM
i am wondering if any one has done this. i am trying to build a polygon based on a ST_Point and adding a distance, for example I have a Long and Lat point and i want to build an area of the St_point plus 50 km around my st_point.
I have seen how people calculate distances between two points or map a point, etc... which is fine.. my requirement, however, is to see if i can build a polygon based on a point and a given distance.
thank you in advance.
i am stil not able to answer this question, however, i went a different route on identifying two points and calculating the distance then i would filter out the distances which are greater than the distance i am setting up. this is working fine, however, the only thing i am not so sure is the margin of error. it seems like it increases as i increase the distance between the two points i am testing. i also wonder if the distance calculated by the geo-spatial functions are direct distances, driving distances, etc.
anyways, i dont think this is an issue for me, however, i would still try to find out how to create the polygon from a point and a distance provided. i may have to create a custom function for that scenario.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.