2
votes
2answers
85 views

How to find the destination point given a start point, distance and bearing?

If I have a starting point as well as distance and a bearing to the destination point, how can I find the coordinates of the destination point using PostGIS? I'm looking for a PostGIS equivalent to ...
4
votes
0answers
51 views

Compute visibility graph on sphere

I have a PostGIS table with some polygons (stored using the geography data type). They represent regions on a spherical earth. For each pair of vertices chosen from among all the polygons, I want to ...
2
votes
1answer
97 views

Draw a line and a buffer around it onto the spheroid

I need to draw a line between two points and create a buffer around this line. The only difficulty is that I need to draw not a "cartesian" line but a line that is laying on the spheroid. I tried to ...
0
votes
0answers
431 views

Implementing custom (Vincenty/Haversine formula) functions for MySQL vs Using PostGIS?

I currently am using MySQL for all of my relational data. I have hit a crossroads with geo calculations. Since, MySQL does not have good support for spatial functions, I am contemplating on using ...
2
votes
1answer
711 views

MySQL GeoSpatial function for ST_Distance_Spheroid? Metric used in return Type of GLength?

Is there a ST_Distance_Sphere, ST_Distance_Spheroid equivalent function in MySQL's GeoSpatial Support? If not, any way to emulate this? What is the metric used in return type of ...
2
votes
2answers
1k views

ST_Distance versus ST_Distance_Spheroid?

As my client software uses lat/lon coordinates when communicating with my (spherical mercator) postgis database i decided to ST_Transform every geometry to WGS-84. However i noticed that ST_Distance ...
1
vote
1answer
223 views

Lambert cylindrical projection support in PostGis

Does PostGis support Lambert cylindrical projection or is there a way to add support for it? I'm probably searching the wrong terms, but google isn't bringing up anything useful. Any help is ...