8000 GitHub - keiferc/ca-precincts: Geodata processing and analyses for California precincts
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

keiferc/ca-precincts

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

49 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

California Precincts GeoData

Contains shapefiles and tabular election and demographics data of California precincts.

Contents

Repo Structure

Sources

Data Processing

Results

Analysis

Naming Reference

Repo Structure

.
├── README.md
├── analyses
├── coun
8000
ties
│   ├── alameda
│   │   ├── README.md
│   │   ├── processed
│   │   │   ├── georeferenced
│   │   │   ├── shp
│   │   │   └── tab
│   │   ├── raw
│   │   │   ├── jpg
│   │   │   └── shp
│   │   └── results
|   ├── alpine
│   │   ├── README.md
│   │   ├── processed
│   │   │   ├── georeferenced
│   ... ... ...
├── geodata
│   ├── acs
│   │   ├── shp
│   │   └── tab
│   ├── census
│   │   ├── shp
│   │   │   └── 2010
│   │   │       ├── blocks.zip [not included because of large file size]
│   │   │       └── counties.zip
│   │   └── tab
│   │       └── 2010
│   │           └── blocks.zip
│   └── election
│       └── 2016
│           ├── federal
│           │   ├── house.zip
│           │   ├── president.zip
│           │   └── senate.zip
│           └── state
│               └── state.zip
└── scripts
    └── extract.py

Sources

Geographic Data geodata/census/shp/

2010 Decennial Census /2010/

blocks.zip: Shapefile of 2010 California census blocks

counties.zip: Shapefile of 2010 California counties

state.zip: Shapefile of 2010 California state.

Demographics Data geodata/census/tab/

2010 Decennial Census /2010/

blocks.zip: Tabular demographics and VAP data of 2010 California census blocks

  • Retrieved June 2020 from the NHGIS database's 2010_SF1a dataset

  • Contains tables "Total Population" and "Hispanic or Latino, and Not Hispanic or Latino by Race for the Population 18 Years and Over"

Election Data geodata/election/

2016 United States Elections /2016/

/federal/president.zip: Tabular California precinct-level data for the 2016 United States Presidential election

/federal/senate.zip: Tabular California precinct-level data for the 2016 Senate elections

  • Retrieved June 20 from the MEDSL database

  • California-specific data extracted with ‘state_postal = CA’ query

/federal/house.zip: Tabular California precinct-level data for the 2016 House elections

  • Retrieved June 20 from the MEDSL database

  • California-specific data extracted with ‘state_postal = CA’ query

/state/state.zip: Tabular California precinct-level data for 2016 state elections

  • Retrieved June 20 from the MEDSL database

  • California-specific data extracted with ‘state_postal = CA’ query

Data Processing

County Metadata

Number of precincts and precinct names were retrieved June 2020 from...

Digitization of Precinct Maps

Raster maps from the county's website were georeferenced in QGIS and then used to outline precinct boundaries around which census blocks were geographically merged. All maps have coordinate reference systems (CRS) defined on EPSG:102003 (USA Contiguous Albers Equal Area Conic) for georeferencing along the OpenStreetMap (OSM) standard. Additionally, the Albers projection is the standard used by the US Census Bureau, from which the geographic data comes. The maps are projected in EPSG:3310 (NAD83/California Albers) for prioritizing geographic area.

Data Joining

The block-level and county-level shapefiles were joined to disaggregate county names to blocks. The script can be found in the Jupyter Notebook script/join-blocks-counties.ipynb. The joined shapefile can be found in geodata/census/shp/2010/blocks-counties-joined.zip.

Shapefile and tabular data joins were done using python. The documented script can be found in the Jupyter Notebook ...

GeoData Aggregation

Census-block-level demographics geodata were aggregated into precinct-level election geodata using the python maup package. The documented script can be found in the Jupyter Notebook ...

Results

Alameda County (counties/alameda/results/)

  • alameda_precincts.zip

  • alameda_blocks.zip

Analysis

More detailed analyses can be found in analyses/.

Note: Because of the immigration history and the election requirements of the United States, not all in the Hispanic voting age population (HVAP) nor all in the Asian voting age population (ASIANVAP) are citizens. Consequentially, not all in the HVAP nor in the ASIANVAP are permitted to vote in United States federal elections. Therefore, any ecological regression (ER) or ecological inference (EI) analyses using HVAP or ASIANVAP lack statistical accuracy. It is better to use HCVAP and ASIANCVAP for analysis purposes.

Naming Reference

The columns names used in the geodata follow the Metric Geometry and Gerrymandering Group (MGGG) naming conventions.

Election Data

Presidential Election

  • PRES16C: Votes for the Constitution candidate in the 2016 United States Presidential Election

  • PRES16D: Votes for the Democratic candidate in the 2016 United States Presidential Election

  • PRES16R: Votes for the Republican candidate in the 2016 United States Presidential Election

  • PRES16L: Votes for the Libertarian candidate in the 2016 United States Presidential Election

  • PRES16G: Votes for the Green candidate in the 2016 United States Presidential Election

Senate Election

Coming soon...

House Election

Coming soon...

Gubernatorial Election

Coming soon...

Demographics Data

Population Data

  • TOTPOP (H7Z001): Total population

  • NH_WHITE (H7Z003): White, non-Hispanic alone population

  • NH_BLACK (H7Z004): Black, non-Hispanic alone population

  • NH_AMIN (H7Z005): American Indian and Alaska Native, non-Hispanic alone population

  • NH_ASIAN (H7Z006): Asian, non-Hispanic alone population

  • NH_NHPI (H7Z007): Native Hawaiian and Pacific Islander, non-Hispanic alone population

  • NH_OTHER (H7Z008): Other race, non-Hispanic alone population

  • NH_2MORE (H7Z009): Non-Hispanic population of two or more races

  • HISP (H7Z010): Total Hispanic/Latino population

  • H_WHITE (H7Z011): White, Hispanic alone population

  • H_BLACK (H7Z012): Black, Hispanic alone population

  • H_AMIN (H7Z013): American Indian and Alaska Native, Hispanic alone population

  • H_ASIAN (H7Z014): Asian, Hispanic alone population

  • H_NHPI (H7Z015): Native Hawaiian and Pacific Islander, Hispanic alone population

  • H_OTHER (H7Z016): Other race, Hispanic alone population

  • H_2MORE (H7Z017): Hispanic population of two or more races

Voting Age Population (VAP) Data

  • VAP (H75001): Total voting age population

  • HVAP (H75002): Hispanic voting age population

  • WVAP (H75005): White, non-Hispanic voting age population

  • BVAP (H75006): Black, non-Hispanic voting age population

  • AMINVAP (H75007): American Indian and Alaska Native, non-Hispanic voting age population

  • ASIANVAP (H75008): Asian, non-Hispanic voting age population

  • NHPIVAP (H75009): Native Hawaiian and Pacific Islander, non-Hispanic voting age population

  • OTHERVAP (H75010): Other race, non-Hispanic voting age population

  • 2MOREVAP (H75011): Voting age population of two or more races

About

Geodata processing and analyses for California precincts

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published
0