Different data sources for regions in geographical hierarchies

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.

A system comprising:

• a set of processors;
• and
• a non-transitory machine-readable medium storing instructions that when executed by at least one processor in the set of processors cause the at least one processor to:
• receive 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, retrieve 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;
• retrieve, 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;
• provide the subset of the set of geometries in a view of a map;
• receive 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, retrieve, 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.