Latest Contributions by timdunlevie

‎04-23-2018

Hi all, We are using ArcGIS Desktop 10.5. I have created a file gdb consisting of around 20 fcs, which sits on a share drive on our windows file server. For some reason I keep getting the dreaded ArcMap Drawing Errors message: One or more layers failed to draw: FDO error: 0 [Failed to label layer ASSETS for class default.] General function failure Drainage: General function failure This happens to all data stored in the fgdb. The frequency is probably every 15-30 mins. Imagery (or other .shp files) that are not in the fgdb but reside on the same share drive on the server are fine. The only way to operate properly in AM is to shutdown AM and restart....fairly annoying. Anyone had this issue? A way around it? Could my fgdb be causing a problem? I have compacted the gdb and same problem persists. help? thanks

‎06-30-2016

Hi all, I have a python script which runs perfectly on my PC running ArcGIS 10.3... The script truncates a feature class in our ArcSDE, then appends new records. As I said...works flawlessly on my PC. I now want to run this on our application server (windows 2012 R2) ArcGIS Desktop 10.2 and set up a schedule task... When I run the exact same code on the server I get this error message: File "D:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\management.py", line 14530, in TruncateTable raise e AttributeError: Object: Tool or environment <TruncateTable_management> not found Anyone have an idea? Thanks

‎04-17-2016

Gotcha…thanks. Regards, Tim

‎04-17-2016

Hi Vince, Righto – thanks for the info….might not have structured that post correctly… What I was attempting to do is “add query layer” from our enterprise geodatabase via ArcMap. And was hoping to add a fairly detailed SQL expression to get the result I wanted and wanted some help in the sql commands that would work. If you think it’s best to do this on the actual Microsoft sql database then I’ll do it that way. Thanks, Tim

‎04-14-2016

Hi all, We have a Microsoft sql server which our ArcSDE is located on. In the database are a collection of feature classes. I want to add a query layer using 2 feature classes. It's a simple query involving a points FC & a polygon FC. I want to query points which are within a polygon based on an attribute. for example: select * from FC_Points, FC_Polygon where FC_Points are within FC_Polygon and FC_Points.ID = FC_Polygon.ID could someone point me in the right direction to write the syntax? Many thanks

‎01-06-2016

Ahh gotcha ! Thanks for the reply. OK – then the map service is performing properly…..for a minute I thought something was wrong. Thanks, Tim

‎01-06-2016

Hi all, I have built a MXD which I use to create a feature service to our ArcGIS server for use in our internal web client. All feature classes reside in our SDE (sql server). One feature class is time-enabled based on a "date_stamp" field (date type). Using the slider in ArcMap is shows monthly updates of the data. It all works fine. If I leave the time slider on the latest month of the dataset I am able to identify only this month of the dataset in ArcMap. I want the service to show the latest data in my web map and then have the user use the slider to interrogate the data as-needed. However, when I publish the service it shows me ALL months in my dataset - it displays the data cumulatively (which I have un-ticked in the layer properties). For example, if I identify the data in our web map, it will list ALL "date_stamps" of the published feature Class. Is there a way for the service to publish and only show the latest month as I see it in ArcMap ? We are using 10.3. thanks

‎12-15-2015

mate just tested this again and it works! Brilliant!!!! I had an incorrect reference to my fc in the syntax when I tested it initially!! Many thanks.

‎12-15-2015

Cheers mate. This gives me no syntax errors when incorporating the qry in the SelectLayerByAttribute command, and seems like it “should’ work. However, I am still getting both ID A, Version 1 & ID A, Version 2 in the resulting outFC. I’ll keep playing around with this – I believe it’s what I am looking for! Thanks, Tim

‎12-14-2015

Thanks mate. I didn’t want to bore everyone with the full code as this is a small part of the script. What I was hoping to do was to simply add an “expression” to either the SelectLayerByAttribute command, or the MakeFeatureLayer command. (apologies if the format of this code is not what is required). inFeatures = "MasterFC" layerName = "Temp" inField = "ID" joinTable = "text” joinField = "Name" qry = "[Version] = (SELECT MAX() from MasterFC GROUP BY )" expression = "text.type = ‘active’” outFeature = “NewTable” arcpy.MakeFeatureLayer_management (inFeatures, layerName) arcpy.SelectLayerByAttribute_management(layerName, "NEW_SELECTION", qry) arcpy.AddJoin_management(layerName, inField, joinTable, joinField) arcpy.SelectLayerByAttribute_management(layerName, "NEW_SELECTION", expression) arcpy.CopyFeatures_management(layerName, outFeature) In the above example I get “ERROR 000358: Invalid expression” If I modify this to this placing the “qry” in the MakeFeatureLayer command: arcpy.MakeFeatureLayer_management (inFeatures, layerName, qry) arcpy.SelectLayerByAttribute_management(layerName, "NEW_SELECTION", qry) arcpy.AddJoin_management(layerName, inField, joinTable, joinField) arcpy.SelectLayerByAttribute_management(layerName, "NEW_SELECTION", expression) arcpy.CopyFeatures_management(layerName, outFeature) I get an error again with the query…. ERROR 000230: Failed selecting with = (SELECT MAX() I guess my question is whether it can done this way using an expression parameter in either command? I’m thinking my expression is completely wrong… Or should I be using a Search cursor with an expression? And yes – there can potentially be different “versions” for each “ID”…..eg ID A, Version 1, ID C, Version 3, ID F, Version 2 etc… The Feature Class is not versioned. Many thanks, Tim

‎12-13-2015

Hi all, I have a FC in an SDE with Fields: ID & Version. These are populated like this: ID "A", Version "1" ID "A", Version "2" ID "B", Version "1" ID "B", Version "2" etc.. so when the ID object changes we create a new shape with a new Version number, but keep the old shape for historic purposes. I am doing a join on another table but only want to perform the join on a subset of the original FC, grabbing the latest "Version" of the ID. For the life of me I cannot seem to be able to select these records. This will be a python script. I was thinking of using the arcpy.MakeFeatureLayer_management with an expression and/or arcpy.SelectLayerByAttribute_management function with an expression to form my subset before I join to another table. "Version" = (SELECT MAX("Version") from FC) - does not seem to work. I also tried a "group by" and got a sql error. We are using SQL server and ArcGIS 10.2 Even in ArcMap I cannot seem to be able to select the latest version of the ID....I am guessing I don't have the syntax correct. any help would be appreciated. thanks

‎10-06-2015

hi mate, I tested this today and it works brilliantly. Many thanks.

‎10-06-2015

Thanks for the reply. Yes FC_Main will be an update from FC_New. That was my first option – remove features, append data….but was thinking there may be a more efficient way of doing that. I was finding after I removed all features, then append new data (8000 records) I would have to compress the database for the Feature Class to display quickly. I had not looked at Truncate Table option so I might give this a play ! Thanks! Tim

‎10-06-2015

“FC_Main” sits in our SDE database. thanks

‎10-05-2015

hi all, OK here's what I want to do... I have 2 Feature Classes. One is the main Feature Class which resides in a Geodatabase which I want to update - call it "FC_main" The other Feature Class resides in a FGDB which gets new updated metadata & new/modified objects from an export from another database - "FC_new" Both FC's have the same schema ([fieldID], [field1], [field2], [field3], [field4], [field5]). Both have a matching unique ID field (fieldID). Using arcpy is it possible to compare the 2 FCs, update any metadata differences, add new objects, update any changed spatial locations ? I've been playing around with lists, search cursors ,update cursors and can do parts of this, but not all. My scripting is pretty limited. The main problem I have are the existing objects when they have coordinate changes. These don't seem to update. Just need to be put onto the right path and the steps to go about coding all this into 1 script. Arc 10.2. Many thanks, Tim

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

My Ideas

Latest Contributions by timdunlevie

General Function Failure - Data in a fgdb on a server

Arcpy AttributeError: Object: Tool or environment <TruncateTable_management> not found

Re: sql syntax arcSDE query layer points within polygon

Re: sql syntax arcSDE query layer points within polygon

sql syntax arcSDE query layer points within polygon

Re: Problems Creating a Time Aware Map Service

Problems Creating a Time Aware Map Service

Re: Select Max value arcpy

Re: Select Max value arcpy

Re: Select Max value arcpy

Select Max value arcpy

Re: Arcpy - Updating FC2 with FC1 updates/changes

Re: Arcpy - Updating FC2 with FC1 updates/changes

Re: Arcpy - Updating FC2 with FC1 updates/changes

Arcpy - Updating FC2 with FC1 updates/changes

Survey123 Feature Report, Summary showing filter V...

Re: IDLE Python error after up upgrade - subproces...

Re: SDE and organising Feature Classes & Feature D...

Re: survey123 Date calculation using 12 hour day

Re: Model Builder not Appending Data Correctly ?!