Different data sources for regions in geographical hierarchies

Patent metadata

Field	Value
Publication number	US-11308136-B2
Application number	US-201816107682-A
Country	US
Kind code	B2
Filing date	Aug 21, 2018
Priority date	Aug 21, 2018
Publication date	Apr 19, 2022
Grant date	Apr 19, 2022

Abstract

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives an input specifying a location field of a dataset. In response to the input, the program further retrieves a set of geographical hierarchy definitions. The program also retrieves, from the data source specified for a level in the geographical hierarchy defined by a geographical hierarchy definition in the set of geographical hierarchy definitions, a subset of a set of geometries representing a set of geographical regions belonging to the level in the geographical hierarchy. For each geometry in the subset of the set of geometries, at least one record in the dataset has a spatial point in a location field that falls within the geometry. The program further provides the subset of the set of geometries in a view of a map.

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 device, the program comprising sets of instructions for:
receiving an input specifying a location field of a dataset, the dataset comprising a set of records, each record in the set of records comprising the location field and a set of fields, the location field configured to store a spatial point;
in response to the input, retrieving a set of geographical hierarchy definitions, each geographical hierarchy definition in the set of hierarchy definitions comprising a number of levels in a geographical hierarchy and a data source for each level in the geographical hierarchy;
retrieving, from the data source specified for a first level in the geographical hierarchy defined by a geographical hierarchy definition in the set of geographical hierarchy definitions, a subset of a first set of geometries representing a first set of geographical regions belonging to the first level in the geographical hierarchy, wherein, for each geometry in the subset of the first set of geometries, at least one record in the dataset has a spatial point in the location field that falls within the geometry;
providing the subset of the first set of geometries in a view of a map;
receiving a selection of a second level in the geographical hierarchy defined by the geographical hierarchy definition, wherein the data source specified for the second level in the geographical hierarchy and the data source specified for the first level in the geographical hierarchy are different data sources; and
in response to the selection of the second level, retrieving, from the data source specified for the second level in the geographical hierarchy, a subset of a second set of geometries representing a second set of geographical regions belonging to the second level in the geographical hierarchy, wherein each geometry in the subset of the second set of geometries has at least one record in the dataset with a spatial point in the location field that falls within the geometry.

2. The non-transitory machine-readable medium of claim 1 , wherein the geographical hierarchy defined by the geographical hierarchy definition in the set of geographical hierarchy definitions is a first geographical hierarchy defined by a first geographical hierarchy definition in the set of geographical hierarchy definitions, wherein the program further comprises sets of instructions for:
receiving a selection of a second geographical hierarchy defined by a second geographical hierarchy definition in the set of geographical hierarchy definitions; and
in response to the selection of the second geographical hierarchy definition, retrieving, from the data source specified for a level in the second geographical hierarchy, a subset of a third set of geometries representing a third set of geographical regions belonging to the level in the second geographical hierarchy, wherein each geometry in the subset of the third set of geometries has at least one record in the dataset with a spatial point in the location field that falls within the geometry.

3. The non-transitory machine-readable medium of claim 2 , wherein the data source specified for the second level in the second geographical hierarchy and the data source specified for the first level in the first geographical hierarchy are different data sources.

4. The non-transitory machine-readable medium of claim 1 , wherein retrieving the set of geographical hierarchy definitions comprises:
generating a query for the set of geographical hierarchy definitions;
sending the query to a computing system for execution; and
receiving the set of geographical hierarchy definitions from the computing system.

5. The non-transitory machine-readable medium of claim 1 , wherein retrieving the set of geographical hierarchy definitions comprises:
generating a query for the set of geographical hierarchy definitions;
executing the query on a database of the device; and
receiving the set of geographical hierarchy definitions from the database.

6. A method comprising:
receiving an input specifying a location field of a dataset, the dataset comprising a set of records, each record in the set of records comprising the location field and a set of fields, the location field configured to store a spatial point;
in response to the input, retrieving a set of geographical hierarchy definitions, each geographical hierarchy definition in the set of hierarchy definitions comprising a number of levels in a geographical hierarchy and a data source for each level in the geographical hierarchy;
retrieving, from the data source specified for a first level in the geographical hierarchy defined by a geographical hierarchy definition in the set of geographical hierarchy definitions, a subset of a first set of geometries representing a first set of geographical regions belonging to the first level in the geographical hierarchy, wherein, for each geometry in the subset of the first set of geometries, at least one record in the dataset has a spatial point in the location field that falls within the geometry;
providing the subset of the first set of geometries in a view of a map;
receiving a selection of a second level in the geographical hierarchy defined by the geographical hierarchy definition, wherein the data source specified for the second level in the geographical hierarchy and the data source specified for the first level in the geographical hierarchy are different data sources; and
in response to the selection of the second level, retrieving, from the data source specified for the second level in the geographical hierarchy, a subset of a second set of geometries representing a second set of geographical regions belonging to the second level in the geographical hierarchy, wherein each geometry in the subset of the second set of geometries has at least one record in the dataset with a spatial point in the location field that falls within the geometry.

7. The method of claim 6 , wherein the geographical hierarchy defined by the geographical hierarchy definition in the set of geographical hierarchy definitions is a first geographical hierarchy defined by a first geographical hierarchy definition in the set of geographical hierarchy definitions, wherein the method further comprises:
receiving a selection of a second geographical hierarchy defined by a second geographical hierarchy definition in the set of geographical hierarchy definitions; and
in response to the selection of the second geographical hierarchy definition, retrieving, from the data source specified for a level in the second geographical hierarchy, a subset of a third set of geometries representing a third set of geographical regions belonging to the level in the second geographical hierarchy, wherein each geometry in the subset of the third set of geometries has at least one record in the dataset with a spatial point in the location field that falls within the geometry.

8. The method of claim 7 , wherein the data source specified for the second level in the second geographical hierarchy and the data source specified for the first level in the first geographical hierarchy are different data sources.

9. The method of claim 6 , wherein retrieving the set of geographical hierarchy definitions comprises:
generating a query for the set of geographical hierarchy definitions;
sending the query to a computing system for execution; and
receiving the set of geographical hierarchy definitions from the computing system.

10. The method of claim 6 , wherein retrieving the set of geographical hierarchy definitions comprises:
generating a query for the set of geographical hierarchy definit

Assignees

• Sap Se

Inventors

• Tiu Jonathan
• Bolognese Christopher
• Kohan Anthony
• Yin Fangzhou
• Sharma Sumedha
• Lloyd James

Classifications

• G06F16/29 Primary

  Geographical information databases · CPC title

• G01C21/3878

  Hierarchical structures, e.g. layering · CPC title

• G06F16/27

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title

• G01C21/3667

  Display of a road map (G01C21/3614 takes precedence; guidance using 3D or perspective road maps G01C21/3635) · CPC title

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title