EMERGENCY INFORMATION FDOT Emergency Travel Alert: For information on the current situation, please visit the following page - Alerts.

Traffic Engineering and Operations Office

TEO / Divisions / ITS / TPM / ITSFM / Feature Import /

Feature Import

Picture of a Florida Roadway

ITSFM
Home
Management Responsibility
User Roles
Standards
History
Downloads:
As Built Forms
Data Collection
Feature Import
Quality Construction Checklist
Training

The ITSFM is a geographical information system (GIS) based Web application designed to manage Outside Plant facilities based on their Latitude / Longitude coordinates. All primary point features encoded into the ITSFM should be based on actual Global Positioning System (GPS) Latitude / Longitude coordinate values to provide all stakeholders with the ability to accurately locate equipment statewide.

The purpose of this section is to provide a methodology for entering new data into the ITSFM database. The system recognizes two types of positional features; Primary Point and Primary Linear features. These features can be entered into the database through individual entries or in mass by using the predefined ITSFM Import templates. The following sections describe the types of data and the methodology for importing new data into the database.

feature input globe


Primary Point Features

Primary Point Features

Point features are items with a definable location and are associated to an individual site such as:

  • The Transportation Management Center sites
  • Communication Facility sites
  • ITS field device sites
  • Electrical equipment sites
  • Conduit access points
  • Support structures
  • Field equipment cabinets

These sites house multiple sub features such as communications and electrical equipment, fiber terminations and other components that together comprise the entire assemble. Typically, these features are shown on as-built plans that may not provide all the detailed attributes necessary to document the assembly, thereby requiring a field inventory. See Data Collection for more information about as-built plans, field inventory and the specially designed ITSFM Attribute Forms that define the attribute requirements.

The ITSFM provides for importing primary point feature/attributes and secondary sub feature attributes directly into the database. See Importing Primary Point Features & Sub features for more information.

Primary Linear Features

Primary Linear Features

Linear features include conduit and cables; have a defined start and end point with multiple coordinate values along the feature as it traverses the roadway. Linear features include both electrical and communication conduits and cable.

The ITSFM provides for importing linear features directly into the database. Linear features can be imported as "Primitive Graphics" from electronic Micro Station, Version 7 as-built plans that were created using the Longitude / Latitude WGS 84 coordinates for the installation area. The imported graphics will reside on a different layer and can be converted into new conduit or cable features. When primary linear feature are created, the primitive graphic coordinate value is used to define the features position, then the user is prompted to input predefined attributes about the feature in the form presented. See Importing Primary Linear Features for more information.

Back to Top


Importing Primary Point Features & Sub features

The ITSFM provides for importing primary point feature and secondary sub feature attributes directly into the database using specially designed ITSFM Import Templates produced in MS Excel as shown in the example below:

ITSFM Import Table Example

The ITSFM import templates support the following primary point feature and secondary sub feature attributes.

Primary Point Features

Supported primary point features are infrastructure and equipment sites that have a definable Latitude / Longitude coordinate. These include:

  • The Transportation Management Center sites
    • RTMCs
    • Other Control Centers (City, County, Etc.)
  • Communication Facility sites
    • Remote Communication Hubs
    • Wireless Shelters
  • ITS field device sites
    • Closed Circuit Television Camera (CCTV)
    • Dynamic Message Sign (DMS)
    • Electronic Feedback Speed Sign (EFSS)
    • Highway Advisory Radio (HAR)
    • Highway Advisory Radio (HAR) Sign
    • Roadway Weather Information System (RWIS)
    • Safety Barrier Cable System (SBCS)
    • Signal System (Intersection or Ramp)
    • Travel Time System (TTS)
    • Trail Blazer (TB)
    • Vehicle Detection System (VDS)
    • Warning Beacon (WB)
  • Electrical equipment sites
    • ITS Equipment Cabinets
    • Electric Sites (Load Center, Service, Meter or Disconnect Points)
    • Utility demarcation sites
  • Conduit System Access Points
    • Fiber Splice Vault (FSV)
    • Fiber Pull box (FPB)
    • Electric Pull box (EPB)
  • Support Structure
    • Pole
    • Overhead Structure
    • Cantilever Structure
    • Butterfly Structure
    • Towers
  • Field Equipment Cabinets
    • ITS
    • Traffic Signal (Intersection or Ramp Meter)

Back to Top

Secondary Sub features

Supported sub features are items housed within the primary point features defined above. These sub features include:

  • Equipment Controllers
    • Various types of ITS and Traffic Management equipment
  • Communication Devices
    • Media Converter
    • Multiplexer
    • Port Terminal Server
    • Radio
    • Remote Terminal Unit (RTU)
    • Voter
  • Electric Devices
    • Cabinet Disconnect
    • Cabinet Power Outlets
    • Cabinet Surge Protection
    • Power Management
    • Uninterrupted Power Service
    • Solar Power Service
    • Power Supply
    • Stand-By Generator
    • Surge Protection Device - Data Line, Low Voltage, Video Line
    • Transfer Switch
  • Fiber Device
    • Ethernet Switch / Router
    • Fiber Modem
    • Fiber Transmission Equipment
    • Optical Patch Panel

Back to Top


ITSFM Import Templates

Custom templates have been developed to support the direct importing of Primary Point features and sub features into the ITSFM database. ITSFM Import Templates include:

The following subsections provide a detailed description of each ITSFM Import Template including what features, sub features and attributes are supported within.

Back to Top


ITSFM Master Code Lists

Master Code Lists file is a key file that is required for any Import Template to work. This file and Import Templates must be saved in the same folder.

Form Number Title
Master Code Lists ITSFM Master Code Lists, Version 04/13

Communication Device Import Template

This template provides for importing secondary sub features associated to a primary point feature, typically at a TMC, Communication Facility or Equipment Cabinet. This template includes various types of traffic management equipment controllers and other types of communication devices including media converters, multiplexers, port terminal servers, radios, remote terminal unit and voters.

Form Number Title
ITSFM5001 Communication Device Import Template, Version 04/13

Conduit Access Points Import Template

This template provides for importing fiber splice vault, fiber pull box, and electric pull box primary point features and general attributes including the longitude/latitude, facility owner, installation date and the site identification name. Additional attributes include the access point material type & size, lid type, material & locking bolt type and the distance to the nearest travel lane and if the access point is located in the clear zone.

Form Number Title
ITSFM5002 Conduit Access Points Import Template, Version 03/13

Electric DC Power Components Import Template

This template provides for importing secondary DC power sub features associated to a wireless shelter primary point feature. The sub features include DC power distribution equipment, batteries, rectifiers, and control panels. Additional attributes include:

Form Number Title
ITSFM5003 Electric DC Power Components Import Template, Version 08/12

Electric Equipment Cabinet Components Import Template

This template provides for importing secondary electrical sub features associated to a communication facility or equipment cabinet point features. The sub features include electrical panel, enclosure & disconnects, power receptacle, surge protection, power management, uninterrupted power system, solar power, power supply and various surge protection devices. Additional attributes include:

  • Panel-enclosure-disconnect type, voltage & amp rating, main and branch breaker quantity and amp rating
  • Cabinet power receptacle type (Std/GFCI), quantity and amp rating and if a surge suppression power strip is installed
  • Cabinet surge protection manufacturer and model
  • Power management system manufacturer, model, number of receptacle, IP address and MAC address
  • Uninterrupted power system manufacturer, model, number of receptacle, IP address, and MAC address. Battery attributes include type, year battery was installed or replaced, battery manufacturer, model and quantity
  • Solar power system panel manufacturer, model. Battery attributes include Type, year installed/replaced, manufacturer, model and quantity
  • Power supply manufacturer and model
  • Surge protection device type, manufacturer and model
Form Number Title
ITSFM5004 Electric Equipment Cabinet Components Import Template, Version 08/12

Electric Equipment Site Components Import Template

This template provides for importing electrical load center, service, utility meter and power disconnect site primary point features and general attributes including the longitude/latitude, facility owner, installation date and the site identification name. Additional attributes include panel/enclosure mount type, the distance to the nearest travel lane and if a lane closure is required to use a bucket truck.

This template also supports the following secondary sub features and attributes:

  •  Panel-Enclosure-Disconnect:
    • Type, voltage & amp rating, main and branch breaker quantity and amp rating
  • Panel-Enclosure Surge Protection
    • Manufacturer and model
  • Power Management System
    • Manufacturer, model, number of receptacle, IP address and MAC address
  • Stand-by Generator
    • FDOT property identification number, manufacturer, model, serial number, year installed, prime kilowatt rating, stand-by kilowatt rating, output voltage rating, fuel type and storage capacity in gallons
  • Transfer Switch
    • Type, manufacturer and model
  • Transformer
    • Input & output voltage rating and kilovolt-ampere rating
  • Utility Meter
    • Type, utility company meter number, meter address and the service provider.
Form Number Title
ITSFM5005 Electric Equipment Site Components Import Template, Version 11/12

Equipment Cabinets & Support Structures Import Template

This template provides for importing field equipment cabinets and ITS support structure primary point features and general attributes including the longitude/latitude, facility owner, installation date and the site identification name.

Additional attributes include:

  • Support structure type, material, length, above ground length, FDOT structure number, the distance to the nearest travel lane, is the feature located in the clear zone or if a lane closure is required to use a bucket truck.
  • Equipment Cabinet administrative usage (ITS or signal cabinet), cabinet type, mount type, if a sun shield is installed, key type, number of filters, filter type & dimensions, the distance to the nearest travel lane, is the feature located in the clear zone or if a lane closure is required to use a bucket truck.
Form Number Title
ITSFM5006 Cabinets & Support Structures Import Template, Version 03/13

Fiber Device Import Template

This template provides for importing secondary sub features associated to a primary point feature, typically at a TMC, Communication Facility or Equipment Cabinet. This sub feature includes the fiber device type (Ethernet switch / router, fiber modem, fiber transmission equipment, and optical patch panels). Additional attributes include manufacturer, model, serial number, IP address, MAC address, firmware version, fiber mode, number of copper ports in & out, number of fiber ports in & out and fiber connector type.

Form Number Title
ITSFM5007 Fiber Device Import Template, Version 03/13

Highway Advisory Radio Import Template

This template provides for importing the HAR Transmitter and HAR Sign sites primary point features information including general attributes such as the longitude/latitude, facility owner, installation date and the site identification name.

  • Highway advisory radio transmitter attributes include the radio type, transmit frequency & band, FCC call sign & station class and the site identification name for all HAR signs associated with the HAR transmission site.
  • Highway advisory radio sign attributes include the associated HAR transmitter name, communication type, beacon controller type, color, size and sign display dimensions.
Form Number Title
ITSFM5008 Highway Advisory Radio Import Template, Version 04/13

ITS Devices Import Template

This template provides for importing ITS Device site primary point feature information including general attributes such as the longitude/latitude, facility owner, installation date, site identification name, device type and SunGuide name.

ITS devices include are:

  • Closed Circuit Television Camera (CCTV)
  • Dynamic Message Sign (DMS)
  • Electronic Feedback Speed Sign (EFSS)
  • Safety Barrier Cable System (SBCS)
  • Trail Blazer (TB)
  • Vehicle Detection System (VDS)
  • Warning Beacon (WB)

Additional attributes vary based on the ITS device type and may include mount type, point of attachment, manufacturer, model, serial number, if the controller is built-in or if it is located in at the same site of other remote controller location.

Form Number Title
ITSFM5009 ITS Devices Import Template, Version 04/13

Roadway Weather Information System (RWIS) Import Template

This template provides for importing RWIS site primary point feature information including general attributes such as the longitude / latitude, facility owner, installation date, site identification name, device type and SunGuide name.

This template also supports the following secondary sub feature RWIS sensors:

  • Air Temperature Sensor
  • Precipitation Sensor
  • Visibility Sensor
  • Relative Humidity Sensor
  • Dew Point Sensor Installed
  • Wind Speed / Direction Combination Sensor
  • Wind Speed Sensor
  • Wind Direction Sensor

Supported attribute for RWIS sensors include the sensor type, year installed, manufacture, model and serial number.

Form Number Title
ITSFM5010 RWIS Import Template, Version 03/13

Signal System Import Template

This template provides for importing Traffic Signal site primary point feature information including general attributes such as the longitude/latitude, facility owner, installation date, site identification name, signal usage (Intersection or Ramp) and SunGuide name.

This template also supports the following secondary sub feature Signal control and sensor equipment:

  • Signal Control Device
    • Bus Interface
    • Conflict Monitor
    • Clock Unit
    • Flasher
    • Load Resistor
    • Load Switch
    • Transfer Relay
  • Sensor Devices
    • Sensor/Detector Module
    • Sensor/Detector Module Chassis

Supported attribute for Signal control and sensor equipment include:

  • Bus Interface:
    • Manufacturer and model
  • Conflict Monitor:
    • Number of Ethernet and Serial ports, manufacturer, model, channels, serial number, IP address, MAC address and firmware version
  • Clock Unit:
    • Type, manufacturer and model
  • Flasher:
    • Manufacturer, model and quantity
  • Load Resistor:
    • Type, manufacturer, model and quantity
  • Load Switch:
    • Manufacturer, model and quantity
  • Transfer Relay:
    • Manufacturer, model, and amp & voltage rating
  • Sensor/Detector Module
    • Type, channel, manufacturer, model, serial number, and chassis & slot number assignments
  • Sensor/Detector Module Chassis
    • Chassis number assignment, number of card slots, manufacturer and model
Form Number Title
ITSFM5011 Signal System Import Template, Version 05/12

Transportation Management Center & Communication Facility

This template provides for importing TMC & Communication Facility primary point features and general attributes including the longitude / latitude, facility owner, installation date and the name of the facility.

Form Number Title
ITSFM5012 Conduit Access Points Import Template, Version 04/13

Tower Import Template

This template provides for importing Tower site primary point feature information including general attributes such as the longitude/latitude, facility owner, installation date, and site identification name. Additional attributes include the tower type, manufacturer, model, finish, height, property ID number, antenna structure registration, and aeronautical study number, safety climbing hardware, tower condition, last inspection and structural analysis date.

This template also supports antenna & cable and warning light secondary sub feature. Supported attribute for these sub features include:

  • Antenna & cable
    • Antenna type manufacturer, model, polarization, direction, mount, installed location, point-of-attachment, jumper size & length, communication cable type, size, length and connector type
  • Warning light
    • Beacon type, manufacturer, model, light controller manufacturer & model, side markers type, manufacturer, model & point-of-attachment.
Form Number Title
ITSFM5013 Import Template, Version 03/13

Travel Time System Import Template

This template provides for importing Travel Time System site primary point feature information including general attributes such as the longitude/latitude, facility owner, installation date, site identification name, and SunGuide name.

This template also supports Travel Time System antenna secondary sub feature including the associated controller / reader identification, the antenna type, manufacture and model, the travel lane coverage, and the travel direction.

Form Number Title
ITSFM5014 Travel Time System Import Template, Version 03/13

Utility Demarcation Site Components Import Template

This template provides for importing Utility Demarcation Site primary point features and general attributes including the longitude / latitude, facility owner, installation date and the site identification name. Additional attributes include the associated load center name and/or the associated equipment site name, the distance to the nearest travel lane and if a lane closure is required to use a bucket truck.

This template also supports the following secondary sub features and attributes:

  • Panel-Enclosure-Disconnect:
    • Type, voltage & amp rating, main and branch breaker quantity and amp rating
  • Panel-Enclosure Surge Protection
    • Manufacturer and model
  • Stand-by Generator
    • FDOT property identification number, manufacturer, model, serial number, year installed, prime kilowatt rating, stand-by kilowatt rating, output voltage rating, fuel type and storage capacity in gallons,
  • Transfer Switch
    • Type, manufacturer and model
  • Transformer
    • Input & output voltage rating and kilovolt-ampere rating
  • Utility Meter
    • Type, utility company meter number, meter address and the service provider.
  • Communication Service
    • Service type, service provider, if an interface or disconnect is installed, comm. service type, telephone number, circuit ID and static IP address
Form Number Title
ITSFM5015 Utility Demarcation Site Components Import Template, Version 06/12

Back to Top


How to Use the ITSFM Import Templates

The following steps outline the process and procedures for using the ITSFM feature import templates for mass importing of primary points and sub features data:

Step 1

Download the latest version of the appropriate ITSFM Import Template and the ITSFM Master Code Lists to your computer from this website. Master Code Lists file and Import Templates must be saved in the same folder. The ITSFM is routinely updated so make sure you are working from the current templates available.

Step 2

Rename and save the Import Template on your computer with a new name that is meaningful and specific to your current project. For example, replace the template number with the project number that installed the features you want to import as shown in the following example:

(ITSFM5006) - Equipment Cabinets & Support Structures Import Template
123456789 - Equipment Cabinets & Support Structures Import Template

Step 3

Compile a list of both primary feature and sub feature attributes that are needed to encode the new equipment information. Compare your list with the ITSFM Master Code Lists to verify that all the needed attributes are included in the master code list.

Note: The ITSFM Master Code Lists is password protected to restrict edits and allow the FDOT Central Office to manage the code list. This was implemented to ensure accurate and consistent information is populated within the code list and the ITSFM database.

To request Master Code List updates, email a list of new attribute descriptions and it's ITSFM database table name shown in the import templates to Randy.Pierce@dot.state.fl.us. The Central Office will update the Code List and email you the updated version within two business days or less. The updated version will also be posted to this website to ensure the most accurate information is available to the users.

Step 4

Open both the ITSFM Master Code Lists file and the appropriate Import Template file using the most current version of MS Excel. The ITSFM Master Code Lists must be open at all times when populating the templates.

Step 5

Input site and equipment attributes into the Import template worksheet including ALL required fields denoted in the ITSFM table name description header of the workbook. The ITSFM system will abort the importing process if any required field is missing.

Step 6

Validate the completeness and accuracy of your populated spread sheet file then forward it to the Central Office for importing into the ITSFM database. The Central Office will process and notify you within two business days or less the status of the feature import. Email your request and populated template file to Randy.Pierce@dot.state.fl.us.

Note: Once the new data has been imported, it is the inputting user's responsibility to review the accuracy of the data and will need to rotate symbols to parallel the roadway, adjust text location as required and move the ITS device and equipment cabinet symbols away from the support structure symbol (primary coordinate) to provide clarity since they share the same coordinate value as the pole or support structure.

Note: All imported point feature symbols and text will be imported with a zero rotation.

Back to Top


How to Import Primary Linear Features

The ITSFM provides for importing primary linear features (cables and conduits) directly into the database. Linear features can be imported as "Primitive Graphics" from electronic MicroStation, Version 7 as-built plans. The plans must have been created using the Longitude / Latitude WGS 84 coordinates for the installation area. The imported graphics will reside on a different layer and can be digitize into new conduit or cable features.

When these features are created, the primitive graphics coordinate value is used to define the primary linear features position including start, mid-span and end points. After selection, the user is prompted to input predefined attributes about the feature in the form presented.

Note: It is important that linear features in the MicroStation file have the proper start and end points. For example, conduit must start and end at an access point. If this is not the case, the imported linear features will require graphical modifications as they are created in the ITSFM.

The following steps define the procedures to create linear features using primitive graphics:

Step 1

Validate the completeness and accuracy of the electronic MicroStation V7 as-built file then forward it to the Central Office for importing into the ITSFM database. The Central Office will process and notify you within two business days or less the status of the feature import. Email your request electronic file to Randy.Pierce@dot.state.fl.us

Step 2

Notify the Central Office when you have finished using the imported primitive graphics so they can be deleted from the ITSFM. Deleting unwanted graphics will improve system performance.

Back to Top



For additional information, please contact Randy Pierce at Randy.Pierce@dot.state.fl.us