Or you could change the SQL statement to take a unit as well:
Select CartesianArea(Overlap(PolygonTable1.Obj, PolygonTable2.Obj), hectare)
, PolygonTable1.ID, PolygonTable2.ID
From PolygonTable1, PolygonTable2
Where PolygonTable1.Obj Intersects PolygonTable2.Obj
Into a Noselect
This also gives
In the raster registration requester, each reference point can receive a
label (by default it is pt1. pt2,...). In my old 6.5 , the custom labels are
properly saved in the tab file but they are not reloaded in the registration
requester.
Is it the normal behaviour? Has it been changed since 6.5?
Hi All,
I have one X and Y coordinate points (projection MTM NAD83 - Zone 9) in a
database access table. I want to convert that point to MTM NAD27 - Zone 9
projection. Can anyone show me step by step how to convert it using Mapinfo
application. Thank a lot.
It works, but i would like to do that automatically with Mapbasic 5 (i know,
it's an old version !)
The method I use is :
1)Selecting the parent Region
===
Select Obj From mytable Where RowID=id1
2)Setting target
Set Target On
3)Selecting child
One of my clients had a similar situation. The informal answer is this:
The people who own the data really have two concerns.
1. They want to make sure that you are not creating a situation in which
people who would otherwise buy data from them, are getting it from you,
without compensation.
They are many ways to do it. You could use the tools coordinate extractor.
You could also make a copy of you table - create points using the create point
command in NAD83 and save a copy as and specify then to make the copy in NAD 27
BE CAREFUL. Whatever techniques you use, if you are from
Try this in stead:
'
Dim oTarget, oCutter As Object
'**Selecting the parent Region
'** MAKE SURE ONLY ONE RECORD IS SELECTED !!!
Select * From mytable Where RowID=id1 Into __TARGET NoSelect
'**Fetching the target object
Fetch First From __TARGET
The exact thin I want to do is retrieve the moose coordinates when I click
on a map.
The way I use actually is :
Create a ToolButton, calling 'mycallback'
then
Sub mycallback
Dim x,y As Float
x = CommandInfo(CMD_INFO_X)
y = CommandInfo(CMD_INFO_Y)
nb_found =
Dear List,
I am looking for an entrance using following programs.
- MS SQL Server 2000
- Spatialware 4.8
used with Mapinfo and Mapbasic 7.0
1. I am looking for general informations to avoid beginner's mistakes.
2. I would like to implement some triggers (update). What does that mean for
the
Greetings All,
I'm doing a select and Append Rows using the Mapbasic window. I know there
are columns from the source table that don't match the format of the target
table but in this case, it doesn't matter as I'll be updating that field
with my own data.
As there are opposing column formats, I
Hi David,
You should only select the columns that fit the structure in the table you are
inserting into, or you could convert the data to fit the structure
Here is an example:
This is what MapInfo generated for me:
Insert into tobago_county (col1, col2, col3, col4)
Select col1, col2, col3,
Cristophe wrote:
But this method is not very nice, because the user MUST first click on the
ToolButton, each time before clicking on the map.
with a simple trick you need to only push once the button (not all/each the
time) then as far as you want when you click on the map you can get the
I'll second Fletcher's observations. Up-to-date street information makes
sense for certain usages. Keeping data-up-to-date is not trivial. Its one
thing to use Tigre data but totally different to the effort and investment
to insure the streets and addresses are clean and accurate. Make certain the
hi Hendrick
Being a relatively new user myself, there are a few tricks that I learned
on the way over the last month or so
that I meant to write down, but of course haven't, but here goes.
First is to read the manual ( and download the latest one) and follow the
steps on spatialising the
More random thoughts on SQL.
If you are not one yourself, make friends with a good database
administrator. They are worth their weight in gold.
And be careful about restricting access to various tables in the database
- eg. users need to be able to see the base tables - something dbas don't
Does anyone have a .mbx script that acts as a 'cookie cutter' though ALL
layers via a region/polygon (i.e. 'erase outside' through all layers). I
understand this would be easy to write in MapBasic but our version hasnt
arrived yet : ). I have also checked GeoComm and Directions with no
luck.
yeah, good info dudes. cheers.
in short, we're not making a profit, we're providing a service. this is a
govt agency who provides public transport information, so we don't re-sell
anything or make any money from the people who will be using our services.
as far as accuracy required for the
17 matches
Mail list logo
