[postgis-users] Query

[Jaime Mejia]

if you have the coordinates x, y of location and a table with the location (
"puntos_venta") of the outlets, you can find the closest consultation with
the following:

SELECT id, nombre FROM puntos_venta ORDER BY
distance(the_geom,GeomFromText('POINT(x y)',-1)) ASC LIMIT 1

Cordial Saludo,

Jaime Mejía


2009/6/13 <juapabsan at tutopia.com>

> Buen dia lista.
>
>
>
> Agradeceria informacion a lo siguiente,
>
>
>
> Quisiera saber si es posible con postgis lo siguiente.
>
>
>
> Si tengo un punto de venta ubicado en  una direccion (o ubicacion), y me
> hacen una llamada, como puedo saber o como lo remito al punto de venta (POS)
> mas cercano?
>
>
>
> Es posible con postgis hacer esto?
>
>
> Good day list.
>
>
>
> Would appreciate information on the following,
>
>
>
> Let me know if it is possible that with PostGIS.
>
>
>
> If I have a retail outlet located at an address (or location), and I make a
> call, or how can I know what it refers to point of sale (POS) nearest?
>
>
>
> PostGIS is possible to do this?
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090613/bfc5a44b/attachment.html>