LandStat: Land Record Data Analysis Application City of Philadelphia: Department of Records

1
LandStat Land Record Data Analysis
ApplicationCity of Philadelphia Department of
Records
2
Background

• Data extracted from
• PhilaDox
• Tax Parcel GIS Map
• BRT (property type only)
• Data aggregated to Geographic Levels that
  include
• City Council Districts
• Zipcodes
• Wards
• Census Tracts
• Census Blockgroups
• 44 indicators in 5 categories
• Deed
• Condominium
• Mortgage
• Property Type (based on BRT)
• RTT Tax
• 9 years of data through FY09
• 742,080 total records

3
Home Page
4
Select Geographic Level
5
Select Category
6
Select indicators and years
7
Add indicators and name the Project
8
Choose a way to view the Project
9
Change indicators
10
Zoom in/out, Pan, Print, Save, export as PDF
11
Turn on Map Layers
12
Change Map Breaks and Colors
13
Bookmarks save map extents
14
Bookmarks attached to user account
15
Table display
16
Overview / Index map
17
Trend chart example 1
18
Trend chart example 2
19
Trend chart example 3
20
Filter columns
21
Summary statistics and histogram
22
Comparison statistics
23
Scatter plot
24
Scatter plot Third Variable change dot size
25
Ranked Lists
26
Data Dictionary link
27
Data Dictionary by Time
28
Data Dictionary by Geographic Level
29
User Account
30
User Account Page - Data
31
Address Groups Upload or Manually Enter
32
Address Groups - Uploading
33
Address Groups Enter manually
34
Address Groups display on map
35
Generating Reports
36
Select a place, then select a report type
37
Select a Geographic Level
38
Name report and select indicators
39
Single Area Report census tract example
40
Single Area Report zip code example
41
PDF Report
42
Multiple area report use map to select areas
43
Multiple Area Report select by rectangle
44
Multiple Area Report select by radius
45
Multiple Area Report add/remove areas
46
Name report and select indicators
47
Multiple Area Report
48
Administrative Console
49
Activity Dashboard
50
Edit Site Configuration
51
Additional Capabilities
KIF has additional functionality thats not
currently being used in the LandStat application,
including
52
Additional Capabilities - Data
The KIF database can accommodate hundreds of
indicators, millions of records and dozens of
levels of geography. LandStat might be extended
to

• Store, analyze and publish data from PhillyStat
• Publish recovery projects
• Add data from
• LI permits, licenses and violations issued
• Streets recycling rates, litter index, potholes
  repaired
• Parks Recreation tree conditions
• Revenue real estate tax collected, delinquent
  accounts
• BRT sales, exempt properties, median sale price

53
LandStat Land Record Data Analysis
ApplicationCity of Philadelphia Department of
Records