Latest Contributions by DaytonPoff

Hi, I'm sorry if I'm a little late to the party. I'm also trying to load SSURGO data into the LGDM. From what I'm seeing the SSURGO data has two parts. The Mapunits which are the polygons actually representing different soils, and related tables called component tables that come as pipe delimited text files with no headings. To load all the data into the LGDM these tables have to be combined. The following link (ESRI's SSURGO Downloader) does a great job of getting the process started. The data that you can download has a Mapunits Feature Class for your watershed that already includes a lot of the data from the components tables. I will refer to this table/feature class as "Mapunits_Merged" because it is the original SSURGO Mapunits table joined with the various components. Features from the Mapunits_Merged table can be directly imported into the LGDM once you figure out the field mapping. The problem is the component percentage fields that the LGDM ask for are not included with the Mapunits_Merged table. There are two tools that can be downloaded from "ArcGIS Reources" that were probably used to make the transition from SSURGO data to geodatabase. According to the documentation the percentages missing from Mapunits_Merged are part of the output from these tools. SSURGO Soils Tools: Part 1 SSURGO Soils Tools: Part 1 These tools require a geodatabase with two tables as inputs. One table being the original SSURGO Mapunits table and the other being the components table. There doesn't seem to be an easy way to get the pipe delimited text files into a readable format that can be used as an input for the two tools. I will be emailing the creators of the tools to find out how to derive the components table. I will update when I find out more info. Sorry if you've already figured this out. Any additional information that I could use to help my data loading would be much appreciated. Thanks, Dayton ... View more

Hi Rachel, I'm having about the same problem. When I click on the map to pick the address ArcMap throws my point somewhere completely different than where I clicked. The only solution I've found is to pick the address three times. I do this because the second time doesn't usually put the point where I click either. Funny...never had this problem with 9.x. When you pick your address does it add x,y coordinates in the geocoding results for the point you are working on? -Dayton ... View more

Dayton-   If you navigate to C:\Program Files\ArcPad 8.0\Developer\Samples\RelatedTables, there is a comprehensive code sample that shows how to creates forms for related tables. Please see my other post. http://forums.arcgis.com/threads/1884-Customizing-Related-Table-Sample-.vbs-Script I am aware of the Related Tables sample and Inspections.vbs sample code. However I have so far been unsuccessful in making the code work with my data. According to ESRI, ArcPad 10 will allow users to select certain related tables during checkout with the ArcPad Data Manager. Also, the form wizard will recognize related tables as it does the master table. In other words scripting won't be required. Forms can be built on related tables out of the box in ArcPad Studio at version 10. -Dayton ... View more

Just an update. This is the response from ESRI Support. "...this bug is fixed in ArcPad 10." If anyone has any ideas in the meantime I would greatly appreciate it. ... View more

Is the SIP checkbox ticked on or off in your combo box's properties? ... View more

Quite a few options are available on the drawing toolbar. This is normally docked at the bottom of the ArcMap session. Someone actually pointed this out to me after I had been using ArcMap for three years. Definitely a time saver. Select the text on your map and then use this toolbar to make changes. Hope that helps! ... View more

I confirmed with another user that 8.0.3 has the Related Tables samples. She applied the service pack and now has the files I've been talking about. Congratulation on getting your code to work. I finally worked out all the bugs in mine and it is working too. Thanks for the advice. Looks like we went about it two separate ways, but were both successful in the end. ... View more

Finally got the code to work. Turns out I forgot to initiate one of my controls and forgot to add the index control to my signs page. In the Riverside sample it is the #/# on the Inspections form that signifies what inspection is currently being edited. I still have to go through the entire check out/edit/check in process, but so far so good! ... View more

Jane, I'm sorry I wasn't able to upload the script. There is licensing agreement included with the code samples that says I'm not allowed to post the code to the forum. I agree the code isn't very simple. And after customizing it to fit my data I have well over 1000 lines of code. Good luck with making it work. I'm still working on mine as well. Please give us updates on how you are progressing. ... View more

Check out the forum I started called "Customizing Related Table Sample .vbs Script". I'm trying to do basically the same thing. Inspections.vbs may help point you in the right directions in regards to SQL scripting. Check out the following two directories on your computer. C:\Program Files\ArcPad 8.0\Samples\Riverside (includes the Riverside_mdb.axf sample) C:\Program Files\ArcPad 8.0\Developer\Samples\RelatedTables\RelatedTablesForm (includes the Inspections.vbs sample) Hope that helps! ... View more

Jane, I am checking with ESRI to make sure there are no legal ramifications for posting the sample to this thread. I'll know something soon. Thanks, Dayton ... View more

This sample may have been included with Service Pack 3. Open ArcPad and Click the glowing ArcPad button. Then click About ArcPad to see if you have Version 8.0 SP3 (Build 7). I downloaded the service pack from ESRI's website at the following link. http://resources.arcgis.com/content/patches-and-service-packs?fa=listPatches&PID=26 Unfortunately you have to completey uninstall ArcPad and then reinstall the service pack. If you want to do that and let me know how it goes you can email me or just reply back on this forum. -Dayton ... View more

Hi Jane, If ArcPad is installed in the default directory then here is the path to the script. C:\Program Files\ArcPad 8.0\Developer\Samples\RelatedTables\RelatedTablesForm\Inspections.vbs ... View more