View In:   ArcGIS Online Map Viewer

Name: Street Lights

Display Field: TYPE_FIXTURES

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 83935a088d5d4083bfe4ead665f537c2

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 2505549.8231514394
YMin: 7078017.557899833
XMax: 2547243.0932062566
YMax: 7108897.050536588
Spatial Reference: 102738  (2276)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [143, 145, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Engineering_StreetLightDbase ( type: esriFieldTypeInteger, alias: Engineering_StreetLightDbase, editable: true, nullable: true, defaultValue: null, modelName: Engineering_StreetLightDbase )
• TYPE_FIXTURES ( type: esriFieldTypeString, alias: STANDARD STREET LIGHTING, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TYPE_FIXTURES , Coded Values: [CH-A: Cobra Head TYPE-A] , [CH-B: Cobra Head TYPE-B] , [CH-C: Cobra Head TYPE-C] , ...7 more... )
• NO_FIXTURES ( type: esriFieldTypeSmallInteger, alias: NUMBER OF FIXTURE, editable: true, nullable: true, defaultValue: null, modelName: NO_FIXTURES , Coded Values: [0: Retire] , [1: Single Fixture] , [2: Double Fixture] , ...2 more... )
• OWNERSHIP ( type: esriFieldTypeString, alias: STREET LIGHT OWNERSHIP, editable: true, nullable: true, length: 40, defaultValue: null, modelName: OWNERSHIP , Coded Values: [AISD: Allen Independent School District] , [COA: City of Allen] , [COSERV: Coserv] , ...19 more... )
• LAMP_TYPE ( type: esriFieldTypeString, alias: LAMP TYPE, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LAMP_TYPE , Coded Values: [MV: Mercury Vapor] , [HPS: High Pressure Sodium] , [MH: Metal Halide] , ...2 more... )
• METER ( type: esriFieldTypeString, alias: METER OR UNMETER, editable: true, nullable: true, length: 15, defaultValue: null, modelName: METER , Coded Values: [Y: Meter] , [N: No Meter] , [UNK: Unknown] )
• PROVIDER ( type: esriFieldTypeString, alias: SERVICE PROVIDER, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PROVIDER , Coded Values: [AISD: Allen Independent School District] , [COA: City of Allen] , [COSERV: Coserv] , ...8 more... )
• SUPP_STRCTRE ( type: esriFieldTypeString, alias: SUPPORT STRUCTURE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SUPP_STRCTRE , Coded Values: [AB: Anchor Base] , [BLK: Black] , [BRZ: Bronze] , ...12 more... )
• YR_INSTALLED ( type: esriFieldTypeSmallInteger, alias: YEAR LIGHT INSTALLED, editable: true, nullable: true, defaultValue: null, modelName: YR_INSTALLED , Range: [1800, 2500] )
• LAMP_SIZE ( type: esriFieldTypeSmallInteger, alias: LAMP SIZE (WATTS), editable: true, nullable: true, defaultValue: null, modelName: LAMP_SIZE , Coded Values: [100: 100] , [150: 150] , [175: 175] , ...10 more... )
• TYPICAL_APPLICATION ( type: esriFieldTypeString, alias: TYPICAL APPLICATION, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TYPICAL_APPLICATION , Coded Values: [01: RESIDENTIAL/COMMERCIAL/ROADWAY] , [02: RESIDENTIAL] , [03: COMMERCIAL/ROADWAY] , ...4 more... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 75, defaultValue: null, modelName: COMMENTS )
• OBJECTID_1 ( type: esriFieldTypeInteger, alias: OBJECTID_1, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID_1 )
• location ( type: esriFieldTypeString, alias: location, editable: true, nullable: true, length: 41, defaultValue: null, modelName: location )
• Subdivisio ( type: esriFieldTypeString, alias: Subdivisio, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Subdivisio )
• Thorough_1 ( type: esriFieldTypeString, alias: Thorough_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Thorough_1 )
• Locations ( type: esriFieldTypeInteger, alias: Locations, editable: true, nullable: true, defaultValue: null, modelName: Locations )
• Type ( type: esriFieldTypeInteger, alias: Type, editable: true, nullable: true, defaultValue: null, modelName: Type )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Contractor )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [E: Existing] , [P: Proposed/Future] , [U: Underconstruction] , ...2 more... )
• Qty ( type: esriFieldTypeSmallInteger, alias: Qty, editable: true, nullable: true, defaultValue: null, modelName: Qty )
• GRID ( type: esriFieldTypeString, alias: GRID, editable: true, nullable: true, length: 2, defaultValue: null, modelName: GRID )
• LIGHTID_1 ( type: esriFieldTypeInteger, alias: LIGHTID_1, editable: true, nullable: true, defaultValue: null, modelName: LIGHTID_1 )
• SUBGRID ( type: esriFieldTypeString, alias: SUBGRID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SUBGRID )
• AS_CODE ( type: esriFieldTypeDouble, alias: AS_CODE, editable: true, nullable: true, defaultValue: null, modelName: AS_CODE )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• CONTACTS ( type: esriFieldTypeString, alias: CONTACTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CONTACTS )
• CWID ( type: esriFieldTypeString, alias: CWID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CWID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• InspectedBy ( type: esriFieldTypeString, alias: InspectedBy , editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectedBy , Coded Values: [City of Allen: City of Allen] , [Contractor: Contractor] )
• KNockdownBy ( type: esriFieldTypeString, alias: KNockdownBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: KNockdownBy , Coded Values: [City of Allen: City of Allen] , [Contractor: Contractor] )
• RepairBy ( type: esriFieldTypeString, alias: RepairBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RepairBy , Coded Values: [City of Allen: City of Allen] , [Contractor: Contractor] )
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• RepairDate ( type: esriFieldTypeDate, alias: RepairDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RepairDate )
• ConvertedYear ( type: esriFieldTypeString, alias: Converted Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ConvertedYear )
• PhotoCell ( type: esriFieldTypeString, alias: Photo Cell, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PhotoCell , Coded Values: [Yes: Yes] , [No: No] )
• UBCell ( type: esriFieldTypeString, alias: UB Cell, editable: true, nullable: true, length: 4, defaultValue: null, modelName: UBCell , Coded Values: [Yes: Yes] , [No: No] )
• TypeofPoleBase ( type: esriFieldTypeString, alias: Type of Pole Base, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TypeofPoleBase , Coded Values: [Standard Square: Standard Square] , [Standard Tube: Standard Tube] , [Specialty: Specialty] )
• SmallCellNode ( type: esriFieldTypeString, alias: Small Cell Node, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SmallCellNode , Coded Values: [Yes: Yes] , [No: No] )

Templates:

• Name: Street Lights
  Description:
  Prototype:
  TypeofPoleBase: null
  Engineering_StreetLightDbase: null
  TYPE_FIXTURES: null
  NO_FIXTURES: null
  OWNERSHIP: null
  LAMP_TYPE: null
  METER: null
  PROVIDER: null
  SUPP_STRCTRE: null
  YR_INSTALLED: null
  LAMP_SIZE: null
  TYPICAL_APPLICATION: null
  COMMENTS: null
  OBJECTID_1: null
  location: null
  Subdivisio: null
  Thorough_1: null
  Locations: null
  Type: null
  Contractor: null
  Status: null
  Qty: null
  GRID: null
  LIGHTID_1: null
  SUBGRID: null
  AS_CODE: null
  UBCell: null
  PhotoCell: null
  ConvertedYear: null
  RepairDate: null
  CONTACTS: null
  CWID: null
  SmallCellNode: null
  InspectedBy: null
  KNockdownBy: null
  RepairBy: null
  InspectionDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

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

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