{"id":221,"date":"2014-11-07T20:06:17","date_gmt":"2014-11-07T20:06:17","guid":{"rendered":"http:\/\/jafma.net\/ana\/theweekendarchaeologist\/?p=221"},"modified":"2015-01-06T21:35:33","modified_gmt":"2015-01-06T21:35:33","slug":"postgresqlpostgis-gvsig-windows-xp","status":"publish","type":"post","link":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/?p=221","title":{"rendered":"PostgreSQL\/PostGIS + gvSIG + Windows XP"},"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%252F221&#038;t=PostgreSQL%2FPostGIS%20%2B%20gvSIG%20%2B%20Windows%20XP&#038;s=100&#038;p&#091;url&#093;=https%3A%2F%2Fjafma.net%2Fana%2Ftheweekendarchaeologist%2Findex.php%3Frest_route%3D%252Fwp%252Fv2%252Fposts%252F221&#038;p&#091;images&#093;&#091;0&#093;=&#038;p&#091;title&#093;=PostgreSQL%2FPostGIS%20%2B%20gvSIG%20%2B%20Windows%20XP\" 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%252F221&#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%252F221&#038;title=PostgreSQL%2FPostGIS%20%2B%20gvSIG%20%2B%20Windows%20XP\" 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%252F221&#038;media=&#038;description=PostgreSQL%2FPostGIS%20%2B%20gvSIG%20%2B%20Windows%20XP\" 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%252F221&#038;title=PostgreSQL%2FPostGIS%20%2B%20gvSIG%20%2B%20Windows%20XP\" 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%20gvSIG%20%2B%20Windows%20XP&#038;body=Check%20this%20out%20%2F%20Mira%20esto:%20https%3A%2F%2Fjafma.net%2Fana%2Ftheweekendarchaeologist%2Findex.php%3Frest_route%3D%252Fwp%252Fv2%252Fposts%252F221\" 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 \/>\nFinalmente, he instalado PostgreSQL\/PostGIS y gvSIG en una m\u00e1quina virtual Windows XP (creo que ya me quedan pocas combinaciones por probar :P). Estos son los puntos principales a tener en cuenta:<\/p>\n<ul>\n<li>Primero he instalado gvSIG 2.1.0.2252 RC2. Los r\u00e1ster los carga bien; en algunos me ha dado problema con la carga con teselado, pero se cargan bien sin esta opci\u00f3n.<\/li>\n<li>La versi\u00f3n de PostgreSQL que he usado es la 9.3, y la versi\u00f3n de PostGIS es la 2.1. He instalado lo m\u00ednimo posible; la instalaci\u00f3n de Apache y phpPgAdmin ha dado error (olvid\u00e9 apuntarlo :(); he permitido que se actualicen las variables de entorno GDAL_DATA,POSTGIS_GDAL_ENABLED_DRIVERS, y POSTGIS_ENABLE_OUTDB_RASTERS.<\/li>\n<li>En esta versi\u00f3n, PostGIS se a\u00f1ade como una extensi\u00f3n una vez creada nuestra base de datos.<\/li>\n<li>Una cosa curiosa ha sido que, al cargar datos en la base de datos desde un fichero .csv, saltaba un error debido a que no ten\u00eda permisos de lectura en el fichero. Buscando un poco, he encontrado <a href=\"http:\/\/forums.enterprisedb.com\/posts\/list\/2819.page\" target=\"_blank\">este foro<\/a> en el que se explicaba la soluci\u00f3n (\u00a1gracias!): copiar el fichero .csv en un directorio visible como &#8220;Documentos Compartidos&#8221;<\/li>\n<li>Para poder usar las opciones de scripting de gvSIG y conectarme con jython a la base de datos, he guardado el .jar con el driver de PostgreSQL (postgresql-9.1-903.jdbc4.jar) en el directorio gvSIG creado en la instalaci\u00f3n, y ha ido todo estupendamente \ud83d\ude42<\/li>\n<\/ul>\n<p><a id=\"english\"><\/a><br \/>\n<a href=\"#spanish\">[En espa\u00f1ol]<\/a><\/p>\n<p>Finally, I have installed PostgreSQL\/PostGIS and gvSIG on a Windows XP virtual machine (I would say that there are not much more possibilites I could try :P). These are the main issues to take into account:<\/p>\n<ul>\n<li>Firstly, I have installed gvSIG 2.1.0.2252 RC2. Raster files are, in general, properly loaded; some files have shown errors if loaded with tiling options, but they load ok if tiling is not used.<\/li>\n<li>Then I have installed PostgreSQL 9.3 and PostGIS 2.1. My installation was minimal; anyway, Apache and phpPgAdmin installation failed (I did not write down which were the errors :(); along the installation process, I updated enviroment variables GDAL_DATA, POSTGIS_GDAL_ENABLED_DRIVERS, and POSTGIS_ENABLE_OUTDB_RASTERS.<\/li>\n<li>In this version, PostGIS is added as an extension, once we have created our database.<\/li>\n<li>A funny issue was that, when I tried to load my data into the database from a .csv file, an error arose because I had not reading permissions on that file. Doing a little research, I found <a href=\"http:\/\/forums.enterprisedb.com\/posts\/list\/2819.page\" target=\"_blank\">this forum<\/a> which explained how to fix it (zanks!): just copy the .csv in a visible folder like &#8220;Shared Documents&#8221;.<\/li>\n<li>In order to use the scripting utilities of gvSIG, and connecting from a jython script to the database, I have placed the .jar file with the PostgreSQL driver (postgresql-9.1-903.jdbc4.jar) in the gvSIG folder (the one created when gvSIG is installed), and everything went fine \ud83d\ude42<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>[In English] Finalmente, he instalado PostgreSQL\/PostGIS y gvSIG en una m\u00e1quina virtual Windows XP (creo que ya me quedan pocas combinaciones por probar :P). Estos son los puntos principales a tener en cuenta: Primero he instalado gvSIG 2.1.0.2252 RC2. Los r\u00e1ster los carga bien; en algunos me ha dado problema con la carga con teselado, &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/?p=221\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;PostgreSQL\/PostGIS + gvSIG + Windows XP&#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],"_links":{"self":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/221"}],"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=221"}],"version-history":[{"count":7,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/221\/revisions"}],"predecessor-version":[{"id":229,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/221\/revisions\/229"}],"wp:attachment":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}