Latest Contributions by BenVan_Kesteren1

‎07-08-2018

Exactly what I am looking for, thanks Dan.

‎07-08-2018

Hey Everyone, I am wondering if anyone has got a simple script that they have that will iterate over all feature classes within my Enterprise Geodatabase, and return only the ones that are Registered as Versioned? Sounds simple enough, I just haven't found an arcpy tool that will return versioned or not versioned. Cheers

‎07-05-2018

Hey, Yeah so if I could simply have a label at each feature, and that label shows the number of attachments that feature has associated to it. In addition to this, could I highlight all my features as Red Dots, then as soon as someone has attached/collected a photograph that symbology changes to green, indicating this feature has been tended too. They are columns in my table, but they are not 'interactive' like my other columns are. I think this would be a fantastic feature (if it isnt already possible, and I just cannot work out how?). Cheers

‎07-03-2018

Hey All, I have created a Web Map using ArcGIS Online, and I have been collecting features using the collector map, and I would now love to symbolize or create a label showing which features have a photo attached. It seems the field Photos and Files is not available in the filter window, and same when I try to symbolize. But basically I would love for my points to be a tiny dot if it has a photo attached, otherwise I would like the point to stand out to the user, indicating it needs attention. Has anyone worked out how to symbolize OR label based on Photos and Files field? Cheers

‎07-02-2018

Hey, Thanks for the detailed reply. Yeah it seems to have eventually worked fine, but it was not applying the changes instantly for some reason. It wasn't until I came into work the next day that the changes filtered through entirely. Cheers!

‎07-01-2018

Does anyone know if this functionality is available on the https://survey123.arcgis.com site? Cheers

‎06-28-2018

Works perfectly with that suggetion Mark Bockenhauer, thanks for the tip!

‎06-27-2018

Hey, fantastic blog, very useful and informative! I have been able to create my URL no worries in the pop-up, but it seems the URL structure has changed since this blog was written. This is what I am presented with in my collaboration tab of survey123 site: This is the sample that we are given in the above blog: I am wondering what my URL should look like? My URL is vastly different to the blog example. The blog example looks like this: arcgis-survey123://?itemID=4560a3c533eb41fcb79fa3ec473babc8&field:TRAILNAME={TRAIL_NAME}&field:MAINTENANCE={MAINT_BY} But my URL ends up looking like this: arcgis-survey123://?itemID=1XXeCb&field:asset_id={OBJECTID_1} And when i open the URL it gives me this: Any tips on how to fix this one? Thanks!

‎06-26-2018

Hey, I have just created a feature layer online, and this feature layer has hundreds of features, and there is about 20 attributes in this table for each feature. I want to select a feature on the web map, and assign the task to a worker. When I select a feature and click create assignment, it auto populates the LOCATION field with the feature layer name. I am wondering if I am able to modify what data is inserted here, as I would much prefer to pass an assetID accross. Is this possible?

‎04-26-2018

Yeah thanks for that. There is another guy in my team who will be providing his list of pipes he wants repaired based on material+age calculation (no . So mine is purely a spatial question. So I was thinking to make it 'fair' that I get the total length of the pipe, then divide it by the number of bursts, to get a 'score'. The higher the score the worse off the pipe. Does this make sense? For example a pipe segment that is only 10m long, may have two bursts, and a pipe that is 1km long may also have two bursts, and I think the shorter pipe should be replaced before the 1km, as it has more bursts per lineal meter. Does this make sense to others? Or am I over/under complicating it? Thanks

‎04-26-2018

Hi Everyone, I work in a local government and one of my roles is to help come up with next years water main (and sewer) renewal program. I have each of our pipe segments mapped, each with individual asset id, installation year, construction material, diameter etc. On top of this I have another table (joined by a 1-M relationship) to each and every burst or fault recorded against each pipe segment. And this is what management would like me to weigh in on. They have asked me to present "a list of water mains that based on breakage/fault history should be replaced". I am wondering if anyone else out there has a similar project they had done in the past, and how did you go about presenting this? I could simply order my pipes by the greatest number of recorded faults to least amount of faults, but I don't think this would be the most effective method. Can anyone else provide any ideas on how they go about collating and presenting this information? Thanks for your time.

‎02-27-2018

Just a note to Future Me, there is a Geoprocessing tool called Add Geometry Attributes, works a treat!

‎01-18-2018

Hey All, I am trying to find the tool that would be useful in creating a grid index showing the extent (and ideally, the associated filename), of each of my several hundred TIF files containing our Aerial Photography. I am sure I can automate something with Python if I knew what tool to use. In the past we had been supplied this file from the creator of the Aerial Imagery, but this time they did not, and unfortunately I did not specify this in our contract. This is what I am after: This is all that I have got:@ Any direction for someone in need?? NathanDuncan‌ Cheers

‎12-11-2017

im not sure if it matters, but I'm thinking it could, the AUDITS_LATEST_RECORD is a joined view. It is joined to the ALBURYTREES via this setup: SELECT * FROM ALBURYTREES LEFT JOIN AUDITS_LATEST_RECORD ON ALBURYTREES.ASSET_ID = AUDITS_LATEST_RECORD.ASSET_ID‍‍‍‍‍‍‍ Also just looking at the INS_DATE field, I have confirmed it is of type 'DATE', but you will note the formatting within switches between date only, to datetime. Is there a way I can cast everything to be a date first, and then find rows where date is from last 90 days? Note I cannot modify the actual data to do this, it must be done in the Definition Query...

‎12-10-2017

Hi, In ArcGIS Pro 2.0 when creating a Map Series the application seems to filter the available options in the Name drop down list to exclude fields that are a type 'Double' and 'Date' (from my limited testing). See below screenshot of table, and then the map series options that are presented: I would love to use the Police_ID field (it is a type double) as my naming convention when bulk exporting my Map Series, but as I cannot set it as the Name, I am unable to do so. I would love to see the fields that are type "Double" appear in the Name Field options list. Cheers

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

My Ideas

Latest Contributions by BenVan_Kesteren1

Re: Python Code to find all Versioned Feature Classes within Enterprise Geodatabase

Python Code to find all Versioned Feature Classes within Enterprise Geodatabase

Re: Can I label or symbolize my features using the 'Photos and Files' column?

Can I label or symbolize my features using the 'Photos and Files' column?

Re: How to tell Workforce Which Column of Feature Layer to Use In Location When Creating Assigment

Re: Make a question required conditionally based on answer to previous question

Re: Using App links to Launch Survey123 from Explorer for ArcGIS

Re: Using App links to Launch Survey123 from Explorer for ArcGIS

How to tell Workforce Which Column of Feature Layer to Use In Location When Creating Assigment

Re: I need help presenting next years pipe replacement program to management

I need help presenting next years pipe replacement program to management

Re: How to create Grid Index of hundreds of Aerial TIF Images

How to create Grid Index of hundreds of Aerial TIF Images

Re: Data Definition to find rows from past 90 days

Allow numeric fields to be used as Name Field in ArcGIS Pro Map Series

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 ...