<!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=067070402-12122011><FONT color=#0000ff
size=2 face=Arial>Aren,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=067070402-12122011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=067070402-12122011><FONT color=#0000ff
size=2 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 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 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>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">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 class=HOEnZb><FONT
color=#888888>
<DIV><BR></DIV></FONT></SPAN>
<DIV><SPAN class=HOEnZb><FONT color=#888888>Aren</FONT></SPAN>
<DIV>
<DIV class=h5><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></BLOCKQUOTE></BODY></HTML>