RE: MI-L points with same lat/lon

Hi Robert, I'm not sure whether you saw this solution I sent before. I just checked and found some errors in it, but it works, without saving any queries ! Grouping all reocrds by LAT and long, and counting the number of records at the same location: Select LAT, LONG, LAT + # + LONG LAT_LONG,

MI-L MapXtreme query

Hi We've recently bought MapXtreme to commence development of an intranet Web mapping service for the Authority. This will then be expanded to out Extranet and finally the Internet MapXtreme is held on it's own server, as are the intranet and internet. The GIS data is held on yet another

MI-L Logical fields in SQL select

Err, I seem to be having a problem with something that should appear straightforward! I've got a table with a number of logical fields and when I query even field using the following: Select * from police_stations where HQ = false all that is returned are the records that are TRUE. I've tried

Re: MI-L Logical fields in SQL select

Hi Greg Try:- Select * from police_stations where not HQ Regards Martin - Original Message - From: Driver, Greg 9434 [EMAIL PROTECTED] To: MapInfo-L (E-mail) [EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 9:06 AM Subject: MI-L Logical fields in SQL select Err, I seem to be having

MI-L SUM -MI-L Logical fields in SQL select

Thanks to Mark, Martin and Photogrammetry GIU (!) who suggested either inverting the selection or using the following : Select * from police_stations where not HQ Thanks Guys. -Original Message- From: Driver, Greg 9434 Sent: Tuesday, May 18, 2004 09:07 To: MapInfo-L (E-mail)

RE: MI-L Labelling expression help needed

David Assuming you can do it in MapBasic, to get your label try: lnPos1 = InStr ( 1, lcLot_string, ) lnPos2 = InStr ( lnPos1+1, lcLot_string, ) lcShort_string = Left$ (lcLot_string, lnPos2-1 ) HTH Terry -Original Message- Greetings List, I wish to label a map with an

RE: MI-L Coordinate Conversion

Willie I put a VB class up on Directions a couple of years ago, based on an algorithm that the Ordnance Survey made available as an Excel spreadsheet. (Look for utmconveter-380.txt - it was spelt correctly when I uploaded it I'm sure!) The class instantiates on the values for the UK but they are

SV: MI-L Labelling expression help needed

Assuming the database field (column) is called xxx, you can label with the following expression: Left$ (xxx,InStr( InStr( 1,xxx, )+1,xxx, )-1) Regards Bo Thomsen GeoConsult I/S Denmark -Oprindelig meddelelse- Fra: David Reid [mailto:[EMAIL PROTECTED] Sendt: 18. maj 2004 03:44 Til:

Re: MI-L Logical fields in SQL select

On Tue, 18 May 2004, Driver, Greg 9434 wrote: Err, I seem to be having a problem with something that should appear straightforward! I've got a table with a number of logical fields and when I query even field using the following: Select * from police_stations where HQ = false all that

MI-L New User, Have Question

Im using MapInfo 7.0, my company wants me to geocode their database of sites, which is simple, then create a program where an end user can input a zip code, and the program finds all the sites within a 15 mile radius. I have a few idea how to do this, but I do not have MapBasic, is their anyway

RE: MI-L Testing to ensure a string is numeric

Spencer, In terms of speed, I would mostly stick with just the val function. Just the idea that converting a string to a number and back to a string and comparing them is fraught with danger, at least for floating point. Note that the val function returns a number. It returns 0 for things

RE: MI-L Coordinate Conversion

Since this is a MapInfo mailing list, I suppose we should let you know that you can do this in MapInfo without any special add-ons or MapBasic applications (although you should use MapInfo 7.0 or later to preserve coordinate precision). 1. Import your list of coordinates into a table. 2. Use

MI-L ann: Future of Geomatics Policy in Canada

hello all, FYI, I thought this would be of interest to some of you Canucks as there was little mention of this event out there.. I'll be there! On May 19, 2004 a one day workshop is to be held in Victoria, BC to discuss policies that will govern geomatic initiatives in Canada, and in particular

Re: MI-L points with same lat/lon

Thanks Peter. That is more along the lines of what I was expecting. It works great. Very cool. -Bob Peter Horsbøll Møller [EMAIL PROTECTED] writes: Hi Robert, I'm not sure whether you saw this solution I sent before. I just checked and found some errors in it, but it works, without saving any

RE: MI-L Coordinate Conversion

Actually, it is more simple than this. Several years ago the only way to accomplish this task was the method described below. However, there is now a tool that comes with MI, which you can load through ToolsTool Manager, called Coordinate Extractor. The description of the tool may indicated

MI-L Quick stupid question

I couldn't find the answer to this anywhere, and the question is frustratingly simple: I just want to add a dollar sign to the beginning of a label, to indicate cost. Right now, the number just reads as 111.11, and I just want $111.11. How do I change the expression on the label to allow for

RE: MI-L Quick stupid question

Josh, give the Chr$(36) a try, 36 is the ASCII decimal value for the $ dollar sign. Chr$(36)+(column_name) HTH David Reid -Original Message- From: Josh Forsythe [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 11:54 AM To: [EMAIL PROTECTED] Subject: MI-L Quick stupid question I

RE: MI-L Testing to ensure a string is numeric: another approach

List, I just wanted to point out another solution from Bill Thoen that seems to be pretty bulletproof: function IsNumeric (byval sVal as string) as logical dim i as integer For i = 1 to Len(sVal) If NOT InStr (1, 0123456789.+-e, mid$(sVal,i,1)) Then 'String contains a

MI-L Thank you...

To everyone that helped me out. Of course it was something as simple as a plus sign. And it's only Tuesday? Thanks again, Josh Josh Forsythe Engineering Assistant Midwest Wireless

MI-L MapShop Projection Question

Hi Listers For those of you using MapShop, hopefully you can help me. I have the problem that when I open up my aerial photography behind a series layer the projection changes putting my series blocks on an angle rather than having them straight as they were created. This happens even if I open

RE: MI-L Quick stupid question

On Wed, 19 May 2004, Brown, Christopher (HI) wrote: I know Chr$(13) gives a character return as well but could someone point me to where there is a list of all the Chr$ values? It's the decimal values of the ASCII table. Online, you can view the list at http://www.asciitable.com/ (kind of

RE: MI-L Quick stupid question

ASCII stupid question, get a stupid ANSI MWOOHAHAHAHAHAHahahahahah (sorry - i couldn't resist) Mat -Original Message- From: B. Thoen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 19 May 2004 1:01 PM To: Brown, Christopher (HI) Cc: [EMAIL PROTECTED] Subject: RE: MI-L Quick stupid

Re: MI-L Quick stupid question -- Key Codes

0-31 Control Codes These are from the old teletype days and contain formating commands and even beeping the speaker #7 [bel] Some are very functional in providing a text based database, even the 911 data has #2 [start text] #3 [end text] #28 [file separator] Most used in MapInfo/MapBasic [in

RE: MI-L MapShop Projection Question

Carolyn I'm not using MapShop, but I have NATMAP Raster Mapsheets - the 2003 Release - and discovered that with version 1.4 of the Raster Viewer the paper edges of each map are visible - the legends, etc. And some sheets appear skewed on the screen by 5 degrees or so. A friend in Sydney has 2002

MI-L MapX in C#.NET

Hi, I'm Writing an app in C#.Net with an embedded MapX control (this applies to all you VB.NET people too so don't go deleting this message!) I have a problem with displaying a MapX map on a tabControl which is a part of a User Control. If I put the map on the first tabPage in the tabControl it

MI-L MB Colour codes

Hi - would anyone know the colour codes for Grey and Orange. Thanks in advance. Samuel Shelley GIS OFFICER FIRE MANAGEMENT UNIT TASMANIA FIRE SERVICE GPO Box 1526 HOBART, Tasmania AUSTRALIA, 7001 (CNR ARGYLE AND MELVILLE STS, HOBART 7000) EMAIL: [EMAIL PROTECTED] PHONE: (03)