POST
|
That's great Shaun. It's a really necessary piece of software so I'm glad you're actively supporting it. I hate to do it to you, but I've discovered two further issues surrounding date fields. When you use a date type in R, which I can successfully transfer dates to date type from POSIXct, but not POSIXlt, which causes an error. A simple translation to POSIXct prior to writing should fix this. Also, ArcGIS does not seem to honor time zone info, so I actually have to trick Arc when local times are given with time zones by telling it's a GMT time, otherwise it appears to strip the time zone info and present the GMT time only even if it's New York time or whatever. Of course you can convert to text and export, but it then will not be a date field. Sorry to bring you more issues, I think these two probably will be minor issues to deal with, but can be problematic if folks don't realize this is happening. Thanks again, Cheers, Andrew
... View more
08-03-2017
07:12 AM
|
0
|
0
|
793
|
POST
|
Shaun, I double checked what was going on and it's only fields that are listed as logical. I have a number of fields that default to logical in R when I import them from a CSV file. These fields have no data for a particular dataset so it creates them as logical fields which if NA convert to -1 in arc.write. Checking numeric fields these do as you say convert to successfully. So I was not correct. I can of course make sure there are no logical fields, except that if you have a true logical field then -1 may not make sense. I did discover another issue I can't seem to determine a good work around to if you have happen to have a suggestion. When I try to write a character field with more than 255 characters to the File Geodatabase featureclass it fails as it seems to default to field length 255 for a text field in Arc, despite the fact that they can be much larger. Is there a way to either default to a much larger size or specify this in arc.write? The only workaround is to truncate or split among multiple fields which isn't desirable. Thanks for your help. Cheers, Andrew Gilbert
... View more
07-31-2017
09:17 AM
|
0
|
2
|
793
|
POST
|
Hi Shaun I'm not in the office today but I'm trying to write a spatialpointdataframe from R to a point featureclass in a File Geodatabase. I have not tried pulling data the other way. I think both text and integer fields in R are being translated to -1 in the gdb. I need to confirm the integer issue when I get back to my desk. Thanks for the response on this. I've been desperate for a good way to write out to File geodatabase from R and just discovered this. Cheers Andrew Andrew Gilbert Biodiversity Research Institute 276 Canco Rd. Portland, ME 04103 207-839-7600 X205 Sent from my iPhone
... View more
07-28-2017
11:33 AM
|
0
|
0
|
793
|
POST
|
Thanks for putting together the arcgisbinding package, it is very useful. It seems that when converting a spatial dataframe to a file geodatabase, NAs in R are converted to -1 in the file geodatabase. This is a problem on many different levels as -1 may represent a real value that can't be removed if real -1 values are also present. ArcGIS does not appear to use NAs, but they do use the Null value as equivalent. While these are slightly different things in R, it would be much better to convert NAs to real Nulls in the file geodatabase than a -1 which is problematic at best. Can this be fixed in an update to this package? Thanks Andrew
... View more
07-27-2017
06:11 AM
|
0
|
8
|
1161
|
Online Status |
Offline
|
Date Last Visited |
10-25-2021
02:01 PM
|