I am attempting to compress 1.2 million ZIP plus 4 rows into fewer rows based on the city with which they are associated. I have an mbx that will provide the range for each city, i.e. St. Paul, 55101-0001 to 55195-9998, however the range is inclusive of ZIP+4's that are not in St. Paul, 55113-0001. I think I have an idea of how this can work, however, the spirit is willing but the coding is weak. I sorted the file by ZIP+4 and then updated recnum with rowid, which means when St. Paul ZIP4's are selected, those not contiguous breaks in the data will show up as non-sequential recnums. That is as far as I've gotten. I am not looking for a completely written mbx, maybe a few pointers or even snippets of code I can run in the MapBasic window. Thank you.
____________ Kent Treichel Analyst-GIS Tax Research Minnesota Department of Revenue MS 2230 600 North Robert St St. Paul, MN 55146-2230 651-556-6150
