Latest Contributions by BenVan_Kesteren1

‎12-07-2017

Hi Richard, I included a screenshot of my INS_DATE field, i do see it is a DATE type, is there any way it may not be storing dates? I don't need to be exact with the 90 days, if I am within 24hr each side of that it will not matter for this particular job. See below screenshot from when I tried using the DATEDIFF method: Cheers

‎12-07-2017

Hey, I am using ArcMap 10.5 with a table within our Enterprise SDE that has a join to a view (also in the SDE). This view has a date field that I would like to use to filter my data on. I need to find rows that were inspected in the past 90 days. INS_DATE field properties: An sample of my data: tbl1.ObjectID tbl1.AssetID tbl1.Shape() tbl2.AssetID tbl2.INS_DATE 1 10000 10000 3/02/2016 11:34:52 AM 2 10001 10000 29/11/2017 8:37:12 AM 3 10002 10000 29/11/2017 1:45:23 PM So I want to limit my rows to ones that have an INS_DATE within the past 90 days. I have been trying to use the below code (and about a dozen variables of it) all give a non-descriptive error: SDE_SPATIAL.GISADMIN.%AUDITS_LATEST_RECORD.INS_DATE > (GetDate() - 90)‍‍‍‍‍‍‍‍ Is there another way I should be approaching this one? NathanDuncan‌ FYI Cheers Ben

‎10-16-2017

Yeah I originally thought to use the properties (parcel) feature class, but it is not geographically perfect, so there are thousands of slivers and areas which are dirty data. The only clean data we have is the polyline feature class (black lines in original screenshot).

‎10-16-2017

Hey, I have got our road network outlines drawn with a Polyline feature class, made up of several thousand features. They are shown as the thin black line on the attached drawing. I would like to convert this feature class into a (single??) polygon type, the area I would expect to be correct is highlighted pink in the attached screenshot. I have tried using the construct polygons tool on the road outline polyline feature class, which has created the blue features in the below screenshot. In the sample area, you can see there is a single feature that actually looks correct, all the rest it has constructed on the 'wrong side' of the polyline, so I think there must be a better way to do what I am trying to do. Any pointers to get me started? Thanks

‎09-28-2017

Its funny how I come about finding this old post... I just got a new PC, and I forgot how to setup my models so that they overwrote data each time I run it, so I Googled my problem which actually found my original post above. Reading Jayanta's comments allowed me to fix my problem (this time). So I marked it as correct. I am unsure what the fix was back in 2016, but something else must have been locking my data, not allowing it to be overwritten, but this time around Jayanta fixed my issue, hence the marking it correct. Everyone can sleep easier now knowing its all good

‎08-29-2017

Fantastic, thanks for that... I kept clicking 'more value' thinking thats where you were indicating, and then I expanded my field of view and found the 'more' button you said to click! Thanks heaps, works exactly as expected.

‎08-29-2017

Hey, thanks for the suggestion. I did try what you suggested by changing colors to NONE and no label, but it is just a n00b hack and not a proper solution, as it keeps the blank line in the legend which is not very professional I believe. I know I can re-order the layers, which will work in this instance to put the blank line at the bottom, but what happens if all my layers have <all other values>? I was hoping for a tick box or something that is hidden somewhere...

‎08-29-2017

Hey Guys, I am having a go at using ArcPRO to create a simple map, I am doing OK right up until I have to create the legend. Is there a way to filter off and not display the <all other values> from my legend? I click on the symbology, and right click on this item and I am unable to remove this symbol (this is expected, as I know in arcMap this is the same) So, I am sure in ArcPro I should be able to remove this option from the legend, can someone explain to a n00b how to do this please? Thanks

‎08-23-2017

Sorry I should have made that clearer (I will edit original post), but I am meaning I am changing symbology etc, then re-publishing my map service. I want to find the last time the map service (sitting on the map server) was published. Cheers

‎08-22-2017

Hey All, Just wondering if anyone knows if it is possible to find the date a Map Service was last published to our GIS Server? I currently automate the publishing of a MXD document to the Online Map Server, but I want to skip the update if the document (layer symbology, layer visibility etc.) has not been modified since it was last published. I have worked out how to detect file modification date no worries, but its the online map service I am unable to work out how to detect last published date. Any ideas?

‎08-20-2017

Hey, I am trying to create a dynamic text box as a map label, and it needs to show the <last year> - <current year>, so the text today should look like 2016-2017. I have found this below snippet is correct in displaying 2017, but I am unable to work out how to manipulate the below code to subtract 1 from the figure of 2017, in order to display last year. <dyn type="date" format="yyy"/> Any ideas? I would love for there to be a pythonic solution to my dilemma... I just don't know if that would even be possible in a text box. Thanks Nathan Duncan‌ FYI

‎08-18-2017

I believe what happened is that our IT team audited the SQL Server permissions and noticed our SDE account had quite high privileges, and as I am not located 'within' the IT team this is against business rules, so they revoked my access as SDE Admin, which in turn caused this error to rear its head. Once my IT team restored previous permissions all was good again. Cheers

‎07-09-2017

Hi Dan, you are correct on most fronts... since I posted this morning I bit the bullet and upgraded from 10.3 to 10.5, which has indeed fixed my issue. I was using pycharm, but I then went bare basics by running python.exe, which had the same issue. I narrowed it down to the arcpy module, and it was only on this PC, not my other backup machine, so I thought a repair was in order, and like I said, I did the upgrade instead of a simple repair. All seems to be working now, but I do thank you for your comments and time in replying to my question.

‎07-09-2017

Hey All, I have multiple python scripts that work on my SDE. Has been working well for some time. Just recently I have noticed that if I import arcpy in one python console, it works great, but if I then try to import arcpy again in another window or another script, it just hangs, not throwing any errors. The only way I can get my machine to run any import arcpy again is to reboot completely. I am running Python 2.7.12 from C:\Python27\ArcGIS10.3 Anyone else seeing arcpy play up like this? Cheers

‎06-12-2017

That single line of code crashes arcCatalog when I run it in the Python Window: print arcpy.ListFeatureClasses('SDE_SPATIAL.GISADMIN.Airport')‍ This line works perfectly: print arcpy.ListFeatureClasses(feature_dataset='SDE_SPATIAL.GISADMIN.Airport')‍ This script was working fine for over a year, I think the problem started when we updated from 10.3 to 10.3.1, but I cannot be 100% sure, it could be coincidental. Thanks for your help.

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

My Ideas

Latest Contributions by BenVan_Kesteren1

Re: Data Definition to find rows from past 90 days

Data Definition to find rows from past 90 days

Re: Converting Road Outline (Polyline) to Polygon

Converting Road Outline (Polyline) to Polygon

Re: Basic Model Won't Overwrite Existing Data

Re: How to remove <all other values> from Legend in ArcPro

Re: How to remove <all other values> from Legend in ArcPro

How to remove <all other values> from Legend in ArcPro

Re: Find Map Services Last Published Date?

Find Map Services Last Published Date?

Perform a calculation inside dynamic text

Re: arcpy.DisconnectUser is throwing this error - RuntimeError: Unable to disconnect: The connection ID provided is for the current administrator connection

Re: import arcpy freezes python, restart fixes momentarily

import arcpy freezes python, restart fixes momentarily

Re: Anyone able to run arcpy.ListFeatureClasses() successfully?

Re: Export survey form

Re: Callout lead line drops off when symbol has no...

Can ArcGIS Pro ModelBuilder append today's date to...

How do I set "Distance Factor" Ground to Grid corr...

How do I show image attachments in pop-up, from a ...