Latest Contributions by George_Thompson

‎11-12-2014

Hi Kenric, If you are using shapefiles, then they are stored outside of a geodatabase. There is no "rule of thumb" for when to create a new geodatabase to store your data. It depends on many different factors (too many to list here). Here are the limitations for both file geodatabases and enterprise geodatabases: File geodatabase limitations Enterprise geodatabase limitations Hopefully this gives you a starting point to go from. Based on only having 60 feature classes, I would say that a single geodatabase should be fine at this time. -George

‎11-11-2014

Hi Terry, You are correct that support for SQL Server 2014 is not available at 10.2.x releases. Support for SQL 2014 starts with the 10.3 release: SQL Server 2014 for ArcGIS 10.3 As for any serious issues using SQL Server 2014 with ArcGIS 10.2.x or ArcGIS Server there may be some unintended issues that are not documented and may pop up out of the blue and be difficult to resolve, if the environment is not supported. I would recommend waiting to 10.3 final is released before upgrading fully to SQL Server 2014. Hope this helps.... -George

‎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

Online Status	Offline
Date Last Visited	14 hours ago

My Ideas

Latest Contributions by George_Thompson

Re: Geodatabases - How many to create?

Re: Microsoft SQL Server 2014 and ArcGIS 10.2.2

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: recent increase in timeouts from AGOL hosted f...

Re: Is there an outage? Can't open or create any ...

Re: Cannot edit branch versioned data

Re: Are Shape_Length and Shape__Length really the ...

Re: System Log Parser - How does it work?

Esri Certified Individuals

Cloud Computing