hackoregon/urbandev-etl issues and pull requests

#44 - Minor fixes

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#43 - Modify generate script to load json into S3 Buckets

Pull Request - State: closed - Opened by meyersj over 8 years ago

#42 - Update `CREATE-TABLE-zillow_json.sql` with craigslist data

Issue - State: open - Opened by meyersj over 8 years ago

#41 - Move check for crime table to beginning of script

Pull Request - State: closed - Opened by meyersj over 8 years ago

#40 - Craigslist rentals by zillow neighborhood

Pull Request - State: closed - Opened by hassanshamim over 8 years ago

#39 - Modify generate.py script to load assets into S3

Issue - State: closed - Opened by meyersj over 8 years ago - 1 comment

#38 - add craigslist neighborhood rental sql import

Pull Request - State: closed - Opened by hassanshamim over 8 years ago - 3 comments

#37 - build_db fails - missing CREATE_TABLE

Issue - State: closed - Opened by hassanshamim over 8 years ago - 1 comment

#36 - generate final json for each neighborhood

Pull Request - State: closed - Opened by meyersj over 8 years ago

#35 - (improved) script to map block groups to zillow neighborhoods

Pull Request - State: closed - Opened by meyersj over 8 years ago

#34 - Queries to build table with json field for each neighborhood across multiple years/datasets

Pull Request - State: closed - Opened by meyersj over 8 years ago

#33 - TIGER/Line® with Selected Demographic and Economic Data

Issue - State: open - Opened by znmeb over 8 years ago

#32 - Aggregate Crime and Demolition data by Zillow neighborhood

Pull Request - State: closed - Opened by meyersj over 8 years ago

#31 - Create views for census data over multiple years

Pull Request - State: closed - Opened by meyersj over 8 years ago

#30 - ACS Household Income 2009, 2014 by Zillow region by Block Groups.

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#29 - Race by Zillow region for years 2000, 2010.

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#28 - Added education to 274797.sample.json

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#27 - Port of Crime, Demoltion and Permits data from MySQL to PostgreSQL

Pull Request - State: closed - Opened by meyersj over 8 years ago

#26 - Buildathon queries

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#25 - add directions to compute nbo_blocks

Pull Request - State: closed - Opened by meyersj over 8 years ago

#24 - Data that maps Zillow Region to Block Group with percentage overlap.

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago - 1 comment

#23 - Add nbo_blocks table

Pull Request - State: closed - Opened by urbanyeti over 8 years ago

#22 - Directory to hold scripts and files from the Buildathon.

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#21 - Data for average apartment rental prices for Jan-May 2016.

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#20 - Fixed typo in variable. Added documentation for Mac OS X usage.

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#19 - Automated script to build Census Postgres database

Pull Request - State: closed - Opened by meyersj over 8 years ago - 1 comment

#18 - Apartment listings from craigslist.org

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#17 - add missing field types to census_households_by_income table

Pull Request - State: closed - Opened by meyersj over 8 years ago

#16 - Census block nbrhood mapper

Pull Request - State: closed - Opened by jamilalvi over 8 years ago

#15 - Block groups in neighborhoods

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#14 - Fixed script errors and documentation.

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#13 - Educational attainment by block group

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#13 - Educational attainment by block group

Pull Request - State: closed - Opened by jimtyhurst over 8 years ago

#12 - Inventory of data already obtained

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

#11 - Shape files for census Block Groups.

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

#10 - New tables for ACS Household Income data for 2009 and 2014.

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

#9 - New table: census_persons_by_race_blkgrp

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

#8 - Fixed documentation in deoid10.sh

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

#7 - SQL and data loader scripts for table census_total_population_blkgrp

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

#6 - Household Income Data table loads

Pull Request - State: closed - Opened by wheelerma55 almost 9 years ago

#5 - Census data: educational attainment

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

#4 - Added ERDs for handling Area Overlap and Data Provenance

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

#3 - Added 4 more census data files from NHGIS.

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

#2 - Fixed list formatting.

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

#1 - Moved database scripts and documentation from urbandev-backend

Pull Request - State: closed - Opened by jimtyhurst almost 9 years ago

GitHub / hackoregon/urbandev-etl issues and pull requests