Latest Contributions by JoseSanchez

Hello everyone, How can I list only Feature Datasets, Feature Classes and Tables owned by a specific owner? I am working on SDE and would like only to select layers owned by a specific account. I am using Python arcpy.ListDatasets Thanks ... View more

Hello everyone, Is this correct ? pRow.set_Value(pRow.Fields.FindField("DATECREATED"), Today) pRow.Store() ... View more

Good afternoon, Database: Ms SQL Server 2014.  When we try to create a table using ArcCatalog in a SQL Server database, we get the following error message:  Failed to create table.DBMS table not found[4252   .... It looks like when creating a table, FC or view with ArcCatalog, it requires to create the table with the account that is logged in as owner. But this specific account was set up in SQL to  create objects as "dbo." Is there a way to create objects in SQL Server that accepts the schema "dbo" instead of the user name.   Error: Failed to create feature class. DBMS table not found [database.user.fcname]  Thanks ... View more

Hello everyone, I am doing some tests. I was able to copy SDE FCs and Tables into a regular SQL server 2014 database using ArcCatalog.  Now I can see these FC in SQL Server using ArcCatalog. It keeps the shape part. Also I was able to create an SDE view in SQL Server. I can not copy Feature Datasets. Then I copied back the FC created in SQL Server to ArcSDE and it seems ok. I was wondering if I can use a regular SQL server database as a intermediate GIS storage for processing and then copy the final result into an SDE instance. Any pros and cons. Thanks ... View more

Hello everyone, How can  I sort the feature class I am reading with a cursor, I would like to sort features  by for example Commission District or Municipality, or Project Number. pCursor = pFeatureClassParcel.Search(Nothing, False) currentFeature = pCursor.NextFeature() ' ' Parcel Found ' Do While Not currentFeature Is Nothing .... currentFeature = pCursor.NextFeature() Loop ... View more

Hello everyone, Is there a way to append feature classes using a SQL Insert statement, running directly  SQL Server, or is it required to run an append in ArcCatalog, Model Builder, Python ... Thanks ... View more

Hello everyone, Any idea of how to check for this error in the database. We are using ArcSDE SQL Server. "Target state not found in the STATES table[STATE_ID = 333001]" Thanks ... View more

Good morning, When running an arcpy.ReconcileVersions_management, s tre a way to place a timeout in the Python script that will stop the reconcile f the feature class is locked. arcpy.ReconcileVersions_management(sdeGeodatabase, "ALL_VERSIONS", PreProdVersion, *****VersionToBeReconciled******, "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_TARGET_VERSION", "POST", "KEEP_VERSION", reconcileLog) ... View more

Hello everyone, What  tools do you recommend to monitor  an SDE SQL Server database that gets locked and it does not allow to open any connection using ArcCatalog. We are using this link to check the locks, but we wil like to monitor the database to prevent these locks: How To: Obtain a listing of user processes and locks from a geodatabase when there is no ArcSDE service  Thanks ... View more

Hello everyone, I am able to call a  HTTP web service from Python using urllib, urllib2. But now I need to add authentication adding the UserID and Password in order to call the another service. This is the existing code: import arcpy, urllib, urllib2, url = r'https://wwww.example.com/GISAddress/Check.asmx/VerifyAddress' values = {'myAddress' : '100 SW 10 street'} data = urllib.urlencode(values) req = urllib2.Request(url, data) response = urllib2.urlopen(req) the_page = response.read() t = ET.fromstring(the_page) Thank you ... View more