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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: null

Fields:

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

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)

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

  Iteminfo   Thumbnail   Metadata