Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Set up a DynamoDB instance #5

Open
gordonje opened this issue Sep 28, 2016 · 3 comments
Open

Set up a DynamoDB instance #5

gordonje opened this issue Sep 28, 2016 · 3 comments
Assignees

Comments

@gordonje
Copy link
Owner

For storing election night, as well as historic data.

@gordonje gordonje changed the title Set up an DynamoDB instance Set up a DynamoDB instance Oct 3, 2016
@NathanLawrence
Copy link
Collaborator

Set up table "StateGeo" on Access Missouri's AWS.

Fields:

  • year (mandatory, Partition Key) - The year the data was relevant for.
  • divisions (mandatory, Sort Key) - The kind of division the topography draws, for example "counties," "municipalities"
  • topo (optional, AttributeValue flex type) - TopoJSON version of the object, if applicable.
  • geo (optional, AttributeValue flex type) - GeoJSON version of the object, if applicable.

@NathanLawrence
Copy link
Collaborator

Set up table "CountyGeo" on Access Missouri's AWS.

Fields:

  • year (mandatory, Partition Key) - The year the data was relevant for.
  • county (mandatory, Sort Key) - The county name: I'm thinking we'll use the same name formatting as the field named "NAMELSAD" in @gordonje's converted USGS TopoJSON file.
  • geo (optional, AttributeValue flex type) - GeoJSON version of the object, if applicable.
  • topo (optional, AttributeValue flex type) - TopoJSON version of the object, if applicable. (But it won't be. Because there can't be shared topology in singular objects. I just wanted to write this in to emphasize that all these objects are more or less structured the same way.)

@NathanLawrence NathanLawrence self-assigned this Oct 11, 2016
@NathanLawrence
Copy link
Collaborator

Proposed structure of the live elections data table:

  • race (mandatory, Partition Key) - Race name, which we'll define standards for together.
  • time (mandatory, Sort Key) - Time data was pulled and created, which we'll also choose conventions for together.
    ...and other stuff?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants