[MI-L] Universal Translator

Title: Universal Translator Hi all, I'm having trouble converting some shapefiles to tab files and don't know why. I am able to convert some of them no problem, but others are failing. I printed out a sucessful log and failed log to compare the difference and everything seems to be running

[MI-L] Labels not showing up in Print Layout

Title: Labels not showing up in Print Layout Hi everyone, Thanks for the replies on my question yesterday abou the workspace not opening. I had to recreate the page I was trying to open as someone needed it right away, but I will try the suggestions later this afternoon. My next problem

RE: [MI-L] Labels not showing up in Print Layout

Title: Message Thanks David, I actually just closed out of the workspace and re-opened it and noweverything works fine! Sorry should have tried this before posting the question. Christine From: David Reid [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 9:40 AMTo: Ronning, Christine

[MI-L] Selecting Dates

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

RE: [MI-L] Selecting Dates

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

[MI-L] Legend not displaying properly

Title: Legend not displaying properly Hi all, Part of the program I've written inserts a legend into layout view. This is working properly but the legend text and objects all bunch together in the middle of the frame. When I go into the layout manually and double click on the frame to

[MI-L] Datatype Mismatch in Expression

Title: Datatype Mismatch in Expression Hi, I'm coping a bit of code below that I'm getting stuck on. mszDate is a Global SmallInt variable that contains the value of a selection from a MultiList Box, which I obtained using ReadControlValue. The program compiles with no errors but when

[MI-L] Number of points in a buffer

-Original Message- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED]] Sent: Wed 6/21/2006 2:17 PM To: Ronning, Christine; MapInfo-L@lists.directionsmag.com Subject: RE: [MI-L] Wrong Subject on last one: Spatial Query Christine, I'm sure there are a number of ways to do this. Here is mine 1

RE: [MI-L] Number of points in a buffer

Title: RE: [MI-L] Number of points in a buffer Hi all, Sorry please ignore my last note. Thanks Peter your suggestion works like a charm! Christine -Original Message- From: [EMAIL PROTECTED] on behalf of Ronning, Christine Sent: Tue 6/27/2006 9:26 AM To: Peter Horsbøll Møller

[MI-L] Selecting object types

Title: Selecting object types Hi all, Can anyone tell me how to select object types within a table? For example I have a table with points and regions but would like to seperate them out. How would I select just the points? Thanks Christine -Original Message- From: [EMAIL

[MI-L] no DAT found

Title: no DAT found Okay, Sorry about this multitude of questions today: In MapBasic I want to save a copy of a table and open it in the workspace. I've used Commit Table Pen_Ver_Emp As F:\CHSPR\data\cronning\Data\Proof of Concept\Buffer_Employee.TABTYPE NATIVE Charset WindowsLatin1 Open

RE: [MI-L] Creating a line from a series of points

Title: RE: [MI-L] Creating a line from a series of points Hi all, I have mapped a points layer. I would like to select those records where there is more than 10 points within a radius of .5km. I'm having trouble even starting on this one! Can anyone provide some guidance/thoughts? Thanks

[MI-L] Wrong Subject on last one: Spatial Query

Title: Wrong Subject on last one: Spatial Query Hi all, I have mapped a points layer. I would like to select those records where there is more than 10 points within a radius of .5km. I'm having trouble even starting on this one! Can anyone provide some guidance/thoughts? Thanks

RE: [MI-L] Wrong Subject on last one: Spatial Query

Title: Wrong Subject on last one: Spatial Query Thanks Peter, One of those days where the brain stopped working creatively once lunch hit! Christine From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 2:17 PMTo: Ronning, Christine; MapInfo-L

[MI-L] Naming a query window

Title: Naming a query window Hi all, Easy question I'm pretty sure, but I don't know the answer. I've created a tool that brings up specific attributes for a health site once you click on it. Instead of it saying Query1 in the browser window is there an easy way name the window something

RE: [MI-L] Naming a query window

-Original Message- From: Ben A Greenberg [mailto:[EMAIL PROTECTED]] Sent: Tue 6/13/2006 12:45 PM To: Ronning, Christine; MapInfo-L@lists.directionsmag.com Subject: RE: [MI-L] Naming a query window You can name the query by using into in the sql statement. Select * from Table into qryResults

RE: [MI-L] Naming a query window

:52 PM To: Ronning, Christine; MapInfo-L@lists.directionsmag.com Subject: RE: [MI-L] Naming a query window Use Alter Window Title to accomplish the effect you want. HTH Spencer Sub BrowseEquipTable If gMouseclickX = -119.491592 And gMouseclickY = 49.873164 Then Select * From DI_Equip WHERE

[MI-L] Changing font colour in browser

Title: Changing font colour in browser Hi all, Is it possible to change the font colour of selected records in a browser window? Id like to make it more obvious what records are selected. Thanks Christine ___ MapInfo-L mailing list

[MI-L] MapBasic and MapXtreme

Title: MapBasic and MapXtreme Hi all, Excuse my ignorance in this, but hoping to understand a little bit more about the relationship between MapInfo capability with web software (MapXtreme). After a little research I see that you can use .NET languages which brings me to my question. If

[MI-L] Page size

Title: Page size Thanks to all who replied about my page size issue. Seems the most common solution is to download a printer driver that I won't actually print to, but has the paper size Im looking for. Works fine thanks Christine ___ MapInfo-L

[MI-L] Printing

Title: Printing Okay, Now that I have my layout set up how I want it, printing to PDF is causing some issues. I have the page layout set to 36X60 but when I print to PDF the bottom 1/4 or so of the map doesn't show up. The size of the PDF is correct, but it doesn't print the whole map from

[MI-L] Printing

Title: Printing Eric suggested changing my dpi from 1200 to 600. It was already at 600, but changed to 300 (minimum required by printers at this size of map for quality resolution) and now is printing properly! Thanks so much Christine ___

[MI-L] Page Size

Title: Page Size Hi all, I'm creating a wall size map and planning to send to a printing service for them to print out the map. We obviously dont have any printers here that will accommodate something of that size and this is where the problem lies. I would really like to create in layout

[MI-L] Editing and Queries

Title: Editing and Queries Thanks to Bill and Jaques for their replies on my editing question. I started again following their suggestions and have a clean file now. Next question!: I've performed a query on a table by 'city' field to find all patients that live in the Kelowna Area

[MI-L] Area Calculations

Hi all, I'm calculating the area of some boundaries, and have noticed that when I change the Map Options Distance/Area using: from Spherical to Cartesian the area calculation is the same. Shouldn't it be different and does anyone know how to change this setting so it reflects the different

RE: [MI-L] Area Calculations

[mailto:[EMAIL PROTECTED] Sent: Thursday, February 16, 2006 11:09 AM To: Ronning, Christine; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] Area Calculations Christine, You say that you are calculating the area of some boundaries. How exactly are you doing this ? If you use Update Column, you

[MI-L] Transparent Dot Thematic Map

Hi everyone, I'm wanting to overlay two thematic maps with different data on the same map. I was hoping to do this by using solid colour as the bottom layer and either variously spaced lines, or dots on top. I used the standard Region Ranges Transparent Dots in the create thematic map but

MI-L Area of a polygon

Hi all, I've done this before and can't figure out why it isn't working right now. I'm creating a circular buffer around a point to calculate population density within a 1km radius. Some of these buffers fall on water and so I want to subtract the area that covers water from the original buffer

MI-L Custom Thematic Symbol

Hi List, I loaded in a symbol that I created in paint as a bitmap and I can use this for points in a normal layer. However when I try to use the same symbol in a graduated symbol map is doesn't work. Does anyone know why? Thanks Christine

RE: MI-L Map Basic Application not inserting text where wanted

11:50 PM To: Ronning, Christine Cc: MapInfo-L@lists.directionsmag.com Subject: Re: MI-L Map Basic Application not inserting text where wanted Hi Christine, You've also defined the column names as local variables, and they override any table based column references. If you delete the problematic

MI-L Map Basic Application not inserting text where wanted

Hi List, Just wondered if you could look over the following code and see if there's anything obviously wrong! I'm trying to identify the maximum value from a row based on values in Table Population_Var and place the column name of this value into another column. I've managed to find this

MI-L Landscape layout orientation

Hi List, I know I've asked something similar to this before but I can't seem to find it anywhere in my notes or in the archives. I have a series of pages in a layout view. I want to save them in landscape orientation, but each time I open the workspace they've gone back to portrait. When this

MI-L RE: Update row with field name

der Linden Sent: Thursday, August 18, 2005 12:22 AM To: Ronning, Christine Cc: 'Mapinfo-L' Subject: RE: Update row with field name A couple of questions: - Did the update population_Var Set Max_Count statement actually create data in your Max_Count column? Check to see this in mapinfo via

MI-L Universal Translator not working

Hi, I'm trying to convert some MapInfo .tab files to ESRI shapefile using the Universal Translator. All .tab files open up in MapInfo no problem. Most of the files I'm trying to do this with have worked, but a few have not. I don't see any consistancy with those that convert and those that

RE: MI-L SQL question

Hi Group, Thanks to all those who replied about the Universal Translator. I am going to wait and try to use MapInfo 7.8 on my other workstation, where the files were originally created, instead of the 7.0 verion which is what I've been trying to translate with. Hopefully it works! My next

MI-L RE: Update row with field name

If 'repeated for each age group End Sub -Original Message- From: Milo van der Linden [mailto:[EMAIL PROTECTED] Sent: Wed 8/17/2005 3:08 PM To: Ronning, Christine Cc: 'Mapinfo-L' Subject: RE: MI-L SQL question There is, but it seems that you need to loop all the records and for that you

MI-L Graphs

Hi list, I'm creating a Bar Graph right now and I want to do two things that I can't seem to figure out: How to change the y axis maximum value? How to get rid of the series legend that is automatically created with the graph? And thanks to those who repsonded to my post yesterday on MapBasic

MI-L MapBasic Sample Applications

Hi List, I apologize if this has already been sent to Lars and/or Bill. I having being using MapInfo for about 6 months now and am just about the start using MapBasic. I have limited programming experience (Beginner VBA course and web application for school lab requirements), but think I have

MI-L Maximum Function

Thanks to those who replied, By nesting the function Maximum(Maximum(Maximum(field1,field2),field3) I was able to get the value I was looking for Christine

MI-L Maximum function

Hi Group, Just wanted to double check that the 'Maximum' function can only do comparison between 2 fields? It works for me when I use 2, but I want to find the highest value in each record using a criteria of 7 fields. Any other ideas on how to do this? Thanks, Christine Christine Ronning GIS

MI-L Field not defined

Dear List, I was playing around in a workspace as I needed to edit a table that was already open in it. I didn't save the workspace afterwards because I wanted the original formatting and layout to be the same. I'm guessing because I deleted a field one of the tables and didn't save the

MI-L Lines in browser table

Hi list, Is there a way to insert a browser table into a layout but modify it show the lines of the table don't print? Thanks Christine

MI-L Concentric Ring Buffer

Hi all, I'm calculating the average population/square kilometer of labs in a certain area using the concentric ring buffer. At the moment if I select more than one object the average between all objects is calculated and I only get one value. Does anyone know of a relatively easy way to

MI-L Changing legend order

Hi all, I wanted to change the order of legend items in a workspace so I opened it up in Notepad and cut/paste to change the order. I have done this many times succuessfully in a regular legend, but not a thematic, should it make a difference? Below is the values I changed around and the first

MI-L Concentric Ring Buffer

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

MI-L Double symbols in legend

Hi all, I have a facilities point layer that I've used a variety of symbols to show different type of facilities. My problem is when I create a legend the same symbol is showing up more than once. Does anyone know why this is and how to get just one of each symbol to be listed in the legend?

MI-L Updating a field

Hi all, I'm trying to update the mapping type field for one of my tables based on the service type. I have used the following: Update Facilities_Test2 Set Mapping_Type = A This works fine. However the following does not: Update Facilities_Test2 Set Mapping_Type = A Where Service_Type = H

MI-L Formatting Fields

Hi everyone, This is probably pretty simple, but I need some help. I have just received a road network that has listed address ranges associated with it, that were originally formatted as decimal. The problem I have is that the numbers have thousand seperators in them which I don't want for

MI-L Source files

Hi all, I work off a network drive that is very slow and it's much faster for me to copy over my files to my hard drive and work from there. However when I open up my workspace the files are still pointing to the network drive. I know how to change the source files in ArcView and know there

MI-L Source Files solved

Thanks Kent and Micheal, Problem solved! Christine

MI-L Returning numeric values from a string

Hi all, I'm trying to separate out all the numeric values from a string field. I've tried using the Var(field) syntax, but because most of the values in my field have characters before the number, it's not working. Does anyone know how to do this? Thanks, Christine

MI-L Changing symbol size in legend

Hi everyone, Can anyone tell me how to change symbol size in the legend to appear bigger, without chaning it on the map? Thanks Christine

MI-L Symbols not displaying

Hi all, I've created a thematic map using pie charts, but after the theme is created nothing shows up on the map. It's listed in the layer control box, but I can't see it. Does anyone have any ideas? Thanks, Christine

MI-L .e00 format

Hi everyone, I am wanting to download some files that are in .e00 format. Does anyone know how to get this into a format that MapInfo can read? Thanks, Christine

MI-L .e00

Thanks to everyone that responded so quickly! I tried the Universal Translator a while ago and it didn't work, but maybe it's the projection that I need to play around with. I let you know if I have any more problems. Thanks again Christine

MI-L MapInfo Not Responding

Hi all, Thanks for your suggestions. On the advise of Jon Gramm I deleted all .tmp files I could, to see if that was why the program was crashing. It wasn't. I've tried numerous things; indexing the field I'm joining on, making sure that the table fields are the same, and saving the matched

MI-L Lables

Hi all, I have noticed that when you manually select and move a lable it is no longer turns on or off with the label option in the Layer Control box. You now have to edit this lable seperately. Even if you have the editing box selected the label seems to be added to the cosmetic layer. Can

MI-L MapInfo Not Responding

Hi all, I've done a match on records by postal code and 30 of the records don't match up. I tried the following to try and select all records that were matched in the original table and then use the invert selection tool to find all those records that didn't match. Select * From IH_All_Babies

MI-L Updating fields

Thanks to all who have replied about my not being able to update a field. The e-mail that solved my problem was from Soren Breddam in which he suggested that you can't perform an update with a WHERE clause. I used the following to successfully update my field. Select * From

MI-L Removing 0's

I know there has to be an easy way to do this, but I can't figure it out right now. I have a field I want to join two tables on, but on of the tables has 00 infront of each number. Ex want to join one field (value =1) and other field (value = 001). Does anyone know the syntax to removes these

MI-L Can't update field

Hi again, Sorry but I'm pretty new to using SQL so these questions are probably pretty easy to figure out. I would like to create pie charts for each geographic region that will show elective vs. urgent surgeries. As far as I can tell I will need to do this with a numeric field so I'm trying to

MI-L Still can't update

Hi all, Thanks for all the suggestions, but nothing seems to work. I know my syntax is correct now, but the same message Cannot perform this operation on field Elective_vs__Urgent. I looked up in MapInfo Help menu and tables that have been grouped can't be updated, so I queried from the

MI-L Different sized symbols

Hi, I'm creating a thematic map of cities and would like to theme the points so that population is symbolized by both a different colour and symbol size. I've looked at the Graduated Symbol Default and Individual Point IndValue Default thematic options, but on one you can't differeniate colour,

RE: MI-L Problem with MapInfo crashing

I agree, that was my problem a couple months ago Christine Ronning -Original Message- From: Ben A Greenberg [mailto:[EMAIL PROTECTED] Sent: Thursday, March 31, 2005 2:29 PM To: Brown, Jennifer; mapinfo-l@lists.directionsmag.com Subject: RE: MI-L Problem with MapInfo crashing By any

RE: MI-L Trouble saving Layout Page Setup.

No, but I also would like a solution to this, as I have the same problem! Christine Ronning GIS Technician 740 Carmi Avenue Penticton, BC V2A 8P9 250-770-3408/250-870-4677 [EMAIL PROTECTED] -Original Message- From: Mcinnis, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22,

MI-L Reader

Hi everyone, Just wondering if anyone knows of a product similar to ArcReader for MapInfo? Thanks, Christine - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED]

MI-L Raster Analysis

Hi all, I'm just wondering if anyone knows what software application would be best to buy for raster analysis. I would be working mainly with site suitability. Thanks Christine Ronning GIS Technician 740 Carmi Avenue Penticton, BC V2A 8P9 250-770-3408/250-870-4677 [EMAIL PROTECTED]

MI-L Mapping pandemics and epidemics

Hi all, I'm looking for some sources right now so I can research mapping pandemics and epidemics. Does anyone know of any examples of this or sites that may be helpful to search? Thanks, Christine - List hosting provided by

MI-L Variables Not Defined

Hi all, I'm doing a SQL Select query and am having some problems. I have joined three tables together and am trying to select only the columns I want right now in SQL Select. (I've tried writing in MapBasic but am getting the same result). 3 of the variables have the message Variable Not

MI-L Saving table without geographic data

Hi Robert, I don't know if this will work, but if you go to table maintenance and deselect table is mappable checkbox it should delete any spatial references. Christine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:20 PM To:

RE: MI-L MI-ArcView Shape Files (.shp)

Hi Jake, I've found that when importing shape files it's very important to do so in the same projection the file originally came in. I know when I've imported it automatically goes to default of Lat and Long, however most of the shape files I'm using are in a NAD 83 BC Albers projection. I'm

MI-L Point Density Map

Hi all, Does anyone know what function I would use to do a point population density map in MapInfo? Thanks Christine - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL

RE: MI-L Point Density Map

:[EMAIL PROTECTED] Sent: Monday, March 07, 2005 2:31 PM To: Ronning, Christine; MapInfo List Subject: Re: MI-L Point Density Map Hi Christine I'm not sure if I understand your intent for point density correctly, but Spatial Decisions (a MapInfo Partner form Australia) has the global (except Europe

MI-L Workspace answers and question on themes

Hi all, Thanks so much for your answers with about my workspaces not coming up. It was the printers, I've hooked them back up and I'm in business! Another question now: I have joined two tables together, one that has my geographic boundaries (Local Health Areas) with an attribute table

RE: MI-L Table comparaison

Hello all, I've have a bad news, good news scenario: Good news, I have a new laptop. Bad news, I can get all of my TAB files to come up, but none of my workspaces. I have to tell MapInfo where to get all the files from, which works fine and everything comes up, but when it gets to the

MI-L Wrong subject (Workspaces not coming up)

Sorry didn't have the right subject originally: Hello all, I've have a bad news, good news scenario: Good news, I have a new laptop. Bad news, I can get all of my TAB files to come up, but none of my workspaces. I have to tell MapInfo where to get all the files from, which works fine and

MI-L Edit graduated symbols?

Hi all, I've created a thematic map layer that consists of graduated circles. I'm trying to create a more cartographic pleasing map and would like to be able to select the objects as individual objects. Does anyone know how to do this? Thanks, Christine

MI-L Transparency

Hi everyone, Just wondering if anyone knows of a way to make layers transparent? Thanks, Christine - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For

RE: MI-L Transparency

Thanks Ryan, Unfortunately I don't have any graphics software! Does anyone have any suggestions on a good one to get? Christine -Original Message- From: Ryan Morgan, Aerials Express [mailto:[EMAIL PROTECTED] Sent: Monday, February 21, 2005 1:44 PM To: Ronning, Christine; mapinfo-l

MI-L Combining text from two columns into one

Hi, I'm new to MapInfo and SQL so sorry if this questions is very simple. Anyways I'm trying to combine two text columns into one. What SQL command should I be using? I'm depending on my excel knowledge and was trying to use CONCATENATE, which isn't working! Also any good referene material

MI-L Geocoding by street address and postal code

Hi everyone, I'm trying to geocode some records that have a street address and 6 digit postal code. The street network I am geocoding to only has a 3-digit postal code though. It's for all of BC so obviously there are a lot of repeat street names. Is there any way to specify to look first

MI-L Queries as individual Files

Hi everyone, I have just started using MapInfo, so very new to the program, but do have experience with other GIS software. I have selected the BC polygon data from a Canadawide dataset in a query. I saved the query, but it will only display when the Canada table is open to query from. Does