Le portail francophone de la géomatique

Bonjour,

Je souhaite importer les données edigeo et majic du cadastre via le plugin cadastre sur Qgis. L'import stoppe à un moment. Une boite de dialogue affiche le message suivant. Avez-vous été concerné par ce problème ? Une idée quant à la résolution ?


-- Traitement: local00
INSERT INTO "cadastre".local00
(
local00, annee, ccodep, ccodir, ccocom, invar, ccopre, ccosec, dnupla, dnubat, descr, dniv, dpor, ccoriv, ccovoi, dnvoiri, dindic, ccocif, dvoilib, cleinvar,
assietf, ccpper, codique, parcelle, voie, lot
)
SELECT
  REPLACE(SUBSTRING(tmp,1,3)||SUBSTRING(tmp,7,10),' ','0') AS local00,
  '2024',
  SUBSTRING(tmp,1,2) AS ccodep,
  SUBSTRING(tmp,3,1) AS ccodir,
  SUBSTRING(tmp,4,3) AS ccocom,
  SUBSTRING(tmp,7,10) AS invar,
  SUBSTRING(tmp,36,3) AS ccopre,
  SUBSTRING(tmp,39,2) AS ccosec,
  SUBSTRING(tmp,41,4) AS dnupla,
  SUBSTRING(tmp,46,2) AS dnubat,
  SUBSTRING(tmp,48,2) AS descr,
  SUBSTRING(tmp,50,2) AS dniv,
  SUBSTRING(tmp,52,5) AS dpor,
  SUBSTRING(tmp,57,4) AS ccoriv,

  SUBSTRING(tmp,62,5) AS ccovoi,
  SUBSTRING(tmp,67,4) AS dnvoiri,
  SUBSTRING(tmp,71,1) AS dindic,
  SUBSTRING(tmp,72,4) AS ccocif,
  SUBSTRING(tmp,76,30) AS dvoilib,
  SUBSTRING(tmp,106,1) AS cleinvar,
  SUBSTRING(tmp,108,10) AS assietf,
  SUBSTRING(tmp,125,3) AS ccpper,
  SUBSTRING(tmp,128,7) AS codique,
  REPLACE(SUBSTRING(tmp,1,6)||SUBSTRING(tmp,36,9),' ', '0') AS parcelle,
  REPLACE(SUBSTRING(tmp,1,6)||SUBSTRING(tmp,62,5),' ', '0')||SUBSTRING(tmp,57,4) AS voie,
  'edigeo6924' as lot
FROM "cadastre".bati WHERE SUBSTRING(tmp,31,2) ='00'