Latest Contributions by George_Thompson

‎04-30-2014

Just the geoprocessing history part of the metadata gets deleted. This can become rather large over time. The Documentation field is located in the SDE.GDB_ITEMS table, it is an XML field. I just tested this on a local instance of SQL Server(2012), using ArcGIS Desktop 10.1 SP1 w/QIP installed, and it just deleted the Geoprocessing History for the feature classes that I selected. I verified in the Metadata, for those feature classes, that the geoprocessing section is now empty. I only tested this on a 10.x geodatabase, not a 9.3.x version. System Tables of a Geodatabase in SQL Server Here is a link to a KB article that talks about how to do it via Python: Automate the process of deleting geoprocessing history I would recommend doing this after you have a full, verified backup of the geodatabase or on a test instance. This is in case there are any hiccups during the process. Hopefully this helps clear up some questions.

‎04-30-2014

Matt, I wonder if the geoprocessing history for those two feature classes is getting very large. Every time that you perform a GP process it adds to the metadata. The metadata is stored in a geodatabase system table. You may want to look into this add-in: Delete Geoprocessing History from Metadata Got the link from this post: http://forums.arcgis.com/threads/43399-metadata-geoprocessing-history I would only do this after you have a verified back of the geodatabase. Try it on the two feature classes in question -George

‎04-24-2014

How was the data copied over to the new SQL Server SDE geodatabase? Is the data in the feature dataset versioned? If so, you can not create a network on versioned data. See the tip section: http://resources.arcgis.com/en/help/main/10.2/index.html#/in_ArcCatalog/002r00000009000000/ Can you post a screenshot of the feature classes within the feature dataset that you are creating the network in?

‎04-24-2014

I am wondering if it has to do with the fact that most of the roads are a single polygon and it is creating the errors. There are also a bunch of very small polygons that barely have geometry to them. I think that they may get collapsed when loaded into the SQL geodatabase as part of the check when loading data. I have read you other post (http://forums.arcgis.com/threads/107598-Error-�??line-string-or-poly-boundary-is-self-intersecting�?�-error) and think that these issues are all related. What is you try to split the massive road polygon into smaller pieces for loading?

‎04-23-2014

Jamal, I tested in SQL Server and Oracle and got a different message when copying/pasting into the feature class in either. See attached screenshot. This error seems related to the other forum post that you have. My process was: Start an edit session, open the file geodatabase feature class table, select all features, copy, then paste into the SDE feature class. Hope this helps..... George

‎04-23-2014

Jamal, I noticed that in the third image (from the SDE geodatabase) that there are not feature extent coordinates (Top, bottom, left and right). The the second image (from the file geodatabase) has feature extent coordinates. That may be a direction to look into. I did see that the projections are the same. Just an observation...... George

‎04-18-2014

Hi Kelly, You can use the append geoprocessing tool to combine the tables to a single output table. This may be helpful. I would only recommend running this inside of a model and not in Python, because of the field matching. I tested loading a table in an enterprise geodatabase from tables in two different locations on my PC using the append tool with no issues. http://resources.arcgis.com/en/help/main/10.2/#/Append/001700000050000000/ Hope this helps! I just made it after Richards post..... George T.

‎04-15-2014

Hi Emad, This is expected behavior. Versioned views are created in every feature class that is versioned by design. The below is an exerpt from the help documentation: If you decide to register a feature dataset, stand-alone feature class, or table as versioned with the option to move edits to base, right-click it in the Catalog tree, point to Manage, then click Register As Versioned to open the Register As Versioned dialog box. Check Register the selected objects with the option to move edits to base. Checking this option causes edits that have been saved to the DEFAULT version, whether edited directly or merged from other versions, to be saved in the base (business) tables. Edits to other versions remain in the delta tables when you save. http://A quick tour of registering and unregistering data as versioned -Under the section Registering as versioned with the option to move edits to base. The underlined portion is the important section, if the edits are made to the DEFAULT version they will get pushed to the base table, but if they are made in other versions they remain in the delta tables. What is a versioned view? - http://resources.arcgis.com/en/help/main/10.2/index.html#/What_is_a_versioned_view/006z0000000q000000/ ...Versioned views are automatically created for tables or feature classes that are registered as versioned in ArcGIS 10.1 or later releases..... Hopefully this help! George

‎04-08-2014

Hi Holly, -What version of SQL Server are you using? -What ArcGIS client is being used to copy the feature classes? -What version is your SDE geodatabase in?(10.1, 10.2, 10.2.1, etc..)

‎04-03-2014

Angeleta, What RDBMS and O/S are you using for your 10.0 SDE? Thanks! George

‎03-04-2014

Jose, It sound like you SQL Server database is not a geodatabase. You can have feature classes in your SQL database, the feature geometry is stored as SQL Server Geometry. If you would like to use the full functionality of a geodatabase, I would recommend enabling it. This will allow you to import/export the raster data that you need. Enabling geodatabase functionality in an existing SQL Server database: http://resources.arcgis.com/en/help/main/10.2/#/Enabling_geodatabase_functionality_in_an_existing_SQL_Server_database/002q000000rq000000/

‎02-04-2014

Walter, Using SQL Server Express you are limited to the number of connections that are allowed based on your license level (Workgroup vs. Personal). Even though the server_config table show that 64 connections are allowed, it is limited by SQL Server Express. This is because SQL Server Express is a free product offered by Microsoft (Esri just packages it up to make it easy to find and use). There are also other limitations that SQL Server Express has, for example only using 1GB of RAM and 1 CPU core (Under the section - How is ArcSDE technology included in ArcGIS?: http://resources.arcgis.com/en/help/main/10.2/index.html#//003n00000007000000) Only ArcGIS products (ArcMap, ArcCatalog, ArcGIS for Server, etc..) count as connections to the geodatabase. To see more information on Multiuser Geodatabases visit here: http://www.esri.com/software/arcgis/geodatabase/multi-user-geodatabase If you need more than 10 concurrent connections to the geodatabase, I would recommend looking into to using an Enterprise version of a RBDMS system that is supported with a ArcGIS for Server Enterprise license (Basic, Standard or Advanced). Look under the Relational Database Management Systems tab under the System Requirements page for supported RDBMS versions. ArcGIS for Server Functionality: http://www.esri.com/software/arcgis/arcgisserver/features/functionality-table Hope this helps.... George

‎01-17-2014

Will, When you enable attachments in your geodatabase it creates a relationship class and table that is linked to the source feature class. I would review the following link to see which workflow would be best for you. As for the performance, that is very difficult to estimate as the size of the attachments, RDBMS used, machine specs, etc.... all factor into the performance. An overview of the Attachments toolset: http://resources.arcgis.com/en/help/main/10.2/index.html#/An_overview_of_the_Attachments_toolset/00170000015m000000/ Working with the Attachments geoprocessing tools: http://resources.arcgis.com/en/help/main/10.2/index.html#/Working_with_the_Attachments_geoprocessing_tools/00170000017z000000/

‎01-02-2014

It looks like there is a lock on one of the feature classes that you are trying to apply the domain change to. Verify that there are no other connections/locks on the SDE GDB and try to update the domain. Check to see if any map services are using that SDE database.

‎11-27-2013

Andy, Having that many layers in a map document seems to be overkill. Can some of those layers be combined and symbolized differently based off of attribute data? For example the floodplain polygon data can be in one layer and be symbolized based on the flood zone and floodway fields. How much data is in each layer that is being used? Why do you have 200-300 layers in a map? What is trying to be shown? Maybe look into using group layers and only showing what is needed to complete the map. About displaying layers: http://resources.arcgis.com/en/help/main/10.2/#/About_displaying_layers/00s50000001s000000/ Working with group layers: http://resources.arcgis.com/en/help/main/10.2/#/Working_with_group_layers/00s500000011000000/

Online Status	Offline
Date Last Visited	15 hours ago

My Ideas

Latest Contributions by George_Thompson

Re: Non-versioned data slowing way down

Re: Non-versioned data slowing way down

Re: Failed to build Geometric Network in SDE

Re: Error: �??the coordinates or measure are out of bound�?�,

Re: Error: �??the coordinates or measure are out of bound�?�,

Re: Error: �??the coordinates or measure are out of bound�?�,

Re: I need to merge two dbf tables

Re: versioned view creation - versioning not to base table

Re: Copy Feature SQL DBMS Error Invalid Precision Value

Re: Could not load data from the data source

Re: Upload a raster into SQL Server 2008 using ArcCatalog

Re: Maximum Number of Instances

Re: ArcSDE Size/Performance with Thousands of Attachments

Re: ArcSDE connection error

Re: Layer structure, count and performance

Re: Error: Underlying DBMS error [[Microsoft][ODBC...

Re: I m New to ESRI COMMUNITY

Re: Comparing Monthly Parcel Update to find change...

Re: Identify missing lines between two datasets

Re: How to disable web help

Cloud Computing

Esri Certified Individuals