This made it easier to batch geocode and then import the data into a local PostgreSQL and PostGIS enabled database where it could be joined to and then analyzed with the NYC MapPLUTO tax lot Shapefile data. Processing the DHCR Rent Stabilized Building ListĮxcel workbooks obtained from a Freedom of Information Law request that I made to the NYC Department of Housing and Community Renewal were normalized, stacked, and converted to a Comma Separated Value (CSV) file format using a Node JS script.
Typically when working with large datasets that I only need a subset of or want to aggregate, I'll process the data locally so that I don't need to use as much disk space on my CARTO account. Below, I'll outline the data processing steps that I performed. DHCR & MapPLUTO Data ProcessingĪm I Rent Stabilized? uses data I created that lives on CARTO which enables the website to work as a fully functional web-app via CARTO's SQL API and the CARTO.JS library. You may read more about in a separate article I wrote for Urban Omnibus, an online publication by the NYC Architectural League.
Am I Rent Stabilized features a responsive UI that is mobile friendly, and its entire content can be toggled to either Spanish or Chinese for non-English speakers. From there the app recommends a course of action and informs the user of their nearest tenants rights group so they may get help. The app first asks the user to input their address and borough, then checks it against a database of properties that are likely to have rent stabilized apartments. It is an attempt at using open data as a prompt for civic action, rather than solely for visualization and analysis. The development of the app was motivated by the lack of enforcement of rent regulation laws in NYC by the local and state government. Also note that CARTO renamed / rebrandedĪm I Rent Stabilized? is a web application that encourages New York City tenants to find out if their landlord may be illegally overcharging them for a rent stabilized apartment and if so, motivates them to take action.
Reflect changes in the project since then. Note: This post originally appeared in CARTO's Map of the Week, on
0 kommentar(er)
