Layers:

Layer: Individual Small Signs (2)

Name: Individual Small Signs

Display Field: Location_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 3009333.2643226385
YMin: 1.3781387862263069E7
XMax: 3232040.0036195517
YMax: 1.399573560876356E7
Spatial Reference: 102740  (2278)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Location_ID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:

Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Location_ID

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Location_ID ( type: esriFieldTypeString, alias: Location_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Location_ID )
• Structural_Rating ( type: esriFieldTypeInteger, alias: Structural_Rating, editable: true, nullable: true, defaultValue: null, modelName: Structural_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Manufacture_Date ( type: esriFieldTypeDate, alias: Manufacture_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Manufacture_Date )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Description )
• Front_Pic ( type: esriFieldTypeString, alias: Front_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Front_Pic )
• Manufacture_Pic ( type: esriFieldTypeString, alias: Manufacture_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Manufacture_Pic )
• General_1_Pic ( type: esriFieldTypeString, alias: General_1_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: General_1_Pic )
• General_2_Pic ( type: esriFieldTypeString, alias: General_2_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: General_2_Pic )
• Inspectors ( type: esriFieldTypeString, alias: Inspectors, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Inspectors )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
• RoadwayKey ( type: esriFieldTypeString, alias: RoadwayKey, editable: true, nullable: true, length: 3, defaultValue: null, modelName: RoadwayKey )
• Segment ( type: esriFieldTypeString, alias: Segment, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Segment )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• SignType ( type: esriFieldTypeString, alias: SignType, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SignType , Coded Values: [Single Sign: Single Sign] , [Back-to-Back Sign: Back-to-Back Sign] )
• MountType ( type: esriFieldTypeString, alias: MountType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MountType , Coded Values: [1P: 1P] , [2P: 2P] , [1T: 1T] , ...6 more... )
• TIMESTAMP ( type: esriFieldTypeDate, alias: TIMESTAMP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TIMESTAMP )
• RatingYear ( type: esriFieldTypeInteger, alias: Rating Year, editable: true, nullable: true, defaultValue: 2024, modelName: RatingYear )
• RSKey ( type: esriFieldTypeString, alias: RSKey, editable: true, nullable: true, length: 11, defaultValue: null, modelName: RSKey )
• FieldVerified ( type: esriFieldTypeInteger, alias: FieldVerified, editable: true, nullable: true, defaultValue: 0, modelName: FieldVerified , Coded Values: [0: No] , [1: Yes] )
• OfficeVerified ( type: esriFieldTypeInteger, alias: OfficeVerified, editable: true, nullable: true, defaultValue: 0, modelName: OfficeVerified , Coded Values: [0: No] , [1: Yes] )
• PMVerified ( type: esriFieldTypeInteger, alias: PMVerified, editable: true, nullable: true, defaultValue: 0, modelName: PMVerified , Coded Values: [0: No] , [1: Yes] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FrontVisibilityRating ( type: esriFieldTypeDouble, alias: FrontVisibilityRating, editable: true, nullable: true, defaultValue: null, modelName: FrontVisibilityRating )
• BackVisibilityRating ( type: esriFieldTypeDouble, alias: BackVisibilityRating, editable: true, nullable: true, defaultValue: null, modelName: BackVisibilityRating )
• OverallVisibilityRating ( type: esriFieldTypeDouble, alias: OverallVisibilityRating, editable: true, nullable: true, defaultValue: null, modelName: OverallVisibilityRating )
• FrontSign1 ( type: esriFieldTypeString, alias: FrontSign1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FrontSign1 )
• FrontSign2 ( type: esriFieldTypeString, alias: FrontSign2, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FrontSign2 )
• BackSign1 ( type: esriFieldTypeString, alias: BackSign1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: BackSign1 )
• BackSign2 ( type: esriFieldTypeString, alias: BackSign2, editable: true, nullable: true, length: 250, defaultValue: null, modelName: BackSign2 )
• FrontSign1Color ( type: esriFieldTypeInteger, alias: FrontSign1Color, editable: true, nullable: true, defaultValue: null, modelName: FrontSign1Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• FrontSign2Color ( type: esriFieldTypeInteger, alias: FrontSign2Color, editable: true, nullable: true, defaultValue: null, modelName: FrontSign2Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• BackSign1Color ( type: esriFieldTypeInteger, alias: BackSign1Color, editable: true, nullable: true, defaultValue: null, modelName: BackSign1Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• BackSign2Color ( type: esriFieldTypeInteger, alias: BackSign2Color, editable: true, nullable: true, defaultValue: null, modelName: BackSign2Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• DateInspected ( type: esriFieldTypeDate, alias: DateInspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInspected )
• IssueFixed ( type: esriFieldTypeInteger, alias: IssueFixed, editable: true, nullable: true, defaultValue: 0, modelName: IssueFixed , Coded Values: [0: No] , [1: Yes] , [3: N/A] )
• SignSize ( type: esriFieldTypeInteger, alias: SignSize, editable: true, nullable: true, defaultValue: 1, modelName: SignSize , Coded Values: [0: No] , [1: Yes] )
• MaintenanceNeeded ( type: esriFieldTypeInteger, alias: MaintenanceNeeded, editable: true, nullable: true, defaultValue: 1, modelName: MaintenanceNeeded , Coded Values: [0: No] , [1: Yes] )
• MaintenanceCompleted ( type: esriFieldTypeInteger, alias: MaintenanceCompleted, editable: true, nullable: true, defaultValue: 0, modelName: MaintenanceCompleted , Coded Values: [0: No] , [1: Yes] )
• MaintenanceIssueType ( type: esriFieldTypeInteger, alias: MaintenanceIssueType, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceIssueType , Coded Values: [0: Vegetation Growth] , [1: Cracking / Peeling] , [2: Rusting] , ...3 more... )
• MaintenanceConstType ( type: esriFieldTypeInteger, alias: MaintenanceConstType, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceConstType , Coded Values: [0: Routine] , [1: Heavy] , [2: Routine/Heavy] )
• SignText ( type: esriFieldTypeString, alias: SignText, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: SignText )
• TollRates ( type: esriFieldTypeInteger, alias: Toll Rates, editable: true, nullable: true, defaultValue: 0, modelName: TollRates , Coded Values: [0: NO] , [1: YES] )
• MaintenanceIssueNote ( type: esriFieldTypeString, alias: Maintenance Issue Note, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceIssueNote )
• Back_Sign_Text ( type: esriFieldTypeString, alias: Back Sign Text, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Back_Sign_Text )
• BidItems ( type: esriFieldTypeString, alias: BidItems, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BidItems , Coded Values: [6366007: 6366007 - REPLACE EXISTING ALUMINUM SIGNS(TY A)] , [6366008: 6366008 - REPLACE EXISTING ALUMINUM SIGNS(TY G)] , [6366009: 6366009 - REPLACE EXISTING ALUMINUM SIGNS(TY O)] , ...7 more... )
• Toll_Rate_Value ( type: esriFieldTypeString, alias: Toll Rate Value, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Toll_Rate_Value )
• Front_Reflectivity_Rating ( type: esriFieldTypeInteger, alias: Front Reflectivity Rating, editable: true, nullable: true, defaultValue: null, modelName: Front_Reflectivity_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Back_Reflectivity_Rating ( type: esriFieldTypeInteger, alias: Back Reflectivity Rating, editable: true, nullable: true, defaultValue: null, modelName: Back_Reflectivity_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Overall_Reflectivity_Rating ( type: esriFieldTypeDouble, alias: Overall Reflectivity Rating, editable: true, nullable: true, defaultValue: null, modelName: Overall_Reflectivity_Rating )
• FrontVisibilityRating2 ( type: esriFieldTypeInteger, alias: Front Visibility Rating, editable: true, nullable: true, defaultValue: null, modelName: FrontVisibilityRating2 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• BackVisibilityRating2 ( type: esriFieldTypeInteger, alias: Back Visibility Rating, editable: true, nullable: true, defaultValue: null, modelName: BackVisibilityRating2 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• HCTRAID ( type: esriFieldTypeString, alias: HCTRAID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HCTRAID )
• Roadway ( type: esriFieldTypeString, alias: Roadway, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Roadway )
• MaintenanceConflict ( type: esriFieldTypeString, alias: MaintenanceConflict, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintenanceConflict )
• MaintenanceConflictNote ( type: esriFieldTypeString, alias: MaintenanceConflictNote, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceConflictNote )
• KPI_Year ( type: esriFieldTypeInteger, alias: KPI Year, editable: true, nullable: true, defaultValue: 2023, modelName: KPI_Year )
• HCTRA_MUTCD ( type: esriFieldTypeString, alias: HCTRA MUTCD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HCTRA_MUTCD , Coded Values: [Back-to-Back Assembly: Back-to-Back Assembly] , [Back-to-Back Sign: Back-to-Back Sign] , [D1-1: D1-1] , ...923 more... )
• NumberOfSigns ( type: esriFieldTypeInteger, alias: Number Of Signs, editable: true, nullable: true, defaultValue: null, modelName: NumberOfSigns )
• RoadwayMaintenanceZone ( type: esriFieldTypeInteger, alias: Roadway Maintenance Zone, editable: true, nullable: true, defaultValue: null, modelName: RoadwayMaintenanceZone )
• MaintenanceSection ( type: esriFieldTypeInteger, alias: Maintenance Section, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceSection )
• Precinct ( type: esriFieldTypeInteger, alias: HC Commissioner Precinct, editable: true, nullable: true, defaultValue: null, modelName: Precinct )
• REL_GLOBALID2 ( type: esriFieldTypeGUID, alias: REL_GLOBALID2, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID2 )

Relationships:

• SDE.HCTRASystemInspection_SmallSignsInspectionItems (1) -- Related To: Post Missing Signs (3)
• SDE.HCTRASystemInspection_SmallSignsInspectionItems (2) -- Related To: Small Sign Post (0)

Layer: Post Missing Signs (3)

Name: Post Missing Signs

Display Field: Location_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Created in 2016. This feature class contains all small and large sign inspection issues with associated pictures and rating values for the final HCTRA System Inspection Report.

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 3009333.2643226385
YMin: 1.3781298720380977E7
XMax: 3191429.6284756362
YMax: 1.397004122347264E7
Spatial Reference: 102740  (2278)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Location_ID ( type: esriFieldTypeString, alias: Location_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Location_ID )
• Structural_Rating ( type: esriFieldTypeInteger, alias: Structural_Rating, editable: true, nullable: true, defaultValue: null, modelName: Structural_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Manufacture_Date ( type: esriFieldTypeDate, alias: Manufacture_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Manufacture_Date )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Description )
• Front_Pic ( type: esriFieldTypeString, alias: Front_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Front_Pic )
• Manufacture_Pic ( type: esriFieldTypeString, alias: Manufacture_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Manufacture_Pic )
• General_1_Pic ( type: esriFieldTypeString, alias: General_1_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: General_1_Pic )
• General_2_Pic ( type: esriFieldTypeString, alias: General_2_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: General_2_Pic )
• Inspectors ( type: esriFieldTypeString, alias: Inspectors, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Inspectors )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
• RoadwayKey ( type: esriFieldTypeString, alias: RoadwayKey, editable: true, nullable: true, length: 3, defaultValue: null, modelName: RoadwayKey )
• Segment ( type: esriFieldTypeString, alias: Segment, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Segment )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• SignType ( type: esriFieldTypeString, alias: SignType, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SignType , Coded Values: [Single Sign: Single Sign] , [Back-to-Back Sign: Back-to-Back Sign] , [Sign Assembly: Sign Assembly] , ...2 more... )
• MountType ( type: esriFieldTypeString, alias: MountType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MountType , Coded Values: [1P: 1P] , [2P: 2P] , [1T: 1T] , ...6 more... )
• TIMESTAMP ( type: esriFieldTypeDate, alias: TIMESTAMP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TIMESTAMP )
• RatingYear ( type: esriFieldTypeInteger, alias: Rating Year, editable: true, nullable: false, defaultValue: 2024, modelName: RatingYear )
• RSKey ( type: esriFieldTypeString, alias: RSKey, editable: true, nullable: true, length: 11, defaultValue: null, modelName: RSKey )
• FieldVerified ( type: esriFieldTypeInteger, alias: FieldVerified, editable: true, nullable: true, defaultValue: 0, modelName: FieldVerified , Coded Values: [0: No] , [1: Yes] )
• OfficeVerified ( type: esriFieldTypeInteger, alias: OfficeVerified, editable: true, nullable: true, defaultValue: 0, modelName: OfficeVerified , Coded Values: [0: No] , [1: Yes] )
• PMVerified ( type: esriFieldTypeInteger, alias: PMVerified, editable: true, nullable: true, defaultValue: 0, modelName: PMVerified , Coded Values: [0: No] , [1: Yes] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FrontVisibilityRating ( type: esriFieldTypeDouble, alias: FrontVisibilityRating, editable: true, nullable: true, defaultValue: null, modelName: FrontVisibilityRating )
• BackVisibilityRating ( type: esriFieldTypeDouble, alias: BackVisibilityRating, editable: true, nullable: true, defaultValue: null, modelName: BackVisibilityRating )
• OverallVisibilityRating ( type: esriFieldTypeDouble, alias: OverallVisibilityRating, editable: true, nullable: true, defaultValue: null, modelName: OverallVisibilityRating )
• FrontSign1 ( type: esriFieldTypeString, alias: FrontSign1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FrontSign1 )
• FrontSign2 ( type: esriFieldTypeString, alias: FrontSign2, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FrontSign2 )
• BackSign1 ( type: esriFieldTypeString, alias: BackSign1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: BackSign1 )
• BackSign2 ( type: esriFieldTypeString, alias: BackSign2, editable: true, nullable: true, length: 250, defaultValue: null, modelName: BackSign2 )
• FrontSign1Color ( type: esriFieldTypeInteger, alias: FrontSign1Color, editable: true, nullable: true, defaultValue: null, modelName: FrontSign1Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• FrontSign2Color ( type: esriFieldTypeInteger, alias: FrontSign2Color, editable: true, nullable: true, defaultValue: null, modelName: FrontSign2Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• BackSign1Color ( type: esriFieldTypeInteger, alias: BackSign1Color, editable: true, nullable: true, defaultValue: null, modelName: BackSign1Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• BackSign2Color ( type: esriFieldTypeInteger, alias: BackSign2Color, editable: true, nullable: true, defaultValue: null, modelName: BackSign2Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• DateInspected ( type: esriFieldTypeDate, alias: DateInspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInspected )
• IssueFixed ( type: esriFieldTypeInteger, alias: IssueFixed, editable: true, nullable: true, defaultValue: 0, modelName: IssueFixed , Coded Values: [0: No] , [1: Yes] , [3: N/A] )
• SignSize ( type: esriFieldTypeInteger, alias: SignSize, editable: true, nullable: true, defaultValue: 1, modelName: SignSize , Coded Values: [0: Small] , [1: Large] )
• MaintenanceNeeded ( type: esriFieldTypeInteger, alias: MaintenanceNeeded, editable: true, nullable: true, defaultValue: 0, modelName: MaintenanceNeeded , Coded Values: [0: No] , [1: Yes] )
• MaintenanceCompleted ( type: esriFieldTypeInteger, alias: MaintenanceCompleted, editable: true, nullable: true, defaultValue: 0, modelName: MaintenanceCompleted , Coded Values: [0: No] , [1: Yes] )
• MaintenanceIssueType ( type: esriFieldTypeInteger, alias: MaintenanceIssueType, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceIssueType , Coded Values: [0: Vegetation Growth] , [1: Cracking / Peeling] , [2: Rusting] , ...3 more... )
• MaintenanceConstType ( type: esriFieldTypeInteger, alias: MaintenanceConstType, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceConstType , Coded Values: [0: Routine] , [1: Heavy] , [2: Routine/Heavy] )
• SignText ( type: esriFieldTypeString, alias: SignText, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: SignText )
• TollRates ( type: esriFieldTypeInteger, alias: Toll Rates, editable: true, nullable: true, defaultValue: 0, modelName: TollRates , Coded Values: [0: NO] , [1: YES] )
• MaintenanceIssueNote ( type: esriFieldTypeString, alias: Maintenance Issue Note, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceIssueNote )
• Back_Sign_Text ( type: esriFieldTypeString, alias: Back Sign Text, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Back_Sign_Text )
• BidItems ( type: esriFieldTypeString, alias: BidItems, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BidItems , Coded Values: [6366007: 6366007 - REPLACE EXISTING ALUMINUM SIGNS(TY A)] , [6366008: 6366008 - REPLACE EXISTING ALUMINUM SIGNS(TY G)] , [6366009: 6366009 - REPLACE EXISTING ALUMINUM SIGNS(TY O)] , ...7 more... )
• Toll_Rate_Value ( type: esriFieldTypeString, alias: Toll Rate Value, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Toll_Rate_Value , Coded Values: [0: $0.50] , [1: $0.90] , [2: $1.00] , ...5 more... )
• Front_Reflectivity_Rating ( type: esriFieldTypeInteger, alias: Front Reflectivity Rating, editable: true, nullable: true, defaultValue: null, modelName: Front_Reflectivity_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Back_Reflectivity_Rating ( type: esriFieldTypeInteger, alias: Back Reflectivity Rating, editable: true, nullable: true, defaultValue: null, modelName: Back_Reflectivity_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Overall_Reflectivity_Rating ( type: esriFieldTypeDouble, alias: Overall Reflectivity Rating, editable: true, nullable: true, defaultValue: null, modelName: Overall_Reflectivity_Rating )
• FrontVisibilityRating2 ( type: esriFieldTypeInteger, alias: Front Visibility Rating, editable: true, nullable: true, defaultValue: null, modelName: FrontVisibilityRating2 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• BackVisibilityRating2 ( type: esriFieldTypeInteger, alias: Back Visibility Rating, editable: true, nullable: true, defaultValue: null, modelName: BackVisibilityRating2 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• HCTRAID ( type: esriFieldTypeString, alias: HCTRAID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HCTRAID )
• Roadway ( type: esriFieldTypeString, alias: Roadway, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Roadway )
• MaintenanceConflict ( type: esriFieldTypeString, alias: MaintenanceConflict, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintenanceConflict , Coded Values: [Need Clarification: Need Clarification] , [Out of Maintenance Area: Out of Maintenance Area] , [Out of Scope of Work: Out of Scope of Work] , ...3 more... )
• MaintenanceConflictNote ( type: esriFieldTypeString, alias: MaintenanceConflictNote, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceConflictNote )
• KPI_Year ( type: esriFieldTypeInteger, alias: KPI Year, editable: true, nullable: true, defaultValue: 2024, modelName: KPI_Year )
• HCTRA_MUTCD ( type: esriFieldTypeString, alias: HCTRA MUTCD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HCTRA_MUTCD , Coded Values: [Back-to-Back Assembly: Back-to-Back Assembly] , [Back-to-Back Sign: Back-to-Back Sign] , [D1-1: D1-1] , ...923 more... )
• NumberOfSigns ( type: esriFieldTypeInteger, alias: Number Of Signs, editable: true, nullable: true, defaultValue: null, modelName: NumberOfSigns )
• RoadwayMaintenanceZone ( type: esriFieldTypeInteger, alias: Roadway Maintenance Zone, editable: true, nullable: true, defaultValue: null, modelName: RoadwayMaintenanceZone )
• MaintenanceSection ( type: esriFieldTypeInteger, alias: Maintenance Section, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceSection )
• Precinct ( type: esriFieldTypeInteger, alias: HC Commissioner Precinct, editable: true, nullable: true, defaultValue: null, modelName: Precinct )
• CommissionerPct ( type: esriFieldTypeInteger, alias: Commissioner Precinct, editable: true, nullable: true, defaultValue: null, modelName: CommissionerPct )
• MaintenanceZone ( type: esriFieldTypeInteger, alias: Maintenance Zone, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceZone )
• Quadrant ( type: esriFieldTypeString, alias: Quadrant, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Quadrant )
• Statewide_12M_Average ( type: esriFieldTypeDouble, alias: Statewide 12M Average, editable: true, nullable: true, defaultValue: null, modelName: Statewide_12M_Average )
• MaintenanceLength_Qtr ( type: esriFieldTypeString, alias: Quarter, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MaintenanceLength_Qtr , Coded Values: [Q1: Q1] , [Q2: Q2] , [Q3: Q3] , ...1 more... )
• MaintenanceLength_Yr ( type: esriFieldTypeString, alias: Year, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MaintenanceLength_Yr , Coded Values: [FY24: FY24] , [FY25: FY25] , [FY26: FY26] , ...4 more... )
• AssetType ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AssetType )
• MaintenanceVerified ( type: esriFieldTypeInteger, alias: Maintenance Verified, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceVerified , Coded Values: [0: No] , [1: Yes] )
• OriginSource ( type: esriFieldTypeString, alias: OriginSource, editable: true, nullable: true, length: 255, defaultValue: SI, modelName: OriginSource , Coded Values: [SI: System Inspection] , [SIE: System Inspection Edited] , [HM: Heavy Maintenance Application] )
Templates:
• Name: Post Missing Signs
  Description:
  Prototype:
  MaintenanceVerified: null
  AssetType: null
  Location_ID: null
  Structural_Rating: null
  Manufacture_Date: null
  Description: null
  Front_Pic: null
  Manufacture_Pic: null
  General_1_Pic: null
  General_2_Pic: null
  Inspectors: null
  Inspection_Date: null
  RoadwayKey: null
  Segment: null
  Y: null
  X: null
  SignType: null
  MountType: null
  TIMESTAMP: null
  RatingYear: 2024
  RSKey: null
  FieldVerified: 0
  OfficeVerified: 0
  PMVerified: 0
  MaintenanceLength_Yr: null
  MaintenanceLength_Qtr: null
  Statewide_12M_Average: null
  Quadrant: null
  OriginSource: SI
  FrontVisibilityRating: null
  BackVisibilityRating: null
  OverallVisibilityRating: null
  FrontSign1: null
  FrontSign2: null
  BackSign1: null
  BackSign2: null
  FrontSign1Color: null
  FrontSign2Color: null
  BackSign1Color: null
  BackSign2Color: null
  DateInspected: null
  IssueFixed: 0
  SignSize: 1
  MaintenanceNeeded: 0
  MaintenanceCompleted: 0
  MaintenanceIssueType: null
  MaintenanceConstType: null
  SignText: null
  TollRates: 0
  MaintenanceIssueNote: null
  Back_Sign_Text: null
  BidItems: null
  Toll_Rate_Value: null
  Front_Reflectivity_Rating: null
  Back_Reflectivity_Rating: null
  Overall_Reflectivity_Rating: null
  FrontVisibilityRating2: null
  BackVisibilityRating2: null
  HCTRAID: null
  Roadway: null
  MaintenanceConflict: null
  MaintenanceConflictNote: null
  KPI_Year: 2024
  HCTRA_MUTCD: null
  NumberOfSigns: null
  RoadwayMaintenanceZone: null
  MaintenanceSection: null
  Precinct: null
  CommissionerPct: null
  MaintenanceZone: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• SDE.HCTRASysteminspection_IndivSmallSigns (1) -- Related To: Individual Small Signs (2)

Layer: Small Sign Post (0)

Name: Small Sign Post

Display Field: Location_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Created in 2016. This feature class contains all small and large sign inspection issues with associated pictures and rating values for the final HCTRA System Inspection Report.

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 3009333.2643226385
YMin: 1.3781298720380977E7
XMax: 3191429.6284756362
YMax: 1.397004122347264E7
Spatial Reference: 102740  (2278)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Location_ID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:

Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Location_ID

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Location_ID ( type: esriFieldTypeString, alias: Location_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Location_ID )
• Structural_Rating ( type: esriFieldTypeInteger, alias: Structural_Rating, editable: true, nullable: true, defaultValue: null, modelName: Structural_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Manufacture_Date ( type: esriFieldTypeDate, alias: Manufacture_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Manufacture_Date )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Description )
• Front_Pic ( type: esriFieldTypeString, alias: Front_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Front_Pic )
• Manufacture_Pic ( type: esriFieldTypeString, alias: Manufacture_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Manufacture_Pic )
• General_1_Pic ( type: esriFieldTypeString, alias: General_1_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: General_1_Pic )
• General_2_Pic ( type: esriFieldTypeString, alias: General_2_Pic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: General_2_Pic )
• Inspectors ( type: esriFieldTypeString, alias: Inspectors, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Inspectors )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
• RoadwayKey ( type: esriFieldTypeString, alias: RoadwayKey, editable: true, nullable: true, length: 3, defaultValue: null, modelName: RoadwayKey )
• Segment ( type: esriFieldTypeString, alias: Segment, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Segment )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• SignType ( type: esriFieldTypeString, alias: SignType, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SignType , Coded Values: [Single Sign: Single Sign] , [Back-to-Back Sign: Back-to-Back Sign] , [Sign Assembly: Sign Assembly] , ...2 more... )
• MountType ( type: esriFieldTypeString, alias: MountType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MountType , Coded Values: [1P: 1P] , [2P: 2P] , [1T: 1T] , ...6 more... )
• TIMESTAMP ( type: esriFieldTypeDate, alias: TIMESTAMP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TIMESTAMP )
• RatingYear ( type: esriFieldTypeInteger, alias: Rating Year, editable: true, nullable: false, defaultValue: 2024, modelName: RatingYear )
• RSKey ( type: esriFieldTypeString, alias: RSKey, editable: true, nullable: true, length: 11, defaultValue: null, modelName: RSKey )
• FieldVerified ( type: esriFieldTypeInteger, alias: FieldVerified, editable: true, nullable: true, defaultValue: 0, modelName: FieldVerified , Coded Values: [0: No] , [1: Yes] )
• OfficeVerified ( type: esriFieldTypeInteger, alias: OfficeVerified, editable: true, nullable: true, defaultValue: 0, modelName: OfficeVerified , Coded Values: [0: No] , [1: Yes] )
• PMVerified ( type: esriFieldTypeInteger, alias: PMVerified, editable: true, nullable: true, defaultValue: 0, modelName: PMVerified , Coded Values: [0: No] , [1: Yes] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FrontVisibilityRating ( type: esriFieldTypeDouble, alias: FrontVisibilityRating, editable: true, nullable: true, defaultValue: null, modelName: FrontVisibilityRating )
• BackVisibilityRating ( type: esriFieldTypeDouble, alias: BackVisibilityRating, editable: true, nullable: true, defaultValue: null, modelName: BackVisibilityRating )
• OverallVisibilityRating ( type: esriFieldTypeDouble, alias: OverallVisibilityRating, editable: true, nullable: true, defaultValue: null, modelName: OverallVisibilityRating )
• FrontSign1 ( type: esriFieldTypeString, alias: FrontSign1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FrontSign1 )
• FrontSign2 ( type: esriFieldTypeString, alias: FrontSign2, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FrontSign2 )
• BackSign1 ( type: esriFieldTypeString, alias: BackSign1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: BackSign1 )
• BackSign2 ( type: esriFieldTypeString, alias: BackSign2, editable: true, nullable: true, length: 250, defaultValue: null, modelName: BackSign2 )
• FrontSign1Color ( type: esriFieldTypeInteger, alias: FrontSign1Color, editable: true, nullable: true, defaultValue: null, modelName: FrontSign1Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• FrontSign2Color ( type: esriFieldTypeInteger, alias: FrontSign2Color, editable: true, nullable: true, defaultValue: null, modelName: FrontSign2Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• BackSign1Color ( type: esriFieldTypeInteger, alias: BackSign1Color, editable: true, nullable: true, defaultValue: null, modelName: BackSign1Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• BackSign2Color ( type: esriFieldTypeInteger, alias: BackSign2Color, editable: true, nullable: true, defaultValue: null, modelName: BackSign2Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• DateInspected ( type: esriFieldTypeDate, alias: DateInspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInspected )
• IssueFixed ( type: esriFieldTypeInteger, alias: IssueFixed, editable: true, nullable: true, defaultValue: 0, modelName: IssueFixed , Coded Values: [0: No] , [1: Yes] , [3: N/A] )
• SignSize ( type: esriFieldTypeInteger, alias: SignSize, editable: true, nullable: true, defaultValue: 1, modelName: SignSize , Coded Values: [0: Small] , [1: Large] )
• MaintenanceNeeded ( type: esriFieldTypeInteger, alias: MaintenanceNeeded, editable: true, nullable: true, defaultValue: 0, modelName: MaintenanceNeeded , Coded Values: [0: No] , [1: Yes] )
• MaintenanceCompleted ( type: esriFieldTypeInteger, alias: MaintenanceCompleted, editable: true, nullable: true, defaultValue: 0, modelName: MaintenanceCompleted , Coded Values: [0: No] , [1: Yes] )
• MaintenanceIssueType ( type: esriFieldTypeInteger, alias: MaintenanceIssueType, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceIssueType , Coded Values: [0: Vegetation Growth] , [1: Cracking / Peeling] , [2: Rusting] , ...3 more... )
• MaintenanceConstType ( type: esriFieldTypeInteger, alias: MaintenanceConstType, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceConstType , Coded Values: [0: Routine] , [1: Heavy] , [2: Routine/Heavy] )
• SignText ( type: esriFieldTypeString, alias: SignText, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: SignText )
• TollRates ( type: esriFieldTypeInteger, alias: Toll Rates, editable: true, nullable: true, defaultValue: 0, modelName: TollRates , Coded Values: [0: NO] , [1: YES] )
• MaintenanceIssueNote ( type: esriFieldTypeString, alias: Maintenance Issue Note, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceIssueNote )
• Back_Sign_Text ( type: esriFieldTypeString, alias: Back Sign Text, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Back_Sign_Text )
• BidItems ( type: esriFieldTypeString, alias: BidItems, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BidItems , Coded Values: [6366007: 6366007 - REPLACE EXISTING ALUMINUM SIGNS(TY A)] , [6366008: 6366008 - REPLACE EXISTING ALUMINUM SIGNS(TY G)] , [6366009: 6366009 - REPLACE EXISTING ALUMINUM SIGNS(TY O)] , ...7 more... )
• Toll_Rate_Value ( type: esriFieldTypeString, alias: Toll Rate Value, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Toll_Rate_Value , Coded Values: [0: $0.50] , [1: $0.90] , [2: $1.00] , ...5 more... )
• Front_Reflectivity_Rating ( type: esriFieldTypeInteger, alias: Front Reflectivity Rating, editable: true, nullable: true, defaultValue: null, modelName: Front_Reflectivity_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Back_Reflectivity_Rating ( type: esriFieldTypeInteger, alias: Back Reflectivity Rating, editable: true, nullable: true, defaultValue: null, modelName: Back_Reflectivity_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Overall_Reflectivity_Rating ( type: esriFieldTypeDouble, alias: Overall Reflectivity Rating, editable: true, nullable: true, defaultValue: null, modelName: Overall_Reflectivity_Rating )
• FrontVisibilityRating2 ( type: esriFieldTypeInteger, alias: Front Visibility Rating, editable: true, nullable: true, defaultValue: null, modelName: FrontVisibilityRating2 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• BackVisibilityRating2 ( type: esriFieldTypeInteger, alias: Back Visibility Rating, editable: true, nullable: true, defaultValue: null, modelName: BackVisibilityRating2 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• HCTRAID ( type: esriFieldTypeString, alias: HCTRAID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HCTRAID )
• Roadway ( type: esriFieldTypeString, alias: Roadway, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Roadway )
• MaintenanceConflict ( type: esriFieldTypeString, alias: MaintenanceConflict, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintenanceConflict , Coded Values: [Need Clarification: Need Clarification] , [Out of Maintenance Area: Out of Maintenance Area] , [Out of Scope of Work: Out of Scope of Work] , ...3 more... )
• MaintenanceConflictNote ( type: esriFieldTypeString, alias: MaintenanceConflictNote, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceConflictNote )
• KPI_Year ( type: esriFieldTypeInteger, alias: KPI Year, editable: true, nullable: true, defaultValue: 2024, modelName: KPI_Year )
• HCTRA_MUTCD ( type: esriFieldTypeString, alias: HCTRA MUTCD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HCTRA_MUTCD , Coded Values: [Back-to-Back Assembly: Back-to-Back Assembly] , [Back-to-Back Sign: Back-to-Back Sign] , [D1-1: D1-1] , ...923 more... )
• NumberOfSigns ( type: esriFieldTypeInteger, alias: Number Of Signs, editable: true, nullable: true, defaultValue: null, modelName: NumberOfSigns )
• RoadwayMaintenanceZone ( type: esriFieldTypeInteger, alias: Roadway Maintenance Zone, editable: true, nullable: true, defaultValue: null, modelName: RoadwayMaintenanceZone )
• MaintenanceSection ( type: esriFieldTypeInteger, alias: Maintenance Section, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceSection )
• Precinct ( type: esriFieldTypeInteger, alias: HC Commissioner Precinct, editable: true, nullable: true, defaultValue: null, modelName: Precinct )
• CommissionerPct ( type: esriFieldTypeInteger, alias: Commissioner Precinct, editable: true, nullable: true, defaultValue: null, modelName: CommissionerPct )
• MaintenanceZone ( type: esriFieldTypeInteger, alias: Maintenance Zone, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceZone )
• Quadrant ( type: esriFieldTypeString, alias: Quadrant, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Quadrant )
• Statewide_12M_Average ( type: esriFieldTypeDouble, alias: Statewide 12M Average, editable: true, nullable: true, defaultValue: null, modelName: Statewide_12M_Average )
• MaintenanceLength_Qtr ( type: esriFieldTypeString, alias: Quarter, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MaintenanceLength_Qtr , Coded Values: [Q1: Q1] , [Q2: Q2] , [Q3: Q3] , ...1 more... )
• MaintenanceLength_Yr ( type: esriFieldTypeString, alias: Year, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MaintenanceLength_Yr , Coded Values: [FY24: FY24] , [FY25: FY25] , [FY26: FY26] , ...4 more... )
• AssetType ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AssetType )
• MaintenanceVerified ( type: esriFieldTypeInteger, alias: Maintenance Verified, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceVerified , Coded Values: [0: No] , [1: Yes] )
• OriginSource ( type: esriFieldTypeString, alias: OriginSource, editable: true, nullable: true, length: 255, defaultValue: SI, modelName: OriginSource , Coded Values: [SI: System Inspection] , [SIE: System Inspection Edited] , [HM: Heavy Maintenance Application] )

Relationships:

• SDE.HCTRASysteminspection_IndivSmallSigns (2) -- Related To: Individual Small Signs (2)