Latest Contributions by ChristianWells

You can change the "owner" and "table" variables to be your feature class, table or raster. So if the feature class you want to get information for appears as "gis.abc.polygons" the variable would be: owner = 'abc' table = 'polygons' ... View more

Here is a sample of a single feature class: import arcpy, os, datetime, time gdb = r"Database Connections\Connection to cwells.sde" conn = arcpy.ArcSDESQLExecute(gdb) owner = 'sde' table = 'alex' sql = """SELECT create_date,modify_date FROM sys.tables where UPPER(SCHEMA_NAME(schema_id)) = '{0}' AND   UPPER(OBJECT_NAME(object_id)) = '{1}'""" dates = conn.execute(sql.format(owner.upper(), table.upper())) print (owner + '.' + table).upper() print "Create Date: {0}".format(dates[0][0]) print "Modify Date: {0}".format(dates[0][1]) OUTPUT SDE.ALEX Create Date: 8/3/2015 10:55:11 AM Modify Date: 8/3/2015 11:00:51 AM ... View more

I'm not sure of your exact question, but are you asking if its possible to return a date for a single feature class only? ... View more

Hi Said, This is something that can be done by sending SQL queries to your SDE repository tables to get the created UNIX time from the sde_table_registry and convert that to a more standard time. I have attached a script I have used to perform this in the past and write it out to a logfile. However, this should be enough to get you started on how to access and convert the registration time in your Enterprise Geodatabase. import arcpy, os, datetime, time workPath = r"Database Connections\Connection to cwells.sde" arcpy.CreateDatabaseView_management(workPath, viewName, "select database_name, owner, table_name, registration_date from sde.sde_table_registry") for row in arcpy.SearchCursor(os.path.join(workPath, viewName)):     tableName = row.getValue("DATABASE_NAME") + "." + row.getValue("OWNER") + "." + row.getValue("TABLE_NAME")     cDate = row.getValue("REGISTRATION_DATE")     dTime = time.strftime('%d-%b-%Y %H:%M:%S', time.localtime(cDate)) ... View more

Hi Said, When you say modified date, do you mean table structure or last updated/added row? ... View more

Hi Jake, You could try describing the table prior to the list fields. Once the object is described, look for the dataset ID (DSID) property. Anything not registered with the geodatabase will return -1. If the value doesn't equal or is greater than -1, perform the arcpy.ListFields() operation. >>> tblList = arcpy.ListTables() >>> for tbl in tblList: ...     desc = arcpy.Describe(tbl) ...     print desc.DSID ...     -1 ... View more

Hi Bledar, Can you please post a snippet of the SQL you are using? ... View more

Hi Jose, With a direct connect in SDE command line, you have a few options for the syntax. The -s option is not needed here as this will be grabbed from your Net Service Name (TNS names) or EZ Connect string. If possible, can you please confirm the following?: 1. Is the 64-bit Oracle 11g client installed on this machine? 2. Are you using EZ connect or TNS names? 3. Is your Oracle listener using a port other than 1521? If you are using the EZ connect syntax would be similar to the following: sdemon -o info -I users -i sde:oracle11g:<server>/<SID> -u username -p password If you are using TNS names the syntax would be similar to the following: sdemon -o info -I users -i sde:oracle11g:<TNS Name> -u username -p password ... View more

Hi Stacy, Try out the Assign Default To Field (Data Management) tool. feature_class = "Roads" fields = arcpy.ListFields(feature_class) for field in fields:      if field.name == "Project_Name":           arcpy.AssignDefaultToField_management(feature_class, "Project_Name", "Test_Project") ... View more

Can you please post the results from the following query? select instance_id, instance_name, status from sde.instances; ... View more

Hi Tom, You could try this out in Python using the GetCount_management() tool. import arcpy arcpy.env.workspace = <GDB> fcList = arcpy.ListFeatureClasses() for fc in fcList:      result =  arcpy.GetCount_management(fc)      count = int(result.getOutput(0))      if count == 0:           arcpy.Delete_management(fc) Get Count (Data Management): ArcGIS Help (10.2, 10.2.1, and 10.2.2)  ... View more

Hi Michael, It is possible to do this using arcpy.mapping.Layer(): import arcpy mxd = arcpy.mapping.MapDocument(<mxdFile>) lyr = arcpy.mapping.Layer(<queryLayer>) oldConn = lyr.workspacePath lyr.findAndReplaceWorkspacePath(<newSDEconn>, <oldSDEconn>) mxd.save() Just a note, you won't be able to use the replaceDataSource method for query layers because the dataSource property does not return the name of the tables used in the query layer. lyr = arcpy.mapping.Layer(<queryLayer>) print lyr.dataSource output = u'Database Connections\\ConnectionFile.sde\\SDE.%queryLayer' ... View more

Sounds good. Just something to keep in mind with conversions here is that SQL Server doesn't have support for a Transform or Reproject function. Is it possible to reproject spatial data using SQL Server? ... View more

Hi Aaron, SQL Server does also support STX and STY for the geometry type: STX (geometry Data Type) In addition, are you looking to convert the Feet units of a Projected Coordinate System to Decimal Degrees? Chris ... View more