[MI-L] Create buffers

2006-07-04 Thread Lee Morris








Can anybody help?

 

How can I create buffers around points on a map, and save
the buffers created into a separate table?

 

Please help!!

 

Lee Morris

 

Mouchel Parkman Services Ltd

Cunard Building

Water Street

Liverpool

L3 1ES

 

mailto: [EMAIL PROTECTED]

Tel 0151 242  x.358

Fax 0151 242 7704

 




The information in this e-mail is confidential and intended to be solely for the use of the addressee(s) and may contain copyright and/or legally privileged information.  If you are not the addressee (or responsible for delivery of the message to the addressee) please e-mail us at [EMAIL PROTECTED] and delete the message from your computer; copying, distribution, use or disclosure of its contents is strictly prohibited.
As Internet communications are capable of data corruption no responsibility is accepted for changes made to this message after it was sent. For this reason it may be inappropriate to rely on advice contained in any e-mail without obtaining written confirmation of it.
In addition, no liability or responsibility is accepted for viruses and it is your responsibility to scan attachments (if any).
Please note that for business purposes, outgoing and incoming emails from and to the company may be monitored and recorded.

 
Mouchel Parkman Services Ltd, Registered in England at West Hall, Parvis Road, West Byfleet, Surrey UK KT14 6EZ Registered No : 1686040


___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


RE: [MI-L] Auditing edits made to mapinfo tables.

2006-07-04 Thread Terry McDonnell
Title: Auditing edits made to mapinfo tables.



Mathew 

 
Well all I can offer is what seems to be obvious.  
Create a table that holds all the audit trail fields and create new records for 
it every time you amend the database.  If you keep your updates to the 
database in dedicated procs then that would be the place to also update the 
audit table.
 
Regards
 
Terry 
McDonnell


From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Mathew 
LinnaneSent: 04 July 2006 06:00To: Terry 
McDonnellSubject: [MI-L] Auditing edits made to mapinfo 
tables.

I need to create 
an audit trail of all 
edits made to a certain mapinfo table. The Audit trail must include user ID, Date, Time etc. Can mapinfo 
facilitate any form of auditing? All ideas would help.
Regards,
 
 
 
Mathew 
Linnane
 
GIS/LIS 
Assets Officer.
Queanbeyan City 
Council.
257 Crawford 
Street
Queanbeyan NSW 
2620.
Bus: (02) 6298 
0205
Fax: (02) 6297 
4044
Mob: 0412 565 
552
Email: [EMAIL PROTECTED]
 

+
"This message is intended for the addressee 
named and may contain confidential information. If you are not the intended 
recipient, please delete it and notify the sender. Views expressed in this 
message are those of the individual sender, and are not necessarily the views of 
Queanbeyan City Council, unless otherwise stated.
For the purposes of the Copyright Act, the 
permission of the holder of copyright in this communication may be taken to have 
been granted, unless stated otherwise, for the copying or forwarding of this 
message, as long as both the content of this communication and the purpose for 
which it is copied or forwarded are work related."
+
 
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


RE: [MI-L] Auditing edits made to mapinfo tables.

2006-07-04 Thread Peter Horsbøll Møller
Title: Auditing edits made to mapinfo tables.



Mathew,
 
MapInfo isn't that good at these kind of things, not when working in the 
native tab format. You would need to write your own tools for doing all the 
operations - that would be quite a job.
 
I would recommend using a Spatial Database in stead. You can then make 
the database system keep track of all the changes, even tore them in a separate 
table, so that you have access to the previous version of every 
record.
 
MapInfo 8.0 introduced support for Oracle Workspaces. This is actual 
exactly what you are looking for. You can setup a table to keep track of every 
change, and this can be done from within MapInfo. The changes at stored in a 
separate table that with a small amount of work can be opened and viewed in the 
map as well.
 
Peter Horsbøll Møller GIS Developer, MTM Geographical 
Information & IT   COWI A/S Odensevej 
95 DK-5260 Odense S. Denmark   Tel +45 6311 4900 Direct  +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail  [EMAIL PROTECTED] http://www.cowi.dk/gis 
 


From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Mathew 
LinnaneSent: Tuesday, July 04, 2006 1:10 AMTo: 
mapinfo-l@lists.directionsmag.comSubject: [MI-L] Auditing edits made 
to mapinfo tables.

I need to create 
an audit trail of all 
edits made to a certain mapinfo table. The Audit trail must include user ID, Date, Time etc. Can mapinfo 
facilitate any form of auditing? All ideas would help.
Regards,
 
 
 
Mathew 
Linnane
 
GIS/LIS 
Assets Officer.
Queanbeyan City 
Council.
257 Crawford 
Street
Queanbeyan NSW 
2620.
Bus: (02) 6298 
0205
Fax: (02) 6297 
4044
Mob: 0412 565 
552
Email: [EMAIL PROTECTED]
 

+
"This message is intended for the addressee 
named and may contain confidential information. If you are not the intended 
recipient, please delete it and notify the sender. Views expressed in this 
message are those of the individual sender, and are not necessarily the views of 
Queanbeyan City Council, unless otherwise stated.
For the purposes of the Copyright Act, the 
permission of the holder of copyright in this communication may be taken to have 
been granted, unless stated otherwise, for the copying or forwarding of this 
message, as long as both the content of this communication and the purpose for 
which it is copied or forwarded are work related."
+
 
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


RE: [MI-L] Create buffers

2006-07-04 Thread Peter Horsbøll Møller



Hi,
 
You can do this very easily with the Table > Buffer function. You can 
even create a new table from within this procedure.
 
Alternatively just remember that when using Objects > Buffer, the 
buffers are inserted into the editable layer.
Peter Horsbøll Møller GIS Developer, MTM Geographical 
Information & IT   COWI A/S Odensevej 
95 DK-5260 Odense S. Denmark   Tel +45 6311 4900 Direct  +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail  [EMAIL PROTECTED] http://www.cowi.dk/gis 
 


From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Lee 
MorrisSent: Tuesday, July 04, 2006 11:56 AMTo: 
mapinfo-l@lists.directionsmag.comSubject: [MI-L] Create 
buffers


Can anybody help?
 
How can I create buffers around 
points on a map, and save the buffers created into a separate 
table?
 
Please help!!
 
Lee Morris
 
Mouchel Parkman 
Services Ltd
Cunard Building
Water Street
Liverpool
L3 1ES
 
mailto: 
[EMAIL PROTECTED]
Tel 0151 242  
x.358
Fax 0151 242 7704
 
The information in this 
e-mail is confidential and intended to be solely for the use of the addressee(s) 
and may contain copyright and/or legally privileged information. If you are not 
the addressee (or responsible for delivery of the message to the addressee) 
please e-mail us at [EMAIL PROTECTED] and delete the message from 
your computer; copying, distribution, use or disclosure of its contents is 
strictly prohibited.
As Internet communications 
are capable of data corruption no responsibility is accepted for changes made to 
this message after it was sent. For this reason it may be inappropriate to rely 
on advice contained in any e-mail without obtaining written confirmation of 
it.
In addition, no liability 
or responsibility is accepted for viruses and it is your responsibility to scan 
attachments (if any).
Please note that for 
business purposes, outgoing and incoming emails from and to the company may be 
monitored and recorded.

 
Mouchel Parkman Services 
Ltd, Registered in England at West Hall, Parvis Road, West Byfleet, Surrey UK 
KT14 6EZ Registered No : 1686040
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


Re: [MI-L] Auditing edits made to mapinfo tables.

2006-07-04 Thread Mike Tonge
You could try writing a little mapbasic program that you use instead of the open file command.  Then each time the file requiring auditing is opened you could update another table with the date, time and username (accessible through windows api) of the person editing the file.
 
If you want any more info on this idea please e-mail me.
 
Mike
- Original Message From: Terry McDonnell <[EMAIL PROTECTED]>To: Mathew Linnane <[EMAIL PROTECTED]>; mapinfo-l@lists.directionsmag.comSent: Tuesday, 4 July, 2006 9:31:56 AMSubject: RE: [MI-L] Auditing edits made to mapinfo tables.
Mathew 
 
Well all I can offer is what seems to be obvious.  Create a table that holds all the audit trail fields and create new records for it every time you amend the database.  If you keep your updates to the database in dedicated procs then that would be the place to also update the audit table.
 
Regards
 
Terry McDonnell


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew LinnaneSent: 04 July 2006 06:00To: Terry McDonnellSubject: [MI-L] Auditing edits made to mapinfo tables.

I need to create an audit trail of all edits made to a certain mapinfo table. The Audit trail must include user ID, Date, Time etc. Can mapinfo facilitate any form of auditing? All ideas would help.
Regards,
 
 
 
Mathew Linnane
 
GIS/LIS Assets Officer.
Queanbeyan City Council.
257 Crawford Street
Queanbeyan NSW 2620.
Bus: (02) 6298 0205
Fax: (02) 6297 4044
Mob: 0412 565 552
Email: [EMAIL PROTECTED]
 

+
"This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of Queanbeyan City Council, unless otherwise stated.
For the purposes of the Copyright Act, the permission of the holder of copyright in this communication may be taken to have been granted, unless stated otherwise, for the copying or forwarding of this message, as long as both the content of this communication and the purpose for which it is copied or forwarded are work related."
+
 
___MapInfo-L mailing listMapInfo-L@lists.directionsmag.comhttp://www.directionsmag.com/mailman/listinfo/mapinfo-l
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


Re: [MI-L] Auditing edits made to mapinfo tables.

2006-07-04 Thread Lars I. Nielsen (GisPro)
Title: Auditing edits made to mapinfo tables.




I beg to differ.

MapInfo Pro knows exactly what records and fields and graphical objects
have been edited at any time. The only thing MapInfo Pro's not good at,
is making this information available to everyone else.

The illusive "transaction files" (TDA, TIN and TMA) contains the
information of what edits have been made. Only problem: they're locked
when they exist, and deleted when closed. Otherwise I think it would be
perfectly feasiable to utilize these to generate an audit trail of some
kind.

I'll make a simple feature suggestion for MI Pro 9.0 : have Pro add
some log of all edits to a .log whenever edits are
committed. The log file should be in a known, dense, maybe binary,
format that could be utilized programmatically. Maybe just
rowid+field+timestamp. And add an option to turn this feature on.


That said, I too think a more server based approach would be a smarter
option for a number of reasons, although I'm sure Oracle isn't the only
egg in that basket.

Best regards / Med venlig hilsen
Lars I. Nielsen
GisPro



Peter Horsbøll Møller wrote:

  
  
  
  Mathew,
   
  MapInfo isn't that good at these kind of
things, not when working in the native tab format. You would need to
write your own tools for doing all the operations - that would be quite
a job.
   
  I would recommend using a Spatial Database in
stead. You can then make the database system keep track of all the
changes, even tore them in a separate table, so that you have access to
the previous version of every record.
   
  MapInfo 8.0 introduced support for Oracle
Workspaces. This is actual exactly what you are looking for. You can
setup a table to keep track of every change, and this can be done from
within MapInfo. The changes at stored in a separate table that with a
small amount of work can be opened and viewed in the map as well.
   
  Peter Horsbøll Møller 
  GIS Developer, MTM 
  Geographical Information & IT
  
    
  COWI A/S 
  Odensevej 95 
  DK-5260 Odense S. 
  Denmark 
    
  Tel +45 6311 4900 
  Direct  +45 6311 4908 
  Mob +45 5156 1045 
  Fax +45 6311 4949 
  E-mail  [EMAIL PROTECTED] 
  http://www.cowi.dk/gis
  
   
  
  
  From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Mathew
Linnane
  Sent: Tuesday, July 04, 2006 1:10 AM
  To: mapinfo-l@lists.directionsmag.com
  Subject: [MI-L] Auditing edits made to mapinfo tables.
  
  

  I
need to create an audit trail of all edits made to a certain mapinfo table. The Audit trail must
include user ID, Date, Time etc. Can mapinfo facilitate any form
of auditing?
All ideas would help.
  Regards,
   
   
   
  Mathew
Linnane
   
  GIS/LIS
Assets Officer.
  Queanbeyan
City Council.
  257
Crawford Street
  Queanbeyan
NSW 2620.
  Bus:
(02) 6298 0205
  Fax:
(02) 6297 4044
  Mob:
0412 565 552
  Email: [EMAIL PROTECTED]
   
  
  +
  "This message is intended for the
addressee named and may contain confidential information. If you are
not the intended recipient, please delete it and notify the sender.
Views expressed in this message are those of the individual sender, and
are not necessarily the views of Queanbeyan City Council, unless
otherwise stated.
  For the purposes of the Copyright
Act, the permission of the holder of copyright in this communication
may be taken to have been granted, unless stated otherwise, for the
copying or forwarding of this message, as long as both the content of
this communication and the purpose for which it is copied or forwarded
are work related."
  +
   
  

___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
  



___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


RE: [MI-L] Auditing edits made to mapinfo tables.

2006-07-04 Thread Peter Horsbøll Møller
Title: Auditing edits made to mapinfo tables.



Lars,
 
You are absolutely right. MapInfo certainly known the changes.  The 
problem is - as you write yourself - that these information aren't made 
availeble in any way.
 
The idea of a log-file is great. I would like to add another request, a 
RowEditedHandler that could be "caught" within your MapBasic application. This 
should be seen as a sort of trigger, so maybe we actual need as well a before as 
an after trigger.
 
Within these it should be possible to detect which column was 
updated.
 
So what we actual are asking for is a full support for "triggers" thru 
the MapBasic interface ?!
 
And you are 
right Oracle is just one of the possibilities. But for now, if you are using 
MapInfo, I can only see a few.
Peter Horsbøll Møller GIS Developer, MTM Geographical 
Information & IT   COWI A/S Odensevej 
95 DK-5260 Odense S. Denmark   Tel +45 6311 4900 Direct  +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail  [EMAIL PROTECTED] http://www.cowi.dk/gis 


From: Lars I. Nielsen (GisPro) 
[mailto:[EMAIL PROTECTED] Sent: Tuesday, July 04, 2006 2:49 
PMTo: mapinfo-l@lists.directionsmag.comCc: Peter Horsbøll 
Møller; Mathew LinnaneSubject: Re: [MI-L] Auditing edits made to 
mapinfo tables.
I beg to differ.MapInfo Pro knows exactly what records and 
fields and graphical objects have been edited at any time. The only thing 
MapInfo Pro's not good at, is making this information available to everyone 
else.The illusive "transaction files" (TDA, TIN and TMA) contains the 
information of what edits have been made. Only problem: they're locked when they 
exist, and deleted when closed. Otherwise I think it would be perfectly 
feasiable to utilize these to generate an audit trail of some kind.I'll 
make a simple feature suggestion for MI Pro 9.0 : have Pro add some log of all 
edits to a .log whenever edits are committed. The log file 
should be in a known, dense, maybe binary, format that could be utilized 
programmatically. Maybe just rowid+field+timestamp. And add an option to turn 
this feature on.That said, I too think a more server based approach 
would be a smarter option for a number of reasons, although I'm sure Oracle 
isn't the only egg in that basket.Best regards / Med venlig hilsen
Lars I. Nielsen
GisPro
Peter Horsbøll Møller wrote: 

  
  Mathew,
   
  MapInfo isn't that good at these kind of things, not when working in 
  the native tab format. You would need to write your own tools for doing all 
  the operations - that would be quite a job.
   
  I would recommend using a Spatial Database in stead. You can then make 
  the database system keep track of all the changes, even tore them in a 
  separate table, so that you have access to the previous version of every 
  record.
   
  MapInfo 8.0 introduced support for Oracle Workspaces. This is actual 
  exactly what you are looking for. You can setup a table to keep track of every 
  change, and this can be done from within MapInfo. The changes at stored in a 
  separate table that with a small amount of work can be opened and viewed in 
  the map as well.
   
  Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT   COWI A/S 
  Odensevej 95 DK-5260 Odense S. Denmark 
    Tel +45 6311 4900 Direct  +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail  [EMAIL PROTECTED] http://www.cowi.dk/gis 
  
   
  
  
  From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] 
  On Behalf Of Mathew LinnaneSent: Tuesday, July 04, 2006 1:10 
  AMTo: mapinfo-l@lists.directionsmag.comSubject: 
  [MI-L] Auditing edits made to mapinfo tables.
  I need to create 
  an audit trail of all edits made to a certain mapinfo table. The Audit trail must 
  include user ID, 
  Date, Time etc. Can mapinfo facilitate any form of auditing? All ideas would 
  help.
  Regards,
   
   
   
  Mathew 
  Linnane
   
  GIS/LIS 
  Assets Officer.
  Queanbeyan City 
  Council.
  257 Crawford 
  Street
  Queanbeyan NSW 
  2620.
  Bus: (02) 6298 
  0205
  Fax: (02) 6297 
  4044
  Mob: 0412 565 
  552
  Email: [EMAIL PROTECTED]
   
  
  +
  "This message is intended for the addressee 
  named and may contain confidential information. If you are not the intended 
  recipient, please delete it and notify the sender. Views expressed in this 
  message are those of the individual sender, and are not necessarily the views 
  of Queanbeyan City Council, unless otherwise stated.
  For the purposes of the Copyright Act, the 
  permission of the holder of copyright in this communication may be taken to 
  have been granted, unless stated otherwise, for the copying or forwarding of 
  this message, as long as both the content of this communication and the 
  purpose for which it is copied or forwarded are work related."
  +
   
___

[MI-L] Distances between multiple points.

2006-07-04 Thread Lee Morris








Does anyone have any tools or MB code that can measure the
distances between multiple points in the same table?

 

I have tried using buffers, but to no effect.

 

PLEASE HELP!!!

 

Lee Morris

 

Mouchel Parkman Services Ltd

Cunard Building

Water Street

Liverpool

L3 1ES

 

mailto: [EMAIL PROTECTED]

Tel 0151 242  x.358

Fax 0151 242 7704

 




The information in this e-mail is confidential and intended to be solely for the use of the addressee(s) and may contain copyright and/or legally privileged information.  If you are not the addressee (or responsible for delivery of the message to the addressee) please e-mail us at [EMAIL PROTECTED] and delete the message from your computer; copying, distribution, use or disclosure of its contents is strictly prohibited.
As Internet communications are capable of data corruption no responsibility is accepted for changes made to this message after it was sent. For this reason it may be inappropriate to rely on advice contained in any e-mail without obtaining written confirmation of it.
In addition, no liability or responsibility is accepted for viruses and it is your responsibility to scan attachments (if any).
Please note that for business purposes, outgoing and incoming emails from and to the company may be monitored and recorded.

 
Mouchel Parkman Services Ltd, Registered in England at West Hall, Parvis Road, West Byfleet, Surrey UK KT14 6EZ Registered No : 1686040


___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


[MI-L] Cadrg Files

2006-07-04 Thread Greg Gainey



Hi
 
I have a number of 
CADRG raster images that MainInfo v8.5 documentation says it now supports, 
however, I can not find the option to import these files in any of the 
open/import table options. 
 
Do I need a special 
tool or have I overlooked the obvious?
 
thanks 

Greg
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


[MI-L] a sort of routing problem

2006-07-04 Thread Verspagen, B.
Title: a sort of routing problem






Hi,


I am trying to solve the following puzzle in Mapinfo:


I have a table/map with information on regions (counties in the UK). I have also drawn a layer of polylines into that map, these polylines represent railway lines. Obviously, when the railway lines are layered over the map of counties, they will "connect" some of the counties. I am looking for a way to automatically make a list of which counties are connected by each individual line. For example, if a line goes from Cornwall to Devon to Dorset to Hampshire to Surrey, and stops there, I would like a script/utility that generates this list (Cornwall-Devon-Dorset-Hampshire-Surrey).

I am not a GIS-expert (so please try to go slow in suggesting solutions), but this seems like a pretty standard problem to me. So I figured it would be a standard feature, or something for which people had written scripts. But so far I haven't found anything that helps. 

I am using Mapinfo Pro 7.8, unfortunately don't have Mapbasic, but I am able to programme in a bunch of other languages (outside Mapinfo). So, a partial solution that generates some data that could be used further outside Mapinfo would already make me happy. 

Thanks for any help.


Best regards,

Bart Verspagen



___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


[MI-L] Changing the bounds clause

2006-07-04 Thread John Eyre



I've already had help with this problem but clearly 
not enough!
First the problem.
I am using 1:10,000 Ordnance Survey maps and 
overlaying these with site outlines. When I open the site outline table, the 
detail on the underlying OS map goes into square blocks. I have been advised 
that this is because the coordinate system of the OS map window is being limited 
by the bounds of the site layer. To correct this, I have to change the bounds of 
the site layer so that it doesn't control the spatial granularity of the OS 
Map. 
 
I need help in actually doing this! Can anyone 
spell out in layman's terms how I go about it?
Many thanks.
John
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


[MI-L] Lengthening lines

2006-07-04 Thread Michele Tuomi
Hello everyone;

I have about 20 lines of the same length in my map.  I'd like to lengthen
them all.  Is this possible to do as a group, or do I have to lengthen each
one individually?

Thanks in advance,
Michele


___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


[MI-L] Selecting Dates

2006-07-04 Thread Ronning, Christine
Title: Selecting Dates






Hi everyone,

I'm trying to select dates from a table and keep getting the "Could not Convert Data" error message and I have no idea why!

I've used the following in the SQL Select Box:

Select Columns: *
from Tables: tmep
where condition: Dat_of_Shift="14-06-2006"

When I use the verify button it comes up with the "Syntax is Correct" message

Can anyone help me with why it won't select records with the requested date?  Thanks

Christine




___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


RE: [MI-L] Selecting Dates

2006-07-04 Thread Ronning, Christine
Title: RE: [MI-L] Selecting Dates






Never mind, figured it out!


-Original Message-
From: [EMAIL PROTECTED] on behalf of Ronning, Christine
Sent: Tue 7/4/2006 12:16 PM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] Selecting Dates

Hi everyone,

I'm trying to select dates from a table and keep getting the "Could not Convert Data" error message and I have no idea why!

I've used the following in the SQL Select Box:

Select Columns: *
from Tables: tmep
where condition: Dat_of_Shift="14-06-2006"

When I use the verify button it comes up with the "Syntax is Correct" message

Can anyone help me with why it won't select records with the requested date?  Thanks

Christine





___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


[MI-L] Scandanavia Postcodes

2006-07-04 Thread Tim Rideout
Title: Auditing edits made to mapinfo tables.



Dear All,
 
I have been asked by a client to find out what is 
available in the way of postcode map data sets for Sweden, Finland, Norway and 
Denmark. Ideally what they would like is something like the UK PAF / PostZon 
data that lets you track down an address to a few hundred metres, but I realise 
the postcodes in this area are not as detailed as that.
 
All information will be much 
appreciated,
 
regards
 
Tim
 
Dr Tim Rideout
Director
 
Visit XYZ at the Cape Town 
International Book Fair, June 2006, Frankfurt Book Fair, Oct 2006, Intergeo 
Munich Oct 2006 or IMTA World in Singapore, Nov 2006
 
The XYZ Digital Map Company
Unit 9 Phase 2 Hardengreen Business 
Park
Dalhousie Road, Dalkeith
EH22 3NX, Scotland, Europe
 
Tel: +44 131 454 0426
Fax: +44 131 454 0443
Mobile: +44 7766 825937
Email: [EMAIL PROTECTED]
Web: www.xyzmaps.com
 
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


Re: [MI-L] Scandinavia Postcodes

2006-07-04 Thread Uffe Kousgaard
Title: Auditing edits made to mapinfo tables.



The very small postcode zones are unique to the UK 
as far as I know. My own postcode zone here in Denmark is >20 km from North 
to South, so that won't bring you much detail. But "exact" address coordinates 
for almost the whole country is available. Not for free, but not very expensive 
either.
 
Kind regards
 
Uffe Kousgaardwww.routeware.dk
 
 

  - Original Message - 
  From: 
  Tim 
  Rideout 
  To: mapinfo-l@lists.directionsmag.com 
  
  Sent: Tuesday, July 04, 2006 10:39 
  PM
  Subject: [MI-L] Scandanavia 
  Postcodes
  
  Dear All,
   
  I have been asked by a client to find out what is 
  available in the way of postcode map data sets for Sweden, Finland, Norway and 
  Denmark. Ideally what they would like is something like the UK PAF / PostZon 
  data that lets you track down an address to a few hundred metres, but I 
  realise the postcodes in this area are not as detailed as 
  that.
   
  All information will be much 
  appreciated,
   
  regards
   
  Tim
   
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


Re: [MI-L] Changing the bounds clause

2006-07-04 Thread Uffe Kousgaard



I think the only way is to export the table to a 
MIF file, change the coordsys in the MIF file and re-import.
 
Kind regards
 
Uffe Kousgaardwww.routeware.dk
 

  - Original Message - 
  From: 
  John 
  Eyre 
  To: MapInfo 
  Sent: Tuesday, July 04, 2006 6:10 
PM
  Subject: [MI-L] Changing the bounds 
  clause
  
  I've already had help with this problem but 
  clearly not enough!
  First the problem.
  I am using 1:10,000 Ordnance Survey maps and 
  overlaying these with site outlines. When I open the site outline table, the 
  detail on the underlying OS map goes into square blocks. I have been advised 
  that this is because the coordinate system of the OS map window is being 
  limited by the bounds of the site layer. To correct this, I have to change the 
  bounds of the site layer so that it doesn't control the spatial 
  granularity of the OS Map. 
   
  I need help in actually doing this! Can anyone 
  spell out in layman's terms how I go about it?
  Many thanks.
  John
   
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


Re: [MI-L] Auditing edits made to mapinfo tables.

2006-07-04 Thread nicholas . g . lawrence
> Lars I. Nielsen said
>
> I'll make a simple feature suggestion for MI Pro 9.0

Just how do we make feature suggestions for MapInfo?

Does MapInfo read this list?

Is there a place on the MapInfo web site where feature suggestions can be
logged?

Does MapInfo have a contact person who can be emailed suggestions?

Once submitted, do suggestions have a tracking number? Can we track their
progress?

nick



Opinions contained in this e-mail do not necessarily reflect
the opinions of the Queensland Department of Main Roads,
Queensland Transport or Maritime Safety Queensland, or
endorsed organisations utilising the same infrastructure.
If you have received this electronic mail message in error,
please immediately notify the sender and delete the message
from your computer.

___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


RE: [MI-L] Changing the bounds clause

2006-07-04 Thread Llewellyn, David









John,

 

You can also use the “Coordsys
Bounds Manager” tool. I think this has been included in MapInfo since
about V7.0.

Go to “Tools/Tools Manager”
to add it into your list of tools.

 

Cheers

 

























David Llewellyn    

























 

-Original
Message-
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Eyre
Sent: Wednesday,
 5 July 2006 12:10
 AM
To: MapInfo
Subject: [MI-L] Changing the
bounds clause

 



I've already had help with this
problem but clearly not enough!





First the problem.





I am using 1:10,000 Ordnance Survey
maps and overlaying these with site outlines. When I open the site outline
table, the detail on the underlying OS map goes into square blocks. I have been
advised that this is because the coordinate system of the OS map window is
being limited by the bounds of the site layer. To correct this, I have to
change the bounds of the site layer so that it doesn't control the spatial
granularity of the OS Map. 





 





I need help in actually doing this!
Can anyone spell out in layman's terms how I go about it?





Many thanks.





John









If this email has been received in error, please delete all copies and inform the National Native Title Tribunal by return email or telephone 1800 640 501.  The Tribunal does not warrant that its email is virus free.  All emails sent to the Tribunal are filtered for viruses and inappropriate content. Thus your email may not reach the person to whom it is addressed. Seek confirmation of receipt of your email if you consider the email important.
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l


Re: [MI-L] Auditing edits made to mapinfo tables.

2006-07-04 Thread Richard Greenwood

On 7/4/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:


Once submitted, do suggestions have a tracking number? Can we track their
progress?


They don't even let us users track bugs, let alone feature requests!
It really discourages user participation. All MI wants from us is our
credit card number.

Rich

--
Richard Greenwood
[EMAIL PROTECTED]
www.greenwoodmap.com
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l