Latest Contributions by ChrisGaylor

I've been experimenting with Data Interoperability the past couple of days trying to do a simple GIS to CAD tool. I created a file geodatabase that contains our street centerlines and the street centerlines annotation layers. I want to export these features to an AutoCAD .dwg, but can't seem to get the annotation layer to cooperate. I've followed the steps outlined here: Reading Basic Geodatabase Annotation - GDB to DWG - FME Knowledge Center. However, I still do not get annotation output to the .dwg file, only the lines. In the Translation Log, I see the following message that stands out: Reading table/feature class 'RoadCenterlinesAnno' Geometry type esriGeometryBag is invalid for an annotation. If reading multi-part annotations, please set SPLIT_MULTI_PART_ANNOS to 'yes', or switch to classic geometry mode in order to read each part as a separate feature ... Last line repeated 114 times ... Reading source feature # 7500 Geometry type esriGeometryBag is invalid for an annotation. If reading multi-part annotations, please set SPLIT_MULTI_PART_ANNOS to 'yes', or switch to classic geometry mode in order to read each part as a separate feature ... Last line repeated 791 times ... An annotation feature, for the table 'RoadCenterlinesAnno', was found that is incomplete (or is not actually an annotation). The feature will still be translated, but will not contain any geometry or any annotation specific attributes. Its geodb_type will be set to 'geodb_undefined' ... Last line repeated 2 times ... Geometry type esriGeometryBag is invalid for an annotation. If reading multi-part annotations, please set SPLIT_MULTI_PART_ANNOS to 'yes', or switch to classic geometry mode in order to read each part as a separate feature ... Last line repeated 72 times ... Closing the Geodatabase reader Being new to Data Interoperability, I can't seem to find where to set the 'SPLIT_MULTI_PART_ANNOS' or switch to classic geometry mode. I've also attached an image of my workflow for reference. Does anyone have any tips on getting an annotation layer to convert into a .dwg file or know where I went wrong above? Thanks for the help! ... View more

We've recently migrated to the ESRI platform and are still trying to get all the bugs worked out and everything running properly. When we initially set up our databases in SQL Server 2012, we did not define a maintenance plan. We are at a point now where we need to be maintaining and backing up our databases routinely and I was hoping to automate that process.  I've done some reading on the web and it seems that we need to be performing some maintenance items along the lines of compressing the databases, rebuilding indexes, updating statistics, etc. SQL Server allows me to configure a maintenance plan that will perform these tasks, however, all of the examples show doing these tasks through ArcCatalog. My question is are these tasks better handled in ArcCatalog or in SQL Server? Also, if handled in SQL Server, are there any details/tricks/tips I need to be aware of?  Below is a list of maintenance plan options in SQL Server 2012 for reference: Check Database Integrity, Shrink Database, Reorganize Index, Rebuild Index, Update Statistics, Clean Up History, Execute SQL Server Agent Job, Back Up Database (Full), Back Up Database (Differential), Back Up Database (Transaction Log), Maintenance Cleanup Task Thanks in advance! ... View more