Spatial Street Address Data Integration for Emergency Response

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Geographic data sets, such as those used for emergency services, often require multiple databases and tabular information, leading to inaccuracies and delays in response times due to the need to align and combine data from different sources.

Innovation Solution

A method and system that integrates street address data, postal data, community translation data, and a spatial layer base map to create a unified spatial street address data set through a series of translations and geocoding processes, ensuring accurate and efficient data alignment with known loci.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If multiple separate databases are used to store geographic data, then data can be organized by specific functions (emergency services, postal services, etc.), but response time increases and inaccuracies occur due to the need to consult multiple data sets

Engineering Contradiction:
Improvedata accuracyVSAvoidresponse time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The patent merges multiple separate geographic databases (emergency services data, postal services data, street address data) into a single integrated spatial database. This consolidation eliminates the need to consult multiple data sets, thereby reducing response time and eliminating inaccuracies that occur when aligning data from different sources. The integrated database maintains all necessary information in one unified structure.

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The integrated spatial database is designed to serve multiple functions simultaneously - it supports emergency services, postal services, and general geographic information needs. By creating a universal database that handles various types of geographic queries and applications, the system eliminates the need for separate specialized databases, thereby reducing response time while maintaining data accuracy for all functions.

Inventive Principle:
Principle #6Universality (Multi-functionality)

2Ease of manufacture

If tabular two-dimensional data structures are used, then data can be stored in conventional formats, but inaccuracies and delays occur when aligning and combining data from different data sets

Engineering Contradiction:
Improvedata storage simplicityVSAvoiddata alignment accuracy
Core Design Contradiction:
Ease of manufactureVSReliability

Solution Approach 1:

The patent transitions from conventional two-dimensional tabular data structures to a three-dimensional spatial database structure. This dimensional change enables the system to store and query geographic data in spatial coordinates (x, y, z) rather than in flat tables, allowing for accurate alignment and integration of data from different sources through spatial relationships. The spatial dimension enables precise location-based queries and eliminates alignment inaccuracies inherent in tabular formats.

Inventive Principle:
Principle #17Another dimension (Dimensionality change)

3Loss of information

If multiple data sets are consulted to obtain complete information, then comprehensive data can be obtained, but response time increases and inaccuracies are introduced

Engineering Contradiction:
Improveinformation completenessVSAvoidquery response time
Core Design Contradiction:
Loss of informationVSLoss of time

Solution Approach 1:

The patent combines multiple data sets containing different types of geographic information (emergency services data, postal data, street address data, spatial layer data) into a single integrated database. This merger ensures that all necessary information is available within one database, eliminating the need to consult multiple separate data sets. The complete information is retained while query response time is significantly reduced as the system can retrieve all needed data from a single source.

Inventive Principle:
Principle #5Merging (Combining)

Data Source

PatentUS7987218B2Method and system for establishing a spatial street address data set
Publication Date: 2011.07.26 WEST INTERACTIVE SERVICES CORP
  • US7987218B2 patent drawing
  • US7987218B2 patent drawing
  • US7987218B2 patent drawing

AI summary

A method for establishing a spatial street address data set including: First, in no particular order: (1) providing street address data; (2) providing postal data; (3) providing community translation data; and (4) providing a spatial layer base map. Second, establishing a first data base containing once-translated address entries, each relating to a selected community entry from the street address data or a selected community entry from the community translation data. Third, establishing a second data base containing twice-translated address entries, each relating to a selected street name entry from the postal data or a selected street name entry from the street address data. Fourth, treating the second data base with a geocoder routine to create geocoded address entries in a geocoded data set. Fifth, situating the geocoded data set in a spatial layer. Sixth, orienting the spatial layer with known loci in the spatial layer base map.