Start of Content Area

Procedure documentation Geocoding Using ArcView GIS  Locate the document in its SAP Library structure

Prerequisites

·        You have installed the ESRI ArcView software on your system and requested the geographical data you need from ESRI, if this is not already on the data CD delivered with the software.

·        You have completed the following step:

Downloading BI master data into a dBase file

Use

Using geocoding, you enhance dynamic geo-characteristics from BI master data with the geographical attributes degrees of longitude and latitude.

Procedure

Note

The following procedure is an example procedure that you can reconstruct using the demo contents. For further details on geocoding and on the ArcView functions, refer to ArcView documentation.

Note

In ArcView GIS you can execute many commands easily from the context menu. To open the context menu, select an element and click on it with the secondary mouse button.

...

       1.      Open using Programs    ArcGIS    ArcCatalog.

       2.      Under Address Locators, double-click on the entry New Address Locator.

       3.      In the Create New Address Locator window, select the entry Single Field (File) and click on OK.

       4.      In the New: Single Field (File) Address Locator window, enter the name of the service and the description, for example, Geocoding Service SoldTo. Under Reference data, enter the path for the reference Shapefile, for example, g_stat00.shp and from the Fields dropdown menu, select the most appropriate entry, in this case, SAPBWKEY. Under Output Fields, activate the control box X and Y Coordinates.

In the navigation menu, the new service is displayed under Address Locators.

       5.      Open using Programs ArcGis    ArcMap and start with A New, Empty Map in the entry dialog. Choose OK.

       6.      In the standard toolbar, click on the Add Data symbol and add the corresponding dBase file, for example, SoldTo.dbf as a new table.

The Choose an address locator to use.. window is opened. All available services are displayed in this window.

       7.      Click Add and, in choose the Address Locator entry in the Add Address Locator window under Search in:. Select the service that you created in step four (in this example, Geocoding Service SoldTo) and click on Add.

       8.      In the Choose an address locator to use.. window, select the service again, and click OK.

The Geocode Addresses window is opened.

       9.      Under Address Input Fields, choose the appropriate entry, for example, 1_0D_Regio. This is the field that tallies with the reference data. Under Output   Output Shapefile or feature class, enter the path under which the result of the geocoding is to be saved. Choose OK.

The data is geocoded.

   10.      After you have checked the statistics in the Review/Rematch Addresses window, click Done.

Result

The dynamic geo-characteristics for your master data have now been enhanced with additional geo-information in the form of the columns X (longitude) and Y (latitude). In ArcMap this information is displayed by points displayed in the right-hand side of the work area.

To check whether the result appears as you had planned, you can place the points on the relevant map. Proceed as follows:

...

       1.      Click on the Add Data symbol on the tab page.

       2.      Select the reference Shapefile that you used in step four, for example, g_stat00.shp.

       3.      Click Add.

The map is displayed in the work area in a layer beneath the points.

 

End of Content Area