Name: lampes

Display Field: CULOT

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID_1

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CULOT (type: esriFieldTypeString, alias: Culot de la lampe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DATE_INST (type: esriFieldTypeDate, alias: Date d’installation, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FORME (type: esriFieldTypeString, alias: Forme de la lampe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Bi-section], [2: Octogonal], [3: Octoconique], ... 13 more ...)
• ID_LAM (type: esriFieldTypeDouble, alias: Identifiant interne, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ID_LANT (type: esriFieldTypeDouble, alias: Identifiant de la lanterne, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MARQUE (type: esriFieldTypeString, alias: Marque, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: ABEL], [2: ACTITUBE], [3: ARIC], ... 15 more ...)
• MODELE (type: esriFieldTypeString, alias: Modèle, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NB_AMP (type: esriFieldTypeDouble, alias: Nombre d’ampoule, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• P_LAMPE (type: esriFieldTypeDouble, alias: Puissance (W), SQL Type: sqlTypeOther, nullable: true, editable: true)
• P_CONSOM (type: esriFieldTypeDouble, alias: Puissance consommée d’une lampe (W), SQL Type: sqlTypeOther, nullable: true, editable: true)
• T_COULEUR (type: esriFieldTypeDouble, alias: Température de couleur, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TENSION (type: esriFieldTypeDouble, alias: Tension (V), SQL Type: sqlTypeOther, nullable: true, editable: true)
• VIE_LAMP (type: esriFieldTypeDouble, alias: Durée de vie d’une lampe (H), SQL Type: sqlTypeOther, nullable: true, editable: true)
• VIE_EXPLOI (type: esriFieldTypeDouble, alias: Durée de vie d’exploitation (H), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ID_FOYER (type: esriFieldTypeDouble, alias: Identifiant foyer, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AN_GARANT (type: esriFieldTypeDouble, alias: Année de garantie, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REG_FNCT (type: esriFieldTypeString, alias: Durabilité, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [1: Permanent], [2: Temporaire], [3: Non renseigné])
• ETAT (type: esriFieldTypeString, alias: Etat lumineux, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true, Coded Values: [BON: Bon état], [MOYEN: Moyen état], [VETUSTE: Ancien équipement], ... 2 more ...)
• STATUT_PAT (type: esriFieldTypeString, alias: Statut patrimoine, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true, Coded Values: [ES: En service], [HS: Hors service], [EP: En projet], ... 1 more ...)
• USAGE (type: esriFieldTypeString, alias: l'usage du point lumineux, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A: Éclairage extérieur destiné à favoriser la sécurité des déplacements, des personnes et des biens et le confort des usagers sur l'espace public ou privé], [B1: Mise en lumière du patrimoine, tel que défini à l’article L.1 du code du patrimoine], [B2: B2 Mise en lumière du cadre bâti], ... 11 more ...)
• TYPE_ECLAI (type: esriFieldTypeString, alias: Eclairage public ou privé, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NR: Non renseigné], [1: Public], [2: Privé])
• STRUCT_LUM (type: esriFieldTypeString, alias: Structure du luminaire, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [APP: Applique], [BOR: Borne], [BL: Boule lumineuse], ... 9 more ...)
• PRES_SUPP (type: esriFieldTypeString, alias: Présence du Support, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Oui], [2: Non], [3: Non renseigné], ... 1 more ...)
• FABRICANT (type: esriFieldTypeString, alias: Fabricant du point lumineux, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ID_PHOTOME (type: esriFieldTypeString, alias: Identifiant la distribution photométrique, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HAUTEUR_PL (type: esriFieldTypeDouble, alias: Hauteur par rapport le sol, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INCLIN_MAX (type: esriFieldTypeDouble, alias: Inclinaison maximale, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INCLIN_INS (type: esriFieldTypeDouble, alias: Inclinaison installée, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ID_NOCTURN (type: esriFieldTypeString, alias: Identifiant du profil nocturne, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ECLAIR_ADAPT (type: esriFieldTypeString, alias: Eclairage adaptatif , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Oui], [2: Non], [3: Non renseigné], ... 1 more ...)
• TYPE_ECLAD (type: esriFieldTypeString, alias: Type d’éclairage adaptatif, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AV: Action volontaire de l’usager (par ex. interrupteur)], [CO: Adaptation en fonction du comportement des usagers (par exemple détection de présence)], [EN: Adaptation en fonction de l’environnement (par exemple en fonction de la luminosité)], ... 2 more ...)
• CODE_CIE (type: esriFieldTypeString, alias: Code de flux CIE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ULR_NOMINAL (type: esriFieldTypeDouble, alias: Rapport ULR nominal , SQL Type: sqlTypeOther, nullable: true, editable: true)
• ULR_INSTAL (type: esriFieldTypeDouble, alias: Rapport ULR installé, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATEPOSE (type: esriFieldTypeDate, alias: Date de dépose, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LUM_TOP (type: esriFieldTypeString, alias: Luminaire en top, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Oui], [2: Non], [3: Non renseigné], ... 1 more ...)
• DATE_MAJ (type: esriFieldTypeDate, alias: Date de MAJ, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EXTINCT_NUIT (type: esriFieldTypeString, alias: Extinction nuit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Oui], [2: Non], [3: Non renseigné], ... 1 more ...)
• TYPE_INSTALL (type: esriFieldTypeString, alias: Type d'installation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: Source de la donnée, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TYPE_VOIE (type: esriFieldTypeString, alias: Type de la voie, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• NUMERO (type: esriFieldTypeString, alias: NUMERO, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GlobalID_1 (type: esriFieldTypeGlobalID, alias: GlobalID_1, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• IDSUPPORT (type: esriFieldTypeString, alias: ID Support, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• NOM_VOIE (type: esriFieldTypeString, alias: Nom de la voie, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COMMUNE (type: esriFieldTypeString, alias: Nom de commune, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Cosmopolis], [2: fluocompacte - alimentation incorporée], [3: fluocompacte - alimentation séparée], ... 29 more ...)

Templates:

Name: lampes
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Lanternes (2) -- Related To: Lanternes (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/29/2024 10:38:13 AM

Schema Last Edit Date: 6/26/2024 2:30:32 PM

Data Last Edit Date: 10/29/2024 10:38:13 AM

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