Skip to Content

Deriving longitude and latitude details from address

Hi,

I have address data and would need to derive longitude and latitude information from this.

Am aware that the geo-coding feature of SDQ in SP9 allows us to do this but the license cost is not something the client is too happy about.

Need some alternate solution.s Please help out.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 18, 2015 at 05:37 PM

    Hi Shyam,

    If client has SAP Data Services then you have Geocoder transform available as part of Data Quality transform.

    Regards,

    Venkat N.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 19, 2015 at 07:30 AM

    Hi,

    in SAP Visual Business provides some geo services on a Netweaver platform. OData services are also available.

    The Visual Business Backend API includes also a GeoCoding abstraction. The available function are provided by interface IF_VBI_GEOCODING_SERVICE. You can get an instance of this interface from the factory class CL_VBI_GEOCODER: data: LV_GEO_CODER type ref to IF_VBI_GEOCODING_SERVICE. LV_GEO_CODER = CL_VBI_GEOCODER=>GET_INSTANCE( ). The above coding snipped will return you the instance of the last use geocoder. Usually this work, since the geo coding service assigned to the application is instantiated upon the application initialization. Thus you have to make sure that the VBI application is already instantiated and initialized.In case there is no VBI application or no service is assigned to the used application you can also retrieve a dedicated coder from the factory by providing the service ID: LV_GEO_CODER = CL_VBI_GEOCODER=>GET_INSTANCE( 'OSM' ). The available service IDs are maintained in view cluster VBIVC_APPDEV and can be retrieved with method CL_VBI_CUSTOMIZING_ACCESS=>GET_SERVICES( ).Once you have an instance of the geocoding interface you can use it for
    • Getting geo coordinates for an address (FIND_LOCOCATION)
    • Calculating a a route between two addresses (CALCULATE_ROUTE_SIMPLE)
    • Calculating a route between an arbitrary number of way point (CALCULATE_ROUTE)
    • Getting address information for a given geo location (FIND_LOCATION_REVERSE)

    You can use CL_VBI_GEOCODING_OSM as an example.

    One implementation uses the Openstreetmap services provided by some vendors without a fee.

    But please keep in mind that you have to take a look at the license conditions. E.g. for some services you are only allowed to request an adress once a second.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.