visualizing data so far we have been learning the python language and then learning how to use pythonthe networkand databases to manipulate data in this we take look at three complete applications that bring all of these things together to manage and visualize data you might use these applications as sample code to help get you started in solving real-world problem each of the applications is zip file that you can download and extract onto your computer and execute building openstreetmap from geocoded data in this projectwe are using the openstreetmap geocoding api to clean up some user-entered geographic locations of university names and then placing the data on an actual openstreetmap to get starteddownload the application fromwww py com/code /opengeo zip the first problem to solve is that these geocoding apis are rate-limited to certain number of requests per day if you have lot of datayou might need to stop and restart the lookup process several times so we break the problem into two phases in the first phase we take our input "surveydata in the file where data and read it one line at timeand retrieve the geocoded information from google and store it in database geodata sqlite before we use the geocoding api for each user-entered locationwe simply check to see if we already have the data for that particular line of input the database is functioning as local "cacheof our geocoding data to make sure we never ask google for the same data twice you can restart the process at any time by removing the file geodata sqlite run the geoload py program this program will read the input lines in where data and for each line check to see if it is already in the database if we don' have the