Hello CodeFellows, Here is code that I wrote for a client’s geocoding project
- The Us Post Office creates a dataset, called AIS, that has every address listed by the post office and carrier route. This information comes in zipped text files. There are no spaces in the files to store the most data. Before using this information, the CD has to be uploaded to the server, the files unzipped and then unpacked. My client’s instructions were “Make it so easy that a monkey could do it”
Holly Glaser
- Process
• How to install software and upload a CD of AIS data o 1_AIS_Automating Data Upload to Server Using WinSCP o AIS_Upload_Data.bat • Once data is loaded on server, unzip, unpack and write to output file o After_ais_data_loaded_unpack o Build a table for AIS data o Lookup address abbreviations