Public lighting

Description

Public lighting data containing EP Lighting Points and Illuminated Urban Furniture (MU)

Data extracted from the CMMS tool database

Coordinate system of this dataset: RGF93 Lambert 93, WKID 2154

Original coordinate system: NTF Lambert Nord France, WKID 27561

Field name Data type Alias
COD_OUVRAG VARCHAR(254) Work ID
FOYER VARCHAR(254) Unique lamp identifier
LIB_DOMAIN VARCHAR(254) Domain Name
LIB_OUVRAG VARCHAR(254) Category of the work
OBSERVATIO VARCHAR(254) Observation
POSX_OUVRA DOUBLE Map coordinates X of the work
POSY_OUVRA DOUBLE Map coordinates Y of the work
LIB_REGIME VARCHAR(254) Regime Wording
VOIEVENT_V VARCHAR(254) Whole Way Identifier
FACEOP_OUV VARCHAR(254) Address: Face / Opposite
NUMVOIE_OU VARCHAR(254) Address: Num in the lane
BISTER_OUV VARCHAR(254) Address: Bis/Ter
NATURE_VOI VARCHAR(254) Nature of the Way
LIB_VOIE VARCHAR(254) Track Name
LIB_VOIEDO VARCHAR(254) Lane domain label
LIB_SECTEU VARCHAR(254) Sector Label
LIB_REGION VARCHAR(254) Technical Region Label
LIB_REGI_1 VARCHAR(254) Borough Wording
COD_SUPPOR VARCHAR(254) Support ID
LIB_SUPPOR VARCHAR(254) Support Label
HEIGHT_SU DOUBLE Stand height (in meters)
DUREEVIE_S DOUBLE Support life
UNITEVIE_S VARCHAR(254) Lifetime Unit
MATERIAU_S VARCHAR(254) Support Material
TYPE_SUPPO VARCHAR(254) Media Type
LIB_SUPP_1 VARCHAR(254) Support Label
LIB_FOURNI VARCHAR(254) Support Provider Identifier
COD_CONSOL DOUBLE Console ID
LIB_CONSOL VARCHAR(254) Console Technical Label
DUREEVIE_C DOUBLE Console Life
UNITEVIE_C VARCHAR(254) Console Life Unit
LIB_CONS_1 VARCHAR(254) Console label
LIB_FOUR_1 VARCHAR(254) Console Provider
COD_LUMINA VARCHAR(254) Luminaire ID
LIB_LUMINA VARCHAR(254) Luminaire label
IS_OUVERT_ DOUBLE Luminaire O/N
MODELE_LUM VARCHAR(254) Lamp model
DUREEVIE_L DOUBLE Luminaire life
UNITEVIE_L VARCHAR(254) Luminaire lifetime unit
MATERIAU_L VARCHAR(254) Lighting material
CLASSEIP_L VARCHAR(254) IP class of luminaire
CLASS_LUM VARCHAR(254) Class of luminaire
LIB_LUMI_1 VARCHAR(254) Luminaire family label
LIB_FOUR_2 VARCHAR(254) Lighting supplier
XLUMELEC DOUBLE Presence of electronic switchgear
COD_LAMPE VARCHAR(254) Lamp ID
LIB_LAMPE VARCHAR(254) Lamp Label
PW_LAMPE DOUBLE Rated lamp power (W)
PWC_LAMPE DOUBLE Power consumption of the lamp with app ferro (W)
PWE_LAMPE DOUBLE Power consumption of the lamp with electronic app(W)
FORM_LAMP VARCHAR(254) Lamp Shape
TYPE_LAMP VARCHAR(254) Lamp type
MODEL_LAM VARCHAR(254) Lamp model
DUREEVIE_1 DOUBLE Lamp life
UNITEVIE_1 VARCHAR(254) Unit of time for lamp lifetime
FLUX_LAMPE DOUBLE Lamp flow (in Lumen)
CLASS_LAM VARCHAR(254) Lamp class
VOLT_LAMPE DOUBLE Voltage (V)
TEMPCOULEU DOUBLE Lamp temperature (in Kelvin)
LIB_LAMPEF VARCHAR(254) Family Wording
LIB_FOUR_3 VARCHAR(254) Lamp Supplier
GRADATION DOUBLE Gradation as % of max power (non-linear formula)
ULOR DOUBLE Upward Light Output Ratio
DLOR DOUBLE Downward Light Output Ratio
RTOT DOUBLE Total Ratio

Resources

Name Format Description Link
eclairage-public.geojson JSON Open resource
eclairage-public.zip ZIP Open resource
Export in Shapefile format ESRI Shape Open resource
eclairage-public.json JSON Open resource
eclairage-public.csv CSV Open resource

Tags

Topics

Categories