[postgis-users] TIGER geocoder

[Andre Mano]

Luma, Regina,

Thank you once more. Everything is on a local machine. In fact it's a one
user database (me) that I will, hopefully, use just for geocoding purposes.
All clearer now.

Regards,


On Thu, Apr 17, 2014 at 8:59 PM, Paragon Corporation <lr at pcorp.us> wrote:

>  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
>> 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:* 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/
>>
>> _______________________________________________
>> 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/
>
> _______________________________________________
> 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140417/0648c342/attachment.html>