{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Guide de lecture","TRANCHEE_GEO","ARTERE_GEO","NOEUD_GEO","CABLE_GEO","EQUIPEMENT_PASSIF","SITE_GEO","ZAPBO_GEO"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guide de lecture","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Dictionnaire de données"]
["Champs obligatoires en étude"]
["Nouveaux champs et/ou nouvelle liste de valeurs (italique)"]

{"sheet":"TRANCHEE_GEO","index":1,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,0,61,0],[22,1,26,1],[22,2,26,2],[22,3,26,3],[22,4,26,4],[5,3,12,3],[5,4,12,4],[5,1,12,1],[13,3,21,3],[13,4,21,4],[5,2,12,2],[13,2,21,2],[13,1,21,1],[29,1,34,1],[29,2,34,2],[38,1,39,1],[38,2,39,2],[40,3,44,3],[29,3,34,3],[45,1,49,1],[45,2,49,2],[40,2,44,2],[58,1,61,1],[53,1,55,1],[40,1,44,1],[58,2,61,2],[53,2,55,2],[29,7,34,7],[22,5,26,5],[45,4,49,4],[54,7,55,7],[38,5,39,5],[29,4,34,4],[38,4,39,4],[29,5,34,5],[40,4,44,4],[40,5,44,5],[53,4,55,4],[58,5,61,5],[45,5,49,5],[58,3,61,3],[58,4,61,4],[5,5,12,5],[13,5,21,5],[38,3,39,3],[45,3,49,3],[53,3,55,3]]}
["TABLE","ATTRIBUT","ATTRIBUT SHAPE","FORMAT_CHAMP","DETAIL_CHAMP","EXEMPLE","VALEUR","DETAIL VALEUR"]
["TRANCHEE_GEO","TR_CODE","TR_CODE","Caractère (23 BYTE)","Codage d'un support - page 42, paragraphe 7.3 - Guide 2.8","TRA–57-001–AC–0050-0055"]
[null,"TR_NOM","TR_NOM","Caractère (23BYTE)","Identique à TR_CODE","TRA–57-001–AC–0050-0055","Identique à TR_CODE"]
[null,"TR_ID_INSEE","TR_ID_INSE","Caractère (5 BYTE)","Code INSEE de la commune où est implanté la tranchée",50001,null,"cf liste codes INSEE annexe 1"]
[null,"TR_VOIE","TR_VOIE","Caractère (200 BYTE)","Adresse","20 PLACE DU GENERAL DE GAULLE, 50000 SAINT-LÔ"]
[null,"TR_TYP_IMPL","TR_TYP_IMP","Caractère (24 BYTE)","Type d’implantation de la tranchée","ACCOTEMENT STABILISE","ACCOTEMENT STABILISE"]
[{"$nulls":6},"ACCOTEMENT NON STABILISE"]
[{"$nulls":6},"CHAUSSEE LOURDE"]
[{"$nulls":6},"CHAUSSEE LEGERE"]
[{"$nulls":6},"FOSSE"]
[{"$nulls":6},"TROTTOIR"]
[{"$nulls":6},"ESPACE VERT"]
[{"$nulls":6},"ENCORBELLEMENT"]
[null,"TR_MOD_POSE","TR_MOD_POS","Caractère (14 BYTE)","Type de tranchée","TRADITIONNEL","TRADITIONNEL"]
[{"$nulls":6},"MICRO TRANCHEE"]
[{"$nulls":6},"FONCAGE 60"]
[{"$nulls":6},"FONCAGE 90"]
[{"$nulls":6},"FONCAGE 120"]
[{"$nulls":6},"TRANCHEUSE"]
[{"$nulls":6},"FORAGE URBAIN"]
[{"$nulls":6},"FORAGE RURAL"]
[{"$nulls":6},"ENCORBELLEMENT"]
[null,"TR_MOD_POSE_AI","TR_MPOS_AI","Caractère (3 BYTE)","Type de tranchée","TRA","TRA","TR_MOD_POSE = TRADITIONNEL"]
[{"$nulls":6},"ALL","TR_MOD_POSE  = MICRO TRANCHEE ou TRANCHEUSE. (ALL = GC ALLEGE)"]
[{"$nulls":6},"FON","TR_MOD_POSE  =  FONCAGE 60, 90 ou 120"]
[{"$nulls":6},"FOR","TR_MOD_POSE  = FORAGE URBAIN ou FORAGE RURAL"]
[{"$nulls":6},"ENC","TR_MOD_POSE  = ENCORBELLEMENT"]
[null,"TR_LONG","TR_LONG","Number (6,2)","Longueur de la tranchée (en mètre)",50.21]
[null,"TR_LARG","TR_LARG","Number (6,2)","Largeur de la tranchée (en mètre)",1.62]
[null,"TR_REVET","TR_REVET","Caractère (20 BYTE)","Type de revêtement","ENROBE","SABLE","cf coupe-type ou bordereau en annexe CCTP"]
[{"$nulls":6},"BICOUCHE"]
[{"$nulls":6},"ENROBE"]
[{"$nulls":6},"BETON"]
[{"$nulls":6},"PAVE"]
[{"$nulls":6},"TERRAIN NATUREL"]
[null,"TR_CHARGE","TR_CHARGE","Number (6,2)","Hauteur de charge (en mètre)",1.23]
[null,"TR_GRILLAGE","TR_GRILLAG","Number (6,2)","Profondeur du grillage (en mètre)",0.8]
[null,"TR_REMBLAIS","TR_REMBLAI","Caractère (20 BYTE)","Type de remblais","GRAVIER",null,"cf coupe-type ou bordereau"]
[null,"TR_PLYNOX","TR_PLYNOX","Caractère (3 BYTE)","Présence plynox","NON","OUI"]
[{"$nulls":6},"NON"]
[null,"TR_PRO_VOIE","TR_PRO_VOI","Caractère (22 BYTE)","Propriétaire de la voirie","DEPARTEMENT","COMMUNE"]
[{"$nulls":6},"COMMUNAUTE DE COMMUNES"]
[{"$nulls":6},"DEPARTEMENT"]
[{"$nulls":6},"ETAT"]
[{"$nulls":6},"PRIVE"]
[null,"TR_GEST_VOIE","TR_GEST_VO","Caractère (22 BYTE)","Gestionnaire de la voirie","DEPARTEMENT","COMMUNE"]
[{"$nulls":6},"COMMUNAUTE DE COMMUNES"]
[{"$nulls":6},"DEPARTEMENT"]
[{"$nulls":6},"ETAT"]
[{"$nulls":6},"PRIVE"]
[null,"TR_SCHEMA","TR_SCHEMA","Caractère (100 BYTE)","Schéma propre au projet représentant la typologie de la tranchée","05",null,"cf coupe-type en annexe CCTP"]
[null,"TR_DATE_INST","TR_DATE_IN","Date","Date d’installation de l’infrastructure","2012-05-04"]
[null,"TR_SRC_GEO","TR_SRC_GEO","Caractère (50 BYTE)","Source de géoréférencement","PERRION",null,"Nom du géomètre en majuscule sans accent"]
[null,"TR_QLT_GEO","TR_QLT_GEO","Caractère 1 BYTE)","Qualité de géoréférencement","A",null,"Classe A obligatoire (selon réforme DT-DICT) en cas de GC (précison 25cm de part et d'autre, "]
[{"$nulls":5},"B",null,"Sinon, classe opérateur  (selon réforme DT-DICT) "]
[{"$nulls":5},"C"]
[null,"TR_PRO_MD","TR_PRO_MD","Caractère (20 BYTE)","Propriétaire des métadonnées","MANCHE NUMERIQUE","MANCHE NUMERIQUE"]
[null,"TR_COMMENT","TR_COMMENT","Caractère (300 BYTE)","Commentaire",null,null,"Toutes obsevations utiles."]
[null,"TR_STATUT","TR_STATUT","Caractère (14 BYTE)","Statut du rendu","EN ETUDE","EN ETUDE","APS ou APD = En étude"]
[{"$nulls":6},"EN REALISATION","EXE = En réalisation"]
[{"$nulls":6},"EN SERVICE","REC = En service"]
[{"$nulls":6},"HORS SERVICE"]

{"sheet":"ARTERE_GEO","index":2,"n_rows":80,"n_cols":8,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,0,79,0],[20,2,27,2],[54,3,60,3],[54,4,60,4],[28,1,33,1],[28,2,33,2],[28,3,33,3],[28,4,33,4],[54,1,60,1],[54,2,60,2],[34,3,43,3],[34,4,43,4],[34,2,43,2],[44,2,47,2],[61,2,66,2],[61,3,66,3],[5,3,9,3],[5,4,9,4],[54,5,60,5],[5,5,9,5],[10,5,15,5],[20,3,27,3],[34,5,43,5],[10,4,15,4],[10,3,15,3],[20,4,27,4],[20,5,27,5],[44,4,47,4],[44,3,47,3],[5,1,9,1],[10,1,15,1],[34,1,43,1],[10,2,15,2],[5,2,9,2],[20,1,27,1],[76,1,79,1],[44,5,47,5],[76,5,79,5],[71,5,73,5],[28,5,33,5],[61,1,66,1],[44,1,47,1],[76,2,79,2],[71,3,73,3],[71,1,73,1],[71,2,73,2],[71,4,73,4],[76,4,79,4],[61,5,66,5],[61,4,66,4],[76,3,79,3]]}
["TABLE","ATTRIBUT","ATTRIBUT SHAPE","FORMAT_CHAMP","DETAIL_CHAMP","EXEMPLE","VALEUR","DETAIL VALEUR"]
["ARTERE_GEO","AR_CODE","AR_CODE","Caractère (26 BYTE)","Codage d'une infrastructure - page 45, paragraphe 8.7 - Guide 2.8","PEH-57-001-AC-0050-0055-00"]
[null,"AR_NOM","AR_NOM","Caractère (26 BYTE)","Identique à AR_CODE","PEH-57-001-AC-0050-0055-00","Identique à AR_CODE"]
[null,"AR_ID_INSEE","AR_ID_INSE","Caractère (5 BYTE)","Code INSEE de la commune où est implanté l'artère",50001,null,"cf liste codes INSEE annexe 1"]
[null,"AR_LONG","AR_LONG","Number (6,2)","Longueur de l'artère (en mètres)",120.12]
[null,"AR_ETAT","AR_ETAT","Caractère (1 BYTE)","Etat de l'artère",0,0,"Schéma d'ingénierie"]
[{"$nulls":6},1,"L'infrastructure doit être changée car la moindre intervention peut être préjudiciable à la fourniture du service"]
[{"$nulls":6},2,"Mauvais état général de l'infrastructure qui ne permet pas certaines interventions"]
[{"$nulls":6},3,"Bon état général qui permet de réaliser toute opération de maintenance, d'exploitation ou d'évolution"]
[{"$nulls":6},4,"Non communiqué"]
[null,"AR_OCCP","AR_OCCP","Caractère (3 BYTE)"," ",0,0,"L'infrastructure est vide"]
[{"$nulls":6},"1.1","L'infrastructure est non vide mais exploitable car rangée"]
[{"$nulls":6},"1.2","L'infrastructure est non vide et non exploitable car non rangée"]
[{"$nulls":6},2,"L'infrastructure est saturée"]
[{"$nulls":6},3,"Evaluation impossible, commentaire attendu"]
[{"$nulls":6},4,"Non communiqué"]
[null,"AR_NOEUD_A","AR_NOEUD_A","Caractère (20BYTE)","Code du nœud A (cf NO_CODE)","CHA-57-001-AC-0050",null,"Codage d’un point technique - page 33, paragraphe 5.3 - Guide 2.8"]
[null,"AR_NOEUD_B","AR_NOEUD_B","Caractère (20 BYTE)","Code du nœud B (cf NO_CODE)","CHA-57-001-AC-0055",null,"Codage d’un point technique - page 33, paragraphe 5.3 - Guide 2.8"]
[null,"AR_NB_FOUR","AR_NB_FOUR","Caractère (10 BYTE)","Nombre de fourreaux",5,null,"En phase APD pour l'existant, si fourreaux avec diamètre différent : 4 - 3"]
[null,"AR_NB_FOUR_DIS","AR_FOU_DIS","Entier (2 BYTE)","Nombre  de fourreaux vides",2]
[null,"AR_TYPE_FOUR","AR_TYPE_FO","Caractère (20 BYTE)","Type  de fourreaux","PEHD","PVC"]
[{"$nulls":6},"PEHD"]
[{"$nulls":6},"SOUS-TUBAGE PEHD"]
[{"$nulls":6},"SOUS-TUBAGE  SOUPLE"]
[{"$nulls":6},"FACADE"]
[{"$nulls":6},"AERIEN"]
[{"$nulls":6},"ENCORBELLEMENT"]
[{"$nulls":6},"AUTRE"]
[null,"AR_TYPE_FOUR_AI","AR_TYFO_AI","Caractère (3 BYTE)","Type  de fourreaux","PEH","PVC","AR_TYPE_FOUR = PVC"]
[{"$nulls":6},"PEH","AR_TYPE_FOUR = PEHD"]
[{"$nulls":6},"TUB","AR_TYPE_FOUR = SOUS-TUBAGE PEHD ou SOUS-TUBAGE  SOUPLE"]
[{"$nulls":6},"FAC","AR_TYPE_FOUR = FACADE"]
[{"$nulls":6},"ENC","AR_TYPE_FOUR = ENCORBELLEMENT"]
[{"$nulls":6},"APP","AR_TYPE_FOUR = AERIEN"]
[null,"AR_DIAM_FOUR","AR_DIAM_FO","Caractère (10 BYTE)","Diamètre extérieur du fourreau (en mm)",18,10,"En phase APD pour l'existant, si fourreaux avec diamètre différent : 40 - 60"]
[{"$nulls":6},14]
[{"$nulls":6},18]
[{"$nulls":6},25]
[{"$nulls":6},28]
[{"$nulls":6},32]
[{"$nulls":6},40]
[{"$nulls":6},45]
[{"$nulls":6},60]
[{"$nulls":6},"NUL"," NUL en cas d'aérien"]
[null,"AR_PRO_FOUR","AR_PRO_FOU","Caractère (20 BYTE)","Propriétaire du fourreau","MANCHE NUMERIQUE","MANCHE NUMERIQUE","si GC neuf, remplir MANCHE NUMERIQUE"]
[{"$nulls":6},"COLLECTIVITE"]
[{"$nulls":6},"ORANGE"]
[{"$nulls":6},"AUTRE (à préciser)"]
[null,"AR_FABRICANT","AR_FAB","Caractère (100 BYTE)","Nom du fabricant"]
[null,"AR_REF_FABRICANT","AR_REFFAB","Caractère (100 BYTE)","Référence du matériel chez le fabricant"]
[null,"AR_COULEUR","AR_COULEUR","Caractère (20 BYTE)","Couleur extérieure du fourreau"]
[null,"AR_AIGUILLEE","AR_AIGUIL","Caractère (3 BYTE)","Présence d’une aiguille en attente dans le fourreau. Oui/Non","OUI","OUI/NON"]
[null,"AR_NB_CABLES","AR_NBCABL","Entier (2 BYTE)","Nombre de câbles dans l’infra",2]
[null,"AR_PRO_CABLE","AR_PRO_CAB","Caractère (20 BYTE)","Propriétaire du câble","MANCHE NUMERIQUE","MANCHE NUMERIQUE"]
[null,"AR_GEST_FOUR","AR_GEST_FO","Caractère (50 BYTE)","Gestionnaire du fourreau","ORANGE","MANCHE NUMERIQUE","si GC neuf, remplir NUL"]
[{"$nulls":6},"MANCHE TELECOM"]
[{"$nulls":6},"COLLECTIVITE"]
[{"$nulls":6},"ORANGE"]
[{"$nulls":6},"MANCHE FIBRE"]
[{"$nulls":6},"AUTRE (à préciser)"]
[{"$nulls":6},"NUL"]
[null,"AR_UTIL_FOUR","AR_UTIL_FO","Caractère (50 BYTE)","Utilisateur du fourreau","MANCHE NUMERIQUE","MANCHE NUMERIQUE","si GC neuf, remplir NUL"]
[{"$nulls":6},"MANCHE TELECOM","Plusieurs valeurs possibles dans le même enregistrement"]
[{"$nulls":6},"COLLECTIVITE"]
[{"$nulls":6},"ORANGE"]
[{"$nulls":6},"AUTRE (à préciser)"]
[{"$nulls":6},"NUL"]
[null,"AR_DATE_INST","AR_DATE_IN","Date","Date d'installation de l'infrastructure","2012-05-04","JJ/MM/AAAA"]
[null,"AR_DATE_RECEP","AR_DATE_RE","Date","Date à la réception des travaux","2012-05-04","JJ/MM/AAAA"]
[null,"AR_REF_PLANCHE","AR_REF_PLA","Caractère (100 BYTE)","Référence de la planche d'origine dans laquelle se trouve l'infrastructure","REC_50639_COL_LE_DINANDIER_FOLIOXX.PDF",null,"Planche majoritaire sur le tronçon"]
[null,"AR_SRC_GEO","AR_SRC_GEO","Caractère (50 BYTE)","Source de géoréférencement","PERRION",null,"Nom du géomètre en majuscule sans accent"]
[null,"AR_QLT_GEO","AR_QLT_GEO","Caractère 1 BYTE)","Qualité de géoréférencement","A","A","Classe A obligatoire (selon réforme DT-DICT) en cas de GC (précison 25cm de part et d'autre, "]
[{"$nulls":6},"B","Sinon, classe opérateur  (selon réforme DT-DICT) "]
[{"$nulls":6},"C"]
[null,"AR_PRO_MD","AR_PRO_MD","Caractère (20 BYTE)","Propriétaire des métadonnées","MANCHE NUMERIQUE"]
[null,"AR_COMMENT","AR_COMMENT","Caractère (300 BYTE)","Commentaires","EXISTANT",null,"Toutes obsevations utiles. Si réseau existant, mettre \"EXISTANT\".\nSi artere en attente pour racco client mettre \"INFRASTRUCTURE POUR LE RACCORDEMENT CLIENT\""]
[null,"AR_STATUT","AR_STATUT","Caractère (14 BYTE)","Statut du rendu","EN ETUDE","EN ETUDE","APS ou APD = En étude"]
[{"$nulls":6},"EN REALISATION","EXE = En réalisation"]
[{"$nulls":6},"EN SERVICE","REC = En service"]
[{"$nulls":6},"HORS SERVICE"]

{"sheet":"NOEUD_GEO","index":3,"n_rows":91,"n_cols":8,"rows_kept":91,"cut":false,"hidden":false,"merged":[[60,7,65,7],[66,7,73,7],[78,7,80,7],[24,5,28,5],[1,0,86,0],[11,1,16,1],[29,1,37,1],[6,1,10,1],[48,1,54,1],[83,2,86,2],[66,2,73,2],[66,1,73,1],[78,2,80,2],[56,1,57,1],[78,1,80,1],[83,1,86,1],[56,3,57,3],[56,2,57,2],[60,2,65,2],[60,1,65,1],[24,2,28,2],[24,1,28,1],[6,5,10,5],[24,3,28,3],[24,4,28,4],[83,4,86,4],[78,4,80,4],[60,5,65,5],[66,5,73,5],[60,3,65,3],[83,5,86,5],[78,5,80,5],[83,3,86,3],[6,4,10,4],[66,3,73,3],[66,4,73,4],[60,4,65,4],[56,4,57,4],[48,5,54,5],[56,5,57,5],[17,5,23,5],[11,5,16,5],[38,4,46,4],[29,4,37,4],[48,4,54,4],[17,4,23,4],[11,4,16,4],[29,5,37,5],[38,5,46,5],[6,2,10,2],[48,2,54,2],[38,2,46,2],[17,1,23,1],[6,3,10,3],[17,2,23,2],[29,2,37,2],[11,2,16,2],[38,1,46,1],[17,3,23,3],[11,3,16,3],[48,3,54,3],[38,3,46,3],[29,3,37,3]]}
["TABLE","ATTRIBUT","ATTRIBUT SHAPE","FORMAT_CHAMP","DETAIL_CHAMP","EXEMPLE","VALEUR","DETAIL VALEUR"]
["NOEUD_GEO","NO_CODE","NO_CODE","Caractère (18 BYTE)","Codage d’un point technique - page 33, paragraphe 5.3 - Guide 2.8","CHA-57-001-AC-0050"]
[null,"NO_ID_INSEE","NO_ID_INSE","Caractère (5 BYTE)","Code INSEE de la commune où est implanté le Noeud",50001,null,"cf liste codes INSEE annexe 1"]
[null,"NO_NOM","NO_NOM","Caractère (20 BYTE)","Nom terrain ou NO_CODE","CHA-57-001-AC-0050",null,"Si existant, reprendre codes : Chambre FT (50001_0001), Chambre MN ; sinon 'NO_CODE'"]
[null,"NO_VOIE","NO_VOIE","Caractère (100 BYTE)","Adresse"]
[null,"NO_EMPRISE","NO_EMPRISE","Caractère (10 BYTE)","Code du NRO dont dépend le point technique - Codage d'un NRO- page 19 paragraphe 4.1.3 - Guide 2.8","NRO-50-013"]
[null,"NO_ETAT","NO_ETAT","Caractère (1 BYTE)","Etat du nœud",0,0,"Schéma d'ingénierie"]
[{"$nulls":6},1,"L'infrastructure doit être changée car la moindre intervention peut être préjudiciable à la fourniture du service"]
[{"$nulls":6},2,"Mauvais état général de l'infrastructure qui ne permet pas certaines interventions"]
[{"$nulls":6},3,"Bon état général qui permet de réaliser toute opération de maintenance, d'exploitation ou d'évolution"]
[{"$nulls":6},4,"Non communiqué"]
[null,"NO_OCCP","NO_OCCP","Caractère (3 BYTE)","Occupation du nœud",0,0,"L'infrastructure est vide"]
[{"$nulls":6},"1.1","L'infrastructure est non vide mais exploitable car rangée"]
[{"$nulls":6},"1.2","L'infrastructure est non vide et non exploitable car non rangée"]
[{"$nulls":6},2,"L'infrastructure est saturée"]
[{"$nulls":6},3,"Evaluation impossible, commentaire attendu"]
[{"$nulls":6},4,"Non communiqué"]
[null,"NO_TYPE","NO_TYPE","Caractère (3 BYTE)","Type de nœud","CHA","CHA","Chambre"]
[{"$nulls":6},"POT","Poteau"]
[{"$nulls":6},"LTE","Local Technique"]
[{"$nulls":6},"SEM","Site Emission"]
[{"$nulls":6},"FAC","Accroche-Façade"]
[{"$nulls":6},"OUV","Ouvrage d'art"]
[{"$nulls":6},"IMM","Immeuble"]
[null,"NO_TYP_FONCTIONNEL","NO_TYPFCT","Caractère (14 BYTE)","La liste de valeurs est construite par ordre d'importance, 1 étant la valeur la plus élevée","INTERCONNEXION","INTERCONNEXION",1]
[{"$nulls":6},"SATELLITE",3]
[{"$nulls":6},"PASSAGE",2]
[{"$nulls":6},"REGARD",4]
[{"$nulls":6},"INDETERMINE",5]
[null,"NO_TYPE_LQ","NO_TYPE_LQ","Caractère (10 BYTE)","Type logique du nœud","CHTIR","CHTIR","Chambre de Tirage - NO_TYPE = CHA"]
[{"$nulls":6},"CHRACC","Chambre de Raccordement - NO_TYPE = CHA"]
[{"$nulls":6},"POT","Poteau - NO_TYPE = POT"]
[{"$nulls":6},"NRO","Nœud de Raccordement Optique - NO_TYPE = LTE"]
[{"$nulls":6},"PM","Point de Mutualisation - NO_TYPE = LTE"]
[{"$nulls":6},"MIMO","Site d'émission MIMO - NO_TYPE = SEM"]
[{"$nulls":6},"FAC","Accroche-Façade - NO_TYPE = FAC"]
[{"$nulls":6},"OUV","Ouvrage d'art"]
[{"$nulls":6},"IMM","Immeuble - NO_TYPE = IMM"]
[null,"NO_TYPE_PH","NO_TYPE_PH","Caractère (9BYTE)",null,"CHAMBRE","CHAMBRE","NO_TYPE = CHA"]
[{"$nulls":6},"POTEAU","NO_TYPE = POT"]
[{"$nulls":6},"ARMOIRE","NO_TYPE = LTE"]
[{"$nulls":6},"SHELTER","NO_TYPE = LTE"]
[{"$nulls":6},"BATIMENT","NO_TYPE = LTE"]
[{"$nulls":6},"SITE MIMO","NO_TYPE = SEM"]
[{"$nulls":6},"FACADE","NO_TYPE = FAC"]
[{"$nulls":6},"OUVRAGE","NO_TYPE = OUV"]
[{"$nulls":6},"IMMEUBLE","NO_TYPE = IMM"]
[null,"NO_CODE_PH","NO_CODE_PH","Caractère (20BYTE)","Code physique du support des chambres et Poteaux","L1T SF",null,"Pour poteaux existants, à remplir avec liste de chambres et poteaux des gestionnaires (FT et ERDF)\nPour création poteau remplir en utilisant la même logique (FT et ERDF)\nPour les chambre indiquer la rérérence du modèle (ex L1T), Si sans fond rajouter SF à la fin de la référence"]
[null,"NO_TECH_PSTES","NO_TECH_PS","Caractère (4 BYTE)","Technologies présentes dans le nœud","OPT","COAX","Coaxial"]
[{"$nulls":6},"CUT","Cuivre télécom"]
[{"$nulls":6},"ECL","Eclairage"]
[{"$nulls":6},"ELEC","Electricité"]
[{"$nulls":6},"VP","Vidéo Protection"]
[{"$nulls":6},"OPT","Optique"]
[{"$nulls":6},"NC","Non connu"]
[null,"NO_AMO","NO_AMO","Caractère (20 BYTE)","Identifiant du nœud logique en amont","107ACHA00013",null,"Reprendre code existant quand existe (FT clé MKT, MN code,...); sinon 'ZAPM'_'NO_TYPE'_'Num_auto 5 caractères'\nSi pose sur réseau existant, indiquer BUS"]
[null,"NO_PLINOX","NO_PLINOX","Caractère (3 BYTE)","Présence de plinox","NON","OUI"]
[{"$nulls":6},"NON"]
[null,"NO_X","NO_X","Double (15,4)","Coordonnées géo X en CC49",1349961.2466]
[null,"NO_Y","NO_Y","Double (15,4)","Coordonnées géo Y en CC49",8285617.0839]
[null,"NO_PRO","NO_PRO","Caractère (20 BYTE)","Propriétaire","MANCHE NUMERIQUE","MANCHE NUMERIQUE","Si GC neuf, remplir MANCHE NUMERIQUE"]
[{"$nulls":6},"COLLECTIVITE"]
[{"$nulls":6},"ORANGE"]
[{"$nulls":6},"ERDF"]
[{"$nulls":6},"AUTRE (à préciser)"]
[{"$nulls":6},"NUL"]
[null,"NO_GEST","NO_GEST","Caractère (20 BYTE)","Gestionnaire du nœud","MANCHE NUMERIQUE","MANCHE NUMERIQUE","Si GC neuf, remplir NUL"]
[{"$nulls":6},"MANCHE TELECOM"]
[{"$nulls":6},"COLLECTIVITE"]
[{"$nulls":6},"ORANGE"]
[{"$nulls":6},"ERDF"]
[{"$nulls":6},"AUTRE (à préciser)"]
[{"$nulls":6},"MANCHE FIBRE"]
[{"$nulls":6},"NUL"]
[null,"NO_HAUT","NO_HAUT","NUMBER(2,2)","Hauteur du nœud (en mètre)",10,null,"Hauteur du poteau (en mètres)"]
[null,"NO_DATE_INST","NO_DATE_IN","Date","Date d'installation de l'infrastructure","2012-05-04",null,"JJ/MM/AAAA"]
[null,"NO_REF_PLANCHE","NO_REF_PLA","Caractère (100 BYTE)","Référence de la planche d'origine dans laquelle se trouve l'infrastructure","REC_50639_COL_LE_DINANDIER_FOLIOXX.PDF",null,"Planche majoritaire sur le nœud"]
[null,"NO_SRC_GEO","NO_SRC_GEO","Caractère (50 BYTE)","Source de géoréférencement","PERRION",null,"Nom du géomètre en majuscule sans accent"]
[null,"NO_QLT_GEO","NO_QLT_GEO","Caractère 1 BYTE)","Qualité de géoréférencement","A","A","Classe A obligatoire (selon réforme DT-DICT) en cas de GC (précison 25cm de part et d'autre, \nSinon, classe opérateur  (selon réforme DT-DICT) "]
[{"$nulls":6},"B"]
[{"$nulls":6},"C"]
[null,"NO_PRO_MD","NO_PRO_MD","Caractère (20 BYTE)","Propriétaire des métadonnées","MANCHE NUMERIQUE","MANCHE NUMERIQUE"]
[null,"NO_COMMENT","NO_COMMENT","Caractère (300 BYTE)","Commentaire","EXISTANT",null,"Toutes obsevations utiles. Si réseau existant, indiquez-le dans ce champ là. "]
[null,"NO_STATUT","NO_STATUT","Caractère (14 BYTE)","Statut du rendu","EN ETUDE","EN ETUDE","APS ou APD = En étude"]
[{"$nulls":6},"EN REALISATION","EXE = En réalisation"]
[{"$nulls":6},"EN SERVICE","REC = En service"]
[{"$nulls":6},"HORS SERVICE"]
[]
[]
[]
[{"$nulls":6},{"$f":"LEN(G25)","v":14}]

{"sheet":"CABLE_GEO","index":4,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[8,3,12,3],[8,4,12,4],[8,5,12,5],[18,4,22,4],[18,5,22,5],[13,5,17,5],[38,5,41,5],[27,5,29,5],[30,7,31,7],[30,3,31,3],[30,2,31,2],[30,4,31,4],[30,5,31,5],[27,2,29,2],[27,3,29,3],[27,4,29,4],[1,0,41,0],[18,1,22,1],[27,1,29,1],[13,4,17,4],[13,3,17,3],[38,3,41,3],[13,1,17,1],[13,2,17,2],[30,1,31,1],[38,1,41,1],[38,2,41,2],[8,2,12,2],[8,1,12,1],[18,2,22,2],[38,4,41,4],[18,3,22,3]]}
["TABLE","ATTRIBUT","ATTRIBUT SHAPE","FORMAT_CHAMP","DETAIL_CHAMP","EXEMPLE","VALEUR","DETAIL VALEUR"]
["CABLE_GEO","CA_CODE","CA_CODE","Caractère (18 BYTE)","Codage d’un câble - page 48, paragraphe 9.3 - Guide 2.8","CDI-57-001-AC-0050"]
[null,"CA_NOM","CA_NOM","Caractère (18 BYTE)","Codage d’un câble - page 48, paragraphe 9.3 - Guide 2.8","CDI-57-001-AC-0050",null,"Si existant, reprendre code câble existant (ex :107AA072A01), sinon CA_CODE"]
[null,"CA_NUMERO","CA_NUMERO","Caractère (17 BYTE)","Numéro d'identification du cable","CDI-145-A-012-A01",null,"Type fonctionnel du câble+N° de SRO (ex:S145)+mode de pose + capacité de câble (3 caractères)+incrément 3 caractères alphanumériques\nCA_TYPE : A Aérien, S Souterrain, F Facade, I Immeuble, M Mixte"]
[null,"CA_EMPRISE","CA_EMPRISE","Caractère (10 BYTE)","Code du NRO dont dépend le point technique - Codage d'un NRO- page 19 paragraphe 4.1.3 - Guide 2.8","NRO-50-013"]
[null,"CA_FABRICANT","CA_FAB","Caractère (100 BYTE)","Fabricant du câble","ACOME"]
[null,"CA_REFERENCE","CA_REFFAB","Caractère (100 BYTE)","Référence du cable chez le fabricant"]
[null,"CA_MODELE","CA_MODELE","Caractère (10 BYTE)","Modèle de cable","C048T08F06",null,"Cable 48 Fo, composé de 8 tubes de 6 fibres"]
[null,"CA_TYPE","CA_TYPE","Caractère (10 BYTE)","Type de câble","AERIEN","AERIEN"]
[{"$nulls":6},"IMMEUBLE"]
[{"$nulls":6},"FACADE"]
[{"$nulls":6},"MIXTE","Aérosouterrain"]
[{"$nulls":6},"SOUTERRAIN"]
[null,"CA_TYPE_FONCTIONNEL","CA_TYPFCT","Caractère (3 BYTE)","Type fonctionnel du câble","CDI","CDI","Cable distribution"]
[{"$nulls":6},"CTR","Cable Transport"]
[{"$nulls":6},"CBM","Cable Boucle Métropolitaine"]
[{"$nulls":6},"RAC","Cable de raccordement"]
[{"$nulls":6},"CBO","Cable Breakout"]
[null,"CA_ETAT","CA_ETAT","Caractère (1 BYTE)","Etat du câble",0,0,"Schéma d'ingénierie"]
[{"$nulls":6},1,"L'infrastructure doit être changée car la moindre intervention peut être préjudiciable à la fourniture du service"]
[{"$nulls":6},2,"Mauvais état général de l'infrastructure qui ne permet pas certaines interventions"]
[{"$nulls":6},3,"Bon état général qui permet de réaliser toute opération de maintenance, d'exploitation ou d'évolution"]
[{"$nulls":6},4,"Non communiqué"]
[null,"CA_LONG","CA_LONG","NUM (6,2)","Longueur total du câble en mètre",1230.2]
[null,"CA_EQ_A","CA_EQ_A","Caractère (18 BYTE)","Nom de l'équipement passif A","BPE–57-001–AC–0050",null,"Reprendre le code EQ_NOM de l'équipement passif"]
[null,"CA_EQ_B","CA_EQ_B","Caractère (18 BYTE)","Nom de l'équipement passif B","BPE–57-001–AC–0055",null,"Reprendre le code EQ_NOM de l'équipement passif"]
[null,"CA_DIAMETRE","CA_DIAMETR","NUM (4,2)","Diamètre du câble en millimètres",12]
[null,"CA_COULEUR","CA_COULEUR","Caractère (20 BYTE)","Couleur du câble","NOIR","NOIR"]
[{"$nulls":6},"BLEU"]
[{"$nulls":6},"BLANC"]
[null,"CA_TECHNOLOGIE","CA_TECHNOL","Caractère (17 BYTE)","Technologie du Câble","G657A2_M12","G657A2_M6","Information transmise par le constructeur"]
[{"$nulls":6},"G657A2_M12"]
[null,"CA_NBRFIBREUTILISE","CA_NB_FO_U","NUM (3,0)","Nombre de fibres Utilisées",2]
[null,"CA_NBRFIBREDISPO","CA_NB_FO_D","NUM (3,0)","Nombre de fibres disponibles",70]
[null,"CA_PRO","CA_PRO","Caractère (20 BYTE)","Propriétaire du câble","MANCHE NUMERIQUE","MANCHE NUMERIQUE"]
[null,"CA_GEST","CA_GEST","Caractère (20 BYTE)","Gestionnaire du Câble","NUL","NUL","NUL (pas dans la phase de construction)"]
[null,"CA_DATE_INST","CA_DATE_IN","Date","Date de pose du câble","2014-08-12"]
[null,"CA_COMMENT","CA_COMMENT","Caractère (300 BYTE)","Commentaire",null,null,"Toutes obsevations utiles."]
[null,"CA_STATUT","CA_STATUT","Caractère (14 BYTE)","Statut du rendu","EN ETUDE","EN ETUDE","APS ou APD = En étude"]
[{"$nulls":6},"EN REALISATION","EXE = En réalisation"]
[{"$nulls":6},"EN SERVICE","REC = En service"]
[{"$nulls":6},"HORS SERVICE"]
[]
[]
[]
[{"$nulls":5},{"$f":"LEN(F8)","v":10}]

{"sheet":"EQUIPEMENT_PASSIF","index":5,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[[12,2,16,2],[17,1,22,1],[23,1,26,1],[12,1,16,1],[64,5,67,5],[64,3,67,3],[33,2,37,2],[38,2,48,2],[33,1,37,1],[38,1,48,1],[49,2,53,2],[49,3,53,3],[38,4,48,4],[38,3,48,3],[33,4,37,4],[64,1,67,1],[23,2,26,2],[23,3,26,3],[17,4,22,4],[64,4,67,4],[54,1,60,1],[64,2,67,2],[54,2,60,2],[54,3,60,3],[54,4,60,4],[1,0,67,0],[49,4,53,4],[54,5,60,5],[38,5,48,5],[49,5,53,5],[12,5,16,5],[27,2,32,2],[12,3,16,3],[12,4,16,4],[33,5,37,5],[33,3,37,3],[17,2,22,2],[17,3,22,3],[17,5,22,5],[23,5,26,5],[23,4,26,4],[54,7,60,7],[49,7,53,7],[27,1,32,1],[27,3,32,3],[27,5,32,5],[27,4,32,4],[27,7,32,7],[49,1,53,1]]}
["TABLE","ATTRIBUT","ATTRIBUT SHAPE","FORMAT_CHAMP","DETAIL_CHAMP","EXEMPLE","VALEUR","DETAIL VALEUR"]
[null,"EQ_CODE","EQ_CODE","Caractère (18 BYTE)","Codage d’un boitier transport « BPE »,\"PBO\", \"PEC\", \"DTIO ou PTO\"","BPE–57-001–AC–0050"]
[null,"EQ_NOM","EQ_NOM","Caractère (18 BYTE)","Codage d’un équipement - page 36, paragraphe 6.3 - Guide 2.8","BPE–57-001–AC–0050",null,"Si existant, reprendre code terrain (ex : 107ABPEA01), sinon EQ_CODE"]
[null,"EQ_NOM_NOEUD","EQ_NOM_NOE","Caractère (14 BYTE)","Identifiant du nœud (ref NO_CODE table NOEUD)","CHA-57-001-AC-0050",null,"Code ZAPM + 'NO' + 'incrément alphanumérique sur 4 caractères'"]
[null,"EQ_REF","EQ_REF","Caractère (100 BYTE)","Référence constructeur de la boite",null,null,"FIST GC02 BC6, FIST GC02 BD6"]
[null,"EQ_EMPRISE","EQ_EMPRISE","Caractère (7 BYTE)","NRO de référence","NRO-50-013"]
[null,"EQ_FABRICANT","EQ_FABR","Caractère (100 BYTE)","Fabricant de la boite"]
[null,"EQ_CAPA_FIBRE","EQ_CAPFO","NUM (3,0)","Nombre de fibre maximum du BPE (imposé par modèle)"]
[null,"EQ_NBMAX_EQPMTS","EQ_NBMXEQ","NUM (2,0)","Nombre de cassettes maximum contenues dans la boite"]
[null,"EQ_NBCABLES","EQ_NBCAB","NUM (2,0)","Nombre de câbles entrée/sortie maximum admissibles dans la boite"]
[null,"EQ_DIMENSIONS","EQ_DIMENS","Caractère (50 BYTE)","Longueur x largeur x profondeur en mm ex : « 230x420x150mm »"]
[null,"EQ_TYP_EQPMTS","EQ_TYPEQ","Caractère (100 BYTE)","Types de cassette contenue dans la BPE (ex. slim)"]
[null,"EQ_ETAT","EQ_ETAT","Caractère (1 BYTE)","Etat de l'équipement passif",0,0,"Schéma d'ingénierie"]
[{"$nulls":6},1,"L'infrastructure doit être changée car la moindre intervention peut être préjudiciable à la fourniture du service"]
[{"$nulls":6},2,"Mauvais état général de l'infrastructure qui ne permet pas certaines interventions"]
[{"$nulls":6},3,"Bon état général qui permet de réaliser toute opération de maintenance, d'exploitation ou d'évolution"]
[{"$nulls":6},4,"Non communiqué"]
[null,"EQ_OCCP","EQ_OCCP","Caractère (3 BYTE)","Occupation de l'équipement passif",0,0,"L'infrastructure est vide"]
[{"$nulls":6},"1.1","L'infrastructure est non vide mais exploitable car rangée"]
[{"$nulls":6},"1.2","L'infrastructure est non vide et non exploitable car non rangée"]
[{"$nulls":6},2,"L'infrastructure est saturée"]
[{"$nulls":6},3,"Evaluation impossible, commentaire attendu"]
[{"$nulls":6},4,"Non communiqué"]
[null,"EQ_TYPE","EQ_TYPE","Caractère (3 BYTE)","Type de l'équipement passif","BPE","PBO","Point de Branchement Optique pour raccordement client avec maximum 2 dérivations possible"]
[{"$nulls":6},"PEC","Anciennement PBOE - Point de Branchement Optique pour dérivation (sans raccordement de client)"]
[{"$nulls":6},"BPE","Boîte de Protection d'Epissure"]
[{"$nulls":6},"BAI","Baie de desserte"]
[null,"EQ_TYP_STRUCTUREL","EQ_TYPSTRC","Caractère (16 BYTE)",null,"CHAMBRE","CHAMBRE"]
[{"$nulls":6},"AERIEN"]
[{"$nulls":6},"FACADE"]
[{"$nulls":6},"COLONNE MONTANTE"]
[{"$nulls":6},"PIED IMMEUBLE"]
[{"$nulls":6},"DTIO"]
[null,"EQ_TYPE_LQ","EQ_TYPE_LQ","Caractère (6 BYTE)","Type logique de l'équipement passif","BPE JD","PBO","Point de Branchement Optique - EQ_TYPE = PBO"]
[{"$nulls":6},"BPE JB","Boîte de Protection d'Epissure Joints Blanc - EQ_TYPE = BPE ou PBOE"]
[{"$nulls":6},"BPE JD","Boîte de Protection d'Epissure Joints Droits - EQ_TYPE = BPE ou PBOE"]
[{"$nulls":6},"BAIDC","Baie de desserte client"]
[{"$nulls":6},"BAIOP","Baie opérateur"]
[null,"EQ_TYPE_PH","EQ_TYPE_PH","Caractère (24 BYTE)","Type physique de l'équipement passif","BPE 72EP","PBO 6","Point de Branchement Optique - EQ_TYPE = PBO"]
[{"$nulls":6},"PBO 12","Point de Branchement Optique - EQ_TYPE = PBO"]
[{"$nulls":6},"BPE 12EP","Boîte de Protection d'Epissure Joints Droits - EQ_TYPE = BPE ou PBOE"]
[{"$nulls":6},"BPE 24EP","Boîte de Protection d'Epissure Joints Droits - EQ_TYPE = BPE ou PBOE"]
[{"$nulls":6},"BPE 48EP","Boîte de Protection d'Epissure Joints Droits - EQ_TYPE = BPE ou PBOE"]
[{"$nulls":6},"BPE 72EP","Boîte de Protection d'Epissure Joints Droits - EQ_TYPE = BPE"]
[{"$nulls":6},"BPE 96EP","Boîte de Protection d'Epissure Joints Droits - EQ_TYPE = BPE"]
[{"$nulls":6},"BPE 144EP","Boîte de Protection d'Epissure Joints Droits - EQ_TYPE = BPE"]
[{"$nulls":6},"BPE 288EP","Boîte de Protection d'Epissure Joints Droits - EQ_TYPE = BPE"]
[{"$nulls":6},"BPE 576EP","Boîte de Protection d'Epissure Joints Droits - EQ_TYPE = BPE"]
[{"$nulls":6},"BPE 720EP","Boîte de Protection d'Epissure Joints Droits - EQ_TYPE = BPE"]
[null,"EQ_PRO","EQ_PRO","Caractère (20 BYTE)","Propriétaire","MANCHE NUMERIQUE","MANCHE NUMERIQUE","Si GC neuf, remplir MANCHE NUMERIQUE"]
[{"$nulls":6},"COLLECTIVITE"]
[{"$nulls":6},"ORANGE"]
[{"$nulls":6},"AUTRE (à préciser)"]
[{"$nulls":6},"NUL"]
[null,"EQ_GEST","EQ_GEST","Caractère (20 BYTE)","Gestionnaire de l'équipement passif","MANCHE NUMERIQUE","MANCHE NUMERIQUE","Si GC neuf, remplir NUL"]
[{"$nulls":6},"MANCHE TELECOM"]
[{"$nulls":6},"COLLECTIVITE"]
[{"$nulls":6},"ORANGE"]
[{"$nulls":6},"AUTRE (à préciser)"]
[{"$nulls":6},"MANCHE FIBRE"]
[{"$nulls":6},"NUL"]
[null,"EQ_HAUT","EQ_HAUT","NUMBER(2,2)","Hauteur de l'équipement passif (en mètres)",5.2,null,"Hauteur en mètre entre le sol et la base du nœud. A renseigner dans les cas de supports supérieurs à 1,50m par rapport au sol ou au pallier d'étage "]
[null,"EQ_DATE_INST","EQ_DATE_IN","Date","Date d'installation de l'équipement passif","2012-05-04",null,"JJ/MM/AAAA"]
[null,"EQ_COMMENT","EQ_COMMENT","Caractère (300 BYTE)","Commentaire","EXISTANT",null,"Toutes obsevations utiles. Si réseau existant, indiquez-le dans ce champ là. "]
[null,"EQ_STATUT","EQ_STATUT","Caractère (14 BYTE)","Statut du rendu","EN ETUDE","EN ETUDE","APS ou APD = En étude"]
[{"$nulls":6},"EN REALISATION","EXE = En réalisation"]
[{"$nulls":6},"EN SERVICE","REC = En service"]
[{"$nulls":6},"HORS SERVICE"]

{"sheet":"SITE_GEO","index":6,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,21,0],[15,5,21,5],[15,4,21,4],[15,3,21,3],[15,2,21,2],[15,1,21,1]]}
["TABLE","ATTRIBUT","ATTRIBUT SHAPE","FORMAT_CHAMP","DETAIL_CHAMP","EXEMPLE","VALEUR"]
["SITE_GEO","ID_SITE_LOT",{"$f":"LEFT(B2,10)","v":"ID_SITE_LO"},"EXISTANT","Identifiant du lot de prise","0111_0735"]
[null,"FIRST_NUM_","FIRST_NUM_","EXISTANT","Numéro de rue"]
[null,"FIRST_DIND","FIRST_DIND","EXISTANT","Répétiteur (bis, ter,…)"]
[null,"DNUBAT","DNUBAT","EXISTANT","Numéro de batiment (A, B,…)"]
[null,"DESC_","DESC_","EXISTANT","Numéro de cage d'escalier"]
[null,"FIRST_NOM_","FIRST_NOM_","EXISTANT","Nom de voie"]
[null,"COMMUNE","COMMUNE","EXISTANT","Nom commune"]
[null,"DTELOC","DTELOC","EXISTANT","Type de local (1 maison, 2 appartement, 4 Local commercial ou industriel, 9 Equipement, 0 Local technique)"]
[null,"NB_PRISE","NB_PRISE","EXISTANT","Nombre de prise du lot"]
[null,"T_ETAT","T_ETAT","EXISTANT","Etat de la prise (VALIDE, OBSOLETE, NOUVEAU, FUTUR)"]
[null,"T_ADD_ERDF","T_ADD_ERDF","EXISTANT","Aérien, Souterrain, Aéro-Souterrain, Façade, Non Connu"]
[null,"T_ADD_FT","T_ADD_FT","EXISTANT","Aérien, Souterrain, Aéro-Souterrain, Façade, Non Connu"]
[null,"OPEN_THEME","OPEN_THEME","EXISTANT","DETELOC=9 (Equipement administratif - Equipement de justice - Equipement sanitaire - Equipement funéraire - Equipement social et d'animation -\n Equipement sportif, de loisirs et de tourisme - Equipement d’enseignement - Equipement cultuel - Equipement culturel)\nDETELOC=0 (Activité agricole et d'élevage - Château d'eau - Parc d'éoliennes - Antenne relais - Station d'épuration - Usine de production d'eau potable)"]
[null,"T_OBS","T_OBS","EXISTANT","Observation si besoin"]
[null,"MODIF_ENT","MODIF_ENT","Caractère (300 BYTE)","Idiquer les modifications effectuées par l'entreprise\nSi plusieurs modification, les cumuler ","Modification du nombre de prise","Création"]
[{"$nulls":6},"Suppression"]
[{"$nulls":6},"Déplacement"]
[{"$nulls":6},"Modification du nombre de prise"]
[{"$nulls":6},"Modification du type de prise"]
[{"$nulls":6},"Modification de l'adresse"]
[{"$nulls":6},"Modification de l'adduction"]

{"sheet":"ZAPBO_GEO","index":7,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,5,6,5],[1,0,6,0],[3,1,6,1],[3,2,6,2],[3,3,6,3],[3,4,6,4]]}
["TABLE","ATTRIBUT","ATTRIBUT SHAPE","FORMAT_CHAMP","DETAIL_CHAMP","EXEMPLE","VALEUR","DETAIL VALEUR"]
["ZAPBO_GEO","ID_ZAPBO","ID_ZAPBO","Caractère (10 BYTE)","Identifiant de la ZABPO associée à BPO","107APBOA01",null,"code ZAPM + PBO + incrément alphanumérique sur 3 caractères"]
[null,"COMMENTAIRE","COMMENTAIR","Caractère (254 BYTE)",null,null,null,"A utiliser pour les zapbo ATT_EQ_NOM, ex: futur lotissement"]
[null,"STATUT","STATUT","Caractère (14 BYTE)","Statut du rendu","EN ETUDE","EN ETUDE","APS ou APD = En étude"]
[{"$nulls":6},"EN REALISATION","EXE = En réalisation"]
[{"$nulls":6},"EN SERVICE","REC = En service"]
[{"$nulls":6},"HORS SERVICE"]