Latest Contributions by ChristianWells

‎02-20-2015

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

‎02-20-2015

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.

‎02-20-2015

In your script it appears you are deleting ALL records from the SDE table prior to the insert. Is the goal to remove all the records prior to the insert cursor? If this is such the case, I would not recommend using the Delete Rows command, but rather the Truncate Table command. In SQL, truncate is much more efficient than delete. However, this requires that your table is not registered as versioned.

‎02-10-2015

Hi Pawel, In the error log it appears the Enable Enterprise Geodatabase tool is attempting to create the sde.version table but failing. Can you confirm that the sde user does not already own this object in the database? If the table does exist, it may point to either a geodatabase previously existing there or the tool only partially completing.

‎02-10-2015

What does your export and import command look like? In addition, from your import log do you see any rows being imported? If you are using the imp commands the row import may look like this: . . importing table "A108" 3728 rows imported If you are using the impdp command the row import may look like this: . . imported "SDE"."A108" 17.80 MB 3728 rows

‎01-27-2015

Hi David, Here are what those tables are used for: A##: Versioning changes that have been inserted or updated D##: Versioning changes that have been deleted F##: Feature information for SDEBinary or SDELOB feature classes S##: Geometry information for SDEBinary or SDELOB feature classes ArcGIS Help (10.2, 10.2.1, and 10.2.2) -Chris

‎01-22-2015

There is a good sample on the resource center that will list all the fields, their default value, and any domain assigned. import arcpy fc = <FeatureClass> subtypes = arcpy.da.ListSubtypes(fc) for stcode, stdict in subtypes.iteritems(): print('Code: {0}'.format(stcode)) for stkey in stdict.iterkeys(): if stkey == 'FieldValues': print('Fields:') fields = stdict[stkey] for field, fieldvals in fields.iteritems(): print(' --Field name: {0}'.format(field)) print(' --Field default value: {0}'.format(fieldvals[0])) if not fieldvals[1] is None: print(' --Domain name: {0}'.format(fieldvals[1].name)) else: print('{0}: {1}'.format(stkey, stdict[stkey])) However, if you are only interested in a list of all the domains used within the subtype, we can just list the domains using a similar code: import arcpy fc = <FeatureClass> subtypes = arcpy.da.ListSubtypes(fc) for stcode, stdict in subtypes.iteritems(): print('Code: {0}'.format(stcode)) for stkey in stdict.iterkeys(): if stkey == 'FieldValues': print('Fields with Domains:') fields = stdict[stkey] for field, fieldvals in fields.iteritems(): if not fieldvals[1] is None: print(' --Field name: {0}'.format(field)) print(' --Domain name: {0}\n'.format(fieldvals[1].name)) else: print('{0}: {1}'.format(stkey, stdict[stkey])) Output: Code: 1 Default: True Name: Metal Pipe SubtypeField: SubTypeCD Fields: --Field name: InletWallThickness --Domain name: fcNumericWallThickness --Field name: Material --Domain name: fcMetalMaterial --Field name: PipeDistributor --Domain name: fcPipeDistributor

‎12-11-2014

Currently the only documentation on supportability for OSX is here: What's Coming in ArcGIS | Common Questions Excerpt: "Currently, Esri has no plans to release ArcGIS for Desktop on Mac OS. However, a new application called Explorer for ArcGIS will be released in early Q2, 2014. In its initial release, it will support iOS 7 and be available for download from Apple's App store. In a future release we also plan on bringing this native app to the Android and Mac platforms. The initial release of the app will allow you to discover, use, and share maps in ArcGIS Online and Portal for ArcGIS. A future release will also have authoring capabilities."

‎10-20-2014

To show the output for the Python, can you try and run the the script but at the end, press enter two times to start the script.

‎10-16-2014

Hi Yoshi, you are on the right track for running the python command in the MXD. If you open the Python window and then paste each line into the python window, you should see the following output. The only change that you would need to make is to set arcpy.mapping.MapDocument() to arcpy.mapping.MapDocument("CURRENT"). This will set the mxd in Python to match the current ArcMap session. The output results should print in the same window you are working in. If you want to run this outside of ArcMap, we can use a program called IDLE which is installed with ArcGIS. 1. To get to it, go to the Start Menu > All Programs > ArcGIS > Python 2.7 > IDLE (Python GUI). This should open a new Python shell window. 2. From this window, click File > New. Paste the entire code into this window. 3. Change the path of the MapDocument to match your MXD. Example: mxd = arcpy.mapping.MapDocument(r"C:\Temp\Python.mxd") *make sure that a lowercase "r" is used before the path 4. Save the Python file 5. Click Run > Run Module 6. All the results will be printed on screen Both of the methods are acceptable for running this script. Just remember that in the script provide, you can delete any of the print statements that you don't want to see on the final output. print "Data Frame: " + d.name print "Layer Name: " + lyr.name print "Data Source: " + lyr.dataSource print "Workspace Path: " + lyr.workspacePath

‎10-15-2014

One way that this could be found is by using the arcpy.mapping module to list out all the layers in your MXD. Here is an example of that where it will list both the fully qualified file path and the workspace path: import arcpy mxd = arcpy.mapping.MapDocument("<MXDPath>") df = arcpy.mapping.ListDataFrames(mxd) for d in df: print "Data Frame: " + d.name layers = arcpy.mapping.ListLayers(mxd, "", d) for lyr in layers: print "Layer Name: " + lyr.name print "Data Source: " + lyr.dataSource #This will return the fully qualified path of the file (C:\Shapefiles\femapnls.shp) print "Workspace Path: " + lyr.workspacePath #This will return the workspace path of the file (C:\Shapefiles) Output: Data Frame: Layers Layer Name: FEMA Data Source: C:\Shapefiles\femapnls.shp Workspace Path: C:\Shapefiles Note: This output will be reflect a similar path name if there are raster, csv, dbf, etc. in the MXD (C:\Raster\Aerial.tif)

‎10-14-2014

This can be done using the geometry column of the shapefile to return the length and area in the Calculate Field tool. ArcGIS Help 10.1 import arcpy shp = r"<Path>\<ShapefileName>.shp" arcpy.CalculateField_management(in_table=shp, field="EdgeRatio", expression="!shape.length!/!shape.area!", expression_type="PYTHON_9.3", code_block="#")

‎10-02-2014

Hi Bahram, probably the easiest way to get all the client libraries required is to download them from the my.esri.com portal. However, they can also be downloaded directly from PostgreSQL. The only issue of downloading them directly from PostgreSQL is that the libiconv-2.dll (for Win32) is not included in the PG binaries, this instead comes from the PostGIS install. If you would like to download the client libraries from the my.esri.com you can use the following steps to download the libraries. Log into my.esri.com Click the My Organizations tab Click Products from the Organization ribbon Click Downloads from the Products list 5. Click View Downloads next to your current version of ArcGIS for Desktop 6. Expand the Additional Products tab to download the correct version of the PostgreSQL client

‎10-01-2014

For some users, it is much more efficient to insert data into their SDE feature classes via SQL statements. Although its fairly straightforward to do this for a single feature, it gets a little more complicated when a lot of records need to be inserted while referencing the sde.next_rowid function. However, one way to fulfill the constraints of the primary key and use proper sequencing is to create an iterator in SQL Server. The below example shows how this can be done: -- Truncate the table to have the records inserted TRUNCATE TABLE sde.pipeline_points -- Get the number of rows in the looping table DECLARE @RowCount INT SET @RowCount = (SELECT COUNT(*) FROM [sde].[INPUTTABLE]) -- Declare an iterator DECLARE @iterator INT -- Initialize the iterator SELECT @iterator = MIN(OBJECTID) FROM SDE.INPUTTABLE -- Loop through the rows of a table WHILE @iterator is NOT NULL BEGIN DECLARE @id as integer -- Get OBJECTID value EXEC sde.next_rowid 'sde', 'pipeline_points', @id OUTPUT; -- Insert the data while casting the points geometry INSERT INTO sde.pipeline_points SELECT @id, LATITUDE, LONGITUDE, geometry::STPointFromText('POINT('+str(LONGITUDE, 20, 10) + ' ' + str(LATITUDE, 20, 10) + ')', 4326) as SHAPE FROM [sde].[INPUTTABLE] where objectid = @iterator; -- Update the iterator value SELECT @Iiterator= MIN(OBJECTID) FROM SDE.INPUTTABLE WHERE @iterator < OBJECTID END This script is also helpful for selecting geometries on the fly from the Lat/Long fields within a table without having to use the Display XY tool in ArcMap. SELECT *, geometry::STPointFromText('POINT(' + Str(LONGITUDE, 20, 10) + ' ' + Str(LATITUDE, 20, 10) + ')', 4326) AS shape FROM database.SCHEMA.table

‎09-22-2014

Hi Gustavo, probably the easiest way to get all the client libraries required is to download them from the my.esri.com portal. However, they can also be downloaded directly from PostgreSQL. The only issue of downloading them directly from PostgreSQL is that the libiconv-2.dll (for Win32) is not included in the PG binaries, this instead comes from the PostGIS install. If you would like to download the client libraries from the my.esri.com you can use the following steps to download the libraries. Log into my.esri.com Click the My Organizations tab Click Products from the Organization ribbon Click Downloads from the Products list 5. Click View Downloads next to your current version of ArcGIS for Desktop 6. Expand the Additional Products tab to download the correct version of the PostgreSQL client

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by ChristianWells

Re: Could this be better (data transfer Access -> SDE)?

Re: Could this be better (data transfer Access -> SDE)?

Re: Could this be better (data transfer Access -> SDE)?

Re: ArcGIS for Server + IBM Informix - enable geodatabase error

Re: Importing the oracle .dmp (Dump) file

Re: select layer by location returns empty results

Re: Handling Subtypes in Python

Re: ArcGIS Desktop for OSX

Re: How to print the list of "table of contents (TOC)"

Re: How to print the list of "table of contents (TOC)"

Re: How to print the list of "table of contents (TOC)"

Re: Hi

Re: PostgreSQL client files

Iterating insert geometry statements via T-SQL

Re: I need the download path of the PostgreSQL client files

Re: Future Proofing Your GIS Career

Re: Looking for Guidance: Masters in GIS

The Art of Resumes: Apply These Best Practices

Re: Why aren't more bug reports shared publicly?

Career Strategy, Professional Development, Finding...