Name: ProdGeoDB.STREETLIGHTS.StreetLighting_Lamps

Display Field: ModelName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GIS_ID ( type: esriFieldTypeInteger, alias: Streetlight GIS ID )
• GIS_FeatureKey ( type: esriFieldTypeString, alias: Unique Lamp ID, length: 20 )
• LampStyle ( type: esriFieldTypeString, alias: Lamp Style, length: 5 , Coded Values: [GAS: Gas] , [LED: Light Emitting Diode (LED)] , [HPS: High Pressure Sodium (HPS)] , ...5 more... )
• FixtureStyle ( type: esriFieldTypeString, alias: Fixture Style, length: 5 , Coded Values: [BL: Box Light] , [CL: Coach Lantern] , [COB: Cobra] , ...14 more... )
• ControlType ( type: esriFieldTypeString, alias: Control Type, length: 5 , Coded Values: [Photo: Photo Electric] , [Relay: Relay] , [NA: N/A] , ...1 more... )
• MountType ( type: esriFieldTypeString, alias: Mount Type, length: 8 , Coded Values: [Arm: Arm] , [Other: Other] , [Post Top: Post Top] , ...2 more... )
• MountHeight ( type: esriFieldTypeString, alias: Mount Height, length: 5 , Coded Values: [9: 2.7 m (9 ft)] , [9.5: 2.9 m (9.5 ft)] , [10: 3.0 m (10 ft)] , ...72 more... )
• ModelName ( type: esriFieldTypeString, alias: Model Name, length: 50 , Coded Values: [Autobahn ATB0 Autobahn ATB0 Autobahn ATB0: Autobahn ATB0] , [Autobahn ATB1: Autobahn ATB1] , [Autobahn ATB2: Autobahn ATB2] , ...16 more... )
• ModelNumber ( type: esriFieldTypeString, alias: Model Number, length: 50 , Coded Values: )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• DistributionType ( type: esriFieldTypeString, alias: Distribution Type, length: 50 , Coded Values: )
• CatalogNumber ( type: esriFieldTypeString, alias: Catalog Number, length: 50 , Coded Values: )
• Voltage ( type: esriFieldTypeInteger, alias: Voltage , Coded Values: [120: 120 volts] , [240: 240 volts] , [0: Unknown] )
• Wattage ( type: esriFieldTypeString, alias: Wattage, length: 5 , Coded Values: [100: 100 watts] , [101: 101 watts] , [103: 103 Watts] , ...102 more... )
• Comment ( type: esriFieldTypeString, alias: Comment, length: 1073741822 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 , Coded Values: [American Electric Lighting: American Electric Lighting] , [Cooper Lighting: Cooper Lighting] , [Cree: Cree] , ...8 more... )
• CorrelatedColourTemperature ( type: esriFieldTypeSmallInteger, alias: CorrelatedColourTemperature , Coded Values: [3000: 3000 K] )
• LampBase ( type: esriFieldTypeString, alias: Lamp Base, length: 255 , Coded Values: [Mogul: Mogul] , [Medium: Medium] , [Long: Long] )

Relationships:

• StreetLight Features (1) -- Related To: Street Lighting - Streetlight Features (5)

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

  Iteminfo   Thumbnail   Metadata