+2I'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
+55You're trying to write non spatial features to a spatial (polygon) layer.
You'll need to change the Geometry in your writer to "Table"
+2Thanks for your response hkingsbury. Changing to "Table" creates a fgdb table. How do I create a feature class?
+55Thanks 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
+2Sorry 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.
+55Sorry 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
+2This 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
