Latest Contributions by KevinYanuk

No.  You can set the env workspace to your SDE connection. And by the way, it's 'management'. Great thanks - and oops 😛 EDIT: This has happened to me before -- it hangs up on arcpy.Rename_management() and doesn't work when trying to do this on SDE. I can always use C# or something, but this only took a few minutes to throw together, I don't know why it hangs up. ... View more

What do you get when you do this? _feature.get_Value(_feature.Fields.FindField("MYFIELD")).ToString() cannot perform the operator on "object" and "double" If the value in the field is null, you will not be able to cast it to double.  When there is a null value in a field, .net returns a dbnull.value which cannot be cast to a double even if the field type is double.  Perhaps this is the problem. Ah, I believe this is probably the case.  I will have to check tomorrow, but I'm pretty sure this is my problem.  Thanks! ... View more

*******EDIT******** I figure out everything using the Spatial and Query Filters.      See the discussion here on the Windows Application template in the     Choosing an ArcGIS for Desktop project template document. When you use the template you will have GUI options for defining your license and the binding code will be automatically added to the project for you. Once you have handled the proper license initialization and product binding you can start writing the ArcObjects code you need to make use of.        See the     Connecting to geodatabases and databases document for some details on how to connect to your enterprise geodatabase. Then you could use something like     IWorkspace.DatasetNames or the     geoprocessors list methods to get at the feature classes.   Thank you very much, I was able to get a handle on my SDE perfectly. I am now a little stuck on my next task: I want to perform a spatial query; the way I had done it before was using IGeometry and ITopologicalOperator's on IFeatures... however, now I am using just Featureclasses. my code thus far is: IFeatureWorkspace fws = (IFeatureWorkspace)ws;                 IFeatureDataset opDS = fws.OpenFeatureDataset("Operational");                 IFeatureDataset baseDS = fws.OpenFeatureDataset("Base");                 IEnumDataset opEnum = opDS.Subsets;                 IEnumDataset baseEnum = baseDS.Subsets;                 IDataset opNext = opEnum.Next();                 IDataset baseNext = baseEnum.Next();                 while (baseNext != null)                 {                     IQueryFilter baseFilter = new QueryFilterClass();                     IDataStatistics bds = new DataStatisticsClass();                     IFeatureClass bfc = fws.OpenFeatureClass(baseNext.Name);                     if (baseNext.Name.Equals("FIELD1")) bds.Field = "FIELD1";                     else if (baseNext.Name.Equals("FIELD2")) bds.Field = "FIELD2";                     else                     {                         baseNext = baseEnum.Next();                         continue;                     }                     IFeatureCursor bcurs = bfc.Search(null, false);                     bds.Cursor = (ICursor)bcurs;                     System.Collections.IEnumerator pEnum = bds.UniqueValues;                     pEnum.MoveNext();                     while (pEnum.Current != null)                     {                         string f = pEnum.Current.ToString();                         //etc etc                     } What I would like to do, is put a spatial filter on this featureclass, so I may use it's Geometry as the intersection for another featureclass I want to select from. The idea is to select features from one featureclass that intersects the above featureclass' field I am getting from "pEnum.Current", and add that unique value into a new field of the selected featureclass. (That is probably a little confusing). Example: I have a polygon containing 3 values in a "DISTRICT" field - 1, 2, and 3. I have a featureclass of points that will fall into one of these polygons. I want to select all the points in "DISTRICT=1" and add the value of "1" to a new field in the featureclass called "DISTRICT" *******EDIT******** I figured out everything using the Spatial and Query Filters. ... View more

I think I may have figured out what is wrong.  Since the ListFields function is not part of the 'mapping' module, it needs to read the full path of the layer.  Replace: for sc in arcpy.ListFields(lyr): with: for sc in arcpy.ListFields(lyr.dataSource): Entire code: for de in searchfile.readlines():     if '--' in de:         fc=de.split('--')         for lyr in arcpy.mapping.ListLayers(mxd):             if lyr.name==fc[1].split('\n')[0]:                 print lyr.name,type(lyr)                 for sc in arcpy.ListFields(lyr.dataSource):                     if not sc.name in searchfile.readlines():                         print sc.name Ah!  Perfect, worked like a charm.  Thank you for your help Jake, much appreciated. ... View more

Sorry if I was unclear. My user is going to draw a polygon on the map or supply a point (dragging and dropping a push pin onto the map). Whichever geom is supplied (point or polygon) I want to convert that to JSON and send it to a script on my server. When the script on the server gets it I want to intersect that point/polygon with a layer that's stored on the server to find out if it intersects with the polygon/point. At worst it'll probably be a couple of polygons or one point, so you're saying I should convert those polygons/point to at least an in-memory feature layer? Maybe a shapefile or geodatabase feature class may be overkill?  I'm very new to ArcGIS Python so I'm not sure what approach I should take to getting this done. What's the best way to store these "layers" on the server? In a geodatabase? What exactly is your code above outputting?  A group of strings you are parsing to JSON? What part of your code functions properly at the moment and what is not working? As far as looking for intersection, if you don't want an output layer, shapefile, or featureclass, you can look into SelectLayerByLocation_management: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000072000000 Where you can then run an additional cursor through those 'selected' features.  If the cursor is empty, it has not intersected the source layer. ... View more

Can you attach a sample of your text file? It is basically laid out where anything with a '--' in front is the feature class, and what is below are the fields they should contain. --FEATURECLASS1 FIELD FIELD FIELD FIELD --FEATURECLASS2 FIELD FIELD FIELD FIELD FIELD --FEATURECLASS3 FIELD FIELD FIELD FIELD ... View more

Hi Kevin, "for sc in arcpy.ListFields(lyr)"  will return a field object.  Try specifying the 'name' property for this object.  Ex: for de in searchfile.readlines():     if '--' in de:         fc=de.split('--')         for lyr in arcpy.mapping.ListLayers(mxd):             if lyr.name==fc[1].split('\n')[0]:                 print lyr.name,type(lyr)                 for sc in arcpy.ListFields(lyr):                     if not sc.name in searchfile.readlines():                         print sc.name Thanks for the reply - unfortunately, it is still returning the same error ... "[layer]" Does not exist, even though it is printing the layer name at the print lyr.name,type(lyr) line... ... View more

It is possible to change fields alias  in layer within mxd by arcpy?(Table Options > Appearance) Have you taken a look at this: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//000v00000071000000 ... View more