ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
SystemInspection
>
HCTRASystemInspectionIndividualSigns (FeatureServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (SystemInspection/HCTRASystemInspectionIndividualSigns)
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
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.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) LatestVCSWkid(0)
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:
<all other values>
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: false
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
:
Small Sign Post
(0)
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
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.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) 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: false
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: Small Sign Post
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)