exporting postbox locations into ArcGIS

General talk
1

Hi,

I’m a student at UCL London and as the title says really, I’d like to be able to export the postbox locations from Openstreetmap and put them in as a layer into ArcGis. Does anyone think this is possible? If so, how?
I hope this isn’t a stupid question and I thank you in advance for your responses

Rich

2

Welcome to OSM Rich :slight_smile:

Have you tried ArcGIS OSM Addon? http://wiki.openstreetmap.org/wiki/ArcGIS

3

Hi,

There are many ways to do this but if you are going to use GIS tools later it could be a good idea to import data first into PostGIS database with osm2pgsql. I am not sure if ArcGIS supports PostGIS directly but there are utilities which can be used for quering data from PostGIS and converting result into shapefiles. Ogr2ogr and pgsql2shp are two examples. The latter comes with PostGIS and here is a cheat sheet
http://www.bostongis.com/pgsql2shp_shp2pgsql_quickguide.bqg

In your case you would need to run is like
pgsql2shp -f “/path/to/output” -h myserver -u apguser -P apgpassword mygisdb
“SELECT * FROM osm_point WHERE amenity= ‘post_box’”