Hi Evan,
I don't think MapInfo allows you to combine columns or to use functions when
creating a join. It hasn't worked for me in the past.
You could try creating a new column and populating it with either
Table2.state+Table2.community in Table2 or Right$(Table1.cmtyno,4) in Table1,
and then do a join using this new column.
Don
Message: 1
Date: Thu, 31 Aug 2006 10:00:58 -0700
From: "Evan MacDougall" <[EMAIL PROTECTED]>
Subject: [MI-L] Complex SQL Joins
To: <mapinfo-l@lists.directionsmag.com>
Message-ID:
<[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"
I am trying to join two tables in MapInfo where there isn't a column-to-column
match. In Oracle SQL I can do a join on substrings of a panel or on a joint
expression of two columns matched to one.
However, when I try this in MapInfo it gives me an error about my join not
being valid.
Table1 cmtyno (char 6) = Table2 state (char 2) + Table2 community (char 4).
So I try this as my join:
Table1.cmtyno = (Table2.state+Table2.community)
MapInfo throws me an error saying it's an invalid join.
Then I try this as my join:
Right$(Table1.cmtyno,4) = Table2.community
This also causes MapInfo to give me and error about an invalid join.
Is it possible to join these two tables without creating new columns?
Am I just getting my syntax wrong or have I found a limitation in MapInfo?
-Evan MacDougall
GIS Supervisor
Nationwide TotalFlood Services Inc. (NTSI)
(a wholy owned subsidiary of Capital Title Group)
[EMAIL PROTECTED]
(800)736-3109 x3681
"Gentlemen, we may not make history tomorrow, but we shall certainly change the
geography."
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://www.directionsmag.com/pipermail/mapinfo-l/attachments/20060831/ac562409/attachment-0001.htm
------------------------------
Message: 2
Date: Thu, 31 Aug 2006 16:47:40 -0400
From: "Hughes, Colleen / Don Mitchell" <[EMAIL PROTECTED]>
Subject: RE: [MI-L] Generating points table
To: <mapinfo-l@lists.directionsmag.com>
Message-ID:
<[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"
Hi Sandra,
I've done this many times before. In Table Maintenance, add 2 columns to your
points table to hold the coordinates. Then use Update Table to update each
column using the function CentroidX and CentroidY. I'm assuming you're using
UTM, so CentroidX would be for the Easting and CentroidY for the Northing. But
you probably figured that out without me telling you. 8-)
Don
------------------------------
Message: 4
Date: Thu, 31 Aug 2006 11:25:02 -0400
From: "Sandra Rickard" <[EMAIL PROTECTED]>
Subject: [MI-L] Generating points table
To: <mapinfo-l@lists.directionsmag.com>
Message-ID:
<!&!AAAAAAAAAAAYAAAAAAAAAPvfQWF0s29JgoOTN0LDsRDCgAAAEAAAAB48sBv7KU1Ir10Y
[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"
I was wondering if anyone can help me to populate a table with coordinates from
point created on a Map. I need to create an excel
(csv) file from this. I know how to create the csv file from a table.
I just need to know how to populate the table. We have created points on a map
but I now need the coordinates of these points. There are a lot of them so I
don't want to have to manually type these in. Is there away to populate the
table?
Thanks you in advance to all who can help.
Cheers,
Sandra Rickard
Geologist
Wolfden Resources Inc.
Phone: (807) 346-1668
Fax: (807) 345-0284
401-1113 Jade Court
Thunder Bay, ON P7B 6M7
www.wolfdenresources.com
------------------------------
Message: 3
Date: Fri, 1 Sep 2006 07:41:17 +1000
From: "Strawbridge Nola" <[EMAIL PROTECTED]>
Subject: [MI-L] RE: Generating points table (Sandra Rickard)
To: <mapinfo-l@lists.directionsmag.com>
Message-ID:
<[EMAIL PROTECTED]>
Content-Type: text/plain; charset="iso-8859-1"
Sandra,
If I understand your query correctly- the X & Y Coords already exist if your
points table is mappable.
If you want to view them you need to create 2 new columns for X,Y (make sure
they are Float type, then use "Update column" to populate the table with the
coords.
HTH
Nola
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Friday, 1 September 2006 3:01 AM
To: mapinfo-l@lists.directionsmag.com
Subject: MapInfo-L Digest, Vol 10, Issue 96
Send MapInfo-L mailing list submissions to
mapinfo-l@lists.directionsmag.com
To subscribe or unsubscribe via the World Wide Web, visit
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
or, via email, send a message with subject or body 'help' to
[EMAIL PROTECTED]
You can reach the person managing the list at
[EMAIL PROTECTED]
When replying, please edit your Subject line so it is more specific than "Re:
Contents of MapInfo-L digest..."
Today's Topics:
1. Re: Mapbasic & Vertical Mapper (Bill Thoen)
2. Re: FW: [MI-L] Importing DWG files (Simon Roy)
3. Looping in MapInfo MapBasic Window
(Hughes, Colleen / Don Mitchell)
4. Generating points table (Sandra Rickard)
----------------------------------------------------------------------
Message: 1
Date: Thu, 31 Aug 2006 07:05:59 -0600
From: Bill Thoen <[EMAIL PROTECTED]>
Subject: Re: [MI-L] Mapbasic & Vertical Mapper
To: "Jackson, Simon (Capita Symonds)" <[EMAIL PROTECTED]>
Cc: mapinfo-l@lists.directionsmag.com
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=us-ascii
On Thu, Aug 31, 2006 at 12:25:13PM +0100, Jackson, Simon (Capita Symonds) wrote:
> Ok, I have the S-Dev-Kit.
> I need to tie MapBasic into VM so that I can create some batch routine
> for subtracting some grids, a grid query and outputting as ascii. I
> asked this awhile back and got not much reply. I assume it is possible?
> Any good links to sources that maybe able to help?
According to the manual, it should be able ot do that. However, I was a little
dissappointed with Vertical Mapper SDK. It's a product that's needed, but this
implementation looks more like an afterthought that a typical solid MapInfo
product. About a month ago I sent the following to MapInfo Tech Support
describing some problems I had with it but still have not had a response.
"1. If I develop an MBX in my own directory with calls to the vm SDK functions,
they don't work.
2. If I copy all the vm DLLs to the directory where my MBX runs from, the
applications works, but the VM progress bars don't show.
3. If I load Vertical Mapper into the MapInfo environmemt first, and I'm
running my MBX from my own directory, and I've copied all the vm DLLs to that
directory, everything works and the VM progress bars show.
4. If I run my MBX from the vm directory, I don't have to copy any DLLs, but it
behaves as in 2 and 3 above.
5. The SDK manual needs some work. There are a number of mistakes and at least
one function undocumented (vmGetPRogressTextCallback() used in Batch.mb).
Documentation about parameters whose values depend on units (e.g. height,
coordinates, radius etc. as in vmViewshed()) needs to include what units are
assumed. Also, the documentation fails to describe the return values from many
functions. If it doesn't matter, these should be subroutines, not functions,
and if it does matter, they need to be documented.
So what is the proper way to develop, distribute and install MBX applications
that use the vm SDK? I don't want to put applications in the vm directory
because that will clutter up that directory. Also, you need Admin privilege to
write to directories in the Program Files tree.
I don't want to have to copy DLLs to each directory where my MBX's may be
installed. That gets into legal and user-screwup issues. Besides, unless VM is
running, they won't work properly anyway if I do that.
The vnDev.def file assumes that the vm DLLs are in the application directory or
at least in the search path. Standard installation of Vertical Mapper doesn't
guarantee this.
The manual says nothing about where to install the sdk or how to integrate
MBX's with Vertical Mapper so that they actually work. I think the assumption
is that MBXs go in the vm directory and that VM is loaded into MapInfo. If it
has to be that way, then they should say so, and in any case that's not an
ideal solution due to privilege issues and the fact that MBXs often come with
their own baggage in terms of data and configuration files and will potentially
make a mess of the vm directory.
So, can you give me some guidance?"
- Bill Thoen
------------------------------
Message: 2
Date: Thu, 31 Aug 2006 09:32:54 -0400
From: Simon Roy <[EMAIL PROTECTED]>
Subject: Re: FW: [MI-L] Importing DWG files
To: Mapinfo-L <MapInfo-L@lists.directionsmag.com>
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
I use UT to import DWG into MI (7.8). I also work with AutoCAD. When I import
a file, UT will create one layer for each layer present in the CAD document. I
don't know if this what you mean by "consistent layer"?
Simon
Nicolas Labombarda a écrit :
>
> Hi, a couple of weeks ago someone from the list sent me a link for a
> soft that would import dwg files to MIP in consistent layers.....I
> lost it, and I wonder if I can get it back again.....thanks
>
>
>
>
>> From: "Nicolas Labombarda" <[EMAIL PROTECTED]>
>> To: mapinfo-l@lists.directionsmag.com
>> Subject: [MI-L] Importing DWG files
>> Date: Sun, 13 Aug 2006 18:43:40 +0000
>>
>>
>> Hi there, I am currently working with a dwg file from AutoCad, my
>> problem is when I import it to MIP 8.0 I just get one crowded layer
>> of numerous topologies and subjects. Polygons, points and lines that
>> should be in different layers.
>>
>> I mean I want to be able to see the golf court in a layer apart from
>> a lake or a boundary limit and the rivers layer separately from the
>> roads and the pipelines, and so on.
>>
>> I believe this come from the way the CAD soft works; I am after a
>> manner to deal with that data in a GIS like approach.
>>
>> Thanks in advance
>>
>> Nicolas
>>
>> _________________________________________________________________
>> Windows Live Messenger, la nueva generación de tu MSN.
>> http://imagine-msn.com/minisites/messenger/default.aspx?locale=es-ar
>>
>> _______________________________________________
>> MapInfo-L mailing list
>> MapInfo-L@lists.directionsmag.com
>> http://www.directionsmag.com/mailman/listinfo/mapinfo-l
>
> _________________________________________________________________
> Consigue aquí las mejores y mas recientes ofertas de trabajo en
> América Latina y USA: http://latam.msn.com/empleos/
>
> _______________________________________________
> MapInfo-L mailing list
> MapInfo-L@lists.directionsmag.com
> http://www.directionsmag.com/mailman/listinfo/mapinfo-l
>
------------------------------
Message: 3
Date: Thu, 31 Aug 2006 09:35:07 -0400
From: "Hughes, Colleen / Don Mitchell" <[EMAIL PROTECTED]>
Subject: [MI-L] Looping in MapInfo MapBasic Window
To: <mapinfo-l@lists.directionsmag.com>
Message-ID:
<[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"
Hi All,
I'm slowly trying to learn MapBasic with the MapBasic window in MapInfo and the
User Guides for MapBasic that I downloaded. I'm trying to change the symbol
for a selection using mapbasic. When I look up the commands in the reference
guide, it states that the Do While statement isn't supported in the MapBasic
window, nor is any of the other looping statements nor is the If Then
statement. Is it possible to perform looping or to test for things (like If
Then) from the MapBasic window.
I don't have Mapbasic, other than from within MapInfo, but thought I could
write some simple scripts to automate some of the repetitive tasks I have and
just copy them into the mapbasic window to run them.
The code that I have so far:
------------------------------------------------------------------------
-----------------------------
select * from OverDue where Due_Tested = "NO BFP" into NoBFPtab Dim bfpobj As
Object, bfpsymbol As Symbol bfpsymbol = MakeSymbol(34,0,6) Fetch First From
NoBFPtab Do While Not EOT(NoBFPtab)
bfpobj = NoBFPtab.obj
Alter Object bfpobj
Info OBJ_INFO_SYMBOL, bfpsymbol
Update NoBFPtab Set obj = bfpobj
Fetch Next From NoBFPtab
------------------------------------------------------------------------
-----------------------------
Any help is be appreciated.
Don
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://www.directionsmag.com/pipermail/mapinfo-l/attachments/20060831/58a8f1fd/attachment-0001.htm
------------------------------
Message: 4
Date: Thu, 31 Aug 2006 11:25:02 -0400
From: "Sandra Rickard" <[EMAIL PROTECTED]>
Subject: [MI-L] Generating points table
To: <mapinfo-l@lists.directionsmag.com>
Message-ID:
<!&[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"
I was wondering if anyone can help me to populate a table with coordinates from
point created on a Map. I need to create an excel (csv) file from this. I
know how to create the csv file from a table. I just need to know how to
populate the table. We have created points on a map but I now need the
coordinates of these points. There are a lot of them so I don't want to have
to manually type these in. Is there away to populate the table?
Thanks you in advance to all who can help.
Cheers,
Sandra Rickard
Geologist
Wolfden Resources Inc.
Phone: (807) 346-1668
Fax: (807) 345-0284
401-1113 Jade Court
Thunder Bay, ON P7B 6M7
www.wolfdenresources.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://www.directionsmag.com/pipermail/mapinfo-l/attachments/20060831/93ca88f6/attachment-0001.htm
------------------------------
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
End of MapInfo-L Digest, Vol 10, Issue 96
*****************************************
------------------------------
Cairns City Council Disclaimer
------------------------------
"This message, and any attachments, may contain privileged and confidential
information intended only for the use of the intended addressee(s). Any
unauthorized use of this material is prohibited. If you receive this message
in error, please notify the sender immediately, delete the message and destroy
any printed or electronic copies.
Opinions expressed in this e-mail are those of the sender and do not
necessarily represent the views of the Cairns City Council. Council does not
accept any responsibility for the loss or damage that may result from reliance
on, or the use of, any information contained in this e-mail or attachments."
------------------------------
------------------------------
Message: 4
Date: Thu, 31 Aug 2006 15:05:57 -0700
From: Joe Barreca <[EMAIL PROTECTED]>
Subject: [MI-L] [M-L] Raster Image
To: MapInfo-L@lists.directionsmag.com
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"
Bill:
You wrote:
Listers
Does anyone know of a device which can be used inside MapInfo to cut a piece
out of a raster image while retaining its geographic attributes ?
Bill Williams
GIS Specialist, Statistics & Mapping Section Parliamentary Library Department
of Parliamentary Services Parliament House PO Box 6000 CANBERRA ACT 2600
Telephone : 02 62772513
Email: [EMAIL PROTECTED]
MI 8.5 has an option to do this by just focusing a map window on the part of
the already-registered image that you want and saving the window as an image
with a tab file. But yesterday Greg Driver suggested this:
For those who don't have MI V8.5 there is a tool that will do this -
<http://www.directionsmag.com/files/index.php/view/679>http://www.directionsmag.com/files/index.php/view/679
HTH
Which does the same thing. I should know. I've been using it all day.
Joe
Joseph Barreca
Map Metrics
2109 Hwy 25 South
Kettle Falls, WA 99141
509 738 6155
[EMAIL PROTECTED]
http://www.mapmet.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://www.directionsmag.com/pipermail/mapinfo-l/attachments/20060831/57b4a27a/attachment.htm
------------------------------
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
End of MapInfo-L Digest, Vol 10, Issue 97
*****************************************
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
