[postgis-users] Address Geocoding

[Oscar Zamudio]

When you write: "FROM (roads, settlements, poi, province, etc...)" you
actually mean one table at a time? Because if you try more than one table
separated by commas, there will be an error. If you are trying to use more
than one table I'm afraid you will need to use a JOIN clause ...
Regards,


On Wed, Mar 24, 2010 at 6:21 AM, ibrahim saricicek <
ibrahimsaricicek at gmail.com> wrote:

> Hi;
>
> for reverse geoceding now using this and works fine;
>
> SELECT id, the_geom
> FROM (roads, settlements, poi, province, etc...)
> WHERE
>   the_geom && SetSRID('BOX3D(x+0.01 y+0.01, x-0.01 y-0.01)'::box3d, 4326)
> ORDER BY
>   ST_Distance(the_geom, GeomFromText('POINT(x y)', 4326))
> LIMIT 1;
>
> regards...
>
>
> On Fri, Mar 19, 2010 at 8:23 PM, Stephen Woodbridge <
> woodbri at swoodbridge.com> wrote:
>
>> http://www.google.com/#hl=en&source=hp&q=postgis+geocoder
>>
>> Ricardo Bayley wrote:
>>
>>> Hi fellows,
>>>
>>> I was wondering if any of you have a good approach to do Address
>>> Geocoding within postgis.
>>> Any ideas, considerations, thoughts ??
>>>
>>> thanks in advanced.
>>>
>>>
>>> Warm regards,
>>>
>>>
>>> Ricardo
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> 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/20100329/338e6afb/attachment.html>