This dataset contains all the local government tax breaks given to corporations in the City of Syracuse from 2003 to 2014. This dataset was extracted using the Subsidy Tracker, which is a national search engine for economic development subsidies and other forms of government financial assistance to business. This information is compiled by the Good Jobs First Center and includes tax breaks given by national, state and local government agencies.
Subsidy Tracker is made up of data drawn from hundreds of online sources, supplemented by the results of open records requests for information not posted by government agencies. For tax subsidies in the City of Syracuse, most information comes from the Onondaga County Industrial Development Agency, Syracuse Industrial Development Agency and the New York Department of Taxation and Finance.
The first step involved loading the dataset and manually fixing all address and company name inconsistencies. This is an important process before we geocode all the projects that received a tax break in the City of Syracuse.
The second step involved geocoding the dataset. Geocoding is the process of converting addresses into geographic coordinates, which you can use to place markers or position the map. For this step, we used the Google Maps API geocoding service. In addition, variables that were not relevant to the analysis were removed from the dataset.
The third step involved preparing the data for geospatial projection. To do this, we used the U.S. Census Tiger shapefiles for Onondaga County census tracts to create a working GEOJSON file. Next, we performed a spatial join with GEOJSON and the geocoded tax subsidies dataset. Finally, we clipped the data to keep only those tax subsidies that are within the City of Syracuse Census Tracts.
Finally, we grouped the dataset by census tract and we calculated the total number and total amount of tax subsidies per census tract. This is our final processed dataset.
The last step involved saving the final dataset, which includes the total number and total amount of tax subsidies per census tract.
## [1] "Saved"