Geospatial queries using associated distribution data
First Claim
1. A method for optimizing spatial queries, the method comprising:
- a computer receiving a first spatial data set and a target spatial shape, wherein a geometry of the first spatial data set does not align with a geometry of the target spatial shape;
the computer receiving a distribution data set, wherein a geometry of the distribution data set aligns with the geometry of the first spatial data set;
the computer performing one or more geospatial queries to determine a list of full and partial shapes of the first spatial data set which are located within the target spatial shape;
the computer determining a ratio for a determined partial shape of the first spatial data set using the distribution data set;
the computer determining an apportioned value of a variable of the first spatial data set within the determined partial shape, wherein the apportioned value of the variable is based on a full value of the variable and the determined ratio; and
the computer outputting a result set comprising the apportioned value of the variable.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments of the present invention disclose a method, computer program product, and system for optimizing spatial queries, the method comprising a computer receiving a spatial data set, and a target spatial shape. The computer determining a distribution data set which aligns with the geometry of the spatial data set. The computer performing a query to determine a list of full and partial shapes of the spatial data set located within the target spatial shape. The computer determining a ratio for a determined partial shape of the spatial data set using the distribution data set. The computer determining an apportioned value of a variable of the spatial data set within the determined partial shape. The computer summarizing into a result set the value of the variable within the determined list of full and partial shapes of the spatial data set.
13 Citations
20 Claims
-
1. A method for optimizing spatial queries, the method comprising:
-
a computer receiving a first spatial data set and a target spatial shape, wherein a geometry of the first spatial data set does not align with a geometry of the target spatial shape; the computer receiving a distribution data set, wherein a geometry of the distribution data set aligns with the geometry of the first spatial data set; the computer performing one or more geospatial queries to determine a list of full and partial shapes of the first spatial data set which are located within the target spatial shape; the computer determining a ratio for a determined partial shape of the first spatial data set using the distribution data set; the computer determining an apportioned value of a variable of the first spatial data set within the determined partial shape, wherein the apportioned value of the variable is based on a full value of the variable and the determined ratio; and the computer outputting a result set comprising the apportioned value of the variable. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer program product for optimizing spatial queries, the computer program product comprising:
one or more computer-readable storage media and program instructions stored on the one or more computer-readable storage media, the program instructions comprising; program instructions to receive a first spatial data set and a target spatial shape, wherein a geometry of the first spatial data set does not align with a geometry of the target spatial shape; program instructions to receive a distribution data set, wherein a geometry of the distribution data set aligns with the geometry of the first spatial data set; program instructions to perform one or more geospatial queries to determine a list of full and partial shapes of the first spatial data set which are located within the target spatial shape; program instructions to determine a ratio for a determined partial shape of the first spatial data set using the distribution data set; program instructions to determine an apportioned value of a variable of the first spatial data set within the determined partial shape, wherein the apportioned value of the variable is based on a full value of the variable and the determined ratio; and program instructions to output a result set comprising the apportioned value of the variable. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
15. A computer system for optimizing spatial queries, the computer system comprising:
-
one or more computer processors; one or more computer-readable storage media; program instructions stored on the computer-readable storage media for execution by at least one of the one or more processors, the program instructions comprising; program instructions to receive a first spatial data set and a target spatial shape, wherein a geometry of the first spatial data set does not align with a geometry of the target spatial shape; program instructions to receive a distribution data set, wherein a geometry of the distribution data set aligns with the geometry of the first spatial data set; program instructions to perform one or more geospatial queries to determine a list of full and partial shapes of the first spatial data set which are located within the target spatial shape; program instructions to determine a ratio for a determined partial shape of the first spatial data set using the distribution data set; program instructions to determine an apportioned value of a variable of the first spatial data set within the determined partial shape, wherein the apportioned value of the variable is based on a full value of the variable and the determined ratio; and program instructions to output a result set comprising the apportioned value of the variable. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification