1	GIS Data Consolidation Anthony Bonnici www.webGISdev.com Sir Sandford Fleming College 6 July 2004
2	Today ’s Demo Background – 15 minutes Web GIS Demo – 20 minutes Data Anomalies – 10 minutes More “WHAT” than “HOW”
3	Basic Street Network Example
4	Basic Street Network Terminology Street Segment – a portion of a street centerline between two adjacent nodes Node – intersection point of two or more segments node not required at overpass/underpass node required for street name change and for dead-end Address Range – upper & lower limits of address numbers on both sides of a segment may not be existing addresses “from” / “to” based on lower / upper numbers respectively “left” / “right” rule: stand at lower-end facing towards upper-end Road Section – a portion of a street with homogeneous physical characteristics (e.g. number of lanes, pavement type/age, speed limit) may consist of any number of street segments, including fractions Route – a directed path through a street network, with start and end points may include separate passes for each side of segments
5	Basic Street Network Database
6	Basic Street Network Database
7	Major Sources of Data MNR Ontario Road Network – spatial TSH Roads Study – street names CKL paper plans – 80, large format BELL Segment List – address ranges CKL Street Atlas – paper & DWG MNR NRVIS data missing segments also buildings and hydrography
8	Minor Sources of Data ES Routing Maps Lindsay routes entered, others by ES ES Landfill Map five active ones entered Pet. County data along east side of CKL Windshield Surveys some data collection in Lindsay
9	Street Segment Workflow 1. Import Attribute & Spatial Data - CKL Roads Study, ORN, BELL 2. Add missing segments from NRVIS 3. Associate ORN with Roads Study - associate street names (macro 1) 4. Alter Segmentation as required 5. Associate ORN with BELL addresses - asscoiate address numbers (macro 2) - reference: CKL plans and street atlas
10
11	Project Results Data Consolidation for ES dept Integrated data from 10 sources System to manage collection routes Some data on landfill sites Street Segment Network for CKL Latest map data Street names and address ranges Solid framework for future GIS layers Orthophotgraphy, OPA Parcel Fabric
12	GIS System “Base” GIS Full access to map data and database Autocad and SQL Server For IT and GIS staff Web GIS Limited access to data MapGuide and ColdFusion/ASP For users in ES, Planning, Engineering…
13	Map Layers Street Segments Street Names and Address Ranges Collection Routes Landfill Sites Supplementary Segments Segment Anomalies Former Municipal Boundaries Buildings Lakes and Swamps
14	Segment Layers No. Name Description 1 Segment - OK Processed 2 Segment - Minor Minor Anomalies 3 Segment - Major Major Anomalies 4 Segment - NOT Not Processed
15	Supplementary Segments No. Name Description 15 SuppSeg - TLA Turn-lane 16 SuppSeg - TAR Turn-around 17 SuppSeg - BRI Bridge 18 SuppSeg - OUT Outside CKL 19 SuppSeg - RED Redundant 20 SuppSeg - ADJ Adjacent
16
17
18
19
20
21
22
23	Archived Layers No. Name Description MNR DATA 9 Junction Nodes 10 BlockPass Gates/fences WORKFLOW DATA 11 Link Line Section to Segment 12 Progress Grid
24	Street Annotation STREET NAMES 22 St Name - large 23 St Name - medium 24 St Name - small 25 St Name - tiny ADDRESS NUMBERS 5 AddNum - large 6 AddNum - medium 7 AddNum - small 8 AddNum - tiny
25	Annotation Settings
26	Database Tables Street Segments (9 tables) ES Routing (4) Landfill Sites (1) Road Sections (3) Anomalies (2)
27	CKL Relational Database Schema
28	Built-in Functionality View Control – zoom, pan, etc Measure Distances and Positions Copy Map Image – into documents Print Map Image Bookmarks – save view configuration Zoom Goto – display segments
29
30
31
32
33
34
35	Custom Functionality Segment Search Based on Ward, Street Name, Address Display on Map and view Report Segment Form View all segment database records Update ES collection data Route Update Assign collection routes to segments selected on the map
36
37
38
39
40	DEMO Web GIS (30 minutes) Base GIS (5 minutes)
41	Resource Summary
42	Resource Summary
43	Data Anomalies Ambiguous Situations Not enough data to resolve all Examples: CKL and TSH data do not match Missing section or segment ORN does not match CKL data BELL address range does not match CKL Missing intersection à new segment All documented in database and map
44	Street Anomalies
45	Street Anomalies
46
47
48	Tony’s “To Do” List Finish Segment Forms Provide corrected data to contributing agencies MNR – streets, names, addresses (done) BELL – corrected address ranges MoH – assistance with verification Upload to CKL Server and Network
49	CKL’s Future… Add Parcel Fabric From OPA (MPAC, Teranet, MNR) Add Ortho-photography From MNR (Oak Ridges Moraine project) On-going verification & maintenance Web GIS college course in summer?