View In:   ArcGIS Online Map Viewer

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)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata