Geo-enriched data based on shapes for visualizations

A method comprising:

• receiving a request for a map visualization that includes geo-enriched data comprising a set of shapes, the request specifying a set of geographical regions at a level in a plurality of levels of a hierarchy of shape data, each shape data in the hierarchy of shape data comprising spatial data defining a shape associated with a geographical region and a level attribute for indicating a level in the plurality of levels of the hierarchy of shape data with which the shape is associated;
• in response to the request, generating a query for the geo-enriched data;
• sending the query to a geo-enriching data system, wherein the geo-enriching data system is configured to process the query based on the hierarchy of shape data and a set of tables, each record in each table in the set of tables comprising a reference to shape data in the hierarchy of shape data and a geographical region associated with the referenced shape data, wherein processing the query comprises:
• identifying a set of records in the set of tables each having a geographical region that matches a geographical region in the set of geographical regions specified in the request, and
• identifying a set of shape data in the hierarchy of shape data referenced by the references in the identified set of records;
• receiving the geo-enriched data from the geo-enriching data system;
• and
• generating the map visualization that includes the set of shapes.

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 a request for a map visualization that includes geo-enriched data comprising a set of shapes, the request specifying a set of geographical regions at a level in a plurality of levels of a hierarchy of shape data, each shape data in the hierarchy of shape data comprising spatial data defining a shape associated with a geographical region and a level attribute for indicating a level in the plurality of levels of the hierarchy of shape data with which the shape is associated;
• in response to the request, generate a query for the geo-enriched data;
• send the query to a geo-enriching data system, wherein the geo-enriching data system is configured to process the query based on the hierarchy of shape data and a set of tables, each record in each table in the set of tables comprising a reference to shape data in the hierarchy of shape data and a geographical region associated with the referenced shape data, wherein processing the query comprises:
• identifying a set of records in the set of tables each having a geographical region that matches a geographical region in the set of geographical regions specified in the request, and
• identifying a set of shape data in the hierarchy of shape data referenced by the references in the identified set of records;
• receive the geo-enriched data from the geo-enriching data system;
• and
• generate the map visualization that includes the set of shapes.