Thanks. I was wondering about needing to do ST_SetSRID!<div><br></div><div>Trying the clustering now. I'm on 9.1, so the command for me is <b>CLUSTER tiger_data.tx_edges USING tiger_data_tx_edges_the_geom_gist;</b></div>
<div><br></div><div>Given 6.2 million rows, I'm expecting this to take a while! :-)</div><div><br></div><div>Aren</div><div><br><div class="gmail_quote">On Sun, Dec 11, 2011 at 8:40 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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">Forgot -- you don't need the ST_SetSRID call you have
there. It's doing nothing for you if you are just going to output the x
and y coords.</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">You might also want to try clustering your edges
table</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div><span>
<div dir="ltr" align="left"><br><font color="#0000ff" face="Arial">CLUSTER
tiger_data_tx_edges_the_geom_gist ON tiger_data.tx_edges;</font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"></font> </div>
<div dir="ltr" align="left"></div></span><span><font color="#0000ff" face="Arial">I haven't confirmed its absolutely better for
the geocoder in all cases since it does do a lot of text checks, but I think the
cross streets logic is more sensitive to it than other routines. We
are planning to do some more benchmarks</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">on different versions of PostgreSQL to determine the optimal
index to cluster on and then provide that as a maintenance function similar to
the other ones we have listed in the docs.</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"><a href="http://www.postgis.org/documentation/manual-svn/Extras.html#Tiger_Geocoder" target="_blank">http://www.postgis.org/documentation/manual-svn/Extras.html#Tiger_Geocoder</a></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">Regina</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></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>Paragon Corporation<br><b>Sent:</b> Sunday, December 11, 2011 9:28
PM<div><div class="h5"><br><b>To:</b> 'PostGIS Users Discussion'<br><b>Subject:</b> Re:
[postgis-users] geocode_intersection (was How to update yourSVNcopy of
PostGIS)<br></div></div></font><br></div><div><div class="h5">
<div></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">fixed.</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">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><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" 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><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span>
<div><b><font color="#0000ff" 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" face="Arial">FROM
geocode_intersection('ross', 'harwood', 'TX', 'dallas'<span>, '', 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" 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 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" target="_blank">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" target="_blank">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>
<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" 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></div></div></blockquote></div><br>_______________________________________________<br>postgis-users
mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div></blockquote></div></div></blockquote>
<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>