Street Light Inventory A Miami-Dade County

About This Dataset

This dataset maps the exact location and condition of every street light in Miami-Dade County, including details like bulb type, pole height, and maintenance zones. It's a shared resource between Miami-Dade County and Florida Power & Light, helping the county manage lighting infrastructure, respond to outage reports, and plan maintenance work to keep neighborhoods safe and well-lit.

Why This Matters

Key Metadata

Columns / Fields

Name Type Description
OBJECTID integer StreetLightInventory: OBJECTID
EAMSCLASS text The asset classification code used in the city's equipment and asset management system (EAMS) to categorize this street light. AI
ASSETSEQNO text A unique sequence number assigned to identify and track this specific street light asset in the city's inventory system. AI
GISOBJID integer A unique identifier assigned by the Geographic Information System (GIS) to track the precise location and properties of this street light. AI
BULBTYPE text The type of light bulb used in the street light, such as LED, metal halide, or sodium vapor. AI
CONDITION text The current condition status of the street light, typically indicating whether it is working, broken, or needs maintenance. AI
POLENUM text The unique identification number assigned to the utility pole that supports this street light. AI
POLETYPE text The type or material of the pole supporting this street light, such as wood, concrete, or metal. AI
ARTNAME text The name of the arterial road or major street where this street light is located. AI
CIRCNUM integer The circuit number that this street light is connected to, used to identify which electrical circuit supplies power to this light. AI
POLHEIGHT integer The height of the pole supporting this street light, measured in feet. AI
VOLTAGE integer The electrical voltage (measured in volts) supplied to the street light, indicating the power level required to operate the fixture. AI
FPLRATE integer The rate code or rate schedule used by Florida Power & Light for charging the electrical usage of this street light. AI
MAINTRATE integer The maintenance cost rate or schedule assigned to this street light for budgeting and upkeep purposes. AI
SERVPOINT text The service point identifier that connects this street light to the electrical distribution system for power delivery. AI
CIRCTYPE text The type of electrical circuit that powers this street light, such as single-phase or three-phase. AI
OWNED text Indicates who owns or is responsible for this street light, such as the City of Miami-Dade or another entity like FPL. AI
MAINTZONE text The designated maintenance zone or district that is responsible for servicing and repairing this street light. AI
WATTS integer The power consumption of the street light measured in watts, showing how much electrical energy the light bulb uses when operating. AI
TBASE text Specifies the type of base or mounting connection used on the street light fixture, determining how the light is attached to the pole or support structure. AI
SKIRT text Indicates whether the street light has a skirt (a protective shroud or covering around the pole base), typically marked as Y/N or Yes/No. AI
AERIALCNDTR text Indicates whether the street light has an aerial conductor (overhead wire) attached to it, typically marked as Y/N or Yes/No. AI
PULLBOXLID text Indicates whether a pull box lid (electrical access cover) is present at or near this street light, typically marked as Y/N. AI
SRGARRSTR text Indicates whether the street light has a surge arrestor installed, which is a device that protects the light fixture from electrical damage due to power surges or lightning strikes. AI
FPLACCTNUM integer The Florida Power & Light (FPL) account number associated with the billing or service for this street light. AI
METERNUM integer The meter number that tracks and records the electrical consumption of this street light for billing purposes. AI
PERMID integer The permit identification number associated with the installation or modification of this street light. AI
POINT_Y number The Y coordinate (north-south position) in a projected map coordinate system used to precisely locate this street light. AI
POINT_X number The X coordinate (east-west position) in a projected map coordinate system used to precisely locate this street light. AI
LAT number The latitude coordinate (north-south position) of this street light in decimal degrees, used for mapping and location purposes. AI
LON number The longitude coordinate (east-west position) of this street light in decimal degrees, used for mapping and location purposes. AI
CREATEBY text The name or identifier of the person who originally created this record in the inventory system. AI
CREATEDATE date The date when this street light record was first added to the inventory system. AI
MODIFYBY text The name or identifier of the person who most recently made changes or updates to this street light record. AI
MODIFYDATE date The date when this street light record was last modified or updated in the inventory system. AI
GlobalID text StreetLightInventory: GlobalID

Related Datasets

Quality Breakdown

A Composite Score: 96%
100%
86%
100%

Findings

  • Row count not available