2
votes
0answers
19 views

Problem with postgres/quantum converting long/lat to suitable projection/SRID [duplicate]

I'm sure it's a simple question but this is all very new to me and after a lot of internet searching my points are still in the sea! I have a set of UK postcode data that I have converted into ...
4
votes
2answers
582 views

ST_Distance is not delivering right results

I want to calculate the distance between lat/lon points. I tried the following queries: Select ST_DISTANCE(ST_GeomFromText('POINT(-73.97923 40.75571)', 4326), ST_GeomFromText('POINT(-73.974509 ...
2
votes
2answers
2k views

Problem when calculating longitude and latitude for points

I have a PostGIS database with SRID=900913 (Google Mercator) and I would like to know the latitude and longitude of points. I use this command: ST_X(ST_TRANSFORM(the_geom,4283)) Following what is ...