similar to: reading in mdb and outputting to sql (GIS application)

Hello- Does anyone know if R can read in ESRI file geodatabase feature classes, directly from the file geodatabase? I currently have to export the data out of Arc, to a csv file, then read the csv file. I'd like to bypass this step and read directly from the file geodatabase. Thanks for your help. -al

Hi again, I have played a little more with mdbtools and R. I downloaded the latest version of mdbtools from sourceforge (version 0.6pre1). Quickly scanning the mailing list suggests that ODBC seems to work with PHP but I have not been able to get it to work with R. I can make a connection to the database and when I do a query I get back the names of the rows but not the data. I must admit I have

Hi, Is there is anyway to Open Microsoft .mdb files in open office on Centos 5.3 ? Thanks linux

I need to get read only access to a MDB database accessed from a Linux box using samba, anyone had any luck with this and know how to set it up? Please resist from posting your reasons why and MDB should not be used, I am the converted so stop preaching. The MDB is there to stay and I have to read to it. thanks -- Posted via http://www.ruby-forum.com/.

Hi all, I need to convert a floating point value from Microsoft Basic format to IEEE format. There's a simple way to achieve this in R or I have to write my own function? (e.g. convert the C code below) thanks t #include <string.h> /* for strncpy */ int _fmsbintoieee(float *src4, float *dest4) { unsigned char *msbin = (unsigned char *)src4; unsigned char *ieee

I am trying to use some ms access databases in R (version 1.9.1 or 2.0 on a Debian system). In searching the net for promising software to do this, I found mdbtools. Mdbtools claims the ability to convert schemas and tables in MS Access to MySQL and other databases. http://mdbtools.sourceforge.net/ I'm wondering if anyone in the R community has tried using this software to use

Dear all, I'm trying to connect to an MSAccess database (ArcGIS personal geodatabase). I keep getting an error about the channel when using sqlQuery(). However, sqlTables() does not complain about the channel and lists all tables in the database. If I try sqlFetch(), then R crashes. I'm happy to hear suggestions on how to solve this. Best regards, Thierry > MDB <-

I have a microsoft database that I have read in that is a list of dataframes processed by mdb.get. I am trying to read this into GRASS gis and need to change the labled atomic vectors to double precision- especially the coord.x coord.y. Now is there a way to check for classes and then change them inside of a for loop. This is the code I am using at the moment. library(Hmisc) # Read all tables

Morning everyone, I was hoping to use mdbtools to extract data from some Access databases overnight. I have yum installed the tools from Dag and also downloaded and (eventually!) compiled the latest release from the mdbtools web site, but I either get 'buffer overflow' errors or no output from most of the tools. I have been trying to cvs checkout the latest development version but

Hello I have a problem with my Windows 10 drive connections dropping every 24 hours, very briefly. It's enough to cause me to be unable to save my file, or access a geodatabase. I have followed much trouble shooting and I believe that its due to the KDC Service ticket lifetime expiring, I have it set for 24 hours in smb.conf. I have a Samba 4.9 DC and an Ubuntu 18.04 member file

@Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business. Does anyone have experience doing so? I have used odbtp in the recent past but it is extremely difficult to set up on the linux box as I learned when I recently upgraded from CentOS 4.x to 5.x. Is there another way to get

I posted the following a month ago but have only managed to get to fixing on this over the holidays.? Rowland mentions that I needed to add my domain info, it?s now included and I still have the same issue. Thanks and Happy New YearOld post begins below with edits Hello ? I have a problem with my Windows 10 drive connections dropping every 24 hours, very briefly.? It's enough to cause me to

Dear All, I am really far from a database expert (I do prefer flat files as long as that is reasonable), but I have to deal with an accdb database (Microsoft Access new format). It all stems from the fact that I run R almost exclusively on Debian platforms. I did a bit of googling http://r.789695.n4.nabble.com/How-to-load-data-from-accdb-into-R-td4656613.html

Dear All I would really appreciate some help with a script which a colleague wrote for me, but I am having problems running (and have not been able to contact my colleague). The script is designed to compare the area of suitable habitat in binary projections of a large number of species current and future distributions, and create an excel file detailing the total area suitable in the

Hi Gurus! I have a job that is to get randomly samples from point-based GIS data (sp called shape GIS files) under the total sum resctricted. For example, I would like to take random smaples under the 1000 persons in each city. The randomly sampled persons should not be over 1000 any case. Thank you in advance, -- Kum-Hoe Hwang, Ph.D. Phone : 82-31-250-3283 Email : phdhwang@gmail.com

Hello I have been working with Diva-GIS lately in Windows and I love it. At home I have a Mac so I decided to Install it using the Winebottler. Today I run my antivirus (ClamXav) and It detects a Infection on de DIVA-GIS app "/Applications/DIVA-GIS.app/Contents/Resources/drive_c/windows/system32/drivers/mountmgr.sys:" Does anybody know something about this? This mean that the

Dear All, Has anyone worked with linking R to both ArcView and MapInfo GIS systems? My desire is to capture object selection from GIS and pass to R and to return spatially based statistical model results from R to GIS. If both could simultaneously access the same data file this would be a bonus. My inclination is to put together some routines based on ODBC linking but thought I would seek like

Dear R Community- I am a new user of R. I am using R with GRASS GIS. I would apply svm "on" raster data in GRASS. Basically I have a raster with "areas training" and other three raster (each represents a band of ASTER satellite image). My goal is to classify, according to training areas, the 3 raster. Trying to replicate the guides found on the net, I did the following: #

Dear R list, I'm trying to create an object of class "owin" (observation window) in the package spatstat from GIS mapping data. Here's an example of my problem. Everything goes well until the last line of code. I get the error message shown at the bottom: library(spatstat) library(sp) library(maptools) con <- url("http://gadm.org/data/rda/CHE_adm1.RData") class(con)

Release of revised version of R/GRASS GIS raster and sites data interface. The latest version of the R contributed package "GRASS", release 0.1-6, may be downloaded from CRAN (cran.r-project.org) - contributed packaged section, "Devel" directory, file: GRASS_0.1-6.tar.gz. It may also be downloaded from ftp://reclus.nhh.no/pub/R/GRASS_0.1-6.tar.gz. This version is intended for