Systems and methods for a geospatial location data architecture
A method for generating location data including receiving and outputting first location data. The method further includes receiving a response and validating the first piece of location data based on the response. The method further includes cleaning the first location data. The method further includes querying a first repository to select second location data and a third location data. The method further includes assigning the cleaned first location data a first rank, the second location data a second rank, and the third location data a third rank. The method further includes merging the cleaned first location data and the second piece of location data to generate first merged location data. The method further includes merging the first merged location data and the third location data to generate second merged location data. The method further includes storing the second merged location data in the first repository.
1 . A method for generating location data, the method comprising:
receiving, by a content management server, first location data;
outputting, by the content management server, the first location data;
receiving, by the content management server and in response to outputting the first location data, a response;
validating, by the content management server, the first location data based on the response;
cleaning, by the content management server and in response to validating the first location data, the first location data; wherein the first location data includes a first field including a 3-digit zip code, and wherein the method further comprises: determining, by the content management server, a 9-digit zip code based at least partially on the cleaned first location data; and modifying, by the content management server, the first field of the cleaned first location data to include the 9-digit zip code
querying, by the content management server, a first repository to select second location data and third location data;
assigning, by the content management server, the cleaned first location data a first rank, the second location data a second rank, and the third location data a third rank;
merging, by the content management server and based on the first rank and the second rank, the cleaned first location data and the second location data to generate first merged location data;
merging, by the content management server and based on the third rank, the first merged location data and the third location data to generate second merged location data; and
storing, by the content management server, the second merged location data in the first repository.
2 . The method of claim 1 , wherein the first location data includes a first field and a second field, and wherein cleaning the first location data comprises:
removing, by the content management server, the second field of the first location data.
3 . The method of claim 1 , wherein the first location data includes an address field including a street type value, and wherein cleaning the first location data comprises:
modifying, by the content management server, the street type value to standardize the street address value.
4 . The method of claim 1 , wherein the first rank is a lowest rank, wherein the second rank is an intermediate rank, and wherein the third rank is a highest rank, further comprising:
determining, by the content management system, a first score based on the first location data;
determining, by the content management system, a second score based on the second location data; and
determining, by the content management system, a third score based on the third location data,
wherein the third location data is assigned the highest rank based on the third score being higher than the second score and the first score, wherein the second location data is assigned the intermediate rank based on the second score being higher than the first score, and wherein the first location data is assigned the lowest rank based on the first score being lower than the second score and the third score.
5 . The method of claim 4 , wherein the cleaned first piece of location data and the second piece of location data each include at least one common field, and wherein the first merged piece of location data includes the common field of the second piece of location data in response to the second piece of location data being ranked as the second rank.
6 . The method of claim 5 , wherein the third location data includes an address field including an address, wherein the third location data includes a health care provider (HCP) field including an HCP identifier, and wherein determining the third score comprises:
querying, by the content management server, a second repository for the HCP identifier to select HCP data including the HCP identifier and an address;
determining, by the content management server, the address of the third location data matches the address of the HCP data; and
determining, by the content management server, the third score based at least partially on determining the address of the third location data matches the address of the HCP data.
7 . A method for generating location data, the method comprising:
receiving, by a content management server, location data including an address field;
determining, by the content management server, the address field includes an address including a street address value, a locality value, and a country value;
validating, by the content management server, the first location data in response to determining the address of the address field includes the street address value, the locality value, and the country value;
cleaning, by the content management server and in response to validating the first location data, the first location data; wherein the address of the address field further includes a 3-digit zip code, and wherein the method further comprises: determining, by the content management server, a 9-digit zip code based at least partially on the cleaned first location data; and modifying, by the content management server, the address of the address field of the cleaned first location data to include the 9-digit zip code
querying, by the content management server, a first repository to select second location data and a third location data;
assigning, by the content management server, the cleaned first location data a first rank, the second location data a second rank, and the third location data a third rank;
merging, by the content management server and based on the first rank and the second rank, the cleaned first location data and the second location data to generate first merged location data;
merging, by the content management server and based on the third rank, the first merged location data and the third location data to generate second merged location data; and
storing, by the content management server, the second merged location data in the first repository.
8 . The method of claim 7 , wherein the first location data includes the address field and a second field, and wherein cleaning the first location data comprises:
removing, by the content management server, the second field of the first location data.
9 . The method of claim 7 , wherein the address of the address field further includes a street type value, and wherein cleaning the first location data comprises:
modifying, by the content management server, the street type value to standardize the street address value.
10 . The method of claim 7 , wherein the first rank is a lowest rank, wherein the second rank is an intermediate rank, and wherein the third rank is a highest rank, further comprising:
determining, by the content management system, a first score based on the first location data;
determining, by the content management system, a second score based on the second location data; and
determining, by the content management system, a third score based on the third location data,
wherein the third location data is assigned the highest rank based on the third score being higher than the second score and the first score, wherein the second location data is assigned the middle rank based on the second score being higher than the first score, and wherein the first location data is assigned the lowest rank based on the first score being lower than the second score and the third score.
11 . The method of claim 10 , wherein the cleaned first location data and the second location data each include at least one common field, and wherein the first merged location data includes the common field of the second location data in response to the second location data being ranked as the second rank.
12 . The method of claim 11 , wherein the third location data includes an address field including an address, wherein the third location data includes a health care provider (HCP) field including an HCP identifier, and wherein determining the third score comprises:
querying, by the content management server, a second repository for the HCP identifier to select HCP data including the HCP identifier and an address;
determining, by the content management server, the address of the third location data matches the address of the HCP data; and
determining, by the content management server, the third score based at least partially on determining the address of the third location data matches the address of the HCP data.
13 . A method for generating location data, the method comprising:
receiving, by a content management server, first location data;
outputting, by the content management server, the first location data;
receiving, by the content management server and in response to outputting the first location data, a response;
validating, by the content management server, the first location data based on the response;
cleaning, by the content management server and in response to validating the first location data, the first location data; wherein the first location data includes a first field including a 3-digit zip code, and wherein the method further comprises: determining, by the content management server, a 9-digit zip code based at least partially on the cleaned first location data; and modifying, by the content management server, the first field of the cleaned first location data to include the 9-digit zip code
querying, by the content management server, a first repository to select second location data and third location data;
assigning, by the content management server, the cleaned first location data a first rank, the second location data a second rank, and the third location data a third rank;
merging, by the content management server and based on the second rank and the third rank, the second location data and the third location data to generate first merged location data;
merging, by the content management server and based on the first rank, the first merged location data and the cleaned first location data to generate second merged location data; and
storing, by the content management server, the second merged location data in the first repository.
14 . The method of claim 13 , wherein the first location data includes a first field and a second field, and wherein cleaning the first location data comprises:
removing, by the content management server, the second field of the first location data.
15 . The method of claim 13 , wherein the first location data includes an address field including a street type value, and wherein cleaning the first location data comprises:
modifying, by the content management server, the street type value to standardize the street address value.
16 . The method of claim 13 , wherein the third rank is a lowest rank, wherein the second rank is an intermediate rank, and wherein the first rank is a highest rank, further comprising:
determining, by the content management system, a first score based on the cleaned first location data;
determining, by the content management system, a second score based on the second location data; and
determining, by the content management system, a third score based on the third location data,
wherein the cleaned first location data is assigned the highest rank based on the first score being higher than the second score and the third score, wherein the second location data is assigned the middle rank based on the second score being higher than the third score, and wherein the third location data is assigned the lowest rank based on the third score being lower than the second score and the first score.
17 . The method of claim 16 , wherein the cleaned first location data includes an address field including an address, wherein the cleaned first location data includes a health care provider (HCP) field including an HCP identifier, and wherein determining the first score comprises:
querying, by the content management server, a second repository for the HCP identifier to select HCP data including the HCP identifier and an address;
determining, by the content management server, the address of the third location data matches the address of the HCP data; and
determining, by the content management server, the first score based at least partially on determining the address of the cleaned first location data matches the address of the HCP data.