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 <[email protected]>
> 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
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
