Hi Colin, To my knowledge it is not possible to geocode to other than point objects. However, you can make an sql join to attach region objects to another table like this: Suppose you want to 'geocode' table a and you have your region objects i table b:
Select * ' or a.COL1, a.COL2, ... , a.COLn >From b, a Where b.IDcol=a.IDcol Into Geocoded_table Noselect The order (b, a) is important because you won't get the objects from table b if you switch the table order. Afterwards you can get the records that are not 'geocoded' also with SQL: Select * >From a Where IDcol Not In (Select IDcol From Geocoded_table) Into Error_table Noselect HTH S�ren Breddam -----Oprindelig meddelelse----- Fra: Colin Anderson [mailto:[EMAIL PROTECTED] Sendt: 22. december 2003 22:09 Til: [EMAIL PROTECTED] Emne: MI-L Is it possible to Geocode to a polygon? I'd never really tried it, and it must be relevant for attaching data to zip boundaries but... I'm in need of a simple routine that can geocode to a polygon. I appreciate that I can generate a centriod with the ID of a polygon, geocode to it, then load the polygon data back into the intended polygon. But, this process is slow and labour intensive. Also, I should state, I have a perfect 1 to 1 corellation of records, ie there are no mulitple geocodeable objects within each polygon. I realize I could use joins to do this as well, but I would like to the process to operate as Geocoding does, ie it should produce polygons only where there are matches. Thanks, Colin Anderson --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9676 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9677
