If you want to do distances like that, without any data it's of no use.
You might consider looking at openstreetmap's functions to import data into postgis, this will at least give you some point information depending on how well your area of interest is mapped.
But in general, the answer is YES WE CAN. postgis is excelent at calculating distances (as the crow flies) between points.
Vernon wrote:
After having been used PostgreSQL for some years, I just learn the PostGID lately. Currently, I need to solve a street address and distance problem which is to find out the distance between to given street address (or well know location as such the city hall in a city) or to find out whether a street address is inside of a given distance from another street address. I am wondering whether PostGIS can help me to solve the problem or not. I understand I first need to convert a street address into a pair of latitude and Longitude. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
