How do I join a CSV to an Esri feature class in an oracle dB and write out the matched records to a feature class in a file geodatabase on my local machine?
Solved
How do I join a CSV to an Esri feature class in an oracle dB and write out the matched records to a feature class in a file geodatabase on my local machine?
I'm currently using a CSV reader, Database Joiner and ESRI Geodatabase Writer. The join is working perfectly:
But when I connect the joined output to the geodatabase writer no records are written to the feature class in the file gdb and I get an error saying "Cannot write a non-area feature to an area feature class": I have tried both Drop and Create and Truncate Existing for Table Handling.
Any suggestions are greatly appreciated.
Best answer by hkingsbury
Sorry for the confusion, Yes I'd like the output to be spatial. The dataset I'm joining the CSV to is a polygonal feature class in an oracle enterprise database. I want to join the matching record's attributes of the CSV to an existing buildings dataset and export to a file geodatabase on my local machine.
Is the geometry coming through encoded in an attribute? If it is, you'll need to use a geometryreplacer to turn it spatial.
If its not coming through at all with the databasejoiner, you might need to look at using an oracle reader and join the data with a featuremerger or featurejoiner
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Thanks for your response hkingsbury. Changing to "Table" creates a fgdb table. How do I create a feature class?
A table is a type of feature class. Are you expecting the data to be spatial? In its current form there is no geometry on the feature to make it spatial
Sorry for the confusion, Yes I'd like the output to be spatial. The dataset I'm joining the CSV to is a polygonal feature class in an oracle enterprise database. I want to join the matching record's attributes of the CSV to an existing buildings dataset and export to a file geodatabase on my local machine.
Sorry for the confusion, Yes I'd like the output to be spatial. The dataset I'm joining the CSV to is a polygonal feature class in an oracle enterprise database. I want to join the matching record's attributes of the CSV to an existing buildings dataset and export to a file geodatabase on my local machine.
Is the geometry coming through encoded in an attribute? If it is, you'll need to use a geometryreplacer to turn it spatial.
If its not coming through at all with the databasejoiner, you might need to look at using an oracle reader and join the data with a featuremerger or featurejoiner
This was the issue! The geometry wasn't coming through with databasejoiner. I used an oracle spatial reader and fed both datasets into Featurejoiner and was able to write out a polygonal feature class! Thanks so much hkingsbury I really appreciate the help.