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

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

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

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:

Feature Draw Order:

N/A

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: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Location_ID ( type: esriFieldTypeString, alias: Location_ID, length: 20 )
• Structural_Rating ( type: esriFieldTypeInteger, alias: Structural_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Manufacture_Date ( type: esriFieldTypeDate, alias: Manufacture_Date, length: 8 )
• Description ( type: esriFieldTypeString, alias: Description, length: 1073741822 )
• Front_Pic ( type: esriFieldTypeString, alias: Front_Pic, length: 255 )
• Manufacture_Pic ( type: esriFieldTypeString, alias: Manufacture_Pic, length: 255 )
• General_1_Pic ( type: esriFieldTypeString, alias: General_1_Pic, length: 255 )
• General_2_Pic ( type: esriFieldTypeString, alias: General_2_Pic, length: 255 )
• Inspectors ( type: esriFieldTypeString, alias: Inspectors, length: 25 )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection_Date, length: 8 )
• RoadwayKey ( type: esriFieldTypeString, alias: RoadwayKey, length: 3 )
• Segment ( type: esriFieldTypeString, alias: Segment, length: 7 )
• Y ( type: esriFieldTypeDouble, alias: Y )
• X ( type: esriFieldTypeDouble, alias: X )
• SignType ( type: esriFieldTypeString, alias: SignType, length: 25 , 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, length: 10 , Coded Values: [1P: 1P] , [2P: 2P] , [1T: 1T] , ...6 more... )
• TIMESTAMP ( type: esriFieldTypeDate, alias: TIMESTAMP, length: 8 )
• RatingYear ( type: esriFieldTypeInteger, alias: Rating Year )
• RSKey ( type: esriFieldTypeString, alias: RSKey, length: 11 )
• FieldVerified ( type: esriFieldTypeInteger, alias: FieldVerified , Coded Values: [0: No] , [1: Yes] )
• OfficeVerified ( type: esriFieldTypeInteger, alias: OfficeVerified , Coded Values: [0: No] , [1: Yes] )
• PMVerified ( type: esriFieldTypeInteger, alias: PMVerified , Coded Values: [0: No] , [1: Yes] )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• FrontVisibilityRating ( type: esriFieldTypeDouble, alias: FrontVisibilityRating )
• BackVisibilityRating ( type: esriFieldTypeDouble, alias: BackVisibilityRating )
• OverallVisibilityRating ( type: esriFieldTypeDouble, alias: OverallVisibilityRating )
• FrontSign1 ( type: esriFieldTypeString, alias: FrontSign1, length: 250 )
• FrontSign2 ( type: esriFieldTypeString, alias: FrontSign2, length: 250 )
• BackSign1 ( type: esriFieldTypeString, alias: BackSign1, length: 250 )
• BackSign2 ( type: esriFieldTypeString, alias: BackSign2, length: 250 )
• FrontSign1Color ( type: esriFieldTypeInteger, alias: FrontSign1Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• FrontSign2Color ( type: esriFieldTypeInteger, alias: FrontSign2Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• BackSign1Color ( type: esriFieldTypeInteger, alias: BackSign1Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• BackSign2Color ( type: esriFieldTypeInteger, alias: BackSign2Color , Coded Values: [0: Green] , [1: Black] , [2: White] , ...8 more... )
• DateInspected ( type: esriFieldTypeDate, alias: DateInspected, length: 8 )
• IssueFixed ( type: esriFieldTypeInteger, alias: IssueFixed , Coded Values: [0: No] , [1: Yes] , [3: N/A] )
• SignSize ( type: esriFieldTypeInteger, alias: SignSize , Coded Values: [0: Small] , [1: Large] )
• MaintenanceNeeded ( type: esriFieldTypeInteger, alias: MaintenanceNeeded , Coded Values: [0: No] , [1: Yes] )
• MaintenanceCompleted ( type: esriFieldTypeInteger, alias: MaintenanceCompleted , Coded Values: [0: No] , [1: Yes] )
• MaintenanceIssueType ( type: esriFieldTypeInteger, alias: MaintenanceIssueType , Coded Values: [0: Vegetation Growth] , [1: Cracking / Peeling] , [2: Rusting] , ...3 more... )
• MaintenanceConstType ( type: esriFieldTypeInteger, alias: MaintenanceConstType , Coded Values: [0: Routine] , [1: Heavy] , [2: Routine/Heavy] )
• SignText ( type: esriFieldTypeString, alias: SignText, length: 1000 )
• TollRates ( type: esriFieldTypeInteger, alias: Toll Rates , Coded Values: [0: NO] , [1: YES] )
• MaintenanceIssueNote ( type: esriFieldTypeString, alias: Maintenance Issue Note, length: 255 )
• Back_Sign_Text ( type: esriFieldTypeString, alias: Back Sign Text, length: 1000 )
• BidItems ( type: esriFieldTypeString, alias: BidItems, length: 20 , 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, length: 10 , Coded Values: [0: $0.50] , [1: $0.90] , [2: $1.00] , ...5 more... )
• Front_Reflectivity_Rating ( type: esriFieldTypeInteger, alias: Front Reflectivity Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Back_Reflectivity_Rating ( type: esriFieldTypeInteger, alias: Back Reflectivity Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Overall_Reflectivity_Rating ( type: esriFieldTypeDouble, alias: Overall Reflectivity Rating )
• FrontVisibilityRating2 ( type: esriFieldTypeInteger, alias: Front Visibility Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• BackVisibilityRating2 ( type: esriFieldTypeInteger, alias: Back Visibility Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• HCTRAID ( type: esriFieldTypeString, alias: HCTRAID, length: 50 )
• Roadway ( type: esriFieldTypeString, alias: Roadway, length: 50 )
• MaintenanceConflict ( type: esriFieldTypeString, alias: MaintenanceConflict, length: 50 , 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, length: 255 )
• KPI_Year ( type: esriFieldTypeInteger, alias: KPI Year )
• HCTRA_MUTCD ( type: esriFieldTypeString, alias: HCTRA MUTCD, length: 50 , 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 )
• RoadwayMaintenanceZone ( type: esriFieldTypeInteger, alias: Roadway Maintenance Zone )
• MaintenanceSection ( type: esriFieldTypeInteger, alias: Maintenance Section )
• Precinct ( type: esriFieldTypeInteger, alias: HC Commissioner Precinct )
• CommissionerPct ( type: esriFieldTypeInteger, alias: Commissioner Precinct )
• MaintenanceZone ( type: esriFieldTypeInteger, alias: Maintenance Zone )
• Quadrant ( type: esriFieldTypeString, alias: Quadrant, length: 100 )
• Statewide_12M_Average ( type: esriFieldTypeDouble, alias: Statewide 12M Average )
• MaintenanceLength_Qtr ( type: esriFieldTypeString, alias: Quarter, length: 25 , Coded Values: [Q1: Q1] , [Q2: Q2] , [Q3: Q3] , ...1 more... )
• MaintenanceLength_Yr ( type: esriFieldTypeString, alias: Year, length: 25 , Coded Values: [FY24: FY24] , [FY25: FY25] , [FY26: FY26] , ...4 more... )
• AssetType ( type: esriFieldTypeString, alias: Asset Type, length: 100 )
• MaintenanceVerified ( type: esriFieldTypeInteger, alias: Maintenance Verified , Coded Values: [0: No] , [1: Yes] )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• OriginSource ( type: esriFieldTypeString, alias: OriginSource, length: 255 , Coded Values: [SI: System Inspection] , [SIE: System Inspection Edited] , [HM: Heavy Maintenance Application] )

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata