305 reputation
19
bio website
location
age
visits member for 1 year, 6 months
seen 2 days ago

Jul
2
awarded  Curious
Jun
18
comment Inverse of Selected Records using ArcObjects?
In most GIS you have an option to invert the current selection. Without more information it's hard to be more specific
Jun
17
revised Optimizing arcpy script to batch generate OD cost matrix in road networks
Code update
Jun
17
comment Optimizing arcpy script to batch generate OD cost matrix in road networks
Thanks for the tip. It already looks a bit less messy
Jun
17
awarded  Yearling
Jun
17
asked Optimizing arcpy script to batch generate OD cost matrix in road networks
Jun
16
comment Why are steps out of order when running model in Batch?
Thank you all for your help. Indeed, it looks like the model is fine and the issue comes from ArcGis itself. I spent the day learning a bit of python and managed to run my model using IDLE, the python shell. However, as one my my datasets is quite huge (40k origins and 40k destinations), I was wondering if there is a way to export only the .dbf associated to the "Lines" output, instead of the whole shapefile (to save time and space, I already chopped up my Origins and set the output to "No Lines")
Jun
16
comment Why are steps out of order when running model in Batch?
Didn't want to re-write things that are already working well, this is the reason I turned to Model Builder. I guess it should give me the results I want if it worked correctly. If a script is the only solution, then I can try. Although I am not too bad in C++ or R, I never touched python and would need a beginner's guide to ArcMap-oriented python programming.
Jun
16
asked Why are steps out of order when running model in Batch?
Jun
11
comment Frequency analysis and overlay analysis
I guess we could help you better if you provide more information: what is the format of your data, which GIS platform do you use, etc.?
Jun
11
comment Find position of a character within a string in Spatialite
In addition, given that ´Name´ is the column where I want to extract the ID, the following command does the job: ´trim(Substr("Name", 0, Instr("Name","-")))´
Jun
11
comment Find position of a character within a string in Spatialite
You are right, the problem came from a deprecated version of Spatialite-gui. I always have a hard time finding the URL of the precompiled newest release. For those interested, it's there: gaia-gis.it/gaia-sins/windows-bin-amd64
Jun
11
accepted Find position of a character within a string in Spatialite
Jun
11
asked Find position of a character within a string in Spatialite
Jun
10
comment Finding the point closest to a point on a near feature
Thank you for your very detailled answer. I tested your queries and they work well. For my specific situation, I encountered memory errors due to the huge amount of data. I had to find a workaround using ArcGis batch processes and managed to get it one. Thanks again for your help!
Jun
10
accepted Finding the point closest to a point on a near feature
Jun
3
comment Finding the point closest to a point on a near feature
Thanks for the explanation. However, when I set a BBOX using BuildMbrCircle or even Buffer(), I obtain very weird results, such as the green point in this picture i.imgur.com/znNRc4m.png When I do not set a box, I only have results for 3 points, but they are correct (the star). In addition, I am surprised that the ClosestPoint() function returns more than one row for each point. If I remove the "GROUP BY test.ID" clause and without BBOX, I have two results for the point with ID=2 (and even more results if a set a BBOX).
Jun
3
revised Finding the point closest to a point on a near feature
deleted 176 characters in body; edited tags
Jun
3
comment Finding the point closest to a point on a near feature
Thank you! I didn't know about the ClosestPoint() function, and it does exactly what I want. I just tried it and it works almost perfectly, and very quickly with the spatial index on. First, for one of my points, I obtain 2 closest points instead of one. Second, I still have the issue with the spatial index (I get the results for only 3 out of 10 points): i.imgur.com/tHdRc5Q.png
Jun
3
revised Finding the point closest to a point on a near feature
added 259 characters in body