Laura Rung-Er Jang_Spatial Analysis by Laura Jang

Spatial Analysis The Work Samples for Planning Oriented GIS Project

Laura Rung-Er Jang City and Regional Planning Program University of Pennsylvania

Laura Rung-Er Jang

jang.rung.er@gmail.com | 215-429-3346 4218 Baltimore Ave., Philadelphia, PA 19104

EDUCATION University of Pennsylvania

Master of City and Regional Planning, Land Use and Environmental Planning Philadelphia, PA Sept ’11 – May ’13

National Chengchi University Bachelor of Art, Land Economics (Urban Planning based) Taipei, Taiwan Sept ’06 – July ’10

SPECIALTIES GIS Graphics Data Analysis

Software

ArcGIS (ArcMap, ArcScene) │Community Viz │Google Earth Pro Adobe CS (Illstrator, Photoshop, InDesign, Bridge) │ AutoCAD │ Rhino MS Office (Word, Excel, Powerpoint, Access) │SAS │ SPSS

Language

English │ Mandarin Chinese │ Taiwanese

Interest

Digital Photography│Travel │Kayaking │Hiking

Contents Total Number of Business 2012 Source: Wharton GIS Lab 1. Philadelphia Block Stabilization Program Year: 2012

´ Properties_Possitive Profit Properties_Negative Profit

2. Philadelphia Commercial Corridor Enhancement Program

Olney

Fern Rock Trans. Center

Logan Wyoming

Frankford Terminal Margaret/Orthodox

Huntng Par k�

ChurchTotal Number of Business 2012

Erie

Erie/Torresdale

Alleghney

Tioga

North Philadelphia

Allegheny

Somerset Huntngdon� Susquehanna-Dauphin York-Dauphin Cecil B. Moore Girard

Girard

Fairmount 69th St. Terminal

Millbourne

63rd 60th

56th 52nd

1.25

2.5

Spring Garden 46th

40th

Spring Garden

Chinatown 15th 13th 8th 5th 2nd Walnut-Locust11th Miles Lombard-SouthCity Hall

34th 30th

Race-Vine

Ellsworth-Federal

Berks

0 - 50 51 - 75

76 - 104 (mean: 104) 3.Transit Oriented Development Potential 105 - 200 Study in Philadelphia 201 - 300 301 - 2000 2001 - 4835

Criteria Score Subway Station Buffer 1.11538462 - 2.03846154

Tasker-Morris

2.03846155 - 2.57692308

Snyder

2.57692309 - 2.88461538

Oregon

2.88461539 - 3.38461538 3.38461539 - 4.73076923

Patson��

Philadelphia Block Stabilization Program City of Philadelphia Redevelopment Authority Internship | 2013 | Philadelphia

Vision

Market Value Analysis

Identify tax delinquent properties in decent neighborhoods; obtain site control through conservatorship, rehabilitate, and sell the property – paying off municipal liens, cost of rehabilitation, and offering a profit to the owner of record.

Target Property

CDE_Properties

2010-2011 MVA MVA A B C D E F G H I

Methodology Identify tax delinquent properties with taxes<$10K located in TRF ranked C and D neighborhoods that have a vacancy violation on them by the License and Inspections.

Work Flow A Data Acquisition

1. Market value analysis (MVA) data from The Reinvestment Fund (TRF) 2. Tax delinquent properties data 3. Vacancy violation by the License and Inspections 4. Zillow 5. Google map

Insufficient data

Target market value type CDE

42 vacant buildings

Filter tax delinquent properties

in market type CDE

Filter vacancy violation selection

Identify proper Property for fixing

1. Choose Properties within market value type = C or D or E 2. Choose Properties: Tax Delinquent < $10,000, Year >= 2 3. Choose vacant buildings from vacancy violation data 4. Take closer look at property from Google map

Economic analysis for targeted properties

1. Get property characteristics 2. Estimate build out fee 3. Calculate Profit fro PRA and the owner

Team: Laura Rung-Er Jang, Qianqian Zhao Build Out Profit

Positive Profit

id R ge e Av nu ge

dA ve

id R

e Fra

fo r

e Av

8 2

´ Properties_Possitive Profit

´ 12

Properties_Possitive Profit

16 17

Properties_Negative Profit

Washingt on

Avenue

14 15

Profit = Estimate Sale Price – Tax Delinquent – Last Sold Price – Build Out Fee

Assume that Build Out Fee = $100 / SQFT PRA will get $20 per square foot

id R

Property Details

ge e Av nu e

TRF Market Value Type C

21 vacant buildings

with positive profit

Summary: Location & Profit 1

dA ve

id R

875 N STILLMAN ST

Fra

for

e Av

8 2

5 4

´ 12

Zoning

Estimate rent 17 21 Estimate 20 price e 19 sale

$1,641

630

Build out18($100)

$84,000

1920

Profit for owner

$146,658

Building Type

Condo

$16,800

Bedrooms

Profit 14 for PRA 15 Build out ($125)

Bathrooms Date of Last sold

Profit for PRA

$125,658

11 RSA-5

Washingt

Area

840

Lot Year built

´ ´

on Avenu

10/1/1967 Profit for owner

Price of last sold

$24,746

Tax Del Mortgage

$260,890

$105,000 10

$21,000

Build out ($150)

$126,000

$5,486

Profit for owner

$104,658

Profit for PRA

$25,200

9 8

Cluster A

id R ge e Av nu e

TRF Market Value Type D 12 11

dA ve

id R

809 N TANEY ST

Fra

for

e Av

16 1721 19 20 18

14 15

8 2

3 5

Zoning Area Lot

´ 12 RSA-5 11

Estimate rent 16

17 sale price Estimate Washi 1512 21 ngton Ave nue 20

$1,685

Build out ($100)

$151,200

Profit for owner

$3,777

Building Type

1920 Single Family 2

Profit for PRA 14 Build 15 out ($125)

$30,240

Bedrooms Bathrooms Date of Last sold

Profit for PRA

-$34,023

$132,704

Profit for owner ($150)

$37,800

Price of last sold Tax Del

$4,050

Profit for owner

-$71,823

Mortgage

Profit for PRA

$45,360

4/3/2013

Build out 13

Sales Revenue

Delinquent Taxes

Cluster A

-$121,548

-$32,493

Cluster B

-$97,098

-$45,420

Other

-$157,450

Total

-$376,096

$291,731

1620

Year built

Cluster B

$189,000

$226,800

Outstanding Debt

Build Out Fee($100/sqft)

Estimate sale price

Net to owner

PRA build out profit

-$29,600

-$1,013,500

$1,469,151

$272,010

$202,700

-$24,900

-$1,782,000

$2,826,747

$877,328

$356,400

-$10,439

-$3,740

-$353,000

$706,824

$182,195

$70,600

-$88,352

-$58,240

-$3,148,500

$5,002,722

$1,331,534

$629,700

Philadelphia Commercial Corridor Enhancement City of Philadelphia Redevelopment Authority Internship | 2013 | Philadelphia

VISION

For the purpose of intensive investment by PRA owned development non- profit, identify the underperforming corridors and bring their performance to average. Build out critical mass, rent at market rate, the residential and rent the commercial at a subsidized rate.

GOAL

- More business - More residents - Higher employment - Less Crime - Better Scholastic achievement

APPROACH

Identify underperforming commercial corridor in transactional neighborhoods. Target pilot areas ,define opportunity (including economic impact analysis)

I. Data Collection

1. Commercial Corridor Analysis 2008 from Econsult solutions 2. Commercial data 20092012 from UPenn Wharton GIS Lab 3. Zoning data 4. Vacancy properties from Department of License and Inspections (L&I) 5. Market properties available for sell or lease

II. Identify Commercial Corridor need to be enhanced

Select the corridors below the average based on the following analysis - Commercial use percentage - Number of business - Number of business change - Business change percentage - Square foot per business - Sum of Sales value

III. Target proper properties

- Vacant binding - Vacant lots - Properties available for sale - Properties available for lease

Team: Laura Rung-Er Jang, Sonal Tiwari

Commercial Use

Business Change 2009-2012

Commercial Use in Corridor (sqft)

Commercial Use in Corridor (%)

Source: Wharton GIS Lab Year: 2012

Number of Business Change 2009-2012

Percentage of Business Change 2009-2012 Source: Wharton GIS Lab Year: 2012

Source: Wharton GIS Lab Year: 2009/2012

Commercial Use (sqft)

Percentage of Business Change

Number of Business Change

Commercial Use (%)

0 - 250,000

0% - 13%

14 - 162

26% - 1000%

250,001 - 300,000

14% - 25%

1 - 13

17% - 25%

300,001 - 560,000 (mean: 554,041)

26% - 33% (mean: 33%)

-5 - 0

1% - 16% (mean:16%)

560,001 - 2,000,000

34% - 65%

-115 - -6 (mean: -6.3)

-3% - 0%

2,000,001 - 10,908,576

66% - 100%

-275 - -116

-9% - -4% -14% - -10%

-1,014 - -276

-71% - -15%

-1,015 0

1.25

2.5

5 Miles

1.25

2.5

5 Miles

1.25

2.5

5 Miles

1.25

2.5

5 Miles

Business Scale

Total Sale Volume

Total Number of Business 2012

Square Feet per Business

Sum of Sales Value 2012

Source: Wharton GIS Lab Year: 2012

Square Feet 0 - 2,000

2012 Total Number of Business

2,001 - 3,000 3,001 - 5,500

0 - 50

5,501 - 10,000

51 - 75

10,001 - 17,181 (mean: 18,171sf)

76 - 104 (mean: 104)

17,182 - 100,000

105 - 200

100,001 - 1,578,685

201 - 300

Sales Value $0 - $10,000 $10,000 - $60,000 $60,000 - $150,000 $150,000 - $250,000 $250,000 - $357,000 (mean: $356,778)

301 - 2000

$357,000 - $2,650,000

2001 - 4835

$2,650,000 - $53,978,328 0

1.25

2.5

5 Miles

1.25

2.5

5 Miles

16 Commercial corridors are

1.Bustleton/Somerton Center

below the average of economic impact analysis 6.Germantown Ave./ Gorgas-Upsal

3.Rising Sun Ave./ Crescentville 2.Frankford Ave./ Holmesburg 7.Germantown Ave./ High-Upsal 4.Frankford Ave./ Margaret-Orthodox 8.East Falls 5.Frankford Ave./ Church St.

12. 40th and Lancaster

9.Girard and Ridge 11.Girard Avenue 10.Broad and Ridge

13. 36th and Lancaster 14. 54th and Woodland 16. Point Breeze Avenue 15. Woodland Avenue

1.25

2.5

5 Miles

Transit Oriented Development Potential Study in Philadelphia Modeling Geographic Objects Final Project, University of Pennsylvania| 2011 | Philadelphia

Purpose and Goals

Philadelphia is a city with successful public transit system compared with most cities in United States with a relatively stable source of customers and physical infrastructures for Transit Oriented Development. Our study identifies Subway Lines as the primary source of transit facility in promoting TOD because they have high capacity, high speed and a large service area. The current subway lines, Market-Frankford Line and Broad Street Line, have a considerable number of passengers and have a relatively stable traffic flow on a daily basis. This enables condensed economic and social activities around the stations. Moreover, the current land use around the stations show signs of Transit Oriented Development with small proportions of mixed use and retail.

Inspired by the availability of transit facilities, stability of passenger source and composition of land use, we launch this study on Transit Oriented Development potential of Philadelphia. We intend to propose to the city government the potential to promote TOD in certain areas. Ideally, the development of TOD will draw economic investment, promote efficiency and mobility, and reduce carbon footprint. Our goals include: determining how the features of the land around the transit nodes decide the potential for TOD; analyzing how suitable and reasonable for the city of Philadelphia to promote TOD; identifying the nodes that have the most potential for TOD.

1. Creat Study Zone

This study aims at creating a typology that classifies station areas based

on their TOD potential. Public transit nodes are the center of Transit oriented development. In our very first step, we try to decide what should be the â&#x20AC;&#x2DC;anchorâ&#x20AC;&#x2122; of our TOD study zone. We look into public transit system of Philadelphia including bus and subway station, regional railway station on 30th and 11th street, and decide to study subway stations of Market-Frankford line and Broad Street Line. These two underground rail lines each runs through the city, connect center city to north, south, east and west, which makes them the major public transit choice for commuters. Subway stations area prime choice for Transit Oriented Development, so as to this study. Regional rail stations on 11th and 30th street are overlapped with subway stations, they were actually included in this study when we looked at subway stations.

Fern Rock Trans. Center Olney!

! !

Station

Logan

Wyoming

Frankford Terminal

Margaret/Orthodox

Hunting Park

400 m

Church

Erie

Erie/Torresdale

Alleghney

Tioga

Allegheny

North Philadelphia

Somerset ! Huntingdon Susquehanna-DauphinYork-Dauphin !

Cecil B. Moore

Girard

Berks

Girard

Fairmount

Spring Garden

Millbourne

! 63rd60th 56th 52nd !69th St.!Terminal ! 46th ! 40th 34th ! ! 30th ! ! !

Race-Vine

Spring Garden

Chinatown

15th13th !! ! ! !8th 5th 2nd ! ! City Hall11th ! Walnut-LocustLombard-South

Ellsworth-Federal

Choose the lines and station Map the route

Create study zone

! !

Tasker-Morris

Snyder

Oregon

Legend

Pattison

Population density

Employment

Travel to work

Land use

Land value

SEPTA Subway Station SEPTA-Market Frankford Line SEPTA-Broad Street Line

Develop criteria

Regional Rail Lines Fairmount Park

Intensity

Economic prosperity

Source of ridership

Vibrant community

Future demand

0 0.5

Miles 4

Hydrology Subway Station Buffer

The study zone is created by drawing a 400-meter buffAnalyze data

Weight the criteria Overlay all criteria

Conclusion

Maps of sites with TOD potential

er around each subway station. Our study zone is designated to be an ideal area to support Transit Oriented Development. A 400 meter radius of buffer based on a 10-minute walking distance is adopted because it is a good measure for the commercial catchment of a subway station. Those study zones become basic analysis unit in this study.

Team: Laura Rung-Er Jang, Xinlin Huang, Yao Lu 2. Develop Criteria

Vehicle Non-availability

Travel by Subway

Walkability

Time Travel to Work

What constitute an ideal TOD site? The essences of TOD

are easy to catch: density, mix land use and walkability. However, these do not tell the whole story of how to identify a potential TOD site. This study adopts basic demographic, economic and urban physical form features as criteria of analyzing TOD potential. The criteria include density, economic prosperity, walkability, zoning, and existing and potential public transit ridership. Population Density

Olney

Fern Rock Trans. Center

Spring Garden 46th

40th

34th 30th

Lombard-South

63rd 60th

56th 52nd

City Hall Walnut-LocustLombard-South

Subway Station Buffer

40th

Ellsworth-Federal

5 Patson��

Rent

House Value

Spring Garden 34th 30th

Race-Vine

Fern Rock Trans. Center

Olney

Alleghney

Tioga Allegheny

Berks

Cecil B. Moore Girard

Girard

Ellsworth-Federal Tasker-Morris

69th St. Terminal

Millbourne

63rd 60th

Income Criteria

56th 52nd

Spring Garden 46th

40th

Race-Vine

34th 30th

Berks

69th St. Terminal

Millbourne

Rent Criteria

63rd 60th

56th 52nd

Spring Garden 46th

40th

Race-Vine

34th 30th

Berks

Cecil B. Moore

Millbourne

63rd 60th

56th 52nd

Spring Garden 46th

40th

Race-Vine

34th 30th

Ellsworth-Federal

Tasker-Morris

Snyder

Oregon

Patson��

3. Weight Criteria

Patson��

Land Use Criteria Subway Station Buffer 1 2 3 4

Patson��

Spring Garden

Chinatown

15th 13th 8th 5th 2nd Walnut-Locust11th Lombard-SouthCity Hall

Subway Station Buffer

Berks

Girard

Fairmount 69th St. Terminal

House Value Criteria

Allegheny

Somerset Huntngdon� York-Dauphin

Girard

Ellsworth-Federal

Tasker-Morris

Susquehanna-Dauphin

Spring Garden

Chinatown

15th 13th 8th 5th 2nd Walnut-Locust11th Lombard-SouthCity Hall

Subway Station Buffer 1

Ellsworth-Federal

Cecil B. Moore

Fairmount

Spring Garden

Chinatown

15th 13th 8th 5th 2nd Walnut-Locust11th Lombard-SouthCity Hall

Subway Station Buffer

Tioga

North Philadelphia

Somerset Huntngdon� York-Dauphin

Girard

Fairmount

Spring Garden

Chinatown

Frankford Terminal Margaret/Orthodox

Erie/Torresdale

Alleghney

Tioga Allegheny

North Philadelphia Susquehanna-Dauphin

Church

Erie

Erie/Torresdale

Alleghney

Allegheny

Somerset Huntngdon� York-Dauphin

Huntng Par k�

Church

Erie

Tioga

North Philadelphia Susquehanna-Dauphin

Logan Wyoming

Frankford Terminal Margaret/Orthodox

Huntng Par k�

Church Erie/Torresdale

Fern Rock Trans. Center

Olney

Logan Wyoming

Frankford Terminal Margaret/Orthodox

Huntng Par k� Erie

Somerset Huntngdon� York-Dauphin

Land Use

Fern Rock Trans. Center

Olney

Logan Wyoming

Frankford Terminal Margaret/Orthodox Church Erie/Torresdale

Snyder

Patson��

Oregon

Patson��

Tasker-Morris

Patson��

Fern Rock Trans. Center

Cecil B. Moore

Subway Station Buffer

Ellsworth-Federal

Girard

TimeTravel toWork Criteria

Lombard-South

Ellsworth-Federal Tasker-Morris

Spring Garden

Race-Vine Chinatown 15th 13th 8th 5th 2nd Walnut-Locust11th City Hall

Fairmount

34th 30th

Snyder

15th 13th 8th 5th 2nd Walnut-Locust11th Lombard-SouthCity Hall

Subway Station Buffer

40th

Oregon

Berks

Tasker-Morris

Girard

Spring Garden 46th

Alleghney

Ellsworth-Federal

Tasker-Morris

56th 52nd

North Philadelphia

40th

63rd 60th

Snyder

Susquehanna-Dauphin

46th

Millbourne

Oregon

Olney

56th 52nd

69th St. Terminal

Walkability Criteria Subway Station Buffer

Lombard-South

Berks

Cecil B. Moore

Fairmount

Spring Garden

Race-Vine Chinatown 15th 13th 8th 5th 2nd Walnut-Locust11th City Hall

Wyoming

63rd 60th

34th 30th

Huntng Par k�

Millbourne

40th

Girard

Spring Garden 46th

Ellsworth-Federal Tasker-Morris

69th St. Terminal

56th 52nd

Snyder

Patson��

Employment Criteria

63rd 60th

Oregon

Erie

Spring Garden

Race-Vine Chinatown 15th 13th 8th 5th 2nd Walnut-Locust11th Lombard-SouthCity Hall

Millbourne

Subway Station Buffer

Allegheny

34th 30th

69th St. Terminal

Travel by Subway Criteria

Lombard-South

Berks

Cecil B. Moore

Fairmount

Spring Garden

Race-Vine Chinatown 15th 13th 8th 5th 2nd Walnut-Locust11th City Hall

Somerset Huntngdon� York-Dauphin

Girard

Spring Garden 46th

34th 30th

Ellsworth-Federal Tasker-Morris

Erie/Torresdale

Cecil B. Moore

Millbourne

40th

Girard

Spring Garden 46th

Tioga Allegheny

North Philadelphia Susquehanna-Dauphin

Snyder

Tioga

Fairmount 69th St. Terminal

Population Density Criteria

56th 52nd

Logan

Girard

63rd 60th

Frankford Terminal Margaret/Orthodox Church Erie/Torresdale

Alleghney

Tioga Somerset Huntngdon� York-Dauphin

Oregon

Somerset Huntngdon� Susquehanna-Dauphin York-Dauphin

Spring Garden

Race-Vine Chinatown 15th 13th 8th 5th 2nd 11th

Millbourne

Subway Station Buffer

Fern Rock Trans. Center

Huntng Par k� Erie

Allegheny

North Philadelphia Susquehanna-Dauphin

Berks

Cecil B. Moore Girard

69th St. Terminal

Vehicle Non-availability Criteria

Olney Logan

Wyoming

Frankford Terminal Margaret/Orthodox Church Erie/Torresdale

Alleghney

Tioga Somerset Huntngdon� York-Dauphin

Fairmount

Spring Garden

Race-Vine Chinatown 15th 13th 8th 5th 2nd Walnut-Locust11th City Hall

Frankford Terminal

North Philadelphia

Berks

Cecil B. Moore Girard Fairmount 56th 52nd

40th

Fern Rock Trans. Center

Huntng Par k� Erie

Allegheny

North Philadelphia Susquehanna-Dauphin

Girard

Spring Garden 46th

Church

Alleghney

Tioga Allegheny

Somerset Huntngdon� Susquehanna-Dauphin York-Dauphin

63rd 60th

56th 52nd

Margaret/Orthodox

Huntng Par k� Erie

Erie/Torresdale

Alleghney

Allegheny

Berks

Cecil B. Moore

63rd 60th

Olney Logan

Wyoming

Frankford Terminal Margaret/Orthodox Church Erie/Torresdale

Alleghney

Tioga

Girard Millbourne

Fern Rock Trans. Center

Huntng Par k� Erie

Somerset Huntngdon� York-Dauphin

Fairmount 69th St. Terminal

Logan

North Philadelphia

Millbourne

Alleghney North Philadelphia

Fern Rock Trans. Center

Olney

Olney Logan

Wyoming

Frankford Terminal Margaret/Orthodox Church

Income

Wyoming

Frankford Terminal Margaret/Orthodox Church

Fern Rock Trans. Center

Erie/Torresdale

Susquehanna-Dauphin

Employment

Logan Wyoming Huntng Par k� Erie

69th St. Terminal

Olney Logan

Wyoming Huntng Par k� Erie

Patson��

Each criteria for a study zone is summarized by assigning a score range from 1 to 5. The higher the score, the higher level of potential it is. The 52 study zones are divided by means of quantile. Olney

Fern Rock Trans. Center

Considering the different level of importance of criteria, we weigh dif-

Logan Wyoming

Frankford Terminal Margaret/Orthodox

Huntng Par k�

Church

Erie

Erie/Torresdale

Alleghney

Tioga

North Philadelphia Susquehanna-Dauphin

Somerset Huntngdon� York-Dauphin

Cecil B. Moore Girard Millbourne

63rd 60th

56th 52nd

Spring Garden 46th

40th

Race-Vine

Spring Garden

Chinatown 15th 13th 8th 5th 2nd Walnut-Locust11th Lombard-SouthCity Hall

34th 30th

Ellsworth-Federal Tasker-Morris

Potential Zone for TOD

Berks

Girard

Fairmount 69th St. Terminal

Allegheny

ferent criteria based on their effectiveness in promoting TOD. Since the critical features of TOD include dense, wakable and mixed use, we assign population density, land use, walkability and subway ridership the highest weight of 5 and each of the other criteria are weighed 1.

Girard

Criteria Score

O !

1.11538462 - 2.03846154 2.03846155 - 2.57692308

Snyder

2.57692309 - 2.88461538

Oregon

2.88461539 - 3.38461538

Girard O !

Subway Station Buffer

Fairmount

Spring Garden

O ! O !

56th

Spring Garden O !

52nd

46th

O !

3.38461539 - 4.73076923

O !

Race-Vine

40th O !

Patson��

34th

O !

30th

Chinatown

O !

15th 13th O! ! 8th O ! O Hall 5th O11th ! ! City 2nd O O ! O ! Walnut-Locust 8th Ridge Spur O !

Lombard-South

High

Low

O !

Legend

The formula for final score

O !

(Population Density*5 + Land Use*5 + Walkability*5 + Travel by Subway*5 + Income + Employment + Rent + House Value + Time Travel to Work + Average Percentage of Household with no Vehicle Available) / 26

SEPTA Subway Station SEPTA-Market Frankford Line

Ellsworth-Federal

O !

SEPTA-Broad Street Line TOD_area

Tasker-Morris

Philadelphia Neighborhoods

O !

Census tract Snyder

O !

0.5

Miles

O !

Oregon