Hi Richard,
I'm pretty sure this will be down to the order you list the tables in the
"FROM" bit of the SQL statement. I think (though I'm not entirely sure) that
you get the objects from the first table in the list. Possibly.
-
David Booth
Senior GIS
hope this helps
Jon
-Original Message-
From: David Booth [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2001 09:16
To: 'Richard Maaranen'; [EMAIL PROTECTED]
Subject: RE: MI-L SQL select bug?
Hi Richard,
I'm pretty sure this will be down to the order you list the tables in
.e.
>
> select *
> frompoints, polygons
> where points.obj within polygons.obj
> group
> order
> intoselection
>
> hope this helps
>
> Jon
>
> -Original Message-
> From: David Booth [mailto:[EMAIL PROTECTED]]
> Sent: 07 February 2001
Andrew,
I would recommend either building a MapBasic application or just using a
Workspace to perform this task.
You only need to know three MapBasic commands to perform this:
Open Table
Server Refresh
Close Table
This can very easy by put into a workspace. You can use the task manager to
Sorry, for UDFs that seems to be 2 single quotes - see the manual, Chapter 6
(page 31).
Ian Thomas
GeoSciSoft - Perth, Australia
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, 13 January 2005 8:54 PM
To: MapInfo-L@lists.directionsmag.com
Subject: MI-
Philip
If your Shield nodes are identified numbered sequentially, e.g. ShieldNo,
beginning at 1, then you could probably do:
Select * from ShieldLayer where ShieldLayer.ShieldNo MOD 5 = 0
That should get every 5th shield, so every 5 miles.
HTH
Terry McDonnell
-Original Message-
Fro
Hi Roger,
We've run SpatialWare (4.5) on MS/SQL 2000 from both MIPro and MapXtreme 3.0
(MapX 5.0) without too many problems. And we're definitely not using "sa" to
access MS/SQL from MXT either.
It may be a security/privilege problem you're dealing with. If the tables
are owned by "dbo", sa will
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
Hi David,
Sure, it is doable. It's just a question of putting the words in the right
order ;-)
And I also think that you need to use a subselect for this query:
Select * From ONETABLE
Where Not OBJ Within Any (Select Obj From SECONDTABLE)
Note that I have placed the Not in front of the conditio
as far as i'm aware a JOIN requires the same fundamental data type, a WHERE
statement does not, so long as they're processed as the same data type.
confuserating i know, but a JOIN is interpreted slightly differently in SQL,
it is more of a hardcoded response where it can take advantage of existin
Jeff,
The key is the order that you list the tables in the table box of the SQL
select. The first table will hold a bunch of selected records. In your case
make sure you list the points table first, then the data table. The
selected records are the same records that show in the query, but you'l
There is no problem. When you use aggregate function, the result is a table only. If
you use the top fields, you create a subset table.
1) Now you can save your count table and since it has the ID link field it can be
relink again.
2) Another way is to create new fields on you base table
Steve,
Just a stab in the dark, but do you need to add the 'ANY' keyword in the
select statement?...
where anytable.obj within Any
CreateCircle(CentroidX(obj),CentroidY(obj),"50")
Keith
-Original Message-
From: Steve Wallace [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 18:21
Hi Steve,
I've had a similar problem using the createcircle function in the SQL
dialog. It turned out the problem was with the current distance units
setting in the map windowa previous statement of mine had changed the
units to meters from miles.
I believe the mapbasic statement to chang
Sergi
Select blah from blah where blah into selection (or into csrMyQuery)
Select blah from selection (or from csrMyQuery) where ...
Terry
-Original Message-
From: Gamiz Ribelles, Sergi (Regsa) [mailto:[EMAIL PROTECTED]
Sent: 20 July 2004 14:55
To: Mapinfo-list (E-mail)
Subject: MI-L sq
Thanks to Hugh, Peter and Jose for the help, looks like a matter of having
all your ducks in a row :)
-Original Message-
Objects in one table = text objects some line objects
Objects in second table = region/polyg objects
Attempting to select objects in one table that are "Not Within" o
Nicola, I'm new to MapInfo (and especially SQL queries), but I've found a
GREAT product that works very well on this sort of thing. Try this (there
is an eval version):
http://www.datadirections.com.au/DataAssistant.htm
Frank Phillips
Manager of Marketing GIS
Vulcan Materials Company (NYSE:VMC)
B
MapInfo's SQL isn't as robust as we'd like, so I think you'll
have to do this in two passes. First select data1,data2
intersections into a table, then the data1, data3 intersections,
and combine the results.
--
- Bill Thoen
GISnet, 14
Lorne,
1 - If you are sure that the end=start lines exist as lines, then you can
add as an extra condition that objectlen(obj,"m") be > 0 to exclude them
2 - The implementation by MI of the notion of centroid for lines and plines
is different from that for regions. One one hand, centroids of li
Hi Jacqui,
I don't know how you'd join all three tables within a single SQL, but
the following query should help calculating the overlap without doing
the cookie-cutter thing. You'll just have to run it twice - once for
hard veg and once for soft.
set area units "hectare"
select
Hi,
Thought to just comment on the "don't know how you'd join all three =
tables within a single SQL".
Joining 3 tables in a single SQL proves to be powerful, time saving and =
does not clutter your disk with unecessary temporary files. The way to =
do this requires a syntax rule which I will
I believe the problem is with base tables verses a named query. Try this
SQL which operates on the 2 base tables, USA which contains the state
objects and UsCuty_8k for the cities, or use any other city table you want.
Select * from Usa, Uscty_8k where Usa.State = "WY" AND Usa.obj Contains
Uscty_
Thanks to Russell Lawley and Ian Hull who sent help on the sql command. =
I wanted to have a query table which had both seawall type and condition =
summarised by length in metres. The metre column had already been =
updated using the ObjectLen(obj,"m") function.
The solution was as follows:
S
Hi,
Yor are right Jaques. That's a horrible solution
And for the newer versions of MapInfo, I'm not even sure that they will
work. I once used this horrible solution to make a "thick" line. And it
worked in versions before 4.5 (or was 5.0, I'm not quite sure).
But after an upgrade, my lini
Thanks to those who answered my simple query.
Answer is you can't do this directly in the update command. Just
perform the required selection and update from that!, as from Martin
Higham:
Select * from where = num1 and = num2 Update
selection set = num3
-Original Message-
From:
Soren,
I have experienced/discovered this too in the past, and have reported it
to MapInfo, they say it is due to the way that MI handles one to many
relations (sorry cant find the correspondence), but I think its just a
bug in the info tool!! or at least a design feature they need to sort
out.
Hi Søren,
I have experienced this problem too. As mad as I am that this bug has
existed for so long, I have just accepted it and used a work-around.
Save the "new_table", then open it. The correct relationships will be
restored.
Cheers,
Simon
---
Hello Bill,
select COLUMN_NAME, DATA_TYPE from information_schema.columns where
TABLE_NAME = "YourTable"
There are lots of other useful field too. Should work like any other table
queried via ODBC.
Regards,
Warren Vick
Europa Technologies Ltd.
http://www.europa-tech.com
-Original Message-
Seems like you have 90% of it figured out. I'll assume your
table is called MyTable and the field where you are storing
your group sums is MyField [as a Char(4)]. If you take your
last expression (where you get "TFFF" for up to 1,000,
"TTFF" for 1,000 to 5,000, "TTTF" for 5,000 to 10,000, and
"T
Have a look at fuzz demo on mi directions FTP site.
It'll let you 'draw' distance functions (a buffer is a very basic function
of distance) and apply them from a set of objects, and calculate the impact
of the combined functions results on 'target' objects (multiple options for
the 'combine' op
This can be done by writing a sql query:
Select * from filename
where file1.polygon overlaps file2.polygon and file2.polygon overlaps
file3.polygon and file3.polygon overlaps file1.polygon
You can adjust the query above to fit your needs.
--
Erick Posner
--
Free Stuff from Cyberrebate!
http://w
inal Message-
From: R. Prest [mailto:[EMAIL PROTECTED]
Sent: Friday, 30 September 2005 3:11 PM
To: Carolyn Bergin
Subject: RE: MI-L SQL - Or / And
Hi,
Best when you post this type of "thanks" message would be to enclose the
answers you got (synthetised), so we can all share them... ;-)
"DPC"
,
tzero.net> <[EMAIL PROTECTED]>
cc:
09-04-2002 0
> 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
101 - 134 of 134 matches
Mail list logo