Latest Contributions by George_Thompson

‎10-14-2014

Hi Erik, This is expected behavior. There are "Some field properties are defined when the table or feature class is created and cannot be changed, including field type, length, precision, and scale." I would recommend creating a new field in long integer and then filed calculate the numbers over to it. The fields with text in then will not work and need to be converted to a number. Hopefully this help! -George GIS‌ Managing Data‌ Geodatabase‌

‎10-13-2014

Hi Duarte, The DLL that you are referencing is not located in the ArcGIS install location. The DLL is located in the ArcSDE for PostgreSQL installation package. I did verify that it is in the BIN folder. Here is the documentation for the installing the ST_Raster function for PostgreSQL: http://resources.arcgis.com/en/help/main/10.2/index.html#//006z000000p8000000 Hopefully this will get you up and running. -George

‎09-30-2014

Hi Travis, How many versions do you have? Do you delete the versions after you reconcile/post them to their parent? Do you have any replicas in the geodatabase? Here is a link that covers how to get a full compress on the geodatabase: http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000s5000000 Hopefully this will help with getting a "full" compress. -George Geodatabase‌

‎09-23-2014

Hi Martin, It is not specifically stated in the system requirements for 9.3.x and SQL Server that SP1 is a certified configuration (http://downloads.esri.com/support/systemrequirements/arcsde_microsoft_sql_server_database_requirements.pdf ). I would say that it is compatible and it falls inline with the Supported Environment Policy. I would also recommend moving the version of your SDE geodatabase to a newer supported version (10.1 SP or newer). Support for 9.3.x products ended in December 2013. Hope that this gives you the necessary information. -George

‎09-22-2014

Both of those files can be found in the ArcSDE for Oracle installation. This can be downloaded from the MyEsri site. You can find the libst_shapelib.so file in the following location for a ArcGIS 10.2.x install: C:\Program Files (x86)\ArcGIS\Desktop10.2\DatabaseSupport\Oracle\Linux64 The libst_raster_ora.so is in the ArcSDE for Oracle install. Here are the directions for setting up and configuring the ST_Raster functions for a local Oracle geodatabase. ArcGIS Help (10.2, 10.2.1, and 10.2.2) -George

‎09-12-2014

Hi Haniu, For each of the spatial data type there may be an appropriate coordinate systems to use. Here is a link to the information ArcGIS and Microsoft Spatial types Usually using the Geometry option is suggested for projected data. For the Geography option: From the help - "You might use the geography storage type with ArcGIS if The coordinate system you want to use is defined in the SQL Server data dictionary. You don't need to store z- or m-values for features. Your data covers large spatial extents and you need to use SQL area and length calculations.The SQL area and length calculations that use Great Elliptic line interpolation can be noticeably different that planar line interpolation over large spatial extents. You need to use Great Elliptic line interpolation for SQL spatial queries." Hopefully this helps. -George

‎08-14-2014

Hi Paul, Are you referring to using ArcSDE service connections to connect to your geodatabase (either version 10.0 or 9.3.1) on SQL Server 2005? You can do it that way, the direct connections are the ones that have issues to SQL Server 2005 with a 10.0 or 9.3.1 geodatabase. But setting up an ArcSDE service connection at 10.2.x is all done manually now. Using ArcSDE service connections @ 10.2 Creating an ArcSDE service @ 10.2

‎08-14-2014

Please be sure to invite other members to this group that are involved or curious about anything geodatabase related. My hope is this group grows with great knowledge and contributors that it will be come it own "fixed" group in the future. As many of you know, there are geodatabase posts in all the different areas of GeoNet. The idea is to have the geodatabase related questions in a "centralized" area to be answered/commented/reviewed by the geodatabase community at large. Please feel free to contact me with any questions.

‎08-14-2014

Please be sure to invite other members to this group that are involved or curious about anything geodatabase related. My hope is this group grows with great knowledge and contributors that it will be come it own "fixed" group in the future. As many of you know, there are geodatabase posts in all the different areas of GeoNet. The idea is to have the geodatabase related questions in "main area to be answered/commented/reviewed by the geodatabase community at large. Please feel free to contact me with any questions.

‎07-09-2014

Was there an error message given in the red bubble? It will be very difficult to troubleshoot with no error message. Have you tried to re-install the SQL Server Native client on the ArcGIS Server machine, I would make sure to use the 64-bit 2012 native client? Also make sure that the ArcGIS Server machine has access to the SQL Server database instance. http://resources.arcgis.com/en/help/main/10.1/index.html#/Registering_your_data_with_ArcGIS_Server_using_Manager/01540000056s000000/ -George

‎07-03-2014

As Vince mentioned there is no direct mechanism for a 10.1 client to connect to a 9.1 enterprise geodatabase. You at least would need to go to a 9.3.x release first then to 10.1 or newer. Client and Geodatabase compatibility. http://resources.arcgis.com/en/help/main/10.1/index.html#//003n00000008000000 You would also need to make sure that you have a supported RDBMS version for each database transition. 9.3.x - Oracle Requirements: http://downloads.esri.com/support/systemrequirements/arcsde_oracle_database_requirements.pdf 10.1 - Oracle Requirements: http://resources.arcgis.com/en/help/system-requirements/10.1/#/Oracle_Database_Requirements/01510000006s000000/ Hope some of this clears up any confusion. -George

‎07-03-2014

I am glad that took care of the client issue. Please mark the post as answered. It will help other people who search. -George

‎07-02-2014

Jose, Be sure to add the 64-bit client for Oracle also. This will explain the details. After you update the PATH variable, you will need to restart the ArcGIS Server instance. Configure a connection to the database in ArcGIS Server: http://resources.arcgis.com/en/help/main/10.2/index.html#//015400000693000000 Install the Oracle Client: http://resources.arcgis.com/en/help/main/10.2/index.html#//002n00000038000000 -George

‎06-23-2014

What type of log files is your instance set up to use? http://resources.arcgis.com/en/help/main/10.2/#/Log_file_table_configuration_options_for_geodatabases_in_Oracle/002n00000014000000/ -George

‎06-12-2014

When you try to publish the MXD as a map service, are you connected to the same database, transaction version (Default, Edit1, Edit2, etc...) and user that is register with ArcGIS Server? Example: Connected to the Mapping geodatabase, looking at the Default version and logged in as the GIS user. If the connection properties are different between the registered database on server and the map source, there might be a conflict and it wants you to register the one that it does not have. This documentation may help also: http://resources.arcgis.com/en/help/main/10.2/index.html#//015400000504000000 Look at the Registering a Database section. Hopefully this will help. -George

Online Status	Online
Date Last Visited	an hour ago

My Ideas

Latest Contributions by George_Thompson

Re: changing field data type

Re: Where is libst_raster_pg.dll for PostgreSQL 9.2?

Re: Sde Not Compressing

Re: SDE 9.3.1 and Windows 2008 R2 SP1

Re: sde tablespace

Re: Coordinate Sys vs spatial Data Type

Re: Geodatabase - MSSQL upload issue

Geodatabase Community

Geodatabase Group

Re: Register versioned geodatabase using ArcGIS Server Manager

Re: ArcSDE 9.1 to ArcSDE 10.1 Documented Differences

Re: ArcGIS Server 10.2.2 error message when registering a database, data store tab

Re: ArcGIS Server 10.2.2 error message when registering a database, data store tab

Re: SDE log file

Re: Publishing Puzzle - Layer's data source is not registered with the server

Re: Error Connecting to Enterprise Geodatabase (SQ...

Re: Question about AD Groups in SQL & permissions

Re: Copying from SHP to Existing GDB FC

Re: ArcGIS Pro Python Toolbox updates enterprise g...

Re: ArcGIS Sites Redirecting to Other Org's Pages

Esri Certified Individuals

Cloud Computing