Development Application Tracking & Visualization

We've spent a lot of time over the last few months talking to real estate developers and industry professionals in Toronto. The single most requested feature has been a way to quickly explore the development applications that already exist. This information is extremely useful for understanding the development potential of a site as it conveys local approvals precedent and neighbourhood activity. Unfortunately, it is very difficult to get this data in a useful format. The City of Toronto hosts a search portal, but it is difficult to filter results to a set that is relevant to particular address.

Today, we are extremely pleased to announce that development applications can now be viewed in 3D for the entire City of Toronto!

dev applications.png

Information available includes current application status, proposed stories, descriptive text and more. Just click on the parcel associated with the application! We have colour coded each application according to its status:

  • Yellow = SPA / ZBA / OPA application submitted & under review

  • Green = Approved

  • Red = Under Appeal

  • Light Blue = Building Permit applied / under construction

  • Dark Blue = Completed

We have translated the applied-for heights (based on number of stories multiplied by 3.5m) and represented them with a 650sm cylindrical extrusion in the middle of the site. Please note that this is NOT a literal representation of the applied for building form but rather an abstraction for understanding scale.

The technical nuts and bolts:

For a bit of a deep dive into how (and why!) we developed this feature please read on.

Lets' start with the City of Toronto site for finding development applications: http://app.toronto.ca/DevelopmentApplications/mapSearchSetup.do?action=init.

City Dev App.png

First, the good stuff. The city has all the information in database with geo-spatial attributes and they actively maintain it. They make this site available to anyone and for free.

Now the not-so-good stuff. Because there is a map on the page, a user has the reasonable expectation that the data can be explored via the map. But there is no data shown on the map without first engaging with the filter search on the left side of the page. Even worse, the filter search is not capable of returning all the data in the database at once, and the filtering options presume a sophisticated knowledge of the whole process of making an application for development. "Community Planning" or "Committee of Adjustment"? Maybe what I'm looking for is under "Toronto Local Appeal Body"? Who knows? I am a registered professional planner and I find this interface massively confusing.

So, the first thing to do is scrape the data that this page provides acccess to and store it in more effective ways. At Ratio.City we lean heavily on PostgreSQL (with the PostGIS extensions) to do high performance querying of geospatial data. We also rely on MapBox with their excellent map-tile hosting service and their WebGL enabled 3D mapping framework. We want to translate the data on the city site into both these formats so.

Some structured exploration with the site's filter search (while observing the requests and responses in the developer tools of your favourite web browser) will reveal that there are clear patterns for how the data on this site is retrieved and structured. This leads to the most frustrating thing about this site: the returned data IS hierarchical, but it is returned in a flattened list with internal referencing rather than a natively hierarchical format like XML or better yet, JSON. Compounding the problem is that to get all the data available, each combination of application type and city ward must be queried, and each response parsed. Much Python scripting was done to manage this querying and parsing until we had nice, tidy JSON records. So where do we store this newly cleaned data?

EM Screen Shot 2018-09-21 at 5.08.21 PM.png

Fortunately, at Ratio.City we already run a high performance API on top of our PostGIS database. (For the curious, our APIs are built with Django REST Framework and deployed to Amazon's server-less infrastructure with Zappa which is an amazing tech combo.) This allows us to simply pass the JSON records we have extracted as the data payload of PUT requests to our API endpoints and our backend services convert them to database records with indexing that enables extremely fast spatial queries. Our first data transformation is complete!

Next we need to generate map tiles to store on MapBox. MapBox provides a great command line tool called Tippecanoe to convert various geospatial file formats to MapBox's .mbtiles format. Keen observers will note that we don't have a geospatial file, we have a bunch of records in a geospatial database. This is true, and there are a few different ways to deal with this, but our preferred approach is to simply ask our API for all the relevant development application records and dump them out as a geoJSON file. Then we run this file through tippecanoe to get our map tiles. The resulting .mbtiles file contains not just the geometric data we want to visualize on our website, but also a number of other parameters that we believe our users will be interested in. We upload this file to MapBox and our web application displays it in glorious 3D!

One final wrinkle is that the City of Toronto is updating their applications database on a daily basis. All the steps described in this post are tedious to carry out, even if a computer is doing most of the heavy lifting. The last step is automate the whole process on a virtual machine on AWS. A bash script runs each of the steps in sequence and emails us with success or failure status every morning at 2am. Voila! A tricky bit of data acquisition and organization running automagically every night while we sleep.

brxxto-346280-unsplash.jpg

Latest Site Analysis Tools

Our instant site analysis and 3D built form evaluation allows our users to easily interpret the Planning Policies. Our tools and work flow is based on the City of Toronto’s Tall Building & Mid-Rise Guidelines and in-depth professional knowledge of building typologies and the Approvals evaluation process. Our tools allow for users to customize parameters to easily test various options and alternatives.

3D massing studies

Instantly generate realistic 3D building massing proposals. See building size (GCA, GFA, NSA, estimated unit count), resulting density and determine land value at the touch of a button.

types-gfa.png
 
 

Sun Shadow Analysis

Dynamically generate shadow studies to test implications of proposed built form. Our sensitivity analysis highlights new shadows that touch public parks. Instant feedback informs massing and setback decisions early in the design process.

Incremental Shadow Study

December, 21 (09:18 am - 16:18 pm)

Net new shadows in blue, net new touching a park in red, net new with neighbourhood covering park already in purple.

shadow_animated.gif

Latest Map Layers

We are building tools to make exploring and understanding intersecting planning policy areas fast and easy. Our online mapping aggregates data layers that can be explored intuitively in an interactive 3D map, and then provides the ability to summarize information for a specific property parcel. We have spent time collecting, cleaning and optimizing layers available from the City of Toronto Open Data Portal and creating our own in the case they are not available from the City. There are many other layers available than what is show below, with new ones added all the time.

You can test out the majority of our tools by signing up for a TRIAL ACCOUNT.

We encourage you to reach out and let us know what you think of what we have built so far, and we have a lot of exciting things in the works that we can't wait to share with you! If you would like to organize a demo please do so here.

zoning_city-min.png

Zoning By-Law 569-2013 : Categories

height_aor-min.png

Zoning By-Law : Heights

op_city-min.png

Official Plan - Land Use

secondary-plans-2-min.png

Secondary Plans

tocore-min.png

TO Core

ravine_nat_feature-min.png

Natural Heritage

heritage-min.png

Heritage Conservation Districts & Listed/Designated Properties

transit.png

Transit

avenues & ROW.png

Urban Structure & Right of Way Widths

See you at RealTrends Conference Sept 13

Real Trends Forum, Canada's leading conference on commercial, industrial, retail & Multi Family real estate is taking place September 13th in Toronto. CEO and Co-Founder, Monika Jaroszonek will be speaking on a panel that explores how technology and regulatory changes are changing the role that brokers and lawyers play in property development.

Technology is transforming industries, making them more modern and efficient. It augments the accessibility of information, cuts our inefficiencies and reduces the risk of theft or fraud. It is hard to imagine that a more secure, faster, trusted process for buying, leasing and selling property will not catch on. But what does it look like, who does it impact and in what area? How are companies capitalizing on these changes to increase revenues and cut costs?

Monika will be participating in a panel discussion to bring her perspective on the challenges of integrating insight from different sources, what the impact will be to jobs, systems and policies.

Official Plan + Transit Layers

Smart development needs to be near transit to keep the city moving.  Take a look at our latest layers:  we’ve added the extents of the current and proposed transit infrastructure and the City’s Official Plan Land Use maps!  Enjoy!

RATIO.CITY OP TRANSIT.jpg

RATIO.CITY is an online mapping and analysis tool that helps real estate developers, urban planners, architects and municipalities instantly evaluate potential development sites.  Get in touch with us to schedule a DEMO for your team!

Density + Urban Structure

The urban experience is ultimately about the spaces between buildings.  When we look at the city of Toronto as a whole and analyze site coverage (aka the footprint of the building as a percentage of the total site area) and highlight sites that have high coverage (60% +), we see some obvious results as well as some outlying surprises.  Interestingly, industrial areas along the railway corridors also tend to have high coverage ratios, but presumably low density.  

How can we use this type of analysis to help determine opportunities for infill development?  

RATIO.CITY coverage.png

Collaborate easily with RATIO.CITY’s new SHARE feature

We’ve introduced clickable and shareable links to our platform to make it easy for our users to share projects with clients, consultants, investors and stakeholders.  We’re always adding new functionality and sharing links was a requested feature. Here’s how it works:

Step 1
Refine proposed 3D building massing - adjust front, side and rear setbacks, floor to floor heights, total height until appropriate.  Once ready to share...

Step 2
… click the share button and copy and paste the URL directly into an email.

Step 3
When clicked, the Recipient can log in and view the 3D building massing.  Recipients can’t change any settings unless they also have a subscription, but they can see all the setback assumptions and rotate the 3d model in its neighbourhood context on any web browser.   

RATIO.CITY SHARE.gif

RATIO.CITY is an online mapping and analysis tool that helps real estate developers, urban planners, architects and municipalities instantly evaluate potential development sites.  Get in touch with us to schedule a DEMO for your team!

$100K Pitch Competition Winner

We are so excited to announce that RATIO.CITY was selected out of 8 finalists for the grand prize of $100K in start up capital in Communitech's Fierce Founder Pitch Competition!

 

A Toronto architect determined to foster urban development and create “more dense, liveable cities,” has emerged as the winner of the latest Fierce Founders Bootcamp pitch competition.

Monika Jaroszonek, CEO and co-founder of Ratio.City, earned the $100,000 grand prize for the best pitch, making her case Thursday before a standing-room only audience at the Tannery Event Centre and a panel of five judges, beating out seven other competitors.

“This is very exciting because now it means we can start building out this functionality that we’ve been talking about and hopefully hit the market as quickly as possible,” said Jaroszonek after the symbolic cheque presentation.

“This really lets us hit the ground running. We’ve been bootstrapping, self-funded to date, and this lets us expand our team and … create a product that will be viable in the market, and help build those dynamic cities that will make great neighbourhoods for us all to live in.”

1000x600_FierceFounders_Feb.18-9.jpg

 (Communitech photo: Kelsey Vere)

 

Beta 2.0 Live Preview

We just released a overhaul of our original BETA!  Login with either your email or LinkedIn credentials for the next 2 weeks.  Take it for a spin and we would love to hear your thoughts!

Filter Search

Search for off-market sites across the whole city.  As a demonstration, we have set up filters for Existing Zoning Category and a limited number of Existing Uses.  What other search criteria do you consider a "must have" to make this an indispensable tool for off-market site identification?  

Updated User Interface Design

Adding the additional functionality required we tighten up the layout.  What you think about the new pull down menus, labels and toggles?  Was it easy enough to find what you're looking for?

user tips:

  • reset the search by pressing CLEAR button;
  • the closer your zoom, the faster the results return;
  • scroll through the pagination at the bottom to see all results
search preview.png
 

Data Visualization

One of the most exciting aspects of new mapping technology is to give us new ways of seeing cities.   In this case, overlaying the existing built form and the allowable zoning heights in San Fransisco and highlighting the areas of the biggest differential.  This is a great example of an intuitive visualization of complex data sets that helps in understanding city structure and highlighting development potential.   

It made us start to think about changes to the planning approvals process and how we can use technology to find sites that meet Provincial Planning Policies and growth targets...stay tuned...