Name: Signs

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 288895.277144

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1010742.26803316
YMin: 1822355.19258807
XMax: 1051060.28450983
YMax: 1874768.15501916
Spatial Reference: 3443 (3443)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[147,66,143,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ATTACHID (type: esriFieldTypeString, alias: Attachment ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SIGNTYPE (type: esriFieldTypeString, alias: Sign Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Regulatory: Regulatory], [Warning: Warning], [Guide: Guide], ... 7 more ...)
• SIGNHEIGHT (type: esriFieldTypeDouble, alias: Height (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGNWIDTH (type: esriFieldTypeDouble, alias: Width (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGNSTYLE (type: esriFieldTypeString, alias: Style, SQL Type: sqlTypeOther, length: 130, nullable: true, editable: true, Coded Values: [R1-1: Stop Sign], [R1-2: Yield], [R1-3W: 3 Way Stop], ... 111 more ...)
• SIGNTEXT (type: esriFieldTypeString, alias: Text, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FACING (type: esriFieldTypeString, alias: Facing Direction, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [East: East], [North: North], [South: South], ... 9 more ...)
• HORIZCLEAR (type: esriFieldTypeString, alias: Horizontal Clearance, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• HORIZFROM (type: esriFieldTypeString, alias: Horizontal From, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• VERTFROM (type: esriFieldTypeString, alias: Vertical From, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• ANGLE (type: esriFieldTypeSmallInteger, alias: Angle (Degrees), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTTOTOP (type: esriFieldTypeDouble, alias: Distance to Top of Pole, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REFLCOAT (type: esriFieldTypeString, alias: Reflective Coating, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SHEETING (type: esriFieldTypeString, alias: Sheeting Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Type I (Engineer Grade): Type I (Engineer Grade)], [Type II (Super Engineer Grade): Type II (Super Engineer Grade)], [Type III (High Intensity): Type III (High Intensity)], ... 8 more ...)
• SUPMATERIAL (type: esriFieldTypeString, alias: Supplemental Materials, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Very Good: Very Good], [Good: Good], ... 5 more ...)
• OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [-1: Private], [-2: Other], ... 6 more ...)
• MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [-1: Private], [-2: Other])
• LASTUPDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• SIGNMTRL (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 ...)
• 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 ...)
• 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 ...)
• SIGNNUMBER (type: esriFieldTypeInteger, alias: Sign Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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 ...)
• 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)
• MUTCDCODE (type: esriFieldTypeString, alias: MUTCDCODE, 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])
• 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)
• IDGRID (type: esriFieldTypeSmallInteger, alias: City Grid, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [4: 4], [5: 5], ... 286 more ...)
• IDSECTION (type: esriFieldTypeString, alias: Section, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NW: NW], [SW: SW], [NE: NE], ... 4 more ...)
• IDJURISDICTION (type: esriFieldTypeString, alias: Jurisdiction, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [NC: Naperville], [DC: DuPage County], [WC: Will County], ... 5 more ...)
• IDADDRESS (type: esriFieldTypeString, alias: Closest Address Number, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IDDIR3 (type: esriFieldTypeString, alias: Address Street Direction, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: N], [S: S], [E: E], ... 1 more ...)
• IDSTREET3 (type: esriFieldTypeString, alias: Address Street Name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: )
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ASSETID (type: esriFieldTypeString, alias: Cityworks AssetID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SIGNWIDTH2 (type: esriFieldTypeSmallInteger, alias: Sign Width Legacy, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGNHEIGHT2 (type: esriFieldTypeSmallInteger, alias: Sign Height Legacy, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REMOVALDATE (type: esriFieldTypeDate, alias: REMOVALDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IDFull_Address (type: esriFieldTypeString, alias: IDFull_Address, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Signs
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• SIGNMTRL: VIP
• IDJURISDICTION: NC

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/10/2021 9:47:47 PM

Schema Last Edit Date: 11/10/2021 9:47:47 PM

Data Last Edit Date: 11/10/2021 9:47:47 PM

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