Name: Rockford_StreetLights

Display Field: STName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2570277.96603375
YMin: 2012280.78719282
XMax: 2626957.4461785
YMax: 2067789.40550607
Spatial Reference: 102672 (3436)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,57,143,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• HouseNum (type: esriFieldTypeString, alias: House Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Private: Private], [Rockford: Rockford], [LP: Loves Park], ... 9 more ...)
• RemovalStatus (type: esriFieldTypeString, alias: Removal Status, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [A: Active], [R: Removed])
• RemovalDate (type: esriFieldTypeDate, alias: Removal Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Al: Aluminum], [Co: Concrete], [Pl: Plastic], ... 4 more ...)
• Service (type: esriFieldTypeString, alias: Service, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Over: Overhead], [Under: Underground])
• HousingType (type: esriFieldTypeString, alias: Housing Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CG: Closed Globe], [CH: Cobra Head], [C: Colonial], ... 18 more ...)
• Voltage (type: esriFieldTypeDouble, alias: Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Wattage (type: esriFieldTypeString, alias: Wattage, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LampType (type: esriFieldTypeString, alias: Lamp Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [HPS: High Pressure Sodium], [MV: Mercury Vapor], [MH: Metal Halide], ... 2 more ...)
• VerifMethod (type: esriFieldTypeString, alias: Verification Method, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Asbuilt: As-Built Drawing], [EngDrawing: Engineering Drawing], [Auto: Auto Generated], ... 7 more ...)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• VerifDate (type: esriFieldTypeString, alias: Verification Date, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PoleNumber (type: esriFieldTypeString, alias: Pole Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ControlNo (type: esriFieldTypeString, alias: Control Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• NoArms (type: esriFieldTypeSmallInteger, alias: Number Arms, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2])
• Banner (type: esriFieldTypeSmallInteger, alias: Banner, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Ward (type: esriFieldTypeSmallInteger, alias: Ward, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 11 more ...)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PoleHeight (type: esriFieldTypeString, alias: Pole Height, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• UnitID (type: esriFieldTypeString, alias: UnitID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CompType (type: esriFieldTypeSmallInteger, alias: CompType, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CompKey (type: esriFieldTypeInteger, alias: CompKey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MaintResp (type: esriFieldTypeString, alias: MaintResp, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [1YR: 1yr Maintenance], [COMED: ComEd], [COUNTY: County], ... 6 more ...)
• Breakaway (type: esriFieldTypeString, alias: Breakaway, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [N: None], [T: T-Base], [C: Coupling], ... 1 more ...)
• BreakawayCover (type: esriFieldTypeString, alias: BreakawayCover, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [AL: Aluminum], [FB: Fiberglass], [NONE: None], ... 1 more ...)
• ControlSource (type: esriFieldTypeString, alias: ControlSource, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [DIS: Disconnect], [PED: Pedestal], [TRN: Transformer], ... 3 more ...)
• Foundation (type: esriFieldTypeString, alias: Foundation, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [CON: Concrete], [DB: Direct Burial], [HEL: Helix], ... 1 more ...)
• ArmLength (type: esriFieldTypeString, alias: ArmLength, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FesToon (type: esriFieldTypeSmallInteger, alias: FesToon, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Subtype (type: esriFieldTypeString, alias: Subtype, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [SL: Street Light Pole], [BL: Bollard], [UPL: Utility Pole with Light], ... 2 more ...)
• ModifiedBy (type: esriFieldTypeString, alias: ModifiedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ModifiedDate (type: esriFieldTypeDate, alias: ModifiedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SharePointLink (type: esriFieldTypeString, alias: SharePointLink, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• RFDGRID (type: esriFieldTypeSmallInteger, alias: RFDGRID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ComEDGRID (type: esriFieldTypeSmallInteger, alias: ComEDGRID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SECTION (type: esriFieldTypeSmallInteger, alias: SECTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• NearestAddress (type: esriFieldTypeString, alias: NearestAddress, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: Rockford_StreetLights
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• StreetLightReportingTable (0) -- Related To: StreetLightReportingTable (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/1/2020 5:05:23 PM

Schema Last Edit Date: 12/1/2020 5:05:23 PM

Data Last Edit Date: 12/1/2020 5:05:23 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat