Framework for data geocoding

Patent metadata

Field	Value
Publication number	US-10673945-B2
Application number	US-201615343340-A
Country	US
Kind code	B2
Filing date	Nov 4, 2016
Priority date	Nov 4, 2016
Publication date	Jun 2, 2020
Grant date	Jun 2, 2020

Abstract

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives, from a client device, a request to geo-enrich data that includes a set of data and a set of location data associated with the set of data. The program also selects a geocoder from a plurality of different geocoders based on the set of location data associated with the set of data. The program further geo-enriches the set of location data using the selected geocoder.

First claim

What is claimed is:

1. A non-transitory machine-readable medium storing a program executable by at least one processing unit of a computing device, the program comprising sets of instructions for:
receiving, from a client device, a set of tables and a request to geo-enrich data in the set of tables, the set of tables comprising a column configured to store a set of data, a set of columns configured to store a set of location data associated with the set of data, and a set of metadata associated with the set of columns, wherein each location data in the set of location data describes a location, area, or region;
analyzing the set of metadata associated with the set of columns to determine a type of location data that the set of columns is configured to store;
upon determining that the type of location data that the set of columns is configured to store is latitude and longitude data, selecting a first geocoder from a plurality of different geocoders;
upon determining that the type of location data that the set of columns is configured to store is data other than latitude and longitude data, selecting a second geocoder from the plurality of different geocoders; and
geo-enriching the set of location data using the selected first or second geocoder by converting the set of location data to a set of spatial data, wherein each spatial data in the set of spatial data defines a geometry of the location, area, or region described by a corresponding location data in the set of location data.

2. The non-transitory machine-readable medium of claim 1 , wherein the program further comprises a set of instructions for sending the geo-enriched data to the client device.

3. The non-transitory machine-readable medium of claim 1 , wherein the request specifies to persist the geo-enriched data, wherein the program further comprises a set of instructions for storing the geo-enriched data for later use.

4. The non-transitory machine-readable medium of claim 3 , wherein the request is a first request, wherein the program further comprises sets of instructions for:
receiving, from the client device, a second request for the geo-enriched data; and
in response to the second request, retrieving the stored geo-enriched data and sending the retrieved geo-enriched data to the client device.

5. The non-transitory machine-readable medium of claim 1 , wherein receiving the set of tables from the client device comprises receiving a file that the client device received through a drag and drop operation performed with the file on a map in a graphical user interface (GUI) presented on a display of the client device, wherein the file includes the set of tables that comprises the set of data and the set of location data.

6. The non-transitory machine-readable medium of claim 1 , wherein the first geocoder is an internal geocoder operating on the computing device, wherein the second geocoder is a geocoding service external to the computing device.

7. The non-transitory machine-readable medium of claim 1 , wherein determining that the type of location data that the set of columns is configured to store is data other than latitude and longitude data comprises determining that the type of location data that the set of columns is configured to store is address data.

8. A method comprising:
receiving, from a client device, a set of tables and a request to geo-enrich data in the set of tables, the set of tables comprising a column configured to store a set of data, a set of columns configured to store a set of location data associated with the set of data, and a set of metadata associated with the set of columns, wherein each location data in the set of location data describes a location, area, or region;
analyzing the set of metadata associated with the set of columns to determine a type of location data that the set of columns is configured to store;
upon determining that the type of location data that the set of columns is configured to store is latitude and longitude data, selecting a first geocoder from a plurality of different geocoders; and
upon determining that the type of location data that the set of columns is configured to store is data other than latitude and longitude data, selecting a second geocoder from the plurality of different geocoders; and
geo-enriching the set of location data using the selected first or second geocoder by converting the set of location data to a set of spatial data, wherein each spatial data in the set of spatial data defines a geometry of the location, area, or region described by a corresponding location data in the set of location data.

9. The method of claim 8 further comprising sending the geo-enriched data to the client device.

10. The method of claim 8 , wherein the request specifies to persist the geo-enriched data, wherein the method further comprises storing the geo-enriched data for later use.

11. The method of claim 10 , wherein the request is a first request, wherein the method further comprises:
receiving, from the client device, a second request for the geo-enriched data; and
in response to the second request, retrieving the stored geo-enriched data and sending the retrieved geo-enriched data to the client device.

12. The method of claim 8 , wherein receiving the set of tables from the client device comprises receiving a file that the client device received through a drag and drop operation performed with the file on a map in a graphical user interface (GUI) presented on a display of the client device, wherein the file includes the set of tables that comprises the set of data and the set of location data.

13. The method of claim 8 , wherein the first geocoder is an internal geocoder operating on the computing device, wherein the second geocoder is a geocoding service external to the computing device.

14. The method of claim 8 , wherein determining that the type of location data that the set of columns is configured to store is data other than latitude and longitude data comprises determining that the type of location data that the set of columns is configured to store is address data.

15. A system comprising:
a set of processing units; and
a non-transitory computer-readable medium storing instructions that when executed by at least one processing unit in the set of processing units cause the at least one processing unit to:
receive, from a client device, a set of tables and a request to geo-enrich data in the set of tables, the set of tables comprising a column configured to store a set of data, a set of columns configured to store a set of location data associated with the set of data, and a set of metadata associated with the set of columns, wherein each location data in the set of location data describes a location, area, or region;
analyze the set of metadata associated with the set of columns to determine a type of location data that the set of columns is configured to store;
upon determining that the type of location data that the set of columns is configured to store is latitude and longitude data, select a first geocoder from a plurality of different geocoders;
upon determining that the type of location data that the set of columns is configured to store is data other than latitude and longitude data, select a second geocoder from the plurality of different geocoders; and
geo-enrich the set of location data using the selected first or second geocoder by converting the set of location data to a set of spatial data, wherein each spatial data in the set of spatial data defines a geometry of the location, area, or region described by a corresponding location data in the set of location data

Assignees

• Sap Se

Inventors

• Asadi Mohsen
• Tiu Jonathan
• Hiew Lyndon
• Tam Christopher
• Om Sae-Won

Classifications

• H04W4/02

  Services making use of location information · CPC title

• G06F16/29

  Geographical information databases · CPC title

• H04L67/1097 Primary

  for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS] · CPC title

• H04L67/18

  Electricity · mapped topic

• H04L67/52

  specially adapted for the location of the user terminal · CPC title