Latest Contributions by KenGalliher1

‎04-01-2016

The purpose of this column is to handle complex geometries such as curves. Since a feature class can have only one shape column, the storage of circular geometries must be stored separately and then joined to the feature class when viewed in ArcGIS. I can't seem to find this documented for Postgres but concept is similar for Oracle's SDO geometry and SQL Server Geometry spatial types. SDO_Geometry: -------------------- "Convert noncircular arcs (such as cubic spline or Bézier) to straight-edged linestrings. When the feature class is registered with the CAD entity mask (c), also store the curved representation in SE_ANNO_CAD_DATA." <--- this is the same concept as the GDB_GEOMATTR_DATA column http://resources.arcgis.com/en/help/main/10.2/index.html#//002n0000006t000000#ESRI_SECTION1_E668383C2132433CBB42FE1241484AA8 --------------------

‎03-17-2016

With the exception of directly accessing a geodatabase, I believe most if not all of the requirements listed above could be met in a Runtime for Java app. Maybe not in the sense of installing an "add-in" into an existing application but Java Runtime provides the selection, query and information display functionality needed to build a custom application from scratch that meets these requirements. Outside of the ArcGIS Runtime SDK, one could use the native Java FileWriter to export a JTable to a .csv file. There are other 3rd party packages that can provide this functionality. The key here is data access. If there is access to the data, the functionality exists to select one or more features, query by attributes, display tables of information, display graphs and calculations, etc. Accessing geodatabase data would require ArcGIS Server services, offline geodatabases created from feature services or map packages. The Runtime SDKs do not provide direct geodatabase access. An ArcObjects application would be necessary to accomplish this programmatically. Here are some examples that could be useful in visualizing what this would entail: Runtime SDK examples Find | ArcGIS for Developers Selection mode | ArcGIS for Developers WebMap charts | ArcGIS for Developers Query by attribute | ArcGIS for Developers Offline feature table query | ArcGIS for Developers Local Server feature layer | ArcGIS for Developers Java examples FileWriter (Java Platform SE 7 ) Apache POI - the Java API for Microsoft Documents

‎04-17-2015

Hi Bradley, The Register With Geodatabase tool is available at 10.2.x as well as 10.3. Here's the doc for 10.3 with some Python snippets. Register with Geodatabase—Help | ArcGIS for Desktop Functionality to handle objectids is available with the geoprocessing tool as well: In addition, registering a table with the geodatabase adds an ObjectID field to the table. This field is populated by the geodatabase with unique ID numbers. If you register a table with the geodatabase and the table already contains an ObjectID field, you are presented with a dialog box that allows you to use the existing field or add a new field, ObjectID_1. Hope this helps.

‎04-10-2015

To add to George's statement, here are some updated tech articles and help docs relevant to this discussion: 44300 - Can ArcSDE command line tools be used against 10.3 and newer geodatabases? Migrate from ArcSDE administration commands—Help | ArcGIS for Desktop 10.3 help George Thompson

‎03-16-2015

Yes. Good catch. Thanks.

‎03-16-2015

Adding to Geonet Admin's answer, I used hasattr(class, 'prop') to check each incoming layer had the datasource property. for df in arcpy.mapping.ListDataFrames(mxd): brknList = arcpy.mapping.ListBrokenDataSources(mxd) for bk in brknList: if hasattr(bk, "dataSource"): bk_list.append(bk.dataSource)

‎08-15-2014

In my line of work, I must have at least a working knowledge of each database management system (DBMS) supported by Esri. Other vendors require near-perfect database administrator (DBA) expertise. This means I am constantly looking at error messages. Some I have memorized, but there is no way I will ever be able retain all of them in my memory. So, here are some resources I use for looking up the meaning of those vague return codes. What are yours? Esri FDO Error constants ArcGIS tool errors and warnings SQL Server error messages Oracle error messages PostgreSQL Error Codes I also found this query for SQL Server very useful. SELECT message_id, severity, text FROM sys.messages WHERE language_id = 1033; Ken G. - Geodata Support Analyst

‎06-03-2014

Hi, I realize I'm late to the party here but I thought this could be helpful. It is possible to create your SDE connection file to specifically use a version. To add some detail to jborgion's comment: In ArcGIS 10.0 and earlier, right click on the geodatabase connection and choose Connection Properties. Under Connection Details, change the transaction details. Choose the version you want access. 10.0 Connection Details In version 10.1 and later, right click the geodatabase connection and choose Geodatabase Connection Properties from the context menu. Choose the version you want access. Connecting to a specific geodatabase version 10.1 +

‎03-12-2014

Allow the slection of many individual features in the conflict resolution window. Allow each selected feature to be reconciled the same way.

‎03-12-2014

Allow the slection of many individual features in the conflict resolution window. Allow each selected feature to be reconciled the same way.

‎08-23-2013

Tuning your RDBMS is an important aspect of maintaining your enterprise geodatabase. Two tasks found in all Esri-supported RDBMS are updating DBMS statistics and rebuilding indexes. If you are loading data in bulk or running query-intensive DML operations with SQL, these tasks need to be done more often. Fortunately for us, these tasks are relatively straightforward to accomplish. The scripts found in Esri Knowledge Base Article 24518 provide the SQL to both update statistics and rebuild indexes. NOTE: Oracle databases can be set to automatically update statistics. The SQL Server script in KB24518 is still applicable for geodatabases in SQL Server 2008, 2008R2 and 2012. Also, if you are using ArcGIS 10.2 or 10.1, there are some new geoprocessing tools in the ArcToolbox that can accomplish this:Data Management Tools > Geodatabase Administration > Analyze Datasets: Updates the database statistics of base tables, delta tables, and archive tables, along with the statistics on those tables’ indexes. This tool is used in enterprise geodatabases to help get optimal performance from the RDBMS query optimizer. Stale statistics can lead to poor geodatabase performance.Data Management Tools > Geodatabase Administration > Rebuild Indexes: Updates indexes of datasets and system tables stored in an enterprise geodatabase. This tool is used in enterprise geodatabases to rebuild existing attribute or spatial indexes. Out-of-date indexes can lead to poor geodatabase performance. No matter which one you choose, these resources can be run as automated tasks using SQL, or the ArcToolBox tools can be exported to Python and automated as well.Ken G. - Geodata Support Analyst

‎12-31-2012

Hi mzoch00, It maybe necessary to delete the raster's associated tables from the database. The raster will have several tables that contain the image's information such as blk, aux, bnd, etc. References to the raster object also exist as records in the table_registry geometry_columns and raster_columns tables. These queries below can help identify what needs to be removed. Please be aware that you are deleting entire tables from the database. Please contact Esri Technical Support if you are not comfortable deleting these tables and records. SQL Server: select * from sde.SDE_raster_columns where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.SDE_table_registry where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.SDE_column_registry where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.SDE_geometry_columns where f_table_name = '<raster_name>' and f_table_schema = 'dbo'; select * from sde.SDE_layers where table_name = '<raster_name>' and owner = 'dbo'; 5 SELECT OBJECTID FROM dbo.GDB_ITEMS where PhysicalName = '<db_name>.<owner>.<raster_name>' Oracle: select * from sde.raster_columns where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.table_registry where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.column_registry where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.geometry_columns where f_table_name = '<raster_name>' and f_table_schema = 'dbo'; select * from sde.layers where table_name = '<raster_name>' and owner = 'dbo'; 5 SELECT OBJECTID FROM dbo.GDB_ITEMS where PhysicalName = '<db_name>.<owner>.<raster_name>'

‎07-26-2012

Hi Adrian, Good catch on the BLOB conversion. I'm glad I could help but it looks like you did all the heavy lifting. - Ken

‎07-23-2012

Hi Adrian, You can find the Sql Server logs in the DATA folder typically found in: C:\Program Files\Microsoft Sql Server\MSSQL10_50.MACHINE\MSSQL\DATA. They won't tell you much in direct relation to ArcGIS but they will let you know what Sql Server is complaining about. Can you query the table in Sql Server Management Studio? This is often a datatype problem. Make sure the fields in the table are acceptable and do not contain special characters or reserved words. Make sure you are passing valid datatypes to whatever is going on in the database. Let me know about the query in Sql Server. Ken

‎03-14-2012

Hi Bruce, This procedure is correct. Any time a new feature class is added to a feature dataset, the feature dataset will then need to be registered again. Also, any necessary permissions will need to be re-granted to the feature dataset. See the version 10 help link(still applicable to pre-10 but a little easier to read).............. http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#//00290000003n000000 Hope this helps.

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by KenGalliher1

Re: strange column GDB_GEOMATTR_DATA

Re: Custom add-ins using ArcGIS Runtime SDK for Java

Re: Life without SDE Command Line

Re: Alternatives to using SDE command line tools - Blog Discussion

Re: AttributeError: LayerObject: Get attribute dataSource does not exist

Re: AttributeError: LayerObject: Get attribute dataSource does not exist

Errors, Errors and more Errors

Re: Editing the non default version, how?

Allow the selection of multiple conflicts in the Conflict Resolution window.

Allow the selection of multiple conflicts in the Conflict Resolution window.

Resources for rebuilding indexes and updating statistics in an SDE geodatabase

Re: Error deleting raster in file geodatabase

Re: OLE DB connection to MS SQL 2008 database table

Re: OLE DB connection to MS SQL 2008 database table

Re: Add new feature into versioned dataset - is this the correct way?

Re: A Special Thanks to the ArcGIS API for Python ...

A Special Thanks to the ArcGIS API for Python Comm...

Re: Receiving error "The coordinates or measures a...

Feature Layer This and Feature Service That

Re: Folder.add() no longer always returns a Future...