Latest Contributions by ChristianWells

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

Hi Aaron, Can you try this in SQL Server: select shape, shape.STX as LONG, shape.STY as LAT from sde.fc ... View more

In addition, you can use the following to get out the field name and then feed it back into your row.getValue() statement: fieldName = mxd.dataDrivenPages.pageNameField.name ... View more

Hi Ulises, Try out the following to get the page name in your loop. pageName = mxd.dataDrivenPages.pageRow.getValue(pageNameField) import arcpy mxd = arcpy.mapping.MapDocument(r"C:\Workspace\DELETEME\TestDDP\dds_test.mxd") pageNameField = "<FieldName>" for pageNum in range(1, mxd.dataDrivenPages.pageCount + 1):      pageName = mxd.dataDrivenPages.pageRow.getValue(pageNameField)      print "Exporting page {0} of {1}".format(str(mxd.dataDrivenPages.currentPageID), str(mxd.dataDrivenPages.pageCount))         arcpy.mapping.ExportToPDF(mxd, r"C:\Workspace\DELETEME\TestDDP" + str(pageName) + ".pdf") del mxd ... View more

In this case, you would have to make a connection as SPW_GDBA ... View more

It would depend on who the owner is. If you look in ArcCatalog, what is the fully qualified name of the feature class/table? ... View more

Hi Steve, we would just need to use the account of the data owner. In ArcCatalog, you may see the feature class displayed as "SDE.tblGageData". In this case, "SDE" would be the data owner. To overcome this, the username from the database connection would need to match. ... View more