FDOTProject.xlsm
XLSM spreadsheet 62 KB Posted
- Solicitation number
- TRN2132636C1
- Issued by
- Broward County, Florida
About this file
This file is a technical project asset data template (FDOTProject.xlsm) created for the Florida Department of Transportation (FDOT) to support infrastructure management and documentation for the Royal Palm Boulevard widening and resurfacing project in Coral Springs, Florida, managed by Broward County's Highway Construction and Engineering Division. The template serves as a data collection and attribute assignment tool for cataloging road infrastructure assets including drainage systems, fencing, gates, and other linear and point features. The spreadsheet provides standardized mechanisms for filtering and extracting asset information based on graphical properties (level, color, line style, weight, transparency, material, and feature definition), as well as for assigning custom attributes to identified assets such as asset ID, installation date, owner, maintenance contractor, condition rating, risk rating, and maintenance status. The template accommodates both location data derived from MicroStation coordinates and OpenRoads reference-based coordinates, including chainage, easting, northing, and elevation values for both start and end points of linear assets.
The template includes predefined asset categories and pick-list options for standardized data entry, support for lookup table calculations and mathematical expressions for derived attributes, and flexible unit management accommodating various measurement standards (metric and US survey units). The project references FPID 449559-1-52-01 and alignments including BL_RYLPLMBLVD, BL_RIVERSD-DR, NW91AVE, and NW89DR. This asset management framework is designed to facilitate comprehensive infrastructure documentation and condition assessment for the Royal Palm Boulevard project, which includes roadway widening, milling and resurfacing, curb median construction, sidewalk replacement, ADA accessibility upgrades, and signaling infrastructure improvements, with funding sourced through Federal Highway Administration allocations and Broward County Transportation Surtax funds.
View the file
Other files
Show 40 more
Latest 50 of 198 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
_Asset Data Types
| Group | Items | GIS Type | |
| Road | Central Reserve | linear | Select the cell in column B at the top of the range you wish to auto populate and then select button to auto populate all asset tabs into list |
| Depot | point | ||
| Verge | linear | ||
| Crossover | point | ||
| Fences | Carriageway Gates | point | |
| Fences | linear | ||
| Fence Gates | point | ||
| Snow Gates | point | ||
| Stile | point | ||
| ExampleAssetFence | point | ||
| Drainage | Manhole | point | |
| Inlet | point | ||
| Headwall | point | ||
| Culvert | linear | ||
| ExampleAssetDrainage | linear |
Auto Populate Asset Tabs
_InternalListManagement
| #Filter | Text | Default Value |
| #Property | Number | Calculation Expression |
| Integer | ||
| True/False | ||
| Date/Time | ||
| Point |
_InternalUnitManagement
| ANGLE_MINUTE | ' [minutes] |
| ANGLE_SECOND | '' [seconds] |
| DOLLAR | $ [dollar] |
| PERCENT_SLOPE | % [percent slope] |
| PERCENT_PERCENT | % [percent] |
| DEGREE | ° [degrees] |
| DEGREE_CELSIUS | °C [Celsius] |
| DEGREE_FAHRENHEIT | °F [Fahrenheit] |
| AMPERE | A [ampere] |
| ACRE_FOOT | acre·ft [acre feet] |
| ACRE_FOOT_PER_DAY | acre·ft/day [acre foot per day] |
| ACRE_FOOT_PER_HOUR | acre·ft/h [acre foot per hour] |
| ACRE_FOOT_PER_MINUTE | acre·ft/min [acre foot per minute] |
| ACRE_INCH_PER_HOUR | acre·in/h [acre inch per hour] |
| ACRE_INCH_PER_MINUTE | acre·in/min [acre inch per minute] |
| ACRE | acres |
| CENTIMETRE | cm [centimeters] |
| CENTIMETRE_CUBED | cm³ [centimeters cubed] |
| CYCLE_PER_HOUR | cycle/hr [cycle per hour] |
| CYCLE_PER_MINUTE | cycle/min [cycle per minute] |
| CYCLE_PER_SECOND | cycle/sec [cycle per second] |
| DAY | days |
| DEGREE_PER_HOUR | deg/hr [degree per hour] |
| DEGREE_PER_MINUTE | deg/min [degree per minute] |
| DEGREE_PER_SECOND | deg/sec [degree per second] |
| DECIMETRE | dm [decimeters] |
| EACH | ea [Each] |
| US_SURVEY_FOOT | ft (US Survey) [foot (US Survey)] |
| FOOT | ft [feet] |
| FOOT_PER_DAY | ft/day |
| FOOT_PER_HOUR | ft/h [feet per hour] |
| FOOT_SQUARED | ft² [feet squared] |
| FOOT_CUBED | ft³ [feet cubed] |
| FOOT_CUBED_PER_DAY | ft³/day [foot cubed per day] |
| FOOT_CUBED_PER_MINUTE | ft³/min [Foot cubed per minute] |
| FOOT_CUBED_PER_SECOND | ft³/s [foot cubed per second] |
| GALLON_IMPERIAL | gal (imp) [imperial gallons] |
| GALLON_IMPERIAL_PER_DAY | gal (imp)/day [gallon imperial per day] |
| GALLON_IMPERIAL_PER_MINUTE | gal (imp)/min [gallon imperial per minute] |
| GALLON_IMPERIAL_PER_SECOND | gal (imp)/s [gallon imperial per second] |
| GALLON | gal [gallons] |
| GALLON_PER_DAY | gal/day [gallon per day] |
| GALLON_PER_MINUTE | gal/min [gallon per minute] |
| GALLON_PER_SECOND | gal/s [gallon per second] |
| HOUR | h [hours] |
| HECTARE | ha [hectares] |
| HORSEPOWER | hp [horsepower] |
| US_SURVEY_INCH | in (US Survey) [inch (US Survey)] |
| INCH | in [inches] |
| INCH_SQUARED | in² [inches squared] |
| INCH_CUBED | in³ [inches cubed] |
| KILOGRAM | kg [kilograms] |
| KILOGRAM_PER_CENTIMETRE_CUBED | kg/cm³ [kilogram per centimeter cubed] |
| KILOGRAM_PER_DAY | kg/day [kilogram per day] |
| KILOGRAM_PER_HOUR | kg/h [kilogram per hour] |
| KILOGRAM_PER_HECTARE | kg/ha [kilogram per hectare] |
| KILOGRAM_PER_LITRE | kg/L [kilograms per liter] |
| KILOGRAM_PER_METRE_SQUARED | kg/m² [kilogram per meter squared] |
| KILOGRAM_PER_METRE_CUBED | kg/m³ [kilograms per meter cubed] |
| KILOMETRE | km [kilometers] |
| KILOMETRE_PER_HOUR | km/h [kilometers per hour] |
| KILOMETRE_SQUARED | km² [kilometers squared] |
| KILOVOLT | KV [kilovolt] |
| KILOWATT | kW [kilowatt] |
| KILOWATT_HOUR | kW·h [kilowatt hour] |
| LITRE | L [liters] |
| LITRE_PER_SECOND_PER_PERSON | L/(s·person) [liter per second per person] |
| LITRE_PER_DAY | L/day [liter per day] |
| LITRE_PER_HOUR | L/h |
| LITRE_PER_MINUTE | L/min [liter per minute] |
| LITRE_PER_SECOND | L/s [liter per second] |
| POUND | lb [pounds] |
| POUND_PER_ACRE | lb/acre [pound per acre] |
| POUND_PER_DAY | lb/day [pound per day] |
| POUND_MASS_PER_FOOT_SQUARED | lb/ft² [pound mass per foot squared] |
| POUND_PER_FOOT_CUBED | lb/ft³ [pounds per foot cubed] |
| POUND_PER_IMPERIAL_GALLON | lb/gal (imp) [pounds per imperial gallon] |
| POUND_PER_GALLON | lb/gal [pounds per gallon] |
| POUND_PER_HOUR | lb/h [pound per hour] |
| POUND_PER_INCH_CUBED | lb/in³ [pounds per inch cubed] |
| POUND_FORCE_PER_FOOT_SQUARED | lbf/ft² [pound force per foot squared] |
| POUND_FORCE_PER_FOOT_CUBED | lbf/ft³ [pound force per foot cubed] |
| POUND_FORCE_PER_INCH_SQUARED | lbf/in² [pound force per inch squared] |
| POUND_FOOT | lbf·ft [pound force foot] |
| POUND_MASS_PER_INCH_SQUARED | lbm/in² [pound mass per inch squared] |
| METRE | m [meters] |
| METRE_PER_DAY | m/day |
| METRE_PER_HOUR | m/h [meters per hour] |
| METRE_SQUARED | m² [meters squared] |
| METRE_CUBED | m³ [meters cubed] |
| METRE_CUBED_PER_DAY | m³/day [meter cubed per day] |
| METRE_CUBED_PER_HOUR | m³/h [meter cubed per hour] |
| METRE_CUBED_PER_MINUTE | m³/min [meter cubed per minute] |
| METRE_CUBED_PER_SECOND | m³/s [meter cubed per second] |
| US_SURVEY_MILE | mi (US Survey) [mile (US Survey)] |
| MILE | mi [miles] |
| MILE_PER_HOUR | mi/h [miles per hour] |
| MILE_SQUARED | mi² [miles squared] |
| MINUTE | min [minutes] |
| MILLIMETRE | mm [millimeters] |
| MEGAWATT | MW |
| MEGAWATT_HOUR | MWh |
| NONE | n/a [none] |
| NEWTON_PER_METRE_SQUARED | N/m² [newtons per meter squared] |
| NEWTON_PER_MILLIMETRE_SQUARED | N/mm² [newton per millimeter squared] |
| NEWTON_METRE | N·m [newton meter] |
| ANGLE_QUADRANT | quadrants |
| RADIAN | rad [radians] |
| RADIAN_PER_HOUR | rad/hr [radian per hour] |
| RADIAN_PER_MINUTE | rad/min [radian per minute] |
| RADIAN_PER_SECOND | rad/sec [radian per second] |
| SECOND | s [seconds] |
| VERTICAL_PER_HORIZONTAL | slope |
| THOUSAND_GALLON | thousand gal [thousand gallons] |
| THOUSAND_LITRE | thousand L [thousand liter] |
| LONG_TON | tn (long) [long ton] |
| SHORT_TON | tn (short) [short ton] |
| SHORT_TON_PER_FOOT_CUBED | tn (short)/ft³ [short tons per foot cubed] |
| SHORT_TON_PER_HOUR | tph [short ton per hour] |
| TONNE_PER_HOUR | tph [tonne per hour] |
| VOLT | V [volt] |
| WATT | W [watts] |
| YARD | yd [yards] |
| YARD_SQUARED | yd² [yards squared] |
| YARD_CUBED | yd³ [yards cubed] |
| YEAR | years |
_AssetNames
_Filter Groups Filter Group Name Option 1
_Pick List Definitions
| Pick List Name | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 |
| Alignment | BL_RYLPLMBLVD | BL_RIVERSD-DR | BL_NW91AVE | BL_NW89DR | |
| FPID | 449559-1-52-01 |
_AssetTemplateDescription
| Graphical Filter | ||||||||
| #FILTER | Level | Enter the level(s) to search for (e.g. EdgeOfPavement or EdgeOfPavement;Fence;Pipe) Use single entry of level name or concatenated list using semi-colons. | ||||||
| #FILTER | Color | Enter the color(s) to search for (e.g. 1 or 1;34;ByLevel) Use single entry of color number or concatenated list using semi-colons. Use word ByLevel if needed | ||||||
| #FILTER | LineStyle | Enter the linestyles(s) to search for (e.g. 1 or 1;Dashed;ByLevel) Use single entry of linestyle number/name or concatenated list using semi-colons. Use word ByLevel if needed | ||||||
| #FILTER | Weight | Enter the weight(s) to search for (e.g. 1 or 1;2;ByLevel) Use single entry of weight number or concatenated list using semi-colons. Use word ByLevel if needed | ||||||
| #FILTER | Element Type | Enter the element type(s) to search for (e.g. Linestring or Line;LineString;Complex Chain) Use single entry of element type or concatenated list using semi-colons. | ||||||
| #FILTER | Cell Name | Enter the cell name(s) to search for (e.g. PPOLE or PPOLE;WV;MH) Use single entry of cell name or concatenated list using semi-colons. | ||||||
| #FILTER | Transparency | Enter the transparency(s) to search for (e.g. 20 or 20;35,90-100) Use single entry for transparency or concatenated list using semi-colons. Max value is 100. Min value is 0. Range is represented by low to high (e.g. 30-70) | ||||||
| #FILTER | Material | Enter the material(s) to search for (e.g. concrete or concrete;brick;stone) Use single entry for material or concatenated list using semi-colons. | ||||||
| #FILTER | Feature Definition | Enter the Feature Definition(s) to search for (e.g. EdgeOfPavement or EdgeOfPavement;EdgeOfAsphalt;EdgeOfOil) Use single entry for material or concatenated list using semi-colons. | ||||||
| NOTE: | AT LEAST ONE ITEM FOR SEARCHING MUST BE DEFINED. | |||||||
| Attributes | ||||||||
| Name | IsUnique | SeedCode | Type | Values | Default Values | Comments | ||
| Location & Physical Properties (values populated at run time) | ||||||||
| #ATTR | Start Chainage | STRING | {ORD_Start_Station} | ORD Calculated start station of the object relative to the selected baseline | ||||
| #ATTR | End Chainage | STRING | {ORD_End_Station} | ORD Calculated start station of the object relative to the selected baseline | ||||
| #ATTR | Road Link | STRING | (ORD_Asset_Baseline} | ORD Active reference baseline selected at runtime | SUE= SUE/SUDA | |||
| #ATTR | Start Easting (X) As Drawn | NUMBER | {MS_Start_Easting} | MS Start Easting of object (X value) | MS = MicroStation | |||
| #ATTR | Start Northing (Y) As Drawn | NUMBER | {MS_Start_Northing} | MS Start Northing of object (Y value) | ORD = OpenRoads | |||
| #ATTR | Start Elevation (Z) As Drawn | NUMBER | {MS_Start_Elevation} | MS Start Elevation of object (Z value) | ||||
| #ATTR | End Easting (X) As Drawn | NUMBER | {MS_End_Easting} | MS End Easting of object (X value) | NOTE: Column A can either have "#FILTER" or "#ATTR". Filter rows should not be added, deleted or order changed. Only lines with "#ATTR" will be read for assigning attributes. | |||
| #ATTR | End Northing (Y) As Drawn | NUMBER | {MS_End_Northing} | MS End Northing of object (Y value) | ||||
| #ATTR | End Elevation (Z) As Drawn | NUMBER | {MS_End_Elevation} | MS End Elevation of object (Z value) | ||||
| #ATTR | Start Easting (X) By Reference | NUMBER | {ORD_Start_Easting} | ORD Start Easting of object (X value) | ||||
| #ATTR | Start Northing (Y) By Reference | NUMBER | {ORD_Start_Northing} | ORD Start Northing of object (Y value) | ||||
| #ATTR | Start Elevation (Z) By Reference | NUMBER | {ORD_Start_Elevation} | ORD Start Elevation of object (Z value) | ||||
| #ATTR | End Easting (X) By Reference | NUMBER | {ORD_End_Easting} | ORD End Easting of object (X value) | ||||
| #ATTR | End Northing (Y) By Reference | NUMBER | {ORD_End_Northing} | ORD End Northing of object (Y value) | ||||
| #ATTR | End Elevation (Z) By Reference | NUMBER | {ORD_End_Elevation} | ORD End Elevation of object (Z value) | ||||
| #ATTR | Begin Offset | NUMBER | {ORD_Begin_Offset} | Beginning Offset | NOTE: The worksheet tab name denotes the name of the item type. | |||
| #ATTR | End Offset | NUMBER | {ORD_End_Offset} | Ending Offset | ||||
| #ATTR | Begin Side | STRING | {ORD_Begin_Side} | Denoted with "Left" or "Right" | ||||
| #ATTR | End Side | STRING | {ORD_End_Side} | Denoted with "Left" or "Right" | ||||
| #ATTR | Length | NUMBER | {MS_Length_2D} | 2D calced Length in a 3D file, If 2D file Same as Slope Length | ||||
| #ATTR | Slope Length | NUMBER | {MS_Length_3D} | 3D Length | ||||
| #ATTR | Perimeter | NUMBER | {MS_Perimeter_2D} | 2D calced Length in a 3D file, If 2D file Same as Slope Length | ||||
| #ATTR | Slope Perimeter | NUMBER | {MS_Perimeter_3D} | 3D Length of Perimeter | ||||
| #ATTR | Area | NUMBER | {MS_Area_2D} | 2D calced Area in a 3D file, If 2D file Same as Slope Area | ||||
| #ATTR | Slope Area | NUMBER | {MS_Area_3D} | 3D Area | NOTE: Type must be set to one of the following: DATE: Denotes date format. LIST: Creates list from concatenated values in column F. STRING: Value can be numerial, alpa characters or combination of both. NUMBER: Can only be a number value. | |||
| #ATTR | Surface Area | NUMBER | {ORD_Component_Area_2D} | 2D Surface area of component mesh | ||||
| #ATTR | Slope Surface Area | NUMBER | {ORD_Component_Area_3D} | 3D Surface area of component mesh | ||||
| #ATTR | Volume | NUMBER | {MS_Volume} | Volume of Object | ||||
| #ATTR | Material | STRING | {MS_Material} | Material assigned of object | ||||
| #ATTR | Conduit Begin Node | STRING | {SUE_Conduit_Start_Node} | Utility conduit starting node | ||||
| #ATTR | Conduit End Node | STRING | {SUE_Conduit_Stop_Node} | Utility conduit ending node | ||||
| #ATTR | Conduit Begin Invert Elevation | NUMBER | {SUE_Conduit_Start_Invert} | Utility conduit starting invert | ||||
| #ATTR | Conduit End Invert Elevation | NUMBER | {SUE_Conduit_Stop_Invert} | Utility conduit ending invert | ||||
| #ATTR | Conduit Size | STRING | (SUE_Conduit_Feature_Description} | Utility conduit diameter from Feature Description | ||||
| #ATTR | Conduit Shape | STRING | (SUE_Conduit_Shape} | Utility conduit shape | ||||
| #ATTR | Node Ground Elevation | NUMBER | {SUE_Node_Ground_Elevation} | Utility node top/ground elevation | ||||
| #ATTR | Node Invert Elevation | NUMBER | {SUE_Node_Invert_Elevation} | Utility bottom inside/invert elevation | ||||
| #ATTR | Sheet Name | STRING | {ORD_Sheet_Name} | Named Boundary Name | ||||
| #ATTR | Feature Name | STRING | {ORD_Feature_Name} | ORD Feature Property | ||||
| #ATTR | Feature Definition | STRING | {ORD_Featurre_Definition} | ORD Feature Property | ||||
| #ATTR | Feature Description | STRING | {ORD_Feature_Description} | ORD Feature Property | ||||
| User defined examples | ||||||||
| #ATTR | Type | LIST | ||||||
| #ATTR | Asset ID | Yes | CRGW-#00 | STRING | See NOTE D: | NOTE D: When Using Col C. and Col. D a unique value will be created for each object that matches the search criteria as defined above. In this example the Asset ID will start at CRGW1 and increment by +1 with each new occurance. The numeric portion defines the format the incremented value will hold, indicating the number of zero-prefixed digits. i.e. # would result in 1, #0 would result in 01, and #000 would result in 0001. | ||
| #ATTR | Installation Date | DATE | 1/30/74 | |||||
| #ATTR | Reason for Gates | LIST | Cow;Goat;Pedistrian | Cow | ||||
| #ATTR | Owner | STRING | Eastern Rail Company | |||||
| #ATTR | Current Maintenance Contract | STRING | Wreckum Ralph | |||||
| #ATTR | Currently Maintained By | LIST | Joe's Crew | |||||
| #ATTR | Departure - DAS ID | STRING | True;False | TRUE | ||||
| #ATTR | Condition Rating (Manual) | LIST | Good;Bad;Ugly | Ugly | ||||
| #ATTR | Risk Rating | LIST | 0;25;50;75;100 | 25 | ||||
| #ATTR | Additional Asset Information | STRING | ||||||
| #ATTR | Start Date of Asset | DATE | 12/31/62 | |||||
| NOTE: You can add as many Specific Examples as needed as long as they have a unique name in column B. |
_AssetTemplate
| Graphical Filter | ||||||
| #FILTER | Level | Enter the level(s) to search for (e.g. EdgeOfPavement or EdgeOfPavement;Fence;Pipe) Use single entry of level name or concatenated list using semi-colons. | ||||
| #FILTER | Color | Enter the color(s) to search for (e.g. 1 or 1;34;ByLevel) Use single entry of color number or concatenated list using semi-colons. Use word ByLevel if needed | ||||
| #FILTER | LineStyle | Enter the linestyles(s) to search for (e.g. 1 or 1;Dashed;ByLevel) Use single entry of linestyle number/name or concatenated list using semi-colons. Use word ByLevel if needed | ||||
| #FILTER | Weight | Enter the weight(s) to search for (e.g. 1 or 1;2;ByLevel) Use single entry of weight number or concatenated list using semi-colons. Use word ByLevel if needed | ||||
| #FILTER | Element Type | Enter the element type(s) to search for (e.g. Linestring or Line;LineString;Complex Chain) Use single entry of element type or concatenated list using semi-colons. | ||||
| #FILTER | Cell Name | Enter the cell name(s) to search for (e.g. PPOLE or PPOLE;WV;MH) Use single entry of cell name or concatenated list using semi-colons. | ||||
| #FILTER | Transparency | Enter the transparency(s) to search for (e.g. 20 or 20;35,90-100) Use single entry for transparency or concatenated list using semi-colons. Max value is 100. Min value is 0. Range is represented by low to high (e.g. 30-70) | ||||
| #FILTER | Material | Enter the material(s) to search for (e.g. concrete or concrete;brick;stone) Use single entry for material or concatenated list using semi-colons. | ||||
| #FILTER | Feature Definition | Enter the Feature Definition(s) to search for (e.g. EdgeOfPavement or EdgeOfPavement;EdgeOfAsphalt;EdgeOfOil) Use single entry for material or concatenated list using semi-colons. | ||||
| AT LEAST ONE ITEM FOR SEARCHING MUST BE DEFINED. | ||||||
| Attributes | ||||||
| Name | Type | Values | Default Values | Comments | ||
| Location & Physical Properties (values populated at run time) | ||||||
| #ATTR | Start Chainage | Select | Select | ORD Calculated start station of the object relative to the selected baseline | ||
| #ATTR | End Chainage | Select | Select | ORD Calculated start station of the object relative to the selected baseline | ||
| #ATTR | Road Link | Select | Select | ORD Active reference baseline selected at runtime | SUE= SUE/SUDA | |
| #ATTR | Start Easting (X) As Drawn | Select | Select | MS Start Easting of object (X value) | MS = MicroStation | |
| #ATTR | Start Northing (Y) As Drawn | Select | Select | MS Start Northing of object (Y value) | ORD = OpenRoads | |
| #ATTR | Start Elevation (Z) As Drawn | Select | Select | MS Start Elevation of object (Z value) | ||
| #ATTR | End Easting (X) As Drawn | Select | Select | MS End Easting of object (X value) | NOTE: Column A can either have "#FILTER" or "#ATTR". Filter rows should not be added, deleted or order changed. Only lines with "#ATTR" will be read for assigning attributes. | |
| #ATTR | End Northing (Y) As Drawn | Select | Select | MS End Northing of object (Y value) | ||
| #ATTR | End Elevation (Z) As Drawn | Select | Select | MS End Elevation of object (Z value) | ||
| #ATTR | Start Easting (X) By Reference | Select | Select | ORD Start Easting of object (X value) | ||
| #ATTR | Start Northing (Y) By Reference | Select | Select | ORD Start Northing of object (Y value) | ||
| #ATTR | Start Elevation (Z) By Reference | Select | Select | ORD Start Elevation of object (Z value) | ||
| #ATTR | End Easting (X) By Reference | Select | Select | ORD End Easting of object (X value) | ||
| #ATTR | End Northing (Y) By Reference | Select | Select | ORD End Northing of object (Y value) | ||
| #ATTR | End Elevation (Z) By Reference | Select | Select | ORD End Elevation of object (Z value) | ||
| #ATTR | Begin Offset | Select | Select | Beginning Offset | NOTE: The worksheet tab name denotes the name of the item type. | |
| #ATTR | End Offset | Select | Select | Ending Offset | ||
| #ATTR | Begin Side | Select | Select | Denoted with "Left" or "Right" | ||
| #ATTR | End Side | Select | Select | Denoted with "Left" or "Right" | ||
| #ATTR | Length | Select | Select | 2D calced Length in a 3D file, If 2D file Same as Slope Length | ||
| #ATTR | Slope Length | Select | Select | 3D Length | ||
| #ATTR | Perimeter | Select | Select | 2D calced Length in a 3D file, If 2D file Same as Slope Length | ||
| #ATTR | Slope Perimeter | Select | Select | 3D Length of Perimeter | ||
| #ATTR | Area | Select | Select | 2D calced Area in a 3D file, If 2D file Same as Slope Area | ||
| #ATTR | Slope Area | Select | Select | 3D Area | NOTE: Type must be set to on of the following: DATE: Denotes date format. LIST: Creates list from concatenated values in column F. STRING: Value can be numerial, alpa characters or combination of both. NUMBER: Can only be a number value. | |
| #ATTR | Surface Area | Select | Select | 2D Surface area of component mesh | ||
| #ATTR | Slope Surface Area | Select | Select | 3D Surface area of component mesh | ||
| #ATTR | Volume | Select | Select | Volume of Object | ||
| #ATTR | Material | Select | Select | Material assigned of object | ||
| #ATTR | Conduit Begin Node | Select | Select | Utility conduit starting node | ||
| #ATTR | Conduit End Node | Select | Select | Utility conduit ending node | ||
| #ATTR | Conduit Begin Invert Elevation | Select | Select | Utility conduit starting invert | ||
| #ATTR | Conduit End Invert Elevation | Select | Select | Utility conduit ending invert | ||
| #ATTR | Conduit Size | Select | Select | Utility conduit diameter from Feature Description | ||
| #ATTR | Conduit Shape | Select | Select | Utility conduit shape | ||
| #ATTR | Node Ground Elevation | Select | Select | Utility node top/ground elevation | ||
| #ATTR | Node Invert Elevation | Select | Select | Utility bottom inside/invert elevation | ||
| #ATTR | Sheet Name | Select | Select | Named Boundary Name | ||
| #ATTR | Feature Name | Select | Select | ORD Feature Property | ||
| #ATTR | Feature Definition | Select | Select | ORD Feature Property | ||
| #ATTR | Feature Description | Select | Select | ORD Feature Property | ||
| User defined examples | ||||||
| #ATTR | Type | STRING | ||||
| #ATTR | Asset ID | STRING | {UID "CRGW#"} | See Note D: | NOTE D: When Using Col C. and Col. D a unique value will be created for each object that matches the search criteria as defined above. In this example the Asset ID will start at CRGW1 and increment by +1 with each new occurance. | |
| #ATTR | Installation Date | DATE | 1/30/74 | |||
| #ATTR | Reason for Gates | LIST | Cow;Goat;Pedistrian | Cow | ||
| #ATTR | Owner | STRING | Eastern Rail Company | |||
| #ATTR | Current Maintenance Contract | STRING | Wreckum Ralph | |||
| #ATTR | Currently Maintained By | STRING | Joe's Crew | |||
| #ATTR | Departure - DAS ID | LIST | True;False | TRUE | ||
| #ATTR | Condition Rating (Manual) | LIST | Good;Bad;Ugly | Ugly | ||
| #ATTR | Risk Rating | LIST | 0;25;50;75;100 | 25 | ||
| #ATTR | Additional Asset Information | STRING | Note F: Lookup table definitions indicate the table name (worksheet name that must begin with _LU_) and the attribute that contains the key value used for the lookup. The lookup table must be a worksheet in this spreadsheet. | |||
| #ATTR | Conduit Wall Thickness | NUMBER | {_LU_RCP_Wall_Thickness[Conduit Size]} | See Note F | ||
| #ATTR | Conduit Begin Top Elevation | NUMBER | {[Conduit Begin Invert Elevation] + [Conduit Size] + [Conduit Wall Thickness]} | See Note G | ||
| #ATTR | Start Date of Asset | DATE | 12/31/62 | |||
| NOTE: You can add as many Specific Examples as needed as long as they have a unique name in column B. | ||||||
| NOTE G: Calculated expressions may contain numbers, operators, and attribute names to calculate a value based on other attributes. Attribute names must be enclosed in brackets ([]) and operators are currently limited to addition (+), subtraction (-), multiplication (*), and division (/). Expressions may also include parenthesis for grouping. |
_Blank Asset
| Graphical Filters | ||
| #Filter | Level | Enter the levels to filter on using a ';' delimited list (e.g. "EdgeOfPavement" or "EdgeOfPavement;Fence;Pipe") |
| #Filter | Color | Enter the colors to filter on using a ';' delimited list. Use word ByLevel if needed (e.g. "1" or "1;34;ByLevel") |
| #Filter | Line Style | Enter the line styles to filter on using a ';' delimited list. Indicate line style by number/name. Use ByLevel if needed (e.g. "1" or "1;Dashed;ByLevel") |
| #Filter | Line Weight | Enter the line weights to filter on using a ';' delimited list. Use word ByLevel if needed (e.g. "1" or "1;2;ByLevel") |
| #Filter | Element Type | Enter the element types to filter on using a ';' delimited list (e.g. "Linestring" or "Line;LineString;Complex Chain") |
| #Filter | Cell Name | Enter the cell names to filter on using a ';' delimited list (e.g. "PPOLE" or "PPOLE;WV;MH") |
| #Filter | Transparency | Enter the transparencies to filter on using a ';' delimited list. Values can be between 0 and 100. Ranges are specified by "low-high" (e.g. "20" or "20;35;90-100") |
| #Filter | Material | Enter the materials to filter on using a ';' delimited list (e.g. "concrete" or "concrete;brick;stone") |
| #Filter | Feature Definition | Enter the feature definitions to filter on using a ';' delimited list (e.g. "EdgeOfPavement" or "EdgeOfPavement;EdgeOfAsphalt;EdgeOfOil") |
| Custom Properties | |||||||
| Name | Type | Pick List | Default Value | Calculation Expression | Expression Failure Value | Unit | Comments |
| User Defined Attributes | |||||||
| Note: You can add as many properties as needed as long as they have a unique name in column B. |
Alignment
| Graphical Filters | ||
| #Filter | Level | Enter the levels to filter on using a ';' delimited list (e.g. "EdgeOfPavement" or "EdgeOfPavement;Fence;Pipe") |
| #Filter | Color | Enter the colors to filter on using a ';' delimited list. Use word ByLevel if needed (e.g. "1" or "1;34;ByLevel") |
| #Filter | Line Style | Enter the line styles to filter on using a ';' delimited list. Indicate line style by number/name. Use ByLevel if needed (e.g. "1" or "1;Dashed;ByLevel") |
| #Filter | Line Weight | Enter the line weights to filter on using a ';' delimited list. Use word ByLevel if needed (e.g. "1" or "1;2;ByLevel") |
| #Filter | Element Type | Enter the element types to filter on using a ';' delimited list (e.g. "Linestring" or "Line;LineString;Complex Chain") |
| #Filter | Cell Name | Enter the cell names to filter on using a ';' delimited list (e.g. "PPOLE" or "PPOLE;WV;MH") |
| #Filter | Transparency | Enter the transparencies to filter on using a ';' delimited list. Values can be between 0 and 100. Ranges are specified by "low-high" (e.g. "20" or "20;35;90-100") |
| #Filter | Material | Enter the materials to filter on using a ';' delimited list (e.g. "concrete" or "concrete;brick;stone") |
| #Filter | Feature Definition | Enter the feature definitions to filter on using a ';' delimited list (e.g. "EdgeOfPavement" or "EdgeOfPavement;EdgeOfAsphalt;EdgeOfOil") |
| Custom Properties | ||||||||
| Name | Type | Pick List | Default Value | Calculation Expression | Expression Failure Value | Unit | Comments | |
| User Defined Attributes | ||||||||
| Note: You can add as many properties as needed as long as they have a unique name in column B. | ||||||||
| #Property | Alignment | Text | Alignment | Select |
FPID
| Graphical Filters | ||
| #Filter | Level | Enter the levels to filter on using a ';' delimited list (e.g. "EdgeOfPavement" or "EdgeOfPavement;Fence;Pipe") |
| #Filter | Color | Enter the colors to filter on using a ';' delimited list. Use word ByLevel if needed (e.g. "1" or "1;34;ByLevel") |
| #Filter | Line Style | Enter the line styles to filter on using a ';' delimited list. Indicate line style by number/name. Use ByLevel if needed (e.g. "1" or "1;Dashed;ByLevel") |
| #Filter | Line Weight | Enter the line weights to filter on using a ';' delimited list. Use word ByLevel if needed (e.g. "1" or "1;2;ByLevel") |
| #Filter | Element Type | Enter the element types to filter on using a ';' delimited list (e.g. "Linestring" or "Line;LineString;Complex Chain") |
| #Filter | Cell Name | Enter the cell names to filter on using a ';' delimited list (e.g. "PPOLE" or "PPOLE;WV;MH") |
| #Filter | Transparency | Enter the transparencies to filter on using a ';' delimited list. Values can be between 0 and 100. Ranges are specified by "low-high" (e.g. "20" or "20;35;90-100") |
| #Filter | Material | Enter the materials to filter on using a ';' delimited list (e.g. "concrete" or "concrete;brick;stone") |
| #Filter | Feature Definition | Enter the feature definitions to filter on using a ';' delimited list (e.g. "EdgeOfPavement" or "EdgeOfPavement;EdgeOfAsphalt;EdgeOfOil") |
| Custom Properties | ||||||||
| Name | Type | Pick List | Default Value | Calculation Expression | Expression Failure Value | Unit | Comments | |
| User Defined Attributes | ||||||||
| Note: You can add as many properties as needed as long as they have a unique name in column B. | ||||||||
| #Property | FPID | Text | FPID | Select |
File details come from the government source that posted it. Updated .