Use OCD identifiers for districts and legislatures

[alexmingoia]

We should use OCD identifiers for districts and legislatures. Right now they're identified by their name, but that name might not match what is in our database.

[alexmingoia]

This will be a lot of work because at the city/county level many OCD IDs will need to be applied for.

[dallasjc]

Is this something I can help with? There are a few ways geographically defined legislatures could be useful for people I'm working with.

Does OCD = Open Civic Data?

How would I apply for the IDs? Is it something other than the this format?

ocd-division/country:us/state:nc/county:wake
http://docs.opencivicdata.org/en/latest/proposals/0002.html

[alexmingoia]

OCD ID stands for Open Civic Data Identifier, a standard for globally unique IDs for open civic data. One of the many useful things to come from the Sunlight Foundation.

We'd need to:

• Add ocd_id fields to api.legislatures and api.legislature_offices, add unique constraint, and update all dependent views.
• Update private.upsert_user_legislatures to insert api.user_legislatures with legislatures that have offices with boundaries that the user lives within.
• Update src/tasks/import_legislatures.js task to use OCD IDs.
• Migrate all the existing legslatures and offices.
• Apply for any new OCD IDs we need to generate.
• Update any other code that requires one-to-one association between a legislature and city/state/county.