Name: StreetLight

Display Field: LightID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 30000

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• LightID ( type: esriFieldTypeInteger, alias: Light ID, editable: true, nullable: true, defaultValue: null, modelName: LightID )
• StructureID ( type: esriFieldTypeInteger, alias: Structure ID, editable: true, nullable: true, defaultValue: null, modelName: StructureID )
• ValidFromDate ( type: esriFieldTypeDate, alias: Valid From Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ValidFromDate )
• ValidToDate ( type: esriFieldTypeDate, alias: Valid To Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ValidToDate )
• LightNumPrefix ( type: esriFieldTypeString, alias: Light Number Prefix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LightNumPrefix )
• LightNum ( type: esriFieldTypeSmallInteger, alias: Light Number, editable: true, nullable: true, defaultValue: null, modelName: LightNum )
• LightNumSuffix ( type: esriFieldTypeString, alias: Light Number Suffix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LightNumSuffix )
• LightNumSuffix2 ( type: esriFieldTypeString, alias: Light Number Suffix 2, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LightNumSuffix2 )
• StreetLightFaces ( type: esriFieldTypeString, alias: Street Light Faces, editable: true, nullable: true, length: 40, defaultValue: null, modelName: StreetLightFaces , Coded Values: [6th Street: 6th Street] , [A Place: A Place] , [Aab Street: Aab Street] , ...1794 more... )
• FixtureType ( type: esriFieldTypeString, alias: Fixture Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FixtureType , Coded Values: [Z: Gardco Mataray] , [XuP: Expressway Underpass] , [XCGW: Sterner - Clinton Gateway] , ...34 more... )
• FixtureManufacturer ( type: esriFieldTypeString, alias: Fixture Manufacturer, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FixtureManufacturer , Coded Values: )
• FixturePartNumber ( type: esriFieldTypeString, alias: Fixture Part Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FixturePartNumber )
• LampType ( type: esriFieldTypeString, alias: Lamp Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LampType , Coded Values: [F: Fluorescent] , [H: High Press Sodium] , [I: Incandescent] , ...4 more... )
• Watts ( type: esriFieldTypeSmallInteger, alias: Watts (nominal rate), editable: true, nullable: true, defaultValue: null, modelName: Watts )
• Burn24Hr ( type: esriFieldTypeString, alias: Burn 24 Hr, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Burn24Hr , Coded Values: [1: Yes] , [0: No] )
• FuseLocation ( type: esriFieldTypeString, alias: Fuse Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FuseLocation )
• PowerPointID ( type: esriFieldTypeString, alias: Power Point ID (RG&E), editable: true, nullable: true, length: 25, defaultValue: null, modelName: PowerPointID )
• JunctionLocation ( type: esriFieldTypeString, alias: Junction Location, editable: true, nullable: true, length: 40, defaultValue: null, modelName: JunctionLocation )
• JunctionComments ( type: esriFieldTypeString, alias: Junction Comments, editable: true, nullable: true, length: 50, defaultValue: null, modelName: JunctionComments )
• ArmAttachHeight ( type: esriFieldTypeDouble, alias: Arm Attachment Height, editable: true, nullable: true, defaultValue: null, modelName: ArmAttachHeight )
• ArmLength ( type: esriFieldTypeDouble, alias: Length of Arm (ft), editable: true, nullable: true, defaultValue: null, modelName: ArmLength )
• ArmRise ( type: esriFieldTypeDouble, alias: Rise of Arm, editable: true, nullable: true, defaultValue: null, modelName: ArmRise )
• ArmDirection ( type: esriFieldTypeSmallInteger, alias: Arm Direction (Degrees), editable: true, nullable: true, defaultValue: null, modelName: ArmDirection )
• ArmManufacturer ( type: esriFieldTypeString, alias: Arm Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ArmManufacturer )
• ArmModelNumber ( type: esriFieldTypeString, alias: Arm Model Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ArmModelNumber )
• Purchased ( type: esriFieldTypeString, alias: RGE Purchase, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Purchased , Coded Values: [1: Yes] , [0: No] )
• DateInstalled ( type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled )
• DateEnergized ( type: esriFieldTypeDate, alias: Date Energized, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateEnergized )
• LastServiced ( type: esriFieldTypeDate, alias: Last Serviced, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastServiced )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Condition , Coded Values: [Good: Good] , [Fair: Fair] , [Unknown: Unknown] , ...2 more... )
• OwnedBy ( type: esriFieldTypeString, alias: Owned By, editable: true, nullable: true, length: 25, defaultValue: null, modelName: OwnedBy , Coded Values: [City of Rochester: City of Rochester] , [Frontier: Frontier] , [Monroe County: Monroe County] , ...1 more... )
• MaintBy ( type: esriFieldTypeString, alias: Managed By, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MaintBy , Coded Values: [City of Rochester: City of Rochester] , [Frontier: Frontier] , [Monroe County: Monroe County] , ...1 more... )
• SourceFile ( type: esriFieldTypeString, alias: Source File, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SourceFile )
• SourceLink ( type: esriFieldTypeString, alias: Source Link, editable: true, nullable: true, length: 250, defaultValue: null, modelName: SourceLink )
• X ( type: esriFieldTypeDouble, alias: X (Long), editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y (Lat), editable: true, nullable: true, defaultValue: null, modelName: Y )
• AccountID ( type: esriFieldTypeSmallInteger, alias: Account ID, editable: true, nullable: true, defaultValue: null, modelName: AccountID )
• MercConvert ( type: esriFieldTypeString, alias: MercConvert, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MercConvert , Coded Values: [1: Yes] , [0: No] )
• SizeMerc ( type: esriFieldTypeSmallInteger, alias: SizeMerc, editable: true, nullable: true, defaultValue: null, modelName: SizeMerc )
• Metered ( type: esriFieldTypeString, alias: Metered, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Metered , Coded Values: [1: Yes] , [0: No] )
• SLIT ( type: esriFieldTypeString, alias: SLIT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLIT )
• Contract2Size ( type: esriFieldTypeInteger, alias: Contract2Size - COR Field Disregard, editable: true, nullable: true, defaultValue: null, modelName: Contract2Size )
• Contract2Size2 ( type: esriFieldTypeInteger, alias: Contract2Size2 - COR Field Disregard , editable: true, nullable: true, defaultValue: null, modelName: Contract2Size2 )
• Opp ( type: esriFieldTypeString, alias: Location of the Pole - Lists that it is opposite a specific house number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Opp )
• CIR ( type: esriFieldTypeDouble, alias: CIR - COR Field Disregard, editable: true, nullable: true, defaultValue: null, modelName: CIR )
• PFWL ( type: esriFieldTypeString, alias: Pole, Fixture, Wattage, Lamp, Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PFWL )
• AttachCode ( type: esriFieldTypeString, alias: Wood Pole Attach Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AttachCode )
• SIDE2 ( type: esriFieldTypeString, alias: Location of Pullbox/Handhole - Lists the side of the street, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SIDE2 )
• OS1 ( type: esriFieldTypeString, alias: Location of Pullbox/Handhole - Lists the offset from the street , editable: true, nullable: true, length: 255, defaultValue: null, modelName: OS1 )
• DistSkewed ( type: esriFieldTypeString, alias: Location of Pullbox/Handhole - Lists the distance ina specific direction (direction2), editable: true, nullable: true, length: 255, defaultValue: null, modelName: DistSkewed )
• DIRECTION2 ( type: esriFieldTypeString, alias: Light Direction, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DIRECTION2 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• S_PC ( type: esriFieldTypeInteger, alias: Smart Photocell, editable: true, nullable: true, defaultValue: null, modelName: S_PC )
• Notes__for_changes_ ( type: esriFieldTypeString, alias: Notes (for changes), editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes__for_changes_ )
• Add__Notes ( type: esriFieldTypeString, alias: Add. Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Add__Notes )
• Retrofit ( type: esriFieldTypeString, alias: Retrofit, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Retrofit )
• MED_Base ( type: esriFieldTypeInteger, alias: MED Base, editable: true, nullable: true, defaultValue: null, modelName: MED_Base )
• LNUMBER_OR ( type: esriFieldTypeString, alias: Light Number Original, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LNUMBER_OR )
• Action ( type: esriFieldTypeString, alias: Action, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Action , Coded Values: [Added: Added] , [Appended: Appended] , [Exists: Exists] , ...9 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes , Coded Values: [Added from COR Excel: Added from COR Excel] , [Added from OTM Survey: Added from OTM Survey] , [CAD - RG&E Wood Distribution Pole: CAD - RG&E Wood Distribution Pole] , ...16 more... )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Source , Coded Values: [CAD: CAD] , [CAD and City Touch: CAD and City Touch] , [CAD and OTM: CAD and OTM] , ...9 more... )
• AdditionalSourceInformation ( type: esriFieldTypeString, alias: Additional Source Information, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AdditionalSourceInformation )
• OTMFeatureCode ( type: esriFieldTypeString, alias: OTM Feature Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTMFeatureCode )
• OTMFeatureDescription ( type: esriFieldTypeString, alias: OTM Feature Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTMFeatureDescription )
• Comments1 ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments1 )

Templates:

• Name: StreetLight
  Description:
  Prototype:
  OTMFeatureDescription: null
  Comments1: null
  LightID: null
  StructureID: null
  ValidFromDate: null
  ValidToDate: null
  LightNumPrefix: null
  LightNum: null
  LightNumSuffix: null
  LightNumSuffix2: null
  StreetLightFaces: null
  FixtureType: null
  FixtureManufacturer: null
  FixturePartNumber: null
  LampType: null
  Watts: null
  Burn24Hr: null
  FuseLocation: null
  PowerPointID: null
  JunctionLocation: null
  JunctionComments: null
  ArmAttachHeight: null
  ArmLength: null
  ArmRise: null
  ArmDirection: null
  ArmManufacturer: null
  ArmModelNumber: null
  Purchased: null
  DateInstalled: null
  DateEnergized: null
  LastServiced: null
  Condition: null
  OwnedBy: null
  MaintBy: null
  SourceFile: null
  SourceLink: null
  X: null
  Y: null
  AccountID: null
  MercConvert: null
  SizeMerc: null
  Metered: null
  SLIT: null
  Contract2Size: null
  Contract2Size2: null
  Opp: null
  CIR: null
  PFWL: null
  AttachCode: null
  SIDE2: null
  OS1: null
  DistSkewed: null
  DIRECTION2: null
  COMMENTS: null
  S_PC: null
  Notes__for_changes_: null
  Add__Notes: null
  Retrofit: null
  MED_Base: null
  LNUMBER_OR: null
  Action: null
  Notes: null
  Source: null
  AdditionalSourceInformation: null
  OTMFeatureCode: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Structure (0) -- Related To: Structure (0)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

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

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