Pull Data from Various Sources and Build a List to be used to visualize in Google Maps
Budget: $30 – $250 USD
We need to build a custom google map to visualize our vendors in each of the following states, Florida, Georgia, Alabama, South Carolina, North Carolina, Tennessee, Virginia & Mississippi by state and vendor type.
We have identified the source for all of this data, but it needs to be extracted from the various source formats and reformatted on a google sheet. The sources for the data vary from .csv, .pdf, html tables and maps. Some of the data is incomplete and so we will need to do a google search to obtain the rest of the information. For example, our source may list the producer name and city, ACME Concrete Montgomery AL, but doesn't list a street address, contact name, contact email or phone number. You will need to search for this information to the best of your ability and include it on our list if possible. We will also need a google maps link for the location & a copy and past of the lat / long coordinates from the google pin. (This is easy, I can show you how if needed)
The sheet has been started and is linked below. The first tab lists the data sources for each of the following tabs. The second tab shows the format we will need with an example.
This is a very easy project, but may take some time. Let me know if you have any questions.
https://docs.google.com/spreadsheets/d/18ND2vVpOBI12WRPfZIv2Jl3WUJdJbNOtsrW5VvTDjbM/edit?usp=sharing
We have identified the source for all of this data, but it needs to be extracted from the various source formats and reformatted on a google sheet. The sources for the data vary from .csv, .pdf, html tables and maps. Some of the data is incomplete and so we will need to do a google search to obtain the rest of the information. For example, our source may list the producer name and city, ACME Concrete Montgomery AL, but doesn't list a street address, contact name, contact email or phone number. You will need to search for this information to the best of your ability and include it on our list if possible. We will also need a google maps link for the location & a copy and past of the lat / long coordinates from the google pin. (This is easy, I can show you how if needed)
The sheet has been started and is linked below. The first tab lists the data sources for each of the following tabs. The second tab shows the format we will need with an example.
This is a very easy project, but may take some time. Let me know if you have any questions.
https://docs.google.com/spreadsheets/d/18ND2vVpOBI12WRPfZIv2Jl3WUJdJbNOtsrW5VvTDjbM/edit?usp=sharing