Dear All
I have a gazetteer table in MapInfo and I am trying to write a query to extract the
following :
There are two columns which I require data from porptype and propsit. Both columns are
populated with 1 of 5-10 letters. I need to select every different value from proptype
and then count
Dear All
I am trying to select all records within a column that have the tenth character
as either a 2 or a 3. All of the records within the column have 13 numbers. Is
there any easy way to produce a query for the above?
Regards
Andrew Tracey
Information Support Officer
Corporate Information
C
I have a boundary table containing 71 boundaries. I also have a table
containing 71000 points, which have a postcode attached. Is the any way of
writing a SQL query that will give me all post code within a boundary, but will
only return each post code once, and return the post code that has the
I have a table with 270+ polygons in it, all polygons are referenced with a
four figure number then two letters. I want to pick out all polygons that have
the same four-figured number and then combine them, is there a way of
automating this process? I know that you can do a SQL select to pick ou
Dear All
Does anyone know of a way of querying for all non-matched entries between 2
different tables? I have two tables with postcode in and want to find which
don't match.
Thanks
Andrew Tracey
Information Support Officer
Corporate Information
Corporate Development
South Tyneside Council
Westo
Dear All
Can anybody help I am trying to pick out all records within a column that
are more than 40 characters in length. Does anybody have a SQL that will do
this ?
Thanks in advance
Andrew Tracey
Development Services Department
South Tyneside M.B.C.
Town Hall
Westoe Road
South Shields
Tyne &
Dear All
I have a MapInfo table, which consists of 200+ squared regions. I want to query
to find out the bottom left X,Y coordinate and the top Right X,Y coordinate,
plus a centroid and the id number from column A, does anyone know if this is
possible.
Thanks in advance
Andrew Tracey
Informat
Dear All
I have a table containing 6000+ points which has a code of 1-12 associated with
each point, as well as a boundary table, I want to get a count of points within
each boundary dependant on code (1-12). This is easy to do but I would like the
results to be displayed in a table format e.g.
Dear All
I was provided yesterday with the following syntax : -
Select areaname, sum(int(mycode="code1"))"Code1",
sum(int(mycode="code2"))"Code2", ...
>From mybigtab
Group by areaname
This really help with what I was doing but was wondering if there was any way
of putting a wildcard into the myc
I have two tables - 1 consisting of 70 polygons and 1 consisting of 20
polygons. Both tables cover the same area, what I want to do is work out what
area or percentage of each of the polygons that is within another.
Does anyone know the syntax to do this?
Thanks
Andrew Tracey
Information Suppor
From: Andrew Tracey [mailto:[EMAIL PROTECTED]
Sent: 20 October 2004 14:08
To: [EMAIL PROTECTED]
Subject: MI-L SQL Querying
Dear All
I have a gazetteer table in MapInfo and I am trying to write a query to
extract the following :
There are two columns which I require data from porptype and pr
al Message-
From: Andrew Tracey [mailto:[EMAIL PROTECTED]
Sent: 30 November 2004 17:54
To: [EMAIL PROTECTED]
Subject: MI-L SQL Querying
Dear All
I am trying to select all records within a column that have the tenth
character as either a 2 or a 3. All of the records within the column
have 13 n
[mailto:[EMAIL PROTECTED]
Sent: 30 November 2004 17:54
To: [EMAIL PROTECTED]
Subject: MI-L SQL Querying
Dear All
I am trying to select all records within a column that have the tenth
character as either a 2 or a 3. All of the records within the column have 13
numbers. Is there any easy way
Andrew
Select Postcode
from Table 1
where PostCode not in ( select Postcode from Table2)
HTH
Terry McDonnell
-Original Message-
From: Andrew Tracey [mailto:[EMAIL PROTECTED]
Sent: 10 October 2005 15:01
To: Terry McDonnell
Subject: MI-L SQL Querying
Dear All
Does anyone know
TED]
Subject: MI-L SQL Querying
Dear All
Can anybody help I am trying to pick out all records within a column that
are more than 40 characters in length. Does anybody have a SQL that will do
this ?
Thanks in advance
Andrew Tracey
Development Services Department
South Tyneside M.B.C.
Town H
I believe it's len(columnname) > 40
Dan
Andrew Tracey <[EMAIL PROTECTED]> on 07/09/2002 09:10:51
AM
To:[EMAIL PROTECTED]
cc:
Subject:MI-L SQL Querying
Dear All
Can anybody help I am trying to pick out all records within a column that
are more than 40 characters i
Of Andrew
Tracey
Sent: Tuesday, May 02, 2006 4:24 AM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] SQL Querying
Dear All
I have a MapInfo table, which consists of 200+ squared regions. I want
to query to find out the bottom left X,Y coordinate and the top Right
X,Y coordinate, plus a c
Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Andrew
Tracey
Sent: Tuesday, May 02, 2006 2:24 AM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] SQL Querying
Dear All
I have a MapInfo table, which consists of 200+ squared regions. I want to query
to find
Sent: Tuesday, August 15, 2006 11:51 AM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] SQL Querying
Dear All
I have a table containing 6000+ points which has a code of 1-12 associated
with each point, as well as a boundary table, I want to get a count of
points within each boundary dependant on
muligt?
Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Tracey
Sent: Monday, September 18, 2006 5:17 PM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] SQL Querying
I ha
Hi Andrew,
The SQL Select syntax is:
select table1.IDcol , table2.IDcol , areaoverlap(table1.obj,table2.obj)
from table1,table2
where table1.obj intersects table2.obj
Note that the area returned will be in Mapinfo's current area units, so
you might want to set these by running the 'Set Area Un
21 matches
Mail list logo