Tag Archive:
City of Philadelphia

Mapping Philadelphia’s Trees at PhillyTreeMap.org

On April 29, as part of Technically Philly’s Philly Tech Week, we will launch PhillyTreeMap.org, a wiki-style, web-based geography-enabled urban tree inventory application that enables the general public to collaborate with Philadelphia Parks and Recreation, the Pennsylvania Horticultural Society (PHS), and other local groups in a joint effort to map, tend, and preserve Philly’s trees.

Philadelphia, like many American cities, has a wealth of urban street trees.  These hard-working trees line the streets of Philadelphia and help improve our neighborhoods by adding shade, bettering air quality, assisting with stormwater runoff, and generally improving the look and feel of our communities.  Despite their clear benefits, calculating the exact number of street trees has been a difficult and time-consuming process for many municipalities.  With limited resources and other necessary activities, how can a city find time to inventory every single tree?

We’re hoping to make the tree inventory process easier for the City of Philadelphia starting April 29.  As part of that day’s Green Tech Showcase at Philly Tech Week, we’ll be joining with our partners Philadelphia Parks and Recreation, PHS, and DVRPC to introduce PhillyTreeMap and encourage the people of Philadelphia to join the process of growing a green future together.

Why bother with a tree inventory?  Having an up-to-date inventory enables organizations to better maintain these important trees and plan future planting and renewal efforts.  To get started with the process, we’ve loaded the database with existing inventories from PHS, the City, and the Township of Lower Merion and created a series of checks to eliminate duplicate entries.  Each tree is associated with a particular location and may include information such as species, diameter, a photograph of the tree, and yearly eco impact numbers.

PhillyTreeMap.org will be available on April 29

To contribute to the inventory, users can create a free account and then edit existing tree details, upload an image of the tree, or add a new tree to the system.  They can also get help to identify the species of a tree using the handy tree key available on the site.  All changes are available to the general public although a group of trained administrators will review the site for inaccurate or inappropriate changes.  The database will accept additions for trees within the larger thirteen county/three state region surrounding Philadelphia, the same region as the recently announced Plant One Million campaign.

Collaboration is an important part of PhillyTreeMap. The website is built on open source code contributed by the Urban Forest Map project in San Francisco, a group with whom Azavea will continue to work in the future. We hope that the combination of members of the public, non-profit groups, and local government and businesses will result in a dynamic and exciting project that leads to a more complete tree inventory for our nation.

Azavea developed PhillyTreeMap using funding received from the USDA National Institute of Food and Agriculture as part of the Small Business Innovation Research Program (Grant Number 2010-33610-20937).  PhillyTreeMap serves as the prototype of a larger OpenTreeMap project for which we’re currently pursuing further grants in order to implement additional features that may be of use to other municipalities nationwide.

Philadelphia Water Department: An Innovative and Transparent Stormwater Billing System

PWD-logoLike many old cities in America, Philadelphia has a complicated relationship with rain.  Centuries ago this “greene country towne” was streaked by streams and covered by a thick blanket of vegetation that naturally filtered and absorbed storm water.  But much of the city’s green space has since been covered with pavement and its streams converted into a combined storm water/sewage management system.  The consequence is significantly more runoff from impervious surfaces funneling into a finite system of underground tunnels and pipes.  In other words, too much runoff causes the system to break down, forcing a combination of storm water and untreated sewage directly into the rivers.

Many cities have taken a “gray” approach to this problem, building additional capacity into its existing infrastructure.  But the Philadelphia Water Department (PWD) has opted for an entirely “green” approach and stands to save a lot of green in the process.  The plan?  Phase in policies that charge commercial property owners for the actual impervious area on their parcels and provide financial incentives to adopt storm water management practices (SMP), such as green roofs and porous pavement, to decrease runoff before it even enters a storm drain.

This is a massive undertaking for PWD and Azavea has played an important role in supporting it.  A critical component of this plan is to maintain an accurate record of impervious surface areas and property boundaries for the entire city.  Two Azavea GIS analysts have been working onsite with PWD to validate and make corrections to these extensive spatial data collections.

Philadelphia Water Department's Stormwater Billing Application

Philadelphia Water Department's Stormwater Billing Application

One of PWD’s goals was to make this fee restructuring as transparent as possible.  To that end, Azavea built the PWD’s Stormwater Billing application, PhillyStormwater.org, to allow property owners to see exactly how PWD is calculating their new storm water charges.  This web application lets users explore parcels on an interactive map, including high resolution ortho-photography, transparent overlays of impervious surfaces, and tools to do approximate measurements of length and area.  It also provides a charge summary for each parcel, detailing how each component of the bill was calculated and how it will be phased in over time.

Behind the scenes, PWD is running Azavea software to manage each financial credit issued back to its customers for every SMP added, ensuring that land owners are not being overcharged.  Our software is also tracking customer appeals so that data can be promptly corrected when errors are found.

As with so many things, what was old is new again.  It turns out that Mother Nature has been pretty good at managing storm water all along.  It is encouraging to see innovative agencies like PWD leading the way with sustainable, cost-effective solution for managing storm water.

More info:

Data on Mortgages, Deeds, Sheriff’s Deeds, Property Types, etc. at Your Fingertips: Philly LandStat Released to the Public

"The Philadelphia Department of Records has released LandStat to the public, allowing anyone to access more than 650,000 individual pieces of property transaction data within the city. "


Have you ever wondered which zip codes in your city have the most real estate transactions? Or maybe you’ve wanted to know which city council district has the most vacant land? Whether you are a city planner, a real estate investor, or a curious citizen, The Philadelphia Department of Records‘ ‘Philly LandStat ‘ website allows you to access more than 650,000 individual pieces of property transaction data within the city. When we first announced the application in October 2008, it was only accessible from the City’s internal network. The Department of Records has recently released the application (which has just been updated with the latest real estate data) to the public.

LandStat incorporates information on property transactions from the Department of Records’ ParcelExplorer and PhilaDox applications and presents it in an interactive web application. Individual records from those applications were placed into ZIP Codes, City Council districts, wards, U.S. Census tracts, and blockgroups using the Unified Land Records System (ULRS) — winner of the Public Technology Institute 2008 Technology Solutions Award (Web & EGovernment category). Once aggregated to these districts, the resulting dataset could then be fed into Azavea’s Kaleidocade Indicators Framework (KIF) software for publication and analysis over the web, covering such categories as mortgages, deeds, condominiums, the Real Estate Transfer Tax, and property type.

2008 Residential Parcels in Philadelphia’s City
Council District #10.

Kaleidocade enables the end user to create thematic maps, chart trends over time, get detailed reports on specific geographic areas of interest, and perform complex analysis through a straightforward interface using only a web browser. Releasing the property data through KIF, rather than as a flat text file or raw database, gives those interested a set of easy-to-use tools to quickly and easily visualize the various datasets. Users can focus their queries on individual geographic areas or specific types of transactions, or take a step back and look at the data in a larger context, depending on what types of questions they’re trying to answer. It’s the hope of the project that as those answers are sought, a level of knowledge is gained that otherwise might not have been possible by simply looking at a listing of the facts and figures on their own.

To try LandStat, just point your browser to: http://www.phillylandstat.com. Registration is free, and will create an account where all of your searches and reports will be saved so that you can return to them later, but it’s not a requirement.

For more information on Kaleidocade, please contact Chip Hitchens at chitchens@azavea.com.

PhillyHistory.org Makes it to the iPhone

"We've recently decided to make some inroads to learning about and implementing mobile phone technology for several of our software applications."
Left to Right: PhillyHistory as seen on an iPhone; detail view of an historic photo; map view of historic photo search.

An increasingly hot topic in technology lately is that of mobile versions of web applications. It seems that everyone is carrying a BlackBerry, SmartPhone, or iPhone these days, and wants to be able to access all their information on the go. In response to this trend, we’ve recently decided to make an investment in learning about and implementing mobile phone technology for several of our software applications. I recently attended a workshop on iPhone development at the 2009 Museums and the Web conference, and decided that working on an iPhone-specific application would be a great way to get started. We decided to start with the Sajara-enabled PhillyHistory.org site.

Basically, developing for iPhone can take one of three forms:

  • Adjust an existing site. Essentially, you simply need to make sure that your current site looks good on the iPhone.
  • Create an iPhone specific web application. Create a new web application, but tailor it visually and functionally to the iPhone’s layout and interface.
  • Create an iPhone application. Write a full application (in the Objective-C programming language) and publish it through the App Store.

Each option has its advantages and disadvantages, but we decided to go with the second option, since it allows us to have a very sleek interface, without the difficulty of rewriting the application in a new language and the overhead of publishing it to the Apple Store. The main disadvantage to creating a full iPhone application is that it means that we won’t have access to the iPhone’s location SDK.

Once we chose a development route, we needed to start thinking about the user interface from a functional standpoint. I first decided to remove some of the more advanced features (such as keyword and topic searching) of the PhillyHistory site, and focus on what Sajara does best: geography-based searching. iPhone UI design generally follows a simple ‘screen-per-function’ guideline, so I decided to include three ways of accessing a geographic search: by neighborhood, by text location, or directly by map interaction.

All three tasks eventually take the user to a map view, which includes the Sajara geographically-based asset search, and shows markers for the results. The map view uses the OpenLayers API for displaying the map and markers, with some hacks and modifications for allowing the user to more easily drag the map around and zoom in and out on the iPhone. Each time the user pans or zooms the map, the new map extents are used to request a new search. Since I was mostly focusing on the redesign of the user interface, I left the logic behind the search mechanism unchanged from the logic that runs the full PhillyHistory site.

From the map, a user can select one of the markers to get the details for that asset. This screen shows the asset’s image, title, date, and other related data.

Developing the Sajara iPhone web application was fairly simple from a technical perspective. The constraints of having a small screen and keeping a touch interface in mind did make the project interesting. Additionally, one of the big advantages of developing a web app for the iPhone is that there is only one target platform, which greatly simplifies testing.

We look forward to continuing to brainstorm about possible ‘next steps’ in expanding our collection of mobile Sajara apps (and beyond). The next steps for this application and research, specific to Sajara, might include:

  • Enhancing the map interface to allow for pinch zooming
  • Supporting other devices, e.g. BlackBerry
  • Allow other types of searching (keyword, year range, etc.)

To experience the PhillyHistory iPhone app, please go to http://www.phillyhistory.org/i

Azavea Newsletter Puzzle: Philadelphia Public LandStat Application

Map generated in the LandStat application

We’re excited to help make Philadelphia land records information available through the newly public LandStat application. Want to learn more about LandStat? Head to http://www.phillylandstat.com to check out the database and find the answers to this month’s puzzle.

On the welcome page click ‘Mapping and Analysis’ (click on ‘Register’ only if you want to save your work). In Step 1: ‘Select a Geographic Area,’ select ‘All Ward’ from the menu. In Step 2: ‘Create a Project,’ select ‘Property Type’ in the drop down menu under ‘Select a Category.’ A list of available indicators will appear. Select ‘Parcels, Residential, Count’ and click ‘Add.’ Then select ‘Parcels, Commercial, Count’ and click ‘Add.’ In Step 3: ‘Name the Project,’ give your project a name and click ‘Save’ to view the results. The resulting information can be viewed in five ways: map, table, statistics, scatter, or rank.

1. Click ‘Map’ to view the number of residential parcels displayed by city ward. In the mapping features on the left, click on ‘Search’ and enter 340 N. 12th Street (Azavea’s office address) into the box and click ‘Find.’ Then click on the ‘Map Breaks and Colors’ menu located in the same column. What is the range of residential parcels for the ward in which Azavea is located? Hint: It is the smallest range.

2. Click on the ‘Statistics’ tab to view a variety of statistics related to residential and commercial parcels in your project. You can now compare the two indicators you chose for your project: select ‘Parcels, Commercial, Count, 2008′ from the ‘Indicator 2′ drop-down menu. What is the minimum number of commercial parcels in any ward?

3. Click on the ‘Table’ tab to view the number of residential and commercial parcels in each ward. In Ward 15, what is the number of commercial parcels and the number of residential parcels?

Again, be the first to send in all 3 correct answers and receive a $25 gift card to Barnes & Noble! Send your answers to info@azavea.com

LandStat Helps Philadelphia’s Department of Records Get the Big Picture on Real Estate Transactions

"[The] new application...helps city staff visualize and interpret Philadelphia property information"


Continuing our commitment to the Philadelphia Department of Records, we have recently rolled out a new application to help city staff visualize and interpret Philadelphia property information. The new application, called LandStat, is powered by the Kaleidocade Indicators Framework (KIF) to represent aggregated data on such topics as mortgages, deeds, foreclosures, real estate transfer tax, condominium declarations, and property types. By counting, averaging, or adding up records in a particular ZIP Code or census tract, areas can be compared to each other at a glance.


Map describing mortgages in Philadelphia in 2007.

The data used in LandStat has quite a lineage. Azavea previously worked with the Department of Records on the ParcelExplorer application, which combines property transaction and other information from the City’s PhilaDox document recording system with parcel-level data from other agencies as well as a series of historic and contemporary maps. Using the Philadelphia Department of Technology’s Unified Land Records System (ULRS), also developed by Azavea, we were able to enhance the real estate transaction data by performing a series of “point in polygon” operations to determine in which ZIP Code, City Council District, ward, US Census tract or blockgroup each document and property was located. In order to convert that data to something compatible with KIF, we then created an aggregating tool which took the sum, count, or average of each indicator in each of the different geographies and created a KIF database.


Block group report generated by LandStat.

As with other applications using Kaleidocade, LandStat’s data can be viewed in a map, with geographic areas color-coded to indicate different ranges of values. Being able to see hot spots or areas of inactivity quickly and easily can inform decisions and inspire ways of thinking that might not have been possible by viewing the same data in a spreadsheet. LandStat also enables users to create scatter plots, view a statistical analysis, create tables with specific ranges of data, or rank top and bottom locations for a particular indicator. Detailed reports can also be created for an area of interest. LandStat will round out the city’s already advanced suite of land analysis applications.

LandStat is currently available from the City of Philadelphia’s internal network, although the Department of Records may elect to make it available to the public at some point in the future. Please contact Chip Hitchens for more information on LandStat or KIF.

ESRI President’s Award 2008 Awarded to City of Philadelphia’s MOIS GIS Applications

"The President's Award ... is a special recognition to an organization that is "a model for others to follow in implementing GIS successfully as well as making a positive impact on the environment and society."

Jim Querry of Division of Technology accepts award from President Jack Dangermond

At the ESRI User Conference earlier this month, the City of Philadelphia was presented with the President’s Award by Jack Dangermond, President of ESRI. The President’s Award is given to one organization each year and is a special recognition by Mr. Dangermond to an organization that is “a model for others to follow in implementing GIS successfully as well as making a positive impact on the environment and society.” Previous winners have included the U.S. Department of the Interior, the City of New York, the International Center for Integrated Mountain Development, and the Hong Kong Information Center. Though the award is seldom given to the same recipient twice, this is the second time the City of Philadelphia has received the award (the last time was in 2000).

The award was accepted by Jim Querry, the Director of Enterprise GIS for the City. The award was presented in the Plenary Session of the annual ESRI User Conference in San Diego before a crowd of more than 12,000. Several efforts were cited including: the public crime mapping web site, PhillyHistory, the work order management system at the Streets Department, a new mobile GIS system at the Airport, the Unified Land Record System, CityMaps and ParcelExplorer. We’re happy and proud that some of Azavea’s work was part of this recognition for the innovative GIS work being done by the City of Philadelphia.


To read more about the award ceremony visit the ESRI User Conference blog here.