In this article we will discuss about the geo-characteristics of a location.
1. Static Geo-Characteristics:
A static geo-characteristic is a characteristic that describes a surface (polygon), whose geographical coordinates rarely change. Country and region are examples of static geo-characteristics. Data from areas or polygons are stored in Shape-files that define the geometry and the attributes of the geo-characteristics.
2. Dynamic Geo-Characteristics:
A dynamic geo-characteristic is a characteristic that describes a location (information in point form), whose geographical coordinates can change more frequently. Customer and plant are examples of dynamic geo-characteristics because they are rooted to one geographical “point” that can be described by an address, and the address data of these characteristics can often change.
BW adds a range of standard attributes to this geo-characteristic. These standard attributes store the geographical coordinates of the corresponding object for each row in the master data table.
There are the following geo-attributes:
At present, only the LONGITUDE and LATITUDE attributes are used. ALTITUDE, PRECISID and SRCID are reserved for future use.
3. Dynamic Geo-Characteristics with Values from Attributes:
The system treats this geo-characteristic as a regular dynamic geo-characteristic that describes a location (geographical information as a point on map). There is a geocode for each dynamic geo-characteristic individually; a dynamic geo-characteristic can get its geo-attributes (longitude, latitude, altitude) from another dynamic characteristic that has been geocoded already like postal code, 110011, and 200601. Customers and plants are examples of this type of dynamic geo-characteristics with values from attributes (type 3).
The geo-attributes described above are not added to the master data table on the database level. Instead, the geo-coordinates are stored in the master data table of a regular attribute of the characteristic. We want to define a dynamic geo- characteristic for Plant with the postal code as an attribute. The geo-coordinates are generated from the postal code master data table during the runtime.
This method prevents redundant entries from appearing in the master data table.
4. Static Geo-Characteristics with Geo-Attributes:
A static geo-characteristic is the geo-attributes that include longitude, latitude, and altitude. Geo-characteristics of type 3 are able to refer to. The postal code, for example, can be used as a static geo-characteristic with geo-attributes.
OPOSTCD_GIS (postal code) is used as an attribute in the dynamic geo- characteristic OBPARTNER (business partner) that gets its geo-coordinates from this attribute. In this way, the location information for the business partner is stored on the level of detail of the postal code areas.