Latest Contributions by ZacharyLehmann

‎01-10-2018

Sorry maybe I can explain it better. Basically there is an Access database that houses all of the data the group uses. I have saved exports which can put updated data into four excel tables that I had been importing into the file geodatabase as tables. But it seems to break the relationships on the webapp side of things when I do that. It sounds like your method would probably do the trick. I was hoping there was a way I could just link/relate the tables in the geodatabase to the excel tables but I haven't been able to find a way of just "refreshing" those tables.

‎01-10-2018

Hi all, So I'm volunteering for a park conservancy and helping them build a web app to track some data about their efforts in and around the park. The app side is easy enough. All the data they want displayed is in an Access database. Currently I have saved exports for all the table the app needs. When they update the DB they just run those preset exports and I'm left with a folder of Excel tables formatted to match what the app needs. The problem I'm having and can't seem to find a solution to in my forum searches is how to go about updating the tables in the file geodatabase I'm using with these excel tables without having to re-import/delete them and hopefully allow them to keep the same relationship class. Does anyone know of a way to do this better than this? I really just want to save over the current tables in the geodatabase with the new ones.

‎01-05-2018

Hi all, So I'm volunteering for a park conservancy and helping them build a web app to track some data about their efforts in and around the park. The app side is easy enough. All the data they want displayed is in an Access database. Currently I have saved exports for all the table the app needs. When they update the DB they just run those preset exports and I'm left with a folder of Excel tables formatted to match what the app needs. The problem I'm having and can't seem to find a solution to in my forum searches is how to go about updating the tables in the file geodatabase I'm using with these excel tables without having to re-import/delete them and hopefully allow them to keep the same relationship class. Does anyone know of a way to do this better than this? I really just want to save over the current tables in the geodatabase with the new ones.

‎09-09-2014

Indeed!

‎09-09-2014

I appreciate the answer! I couldn't figure out how the data was becoming classified. Turns out when I was extracting a portion of the DEM I was using I had the bit number set too low. I changed it to 64-bit so the raster remained continuous after extraction and now it works perfectly!

‎08-27-2014

Hey all, I'm by no means an expert with GIS, but I have been using the software for over 8 years and know my way around pretty well. I've been having some trouble with the slope tool that I'm hoping this community might be able to help with. I'm using 1-meter LIDAR data to create this slope data set. The result is the image attached here. Now at first I thought there was some error with the tool since it is making these lines all over the data set that are basically where the pixel values jump from one value to another. That's how the tool is supposed to work and apparently there are a lot of areas where the adjoining cells are the same value leading to this weird topo line look. My question is does anyone know of any tips for smoothing this surface out. The model I'm trying to create needs smoother surface than this to really work and I'm not sure how to go about it considering that it's technically doing everything it's supposed to. Does that make any sense/can anyone help? Appreciate it.

‎07-15-2013

It uses NMEA yes. I seem to have figured it out. I was shutting down the unit (old windows troubleshooting habit). If you hold down the power button and select reset instead of power off, it works. After I did that I could use the GPS search tool (little binoculars) and didn't have any trouble after that.

‎07-15-2013

Hey everyone, Hoping someone can help me solve this problem. I have just received my second Archer unit in the mail with the GPS receiver installed and the ArcPad software installed ready to go. When I boot up ArcPad I click on the find GPS button under the GPS preferences menu in ArcPad, and it cannot find the receiver. The exact same thing happened with my first unit. I fought with settings for hours and couldn't get it to work. Finally I just restarted it for the 6th or 7th time and it worked and it's been working ever since. I'm currently in battle with the second unit with the same symptoms but restarting it doesn't seem to be fixing it this time around. I've checked all my device settings, the bauds and com ports are all correct, ArcPad just can't find the damn thing. Even if I manually enter the com port it doesn't receive any GPS signal. Any help would be greatly appreciated. I'm pulling my hair out over this one!

‎05-07-2013

Huh, it seems to be working now. It had frozen up after I did all the steps you suggested before, so I task manager-killed it. Now that I think about it I don't know if I restarted the application after your suggestions. So now that it's opened up again it seems to be working fine. I'm not sure which step was the one that got it to work sadly 😞 But thank you for the help! You were very quick with your responses.

‎05-07-2013

Run windows Disk Cleanup Check to see how much disk space you have on your machine. If less than 12% clean it out. Defragfragment your hard disk. Clear your web browsers history Do a Ctrl-alt-Delete pull up the task manager and sort by which program is chewing up the most memory. chances are it is not an ESRI issue but a hardware software issue on your own computer. What is the size of your MXD that you are using? If it is over 3000 kilobytes you should create a new mxd. If it is over 10,000 kb you have seriously large mxd issues. My drive has a lot of space on it still, almost a brand new computer. I cleaned the disk, and defraged it. Browser history and cache was cleared the other day for a different issue. My task manager showed arcmap being the top memory eater so I don't think that's the problem. My MXD file is about 600 KB. No luck. I can load raster data no problem and work over my server on other applications without an issue. It doesn't feel like a networking or computer issue but again I am no IT specialist.

‎05-07-2013

Hey all, I hope this is the right place to post this. I have been using ESRI's basemaps since they came out as my aerial imagery source for my maps. It seems like just the last couple of months the speed of these basemaps has gotten so slow they're pretty much unusable. I don't know a lot about networking or how this data is served up to me, all I know is they used to work great, and now I basically can't use them. I've searched the forums for some solutions but all of the threads I've found dated back to 2010 or so and I don't think they're relevant anymore. My specs: Arcmap 10.1 Build 3035 Windows 7 Professional SP1 8 gigs ram 64 bit OS 2.4 core i7 cpu Download speed: 5.85 Mbps Upload speed: 5.64 Mbps Things I've tried to fix this: Added all the ESRI products to my firewall's allow list Moved cache to the local C: drive Defraged and cleaned C: drive (this seems to be what helped!) , cleared browser history and caches Any help is appreciated! Hopefully it's an easy fix. I'm sure other people in my office are having similar issues. Thanks in advance!

‎11-12-2012

There are no special characters in the field headers of values.

‎11-09-2012

I'm sorry that was the best title I could come up with to describe what is going on! This problem is currently happening with the Reclass to Table tool in Spatial Analyst, but I've had this problem trying to join tables to shapefiles as well. I'm using Desktop 10.1 with the Spatial Analyst toolset. Here is the situation. I have a raster with a value field and a count field, pretty generic. I also have an excel table with a value field and an index field. I'm trying to use the Reclass to Table tool to reclassify the raster using the values in the index field of the table. When I open the tool and setup everything, the index field does not show up as an option under the Output Value Field drop down box. I tried entering it manually but that didn't work either. The field shows up just fine if I open the table in ArcMap and the settings for each field in the table are identical. The same thing happens when I try to join the table to the raster. The index field just doesn't show up in the drop down box. Does anyone know why this is happening? I've been pulling my hair out for hours now. Any help would be appreciated!

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

My Ideas

Latest Contributions by ZacharyLehmann

Re: Best Workflow for Updating File Geodatabase Tables

Workflow for updating file geodatabase tables with relationship classes

Best Workflow for Updating File Geodatabase Tables

Re: Advice for using the slope tool in Spatial Analyst

Re: Advice for using the slope tool in Spatial Analyst

Advice for using the slope tool in Spatial Analyst

Re: Juniper Archer Handheld GPS with ArcPad - No GPS device detected error

Juniper Archer Handheld GPS with ArcPad - No GPS device detected error

Re: ArcMap Aerial Basemaps take forever to load

Re: ArcMap Aerial Basemaps take forever to load

ArcMap Aerial Basemaps take forever to load

Re: Imported Tables Not Displaying All Fields In Tools

Imported Tables Not Displaying All Fields In Tools