{"id":10468,"date":"2023-05-25T10:30:00","date_gmt":"2023-05-25T08:30:00","guid":{"rendered":"https:\/\/www.sigterritoires.fr\/?p=10468"},"modified":"2023-05-21T20:51:00","modified_gmt":"2023-05-21T18:51:00","slug":"cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/","title":{"rendered":"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Entre las diferentes opciones para cargar datos en Postgresql, veremos aqu\u00ed la que, en mi opini\u00f3n, es la m\u00e1s sencilla y r\u00e1pida. Simplemente utilizaremos QGis y su Gestor de Base de Datos.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\">El video est\u00e1 en franc\u00e9s.<\/p>\n\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 class=\"wp-block-paragraph\">Puede encontrar este v\u00eddeo en nuestro canal de Youtube:<a href=\" https:\/\/www.youtube.com\/@sigterritoires\"> https:\/\/www.youtube.com\/@sigterritoires<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cargaremos una capa grande para el ejemplo. La capa Edificios del Topo DB es un buen ejemplo.<\/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 class=\"wp-block-paragraph\">La del departamento 65 contiene 385.880 entidades poligonales. Adem\u00e1s son entidades xyz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vamos a cargar esta capa en una base de datos Postgis bajo 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 class=\"wp-block-paragraph\">Abre el DB Manager 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 class=\"wp-block-paragraph\">Pulse delante del icono PostGIS para comprobar que est\u00e1 conectado a la base de datos PostgreSQL. Si no es as\u00ed, debe ir al panel <strong><em>Explorador-&gt;PostgreSQL<\/em><\/strong> y hacer clic en <strong><em>Nueva conexi\u00f3n<\/em><\/strong>, para definir la base de datos y los permisos de conexi\u00f3n.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vaya al esquema de la base de datos donde desea cargar la nueva tabla, luego en el men\u00fa <strong><em>Tabla <\/em><\/strong>seleccione <strong><em>Importar Capa\/Archivo<\/em><\/strong><\/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 class=\"wp-block-paragraph\">Puedes definir qu\u00e9 datos cargar y d\u00f3nde se cargar\u00e1n. Tambi\u00e9n puedes cambiar la configuraci\u00f3n por defecto.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En este ejemplo, lo \u00fanico interesante que hay que cambiar es la casilla \u00ab\u00a0<strong><em>Crear un \u00edndice espacial<\/em><\/strong>\u00ab\u00a0. Dado el n\u00famero de entidades de la tabla, ser\u00e1 \u00fatil para las consultas espaciales.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Haz clic en <strong><em>Aceptar <\/em><\/strong>y \u00a1listo!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cargar un gran n\u00famero de entidades puede llevar mucho tiempo. A\u00f1ade que el \u00edndice espacial tambi\u00e9n se toma su tiempo, as\u00ed que ten paciencia\u2026<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Espera a que aparezca el mensaje: Importar con \u00e9xito. Entonces ver\u00e1s la nueva capa en el panel izquierdo. Haz clic sobre ella y ver\u00e1s el resultado completo de la operaci\u00f3n.<\/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 class=\"wp-block-paragraph\">Puedes hacer lo mismo en 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 class=\"wp-block-paragraph\">Observar\u00e1s que se trata efectivamente de pol\u00edgonosZ creados.<\/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 class=\"wp-block-paragraph\">El \u00edndice GIST tambi\u00e9n est\u00e1 ah\u00ed. Si desea otros tipos de \u00edndices, tendr\u00e1 que configurarlos directamente con pgAdmin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Entre las diferentes opciones para cargar datos en Postgresql, veremos aqu\u00ed la que, en mi opini\u00f3n, es la m\u00e1s sencilla y r\u00e1pida. Simplemente utilizaremos QGis y su Gestor de Base de Datos.<\/p>\n","protected":false},"author":1,"featured_media":10457,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_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_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1340,1357],"tags":[1987,1983,1985,1989,1365,1367,1369],"class_list":["post-10468","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql-es","category-qgis-es","tag-base-de-datos","tag-cargar","tag-datos","tag-geopackage-es","tag-postgis-es","tag-postgresql-es","tag-qgis-es"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Entre las diferentes opciones para cargar datos en Postgresql, veremos aqu\u00ed la que, en mi opini\u00f3n, es la m\u00e1s sencilla y r\u00e1pida. Simplemente utilizaremos QGis y su Gestor de Base de Datos. El video est\u00e1 en franc\u00e9s. Puede encontrar este v\u00eddeo en nuestro canal de Youtube: https:\/\/www.youtube.com\/@sigterritoires Cargaremos una capa grande para el ejemplo. La\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Atilio Francois\"\/>\n\t<meta name=\"google-site-verification\" content=\"ByXHZUbGNn7RNv-Xk5A-ysTZrM65VLIO2RxfSJ2nIEQ\" \/>\n\t<meta name=\"keywords\" content=\"base de datos,cargar,datos,geopackage,postgis,postgresql,qgis\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Blog SIG &amp; Territoires | le portail des professionnels du SIG\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis | Blog SIG &amp; Territoires\" \/>\n\t\t<meta property=\"og:description\" content=\"Entre las diferentes opciones para cargar datos en Postgresql, veremos aqu\u00ed la que, en mi opini\u00f3n, es la m\u00e1s sencilla y r\u00e1pida. Simplemente utilizaremos QGis y su Gestor de Base de Datos. El video est\u00e1 en franc\u00e9s. Puede encontrar este v\u00eddeo en nuestro canal de Youtube: https:\/\/www.youtube.com\/@sigterritoires Cargaremos una capa grande para el ejemplo. La\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-05-25T08:30:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-05-21T18:51:00+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/atilio.francois\/\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@SigTerritoires\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis | Blog SIG &amp; Territoires\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Entre las diferentes opciones para cargar datos en Postgresql, veremos aqu\u00ed la que, en mi opini\u00f3n, es la m\u00e1s sencilla y r\u00e1pida. Simplemente utilizaremos QGis y su Gestor de Base de Datos. El video est\u00e1 en franc\u00e9s. Puede encontrar este v\u00eddeo en nuestro canal de Youtube: https:\/\/www.youtube.com\/@sigterritoires Cargaremos una capa grande para el ejemplo. La\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@SigTerritoires\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#article\",\"name\":\"Cargar datos de Geopackage en PostgreSQL\\\/PostGis con QGis | Blog SIG & Territoires\",\"headline\":\"Cargar datos de Geopackage en PostgreSQL\\\/PostGis con QGis\",\"author\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.sigterritoires.fr\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/a6-3.png?fit=2351%2C2023&ssl=1\",\"width\":2351,\"height\":2023},\"datePublished\":\"2023-05-25T10:30:00+02:00\",\"dateModified\":\"2023-05-21T20:51:00+02:00\",\"inLanguage\":\"fr-FR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#webpage\"},\"articleSection\":\"PostgreSQL, qgis, base de datos, cargar, datos, geopackage, postgis, postgresql, qgis, Espa\\u00f1ol\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sigterritoires.fr\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/category\\\/postgresql-es\\\/#listItem\",\"name\":\"PostgreSQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/category\\\/postgresql-es\\\/#listItem\",\"position\":2,\"name\":\"PostgreSQL\",\"item\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/category\\\/postgresql-es\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#listItem\",\"name\":\"Cargar datos de Geopackage en PostgreSQL\\\/PostGis con QGis\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#listItem\",\"position\":3,\"name\":\"Cargar datos de Geopackage en PostgreSQL\\\/PostGis con QGis\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/category\\\/postgresql-es\\\/#listItem\",\"name\":\"PostgreSQL\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#person\",\"name\":\"Atilio Francois\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f76dc2a720162999bce81d6c99b6d7b9517d6600ad7ceb5ed5268f02cefaa0ee?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Atilio Francois\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/author\\\/admin\\\/#author\",\"url\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/author\\\/admin\\\/\",\"name\":\"Atilio Francois\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f76dc2a720162999bce81d6c99b6d7b9517d6600ad7ceb5ed5268f02cefaa0ee?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Atilio Francois\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#webpage\",\"url\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/\",\"name\":\"Cargar datos de Geopackage en PostgreSQL\\\/PostGis con QGis | Blog SIG & Territoires\",\"description\":\"Entre las diferentes opciones para cargar datos en Postgresql, veremos aqu\\u00ed la que, en mi opini\\u00f3n, es la m\\u00e1s sencilla y r\\u00e1pida. Simplemente utilizaremos QGis y su Gestor de Base de Datos. El video est\\u00e1 en franc\\u00e9s. Puede encontrar este v\\u00eddeo en nuestro canal de Youtube: https:\\\/\\\/www.youtube.com\\\/@sigterritoires Cargaremos una capa grande para el ejemplo. La\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/author\\\/admin\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.sigterritoires.fr\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/a6-3.png?fit=2351%2C2023&ssl=1\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#mainImage\",\"width\":2351,\"height\":2023},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/es\\\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\\\/#mainImage\"},\"datePublished\":\"2023-05-25T10:30:00+02:00\",\"dateModified\":\"2023-05-21T20:51:00+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#website\",\"url\":\"https:\\\/\\\/www.sigterritoires.fr\\\/\",\"name\":\"Blog SIG & Territoires\",\"description\":\"le portail des professionnels du SIG\",\"inLanguage\":\"fr-FR\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis | Blog SIG & Territoires","description":"Entre las diferentes opciones para cargar datos en Postgresql, veremos aqu\u00ed la que, en mi opini\u00f3n, es la m\u00e1s sencilla y r\u00e1pida. Simplemente utilizaremos QGis y su Gestor de Base de Datos. El video est\u00e1 en franc\u00e9s. Puede encontrar este v\u00eddeo en nuestro canal de Youtube: https:\/\/www.youtube.com\/@sigterritoires Cargaremos una capa grande para el ejemplo. La","canonical_url":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/","robots":"max-image-preview:large","keywords":"base de datos,cargar,datos,geopackage,postgis,postgresql,qgis","webmasterTools":{"google-site-verification":"ByXHZUbGNn7RNv-Xk5A-ysTZrM65VLIO2RxfSJ2nIEQ","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#article","name":"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis | Blog SIG & Territoires","headline":"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis","author":{"@id":"https:\/\/www.sigterritoires.fr\/index.php\/author\/admin\/#author"},"publisher":{"@id":"https:\/\/www.sigterritoires.fr\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?fit=2351%2C2023&ssl=1","width":2351,"height":2023},"datePublished":"2023-05-25T10:30:00+02:00","dateModified":"2023-05-21T20:51:00+02:00","inLanguage":"fr-FR","mainEntityOfPage":{"@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#webpage"},"isPartOf":{"@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#webpage"},"articleSection":"PostgreSQL, qgis, base de datos, cargar, datos, geopackage, postgis, postgresql, qgis, Espa\u00f1ol"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr#listItem","position":1,"name":"Home","item":"https:\/\/www.sigterritoires.fr","nextItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/category\/postgresql-es\/#listItem","name":"PostgreSQL"}},{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/category\/postgresql-es\/#listItem","position":2,"name":"PostgreSQL","item":"https:\/\/www.sigterritoires.fr\/index.php\/es\/category\/postgresql-es\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#listItem","name":"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#listItem","position":3,"name":"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis","previousItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/category\/postgresql-es\/#listItem","name":"PostgreSQL"}}]},{"@type":"Person","@id":"https:\/\/www.sigterritoires.fr\/#person","name":"Atilio Francois","image":{"@type":"ImageObject","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/f76dc2a720162999bce81d6c99b6d7b9517d6600ad7ceb5ed5268f02cefaa0ee?s=96&d=mm&r=g","width":96,"height":96,"caption":"Atilio Francois"}},{"@type":"Person","@id":"https:\/\/www.sigterritoires.fr\/index.php\/author\/admin\/#author","url":"https:\/\/www.sigterritoires.fr\/index.php\/author\/admin\/","name":"Atilio Francois","image":{"@type":"ImageObject","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/f76dc2a720162999bce81d6c99b6d7b9517d6600ad7ceb5ed5268f02cefaa0ee?s=96&d=mm&r=g","width":96,"height":96,"caption":"Atilio Francois"}},{"@type":"WebPage","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#webpage","url":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/","name":"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis | Blog SIG & Territoires","description":"Entre las diferentes opciones para cargar datos en Postgresql, veremos aqu\u00ed la que, en mi opini\u00f3n, es la m\u00e1s sencilla y r\u00e1pida. Simplemente utilizaremos QGis y su Gestor de Base de Datos. El video est\u00e1 en franc\u00e9s. Puede encontrar este v\u00eddeo en nuestro canal de Youtube: https:\/\/www.youtube.com\/@sigterritoires Cargaremos una capa grande para el ejemplo. La","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/www.sigterritoires.fr\/#website"},"breadcrumb":{"@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#breadcrumblist"},"author":{"@id":"https:\/\/www.sigterritoires.fr\/index.php\/author\/admin\/#author"},"creator":{"@id":"https:\/\/www.sigterritoires.fr\/index.php\/author\/admin\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2023\/05\/a6-3.png?fit=2351%2C2023&ssl=1","@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#mainImage","width":2351,"height":2023},"primaryImageOfPage":{"@id":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/#mainImage"},"datePublished":"2023-05-25T10:30:00+02:00","dateModified":"2023-05-21T20:51:00+02:00"},{"@type":"WebSite","@id":"https:\/\/www.sigterritoires.fr\/#website","url":"https:\/\/www.sigterritoires.fr\/","name":"Blog SIG & Territoires","description":"le portail des professionnels du SIG","inLanguage":"fr-FR","publisher":{"@id":"https:\/\/www.sigterritoires.fr\/#person"}}]},"og:locale":"fr_FR","og:site_name":"Blog SIG &amp; Territoires | le portail des professionnels du SIG","og:type":"article","og:title":"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis | Blog SIG &amp; Territoires","og:description":"Entre las diferentes opciones para cargar datos en Postgresql, veremos aqu\u00ed la que, en mi opini\u00f3n, es la m\u00e1s sencilla y r\u00e1pida. Simplemente utilizaremos QGis y su Gestor de Base de Datos. El video est\u00e1 en franc\u00e9s. Puede encontrar este v\u00eddeo en nuestro canal de Youtube: https:\/\/www.youtube.com\/@sigterritoires Cargaremos una capa grande para el ejemplo. La","og:url":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/","article:published_time":"2023-05-25T08:30:00+00:00","article:modified_time":"2023-05-21T18:51:00+00:00","article:publisher":"https:\/\/www.facebook.com\/atilio.francois\/","twitter:card":"summary","twitter:site":"@SigTerritoires","twitter:title":"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis | Blog SIG &amp; Territoires","twitter:description":"Entre las diferentes opciones para cargar datos en Postgresql, veremos aqu\u00ed la que, en mi opini\u00f3n, es la m\u00e1s sencilla y r\u00e1pida. Simplemente utilizaremos QGis y su Gestor de Base de Datos. El video est\u00e1 en franc\u00e9s. Puede encontrar este v\u00eddeo en nuestro canal de Youtube: https:\/\/www.youtube.com\/@sigterritoires Cargaremos una capa grande para el ejemplo. La","twitter:creator":"@SigTerritoires"},"aioseo_meta_data":{"post_id":"10468","title":null,"description":null,"keywords":[],"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-05-21 14:54:02","updated":"2025-06-04 17:05:42","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.sigterritoires.fr\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.sigterritoires.fr\/index.php\/es\/category\/postgresql-es\/\" title=\"PostgreSQL\">PostgreSQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tCargar datos de Geopackage en PostgreSQL\/PostGis con QGis\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.sigterritoires.fr"},{"label":"PostgreSQL","link":"https:\/\/www.sigterritoires.fr\/index.php\/es\/category\/postgresql-es\/"},{"label":"Cargar datos de Geopackage en PostgreSQL\/PostGis con QGis","link":"https:\/\/www.sigterritoires.fr\/index.php\/es\/cargar-datos-de-geopackage-en-postgresql-postgis-con-qgis\/"}],"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-2IQ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/10468","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=10468"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/10468\/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=10468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=10468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=10468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}