Just coming in on the end of this, but...
You would know from previous postings that you can use the Update Column
command to populate the columns tih centroidX and centroidY.
The reason the coordinate values are coming in wrong is that they are in a
different coordinate system to the one you want to use. There are three
different sets of coords in MapInfo - one for the map window, one for your
table, and one that MapBasic uses when processing information - and they
obviously aren't usually all the same.
Firstly you need to make sure that the table is in the corrct coordinate
system (the one you want to use). Do this by viewing the table structure.
If is is not in the coord system that you want then you need to save a copy
of the table (File > Save Copy As..) and change the projection to your
desired one.
When you use the update column command mapinfo uses the MapBasic coord
system to calculate things so you need to tell MapBasic to use the same
coord system as your table.
Open the mapbasic window and type in the following statement:
Set CoordSys Table TableName
Where TableName is the name of the table you created.
Now make the table editable and use the Update Column Command
The columns will be updated using MapBasic's coordinate system (which should
now be the same as your table).
Regards,
Stephen White
Analyst Developer
ERSIS Australia Pty Ltd.
The views expressed in this e-mail are not neccesarily those of ERSIS
Australia Pty Ltd.
-----Original Message-----
From: Natalie Swayze [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 2:09 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: MI-L Creating Points
Sorry to bug you about this AGAIN, but I still haven't managed to work this
out yet.
Essentially, I have the table CommunityAggregates table that has some of the
points created already( all those in which the Centroid"" columns are
populated).
I've made the table temp of all the communities without points( 32 total),
and have started filling the Centroid"" columns of this table using the
coordinates and you're recommended format.
One problem though, is that the two tables obviously don't line up once I
try to update the CommunityAggregates table. As you can see the values for
Centroid"" in Community Aggregate are much bigger and don't really relate to
the Lat/Long data in the same way( eg. the coordinates for Aklavik are 68°
13' 10" N - 135° 00' 20" W, but the Centriod"" columns are -937,758.23 and
8008562.19 respectively)
Help??
>From: "Tim.Nuteson (Exchange)" To: 'Natalie Swayze' Subject: RE: MI-L
>Creating Points Date: Mon, 19 Feb 2001 08:01:01 -0600
>
>Hi Natalie. You'll need to convert your coordinates to decimal degrees
>before entering them into my AddPoint program. Some examples:
>
>26° 00' 00" W = 26.0000 67° 00' 00" N = 67.0000 67° 00' 00" S = -67.0000
>67° 02' 00" N = 67.03333
>
>FYI, the general formula to convert DMS to DD is: Deg + Min/60 + Sec/3600
>
>Tim
>
>
>
>-----Original Message----- From: Natalie Swayze
>[mailto:[EMAIL PROTECTED]] Sent: Sunday, February 18, 2001 12:46
>PM To: [EMAIL PROTECTED] Subject: RE: MI-L Creating Points
>
>
>
>Great! Thanks alot. Just one more question-how should thes coordinates be
>entered into the dialogue box. For example, I'm creating a point for
>Colville Lake: 67° 02' 00" N, 26° 07' 00.
>
>
>
>
>
> >From: "Tim.Nuteson (Exchange)" >To: 'Natalie Swayze' >Subject: RE: MI-L
>Creating Points >Date: Fri, 16 Feb 2001 11:21:42 -0600 > >Try this one
>instead. I removed the limitations, so it should work >internationally. >
> >Tim > > > >-----Original Message----- >From: Natalie Swayze
>[mailto:[EMAIL PROTECTED]] >Sent: Friday, February 16, 2001 11:14
>AM >To: [EMAIL PROTECTED] >Subject: RE: MI-L Creating Points > > >
> >Thanks Tim. I'm working from Winnipeg, Canada( just North of the border).
> >Will this program work from here? > > > > >From: "Tim.Nuteson (Exchange)"
> > >To: 'Natalie Swayze' > >Subject: RE: MI-L Creating Points > >Date: Thu,
>15 Feb 2001 08:18:56 -0600 > > > >Hi Natalie. Attached is a small Mapbasic
>program I wrote some time ago that > > >allows you to add a point by keying
>in lat and lon. The point goes into the > > >currently editable layer
>(therefore you need to set a layer editable >first). > >The program only
>allows entry of coordinates in/near the U.S., but I could > >make a quick
>change if you need to add points elsewhere. Let me know. > > > >Good luck.
> > > > >Tim Nuteson > >Target Corporation > >[EMAIL PROTECTED] > > > >
> > > > > > > > >-----Original Message----- > >From: Natalie Swayze
>[mailto:[EMAIL PROTECTED]] > >Sent: Wednesday, February 14, 2001
>6:11 PM > >To: [EMAIL PROTECTED] > >Subject: MI-L Creating
>Points > > > > > >Hello All, > > > >Is there a way to get MI to create
>points at certain Lat/Long positions??
>
> >
> >_________________________________________________________________________
>
> > >Get Your Private, Free E-mail from MSN Hotmail at
>http://www.hotmail.com.
>
> > > > > > > >
> >_______________________________________________________________________ >
> >List hosting provided by Directions Magazine | www.directionsmag.com | >
> >To unsubscribe, send e-mail to [EMAIL PROTECTED] and >
> >put "unsubscribe MapInfo-L" in the message body. > > > ><< addpoint.MBX
> >> > > _____ > >Get Your Private, Free E-mail from MSN Hotmail at
>http://www.hotmail.com > . > > > > ><< addpoint2.MBX >>
>
>_____
>
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com .
>
>
>
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
