View In:   ArcGIS Online Map Viewer

Name: Signs by Status

Display Field: assetname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: ca2cd2420e654d6ca4304a34530e6807

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.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

Extent:

XMin: 1755649.8042313308
YMin: 141782.89897464216
XMax: 1773448.203017667
YMax: 182241.7586735636
Spatial Reference: 103180  (6597)  LatestVCSWkid(0)

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: false
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: true
Supports Query With LOD Spatial Reference: true
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• facilityid ( modelName: facilityid, nullable: true, editable: true, defaultValue: null, length: 20, alias: FACILITYID, type: esriFieldTypeString )
• attachid ( modelName: ATTACHID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Attachment ID, type: esriFieldTypeString )
• signtype ( modelName: SIGNTYPE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Sign Type, type: esriFieldTypeString , Coded Values: [Regulatory: Regulatory] , [Warning: Warning] , [Guide: Guide] , ...10 more... )
• signheight ( modelName: SIGNHEIGHT, nullable: true, editable: true, defaultValue: null, alias: Height (in), type: esriFieldTypeDouble )
• signwidth ( modelName: SIGNWIDTH, nullable: true, editable: true, defaultValue: null, alias: Width (in), type: esriFieldTypeDouble )
• signstyle ( modelName: SIGNSTYLE, nullable: true, editable: true, defaultValue: null, length: 130, alias: Style, type: esriFieldTypeString , Coded Values: [R1-1: Stop Sign] , [R1-2: Yield] , [R1-3W: 3 Way Stop] , ...118 more... )
• signtext ( modelName: SIGNTEXT, nullable: true, editable: true, defaultValue: null, length: 150, alias: Text, type: esriFieldTypeString )
• facing ( modelName: FACING, nullable: true, editable: true, defaultValue: null, length: 30, alias: Facing Direction, type: esriFieldTypeString , Coded Values: [East: East] , [North: North] , [South: South] , ...11 more... )
• horizclear ( modelName: HORIZCLEAR, nullable: true, editable: true, defaultValue: null, length: 12, alias: Horizontal Clearance, type: esriFieldTypeString )
• horizfrom ( modelName: HORIZFROM, nullable: true, editable: true, defaultValue: null, length: 12, alias: Horizontal From, type: esriFieldTypeString )
• vertfrom ( modelName: VERTFROM, nullable: true, editable: true, defaultValue: null, length: 12, alias: Vertical From, type: esriFieldTypeString )
• angle ( modelName: ANGLE, nullable: true, editable: true, defaultValue: null, alias: Angle (Degrees), type: esriFieldTypeSmallInteger )
• disttotop ( modelName: DISTTOTOP, nullable: true, editable: true, defaultValue: null, alias: Distance to Top of Pole, type: esriFieldTypeDouble )
• reflcoat ( modelName: REFLCOAT, nullable: true, editable: true, defaultValue: null, length: 50, alias: Reflective Coating, type: esriFieldTypeString )
• sheeting ( modelName: SHEETING, nullable: true, editable: true, defaultValue: null, length: 50, alias: Sheeting Type, type: esriFieldTypeString , 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 ( modelName: SUPMATERIAL, nullable: true, editable: true, defaultValue: null, length: 30, alias: Supplemental Materials, type: esriFieldTypeString )
• installdate ( modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• condition ( modelName: CONDITION, nullable: true, editable: true, defaultValue: null, length: 50, alias: Condition, type: esriFieldTypeString , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• ownedby ( modelName: OWNEDBY, nullable: true, editable: true, defaultValue: null, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [-1: Private] , [-2: Other] , [1: City of Wenatchee] , ...5 more... )
• maintby ( modelName: MAINTBY, nullable: true, editable: true, defaultValue: null, alias: Managed By, type: esriFieldTypeSmallInteger , Coded Values: [-1: Private] , [-2: Other] , [1: City of Wenatchee] , ...5 more... )
• lastupdate ( modelName: LASTUPDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Update Date, type: esriFieldTypeDate )
• lasteditor ( modelName: LASTEDITOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• signorientation ( modelName: SIGNORIENTATION, nullable: true, editable: true, defaultValue: null, length: 30, alias: SIGNORIENTATION, type: esriFieldTypeString , 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 ( modelName: POSTTYPE, nullable: true, editable: true, defaultValue: null, length: 50, alias: POSTTYPE, type: esriFieldTypeString , Coded Values: [Wood: Wood] , [Steel Post: Steel Post] , [Concrete: Concrete] , ...4 more... )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 100, alias: COMMENTS, type: esriFieldTypeString )
• streetlocation ( modelName: STREETLOCATION, nullable: true, editable: true, defaultValue: null, length: 50, alias: STREETLOCATION, type: esriFieldTypeString , Coded Values: [Right: Right] , [Left: Left] , [Center: Center] , ...1 more... )
• mutcd_original ( modelName: MUTCD_ORIGINAL, nullable: true, editable: true, defaultValue: null, length: 30, alias: MUTCD_ORIGINAL, type: esriFieldTypeString )
• project ( modelName: PROJECT, nullable: true, editable: true, defaultValue: null, length: 50, alias: PROJECT, type: esriFieldTypeString )
• projectnumber ( modelName: PROJECTNUMBER, nullable: true, editable: true, defaultValue: null, length: 50, alias: PROJECTNUMBER, type: esriFieldTypeString )
• projectengineer ( modelName: PROJECTENGINEER, nullable: true, editable: true, defaultValue: null, length: 50, alias: PROJECTENGINEER, type: esriFieldTypeString )
• planasbuiltdate ( modelName: PLANASBUILTDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: PLANASBUILTDATE, type: esriFieldTypeDate )
• signcontentlong ( modelName: SIGNCONTENTLONG, nullable: true, editable: true, defaultValue: null, length: 300, alias: SIGNCONTENTLONG, type: esriFieldTypeString )
• originalglobalid ( modelName: OriginalGlobalID, nullable: true, editable: true, defaultValue: null, length: 38, alias: OriginalGlobalID, type: esriFieldTypeGUID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• status ( modelName: Status, nullable: true, editable: true, defaultValue: null, length: 25, alias: Status, type: esriFieldTypeString , Coded Values: [Replaced: Replaced] , [Needs Replaced: Needs Replaced] , [Needs Repair: Needs Repair] , ...3 more... )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• uid ( modelName: uid, nullable: true, editable: true, defaultValue: null, alias: UID, type: esriFieldTypeInteger )
• assetname ( modelName: assetname, nullable: true, editable: true, defaultValue: null, length: 255, alias: Asset Name, type: esriFieldTypeString )
• locdesc ( modelName: locdesc, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location Description, type: esriFieldTypeString )
• spatialsource ( modelName: spatialsource, nullable: true, editable: true, defaultValue: null, alias: Spatial Source, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...7 more... )
• spatialconfidence ( modelName: spatialconfidence, nullable: true, editable: true, defaultValue: null, alias: Spatial Confidence, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• aandefirm ( modelName: aandefirm, nullable: true, editable: true, defaultValue: null, length: 255, alias: A and E Firm, type: esriFieldTypeString )
• projecttitle ( modelName: projecttitle, nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Title, type: esriFieldTypeString )
• label ( modelName: label, nullable: true, editable: true, defaultValue: null, length: 255, alias: Map Label, type: esriFieldTypeString )
• flmetacode ( modelName: flmetacode, nullable: true, editable: true, defaultValue: null, length: 255, alias: FLMetaCode, type: esriFieldTypeString )
• vertdatum ( modelName: vertdatum, nullable: true, editable: true, defaultValue: null, length: 255, alias: Vertical Datum, type: esriFieldTypeString )
• assetgroup ( modelName: assetgroup, nullable: true, editable: true, defaultValue: null, alias: ASSETGROUP, type: esriFieldTypeSmallInteger )
• assetype ( modelName: assetype, nullable: true, editable: true, defaultValue: null, alias: ASSETYPE, type: esriFieldTypeSmallInteger )
• inspectdate ( modelName: inspectdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Inspect Date, type: esriFieldTypeDate )

Types:

ID: Pending
Name: Pending
Domains:
• spatialsource:
  Inherited
• facing:
  Inherited
• signtype:
  Inherited
• sheeting:
  Inherited
• signstyle:
  Inherited
• condition:
  Inherited
• spatialconfidence:
  Inherited
• posttype:
  Inherited
• maintby:
  Inherited
• streetlocation:
  Inherited
• signorientation:
  Inherited
• ownedby:
  Inherited
• status:
  Inherited
Templates:
• Name: Pending
  Description:
  Prototype:
  facilityid: null
  installdate: null
  signwidth: null
  spatialsource: null
  project: null
  assetname: null
  reflcoat: null
  disttotop: null
  horizclear: null
  streetlocation: null
  aandefirm: null
  ownedby: null
  created_user: null
  mutcd_original: null
  condition: null
  inspectdate: null
  spatialconfidence: null
  lastupdate: null
  signorientation: null
  attachid: null
  status: Pending
  facing: null
  projectengineer: null
  uid: null
  vertdatum: null
  angle: null
  last_edited_date: null
  vertfrom: null
  originalglobalid: null
  projectnumber: null
  comments: null
  supmaterial: null
  planasbuiltdate: null
  signtype: null
  signheight: null
  label: null
  horizfrom: null
  lasteditor: null
  sheeting: null
  assetgroup: null
  signstyle: null
  last_edited_user: null
  signtext: null
  signcontentlong: null
  posttype: null
  flmetacode: null
  maintby: null
  created_date: null
  locdesc: null
  projecttitle: null
  assetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Replaced
Name: Replaced
Domains:
• spatialsource:
  Inherited
• facing:
  Inherited
• signtype:
  Inherited
• sheeting:
  Inherited
• signstyle:
  Inherited
• condition:
  Inherited
• spatialconfidence:
  Inherited
• posttype:
  Inherited
• maintby:
  Inherited
• streetlocation:
  Inherited
• signorientation:
  Inherited
• ownedby:
  Inherited
• status:
  Inherited
Templates:
• Name: Replaced
  Description:
  Prototype:
  facilityid: null
  installdate: null
  signwidth: null
  spatialsource: null
  project: null
  assetname: null
  reflcoat: null
  disttotop: null
  horizclear: null
  streetlocation: null
  aandefirm: null
  ownedby: null
  created_user: null
  mutcd_original: null
  condition: null
  inspectdate: null
  spatialconfidence: null
  lastupdate: null
  signorientation: null
  attachid: null
  status: Replaced
  facing: null
  projectengineer: null
  uid: null
  vertdatum: null
  angle: null
  last_edited_date: null
  vertfrom: null
  originalglobalid: null
  projectnumber: null
  comments: null
  supmaterial: null
  planasbuiltdate: null
  signtype: null
  signheight: null
  label: null
  horizfrom: null
  lasteditor: null
  sheeting: null
  assetgroup: null
  signstyle: null
  last_edited_user: null
  signtext: null
  signcontentlong: null
  posttype: null
  flmetacode: null
  maintby: null
  created_date: null
  locdesc: null
  projecttitle: null
  assetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Needs Replaced
Name: Needs Replaced
Domains:
• spatialsource:
  Inherited
• facing:
  Inherited
• signtype:
  Inherited
• sheeting:
  Inherited
• signstyle:
  Inherited
• condition:
  Inherited
• spatialconfidence:
  Inherited
• posttype:
  Inherited
• maintby:
  Inherited
• streetlocation:
  Inherited
• signorientation:
  Inherited
• ownedby:
  Inherited
• status:
  Inherited
Templates:
• Name: Needs Replaced
  Description:
  Prototype:
  facilityid: null
  installdate: null
  signwidth: null
  spatialsource: null
  project: null
  assetname: null
  reflcoat: null
  disttotop: null
  horizclear: null
  streetlocation: null
  aandefirm: null
  ownedby: null
  created_user: null
  mutcd_original: null
  condition: null
  inspectdate: null
  spatialconfidence: null
  lastupdate: null
  signorientation: null
  attachid: null
  status: Needs Replaced
  facing: null
  projectengineer: null
  uid: null
  vertdatum: null
  angle: null
  last_edited_date: null
  vertfrom: null
  originalglobalid: null
  projectnumber: null
  comments: null
  supmaterial: null
  planasbuiltdate: null
  signtype: null
  signheight: null
  label: null
  horizfrom: null
  lasteditor: null
  sheeting: null
  assetgroup: null
  signstyle: null
  last_edited_user: null
  signtext: null
  signcontentlong: null
  posttype: null
  flmetacode: null
  maintby: null
  created_date: null
  locdesc: null
  projecttitle: null
  assetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Needs Repair
Name: Needs Repair
Domains:
• spatialsource:
  Inherited
• facing:
  Inherited
• signtype:
  Inherited
• sheeting:
  Inherited
• signstyle:
  Inherited
• condition:
  Inherited
• spatialconfidence:
  Inherited
• posttype:
  Inherited
• maintby:
  Inherited
• streetlocation:
  Inherited
• signorientation:
  Inherited
• ownedby:
  Inherited
• status:
  Inherited
Templates:
• Name: Needs Repair
  Description:
  Prototype:
  facilityid: null
  installdate: null
  signwidth: null
  spatialsource: null
  project: null
  assetname: null
  reflcoat: null
  disttotop: null
  horizclear: null
  streetlocation: null
  aandefirm: null
  ownedby: null
  created_user: null
  mutcd_original: null
  condition: null
  inspectdate: null
  spatialconfidence: null
  lastupdate: null
  signorientation: null
  attachid: null
  status: Needs Repair
  facing: null
  projectengineer: null
  uid: null
  vertdatum: null
  angle: null
  last_edited_date: null
  vertfrom: null
  originalglobalid: null
  projectnumber: null
  comments: null
  supmaterial: null
  planasbuiltdate: null
  signtype: null
  signheight: null
  label: null
  horizfrom: null
  lasteditor: null
  sheeting: null
  assetgroup: null
  signstyle: null
  last_edited_user: null
  signtext: null
  signcontentlong: null
  posttype: null
  flmetacode: null
  maintby: null
  created_date: null
  locdesc: null
  projecttitle: null
  assetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Post Needs Replacing
Name: Post Needs Replacing
Domains:
• spatialsource:
  Inherited
• facing:
  Inherited
• signtype:
  Inherited
• sheeting:
  Inherited
• signstyle:
  Inherited
• condition:
  Inherited
• spatialconfidence:
  Inherited
• posttype:
  Inherited
• maintby:
  Inherited
• streetlocation:
  Inherited
• signorientation:
  Inherited
• ownedby:
  Inherited
• status:
  Inherited
Templates:
• Name: Post Needs Replacing
  Description:
  Prototype:
  facilityid: null
  installdate: null
  signwidth: null
  spatialsource: null
  project: null
  assetname: null
  reflcoat: null
  disttotop: null
  horizclear: null
  streetlocation: null
  aandefirm: null
  ownedby: null
  created_user: null
  mutcd_original: null
  condition: null
  inspectdate: null
  spatialconfidence: null
  lastupdate: null
  signorientation: null
  attachid: null
  status: Post Needs Replacing
  facing: null
  projectengineer: null
  uid: null
  vertdatum: null
  angle: null
  last_edited_date: null
  vertfrom: null
  originalglobalid: null
  projectnumber: null
  comments: null
  supmaterial: null
  planasbuiltdate: null
  signtype: null
  signheight: null
  label: null
  horizfrom: null
  lasteditor: null
  sheeting: null
  assetgroup: null
  signstyle: null
  last_edited_user: null
  signtext: null
  signcontentlong: null
  posttype: null
  flmetacode: null
  maintby: null
  created_date: null
  locdesc: null
  projecttitle: null
  assetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Sign Obscured
Name: Sign Obscured
Domains:
• spatialsource:
  Inherited
• facing:
  Inherited
• signtype:
  Inherited
• sheeting:
  Inherited
• signstyle:
  Inherited
• condition:
  Inherited
• spatialconfidence:
  Inherited
• posttype:
  Inherited
• maintby:
  Inherited
• streetlocation:
  Inherited
• signorientation:
  Inherited
• ownedby:
  Inherited
• status:
  Inherited
Templates:
• Name: Sign Obscured
  Description:
  Prototype:
  facilityid: null
  installdate: null
  signwidth: null
  spatialsource: null
  project: null
  assetname: null
  reflcoat: null
  disttotop: null
  horizclear: null
  streetlocation: null
  aandefirm: null
  ownedby: null
  created_user: null
  mutcd_original: null
  condition: null
  inspectdate: null
  spatialconfidence: null
  lastupdate: null
  signorientation: null
  attachid: null
  status: Sign Obscured
  facing: null
  projectengineer: null
  uid: null
  vertdatum: null
  angle: null
  last_edited_date: null
  vertfrom: null
  originalglobalid: null
  projectnumber: null
  comments: null
  supmaterial: null
  planasbuiltdate: null
  signtype: null
  signheight: null
  label: null
  horizfrom: null
  lasteditor: null
  sheeting: null
  assetgroup: null
  signstyle: null
  last_edited_user: null
  signtext: null
  signcontentlong: null
  posttype: null
  flmetacode: null
  maintby: null
  created_date: null
  locdesc: null
  projecttitle: null
  assetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata