Latest Contributions by JoeBorgione

Hardolph, Yes, two different polyline feature classes.  The problem with selecting common vertices is that whoever, or whatever, drew the lines really went out of their way to draw them as stupid as they could.   So, there are MANY vertices that aren't needed.  Like, instead of drawing one straight line, they wen't up and down the line 2 or 3 times placing random anchors.  So, it's just easier to reshape each line out of each feature class.  I was hoping for a way to reshape and get the line where I want it on one feature class, then just have the other "follow" the edit that was just done.   I'll give the other way a shot.  I'm an idiot, so I'm not completely sure I can accomplish what you said. First off, I'd say the guy who digitized the roads in the first place is the idiot; at the very least you know it's junk and you're trying to get it fixed! My suggestion is to concentrate your efforts on one feature class or the other.  You'll need to figure out which one you can get cleaned up the fastest, with respect to geometry.  Once that is completed you can use the spatial adjustment tool bar to transfer attributes/geometry to the offending lines.  I did a similar exercise for a set of county roads where the old TIGER data had great attributes but lousy geometry; the current feature of roads had great geometry but lousy attributes.  Using the spatial adjustment tool bar, I transferred to attribute values from the TIGER data to the good geometry and never looked back... Hope this helps- ... View more

Yes, I formatted the table to be compatible with DBF, not easy, there are so many ridiculous rules! But that worked.. Thanks! My personal approach is to bring the address data into a geodatabase of some flavor.  That way your geocoding results can be written to the same database.  Tidy little package. DBF files are so.... 80s... :cool: ... View more

Hello I'm trying to geocode addresses in Arcview 10. Every time it just says "there was an error trying to process this table." I use the 10.0 North America Geocode service or the US Streets Geocode service. Tried in Arcview and Arccatalog. Using Excel 2007 sheet. The addresses are correct spelled right and everything. Any Ideas? This is a farily common problem, but I'm a believer in teaching a man to fish:  try a search with the keywords excel, addresses.  You'll find a few posts.  A couple of them I've responded to.  Let us know what you find out! ... View more

How about a summary table approach?  Select all your unmatched addresses and summarize on what ever attribute you need to; that will give you a count / frequency.  Depending on how your address data is set up, you may have to parse out various address components; for example, if your address is all in one field like 1234 S Main St, you might want to get the street into it's own field with a split function (oops, there I go again with old fashioned vba). Hope this helps- ... View more

I keep getting "Source table must have an ObjectID column to perform a join by location" What? Ive never gotten this before...using ArcView 10 I can do the map in reverse by using my response Areas (polygon) layer and then joining my crime data to it, but it doesn't look like it is counting the data correctly. I cannot get it to work the correct way. I have tried an excel spreadsheet and a direct database connection to my access database, I have added an numbered field in excel and included the activity ID number in my access Qry (which is a unique auto number). I renamed this field ObjectID but still cannot get past this.....what am I missing. Thanks, Laurie Laurie-  look at what it's telling you and what you've posted: No OID and Excel....  Give this a try; import your excel spreadsheet into some flavor of geodatabase and you'll get a real live object id. Hope this helps... ... View more

Guys-  I'm an old gray-hair that's been working with ESRI products since 1990 and version 4.5 ArcInfo on a Unix box; there is always something to learn and share.  For the past 8 years or so I've been doing nothing but GIS/9-1-1 dispatch work because I saw a niche there, and I'm sure you know what I'm talking about. [A couple of weeks ago I got a call from a Police Captain saying he had just been to an ESRI presentation and wanted to know if we had the ability to map crime incidents.... Wow, that's a novel concept.... ] The ESRI forums in general are a great resource, and a specific user community like this one is a great place to come up with ideas, share them, and commiserate about problems. All the best- ... View more

Charles, Joe Please see here: http://resources.arcgis.com/gallery/file/geocoding/details?entryID=1A290038-1422-2418-88FC-098400376B88 Regards Nice!  thanks Bruce! ... View more

I am using 9.3.1; is this a tool in 10.x?  What 'brand' CAD are you using?  The two that I use (in different 9-1-1 centers) both provide utilities that check for address attribute errors. It would be a great tool for anyone who does a lot of geocoding. [Edited moments after initial post]  Just read your other post; I misunderstood that this was an older ArcInfo tool.  So, absolutely, an ArcMap version of the tool would be great.  Seems to me there is a users 'wish-list' forum or blog somewhere in ESRI-cyberland that accepts suggestions like this ... View more

This isn't much help, but here's a link to an even earlier thread: http://forums.esri.com/Thread.asp?c=158&f=2284&t=265675 Perhaps you need to log a bug with support? ... View more

Good for you!  Happy to help out. ... View more

There is a tool called Export Feature Attribute to ASCII that I just tried for the first time a moment ago.  You might look at that, and then see if you can figure out a way to automate importing that into access.  Certainly you could import it manually... Good Luck! ... View more

Joe- That does help a little bit. I already have an odbc connection to the access database. I actually use it in a model to geocode the addresses and output to a file geodatabase. I can't figure out how to geocode back to teh access database. Is there any documentation on that? Does it matter that I am using an access 2007 accdb? Sorry about that, I guess I read your post incorrectly.  I don't think you can directly write the results of geocoding to an Access database unless that DB was a personal geodatabase, and even then it would still be in form of a point feature class.  You would obviously have the Geocoding_Results attribute table there, for what it's worth. That is an interesting proposition though; somehow translate just those attributes in the gecoded results into a stand alone access db table... ... View more

So i have roughly 500K policies that I geocode monthly from an access database. The access database is populated from a Microstrategy report as I do not have direct access to the policy server. Most of the policies have previously been geocoded. The geocoded results are currently saved in a file geodatabase. I would like to create a workflow where I would only have to geocode new policies and not all policies every month. Any ideas? Can ArcCatalog geocode back to an access database? PS. I only have an ArcView license. Thanks in advance. Is it reasonable to create a realitionship between the monthly input records and those that have been geocoded already?  Perhaps through a unique identifier such as the policy number?  That way you could examine the incoming records against those already geocoded, and concetrate your efforts where they need to be.  Another approach may include modifying the Access schema by adding a field that indicates if a record has been geocoded or not. Can ArcCatalog geocode back to an access database?  The short answer is yes, you need to set up an odbc connection from ArcCatalog and your Access database. Hope this helps- ... View more

I am working on a project for the local police department.  When I open the excel file in arcgis9.3 all the information is correct.  However after the data has been geocoded the police identification number is not there.  The only part of the number that remains is the year, however the unique identification numbers have all turned to zeros.  I have tried to reformat the cell in arcgis to various number configurations under properties without success.  Any suggestions would be greatly appreciated. matt wittenberg university Do youself a favor and import your spread sheet into a table in some flavour of geodatabase and geocode that. Excel is for accountants. Database tables are for analysts. Let the flames begin. ... View more