Latest Contributions by LorindaGilbert

So, Has anyone figured out how to get the Feature Dataset name using Python when your data is residing in FeatureDatasets within the database?  I see that the layer.datasetName is really the feature class name.  Unfortunately, we have several feature classes within feature datasets for network and topology purposes and now that we are changing servers, I need to have a script that will change the source data.  Alas, as of right now, I can't do it via script unless someone has a work around out there.  I've been banging my head against the wall for a week now, because like some others, when a term 'dataset' is used, you would expect it to be related to the same things that it is elsewhere.  I'd seriously consider an attempt to parse the name out, but we have several different former datasources referenced (even after changing them in the mxd - thanks for hardcoding ESRI) and the feature dataset names are many different lengths. Thanks if anyone has a workaround to help with this. ... View more

Hi All, Like many before me (and yes, I have perused the forums looking for pointers) I am having to change servers for one of the several SDE databases.  I would like to have a script that can be run either from python or as a GP script in ArcCatalog. We have several mxd's that are in the same folder (as well as several folders with individual mxds) that need to be updated.  I have grabbed code from several others that have done the same thing and attempted to get the end result as desired to no avail.  I'm getting the saved second copy of the mxd in another directory and a partial output file telling me what it is doing (or not doing).  The output file lists the mxd, the full path, and dataframe.  I'd like to get the layers listed if they are part of the changing database and then have the datasource changed for each of those layers. We are only changing the server location of the database, the name and structure is remaining the same.  I will be creating a sde connection file to pass to everyone (we use AD groups with windows login) to be placed in the ArcCatalog directory in the appdata directory for each user. I've tried several things, but it appears that it isn't getting past the layer list right now - yet, this was working when I had it just reporting back to me the listings.  I'm also aware of the 'feature' where using ArcCatalog to change the data source in the mxd doesn't work as advertised. When I run this script, the only info returned besides the incomplete listing of data is, "returned exit code 0". Running ArcDesktop 10.0 SP2, SDE 9.3.1, Python 2.6 Thanks for any insight that can be offered.  And I realize that it could be a simple typo or misplaced quote or something, but I just don't see it. ... View more

Hi All, I've been using FME to extract the start x, y; mid x, y; and end x, y from our street centerlines for another user.  We've decided that rather than having this data move through multiple formats that we would like to attempt to do a view in the geodatabase that could then be used by other users. I have created a MV view of our street centerlines and the nodes (intersection points) that accomodates the delta tables with the business table.  The intersection points (nodes) are real easy to get the x, y coordinate.  Just used the MV view and the f table to get the eminx and eminy - as a point they are rather self evident as to what to use.  This will also be used for another point table. Now.... I need to get the start point, mid point and end points for the centerlines.  These could have 2 points or many points.  In FME, there is a command to get the coordinates and it uses the index of the number of points, i.e. 0 for start, -1 for the end and then use mod of the number of points for the ones over 2, otherwise, simple math for the 2 point centerlines.  How do you locate the coordinate list for vertices in SDE?  I was thinking that it was in the s table, but not seeing that since even if there are mulitple sp_fid's the numbers are the same in the other columns. Thanks for any help! Thanks, ... View more

Hi All, I find myself needing to create child replicas of data that is edited inside the security of our firewall to a server that is outside our firewall.  I remember reading about how to do that in 9.3, but cannot find the documentation anywhere right now.  Our security guys want to know the ins and outs of doing the connection and I want to refresh my memory on how to do it as we will be doing another server very soon after this one. Thanks for pointing me in the right direction. J~ ... View more

Hi All, Has anyone else run into this?  I have a view in Oracle that I am using for an x,y event layer in ArcMap (and by way of publishing, a mapping service).  I have over 21K rows in the view when I query in Oracle.  When I open the layer file in ArcMap, I SEE all of the points (at least the ones that have valid x y coords - there are a few nulls), but when I open the attribute table there are only 2048 in the list.  Yet, I can go to one that is not showing in the attribute list and do an info tool and get the data. What kind of quirkiness is this? ETA:  Win7 x64, Arc10 SP1, Oracle 10g, our server for SDE is SQL Server 2008 Thanks. ... View more

Hi, Is there a way of formating text that is in an AddMessage statement?  I'd like to change the color and whether it is bold or not so that the message jumps out to my users on the geoprocessing window. Thanks, Jazmateta ... View more

Writing a python script and attempting to use the SelectLayerByAttribute_management command. I've tried it several different ways and keep getting a syntax error on the variable set, or if the variable set works, get invalid expression.  I am querying against a file geodatabase. python snippet: where_clause = (r"Status = 'U'") arcpy.SelectLayerByAttribute_management("Crimes", "NEW_SELECTION", where_clause) I'd like to add .outputCount to this to see if there are any rows selected.  I have done this once in the python window but can't remember how I did it now and didn't put it in my script when it worked. I've also tried various ways of putting quotes and single quotes with and without the r or the parenthesis.  Syntax error or it doesn't get passed properly to the query and gives the Invalid expression. Help! Forgot to add:  In the ArcMap window using the Select by Attributes dialog, the proper syntax is "Status" = 'U' and it works as expected.  Just can't get the translation to python to work properly. ... View more