[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Address Geocoding
From: Oscar Zamudio <cmntlk () gmail ! com>
Date: 2010-03-30 1:49:56
Message-ID: y2vd23fc8601003291849qf7e10128vd1fd9b5c56de9040 () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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@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@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@postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
[Attachment #5 (text/html)]
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 ...<div> \
Regards,</div><div><br><br><div class="gmail_quote">On Wed, Mar 24, 2010 at 6:21 AM, \
ibrahim saricicek <span dir="ltr"><<a \
href="mailto:ibrahimsaricicek@gmail.com">ibrahimsaricicek@gmail.com</a>></span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex;"> Hi;<br><br>for reverse geoceding now using this and \
works fine;<br><br>SELECT id, the_geom <br>FROM (roads, settlements, poi, province, \
etc...)<br>WHERE<br> the_geom && SetSRID('BOX3D(x+0.01 y+0.01, x-0.01 \
y-0.01)'::box3d, 4326)<br>
ORDER BY<br> ST_Distance(the_geom, GeomFromText('POINT(x y)', \
4326))<br>LIMIT 1;<br><br>regards...<div><div></div><div class="h5"><br><br><div \
class="gmail_quote">On Fri, Mar 19, 2010 at 8:23 PM, Stephen Woodbridge <span \
dir="ltr"><<a href="mailto:woodbri@swoodbridge.com" \
target="_blank">woodbri@swoodbridge.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid \
rgb(204, 204, 204);padding-left:1ex"><a \
href="http://www.google.com/#hl=en&source=hp&q=postgis+geocoder" \
target="_blank">http://www.google.com/#hl=en&source=hp&q=postgis+geocoder</a><br>
<br>
Ricardo Bayley wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid \
rgb(204, 204, 204);padding-left:1ex"><div><div></div><div> Hi fellows,<br>
<br>
I was wondering if any of you have a good approach to do Address Geocoding within \
postgis.<br> Any ideas, considerations, thoughts ??<br>
<br>
thanks in advanced.<br>
<br>
<br>
Warm regards,<br>
<br>
<br>
Ricardo<br>
<br>
<br></div></div>
------------------------------------------------------------------------<div><br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" \
target="_blank">postgis-users@postgis.refractions.net</a><br> <a \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
</div></blockquote><div><div></div><div> <br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" \
target="_blank">postgis-users@postgis.refractions.net</a><br> <a \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
</div></div></blockquote></div><br> \
</div></div><br>_______________________________________________<br> postgis-users \
mailing list<br> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
<br></blockquote></div><br></div>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic