Latest Contributions by George_Thompson

‎01-23-2015

Hi Anand, I think I would contact you Esri Account Manager or Esri Customer Service with licensing specific questions. This may limit possible incorrect responses. -George Customer Service‌

‎01-23-2015

Adding this to the Geodatabase group Geodatabase‌

‎01-20-2015

It looks like the ST_PixelData that is available at 10.2.x is also available at 10.3. Is this the ST_Pixel that you are referencing? I cannot speak for future release of Esri software and support plans. But support for these functions would extend till the version is moved to the "Retired" status.

‎01-20-2015

Yes, ST_Raster is still supported at 10.3. The ST_Raster spatial type is created with a GP Tool or Python script: Create Raster Type Here is the documentation for ST_Raster for Oracle: http://desktop.arcgis.com/en/desktop/latest/manage-data/using-sql-with-gdbs/install-st-raster-oracle.htm There is also a list of functions that return the properties of an ST_Raster value Hopefully this will help.... -George Geodatabase‌

‎01-13-2015

Hi Jose, The upgrade process should not touch the versions in the geodatabase. The upgrade process is usually upgrading the geodatabase repository table, stored procedures, triggers, etc... to add the latest functionality. I would also recommend a reconcile/post on as many versions as possible, then run a compress to clear out the delta tables as much as possible. This will help improve the upgrade process. With that being said, it is recommended that you test the upgrade on a DEV machine first to make sure that everything appears correct after the upgrade and works as expected. Here is some documentation that cover the steps for a successful upgrade to 10.2.x: Preparing to upgrade an Oracle geodatabase Upgrading a geodatabase in Oracle Hopefully this helps. -George

‎12-16-2014

Hi Kris, You may want to look at this blog: Why do Python scripts fail on a machine with both ArcGIS for Server and Desktop installed? It may have to do with pointing to the 64-bit Python libraries and not the 32-bit libraries. Hope this helps! -George

‎12-12-2014

Hi Fiona, When you are storing spatial data in a SQL Server database (non-geodatabase) you are not able to use some of the advanced functionality that makes it a geodatabase. Below is a list of some functions that are able to be performed in the geodatabase, that would not be available within a "regular" SQL Server database. Versioning Esri Replication Multiuser Editing Relationships Mosiac Datasets Editor Tracking Archiving There are many more functions that are available that I have not listed. Here is a site that has a lot of information related to geodatabases and what they can help you accomplish: http://www.esri.com/software/arcgis/geodatabase Hopefully this will give you some more information. -George Geodatabase‌

‎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

Online Status	Offline
Date Last Visited	Thursday

My Ideas

Latest Contributions by George_Thompson

Re: Do we need 2 licenses of Server even if we restrict usage to only 4 cores?

Re: No Data on a db connection

Re: Will ST_RASTER and ST_PIXEL Still be Supported?

Re: Will ST_RASTER and ST_PIXEL Still be Supported?

Re: Preparing to upgrade a geodatabase in Oracle from SDE 9.3 to SDE 10.x

Re: ArcGIS 10.2.1 for Desktop and Server

Re: Why buy an ESRI ArcGIS Server license if SQLServer 2012 can read geometry data types?

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: Esri Community Read-Only Period Begins August ...

Re: Failure to Access the DBMS Server on ArcCatalo...

Re: Roadmap to Get Started with ArcGIS Enterprise

Re: Ward layer for Somerville, MA no longer availa...

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

Esri Certified Individuals

Cloud Computing