search

mikeymicrophone / commissulator

Commissulator is a set of tools that help Real Estate Agents working with Citi Pads in Manhattan streamline their paperwork.
Other
3 stars 4 forks source link

Architect data model for addresses and apartments #17

Open mikeymicrophone opened 6 years ago

mikeymicrophone commented 6 years ago

There's a lot of data on New York addresses, streets, buildings, and apartments. The owner of each building, and ideally the management company as well, could be mined out of this data.

Commissulator only needs Manhattan addresses right now. I know a way to pull block and lot data from PLUTO, and to get all streets and addresses from that. The next thing I want is a list of unit names in each rental building, or a way to know their pattern and scope so they can be generated.

Once we have a quick way to refer to each apartment, we don't need much data beyond that because we know the inventory already.

mikeymicrophone commented 6 years ago

If a certain data source is already good for this need, we can consider that. I know there are some awesome efforts in this space, and New York's big data initiatives have been some of the most successful in the world.

mikeymicrophone commented 6 years ago

https://data.cityofnewyork.us/Housing-Development/Housing-New-York-Units-by-Building/hg8x-zxpr

gitcoinbot commented 6 years ago

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

This issue now has a funding of 0.085 ETH (17.42 USD @ $204.94/ETH) attached to it.

mikeymicrophone commented 6 years ago

Not in a graphical way, the schema is shown here though. https://github.com/mikeymicrophone/commissulator/blob/master/db/schema.rb

I think we can start with a State model, a City model, a Street model, a Building model, and an Apartment model. Deciding where to put Zip codes is one issue. Finding the data for apartment numbers (and potentially what unit size or floor number they correspond to) is the biggest goal.

mayank8318 commented 6 years ago

Can you please state the required fields for each model?

mikeymicrophone commented 6 years ago

State: name, abbreviation City: name, state_id Street: name, city_id ZipCode: number Building: name, street_address, access_codes, landlord_id, street_id, zip_code_id Apartment: unit_number, floor_number, size, building_id

gitcoinbot commented 6 years ago

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

Work has been started.

These users each claimed they can complete the work by 3 months, 2 weeks ago. Please review their action plans below:

1) mayank8318 has started work.

I will work on this and submit a PR within 2 days.

Learn more on the Gitcoin Issue Details page.