[postgis-users] TIGER geocoder

[Paragon Corporation]

No not directory where Postgres is installed.
 
On Windows something like C:\gisdata or E:\gisdata
 
On Linux  /gisdata
 
Technically you can create the folder anywhere  as long as you change the
path in the generated script (or prechange it in the
tiger.loader_variables.staging_fold field before you generate the script) to
where you want the files put.
Note that if you put the folder on your local pc and your PostgreSQL server
is on another machine, you'll need to have shp2pgsql and psql executables
etc accessible from your local pc.
It's generally more efficient to just run from the machine you have
PostgreSQL installed because of network / bandwidth.
 
Hope that helps,
Regina
http://www.postgis.us
http://postgis.net
 

  _____  

From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Andre Mano
Sent: Thursday, April 17, 2014 2:40 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] TIGER geocoder


Thank you for your report. 

I followed your suggestions but I run into one more question. 
The readme file that documents the geocoder tool says it's necessary to
"Create a folder called gisdata on root of server or your local pc".

What is considered to be the root of the server? The directory where
Postgres is installed?

Thank you for your support,

Andre


On Thu, Apr 17, 2014 at 10:37 AM, Paragon Corporation <lr at pcorp.us> wrote:



Andre,
 
If you plan to do geocoding, then you need to load tiger data.  Next steps
here:
 
http://postgis.net/docs/manual-2.1/postgis_installation.html#tiger_geocoder_
loading_data  
 
Hope that helps,
Regina
h <http://www.postgis.us> ttp://www.postgis.us
h <http://postgis.net> ttp://postgis.net
 
 

  _____  

From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Andre Mano
Sent: Wednesday, April 16, 2014 7:22 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] TIGER geocoder


Hi users,

I am a bit lost on the necessary steps in order to use the TIGER geocoding
tool. This is what I have done so far:


# Enable geocoding capabilities


CREATE EXTENSION fuzzystrmatch; 

CREATE EXTENSION postgis_tiger_geocoder;




# Test Geocoding capabilities


SELECT na.address, na.streetname,na.streettypeabbrev, na.zip

FROM normalize_address('1 Devonshire Place, Boston, MA 02109') AS na;



(Returns, as expected: 1;"Devonshire";"Pl";"02109")


But now I don't know exactly what I have to do. I have read the
documentation, but still I am not very secure of what I should do. Does
anyone here with experience with the TIGER geocoder can give me a hint? 

(PostgresSQL 9.3, PostGIS 2.1, Win7 Enterprise 64bits)

Thank you,

Andre

-- 
..................................
André Mano
 <http://opussig.blogspot.com/> http://opussig.blogspot.com/


_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users





-- 
..................................
André Mano
 <http://opussig.blogspot.com/> http://opussig.blogspot.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140417/13d02970/attachment.html>