MI geocoding problem

Hi- we have 40,000 addresses that we would like to automatically geocode. We have the street address, which are not always accurate, as well as it zipcode, which we are comfortable with. The problem is that sometimes the address is incomplete, e.g. 100 winchester rather than 100 n winchester.

MI Drainage and Pipe analysis programs

Hi, Does anyone know of a good drainage and pipe analysis program compatable with MapInfo? Any help would be appreciated. Thanks Steve -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe

MI Strange Behavior

SQL Select records from two tables where table1.obj intersects table2.obj and you get a browser window. In my case, there were 77 records. I wanted these in Excel, so I select all and copy-n-paste. But it only pasted 34 rows. I tried it in Lotus 1-2-3, same thing. Somehow the pointers are not

Re: MI Perto Rico Census Data

Title: Perto Rico Census Data Hello, I've gotten a lot of stuff for - ugh - AkeView. There is census - down to block - , school districts, . One note if you get the school districts it has some 460 fields and you will need to open the dbf in some database and drop the last 400 or

RE: MI One vs. Many Objects

Stephen, My initial guess is that it is to do with the way that MapInfo does its intersection calcs. Like most GIS packages mapInfo probably uses an objects Minimum Bounded Rectangle (MBR) to initially determine if a object is likely to touch another object. The mathematical comparison on two

RE: MI Id question thanks

An alternative that I use to maintain the uniqueness of a column is to use a generic function that looks something like this: Function GetNextId(ByVal Tab_name as string,Col_name as string) as integer dim cmd as string Dim i as integer cmd = "select max("+col_name+") from

RE: MI Strange Behavior

Steve Are there any duplicate records - ie do you get the same results when you use a statement like select * from table1 where object intersects any(select object from table2) Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109

RE: MI geocoding problem

Alex, If you have a road dataset that includes the zipcode as an attribute and you have the zip code in the addresses perhaps you could do a series of geocoding zipcode by zipcode eg 1) - get list of all zip codes (eg select zipcode from streettab group by zipcode) 2) - select all roads with

RE: MI text to mif

Laith, you should just be able to rename the file back to *.mif. I've done this 100's of times without problem. You are on the right track but it must be something else you are doing. What error message are you getting - or if none EXACTLY what are you doing? I am sure that at the end of the

MI SUM text to mif

Thanks Chris for the simple answer, In Explorer, choose from the menu View Options Make sure that the "Hide MS-DOS file extensions for file types that are registered" is NOT ticked Try renaming again. Thanks Dawn for the initial idea. Laith == Laith Wark EDAW

MI: Need 104th Congressional District Boundaries

I have an undergraduate Speech Communications class that wants to look at voting patterns in 104th Congressional Districts. They are getting the voting behavior data for the precincts in Champaign, Ford, Douglas counties in Illinois for 1996. I need to obtain the corresponding state

MI Multiple columns selection in SQL

Hi dear friends, I want to select more than one columns in one SQL statement. How can I use a string or alias variable as the expression after the Select key word? Like I have a table named Test with four columns A, B, C, and D. Can I do this: Dim exp as String (or Alias) exp = "A, B, C"

MI Free No Repay Cash Grants! Up To $50,000

FREE CASH GRANTS, NEVER REPAY! You Can Get The Money You Need... To Start Your Home Business... To Consolidate Your Debt... To Go To college... To Start Your Home Business... Almost ANY Worthwhile Reason... Why? Foundations all over the United States GIVE away Millions of Dollars of

MI Id question thanks

Thanks to all who responded to my MI ID question. The solution of creating an ID column and updating column with ROWID was perfect. Got that project done in short order! I really appreciate the help. Fran Peck Peoria Unified School District 6330 W Thunderbird Rd Glendale, AZ 85306 Voice:

RE: MI Multiple columns selection in SQL

David, The easiest way to do this is to construct a command string and run that. eg Dim exp as String dim cmd as string exp = "A, B, C" cmd = "Select "+exp+ "from test" run command cmd Hope this helps Martin == Martin Roundill GIS Manager Waitakere City

MI: ADDING PICTURES - THANKS

Hi Mappers, Thanks to everyone who sent me pointers as to the freebies there seems to be quite a few I will give them all a try. Once again Thanks. Cheers Marie -- To unsubscribe from this list, send e-mail to [EMAIL

Re: MI adding map into Excel

Thanks to all the listers who responded - it's good to know you belong! I've had a look at all the replies, but it looks as if I was doing it right after all, so the problem must lie in my tables. MapInfo Tech Support her in the UK are looking at it as well, but the list is far, far quicker!

MI Re:A Question for Surveyors

Bill, I concur with the other answers to your question, sites are surveyed along a flat plane, and areas calculated likewise. With regards to 'getting more for your money' on a sloping site, it is far more expensive to develop a sloping site as opposed to a flat one. Unless you're building a dry

MI test do not open

test. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

MI To: Mapinfo-L mapinfo-l@lists.csn.net

subscribe MAPINFO-L -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

RE: MI A Question for Surveyors

I will pick one small detail that may have sad consequences in the application of zoning by-laws. If Matts says "... But the house you build will not get bigger unless you make the floors sloping as well. I may add that it may even "grow smaller" if setbacks (imposed minimum distances from lot

MI id question

Fellow listers, This is my week for strange issues, I know! When I query a table and save a copy of the query table to Microsoft Access, there is a column with the MapInfo ID number. I have a list of student points that need to be repositioned and querying by the MI ID number would be great.