Name: gpso.aop.GPSEO_EP_EP_LUMINAIRE

Display Field: nom_voie

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 8696d33e36fc40939cdec175a556db13

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• num_candelabre ( type: esriFieldTypeString, alias: N° de candélabre , editable: true, nullable: true, length: 255, defaultValue: null, modelName: num_candelabre )
• type_materiel ( type: esriFieldTypeString, alias: Type de matériel , editable: true, nullable: true, length: 255, defaultValue: Luminaire du point lumineux, modelName: type_materiel )
• lot_geo_march ( type: esriFieldTypeString, alias: Lot géographique marché , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lot_geo_march , Coded Values: [Zone 1: Zone 1] , [Zone 2: Zone 2] , [Zone 3: Zone 3] , ...3 more... )
• nom_voie ( type: esriFieldTypeString, alias: Nom de la voie , editable: true, nullable: true, length: 255, defaultValue: null, modelName: nom_voie )
• x ( type: esriFieldTypeString, alias: Coordonnée en X , editable: true, nullable: true, length: 255, defaultValue: null, modelName: x )
• y ( type: esriFieldTypeString, alias: Coordonnée en y, editable: true, nullable: true, length: 255, defaultValue: null, modelName: y )
• lum_mis_service ( type: esriFieldTypeDate, alias: LUM_Mise en service , editable: true, nullable: true, length: 8, defaultValue: null, modelName: lum_mis_service )
• lum_date_dern_inv ( type: esriFieldTypeDate, alias: LUM_Date dernier inventaire , editable: true, nullable: true, length: 8, defaultValue: null, modelName: lum_date_dern_inv )
• num_luminaire ( type: esriFieldTypeString, alias: N° du luminaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: num_luminaire )
• id_luminaire ( type: esriFieldTypeString, alias: ID_Luminaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: id_luminaire )
• lum_fabric ( type: esriFieldTypeString, alias: LUM_Fabricant luminaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_fabric , Coded Values: [3eInternational: 3eInternational] , [Abel Eclairage: Abel Eclairage] , [AEG: AEG] , ...44 more... )
• lum_fabric_autr ( type: esriFieldTypeString, alias: LUM_Fabricant autre luminaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_fabric_autr )
• lum_modele ( type: esriFieldTypeString, alias: LUM_Fabricant autre luminaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_modele , Coded Values: [Adis: Adis] , [Alura: Alura] , [Aquila: Aquila] , ...268 more... )
• lum_model_autr ( type: esriFieldTypeString, alias: LUM_Modèle autre luminaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_model_autr )
• lum_ral ( type: esriFieldTypeString, alias: LUM_RAL luminaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_ral , Coded Values: [RAL 9021 - Noir goudron: RAL 9021 - Noir goudron] , [RAL 1014 - Ivoire: RAL 1014 - Ivoire] , [RAL 1015 - Ivoire clair: RAL 1015 - Ivoire clair] , ...18 more... )
• lum_haut_instal ( type: esriFieldTypeString, alias: LUM_Hauteur installation luminaire en m , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_haut_instal , Coded Values: [Non connu: Non connu] , [0: 0] , [0.5: 0.5] , ...48 more... )
• lum_usage ( type: esriFieldTypeString, alias: LUM_Usage luminaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_usage , Coded Values: [Balisage: Balisage] , [Cyclable: Cyclable] , [Parking: Parking] , ...6 more... )
• lum_class_elec ( type: esriFieldTypeString, alias: LUM_Classe électrique luminaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_class_elec , Coded Values: [Sans objet: Sans objet] , [Non connu: Non connu] , [0: 0] , ...3 more... )
• lum_typ_appareil ( type: esriFieldTypeString, alias: LUM_Type appareillage (Ballast/driver) , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_typ_appareil , Coded Values: [Ballast magnétique ou ferromagnétique: Ballast magnétique ou ferromagnétique] , [Ballast électronique: Ballast électronique] , [Driver: Driver] , ...1 more... )
• lum_type_lamp ( type: esriFieldTypeString, alias: LUM_Type lampe , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_type_lamp , Coded Values: [Ballon Fluo / Vapeur de Mercure / Tube Fluo: Ballon Fluo / Vapeur de Mercure / Tube Fluo] , [Halogène: Halogène] , [Iodure métallique (IM): Iodure métallique (IM)] , ...6 more... )
• lum_model_lamp ( type: esriFieldTypeString, alias: LUM_Modèle lampe , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_model_lamp )
• lum_typ_culot ( type: esriFieldTypeString, alias: LUM_Type culot , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_typ_culot , Coded Values: [BY22d: BY22d] , [E27: E27] , [E40: E40] , ...11 more... )
• lum_typ_autr_culot ( type: esriFieldTypeString, alias: LUM_Type autre culot , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_typ_autr_culot )
• lum_puiss_lamp ( type: esriFieldTypeString, alias: LUM_Puissance lampe en W , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_puiss_lamp , Coded Values: [Sans objet: Sans objet] , [Non connu: Non connu] , [2: 2] , ...48 more... )
• lum_date_remplacmnt_lamp ( type: esriFieldTypeDate, alias: LUM_Date remplacement lampe , editable: true, nullable: true, length: 8, defaultValue: null, modelName: lum_date_remplacmnt_lamp )
• lum_temp_coul_lamp ( type: esriFieldTypeString, alias: LUM_Température de couleur lampe en K , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_temp_coul_lamp , Coded Values: [De 1950 à 3000 (routier et tunnel principalement): De 1950 à 3000 (routier et tunnel principalement)] , [De 3000 à 5600 ( résidentiel principalement): De 3000 à 5600 ( résidentiel principalement)] , [De 2800 à 4200 (piétonnier et résidentiel principalement): De 2800 à 4200 (piétonnier et résidentiel principalement)] , ...3 more... )
• lum_restrict_heur_fonction ( type: esriFieldTypeString, alias: LUM_Restriction horaire de fonctionnement , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_restrict_heur_fonction , Coded Values: [Oui: Oui] , [Non: Non] , [Non connu: Non connu] )
• lum_abaissemnt_puiss ( type: esriFieldTypeString, alias: LUM_Abaissement de puissance , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_abaissemnt_puiss , Coded Values: [Oui: Oui] , [Non: Non] , [Non connu: Non connu] )
• lum_pourcentag_abaissemnt ( type: esriFieldTypeString, alias: LUM_Pourcentage d'abaissement , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_pourcentag_abaissemnt , Coded Values: [Sans objet: Sans objet] , [Non connu: Non connu] , [10: 10] , ...18 more... )
• lum_duree_abaissemnt ( type: esriFieldTypeString, alias: LUM_Durée d'abaissement , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_duree_abaissemnt , Coded Values: [1h: 1h] , [1h30: 1h30] , [2h: 2h] , ...12 more... )
• lum_date_control ( type: esriFieldTypeDate, alias: LUM_Date contrôle luminaire , editable: true, nullable: true, length: 8, defaultValue: null, modelName: lum_date_control )
• lum_etat_vetust ( type: esriFieldTypeString, alias: LUM_Etat vétusté luminaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_etat_vetust , Coded Values: [Bon: Bon] , [Moyen: Moyen] , [Vétuste: Vétuste] , ...4 more... )
• lum_pres_vask ( type: esriFieldTypeString, alias: LUM_Vasque présente , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_pres_vask , Coded Values: [Oui: Oui] , [Non: Non] , [Sans objet: Sans objet] , ...1 more... )
• lum_commentaire ( type: esriFieldTypeString, alias: LUM_Commentaire , editable: true, nullable: true, length: 255, defaultValue: null, modelName: lum_commentaire )
• num_new_candelabre ( type: esriFieldTypeString, alias: Nouveau n° de candélabre, editable: true, nullable: true, length: 100, defaultValue: null, modelName: num_new_candelabre )
• num_new_luminaire ( type: esriFieldTypeString, alias: Nouveau n° de luminaire, editable: true, nullable: true, length: 100, defaultValue: null, modelName: num_new_luminaire )
• commune ( type: esriFieldTypeString, alias: commune, editable: true, nullable: true, length: 255, defaultValue: null, modelName: commune , Coded Values: [Achères: Achères] , [Andrésy: Andrésy] , [Arnouville-lès-Mantes: Arnouville-lès-Mantes] , ...70 more... )
• quartier ( type: esriFieldTypeString, alias: quartier, editable: true, nullable: true, length: 255, defaultValue: null, modelName: quartier )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: gpso.aop.GPSEO_EP_EP_LUMINAIRE
  Description:
  Prototype:
  quartier: null
  commune: null
  num_candelabre: null
  type_materiel: Luminaire du point lumineux
  lot_geo_march: null
  nom_voie: null
  x: null
  y: null
  lum_mis_service: null
  lum_date_dern_inv: null
  num_luminaire: null
  id_luminaire: null
  lum_fabric: null
  lum_fabric_autr: null
  lum_modele: null
  lum_model_autr: null
  lum_ral: null
  lum_haut_instal: null
  lum_usage: null
  lum_class_elec: null
  lum_typ_appareil: null
  lum_type_lamp: null
  lum_model_lamp: null
  lum_typ_culot: null
  lum_typ_autr_culot: null
  lum_puiss_lamp: null
  lum_date_remplacmnt_lamp: null
  lum_temp_coul_lamp: null
  lum_restrict_heur_fonction: null
  lum_abaissemnt_puiss: null
  lum_pourcentag_abaissemnt: null
  lum_duree_abaissemnt: null
  lum_date_control: null
  lum_etat_vetust: null
  lum_pres_vask: null
  lum_commentaire: null
  num_new_candelabre: null
  num_new_luminaire: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GPSEO_EP_EP_POINT_LUMINEUX (1) -- Related To: EP - Points lumineux (117)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata