Name: Signs

Display Field: SignCode

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 0058c9f3f8664cc2b654fe91486bb954

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• SignId ( type: esriFieldTypeInteger, alias: SignId, editable: true, nullable: true, defaultValue: null, modelName: SignId )
• SignCode ( type: esriFieldTypeString, alias: SignCode, editable: true, nullable: false, length: 9, defaultValue: null, modelName: SignCode , Coded Values: [AD-7: AD-7: LITTER CREW AHEAD - HINGED] , [ADO-1: ADO-1: ADOPT-A-HIGHWAY CLUB SIGN] , [ADO-2: ADO-2: ADOPT-A-HIGHWAY LITTER CONTROL COURTESY OF] , ...632 more... )
• LegendText ( type: esriFieldTypeString, alias: LegendText, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LegendText )
• SignWidth ( type: esriFieldTypeDouble, alias: SignWidth, editable: true, nullable: true, defaultValue: null, modelName: SignWidth , Range: [1, 800] )
• SignHeight ( type: esriFieldTypeDouble, alias: SignHeight, editable: true, nullable: true, defaultValue: null, modelName: SignHeight , Range: [1, 500] )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• RemarkText ( type: esriFieldTypeString, alias: RemarkText, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RemarkText )
• SheetingTypeDesc ( type: esriFieldTypeString, alias: SheetingTypeDesc, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SheetingTypeDesc , Coded Values: [Cubic Prismatic: Cubic Prismatic] , [Engineering Grade: Engineering Grade] , [High Intensity: High Intensity] , ...2 more... )
• SubstrateDesc ( type: esriFieldTypeString, alias: SubstrateDesc, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SubstrateDesc , Coded Values: [Extruded Aluminum: Extruded Aluminum] , [Flat Aluminum: Flat Aluminum] , [Plaque: Plaque] )
• SignCondDesc ( type: esriFieldTypeString, alias: SignCondDesc, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SignCondDesc , Coded Values: [Satisfactory: Satisfactory] , [Needs Replaced: Needs Replaced] )
• DirSignFacesDesc ( type: esriFieldTypeString, alias: DirSignFacesDesc, editable: true, nullable: true, length: 25, defaultValue: null, modelName: DirSignFacesDesc , Coded Values: [North: North] , [South: South] , [East: East] , ...5 more... )
• UserTypeDesc ( type: esriFieldTypeString, alias: UserTypeDesc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UserTypeDesc , Coded Values: [Bicyclist: Bicyclist] , [Other: Other] , [Pedestrian: Pedestrian] , ...1 more... )
• SignColorDesc ( type: esriFieldTypeString, alias: SignColorDesc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignColorDesc , Coded Values: [Blk/Blu/R/W: Black/Blue/Red/White] , [Blk/Blu/R/Y: Black/Blue/Red/Yellow] , [Blk/Blu/Y/W: Black/Blue/Yellow/White] , ...45 more... )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• CreateUser ( type: esriFieldTypeString, alias: CreateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateUser )
• UpdateDate ( type: esriFieldTypeDate, alias: UpdateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: UpdateDate )
• UpdateUser ( type: esriFieldTypeString, alias: UpdateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: UpdateUser )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• AssemblyGlobalID ( type: esriFieldTypeGUID, alias: AssemblyGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: AssemblyGlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• RetroreflectivityMeasurement ( type: esriFieldTypeInteger, alias: RetroreflectivityMeasurement, editable: true, nullable: true, defaultValue: null, modelName: RetroreflectivityMeasurement )
• MeasurementDate ( type: esriFieldTypeDate, alias: MeasurementDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MeasurementDate )
• ModifiedSignReplDate ( type: esriFieldTypeDate, alias: ModifiedSignReplDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ModifiedSignReplDate )

Templates:

• Name: Signs
  Description:
  Prototype:
  MeasurementDate: null
  SignId: null
  SignCode:
  LegendText: null
  SignWidth: null
  SignHeight: null
  InstallDate: null
  RemarkText: null
  SheetingTypeDesc: null
  SubstrateDesc: null
  SignCondDesc: null
  DirSignFacesDesc: null
  UserTypeDesc: null
  SignColorDesc: null
  RetroreflectivityMeasurement: null
  AssemblyGlobalID: null
  ModifiedSignReplDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SignBelongsToSignAssembly (0) -- Related To: Sign Assemblies (0)

Capabilities: Query,Sync,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: CreateDate
• Creator Field: CreateUser
• Edit Date Field: UpdateDate
• Editor Field: UpdateUser

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

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