Timeline for Install PostGIS and TIGER Data in Ubuntu 12.04
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Nov 14, 2014 at 14:51 | history | suggested | CommunityBot | CC BY-SA 3.0 |
The scripts generated are shell scripts (.sh), not SQL scripts (.sql).
|
| Nov 14, 2014 at 13:58 | review | Suggested edits | |||
| S Nov 14, 2014 at 14:51 | |||||
| Jan 3, 2014 at 23:52 | vote | accept | stat_novice | ||
| Jan 3, 2014 at 23:01 | comment | added | HeyOverThere | let us continue this discussion in chat | |
| Jan 3, 2014 at 22:33 | comment | added | HeyOverThere | Yes, PGBIN needs to point to the directory that psql is in. Use the command which psql to see where psql lives. Then you can set the path in the tiger.loader_platform table I believe. | |
| Jan 3, 2014 at 22:25 | comment | added | stat_novice | HeyOverThere: You are a god among men/women. This almost works. Both the nation and state scripts run and they are FTPing the census website and seem to be retrieving files, but after both complete they issue some of the following error statements: "loader_script.sql: 408: loader_script.sql: /usr/pgsql-9.0/bin/psql: not found". Moreover, there is no data in the tiger_data schema. Do I need to edit the files, specifically this line: "export PGBIN=/usr/pgsql-9.0/bin"? | |
| Jan 3, 2014 at 21:39 | history | edited | HeyOverThere | CC BY-SA 3.0 |
Added section on setting up geocoder lookup tables, etc.
|
| Jan 3, 2014 at 21:31 | comment | added | HeyOverThere | Double sorry! I forgot about that too! First thing to check will be your database's search path, make sure the tiger schema is in there. 2nd thing to check is in the tiger schema there are tables, tiger.loader_platform and tiger.loader_variables that tell your scripts your password and other information. Use PGAdmin to edit those. Finally, before running your loader script run the loader_generate_nation function to set up all the tables that the geocoder needs. I'll edit my answer to fill in these blanks. | |
| Jan 3, 2014 at 21:22 | comment | added | stat_novice | That worked! Though, now I'm receiving this error message "No function matches the given name and argument types. You might need to add explicit type casts." when executing the query for the loader script. Also, if I remember correctly, I'll have to edit that file, right to add my username and db? | |
| Jan 3, 2014 at 21:17 | comment | added | HeyOverThere | Sorry! I forgot most people don't use their normal user accounts to run psql. You'll need to save the script somewhere that your postgres user has write permission. Easiest is to use \o /tmp/loader_script.sql which will save the file to /tmp. Then to run the file it will be sh ./tmp/loader_script.sql. | |
| Jan 3, 2014 at 21:12 | comment | added | stat_novice | HeyOverThere: Thank you for the detailed response. Whilst in psql, typing "\o loader_script.sql" results in a permission denied statement. Any idea as to why? I'm logged in as user postgres. | |
| Jan 3, 2014 at 20:48 | history | answered | HeyOverThere | CC BY-SA 3.0 |