Yiwei Hao
Real estate, aviation and finance projects, built on public data. Each project opens to a live page with its data sources and method.
I have loved SimCity since I was small, and I loved sitting by the railway tracks with my grandfather, waiting for trains to pass. That is why the live transit is on the map too. Sorry — only Greater Vancouver and Cambridge are built so far on the map, and the 13F project is still being filled in. Each region means pulling every council agenda, planning application, permit report and parcel record since 2022 to a local store (tens of thousands of documents), geocoding and matching them to lots, then classifying each one by stage, use and work before anything appears on the map. That takes days per region, so the other projects stay locked until they get the same treatment.
1 · Real estate
Greater Vancouver & Cambridge Development Map
Every rezoning, development permit and building permit since 2022 across Metro Vancouver and the Fraser Valley, as a 3D map of where each parcel stands: under review, approved, permitted, demolished, built.
ohere.ai/devmap · by admissionCMBS Property Atlas
Every property behind US commercial-mortgage securitizations, read from the Annex A-1 of SEC prospectuses: appraised value, NOI history, occupancy, loan terms and sponsor, on a ZIP-code map with cap-rate, underwriting-versus-actual, maturity-wall and lender charts, 68 trusts, 2012–2026.
ohere.ai/cmbs · v2NYC Land Price Map
Click any tax lot in Brooklyn: the land price before the building, every unit sale since 2003, zoning and planning items, and the land → units value chain.
Vancouver Tower Site & Sales Forecast
Rezoning path, massing options and sell-out forecast for two downtown Vancouver lots, with a residual land value model.
2 · Aviation
Airline operations
Every open analyst/coordinator-type role found at airlines, airports, lessors, aviation-data, MRO firms and aircraft makers worldwide, plus REIT jobs worldwide, analyst and data roles in Canada, and every job in Greater Vancouver, by a daily career-page scan. Each point sits at the street address or the employer's office when known, with the number of open jobs there.
ohere.ai/airline-map · password requiredAirline Finance
A living map of the world's aircraft: who owns and operates them, which routes they fly and how full those routes are, what they are worth and when leases expire. From 19 national registries, SEC filings and national traffic statistics.
ohere.ai/airline-finance · fleets and routes liveRegional Airline Route Planning
Where a new aircraft type pays off on a regional network: demand model, range and runway screening, integer-programme fleet assignment.
3 · Finance
13F Homework
What the 500 largest US investment managers opened, added, reduced and exited each quarter from SEC Form 13F filings, grouped by style, with a map of who bought the same stocks in the same quarter.
ohere.ai/13f · in progressListed Companies & Meetings
Every company and REIT listed on US and Canadian exchanges, pinned to its head office, with upcoming shareholder meetings lit up where they will be held and laid out on a calendar, read from the meeting notices themselves.
ohere.ai/listed · newMethods and data notes: Development Map · CMBS Property Atlas (deals, states) · Airline Finance · 13F Homework · Listed Companies & Meetings