Skip to main content
Cartegraph Campus

Floor Plan Lines to OMS Cheat Sheet

This resource will help you convert CAD drawings to GIS in order to load them into OMS. For advanced data manipulation, or to purchase the automated Floor Plan Updater, contact your Cartegraph representative.

Steps

1.  Organize and rename your CAD drawings

Our tools use the file name to auto-populate the Site>Building>Floor hierarchy. To leverage this, create a separate folder for each site and each building within that site. Then, rename your drawings to represent the full hierarchy, and use underscores between the values. For example, if the site is Dubuque, the building is A, and the floor is 1, the file should be named Dubuque_A_1.dwg. If the site is NYC, the building is 18812, and the floor is 12, the file should be named NYC_18812_12.dwg

2.  Georeference your CAD drawings

To bring your data into GIS, it will need to be georeferenced. You can easily do this in ArcGIS Desktop (ArcMap or ArcGIS Pro) to generate a .wld file, which will be saved in the same directory as your drawing. If all floors for a given building are vertically aligned, you can georeference the first and copy and paste the World file, while renaming, to match the rest. 

3.  Update the Layer Mapping spreadsheet

The layer mapping spreadsheet specifies which CAD elements you want to convert. For floor plan lines, you will want to include all the levels you wish to extract, transform, and load (ETL), as well as the floor area outline. 

4.  Adjust workbench settings

Prior to running, adjust a handful of workbench settings outlined in the Tools section below. 

5.  Run the workbench 

Run the workbench and view the outcome in Data Interop. 

6.  Publish a feature service and sync 

After the processing is complete, you can publish the BuildingFloor and BuildingFloorplanLine feature classes as a feature service, in order to use the GIS sync in OMS to bring data over. Choose the FPLINEID as the unique ID for the Floorplan Line multi-part features. 

The next section, Tools, will help you understand the sample tools provided and how best to use them. 

Tools

Within the FloorplanLineSample.zip, you will find the Desktop Data-Interop workbench, a File Geodatabase, and a sample Layer Map spreadsheet. 

 

The Layer_Map_FPL_example.xlsx spreadsheet has a sample set of typical CAD level names, which are mapped to floor plan lines, as well as a level for the Floor area. Feel free to add or remove floor plan line levels, but make sure to include a level that represents the Floor area (often called GSF). 

The FloorplanLineSample.gdb file geodatabase contains feature classes for loading your floor plan lines and floor data. There are other sample feature classes, but the only two expected are BuildingFloor and BuildingFloorplanLine. 

The InVisionETL.tbx has Data Interop workbenches that can be used to load data. The BuildingFootprints workbench is optional if you want to load buildings from a CAD site plan into GIS. Right-click on the Floor plans workbench and click Edit to open in Esri Data Interop. Once open, you can update a handful of parameters specific to your environment and run the workbench. Prior to running, you will want to update the following parameters:  

  • SourceDataset_ACAD: Set this to the directory where your CAD drawings are stored. This will let you run batch migrations, if you have multiple buildings. 
  • LayerMap: Location of the Layer_Map_FPL_example.xslx, which you have updated. 
  • SourceCS: Source coordinate system you used to georeference. 
  • SourceUnit: Units used in your CAD drawing (inches, centimeters, etc.). 
  • TargetCS: Target cFoordinate system. This should be WGS84 by default. 
  • Dest_Dataset_Geodatabase_File: Location of the sample file geodatabase you wish to write to.  

FPL_OMS_CheatSheet2.png