{"id":2235,"date":"2019-05-24T21:29:34","date_gmt":"2019-05-25T02:29:34","guid":{"rendered":"http:\/\/linuxitos.com\/main\/?p=2235"},"modified":"2020-11-29T14:03:02","modified_gmt":"2020-11-29T20:03:02","slug":"instalar-shp2pgsql-gui-fedora-30","status":"publish","type":"post","link":"https:\/\/linuxitos.com\/main\/instalar-shp2pgsql-gui-fedora-30\/","title":{"rendered":"Instalar shp2pgsql-gui shape | Fedora 30"},"content":{"rendered":"\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/05\/Screenshot-from-2019-05-24-21-13-21.png\" alt=\"\" class=\"wp-image-2236\" width=\"585\" height=\"740\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/05\/Screenshot-from-2019-05-24-21-13-21.png 529w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/05\/Screenshot-from-2019-05-24-21-13-21-237x300.png 237w\" sizes=\"auto, (max-width: 585px) 100vw, 585px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">shp2pgsql-gui es una interfaz simple que sirve para subir archivos shape a bases de datos con datos georreferenciados, como lo es postgis utilizando postgresql. Es compatible con Fedora 30, aqu\u00ed la configuraci\u00f3n a\u00f1adirlo como plugin a pgAdmin III de PostgreSQL.<\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo dnf install -y shp2pgsql-gui<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Una vez instalado, es posible lanzar la interfaz con el comando<\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">shp2pgsql-gui<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Ahora configurar el plugin para cargarlo directamente en la interfaz de pgAdmin III<\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo gedit \/usr\/share\/pgadmin3\/plugins.d\/plugins.ini<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">A\u00f1adir al final de archivo las siguientes l\u00edneas:<\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">;\n; pgShapeLoader (Linux):\n;\nTitle=PostGIS Shapefile and DBF loader\nCommand=$$PGBINDIR\/shp2pgsql-gui -U $$USERNAME -d $$DATABASE -p $$PORT -h $$HOSTNAME\nDescription=Open a PostGIS ESRI Shapefile or Plain dbf loader console to the current database.\nKeyFile=$$PGBINDIR\/shp2pgsql-gui\nPlatform=unix\nServerType=postgresql\nDatabase=Yes\nSetPassword=No<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"898\" height=\"410\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/05\/Screenshot-from-2019-05-24-21-24-48.png\" alt=\"\" class=\"wp-image-2239\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/05\/Screenshot-from-2019-05-24-21-24-48.png 898w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/05\/Screenshot-from-2019-05-24-21-24-48-300x137.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/05\/Screenshot-from-2019-05-24-21-24-48-768x351.png 768w\" sizes=\"auto, (max-width: 898px) 100vw, 898px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c9stas herramientas son muy espec\u00edficas para trabajos con sistemas de informaci\u00f3n geogr\u00e1fica, sin embargo aqu\u00ed les dejo el post, por si a alguien le gusta.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>shp2pgsql-gui es una interfaz simple que sirve para subir archivos shape a bases de datos con datos georreferenciados, como lo es postgis utilizando postgresql. Es compatible con Fedora 30, aqu\u00ed la configuraci\u00f3n a\u00f1adirlo como plugin a pgAdmin III de PostgreSQL. sudo dnf install -y shp2pgsql-gui Una vez instalado, es posible lanzar la interfaz con el [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[122,1611,1612],"tags":[1613,1614],"class_list":["post-2235","post","type-post","status-publish","format-standard","hentry","category-postgresql","category-shape","category-sig","tag-inegi","tag-sig"],"_links":{"self":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/comments?post=2235"}],"version-history":[{"count":5,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2235\/revisions"}],"predecessor-version":[{"id":2952,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2235\/revisions\/2952"}],"wp:attachment":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media?parent=2235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/categories?post=2235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/tags?post=2235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}