<!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 8.00.7601.17573"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=436593721-28042011><FONT color=#0000ff
size=2 face=Arial>Jonathan,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=436593721-28042011><FONT color=#0000ff
size=2 face=Arial>A</FONT></SPAN><SPAN class=436593721-28042011><FONT
color=#0000ff size=2 face=Arial>ttach it to this ticket.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=436593721-28042011><FONT color=#0000ff><A
href="http://trac.osgeo.org/postgis/ticket/908">http://trac.osgeo.org/postgis/ticket/908</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=436593721-28042011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=436593721-28042011><FONT color=#0000ff
size=2 face=Arial>I'm setting up a couple of CentOS boxes now and when I'm
thru with the benchmarking I'm doing for another project, I'll be testing
tiger geocoder on them.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=436593721-28042011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=436593721-28042011><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=436593721-28042011><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=436593721-28042011><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=436593721-28042011></SPAN> </DIV><FONT
color=#0000ff size=2 face=Arial></FONT><FONT color=#0000ff size=2
face=Arial></FONT><BR>
<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>Johnathan Leppert<BR><B>Sent:</B> Thursday, April 28, 2011 5:28
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users]
Geocoder (from extras)<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hi Regina,</DIV>
<DIV><BR></DIV>Great, thanks! Do you want me to also send my changes for your
review to the linux version of the shell loader script? I fixed some syntax
errors and re-worked how it loops over files.
<DIV><BR></DIV>
<DIV>Thank you,</DIV>
<DIV><BR></DIV>
<DIV>Johnathan<BR><BR>
<DIV class=gmail_quote>On Thu, Apr 28, 2011 at 5:00 PM, Paragon Corporation
<SPAN dir=ltr><<A href="mailto:lr@pcorp.us">lr@pcorp.us</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial>Jonathan,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>Sorry
about that. My fault. I accidentally commented something out not
intending to.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>The second
function in that file should be</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>CREATE OR
REPLACE FUNCTION reverse_geocode(IN pt geometry, OUT intpt
geometry[],<BR> OUT addy NORM_ADDY[],<BR>
OUT street varchar[]) RETURNS RECORD<BR>AS <BR>$$<BR>-- default to not
including street range in cross streets<BR> SELECT
reverse_geocode($1,false);<BR>$$<BR>language sql STABLE;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>I'll patch
this in subversion.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial><A
href="http://www.postgis.us"
target=_blank>http://www.postgis.us</A></FONT></SPAN></DIV><FONT color=#0000ff
size=2 face=Arial></FONT><BR>
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT size=2 face=Tahoma>
<DIV class=im><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>Johnathan Leppert<BR></DIV><B>Sent:</B> Thursday, April 28, 2011 4:14
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re:
[postgis-users] Geocoder (from extras)<BR></FONT><BR></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV></DIV>Yes I do, but my problem occurs when running the SQL to install the
various functions into that schema. I had to comment out
geocode/reverse_geocode.
<DIV>sql (which is included as part of create_geocode.sql) in order for the
rest to install successfully.<BR><BR>There appears to be a syntax error with
the reverse_geocode function:<BR><BR>psql:geocode/reverse_geocode.
<DIV>sql:101: ERROR: return type mismatch in function declared to return
record<BR>DETAIL: Function's final statement must be SELECT or
INSERT/UPDATE/DELETE RETURNING.<BR>CONTEXT: SQL function
"reverse_geocode"<BR><BR>I'm not too familiar with writing them, so I'm not
able to stop/debug the error. Any
ideas?<BR><BR>Thanks,<BR><BR>Johnathan<BR></DIV></DIV><BR><BR>
<DIV class=gmail_quote>On Thu, Apr 28, 2011 at 4:09 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>
<DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>All the
functions should have been installed in tiger schema.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>Do you
have a tiger schema?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN></SPAN><SPAN></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN>Leo</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN></SPAN></FONT><A href="http://www.postgis.us"
target=_blank><FONT
size=2>h<SPAN>ttp://www.postgis.us</SPAN></FONT></A></FONT></FONT><BR></DIV>
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT size=2 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>Johnathan Leppert<BR><B>Sent:</B> Thursday, April 28, 2011
10:39 AM<BR><B>To:</B> <A
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><B>Subject:</B>
[postgis-users] Geocoder (from extras)<BR></FONT><BR></DIV>
<DIV>
<DIV></DIV>
<DIV>
<DIV></DIV>I fixed several bugs in the generated bash script to import US
Census shapefiles. Now I'm having an issue with the reverse geocoder
SQL:<BR><BR>postgres@li63-206:/tmp/tiger_2010$ /usr/local/pgsql/bin/psql -d
geo -f ./create_geocode.sql<BR>psql:./create_geocode.sql:4: ERROR:
schema "tiger" does not exist<BR>BEGIN<BR>psql:./create_geocode.sql:7:
NOTICE: type "norm_addy" does not exist, skipping<BR>DROP
TYPE<BR>CREATE TYPE<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>psql:geocode/reverse_geocode.sql:101: ERROR: return type
mismatch in function declared to return record<BR>DETAIL: Function's
final statement must be SELECT or INSERT/UPDATE/DELETE
RETURNING.<BR>CONTEXT: SQL function
"reverse_geocode"<BR>ROLLBACK<BR><BR>Anyone have any ideas? Using
postgis-2.0.0SVN<BR><BR>Thanks,<BR><BR>Johnathan<BR></DIV></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR><I><FONT color=#cccccc>Johnathan</FONT></I>
<DIV><FONT color=#cccccc>Software Architect & Developer</FONT></DIV>
<DIV><FONT color=#cccccc>Columbus, Ohio</FONT></DIV>
<DIV><I><FONT color=#cccccc><A href="http://twitter.com/#%21/iamleppert"
target=_blank>Follow me on Twitter:
@iamleppert</A></FONT></I></DIV><BR></DIV></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR><I><FONT color=#cccccc>Johnathan</FONT></I>
<DIV><FONT color=#cccccc>Software Architect & Developer</FONT></DIV>
<DIV><FONT color=#cccccc>Columbus, Ohio</FONT></DIV>
<DIV><I><FONT color=#cccccc><A href="http://twitter.com/#!/iamleppert"
target=_blank>Follow me on Twitter:
@iamleppert</A></FONT></I></DIV><BR></DIV></BODY></HTML>