1 / 12

The Use of XML in Election Results Reporting , A historical review of Virginia’s use of XML in 2008

The Use of XML in Election Results Reporting , A historical review of Virginia’s use of XML in 2008 Paul E. Stenbjorn, M.S. Information Services Manager, Virginia State Board of Elections. You want what when??. Background

Sophia
Download Presentation

The Use of XML in Election Results Reporting , A historical review of Virginia’s use of XML in 2008

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Use of XML in Election Results Reporting, A historical review of Virginia’s use of XML in 2008 Paul E. Stenbjorn, M.S. Information Services Manager, Virginia State Board of Elections

  2. You want what when?? Background • Each Election Day candidates, voters, public interest groups, and the media anxiously await publication of official results from the various election administration entities.  • Many states and municipalities have developed online reporting systems to which election results are posted online.  • Media outlets race to collect results by calling local and state officials, scouring the internet for results, and through any means available to be first in line with the freshest results.

  3. Findings • Inconsistency of Data Presentation • Media outlets and other reporting entities have yet to develop a standard presentation logic for formatting and delivering election results.  • Taxonomy • With few examples to draw from, the Virginia State Board of Elections developed its own terminology to refer to election results data objects.

  4. Methodology • The Election Results Markup Language Schema • The Virginia State Board of Elections developed a series of schemas based on the political subdivision grouping of data • 2009 examples • Statewide • Locality level • Precinct level

  5. Sample Schema – Statewide Example <?xml version="1.0" encoding="UTF-8" ?> - <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> - <xs:element name="CANDIDATE"> - <xs:complexType> <xs:attribute name="MIDDLE_NAME" type="xs:NMTOKEN" use="required" /> <xs:attribute name="PARTY" type="xs:NMTOKEN" use="required" /> <xs:attribute name="FIRST_NAME" type="xs:NMTOKEN" use="required" /> <xs:attribute name="LAST_NAME" type="xs:NMTOKEN" use="required" /> <xs:attribute name="TOTAL_VOTES" type="xs:NMTOKEN" use="required" fixed="0" /> <xs:attribute name="BALLOT_ORDER" type="xs:NMTOKEN" use="required" /> <xs:attribute name="BALLOT_NAME" type="xs:string" use="required" /> </xs:complexType> </xs:element> - <xs:element name="ELECTION"> - <xs:complexType> - <xs:sequence> <xs:element ref="OFFICE" maxOccurs="unbounded" /> </xs:sequence> <xs:attribute name="ELECTION_UID" type="xs:NMTOKEN" use="required" /> <xs:attribute name="ELECTION_DATE" type="xs:NMTOKEN" use="required" /> <xs:attribute name="CODE_NAME" type="xs:string" use="required" /> </xs:complexType> </xs:element> - <xs:element name="OFFICE"> - <xs:complexType> - <xs:sequence> <xs:element ref="CANDIDATE" maxOccurs="unbounded" /> </xs:sequence> <xs:attribute name="BALLOT_ORDER" type="xs:NMTOKEN" use="required" /> <xs:attribute name="TITLE" type="xs:string" use="required" /> </xs:complexType> </xs:element> </xs:schema>

  6. Deficiencies of current Schema • The creation of district based election results adds complexity to the data model and will require the development of a district schema and a relationship model of districts to election results. • Taxonomical inconsistencies across consumers of XML feeds

  7. Data Driven XML File Development The Virginia State Board of Elections technology staff leveraged the state-wide voter registration SQL 2005 database to generate the XML files used in the presentation of data. Method Create denormalized data tables, and use XML AUTO feature of T-SQL to generate XML dataset Create files using scripting objects in T-SQL

  8. XSL Presentation Logic • Largely due to the lack of data standards, the Virginia State Board of Elections created XSL sheets to aid in the presentation of XML by reporting entities • These XSL sheets were inherently self limiting as they were designed to present data by specific jurisdictional boundaries.

  9. 2009 XSL Presentation Example

  10. 2009 Widget Application

  11. Conclusions • Current process is ad hoc • The consumers of the data appreciated and used the results for online presentation. • 2009 Elections have seen a substantial rise in the requests for online data delivery methods • Data standards are needed • The scarcity of state funded technology resources familiar with the development and implementation of XML schemas presents a challenge for the maintenance of these efforts.

  12. Questions? Contact Information Paul E. Stenbjorn, M.S. Paul.stenbjorn@sbe.virginia.gov 804 864-8905

More Related