1 of 38

Rod Reza Sardari, PhD, GISP

Data, Maps & Research

2 of 38

Defining the Framework

2

Define Scope or Issues

Data Engineering & Integration

Scripting & Modeling

Analysis

Visualization,

Storytelling,

Sharing

It is a process

Tableau Server

Tableau Public

Feedback

3 of 38

Outlines

  1. Intro

Data, GIS, Data Visualization, Publications

2. Demand Modeling & Demographic Analysis

Travel Behavior, Spatial Mismatch

3. Urban Planning

Integrated Land Use & Housing Inventory

4. IT Department

    • Power BI Data Visualization
    • Tableau & Tableau Prep
    • Tableau Server Administrator

4 of 38

4

5 of 38

WHERE

WHY

TREND

WHEN

6 of 38

Data

  •  IPUMS National Historical Geographic Information System (NHGIS)

https://www.nhgis.org/

  • Longitudinal Employer-Household Dynamics

https://lehd.ces.census.gov/

  • GTFS: General Transit Feed Specification

https://gtfs.org/

7 of 38

Data Visualization

8 of 38

Data+Maps TUG Meeting

9 of 38

Example: Dallas Fed Surveys Data Visualization

10 of 38

Data Exploration & Publication

11 of 38

12 of 38

A Multilevel Spatial Framework for E-Scooter Collision Risk Assessment

https://www.mdpi.com/2313-576X/11/3/67

13 of 38

Demand Modeling & Demographic Analysis

14 of 38

15 of 38

Spatial Mismatch Hypothesis

16 of 38

17 of 38

Visualizing Spatial Mismatch

18 of 38

Skills Mismatch�Transitions from School to Work

https://lightcast.io/skills-mismatch-full-results

19 of 38

GIS & BI for Urban Planning

20 of 38

Goal

20

Align

Existing Land Use with Future Comprehensive Plan

21 of 38

Comparing Existing Land Use vs. Future Land Use Plan

21

22 of 38

Calculation

22

23 of 38

Solution

23

GIS

BI

R & Python

24 of 38

Data Engineering

24

Department databases: Parcel information, zoning data, property boundaries

Planning Department files: Zoning requirements, development standards, PDF documents

Housing inventory records: Current housing stock, permits, developments

Comprehensive Plan documents: Goals, policies, and requirements

25 of 38

Data Engineering & Data Prep

25

26 of 38

Power BI

27 of 38

28 of 38

APA Implementation Award�City of Plano Future Land Use Map Implementation Tools

28

29 of 38

4. Plano IT Department

29

30 of 38

Example

30

31 of 38

Library Department

31

32 of 38

911 & Public Safety

32

33 of 38

Fire Rescue

33

34 of 38

Fire Rescue Outlier Statistics

34

35 of 38

Automating Data Prep & Workflows

35

36 of 38

Tableau Server Administrator

  • Maintain Tableau Server
  • Security Check-up
  • Backups
  • Activities by users
  • Assign Tableau Licenses
  • Schedule Tasks
  • Control Jobs

37 of 38

Tableau Server Administrator

38 of 38

Conclusion

38