View In:   ArcGIS Online Map Viewer

Name: Sign Status

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: d43c636c36414585bbb91a05ee508a00

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 1755649.804133825
YMin: 141782.89888393134
XMax: 1777085.4883785136
YMax: 182241.75866486877
Spatial Reference: 103180  (6597)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Pending
  Label: Pending
  Description: N/A
  Symbol:
  
• Value: Replaced
  Label: Replaced
  Description: N/A
  Symbol:
  
• Value: Needs Replaced
  Label: Needs Replaced
  Description: N/A
  Symbol:
  
• Value: Needs Repair
  Label: Needs Repair
  Description: N/A
  Symbol:
  
• Value: Post Needs Replacing
  Label: Post Needs Replacing
  Description: N/A
  Symbol:
  
• Value: Sign Obscured
  Label: Sign Obscured
  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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Status

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• ATTACHID ( type: esriFieldTypeString, alias: Attachment ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ATTACHID )
• SIGNTYPE ( type: esriFieldTypeString, alias: Sign Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGNTYPE , Coded Values: [Regulatory: Regulatory] , [Warning: Warning] , [Guide: Guide] , ...10 more... )
• SIGNHEIGHT ( type: esriFieldTypeDouble, alias: Height (in), editable: true, nullable: true, defaultValue: null, modelName: SIGNHEIGHT )
• SIGNWIDTH ( type: esriFieldTypeDouble, alias: Width (in), editable: true, nullable: true, defaultValue: null, modelName: SIGNWIDTH )
• SIGNSTYLE ( type: esriFieldTypeString, alias: Style, editable: true, nullable: true, length: 130, defaultValue: null, modelName: SIGNSTYLE , Coded Values: [R1-1: Stop Sign] , [R1-2: Yield] , [R1-3W: 3 Way Stop] , ...118 more... )
• SIGNTEXT ( type: esriFieldTypeString, alias: Text, editable: true, nullable: true, length: 150, defaultValue: null, modelName: SIGNTEXT )
• FACING ( type: esriFieldTypeString, alias: Facing Direction, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACING , Coded Values: [East: East] , [North: North] , [South: South] , ...11 more... )
• HORIZCLEAR ( type: esriFieldTypeString, alias: Horizontal Clearance, editable: true, nullable: true, length: 12, defaultValue: null, modelName: HORIZCLEAR )
• HORIZFROM ( type: esriFieldTypeString, alias: Horizontal From, editable: true, nullable: true, length: 12, defaultValue: null, modelName: HORIZFROM )
• VERTFROM ( type: esriFieldTypeString, alias: Vertical From, editable: true, nullable: true, length: 12, defaultValue: null, modelName: VERTFROM )
• ANGLE ( type: esriFieldTypeSmallInteger, alias: Angle (Degrees), editable: true, nullable: true, defaultValue: null, modelName: ANGLE )
• DISTTOTOP ( type: esriFieldTypeDouble, alias: Distance to Top of Pole, editable: true, nullable: true, defaultValue: null, modelName: DISTTOTOP )
• REFLCOAT ( type: esriFieldTypeString, alias: Reflective Coating, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REFLCOAT )
• SHEETING ( type: esriFieldTypeString, alias: Sheeting Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SHEETING , 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, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SUPMATERIAL )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OWNEDBY , Coded Values: [-1: Private] , [-2: Other] , [1: City of Wenatchee] , ...5 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: MAINTBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• SIGNORIENTATION ( type: esriFieldTypeString, alias: SIGNORIENTATION, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SIGNORIENTATION , Coded Values: [Towards N Bound Traffic: Towards N Bound Traffic] , [Towards S Bound Traffic: Towards S Bound Traffic] , [Towards W Bound Traffic: Towards W Bound Traffic] , ...6 more... )
• POSTTYPE ( type: esriFieldTypeString, alias: POSTTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POSTTYPE , Coded Values: [Wood: Wood] , [Steel Post: Steel Post] , [Concrete: Concrete] , ...4 more... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• STREETLOCATION ( type: esriFieldTypeString, alias: STREETLOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREETLOCATION , Coded Values: [Right: Right] , [Left: Left] , [Center: Center] , ...1 more... )
• MUTCD_ORIGINAL ( type: esriFieldTypeString, alias: MUTCD_ORIGINAL, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MUTCD_ORIGINAL )
• PROJECT ( type: esriFieldTypeString, alias: PROJECT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT )
• PROJECTNUMBER ( type: esriFieldTypeString, alias: PROJECTNUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECTNUMBER )
• PROJECTENGINEER ( type: esriFieldTypeString, alias: PROJECTENGINEER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECTENGINEER )
• PLANASBUILTDATE ( type: esriFieldTypeDate, alias: PLANASBUILTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLANASBUILTDATE )
• SIGNCONTENTLONG ( type: esriFieldTypeString, alias: SIGNCONTENTLONG, editable: true, nullable: true, length: 300, defaultValue: null, modelName: SIGNCONTENTLONG )
• OriginalGlobalID ( type: esriFieldTypeGUID, alias: OriginalGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: OriginalGlobalID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Status , Coded Values: [Replaced: Replaced] , [Needs Replaced: Needs Replaced] , [Needs Repair: Needs Repair] , ...3 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• UID ( type: esriFieldTypeInteger, alias: UID, editable: true, nullable: true, defaultValue: null, modelName: UID )
• assetname ( type: esriFieldTypeString, alias: Asset Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: assetname )
• locdesc ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: locdesc )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source, editable: true, nullable: true, defaultValue: null, modelName: spatialsource , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...7 more... )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence, editable: true, nullable: true, defaultValue: null, modelName: spatialconfidence , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• aandefirm ( type: esriFieldTypeString, alias: A and E Firm, editable: true, nullable: true, length: 255, defaultValue: null, modelName: aandefirm )
• projecttitle ( type: esriFieldTypeString, alias: Project Title, editable: true, nullable: true, length: 255, defaultValue: null, modelName: projecttitle )
• label ( type: esriFieldTypeString, alias: Map Label, editable: true, nullable: true, length: 255, defaultValue: null, modelName: label )
• flmetacode ( type: esriFieldTypeString, alias: FLMetaCode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: flmetacode )
• vertdatum ( type: esriFieldTypeString, alias: Vertical Datum, editable: true, nullable: true, length: 255, defaultValue: null, modelName: vertdatum )

Types:

ID: Pending
Name: Pending
Domains:
• SIGNTYPE:
  Inherited
• SIGNSTYLE:
  Inherited
• FACING:
  Inherited
• SHEETING:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• SIGNORIENTATION:
  Inherited
• POSTTYPE:
  Inherited
• STREETLOCATION:
  Inherited
• Status:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
Templates:
• Name: Pending
  Description:
  Prototype:
  vertdatum: null
  flmetacode: null
  FACILITYID: null
  ATTACHID: null
  SIGNTYPE: null
  SIGNHEIGHT: null
  SIGNWIDTH: null
  SIGNSTYLE: null
  SIGNTEXT: null
  FACING: null
  HORIZCLEAR: null
  HORIZFROM: null
  VERTFROM: null
  ANGLE: null
  DISTTOTOP: null
  REFLCOAT: null
  SHEETING: null
  SUPMATERIAL: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  SIGNORIENTATION: null
  POSTTYPE: null
  COMMENTS: null
  STREETLOCATION: null
  MUTCD_ORIGINAL: null
  PROJECT: null
  PROJECTNUMBER: null
  PROJECTENGINEER: null
  PLANASBUILTDATE: null
  SIGNCONTENTLONG: null
  OriginalGlobalID: null
  Status: Pending
  label: null
  projecttitle: null
  aandefirm: null
  spatialconfidence: null
  UID: null
  assetname: null
  locdesc: null
  spatialsource: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Replaced
Name: Replaced
Domains:
• SIGNTYPE:
  Inherited
• SIGNSTYLE:
  Inherited
• FACING:
  Inherited
• SHEETING:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• SIGNORIENTATION:
  Inherited
• POSTTYPE:
  Inherited
• STREETLOCATION:
  Inherited
• Status:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
Templates:
• Name: Replaced
  Description:
  Prototype:
  vertdatum: null
  flmetacode: null
  FACILITYID: null
  ATTACHID: null
  SIGNTYPE: null
  SIGNHEIGHT: null
  SIGNWIDTH: null
  SIGNSTYLE: null
  SIGNTEXT: null
  FACING: null
  HORIZCLEAR: null
  HORIZFROM: null
  VERTFROM: null
  ANGLE: null
  DISTTOTOP: null
  REFLCOAT: null
  SHEETING: null
  SUPMATERIAL: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  SIGNORIENTATION: null
  POSTTYPE: null
  COMMENTS: null
  STREETLOCATION: null
  MUTCD_ORIGINAL: null
  PROJECT: null
  PROJECTNUMBER: null
  PROJECTENGINEER: null
  PLANASBUILTDATE: null
  SIGNCONTENTLONG: null
  OriginalGlobalID: null
  Status: Replaced
  label: null
  projecttitle: null
  aandefirm: null
  spatialconfidence: null
  UID: null
  assetname: null
  locdesc: null
  spatialsource: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Needs Replaced
Name: Needs Replaced
Domains:
• SIGNTYPE:
  Inherited
• SIGNSTYLE:
  Inherited
• FACING:
  Inherited
• SHEETING:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• SIGNORIENTATION:
  Inherited
• POSTTYPE:
  Inherited
• STREETLOCATION:
  Inherited
• Status:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
Templates:
• Name: Needs Replaced
  Description:
  Prototype:
  vertdatum: null
  flmetacode: null
  FACILITYID: null
  ATTACHID: null
  SIGNTYPE: null
  SIGNHEIGHT: null
  SIGNWIDTH: null
  SIGNSTYLE: null
  SIGNTEXT: null
  FACING: null
  HORIZCLEAR: null
  HORIZFROM: null
  VERTFROM: null
  ANGLE: null
  DISTTOTOP: null
  REFLCOAT: null
  SHEETING: null
  SUPMATERIAL: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  SIGNORIENTATION: null
  POSTTYPE: null
  COMMENTS: null
  STREETLOCATION: null
  MUTCD_ORIGINAL: null
  PROJECT: null
  PROJECTNUMBER: null
  PROJECTENGINEER: null
  PLANASBUILTDATE: null
  SIGNCONTENTLONG: null
  OriginalGlobalID: null
  Status: Needs Replaced
  label: null
  projecttitle: null
  aandefirm: null
  spatialconfidence: null
  UID: null
  assetname: null
  locdesc: null
  spatialsource: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Needs Repair
Name: Needs Repair
Domains:
• SIGNTYPE:
  Inherited
• SIGNSTYLE:
  Inherited
• FACING:
  Inherited
• SHEETING:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• SIGNORIENTATION:
  Inherited
• POSTTYPE:
  Inherited
• STREETLOCATION:
  Inherited
• Status:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
Templates:
• Name: Needs Repair
  Description:
  Prototype:
  vertdatum: null
  flmetacode: null
  FACILITYID: null
  ATTACHID: null
  SIGNTYPE: null
  SIGNHEIGHT: null
  SIGNWIDTH: null
  SIGNSTYLE: null
  SIGNTEXT: null
  FACING: null
  HORIZCLEAR: null
  HORIZFROM: null
  VERTFROM: null
  ANGLE: null
  DISTTOTOP: null
  REFLCOAT: null
  SHEETING: null
  SUPMATERIAL: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  SIGNORIENTATION: null
  POSTTYPE: null
  COMMENTS: null
  STREETLOCATION: null
  MUTCD_ORIGINAL: null
  PROJECT: null
  PROJECTNUMBER: null
  PROJECTENGINEER: null
  PLANASBUILTDATE: null
  SIGNCONTENTLONG: null
  OriginalGlobalID: null
  Status: Needs Repair
  label: null
  projecttitle: null
  aandefirm: null
  spatialconfidence: null
  UID: null
  assetname: null
  locdesc: null
  spatialsource: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Post Needs Replacing
Name: Post Needs Replacing
Domains:
• SIGNTYPE:
  Inherited
• SIGNSTYLE:
  Inherited
• FACING:
  Inherited
• SHEETING:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• SIGNORIENTATION:
  Inherited
• POSTTYPE:
  Inherited
• STREETLOCATION:
  Inherited
• Status:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
Templates:
• Name: Post Needs Replacing
  Description:
  Prototype:
  vertdatum: null
  flmetacode: null
  FACILITYID: null
  ATTACHID: null
  SIGNTYPE: null
  SIGNHEIGHT: null
  SIGNWIDTH: null
  SIGNSTYLE: null
  SIGNTEXT: null
  FACING: null
  HORIZCLEAR: null
  HORIZFROM: null
  VERTFROM: null
  ANGLE: null
  DISTTOTOP: null
  REFLCOAT: null
  SHEETING: null
  SUPMATERIAL: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  SIGNORIENTATION: null
  POSTTYPE: null
  COMMENTS: null
  STREETLOCATION: null
  MUTCD_ORIGINAL: null
  PROJECT: null
  PROJECTNUMBER: null
  PROJECTENGINEER: null
  PLANASBUILTDATE: null
  SIGNCONTENTLONG: null
  OriginalGlobalID: null
  Status: Post Needs Replacing
  label: null
  projecttitle: null
  aandefirm: null
  spatialconfidence: null
  UID: null
  assetname: null
  locdesc: null
  spatialsource: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Sign Obscured
Name: Sign Obscured
Domains:
• SIGNTYPE:
  Inherited
• SIGNSTYLE:
  Inherited
• FACING:
  Inherited
• SHEETING:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• SIGNORIENTATION:
  Inherited
• POSTTYPE:
  Inherited
• STREETLOCATION:
  Inherited
• Status:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
Templates:
• Name: Sign Obscured
  Description:
  Prototype:
  vertdatum: null
  flmetacode: null
  FACILITYID: null
  ATTACHID: null
  SIGNTYPE: null
  SIGNHEIGHT: null
  SIGNWIDTH: null
  SIGNSTYLE: null
  SIGNTEXT: null
  FACING: null
  HORIZCLEAR: null
  HORIZFROM: null
  VERTFROM: null
  ANGLE: null
  DISTTOTOP: null
  REFLCOAT: null
  SHEETING: null
  SUPMATERIAL: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  SIGNORIENTATION: null
  POSTTYPE: null
  COMMENTS: null
  STREETLOCATION: null
  MUTCD_ORIGINAL: null
  PROJECT: null
  PROJECTNUMBER: null
  PROJECTENGINEER: null
  PLANASBUILTDATE: null
  SIGNCONTENTLONG: null
  OriginalGlobalID: null
  Status: Sign Obscured
  label: null
  projecttitle: null
  aandefirm: null
  spatialconfidence: null
  UID: null
  assetname: null
  locdesc: null
  spatialsource: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• SignInspection (0) -- Related To: SignInspection (2)
• SignRepairs (1) -- Related To: SignRepairs (3)

Capabilities: Query

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

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata