Syndicate
Website progress
I'm not new to programming, but I'm not a professional. Every website I build is always a work in progress as a learn new things and develop new and better techniques. This website in particular, along with the 46th District site, is where I've been learning and experimenting with database connections. I just put up a few pages as part of this 'work in progress' that are in a condition that I can share with you.
List of Precincts (this one is a large page, download may take a while)
That last one is where I'm the most excited. It's a list of the 6,698 precincts in Washington State as of January of this year, and I'm working to make it filterable by county, LD and Congressional District.
For example, if you want to filter the Precinct list to just Adams County, you can add "?county=AD" to the URL.
You can view the rest of the codes on the County list, where each one links to a list of precincts in that county.
I'm still collecting the LD and CD information for each precinct. I uploaded the database table before I finished collecting that, and I'll get them filled in as quick as I can.
One other thing I wanted to show is the Election history for Snohomish County, which Fred was able to load into his database. Click on the "history" link on that page, and you'll see what we have available.
The goal, eventually, is to be able to create links between all of these lists, Google Maps down to the precinct level and election history down to the precinct level. We will be able to call the lists in XML format, and eventually KML as well, meaning that we can bring up maps in Google Earth. This will show, in a very graphical and useful way, how we are doing around the state and how much work we need to do on the ground to reach out to new voters, convince current registered voters and build our organizational infrastructure to help Democrats win office so they can push our legislative priorities.
That's what this is all about.
- chadlupkes's blog
- Login to post comments
Comments
Update: County Filter
Ok, if you go to the Precinct page, you'll see a dropdown form at the top of the page. Selecting one of the counties will filter the precinct list by that county. These products are also available in dynamic XML.
However, the entire XML list of 6,698 precincts takes a VERY long time to load, and I don't quite know what that's doing to the server so I'm only making it available to people who ask for it. I don't know that many people will need it, but if you do, I'll provide it as a static file. You might want to wait until I can get the LD and CD numbers filled in.