My main goal is to collect information of US Golf courses located in the United States and geocode them to create a meaningful map.
I was able to scrape from four sites in which I created 4 CSV files based on each site. Each giving me a variation on name, address convention and some even giving me miscellaneous information like Phone Number,Website, and Golf Course Type (E.G Private or Public).
With that I want to create a file that contains all the information combined into one file displaying name of the golf course, the address,Phone number, Webiste and type from the 4 CSV files.
How do I go about of merging, combining and cleansing data into one CSV file so that I can geocode and display proper information.
If someone can provide the steps in any program from FME, SQL, or even ARCGIS or Excel will be greatly appreciated.
أكثر...
I was able to scrape from four sites in which I created 4 CSV files based on each site. Each giving me a variation on name, address convention and some even giving me miscellaneous information like Phone Number,Website, and Golf Course Type (E.G Private or Public).
With that I want to create a file that contains all the information combined into one file displaying name of the golf course, the address,Phone number, Webiste and type from the 4 CSV files.
How do I go about of merging, combining and cleansing data into one CSV file so that I can geocode and display proper information.
If someone can provide the steps in any program from FME, SQL, or even ARCGIS or Excel will be greatly appreciated.
أكثر...