Lighting candelabres table

electricite.candelabres.sql

CREATE TABLE IF NOT EXISTS electricite_new.candelabres
(
    id integer,
    id_obrv integer,
    id_sit integer,
    model character varying(50),
    number character varying(100),
    deployment_status character varying(50),
    maintenance_status character varying(50),
    construction_date timestamp without time zone,
    commissioning_date timestamp without time zone,
    voltage character varying(80),
    owner character varying(50),
    operator character varying(50),
    altitude double precision,
    access character varying(150),
    project_id integer,
    project_name character varying(100),
    project_description character varying(255),
    project_status integer,
    creation_date timestamp without time zone,
    modification_date timestamp without time zone,
    status text,
    saga_link character varying(200),
    source_type character varying(200),
    luminaire_type character varying(200),
    luminaire_installation_year character varying(20),
    pole_owner character varying(200),
    pole_installation_year character varying(20),
    number_of_sources character varying(20),
    luminous_point_height character varying(20),
    color_temperature character varying(20),
    theoretical_power_per_source character varying(20),
    dimming_type text,
    flux_percentage_after_dimming text,
    municipality character varying(200),
    code character varying(20),
    root_guid text,
    property_type character varying(50),
    esti_number character varying(50),
    observation character varying(200),
    supplier character varying(50),
    location character varying(150),
    inspection_remark character varying(100),
    inspection_date timestamp without time zone,
    tooltip character varying(200),
    decommissioning_date timestamp without time zone,
    construction_type character varying(100),
    annexes text,
    last_mechanical_inspection_year character varying(20),
    mechanical_inspection_planning character varying(40),
    the_geom geometry(Point,2056)
);

wow thank you for your sql. i will use it to check that every attribut you have will be part of my ili model :)

Feel free to ask if you find namings that don't feel very explicit or would require some comments.