I've a question about arcpy List* modules.   I have a quite large amount of data on ArcSDE Server.   Earlier I made a list of the feature classes, and tables in the mxd-s placed there using da.Walk and ListFeatureClasses/ListTableViews.   Now I'd like to list the joined tables too, but I've no further idea how to do it.   Actually is it possible to get these relations?
123641
I have some Python code that is launched from within an ArcMap project. Any joins that the user may have created in the project must be removed in order for my code to run. Unfortunately, the code that removes a join… arcpy.RemoveJoin_management("layer1", "layer2")… also breaks some of the layer properties that are critical to my application (highlighted fields, read-only fields, etc).  If joins are removed by right-clicking the layer in ArcMap and choosing “Remove Joins” the layer properties are left intact.  If I can detect that a join exists from within my code, I will simply exit the code and display a message that the user must manually remove their joins before attempting to run the code. So… Can a Join be detected programmatically?
44341
I am working with ArcGIS Map and using two computer screens. I use the second screen to see my attribute table clearly. But once I disconnect my main computer from the second screen and want to see the attribute table I am not able to see it. Even I restart the computer and try, it is opened somewhere. Again, when I connect my main computer with the second screen, I can see my attribute table there. It creates problem when I have to show my work to team on projector far from my second screen.
9443
I was trying to figure out how to use dynamic text from an attribute table in a collection of Data Driven Pages in ArcGIS 10.   I've looked in the help files, but can't find anything on dynamic text from attribute tables.
93588
I have created a set of general scripting tools for map automation, etc. In one of my tools a geodatabase is created in the workspace folder the script points to. Just out of curiosity, is there any way I can add a folder connection in the ArcMap catalog window once the GDB is created so the user doesn't have to manually create one (assuming they haven't already done so), or is that out of ArcPy's scope?
95690
I've just updated to ArcGIS 10.1 for Desktop and when I go to open an attribute table, I can not see it anywhere.   I'm wondering if it is off my screen somewhere or if its just super tiny that I can't see it.   I'm using dual monitors and it's not popping up on either.  Is there a way I can find my attribute table?
17744
How do I get a list of all the tables defined for the database when using active record?
71048
How can I connect to a PostGIS database from ArcMap using ArcGIS Desktop 9.3 and later?  I would like to be able to perform spatially enabled queries and receive the results back (e.g. spatial and non-spatial joins, filtering etc.) rather than just dumping the contents of a table.  I don't want to use the ArcSDE spatial extensions, I want to use the PostGIS spatial extensions in ArcGIS Desktop.
17297
I would like to use a Python script that is not based on arcpy to do things like  query a shapefile by attributes, create new layer from selection, and calculate areas of a polygon and convert polygons to points.  Anyone have any code examples of using other Python modules or libraries? I am able to do this easily using arcpy but i wanted to explore other options.
80383
I am having trouble formatting my list of figures and list of tables.  Currently, my tex document is printing the list in the following manner:     1 Foreign Key Constraint Problem Due   to Improper Table Design. . . . 3      2 Application Flow of Territory   Maintenance Tool. . . . . . . . . . .   . . 4   But I want to number figures by their sections:     3.1.2 Foreign Key Constraint Problem Due to Improper Table Design
73084
Is there a way of having a list of all the used (active) modules on a site ?  I am in the process of documenting a site and would like to list all the active modules, I know I can take them from admin/modules but there must be another way.
46508
I am trying to populate a folder with ArcSDE database connection files for all the databases within a server instance.  I need to be able to do this for several of our servers.  Although I know within SQL Server how to get a list of DB names from the sys.databases table, using the arcpy function CreateDatabaseConnection I cannot specify "sys" or "master" to make the connection.  Therefore, I need to know the name of a database currently in the server.  I am not sure how to make the check without hard-coding a name.  import arcpy arcpy.env.overwriteOutput = True  #Input the location where the database connection files will be stored connectionLocation = "F:/FolderName"  #Get the list of servers arcpy.CreateDatabaseConnection_management(out_folder_path= arcpy.env.scratchFolder,out_name= "GIS_USERCONFIG" ,database_platform="SQL_SERVER",\                                           instance = "XXXXXXX" ,account_authentication="DATABASE_AUTH",username="user",password="password",\                                           save_user_pass="SAVE_USERNAME",database= "GIS_USERCONFIG",schema="#",version_type="TRANSACTIONAL",version="dbo.DEFAULT",date="#") sdeConn = arcpy.ArcSDESQLExecute(arcpy.env.scratchFolder + "/GIS_USERCONFIG.sde") serverListSQL = sdeConn.execute("Select name from userservers") serverList = [] for i in range(0,len(serverListSQL)):     serverList.append(serverListSQL[i][0])  #Make a folder for each server instance and build the connection files for all DBs in the server instance for server in serverList:     folder = connectionLocation + "/" + server     if arcpy.Exists(folder):         print server + " folder already created"     else:         try:             arcpy.CreateFolder_management(connectionLocation, server)             print "Created Folder " + server         except:             print "failed to create folder " + server      #     arcpy.CreateDatabaseConnection_management(out_folder_path= arcpy.env.scratchFolder,out_name= server ,database_platform="SQL_SERVER",\                                           instance = server ,account_authentication="OPERATING_SYSTEM_AUTH",\                                           database= "master",schema="#",version_type="TRANSACTIONAL",version="dbo.DEFAULT",date="#")     sdeConn = arcpy.ArcSDESQLExecute(arcpy.env.scratchFolder + "/" + server + ".sde")     dbListSQL = sdeConn.execute("Select name from sys.databases")     dbList = []     for i in range(0,len(serverListSQL)):         dbList.append(dbListSQL[i][0])     for db in dbList:         arcpy.CreateDatabaseConnection_management(out_folder_path= folder ,out_name= db,database_platform="SQL_SERVER",\                                           instance = server ,account_authentication="OPERATING_SYSTEM_AUTH",\                                           database= db,schema="#",version_type="TRANSACTIONAL",version="dbo.DEFAULT",date="#")   Basically my issue is with the 2nd call for the function "CreateDatabaseConnection_management" since it needs a database that exists in the database (and I could not use "master or sys").  If you open this as a tool in arcmap, the input is a drop-down box that populates choices based on the databases in the chosen server instance.  Is there a way to do this in the code?
108579
How can I 'LEFT OUTER JOIN' or 'LEFT JOIN' using Views in Drupal 7.  Here is what I'm trying to do, using an :  I have 2 content types: Employee's and Department's (tables below)  The "DepartmentID" noted in the Employee Table below in my case would be the NodeID of the department from the "Department" custom content type.    How can I use Drupal 7's Views module to Display a list of employees with the department name pulled from another content type as noted in the graphic below?  (The SQL statement below is really what I'm hoping to be able to do with the Views module, the table is the output I'm hoping to achieve.)
21406
I have a Python module installed on my system and I'd like to be able to see what functions/classes/methods are available in it. I want to call the help function on each one. In Ruby I can do something like ClassName.methods to get a list of all the methods available on that class. Is there something similar in Python? eg. something like: from somemodule import foo print(foo.methods)  # or whatever is the correct method to call
113993
What are the rules for naming valid feature classes and tables in ArcGIS Desktop, and is there any supporting document which can explain all the dataset naming limitations?
3437
I will be writing scripts for ArcGIS Desktop in Python with ArcPy.   Is there a community or open source project where code and models can be shared?
46655
I'm wondering if there is any method to preserve the original field names in ArcGIS when I join csv. tables to a Shapefile.  I ask, because sometimes I  join tables with 10, 20 or even more columns and when exporting the joined data ArcGIS always renames them according to the name of the original table and the order of the column (e.g. table_xy_1,table_xy_2, etc.).  Since there is no easy way to rename the fields in the attribute table permanently (i.e. you have to create a new column and copy the old on into this new column AND delete the old column) this creates a bunch of work (despite from the fact that you have to orientate yourself in this mess of field names).
51342
Is it possible to include the tag-wiki associations in the Data Explorer? To do this would require two additional columns in the postTags table that associate a tag wiki excerpt and a tag wiki to their tag.  The tag wiki data is already available in the posts table. But there is no way to associate this data with its tags. The SEDE schema lacks the required columns to link the tag excerpt and the tag wiki to the tags table.  Additionally, the postTypes table only lists three posts types. It makes no mention of tag-wiki and tag excerpt posts. Perhaps the postypes table can be updated to reflect the additional post types?