{"id":494,"date":"2015-10-05T11:16:51","date_gmt":"2015-10-05T11:16:51","guid":{"rendered":"http:\/\/jafma.net\/ana\/theweekendarchaeologist\/?p=494"},"modified":"2015-10-07T16:04:54","modified_gmt":"2015-10-07T16:04:54","slug":"r-rstudio-postgis-xubuntu-14-04debian-jessie","status":"publish","type":"post","link":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/?p=494","title":{"rendered":"R + RStudio + PostGIS + Xubuntu 14.04\/Debian jessie"},"content":{"rendered":"\"Facebook\"<\/a>\"twitter\"<\/a>\"reddit\"<\/a>\"pinterest\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>

<\/a>
\n[In English]<\/a><\/p>\n

Estos son los pasos para poder obtener datos de una base de datos PostGIS desde RStudio trabajando en Xubuntu 14.04 o en Debian jessie:<\/p>\n

    \n
  1. Deben estar instaladas las librer\u00edas libgeos<\/em>, libgeos-c1<\/em>, libgeos-dev<\/em> y libgeos++-dev<\/em>; las dos primeras ya las ten\u00eda instaladas tanto en Xubuntu como en jessie, pero las dos \u00faltimas las he tenido que a\u00f1adir desde Synaptics, seg\u00fan se indica en este enlace de AskUbuntu<\/a>.<\/li>\n
  2. En RStudio, hay que instalar y despu\u00e9s cargar los paquetes RPostgreSQL<\/em>, rgeos<\/em> y sp<\/em>.<\/li>\n
  3. Despu\u00e9s hay que crear la conexi\u00f3n a la base de datos:\n

    drv <- dbDriver(“PostgreSQL”)<\/em><\/p>\n

    con<- dbConnect(drv,dbname=’tuBD’,host=’localhost’,port=5432,user=’tuUsuario’,password=’tuPw’)<\/em><\/p>\n<\/li>\n

  4. Para obtener datos que utilicen informaci\u00f3n extra\u00edda de una tabla con datos espaciales, deben usarse las funciones PostGIS habituales de acceso a geometr\u00edas:<\/li>\n<\/ol>\n

    data <- dbGetQuery(con,”SELECT nongeocolumn, ST_AsText(geocolumn) FROM yourtable”)<\/em><\/p>\n

    Una vez finalizado el trabajo con la BD, se cierran conexi\u00f3n y driver:<\/p>\n

    dbDisconnect(con)<\/em>
    \ndbUnloadDriver(drv)<\/em><\/p>\n

    Los pasos 2-4 est\u00e1n explicados en este enlace de R-bloggers<\/a>. A partir de \u00e9l he subido a Github<\/a> un peque\u00f1o script R\u00a0(accessDB.R<\/em>) que realiza la instalaci\u00f3n y carga de paquetes, y la conexi\u00f3n a la base de datos.<\/p>\n

    <\/a>
    \n    [En espa\u00f1ol]<\/a><\/p>\n

    These are the steps for retrieving data from a PostGIS database using RStudio under Xubuntu 14.04 or under Debian jessie:<\/p>\n

      \n
    1. Libraries libgeos<\/em>, libgeos-c1<\/em>, libgeos-dev<\/em> y libgeos++-dev<\/em> must be installed; both Xubuntu and jessie had the first two of them installed, but I had to add the last ones from Synaptics, as it is explained in this link at AskUbuntu<\/a>.<\/li>\n
    2. In RStudio, you have to install and then load RPostgreSQL<\/em>, rgeos<\/em> y sp <\/em>packages.<\/li>\n
    3. After that, you have to create the connection to the database:\n

      drv <- dbDriver(“PostgreSQL”)<\/em><\/p>\n

      con<- dbConnect(drv,dbname=’yourDB’,host=’localhost’,port=5432,user=’yourUser’,password=’yourPw’)<\/em><\/p>\n<\/li>\n

    4. In order to get\u00a0 information from tables which store geospatial data, you have to use the usual PostGIS functions for handling geometries:<\/li>\n<\/ol>\n

      data <- dbGetQuery(con,”SELECT nongeocolumn, ST_AsText(geocolumn) FROM yourtable”)<\/em><\/p>\n

      Once the work with the DB is finished, connection and driver must be closed:<\/p>\n

      dbDisconnect(con)<\/em>
      \ndbUnloadDriver(drv)<\/em><\/p>\n

      Steps 2-4 are explained in this link at R-bloggers<\/a>. From the content in this post I have uploaded to Github<\/a> a little R script (accessDB.R<\/em>) that installs and load the required packages, and then connects to a database.<\/p>\n

       <\/p>\n","protected":false},"excerpt":{"rendered":"

      [In English] Estos son los pasos para poder obtener datos de una base de datos PostGIS desde RStudio trabajando en Xubuntu 14.04 o en Debian jessie: Deben estar instaladas las librer\u00edas libgeos, libgeos-c1, libgeos-dev y libgeos++-dev; las dos primeras ya las ten\u00eda instaladas tanto en Xubuntu como en jessie, pero las dos \u00faltimas las he … <\/p>\n

      Continue reading “R + RStudio + PostGIS + Xubuntu 14.04\/Debian jessie”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[12,20],"tags":[14,13,21],"_links":{"self":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/494"}],"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=494"}],"version-history":[{"count":10,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/494\/revisions"}],"predecessor-version":[{"id":533,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/494\/revisions\/533"}],"wp:attachment":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}