{"id":10450,"date":"2023-05-25T10:30:00","date_gmt":"2023-05-25T08:30:00","guid":{"rendered":"https:\/\/www.sigterritoires.fr\/?p=10450"},"modified":"2023-05-25T10:34:43","modified_gmt":"2023-05-25T08:34:43","slug":"charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis\/","title":{"rendered":"Charger des donn\u00e9es Geopackage dans Postgresql\/Postgis avec QGis"},"content":{"rendered":"\n<p>Parmi les diff\u00e9rentes options pour charger des donn\u00e9es dans Postgresql, nous verrons ici celle qui, \u00e0 mon avis, est la plus simple et rapide. Nous allons tout simplement utiliser QGis et son Gestionnaire de Base de donn\u00e9es.<\/p>\n\n\n<a class=\"wp-block-read-more\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis\/\" target=\"_self\">https:\/\/www.sigterritoires.fr\/index.php\/charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis\/<span class=\"screen-reader-text\">\u00a0: Charger des donn\u00e9es Geopackage dans Postgresql\/Postgis avec QGis<\/span><\/a>\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"jetpack-video-wrapper\"><span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe loading=\"lazy\" class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/3bMFCLiz-4E?version=3&#038;rel=1&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=fr-FR&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span><\/div>\n<\/div><\/figure>\n\n\n\n<p>Retrouvez cette vid\u00e9o sur notre cha\u00eene Youtube: <a href=\"https:\/\/www.youtube.com\/@sigterritoires\">https:\/\/www.youtube.com\/@sigterritoires<\/a><\/p>\n\n\n\n<p>Nous allons charger une couche volumineuse pour l&rsquo;exemple. La couche B\u00e2timents de la BD topo est un bon exemple.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"517\" data-attachment-id=\"10451\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis\/a1-3-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?fit=1909%2C1541&amp;ssl=1\" data-orig-size=\"1909,1541\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"a1-3\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?fit=640%2C517&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?resize=640%2C517&#038;ssl=1\" alt=\"\" class=\"wp-image-10451\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?resize=1024%2C827&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?resize=300%2C242&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?resize=768%2C620&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?resize=1536%2C1240&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?resize=150%2C121&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?resize=186%2C150&amp;ssl=1 186w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?w=1909&amp;ssl=1 1909w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a1-3.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n\n\n\n<p>Celle du d\u00e9partement 65 contient 385 880 entit\u00e9s polygonales. De plus ce sont des entit\u00e9s xyz.<\/p>\n\n\n\n<p>Nous allons charger cette couche dans une base <a href=\"https:\/\/www.sigterritoires.fr\/index.php\/debuter-avec-postgrespostgis\/\">Postgis<\/a> sous PostgreSQL 15.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"416\" data-attachment-id=\"10453\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis\/a2-1-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?fit=3125%2C2033&amp;ssl=1\" data-orig-size=\"3125,2033\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"a2-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?fit=640%2C416&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?resize=640%2C416&#038;ssl=1\" alt=\"\" class=\"wp-image-10453\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?resize=1024%2C666&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?resize=300%2C195&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?resize=768%2C500&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?resize=1536%2C999&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?resize=2048%2C1332&amp;ssl=1 2048w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?resize=150%2C98&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?resize=231%2C150&amp;ssl=1 231w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?w=1280&amp;ssl=1 1280w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a2-1.png?w=1920&amp;ssl=1 1920w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n\n\n\n<p>Ouvrez le gestionnaire de base de donn\u00e9es de QGis<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"487\" data-attachment-id=\"10454\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis\/a3-1-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?fit=1725%2C1313&amp;ssl=1\" data-orig-size=\"1725,1313\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"a3-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?fit=640%2C487&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?resize=640%2C487&#038;ssl=1\" alt=\"\" class=\"wp-image-10454\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?resize=1024%2C779&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?resize=300%2C228&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?resize=768%2C585&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?resize=1536%2C1169&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?resize=150%2C114&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?resize=197%2C150&amp;ssl=1 197w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?w=1725&amp;ssl=1 1725w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a3-1.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n\n\n\n<p>Cliquez devant l&rsquo;ic\u00f4ne PostGIS pour v\u00e9rifier que vous \u00eates bien connect\u00e9s \u00e0 la base de donn\u00e9es PostgreSQL. Sui ce n&rsquo;est pas le cas, vous devez aller dans le panneau explorateur-&gt;PostgreSQL et cliquer sur Nouvelle connexion, pour d\u00e9finir la base de donn\u00e9es et les autorisations de connexion.<\/p>\n\n\n\n<p>Placez vous sur le sch\u00e9ma de la base de donn\u00e9es dans lequel vous voulez charger la nouvelle table, puis dans le menu Table s\u00e9lectionnez Import de couche\/fichier<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a5-1.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"692\" data-attachment-id=\"10456\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis\/a5-1-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a5-1.png?fit=1373%2C1485&amp;ssl=1\" data-orig-size=\"1373,1485\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"a5-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a5-1.png?fit=640%2C692&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a5-1.png?resize=640%2C692&#038;ssl=1\" alt=\"\" class=\"wp-image-10456\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a5-1.png?resize=947%2C1024&amp;ssl=1 947w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a5-1.png?resize=277%2C300&amp;ssl=1 277w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a5-1.png?resize=768%2C831&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a5-1.png?resize=139%2C150&amp;ssl=1 139w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a5-1.png?w=1373&amp;ssl=1 1373w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a5-1.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n\n\n\n<p>Vous pouvez d\u00e9finir les donn\u00e9es \u00e0 charger et o\u00f9 elle seront charg\u00e9es. Vous pouvez aussi modifier les param\u00e8tres par d\u00e9faut.<\/p>\n\n\n\n<p>Dans cet exemple, le seul int\u00e9ressant \u00e0 modifier est la case \u00e0 cocher \u00ab\u00a0Cr\u00e9er un index spatial\u00a0\u00bb. Vu le nombre d&rsquo;entit\u00e9s de la table, il sera forc\u00e9ment utile lors des requ\u00eates spatiales.<\/p>\n\n\n\n<p>Vous cliquez sur OK, et c&rsquo;est parti!<\/p>\n\n\n\n<p>Le chargement de grand nombre d&rsquo;entit\u00e9s peut prendre un temps certain. Ajoutez que l&rsquo;index spatial prend aussi son temps, donc, soyez patient&#8230;<\/p>\n\n\n\n<p>Attendez le message : Importation r\u00e9ussie. Vous verrez alors la nouvelle couche dans le panneau de gauche. Cliquez dessus et vous verrez le r\u00e9sultat complet de l&rsquo;op\u00e9ration.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"551\" data-attachment-id=\"10457\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis\/a6-3-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?fit=2351%2C2023&amp;ssl=1\" data-orig-size=\"2351,2023\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"a6-3\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?fit=640%2C551&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?resize=640%2C551&#038;ssl=1\" alt=\"\" class=\"wp-image-10457\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?resize=1024%2C881&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?resize=300%2C258&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?resize=768%2C661&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?resize=1536%2C1322&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?resize=2048%2C1762&amp;ssl=1 2048w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?resize=150%2C129&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?resize=174%2C150&amp;ssl=1 174w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?w=1280&amp;ssl=1 1280w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?w=1920&amp;ssl=1 1920w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n\n\n\n<p>Vous pouvez faire de m\u00eame dans pgAdmin:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"358\" data-attachment-id=\"10459\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis\/a8-1-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?fit=3553%2C1987&amp;ssl=1\" data-orig-size=\"3553,1987\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"a8-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?fit=640%2C358&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?resize=640%2C358&#038;ssl=1\" alt=\"\" class=\"wp-image-10459\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?resize=1024%2C573&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?resize=300%2C168&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?resize=768%2C430&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?resize=1536%2C859&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?resize=2048%2C1145&amp;ssl=1 2048w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?resize=150%2C84&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?resize=250%2C140&amp;ssl=1 250w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?w=1280&amp;ssl=1 1280w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a8-1.png?w=1920&amp;ssl=1 1920w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n\n\n\n<p>Vous remarquerez que ce sont bien des polygonZ qui ont \u00e9t\u00e9 cr\u00e9\u00e9s.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"324\" data-attachment-id=\"10460\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/charger-des-donnees-geopackage-dans-postgresql-postgis-avec-qgis\/a9-1-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?fit=3073%2C1557&amp;ssl=1\" data-orig-size=\"3073,1557\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"a9-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?fit=640%2C324&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?resize=640%2C324&#038;ssl=1\" alt=\"\" class=\"wp-image-10460\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?resize=1024%2C519&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?resize=300%2C152&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?resize=768%2C389&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?resize=1536%2C778&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?resize=2048%2C1038&amp;ssl=1 2048w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?resize=150%2C76&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?resize=250%2C127&amp;ssl=1 250w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?w=1280&amp;ssl=1 1280w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a9-1.png?w=1920&amp;ssl=1 1920w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n\n\n\n<p>L&rsquo;index de type GIST lui aussi est bien l\u00e0. Si vous souhaitez d&rsquo;autres types d&rsquo;index, il faudra les mettre en place directement avec pgAdmin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Parmi les diff\u00e9rentes options pour charger des donn\u00e9es dans Postgresql, nous verrons ici celle qui, \u00e0 mon avis, est la plus simple et rapide. Nous allons tout simplement utiliser QGis et son Gestionnaire de Base de&hellip;<\/p>\n","protected":false},"author":1,"featured_media":10457,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[311,62],"tags":[198,1981,183,1478,1885,227,312,58],"class_list":["post-10450","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","category-qgis-2","tag-base-de-donnees","tag-chargement","tag-donnees","tag-geopackage","tag-importer","tag-postgis","tag-postgresql","tag-qgis"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?fit=2351%2C2023&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p6XU0A-2Iy","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/10450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/comments?post=10450"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/10450\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media\/10457"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=10450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=10450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=10450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}