{"id":64,"date":"2014-08-09T06:12:35","date_gmt":"2014-08-09T06:12:35","guid":{"rendered":"http:\/\/jafma.net\/ana\/theweekendarchaeologist\/?p=64"},"modified":"2015-01-06T21:37:14","modified_gmt":"2015-01-06T21:37:14","slug":"postgresqlpostgis-www-sql-designer-gvsig-ii","status":"publish","type":"post","link":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/?p=64","title":{"rendered":"PostgreSQL\/PostGIS + WWW SQL Designer + gvSIG (II)"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-16 synved-social-resolution-single synved-social-provider-facebook nolightbox\" data-provider=\"facebook\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Facebook\" href=\"http:\/\/www.facebook.com\/sharer.php?u=https%3A%2F%2Fjafma.net%2Fana%2Ftheweekendarchaeologist%2Findex.php%3Frest_route%3D%252Fwp%252Fv2%252Fposts%252F64&#038;t=PostgreSQL%2FPostGIS%20%2B%20WWW%20SQL%20Designer%20%2B%20gvSIG%20%28II%29&#038;s=100&#038;p&#091;url&#093;=https%3A%2F%2Fjafma.net%2Fana%2Ftheweekendarchaeologist%2Findex.php%3Frest_route%3D%252Fwp%252Fv2%252Fposts%252F64&#038;p&#091;images&#093;&#091;0&#093;=&#038;p&#091;title&#093;=PostgreSQL%2FPostGIS%20%2B%20WWW%20SQL%20Designer%20%2B%20gvSIG%20%28II%29\" style=\"font-size: 0px; width:16px;height:16px;margin:0;margin-bottom:5px;margin-right:5px;\"><img loading=\"lazy\" decoding=\"async\" alt=\"Facebook\" title=\"Share on Facebook\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"16\" height=\"16\" style=\"display: inline; width:16px;height:16px; margin: 0; padding: 0; border: none; box-shadow: none;\" src=\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/facebook.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-16 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fjafma.net%2Fana%2Ftheweekendarchaeologist%2Findex.php%3Frest_route%3D%252Fwp%252Fv2%252Fposts%252F64&#038;text=Check%20this%20out%20%2F%20Mira%20esto\" style=\"font-size: 0px; width:16px;height:16px;margin:0;margin-bottom:5px;margin-right:5px;\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"16\" height=\"16\" style=\"display: inline; width:16px;height:16px; margin: 0; padding: 0; border: none; box-shadow: none;\" src=\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-16 synved-social-resolution-single synved-social-provider-reddit nolightbox\" data-provider=\"reddit\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Reddit\" href=\"http:\/\/www.reddit.com\/submit?url=https%3A%2F%2Fjafma.net%2Fana%2Ftheweekendarchaeologist%2Findex.php%3Frest_route%3D%252Fwp%252Fv2%252Fposts%252F64&#038;title=PostgreSQL%2FPostGIS%20%2B%20WWW%20SQL%20Designer%20%2B%20gvSIG%20%28II%29\" style=\"font-size: 0px; width:16px;height:16px;margin:0;margin-bottom:5px;margin-right:5px;\"><img loading=\"lazy\" decoding=\"async\" alt=\"reddit\" title=\"Share on Reddit\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"16\" height=\"16\" style=\"display: inline; width:16px;height:16px; margin: 0; padding: 0; border: none; box-shadow: none;\" src=\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/reddit.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-16 synved-social-resolution-single synved-social-provider-pinterest nolightbox\" data-provider=\"pinterest\" target=\"_blank\" rel=\"nofollow\" title=\"Pin it with Pinterest\" href=\"http:\/\/pinterest.com\/pin\/create\/button\/?url=https%3A%2F%2Fjafma.net%2Fana%2Ftheweekendarchaeologist%2Findex.php%3Frest_route%3D%252Fwp%252Fv2%252Fposts%252F64&#038;media=&#038;description=PostgreSQL%2FPostGIS%20%2B%20WWW%20SQL%20Designer%20%2B%20gvSIG%20%28II%29\" style=\"font-size: 0px; width:16px;height:16px;margin:0;margin-bottom:5px;margin-right:5px;\"><img loading=\"lazy\" decoding=\"async\" alt=\"pinterest\" title=\"Pin it with Pinterest\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"16\" height=\"16\" style=\"display: inline; width:16px;height:16px; margin: 0; padding: 0; border: none; box-shadow: none;\" src=\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/pinterest.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-16 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"http:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fjafma.net%2Fana%2Ftheweekendarchaeologist%2Findex.php%3Frest_route%3D%252Fwp%252Fv2%252Fposts%252F64&#038;title=PostgreSQL%2FPostGIS%20%2B%20WWW%20SQL%20Designer%20%2B%20gvSIG%20%28II%29\" style=\"font-size: 0px; width:16px;height:16px;margin:0;margin-bottom:5px;margin-right:5px;\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"16\" height=\"16\" style=\"display: inline; width:16px;height:16px; margin: 0; padding: 0; border: none; box-shadow: none;\" src=\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-16 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=PostgreSQL%2FPostGIS%20%2B%20WWW%20SQL%20Designer%20%2B%20gvSIG%20%28II%29&#038;body=Check%20this%20out%20%2F%20Mira%20esto:%20https%3A%2F%2Fjafma.net%2Fana%2Ftheweekendarchaeologist%2Findex.php%3Frest_route%3D%252Fwp%252Fv2%252Fposts%252F64\" style=\"font-size: 0px; width:16px;height:16px;margin:0;margin-bottom:5px;\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"16\" height=\"16\" style=\"display: inline; width:16px;height:16px; margin: 0; padding: 0; border: none; box-shadow: none;\" src=\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/mail.png\" \/><\/a><p><a id=\"spanish\"><\/a><br \/>\n<a href=\"#english\">[In English]<\/a><br \/>\nRespecto a gvSIG 1.12.0, hay que tener en cuenta que:<\/p>\n<ul>\n<li>Instalar gvSIG sin <em>sudo<\/em> y con <em>jre<\/em> propia (la que tengo por defecto es <em>openjdk<\/em>, y no queda claro que no de problemas)<\/li>\n<li>Para lograr que abra los rasters hay que instalar <em>lib64ncurses5-dev:i386<\/em> y <em>lib64ncurses5:i386<\/em> desde Synaptics (mi Xubuntu es 64 bits)<br \/>\n(averiguado gracias a: http:\/\/osgeo-org.1560.x6.nabble.com\/Solucion-a-Formato-no-valido-al-cargar-un-archivo-raster-Debian-Wheezy-64bit-gvSIG-1-1-y-gvSIG-2-1-td5130483.html)<\/li>\n<li>Otros enlaces que intentan resolver el problema de apertura de los rasters, aunque a m\u00ed no me han servido:<br \/>\n<a href=\"http:\/\/blog.gvsig.org\/2013\/02\/28\/solution-for-gvsig-1-12-problems-in-windows-64bits-operative-systems\/\">Solution for gvSIG 1.12 problems in Windows 64bits operative&nbsp;systems<\/a><br \/>\nhttp:\/\/comments.gmane.org\/gmane.comp.gis.gvsig.user.es\/22669<\/li>\n<li>Ni gvSIG 2.0 ni anteriores soportan PostGIS 2.0; gvSIG 2.1 s\u00ed, y tambi\u00e9n QGIS, OpenJump y uDig. \u00bfC\u00f3mo solucionarlo para gvSIG 1.12.0?<br \/>\nhttp:\/\/mappinggis.com\/2012\/11\/como-conectar-gvsig-con-postgis-2-0\/<\/li>\n<li>Es recomendable, para evitar problemas en la conexi\u00f3n de gvSIG 1.12.0\u00a0 a PostGIS, que las tablas y las columnas est\u00e9n todas en min\u00fasculas: a veces, si el campo mezcla may\u00fasculas y min\u00fasculas, puede no reconocerse en gvSIG.<\/li>\n<\/ul>\n<p><a id=\"english\"><\/a><br \/>\n<a href=\"#spanish\">[En espa\u00f1ol]<\/a><br \/>\nRegarding gvSIG 1.12.0, you should take into account the following issues:<\/p>\n<ul>\n<li>gvSIG should be installed without <em>sudo<\/em> and with a <em>jre<\/em> of its own (my default <em>jre<\/em> is <em>openjdk<\/em>, and some problems could arise).<\/li>\n<li>For opening raster files, you should install <em>lib64ncurses5-dev:i386<\/em> and <em>lib64ncurses5:i386<\/em> from Synaptics (I use a 64 bits Xubuntu version)<br \/>\n(I learned that thanks to [in Spanish] a: http:\/\/osgeo-org.1560.x6.nabble.com\/Solucion-a-Formato-no-valido-al-cargar-un-archivo-raster-Debian-Wheezy-64bit-gvSIG-1-1-y-gvSIG-2-1-td5130483.html)<\/li>\n<li>Some other links for solving that raster issue, though they did not work for me [in Spanish]:<br \/>\n<a href=\"http:\/\/blog.gvsig.org\/2013\/02\/28\/solution-for-gvsig-1-12-problems-in-windows-64bits-operative-systems\/\">Solution for gvSIG 1.12 problems in Windows 64bits operative&nbsp;systems<\/a><br \/>\nhttp:\/\/comments.gmane.org\/gmane.comp.gis.gvsig.user.es\/22669<\/li>\n<li>Neither gvSIG 2.0 nor previous versions work with\u00a0 Postgis 2.0; gvSIG 2.1 does, and also tambi\u00e9n QGIS, OpenJump and uDig.\u00a0 How solve this question for gvSIG 1.12.0 [in Spanish]?<br \/>\nhttp:\/\/mappinggis.com\/2012\/11\/como-conectar-gvsig-con-postgis-2-0\/<\/li>\n<li>In order to avoid problems in the conection between gvSIG 1.12.0\u00a0 and PostGIS,\u00a0 tables and columns should be lower case:\u00a0 in some cases, columns with both lower and upper case may be not recognized in gvSIG.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>[In English] Respecto a gvSIG 1.12.0, hay que tener en cuenta que: Instalar gvSIG sin sudo y con jre propia (la que tengo por defecto es openjdk, y no queda claro que no de problemas) Para lograr que abra los rasters hay que instalar lib64ncurses5-dev:i386 y lib64ncurses5:i386 desde Synaptics (mi Xubuntu es 64 bits) (averiguado &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/?p=64\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;PostgreSQL\/PostGIS + WWW SQL Designer + gvSIG (II)&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[12],"tags":[43,16,14,13,15,17],"_links":{"self":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/64"}],"collection":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=64"}],"version-history":[{"count":7,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/64\/revisions"}],"predecessor-version":[{"id":117,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/64\/revisions\/117"}],"wp:attachment":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}