I've been trying for over a week now, and I'm not sure what I'm doing wrong and I haven't found the answer yet.
Target. I am trying to display and symbolize the OSM dataset over Jordan in ArcGIS for Desktop 10.3.
Software. Currently running PostgreSQL 9.3.5 and PostGIS 2.1 on a Windows 2008 R2 Server. ArcMap 10.3 is also installed on a Windows 2008 R2 Server. Along with ArcGIS for Server 10.3.
Steps after installation.
- Use ArcGIS tool "Create Enterprise Geodatabase" and Name it jordan. (Works)
- In PostgreSQL use
CREATE EXTENSION postgis;(Works)
- Use osm2pgsql using -
osm2pgsql -s -c -H servername -d jordan -U sde -W -M -S .\default.style .\jordan-latest.osm.pbfto add the data to the PostGIS database (Works)
- Connect to Database in ArcGIS (Works)
*_linedatabase record with ArcGIS and Add OID (Works)
- Add the feature in ArcMap (Works - Feature Geometry shows up)
- Open Attribute table (Failed with error
Could not load data from the data source. If you can correct the problem, press the refresh button to reload data. Possible problems can include bad network, invalid field, etc. Invalid SQL syntax [ERROR: syntax error at or near":" Line 1: select osm_id, access, addr:housename, addr:housenumber,... ::SQL state: 42602][jordan.sde.planet_osm_line])
I can not symbolize the data using the OpenStreetMap toolbox as well because of the same error.
I have tried changing the field names from
"_" and the error goes away, but the next error states
[ERROR: syntax error at or near","] and there is no comma in the field names so it must be inheriting it from somewhere else, and I have no clue where.
My ultimate goal of this project is to bring in the planet file from osm and symbolize it correctly.
What am I doing wrong, what other things can I try?