Import script for Vacant Building Finder
PHP
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
source
.gitignore
README.md
run_import.php
run_import_api.php
test_ft_queries.php

README.md

Chicago Vacant Buildings Data Importer

This script pulls 311 reports of vacant and abandoned buildings from the City of Chicago Data Portal and dumps them to a CSV file.

Source: https://data.cityofchicago.org/Service-Requests/311-Service-Requests-Vacant-and-Abandoned-Building/7nii-7srd Destination: http://www.google.com/fusiontables/DataSource?dsrcid=1614852

This import script has 2 modes:

  • importing into Google Fusion Tables deprecated
  • exporting to a CSV file

To use CSV mode, set $dump_to_csv = true; in source/connectioninfo.php

In CSV mode, the script pulls down a CSV from the Socrata data portal and removes any duplicate rows for addresses that it has already seen.

usage

  1. cp source/connectioninfo.php.example to source/connectioninfo.php
  2. save your settings in source/connectioninfo.php
  3. php run_import.php