NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hi guys,

I downloaded tiger 2011 edges data for USA map. After unziping them (about 3000 files), I used the following commands to import them: ./utils/imports.php --parse-tiger-2011 ../tiger2011 (the place where the files are) ./utils/setup.php --import-tiger-data

It finished in a blink of eye and without telling me whether failed or succeeded, just showed some lines of CREATE TABLE, DROP TABLE. Since there are so many files, I doubt it did any change on nominatim database. I checked the database. It looked only one table related to tiger which is "location_property_tiger", and it is empty. So can someone tell me whether it succeeded or not, if not, how should I import tiger data correctly? The following is the detailed output I got (again, in less than a second):


DROP TABLE

CREATE TABLE

CREATE FUNCTION

Creating indexes

CREATE INDEX

CREATE INDEX

GRANT

DROP TABLE

ALTER TABLE

ALTER INDEX

ALTER INDEX

DROP FUNCTION


Thanks in advance! TJ

asked 24 Jul '13, 14:31

OSM-TJ2013's gravatar image

OSM-TJ2013
16445
accept rate: 0%

closed 25 Jul '13, 02:53

aseerel4c26's gravatar image

aseerel4c26 ♦
32.6k18248554

The question has been closed for the following reason "The question is self-answered, "accepting" not possible - closing therefore." by aseerel4c26 25 Jul '13, 02:53


Never mind guys. I checked the imports.php. It seems looking for zip files instead of unzipped. But I moved zip files to somewhere else after unzipping. Silly me!

permanent link

answered 24 Jul '13, 16:30

OSM-TJ2013's gravatar image

OSM-TJ2013
16445
accept rate: 0%

Hi to all, I am also get the the same problem, even my zip files not moved to anywhere. Refer the following:

[sas@...~/Nominatim-2.2.0]$ php utils/imports.php --parse-tiger-2011 /home/sas/rajavelu/tigerdata/edges/

Processing 15005...

[sas@...~/Nominatim-2.2.0]$ php utils/setup.php --import-tiger- data

DROP TABLE CREATE TABLE CREATE FUNCTION /home/sas/Nominatim-2.2.0/data/tiger2011/15005.sql: Creating indexes CREATE INDEX CREATE INDEX GRANT DROP TABLE ALTER TABLE ALTER INDEX ALTER INDEX DROP FUNCTION [sas@...~/Nominatim-2.2.0]$

(23 Jul '15, 06:40) Rajavelu_M

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×689
×30

question asked: 24 Jul '13, 14:31

question was seen: 3,096 times

last updated: 23 Jul '15, 06:41

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum