<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 class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<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>