<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16437"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=561142202-12122011><FONT color=#0000ff
size=2 face=Arial>fixed.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=561142202-12122011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=561142202-12122011><FONT color=#0000ff
size=2 face=Arial>You get 4 because it interpolates 4 addresses at the 2 on one
side and 2 on the other where harwood cuts. Since we aren't offsetting the
point to the correct side of the street, it gives the same point for
each.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=561142202-12122011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=561142202-12122011><FONT color=#0000ff
size=2 face=Arial>If you only care about the point, what you can do is just ask
for the first result. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=561142202-12122011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=561142202-12122011>
<DIV><B><FONT color=#0000ff size=2 face=Arial>SELECT addy,
ST_X(ST_SetSRID(geomout,4326)), ST_Y(ST_SetSRID(geomout,4326)),
rating</FONT></B></DIV>
<DIV><B><FONT color=#0000ff size=2 face=Arial>FROM geocode_intersection('ross',
'harwood', 'TX', 'dallas'<SPAN class=561142202-12122011>, '',
1</SPAN>)</FONT></B></DIV></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Aren Cambre<BR><B>Sent:</B> Sunday, December 11, 2011 9:17
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re:
[postgis-users] geocode_intersection (was How to update your SVNcopy of
PostGIS)<BR></FONT><BR></DIV>
<DIV></DIV>That's it! Filed bug report at <A
href="http://trac.osgeo.org/postgis/ticket/1366">http://trac.osgeo.org/postgis/ticket/1366</A>.
<DIV><BR></DIV>
<DIV>Now I don't know if this is a bug <I>per se</I>, but if I run this:</DIV>
<DIV>
<DIV><B>SELECT addy, ST_X(ST_SetSRID(geomout,4326)),
ST_Y(ST_SetSRID(geomout,4326)), rating</B></DIV>
<DIV><B>FROM geocode_intersection('ross', 'harwood', 'TX',
'dallas')</B></DIV></DIV>
<DIV><BR></DIV>
<DIV>I get this:</DIV>
<DIV>
<DIV><B>"(2001,,Ross,Ave,,,Dallas,TX,75201,t)";-96.799239;32.786929;3</B></DIV>
<DIV><B>"(2000,,Ross,Ave,,,Dallas,TX,75201,t)";-96.799239;32.786929;3</B></DIV>
<DIV><B>"(1999,,Ross,Ave,,,Dallas,TX,75201,t)";-96.799239;32.786929;3</B></DIV>
<DIV><B>"(1998,,Ross,Ave,,,Dallas,TX,75201,t)";-96.799239;32.786929;3</B></DIV></DIV>
<DIV><BR></DIV>
<DIV>It seems weird that I am getting four almost identical locations, each
with the same rating. The lat/long for this is dead on.</DIV>
<DIV><BR></DIV>
<DIV>Aren</DIV>
<DIV><BR>
<DIV class=gmail_quote>On Sun, Dec 11, 2011 at 8:06 PM, Paragon Corporation
<SPAN dir=ltr><<A href="mailto:lr@pcorp.us">lr@pcorp.us</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote><U></U>
<DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial>Aren,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial>Try upper case
TX. I think we may have forgotten the logic to upper case the
state. We'll check that out.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT face=Tahoma><B>From:</B> <A
href="mailto:postgis-users-bounces@postgis.refractions.net"
target=_blank>postgis-users-bounces@postgis.refractions.net</A> [mailto:<A
href="mailto:postgis-users-bounces@postgis.refractions.net"
target=_blank>postgis-users-bounces@postgis.refractions.net</A>] <B>On
Behalf Of </B>Aren Cambre<BR><B>Sent:</B> Sunday, December 11, 2011 7:32
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B>
[postgis-users] geocode_intersection (was How to update your SVNcopy of
PostGIS)<BR></FONT><BR></DIV>
<DIV>
<DIV class=h5>
<DIV></DIV>I think that was it! Ran the <B>upgrade_geocode.sql </B>script
against my DB, and now I have the <B>geocode_intersection</B> function.
<DIV><BR></DIV>
<DIV><B>However,</B> I'm getting no results with<B>
geocode_intersection</B>. For example:</DIV>
<DIV>
<DIV><B>SELECT *</B></DIV>
<DIV><B>FROM geocode_intersection('ross', 'harwood', 'tx',
'dallas')</B></DIV></DIV>
<DIV><BR></DIV>
<DIV>
<DIV>I get a blank result set.</DIV>
<DIV><BR></DIV>
<DIV>However, if I geocode a known address at that intersection, I get a
valid location:</DIV>
<DIV>
<DIV><B>SELECT addy, ST_X(ST_SetSRID(geomout,4326)),
ST_Y(ST_SetSRID(geomout,4326)), rating</B></DIV>
<DIV><B>FROM geocode('1928 ross ave, dallas, tx');</B></DIV></DIV>
<DIV><BR></DIV>
<DIV>Still investigating...</DIV>
<DIV><BR></DIV>
<DIV>Aren<BR><BR>
<DIV class=gmail_quote>On Sat, Dec 10, 2011 at 6:17 PM, Aren Cambre <SPAN
dir=ltr><<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV>Ah, I see the problem now. I was thinking I'd have to reinstall all
of PostGIS 2.0 to get the <B>geocode_intersection</B> function, but
looking at <A href="http://trac.osgeo.org/postgis/changeset/8276"
target=_blank>http://trac.osgeo.org/postgis/changeset/8276</A>, I
realize that it's the <B>tiger_geocoder</B> extras package as you
mention below.</DIV>
<DIV><BR></DIV>
<DIV>So I looked at the <B>upgrade_geocode.sql</B> script (<A
href="http://trac.osgeo.org/postgis/browser/trunk/extras/tiger_geocoder/tiger_2010/upgrade_geocode.sql?rev=8276"
target=_blank>http://trac.osgeo.org/postgis/browser/trunk/extras/tiger_geocoder/tiger_2010/upgrade_geocode.sql?rev=8276</A>),
and I guess this may help make sure I have the latest geocoding
functions in my DB.</DIV>
<DIV><BR></DIV>
<DIV>I'll try this and see what happens.</DIV><SPAN><FONT color=#888888>
<DIV><BR></DIV></FONT></SPAN>
<DIV><SPAN><FONT color=#888888>Aren</FONT></SPAN>
<DIV>
<DIV><BR><BR>
<DIV class=gmail_quote>On Sat, Dec 10, 2011 at 5:58 PM, Stephen
Woodbridge <SPAN dir=ltr><<A href="mailto:woodbri@swoodbridge.com"
target=_blank>woodbri@swoodbridge.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>Ok, just checking.<BR><A
href="http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/"
target=_blank>http://svn.osgeo.org/postgis/<U></U>trunk/extras/tiger_geocoder/<U></U>tiger_2010/</A><BR><BR>Looks
like something like this might do it:<BR><BR>cd
/usr/share/postgresql/contrib<BR># edit create_geocode.sh<BR># then
run it<BR>./create_geocode.sh<BR><BR>or just load them from
here:<BR><BR><A
href="http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/geocode/"
target=_blank>http://svn.osgeo.org/postgis/<U></U>trunk/extras/tiger_geocoder/<U></U>tiger_2010/geocode/</A><BR><BR>browse
about and install what you need.<BR><BR>-Steve W
<DIV><BR><BR>On 12/10/2011 6:25 PM, Aren Cambre wrote:<BR></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV>I refreshed the functions list and the parent DB and even
opened/closed<BR>pgAdmin III. :-)<BR><BR>I also ran this
script:<BR></DIV>*SELECT * FROM pg_proc proc JOIN pg_language
lang*<BR>*ON proc.prolang = lang.oid*<BR>*ORDER BY
proname;*<BR><BR>Double-checked myself with:<BR>*SELECT * FROM
pg_proc proc JOIN pg_language lang*<BR>*ON proc.prolang =
lang.oid*<BR>*WHERE proname LIKE '%geocode%'*<BR>*ORDER BY
proname;*<BR><BR>Definitely no *geocode.** functions there.
<DIV><BR><BR>Aren<BR><BR>On Sat, Dec 10, 2011 at 5:18 PM, Stephen
Woodbridge<BR></DIV>
<DIV><<A href="mailto:woodbri@swoodbridge.com"
target=_blank>woodbri@swoodbridge.com</A> <mailto:<A
href="mailto:woodbri@swoodbridge.com"
target=_blank>woodbri@swoodbridge.<U></U>com</A>>>
wrote:<BR><BR> Try right click on database and/or
function list and refresh it.<BR><BR><BR> On 12/10/2011
6:15 PM, Aren Cambre wrote:<BR><BR>
Thanks.<BR><BR> Now here's what I
don't get: where are the *geocode* and<BR>
*geocode_intersection* functions? If I look at the functions
list in<BR> *spatial_db_template*'s
*public* schema (using pgAdmin III),<BR>
should I<BR><BR> see those two? I
thought they were included in the base PostGIS<BR>
2.0 product?<BR><BR>
Aren<BR><BR> On Sat, Dec 10, 2011 at
5:09 PM, Stephen Woodbridge<BR> <<A
href="mailto:woodbri@swoodbridge.com"
target=_blank>woodbri@swoodbridge.com</A> <mailto:<A
href="mailto:woodbri@swoodbridge.com"
target=_blank>woodbri@swoodbridge.<U></U>com</A>><BR></DIV>
<mailto:<A href="mailto:woodbri@swoodbridge"
target=_blank>woodbri@swoodbridge</A>. com
<DIV>
<DIV><BR> <mailto:<A
href="mailto:woodbri@swoodbridge.com"
target=_blank>woodbri@swoodbridge.<U></U>com</A>>>>
wrote:<BR><BR> You can
ignore all the notices. As long as you do not get a<BR>
rollback, then things should be
ok.<BR><BR> The script is
just trying to clean out potential obsolete<BR>
functions<BR> that
might be there if the database was created many<BR>
versions ago<BR>
and upgraded to this point.<BR><BR>
-Steve W<BR><BR><BR>
On 12/10/2011 5:46 PM, Aren Cambre wrote:<BR><BR>
Thanks. Yup, I see it now.
My mind was stuck in 3rd<BR>
generation<BR>
languages<BR>
where things stop when you get an exception.<BR><BR>
The script's first
gripe was that the *spatial_ref_sys*<BR>
table<BR>
already<BR><BR>
exists. Shouldn't it automatically kill and reload
that<BR> table?<BR>
Is that a<BR>
bug?<BR><BR>
Anyway, I deleted it and reran the
script. Now I get a<BR> bunch of<BR>
notices<BR>
about functions that
don't exist. See attachment.<BR><BR>
It appears it's mostly not finding
overloads of<BR> functions.
E.g.,<BR> it
says<BR>
*populate_geometry_columns()* and<BR>
*populate_geometry_columns(<BR>
oid)* are<BR><BR>
missing. I do have variants with
different function<BR>
signatures:<BR>
*populate_geometry_columns( oid,boolean)* and<BR>
*populate_geometry_columns( boolean)*.<BR><BR><BR>
BTW, I'm trying to
run this on my template PostGIS DB,<BR>
which I named<BR>
*spatial_db_template*.<BR><BR><BR>
Aren<BR><BR>
On Sat, Dec 10, 2011 at 10:26 AM,
Bborie Park<BR> <<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>>>>
wrote:<BR><BR>
Oops! My head is always in the raster
world, so I<BR> just ran<BR>
with the<BR>
raster
upgrade. Sorry about that.<BR><BR>
If you're getting an error,
you'll want to scroll up<BR> past
the<BR>
transaction error message as the very first
error<BR> message<BR>
should be<BR>
related to the
actual statement that is failing.<BR><BR>
-bborie<BR><BR>
On
Sat, Dec 10, 2011 at 6:47 AM, Aren Cambre<BR>
<<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>><BR>
<mailto:<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>>><BR>
<mailto:<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>><BR>
<mailto:<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>>>><U></U>>
wrote:<BR> > Thanks. Yesterday
I<BR> ><BR>
found
postgis_upgrade_20_minor.sql in<BR>
/usr/share/postgresql/9.1/
contrib/postgis-2.0.<BR> ><BR>
> When I ran that, I got tons of errors like
this:<BR> ><BR>
psql:/usr/share/postgresql/9.<BR>
1/contrib/postgis-2.0/postgis_<BR>
upgrade_20_minor.sql:3235:<BR>
> ERROR: current transaction is
aborted, commands ignored<BR>
until end of<BR> >
transaction block<BR> ><BR>
> I see you mentioned
rtpostgis_upgrade_20_minor. sql. Isn't that<BR><BR>
just
for<BR> > raster functions? I searched
my machine and cannot find it,<BR>
anyway.<BR>
><BR> > Aren<BR>
><BR> > On Fri, Dec
9, 2011 at 10:02 PM, Bborie Park<BR>
<<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>>>>
wrote:<BR> >><BR>
>> Aren,<BR>
>><BR> >> Since you're
tracking trunk, after you've done the configure,<BR>
make
and<BR> >> make install, you'll
want to run the upgrade script<BR>
>><BR> >>
rtpostgis_upgrade_20_minor.sql<BR>
>><BR> >> Usually, the file
is installed in the same place as<BR>
rtpostgis.sql.
If<BR> >> you can't find the
upgrade file, you can find it in your<BR>
checkout's<BR>
>> directory at:<BR>
>><BR> >>
raster/rt_pg<BR> >><BR>
>> -bborie<BR>
>><BR> >> On Fri, Dec 9, 2011
at 7:53 PM, Aren Cambre<BR> <<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>><BR>
<mailto:<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>>><BR>
<mailto:<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>><BR>
<mailto:<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>>>><U></U>>
wrote:<BR> >> > Thanks. I got
the latest SVN snapshot. I was able to<BR>
configure,
make,<BR> >> > and<BR>
>> > make install. The problem is
there seems to be missing steps<BR>
between<BR>
>> > building the whole thing and getting
changes into my<BR>
preexisting<BR> >> >
PostGIS-enabled database.<BR> >>
><BR> >> > Aren<BR>
>> ><BR>
>> ><BR> >> > On Fri,
Dec 9, 2011 at 9:47 PM, Bborie Park<BR>
<<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>>>>
wrote:<BR> >> >><BR>
>> >> If you used something
like...<BR> >> >><BR>
>> >> svn check out <A
href="https://svn.osgeo.org/postgis/"
target=_blank>https://svn.osgeo.org/postgis/</A> trunk<BR>
<<A href="https://svn.osgeo.org/"
target=_blank>https://svn.osgeo.org/</A> postgis/trunk<BR>
<<A
href="https://svn.osgeo.org/postgis/trunk"
target=_blank>https://svn.osgeo.org/<U></U>postgis/trunk</A>>><BR>
>> >><BR>
>> >> You can safely run...<BR>
>> >><BR>
>> >> svn update<BR> >>
>><BR> >> >> If that
works, I'd recommend doing...<BR>
>> >><BR> >> >>
svn cleanup<BR> >>
>><BR> >> >>
-bborie<BR> >> >><BR>
>> >> On Fri, Dec 9, 2011 at 7:19
PM, Aren Cambre<BR> <<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>><BR>
<mailto:<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>>><BR>
<mailto:<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>><BR>
<mailto:<A href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A> <mailto:<A
href="mailto:aren@arencambre.com"
target=_blank>aren@arencambre.com</A>>>><U></U>><BR><BR><BR>
>> >> wrote:<BR>
>> >> > I admit this is a dumb
question, but here it is.<BR> >>
>> ><BR> >> >> >
I installed PostGIS on my Ubuntu 11.10 environment a few<BR>
weeks
ago<BR> >> >> >
using<BR> >> >> >
the<BR> >> >> > excellent
instructions<BR> >> >> >
at<BR> <A
href="http://www.letseehere.com/"
target=_blank>http://www.letseehere.com/</A>
postgis-geocoder-using-tiger-<BR>
2010-data<BR> <<A
href="http://www.letseehere.com/"
target=_blank>http://www.letseehere.com/</A>
postgis-geocoder-using-tiger-<BR>
2010-data<BR> <<A
href="http://www.letseehere.com/postgis-geocoder-using-tiger-2010-data"
target=_blank>http://www.letseehere.com/<U></U>postgis-geocoder-using-tiger-<U></U>2010-data</A>>>.<BR><BR>
>> >> ><BR>
>> >> > Since then, the geocode_intersection
function was added,<BR>
and I need<BR>
>> >> > it.<BR> >>
>> > I'm<BR> >> >>
> not clear what is the process of replacing the older<BR>
snapshot of<BR> >> >>
> PostGIS<BR> >> >> >
with this newer one.<BR> >>
>> ><BR> >> >> >
I don't see an obvious install/uninstall routine. I tried<BR>
the
soft<BR> >> >> >
upgrade<BR> >> >>
><BR> >> >> ><BR>
>> >> > at<BR>
<A href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/documentation/manual-svn/<BR>
postgis_installation.html# upgrading<BR>
<<A href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/documentation/manual-svn/<BR>
postgis_installation.html# upgrading<BR>
<<A
href="http://postgis.refractions.net/documentation/manual-svn/postgis_installation.html#upgrading"
target=_blank>http://postgis.refractions.<U></U>net/documentation/manual-svn/<U></U>postgis_installation.html#<U></U>upgrading</A>>>,<BR><BR>
>> >> > but that didn't work. Do
I need to do the hard upgrade each<BR>
time I do<BR>
>> >> > a<BR>
>> >> > SVN<BR>
>> >> > update?<BR>
>> >> ><BR> >>
>> > Aren<BR> >> >>
><BR> >> >> >
______________________________ _________________<BR>
>> >> > postgis-users mailing
list<BR> >> >> >
postgis-users@postgis. <A href="http://refractions.net"
target=_blank>refractions.net</A><BR></DIV></DIV>
<<A href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>><BR></DIV>
<mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>><U></U>.<BR>
<A href="http://refractions.net"
target=_blank>refractions.net</A> <<A
href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>>><BR><BR>
>> >> > <A
href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.<BR>
net/mailman/listinfo/postgis- users<BR><BR>
<<A href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR>
<<A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A>>><BR>
>> >> ><BR>
>> >><BR> >>
>><BR> >> >><BR>
>> >> --<BR>
>> >> Bborie Park<BR>
>> >> Programmer<BR> >>
>> Center for Vectorborne Diseases<BR>
>> >> UC Davis<BR>
>> >> <A href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A><BR></DIV>
<tel:<A href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>>> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>><BR><BR>
<tel:<A href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>>>>
<DIV><BR> >> >> <A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>><BR></DIV>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>
<DIV><BR> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>>><BR><BR>
>> >>
______________________________ _________________<BR>
>> >> postgis-users mailing list<BR>
>> >> postgis-users@postgis. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR></DIV>
<<A href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>><BR></DIV>
<mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>><U></U>.<BR>
<A href="http://refractions.net"
target=_blank>refractions.net</A> <<A
href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>>><BR><BR>
>> >> <A
href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis-<BR>
users<BR></DIV>
<DIV> <<A
href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR>
<<A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A>>><BR>
>> ><BR>
>> ><BR> >> ><BR>
>> > ______________________________
_________________<BR> >> >
postgis-users mailing list<BR> >>
> postgis-users@postgis. <A href="http://refractions.net"
target=_blank>refractions.net</A><BR></DIV>
<<A href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>><BR></DIV>
<mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>><U></U>.<BR>
<A href="http://refractions.net"
target=_blank>refractions.net</A> <<A
href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>>><BR><BR>
>> > <A
href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis-<BR>
users<BR><BR> <<A
href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR>
<<A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A>>><BR>
>> ><BR>
>><BR> >><BR>
>><BR> >>
--<BR> >> Bborie Park<BR>
>> Programmer<BR>
>> Center for Vectorborne Diseases<BR>
>> UC Davis<BR>
>> <A href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A><BR></DIV>
<tel:<A href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>>> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>><BR><BR>
<tel:<A href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>>>>
<DIV><BR> >> <A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>><BR></DIV>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>
<DIV><BR> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>>><BR><BR>
>> ______________________________
_________________<BR> >>
postgis-users mailing list<BR></DIV>
>> postgis-users@postgis. <A href="http://refractions.net"
target=_blank>refractions.net</A> <<A
href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>><BR></DIV>
<mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>><U></U>.<BR>
<A href="http://refractions.net"
target=_blank>refractions.net</A> <<A
href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>>><BR><BR>
>> <A href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis-<BR>
users<BR></DIV>
<DIV> <<A
href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR>
<<A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A>>><BR>
><BR>
><BR> ><BR>
> ______________________________
_________________<BR> > postgis-users
mailing list<BR></DIV> >
postgis-users@postgis. <A href="http://refractions.net"
target=_blank>refractions.net</A> <<A
href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>><BR></DIV>
<mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>><U></U>.<BR>
<A href="http://refractions.net"
target=_blank>refractions.net</A> <<A
href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>>><BR><BR>
> <A href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis-<BR>
users<BR><BR> <<A
href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR>
<<A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A>>><BR>
><BR><BR><BR><BR>
--<BR>
Bborie
Park<BR>
Programmer<BR>
Center for Vectorborne Diseases<BR>
UC
Davis<BR> <A href="tel:530-752-8380"
target=_blank value="+15307528380">530-752-8380</A> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A><BR></DIV>
<tel:<A href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>>> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>><BR><BR>
<tel:<A href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A> <tel:<A
href="tel:530-752-8380" target=_blank
value="+15307528380">530-752-8380</A>>>>
<DIV><BR> <A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>><BR>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>><BR></DIV>
<mailto:<A href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>
<DIV><BR> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A> <mailto:<A
href="mailto:bkpark@ucdavis.edu"
target=_blank>bkpark@ucdavis.edu</A>>>><BR><BR>
______________________________ _________________<BR>
postgis-users mailing list<BR>
postgis-users@postgis. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR></DIV>
<<A href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>><BR></DIV>
<mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>><U></U>.<BR>
<A href="http://refractions.net"
target=_blank>refractions.net</A> <<A
href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>>><BR><BR>
<A href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR></DIV>
<DIV> <<A
href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR>
<<A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A>>><BR><BR><BR><BR><BR>
______________________________ _________________<BR>
postgis-users
mailing list<BR>
postgis-users@postgis. <A href="http://refractions.net"
target=_blank>refractions.net</A><BR></DIV>
<<A href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>><BR>
<A href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR></DIV>
<DIV> <<A
href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR>
<<A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A>>><BR><BR><BR>
______________________________
_________________<BR>
postgis-users mailing list<BR></DIV>
postgis-users@postgis. <A
href="http://refractions.net" target=_blank>refractions.net</A>
<<A href="http://refractions.net"
target=_blank>http://refractions.net</A>>
<DIV><BR> <mailto:<A
href="mailto:postgis-users@postgis"
target=_blank>postgis-users@postgis</A>. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>>><BR>
<A href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR><BR></DIV>
<DIV> <<A
href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR>
<<A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A>>><BR><BR><BR><BR><BR>
______________________________
_________________<BR> postgis-users
mailing list<BR> postgis-users@postgis. <A
href="http://refractions.net"
target=_blank>refractions.net</A><BR>
<mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>><BR>
<A href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR>
<<A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A>><BR><BR><BR>
______________________________ _________________<BR>
postgis-users mailing list<BR>
postgis-users@postgis. <A href="http://refractions.net"
target=_blank>refractions.net</A><BR> <mailto:<A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A>><BR>
<A href="http://postgis.refractions"
target=_blank>http://postgis.refractions</A>.
net/mailman/listinfo/postgis- users<BR> <<A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A>><BR><BR><BR><BR><BR>______________________________<U></U>_________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A><BR></DIV></BLOCKQUOTE>
<DIV>
<DIV><BR>______________________________<U></U>_________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.<U></U>refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.<U></U>net/mailman/listinfo/postgis-<U></U>users</A><BR></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV></DIV></BLOCKQUOTE></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></BLOCKQUOTE></BODY></HTML>