1 / 26

Geomatics and FME: Corporate Insights from the City of Calgary

Explore the role of geomatics within the City of Calgary's municipal government, focusing on the integration of GIS analysis and FME technology. This presentation by Nadia Shahriari Namini discusses the city's demographic growth, its various departments, and how the Geomatics Division supports multiple IT projects through data conversion and analysis. Key highlights include challenges, technologies in use, and the importance of effective data management in waterworks and wastewater asset management. Gain valuable insights into the practical applications of geomatics in urban planning and service delivery.

latham
Télécharger la présentation

Geomatics and FME: Corporate Insights from the City of Calgary

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. v FME Worldwide User Conference - Vancouver Sep. 21, 2006 Geomatics and FME from a Corporate Perspective Nadia Shahriari Namini – City of Calgary, Alberta

  2. City of Calgary • Population ~ 1,000,000 • 22,583 growth last year • Area - 286 square miles and growing • Hosted 1988 Winter Olympics • Home of the Calgary Stampede • Alberta’s main industries are oil, gas and cattle

  3. The City of CalgaryMunicipal Government • City Council • Mayor and 14 Aldermen • Municipal Administration • City Manager, 6 Major Departments, 27 Business Units • 11,733 Employees

  4. How Does Geomatics Fit In?

  5. Geomatics Division

  6. GIS Analysis • Provides data conversion/GIS analysis services to numerous IT projects and Business Unit clients • Responsible for loading and QA of numerous datasets to Corporate SDE (~350 SDE layers)

  7. GIS Analysis (Cont.) • Numerous technologies: FME, ArcGIS, ArcSDE, AML, Pro-C, PL/SQL, … • Batch jobs: nightly, weekly, monthly,… • Ad-hoc processes

  8. Calgary Transit CLIENTS Water Services Water Resources Roads Parks Fire Police Trans. Planning Urban Development Assessment LIM-CDAM Development & Building Approvals Information Technology LIM- Infrastructure Information

  9. SERVICES Quality Assurance Data Schema Change Maintenance of more than 350 Corporate SDE layers Spatial/Non-Spatial Data Integration/Conversion GIS Analysis Consultation Data Conversion Consultation Data Translations / Transformations Spatial/Non-Spatial GIS Analysis

  10. SDE Layers • 56 Legal Survey Fabric (LSF) Layers • 10 Ownership Parcel Fabric (OPF) Layers • 2 Address POSSE Layers • 44 Digital Aerial Survey (DAS) Layers • 6 Road Network (RoadNet) Layers • 42 Waterworks Layers • 16 Sanitary Layers • 26 Storm Layers • 15 Layers for Transit/Transportation • 14 Layers for Calgary Parks • 5 Layers for Calgary Fire • 7 Layers for Calgary Police • 31 Layers for Calgary Census • 8 Layers for Calgary Schools • …..

  11. Example Projects • Trip Planning Application • Street Lighting Enterprise Geodatabase • Permitted Use Building Envelope Analysis • Open Space GIS Analysis • Parks Asset Management • Waterworks and Wastewater Asset Management • …..

  12. Waterworks and Wastewater Asset Management • Waterworks: a multi-million dollar public utility that manages all aspects of the water treatment and delivery process for The City of Calgary. • Wastewater: responsible for the design, construction, and maintenance of two separate collection systems: • Storm drainage system: helps prevent flooding by diverting rain and snow melt. • Sanitary system: protects public health and the environment by collecting and treating wastewater from residences, schools, hospitals, businesses, and industries.

  13. Waterworks and Wastewater Asset Management • Source data sets: • MicroStation Design files (387 sections) • Oracle database (about 100 tables) • Destination data sets: • 39 Water Works SDE layers • 14 Sanitary SDE layers • 24 Storm SDE layers

  14. Sample Source DGN Files

  15. Storm Sanitary Waterworks Database Schemas

  16. Old process: ARCSDE commands DGN files AML Scripts Coverages SDE layers Oracle DB New process: DGN files FME SDE layers Oracle DB Waterworks and Wastewater Asset Management

  17. FME Processes Destination Data Sets Source Data Sets • Data filtering • Data Integration • DB tables Join • DB to DGN Join • Geometric Operations • Linear Referencing • Data Manipulation • Overlay Analysis • … Waterworks and Wastewater Asset Management

  18. Utilized FME Tools • 4 Filtering Transformers: Perform tests on feature geometry/attribute and route the features to different ports. • 9 Geometric Transformers: Operate on the geometry of individual features /groups of features. • 9 String Transformers: Operate on character strings. • 1 Linear Referencing Transformers: Create and apply measure related information onto the geometry. • 3 Collector Transformers: Operate on collections of features at a time.

  19. Utilized FME Tools (Cont.) • 8 Manipulator Transformers: Modify the geometry/attribute of individual features. • 2 Database Transformers: Allow interactions with external databases. • 6 Infrastructure Transformers: Interaction with the underlying FME engine facilities. • 6 Calculator Transformers: Calculate a value and supply it to a new attribute. • 8 List Transformers: Operate on FME attribute lists.

  20. Quality Assurance/Quality Control

  21. Summary • FME Workspaces: • 20 for Water Works • 16 for Sanitary • 20 for Storm • Batch files: 3 batch files • Running time: ~10 hrs. • Intel Pentium 4 CPU 2.80 GHz 2.00 GB of RAM • Output Data sets: 77 SDE layers

  22. Challenges • Backward Compatibility (with older versions) • Line-linked vs. Point-linked Annotation • StringReplacer and StringPairReplacer • Help Document • Data cleaning (MRFCleaner transformer)

  23. What Do We Like about FME? • Easy to maintain • Easy to document • Data Integration from Multiple sources • Multiple Destination datasets • No intermediate data sets required • Complex spatial and non-spatial analysis all in a single FME workspace • QA/QC processes • Batch mode • Safe Software Support • FUN …

  24. Thank You.

More Related