Utility Maintained Street Lights: Madison, Wisconsin
Description:
Data for utility maintained street lights was originally stored in tabular form. Retired records are moved to table SubFormLights. Field descriptions/definitions for utility maintained street light data as follows: ObjectID: GIS auto-generated unique identifier Addr: address of street lighttaken from original data table Street1: street on which street light was installed Street2: cross-street of street light location Notes: pertinent street light notes Rotation: spatial rotation Removal_Date: removal date Pole_Type: pole material description Mounting_Height: mounting height of luminaire Pole_number: utility provided pole number LightsID_PK: primary key for the relationship classes. SubFrmLights foreign key is Lights_IDFK Install_Ordered_Date: date the installation was ordered Lamp: lamp type Watt2: wattage PEC: Photoelectric Cell (Yes/No) Pole_Gauge: metal pole gauge Base_Type: pole base type Shape: GIS geometry type Created_User: GIS user to first enter luminaire into feature class Date_created: creation date in GIS feature class Last_Edited_User: last GIS user to update luminaire data Date_Last_Edited: date of last edit to feature