RE: MI-L auto increment polygons

2005-01-25 Thread Michael Smith
I just wanted to say thanks to the list and especially Paul Smith for
helping me with the code, it does EXACTLY what I wanted it to do.  I really
appreciate all of the help.

Michael




Hi Michael,

I have noticed that in your revised code you have changed order from left to
right, top to bottom. :)

Here is the changes to label each group of 100 blocks 1-100.

This code will only work when the cells specified are in groups of 100
Cells. As it assumes a grid of 10x10.
Anything other then 10x10 you will need add an option to specify the amount
of cells in an individual group.
Eg.  if you enter 88 by 88 cells this code will NOT work..


Currently you are asking user for the total amount of cells x and y.

Would be better to ask user for amount of cells in a group x and y.
And the number of times to duplicate this group x and y.

'//
Include mapbasic.def 

Close All Interactive

Dim iLong, iLat as Float
Dim iCellsRight, iCellsDown, ID, yID as Integer Dim x, y as Integer Dim
temp_obj as object


Dialog
Title Enter Coordinates
Control StaticText Title Enter coordinates for NW Corner as
Decimal: Position 5,5

Control StaticText Title Longitude: Position 5,20
Control EditText Into iLong Position 50,20

Control StaticText Title Latitude: Position 5,35
Control EditText Into iLat Position 50,35

Control StaticText Title # Cells Right: Position 5,50
Control EditText Into iCellsRight Position 50,50 Width 25

Control StaticText Title # Cells Down: Position 5,65
Control EditText Into iCellsDown Position 50,65  Width 25


Control OKButton
Control CancelButton



Create Table grid_temp (RecID Integer) file c:\grid_temp.tab TYPE NATIVE
Charset WindowsLatin1 Create Map For grid_temp CoordSys Earth Projection
1, 62 Browse * From grid_temp Map From grid_temp Set Map Layer 1 Editable On


Set Style Brush MakeBrush(1,RED,-1)
Set Style Pen MakePen(1,4,RED)

ID = 1
yID = 0

For y = 0 to iCellsDown-1
For x = 0 to iCellsRight-1
Create Region Into Variable temp_obj 0

Alter Object temp_obj Node Add ( iLong + 0.0125 * x,
iLat - 0.0125 * y ) 
Alter Object temp_obj Node Add ( iLong + 0.0125 *
(x+1), iLat - 0.0125 * y ) 
Alter Object temp_obj Node Add ( iLong + 0.0125 *
(x+1), iLat - 0.0125 * (y+1) ) 
Alter Object temp_obj Node Add ( iLong + 0.0125 * x,
iLat - 0.0125 *(y+1) ) 

Insert Into Grid_Temp (RecID, Obj) Values
((yID*10)+(ID), Temp_Obj)

ID = ID+1
if ID 10 then
ID = 1
End if
Next
yID = yID+1
if yID 9 then
yID = 0
End If
Next

Commit Table Grid_Temp


'//

regards

Paul



-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED]
Sent: Saturday, 22 January 2005 1:51 AM
To: 'Paul Smith'
Subject: RE: MI-L auto increment polygons


Here is the full corrected code that I have used.


Include mapbasic.def 

Close All Interactive

Dim iLong, iLat as Float
Dim iCellsRight, iCellsDown, ID as Integer Dim x, y as Integer Dim temp_obj
as object


Dialog
Title Enter Coordinates
Control StaticText Title Enter coordinates for NW Corner as
Decimal: Position 5,5

Control StaticText Title Longitude: Position 5,20
Control EditText Into iLong Position 50,20

Control StaticText Title Latitude: Position 5,35
Control EditText Into iLat Position 50,35

Control StaticText Title # Cells Right: Position 5,50
Control EditText Into iCellsRight Position 50,50 Width 25

Control StaticText Title # Cells Down: Position 5,65
Control EditText Into iCellsDown Position 50,65  Width 25


Control OKButton
Control CancelButton



Create Table grid_temp (RecID Integer) file c:\grid_temp.tab TYPE NATIVE
Charset WindowsLatin1 Create Map For grid_temp CoordSys Earth Projection
1, 62 Browse * From grid_temp Map From grid_temp Set Map Layer 1 Editable On


Set Style Brush MakeBrush(1,RED,-1)
Set Style Pen MakePen(1,4,RED)

ID = 1
For y = 0 to iCellsDown -1
For x = 0 to iCellsRight - 1


Create Region Into Variable temp_obj 0

Alter Object temp_obj Node Add ( iLong + 0.0125 * x, iLat - 0.0125 *
y ) 
Alter Object temp_obj Node Add ( iLong + 0.0125 * (x+1), iLat -
0.0125 * y ) 
Alter Object temp_obj Node Add ( iLong + 0.0125 * (x+1), iLat -
0.0125 * (y+1) ) 
Alter Object temp_obj Node Add ( iLong + 0.0125 * x, iLat - 0.0125 *
(y+1) ) 

Insert Into Grid_Temp (RecID, Obj) Values (ID, Temp_Obj)

ID = ID+1

Next
Next

Commit Table Grid_Temp ***888 

-Original Message

MI-L auto increment polygons

2005-01-21 Thread Michael Smith
Thanks to the help of Uffe Kousgaard and Paul Smith I have my mapbasic code
updating (auto numbering) my grids cells from west to east and then down to
the next row to start the process again. 

Currently, I have 14000 grid cells created.  I need to update the attributes
for these in groups of 100 (10 grid cells across numbered 1-10 the next row
will be 11-20 etc. X 10 grid cells down) out of the 14000 total cells.  I
really don't want to manually enter a number in each of these grid cells.

|_|_|_|_|_|_|_|_|_|
|1|2|3|1|2|3|1|2|3|
|4|5|6|4|5|6|4|5|6|
|_|_|_|_|_|_|_|_|_|


Does anyone on the list have any ideas or suggestion on how I could
accomplish this.  I know very little about mapbasic.  Maybe the code I have
below can be modified to do this.  Thank you in advance.

Mike




Hi Michael,

Here is your revised Code. Just swapping the order of (For y = 0 to
iCellsDown - 1) AND (For x = 0 to iCellsRight - 1)

This changes the order the regions are drawn from Vertical to Horizontal
first (Left to Right)

Now simply changing the iLong +   to iLong -  (Changes from left to right
  right to left)

I hope this helps.

Paul

'///

Include mapbasic.def

Dim iCellsRight, iCellsDown, x, y, ID as Integer Dim temp_obj as Object Dim
iLong, iLat as Float

iCellsRight = 10
iCellsDown = 10
iLong = 145
iLat = 10

Create Table grid_temp (RecID Integer) file c:\grid_temp.tab TYPE NATIVE
Charset WindowsLatin1 Create Map For grid_temp CoordSys Earth Projection
1, 62 Browse * From grid_temp Map From grid_temp Set Map Layer 1 Editable On


Set Style Brush MakeBrush(1,RED,-1)
Set Style Pen MakePen(1,4,RED)

For y = 0 to iCellsDown - 1   'Swap these
For x = 0 to iCellsRight - 1  'Swap These

Create Region Into Variable temp_obj 0

Alter Object temp_obj Node Add ( iLong - 0.00125 * x, iLat + 0.00125
* y ) ' Change + to - to
Alter Object temp_obj Node Add ( iLong - 0.00125 * (x+1), iLat +
0.00125 * y ) ' Change + to - to
Alter Object temp_obj Node Add ( iLong - 0.00125 * (x+1), iLat +
0.00125 * (y+1) ) ' Change + to - to
Alter Object temp_obj Node Add ( iLong - 0.00125 * x, iLat + 0.00125
*(y+1) ) ' Change + to - to

Insert Into Grid_Temp (RecID, Obj) Values (ID, Temp_Obj)

ID = ID+1

Next
Next
Commit Table Grid_Temp

'///





-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED]
Sent: Thursday, 20 January 2005 8:25 AM
To: mapinfo-l@lists.directionsmag.com
Subject: RE: MI-L auto increment polygons


 I have this piece of mapbasic code maybe someone can explain.  this code
creates grid cells beginning with the southwest corner of the grid and
autonumbers up and then to the right.  How can I change it so that the row
id numbers autonumber from right to left rather than from bottom to top.

***

Create Table grid_temp (RecID Integer) file c:\grid_temp.tab TYPE NATIVE
Charset WindowsLatin1 Create Map For grid_temp CoordSys Earth Projection
1, 62 Browse * From grid_temp Map From grid_temp Set Map Layer 1 Editable On


Set Style Brush MakeBrush(1,RED,-1)
Set Style Pen MakePen(1,4,RED)


For x = 0 to iCellsRight - 1
For y = 0 to iCellsDown -1

Create Region Into Variable temp_obj 0

Alter Object temp_obj Node Add ( iLong + 0.00125 * x, iLat + 0.00125
* y ) 
Alter Object temp_obj Node Add ( iLong + 0.00125 * (x+1), iLat +
0.00125 * y ) 
Alter Object temp_obj Node Add ( iLong + 0.00125 * (x+1), iLat +
0.00125 * (y+1) ) 
Alter Object temp_obj Node Add ( iLong + 0.00125 * x, iLat + 0.00125
*
(y+1) ) 

Insert Into Grid_Temp (RecID, Obj) Values (ID, Temp_Obj)

ID = ID+1

Next
Next

Commit Table Grid_Temp

*




-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 19, 2005 3:26 PM
To: MapInfo-L@lists.directionsmag.com
Subject: MI-L auto increment polygons

Hi list,

I am trying to create a grid map (polygons) 4000 X 5000.  Grid cell sizes
are 4.5 seconds of latitude and 4.5 seconds of longitude.  Using Mapbasic, I
have created this grid (although I may need to redo it in order to
accomplish my goal).

I have to number these grids cells (polygons) in groups of one hundred - 10
grid cells X 10 grid cells.  In this 4000 X 5000 grid, there will several
groups of these 100 grid cells.  I really don't want to manually enter 1, 2,
3, etc. in each of the grid cells.

On this table I have tried - table -update column and entered value =
rowid.  This works to autonumber all the grid cells, but the problem is
that it does put the autonumbers in the cells that I want them in.  I am
trying to explain the question but may not be making myself clear.  

If anyone has any suggestions or ideas on how to accomplish this, PLEASE
help me!  If I need to give more/better explaination let me know.  Thank you

MI-L auto increment polygons

2005-01-19 Thread Michael Smith
Hi list,

I am trying to create a grid map (polygons) 4000 X 5000.  Grid cell sizes
are 4.5 seconds of latitude and 4.5 seconds of longitude.  Using Mapbasic, I
have created this grid (although I may need to redo it in order to
accomplish my goal).

I have to number these grids cells (polygons) in groups of one hundred - 10
grid cells X 10 grid cells.  In this 4000 X 5000 grid, there will several
groups of these 100 grid cells.  I really don't want to manually enter 1, 2,
3, etc. in each of the grid cells.

On this table I have tried - table -update column and entered value =
rowid.  This works to autonumber all the grid cells, but the problem is
that it does put the autonumbers in the cells that I want them in.  I am
trying to explain the question but may not be making myself clear.  

If anyone has any suggestions or ideas on how to accomplish this, PLEASE
help me!  If I need to give more/better explaination let me know.  Thank you
in advance.

Mike


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 14934



RE: MI-L Looking for Alternative MS SQL Server 2000

2005-01-19 Thread Michael Smith
I have heard that MSDE is somewhat limited on the number of multiple users
or size of db.  I can't quite recall other than Microsoft in the end wants
to get you up and running on Sequel Server - .


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 14940



RE: MI-L auto increment polygons

2005-01-19 Thread Michael Smith
 I have this piece of mapbasic code maybe someone can explain.  this code
creates grid cells beginning with the southwest corner of the grid and
autonumbers up and then to the right.  How can I change it so that the row
id numbers autonumber from right to left rather than from bottom to top.

***

Create Table grid_temp (RecID Integer) file c:\grid_temp.tab TYPE NATIVE
Charset WindowsLatin1
Create Map For grid_temp CoordSys Earth Projection 1, 62 Browse * From
grid_temp Map From grid_temp Set Map Layer 1 Editable On 

Set Style Brush MakeBrush(1,RED,-1)
Set Style Pen MakePen(1,4,RED)


For x = 0 to iCellsRight - 1
For y = 0 to iCellsDown -1

Create Region Into Variable temp_obj 0

Alter Object temp_obj Node Add ( iLong + 0.00125 * x, iLat + 0.00125
* y ) 
Alter Object temp_obj Node Add ( iLong + 0.00125 * (x+1), iLat +
0.00125 * y ) 
Alter Object temp_obj Node Add ( iLong + 0.00125 * (x+1), iLat +
0.00125 * (y+1) ) 
Alter Object temp_obj Node Add ( iLong + 0.00125 * x, iLat + 0.00125
*
(y+1) ) 

Insert Into Grid_Temp (RecID, Obj) Values (ID, Temp_Obj)

ID = ID+1

Next
Next

Commit Table Grid_Temp

*




-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 19, 2005 3:26 PM
To: MapInfo-L@lists.directionsmag.com
Subject: MI-L auto increment polygons

Hi list,

I am trying to create a grid map (polygons) 4000 X 5000.  Grid cell sizes
are 4.5 seconds of latitude and 4.5 seconds of longitude.  Using Mapbasic, I
have created this grid (although I may need to redo it in order to
accomplish my goal).

I have to number these grids cells (polygons) in groups of one hundred - 10
grid cells X 10 grid cells.  In this 4000 X 5000 grid, there will several
groups of these 100 grid cells.  I really don't want to manually enter 1, 2,
3, etc. in each of the grid cells.

On this table I have tried - table -update column and entered value =
rowid.  This works to autonumber all the grid cells, but the problem is
that it does put the autonumbers in the cells that I want them in.  I am
trying to explain the question but may not be making myself clear.  

If anyone has any suggestions or ideas on how to accomplish this, PLEASE
help me!  If I need to give more/better explaination let me know.  Thank you
in advance.

Mike


-
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 14934


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 14943



MI-L creating a grid

2004-10-18 Thread Michael Smith
Hi,

Is there a way to make a custom grid in MapInfo.  What I would like to do is
starting with known x,y coordinates of origin in nad27 lat/long and make
grid cells every 45 seconds latitude and 45 seconds longitude.  I have tried
the mapbasic gridmaker but can't get it to work.  Any suggestions?  Thanks.

Mike


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 13751



MI-L plss grid

2004-10-12 Thread Michael Smith
Hi,

Does anyone know where/how I can obtain a PLSS grid for Texas to use in
mapinfo?  Thanks.

Mike


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 13688



RE: MI-L multiple owners for one parcel

2004-08-17 Thread Michael Smith
 Here is the solution I have so far with help from the list.  I have one map
layer called parcels and 2 db tables.  I have a parcel map layer that
contains a unique field [PIN] for its polygons.  Next, I have a db table
called taxtie with 2 fields in it [TaxID],[PIN].  Now I can join the parcel
map layer to the taxtie table via the common [PIN] field.  Once this join is
made, I then have the [TaxID] that is common to my tax table [TaxID] which
list every person who is taxed and assigns them a taxID number.

This will work but it requires me to run a query on the parcel layer and the
taxtie layer, save that query to a map file, then run a query of the newly
created map file and the tax table and then save that final query as a map.
This process would have to be done everytime I wanted current db info.

I think that there is a better way I just don't know how.  Anyone have any
ideas or suggestions?


-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 11, 2004 8:28 AM
To: [EMAIL PROTECTED]
Subject: MI-L multiple owners for one parcel

Hi List,

I was wondering how if some of you have a resolution to handling multiple
owners for one parcel.  I have a parcel layer with a single db field using
the Tax ID Number from the County Tax Assesor's office that I use to tie to
our county tax database based on these Tax ID Numbers.  The problem I run
into is that if I tie my parcel to a Tax ID number, there can be multiple
accounts associated with a single parcel because of multiple owners of a
single parcel.  As a fix, I have added multiple parcels (to represent each
owner i.e. tax id number) on top of one another and entered in the tax id
number for each one for each of these parcels.

I just was curious as to how any of you may handle this or if it is a
problem that you have encountered.  I am not sure if I have made myself
clear in the question I am asking so feel free to ask for an example.  Any
suggestions are welcome.  Thanks in advance.


-
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12922



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12978



MI-L multiple owners for one parcel

2004-08-11 Thread Michael Smith
Hi List,

I was wondering how if some of you have a resolution to handling multiple
owners for one parcel.  I have a parcel layer with a single db field using
the Tax ID Number from the County Tax Assesor's office that I use to tie to
our county tax database based on these Tax ID Numbers.  The problem I run
into is that if I tie my parcel to a Tax ID number, there can be multiple
accounts associated with a single parcel because of multiple owners of a
single parcel.  As a fix, I have added multiple parcels (to represent each
owner i.e. tax id number) on top of one another and entered in the tax id
number for each one for each of these parcels.

I just was curious as to how any of you may handle this or if it is a
problem that you have encountered.  I am not sure if I have made myself
clear in the question I am asking so feel free to ask for an example.  Any
suggestions are welcome.  Thanks in advance.


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12922



MI-L overlapping polygon maps

2004-06-10 Thread Michael Smith
I have 6 individual map layers of polygons each different but some polygons
overlap.  Each represents certain criteria for carports in our city.  I
would like to show these on a single print out where the overlap areas are
in a darker or heavier shade so that it shows this overlap area darker than
no overlap.  However, I would still like for all areas to be represented on
the print out map.  I would like to try and keep the same color say of grays
with the overlap areas being closer to black.   Any ideas on how I could go
about this?


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12128



MI-L Multiple Views in MapInfo

2004-04-26 Thread Michael Smith
Hi,

In MapInfo 7.5 on Windows 2000, I have my map files on the local drive.  I
have admin privileges on the local pc for editing.  My coworker has read
only permission to view the map files on his machine through our LAN.

Why when he is not editing (has read only permission) only viewing the map
files do I get error messages saying cannot access file map.ID for writing.
Please be sure file is not open in another application.  Once I get these
errors we both have to shut down and restart to correct this.

I know when we were both editing the same map file we had errors but he is
only viewing files and in layer control does not even have the option to
make the files editable.  Is there a workaround for this and what are my
options?

Thanks in advance.

Mike


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11526



MI-L MapInfo Wildcard?

2004-03-25 Thread Michael Smith
Hi,
I am trying to run an sql query of my streets map file to make some changes
to the street names.  What I would like to do is select any street in my
streets table that has a portion of a text string such as find all streets
that contain the letters jo.  The query would then pull johnson st, jones
st, etc.  I can't seem to get this working it is looking for exact matches.

Select:  Roads
Where:  streetname = jo%

This does not work.  Does anyone know the correct wildcard or use of the
wildcard?  Thanks in advance.

Mike


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11098



RE: MI-L MapInfo Wildcard?

2004-03-25 Thread Michael Smith
Thanks guys for your help!  I was close, just needed to change from = jo%
to LIKE jo%

Select:  Roads
Where:  streetname LIKE jo%


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11101



RE: MI-L Convert Polygon Map to Points Map

2004-03-16 Thread Michael Smith
As suggested by several listers, I just needed to set my CoordSys as follows
and it corrected the problem.  Thanks everyone!!

Set CoordSys Table [mapname] enter

Update [mapname] Set obj = CreatePoint (CentroidX(obj), CentroidY(obj))
enter 

-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 15, 2004 4:36 PM
To: [EMAIL PROTECTED]
Subject: MI-L Convert Polygon Map to Points Map

Hi,

I would like to convert a polygon map into a points map.  I have tried this
in mapbasic window:

Update mapname Set obj = CreatePoint (CentroidX(obj), CentroidY(obj))
enter

but does not seem to work correctly on my map.  It does convert all 362
poly's into one single point location on map.  When I click the info tool on
the one point I can see all 362 records in one location.  Does anyone know
what I could be doing wrong?  Maybe there is another method that I can use
to achieve this.  Thanks for any help.

Mike


-
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 10872



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 10895



RE: MI-L Create points save in new table

2004-03-12 Thread Michael Smith
Try this:

Open a  Mapbasic Window and type:


Update mapname Set obj = CreatePoint (CentroidX(obj), CentroidY(obj))
enter

 

-Original Message-
From: Sam Shelley [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 11, 2004 7:01 PM
To: [EMAIL PROTECTED]
Subject: MI-L Create points save in new table

Does anyone know, using MapBasic commands, how to get the centroid of region
objects stored in a table and create a new table of points from those
centroids along with the attribute data of the original table.

 

Basically converting a table of regions to a table of points.

 

Thanks in advance Sam



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 10846



MI-L object not in table

2004-03-10 Thread Michael Smith
Hi,

Can someone tell me how if I have two tables using a query, how do I find
out which records from table A are not in Table B?  Thanks in advance!

Mike


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 10771



RE: MI-L Labeling

2003-11-17 Thread Michael Smith
Thanks Peter it worked.  You guys on this list are awesome!!

I even have the expression set up where I can label all of the roadway
classifications if need be:
Left$(ROADNAME, (Int(CLASSIFICATION = any (mja,”mjc”,”mnc”,”mna”)) *
Len(ROADNAME)))


-Original Message-
From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 12:23 PM
To: 'Michael Smith'; MapInfo-L
Subject: RE: MI-L Labeling


Try this neat little label expression

Left$(CLASSIFICATION, (Int(CLASSIFICATION = mja) * Len(CLASSIFICATION)))

This could also be used to label the roads with the road name if the
classification is mja:
Left$(ROADNAME, (Int(CLASSIFICATION = mja) * Len(ROADNAME)))

The trick is that Int() returns the integer value of the expression in side
the parensis. So here you enter a true/false expression.
If the expression is true the Int() will return 1 else it returns 0. The
value returned is used to decide whether the entire label value should be
returned or no string at all. The Left$() function returns n chars starting
from left.

Only your imagination - and MapInfo max length of label expressions - sets
the limit for whats possible.

Here is a neat example I'm using in a special application:
Left$(MARKNR, Len(MARKNR) * Int(MARKNR  HJÆLPEOBJEKT)) + Chr$(10) +
Left$(MAALEMETODE, Len(MAALEMETODE) * Int(InStr(1, UCase$(MARKNR),
FRADRAG) = 0 and MARKNR  HJÆLPEOBJEKT and InStr(1, UCase$(MARKNR),
**)=0))

Does it make any sence ? ;-)

Peter Horsbøll Møller
GIS Developer
Geographical Information  IT

COWI A/S
Rugårdsvej 55
DK-5000 Odense
Denmark

Tel +45 6313 5013
Direct  +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk


 -Original Message-
 From: Michael Smith [mailto:[EMAIL PROTECTED]
 Sent: Monday, November 17, 2003 7:01 PM
 To: MapInfo-L
 Subject: MI-L Labeling


 Is there a way to label in MapInfo 7.0 using some type of if,
 then (if attribute field equals certain value then label).
 What I need to do seems simple but I just can't seem to figure it out.

 I have a streets centerline file with an attribute field
 classifing the type of roadway each segment is.  In this
 attribute field, I have 4 classifications of data (mja, mna,
 mjc, mnc).  If I want to label only streets with attribute
 data of mja and not label the other streets segments how can
 I do this?

 Thanks in advance.

 Michael Smith, Planner II
 City of San Angelo
 Planning  Development
 325.657.4210 Fax: 325.481.2648
 Email: [EMAIL PROTECTED]



 -
 List hosting provided by Directions Magazine |
 www.directionsmag.com | To unsubscribe, e-mail:
 [EMAIL PROTECTED]
 For additional commands, e-mail:
 [EMAIL PROTECTED]
 Message number: 9174






-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9177



RE: MI-L Decimal Degrees to DMS

2003-09-08 Thread Michael Smith
If you have version 7.0 of MapInfo, click on map options and under display
coordinates select degrees, minutes, seconds.  On the same window under
display in status bar select cursor location.  This will display coordinates
in your map window in degrees minutes seconds.

-Original Message-
From: Chris Gallagher [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 07, 2003 12:19 PM
To: MapInfo List
Subject: MI-L Decimal Degrees to DMS


Hello all,

Is there any way to change the cursor location from DD to DMS?

Thanks tons,

Chris Gallagher, M. Sc.
TRAK Maps - Ontario Manager
1766 Scott St.
Ottawa, Ont
K1Y 2N6
[EMAIL PROTECTED]
866-828-4177



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 8299



MI-L MapInfo Proviewer 7 and the Intranet

2003-08-27 Thread Michael Smith
I am having difficulty getting Proviewer to open a workspace on IIS
5/Windows 2000 Pro.  I have IIS configured to open up pdf files but it can't
seem to find the path or security permissions for the workspace and tab
files.  I want my intranet users to be able to download proviewer and click
on a hyperlink to my mapinfo workspace file.  I have configured the client
pc's to open .wor extensions with proviewer.  All my tab files and
workspaces are in the IIS web directory.  Has anyone done this or have any
advice.  Thanks.

Michael Smith, Planner II
City of San Angelo
Planning  Development
325.657.4210 Fax: 325.481.2648
Email: [EMAIL PROTECTED]



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 8163



MI-L HP Plotters

2003-08-27 Thread Michael Smith
I currently use an HP755cm to plot my mapinfo files.  Looking to get a new
plotter.  I am looking at the HP 1055cm or the hp 5500 42.  Does anyone
have any opinions about either of these or which is better?  Thanks in
advance.

Michael Smith, Planner II
City of San Angelo
Planning  Development
325.657.4210 Fax: 325.481.2648
Email: [EMAIL PROTECTED]



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 8168



MI-L Help with Mapbasic

2003-03-13 Thread Michael Smith
I am a newbie to mapbasic.  Are there any websites that offer free training
or tips on how to get started or that possibly have free code to learn from.
Any help would be appreciated.

Michael Smith, Planner II
City of San Angelo
Planning  Development
915.657.4210 Fax: 915.481.2648
Email: [EMAIL PROTECTED]



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 5937