First Day

Started to work on the va_votes project. Specifically working on Elizabet Guzman in Prince Williams County. The first thing was looking into qgis and psql. I have set up a qgis of all of the precincts in Virginia. I am now working on getting all of the data from past elections. There is a bug in the scraping program that prevents me from viewing the most recent presidential elections. Once I have this data I will create a database to store the data in.

Comments

  1. jelknerJuly 11, 2017 at 5:47 AM

    Take a look again at the blog to which I referred you as a model:

    https://proyectojuanchacon.blogspot.com

    The more specific you can be in describing what you do, to the level of including reproducible steps, the more useful your contribution to the project will be.

    ReplyDelete

Post a Comment

Popular posts from this blog

Fifth Day

        Today I plan on further improving my script by adding the ability to work on multiple files in a folder. I also want to be able to format the information I have into "INSERT" queries for SQL. Another thing I could work on is just creating the tables for my Database.         I figured out how to run my program in the Terminal. python3 Test-CSV.py This is the command I used to run it. The next thing I will work on is getting it in the right format to make the "INSERT" statements.          After lunch I decided to just make all of the tables that I would need for the database. I made the tables very quickly and easily. I am now working on making the script output "INSERT" statements. I almost have the precinct table part done.         I had to rework the whole table, but I was able to finally make the insert statements work. I had to remove all spaces and commas as to not interfere with SQL syntax. Then to make sure it was correct I used a Q
Read more

Second Day

         First thing I did was update my version of the scraper and try it again. Near the end of the process the program froze. I added a new issue to the github page. The next thing I did was delete and reinstall the entire script to ensure it was the correct branch. I then ran it again and waited. The program finished, but the first page bug is still not fixed.         While waiting for a solution I decided to focus on the data I did have for Prince Williams County. I was able to create a database with two tables, one for the 2015 House of Delegates Election and the other for the 2011 House of Delegates Election. Both of these tables only have the data for District 31, which is the District Elizabeth Guzman is working towards. I added the 2007 Election to get a better idea of the voting trends.         If I was trying to see the breakdown of the 2007 House of Delegates Election for only Prince William County I would type: SELECT * FROM District_31_2007 WHERE District_31_2007.coun
Read more