MI-L MapInfo-L Reminder

[MapInfo-L-Owner]

This is just a reminder to help you manage your MapInfo-L subscription. This 
will be posted automatically each week, and please feel free to respond with 
suggestions or improvements.

- Bill Thoen
[EMAIL PROTECTED]

CONTENTS
1. THE MAPINFO-L FAQ
2. LINKS TO EZMLM FAQs AND MANUALS
3. LINK TO THE MAPINFO-L CLEARINGHOUSE
4. MAPINFO-L ARCHIVES
5. TIPS
6. HOW TO UNSUBSCRIBE/SUBSCRIBE

--
1. THE MAPINFO-L FAQ

The acronym "FAQ" stands for "Frequently Asked Questions" (with answers.) To 
get a copy of the MapInfo-L FAQ, send e-mail to:

[EMAIL PROTECTED]

Before you ask a question that's been asked a hundred times before, please 
consult the FAQ first. If you have suggestions for corrections or improvements, 
please send them to [EMAIL PROTECTED], and we'll make whatever changes are 
needed. Thanks to David Reid for putting this first draft together!


--
2. LINKS TO EZMLM FAQs AND MANUALS

We use the EZMLM mailing list software to host MapInfo-L. The following links 
will provide you with information about how to use it to manage your 
subscription.

ezmlm/idx MANUAL
http://ezmlm.area.com/ezman-0.32/ezman1.html


--
3. LINK TO THE MAPINFO-L CLEARINGHOUSE

For information about MapInfo-L and related resources, visit the MapInfo-L 
Clearinghouse at:
http://www.directionsmag.com/mapinfo-l


--
4. MAPINFO-L ARCHIVES

Past messages posted to MapInfo-l can be searched and viewed at the following 
URLs:
http://lists.directionsmag.com/discussion/list.php?f=7
http://testdrive.mapinfo.com/tdc/mapinfo-l.nsf/

--
5. TIPS

Did you know that the message header of every list post contains informative 
email addresses that will greatly help you to manage your subscription to the 
list?

Send an email to [EMAIL PROTECTED] and receive a copy of the List FAQ. You may 
be surprised at what the Mapinfo-L has to offer behind the scenes.

Did you know the Mapinfo-L is available as a "Digest" as apposed to individual 
messages?

When you go on vacation or holiday, please have your email server ignore 
Mapinfo-L traffic so as not to have "Out of office" auto-replies, sent to 
everyone on the list. Or simply temporarily un-subscribe from the list. The 
List FAQ describes how you can easily catch back up on all the news when you 
return.

--
6. HOW TO SUBSCRIBE/UNSUBSCRIBE

To un-subscribe: Simply send an email to
[EMAIL PROTECTED]

To subscribe: Simply send an email to
[EMAIL PROTECTED]

To catch up on all the news while you were away, simply send an email to [EMAIL 
PROTECTED] The FAQ is chocked full of essential information many users are not 
even aware of.


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16656

MI-L Creating your own icons on thematic maps

[Jesper Jensen 1]

Hi
I'm a student currently working on some thematic maps on archeological
excavations. I would like to create my own symbols on these thematic maps.
Is that possible?
Sorry if I posted this in the wrong forum
Jesper 


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16657

MI-L Thematic Map - 'Show this Range' problem

[Taylor, Zara]

Can anyone help?

I've created a thamtic map on a polygon file, into 5 ranges coloured
like this:

0.8 to 1Red
0.6 to 0.8  Orange
0.4 to 0.6  Yellow
0.2 to 0.4  Green
0 to 0.2Blue

I don't want to see the blue ranges on the map, so in the Customize
Legend option in Modify Thematic Map I have unchecked the box which says
'Show this range' for the 0 to 0.2 range.

This makes the blue range disappear from the legend in the dialog box,
but when I click OK to return to main View the blue polygons are still
on the map.

I can't make out what is going wrong?  Can anyone help?

Regards,

Zara Taylor
Information Systems Analyst
Customer Insight Unit
* 181752
* 020 8718 1752
* [EMAIL PROTECTED]




**
Registered Office:
Marks and Spencer plc
Waterside House
35 North Wharf Road
London
W2 1NW

Registered No. 214436 in England and Wales.

Telephone (020) 7935 4422
Facsimile (020) 7487 2670

<>

Please note that electronic mail may be monitored.

This e-mail is confidential. If you received it by mistake, please let us know 
and then delete it from your system; you should not copy, disclose, or 
distribute its contents to anyone nor act in reliance on this e-mail, as this 
is prohibited and may be unlawful.

Re: MI-L Thematic Map - 'Show this Range' problem

[Erik Rude Nielsen]

Zara,
Ticking that box only means it will not show in the legend.
To filter your values try using a query hsowing just the records you want to 
see on your map.
Erik
 On 6/3/05, Taylor, Zara <[EMAIL PROTECTED]> wrote: 
> 
> Can anyone help?
> 
> I've created a thamtic map on a polygon file, into 5 ranges coloured
> like this:
> 
> 0.8 to 1 Red
> 0.6 to 0.8 Orange
> 0.4 to 0.6 Yellow
> 0.2 to 0.4 Green
> 0 to 0.2 Blue
> 
> I don't want to see the blue ranges on the map, so in the Customize
> Legend option in Modify Thematic Map I have unchecked the box which says
> 'Show this range' for the 0 to 0.2 range.
> 
> This makes the blue range disappear from the legend in the dialog box,
> but when I click OK to return to main View the blue polygons are still
> on the map.
> 
> I can't make out what is going wrong? Can anyone help?
> 
> Regards,
> 
> Zara Taylor
> Information Systems Analyst
> Customer Insight Unit
> * 181752
> * 020 8718 1752
> * [EMAIL PROTECTED]
> 
> 
> 
> 
> **
> Registered Office:
> Marks and Spencer plc
> Waterside House
> 35 North Wharf Road
> London
> W2 1NW
> 
> Registered No. 214436 in England and Wales.
> 
> Telephone (020) 7935 4422
> Facsimile (020) 7487 2670
> 
> >>
> 
> Please note that electronic mail may be monitored.
> 
> This e-mail is confidential. If you received it by mistake, please let us 
> know and then delete it from your system; you should not copy, disclose, or 
> distribute its contents to anyone nor act in reliance on this e-mail, as 
> this is prohibited and may be unlawful.
> 
> 
> 
>

Re: MI-L Creating your own icons on thematic maps

[Lars V. Nielsen \(HVM\)]

Hi Jesper,

If you're working with MapInfo Pro, this is definitely the right forum :-)

But are you sure you're talking about thematic maps ?

If you've worked with ArcXxx before, there the styles are applied to the
features by one of several methods.

However, in MapInfo this is different. Here each feature has its own style
definition, embedded within the feature itself.
This default style can be overruled on a layer-by-layer basis, and one or
more entirely different thematic stylings can be applied on top of that.

So it really doesn't make sense to talk about thematic maps with ones own
symbols. It makes sense to attach custom symbols to individual features, but
that's an integrated part of the data model. I assume this is what you are
asking for ?

If so, the easiest way is to create custom symbols is to build bitmapped
(*.bmp) symbols. These symbols are located in this folder (in 2k/xp) :

C:\Documents and Settings\\Application
Data\MapInfo\MapInfo\Professional\\CustSymb\

The previous limitation of 32x32 pixels is supposedly removed in later
versions (haven't checked), so it's possible to use fairly large symbols
with many colors if necessary.

Best regards / Med venlig hilsen
Lars V. Nielsen

Hvenegaard & Meklenborg
Rugaardsvej 55, DK-5000 Odense C
Denmark
http://www.hvm.dk
- Original Message - 
From: "Jesper Jensen 1" <[EMAIL PROTECTED]>
To: <"mailto:M"@lists.directionsmag.com
Sent: Friday, June 03, 2005 1:21 PM
Subject: MI-L Creating your own icons on thematic maps


Hi
I'm a student currently working on some thematic maps on archeological
excavations. I would like to create my own symbols on these thematic maps.
Is that possible?
Sorry if I posted this in the wrong forum
Jesper


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16657


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16660

RE: MI-L Mapinfo system error

[Nabors, Steve]

Hi Peter,
We get this error too.  We first noticed it when we upgraded from MIPro 7.5
to 7.8.  I think is a 7.8 "feature". We were on W2K at the time but now
we're on XP and it has not gone away. It only occurs on text and csv exports
to my knowledge.  The good thing is that it's a benign error that lets you
keep going.

-Original Message-
From: Doyle, Peter W [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 02, 2005 9:32 PM
To: MapInfo-L@lists.directionsmag.com
Subject: MI-L Mapinfo system error

Greetings list,

Has anybody come across the following Mapinfo system error dialog, and can
tell me what it means?

"Unable to access string resource (3395)"  

I am usining Windows XP, and Mapinfo v7.8

This dialog appears when I try to run an mbx I created using Mapbasic v7.5.
I have recompiled it using Mapbasic v4.5 but the error still exists.
When I dismiss the eror dialog, the utility loads and runs as it should,
with no noticable side effects.


Peter Doyle
Geographical  Analysis  and Data
Mobile Coverage Delivery - Qld
Wireless Access Services

Phone : (07) 3887 1128
Mobile : 0418 709 250

> The contents of the E-mail are strictly confidential. If you are not 
> the intended recipient, any use, disclosure or copying of this E-mail 
> (including any attachments) is unauthorised and prohibited. If you 
> have received this E-mail in error, please notify Telstra (ABN 33 051
> 775 556) immediately by return E-mail and then delete the message from 
> your system.
> 
> 

__
This e-mail has been scanned by MCI/MessageLabs Managed Email Service.

__
This e-mail has been scanned by MCI/MessageLabs Managed Email Service.

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16661

MI-L MapBasic and Excel

[Cathy Coldrey]

 Hi,
I am writting a MapBasic programme that I want to open a document in Excel as 
an external document. I can open Excel by using the run programme comand, but 
am uncertain how to then open a specific .xls file at the same time. Has anyone 
attempted to solve a problem like this before? If so could you shed some light 
on the subject?
Many thanks
:) Cathy 

MI-L Fatal error in Mapbasic.exe

[Terry McDonnell]

Don't suppose anyone can help with this but ... who else do I turn to?
 
I've a project with several .MBOs, all to be link4ed together to one big
.MBX.
I've just made some program changes to one of my MBOs, compiled it OK.
Then I went to link the project and Mapbasic just bombed out on me with
an error report for M$
 
The essence of the error report is:
 
Appname: Mapbasic.exe
Version: 7.8.0.17
Modname: NTDLL.DLL
Mod. Version:5.1.2600.2180
Offset:  0001142e
 
... whatever all that means!
 
I assume there's some problem with a dll but what, why, when, where,
how?
 
Any help would be much appreciated
 
Terry McDonnell

RE: MI-L MapBasic and Excel

[Nabors, Steve]

This should get your started:

Run Program "C:\Program Files\Microsoft Office\OFFICE11\Excel.exe
C:\temp\ExportTable.csv"


 

-Original Message-
From: Cathy Coldrey [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 03, 2005 8:35 AM
To: Mapinfo-L@lists.directionsmag.com
Subject: MI-L MapBasic and Excel

 Hi,
I am writting a MapBasic programme that I want to open a document in Excel
as an external document. I can open Excel by using the run programme comand,
but am uncertain how to then open a specific .xls file at the same time. Has
anyone attempted to solve a problem like this before? If so could you shed
some light on the subject?
Many thanks
:) Cathy 


__
This e-mail has been scanned by MCI/MessageLabs Managed Email Service.

__
This e-mail has been scanned by MCI/MessageLabs Managed Email Service.

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16664

RE: MI-L MapBasic and Excel

[OSullivan. Jerry \(IT Solutions\)]

Cathy,

You should be able to pass the name of the excel file as a parameter as
below:

Run program "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE
C:\Book1.xls"

Jerry

-Original Message-
From: Cathy Coldrey [mailto:[EMAIL PROTECTED] 
Sent: 03 June 2005 14:35
To: Mapinfo-L@lists.directionsmag.com
Subject: MI-L MapBasic and Excel


 Hi,
I am writting a MapBasic programme that I want to open a document in
Excel as an external document. I can open Excel by using the run
programme comand, but am uncertain how to then open a specific .xls file
at the same time. Has anyone attempted to solve a problem like this
before? If so could you shed some light on the subject? Many thanks
:) Cathy 


* ** *** ** * ** *** ** * ** *** ** * 
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they 
are addressed. 
Any views or opinions presented are solely those of the author, and do not 
necessarily 
represent those of ESB. 
If you have received this email in error please notify the sender. 
 
Although ESB scans e-mail and attachments for viruses, it does not guarantee 
that either are virus-free and accepts no liability for any damage sustained 
as a result of viruses. 
 
* ** *** ** * ** *** ** * ** *** ** *


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16665

MI-L Grid Value Extractions

[Roy Roux]

Does anyone out there know of a MI Tool or some other GIS software that
will extract a grid Z value (i.e. elevation) based on vector point
table?  Another way to put this would be: For each point location within
one table return the Z value from a grid table nearest to the point and
store the Z value within column in the point table.  I am sure ArcXXX
would do this with some module but am not interested in spending that
much money for this one task.

MI-L Concentric Ring Buffer

[Ronning, Christine]

Hi all,

I'm trying to calculate an estimate of population within a 1km distance
of medical labs.

To do this I'm using a concentric ring buffer...however I have a couple
of questions.

1- I created a 1km buffer first to see what it looked like and what
population polygon centriods would fall into the area.  Then using the
concentric ring buffer I did the same thing, calculating the average for
my population poylgon for those where centriods are found within.  My
problem is the concentric ring buffer is actually close to a 2km radius,
not 1.  I did enter it as 1, any ideas why this is happening?

2- Does anyone know what the difference between the "Average" and
"Proportional Average" functions are and which would be a more accurate
estimate?

Thanks very much

Christine

Re: MI-L creating points in spatial ware

[Lars V. Nielsen (GisPro)]

Hi Robert,

Your query should at least read :

update dbo.T_FTPSITE_RAWDATA_MKYMTDATA
set sw_geometry =  'ST_POINT(' + longitude + ',' + latitute + ')'

and maybe even

update dbo.T_FTPSITE_RAWDATA_MKYMTDATA
set sw_geometry =  'ST_POINT(' + CAST(longitude as varchar(25)) + ',' + 
CAST(latitute as varchar(25)) + ')'

The textual representation given to sw_geometry is parsed and executed (by a 
trigger), but it doesn't allow for variable
substitutions, so you need to extract and format the values. Did you remember 
to spatialize the table with "exec
sp_sw_spatialize_column ..." first ?

If you run the statement via a MapBasic program the command is as follows:

hStmt = Server_Execute (hDBc,
"update dbo.T_FTPSITE_RAWDATA_MKYMTDATA set sw_geometry =  'ST_POINT(' 
+ CAST(longitude as varchar(25)) + ',' +
CAST(latitute as varchar(25)) + ')'"
)

i.e. just as it's stated above, just enclosed in MapBasic text apostrophes. A 
command in a command if you will.

You can use a stored procedure if you want, but the syntax of the update is the 
same.

Best regards/Med venlig hilsen
Lars V. Nielsen
GisPro, Denmark
http://www.gispro.dk/

- Original Message - 
From: "Robert Crossley" <[EMAIL PROTECTED]>
To: "MapInfo List" 
Sent: Friday, June 03, 2005 3:23 AM
Subject: MI-L creating points in spatial ware


Hi all,

I have a csv table of data that includes x and y coordinate coordinates
that I want to insert into a spatialware sql server database.  That part
is easy enough, but I want to then create the points on the server side.

This is the first time that I am trying to do object creation and
manipulation on the server through spatialware - normally all of this is
done through MI Pro.

I have inserted the data into the table on the server that has been
created with easyloader (and then had the data deleted), and I get the
records in OK.  I am using an ado recordset, and on the program side I add
all the data to the recordset and the do an update.  THis doesn't allow me
to create the spatial points as I add them to the recordset.

I thought I would then update the table with a command like this

update dbo.T_FTPSITE_RAWDATA_MKYMTDATA set sw_geometry =
'ST_POINT(longitude,latitute)'

where longitude and latitude are the fields that have the data for x and y
coordinates expressed in the projection of that table.

It seems to run OK, but then when i open the table up in MapInfo, there
are no objects in the table.

I am concerned that the field references won't carry through to the
procedure.

Is this syntax right, or should I use a stored procedure?

Help,

thanks r


-- 


Robert Crossley

Agtrix P/L
9 Short St
PO Box 63
New Brighton 2483
Far Southern Queensland
AUSTRALIA

153.549004 E 28.517344 S

P: 02 6680 1309
F: 02 6680 5214
M: 0419 718 642
E: [EMAIL PROTECTED]
W: www.agtrix.com
W: www.wotzhere.com
skype: robertcrossley

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16653


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16668

MI-L Looking for Data

[Christian McNierney]

Hello list... I am looking for House and Senate district boundaries
for the entire US.  Does anyone have an idea on where I can obtain
this?

TIA,

Christian

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16669