Name: PW Sign Update

Display Field: FACILITYID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: afa20e51f9ad45bcabd031ae85a287d3

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SIGNTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 50 )
• SIGNPOSTID ( type: esriFieldTypeString, alias: Attachment ID, length: 50 )
• SIGNTYPE ( type: esriFieldTypeInteger, alias: Sign Type )
• SIGNHEIGHT ( type: esriFieldTypeString, alias: Sign Height, length: 20 , Coded Values: [20: 20] , [30: 30] , [45: 45] , ...5 more... )
• SIGNWIDTH ( type: esriFieldTypeString, alias: Sign Width, length: 20 , Coded Values: [13: 13] , [30: 30] , [45: 45] , ...5 more... )
• SIGNCODE ( type: esriFieldTypeString, alias: Sign Name, length: 255 , Coded Values: [RA-1: RA-1 Stop] , [RA-1-T: RA-1-T 4 Way Stop] , [RA-102: RA-102 Pedestrian Crossing (2 Lights)] , ...62 more... )
• SIGNTEXT ( type: esriFieldTypeString, alias: Sign Text, length: 255 )
• FACING ( type: esriFieldTypeString, alias: Facing Direction, length: 20 , Coded Values: [None: None] , [North: North] , [Nord: Nord] , ...22 more... )
• SIGNCOLOUR ( type: esriFieldTypeString, alias: Horizontal Clearance, length: 25 )
• HORIZFROM ( type: esriFieldTypeString, alias: Horizontal From, length: 12 )
• VERTFROM ( type: esriFieldTypeString, alias: Vertical From, length: 12 )
• ANGLE ( type: esriFieldTypeSmallInteger, alias: Angle (Degrees) )
• DISTTOTOP ( type: esriFieldTypeDouble, alias: Distance to Top of Pole )
• REFLCOAT ( type: esriFieldTypeString, alias: Reflective Coating, length: 15 )
• SHEETING ( type: esriFieldTypeString, alias: Sheeting Type, length: 50 , Coded Values: [DG3: DG3 - Diamond Grade] , [HIP: HIP - High Intensity] , [EG: EG - Engineered Grade] )
• SUPMATERIAL ( type: esriFieldTypeString, alias: Supplemental Materials, length: 30 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• CONDITION ( type: esriFieldTypeString, alias: Condition, length: 50 , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [-1: Private] , [-2: Other] , [1: City] , ...1 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By , Coded Values: [-1: Private] , [-2: Other] , [1: City] , ...1 more... )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• ACQU_TECH ( type: esriFieldTypeSmallInteger, alias: Acquisition Technique , Coded Values: [-1: Unknown] , [0: None] , [1: Other] , ...19 more... )
• ACCURACY_M ( type: esriFieldTypeDouble, alias: Planimetric Accuracy (m) )
• SCALE_LRG ( type: esriFieldTypeInteger, alias: Largest Scale , Coded Values: [0: None] , [1250: 1:1 250 (Building)] , [2500: 1:2 500 (Buildings)] , ...16 more... )
• SCALE_SM ( type: esriFieldTypeInteger, alias: Smallest Scale , Coded Values: [0: None] , [1250: 1:1 250 (Building)] , [2500: 1:2 500 (Buildings)] , ...16 more... )
• 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 )
• ID_NUM ( type: esriFieldTypeInteger, alias: ID_NUM )
• ID_TEXT ( type: esriFieldTypeString, alias: ID_TEXT, length: 50 )
• FACILITYID_OLD ( type: esriFieldTypeString, alias: FACILITYID_OLD, length: 20 )
• PWID ( type: esriFieldTypeString, alias: PWID, length: 20 )
• AddedToSignCatalog ( type: esriFieldTypeString, alias: AddedToSignCatalog, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• PWSignPostUpdateGlobalID ( type: esriFieldTypeGUID, alias: PWSignPostUpdateGlobalID, length: 38 )

Types:

ID: 0
Name: REGULATORY
Domains:
• SIGNHEIGHT:
  Inherited
• SIGNWIDTH:
  Inherited
• SIGNCODE:
  Inherited
• FACING:
  Coded Values: [None: None] , [North: North] , [Northeast: Northeast] , ...6 more...
• SIGNCOLOUR:
  Coded Values: [White: White] , [Green: Green] , [Black: Black] , ...6 more...
• SHEETING:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ACQU_TECH:
  Inherited
• SCALE_LRG:
  Inherited
• SCALE_SM:
  Inherited
• AddedToSignCatalog:
  Inherited

---

ID: 1
Name: WARNING
Domains:
• SIGNHEIGHT:
  Inherited
• SIGNWIDTH:
  Inherited
• SIGNCODE:
  Coded Values: [WA-112-L: WA-112-L Free Flow -Added Lane Left] , [WA-112-R: WA-112-R Free Flow- Added Lane Right] , [WA-116B-T: WA-116B-T Ends] , ...47 more...
• FACING:
  Coded Values: [None: None] , [North: North] , [Northeast: Northeast] , ...6 more...
• SIGNCOLOUR:
  Coded Values: [White: White] , [Green: Green] , [Black: Black] , ...6 more...
• SHEETING:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ACQU_TECH:
  Inherited
• SCALE_LRG:
  Inherited
• SCALE_SM:
  Inherited
• AddedToSignCatalog:
  Inherited

---

ID: 2
Name: INFORMATION
Domains:
• SIGNHEIGHT:
  Inherited
• SIGNWIDTH:
  Inherited
• SIGNCODE:
  Coded Values: [IA-202: IA-202 Single Distance] , [IA-203: IA-203 Single Combination Directional Distance] , [IA-204: IA-204 Double Directional] , ...42 more...
• FACING:
  Coded Values: [None: None] , [North: North] , [Northeast: Northeast] , ...6 more...
• SIGNCOLOUR:
  Coded Values: [White: White] , [Green: Green] , [Black: Black] , ...6 more...
• SHEETING:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ACQU_TECH:
  Inherited
• SCALE_LRG:
  Inherited
• SCALE_SM:
  Inherited
• AddedToSignCatalog:
  Inherited

---

ID: 3
Name: CUSTOM
Domains:
• SIGNHEIGHT:
  Inherited
• SIGNWIDTH:
  Inherited
• SIGNCODE:
  Coded Values: [CUSTOM-1: __ km/h] , [CUSTOM-2: No Parking/Stopping Alleys] , [CUSTOM-3: Route 560 (Wording Inside Arrow)] , ...50 more...
• FACING:
  Coded Values: [None: None] , [North: North] , [Northeast: Northeast] , ...6 more...
• SIGNCOLOUR:
  Coded Values: [White: White] , [Green: Green] , [Black: Black] , ...6 more...
• SHEETING:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ACQU_TECH:
  Inherited
• SCALE_LRG:
  Inherited
• SCALE_SM:
  Inherited
• AddedToSignCatalog:
  Inherited

---

Relationships:

• PWSignPostUpdate (0) -- Related To: PW Sign Post Update (52)

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

  Iteminfo   Thumbnail   Metadata