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
cp source/connectioninfo.php.example to source/connectioninfo.php- save your settings in source/connectioninfo.php
php run_import.php