Misalignment detection system for efficiently processing database-stored data and automatically generating misalignment information for display in interactive user interfaces
First Claim
1. A computer-implemented method of accessing one or more databases in order to determine information related to routing of an item and providing the determined information to a user in an interactive user interface, the computer-implemented method comprising:
- retrieving geographic data associated with a plurality of first geographic regions from a first database in the one or more databases, wherein the geographic data comprises a list of cities and a list of states;
for each first geographic region,generating a list of each combination of cities and states listed in the geographic data;
ranking each combination of cities and states based on a likelihood that the respective city and state combination is located within the respective first geographic region;
generating an average of geographic coordinates of each combination of cities and states that are ranked above a threshold value; and
determining a first location representing a center of the respective first geographic region based on the average of the geographic coordinates;
retrieving population data associated with a plurality of second geographic regions from a second database in the one or more databases;
for each first geographic region,identifying one or more of the second geographic regions within a first distance of the center of the respective first geographic region based on the population data, andmodifying the respective first geographic region to be a shape of the identified one or more of the second geographic regions and located at a set of geographic locations defined by the identified one or more of the second geographic regions;
generating user interface data for rendering the interactive user interface on a computing device, the interactive user interface including a map representing a large geographic region, wherein the map displays graphical representations of the plurality of modified first geographic regions at locations corresponding to the modified first geographic regions within the large geographic region;
receiving, via user input controlling at least a cursor, a selection of a first graphical representation of one modified first geographic region in the plurality of first geographic regions;
modifying the user interface data such that the interactive user interface displays an expanded view of the map, wherein the expanded view of the map includes a zoomed-in view of the one modified first geographic region and hides a view of other modified first geographic regions in the plurality of modified first geographic regions that otherwise could have been depicted in the expanded view of the map at the same time, and wherein the zoomed-in view of the one modified first geographic region includes a terrain of the one modified first geographic region and an identification of a location of one or more entities located within the one modified first geographic region;
receiving, via user input controlling at least the cursor, a selection of a first entity in the one or more entities located within the one modified first geographic region;
modifying the modified user interface data such that the interactive user interface displays shipment misalignment data associated with the first entity selected within the one modified first geographic region; and
modifying, in response to the selection of the first entity within the one modified first geographic region, the modified user interface data such that the interactive user interface includes, in a window, a selectable option to ship additional items to the one modified first geographic region in response to a determination that an amount of an item shipped to the one modified first geographic region does not exceed a threshold value.
8 Assignments
0 Petitions
Accused Products
Abstract
Various systems and methods are provided that integrate data from disparate sources to identify shipment misalignments and display such information in interactive user interfaces. For example, the systems described herein can define various geographic regions using location and census data and identify the defined geographic regions in which stores are located. Using shipment data and micro-market data, the systems described herein can then identify the geographic regions that items are shipped to, identify the demand for such items in the geographic regions, and determine whether the quantity of items shipped to the geographic regions is appropriate based on the demand. Such information can be displayed in an interactive user interface that allows a user to view the geographic clustering of item demand, identify potential opportunities for correcting shipment misalignment, and/or correct identified shipment misalignments.
215 Citations
11 Claims
-
1. A computer-implemented method of accessing one or more databases in order to determine information related to routing of an item and providing the determined information to a user in an interactive user interface, the computer-implemented method comprising:
-
retrieving geographic data associated with a plurality of first geographic regions from a first database in the one or more databases, wherein the geographic data comprises a list of cities and a list of states; for each first geographic region, generating a list of each combination of cities and states listed in the geographic data; ranking each combination of cities and states based on a likelihood that the respective city and state combination is located within the respective first geographic region; generating an average of geographic coordinates of each combination of cities and states that are ranked above a threshold value; and determining a first location representing a center of the respective first geographic region based on the average of the geographic coordinates; retrieving population data associated with a plurality of second geographic regions from a second database in the one or more databases; for each first geographic region, identifying one or more of the second geographic regions within a first distance of the center of the respective first geographic region based on the population data, and modifying the respective first geographic region to be a shape of the identified one or more of the second geographic regions and located at a set of geographic locations defined by the identified one or more of the second geographic regions; generating user interface data for rendering the interactive user interface on a computing device, the interactive user interface including a map representing a large geographic region, wherein the map displays graphical representations of the plurality of modified first geographic regions at locations corresponding to the modified first geographic regions within the large geographic region; receiving, via user input controlling at least a cursor, a selection of a first graphical representation of one modified first geographic region in the plurality of first geographic regions; modifying the user interface data such that the interactive user interface displays an expanded view of the map, wherein the expanded view of the map includes a zoomed-in view of the one modified first geographic region and hides a view of other modified first geographic regions in the plurality of modified first geographic regions that otherwise could have been depicted in the expanded view of the map at the same time, and wherein the zoomed-in view of the one modified first geographic region includes a terrain of the one modified first geographic region and an identification of a location of one or more entities located within the one modified first geographic region; receiving, via user input controlling at least the cursor, a selection of a first entity in the one or more entities located within the one modified first geographic region; modifying the modified user interface data such that the interactive user interface displays shipment misalignment data associated with the first entity selected within the one modified first geographic region; and modifying, in response to the selection of the first entity within the one modified first geographic region, the modified user interface data such that the interactive user interface includes, in a window, a selectable option to ship additional items to the one modified first geographic region in response to a determination that an amount of an item shipped to the one modified first geographic region does not exceed a threshold value. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer-implemented method for routing an item to a geographic location comprising:
-
retrieving geographic data associated with a plurality of first geographic regions, wherein the geographic data comprises a list of cities and a list of states; for each first geographic region, generating a list of each combination of cities and states listed in the geographic data; ranking each combination of cities and states based on a likelihood that the respective city and state combination is located within the respective first geographic region; generating an average of geographic coordinates of each combination of cities and states that are ranked above a threshold value; and determining a first location representing a center of the first geographic region based on the average of the geographic coordinates; retrieving population data associated with a plurality of second geographic regions; for each first geographic region, identifying one or more of the second geographic regions within a first distance of the center of the respective first geographic region based on the population data, and modifying the respective first geographic region to be a shape of the identified one or more of the second geographic regions and located at a set of geographic locations defined by the identified one or more of the second geographic regions; generating user interface data for rendering an interactive user interface on a computing device, the interactive user interface including a map representing a large geographic region, wherein the map displays graphical representations of the plurality of modified first geographic regions at locations corresponding to the modified first geographic regions within the large geographic region; receiving, via user input controlling at least a cursor, a selection of a first graphical representation of one modified first geographic region in the plurality of first geographic regions; modifying the user interface data such that the interactive user interface displays an expanded view of the map, wherein the expanded view of the map includes a zoomed-in view of the one modified first geographic region and hides a view of other modified first geographic regions in the plurality of modified first geographic regions that otherwise could have been depicted in the expanded view of the map at the same time, and wherein the zoomed-in view of the one modified first geographic region includes a terrain of the one modified first geographic region and an identification of a location of one or more entities located within the one modified first geographic region; receiving, via user input controlling at least the cursor, a selection of a first entity in the one or more entities located within the one modified first geographic region; retrieving shipment data associated with the first entity, wherein the shipment data comprises an amount of the item shipped to the first entity; modifying, in response to the selection of the first entity within the one modified first geographic region, the modified user interface data such that the interactive user interface includes, in a window, a selectable option to ship additional items to the first entity; and generating an instruction to ship the additional items to the first entity selected within the one modified first geographic region in response to a determination that the amount of the item shipped to the first entity does not exceed a threshold value. - View Dependent Claims (10, 11)
-
Specification