Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About George_Thompson
George_Thompson
Esri Notable Contributor
since
06-20-2014
14 hours ago
2855
Posts created
997
Kudos given
306
Solutions
1627
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by George_Thompson
|
POST
|
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
... View more
10-14-2014
05:59 AM
|
0
|
0
|
900
|
|
POST
|
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
... View more
10-13-2014
08:00 AM
|
0
|
1
|
2303
|
|
POST
|
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
... View more
09-30-2014
07:58 AM
|
0
|
1
|
2355
|
|
POST
|
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
... View more
09-23-2014
09:32 AM
|
1
|
0
|
1650
|
|
POST
|
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
... View more
09-22-2014
05:27 AM
|
1
|
1
|
1742
|
|
POST
|
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
... View more
09-12-2014
04:47 AM
|
0
|
1
|
1024
|
|
POST
|
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
... View more
08-14-2014
02:38 PM
|
0
|
0
|
304
|
|
POST
|
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.
... View more
08-14-2014
11:59 AM
|
1
|
0
|
1056
|
|
POST
|
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.
... View more
08-14-2014
11:58 AM
|
0
|
0
|
3957
|
|
POST
|
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
... View more
07-09-2014
04:57 AM
|
0
|
0
|
815
|
|
POST
|
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
... View more
07-03-2014
07:57 AM
|
0
|
0
|
1567
|
|
POST
|
I am glad that took care of the client issue. Please mark the post as answered. It will help other people who search. -George
... View more
07-03-2014
05:46 AM
|
0
|
0
|
2186
|
|
POST
|
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
... View more
07-02-2014
12:19 PM
|
1
|
1
|
2186
|
|
POST
|
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
... View more
06-23-2014
05:11 AM
|
0
|
0
|
1182
|
|
POST
|
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
... View more
06-12-2014
12:29 PM
|
0
|
0
|
1560
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 2 | 4 weeks ago | |
| 1 | 4 weeks ago | |
| 1 | 12-03-2025 01:03 PM | |
| 1 | 10-09-2023 07:21 AM | |
| 1 | 10-15-2025 12:52 PM |
Activity Feed
- Kudoed 2025 Staff Engagement Appreciation for JesseCloutier. Friday
- Kudoed Re: What is the difference between Named User licensing for per-machine installations and Named User licensing for per-user installations for Robert_LeClair. Thursday
- Kudoed ArcGIS Blog - Deploy an enterprise geodatabase in Oracle for MarceloMarques. Wednesday
- Kudoed 2025 Esri Community Contest Winners Announced! for JesseCloutier. Wednesday
- Kudoed ArcGIS Pro 3.6 Patch 1 (3.6.1) is now available for KoryKramer. Wednesday
- Kudoed Prepare for ArcGIS Enterprise 12.0: Script to identify caches stored in the deprecated tile cache data store for Sarah_Hanson. 2 weeks ago
- Kudoed Esri Community AI Use Policy for JesseCloutier. 3 weeks ago
- Got a Kudo for Re: Distributed Gdb. 4 weeks ago
- Got a Kudo for Re: Distributed Gdb. 4 weeks ago
- Posted Re: Distributed Gdb on ArcGIS Enterprise Questions. 4 weeks ago
- Got a Kudo for Re: Distributed Gdb. 4 weeks ago
- Posted Re: Distributed Gdb on ArcGIS Enterprise Questions. 4 weeks ago
- Kudoed Re: ArcSOC Optimizer for ArcGIS Monitor - DEPRECATED for AndrewSakowicz. a month ago
- Kudoed ArcGIS Pro Roadmap - November 2025 for KoryKramer. 12-10-2025 03:41 AM
- Kudoed Esri Mid-decade Apportionment Projections for 2030 for LisaBerry. 12-09-2025 03:14 AM
- Posted Re: Issues Reconciling and Posting Versions When Multiple Utility Networks Exist in the Same Enterprise Geodatabase (Insufficient Permissions Error) on ArcGIS Utility Network Questions. 12-08-2025 09:15 AM
- Posted Re: Ballooning Feature Layer Size on ArcGIS Online Questions. 12-08-2025 08:52 AM
- Got a Kudo for Re: Error: Underlying DBMS error [[Microsoft][ODBC Driver 18 for SQL Server][SQL Server] The geometry data type cannot be selected as DISTINCT. 12-04-2025 02:40 PM
- Kudoed Re: Error: Underlying DBMS error [[Microsoft][ODBC Driver 18 for SQL Server][SQL Server] The geometry data type cannot be selected as DISTINCT for TommyJackson. 12-04-2025 01:20 PM
- Posted Re: ArcGIS Pro Oracle Client 12 32 bits and Oracle Client 12 64 bits installed locally on ArcGIS Pro Questions. 12-04-2025 09:06 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
14 hours ago
|