Latest Contributions by SB5

Hi and thanks for your swift reply Xander Bakker‌ A follow-up question: How do I specify the different symbols? For the custom symbol I have a URL, but the circle symbol I want to use when it is zoomed out beyond 1:50 000 is from the AGOL symbol Library. How to I get that in there? Thanks again. ... View more

Thanks for the tip! I'm using 10.3.1. Seems like the size is greatly overestimated, when I click calculate size it shrinks by 90%, but still so big that I get a warning. Feature service is the way to go for me! ... View more

I just realised that what I had done was to change the fields from lines 12 and 13, I thought I had to specify them myself. That's what happens when a code rookie tries to overcompensate I guess. I will try again over the weekend, will most likely work as a charm. Thanks for taking the time to guide me. ... View more

I'm back. Do the fields have to be indexing fields / objectid fields? I used the unique tunnel identifying field now, as mentioned above, and the numbers were changed during the process. So the solution was not as simple as I had hoped. I'm back to wondering if it is possible to change the objectid field name or being able to add a few more fields from the tunnel point attribute table. Thanks in advance. ... View more

(Sorry for spamming) Nevermind, I just changed what field to include from the tunnel point attribute table, thought it had to be the objectid field. The script works great, I'm very grateful! ... View more

...or can another identifying field be added from the tunnel point attribute table? Each tunnel point has a unique number that is used by the contractors to track the machines, so it needs to be there (either joined or added now) ... View more

I have a small problem: Since the objectid in my tunnel point fc is called "objectid" and the new table's objectid is also called "objectid", the tunnel point objectid is not included and cannot be related to the original tunnel point file afterwards. Is there a way of changing the objectid, either choosing another field or renaming it?  ... View more

Thank you so much for spending time on the script, Xander. I ran/started the script with the two point sets and it got to 20% in two hours before I realised that I wanted to split up the point sets, so I just recently started over. I don't think the process will finish before my long weekend starts, but it looks like it's going very well! I appreciate this a lot. ... View more

Hi again, As mentioned in a comment to Xander above, I used 3D Buffer and Inside 3D plus some table joining to end up with a table with xyz coordinates for both building points and construction machine points. Can you tell me how to calculate 3D distance in a new field, either using excel or in the attribute table?  This is an example (with very many zeros for some reason) POINT_X_building POINT_Y_building POINT_Z_building POINT_X_constructionmachineno2850 POINT_Y_constructionmachineno2850 POINT_Z_constructionmachineno2850 599017.980859000000000 6640584.964650000400000 123.000000000000000 599075.213999999690000 6640639.921700000800000 -6.040000000000000 598973.976436999980000 6640633.025369999900000 121.950400000000000 599075.213999999690000 6640639.921700000800000 -6.040000000000000 598973.976436999980000 6640633.025369999900000 121.950400000000000 599075.213999999690000 6640639.921700000800000 -6.040000000000000 599111.963903000000000 6640589.985279999700000 126.000000000000000 599075.213999999690000 6640639.921700000800000 -6.040000000000000 599090.217955000000000 6640602.671959999900000 126.000000000000000 599075.213999999690000 6640639.921700000800000 -6.040000000000000 Thanks so much in advance. ... View more

Very much appreciated. I am in the process of trying out the following solution, but not quite sure about it: I ran 3D buffer tool for each construction machine point and got 22 000 multipatch 200 meter buffer spheres. I then ran Inside 3D to get a table with all the building points within each buffer sphere/multipatch (which had to be joined to the two point tables to preserve all my information in one table). In the resulting table (only 1 million rows) I have xyz for each construction machine point (=the center of the 3D buffer multipatch) and xyz for each building point, can I calculate 3D distance using the coordinates? ... View more

Thanks, this seems interesting. I unfortunately only have the basic license and need advanced to use Generate Near Table. ... View more

The Z difference is between 5 and 100 meters. Limiting the search radius would at the most cut the number of building points in two, leaving me with 6000 points.The building points are all within 400 meters of the line that the construction machine points run along, and I would need to select building points within 150-250 meters from each construction machine point. I unfortunately cannot share the data.  Thanks again Xander. ... View more

Thanks Xander. I guess the easiest solution is to run Near 3D after specifying one location of the construction machine in the first feature class. My aim was to have this available for my colleagues to query from a table, but there would be too much data. ... View more