Skip to content

Instantly share code, notes, and snippets.

@severinmenard
Forked from springmeyer/DRR_IOM_v1.12.style
Created December 28, 2011 19:27
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
Custom osm2pgsql import for haiti - summary of issues viewing in ArcGIS10

Report from Séverin MENARD severin.menard@gmail.com

Written up by Dane Springmeyer dane@dbsgeo.com

Summary

OSM haiti extract, imported using osm2pgsql and a custom style file, is visible in ArcGIS 10 (spatial data) but the attribute tables are empty.

Steps to replicate

createdb -T template_postgis
wget http://labs.geofabrik.de/haiti/latest.osm.bz2
osm2pgsql -S DRR_IOM_v1.12.style -d haiti latest.osm.bz2

Tried adding primary key but did not help: https://gist.github.com/1521679

Version details

# select postgis_version();
            postgis_version            
---------------------------------------
 1.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
(1 row)
$ osm2pgsql --version
osm2pgsql SVN version 0.80.0 (32bit id space)
node,way IOM:project text #JOSM preset
node,way IOM_project_DRR:form_number text #JOSM preset
node,way NOTE text #JOSM preset
node,way access text linear #osm2pgsql style
node,way addr:city text #JOSM preset
node,way addr:flats text polygon #osm2pgsql style
node,way addr:full text #JOSM preset
node,way addr:housenumber text linear #osm2pgsql style
node,way addr:interpolation text linear #osm2pgsql style
node,way addr:street text #JOSM preset
node,way addr:ward text #JOSM preset
node,way admin_level text linear #osm2pgsql style
node,way aerialway text linear #osm2pgsql style
node,way aeroway text polygon #osm2pgsql style
node,way amenity text nocache,polygon #osm2pgsql style
node,way amenity:police text #JOSM preset
node,way area text #osm2pgsql style
node,way attribute_source_date text #JOSM preset
node,way attribute_source_name text #JOSM preset
node,way attribute_source_type text #JOSM preset
node,way barrier text linear #osm2pgsql style
node,way barrier_bypass text #JOSM preset
node,way barriers:obstacle_description text #JOSM preset
node,way bicycle text nocache #osm2pgsql style
node,way bladder text #JOSM preset
node,way borehole text #JOSM preset
node,way boundary text linear #osm2pgsql style
node,way bridge text linear #osm2pgsql style
node,way bridge_base_material:concrete text #JOSM preset
node,way bridge_base_material:metal text #JOSM preset
node,way bridge_base_material:reinforced_concrete text #JOSM preset
node,way bridge_base_material:stone text #JOSM preset
node,way bridge_base_material:unspecified text #JOSM preset
node,way bridge_base_material:wood text #JOSM preset
node,way bridge_type text #JOSM preset
node,way building text polygon #osm2pgsql style
node,way building_base_material:canvas text #JOSM preset
node,way building_base_material:concrete text #JOSM preset
node,way building_base_material:other text #JOSM preset
node,way building_base_material:plastic_sheeting text #JOSM preset
node,way building_base_material:pvc text #JOSM preset
node,way building_base_material:reinforced_concrete text #JOSM preset
node,way building_base_material:sheet_metal text #JOSM preset
node,way building_base_material:tent text #JOSM preset
node,way building_base_material:unspecified text #JOSM preset
node,way building_base_material:wood text #JOSM preset
node,way building_roof_material:canvas text #JOSM preset
node,way building_roof_material:concrete text #JOSM preset
node,way building_roof_material:other text #JOSM preset
node,way building_roof_material:plastic_sheeting text #JOSM preset
node,way building_roof_material:pvc text #JOSM preset
node,way building_roof_material:sheet_metal text #JOSM preset
node,way building_roof_material:stone text #JOSM preset
node,way building_roof_material:tent text #JOSM preset
node,way building_roof_material:tiles text #JOSM preset
node,way building_roof_material:unspecified text #JOSM preset
node,way building_roof_material:wood text #JOSM preset
node,way building_status text #JOSM preset
node,way cafeteria text #JOSM preset
node,way canal:obstacle_type text #JOSM preset
node,way canal_banks_barriers_desc_left text #JOSM preset
node,way canal_banks_barriers_desc_right text #JOSM preset
node,way canal_banks_barriers_left text #JOSM preset
node,way canal_banks_barriers_right text #JOSM preset
node,way canal_banks_desc_left text #JOSM preset
node,way canal_banks_desc_right text #JOSM preset
node,way canal_banks_left text #JOSM preset
node,way canal_banks_right text #JOSM preset
node,way canal_base_material text #JOSM preset
node,way canal_description text #JOSM preset
node,way canal_roof_desc text #JOSM preset
node,way canal_roof_extent text #JOSM preset
node,way canal_type text #JOSM preset
node,way capacity text #JOSM preset
node,way capacity:beds text #JOSM preset
node,way capacity:seats text #JOSM preset
node,way capacity:standing text #JOSM preset
node capital text linear #osm2pgsql style
node,way cholera_affected_people text #JOSM preset
node,way classrooms:afternoon text #JOSM preset
node,way classrooms:evening text #JOSM preset
node,way classrooms:morning text #JOSM preset
node,way classrooms:night text #JOSM preset
node,way clinic text #JOSM preset
node,way construction text linear #osm2pgsql style
node,way cutting text linear #osm2pgsql style
node,way depth text #JOSM preset
node,way disability_access text #JOSM preset
node,way disused text linear #osm2pgsql style
node,way doctors text #JOSM preset
node,way drinking_water text #JOSM preset
node ele text linear #osm2pgsql style
node,way embankment text linear #osm2pgsql style
node,way employees:afternoon text #JOSM preset
node,way employees:evening text #JOSM preset
node,way employees:morning text #JOSM preset
node,way employees:night text #JOSM preset
node,way employees_non_medical text #JOSM preset
node,way first_aid text #JOSM preset
node,way flood_prone text #JOSM preset
node,way flood_prone:first_year text #JOSM preset
node,way flood_prone:frequency text #JOSM preset
node,way flood_prone:height text #JOSM preset
node,way flood_prone:impact text #JOSM preset
node,way flood_prone:informant text #JOSM preset
node,way flood_prone:rise text #JOSM preset
node,way flood_prone:water_clear text #JOSM preset
node,way flood_prone:water_detritus text #JOSM preset
node,way flood_prone:water_mud text #JOSM preset
node,way foot text linear #osm2pgsql style
node,way gender_access text #JOSM preset
node,way generator:source text #JOSM preset
node,way generator:source_others text #JOSM preset
node,way geometry_source_date text #JOSM preset
node,way geometry_source_name text #JOSM preset
node,way geometry_source_type text #JOSM preset
node,way health_facility_type text #JOSM preset
node,way healthcare:cholera text #JOSM preset
node,way healthcare_departments:ambulances text #JOSM preset
node,way healthcare_departments:general_medicine text #JOSM preset
node,way healthcare_departments:medical_laboratory text #JOSM preset
node,way healthcare_departments:operating_room text #JOSM preset
node,way healthcare_departments:others text #JOSM preset
node,way highway text linear #osm2pgsql style
node,way historic text polygon #osm2pgsql style
node,way horse text linear #osm2pgsql style
node,way id:db_ctc text #JOSM preset
node,way id:uid text #JOSM preset
node,way id:uuid text #JOSM preset
node,way infirmary text #JOSM preset
node,way junction text linear #osm2pgsql style
node,way kitchen text #JOSM preset
node,way landfill_authority text #JOSM preset
node,way landfill_authority_other text #JOSM preset
node,way landfill_height text #JOSM preset
node,way landfill_length text #JOSM preset
node,way landfill_type:dumpster text #JOSM preset
node,way landfill_type:ground text #JOSM preset
node,way landfill_type:other text #JOSM preset
node,way landfill_type:pit text #JOSM preset
node,way landfill_width text #JOSM preset
node,way landuse text polygon #osm2pgsql style
node,way layer text linear #osm2pgsql style
node,way learning text linear #osm2pgsql style
node,way leisure text polygon #osm2pgsql style
node,way length text #JOSM preset
node,way lock text linear #osm2pgsql style
node,way man_made text polygon #osm2pgsql style
node,way marketplace:alimentary text #JOSM preset
node,way marketplace:authority text #JOSM preset
node,way marketplace:covered text #JOSM preset
node,way marketplace:note text #JOSM preset
node,way marketplace:open_air text #JOSM preset
node,way marketplace:specialized text #JOSM preset
node,way marketplace:stands text #JOSM preset
node,way marketplace_status text #JOSM preset
node,way maxweight text #JOSM preset
node,way military text polygon #osm2pgsql style
node,way motorcar text linear #osm2pgsql style
node,way name text linear #osm2pgsql style
node,way name:en text #JOSM preset
node,way name:fr text #JOSM preset
node,way name:kr text #JOSM preset
node,way natural text polygon #osm2pgsql style
node,way note text delete #osm2pgsql style
node,way nurses text #JOSM preset
node,way office text #JOSM preset
node,way oneway text linear #osm2pgsql style
node,way opening_hours:afternoon text #JOSM preset
node,way opening_hours:evening text #JOSM preset
node,way opening_hours:friday text #JOSM preset
node,way opening_hours:monday text #JOSM preset
node,way opening_hours:morning text #JOSM preset
node,way opening_hours:night text #JOSM preset
node,way opening_hours:saturday text #JOSM preset
node,way opening_hours:sunday text #JOSM preset
node,way opening_hours:thursday text #JOSM preset
node,way opening_hours:tuesday text #JOSM preset
node,way opening_hours:unspecified text #JOSM preset
node,way opening_hours:wednesday text #JOSM preset
node,way operational_status text #JOSM preset
node,way operational_status_quality text #JOSM preset
node,way operator text linear #osm2pgsql style
node,way operator_id text #JOSM preset
node,way operator_type text #JOSM preset
node,way operator_type_other text #JOSM preset
node,way organization_location_type text #JOSM preset
node,way osm_timestamp text #osm2pgsql style
node,way osm_uid text #osm2pgsql style
node,way osm_user text #osm2pgsql style
node,way osm_version text #osm2pgsql style
node,way photo_name text #JOSM preset
node,way photo_num text #JOSM preset
node,way photo_url text #JOSM preset
node,way pitlatrine text #JOSM preset
node,way place text linear #osm2pgsql style
node,way place:area text #JOSM preset
node,way place:area_alternate text #JOSM preset
node,way place:description text #JOSM preset
node,way place:nearestlandmark text #JOSM preset
node poi text #osm2pgsql style
node,way power text polygon #osm2pgsql style
node,way power_source text linear #osm2pgsql style
node,way practicability text #JOSM preset
node,way public_adults:afternoon text #JOSM preset
node,way public_adults:evening text #JOSM preset
node,way public_adults:morning text #JOSM preset
node,way public_adults:night text #JOSM preset
node,way public_under18:afternoon text #JOSM preset
node,way public_under18:evening text #JOSM preset
node,way public_under18:morning text #JOSM preset
node,way public_under18:night text #JOSM preset
node,way pupils:afternoon text #JOSM preset
node,way pupils:evening text #JOSM preset
node,way pupils:morning text #JOSM preset
node,way pupils:night text #JOSM preset
node,way railway text linear #osm2pgsql style
node,way ramp text #JOSM preset
node,way ref text linear #osm2pgsql style
node,way registry_name text #JOSM preset
node,way religion text nocache #osm2pgsql style
node,way religion:denomination text #JOSM preset
node,way residence text linear #osm2pgsql style
node,way roof_status text #JOSM preset
node,way route text linear #osm2pgsql style
node,way school:first_cycle text #JOSM preset
node,way school:preschool_cycle text #JOSM preset
node,way school:second_cycle text #JOSM preset
node,way school:third_cycle text #JOSM preset
node,way service text linear #osm2pgsql style
node,way shop text polygon #osm2pgsql style
node,way source text delete #osm2pgsql style
node,way sport text polygon #osm2pgsql style
node,way status text #JOSM preset
node,way store text #JOSM preset
node,way surface text #JOSM preset
node,way surface_condition text #JOSM preset
node,way survey_information_access text #JOSM preset
node,way surveyor:GPS text #JOSM preset
node,way surveyor:email text #JOSM preset
node,way surveyor:name text #JOSM preset
node,way surveyor:phone text #JOSM preset
node,way tank text #JOSM preset
node,way tap text #JOSM preset
node,way telecom:internet text #JOSM preset
node,way telecom:land_line text #JOSM preset
node,way telecom:radio text #JOSM preset
node,way toilets:access text #JOSM preset
node,way toilets:basement text #JOSM preset
node,way toilets:cleaning text #JOSM preset
node,way toilets:durability text #JOSM preset
node,way toilets:emptying text #JOSM preset
node,way toilets:tank text #JOSM preset
node,way toilets:technology text #JOSM preset
node,way tourism text polygon #osm2pgsql style
way tracktype text linear #osm2pgsql style
node,way transportation_use_category text #JOSM preset
node,way tunnel text linear #osm2pgsql style
node,way waste_type:building_waste text #JOSM preset
node,way waste_type:common_urban_waste text #JOSM preset
node,way waste_type:industrial_polluting text #JOSM preset
node,way waste_type:other text #JOSM preset
node,way water_place:access text #JOSM preset
node,way water_place:cleaning text #JOSM preset
node,way water_place:durability text #JOSM preset
node,way water_purification text #JOSM preset
node,way water_supply text #JOSM preset
node,way waterway text polygon #osm2pgsql style
way way_area real #osm2pgsql style
node,way width text linear #osm2pgsql style
node,way wood text linear #osm2pgsql style
node,way z_order int4 linear #osm2pgsql style
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment