View In:   ArcGIS Online Map Viewer

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)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata