<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;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="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><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="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family:
times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><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="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><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="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">#2 the geocode example returns nothing. No error. Just no results.</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><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="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><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="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Michael<br><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color:
transparent; font-style: normal;"><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 face="Arial" size="2"> <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 http-equiv="x-dns-prefetch-control" content="off"><div id="yiv1504693524"><div><div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;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 target="_blank" href="http://tiger.bg/">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="color:rgb(0, 0, 0);font-size:16px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br></div><div style="color:rgb(0, 0, 0);font-size:16px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;">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="color:rgb(0, 0, 0);font-size:16px;font-family:times new roman, new york,
times, serif;background-color:transparent;font-style:normal;"><br></div><div style="color:rgb(0, 0, 0);font-size:16px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;">Here's the error from the logs using CREATE TABLE bg<br></div><div style="color:rgb(0, 0, 0);font-size:16px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br></div><div style="color:rgb(0, 0, 0);font-size:16px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;">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="color:rgb(0, 0, 0);font-size:16px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br></div><div style="color:rgb(0, 0, 0);font-size:16px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br><br></div></div></div></div><meta http-equiv="x-dns-prefetch-control" content="on"><br><br> </div> </div> </div></body></html>