From 730af6c2b7cc3b82a45fe8cdff720c13892316cb Mon Sep 17 00:00:00 2001 From: Michael Orlitzky Date: Sun, 11 Oct 2009 14:01:52 -0400 Subject: [PATCH] Fixed the "all lines" shapefile importing. --- makefile | 26 ++++++++++++++------------ 1 file changed, 14 insertions(+), 12 deletions(-) diff --git a/makefile b/makefile index 30e876a..b7ef3c2 100644 --- a/makefile +++ b/makefile @@ -52,11 +52,11 @@ data: tiger_blocks tiger_lines tiger_blocks: dc_blocks md_blocks va_blocks pa_blocks ny_blocks dc_blocks: - mkdir -p data/census2000/dc/block - if [ ! -f data/census2000/dc/block/tl_2009_11_tabblock00.shp ]; \ + mkdir -p data/census2000/district_of_columbia/block + if [ ! -f data/census2000/district_of_columbia/block/tl_2009_11_tabblock00.shp ]; \ then \ wget -O dcblocks.zip $(DC_BLOCKS_URL); \ - unzip dcblocks.zip -d ./data/census2000/dc/block; \ + unzip dcblocks.zip -d ./data/census2000/district_of_columbia/block; \ rm dcblocks.zip; \ fi; @@ -123,18 +123,20 @@ db: data newdb tiger_blocks_table tiger_lines_table sf1_blocks_table | psql -U $(DB_USER) -d $(DB_NAME); \ done; -# MD Lines +# All Lines # # Since the table and index already exist, we can utilize -a, # and leave -I out. - for x in data/census2000/maryland/lines/*.shp; do \ - $(PG_BINDIR)/shp2pgsql \ - -a \ - -s $(TIGER_SRID) \ - -D \ - $$x \ - tiger_lines \ - | psql -U $(DB_USER) -d $(DB_NAME); \ + for state in data/census2000/*; do \ + for shapefile in $$state/lines/*.shp; do \ + $(PG_BINDIR)/shp2pgsql \ + -a \ + -s $(TIGER_SRID) \ + -D \ + $$shapefile \ + tiger_lines \ + | psql -U $(DB_USER) -d $(DB_NAME); \ + done; \ done; bin/sf1blocks2sql src/Tests/Fixtures/SummaryFile1/mdgeo.uf1 sf1_blocks \ -- 2.43.2