View In:   ArcGIS Online Map Viewer

Name: Signs

Display Field: signtext

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0f2e6b32f2a84d3a855578c48d8a7db6

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 4141526.8871391118
YMin: 282600.91568242013
XMax: 4183627.7339238822
YMax: 332827.2001312375
Spatial Reference: 2270  (2270)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveCenter
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: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 9
Font Family: Corbel
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 1800.0
Max. Scale: 0.0

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:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: System-maintained ObjectID, alias: OBJECTID )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Facility Identifier, 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] , ...3 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: [R2-1-25: 25 MPH] , [R2-1-35: 35 MPH] , [R1-2: Yield] , ...117 more... )
• signtext ( modelName: SIGNTEXT, nullable: true, editable: true, defaultValue: null, length: 100, 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] , ...9 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: Good, length: 50, alias: Condition, type: esriFieldTypeString , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...5 more... )
• ownedby ( modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [-1: Private] , [-2: Other] , [1: City of Grants Pass] , ...5 more... )
• maintby ( modelName: MAINTBY, nullable: true, editable: true, defaultValue: 1, alias: Managed By, type: esriFieldTypeSmallInteger , Coded Values: [-1: Private] , [-2: Other] , [2: Jospehine County] , ...34 more... )
• next_inspection ( modelName: NEXT_INSPECTION, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: NEXT_INSPECTION, type: esriFieldTypeDate )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• signaction ( modelName: SIGNACTION, nullable: true, editable: true, defaultValue: Replace, length: 30, alias: Sign Action, type: esriFieldTypeString , Coded Values: [Replace: Replace] , [Wash: Wash] , [Clear: Clear] , ...2 more... )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• uniqueid_2019 ( modelName: UniqueID_2019, nullable: true, editable: true, defaultValue: null, alias: UniqueID_2019, type: esriFieldTypeInteger )
• signwordage ( modelName: SignWordage, nullable: true, editable: true, defaultValue: null, length: 100, alias: SignWordage, type: esriFieldTypeString )
• signsubtype ( modelName: SignSubType, nullable: true, editable: true, defaultValue: null, length: 75, alias: SignSubType, type: esriFieldTypeString )
• historicid ( modelName: HistoricID, nullable: true, editable: true, defaultValue: null, length: 50, alias: HistoricID, type: esriFieldTypeString )
• inspectiondate ( modelName: INSPECTIONDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Inspection Date, type: esriFieldTypeDate )
• signfacecond ( modelName: SIGNFACECOND, nullable: true, editable: true, defaultValue: null, length: 30, alias: Sign Face Condition, type: esriFieldTypeString , Coded Values: [Good: Good] , [Fair: Fair] , [Critical: Critical] )
• assesstype ( modelName: ASSESSTYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Assess Type, type: esriFieldTypeString , Coded Values: [Day: Day] , [Night: Night] )
• ratingreason ( modelName: RATINGREASON, nullable: true, editable: true, defaultValue: null, length: 50, alias: Rating Reason, type: esriFieldTypeString , Coded Values: [Restripe: Restripe] , [Replant: Replant] , [Replace: Replace] , ...3 more... )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Notes, type: esriFieldTypeString )

Templates:

• Name: Signs
  Description:
  Prototype:
  facilityid: null
  installdate: null
  notes: null
  signwidth: null
  assesstype: null
  facing: null
  signsubtype: null
  signfacecond: null
  inspectiondate: null
  reflcoat: null
  signwordage: null
  disttotop: null
  angle: null
  horizclear: null
  ownedby: 1
  vertfrom: null
  ratingreason: null
  supmaterial: null
  uniqueid_2019: null
  signtype: null
  signheight: null
  horizfrom: null
  sheeting: null
  signstyle: null
  condition: Good
  signtext: null
  signaction: Replace
  historicid: null
  maintby: 1
  next_inspection: null
  attachid: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

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

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

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   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata