Name: Sign

Display Field: PositionName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 416d5b3b84cc4cdd8de4d8b0e8b70ec8

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000000

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• cgLastModified ( type: esriFieldTypeDate, alias: cgLastModified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cgLastModified )
• IsBreakaway ( type: esriFieldTypeSmallInteger, alias: IsBreakaway, editable: true, nullable: true, defaultValue: null, modelName: IsBreakaway )
• SizeHeight ( type: esriFieldTypeDouble, alias: SizeHeight, editable: true, nullable: true, defaultValue: null, modelName: SizeHeight )
• SizeHeight_unit ( type: esriFieldTypeString, alias: SizeHeight_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SizeHeight_unit )
• SizeWidth ( type: esriFieldTypeDouble, alias: SizeWidth, editable: true, nullable: true, defaultValue: null, modelName: SizeWidth )
• SizeWidth_unit ( type: esriFieldTypeString, alias: SizeWidth_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SizeWidth_unit )
• EntryDate ( type: esriFieldTypeDate, alias: EntryDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EntryDate )
• ID ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ID )
• PlacedInService ( type: esriFieldTypeDate, alias: PlacedInService, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PlacedInService )
• MUTCDCode ( type: esriFieldTypeString, alias: MUTCDCode, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MUTCDCode )
• SignText ( type: esriFieldTypeString, alias: SignText, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignText )
• CrossStreet ( type: esriFieldTypeString, alias: CrossStreet, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CrossStreet )
• Direction ( type: esriFieldTypeString, alias: Direction, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Direction )
• InFloodPlain ( type: esriFieldTypeSmallInteger, alias: InFloodPlain, editable: true, nullable: true, defaultValue: null, modelName: InFloodPlain )
• Surround ( type: esriFieldTypeSmallInteger, alias: Surround, editable: true, nullable: true, defaultValue: null, modelName: Surround )
• OffsetDirection ( type: esriFieldTypeString, alias: OffsetDirection, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OffsetDirection )
• MUTCDCompliant ( type: esriFieldTypeSmallInteger, alias: MUTCDCompliant, editable: true, nullable: true, defaultValue: null, modelName: MUTCDCompliant )
• MountingHeight ( type: esriFieldTypeDouble, alias: MountingHeight, editable: true, nullable: true, defaultValue: null, modelName: MountingHeight )
• MountingHeight_unit ( type: esriFieldTypeString, alias: MountingHeight_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MountingHeight_unit )
• SupportLength ( type: esriFieldTypeDouble, alias: SupportLength, editable: true, nullable: true, defaultValue: null, modelName: SupportLength )
• SupportLength_unit ( type: esriFieldTypeString, alias: SupportLength_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SupportLength_unit )
• HasBeacon ( type: esriFieldTypeSmallInteger, alias: HasBeacon, editable: true, nullable: true, defaultValue: null, modelName: HasBeacon )
• HasFlags ( type: esriFieldTypeSmallInteger, alias: HasFlags, editable: true, nullable: true, defaultValue: null, modelName: HasFlags )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Notes )
• Description1 ( type: esriFieldTypeString, alias: Description1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Description1 )
• BackingMaterial ( type: esriFieldTypeString, alias: BackingMaterial, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BackingMaterial )
• BaseType ( type: esriFieldTypeString, alias: BaseType, editable: true, nullable: true, length: 30, defaultValue: null, modelName: BaseType )
• Illumnination ( type: esriFieldTypeString, alias: Illumnination, editable: true, nullable: true, length: 18, defaultValue: null, modelName: Illumnination )
• Reflectorization ( type: esriFieldTypeString, alias: Reflectorization, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Reflectorization )
• SheetingMaterial ( type: esriFieldTypeString, alias: SheetingMaterial, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SheetingMaterial )
• Direction1 ( type: esriFieldTypeString, alias: Direction1, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Direction1 )
• SupportSize ( type: esriFieldTypeString, alias: SupportSize, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SupportSize )
• SupportType ( type: esriFieldTypeString, alias: SupportType, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SupportType )
• Custodian ( type: esriFieldTypeString, alias: Custodian, editable: true, nullable: true, length: 35, defaultValue: null, modelName: Custodian )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 35, defaultValue: null, modelName: Jurisdiction )
• CurrentAttachmentID ( type: esriFieldTypeString, alias: CurrentAttachmentID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CurrentAttachmentID )
• HOUSENUM ( type: esriFieldTypeDouble, alias: HOUSENUM, editable: true, nullable: true, defaultValue: null, modelName: HOUSENUM )
• DistanceAhead ( type: esriFieldTypeDouble, alias: DistanceAhead, editable: true, nullable: true, defaultValue: null, modelName: DistanceAhead )
• DistanceAhead_unit ( type: esriFieldTypeString, alias: DistanceAhead_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DistanceAhead_unit )
• DistanceBack ( type: esriFieldTypeDouble, alias: DistanceBack, editable: true, nullable: true, defaultValue: null, modelName: DistanceBack )
• DistanceBack_unit ( type: esriFieldTypeString, alias: DistanceBack_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DistanceBack_unit )
• Marker ( type: esriFieldTypeDouble, alias: Marker, editable: true, nullable: true, defaultValue: null, modelName: Marker )
• Marker_unit ( type: esriFieldTypeString, alias: Marker_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Marker_unit )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• Z ( type: esriFieldTypeDouble, alias: Z, editable: true, nullable: true, defaultValue: null, modelName: Z )
• Offset ( type: esriFieldTypeDouble, alias: Offset, editable: true, nullable: true, defaultValue: null, modelName: Offset )
• Offset_unit ( type: esriFieldTypeString, alias: Offset_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Offset_unit )
• SpeedZone ( type: esriFieldTypeDouble, alias: SpeedZone, editable: true, nullable: true, defaultValue: null, modelName: SpeedZone )
• SpeedZone_unit ( type: esriFieldTypeString, alias: SpeedZone_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SpeedZone_unit )
• SupportID ( type: esriFieldTypeString, alias: SupportID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SupportID )
• PositionName ( type: esriFieldTypeString, alias: PositionName, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PositionName )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: City )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: STREETNAME )
• StateName ( type: esriFieldTypeString, alias: StateName, editable: true, nullable: true, length: 32, defaultValue: null, modelName: StateName )
• Township ( type: esriFieldTypeString, alias: Township, editable: true, nullable: true, length: 22, defaultValue: null, modelName: Township )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 32, defaultValue: null, modelName: County )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 15, defaultValue: null, modelName: District )
• TodaysBackgroundRa ( type: esriFieldTypeDouble, alias: TodaysBackgroundRa, editable: true, nullable: true, defaultValue: null, modelName: TodaysBackgroundRa )
• TodaysLegendRa ( type: esriFieldTypeDouble, alias: TodaysLegendRa, editable: true, nullable: true, defaultValue: null, modelName: TodaysLegendRa )
• ReplaceBefore ( type: esriFieldTypeDate, alias: ReplaceBefore, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReplaceBefore )
• Origin ( type: esriFieldTypeDate, alias: Origin, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Origin )
• Replaced ( type: esriFieldTypeDate, alias: Replaced, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Replaced )
• Retired ( type: esriFieldTypeDate, alias: Retired, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Retired )
• TodaysRating ( type: esriFieldTypeString, alias: TodaysRating, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TodaysRating )
• ConditionGroup ( type: esriFieldTypeString, alias: ConditionGroup, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ConditionGroup )
• PredictionGroup ( type: esriFieldTypeString, alias: PredictionGroup, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PredictionGroup )
• CurrentInspectionID ( type: esriFieldTypeString, alias: CurrentInspectionID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CurrentInspectionID )
• RouteAhead ( type: esriFieldTypeString, alias: RouteAhead, editable: true, nullable: true, length: 40, defaultValue: null, modelName: RouteAhead )
• RouteBack ( type: esriFieldTypeString, alias: RouteBack, editable: true, nullable: true, length: 40, defaultValue: null, modelName: RouteBack )
• TravelDir ( type: esriFieldTypeString, alias: TravelDir, editable: true, nullable: true, length: 15, defaultValue: null, modelName: TravelDir )
• MaintenanceMethod ( type: esriFieldTypeString, alias: MaintenanceMethod, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintenanceMethod )
• TodaysConditionNotes ( type: esriFieldTypeString, alias: TodaysConditionNotes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TodaysConditionNotes )
• TodaysOCI ( type: esriFieldTypeDouble, alias: TodaysOCI, editable: true, nullable: true, defaultValue: null, modelName: TodaysOCI )
• CartegraphOID ( type: esriFieldTypeInteger, alias: CartegraphOID, editable: true, nullable: true, defaultValue: null, modelName: CartegraphOID )
• Temmmp ( type: esriFieldTypeString, alias: Temmmp, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Temmmp )
• MUTCDCodeDescription ( type: esriFieldTypeString, alias: MUTCDCodeDescription, editable: true, nullable: true, length: 256, defaultValue: null, modelName: MUTCDCodeDescription )
• AttachFileName ( type: esriFieldTypeString, alias: AttachFileName, editable: true, nullable: true, length: 256, defaultValue: null, modelName: AttachFileName )
• ObjectIDD ( type: esriFieldTypeString, alias: ObjectIDD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ObjectIDD )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetID )
• PoleID ( type: esriFieldTypeString, alias: PoleID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PoleID )
• Installed ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Installed )
• Warranty ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Warranty )
• Condition ( type: esriFieldTypeString, alias: Condition Rating, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Condition , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• CondDate ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CondDate )
• Location ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Location )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Owner , Coded Values: [Carmel: Carmel] , [Other Municipality: Other Municipality] , [County: County] , ...8 more... )
• MaintOwner ( type: esriFieldTypeString, alias: Maintenance Owner, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MaintOwner , Coded Values: [Carmel: Carmel] , [Other Municipality: Other Municipality] , [County: County] , ...8 more... )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source , Coded Values: [Asbuilt Drawing: Asbuilt Drawing] , [Assumed: Assumed] , [Construction Drawing: Construction Drawing] , ...3 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Active: Active Asset] , [Planned: Planned Asset] , [Abandoned: Abandoned Asset] , ...2 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Old_PoleID ( type: esriFieldTypeString, alias: Old_PoleID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Old_PoleID )
• MUTCDCode2 ( type: esriFieldTypeInteger, alias: MUTCDCode2, editable: true, nullable: true, defaultValue: 0, modelName: MUTCDCode2 )
• MUTCDCodeSbCd ( type: esriFieldTypeString, alias: MUTCDCodeSbCd, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MUTCDCodeSbCd )

Types:

ID: 0
Name: R1
Domains:
• Condition:
  Inherited
• Owner:
  Inherited
• MaintOwner:
  Inherited
• Source:
  Inherited
• Status:
  Inherited
• MUTCDCodeSbCd:
  Coded Values: [1: 1 : Stop] , [2: 2 : Yield] , [2a: 2a : To Oncoming Traffic] , ...6 more...
Templates:
• Name: R1
  Description:
  Prototype:
  MUTCDCode2: 0
  MUTCDCodeSbCd: null
  cgLastModified: null
  IsBreakaway: null
  SizeHeight: null
  SizeHeight_unit: null
  SizeWidth: null
  SizeWidth_unit: null
  EntryDate: null
  ID: null
  PlacedInService: null
  MUTCDCode: null
  SignText: null
  CrossStreet: null
  Direction: null
  InFloodPlain: null
  Surround: null
  OffsetDirection: null
  MUTCDCompliant: null
  MountingHeight: null
  MountingHeight_unit: null
  SupportLength: null
  SupportLength_unit: null
  HasBeacon: null
  HasFlags: null
  Notes: null
  Description1: null
  BackingMaterial: null
  BaseType: null
  Illumnination: null
  Reflectorization: null
  SheetingMaterial: null
  Direction1: null
  SupportSize: null
  SupportType: null
  Custodian: null
  Jurisdiction: null
  CurrentAttachmentID: null
  HOUSENUM: null
  DistanceAhead: null
  DistanceAhead_unit: null
  DistanceBack: null
  DistanceBack_unit: null
  Marker: null
  Marker_unit: null
  X: null
  Y: null
  Z: null
  Offset: null
  Offset_unit: null
  SpeedZone: null
  SpeedZone_unit: null
  SupportID: null
  PositionName: null
  City: null
  STREETNAME: null
  StateName: null
  Township: null
  County: null
  District: null
  TodaysBackgroundRa: null
  TodaysLegendRa: null
  ReplaceBefore: null
  Origin: null
  Replaced: null
  Retired: null
  TodaysRating: null
  ConditionGroup: null
  PredictionGroup: null
  CurrentInspectionID: null
  RouteAhead: null
  RouteBack: null
  TravelDir: null
  MaintenanceMethod: null
  TodaysConditionNotes: null
  TodaysOCI: null
  CartegraphOID: null
  Temmmp: null
  MUTCDCodeDescription: null
  AttachFileName: null
  ObjectIDD: null
  AssetID: null
  PoleID: null
  Installed: null
  Warranty: null
  Condition: null
  CondDate: null
  Location: null
  Owner: null
  MaintOwner: null
  Source: null
  Status: null
  Comments: null
  Old_PoleID: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 1
Name: R2
Domains:
• Condition:
  Inherited
• Owner:
  Inherited
• MaintOwner:
  Inherited
• Source:
  Inherited
• Status:
  Inherited
• MUTCDCodeSbCd:
  Coded Values: [1: 1 : Speed Limit (English)] , [2: 2 : Truck Speed Limit (English)] , [3: 3 : Night Speed Limit (English)] , ...3 more...
Templates:
• Name: R2
  Description:
  Prototype:
  MUTCDCode2: 1
  MUTCDCodeSbCd: null
  cgLastModified: null
  IsBreakaway: null
  SizeHeight: null
  SizeHeight_unit: null
  SizeWidth: null
  SizeWidth_unit: null
  EntryDate: null
  ID: null
  PlacedInService: null
  MUTCDCode: null
  SignText: null
  CrossStreet: null
  Direction: null
  InFloodPlain: null
  Surround: null
  OffsetDirection: null
  MUTCDCompliant: null
  MountingHeight: null
  MountingHeight_unit: null
  SupportLength: null
  SupportLength_unit: null
  HasBeacon: null
  HasFlags: null
  Notes: null
  Description1: null
  BackingMaterial: null
  BaseType: null
  Illumnination: null
  Reflectorization: null
  SheetingMaterial: null
  Direction1: null
  SupportSize: null
  SupportType: null
  Custodian: null
  Jurisdiction: null
  CurrentAttachmentID: null
  HOUSENUM: null
  DistanceAhead: null
  DistanceAhead_unit: null
  DistanceBack: null
  DistanceBack_unit: null
  Marker: null
  Marker_unit: null
  X: null
  Y: null
  Z: null
  Offset: null
  Offset_unit: null
  SpeedZone: null
  SpeedZone_unit: null
  SupportID: null
  PositionName: null
  City: null
  STREETNAME: null
  StateName: null
  Township: null
  County: null
  District: null
  TodaysBackgroundRa: null
  TodaysLegendRa: null
  ReplaceBefore: null
  Origin: null
  Replaced: null
  Retired: null
  TodaysRating: null
  ConditionGroup: null
  PredictionGroup: null
  CurrentInspectionID: null
  RouteAhead: null
  RouteBack: null
  TravelDir: null
  MaintenanceMethod: null
  TodaysConditionNotes: null
  TodaysOCI: null
  CartegraphOID: null
  Temmmp: null
  MUTCDCodeDescription: null
  AttachFileName: null
  ObjectIDD: null
  AssetID: null
  PoleID: null
  Installed: null
  Warranty: null
  Condition: null
  CondDate: null
  Location: null
  Owner: null
  MaintOwner: null
  Source: null
  Status: null
  Comments: null
  Old_PoleID: null
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

• Pole (0) -- Related To: Pedestrian Crossing Signal (Pole) (27)
• Pole (3) -- Related To: Traffic Signal (Pole) (5)
• Pole (6) -- Related To: Streetlight (Pole) (6)
• Pole (9) -- Related To: Sign (Pole) (7)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

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