missing file on sources

[dnuske]

Hi, I'm unable to generate the necessary files, if you can help me I'd appreciate.

After installing all dependencies in Ubuntu 16.04 I run make and goes ok until imposm3 command. This line has a parameter -read sources/san-francisco_california.osm.pbf but sources dir is empty on the repo and all previous commands only execute things against the database. How do I do to get that pbf file? What am I missing?

[bdon]

it's from https://mapzen.com/data/metro-extracts/

[dnuske]

thanks for the quick response. Now make craete_db does run successfully but the next command make create_tables return:

make create_tables
psql us.ca.san_francisco -f sql/create_tables.sql
psql:sql/create_tables.sql:1: NOTICE:  table "features" does not exist, skipping
DROP TABLE
psql:sql/create_tables.sql:2: NOTICE:  table "tasks" does not exist, skipping
DROP TABLE
psql:sql/create_tables.sql:19: ERROR:  relation "sf2014_bldg_height" does not exist
LINE 14: FROM sf2014_bldg_height, osm_buildings as foo
              ^
psql:sql/create_tables.sql:21: ERROR:  relation "features" does not exist
LINE 1: DELETE FROM features WHERE height_max IS NULL OR height_max ...
                    ^
psql:sql/create_tables.sql:28: ERROR:  relation "features" does not exist
LINE 4: UPDATE features SET z16_task = TRUE WHERE (z16_x, z16_y) IN ...
               ^
psql:sql/create_tables.sql:29: ERROR:  relation "features" does not exist
LINE 1: UPDATE features SET z17_task = TRUE WHERE z16_task IS FALSE;
               ^
CREATE TABLE
psql:sql/create_tables.sql:34: ERROR:  relation "features" does not exist
LINE 1: ...ECT DISTINCT 16 AS z, z16_x AS x, z16_y AS y FROM features W...
                                                             ^
psql:sql/create_tables.sql:35: ERROR:  relation "features" does not exist 
LINE 1: ...ECT DISTINCT 17 AS z, z17_x AS x, z17_y AS y FROM features W...

[bdon]

the make tasks are a bit out of order. you need to run the task to import the building height raster into PostGIS first.

[dnuske]

I see the task sources now all makes sense. I'll try to guess the commands order. Thank you!