I've recently started looking into using spatial ETL on Mysql (not the best-endowed database in this respect, but never mind). Now to find a distance between 2 points I can use trig calculations for given latitude and longitude co-ordinates. I can find these co-ords for each post code I give easily enough in Multimap, for example.
Now the GIS pages I've perused seen to indicate that using WKT (well known text format) allows you to calculate distances using built-in gis formulas (even in Mysql). However I can't find anywhere (spent several hours on google) that converts long/lat easily to WKT, or gives the WKT data for relevant zipcode/postcode. Does anyone know if such a site or tool exists?
Now the GIS pages I've perused seen to indicate that using WKT (well known text format) allows you to calculate distances using built-in gis formulas (even in Mysql). However I can't find anywhere (spent several hours on google) that converts long/lat easily to WKT, or gives the WKT data for relevant zipcode/postcode. Does anyone know if such a site or tool exists?

Comment