Click to edit Master title styleClick to edit Master title style

Denver Regional Data Consortium (DRDC) MeetingSummer 2016

Presented by:

DRCOG Staff

August 25, 2016

Click to edit Master title styleClick to edit Master title styleAgenda

• Introductions

• Understanding the DRCOG Development Type Model

• DRCOG Data – Updating to a New Projection/Datum

• New Traffic Signal Project Webmap

• Planimetrics: Contributing to OSM & Updates on 2016

Project

• Announcements and Discussion

Click to edit Master title styleClick to edit Master title style

UNDERSTANDING THE DRCOG DEVELOPMENT TYPE MODEL

Click to edit Master title styleClick to edit Master title stylePurpose

DRCOG Board makes policy statements

about the region’s future urban extent,

or “footprint”

Need shared understanding of what

is currently urban

Board-adopted Development Classification

System

Development Type (DevType) Model

Click to edit Master title styleClick to edit Master title styleHistory

Pre-2006

• No system

• No model

• Staff manually applied criteria

2006-2011

• Dev. Class System adopted

• Model run in Model Builder

2012-2013

• Model ported over to Python/Postgis

2015-2016

• Re-evaluate how well model implements Dev. Class System

• Flag issues with Dev. Class System language

Click to edit Master title styleClick to edit Master title styleUrban DevType

Urban DevType

Currently urban

In general, this covers:

• Residential subdivisions with

average lot size less than one acre

• Commercial or industrial subdivisions

• Isolated parcels with more than 50 employees

Metro Vision 2035 Growth and Development Supplement, Extent of Urban

Development – Development classification system (pages 4-5)

Click to edit Master title styleClick to edit Master title style

Downtown Denver Highlands Ranch

ThorntonKen Caryl Valley

Range of Urban DevType

N

Click to edit Master title styleClick to edit Master title styleOther DevTypes

UrbanDevType

Semi-

urbanDevType

Semi-

ruralDevType

RuralDevType

Open

spaceDevType

Click to edit Master title styleClick to edit Master title styleDevType Model Status

• Rebuilt model to follow the Board-adopted language

• Flagged (but not fixed) issues with Board-adopted

language

• Missing or unclear definitions

• Data availability assumptions

• Missing or erroneous rationale

• No guidance for local review

• Ready to run on 2015 datasets

• Parcels

• Subdivisions

• Open Space

• Employment

Click to edit Master title styleClick to edit Master title styleWhat’s next?

Preliminary guidance at Board work session (10/7)

DRCOG staff work to implement fixes in DevType Model

DRCOG Board amends Development Class System

Local review period

Official DevType results

Click to edit Master title styleClick to edit Master title style

UPDATING TO A NEW PROJECTION

Click to edit Master title styleClick to edit Master title styleThe Projection

• NAD 83(2011) State Plane Colorado Central FIPS 0502 FT US

• National Adjustment of 2011

• Aligned NGS passive control physical marks and active control system

(CORS)

• CORS coordinates were re-processed using CORS data collected from

Jan ‘94 to Apr ‘11

• Created new realization NAD83(2011) Epoch 2010.00

• CONUS adjusted with 79,546 stations and 1,113 CORS

• New network accuracy: 0.9 cm horizontal, 1.5 cm vertical at 95%

confidence level

• Median change : about 2 cm horizontally and vertically

http://www.ngs.noaa.gov/web/surveys/NA2011/

Click to edit Master title styleClick to edit Master title styleThe Plan

• Project all enterprise ArcGIS data

• Transform the data twice

• Issues:

• Arcpy 10.1 didn’t recognize new projection

• Shuffling of data

• Project all enterprise PostgreSQL data

• Issues:

• Projection not in spatial_ref_sys table in PostgreSQL

9.3/PostGIS

• GeoServer bug?

• Switch out data on the Regional Data Catalog

Click to edit Master title styleClick to edit Master title stylespatialreference.org

• Online repository for spatial reference systems

• SRID = 6428 (SR-ORG 8670)

• OGC WKT confirmed valid

• GeoServer confirmed valid with some tweaking

• PostGIS confirmed valid with some tweaking

• http://spatialreference.org/

• Also some information here: • http://georepository.com/crs_6428/NAD83-2011-Colorado-Central-ftUS.html

Click to edit Master title styleClick to edit Master title styleWhat This Means For You

• Data from DRCOG will be delivered in this projection

• DRAPP, Planimetrics, Data Catalog, Infogroup, QCEW, etc.

• We encourage your organization to consider moving to the

new realization

• Check with your county surveyor

• Tool to show shifts:

• http://www.ngs.noaa.gov/GEOCON11/

• We are here to help with technical implementation

• We will not be asking for data specifically in this realization

Click to edit Master title styleClick to edit Master title style

THE SIGNAL TIMING BRIEFS MAP

Click to edit Master title styleClick to edit Master title styleTraffic Operations

• The Traffic Operations Program

• coordination between DRCOG, CDOT, and local jurisdictions

• The Traffic Signal System Improvement Program

• Implement cost-effective traffic signal timing and capital

improvements

• Benefits include:

• Reduce travel time

• Reduce auto emissions

• For more information on our Traffic Operations Program,

visit: https://drcog.org/programs/transportation-planning/traffic-operations-program

Click to edit Master title styleClick to edit Master title styleThe Signal Timing Briefs Map

• DRCOG has developed a new web map that shows the

signal timing projects in our region

• Every year, this map will have the last 10 years of project

data

• Select features to get attribution for the project and view

the signal briefs

• Filter features by project year and view annual reports

• http://gis.drcog.org/signaltimingbriefs/

Click to edit Master title styleClick to edit Master title style

PLANIMETRIC PROJECT UPDATE

Click to edit Master title styleClick to edit Master title styleBackground

• In June 2016, DRCOG and 21 partners completed a project to develop planimetricfeatures from the 2014 DRAPP imagery.

• Contributions from DRCOG and a CDOT grant filled in gaps between the 21 partners AOIs – so even if your organization was not a partner, we may have captured data for you!

http://gis.drcog.org/datacatalog/subjects/planimetrics

Click to edit Master title styleClick to edit Master title styleWhat Features?Building Roofprints | Edge of Pavement | Parking Lots |

Sidewalks | Trails | Ramps | Driveways | Limited Hydro

http://gis.drcog.org/datacatalog/subjects/planimetrics

Click to edit Master title styleClick to edit Master title styleData Uses

• Pedestrian routing

• Asset inventories

• Sidewalk availability and

quality studies

• Impervious surface

analysis

• 3D building models

• Municipal mapping

• Special District Mapping

• Phone Apps for the Visually Impaired

• GoCode Colorado Winners Use Planimetrics

• Press release

Click to edit Master title styleClick to edit Master title styleWhere to get the data

• Freely available now on

the DRCOG Regional

Data Catalog!

• Upcoming:

• OSM

http://gis.drcog.org/datacatalog/subjects/planimetrics

Extent

Extent shp

Actual data is here!

Metadata

Click to edit Master title styleClick to edit Master title styleContributing to OpenStreetMap (OSM)

• Purpose = to make this

public domain data as

accessible as possible

• Priorities = building

roofprints and sidewalks

• More info on the wiki

Click to edit Master title styleClick to edit Master title styleContributing to OSM

• Standarize data

• OSM Tasking

Manager

• Roofprints pilot in

October

• Entire roofprints data

in December

• Sidewalks to follow

http://gis.drcog.org/datacatalog/subjects/planimetrics

Click to edit Master title styleClick to edit Master title stylePlanimetric Update Project – Progress!

• What: updating the 2014 planimetric datasets using the

2016 imagery

• When: Q1 & Q2 of 2017, select vendor by November

• Who: 25 potential partners, looking for more!

• Why: To leverage the data we’ve already captured, keep

data current and useful (remember: updates are MUCH

cheaper than new collections from scratch)

• If your organization is interested, please reach out to me at

asummers@drcog.org or 303-480-6746.

Click to edit Master title styleClick to edit Master title styleAnnouncements

• InfoGroup data purchase – upcoming in Jan. 2017

• Join DRCOG at GIS in the Rockies 2016

• Web Gallery

• Career Development Academy

• Next Newsletter = 10/15

• Next DRDC Meeting = 11/17

Click to edit Master title styleClick to edit Master title style

QUESTIONS/COMMENTS?