Name: City.PBWORKS.SIGN

Display Field: IDLOC

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• IDLOC (type: esriFieldTypeString, alias: SIMS LocationID, SQL Type: sqlTypeOther, length: 13, nullable: false, editable: true)
• SIGNDESCRP (type: esriFieldTypeString, alias: Sign Description, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• SIGNCATGRY (type: esriFieldTypeString, alias: Sign Category, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [COM: Common], [CUS: Custom], [ST: Street Name], ... 1 more ...)
• SIGNNUMBER (type: esriFieldTypeInteger, alias: Sign Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATERIALUID (type: esriFieldTypeString, alias: MATERIALUID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PWSNR10139-24x30HI: PWSNR10139-24x30HI], [PWSNDI10140-30x18VIP: PWSNDI10140-30x18VIP], [PWSNR759-24X36VIP: PWSNR759-24X36VIP], ... 4329 more ...)
• SIGNWIDTH (type: esriFieldTypeSmallInteger, alias: Sign Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGNHEIGHT (type: esriFieldTypeSmallInteger, alias: Sign Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGNTYPE (type: esriFieldTypeString, alias: Sign Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [AR: Acknowledgement/Recognition], [C: Construction], [DI: Directional/Informational], ... 5 more ...)
• SIGNCOLOR (type: esriFieldTypeString, alias: Sign Color, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [White/Blue, White/Green: White/Blue, White/Green], [Black/Orange: Black/Orange], [White/Green, White/Brown: White/Green, White/Brown], ... 5 more ...)
• SIGNMATRL (type: esriFieldTypeString, alias: Sign Material, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [DG: Diamond Grade], [EG: Engineer Grade], [HI: High Intensity], ... 4 more ...)
• MUTCDCODE (type: esriFieldTypeString, alias: MUTCD Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FACING_N (type: esriFieldTypeSmallInteger, alias: Sign Faces North, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• FACING_S (type: esriFieldTypeSmallInteger, alias: Sign Faces South, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• FACING_E (type: esriFieldTypeSmallInteger, alias: Sign Faces East, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• FACING_W (type: esriFieldTypeSmallInteger, alias: Sign Faces West, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• MNTHEIGHTFT (type: esriFieldTypeSmallInteger, alias: Mount Height FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MNTHEIGHTIN (type: esriFieldTypeSmallInteger, alias: Mount Height IN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: Sign Condition, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: New], [G: Good], [F: Fair], ... 1 more ...)
• DateAdded (type: esriFieldTypeDate, alias: SIMS Date Added, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AssetID (type: esriFieldTypeString, alias: Cityworks AssetID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• WarrantyDate (type: esriFieldTypeDate, alias: WarrantyDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConditionDate (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [PRP: Proposed], [ACT: Active], [RMVD: Removed], ... 2 more ...)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• LegacyLocID (type: esriFieldTypeString, alias: LegacyLocID, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)

Templates:

Name: City.PBWORKS.SIGN
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• IDLOC:
• SIGNMATRL: VIP
• FACING_N: 0
• FACING_S: 0
• FACING_E: 0
• FACING_W: 0
• CONDITION: N

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/22/2023 2:12:05 PM

Schema Last Edit Date: 3/22/2023 2:12:05 PM

Data Last Edit Date: 3/22/2023 2:12:05 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat