Here is a link to the entire SQL code, but the most important queries are the following: - select the number of properties in the dhcr list the nyc map pluto data - returns 47,130 rows SELECT Count ( a. Determining NYC Properties That Are Likely Rent StabilizedĪfter processing and geocoding the DHCR data it was imported into a PostgreSQL database using CSVkit’s csvsql command as follows: csvsql -db:///nyc_pluto -insert dhcr_rs_geocoded.csv -table dhcr_rsįrom here PostgreSQL was then used to analyze the data.A property’s street address and borough are passed to the GeoClient API, which then returns a plethora of useful information about the property such as the BBL, BIN, latitude and logitude values. This allowed the data to be geocoded at once and then imported into a PostgreSQL database where it could be analyzed with the NYC MapPLUTO GIS tax lot data.Ī Python script was then used to obtain values for each property’s Borough - Block - Lot number (BBL), Building Identificaiton Number (BIN), and latitude - longitude coordinates from the NYC GeoClient API.
His MFA thesis project “ Am I Rent Stabilized?” combines code, maps, and critical thinking about urban planning and renters rights - all of which we love and welcome at CartoDB! He currently lives in Brooklyn, NY, where we locals join him in an obsession with rent rates and regulations. This Map of the Week features the work of a familiar face to CartoDB,, who between juggling GIS projects and grad school also co-organizes Maptime NYC. In the bizzare world of renting, we can help you through the looking glass. Between navigating the rental quagmire of online listings to toggling the various Trulia, StreetEasy, and Zillow helper services, you can tumble down a rabbit hole of the worst options imaginable (or at least, publishable). Property values are a persistent obsession for New Yorkers, as are the arbitrary constraints to dwelling well (d welling? yes). Here is a mock up of the naive approach I'n using: import Foundation
I'm trying to use Combine to do several millions concurrent request through the network.