Re: MI-L Vertical Mapper Contouring Intervals Problem

2004-01-14 Thread InDepth Solutions
I remember having to do this before... If your dataset range is 253ft - 1096ft (for example), set your lowest contour interval to 250ft and your highest to 1100ft, then set your interval to what ever you like (10, 25, 50, 100, etc.) and away you go. If you are creating 500 ft intervals, then set

RE: MI-L Vertical Mapper Contouring Intervals Problem

2004-01-14 Thread Ian Tidy
Colin What version of Vertical Mapper are you using. I have just finished a contouring job and I was able to stipulate the Minimum, and Maximum Levels and the Interval. I am using Vertical Mapper 3. When I bring up the Grid Manager and Select Contour there is an Interval Button. This will let

MI-L Vertical Mapper Contouring Intervals Problem

2004-01-14 Thread Colin Anderson
I'm contouring with Vertical mapper and I've found what I hope is a bug... What I would like to do is set a minimum, maximum and contour invterval, however the manual stipulates you can only edit one of them. Thus, it is impossilble to achieve even contouring intervals since my dataset doesn't

RE: MI-L SQL statements when accessing Oracle Spatial from MI 7.5

2004-01-14 Thread Peter Horsbøll Møller
> I was wandering what MI (7.5) does to Oracle (9.2) when querying a table in the > direct mode. Do you perform this query using the SQL Select or do you send the query to Oracle using the DBMS expert ? If you send the query to Oracle you can use the power of Oracle to get a much better perform

RE: MI-L SQL Query

2004-01-14 Thread Peter Horsbøll Møller
Just a tiny comment: The Count aggregation always take a * as parameter, so you query should be like this: Select WARD_NO, TENURE_TYPE, Count(*) "How_Many" >From MY_TABLE GROUP BY WARD_NO, TENURE_TYPE ORDER BY WARD_NO, TENURE_TYPE Into RESULTS_TABLE Peter Horsbøll Møller GIS Developer Geographi

RE: MI-L SUM - MI 4.5 and XP Pro

2004-01-14 Thread Peter Horsbøll Møller
> and am impressed with all the new features I've been missing all of these years. And who said MapInfo never add usefull things to our favorite GIS ?? ;-) Peter Horsbøll Møller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S Denmark Tel +45 6311 4900 Dir

MI-L SUM - MI 4.5 and XP Pro

2004-01-14 Thread DLPSBR
MI-Listers, A belated Thank you to MapInfo Guru Emeritus, Steve Wallace, Gilbert H., Nick Bean, and Bill Thoen for advice concerning MapInfo 4.5 and Windows XP Pro. MI 4.5 will not work with Windows XP Pro. I have upgraded to MI 7.5 through GISnet.com, and am impressed with all the new features

Re: MI-L SQL Query

2004-01-14 Thread Steve Kalmbach
Yes, the query would go something like this: Select WARD_NO, TENURE_TYPE, Count(TENTURE_TYPE) "How_Many" >From MY_TABLE GROUP BY WARD_NO, TENURE_TYPE ORDER BY WARD_NO, TENURE_TYPE Into RESULTS_TABLE If you are using the SQL select dialog, the first line above is the 'Select Columns', the second

MI-L SQL Query

2004-01-14 Thread Andrew Tracey
Dear All I have a MapInfo table which comprises ward reference no and tenure type. I am trying to produce a query that will list the 20 wards and a count of how many of each tenure type there are in each ward. I want one browser with all results on. Is this possible. Thanks in advance Andrew Tr

RE: MI-L How to customise info tool to show certain fields?

2004-01-14 Thread Landmark Geographic Solutions
HI BELINDA, I don't know how many fields you want to display but I know if you go to the layer control and select the layer your interested in and go to the label button, in the "Label with" pull down you can enter a expression to add several fields together so when you go use your info tool you w

RE: MI-L Rhetorical Question about DPI on a Vector File

2004-01-14 Thread Phillips, Frank
Thanks to Bob, Jacques, and Gilbert. Your technical insight to WMF and EMF files is quite helpful. I hope to be able to return the favor soon. Frank -Original Message- From: Phillips, Frank Sent: Tuesday, January 13, 2004 8:38 AM To: 'MapInfo-L' Subject: MI-L Rhetorical Question about

RE: MI-L Maptech Terrain Navigator pro and Mapinfo

2004-01-14 Thread Woody Woodruff
Did this several years ago, I believe I accepted the defaults and it worked fine, but open the map you want, go to File>Export and set the export parameters you want, choose the projection, no collar/collar (that's the printed stuff around the map), all or a portion of the map, the dpi, etc. There'

RE: MI-L Importing from Excel

2004-01-14 Thread Phillips, Frank
Clayton, when you are opening the Excel file, you should be able to specify a range of data, and then check a box telling it that the first line is your header line. When I import XLS files, I tell it the range starts at "A2" instead of "A1", and then I check the box. This is assuming my first li

MI-L SQL statements when accessing Oracle Spatial from MI 7.5

2004-01-14 Thread Christof Kaiser
Hello, I was wandering what MI (7.5) does to Oracle (9.2) when querying a table in the direct mode. It seemed to be "awfully slow" up to "not working at all" for bigger tables (millions of rows). So we eventually did a database trace on Oracle while connecting to the table. The statements that

MI-L - putting road id for parcels - using MapBasic

2004-01-14 Thread Sayed Hifazat Ali
Dear ALL, I have a many parcel maps for different area of riyadh. All the maps has roadnames in a seperate layer and parcel in a seperate layer. there is data field in parcel table called parcelid which is unique for every parcels and roadid. I want to update these roadid with respect to the ne

MI-L - putting road id for parcels - using MapBasic

2004-01-14 Thread Sayed Hifazat Ali
Dear ALL, I have a may parcel maps. All the maps has roadnames in a seperate layer and parcel in a seperate layer. there is data field in parcel table called parcelid which is unique for every parcels and roadid. I want to update these roadid with respect to the nearest road to that parcel. Al

MI-L Theme Colors

2004-01-14 Thread Sayed Hifazat Ali
Dear All, How can i change the color of themes in mapx code. if category 1 is not empty its should be red and if category 2 is not empty it should be green and if category 3 is not empty then it should be blue. but in my case its fixed .. ie. if value of category 1 is empty then for category 2 i

MI-L Ann: MapInfo User Group meeting in Dublin Ireland on the 28th January 2004

2004-01-14 Thread Martin Hodder
Hi, I wanted to let you know that we are having a meeting at the City Hall in Dublin on the above date. An agenda for the meeting is published on our web site (www.muguki.com) in the news area and then click on Dublin meeting. An update to the agenda is that we will also have a Vertical Mapper i

Re: MI-L SQL Queries

2004-01-14 Thread Norman Mabunda
Hi Richard Easy. I am new as well to MapInfo, but I am getting there. This is what you do: click Query>SQL Select, then on the dialog box Select Colums: * >From Tables: Table Name you want to select from Where Condition: Company Name like "Richard%" Group by olumns: Order by Columns: into t

RE: MI-L How to customise info tool to show certain fields?

2004-01-14 Thread Thomas Brix Lyng
Hi Belinda I think that the easiest way to do that is to make a selection from your base table like this: Select MyWantedColumnA, MyWantedColumnB,,MyWantedColumnG, Obj from MyBaseTable And then put this selection table into the map instead of the original. When you point at the objects

RE: MI-L SQL Queries

2004-01-14 Thread Peter Horsbøll Møller
Try this: Select * From MYTABLE Where MYCOLUMN Like "%Richard%" or Select * From MYTABLE Where InStr(1, MYCOLUMN, "Richard") > 0 Replace: MYTABLE with the name of your table MYCOLUMN with the name of the "Company Name" column I'm not which is fastest, but they should do the same thing. Note that

RE: MI-L Display fill color

2004-01-14 Thread Peter Horsbøll Møller
"Display Global": MapInfo uses the style defined as an override style, which can be controlled in the layer control by doubleclicking a layer, checking the "Style override" checkbox and choose the style in the displayed button(s). This also means that every object has the same style. "Display Gr