Re:: MI-L Please help me with SQL select!

2005-01-24 Thread Nigel James
Hi Sarah It might be easier to use the buffer as a to cut out those parts of the polys which are within the buffer. You can then get the area of the new polys. 1. Make a backup copy of your forests table first. 2. Make the forests table editable and select all polys which overlap the buffer

Re:: MI-L MapBasic Compatibility

2005-02-02 Thread Nigel James
Hi Greg and all There's a free utility available called MBXVer: http://www.stopwatchmaps.com/products/mbxver.html It will check which is the earliest version of MapInfo that your mbx will run on and change the code for you. Nigel James On Wed, 2 Feb 2005 23:23:38 +1100 Greg Gainey &l

Re:: MI-L Reading MasterMap

2005-02-16 Thread Nigel James
Hi Sam and all I have written an OS masterMap to MIF/MID translator which can be downloaded free from the Bodleian Map Room website: http://www.bodley.ox.ac.uk/guides/maps/translat.htm It translates the Topo, Address and ITN layers and applies MasterMap colours and styles. Nigel On Tue, 1

Re:: MI-L Label/Text size

2005-02-17 Thread Nigel James
Hi Brian Labels attached to objects (those created using autolabel or the label tool) stay the same size regardless of map scale. Graphic text (text added using the text tool) changes size when the map scale is changed, so if the map in your layout is at a larger scale than the source mapper, t

Re:: MI-L Coordinates

2005-03-08 Thread Nigel James
Hi Andrew Create two new columns (integer type) for eastings and northings, then use Update Column with the function Left$(gridrefcolumn,6) for the eastings and Right$(gridrefcolumn,6) for the northings. If you are working with conventional (i.e. SP123456 type grid refs), I have written a MapB

Re:: MI-L Coordinate Systems

2005-04-04 Thread Nigel James
Hi Nichola I assume you want to enable a user to enter an OS grid ref in conventional (SP123456 etc) form? If so, you could use a Do Case statement to read the first 2 chars from the input string and get the corresponding number. You could then split the rest of the string to get the eastings

Re:: MI-L MapInfo freezing (label problem?)

2005-04-15 Thread Nigel James
I don't know the answer, but I had a similar problem a while ago when running MI from a server - I only changed the label background and MI froze. I had to close down completely and restart. This has only happened when accessing data files from a server - normally I use MI with all data files o

Re: MI-L convert uk easting/westing coordinates to decimal degrees

2005-04-21 Thread Nigel James
and CentroidY for lat. By default MI will use decimal degrees for the values. Nigel On Thu, 21 Apr 2005 14:20:37 +0100 Martin A Spiers <[EMAIL PROTECTED]> wrote: > > Nigel James' mapinfo coordinate co

Re:: MI-L MI-L: US Boundary Tables

2005-05-17 Thread Nigel James
NAD83) projection. regards Nigel James On Mon, 16 May 2005 12:37:38 -0400 "Ali, Naz @ Vancouver" <[EMAIL PROTECTED]> wrote: > Hi: > > I am looking for a very basic US Boundary file. One with the state > boundaries would be great but just with the country boun

Re:: MI-L Excel Sheets

2005-05-19 Thread Nigel James
Hi Andrew Open your Excel table in MapInfo and save a copy with a different filename (or in a different folder). Close the original table and open the copy. This will be editable. Make your data table mappable (Table>Maintenance>Table structure) and set the projection to match the map. Now ad

Re:: MI-L Double symbols in legend

2005-06-01 Thread Nigel James
iated with each layer. best wishes Nigel James On Tue, 31 May 2005 12:29:17 -0700 "Ronning, Christine" <[EMAIL PROTECTED]> wrote: > Hi all, > > I have a facilities point layer that I've used a variety of symbols to > show different type of facilities. > >

Re:: MI-L Decimal Places

2005-07-14 Thread Nigel James
Hi Andrew Use Table>Maintenance>Table Structure, then select each field in turn and change the format to Decimal. You can then specify the number of places. If the table has been opened in MI from an Excel file, you will have to save a copy first and modify that, as you cannot change the Excel

Re:: MI-L Convert NGR to Easting and Northing

2005-08-19 Thread Nigel James
Hi Matt I have written a Mapbasic tool which can do this (Conversion Tools) - it also converts D:M:S etc to decimal and creates points all in one step. It can be downloaded form the Map Room website: http://www.bodley.ox.ac.uk/guides/maps/geo_tools.htm It is not zipped, so remember to right-c

Re:: MI-L Hectares?

2005-09-15 Thread Nigel James
Hi Mark use: Area(obj, "hectare") To find the correct definition for distance or area units, open the MapBasic Window (under Options in 7.8). With the mapper containing the objects active, go to Map>Options then change the area units to the type you want. Click OK and you will see the action

Re:: MI-L OS Mastermap address layer

2005-09-20 Thread Nigel James
Room website: http://www.bodley.ox.ac.uk/guides/maps/translat.htm - along with a batch importer to import all topo layers at one go. Nigel James On Tue, 20 Sep 2005 12:24:48 +0100 Neil Pinheiro <[EMAIL PROTECTED]> wrote: > Hi > > I'm unable to import the address l

Re:: MI-L Dispalying data point in Map

2005-09-21 Thread Nigel James
can download it free from: http://www.bodley.ox.ac.uk/guides/maps/geo_tools.htm regards Nigel James On Tue, 20 Sep 2005 18:52:10 +0100 Ali Zolfaghari <[EMAIL PROTECTED]> wrote: > Hi List, > Does anyone have a MapBasic code that converts a data points table into a >

Re:: MI-L coordenadas

2005-10-13 Thread Nigel James
For a single point, jsut double-click with the Select tool regards Nigel James On Wed, 12 Oct 2005 16:41:24 + Nicolas Labombarda <[EMAIL PROTECTED]> wrote: > > Hi, I am trying to know the X;Y coordinates of for example a point in a > layer. with wich tool I can do that

Re:: MI-L Importing Census Demographic Info into MapInfo

2005-10-18 Thread Nigel James
Hi Akua Our students use US Census data and mapping with MapInfo. I have created a user guide for them (and anyone) which can be found on the Map Room web pages: http://www.bodley.ox.ac.uk/guides/maps/uscensus.htm regards Nigel On Mon, 17 Oct 2005 15:04:30 -0400 [EMAIL PROTECTED] wrote: >

Re:: MI-L Réf. : RE: MI-L Importing Census Demographic Info into MapInfo

2005-10-18 Thread Nigel James
The boundary files in .shp and .e00 formats are at: http://www.census.gov/geo/www/cob/bdy_files.html Nigel On Tue, 18 Oct 2005 09:10:50 +0200 [EMAIL PROTECTED] wrote: > I went there and found : http://www.esribis.com/data/census2000.html, but > nothing free. Do you have a link to the free da

Re:: MI-L Converting OS National Grid Reference

2005-10-19 Thread Nigel James
Hi Mark I have written a Mapbasic tool to do this (Conversion Tools). You can download it from the Map Room website at: http://www.bodley.ox.ac.uk/guides/maps/geo_tools.htm regards Nigel On Wed, 19 Oct 2005 11:50:28 +0100 "Brown, Mark" <[EMAIL PROTECTED]> wrote: > Hello all! I have an e

Re:: MI-L Problem while importing MIF file

2005-10-28 Thread Nigel James
Hi Ali Text objects use 2 coord pairs - X1,Y1 and X2,Y2, defining the rectangle containing the text. In your example you have the same value for Y1 and Y2, so the text has effectively no height and so does not appear. The difference between Y1 and Y2 determines the text size, so you need to us

Re:: [MI-L] converting British Ordnance survey Grid Reference

2005-11-25 Thread Nigel James
Hi Ali I have written a MB tool to do this (Conversion Tools) - it converts GB and Irish OS grid refs to eastings and northings (x,y) and creates a mappable table of points. (It converts lat/lon in d:m:s etc., as well) You can download it from: http://www.bodley.ox.ac.uk/guides/maps/geo_tools

Re:: [MI-L] converting British Ordnance survey Grid Reference

2005-11-25 Thread Nigel James
Hi Ali I have written a MB tool (Conversion Tools) to do this. It converts British and Irish OS grid refs to eastings and northings (x,y) and creates a mappable table of points (it converts lat/lon in d:m:s etc., as well). You can download it from: http://www.bodley.ox.ac.uk/guides/maps/geo_t