Latest Contributions by PaulHuffman

I was playing around, testing the iterative and looping features of Model Builder in 10.5,  to see if they were now complete enough and easier for me to understand than looping in python.  I made a little model that selects a few rasters with a wildcard out of a workspace with Iterate Rasters and then changes the projection, writing the output to a new folder and using the %Name% variable to create similar names on the output files.  I got the model to run,  then I exported to python to see how the iteration was handled by the export.  Well, the python script doesn't contain any of the iteration stuff.  I thought it might run one time but it doesn't.  Seems like the export to python inserted a couple lines # Load required toolboxes arcpy.ImportToolbox("Model Functions")‍‍ But at run time,  IDLE doesn't know the path to this toolbox.  Where do I find it? Traceback (most recent call last):  File "G:\elevation\lidar2010\Orthophotos\testiterativemodels\iterateRaster.py", line 14, in <module>    arcpy.ImportToolbox("Model Functions")  File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\__init__.py", line 125, in ImportToolbox    return import_toolbox(input_file, module_name)  File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\toolbox_code.py", line 452, in import_toolbox    toolbox = gp.createObject("Toolbox", tbxfile)  File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\geoprocessing\_base.py", line 381, in createObject    self._gp.CreateObject(*gp_fixargs(args, True)))IOError: The toolbox file Model Functions was not found. ‍‍ ... View more

I thought I have done this before but I can't make it work in Definition Query> Query Builder.  If I just want to select features from a feature class for an item that evaluated to even 10s,  like   MOD("MILE_NR" / 10) = 0 Can't I use MOD in my Definition Query?  Don't see MOD in the Query Builder Help, but I see it in the SQL reference docs.  Is it because the item MILE_NR is float, 0, not an integer? Didn't see INT in the Query Builder Help either, so I also tried MOD(ROUND("MILE_NR",0) / 10) = 0   Same message "invalid SQL statement was used" Do I need the do this selection in Python?  ... View more

I added a new user to a role in ArcServer 10.3.1, on SQL server, in a networking environment using a  windows domain. The new user added in in the form of domain\username.  I wanted to test the privileges I granted the new user, but couldn't figure out a good test.  I tried both the new user and an existing user's login to start ArcCatalog 10.3.1 as a different user (right click, run as a different user), ArcCatalog started I guess as that user,  but I couldn't seem to make the database connection as one of the users.  For Authentication type, the OS authentication choice grays out the User name, password boxes as I expected, but I would suppose that means the connection would be with my current machine login credentials, not one of the users.  If I choose Database authentication,  then I can't make the domain\username or just the user name with the user's password work to see any database on my server.  Or wait, maybe I am getting a different list of databases when I run ArcCatalog as one of these users and using OS authentication than when I start AC as myself. How did I get talked into using Windows OS authentication? I get so confused.  ... View more

I keep getting asked about this and wondered if there is an elegant solution.  For our PIT tag release locations, I am commonly asked how many river KM the location is up from the mouth of the stream and what the river km is on the receiving stream for the mouth of the  contributing stream. While I can use the  Identify Route Locations to point at these locations down the stream on a stream route layer like SSHIAP (in Washington State), and copy down the route measures,  is there a better method where I can overlay a point feature class on stream routes and get that information of point measure and confluence measures downstream?  Is there a way to get route measures from NHD?  ... View more

I thought I could trim an elevation raster to the outline of a non-rectangular. polygon with Copy Raster if I used the polygon as a mask in the environments, but I just got the entire raster in the output.  And I don't see Mask in the Environments section of the help for Desktop 10.3.1.   I thought I had done this before.  The only way I could figure out how to do it was create a new terrain out of the multipoints I have for the  smaller extent, and use the mask polygon as a soft clip in the terrain generation.  The I ran Terrain to Raster.  Is this the only way?  ... View more

For more the month, I have been trying to get in contact with the Puget Sound Lidar Consortium about the availability of LAS files for the 2015 Klickitat survey.  I've tried asking at the email links provided on the web page at Puget Sound LIDAR Consortium Home but haven't gotten an answer, and some of the email addresses provided on their website sent back a bunch of "The address may be misspelled or may not exist." or "huffmanp is not authorized to relay messages through the server that reported this error." which makes me wonder if some dead links or dead email addresses are not allowing my query to get through to anyone.  Does anyone have a up to date contact for the Consortium?  ... View more