MI-L Points and Regions

Hello all, I have a list of villages/ towns in Oman which have populations attached to them. I want to be able to spread this poplation across a region. For example. Three dots is a row. Point A = 5 Point B = 7 Point C = 10 I want to now be able to distribute point B pop between A and C area a

RE: MI-L Grid calculation

Hi Sarah, Assuming that your grid table is a polygon table, try the following query: select GridTable.ID, count(*) from GridTable, PointTable where GridTable.obj contains PointTable.obj group by GridTable.ID into Selection Substitute the names of your tables for 'GridTable' and 'PointTable', and

MI-L sporting and town symbol fonts

Hi, I am doing a local map of our village and would like to use some point symbols for a couple of sporting facilities (soccer, surfing, tennis) and for schools, restaurants and shopping centres. I used to have some good fonts from an old corel draw 3 program, but that is long uninstalled

RE: MI-L Rotated Text Objects Print Solid

Harold, This is caused by a setting on your printer. Two things can cause this problem: 1. You are using a Printer font, try changing it to a true type font 2. Try selecting a different Windows Default Printer HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/

RE: MI-L SQL selects

Mike, It think the solution suggested by Terry has a problem. What you actual find with that query is the objects in table2 that are within a distance of 100 meters from the "current active" object in table1. With "current active" I mean the record that MapInfo at the moment has it's cursor poi

MI-L Rotated Text Objects Print Solid

> Hi Listers, > > I have a workspace in which the layout has rotated text objects (as well as > unrotated text objects). When I print the layout, the text objects that are > rotated print as a filled rectangle (black or other assigned color). The > strange thing is that other MI 8.0 users can p

RE: MI-L SQL Server - Spatialware - UDF

Hendrik, 1. There isn't a HG_SpericalBuffer or ST_Buffer UDF. See the following notes. HG_SphericalBuffer generates a buffer region around a geometry in a longitude/latitude coordinate system. Note: This function is available within sp_spatial_query, but not available as a UDF, because SQL Se

MI-L extracting street name

Hello all, Someone told me how to do this once and now I can't find it anywhere. Sorry. I need to pull the street name out of a column that has both the address number and street name. Any suggestions? Thanks Alan

MI-L ObjectNode Function

Hi, I try to retrieve the coordinates of all the nodes of a polygon using the ObjectNode function. I set the coordinates system in Long/Lat NAD83. The function return the correct coordinates but round the result to 4 decimals. I store the coordinates in float variables. How can I

Re: MI-L Major Roads layer for New Zealand

Hi Graham (and other Listers) MapInfo offer a StreetPro Basic version of their New Zealand street product which includes layers such as national highways and main roads along with other supporting layers. Cost for NZ is AUD$3,300 (inc.GST). It can also be purchased as North Island and South I

Re: MI-L How to geocode table with no obvious x/y

Hi Tim Thanks for the reply. I want to make it mappable. This is a table that HAD graphic objects. Trouble is, I needed to update my foxpro master database with it, and update it with its master from the foxpro database. In so doing, I think I overwrote the MI .dbf table with its foxpro .db

RE: MI-L SQL selects

Yep that got it working. Thanks Mike Terry McDonnell <[EMAIL PROTECTED]> wrote: Mike I haven't done this myself yet but does the below work? HTH Terry Select * from Table2 where table2.obj within Buffer( table1.Obj, 1, 100, "m") -Original Message- From: Mike Tonge [mailto:[EMAIL

RE: MI-L MapInfo and SpatialWare Error...

Maybe the string length is too big for MI to cope with? Some errors are "referred" and aren't what the problem actually is. As a test, can you break it down into something shorter? Chop off some decimal points, perhaps - and drop off a couple of points. --- Ian Thomas GeoSciSoft - Perth, Austra

MI-L Map of American Guam

Hello, Could somebody help me to find a map of American Guam. Thanks. Petr Grinshpun Senior Analyst, Legislative Demographic Services, Inc. 3975 Fair Ridge Dr. Fairfax, VA 22033-2924 703.259.5247

MI-L How to geocode table with no obvious x/y

Hi List I'll rephrase a previous post: How do I geocode a table that does not have any obvious numeric x/y co-ord type columns? I have a table that has lost its geographical objects and can't remember how I did it way back. It takes its values (polylines) from another table that itself has

RE: MI-L SQL selects

Mike I haven't done this myself yet but does the below work? HTH Terry Select * from Table2 where table2.obj within Buffer( table1.Obj, 1, 100, "m") -Original Message- From: Mike Tonge [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 14:16 To: Terry McDonnell Subject: MI-L SQL sel

RE: MI-L MapInfo and SpatialWare Error...

Maybe the string length is too big for MI to cope with? Some errors are "referred" and aren't what the problem actually is. As a test, can you break it down into something shorter? Chop off some decimal points, perhaps - and drop off a couple of points. --- Ian Thomas GeoSciSoft - Perth, Austra

MI-L Count number of Overlaps by Polygons into new table

Hi there, I have a TAB file with 150 polygons. I would like to somehow create a separate TAB file of where the overlaps take place along with a count of how many overlaps take place. In some cases only two polygons might overlap while in other cases 10 polygons could overlap. I have used the chec

MI-L SQL selects

Hi List I've got two MapInfo points tables and I wish to select all pairs where an object from one table is within 100m of an object in the other table. Can someone tell me the SQL syntax for doing this? Thanks Mike - How much free photo