Latest Contributions by JamesGibson

‎01-22-2016

Thanks Xander, I will have to come back on Monday to do some more verifying as I will not have access to my computer this weekend. I appreciate everyone's help!

‎01-22-2016

Here is a stripped down version of the excel file with personal info removed, which still gives me the same error messages. https://www.dropbox.com/s/ejcywo7vyqi9mdg/test.xls?dl=1 If anyone wanted to test using the actual file.

‎01-22-2016

I was not able to find an excel file that worked at one point, but I checked the date mode and the box is unchecked (using 1900 I suppose) I tried checking the use 1904 date mode and reran the tool, and it worked just fine. Does this not work by using the 1900 date mode? edit: That's odd, it only seems to work using 1904, when I change it back to 1900, I continue to receive the same errors.

‎01-22-2016

I also just tried to save the file as a 2010 xlsx and run the table to excel tool, while leaving the default output location to the default.gdb and this is the error I get. Failed script ExcelToTable... Traceback (most recent call last): File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\ExcelToTable.py", line 254, in <module> arcpy.GetParameterAsText(2)) File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\ExcelToTable.py", line 244, in excel_to_table row = field.validate_value(row, workbook.datemode) File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\ExcelToTable.py", line 100, in validate_value value = xlrd.xldate_as_tuple(value, datemode) File "C:\Python27\ArcGISx6410.3\lib\site-packages\xlrd\xldate.py", line 80, in xldate_as_tuple raise XLDateAmbiguous(xldate) XLDateAmbiguous: 1.0 Failed to execute (ExcelToTable). Failed at Fri Jan 22 14:34:55 2016 (Elapsed Time: 19.67 seconds)

‎01-22-2016

Oh ok, I see what you mean. I tried using the Excel to Table within ArcMap and I still get an error. This time it shows that the maximum record length has been exceeded. Running script ExcelToTable... Failed script ExcelToTable... Traceback (most recent call last): File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\ExcelToTable.py", line 254, in <module> arcpy.GetParameterAsText(2)) File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\ExcelToTable.py", line 225, in excel_to_table template=tmp_table) File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\management.py", line 15242, in CreateTable raise e ExecuteError: ERROR 999999: Error executing function. The maximum record length has been exceeded. Failed to execute (CreateTable). Failed to execute (ExcelToTable). I just did a little bit of research, the excel file is a 97-2003 version. But the total number of rows is 59399 with 31 columns, which is under the 65,536 rows by 256 columns limit. So it should still work, yes?

‎01-22-2016

Darren Wiens Yes, I can open the excel file if I double click the file manually, and also from the full path of "E:\\City of Belton Projects Folders\\Maps and Data\\Tax Appraisal Office\\2016.01.15\\01152016 BellCad_Ownership_Data\\SP_OtherISDs_01152016.xls" minus the additional backslashes. Xander Bakker If I change the script from ExceltoTable to TabletoExcel, I get AttributeError: 'module' object has no attribute 'TabletoExcel_conversion' But that shouldn't work, since it is trying to convert the excel file, to an excel file, correct? The excel file is in the correct format. If I import the excel in arcmap, I can join it to the Shapefile with no problems. It just doesn't seem to work the Python way.

‎01-22-2016

I am having a problem with a simple line of python code here -- and I don't know why this is happening. There was a point in time where I did not receive this error, so I know it should work. What I am trying to do: Every month I get a Tax Data CD from the Tax Office, and I am trying to streamline the process of combining the ownership XLS to the Parcel Shapefile. I have a program I've written in VB which will allow me to select all the files necessary for the join and run the python script. (this stores the input files to a variable in an .ini file, which the python script reads the variables with ConfigParser() When I run the script, I get this error message: WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero Traceback (most recent call last): File "C:\Users\anotgrass\Desktop\test.py", line 8, in <module> arcpy.ExcelToTable_conversion (XLSInput, tableOutput) File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\conversion.py", line 44, in ExcelToTable raise e ExecuteError: Traceback (most recent call last): File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\ExcelToTable.py", line 254, in <module> arcpy.GetParameterAsText(2)) File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\ExcelToTable.py", line 244, in excel_to_table row = field.validate_value(row, workbook.datemode) File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\ExcelToTable.py", line 100, in validate_value value = xlrd.xldate_as_tuple(value, datemode) File "C:\Python27\ArcGISx6410.3\lib\site-packages\xlrd\xldate.py", line 80, in xldate_as_tuple raise XLDateAmbiguous(xldate) XLDateAmbiguous: 1.0 Failed to execute (ExcelToTable). I've narrowed the error down to the ExcelToTable conversion, and now have a test script solely for testing this out. Basically, I have an XLS file that needs to be converted to a temp.dbf file, which later in the script lets me join the table to the Shapefile and create a new shapefile. When I run this simple script, it creates the temp.DBF file, but it doesn't finish creating it, and then I get the error message. Does anyone know what is going on? Thanks!

‎01-04-2016

Are you looking for something similar to what I was asking/looking for? Help finding similar sounding street names I found an open source program that I edited for personal use. I can load a list of street names, and when I type in a name, it will use the soundex, or metaphone method depending on which option I choose, to find exact or similar sounding names. Scroll to the bottom to see.

‎01-04-2016

An update - I never figured out how to do this via a web interface, but I did find some source code available in C# that works and produces pretty much exactly what I need. Phonetic String Comparison with Soundex I converted it to VB using a C# to VB tool, and fixed any conversion errors manually to make the program run correctly. (I needed to edit the code to personalize the program more, and I know VB more than C#) I successfully converted the provided SoundEx code to VB, but couldn't figure out how to convert the supplied Metaphone code to VB. So I searched the internet and found a different Metaphone implementation and got it working that way. (Honestly, I cannot find where I found this since I lost all of my bookmarks.) Here is what I came up with. I added to the code a way to load a text file from a directory, and save this location to an .ini file so that I don't need to reload the street names list every time. The only thing to do now is export my Street Centerlines to an excel when I add any new street names to the list, format it to show only my 'rd_name' column, and save it as a text file.

‎11-18-2014

I recently needed this function and found that tool today (The one by Dan). Is there anyway for it to output files into a gdb? In my case, I needed it to split up a street maintenance plan by category, but when it splits the files out to a shapefile, it truncates the header name.

‎11-18-2014

Agh, I feel like this is too complicated for me to understand lol.

‎11-13-2014

and just to clarify, I need to be able to input a name, and have a list of all similar names in the database listed on screen.

‎11-13-2014

Thanks Paul for your help! However, we do not have ArcServer. And I kinda understand in theory how these scripts and things work, but i'm not understanding how a user can input a name, like a form with a submit button to search for similar names in a streets list/database. Also, i'd like to see how to do this using the double metaphone method if anyone knows how to do that.

‎11-13-2014

Hi all, A quick summary of myself/what i'm trying to accomplish: I work for the City of Belton, TX. I've been doing city work for about a year and a half total, so I am still learning a lot in this position. Among many things that I do for the City, I have the privilege of assigning 9-1-1 addresses and approving new street names in subdivision plats that come to my table. (I've been doing 9-1-1 addressing for about four years now, thanks to my previous position before working at the city) After a bombardment of new plats coming to my office these last few months, I've decided to try and find a way to help speed the process of finding existing duplicate/similar sounding street names - as it takes so long to do this manually. I've tried a bunch of searches on this topic and have found a few solutions - I just don't have the experience to implement them. What I found were different ways of doing 'fuzzy' searches: soundex, metaphone, double metaphone, and a few others. I even found a website that pretty much does exactly what I need. http://www.johnstonnc.com/mainpage.cfm?category_level_id=771&content_id=3543 which uses an SQL soundex search. I sent an email to the webmaster to see how they did that, and was given this answer. "For the search you mention, it is a simple SQL “soundex” search. The query is below: SELECT DISTINCT ROAD_NAME, SUFFIX, COMMUNITY FROM TABLENAME WHERE SOUNDEX(ROAD_NAME) = SOUNDEX('#Form.STREETSOUND#') ORDER BY ROAD_NAME, SUFFIX, COMMUNITY" My issues: 1. I hear that soundex searches will work, but there are better ways to do this, such as the double metaphone way. 2. It would be great to implement this on our website, but I don't have that type of access; I need to be able to do this locally. 3. I am not familiar with creating a MYSQL database. 4. I need to easily update the streets list. I need to have a form where I can enter a potential street name to make sure it doesn't exist already or have a similar name in the database. (Beach vs Beech) How would I go about implementing this? Is there a way to do this through Python? Do I need my streets list to be in a MYSQL database? Right now, they are in my FileGDB, and an excel file. Thanks for any help, Anthony.

Online Status	Offline
Date Last Visited	‎09-27-2023 05:44 AM

My Ideas

Latest Contributions by JamesGibson

Re: ExceltoTable_conversion error

Re: ExceltoTable_conversion error

Re: ExceltoTable_conversion error

Re: ExceltoTable_conversion error

Re: ExceltoTable_conversion error

Re: ExceltoTable_conversion error

ExceltoTable_conversion error

Re: Tool to evaluate similar sounding street names

Re: Help finding similar sounding street names

Re: Split By Attribute Tool

Re: Help finding similar sounding street names

Re: Help finding similar sounding street names

Re: Help finding similar sounding street names

Help finding similar sounding street names

Re: ExceltoTable_conversion error

Re: ExceltoTable_conversion error

Help finding similar sounding street names