New answers tagged

2

If you don't have Visio for Diagramer- All of the other answers here breaks any joins. I found this to work well in my case: Export the schema for the whole db using Arccatalog (Export - XML) - I didnt export the data, schema only Use some online Pretty Print service to format the xml Open the XML file in a text editor and Reorder the fields as you like ...


1

I'm sure you've moved on since the question was asked but I wanted to pass along a doc on what might be happening here for users who land here. Error: Failed to connect to database. Bad login user. Success when creating a geodatabase using ArcSDE workgroup license. The gist of it is there was a bug at 10.1 (NIM083155) where the SDE Workgroup license ...


0

Simple answer: in the instances, just type: localhost, 5432 Or change to your port number it might be 54321 depending on your installation Colon and semi-colon doesn't work! comma is the answer. I just did it now.


0

The answer was quite simple: do additional joins. SELECT EVENT_ID, ROAD_ID, Event_Status_Description, Strategy_Description, Activity_Description FROM ((TEMP_OWNER.ROADS LEFT OUTER JOIN (SELECT EXTRACTVALUE(CodedValues.COLUMN_VALUE, 'CodedValue/Code') AS Event_Status_Code, ...


1

Try using arcpy to back up your geodatabases. Example: workspace = r"workspace\file\path" arcpy.env.workspace = workspace print "Set Workspace" backup_location = r"new\folder\path" + "\\" + "workspace.gdb" print "Backing up workspace" arcpy.Copy_management(workspace, backup_location) print "Clearing Workspace cache" arcpy.env.workspace = "" ...



Top 50 recent answers are included