[postgis-users] Retrieve a feature having point coordinates

[Michel Seuthe]

Yap, as i said it only works for points. If you have lines or polygons you
may build the bounding box of them and try it with st_xmin etc.
It did it this way:

SELECT id,tags,linestring
FROM ( SELECT id,tags,linestring,(each(tags)).key AS key FROM ways ) sub
WHERE st_xmin(st_box2d(linestring)) >=9.362383 AND
st_xmax(st_box2d(linestring)) <=9.417143
AND st_ymin(st_box2d(linestring)) >= 51.478924 AND
st_ymax(st_box2d(linestring)) <=51.511413;



2011/12/27 Alessandro Candini <candini at meeo.it>

>  It dosn't work sayng to me the following:
> ERROR:  Argument to X() must be a point
>
> Maybe you want to try it this way:
>
> SELECT gid,geom FROM mytable
> WHERE st_x(geom) >=45.19 AND st_x(geom) <=45.21
> AND st_y(geom) >=23.29 AND st_y(geom) <=23.31
>
> It finds all points in the given bounding box. But you cannot specify
> exactly one point, because there could be more than one at this point.
>
> Hope that helps although.
>
> Cheers.
>
>
> 2011/12/27 Alessandro Candini <candini at meeo.it>
>
>> Hi list.
>> I'm new to Postgis world and I have a probable dumb question:
>> I have a shape file inserted into a postgis database through shp2pgsql
>> utility and I would like to retrieve a feature ID giving as input a pair of
>> lat/lon coordinates.
>> Something like "SELECT gid from mytable WHERE point_is_into(45.2, 23.3);"
>> How can I achieve this?
>>
>> Thanks in advance.
>>
>> --
>> Alessandro Candini
>> MEEO S.r.l.
>> Via Saragat 9
>> I-44122 Ferrara, Italy
>> Tel: +39 0532 1861501
>> Fax: +39 0532 1861637
>> http://www.meeo.it
>>
>> ========================================
>> "ATTENZIONE:le informazioni contenute in questo messaggio sono
>> da considerarsi confidenziali ed il loro utilizzo è riservato unicamente
>> al destinatario sopra indicato. Chi dovesse ricevere questo messaggio
>> per errore è tenuto ad informare il mittente ed a rimuoverlo
>> definitivamente da ogni supporto elettronico o cartaceo."
>>
>> "WARNING:This message contains confidential and/or proprietary
>> information which may be subject to privilege or immunity and which
>> is intended for use of its addressee only. Should you receive this
>> message in error, you are kindly requested to inform the sender and
>> to definitively remove it from any paper or electronic format."
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at postgis.refractions.nethttp://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> --
> Alessandro Candini
> MEEO S.r.l.
> Via Saragat 9
> I-44122 Ferrara, Italy
> Tel: +39 0532 1861501
> Fax: +39 0532 1861637http://www.meeo.it
>
> ========================================
> "ATTENZIONE:le informazioni contenute in questo messaggio sono
> da considerarsi confidenziali ed il loro utilizzo è riservato unicamente
> al destinatario sopra indicato. Chi dovesse ricevere questo messaggio
> per errore è tenuto ad informare il mittente ed a rimuoverlo
> definitivamente da ogni supporto elettronico o cartaceo."
>
> "WARNING:This message contains confidential and/or proprietary
> information which may be subject to privilege or immunity and which
> is intended for use of its addressee only. Should you receive this
> message in error, you are kindly requested to inform the sender and
> to definitively remove it from any paper or electronic format."
>
>
> _______________________________________________
> 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/20111227/745ee9ac/attachment.html>