<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16450"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=607080706-11112012><FONT color=#0000ff
size=2 face=Arial>Strange. Are you using tiger packaged with 2.0 or
2.1? I now 2.0.1 had issues iwth tract/bg load which are fixed in 2.1 and
I think partly fixed in 2.0.2</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=607080706-11112012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=607080706-11112012><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=607080706-11112012><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV><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@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Michael
Papet<BR><B>Sent:</B> Friday, November 09, 2012 12:28 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> Re: [postgis-users] Newbie:
census_loader.sql Issue<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV
style="BACKGROUND-COLOR: #fff; FONT-FAMILY: times new roman, new york, times, serif; COLOR: #000; FONT-SIZE: 12pt">
<DIV><SPAN>I discovered another table not made tiger.tract. Again, no
error. It just doesn't get made.<BR></SPAN></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR><SPAN></SPAN></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><SPAN>I
used the included script to load Massachusetts data to use the documentation
examples and am having more issues. <BR></SPAN></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><SPAN><BR></SPAN></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><SPAN>#1:
Select Function pprint_addy example does not work. Function pprint_addy is
present as pprint_addy(tiger.norm_addy). </SPAN><SPAN>I can run
SELECT normalize_address(</SPAN>'202 East Fremont Street, Las Vegas, Nevada
89101')) As pretty_address; and it returns a formatted address.</DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><SPAN
style="FONT-STYLE: italic"> SELECT pprint_addy(normalize_address('202 East
Fremont Street, Las Vegas, Nevada 89101')) As pretty_address;<BR>2012-11-09
08:36:50 PST ERROR: function pprint_addy(norm_addy) does not exist at
character 8<BR>2012-11-09 08:36:50 PST HINT: No function matches the given
name and argument types. You might need to add explicit type casts.</SPAN></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px">#2
the geocode example returns nothing. No error. Just no
results.</DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR></DIV><SPAN
style="FONT-STYLE: italic">SELECT g.rating, ST_X(g.geomout) As lon,
ST_Y(g.geomout) As lat, <BR> (addy).address As stno,
(addy).streetname As street, <BR> (addy).streettypeabbrev As
styp, (addy).location As city, (addy).stateabbrev As st,(addy).zip
<BR> FROM geocode('75 State Street, Boston MA 02109') As g;
</SPAN><BR><BR>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><SPAN>The
search_path for the database geocoder is set to include tiger, tiger_data,
public, topology. Do I need to add those names to the search_path variable
value for database postgres?<BR></SPAN></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px">Michael<BR><BR><SPAN></SPAN></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><SPAN><BR></SPAN></DIV>
<DIV><SPAN></SPAN></DIV>
<DIV><BR></DIV>
<DIV
style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV
style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV dir=ltr><FONT size=2 face=Arial>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Michael Papet
<mpapet@yahoo.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
"postgis-users@lists.osgeo.org" <postgis-users@lists.osgeo.org>
<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday, November 8,
2012 8:04 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Newbie:
census_loader.sql Issue<BR></FONT></DIV><BR>
<META content=off http-equiv=x-dns-prefetch-control>
<DIV id=yiv1504693524>
<DIV>
<DIV
style="BACKGROUND-COLOR: #fff; FONT-FAMILY: times new roman, new york, times, serif; COLOR: #000; FONT-SIZE: 12pt"><SPAN
class=yiv1504693524tab> This is an update on my issues loading Tiger2011
data to postGIS using Debian's Wheezy, Postgresql 9.1. After starting over
from the beginning, I'm down to one error loading data using the included loader
scripts as-is. Table <A href="http://tiger.bg/" target=_blank>tiger.bg</A>
doesn't get made on my system with no clue that bg didn't get made unless I
check my log file.<BR><BR><BR></SPAN>
<DIV>psql -d geocoder -f
/home/postgis/postgis/postgis-2.1.0SVN/extras/tiger_geocoder/tiger_2011/census_loader.sql
setsearchpathforinstall<BR>------------------------------------------<BR> tiger
has been made primary for install<BR>(1 row)<BR><BR>CREATE
FUNCTION<BR>psql:/home/postgis/postgis/postgis-2.1.0SVN/extras/tiger_geocoder/tiger_2011/census_loader.sql:108:
NOTICE: function loader_generate_census(text[],text) does not exist,
skipping<BR>DROP FUNCTION<BR>CREATE FUNCTION<BR>DELETE 3<BR>INSERT 0 1<BR>INSERT
0 1<BR>INSERT 0 1<BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px">There's
no bg table made. If I change the stanza from CREATE TABLE bg to CREATE
TABLE tiger.bg, there's still nothing made and no error in postgresql
logs! If I take the bg table query out and put it in an editor without the
RETURN stanza, the table is made.<BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york,
times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px">Here's
the error from the logs using CREATE TABLE bg<BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px">2012-11-08
07:30:20 PST ERROR: syntax error at or near "RETURN" at character
806<BR>2012-11-08 07:30:20 PST STATEMENT: CREATE TABLE
bg<BR>
(<BR>
gid serial NOT
NULL,<BR>
statefp
varchar(2),<BR>
countyfp
varchar(3),<BR>
tractce
varchar(6),<BR>
blkgrpce
varchar(1),<BR>
bg_id varchar(12) PRIMARY
KEY,<BR>
namelsad
varchar(13),<BR>
mtfcc
varchar(5),<BR>
funcstat
varchar(1),<BR>
aland double
precision,<BR>
awater double
precision,<BR>
intptlat
varchar(11),<BR>
intptlon
varchar(12),<BR>
the_geom
geometry,<BR>
CONSTRAINT enforce_dims_geom CHECK (st_ndims(the_geom) =
2),<BR>
CONSTRAINT enforce_geotype_geom CHECK (geometrytype(the_geom) =
'MULTIPOLYGON'::text OR the_geom IS
NULL),<BR>
CONSTRAINT enforce_srid_geom CHECK (st_srid(the_geom) =
4269)<BR>
);<BR>
COMMENT ON TABLE tiger.bg IS 'block
groups';<BR>
RETURN 'Done creating census tract base tables - $Id: census_loader.sql 10179
2012-08-13 21:45:39Z robe $';</DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR><BR></DIV></DIV></DIV></DIV>
<META content=on
http-equiv=x-dns-prefetch-control><BR><BR></DIV></DIV></DIV></BODY></HTML>