using fme to build an enterprise geodatabase
DESCRIPTION
A recent project at the City of Barrie involved building a Geodatabase for Land Parcel Base and Planning datasets. This Geodatabase is a foundation that is part of an overall plan to build an Enterprise GIS Server that is linked to multiple business systems and web applications. The presentation will provide an overview of the project approach, and discuss some of the challenges and solutions getting 12 large CAD drawings into the target data model using FME.TRANSCRIPT
![Page 1: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/1.jpg)
Using FME to Build an Enterprise Geodatabase
Steve Grisé Geo Solution Architect and Founder, Vertex3 Inc.
2010:An FME
Odyssey
![Page 2: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/2.jpg)
Project Purpose
Build an Enterprise Database Parcels integrated with Finance Addresses integrated with Permitting Planning vertical aligned with Parcels
Move from 12 large CAD drawings, multiple shapefiles, and multiple copies of data/maps
Set a foundation for other projects such as asset/work management
![Page 3: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/3.jpg)
Source Data
![Page 4: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/4.jpg)
Target Data Model
![Page 5: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/5.jpg)
Target Data Model
![Page 6: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/6.jpg)
Target Data Model
![Page 7: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/7.jpg)
Challenges and Solutions
![Page 8: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/8.jpg)
Address Points
Rotated text in CAD (Magenta) STNUMBER layer No identifiers
![Page 9: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/9.jpg)
Solution
![Page 10: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/10.jpg)
Boundary Line Types
![Page 11: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/11.jpg)
Boundary Line Types
Source CAD Layer Feature Class Boundary Type Carto Line Type SourceType
PCL_ASSUMED ePARCEL_BOUNDARY Parcel Assumed Right of Way Unknown
PCL-‐UNASSUMED ePARCEL_BOUNDARY Parcel Unassumed Right of Way Unknown
PCL-‐URA ePARCEL_BOUNDARY Parcel Unopened Road Allowance Unknown
PCL-‐PL ePARCEL_BOUNDARY Parcel Plan Registered Plan
PCL ePARCEL_BOUNDARY Parcel Parcel Other
PCL-‐RAIL ePARCEL_BOUNDARY Parcel Rail Other
PCL-‐CON ePARCEL_BOUNDARY Parcel Concession Other
CON-‐LT ePARCEL_BOUNDARY Parcel Concession -‐ Lot Other
ROW ePARCEL_BOUNDARY Parcel Private ROW Other
PCL-‐RDCL ePARCEL_BOUNDARY Parcel Closed Road Other
PCL-‐PRIVATE ePARCEL_BOUNDARY Parcel Private ROW Other
PCL-‐LAKE ePARCEL_BOUNDARY Parcel Water Unknown
EASEMENT ePARCEL_BOUNDARY Easement Easement Other
RESERVE ePARCEL_BOUNDARY Reserve Reserve Other
PCL-‐LAKE eWATER_LINE N/A N/A N/A
PL-‐LT eHISTORICAL_LOT N/A N/A N/A
ROAD EXTENSIONS eROAD_EXTENSION N/A N/A N/A
LAKE eWATER_LINE N/A N/A N/A
CITY_BOUNDARY eMUNICIPAL_BOUNDARY_LINE N/A N/A N/A
CITY_BOUNDARY eMUNICIPAL_BOUNDARY N/A N/A N/A
![Page 12: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/12.jpg)
Solution
![Page 13: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/13.jpg)
Parcels/Roll Numbers
Parcel lines Roll Number text (multi-value) Parcel Polygons/Topology in target Also Lot/Block text/pointss
![Page 14: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/14.jpg)
Solution
![Page 15: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/15.jpg)
Annotation
Annotation relatively clean and consistent in source data Layers Attributes
ArcGIS Desktop reads CAD Annotation well Import option to do the same in FME Performance on load…
![Page 16: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/16.jpg)
Solution
![Page 17: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/17.jpg)
Automation
Multiple loads to refine load process and data model
Mapping files a deliverable of the project Final load to occur after project completion
![Page 18: Using FME to Build an Enterprise Geodatabase](https://reader033.vdocuments.us/reader033/viewer/2022052311/557dac43d8b42a351d8b48ea/html5/thumbnails/18.jpg)
Solution
.bat files to run individual models for all CAD drawings:
REM loop through Land Parcel Base dwg files and load boundary features using FME mapping file in this folder for %%f in ("Land Parcel Base/*.dwg") do "c:\program files\fme\fme.exe" "1. Boundaries.fmw" --
SourceDataset_ACAD "Land Parcel Base/%%f" --DestDataset_GEODATABASE_FILE "Barrie.gdb" --LOG_FILE "%%f_load.log"
Spreadsheet to document steps for loading