[OSM-talk] osm2pgsql import united_states data: alaska, hawaii seems missing

[Min Wang]

Hi

    (1)  I downloaded the united_stats data from
http://downloads.cloudmade.com/americas/northern_america/united_states

    then inported data to postgres/postgis:

  ./osm2pgsql  --slim   -S default.style -d gis -C 2048 
--number-processes=1 --cache-strategy=dense  united_states.osm.bz2

   The map can show US-48 states, but no alaska, hawaii.

   and seems united_state.osm do contain the hawaii data.

  grep Honolulu united_states.osm
<tag k="name:eu" v="Honolulu"/>
<tag k="name" v="Honolulu"/>
<tag k="is_in" v="Honolulu,Hawaii,Hawaii,HI,USA"/>
<tag k="gnis:County" v="Honolulu"/>
<tag k="is_in" v="Honolulu,Hawaii,Hawaii,HI,USA"/>
<tag k="gnis:County" v="Honolulu"/>
<tag k="is_in" v="Honolulu,Hawaii,Hawaii,HI,USA"/>
<tag k="gnis:County" v="Honolulu"/>
<tag k="is_in" v="Honolulu,Hawaii,Hawaii,HI,USA"/>
<tag k="gnis:County" v="Honolulu"/>
<tag k="is_in" v="Honolulu,Hawaii,Hawaii,HI,USA"/>

   What could be wrong?

(2) osm2pgsql : how to append extraction to existing data?

     I have imported alaska into postgres:
  ./osm2pgsql  --slim   -S default.style -d gis -C 2048 
--number-processes=1 --cache-strategy=dense  alaska.osm.bz2

    and the data can show on the map.

    then I tried to append the hawaii data to the existing data.

acorrding to : 
http://lists.openstreetmap.org/pipermail/talk/2011-October/060436.html

seems it can use -a without --slim to append the data,

      but I tried times to append data without success.

./osm2pgsql  -a -S default.style -d gis -C 2048 --number-processes=1 
--cache-strategy=dense  hawaii.osm.bz2


     any suggestion?


Thanks


Min Wang