A few thoughts\ I Assume you are geocoding a list of addresses using a street file (such as street pro) by From/To Left/Right, then you are selecting all from the geocoded table where Block_Region_Table.obj Contains GeoCoded_Table.obj into Some_Table_Name. You then counted the records- Select Count(*) from Some_Table_Name into selection. This last one was 29 records more then the original table you geocoded- Yes?
Check to see that there are not duplicate records in the data set being geocoded- Select Count(*), Address From MyTable, group by address into Group_By_Address then run Select * from Group_By_Address Where Count > 1 into selection. This will give you duplicates. However, this should not cause a different record count from the base table to the joined table, duplicates will geocode on top of each other. IF you are using an ID field to geocode on, then duplicates are a bugger. For example , I geocode records by Parcel Number. The township has a lease for a well, the parcel map accounts for the leased area and the property area with the same parcel number. When I geocode by parcel number, this one parcel will not take the records because it doesn't not know which region to go to , both having the same ID. Check to see that the road line work is not duplicated where the errant objects appear, perhaps a copy and paste paste happened. Click road with info tool, and there should only be one record from the street file. Similarly, check to be sure there are not 2 region objects over one another in the block region file. Check the data in the from left, to left, from right, to right fields, reversals here will cause the geocoded object to show up on the wrong side of the street, or from the wrong end of the line (100 Main Street shows up where 198 Main should be). Also, line direction must be towards increasing street number direction. In the Road center line table turn on show direction under the display button, all the blue arrows should be pointing the dame way in each quadrant, radiating from the intersection of the meridian streets. N. Main Street lines point N, East Center Street lines point east, etc. If you have a number of lines in the wrong direction, check directions mag for a tool that reverses line direction. William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: REBECCA K MURRAY [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 09:49 To: [EMAIL PROTECTED] Subject: MI-L Double-coding addresses Dear List I geocoded 8000+ addresses and then did a join to count the number of addresses on each city block. The total number of addresses reported under sum when doing a query calculate-- statistics was 29 addresses larger than it should have been. I eventually found the first of these addresses that had been counted twice. It was counted once in the correct block which was on the left-hand side of the street and once in the block on the right-hand side of the street which was incorrect. Unfortunately, it was the second address in the file. The default offset of 12 survey feet was never altered while geocoding or at any other time. I have never had this happen before. Has anyone else encountered this problem with MapInfo 7.0 or 6.0? I had to iteratively re-gecode the addresses using smaller and smaller numbers of addresses until I found that the second address in the file was the first address that was doubled. Does anyone know why this problem has occurred? Is there a way to avoid this happening again? Is there an efficient way to find which addresses have been tallied more than once? Doing a "reverse"-join with the address that had been doubled in which I join this address with the block file and assign the block number of the block that contains this address to the address resulted in only one block being assigned to this address that was doubled and it was the wrong one. I greatly appreciate any help on this. Rebecca Murray --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9576 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9584
