Layers:

Layer: PWSDE.PUBWORKS.SignPosts (21)

Name: PWSDE.PUBWORKS.SignPosts

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 50000.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: 2380654.356056884
YMin: 110730.57754914463
XMax: 2581380.7495508045
YMax: 402658.22072680295
Spatial Reference: 2926  (2926)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: SignPostType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: BP
  Label: Beacon Pole
  Description: N/A
  Symbol:
  
• Value: OT
  Label: Other
  Description: N/A
  Symbol:
  
• Value: SC
  Label: Steel Channel
  Description: N/A
  Symbol:
  
• Value: SMA
  Label: Signal Mast Arm
  Description: N/A
  Symbol:
  
• Value: WO
  Label: Wood
  Description: N/A
  Symbol:
  
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


HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SignPostType

Fields:
• SignPostTreatment ( type: esriFieldTypeString, alias: Post Treatment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignPostTreatment , Coded Values: [PA: Paint] , [GA: Galvanizing] , [OT: Other] , ...1 more... )
• RoadNumber ( type: esriFieldTypeString, alias: Road Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: RoadNumber )
• RoadName ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RoadName )
• LastInspection ( type: esriFieldTypeDate, alias: Last Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastInspection )
• PostGUID ( type: esriFieldTypeGUID, alias: PostGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PostGUID )
• LastEditor ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LastEditor )
• LastEditor2 ( type: esriFieldTypeString, alias: Last Editor 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LastEditor2 )
• NewestMaintenance2 ( type: esriFieldTypeString, alias: Newest Maintenance, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NewestMaintenance2 , Coded Values: [INSPPOST: Inspect Post] , [CLSIGHTD: Clear Sight Distance] , [ADDPOST: Inventory Correction - Add Post] , ...10 more... )
• NewestMaintenanceReason2 ( type: esriFieldTypeString, alias: Newest Maintenance Reason, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NewestMaintenanceReason2 , Coded Values: [BALLBANK: Ball Bank] , [CNSTPROJ: Construction Project] , [CNTYCODE: County Code] , ...14 more... )
• SignPostType ( type: esriFieldTypeString, alias: Post Type, editable: true, nullable: true, length: 50, defaultValue: SC, modelName: SignPostType , Coded Values: [SC: Steel Channel] , [SMA: Signal Mast Arm] , [BP: Beacon Pole] , ...2 more... )
• MP ( type: esriFieldTypeDouble, alias: Milepost, editable: true, nullable: true, defaultValue: null, modelName: MP )
• NumberOfPosts ( type: esriFieldTypeInteger, alias: Number of Posts, editable: true, nullable: true, defaultValue: 1, modelName: NumberOfPosts )
• SideOfRoad ( type: esriFieldTypeString, alias: Side of Road, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SideOfRoad , Coded Values: [NULL: NULL] , [A: A] , [B: B] , ...19 more... )
• Comment ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comment )
• DateInstalled ( type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled )
• DateRemoved ( type: esriFieldTypeDate, alias: Date Removed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateRemoved )
• CountyCode ( type: esriFieldTypeString, alias: County Code, editable: true, nullable: true, length: 2, defaultValue: 32, modelName: CountyCode )
• StateLRS ( type: esriFieldTypeString, alias: State LRS, editable: true, nullable: true, length: 7, defaultValue: null, modelName: StateLRS )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global Post ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Offset ( type: esriFieldTypeDouble, alias: Offset, editable: false, nullable: true, defaultValue: null, modelName: Offset )
• PostLength ( type: esriFieldTypeDouble, alias: Post Length, editable: false, nullable: true, defaultValue: null, modelName: PostLength )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PostCondition ( type: esriFieldTypeInteger, alias: PostCondition, editable: false, nullable: true, defaultValue: null, modelName: PostCondition )
• InspectionInterval ( type: esriFieldTypeInteger, alias: InspectionInterval, editable: false, nullable: true, defaultValue: null, modelName: InspectionInterval )
• OwnerID ( type: esriFieldTypeString, alias: OwnerID, editable: false, nullable: true, length: 50, defaultValue: null, modelName: OwnerID )
• PostID ( type: esriFieldTypeInteger, alias: OLDPostID, editable: false, nullable: true, defaultValue: null, modelName: PostID )
• InstallYear ( type: esriFieldTypeInteger, alias: InstallYear, editable: false, nullable: true, defaultValue: null, modelName: InstallYear )
• ObjectIDSave ( type: esriFieldTypeInteger, alias: ObjectIDSave, editable: true, nullable: true, defaultValue: null, modelName: ObjectIDSave )
• RoadNumNum ( type: esriFieldTypeInteger, alias: RoadNumNum, editable: false, nullable: true, defaultValue: null, modelName: RoadNumNum )
• VALIDATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: VALIDATIONSTATUS, editable: false, nullable: true, defaultValue: 6, modelName: VALIDATIONSTATUS , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )
Types:
ID: BP
Name: Beacon Pole
Domains:
• SignPostTreatment:
  Inherited
• NewestMaintenance2:
  Inherited
• NewestMaintenanceReason2:
  Inherited
• SignPostType:
  Inherited
• SideOfRoad:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Beacon Pole
  Description:
  Prototype:
  NewestMaintenanceReason2: null
  ObjectIDSave: null
  SignPostTreatment: null
  RoadNumber: null
  RoadName: null
  LastInspection: null
  PostGUID: null
  LastEditor: null
  LastEditor2: null
  NewestMaintenance2: null
  SignPostType: BP
  MP: null
  NumberOfPosts: 1
  SideOfRoad: null
  Comment: null
  DateInstalled: null
  DateRemoved: null
  CountyCode: 32
  StateLRS: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: OT
Name: Other
Domains:
• SignPostTreatment:
  Inherited
• NewestMaintenance2:
  Inherited
• NewestMaintenanceReason2:
  Inherited
• SignPostType:
  Inherited
• SideOfRoad:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  NewestMaintenanceReason2: null
  ObjectIDSave: null
  SignPostTreatment: null
  RoadNumber: null
  RoadName: null
  LastInspection: null
  PostGUID: null
  LastEditor: null
  LastEditor2: null
  NewestMaintenance2: null
  SignPostType: OT
  MP: null
  NumberOfPosts: 1
  SideOfRoad: null
  Comment: null
  DateInstalled: null
  DateRemoved: null
  CountyCode: 32
  StateLRS: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: SC
Name: Steel Channel
Domains:
• SignPostTreatment:
  Inherited
• NewestMaintenance2:
  Inherited
• NewestMaintenanceReason2:
  Inherited
• SignPostType:
  Inherited
• SideOfRoad:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Steel Channel
  Description:
  Prototype:
  NewestMaintenanceReason2: null
  ObjectIDSave: null
  SignPostTreatment: null
  RoadNumber: null
  RoadName: null
  LastInspection: null
  PostGUID: null
  LastEditor: null
  LastEditor2: null
  NewestMaintenance2: null
  SignPostType: SC
  MP: null
  NumberOfPosts: 1
  SideOfRoad: null
  Comment: null
  DateInstalled: null
  DateRemoved: null
  CountyCode: 32
  StateLRS: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: SMA
Name: Signal Mast Arm
Domains:
• SignPostTreatment:
  Inherited
• NewestMaintenance2:
  Inherited
• NewestMaintenanceReason2:
  Inherited
• SignPostType:
  Inherited
• SideOfRoad:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Signal Mast Arm
  Description:
  Prototype:
  NewestMaintenanceReason2: null
  ObjectIDSave: null
  SignPostTreatment: null
  RoadNumber: null
  RoadName: null
  LastInspection: null
  PostGUID: null
  LastEditor: null
  LastEditor2: null
  NewestMaintenance2: null
  SignPostType: SMA
  MP: null
  NumberOfPosts: 1
  SideOfRoad: null
  Comment: null
  DateInstalled: null
  DateRemoved: null
  CountyCode: 32
  StateLRS: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: WO
Name: Wood
Domains:
• SignPostTreatment:
  Inherited
• NewestMaintenance2:
  Inherited
• NewestMaintenanceReason2:
  Inherited
• SignPostType:
  Inherited
• SideOfRoad:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Wood
  Description:
  Prototype:
  NewestMaintenanceReason2: null
  ObjectIDSave: null
  SignPostTreatment: null
  RoadNumber: null
  RoadName: null
  LastInspection: null
  PostGUID: null
  LastEditor: null
  LastEditor2: null
  NewestMaintenance2: null
  SignPostType: WO
  MP: null
  NumberOfPosts: 1
  SideOfRoad: null
  Comment: null
  DateInstalled: null
  DateRemoved: null
  CountyCode: 32
  StateLRS: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• PWSDE.PUBWORKS.Posts_Plates_Work (1) -- Related To: PWSDE.PUBWORKS.Posts_Plates_Work (29)
• PWSDE.PUBWORKS.Sign_Orders (2) -- Related To: PWSDE.PUBWORKS.Sign_Orders (28)
• post_to_plates (0) -- Related To: PWSDE.PUBWORKS.SignPlates (22)

Layer: PWSDE.PUBWORKS.SignPlates (22)

Name: PWSDE.PUBWORKS.SignPlates

Display Field: CountyCode

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2000.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: 2380645.6467567235
YMin: 110719.2639234811
XMax: 2581380.7495508045
YMax: 402669.53435248137
Spatial Reference: 2926  (2926)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: D3-102
  Label: D3-102; U-SP; D3-302; S-P; R-SP
  Description: N/A
  Symbol:
  
• Value: U-SP
  Label: D3-102; U-SP; D3-302; S-P; R-SP
  Description: N/A
  Symbol:
  
• Value: D3-302
  Label: D3-102; U-SP; D3-302; S-P; R-SP
  Description: N/A
  Symbol:
  
• Value: S-P
  Label: D3-102; U-SP; D3-302; S-P; R-SP
  Description: N/A
  Symbol:
  
• Value: R-SP
  Label: D3-102; U-SP; D3-302; S-P; R-SP
  Description: N/A
  Symbol:
  
• Value: D3-102#
  Label: D3-102#
  Description: N/A
  Symbol:
  
• Value: R2-1
  Label: R2-1
  Description: N/A
  Symbol:
  
• Value: R1-1
  Label: R1-1
  Description: N/A
  Symbol:
  
• Value: W1-8
  Label: W1-8
  Description: N/A
  Symbol:
  
• Value: R8-3A
  Label: R8-3A; R7-9A; R7-1; R8-1; R7-101; R7-2; R7-6-9; R7-1L; R7-9
  Description: N/A
  Symbol:
  
• Value: R7-9A
  Label: R8-3A; R7-9A; R7-1; R8-1; R7-101; R7-2; R7-6-9; R7-1L; R7-9
  Description: N/A
  Symbol:
  
• Value: R7-1
  Label: R8-3A; R7-9A; R7-1; R8-1; R7-101; R7-2; R7-6-9; R7-1L; R7-9
  Description: N/A
  Symbol:
  
• Value: R8-1
  Label: R8-3A; R7-9A; R7-1; R8-1; R7-101; R7-2; R7-6-9; R7-1L; R7-9
  Description: N/A
  Symbol:
  
• Value: R7-101
  Label: R8-3A; R7-9A; R7-1; R8-1; R7-101; R7-2; R7-6-9; R7-1L; R7-9
  Description: N/A
  Symbol:
  
• Value: R7-2
  Label: R8-3A; R7-9A; R7-1; R8-1; R7-101; R7-2; R7-6-9; R7-1L; R7-9
  Description: N/A
  Symbol:
  
• Value: R7-6-9
  Label: R8-3A; R7-9A; R7-1; R8-1; R7-101; R7-2; R7-6-9; R7-1L; R7-9
  Description: N/A
  Symbol:
  
• Value: R7-1L
  Label: R8-3A; R7-9A; R7-1; R8-1; R7-101; R7-2; R7-6-9; R7-1L; R7-9
  Description: N/A
  Symbol:
  
• Value: R7-9
  Label: R8-3A; R7-9A; R7-1; R8-1; R7-101; R7-2; R7-6-9; R7-1L; R7-9
  Description: N/A
  Symbol:
  
• Value: W13-1
  Label: W13-1
  Description: N/A
  Symbol:
  
• Value: Z1-10R
  Label: Z1-10R
  Description: N/A
  Symbol:
  
• Value: Z1-10W
  Label: Z1-10W
  Description: N/A
  Symbol:
  
• Value: Z1-10FY
  Label: Z1-10FY; Z1-10Y
  Description: N/A
  Symbol:
  
• Value: Z1-10Y
  Label: Z1-10FY; Z1-10Y
  Description: N/A
  Symbol:
  
• Value: W14-1LP
  Label: W14-1LP; W14-1RP; W14-1
  Description: N/A
  Symbol:
  
• Value: W14-1RP
  Label: W14-1LP; W14-1RP; W14-1
  Description: N/A
  Symbol:
  
• Value: W14-1
  Label: W14-1LP; W14-1RP; W14-1
  Description: N/A
  Symbol:
  
• Value: W3-1
  Label: W3-1; W3-1A
  Description: N/A
  Symbol:
  
• Value: W3-1A
  Label: W3-1; W3-1A
  Description: N/A
  Symbol:
  
• Value: W12-401R
  Label: W12-401R; W12-401L
  Description: N/A
  Symbol:
  
• Value: W12-401L
  Label: W12-401R; W12-401L
  Description: N/A
  Symbol:
  
• Value: D3-2
  Label: D3-2
  Description: N/A
  Symbol:
  
• Value: W1-6
  Label: W1-6
  Description: N/A
  Symbol:
  
• Value: SPEC-1
  Label: SPEC-1
  Description: N/A
  Symbol:
  
• Value: W13-401
  Label: W13-401
  Description: N/A
  Symbol:
  
• Value: W16-7
  Label: W16-7
  Description: N/A
  Symbol:
  
• Value: S1-1
  Label: S1-1
  Description: N/A
  Symbol:
  
• Value: S3-1
  Label: S3-1
  Description: N/A
  Symbol:
  
• Value: W2-2
  Label: W2-2
  Description: N/A
  Symbol:
  
• Value: R3-9B
  Label: R3-9B
  Description: N/A
  Symbol:
  
• Value: W16-9P
  Label: W16-9P
  Description: N/A
  Symbol:
  
• Value: W11-2
  Label: W11-2
  Description: N/A
  Symbol:
  
• Value: NO SHOOT
  Label: NO SHOOT
  Description: N/A
  Symbol:
  
• Value: W1-5L
  Label: W1-5L; W1-5R
  Description: N/A
  Symbol:
  
• Value: W1-5R
  Label: W1-5L; W1-5R
  Description: N/A
  Symbol:
  
• Value: R3-17
  Label: R3-17
  Description: N/A
  Symbol:
  
• Value: W1-7
  Label: W1-7
  Description: N/A
  Symbol:
  
• Value: W10-1
  Label: W10-1
  Description: N/A
  Symbol:
  
• Value: W1-1L
  Label: W1-1L
  Description: N/A
  Symbol:
  
• Value: W1-1R
  Label: W1-1R
  Description: N/A
  Symbol:
  
• Value: R6-1R
  Label: R6-1R; R6-1L
  Description: N/A
  Symbol:
  
• Value: R6-1L
  Label: R6-1R; R6-1L
  Description: N/A
  Symbol:
  
• Value: W11-3
  Label: W11-3
  Description: N/A
  Symbol:
  
• Value: R1-4
  Label: R1-4
  Description: N/A
  Symbol:
  
• Value: D11-1
  Label: D11-1
  Description: N/A
  Symbol:
  
• Value: W1-2L
  Label: W1-2L
  Description: N/A
  Symbol:
  
• Value: W1-2R
  Label: W1-2R
  Description: N/A
  Symbol:
  
• Value: S3-201
  Label: S3-201
  Description: N/A
  Symbol:
  
• Value: R1-2
  Label: R1-2
  Description: N/A
  Symbol:
  
• Value: POINT
  Label: POINT
  Description: N/A
  Symbol:
  
• Value: W16-102
  Label: W16-102
  Description: N/A
  Symbol:
  
• Value: SRC
  Label: SRC
  Description: N/A
  Symbol:
  
• Value: M6-1
  Label: M6-1
  Description: N/A
  Symbol:
  
• Value: R4-7
  Label: R4-7
  Description: N/A
  Symbol:
  
• Value: R12-4
  Label: R12-4; R12-5
  Description: N/A
  Symbol:
  
• Value: R12-5
  Label: R12-4; R12-5
  Description: N/A
  Symbol:
  
• Value: W2-1
  Label: W2-1
  Description: N/A
  Symbol:
  
• Value: SP-CO
  Label: SP-CO
  Description: N/A
  Symbol:
  
• Value: S4-3
  Label: S4-3
  Description: N/A
  Symbol:
  
• Value: S4-2
  Label: S4-2
  Description: N/A
  Symbol:
  
• Value: S5-2
  Label: S5-2
  Description: N/A
  Symbol:
  
• Value: NO DUMPING
  Label: NO DUMPING
  Description: N/A
  Symbol:
  
• Value: W11-5
  Label: W11-5
  Description: N/A
  Symbol:
  
• Value: C-TRAIL
  Label: C-TRAIL
  Description: N/A
  Symbol:
  
• Value: R5-2A
  Label: R5-2A
  Description: N/A
  Symbol:
  
• Value: W1-3R
  Label: W1-3R
  Description: N/A
  Symbol:
  
• Value: W3-5
  Label: W3-5
  Description: N/A
  Symbol:
  
• Value: R3-7R
  Label: R3-7R
  Description: N/A
  Symbol:
  
• Value: W11-4
  Label: W11-4
  Description: N/A
  Symbol:
  
• Value: OM4-1
  Label: OM4-1
  Description: N/A
  Symbol:
  
• Value: W11-15
  Label: W11-15
  Description: N/A
  Symbol:
  
• Value: W1-3L
  Label: W1-3L
  Description: N/A
  Symbol:
  
• Value: W1-4R
  Label: W1-4R
  Description: N/A
  Symbol:
  
• Value: W1-4L
  Label: W1-4L
  Description: N/A
  Symbol:
  
• Value: R3-17C
  Label: R3-17C
  Description: N/A
  Symbol:
  
• Value: W11-8
  Label: W11-8
  Description: N/A
  Symbol:
  
• Value: W3-3
  Label: W3-3
  Description: N/A
  Symbol:
  
• Value: M1-8
  Label: M1-8
  Description: N/A
  Symbol:
  
• Value: S5-1
  Label: S5-1
  Description: N/A
  Symbol:
  
• Value: R3-2
  Label: R3-2
  Description: N/A
  Symbol:
  
• Value: R3-1
  Label: R3-1
  Description: N/A
  Symbol:
  
• Value: W14-2
  Label: W14-2
  Description: N/A
  Symbol:
  
• Value: W8-3
  Label: W8-3
  Description: N/A
  Symbol:
  
• Value: I8-804
  Label: I8-804
  Description: N/A
  Symbol:
  
• Value: I8-804C
  Label: I8-804C
  Description: N/A
  Symbol:
  
• Value: W15-1
  Label: W15-1
  Description: N/A
  Symbol:
  
• Value: W2-4
  Label: W2-4
  Description: N/A
  Symbol:
  
• Value: W12-2
  Label: W12-2
  Description: N/A
  Symbol:
  
• Value: W11-15a
  Label: W11-15a
  Description: N/A
  Symbol:
  
• Value: R3-17 B
  Label: R3-17 B
  Description: N/A
  Symbol:
  
• Value: R5-1
  Label: R5-1
  Description: N/A
  Symbol:
  
• Value: Other plates
  Label: Other plates
  Description: N/A
  Symbol:
  
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• MaintDate ( type: esriFieldTypeDate, alias: Last Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaintDate )
• PostRelID ( type: esriFieldTypeGUID, alias: PostRelID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PostRelID )
• LastEditor2 ( type: esriFieldTypeString, alias: Last Editor 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LastEditor2 )
• LastEditor ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LastEditor )
• NewestMaintenance2 ( type: esriFieldTypeString, alias: Newest Maintenance, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NewestMaintenance2 , Coded Values: [INSPSIGN: Inspect Sign] , [CLEASIGN: Clean Sign] , [ADDSIGN: Inventory Correction - Add Sign] , ...7 more... )
• NewestMaintenanceReason2 ( type: esriFieldTypeString, alias: Newest Maintenance Reason, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NewestMaintenanceReason2 , Coded Values: [BALLBANK: Ball Bank] , [CNSTPROJ: Construction Project] , [CNTYCODE: County Code] , ...14 more... )
• CodeLegend ( type: esriFieldTypeString, alias: CodeLegend, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CodeLegend )
• SignCode ( type: esriFieldTypeString, alias: Sign Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignCode , Coded Values: [12-101C: 12-101C] , [12.13: 12.13] , [ARTERIAL-C: ARTERIAL-C] , ...491 more... )
• Legend ( type: esriFieldTypeString, alias: Legend, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Legend , Coded Values: [% GRADE FOR-MILES: % GRADE FOR-MILES] , [% GRADE PLAQUE: % GRADE PLAQUE] , [_ MILE(S): _ MILE(S)] , ...465 more... )
• SignColor ( type: esriFieldTypeString, alias: Sign Color, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SignColor , Coded Values: [AMBER: Amber] , [Blk/G: Black legend, Green background] , [Blk/O: Black legend, Orange background] , ...44 more... )
• LegendDetail ( type: esriFieldTypeString, alias: Legend Detail, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LegendDetail )
• SignSize ( type: esriFieldTypeString, alias: Sign Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignSize , Coded Values: [6 X 8: 6 X 8] , [6 X 12: 6 X 12] , [6 X 24: 6 X 24] , ...64 more... )
• SheetingMaterial ( type: esriFieldTypeString, alias: Sheeting Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SheetingMaterial , Coded Values: [EG: Engineering Grade] , [HIP: High Intensity/ Prismatic] , [EC: Electronic Cutable] , ...1 more... )
• PlateMaterial ( type: esriFieldTypeString, alias: Plate Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PlateMaterial , Coded Values: [AL: Aluminum] , [FG: Fiberglass] , [PW: Plywood] , ...2 more... )
• MountPositionNum ( type: esriFieldTypeInteger, alias: Mount Position, editable: true, nullable: true, defaultValue: null, modelName: MountPositionNum )
• Orientation ( type: esriFieldTypeString, alias: Orientation, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Orientation )
• Comment ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comment )
• RoadName ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RoadName )
• RoadNumber ( type: esriFieldTypeString, alias: Road Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: RoadNumber )
• MP ( type: esriFieldTypeDouble, alias: Milepost, editable: true, nullable: true, defaultValue: null, modelName: MP )
• DateInstalled ( type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled )
• DateRemoved ( type: esriFieldTypeDate, alias: Date Removed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateRemoved )
• CountyCode ( type: esriFieldTypeString, alias: County Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CountyCode )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global Plate ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• SignPlateGlobalID ( type: esriFieldTypeGUID, alias: GUID Plate ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: SignPlateGlobalID )
• SignHeight ( type: esriFieldTypeDouble, alias: Sign Height, editable: true, nullable: true, defaultValue: null, modelName: SignHeight )
• MountPosition ( type: esriFieldTypeString, alias: MountPosition, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MountPosition )
• BarCode ( type: esriFieldTypeString, alias: BarCode, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BarCode )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SerialNumber )
• ControlSign ( type: esriFieldTypeString, alias: ControlSign, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ControlSign )
• PlateCondition ( type: esriFieldTypeInteger, alias: PlateCondition, editable: true, nullable: true, defaultValue: null, modelName: PlateCondition )
• SignPostID ( type: esriFieldTypeInteger, alias: SignPostID, editable: true, nullable: true, defaultValue: null, modelName: SignPostID )
• signplateid ( type: esriFieldTypeInteger, alias: signplateid, editable: true, nullable: true, defaultValue: null, modelName: signplateid )
• InstallYear ( type: esriFieldTypeInteger, alias: InstallYear, editable: true, nullable: true, defaultValue: null, modelName: InstallYear )
• SignCodeSymbology ( type: esriFieldTypeString, alias: SignCodeSymbology, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SignCodeSymbology )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• XCoord ( type: esriFieldTypeDouble, alias: XCoord, editable: true, nullable: true, defaultValue: null, modelName: XCoord )
• YCoord ( type: esriFieldTypeDouble, alias: YCoord, editable: true, nullable: true, defaultValue: null, modelName: YCoord )
• PlateIDText ( type: esriFieldTypeString, alias: PlateIDText, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PlateIDText )
• NewestMaintenance ( type: esriFieldTypeString, alias: Newest Maintenance OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: NewestMaintenance )
• NewestMaintenanceReason ( type: esriFieldTypeString, alias: Newest Maintenance Reason OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: NewestMaintenanceReason )
Templates:
• Name: Plate
  Description:
  Prototype:
  NewestMaintenance: null
  MaintDate: null
  PostRelID: null
  LastEditor2: null
  LastEditor: null
  NewestMaintenance2: null
  NewestMaintenanceReason2: null
  CodeLegend: null
  SignCode: null
  Legend: null
  SignColor: null
  LegendDetail: null
  SignSize: null
  SheetingMaterial: null
  PlateMaterial: null
  MountPositionNum: null
  Orientation: null
  Comment: null
  RoadName: null
  RoadNumber: null
  MP: null
  DateInstalled: null
  DateRemoved: null
  CountyCode: null
  NewestMaintenanceReason: null
  SignPlateGlobalID: null
  SignHeight: null
  MountPosition: null
  BarCode: null
  SerialNumber: null
  ControlSign: null
  PlateCondition: null
  SignPostID: null
  signplateid: null
  InstallYear: null
  SignCodeSymbology: null
  XCoord: null
  YCoord: null
  PlateIDText: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• PWSDE.PUBWORKS.Posts_Plates_Work (3) -- Related To: PWSDE.PUBWORKS.Posts_Plates_Work (29)
• PWSDE.PUBWORKS.Sign_Orders (4) -- Related To: PWSDE.PUBWORKS.Sign_Orders (28)
• plates_to_post (0) -- Related To: PWSDE.PUBWORKS.SignPosts (21)

Layer: PWSDE.PUBWORKS.MilepostsDisplay_CRAB_WANorth (17)

Name: PWSDE.PUBWORKS.MilepostsDisplay_CRAB_WANorth

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3000.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: 2380443.5799036324
YMin: 110312.66827997565
XMax: 2582107.4587273
YMax: 403311.0668620616
Spatial Reference: 2926  (2926)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Legend
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: BeginMP
  Label: BeginMP
  Description: N/A
  Symbol:
  
• Value: EndMP
  Label: EndMP
  Description: N/A
  Symbol:
  
• Value: Halfmile
  Label: Halfmile
  Description: N/A
  Symbol:
  
• Value: Hundredthmile
  Label: Hundredthmile
  Description: N/A
  Symbol:
  
• Value: Mile
  Label: Mile
  Description: N/A
  Symbol:
  
• Value: Tenthmile
  Label: Tenthmile
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [Milepost]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [Milepost]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [Milepost]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [Milepost]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [Milepost]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0

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


HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Legend

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• RoadNumber ( type: esriFieldTypeString, alias: RoadNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RoadNumber )
• ORIG_FID ( type: esriFieldTypeInteger, alias: ORIG_FID, editable: true, nullable: true, defaultValue: null, modelName: ORIG_FID )
• Milepost ( type: esriFieldTypeDouble, alias: Milepost, editable: true, nullable: true, defaultValue: null, modelName: Milepost )
• Legend ( type: esriFieldTypeString, alias: Legend, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Legend )
• RoadName ( type: esriFieldTypeString, alias: RoadName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RoadName )
• LOC_ANGLE ( type: esriFieldTypeDouble, alias: LOC_ANGLE, editable: true, nullable: true, defaultValue: null, modelName: LOC_ANGLE )
• LOC_ERROR ( type: esriFieldTypeString, alias: LOC_ERROR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOC_ERROR )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Types:
ID: BeginMP
Name: BeginMP
Domains:
Templates:
• Name: BeginMP
  Description:
  Prototype:
  Milepost: null
  LOC_ERROR: null
  RoadNumber: null
  ORIG_FID: null
  Legend: BeginMP
  RoadName: null
  LOC_ANGLE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: EndMP
Name: EndMP
Domains:
Templates:
• Name: EndMP
  Description:
  Prototype:
  Milepost: null
  LOC_ERROR: null
  RoadNumber: null
  ORIG_FID: null
  Legend: EndMP
  RoadName: null
  LOC_ANGLE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Halfmile
Name: Halfmile
Domains:
Templates:
• Name: Halfmile
  Description:
  Prototype:
  Milepost: null
  LOC_ERROR: null
  RoadNumber: null
  ORIG_FID: null
  Legend: Halfmile
  RoadName: null
  LOC_ANGLE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Hundredthmile
Name: Hundredthmile
Domains:
Templates:
• Name: Hundredthmile
  Description:
  Prototype:
  Milepost: null
  LOC_ERROR: null
  RoadNumber: null
  ORIG_FID: null
  Legend: Hundredthmile
  RoadName: null
  LOC_ANGLE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Mile
Name: Mile
Domains:
Templates:
• Name: Mile
  Description:
  Prototype:
  Milepost: null
  LOC_ERROR: null
  RoadNumber: null
  ORIG_FID: null
  Legend: Mile
  RoadName: null
  LOC_ANGLE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Tenthmile
Name: Tenthmile
Domains:
Templates:
• Name: Tenthmile
  Description:
  Prototype:
  Milepost: null
  LOC_ERROR: null
  RoadNumber: null
  ORIG_FID: null
  Legend: Tenthmile
  RoadName: null
  LOC_ANGLE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Layer: PWSDE.PUBWORKS.RoadSegments_CRAB_WANorth (18)

Name: PWSDE.PUBWORKS.RoadSegments_CRAB_WANorth

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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: 2380443.5799036324
YMin: 110312.66827997565
XMax: 2582107.4587273
YMax: 403311.0668620616
Spatial Reference: 2926  (2926)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 3
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Tahoma
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 18000.0
Max. Scale: 0.0

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


HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• StateLRS ( type: esriFieldTypeString, alias: StateLRS, editable: true, nullable: true, length: 7, defaultValue: null, modelName: StateLRS )
• BMP ( type: esriFieldTypeDouble, alias: BMP, editable: true, nullable: true, defaultValue: null, modelName: BMP )
• EMP ( type: esriFieldTypeDouble, alias: EMP, editable: true, nullable: true, defaultValue: null, modelName: EMP )
• RoadNumber ( type: esriFieldTypeString, alias: RoadNumber, editable: true, nullable: true, length: 5, defaultValue: null, modelName: RoadNumber )
• RoadName ( type: esriFieldTypeString, alias: RoadName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RoadName )
• FunctionClass ( type: esriFieldTypeString, alias: FunctionClass, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FunctionClass )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Jurisdiction )
• JurisdictionDetail ( type: esriFieldTypeString, alias: JurisdictionDetail, editable: true, nullable: true, length: 100, defaultValue: null, modelName: JurisdictionDetail )
• PrimitiveRoad ( type: esriFieldTypeString, alias: PrimitiveRoad, editable: true, nullable: true, length: 75, defaultValue: null, modelName: PrimitiveRoad )
• MaintenanceDist ( type: esriFieldTypeString, alias: MaintenanceDist, editable: true, nullable: true, length: 4, defaultValue: null, modelName: MaintenanceDist )
• ThruLaneMaintenanceType ( type: esriFieldTypeString, alias: ThruLaneMaintenanceType, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ThruLaneMaintenanceType )
• ThruLaneReplacementType ( type: esriFieldTypeString, alias: ThruLaneReplacementType, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ThruLaneReplacementType )
• ThruLanes ( type: esriFieldTypeInteger, alias: ThruLanes, editable: true, nullable: true, defaultValue: null, modelName: ThruLanes )
• TruckRouteClassification ( type: esriFieldTypeString, alias: TruckRouteClassification, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TruckRouteClassification )
• ADTVolume ( type: esriFieldTypeInteger, alias: ADTVolume, editable: true, nullable: true, defaultValue: null, modelName: ADTVolume )
• ADTSource ( type: esriFieldTypeString, alias: ADTSource, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADTSource )
• ADTYear ( type: esriFieldTypeInteger, alias: ADTYear, editable: true, nullable: true, defaultValue: null, modelName: ADTYear )
• FromDescr ( type: esriFieldTypeString, alias: FromDescr, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FromDescr )
• ToDescr ( type: esriFieldTypeString, alias: ToDescr, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ToDescr )
• MileLength ( type: esriFieldTypeDouble, alias: MileLength, editable: true, nullable: true, defaultValue: null, modelName: MileLength )
• PavementWidth ( type: esriFieldTypeSmallInteger, alias: PavementWidth, editable: true, nullable: true, defaultValue: null, modelName: PavementWidth )
• OperationalWidth ( type: esriFieldTypeSmallInteger, alias: OperationalWidth, editable: true, nullable: true, defaultValue: null, modelName: OperationalWidth )
• CrossSectionWidth ( type: esriFieldTypeSmallInteger, alias: CrossSectionWidth, editable: true, nullable: true, defaultValue: null, modelName: CrossSectionWidth )
• LOC_ERROR ( type: esriFieldTypeString, alias: LOC_ERROR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOC_ERROR )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )
Templates:
• Name: PWSDE.PUBWORKS.RoadSegments_CRAB_WANorth
  Description:
  Prototype:
  LOC_ERROR: null
  StateLRS: null
  BMP: null
  EMP: null
  RoadNumber: null
  RoadName: null
  FunctionClass: null
  Jurisdiction: null
  JurisdictionDetail: null
  PrimitiveRoad: null
  MaintenanceDist: null
  ThruLaneMaintenanceType: null
  ThruLaneReplacementType: null
  ThruLanes: null
  TruckRouteClassification: null
  ADTVolume: null
  ADTSource: null
  ADTYear: null
  FromDescr: null
  ToDescr: null
  MileLength: null
  PavementWidth: null
  OperationalWidth: null
  CrossSectionWidth: null
  
  Drawing Tool: esriFeatureEditToolLine

Tables:

Table: PWSDE.PUBWORKS.Sign_Orders (28)

Name: PWSDE.PUBWORKS.Sign_Orders

Display Field: SignCode

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SignCode ( type: esriFieldTypeString, alias: SignCode, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignCode , Coded Values: [Z1-10Y: Z1-10Y] , [Z1-10W: Z1-10W] , [Z1-10R: Z1-10R] , ...219 more... )
• SignDescription ( type: esriFieldTypeString, alias: SignDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignDescription , Coded Values: [ S SCHOOL XWALK ARROW FL YEL GR RIGHT: S SCHOOL XWALK ARROW FL YEL GR RIGHT] , [18" LIME GREEN CONES: 18" LIME GREEN CONES] , [3" X 36" FLURESCENT YLW STRIP: 3" X 36" FLURESCENT YLW STRIP] , ...324 more... )
• SignItemNumber ( type: esriFieldTypeString, alias: SignItemNumber, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignItemNumber , Coded Values: [24 0100: 24 0100] , [24 0101: 24 0101] , [24 0103: 24 0103] , ...322 more... )
• Qty ( type: esriFieldTypeInteger, alias: Qty, editable: true, nullable: true, defaultValue: null, modelName: Qty )
• ActivityCode ( type: esriFieldTypeString, alias: ActivityCode, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ActivityCode , Coded Values: [Add to Inventory: Add to Inventory] , [Adjust: Adjust] , [Adjust Pressure: Adjust Pressure] , ...239 more... )
• SubmittedBy ( type: esriFieldTypeString, alias: SubmittedBy, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SubmittedBy )
• SubmittedDate ( type: esriFieldTypeString, alias: SubmittedDate, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SubmittedDate )
• Department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Department , Coded Values: [110BRIDGES: 110BRIDGES] , [110CONADMI: CONSTRUCTION ADMIN] , [110COSV: CITY OF SPOKANE VALLEY] , ...110 more... )
• WorkOrderID ( type: esriFieldTypeInteger, alias: WorkOrderID, editable: true, nullable: true, defaultValue: null, modelName: WorkOrderID )
• BlankDescription ( type: esriFieldTypeString, alias: BlankDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: BlankDescription , Coded Values: [1-WAY PAVEMENT MARKERS YELLO: 1-WAY PAVEMENT MARKERS YELLO] , [24" SUMMA WHITE REFLECTIVE: 24" SUMMA WHITE REFLECTIVE] , [24" SUMMA WHITE VINYL: 24" SUMMA WHITE VINYL] , ...243 more... )
• BlankItemNumber ( type: esriFieldTypeString, alias: BlankItemNumber, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: BlankItemNumber , Coded Values: [24 0923: 24 0923] , [24 0925: 24 0925] , [24 0926: 24 0926] , ...237 more... )
• BlankPreSheeted ( type: esriFieldTypeInteger, alias: BlankPreSheeted, editable: true, nullable: true, defaultValue: null, modelName: BlankPreSheeted )
• BlankNew ( type: esriFieldTypeInteger, alias: BlankNew, editable: true, nullable: true, defaultValue: null, modelName: BlankNew )
• LaborTime ( type: esriFieldTypeDouble, alias: LaborTime, editable: true, nullable: true, defaultValue: null, modelName: LaborTime )
• LaborRate ( type: esriFieldTypeDouble, alias: LaborRate, editable: true, nullable: true, defaultValue: null, modelName: LaborRate )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Status )
• ProcessedBy ( type: esriFieldTypeString, alias: ProcessedBy, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ProcessedBy )
• ProcessedDate ( type: esriFieldTypeString, alias: ProcessedDate, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ProcessedDate )
• FasterID ( type: esriFieldTypeString, alias: FasterID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FasterID )
• PostGUID ( type: esriFieldTypeGUID, alias: Post GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PostGUID )
• PlateGUID ( type: esriFieldTypeGUID, alias: Plate GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PlateGUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: PWSDE.PUBWORKS.Sign_Orders
  Description:
  Prototype:
  PlateGUID: null
  SignCode: null
  SignDescription: null
  SignItemNumber: null
  Qty: null
  ActivityCode: null
  SubmittedBy: null
  SubmittedDate: null
  Department: null
  WorkOrderID: null
  BlankDescription: null
  BlankItemNumber: null
  BlankPreSheeted: null
  BlankNew: null
  LaborTime: null
  LaborRate: null
  Status: null
  ProcessedBy: null
  ProcessedDate: null
  FasterID: null
  PostGUID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PWSDE.PUBWORKS.SignPosts (2) -- Related To: PWSDE.PUBWORKS.SignPosts (21)
• PWSDE.PUBWORKS.SignPlates (4) -- Related To: PWSDE.PUBWORKS.SignPlates (22)

Table: PWSDE.PUBWORKS.Posts_Plates_Work (29)

Name: PWSDE.PUBWORKS.Posts_Plates_Work

Display Field: RoadName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• MaintDate ( type: esriFieldTypeDate, alias: MaintDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaintDate )
• SignPlateGlobalID ( type: esriFieldTypeGUID, alias: SignPlateGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: SignPlateGlobalID )
• SignPostGlobalID ( type: esriFieldTypeGUID, alias: SignPostGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: SignPostGlobalID )
• SignMaintenanceActivityCode ( type: esriFieldTypeString, alias: SignMaintenanceActivityCode, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SignMaintenanceActivityCode )
• MaintenanceActivityReasonCode ( type: esriFieldTypeString, alias: MaintenanceActivityReasonCode, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaintenanceActivityReasonCode )
• UserID ( type: esriFieldTypeString, alias: UserID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: UserID , Coded Values: [BPRIGAN: BPRIGAN] , [JGREEN: JGREEN] , [IBIRD: IBIRD] , ...12 more... )
• SignCode ( type: esriFieldTypeString, alias: SignCode, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SignCode )
• Legend ( type: esriFieldTypeString, alias: Legend, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Legend )
• LegendDetail ( type: esriFieldTypeString, alias: LegendDetail, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LegendDetail )
• SignSheetingMaterialTypeCode ( type: esriFieldTypeString, alias: SignSheetingMaterialTypeCode, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SignSheetingMaterialTypeCode )
• SignPlateMaterialTypeCode ( type: esriFieldTypeString, alias: SignPlateMaterialTypeCode, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SignPlateMaterialTypeCode )
• SignColorTypeCode ( type: esriFieldTypeString, alias: SignColorTypeCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SignColorTypeCode )
• SignSizeTypeCode ( type: esriFieldTypeString, alias: SignSizeTypeCode, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SignSizeTypeCode )
• MountPosition ( type: esriFieldTypeString, alias: MountPosition, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MountPosition )
• Orientation ( type: esriFieldTypeString, alias: Orientation, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Orientation )
• ActivityComment ( type: esriFieldTypeString, alias: ActivityComment, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ActivityComment )
• InitialInstallYear ( type: esriFieldTypeSmallInteger, alias: InitialInstallYear, editable: true, nullable: true, defaultValue: null, modelName: InitialInstallYear )
• DateInstalled ( type: esriFieldTypeDate, alias: DateInstalled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled )
• DateRemoved ( type: esriFieldTypeDate, alias: DateRemoved, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateRemoved )
• TransactionAppliedToGISInventor ( type: esriFieldTypeSmallInteger, alias: TransactionAppliedToGISInventory, editable: true, nullable: true, defaultValue: null, modelName: TransactionAppliedToGISInventor )
• RoadNumber ( type: esriFieldTypeString, alias: RoadNumber, editable: true, nullable: true, length: 5, defaultValue: null, modelName: RoadNumber )
• MP ( type: esriFieldTypeDouble, alias: MP, editable: true, nullable: true, defaultValue: null, modelName: MP )
• RoadName ( type: esriFieldTypeString, alias: RoadName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RoadName )
• PostTypeCode ( type: esriFieldTypeString, alias: PostTypeCode, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PostTypeCode )
• PostTreatmentCode ( type: esriFieldTypeString, alias: PostTreatmentCode, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PostTreatmentCode )
• NumberOfPosts ( type: esriFieldTypeSmallInteger, alias: NumberOfPosts, editable: true, nullable: true, defaultValue: null, modelName: NumberOfPosts )
• SideOfRoad ( type: esriFieldTypeString, alias: SideOfRoad, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SideOfRoad )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: PWSDE.PUBWORKS.Posts_Plates_Work
  Description:
  Prototype:
  SideOfRoad: null
  MaintDate: null
  SignPlateGlobalID: null
  SignPostGlobalID: null
  SignMaintenanceActivityCode: null
  MaintenanceActivityReasonCode: null
  UserID: null
  SignCode: null
  Legend: null
  LegendDetail: null
  SignSheetingMaterialTypeCode: null
  SignPlateMaterialTypeCode: null
  SignColorTypeCode: null
  SignSizeTypeCode: null
  MountPosition: null
  Orientation: null
  ActivityComment: null
  InitialInstallYear: null
  DateInstalled: null
  DateRemoved: null
  TransactionAppliedToGISInventor: null
  RoadNumber: null
  MP: null
  RoadName: null
  PostTypeCode: null
  PostTreatmentCode: null
  NumberOfPosts: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PWSDE.PUBWORKS.SignPlates (3) -- Related To: PWSDE.PUBWORKS.SignPlates (22)
• PWSDE.PUBWORKS.SignPosts (1) -- Related To: PWSDE.PUBWORKS.SignPosts (21)