- 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 \
+ echo "Importing $$shapefile."; \
+ $(PG_BINDIR)/shp2pgsql \
+ -a \
+ -s $(TIGER_SRID) \
+ $$shapefile \
+ tiger_lines \
+ | bin/filter-transactions \
+ | psql -U $(DB_USER) -d $(DB_NAME) \
+ > /dev/null; \
+ done; \