Name: StreetLight

Display Field: LightID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 30000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

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

Fields:

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata