Latest Contributions by SharonLitteral

‎12-03-2014

Yes. I read through the list of coordinates and add each one to the arcpy.array. Not until I have finished with all of the coordinates do I write the array to the polyline.

‎12-03-2014

I have a python script that was creating points in memory and writing them to an arcpy.Array and then writing the array to an already existing feature class as a polyline. When I looked at the line it was missing the first segment and the last 2 1/4 segments. I changed the script to write the points to an existing featureclass (to verify that it was in fact looking at all of the points). All of the points are there but the line is still incomplete. Here is the code segment: cur = arcpy.da.InsertCursor(outLineFC, ["SHAPE@"]) cur2 = arcpy.da.InsertCurson(outPointFC, ["SHAPE@"] for coords in coordsList: print coords[0] print coords[1] print float(coords[2]) print float(coords[3]) print "next item" array.add(arcpy.Point(float(coords[3]), float(coords[2]))) cur2.insertRow([arcpy.Point(float(coords[3]), float(coords[2]), ID=int(coords[1]))])) if cur2: del cur2 cur.insertRow([arcpy.Polyline(array)]) Can anyone explain to me why it is writing all of the points in the order I would expect it to draw the line but not writing the first segment and the last 2 1/4 segments of the line?

‎10-03-2014

ESRI Tech Support cannot have access to my domain so I will continue to troubleshoot myself.

‎10-03-2014

We are using Windows Authentication and direct connect to the database. Yes, they are a member of a lot of nested groups. However, we denied access through SQL to a single table with a group that contains all domain users. We then used ArcCatalog and changed privileges for another group that the user belongs to to allow select. At this stage, we can see the feature classes in the ArcCatalog tree view, but when we click on any feature class in the feature dataset, it gives an error message box. The message states that we have insufficient privileges on the feature class where we denied access. Our dba has tried removing and adding db security groups and Active Directory groups with select table granted back to the single table with the same result. This user does not have a db login but is a member of several nested groups that can connect to the db.

‎10-03-2014

No, not db_owner. Any other suggestions?

‎10-03-2014

Jamal, Did you ever figure this out? I am experiencing a similar problem. Thank you, Sharon

‎10-02-2014

We are running SQLServer 2012 and not using SDE connections. We are also using all 10.2 products (Desktop and Server). We understand that the dataset privileges can only be managed by ArcGIS since the database does not recognize datasets. We want to know more about the pros and cons of managing user privileges with the SQLServer Management Studio at the table level vs. using ArcGIS and managing user privileges at the dataset level. Also, have any testing metrics been done with one vs the other?

‎08-28-2014

Okay, so I wrote the script to load or append data to an existing feature class. First, I use arcpy.ListFeatureClasses and get a list of the feature classes from my source feature dataset. I then loop through each one of the feature classes in the list above and: 1. Use arcpy.Describe and create a list containing all of the field names in the source 2. Use arcpy.SearchCursor on my source feature dataset and for each row in this cursor I loop through and 3. Use arcpy.InsertCursor.newRow and create a new row in my target dataset 4. Then for each field name in the list of field names from 1. above I loop through and populate that field value in my new row with the value from the source (I use getValue and setValue) 5. Finally, I use the InsertCursor from 3. above and use the method insertRow to update the row in my target database. 6. I clean up my cursors. This all works, however it takes a long time to do this. Does anyone have any experience with tuning the python performance or suggestions for how to modify my logic above to increase performance?

‎08-28-2014

Actually, all caches are fused at this release. However, we found a wierd bug. If we changed the default name of Layers in the TOC for that dataframe to something else other than "Layers" and then published the map service, it would change the variable "Single Fused Map Cache" in the xml for the rest service to false.

‎08-28-2014

How do you set fused map cache to true at ArcGIS Server 10.2.x? It used to be on the advanced button on the cache tab but I no longer see it at 10.2.

‎08-06-2014

I have an existing feature class in a file gdb. I am trying to write a python script to load data from a SQL2012 gdb. I am new to this. Normally, I would just drop a tool into modelbuilder and convert it to a python script. However, I do not know how to do this with the Simple data loader that I use in ArcCatalog. I would think that someone has already done this. Any help is appreciated.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by SharonLitteral

Re: Points to polylines missing first segment and last 2 segments

Points to polylines missing first segment and last 2 segments

Re: A privileges granted to a user for enterprise geodatabase layer,

Re: A privileges granted to a user for enterprise geodatabase layer,

Re: A privileges granted to a user for enterprise geodatabase layer,

Re: A privileges granted to a user for enterprise geodatabase layer,

Question about managing user privileges in SQLServer 2012 database.

Re: Script to load multiple features into already existing feature class?

Re: Fused Map Cache

Fused Map Cache

Script to load multiple features into already existing feature class?

Fused Map Cache

Re: Fused Map Cache

Re: Script to load multiple features into already ...