Deprecated: Function get_magic_quotes_gpc() is deprecated in /home/customer/www/ on line 37

Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/customer/www/ on line 566
DemocracyMap -

E-Democracy Pages Wiki

Search Wiki






Revision as of 18:55, 23 June 2010 by Philipashlock (Talk | contribs)


Plan and build a universal, free, open, shared and continuously updated database of government jurisdictions/entities, their websites, and over time add elected official contact information.

In the United States there are approximately 30,000 government jurisdictions. There is no official database of the websites tied to each jurisdiction be it a city, school district, or some relatively obscure special district. Business.Gov, an effort of the Small Business Administration, recently released an API with 8,000 or so city and county websites raising interest across many organizations in how to to cover ALL government organizations.

Once collecting and maintaining a directory of all government jurisdiction web addresses and a way to find your jurisdiction by entering a street address or by using a map is addressed, then deepening data collection to elected officials and all government owned or funded websites will be explored.

This initiative is being lead by a non-profit, non-partisan consortium combining the efforts of, and the Sunlight Foundation. A consortium approach is envisioned to involve governments, inter-governmental associations, non-profits, media, online search, and other businesses interested in a sustainable model for gathering and maintaining data for the widest distributed use in the public interest.

This joint effort was launched based on discussions on the CityCamp Exchange and a session at Transparency Camp 2010 (turn audio way up).

Case Studies

  • tells you who represents you at all levels of Government in Australia.
  • Openly Local Openly Local is a new project to develop an open and unified way of accessing Local Government information. See also OpenlyLocal Ward Maps
  • Freedomspeaks provides representative lookup and an API
  • RepSheet - Representative site for Chicago area. It's open source, based on Django.
  • - this was just started and recently posted on the sunlight labs mailing list
  • Civic Footprint - this is a largely defunct project, with data currently for the Chicago area. Because it's a closed database with no user contributions, and it no longer has funding to be improved, this will never get any better.
  • NY Times Represent - a recent project that covers New York City. This also has voting records and articles that include the representative.
  • - includes biographical information and some location information (seems a little rougher on location than some databases). National. Also includes information about candidates, and a voting record. Has some local officials but not local candidates.
  • American Solutions is making some sort of wiki, though it may only allow user editing of contact details.
  • LittleSis is an involuntary facebook of powerful Americans, collaboratively edited by people like you.
  • offers a unique look at the world of Washington through its key players and personalities. Our site features profiles of prominent government officials, including members of the Obama administration, U.S. lawmakers and governors, senior congressional aides and committee staff, lobbyists and experts at think tanks and interest groups who comprise the world of unofficial Washington.
  • Smart Voter Local election coverage for candidates and ballot items.
  • Vote 411 Focused on state level elections.
  • OpenlyLocal Ward Maps

Open Source Precedents


Data Standards



System Architecture

Base Data:

Listing sources of data.

  • 2007 Governments Integrated Directory (GID) -
  • Local government entities described:
  • County Governments
  • Municipalities
  • Townships
  • Special District Govts
  • Independent School District Govts
  • Local Dependent School Systems
  • Education Service Agencies
  • State Dependent School Systems

(this appears to be the source data - 2002 & 2007 Data)

Mapping Location to Entities

Municipalities & Townships:

  • Incorporated Places/Census Designated Places

Cartographic Boundary Files

Key Data About Places

Connecting Government Jurisdictions/Entities to Websites

Core Fields

What are the core fields of data to compile/crowd-source?

  • Government Type
  • Government Name
  • Street Address
  • City
  • County
  • State
  • Zip
  • General Telephone
  • 311 - Y/N
  • TTD Telephone
  • General E-mail (Web Contact)
  • FIPS Code (is it useful to keep FIPS places that don't have gov't? e.g. towns or unincorporated areas within a county if users want to search by those. allows this)
  • Zipcodes Served (maybe use ext. source for this? commercial or geonames)
  • Long/Lat of main HQ building
  • Geo/Boundaries
  • Primary Website URL
  • If none, Primary Webpage URL (for really small government, often unreliable)
    • Active/Broken
    • Home Page Last Updated Date
    • Web Feeds Available from Home Page

Additional Fields
  • Multi-lingual Main Page(s) - Language, Link
  • Accessibility Validation (508)
  • Calendar/Events/Meeting Page URL - iCal Feeds
  • Information Elements - Checklists ...
  • Organization Twitter Handle: @something
  • Organization Facebook Fan Page URL:
  • Organization YouTube Account URL:
  • Wikipedia Page About Organization:
  • Wikipedia Page About Placename:
  • Newspaper of Record (where government notices are printed) Name:
  • Newspaper of Record URL:
  • Registered Government Jurisdiction Record "Owner" for direct updating of added fields - ability to request additions from the city clerk for example who has opted-in to feed in site data
  • Verified/Unverified links - If you crowd source links to a Facebook Fan page for example, you would need to labeled unverified until is some how is verified.
  • Giving unrestricted data access to gathered e-mail addresses might render general government inboxes unusable. Possible solution - a partnership hosted U.S. version of model with a unique URL generated in a web contact field. Through you can only contact those (elected officials in their case) governments that serve you. Those wanting to contact governments that do not represent them would need to use current contact methods.
Proposed Officials Fields

Preliminary fields related to elective bodies - information that will assist future incorporation of elected official information:

  • Elected or Appointed Governing Body:
  • Name of Elected Body:
  • At-Large: Y/N
  • Term of Service:
  • Partisan: Y/N
  • Staggered Terms:
  • Judges (Retention Style?):

This section needs work!

  • Public Positions
  • Mayor
  • City Council Member
  • County Board Member
  • Township Board Member
  • Special District Board Member
  • School Board Member
  • Treasurer
  • Tax Collector
  • Auditor-Controller
  • Sheriff
  • Constable
  • District Attorney

Proposed Staff/Quasi-Govt. Head Fields :

  • City Secretary
  • City Manager
  • City Public Information Officer
  • City Planning/Development Director
  • City Parks and Recreation Director
  • Police Chief
  • Police Public Information Officer
  • School District Superintendent
  • School District Public Information Officer
  • Chamber President
  • Economic Development Director
  • Council of Neighborhood Association Chair
  • Council of PTA/PTO President
  • County Board Member Chief of Staff
  • County Public Information Officer

Agency Heads

  • Can hCard or other microformat be used or modified to allow political entity websites to post easily parseable information relating to who represents what?
  • What existing spiders can be used to gather data thus posted? (e.g. Yahoo Local supports hCard )


  • There are dozens of "silo" directories of government websites of a certain kind. All of them suffer from the challenge of keeping up-to-date. There are also 50 state government portals, most of whom host manually maintained listing of local government websites.
  • "Submit-it" crowd-sourcing would require an encouragement link from the state and major "silo" government link directories. If they do not use the data, they will not likely link to encourage governments to submit new websites via the service.
  • Technology assisted volunteer crowd-sourcing is another option where we leverage search engines to identify possible websites for government jurisdictions without known (or no longer functioning links) websites/pages and streamline the verification process.

Potential Partners and Collaborators

In the loop so far:

Might be interested:

Case Studies


Home - Mobile - Forums - Wiki - Blog - About - Help - Contact - People - Donate - Rules - Archives