{"repo":"JustFixNYC/who-owns-what","free":true,"listed":false,"github":"https://github.com/JustFixNYC/who-owns-what","clone":"git clone https://github.com/JustFixNYC/who-owns-what.git","description":"Who owns what in nyc?","language":"TypeScript","stars":212,"topics":["reactjs","postgresql","open-data","opendata","civic-tech","civictech","mapbox-gl-js","mapbox-gl"],"license":"GPL-3.0","category":"databases-storage","readme_excerpt":"Who owns what in nyc? The Who owns What project is a new resource for community organizers and tenant leaders to demystify property ownership and shell company networks across New York City. With this website, you can find crucial information about who is responsible for your building. The site utilizes a database of 160k other properties to connect the dots and discover other properties that your landlord might own or be associated with. Use this tool to discover what buildings in your neighborhood to organize in, what communities your landlord might be targeting, and if your building might be financially overleveraged. This project is currently in active development! Architecture This site is built on top of the critical work done by @aepyornis on the nycdb project, which is used to cleanly extract, sanitize, and load HPD Registration data into a PostgreSQL instance. Backend logic and data manipulation is largely handled by making calls to PostgreSQL functions and prebuilding results into tables whenever possible to avoid complex queries made per-request. for the SQL code that provides this functionality, see: - the hpd-registration scripts of nycdb , and - the sql directory of this repository. Backend The backend of the app is a simple Django app that connects to Postgres. Frontend The frontend of the app ( /client ) is built on top of create-react-app. See /client/README.md for all the info you might need. Setup In order to set things up, you'll need to copy .env.sample t","default_branch":null,"files":null,"tree":[],"storefront":"/r/JustFixNYC","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/JustFixNYC/who-owns-what/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}