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 class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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 class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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 class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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" value="+15307528380" target="_blank">530-752-8380</a> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a>> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a><br>
</div>
<tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a>>> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a>><br>
<br>
<tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">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" value="+15307528380" target="_blank">530-752-8380</a> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a>> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a><br>
</div>
<tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a>>> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a>><br>
<br>
<tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">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" value="+15307528380" target="_blank">530-752-8380</a> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a>> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a><br>
</div>
<tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a>>> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a>><br>
<br>
<tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">530-752-8380</a> <tel:<a href="tel:530-752-8380" value="+15307528380" target="_blank">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>