Geospatial Data Aggregation via Automated Query Construction

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current systems face challenges in synthesizing diverse data sources for geographic areas, making it difficult to obtain granular data for decision-making, and require complex processes to answer geospatial queries.

Innovation Solution

A computer-implemented method and system that allows users to select geographic areas and criteria, retrieving and aggregating geospatial data from a dataset based on overlap, providing intuitive query construction and visualization options like maps and reports.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If complex database queries and code writing are used to obtain geospatial data, then data retrieval accuracy is improved, but system complexity and user difficulty increase

Engineering Contradiction:
Improvedata retrieval accuracyVSAvoidquery construction complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The patent introduces an intermediary processing layer between the user and the geospatial database. This layer includes automated query construction modules that translate user-friendly interface selections into complex database queries, and result formatting modules that convert raw data into visually appealing reports. This intermediary layer maintains data retrieval accuracy while shielding users from query construction complexity.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system implements self-service through automated query generation and processing. When users select geographic areas and data criteria through the interface, the system automatically constructs the appropriate database queries, executes them, and formats the results without requiring user intervention in the complex query writing process. This self-service mechanism resolves the contradiction by maintaining precision while eliminating manual complexity.

Inventive Principle:
Principle #25Self-service

2Adaptability or versatility

If highly granular geospatial data is provided to assist decision-making, then data utility is improved, but data processing complexity and computational resources increase

Engineering Contradiction:
Improvedata utility for decision-makingVSAvoiddata processing complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent segments the geospatial data processing into multiple manageable components: data retrieval from the database, data aggregation by geographic area, data filtering by selected criteria, and result formatting. This segmentation allows highly granular data to be processed efficiently by breaking down the complex task into smaller, independent processing steps that can be executed sequentially with reduced computational overhead at each stage.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system retrieves and processes only the portion of geospatial data that is relevant to the user's specific query parameters (selected geographic area and data criteria). Rather than processing entire datasets, the system performs partial action by filtering and aggregating only the necessary granular data points, thereby maintaining high data utility while reducing overall processing complexity and resource consumption.

Inventive Principle:
Principle #16Partial or excessive action

3Loss of information

If multiple data sources are synthesized to provide comprehensive geospatial information, then information completeness is improved, but data synthesis difficulty increases

Engineering Contradiction:
Improveinformation completenessVSAvoiddata synthesis difficulty
Core Design Contradiction:
Loss of informationVSEase of operation

Solution Approach 1:

The patent merges multiple geospatial data sources within a unified database structure that standardizes different data formats and schemas. The system combines demographic data, economic data, and other geospatial information into a single integrated query interface. This merging approach maintains information completeness from multiple sources while eliminating the difficulty of manual data synthesis by providing unified access through standardized queries.

Inventive Principle:
Principle #5Merging (Combining)

Data Source

PatentUS11544298B2System and method of geographic data aggregation and analysis
Publication Date: 2023.01.03 BLASTPOINT INC
  • US11544298B2 patent drawing
  • US11544298B2 patent drawing
  • US11544298B2 patent drawing

AI summary

Various systems and methods of aggregating and analyzing geographically indexed data are disclosed. The system can include a server database hosting an application that a client computer may access via a web browser according to a SaaS architecture. The server database can store a variety of geographically indexed data, which may include economic data, demographic data, social data, and various other data types. The server database can be programmed to cause the client to display a map for receiving a selected geographic area defined on the map and then retrieve selected data corresponding to user-selected criteria for the selected geographic area. The server database can then transmit the selected data to the client for display on the map.