0

I intersected 5 shapefiles (you can find the question and data here) to get polygon shapefile. In which, each polygon has ALL the attributes from the 5 layers.

You can find the shapefile resulting from this intersection in this link.

I want to process the attribute table in R. I exported the attribute table as .dbf file. You can find the .dbf file in this link

I tried to import it to R as below

library(foreign)
df <- read.dbf("5layers1.dbf")

I got errors (below) and RStudio crashed so I couldn't get sessionInfo(). enter image description here


As @Vince pointed out below, it is unlikely I will be able to import it to R because of the large size.

Do you have any suggestions how to export large attribute table and import it into R?

  • 2
    Please always add error messages as text within the question body. This makes them legible on all devices, and allows anyone with the same error to locate your question. It's unlikely you will be able to import a dBase file in excess of 2^31-1 bytes, since the format specification does not permit it. – Vince Dec 10 '16 at 14:08
  • The error message is clear: this is an invalid DBF file because it's too large, as @Vince points out. – whuber Dec 10 '16 at 16:43
  • 2
    I'm voting to close this question as off-topic because it's not about GIS. – whuber Dec 10 '16 at 16:43
  • @whuber I think it is not off-topic. I think gis.stackexchange is where many users have large size shapefile and attribute table and I want to consult their experience how to handle large attribute table and what is the best way to export them from arcmap and import them in ArcGIS. – shiny Dec 10 '16 at 22:25
  • 1
    That is not what you are asking: you are just reporting an error reading a file. – whuber Dec 10 '16 at 22:33
1

You could try loading your shapefiles into a file geodatabase, intersecting them there, and accessing the resultant intersect feature class from there using R.

I'm assuming that R can read simple feature classes in file geodatabases via the File Geodatabase API.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.