DOCUMENT CONTROL - Department for Infrastructure and …



Road & Marine AssetsASSET DATA COLLECTION MANUAL36385507620RAMA-AM-PRC-00500RAMA-AM-PRC-005Document #: 10918839 Version 5RAMADOCUMENT CONTROLDOCUMENT APPROVALRoleNameSignatureDateManager Road and Marine Assets-1709420-7874000Janey MitsonDOCUMENT HISTORYDocument NameVersionRelease DateDraft (in prep)10 Oct 2016RAMA-AM-PRC-005Rev 09 Nov 2016RAMA-AM-PRC-005Rev 130 Nov 2016RAMA-AM-PRC-005Rev 222 June 2017RAMA-AM-PRC-005Rev 313 Nov 2017RAMA-AM-PRC-005 Rev 3.1 (Draft)22 Feb 2018RAMA-AM-PRC-005 Rev 4August 2018RAMA-AM-PRC-005 Rev 5Dec 2019 TOC \h \z \t "Section subtitle,2,Section title,1" Table of Contents TOC \o "1-3" \h \z \u DOCUMENT CONTROL PAGEREF _Toc27487500 \h 2DOCUMENT APPROVAL PAGEREF _Toc27487501 \h 2DOCUMENT HISTORY PAGEREF _Toc27487502 \h 21.INTRODUCTION PAGEREF _Toc27487503 \h 71.1.Purpose of this Data Collection Manual PAGEREF _Toc27487504 \h 71.2.Guiding Principles PAGEREF _Toc27487505 \h 71.3.Innovation PAGEREF _Toc27487506 \h 72.GENERAL INFORMATION OF DATA ATTRIBUTION PAGEREF _Toc27487507 \h 82.1.Works condition and Defects PAGEREF _Toc27487508 \h 82.2.Geographic Location PAGEREF _Toc27487509 \h 82.3.Asset Types PAGEREF _Toc27487510 \h 92.4.Data Model PAGEREF _Toc27487511 \h 92.5.Asset Identifiers PAGEREF _Toc27487512 \h 102.6.Asset Condition PAGEREF _Toc27487513 \h 112.7.Asset Status PAGEREF _Toc27487514 \h 113.DATA ATTRIBUTES PAGEREF _Toc27487515 \h 123.1.Sign posts PAGEREF _Toc27487516 \h 123.2.Signs PAGEREF _Toc27487517 \h 143.3.Safety Barrier PAGEREF _Toc27487518 \h 163.4.Start\End Terminal PAGEREF _Toc27487519 \h 173.5.Motor Cycle Protection PAGEREF _Toc27487520 \h 183.6.Drainage PAGEREF _Toc27487521 \h 193.7.Inlet / Outlet / Junction PAGEREF _Toc27487522 \h 223.8.Fence / Gates PAGEREF _Toc27487523 \h 233.9.Stack Site PAGEREF _Toc27487524 \h 243.10.Borrow Pits PAGEREF _Toc27487525 \h 253.11.Retaining Walls PAGEREF _Toc27487526 \h 253.12.Rest Areas PAGEREF _Toc27487527 \h 263.13.Bins PAGEREF _Toc27487528 \h 273.14.Table PAGEREF _Toc27487529 \h 283.15.Seats PAGEREF _Toc27487530 \h 283.16.Shelter PAGEREF _Toc27487531 \h 293.17.Shed PAGEREF _Toc27487532 \h 303.18.Toilet Block PAGEREF _Toc27487533 \h 303.19.Water Tank PAGEREF _Toc27487534 \h 313.20.Help Phone PAGEREF _Toc27487535 \h 313.21.Medians PAGEREF _Toc27487536 \h 323.22.Pathways PAGEREF _Toc27487537 \h 333.23.Bollards PAGEREF _Toc27487538 \h 343.24.Fire Hydrates PAGEREF _Toc27487539 \h 353.25.Wind Socks PAGEREF _Toc27487540 \h 353.26.Urban Art PAGEREF _Toc27487541 \h 353.27.Arrestor Bed PAGEREF _Toc27487542 \h 363.28.Weigh Station PAGEREF _Toc27487543 \h 363.29.Park and Ride PAGEREF _Toc27487544 \h 373.30.Rock Slopes PAGEREF _Toc27487545 \h 383.31.Roadstrips PAGEREF _Toc27487546 \h 393.32.Bores PAGEREF _Toc27487547 \h 393.33.Dam PAGEREF _Toc27487548 \h 403.34.Grids PAGEREF _Toc27487549 \h 403.35.Floodways PAGEREF _Toc27487550 \h 413.36.Campsites PAGEREF _Toc27487551 \h 423.37.Maintenance Turn Arounds PAGEREF _Toc27487552 \h 423.38.Bridge PAGEREF _Toc27487553 \h 433.39.Busway Track PAGEREF _Toc27487554 \h 453.40.Tunnel PAGEREF _Toc27487555 \h 463.41.Gantry PAGEREF _Toc27487556 \h 483.42.Noise Wall PAGEREF _Toc27487557 \h 493.43.Safety Screen PAGEREF _Toc27487558 \h 503.44.Waste Oil Stations PAGEREF _Toc27487559 \h 503.45.Marinas PAGEREF _Toc27487560 \h 513.46.Jetties PAGEREF _Toc27487561 \h 523.47.Wharfs PAGEREF _Toc27487562 \h 543.48.Boat Ramps PAGEREF _Toc27487563 \h 543.49.Boatyards PAGEREF _Toc27487564 \h 553.50.Berthing Sturctures PAGEREF _Toc27487565 \h 563.51.Breakwaters PAGEREF _Toc27487566 \h 563.52.Piles PAGEREF _Toc27487567 \h 573.53.Pontoons PAGEREF _Toc27487568 \h 583.54.Fenders PAGEREF _Toc27487569 \h 593.55.Dolphins PAGEREF _Toc27487570 \h 593.56.Seawalls PAGEREF _Toc27487571 \h 603.57.Revetments PAGEREF _Toc27487572 \h 613.58.Causeways PAGEREF _Toc27487573 \h 623.59.Signal Controller PAGEREF _Toc27487574 \h 633.60.Switchboard PAGEREF _Toc27487575 \h 643.61.Electrical Poles PAGEREF _Toc27487576 \h 653.62.Lanterns (Traffic Signals) PAGEREF _Toc27487577 \h 673.63.Luminaires PAGEREF _Toc27487578 \h 693.64.Push Buttons PAGEREF _Toc27487579 \h 713.65.Camera (CCTV) PAGEREF _Toc27487580 \h 723.66.ITS Cabinet PAGEREF _Toc27487581 \h 733.67.Power Distribution Board PAGEREF _Toc27487582 \h 743.68.Uninterriptable Power Supply (UPS) PAGEREF _Toc27487583 \h 753.69.Over Height Detectors PAGEREF _Toc27487584 \h 753.70.Weather Stations PAGEREF _Toc27487585 \h 763.71.Pump PAGEREF _Toc27487586 \h 763.72.Jet Fan PAGEREF _Toc27487587 \h 773.73.Generators PAGEREF _Toc27487588 \h 773.74.Boom Barrier PAGEREF _Toc27487589 \h 783.75.Pits PAGEREF _Toc27487590 \h 783.76.Other Assets Types PAGEREF _Toc27487591 \h 79APPENDIX A – Data Interchange Format PAGEREF _Toc27487592 \h 80APPENDIX B - Examples of Asset Data Collection Detail PAGEREF _Toc27487593 \h 82ADDENDUMSRoads Addendum – Asset Types and Condition Examples……………………#12290952Road Structures Inspection ManualPart 2 – Deterioration of Structures…....…………………………..…#14677930Part 3 – Condition Rating of Structure Elements………………………#14677963Part 4A Condition State Guidelines - Bridges ……………………..…#14888945Part 4B Condition State Guidelines – Culverts……………………..…#14883939Part 4C Condition State Guidelines – Other Structures ……….……...#14883411Appendix A - Description of Structures and Structure Elements……….#14677975Wharf Structures Condition Assessment Manual………………………………...#8781070Electrical Addendum - Asset Types and Condition Examples…………………..#14816675INTRODUCTIONPurpose of this Data Collection ManualThis document is to be a compulsory requirement for all maintenance and construction works undertaken on DPTI assets. The data for all assets which have been altered or added as new to the network must be provided and entered as per this document.The purpose of this document is to ensure that all data provided by DPTI and external parties regarding ancillary road assets is provided in a consistent format.This data is to be then entered into the Asset Management Information System which will enable DPTI to undertake all of the required Asset Management functions in line with ISO55001.Guiding PrinciplesThe guiding principles, as stated in the Data Policy apply. These are:Collect data that is complete, accurate, up-to-date and consistentCollect only the data you needCollect data to the lowest level of detail sufficient to make appropriate decisionsCollect data only when it is required; andEnsure that it is accessible to those who need it.InnovationA fundamental principle is to allow flexibility and innovation in data collection by the provider, but still provide the data necessary for DPTI to undertake its required functions.The intent of this document is to allow data to be captured and provided within a more flexible set of rules which would allow the introduction of current and/or future alternatives as technology develops.The main driver for this change is the future requirements of both DPTI and the providers to have a geographical information system (GIS) capability. DPTI will not dictate the software and/or hardware to be used but rather set up some simple rules based around how data will be accepted in a GIS format.A core assumption is that if an asset location is provided in GPS coordinates then the GIS system will be able to derive all location based data attributes. This needs to be tested to explore the limitations and advantages.From GIS further data attributes can be derived by DPTI Asset Managers as follows:Road Number and NameRoad Running Distance and/or Maintenance MarkersCouncil AreasState ElectoratesSA Government RegionsFederal ElectoratesLength of asset, area, geometry of assetsMaintenance Providers, etcGENERAL INFORMATION OF DATA ATTRIBUTIONWorks condition and DefectsIt is assumed that data attributes related to maintenance works, condition, or defects on assets will be collected in a form of Maintenance Defect Register (MDR). The unique identifiers of the assets will be required to connect assets to their MDR information.Geographic LocationAsset classes will be represented by either Point, Linear (polyline) or Area (polygon) features in the spatial environment, using geographic coordinates (i.e. latitude and longitude) in decimal degrees.Geographic coordinates in the WGS84 Datum are to be used for exchange of asset location. Maintenance Provider systems may store location data in any coordinate system that suits their business needs, but the system must be capable of converting the data to WGS84 coordinates.Asset TypesFor all Asset types.DPTI will need to approve any proposed methods for capturing locational data for point, linear and area assets to ensure that our GIS system can read the proposed data and interpret it. An approved method can be found in Appendix A.Point AssetsA point asset is a single point in geographical space.Linear (Polyline) AssetsLinear Assets are different to point assets. A good example of this is a safety barrier which could follow the side of a windy road. It is important that the method chosen to represent Linear Assets shows the true location, approximate shape and length of the asset. A suggested method maybe a GPS unit that has the ability to capture track logs to capture the position, shape and length of a linear and/or curved asset.Area (Polygon) AssetsSimilar to Linear Assets but with the ability to calculate the area of the asset.Data ModelParent Child RelationshipsDifferent assets will require different Parent Child Relationships.E.g. sign post is the parent, the sign or signs are the child. As with all structures, the structure is the parent. The structure could be a bridge.E.g. the parking bay is the parent, the toilets, the shelter, the bins are the child.Asset IdentifiersTwo unique asset identifiers will be recorded for each asset.DPTI and the Maintenance provider will each assign their own unique identifiers for each asset and these will be recorded in the DPTI Asset register.The DPTI Asset ID will be generated by the DPTI Asset Management system to ensure uniqueness. The Provider will need to store this identifier in their system.The Maintenance provider will implement their own processes for assigning a unique asset identifier. The maintenance provider identifier must begin with the contract number “YYCNNN-xxxxxx”.The two asset identifiers will enable a two way data exchange between DPTI and the Provider. The following table list the business rules that will be used to interpret the data exchanged.ScenarioData exchange requirementProvider creates a new asset or identifies an asset missing from the register.DPTI Asset ID must be null (empty)Provider ID must be suppliedThe DPTI Asset Management system will allocate a new ID when the data is loaded into the system and the ID will be sent back to the Provider in the next data exchange cycleProvider updates an asset recordDPTI Asset ID must be suppliedProvider ID must be suppliedDPTI creates a new asset or identifies an asset missing from the registerDPTI Asset ID must be suppliedProvider ID must be nullThe Provider system will allocate a new ID when the data is loaded into their system and the ID will be sent back to DPTI in the next data exchange cycleDPTI updates an asset recordDPTI Asset ID must be suppliedProvider ID must be suppliedAsset ConditionConditionBelow is an asset condition assessment table to assist in determining condition grading and performance of assets. The attribute to be captured is either New, Good, Average, Poor or Unserviceable.1NewAs new2GoodNo corrosion or other deterioration3AverageSome deterioration but structural integrity satisfactory.(eg. some corrosion of steel but strength not affected)4PoorConsiderable deterioration so that structural integrity compromised.(eg. steel corroded to extent that strength may be affected, cracked concrete posts)5UnserviceableDeteriorated to extent that structural integrity is severely affected.(eg. severely corroded rail, spalled concrete posts, deteriorated timber components)For road asset condition examples refer to Addendums.For bridges, culverts, tunnels and bus way track the condition attribute is capture by using the bridge health index rating system.Asset StatusThe current status of Assets will be defined by the following table:1OperatingAsset in Use / Active / Connected2DecommissionedAsset has been Decommissioned / Disconnected3InvalidEntered in error / Not proceeded with install4RemovedAsset no longer exists5PendingAsset number has been reserved for future installDecommissioned or removal dates are to be added to the comments field for any decommissioned or removed asset that doesn’t have a removal date. DATA ATTRIBUTESAs per 1.2 Guiding Principles and 2.1 Data Test, the following are believed to be the minimal amount of information for which DPTI must have and will use. Refer to Appendix A for “Data Interchange Format”.Sign postsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)SP-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemNumber of PostsNumeric(1)1, 2, 3 or 4 fixed selectionValuation, depreciationPost SizeCodedAs per table, fixed selectionValuation, depreciationFrangibleDomainY or N fixed selectionSafety and cost implicationsFooting TypeCodedAs per table, fixed selectionMaintenance/AMPCoating TypeCodedAs per table, fixed selectionMaintenance/AMPInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationPost SizeCodeDescription1Steel 80x402Circular503Circular804Circular905Circular1006Circular1257Aluminium Frangible508Aluminium Frangible659Aluminium Frangible8010Aluminium Frangible9011Aluminium Frangible10012Steel I Beam Slip Base Posts14Timber Posts15Star Dropper17Steel-Flex18Poly-flex99OtherFooting TypeCodeDescription1Rubble2Sleeved3Concreted4Bolted99OtherCoating TypeCodeDescription1Galvanized2Painted3Powder Coated99OtherSignsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)SI-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset - Post\ Structure\ Bridge\ Weigh Station\ Gantry etcData relationship, valuation, costsSign TypeCodedAs per table, fixed selectionValuation, depreciationSign CodeAlpha Numeric(15)R1-1A Type, Size, cost, valueTES NumberAlpha Numeric(15)TES 16838 (L)Type, Size, cost, valueHeight (mm)Numeric(5)200 Valuation, depreciationWidth (mm)Numeric(5)400Valuation, depreciationMessageAlpha Numeric(255)“KEEP LEFT”Clarity of purpose for all data users.Dynamic TypeDomainAs per table, fixed selectionStatutory requirementsMaterial TypeCodedAs per table, fixed selectionValuation, depreciationAnti-graffiti CoatingDomainY or N fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationDate of ManufactureDateDD/MM/YYYYTo validate warrantyWarrantyNumeric(2)5 (yrs)AM Warranty obligationsCurrent ConditionCodedAs per table, fixed selectionValuation, depreciateCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciateShapePointGeographic locationSign Type codesCodeDescription1Regulatory2Warning3Guide4Hazard5Tourist6Service7Information8Directional9Maintenance Marker99OtherDynamic Type domainStaticCMSVMS*Static & LightsMaterial Type codeCodeDescription1Aluminium2PolycarbonateNote: Clearway signs are also to be entered*Examples Messages for VMSTRAVEL – Travel information signsTUNNEL – Tunnel information signsSPEED – Variable speed signsSafety BarrierAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)SB-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemSafety Barrier TypeCodedAs per table, fixed selectionType, Valuation, depreciationType of PostDomainAs per table, fixed selectionValuation, depreciationPost Spacing (m)Numeric(3,1)2Valuation, depreciationLength (m)Numeric(5)20Valuation, depreciationSpacer BlocksDomainAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePolylineGeographic locationSafety Barrier Type codesCodeDescription1Backing Rail2Bridge Rail3Concrete4Thrie Beam5Wire Rope Brifin6Wire Rope Sentryline7Wire Rope Flexfence8Ezy-Guard9W-Beam10Armourguard11BarrierGuard Gate13Masonry Wall14Aluminium RHS15Steel RHS16Steel Panel17Steel Pipe18Sentry W-Beam19Ezy-Guard High Containment99OtherType of Post domainTimberSteelConcreteAluminiumOtherSpacer Blocks domainNoneTimberSteelBothOtherNote: Add “Railing” into the comments where an additional railing is installed above barrier.Start\End TerminalAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)SB-TE-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Safety BarrierData relationship, valuation, costsTerminalDomain(Start, End)Start, EndData relationship, valuation, costsTerminal TypeCodedAs per table, fixed selectionType, Valuation, depreciationLength (m)Numeric(3)20Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationTerminal Type codesCodeDescription1Melt2BCT3SKT4ET2000Plus5FLEAT6TREND 3508X-Tension9Fishtail10Energy Absorbing End Terminal11Driveway12QuadGuard13TRACC14Universal TAU-II15Smart Cushion16EAPTB Stobie Buffer17Treefend18RAPTOR99OtherMotor Cycle ProtectionAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)SB-MC-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Safety BarrierData relationship, valuation, costsProtection TypeCodedAs per table, fixed selectionType, Valuation, depreciationLength (m)Numeric(3)20Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationProtection Type codesCodeDescription1Stack Cushion2Ingal MPR3HIASA SPM-ES299OtherDrainageAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)DR-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemStructure TypeCodedAs per table, fixed selectionValuation, depreciationMaterial TypeCodedAs per table, fixed selectionValuation, depreciationNumber of RunsNumeric(2)10Valuation, depreciationStandard Culvert DimensionsDomain450x300Valuation, depreciationNon-Standard Width (mm)Numeric(5)450Valuation, depreciationNon-Standard Height (mm)Numeric(5)300Valuation, depreciationNon-Standard Diameter (mm)Numeric(5)1500Valuation, depreciationLength (m)Numeric(5,1)10Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationStructure Type codesCodeDescription1Pipe Culvert2Box Culvert4Subsoil Drain5Grate6Lined Drain8Swale9Bioretension Swale10Arch11Wetland12Sedimentation Basin13Detention Basin14Floodway15Spoon Drain16Kerb & Gutter99OtherMaterial Type codesCodeDescription1Concrete - Precast2Galvanised3Steel (Corrugated)4Cast Iron5Other Plastic ,HDPE, PVC6Masonry7Concrete - Insitu8Aluminium 9Earthenware10Vegetated11Rock 99OtherCulvert Sizes DomainNon-Standard100 dia150 dia300 dia375 dia450 dia525 dia600 dia675 dia750 dia825 dia900 dia1050 dia1200 dia1350 dia1500 dia1650 dia1800 dia300x225450x300600x300600x450900x300900x6001200x3001200x6001200x9001200x12001500x6001500x7501500x9001500x12001500x1500Dimensions are internal.For standard types (i.e. pipe culverts, box culvert, subsoil drain grate and lined drains) closest dimension from the above domain must be selected.Non-standard types (i.e. bridge assets, grid, swale, bioretension swale, arch, wetland, sedimentation basin, detention basin and other), width and height or diameter must be recorded.Inlet / Outlet / JunctionAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)DR-IO -nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of DrainageData relationship, valuation, costsInlet / OutletDomain(Inlet, Outlet, Junction)Inlet, Outlet or Junction fixed selectionData relationship, valuation, costsStructure TypeCodedAs per table, fixed selectionValuation, depreciationMaterial TypeCodedAs per table, fixed selectionValuation, depreciationLid TypeCodedAs per table, fixed selectionValuation, depreciationSizeCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationStructural Type CodeCodeDescription1Headwall2SEP3Grate4SEP / Grate Combo5Field Gully6Junction Box7HUMEceptor8Stormceptor9Downstream Defender10EcoSol RSF 400011Gross Pollution Trap12Trash Nets13Driveable Endwall14Dual Driveable Endwall99OtherMaterial Type CodesCodeDescription1Concrete2Masonry3Rip-Rap4Gabion5Cast Iron99OtherLid Type codesCodeDescription1Standard2Heavy Duty3Super Heavy Duty99OtherSizes codesCodeDescription1Single2Double3TripleFence / GatesAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)FE-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Rest Area\ Weigh Station\ Jetties etc, if applicableData relationship, valuation, costsFence TypeCodedAs per table, fixed selectionValuation, depreciateLength (m)Numeric(3)10Valuation, depreciationAverage Height (m)Numeric(3,1)2.5Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationWarranty (yrs)Numeric(2)5AM Warranty obligationsCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationFence Type codesCodeDescription1Farm or Stock2Chainmesh3Pedestrian4Vermin Proof5Concrete Panel6Timber Panel8Security fence91200 Pedestrian Rail10600 Pedestrian Rail11Stock Gate12Pedestrian Gate13Security Gate14Motorised Security Gate99OtherNote: Colour code to be added to comments &Koala crossing mesh shall be recorded as “Other” with a note added to comments.Stack SiteGeographical data is required to show boundary and derive area.AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)ST-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemSize (m2)Numeric(6)100Size of assetCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationBorrow PitsGeographical data is required to show boundary and derive area.AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)BP-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemSize (m2)Numeric(6)100Size of assetCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationRetaining WallsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)RW-nnnnnn Unique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemBIS Plan NumberAlpha Numeric(10)5214200Data relationshipRetaining Wall TypeCodedAs per table, fixed selectionValuation, depreciateRoad LocatedCodedAs per table, fixed selectionMaintenance/AMPLength (m)Numeric(3)10Valuation, depreciationAverage Height (m)Numeric(3,1)2.2Valuation, depreciationMaximum Height (m)Numeric(3,1)3.3Maintenance/AMPInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationRetaining Wall Type codesCodeDescription1Concrete Block2Concrete Crib3Timber Crib4Gabion6Shotcrete7Stone Walling8Reinforced Concrete9Reinforced Earth – Concrete Faced10Reinforced Earth – Concrete Panels11Reinforced Earth – Gabion Faced12Reinforced Earth – Keystone*13Stone Pitched14Steel Post & Concrete Panel99OtherRoad Located codesCodeDescription1At Base of Wall2At Top of WallRest AreasGeographical data is required to show boundary and derive area.AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)RA-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemRest Area TypeCodedAs per table, fixed selectionValuation, depreciationSurface TypeCodedAs per table, fixed selectionValuation, depreciationSize (m2)Numeric(6)200Valuation, depreciationTruck ParkingDomainY or N fixed selectionMaintenance/AMPCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationRest Area Type codesCodeDescription1Major Rest Area2Minor Rest Area3Truck Parking Bays4Truck Informal ParkingRest Area Surface Type codesCodeDescriptionAAsphaltSSpray SealedUUnsealedOOtherNote: Add name of rest area into comments were applicable.BinsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)RA-BI-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Rest Area\ Weigh Station\ Jetties etcData relationship, valuation, costsMaterial TypeCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationBin Material Type codesCodeDescription1Plastic2Concrete3Metal99OtherTableAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)RA-TA-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Rest Area\ Weigh StationData relationship, valuation, costsMaterial TypeCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationTable Material Type codesCodeDescription1Metal2Wood3Concrete4Recycled Plastic99OtherSeatsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)RA-SE-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Rest Areas/ Jetties / Marinas / Boatyards/ CausewaysData relationship, valuation, depreciationConstruction TypeCodedAs per table, fixed selectionValuation, depreciationLength (m)Numeric (3,1)5.5Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationConstruction Type codesCodeDescription1Timber frame2Aluminium frame3Steel frame99OtherShelterAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)RA-SH-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Rest Area\ Weigh Station\ Jetty\ CausewayData relationship, valuation, costsSize (m2)Numeric(6)100 Valuation, depreciationConstruction TypeCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationConstruction Type codesCodeDescription1Cantilever2Truss3Sails4OtherShedAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)RA-SD-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Boatyard\ Marina etcData relationship, valuation, costsArea (m2)Numeric(6)100Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationToilet BlockAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)RA-TB-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Rest Area\ Weigh Station\ Jetties etc Data relationship, valuation, costsNumber of toiletsNumeric(2)2Valuation, depreciationToilet Connection TypeCodedAs per table, fixed selectionValuation, depreciationDisable Toilet AvailableDomainY or N fixed selectionValuation, depreciationSize (m2)Numeric(6)100Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationToilet Connection Type codesCodeDescription1Mains Water2Tank FeedWater TankAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)RA-WT-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Rest Area\ Weigh Station\ BoatyardData relationship, valuation, costsNumber of TanksNumeric(2)2Valuation, depreciationSize (m3)Numeric(6)2000Valuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationHelp PhoneAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha NumericPH-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha NumericYYCNNN-xxxxxxMust have unique ID to enter into our systemPower CodedAs per table, fixed selectionMaintenance/AMPCommunication TypeCodedAs per table, fixed selectionMaintenance/AMPInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha NumericMaintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationPower codesCodeDescription1240V Metered2240V Unmetered342V Metered442V Unmetered5Solar99OtherCommunication Type codesCodeDescription1Cellular – 3G2PSTN3PABX4Fibre Optic99OtherMediansAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)ME-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemMedian TypeCodedAs per table, fixed selectionValuation, depreciationMedian Infill TypeCodedAs per table, fixed selectionValuation, depreciationWidth (m)Numeric(3,1)2.4Valuation, depreciationLength (m)Numeric(5)9Valuation, depreciationIrrigation SystemDomainY or N fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCouncil MaintainedDomainY or N fixed selectionValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationMedian Type codesCodeDescription3Kerbed4Barrier5No edgeMedian Infill codesCodeDescription1Paved2Concrete3Asphalt4Synthetic Turf5Rubble6Grassed7Deciduous Trees8Mulched9Rocked Filled10Other LandscapingPathwaysAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)PW-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemPathway TypeCodedAs per table, fixed selectionValuation, depreciationSurface TypeCodedAs per table, fixed selectionValuation, depreciationLength (m)Numeric(5)200Valuation, depreciationWidth (m)Numeric(3,1)2.5Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationPathway Type codesCodeDescription1Pedestrian2Shared Use3Bicycle99OtherRest Area Surface Type codesCodeDescriptionAAsphaltSSpray SealedUUnsealedPPavedCConcreteOOtherNote: Add name of pathways into comments were applicable.BollardsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)BL-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemMaterialCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationMaterial CodesCodeDescription1Steel 2Timber3Concrete4Removable SteelNote: Key number for removable bollards added to comments.Fire HydratesAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)FH-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemLast Tested DateDateDD/MM/YYYYValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationWind SocksAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)WI-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemPost Height (m)Numeric (3,1)5.5Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationUrban ArtAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)UA-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemDescriptionAlpha Numeric(255)IdentificationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationArrestor BedGeographical data is required to show boundary and derive area.AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)AB-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemSurface TypeCodedAs per table, fixed selectionValuation, depreciationSize (m2)Numeric(6)200Valuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationArrestor Bed Surface Type codesCodeDescription1Gravel2OtherWeigh StationGeographical data is required to show boundary and derive area.AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)WS-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemTypeDomainBridge or Slab fixed selectionValuation, depreciationSurface TypeCodedAs per table, fixed selectionValuation, depreciationSize (m2)Numeric(6)2000Valuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationSurface Type codesCodeDescriptionAAsphaltSSpray SealedUUnsealedOOtherPark and RideGeographical data is required to show boundary and derive area.AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)PR-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemSurface TypeCodedAs per table, fixed selectionValuation, depreciationPark and Ride TypeCodedAs per table, fixed selectionValuation, depreciationSize (m2)Numeric(6)20000Valuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationSurface Type codesCodeDescriptionAAsphaltSSpray SealedUUnsealedOOtherType codesCodeDescription1Train2Tram3BusRock SlopesAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)SLP-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemTypeCodedAs per table, fixed selectionValuation, depreciationLength (m)Numeric(6)200Valuation, depreciationHeight (m)Numeric(3)20Valuation, depreciationAverage Angle (degrees)Numeric(3)30Maintenance/AMPKNet Report NumberNumeric(20)1234524Maintenance/AMPConstruction DateDateDD/MM/YYYYValuation, depreciationAssessed Risk Level (ARL)CodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationType codesCodeDescription1Rock2Soil3Rock and Soil99OtherAssessed Risk Level codesCodeDescription1Highest Risk2High Risk3Moderate Risk4Low Risk5Lowest RiskRoadstripsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)RS-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemSurface TypeCodedAs per table, fixed selectionValuation, depreciationSize (m2)Numeric(6)2000Valuation, depreciationLength (m)Numeric(6)200Valuation, depreciationWidth (m)Numeric(3)20Valuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationPark and Ride Surface Type codesCodeDescriptionAAsphaltSSpray SealedUUnsealedOOtherBoresAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)BO-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemDepth (m)Numeric(5)100Valuation, depreciationDiameter (m)Numeric(3,1)5.5Valuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationDamGeographical data is required to show boundary and derive area.AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)DA-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemArea (m2)Numeric(6)100Valuation, depreciationLinedDomainYes or No fixed selectionValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationNote: Add name of dam into comments were applicableGridsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)GR-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemType CodedAs per table, fixed selectionValuation, depreciationBaseCodedAs per table, fixed selectionValuation, depreciationLength (m)Numeric(3,1)2.5Valuation, depreciationWidth (m)Numeric(3,1)10.2Valuation, depreciationNumber of SpansNumeric(1)2Valuation, depreciationNumber of SteelsNumeric(3)5Valuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationType codesCodeDescription1Aprilla2Rocla3Gridrite99OtherBase codesCodeDescription1Poured Concrete2Culvert99OtherFloodwaysAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)FW-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemBase TypeCodedAs per table, fixed selectionValuation, depreciationLength (m)Numeric(3,1)2.5Valuation, depreciationWidth (m)Numeric(3,1)10.2Valuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationBase Type codesCodeDescription1Clay2Concrete3Gravel4Sealed5Stabilised6Unstabilised99OtherCampsitesAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)CS-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemArea (m2)Numeric(6)100Valuation, depreciationLength (m)Numeric(3,1)2.5Valuation, depreciationWidth (m)Numeric(3,1)10.2Valuation, depreciationAccess Rd SheetedDomainY or N fixed selectionValuation, depreciationCampsite SheetedDomainY or N fixed selectionValuation, depreciationRampDomainY or N fixed selectionValuation, depreciationWash Down bayDomainY or N fixed selectionValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationMaintenance Turn AroundsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)MT-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemCurrent ConditionCodedAs per table, fixed selectionData relationship, Valuation, costsCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationBridgeAttributeFormatExamplesWhy it is required andwhere it will be usedDPTI Asset IDAlpha Numeric(20)BD-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemBIS Plan NumberAlpha Numeric(10)5214Data relationshipLength (m)Numeric(4)50Valuation, depreciationOverall Width (m)Numeric(3)30Valuation, depreciationKerb to Kerb Width (m)Numeric(4,1)25Over-dimensional loads movement Barrier to Barrier Width (m)Numeric(4,1)27Over-dimensional loads movementClearance (m)(bridges over roads)Numeric(4,1) 15Over-dimensional loads movementConstruction YearDateDD/MM/YYYYValuation, depreciationDesign StandardCodedAs per table, fixed selectionMaintenance/AMPHeavy Load MovementStructure Analysis FlagCodedAs per table, fixed selectionHeavy Load MovementNumber of SpansNumeric(2)5Maintenance/AMPMaximum Span Length (m)Numeric(4,1)20Heavy Load MovementMinimum Span Length (m)Numeric(4,1)15Heavy Load MovementGirder TypeCodedAs per table, fixed selectionMaintenance/AMPHeavy Load MovementGirder Material TypeCodedAs per table, fixed selectionMaintenance/AMPHeavy Load MovementSteel girder corrosion protection systemAlpha Numeric(255)Provide details of corrosion protection system(See example)Maintenance/AMPAttached ServicesAlpha Numeric(255)Provide details of attached servicesMaintenance/AMPCurrent ConditionNumeric(5)Bridge Health IndexValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationDesign Standard codesCodeDescription1Unknown2HLGD3HS204T44 (1976)5T44 (1992)6SM16007Rail8Austroads (AS5100)9Rail – Cooper E5010Higher Mass Limits11HS1012HS15Structure Analysis Flag codesCodeDescription1Simply Supported2Continuous3BothGirder Material Type codesCodeDescription1Concrete2Prestressed Concrete3Steel4Masonry5Timber6Iron7PlasticGirder Type codesCodeDescription1Beam2Truss3Slab4Box5Arch6Cable7PlanksAttached ServicesExample – attached services details should include:Service type: communication, gas, power, water/sewer & otherNumber of servicesLocation of serviceI.e: 2 Electranet power cables suspended from deck between 2 and 3 girder from northSteel girder corrosion protection systemExample - Steel girder corrosion protection system consist of:Prime: Epoxy Zinc: Jotun Barrier (DFT 75 ?m)Intermediate: Epoxy: Jotun Penguard Express MIO (DFT 200 ?m)Finish: Polysiloxane: Jotun Hardtop Ultra (DFT 50 ?m)Busway TrackBusway tracks are to be captured as linear assetsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)BT-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemBIS Plan NumberAlpha Numeric(10)5214Data relationshipLength (m)Numeric(5)3410Valuation, depreciationConstruction YearDateDD/MM/YYYYValuation, depreciateCurrent ConditionNumeric(5)Bridge Health IndexValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationTunnelAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)TU-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemBIS Plan NumberAlpha Numeric(10)5214Data relationshipLength (m)Numeric(5)100Valuation, depreciateOverall Width (m)Numeric(4,1)8.5Valuation, depreciate.Kerb to Kerb Width (m)Numeric(4,1)8.5Over-dimensional loads movement Barrier to Barrier Width (m)Numeric(4,1)8.5Over-dimensional loads movementClearance (m)Numeric(4,1)4.5Over-dimensional loads movementConstruction YearDateDD/MM/YYYYValuation, depreciateNumber of SpansNumeric(4)10Maintenance/AMPCorrosion Protection SystemAlpha Numeric(255)Provide details of corrosion protection systemMaintenance/AMPCurrent ConditionNumeric(3)Bridge Health IndexValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationFor near surface tunnels under roads the following additional attributes requiredStructure Analysis FlagCodedAs per table, fixed selectionHeavy Load MovementMaximum Span Length (m)Numeric(4,1)5.5Heavy Load MovementMinimum Span Length (m)Numeric(4,1)2.5Heavy Load MovementGirder TypeCodedAs per table, fixed selectionMaintenance/AMP, Heavy Load MovementGirder Material TypeCodedAs per table, fixed selectionMaintenance/AMP, Heavy Load MovementStructure Analysis Flag codesCodeDescription1Simply Supported2Continuous3BothGirder Type codesCodeDescription1Beam2Truss3Slab4Box5Arch6Cable7PlanksGirder Material Type codesCodeDescription1Concrete2Prestressed Concrete3Steel4Masonry5Timber6Iron7PlasticCorrosion protection systemExample - Corrosion protection system consist of:Prime: Epoxy Zinc: Jotun Barrier (DFT 75 ?m)Intermediate: Epoxy: Jotun Penguard Express MIO (DFT 200 ?m)Finish: Polysiloxane: Jotun Hardtop Ultra (DFT 50 ?m)GantryAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)GA-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemBIS Plan NumberAlpha Numeric(10)5214200Data relationshipGantry TypeCodedAs per table, fixed selectionData relationship, valuation, costsLength (m)Numeric(3,1)24.5Valuation, depreciationPortal Column to Column width (m)Numeric(3,1)6.5Over-dimensional loads movement Portal vertical clearance (on left) (m)Numeric(3,1)5.5Over-dimensional loads movement Portal vertical clearance (on right) (m)Numeric(3,1)5.5Over-dimensional loads movement Cantilever vertical clearance (m)Numeric(3,1)5.5Over-dimensional loads movement Construction YearDateDD/MM/YYYYValuation, depreciateCorrosion protection systemAlpha Numeric(255)Provide details of corrosion protection systemMaintenance/AMPCurrent ConditionCodedAs per table, fixed selectionValuation, depreciateCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationGantry Type codesCodeDescription1Portal2Cantilever3Double Post (for CMS, VMS)4Single Post5Double Post6Single Post (for CMS, VMS)7Triple Post8Four Post9Mast Arm (for Traffic Signals)Example - Corrosion protection system consist of:Prime: Epoxy Zinc: Jotun Barrier (DFT 75 ?m)Intermediate: Epoxy: Jotun Penguard Express MIO (DFT 200 ?m)Finish: Polysiloxane: Jotun Hardtop Ultra (DFT 50 ?m)Noise Wall AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)NW-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemBIS Plan NumberAlpha Numeric(10)5214Data relationshipMaterial TypeCodedAs per table, fixed selectionValuation, depreciationLength (m)Numeric(5)356Valuation, depreciationMaximum Height (m)Numeric(3,1)3.3Valuation, depreciationAverage Height (m)Numeric(3,1)3.1Valuation, depreciationConstruction YearNumeric(2)5 (yrs)Valuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationMaterial Type codesCodeDescription1Reinforced Concrete2Steel3Corten99OtherSafety ScreenAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)SS-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemBIS Plan NumberAlpha Numeric(10)5214Data relationshipTypeCodedAs per table, fixed selectionValuation, depreciationLength (m)Numeric(5)356Valuation, depreciationMaximum Height (m)Numeric(3,1)3.3Valuation, depreciationAverage Height (m)Numeric(3,1)3.1Valuation, depreciationConstruction YearNumeric(2)5 (yrs)Valuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationType codesCodeDescription1Vertical 2CanopyWaste Oil StationsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)WO-nnnnnnMust have unique ID to enter into our systemMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemShed Area (m2)Numeric(5)100Valuation, sizeGate TypeCodedAs per table, fixed selectionValuation, depreciation Tank Storage Capacity (L)Numeric(5)200Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationGate Type codesCodeDescription1Sliding2RollerMarinasAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)MA-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemArea (m2)Numeric(6)200Valuation, depreciationSurface TypeCodedAs per table, fixed selectionValuation, depreciationSurface Area (m2)Numeric(6)20000Valuation, depreciationMarina TypeCodedAs per table, fixed selectionValuation, depreciationNumber BerthsNumeric(4)20Valuation, depreciationNumber of GangwaysNumeric(4)10Valuation, depreciationMarinas Current ConditionCodedAs per table, fixed selectionValuation, depreciationPump Capacity (kW)Numeric(5)2000Valuation, depreciationPump UseCodedAs per table, fixed selectionValuation, depreciationPump Installation DateDateDD/MM/YYYYValuation, depreciationPump Current ConditionCodedAs per table, fixed selectionValuation, depreciationDate of EstablishmentDateDD/MM/YYYYValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationMarina Type codesCodeDescription1Commercial2Commercial and RecreationalPump Use codesCodeDescription1Grey Water2Black Water3Fresh WaterSurface Type codesCodeDescriptionAAsphaltPPavedCConcreteUUnsealedOOtherJettiesAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)JE-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemBIS Plan NumberAlpha Numeric(10)5214200Data relationshipUseCodedAs per table, fixed selectionValuation, depreciationPredominate Width (m)Numeric(3,1)4.5Valuation, depreciationArea (m2)Numeric(3)100Valuation, depreciationLength (m)Numeric(3)50Valuation, depreciationBentsNumeric(3)20Valuation, depreciationJetty MaterialCodedAs per table, fixed selectionValuation, depreciationAbutmentMaterialsCodedAs per table, fixed selectionValuation, depreciationLower LandingsMaterialCodedAs per table, fixed selectionValuation, depreciationLower Landing Length (m)Numeric(3)10Valuation, depreciationLower Landing Installation DateDateDD/MM/YYYYValuation, depreciationStairs SetNumeric(3)20Valuation, depreciationNumber of TrolleysNumeric(3)5Valuation, depreciationLadder MaterialCodedAs per table, fixed selectionValuation, depreciationTotal LaddersNumeric(3)20Valuation, depreciationConditionCodedAs per table, fixed selectionData relationship, Valuation, costsCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationUse codesCodeDescription1Commercial2Recreational3Commercial and Recreational4Port Bonython 99 OtherMaterial codesCodeDescription1Steel2Aluminium3Timber4Concrete5Plastic6Rock99Other FRPWharfsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)WH-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemMaterialCodedAs per table, fixed selectionValuation, depreciationWidth (m)Numeric(3,1)20Valuation, depreciationLength (m)Numeric(3)100Valuation, depreciationArea (m2)Numeric(3)10000Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationMaterial codesCodeDescription1Timber2Asphalt3Unsealed and Asphalt4ConcreteBoat RampsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)BR-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemWidth (m)Numeric(3,1)15Valuation, depreciationLength (m)Numeric(3)15Valuation, depreciationSurface TypeCodedAs per table, fixed selectionValuation, depreciationNumber of LanesNumeric(2)2Installation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationMaterial codesCodeDescriptionCConcreteAAsphaltBoatyardsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)BY-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemArea (m2)Numeric(5)100Valuation, depreciationSurface TypeCodedAs per table, fixed selectionValuation, depreciationSurface Area (m2)Numeric(4)100Valuation, depreciationVessel NumberNumeric(4)100Valuation, depreciationBoat Ramp DomainY or N fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylgonGeographic locationSurface Type codesCodeDescriptionAAsphaltPPavedCConcreteUUnsealedOOtherBerthing SturcturesAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)BS-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemNumber of PlatformsNumeric(3)100Valuation, depreciationThrust Block Length (m)Numeric(4,1)200Valuation, depreciationThrust Block Width (m)Numeric(3,1)200Valuation, depreciationThrust Block Height (m)Numeric(3,1)200Valuation, depreciationStruts (m) (Length)Numeric(3,1)200Valuation, depreciationStruts (mm) (Diameter)Numeric(3)200Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationBreakwatersAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)BW-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemMaterial CodedAs per table, fixed selectionValuation, depreciationWidth (m)Numeric(3,1)20Valuation, depreciationLength (m)Numeric(3)100Valuation, depreciationAverage AHD top of Breakwater (m)Numeric(3,1)1.5Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationMaterial Type codesCodeDescription1Ballast2Limestone3Granite99OtherPilesAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)JE-PI-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID ofJetties\ Causeways\ Marinas\ Berthing StructureValuation, depreciationMaterialCodedAs per table, fixed selectionValuation, depreciationShapeDomainCircular or Square fixed selectionValuation, depreciationSize (mm)Numeric(4)600Valuation, depreciationThickness (mm)Numeric(3)16Valuation, depreciationInstallation dateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationMaterial codesCodeDescription1Timber2Steel3Plastic4ConcretePontoonsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)MA-PO-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID ofMarinas\ Boat RampsData relationship, valuation, depreciationSystemCodedAs per table, fixed selectionValuation, depreciationMaterialCodedAs per table, fixed selectionValuation, depreciationArea (m2)Numeric(3)100Valuation, depreciationNumber of HeaderNumeric(3)100Valuation, depreciationNumber of FingersNumeric(3)100Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationSystem codesCodeDescription1Fixed2FloatingMaterial codesCodeDescription1Concrete2Timber3PlasticFendersAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)JE-FD-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID ofJetties\ CausewaysData relationship, valuation, depreciationFender SystemCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationSystem codesCodeDescription1Fender Piles2Timber3Plastic4Tyre5Rubber ConeDolphinsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)JE-DO-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID ofJetties\ Causeways\ MarinaData relationship, valuation, depreciationTypeCodedAs per table, fixed selectionValuation, depreciationMaterialCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationType codesCodeDescription1Breasting2MooringMaterial codesCodeDescription1Concrete2Steel99OtherSeawallsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)JE-SW-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Jetties\ MarinaData relationship, valuation, depreciationMaterialCodedAs per table, fixed selectionValuation, depreciationHeight (m)Numeric(3,1)5.5Valuation, depreciationLength (m)Numeric(4)200Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationMaterial codesCodeDescription1Timber2Steel Sheet3Concrete sleeper4Concrete stepped with rocks5Concrete stepped6RockRevetmentsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)JE-RE-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Jetties\ MarinaData relationship, valuation, depreciationRevetment SystemCodedAs per table, fixed selectionValuation, depreciationHeight (m)Numeric(2)20Valuation, depreciationLength (m)Numeric(3)100Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolylineGeographic locationSystem codesCodeDescription1Timber2Steel Sheet3Concrete sleeper4Concrete stepped with rocks5Concrete stepped6RockCausewaysAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)JE-CW-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID ofJettiesData relationship, valuation, depreciationLength (m)Numeric(3)100Valuation, depreciationWidth (m) (toe to toe)Numeric(3,1)5.5Valuation, depreciationWidth (m) (Walking) Numeric(3,1)8.5Valuation, depreciationArea (m2)Numeric(4)500Valuation, depreciationPredominate MaterialCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePolygonGeographic locationPredominate Material codesCodeDescription1Formed Stone2Asphalt99OtherSignal ControllerAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)ITS-SC-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset – ITS Cabinet Data relationship, valuation, costsHousing / MountingCodedAs per table, fixed selectionValuation, depreciationSCATS ModemCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePointGeographic locationHousing / Mounting codesCodeDescription1Base/Ground Mounted2Pedestal Mounted3Pole Mounted4Gantry Mounted5Barrier Mounted6Bridge Mounted99OtherSCATS Modem codesCodeDescriptionRITS1Public Switched Telephone Network (PSTN)PSTN2Mobile (3G)3G3Asymmetric Digital Subscriber Line (ADSL)ADSL4Ethernet Wan (EW)EW99OtherSwitchboardAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)ITS-SW-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemSwitchboard TypeCodedAs per table, fixed selectionValuation, depreciateConnected DateDateDD/MM/YYYYValuation, depreciateCurrent ConditionCodedAs per table, fixed selectionValuation, depreciateCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePointGeographic locationSwitchboard Type CodesCodeDescriptionA3PILLAR (GREY)A2PILLAR (BEIGE)APILLAR (GREEN)BBOX (STEEL GREEN)MSMETERED SITES1STOBIE (GREY)UUNKNOWNS2STOBIE (BLACK)ISX - INDIVIDUAL SUPPLY (IN-GROUND)C2AT PDB SITEMXMETERED SITE - (NON-LIGHTING)C1TOP BOXIGSUBMERSIBLESSSTAINLESS STEEL (MARINE)Electrical PolesAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)EP-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset – Signal Controller, Switchboard Data relationship, valuation, costsPole TypeCodedAs per table, fixed selectionValuation, depreciationFooting Type CodedAs per table, fixed selectionValuation, depreciationSurrounding SurfaceCodedAs per table, fixed selectionMaintenance contractual requirementHeightNumeric(3,1)10.5Valuation, depreciate.Outreach TypeCodedAs per table, fixed selectionValuation, depreciate.Outreach LengthNumeric(3,1)4.5Valuation, depreciate.Pole Installation DateDateDD/MM/YYYYValuation, depreciationPole Current ConditionCodedAs per table, fixed selectionValuation, depreciationBase Installation DateDateDD/MM/YYYYValuation, depreciationBase Current ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationPole Type codesCodeDescriptionSTBStobie PoleSBSlip BaseNOLNo Pole (luminaire only)MTTMunicipal Tramways TrustOTHGalvanised Pole (Jetty Structure)IAImpact AbsorbingOCTSolidBBBuried Base (not laser cut)RBBridge StructureUNKUnknownCMCombo Signal on Mast ArmCRTCombo Signal on PoleSTDStobie & Long Pipe non TariffSTCStobie & Long PipeSTEImpact Absorbing (Buried Base) ETSA typeOC1Custom & Mast Arm (for camera)OCT3Solid (Hinged)IA0Impact Absorbing (Ornamental)IA1Impact Absorbing (Buried Base) DTEI TypeC1Camera Pole 9mC2Camera Pole 12mC3Camera Pole 15mBComboCCombo Mast ArmWCOMMS PoleGGantryIIn-Ground LightMMast ArmITSOther EquipmentDPedestalXRail CrossingLRL PoleCFRLC – Camera and FlashRRLC – CameraFRLC – FlashT1RLC – Data Access PoleSStobieTStubPTS PoleTBTop BoxOEROtherFooting Type codesCodeDescription1Squat2Piled99OtherSurrounding Surface codesCodeDescription1Hard 2Soft / VegetatedOutreach Type codesCodeDescription1None2Single3Double4Quod99OtherNote: Pole may have two unique identification numbers. Enter traffic signal pole number followed by luminaire number, separated with comma.Lanterns (Traffic Signals)AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)EP-LT-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset – Electrical Pole, gantry etc, Data relationship, valuation, costsDisplay TypeCodedAs per table, fixed selectionValuation, depreciate.SizeCodedAs per table, fixed selectionValuation, depreciate.No. of Aspects Domain1,2,3, fixed selectionValuation, depreciate.No. of Red AspectDomain0,1,2,3, fixed selectionValuation, depreciate.No. of Yellow AspectDomain0,1,2,3, fixed selectionValuation, depreciate.No. of Green AspectDomain0,1,2,3, fixed selectionValuation, depreciate.No. of White AspectDomain0,1,2,3, fixed selectionValuation, depreciate.Installation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePointGeographic locationDisplay Type codesCodeDescriptionAARROWBBUSCCYCLEDDISCEEmergency VehiclesFArrow/CrossGTimer/PedIPavement (ON)I2Pavement (AM)I3Pavement (PM)MDISC/TRAMPPEDSA/A/DISCTTRAMWD/D/ARROWXCROSSSize codesCodeDescription37LED 10.5V Aldridge 200mm45240 Aldridge 200mm43240 OTHERS 200mm46240 SIEMENS 200mm70LED 9V ATS 200mm80LED Dual Voltage ATS 200mm66LED 42V ELV ATS 200mm94LED BRAUMS 42V ELV 200mm39KRYPTON Aldridge 200mm125LED BRAUMS 200mm41QUARTZ HALOGEN Aldridge 200mm6LED 10.5V Aldridge 300mm47240 Aldridge 300mm44240 OTHERS 300mm48240 SIEMENS 300mm69LED 9V ATS 300mm81LED Dual Voltage ATS 300mm65LED 42V ELV ATS 300mm101LED BRAUMS 42V ELV 300mm40KRYPTON Aldridge 300mm83LED BRAUMS 300mm42QUARTZ HALOGEN Aldridge 300mm124LED Pavement LightLuminairesAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IdAlpha Numeric(20)EP-LU-nnnnnnUnique ID allocated by DPTIMtce Provider IdAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemPole NumberAlpha Numeric(20)Unique ID of Parent Asset – Electrical Pole, StructureData relationship, valuation, costsCircuit NumberAlpha Numeric(20)2Data relationship, valuation, costsPhase CodedAs per table, fixed selectionValuation, depreciationLuminaire TypeCodedAs per table, fixed selectionValuation, depreciationMakeCodedAs per table, fixed selectionValuation, depreciationWatt (W)Numeric(5,1)250Valuation, depreciationLens TypeCodedAs per table, fixed selectionValuation, depreciationController TypeCodedAs per table, fixed selectionValuation, depreciationConnected DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciateCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePointGeographic locationPhase codesCodeDescriptionREDRedWHITEWhiteBLUEBlueLuminaire Type codesCodeDescription1LED2FLUORESCENT3SODIUM4SOLAR5COMPACT FLUORESENT6DI CROIC7MERCURY8METAL HALIDE99OtherMake codesCodeDescriptionPECPecan GECGEC PHILPhillips REXRexel SYLSylvania OSROsram IBIRainbird THOThornGTGreenThinking solar L1Lamptech/GigaterraMOMoonlighting – Cellite LED1Unilumin LED2LRL AAldridge ATS V2VersaluxW1WE-EF P1Pierlite R1RUUD Lens Type codesCodeDescriptionLEN1Aero ScreenLEN2Optispan StandardLEN3Semi Cut OffLEN4Type 2 (Side Throw)LEN5Type 3 (Forward Throw)LEN6OptimaLEN7RoadsterLEN8Boston 3Control Type codesCodeDescriptionPEPhoto Electric CellSPShorting PlugSCSmart CellDDirectPush ButtonsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)EP-PB-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset – Electrical Pole, gantry etc, Data relationship, valuation, costsTypeCodedAs per table, fixed selectionValuation, depreciate.Installation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePointGeographic locationButton Type codesCodeDescription1Audio Tactile Push Button2Cyclist Push Button3Push Button99OtherCamera (CCTV)AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)EP-CM-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset – Electrical Pole, gantry etc, Data relationship, valuation, costsTypeCodedAs per table, fixed selectionValuation, depreciate.Installation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePointGeographic locationType codesCodeDescription1Pan Tilt Zoom (CAM)2Fixed (CAM) 3Video Incident Detention (CAM)4Thermal Incident Detection (CAM)5Red Light Speed6Safety Cam7Point to Point99OtherITS CabinetAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)ITS-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemCabinet ConfigurationCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePointGeographic locationCabinet Configuration codesCodeDescription1Single Door2Double Door99OtherPower Distribution BoardAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)ITS-PD-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset – ITS CabinetData relationship, valuation, costsTypeCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePointGeographic locationType codesCodeDescription1Metered Type A2Metered Double Door3Meter / Unmetered Switchboard99OtherUninterriptable Power Supply (UPS)AttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)ITS-UPS-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset – ITS Cabinet Data relationship, valuation, costsTypeCodedAs per table, fixed selectionValuation, depreciate.Installation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePointGeographic locationType codesCodeDescription1ECUPS2ICUPS99OtherOver Height DetectorsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)OH-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset – Bridge, TunnelData relationship, valuation, costsHeight (m)Numeric(3,1)4.2Valuation, depreciate.Installation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPRemoval DateDateDD/MM/YYYYValuation, depreciationShapePointGeographic locationWeather StationsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)WE-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationPumpAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)PU-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemCapacity (Lts)Numeric(20)1000Valuation, depreciationCommunication TypeCodedAs per table, fixed selectionValuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationCommunication Type codesCodeDescription1Cellular – 3G2PSTN3PABX4Fibre Optic99OtherJet FanAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)TU-JF-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset – TunnelData relationship, valuation, costsInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationGeneratorsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)GE-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemFuel Capacity (Litres)Numeric(5)120Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationBoom BarrierAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)BB-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemLength (m)Numeric(3,1)5.2Valuation, depreciationInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationPitsAttributeFormatExamplesWhy it is required and where it will be usedDPTI Asset IDAlpha Numeric(20)EP-PT-nnnnnnUnique ID allocated by DPTIMtce Provider IDAlpha Numeric(20)YYCNNN-xxxxxxMust have unique ID to enter into our systemParentAlpha Numeric(20)Unique ID of Parent Asset – Electrical Poles, Detectors etcData relationship, valuation, costsMaterial TypeCodedAs per table, fixed selectionValuation, depreciate.SizeDomainP2, P3, P4 or P5 Fixed SectionValuation, depreciate.LockableDomainY or N fixed selectionMaintenance/AMPInstallation DateDateDD/MM/YYYYValuation, depreciationCurrent ConditionCodedAs per table, fixed selectionValuation, depreciationCommentsAlpha Numeric(255)Maintenance/AMPAsset StatusCodedOperatingMaintenance/AMPShapePointGeographic locationMaterial TypeCodeDescription1Concrete2Metal3Asbestos4Plastic5Wood99OtherOther Assets TypesA preliminary list of other assets that maybe added to this document are shown below:Pavement Marking, as per traffic layout drawingsMedians: Butterfly, interchange arrangements, roundabouts, kerb rampsGeotechnical , rock netting, soil nails etcITS Monitoring systems, underground cablingTheir corresponding attributes will be developed as the document matures/develops.APPENDIX A – Data Interchange FormatFile FormatData interchange files will be in CSV (comma separated) format with each Asset Class supplied as separate file.The following dot points specify the general characteristics applicable to data interchange files.The first line in an interchange file provides the names of the attributes in the sequence that their values will appear in every subsequent line of the file. Each of the rest of the lines in the file represent a separate asset occurrence and provide the values of the asset’s attributes in the same sequence as the attributes in the first line of the file.The attribute names must be spelled precisely as presented within this document, although the spelling is case insensitive. Note that attribute names contain only alpha-numeric characters with one space between words.Every attribute name in the first line of a file must be unique.Attributes can be in any order, but their order is determined by the attribute names in the first line of the file.The first line must include the ‘DPTI Asset ID’.Every attribute supplied with a value must conform to its specified format (alphabetic, alpha-numeric, decimal, integer or date), which must not contain any characters other than alphabetic, numeric, “.” (period), or spaces.Date attributes shall be in the following format: DD/MM/YYYYIf an attribute is specified with a set of coded or domain values, then any value supplied for the attribute must be in the code or domain list.When adding an new asset occurrence, as indicated by ‘DPTI Asset ID’ or “Provider Asset ID” not being supplied:every required identification and location attribute must be supplied with a valid value or the record will not be added;every detail attribute required for completeness not supplied with a valid value will be reported with an incompleteness warning.Geographic location i.e. shape fields shall be supplied in OGC WKT format. The formal definition for this format is available on the Open GeoSpatial Consortium website (). However, for the purposes of this specification, only five simple geometry formats are required viz. POINT, LINESTRING, POLYGON, MULTISTRING and MULTIPOLYGON. Examples:POINT“POINT (Longitude Latitude)”POLYLINE“LINESTRING (Longitude Latitude, Longitude Latitude, Longitude Latitude)”“MULTISTRING ((Longitude Latitude, Longitude Latitude, Longitude Latitude))”POLYGON“POLYGON ((Longitude Latitude, Longitude Latitude, Longitude Latitude))”“MULTIPOLYGON (((Longitude Latitude, Longitude Latitude, Longitude Latitude)))”Shape field accuracy is to be to five (5) decimal places.Latitude must be shown as a negative.Interchange mechanismData will be transferred between DPTI and Maintenance Contractors using Amazon Web Services (AWS) S3 storage. DPTI will provision the S3 storage bucket. Contractors will be provided with access credentials to securely upload and download interchange files.FrequencyData will be exchanged between DPTI and the Maintenance Provider in accordance with the contract.APPENDIX B - Examples of Asset Data Collection DetailSign Posts – Asset Data DetailGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDNumber of PostsPost SizeFrangibleFooting TypeCoating TypeInstallation DateCurrent ConditionCommentsAsset StatusShapeSP-1254YYCNNN-xxxxxx1Circular80NSleevedGalvanized17/10/2016PoorOperatingPointSigns – Asset Data DetailGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentSignTypeSignCodeTESNumberHeight (mm)Width (mm)MessageDynamicTypeMaterialTypeAnti-graffitiCoatingInstallationDateDate ofManufactureWarrantyCurrentConditionCommentsAsset StatusRemoval DateShapeSI-2324YYCNNN-xxxxxxSP-1254GuideR1-1A1683810002000WEEROONA ISLANDStaticAluminiumN30/10/200617/10/20065PoorOperating17/10/2019PointSafety Barrier – Asset Data DetailGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDSafety Barrier TypeType of PostPost Spacing(m)Length(m)SpacerBlocksInstallationDateCurrentConditionCommentsAsset StatusRemoval DateShapeSB-9861YYCNNN-xxxxxxW-BeamSteel450Steel20/01/2010GoodOperating17/10/2019PolylineStart\End Terminal – Asset Data DetailGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentTerminalTerminal TypeLength (m)InstallationDateCurrentConditionCommentsAsset StatusShapeSB-TE-5645YYCNNN-xxxxxxSB-9861StartMelt1620/01/2005PoorOperatingPointDPTI Asset IDMtce Provider IDParentTerminalTerminal TypeLength (m)InstallationDateCurrentConditionCommentsAsset StatusShapeSB-TE-5646YYCNNN-xxxxxxSB-9861EndMelt1620/01/2005AverageOperatingPointMotor Cycle Protection – Asset Data DetailGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentProtection TypeLength (m)Installation DateCurrentConditionCommentsAsset StatusShapeSB-MC-5647YYCNNN-xxxxxxSB-9861Stack Cushion2020/01/2009AverageOperatingPolylineDrainageGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDStructureTypeMaterialTypeNumber ofRunsStandard Culvert DimensionsNon-Standard Width (mm)Non-Standard Height (mm)Non-Standard Diameter (mm)Length(m)InstallationDateCurrentConditionCommentsAsset StatusShapeDR-1098YYCNNN-xxxxxxPipe CulvertConcrete1300 x 2251700100022001520/10/1990GoodOperatingPolylineInlet / Outlet / JunctionGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTI.DPTI Asset IDMtce Provider IDParentInlet / OutletStructure TypeMaterial TypeLid TypeSizeInstallationDateCurrentConditionCommentsAsset StatusShapeDR-IO-1100YYCNNN-xxxxxxDR-1098InletSEPConcreteStandardDouble20/10/1990AverageOperatingPointDPTI Asset IDMtce Provider IDParentInlet / OutletStructure TypeMaterial TypeLid TypeSizeInstallationDateCurrentConditionCommentsAsset StatusShapeDR-IO-8565YYCNNN-xxxxxxDR-1098OutletHeadwallRip-RapN/AN/A20/10/1990AverageOperatingPointFence / GatesGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentFenceTypeLength(m)Average Height(m)InstallationDateWarranty(yrs)CurrentConditionCommentsAsset StatusShapeFE-7586YYCNNN-xxxxxxRA-8490Chainmesh502.125/08/1975UnknownPoorOperatingPolylineStack SiteGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDSize (m2)CommentsAsset StatusShapeST-6572YYCNNN-xxxxxx100OperatingPolygonBorrow PitsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDSize (m2)CommentsAsset StatusShapeBP-6572YYCNNN-xxxxxx100OperatingPolygonRetaining WallsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDBIS Plan NumberRetaining Wall TypeRoad LocatedLength (m)Average Height (m)Maximum Height (m)Installation DateCurrent ConditionCommentsAsset StatusShapeRW-3576YYCNNN-xxxxxx2014021GabionAt Base of Wall502.0414/06/2016NewOperatingPolylineRest AreasGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTDPTI Asset IDMtce Provider IDRest Area TypeSurface TypeSize (m2)Track ParkingCurrent ConditionCommentsAsset StatusShapeRA-8490YYCNNN-xxxxxxMajor Rest AreaAsphalt200YesAverageOperatingPolygonBinsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentMaterial TypeInstallation DateCurrent ConditionCommentsAsset StatusShapeRA-BI-1930YYCNNN-xxxxxxRA-BI-8490Concrete15/03/2006AverageOperatingPointTableGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentMaterial TypeInstallation DateCurrent ConditionCommentsAsset StatusShapeRA-TA-2001YYCNNN-xxxxxxRA-TA-8490Recycled Plastic26/08/2005AverageOperatingPointSeatGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentConstruction TypeLengthInstallation DateCurrent ConditionCommentsAsset StatusShapeRA-SE-8946YYCNNN-xxxxxxRA-SE-8490Timber Frame501/08/2006GoodOperatingPointShelterGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentSize (m2)Construction TypeInstallation DateCurrent ConditionCommentsAsset StatusShapeRA-SH-5983YYCNNN-xxxxxxRA-SH-84909Cantilever01/07/2003AverageOperatingPointShedGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentArea (m2)Installation DateCurrent ConditionCommentsAsset StatusShapeRA-SD-4568YYCNNN-xxxxxxRA-SD-56485001/08/2005PoorOperatingPointToilet BlockGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentNumber of ToiletsToilet Connection TypeDisable Toilet AvailableSize (m2)Installation DateCurrent ConditionCommentsAsset StatusShapeRA-TB-4127YYCNNN-xxxxxxRA-TB-84902Mains WaterY906/11/2001GoodOperatingPointWater TankGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentNumber of TanksSize (m3)Installation DateCurrent ConditionCommentsAsset StatusShapeRA-WT-7347YYCNNN-xxxxxxRA-WT-84902200001/08/2006GoodOperatingPointHelp PhoneGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDPowerCommunication TypeCurrent ConditionCommentsAsset StatusShapePH-6918YYCNNN-xxxxxx240V MeteredPSTNGoodOperatingPointMediansGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDMedian TypeMedian Infill TypeWidth (m)Length (m)Irrigation SystemInstallation DateCouncil MaintainedCurrent ConditionCommentsAsset StatusShapeME-8998YYCNNN-xxxxxxKerbedPaved29Yes17/03/2014NoPoorOperatingPolylinePathwaysGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDPathway TypeSurface TypeLength (m)Width (m)Current ConditionInstallation DateCommentsAsset StatusShapePW-4861YYCNNN-xxxxxxPedestrianPaved1002.5Good6/04/16OperatingPolylineBollardsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDMaterialRemovableInstallation DateCurrent ConditionCommentsAsset StatusShapeBL-1657YYCNNN-xxxxxxSteelYes30/02/2018NewOperatingPointFire HydratesGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDLast Tested DateInstallation DateCurrent ConditionCommentsAsset StatusShapeWI-8998YYCNNN-xxxxxx17/03/201717/03/2014GoodOperatingPointWind SocksGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDPost HeightInstallation DateCurrent ConditionCommentsAsset StatusShapeWI-8998YYCNNN-xxxxxx5.517/03/2014GoodOperatingPointUrban ArtGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDDescriptionInstallation DateCurrent ConditionCommentsAsset StatusShapeUA-8965YYCNNN-xxxxxxSnake Wall23/09/2014GoodOperatingPointArrestor BedGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDSurface TypeSize (m2)Current ConditionCommentsAsset StatusShapeAB-1547YYCNNN-xxxxxxGravel500AverageOperatingPolygonWeigh StationGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDTypeSurface TypeSize (m2)Current ConditionCommentsAsset StatusShapeWS-3716YYCNNN-xxxxxxBridgeAsphalt300GoodOperatingPolygonPark and RideGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDSurface TypePark and Ride TypeSize (m2)Current ConditionCommentsAsset StatusShapePR-8999YYCNNN-xxxxxxAsphaltTram1000GoodOperatingPolygonRock SlopesGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDTypeLength (m)Height (m)Average Angle (degrees)KNet Report NumberConstruction DateAssessed Risk Level (ARL)CommentsAsset StatusShapePR-8999YYCNNN-xxxxxxRock2002030123452401/08/1985GoodOperatingPolygonRoadstripsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDSurface TypeSize (m2)Length (m)Width (m)Current ConditionCommentsAsset StatusShapeRS-8999YYCNNN-xxxxxxAsphalt200020010GoodOperatingPolylineBoresGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDDepth (m)Diameter (m)Current ConditionCommentsAsset StatusShapeBO-8249YYCNNN-xxxxxx1005.5GoodOperatingPointDamGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDArea (m2)LinedCurrent ConditionCommentsAsset StatusShapeDA-8954YYCNNN-xxxxxx100YesGoodOperatingPolygonGridsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDTypeBase Length (m)Width (m)Number of SpansNumber of SteelsCurrent ConditionCommentsAsset StatusShapeGR-8249YYCNNN-xxxxxxAprillaCulvert2.510.225AverageOperatingPointFloodwaysGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDBase Type Length (m)Width (m)Current ConditionCommentsAsset StatusShapeFW-1257YYCNNN-xxxxxxConcrete2.510.2AverageOperatingPointCampsitesGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDArea (m2)Length (m)Width (m)Access Rd SheetedCampsite SheetedRampWash Down BayCurrent ConditionCommentsAsset StatusShapeCS-5487YYCNNN-xxxxxx1005020YesYesNoNoPoorOperatingPolygonMaintenance Turn AroundsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDCurrent ConditionCommentsAsset StatusShapeMT-5765YYCNNN-xxxxxxNewOperatingPointBridgeGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDBIS Plan NumberLength (m)Overall Width (m)Kerb to Kerb Width (m)Barrier to Barrier Width (m)Clearance (m)(bridges over roads)Construction YearDesign StandardStructure Analysis FlagNumber of SpansMaximum Span Length (m)Minimum Span Length (m)BD-2576YYCNNN-xxxxxx5214200503025271501/08/1985SM1600Simply Supported52015Girder TypeGirder Material TypeSteel girder corrosion protection systemAttached ServicesCurrent ConditionsAsset StatusCommentsShapeBeamConcretePrime: Epoxy Zinc: Jotun Barrier (DFT 75 ?m)Intermediate: Epoxy: Jotun Penguard Express MIO (DFT 200 ?m)Finish: Polysiloxane: Jotun Hardtop Ultra (DFT 50 ?m)2 Electranet Power Cables suspended from deck between 2 and 3 girder from north80OperatingPointBusway TrackGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDBIS Plan NumberLength (m)Construction YearCurrent ConditionCommentsAsset StatusShapeBT-2579YYCNNN-xxxxxx5214200341001/08/198660OperatingPolylineTunnelGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDBIS Plan NumberLength (m)Overall Width(m)Kerb to Kerb width (m)Barrier to Barrier Width (m)Clearance (m)Construction YearNumber of SpansCorrosion protection systemCurrent ConditionCommentsAsset StatusShapeTU-1579CYYCNNN-xxxxxx5214200200645401/08/19888Prime: Epoxy Zinc: Jotun Barrier (DFT 75 ?m)Intermediate: Epoxy: Jotun Penguard Express MIO (DFT 200 ?m)Finish: Polysiloxane: Jotun Hardtop Ultra (DFT 50 ?m)70OperatingPointAdditional attributes for near surface tunnels under roads.Structure Analysis FlagMaximum Span Length (m)Minimum Span Length(m)Girder TypeGirder Material TypeSimply Supported3020ArchSteelGantryGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDBIS Plan NumberGantry TypeLength(m)Portal Column to Column width (m)Portal vertical clearance (on left) (m)Portal vertical clearance (on right) (m)Cantilever Vertical Clearance (m)Construction YearCorrosion protection systemCurrent ConditionCommentsAsset StatusShapeGA-3681YYCNNN-xxxxxx5214200Double Post4433301/08/2012Prime: Epoxy Zinc: Jotun Barrier (DFT 75 ?m)Intermediate: Epoxy: Jotun Penguard Express MIO (DFT 200 ?m)Finish: Polysiloxane: Jotun Hardtop Ultra (DFT 50 ?m)50OperatingPointNoise WallGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDBIS Plan NumberMaterial TypeLength (m)Maximum Height (m)Average Height (m)Construction YearCurrent ConditionCommentsAsset StatusShapeNW-4638YYCNNN-xxxxxx6024241Reinforced Concrete203301/08/2012NewOperatingPolylineSafety ScreenGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDBIS Plan NumberTypeLength (m)Maximum Height (m)Average Height (m)Construction YearCurrent ConditionCommentsAsset StatusShapeSS-1576YYCNNN-xxxxxx5124Canopy203301/08/2012GoodOperatingPolylineWaste Oil StationsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDShed Area (m2)Gate TypeStorage Tank Capacity (L)Installation DateCurrent ConditionCommentsAsset StatusShapeWO-5125YYCNNN-xxxxxx100Sliding20001/08/2012GoodOperatingPolygonMarinasGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDArea (m2)Surface TypeSurface Area (m2)Marina TypeNumber of BerthsNumber of GangwaysMarinas Current conditionPump Capacity (kW)Pump UsePump Installation DatePump Current ConditionDate of EstablishmentCommentsAsset StatusShapeMA-9541YYCNNN-xxxxxx2000Paved500Recreational201022000Grey Water20/10/2016Average20/05/00OperatingPolygonJettiesGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDBIS Plan NumberUsePredominate Width (m)Area (m2)Length (m)BentsJetty MaterialAbutment MaterialLower Landing MaterialLower Landing Length (m)Lower Landing Installation DateStair SetsNumber of TrolleysLadder MaterialJE-9844YYCNNN-xxxxxx5201625Recreational520010010TimberConcreteTimber2020/05/201652AluminiumTotal LaddersConditionCommentsAsset StatusShape5GoodOperatingPolygonWharfsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDMaterialWidth (m)Length (m)Area (m2)Installation DateCurrent ConditionCommentsAsset StatusShapeWH-3697YYCNNN-xxxxxxAsphalt1010020020/05/2000PoorOperatingPolygonBoat RampsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDWidth (m)Length (m)Surface TypeNumber of LanesInstallation DateCurrent ConditionCommentsAsset StatusShapeBR-4587YYCNNN-xxxxxx1550Concrete220/06/2016AverageOperatingPolylineBoatyardsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDArea (m2)Surface TypeSurface Area (m2)Vessel NumberBoat RampInstallation DateCurrent ConditionCommentsAsset StatusShapeBY-210YYCNNN-xxxxxx2000Asphalt10020Yes16/02/1992GoodOperatingPolygonBerthing StructureGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDNumber of Platforms)Thrust Block Length (m)Thrust Block Width (m)Thrust Block Height (m)Struts (m) (Length)Struts (mm) (Diameter)Installation DateCurrent ConditionCommentsAsset StatusShapeBS-1248YYCNNN-xxxxxx1052.55260030/05/2004PoorOperatingPolylineBreakwaterGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDMaterialWidth (m)Length (m)Average AHD top of Breakwater (m)Installation DateCurrent ConditionCommentsAsset StatusShapeBW-2489YYCNNN-xxxxxxBallast51001.503/07/2006NewOperatingPolylinePilesGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentMaterialShapeSize (mm)Thickness (mm)Installation DateCurrent ConditionCommentsAsset StatusShapeJE-PI-3578YYCNNN-xxxxxxJE-9005ConcreteCircular6001603/07/2006GoodOperatingPointPontoonsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentSystemMaterialArea (m2)Number of HeaderNumber of FingersInstallation DateCurrent ConditionCommentsAsset StatusShapeMA-PO-6971YYCNNN-xxxxxxMA-9005FixedConcrete10104013/09/2005GoodOperatingPolygonFenderGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentFender SystemInstallation DateCurrent ConditionCommentsAsset StatusShapeJE-FD-3678YYCNNN-xxxxxxJE-9005Plastic13/09/2005AverageOperatingPointDolphinsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentTypeMaterialInstallation DateCurrent ConditionCommentsAsset StatusShapeJE-DO-9874YYCNNN-xxxxxxJE-9005BreastingConcrete20/02/2008GoodOperatingPointSeawallsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentMaterialHeight (m)Length (m)Installation DateCurrent ConditionCommentsAsset StatusShapeJE-SW-5871YYCNNN-xxxxxxJE-9005Rock510009/10/2014PoorOperatingPolylineRevetmentsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentRevetment SystemHeight (m)Length (m)Installation DateCurrent ConditionCommentsAsset StatusShapeJE-RE-6971YYCNNN-xxxxxxJE-9005Concrete Sleeper510009/10/2014PoorOperatingPolylineCausewaysGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentLength (m)Width (m) (toe to toe)Width (m) (Walking)Area (m2)Predominate MaterialInstallation DateCurrent ConditionCommentsAsset StatusShapeJE-CW-3642YYCNNN-xxxxxxJE-90051005.58.5500Formed Stone09/10/2014AverageOperatingPolylineSignal ControllerGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentHousing/MountingSCATS ModemInstallation DateCurrent ConditionCommentsAsset StatusShapeITS-SC-1856YYCNNN-xxxxxxITS-84315Pole MountedMobile (3G)9/8/2012NewOperatingPointSwitchboardGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentSwitchboard TypeConnected DateCurrent ConditionCommentsAsset StatusShapeITS-SW-87641YYCNNN-xxxxxxITS-16547PILLAR (GREEN)17/12/1994AverageOperatingPointElectrical PolesGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentPole TypeFooting TypeSurrounding SurfaceHeightOutreach TypeOutreach LengthPole InstallationPole Current ConditionBase Installation DateBase Current ConditionCommentsAsset StatusShapeEP-45611YYCNNN-xxxxxxITS-SC-1856Slip BasePiledHard5.5Double4.528/2/1992Good28/2/1992PoorOperatingPointLanterns (Traffic Signal)GIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentDisplay TypeSizeNo. AspectNo. of Red AspectNo. or Yellow AspectNo. of green AspectNo. of White AspectInstallation DateCurrent ConditionCommentsAsset StatusShapeEP—LT-1554YYCNNN-xxxxxxEP-45611DISCLED 9V ATS 200mm3111013/09/1997UnserviceableOperatingPointLuminairesGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDPole NumberCircuit NumberPhaseLuminaire TypeMakeWatt (W)Lens TypeController TypeConnection DateCurrent ConditionCommentsAsset StatusRemoval DateShapeEP—LU-51654YYCNNN-xxxxxxEP-456112WhiteSODIUMPecan250Aero ScreenDirect12/6/2017NewOperating12/6/2019PointPush ButtonGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentTypeInstallation DateCurrent ConditionCommentsAsset StatusRemoval DateShapeEP—PB-51472YYCNNN-xxxxxxEP-45611Push Button20/07/2015NewOperating12/6/2019PointCameraGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentTypeInstallation DateCurrent ConditionCommentsAsset StatusRemoval DateShapeEP—CM-5156YYCNNN-xxxxxxEP-45611Safety Cam02/06/2008GoodOperating12/6/2019PointITS CabinetGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDCabinet ConfigurationInstallation DateCurrent ConditionCommentsAsset StatusRemoval DateShapeITS-1573YYCNNN-xxxxxxSingle Door16/12/2001PoorOperating12/6/2019PointPower Distribution BoardGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentTypeInstallation DateCurrent ConditionCommentsAsset StatusRemoval DateShapeITS—PD-3217YYCNNN-xxxxxxITS-1573Metered Type A26/04/2009GoodOperating12/6/2019PointUninterruptable Power SupplyGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentTypeInstallation DateCurrent ConditionCommentsAsset StatusRemoval DateShapeITS—UPS-1553YYCNNN-xxxxxxITS-45611ECUPS13/07/2004AverageOperating12/6/2019PointOver Height DetectorGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentHeightInstallation DateCurrent ConditionCommentsAsset StatusRemoval DateShapeOH-7169YYCNNN-xxxxxxBD-25764.230/09/2003AverageOperating12/6/2019PointWeather StationsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDInstallation DateCurrent ConditionCommentsAsset StatusShapeWE-13846YYCNNN-xxxxxx12/08/2010NewOperatingPointPumpGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDCapacity (Lts)Communication TypeInstallation DateCurrent ConditionCommentsAsset StatusShapePU-41165YYCNNN-xxxxxx1000PSTN20/07/2011AverageOperatingPointJet FanGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentInstallation DateCurrent ConditionCommentsAsset StatusShapeTU-JF-13846YYCNNN-xxxxxxTU-257626/03/2014GoodOperatingPointGeneratorsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDFuel Capacity (Litres)Installation DateCurrent ConditionCommentsAsset StatusShapeGE-52107YYCNNN-xxxxxx12001/04/2012AverageOperatingPointBoom BarrierGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDLengthInstallation DateCurrent ConditionCommentsAsset StatusShapeBB-15586YYCNNN-xxxxxx5.205/11/2008GoodOperatingPointPitsGIS (Shape) information to be provided as per 2.3 Geographic location. In a format previously approved by DPTIDPTI Asset IDMtce Provider IDParentTypeSizeLockableInstallation DateCurrent ConditionCommentsAsset StatusShapeEP-PT-7161YYCNNN-xxxxxxEP-45611ElectricalP2Y05/09/2012AverageOperatingPoint ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download