GO Loader Aviation 1.2 is here! Take a look at what's new.
Skip to end of metadata
Go to start of metadata

This page provides a step by step guide to using the OpenStreetMap Tool to generate geometry features. This Tool should be used after data load and non-spatial indexing. Only when the tool has finished processing should the spatial index be created.

The OpenStreetMap GO Loader Tool Interface

Jump to...

What does the OpenStreetMap Tool do?

The OpenStreetMap Tool provides the end user with the ability to view OpenStreetMap data in a GIS, as well as the ability to do spatal analysis and querying. It does this by identifying line and polygon features within the dataset then creates geometries for each relation and way (but not point, which has already had geometry generated for it by Go Loader Plugins during the data load).

The OpenStreetMap Tool populates the following tables in your database:



OSM Attributes:

Attribute ‘TAGS’ are available from the single OSM_WAY_TAG’s table. The OSM_WAY_TAG table is joined using column FKEY_WAY foreign key to BOTH the OSM_LINE and OSM_POLYGON datasets using the in the PRIMAY_KEY as the parent key.

Using the OpenStreetMap Tool

The OpenStreetMap Tool currently supports Oracle 10g/11g, SQLServer2008 and PostGIS v1.5 databases.

Step 1. Open the OpenStreetMap Tool:

From the GO Loader Tools menu select the OpenStreetMap Tool

Image displaying how to open the OpenStreetMap GeometryTool.

This will open the OpenStreetMap dialog window...

Step 2. OpenStreetMap Tool (Wizard)

Read more information about the OpenStreetMap Model and what it includes, as well as what the Tool actually does.

  • Click Next to move onto the next window.


Display attributes in a GIS

You can amend the standard project template to include user-defined attributes from the OpenStreetMap tag_keys in order to display them in a GIS. 

Image displaying OpenStreetMap dialog window.


Step 3. Create OSM Geometries

The OpenStreetMap Geometries page displays the tables that will contain generated geometries.

 Geometry counts are displayed, showing the number of geometries that will be created for each OpenStreetMap feature.

  • Parallel Processes is default to 1. You can increase this depending on your system resources. 
  • Click Create Geometries to begin the geometry creation process. This will open a summary window, displayed during geometry processing.

Image displaying OpenStreetMap Panel dialog window.


Once the process is complete, the total geometries loaded and their type will be displayed. 

  • Click Close on the OpenStreetMap progress dialog window.
  • Click Finish on the OpenStreetMap Tool window to close the window.

Image displaying OpenStreetMap Progress complete window.

Step 4. Create a Spatial Index

Now Geometries have been created in your database, you should use GO Loader to create your spatial indices.

  • From GO Loader Create Indices (tab # 13) use the Selection Shortcuts dropdown (bottom right hand corner)
  • Choose Clear Selection if previous selections are still present.
  • Then select Spatial Indices
  • Click Create Selected Indices button

Image displaying GO Loader Create Spatial Index window.

Step 5. Registering with ArcSDE

This step is for customers wishing to register their OpenStreetMap tables held in Oracle with ESRI ArcSDE.

Copy & Paste the commands below in a .bat file, in order to register your database tables as layers within ESRI ArcSDE. You will need to modify the paramters such as -u <username> -p <password> etc to match those used by your system.

This is set up for the OpenStreetMap Project Template supplied with the GO Loader Installer, and uses PRIMARY_KEY as the primary key and the ID column is set as the Feature ID column.

sdelayer -o register -l OSM_NODE_POINT,GEOMETRY -e np+ -t SDO_GEOMETRY -C PRIMARY_KEY,USER -G 4326 -i 5151 -u OSM -p OSM -P HIGH -x -200,-100,10000000
sdelayer -o register -l OSM_WAY_LINE,GEOMETRY -e nsl+ -t SDO_GEOMETRY -C PRIMARY_KEY,USER -G 4326 -i 5151 -u OSM -p OSM -P HIGH -x -200,-100,10000000
sdelayer -o register -l OSM_WAY_POLYGON,GEOMETRY -e na+ -t SDO_GEOMETRY -C PRIMARY_KEY,USER -G 4326 -i 5151 -u OSM -p OSM -P HIGH -x -200,-100,10000000
sdelayer -o register -l OSM_RELATION_POLYGON,GEOMETRY -e na+ -t SDO_GEOMETRY -C PRIMARY_KEY,USER -G 4326 -i 5151 -u OSM -p OSM -P HIGH -x -200,-100,10000000


Step 6. View OpenStreetMap in a GIS

Once the spatial index has been generated, you are now ready to view your data in a GIS. Connect your GIS to the database you have loaded your OpenStreetMap data into and display the following tables:

OSM_NODE_POINT - point data generated with the OpenStreetMap Tool

OSM_WAY_LINE - line data generated with the OpenStreetMap Tool

OSM_WAY_POLYGON - polygon data generated with the OpenStreetMap Tool 

OSM_RELATION_POLYGON - complex polygon data generated with the OpenStreetMap Tool 


We provide ESRI Layer file resources to view OpenStreetMap data in ESRI - based on OpenStreetMap Mapnik rendering.

 Image of OpenStreetMap Data registered with ArcSDE and displayed in ArcMap



Further Reading

Now you can see your OpenStreetMap data in a GIS, why not take a look at what else you can do with GO Loader?

  • No labels