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
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 serv
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
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 b
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)
>
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 expr
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
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
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"
>
> al
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 to
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 th
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 Table
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
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 savin
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 Tools>Tool Manager,
called "Coordinate Extractor". The description of the tool may indicated
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
th
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
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 non-numer
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
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?
Regards
Chris
Chris Brown - Cartographer
Resource Evaluation, Land Assets,
Hamersley Iron P/L.
Tel.+61 8 9327 2176
Fax.+61 8 9327 2478
mailto:[EMAIL PROTECTED]
Try:
Mapbasic Reference guide (v7) Page 641 - Appendix A: character code
table has a list of characters values from 32 to 255.
-Original Message-
From: Brown, Christopher (HI)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, 19 May 2004 10:17 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L Quick s
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
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 si
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 questio
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 de
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 200
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
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)
Hi all,
I want to split a collection of tab files one by one using one master file - I am
doing this within a For loop in mapbasic.
I need the data in the output tables to be the same as the input tables (ie all new
objects in the split table have identical attributes to the object they were sp
Ben,
If you issue the split command as a commndstr created by a loop rather
than the object split command directly, you can include all the data from
the target, as follows:
strCommand = "Objects Split Into Target Data "
For i = 1 To NumCols(gEditFile)
strCommand = strCommand + ColumnInfo(gEdi
30 matches
Mail list logo