resistbot / mapping Goto Github PK

We plan to use MongoDB as the data dump store to contain all RapidPro user data.

Next Actions

• Setup locally first
• Setup in Docker container locally
• Setup EC2/Docker container to access RDS that contains the MongoDB (RDS url as env var within EC2)

cc @millzpaugh

We need Congressional District codes in order to match each district on the map with proper features/polygon.

Next actions

• Create a script to add Congressional Districts to rep_by_state.json data, using the google civic api Sunlight Foundation API to lookup congressional districts by rep
• Add this rep_by_state.json data file to this repo for CD lookup by state

Available geo data

Congressional District shapefile

1. Convert shapefile to geojson --> CD.geojson
2. Add aggregated user data to CD.geojson as properties per district feature
3. Upload geojson to s3 and/or studio

Relevant Congressional District shapefile attributes

• STATEFP: State Code
• CD115FP: Congressional District Code

Example cd.geojson

{
"type": "FeatureCollection",
"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
                                                                                
"features": [
{ 
  "type": "Feature", 
  "properties": { 
        "STATEFP": "02", 
         "CD115FP": "00", 
         "num_users": "200", 
         "num_messages": "250" 
    }, 
   "geometry": { "type": "MultiPolygon", "coordinates": [ [ [ [ 179.388742, 51.941917 ], [ 179.404562, 51.968358 ], [ 179.401376, 51.973083 ], [ 179.408729, 52.005355 ], [ 179.429602, 52.023583 ], ...

cc @millzpaugh

Setup bites page to iterate on map, using prototype user data.

cc @millzpaugh

We plan to hold geojson prefixed by state on s3.

s3://resistbot/data/ca/
s3://resistbot/data/co/
s3://resistbot/data/ct/
s3://resistbot/data/de/

Each folder containing:

• state.geojson
  • # users
  • # messages
• congressional_district.geojson
  • # users
  • # messages

{add photo}

cc @millzpaugh