Processing multiple data sets to generate a merged location-based data set

A computer system for merging location-based data sets, the computer system comprising:

• one or more computer processors;
• one or more computer readable storage media;
• program instructions stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising instructions to:
• transform each of a plurality of data sets into a standardized schema, wherein the standardized schema includes rows and columns and the plurality of data sets include at least two data sets including information indicating a geographic location;
• combine the schemas of the plurality of data sets by data set type and grouping the rows within the combined schemas based on a combination of columns to produce a resulting data set in the standardized schema for each data set type;
• join the schemas of first and second data sets of the plurality of data sets to produce a merged data set in the standardized schema based on a machine learning model to identify rows of the schema of the second data set corresponding to rows of the schema of the first data set, wherein the merged data set in the standardized schema indicates the rows of the schema of the first data set corresponding to rows of the schema of the second data set;
• join the schema of the merged data set with the schemas of the resulting data sets for the data set types to produce a new data set in the standardized schema based on geographical distances between location-based data, wherein the new data set in the standardized schema indicates rows of the schema of the merged data set corresponding to rows of the schemas of the resulting data sets;
• and
• produce a resulting merged data set in the standardized schema by combining the corresponding rows indicated in the schemas of the merged and new data sets with the schema of the new data set.

A computer program product for merging location-based data sets, the computer program product comprising one or more computer readable storage media collectively having program instructions embodied therewith, the program instructions executable by a computer to cause the computer to:

• transform each of a plurality of data sets into a standardized schema, wherein the standardized schema includes rows and columns and the plurality of data sets include at least two data sets including information indicating a geographic location;
• combine the schemas of the plurality of data sets by data set type and grouping the rows within the combined schemas based on a combination of columns to produce a resulting data set in the standardized schema for each data set type;
• join the schemas of first and second data sets of the plurality of data sets to produce a merged data set in the standardized schema based on a machine learning model to identify rows of the schema of the second data set corresponding to rows of the schema of the first data set, wherein the merged data set in the standardized schema indicates the rows of the schema of the first data set corresponding to rows of the schema of the second data set;
• join the schema of the merged data set with the schemas of the resulting data sets for the data set types to produce a new data set in the standardized schema based on geographical distances between location-based data, wherein the new data set in the standardized schema indicates rows of the schema of the merged data set corresponding to rows of the schemas of the resulting data sets;
• and
• produce a resulting merged data set in the standardized schema by combining the corresponding rows indicated in the schemas of the merged and new data sets with the schema of the new data set.