MI Using Crystal Peport from MapBasic
Hi, I was wondering if there is anybody out there who has had good result with calling the Crystal Report API functions from within MapBasic. I'm strugling quite a bit with these function and most of my work is doing OK, the only problem I'm still having is that I can't seem to be able of getting the Crystal Report PreView window to appear. Printing the reports directly to the Windows Default Printer works OK. Any ideas or suggestions would be appriciated. I'm aware of the function Open Report in MapBasic 5.5, but this command only works if the application is running on a MapInfo Pro. The MapInfo Runtime doesn't include the Crystal Report! TIA Peter *** * Peter Moller[EMAIL PROTECTED] GIS-Developer Direct: +45 6313 5008 KampsaxVoice: +45 6313 5013 Rugårdsvej 55 Faximile: +45 6313 5090 DK 5000 Odense CWeb: www.mapinfo.dk MapInfo Authorized Partner *** * -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Datums
Hello List, Can any body explain to me what is datum, and where can i change it in MapInfo. As i undestand datum transformatin needed only when i want to jump from one ellipsoid to another. Is it right? I've found some information about datum i need (Pulkovo 1942) in LocalCoordSysDefs.fme file (Bursa transformation as i understood), but shifts there are slightly different from these that i got from another source, i know that datums are being changing with time, but where can i get recent information. I have following problem. I get some data that was made with some datum (is there any need to include one when creating a layer), so after importing it into Mapinfo i have certain coords shift. What can i do? Is there any understandable source of imformation about datums? -- Best regards, Sim D. Biodiversity Conservation Center, Moscow GIS Dept. ++7(095)-124-7934 mailto:[EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Geocoding parameters
Is there any way to "customize" to distance between the created point and the polyline to which it is attached, when performing a geocoding task using a complete address (fromleft, toleft,... and so on) ? In other terms, is there a "hidden parameter" for the MapBasic FIND function ? [EMAIL PROTECTED]
MI MapX geosets collection
Hello all, I'm trying to produce a MapXtreme mapping application that will let users save and restore map information as geosets to a file location. Unfortunately it appears that unless the geoset file is located in the the same directory as the dictionary then a geoset loaded using the GetMapGeoset() function does not appear in the geosets collection,( even though using the SetMapGeoSet ASP function using a file name not to the data dictionary directory does appear to add it to the collection) My question is is there any way to make sure the the current geoset is in the geosets collection (I'm currently using saving the geoset straight after loading to force it through, but I would rather not have to overwrite it unless absolute necessary. (documentation doesn't show a Map.geosets.add method as I would have hoped.) Any help/direction gratefully received. Hamish -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Date: Thu, 17 Feb 2000 14:01:01 -0000
Hi Listers an object geography type question for y'all I have a set of polygons and a set of polylines. The objects in the polyline table fall into two categories. One lot run contiguous to the boundaries of the Polygon coverage (imagine the Polygon covergae after a 'convert to polylines' operation and that is them). The other lot of polylines are not do not run contiguous to the Polygon boundaries and are in fact completely enclosed by those polygons. What I need to do is select all those polylines that are 'within' the polygon boundaries so I can create a new dataset. I have tried various SQL spatial statements but they do not seem to be achieving what I need TIA and will sum Jon Jonathan Stokes GIS Analyst *** Geoplan, 14 - 15 Regent Parade, Harrogate, North Yorkshire, HG1 5AW. tel 00 44 (0) 1423 722715 fax 00 44 (0) 1423 525 545 www.geoplan.com *** -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI ODBC link tables
You need to create a view, similar to a StreetInfo table create view MyView as select * from TableOdbc, TableMap where TableOdbc.UniqueField = TableMap.UniqueField The process is very fast even with large tables. Later, you can even create a .tab file that opens as a regular mapinfo table. At 05:51 a.m. 16/02/2000 PST, you wrote: Hello I'm using the OPEN ODBC TABLES function to link a table from ACCESS. It's working fine. This table is not a mappable table and it's ok. What we want to do is combine it with and existing mappable table in Mapinfo that as a common field with this ACCESS table so that we can create a new unique table. The result we are looking for is that when we ask info on an object in the Mapinfo table, it would give us the info in both table (ACCESS and MAPINFO). To have worked with Arcview, i know that was easy to combine table using a common field. It doesn't seem that easy in mapinfo. Any suggestion out there that doesn't involve to much programming. __ Get Your Private, Free Email at http://www.hotmail.com -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] - Ing. Juan Pufleau Correa Geografía y Electrónica, SA de CV Aguascalientes, Mexico - -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI SUM - Query Contains
Dear all, A quick summary of the responses I recieved for the interested parties is as follows: Basically I have been alerted to the fact that the "Contains" operator is a geographic operator and therefore cannot query text strings...Typical! So heres what I should have done and have since done with complete success... OS_Text Like "%Car Park%". Marvellous! Thanks again all. Dave --- Forwarded message follows --- From: "David Eagle" [EMAIL PROTECTED] Organization: W S Atkins East Anglia To: [EMAIL PROTECTED] Date sent: Fri, 11 Feb 2000 16:49:25 - Subject:MI Query "Contains" Ok, heres a problem which I have come accross before and gave up on...It's cropped up again, and I don't want it to beat me again so here goes... It relates to the query function and is no doubt blindingly simple: I have a browser full of info, Lndl_gaz (OS) to be precise. I want to select all of the items which mention Car Parks. I have tried the obvious: (Table Lndl_gaz) OS_Text Contains "Car Park" I get a data mismatch in expression and a syntax error! It seems that this is a logical way of trying to get a result but despite interrogating numerous help files, I am still failing... If I manage this what would be really useful is working out how to perform the query relating to another table and therefore selecting all the car park entries that fall within a 3 Mile buffer circle that I have setup on another table Any help would ease my frustration. Rgds, Dave _ David A. Eagle (Graduate Analyst). WS Atkins Consultants - East Anglia Wellbrook Court, Girton Road, Cambridge, CB3 0NA. Tel: (01223) 276002, E-Mail: [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] --- End of forwarded message --- _ David A. Eagle (Graduate Analyst). WS Atkins Consultants - East Anglia Wellbrook Court, Girton Road, Cambridge, CB3 0NA. Tel: (01223) 276002, E-Mail: [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Census Data Request
you can buy maptitude for $300 or so, and then they sell block group data for the us (1 CD) for about $300. it reads and writes mid/mif and a bunch of other formats as well. they don't have every data item though, so you should check to see if they have what you need. The block group cd is a great product. we use it to make thematic maps of areas. start to finish it takes me about 5 minute to make a set of four thematic maps of anywhere. good luck bob rogers Does someone know where I may find/buy Florida Census *data* at block group level more easily than the www.census.gov site? I only need a few columns of data (people, households, median income, etc), but it will take forever to acquire it via the on-line queries, the way the Census site is set up. Thanks, -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
SUM: MI Census Data Request
Thanks to all the many people who responded: Commercial offerings, like DataMetrix and Channel Marketing had what I needed and more for $250 (minimum order size), and included forecasted data. Geolytics also has this for sale. Many offered to send me the data for free. Others sent URL's including CIESIN: ftp://ftp.ciesin.org/pub/census/usa/stf/fl http://sedac.ciesin.org/plue/cenguide.html http://plue.sedac.ciesin.org/plue/ddcarto/ Where I finally got the data was the ESRI site: http://www.esri.com/data/online/browse.html Lots of data there, and easy to use. Plus their x-fer speed was primo. Just be careful during the translation from SHP to TAB. They say their files are in NAD83, but the projection was not stored with these files (I opened them in ArcView, and they say "unknown"). The only way to get rid of a 100+ positional error in translation was to use the Universal Translator and pick "long/lat no datum" as the projection. After you convert the files and open them into MapInfo, save them to new filenames with NAD83 projection. Don't get me started on all the problems with the MapInfo "lont/lat" 'projection' -- it is nothing but a headache -- but it did have a use in this instance. Steve Wallace GIS Market Information Manager Florida Farm Bureau Insurance Companies -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Informacion sobre Formato de Archivo
Amigos listeros : les escribo para solicitarles informacion sobre unos archivos *.bin del software PLANET V.2.8 que corre en Solaris, asi como podria leerlos desde un pequeño script para poder extraer informacion de sus puntos(coordenadas longitud,latitud, y altura) Este software es utilizado para planeamiento de radiacion o alcance de señales de radiofrecuencia en empresas de telecomunicaciones. Javier Quispe Varillas Departamento de Investigacion y Desarrollo Corporacion Condor S.A.
MI Date: Thu, 17 Feb 2000 11:15:01 -0500
unsubscribe MAPINFO-L Mathieu Avery Analyste Les Systemes Teldig inc. Tel: (418) 650-5500 Ext: 236 [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
FW: MI MapX geosets collection
Hello All, Further to below, I think maybe I should explain why... I'm trying to embed the full path name of the geoset currently in use within hidden form variables on the page. I'd like to do this by accessing the PathName property of the geoset ie session(SESN_MAPPER).GEOSETS(session(SESN_MAPPER).geoset).PathName But if the geoset is not in the data dictionary directory when loaded it doesn't appear in the geosets collection. May be if somebody could point me to an alternative way of retrieving the geoset path or a reference to the the current geoset object.. (map always starts with a geoset - session(SESN_MAPPER).GEOSET should always have a value) Thanks Hamish -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hamish George Sent: 17 February 2000 12:24 To: [EMAIL PROTECTED] Subject:MI MapX geosets collection Hello all, I'm trying to produce a MapXtreme mapping application that will let users save and restore map information as geosets to a file location. Unfortunately it appears that unless the geoset file is located in the the same directory as the dictionary then a geoset loaded using the GetMapGeoset() function does not appear in the geosets collection,( even though using the SetMapGeoSet ASP function using a file name not to the data dictionary directory does appear to add it to the collection) My question is is there any way to make sure the the current geoset is in the geosets collection (I'm currently using saving the geoset straight after loading to force it through, but I would rather not have to overwrite it unless absolute necessary. (documentation doesn't show a Map.geosets.add method as I would have hoped.) Any help/direction gratefully received. Hamish -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI PS / PDF output
Sorry Rich, I don't have an answer for your problem. What I do have is a request for suggestions for the best method to get from a MapInfo layout to something that can be read by Adobe Acrobat - Distiller. Thanks all. -Original Message- From: Richard Greenwood [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 16, 2000 7:41 PM To: [EMAIL PROTECTED] Subject: MI PS / PDF output I am trying to create high resolution PDF output for a commercial printer. I bought Adobe Acrobat 4.0, and have tried various combination of settings to produce PS or PDF files, but when I get over an 8½x11 paper size and over 2400DPI MapInfo crashes with a Dr. Waton divide by zero error. It seems to have nothing to do with the content of the MapInfo layout window, just the page size and DPI. ANy help or suggestions? I would be forever grateful. Rich Richard W. Greenwood, PLS Greenwood Mapping, Inc. [EMAIL PROTECTED] (307) 733-0203 fax: 733-4018 http://www.GreenwoodMap.com -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Appearance of selected regions
Dear Experts, I have a mappable table with exactly coincident regions, with query select I make selections on the basis of data in various fields. The problem is that where even numbers of coincident regions are selected no selection pattern appears for those regions in the mapper. Is there a way of making MapInfo graphically indicate selections have been effected irrespective of whether there is an even number of them. I am using MapInfo 5.5 and Discover 3.07 Any suggestions gratefully received. Brendan O'Donovan, Exploration Geologist, Tara Mines, Ireland brendan.o'[EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI DATA - US Time Zones in DD NAD83
Does anyone know of a data source for US Time Zones in DD NAD83? Tim Keane GIS Coordinator govWorks, Inc. 81 FRANKLIN ST NEW YORK, NY 10013 phone: 212.941.6900x221 fax: 212.208.4472 mailto:[EMAIL PROTECTED] http://www.govWorks.com -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Designjet 650c printing problem
Hello everyone, I've been having a recurring, but intermittent, problem printing complex plots with my Designjet 650C. I know I don't have enough printer memory for the plot, so I use the "process in computer's memory" selection. The computer(P550) has 128MB of ram. I'm using MI 4.5. Output size of the plots is 36" x 44". No scaling is used. Nothing else is running but MapInfo. The problem is that frequently a (varying) amount of the plot will print, then solid black swaths print. Sometimes rebooting and printing again will allow the entire plot to print, sometimes not. Is this a memory problem (the computer needs more?) or something else? If anyone else has experienced this problem, how did you solve it? Thanks -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Converting .grc files
Listers; Does anyone know of a way to convert .grc files produced by dB Planner into tables that can be opened in MapInfo? Any help would be greatly appreciated. Thanks, Bruce B. Blais Director - Network RF Engineering -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Datums
Old columns of mine (including Uzbekistan) can be downloaded (for free) from the "Grids and Datums" section at: http://www.asprs.org.resources.html Be careful what you say in public (over the internet) about System 42. It is still a State Secret in your country, and the authorities are strict about that topic. Another site that could help you is the U.S. military mapping organization (it is unclassified, and available to anyone over the internet). http://www.NIMA.mil Lots of stuff can be downloaded for free (from that site) in regard to WGS84 Datum relations with other "Local" Datums like System 42. Clifford J. Mugnier ([EMAIL PROTECTED]) The Topographic Engineering Laboratory Department of Civil and Environmental Engineering UNIVERSITY OF NEW ORLEANS New Orleans, Louisiana 70148 Voice and Facsimilie: (504) 280-7095 - On Thursday, 17 February, 2000 3:52 AM, 52 [SMTP:52@mail .ru] wrote: Hello List, Can any body explain to me what is datum, and where can i change it in MapInfo. As i undestand datum transformatin needed only when i want to jump from one ellipsoid to another. Is it right? I've found some information about datum i need (Pulkovo 1942) in LocalCoordSysDefs.fme file (Bursa transformation as i understood), but shifts there are slightly different from these that i got from another source, i know that datums are being changing with time, but where can i get recent information. I have following problem. I get some data that was made with some datum (is there any need to include one when creating a layer), so after importing it into Mapinfo i have certain coords shift. What can i do? Is there any understandable source of imformation about datums? -- Best regards, Sim D. Biodiversity Conservation Center, Moscow GIS Dept. ++7(095)-124-7934 mailto:[EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI DATA - US Time Zones in DD NAD83
Tim, I ran into the same thing yesterday. There are plenty of sources that you can buy the Time Zones from, at prices ranging from $9.95 to $150, but if you're thrifty you can download them from: http://www-atlas.usgs.gov/atlasftp.html It's in Shapefile format, so you'll need to run it through your Universal Translator. Mike Jenne JCSI Trussville, Alabama You'll probably have Tim Keane [EMAIL PROTECTED] wrote: Does anyone know of a data source for US Time Zones in DD NAD83? Tim Keane GIS Coordinator govWorks, Inc. 81 FRANKLIN ST NEW YORK, NY 10013 phone: 212.941.6900x221 fax: 212.208.4472 mailto:[EMAIL PROTECTED] http://www.govWorks.com -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI SUM DATA - US Time Zones in DD NAD83
The follwing urls are all reported to have time zone data I downloaded a pretty good one for free at directionsmag.com http://www.stopwatchmaps.com www.directionsmag.com http://software.geocomm.com/data/intl_timezones.html http://www-atlas.usgs.gov/atlasftp.html Thanks to... Scott Elliot Julie Rediker David Bookless Scott Hall Mike Jenne Tim Keane GIS Coordinator govWorks, Inc. 81 FRANKLIN ST NEW YORK, NY 10013 phone: 212.941.6900x221 fax: 212.208.4472 mailto:[EMAIL PROTECTED] http://www.govWorks.com -Original Message- From: Tim Keane [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 17, 2000 12:30 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: AV DATA - US Time Zones in DD NAD83 Does anyone know of a data source for US Time Zones in DD NAD83? Tim Keane GIS Coordinator govWorks, Inc. 81 FRANKLIN ST NEW YORK, NY 10013 phone: 212.941.6900x221 fax: 212.208.4472 mailto:[EMAIL PROTECTED] http://www.govWorks.com -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI PS / PDF output
I have had good success with using HP printer drivers (running MI 5.0 on NT4 I use HP2500cp driver). The files are saved as postscript and distiller 3.01 reads then no probs. I do admit that we only generate these to enable PDF files to be created for general use not for high end production - although I have supplied printing companies with these files and they are able to produce exceptionally high quality final maps but I am unsure what they do at their end. Cheers Martin -Original Message- From: Thomas Misek [mailto:[EMAIL PROTECTED]] Sent: Friday, 18 February 2000 07:26 To: 'Richard Greenwood'; [EMAIL PROTECTED] Subject: RE: MI PS / PDF output Sorry Rich, I don't have an answer for your problem. What I do have is a request for suggestions for the best method to get from a MapInfo layout to something that can be read by Adobe Acrobat - Distiller. Thanks all. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Converting .grc files
Go to the Vertical Mapper web site and there is a MBX file that will allow reading the raster files by MapInfo. -Original Message- From: Bruce Blais [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 17, 2000 1:23 PM To: Mapinfo List (E-mail) Subject: MI Converting .grc files Listers; Does anyone know of a way to convert .grc files produced by dB Planner into tables that can be opened in MapInfo? Any help would be greatly appreciated. Thanks, Bruce B. Blais Director - Network RF Engineering -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI: *.DAT file in a remote database.
I am unclear on the ability of MI/MapX to store attribute data in a remote database. When you use "File save as" and select a MDB or dbf file, no dat file is created. When you open a DBMS table into MapInfo, MI makes a .dat file. So, can you attach to a table in another database without creating a copy of the attribute data locally, or is that only a "save as" option? Can you ever have the attributes to a polygon layer in, say, SQL Anywhere and have the map objects in MI? -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Lessons learned
From the DUOH!, slap-to-the-forehead department... Yesterday, I re-ordered a table (232 rows, 2 cols - name number) so the records would be in numeric order. Today, I opened a workspace created previously which opens and displays the newly re-ordered table. I had used the workspace to move and/or rotate most of the labels for aesthetic reasons. The labels all appeared in the wrong place. The lesson learned: MI uses the Object number from the table in the workspace. If you re-order the table, all the objects are re-numbered. When you open the workspace, MI uses old Object numbers and applies them to the records as it finds them in the table. Makes for a very interesting, but useless, map. So, today I have spent considerable time cutting pasting the offending Object lines in all the other workspaces that use that table. Isn't technology fun?!? Question: is this still the case with later versions of MI? I still use 4.1.2. Gerald Kornelsen -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Managing file
We are having problems with the management of our data files across the network. Generallywe want toensurethat the author of the layer are the only people who modify it. As it is, we can only rely on people to do the right thing, but unfortunately this does not always occur (especially with new personel). Would anyonelike to share their experiences in the management of their data. Thanks
Re: MI PS / PDF output
Thomas Misek wrote: Sorry Rich, I don't have an answer for your problem. What I do have is a request for suggestions for the best method to get from a MapInfo layout to something that can be read by Adobe Acrobat - Distiller. ?? Print directly to Acrobat Distiller or PDFWriter, it's the obvious solution. There you can set parameters such as paper size, resolution etc. I have become quite attached to the Acrobat that has proven very helpful lately. Here is another workaround: It turned out that OLE linking wrecked transparent region fills when printed from Word. So I had to print to PDF, then read that PDF into Photoshop to produce an image file to paste into Word to get the desired result. Talking of workarounds that makes you run in circles! Can we hope for better output tools in v6, I wonder? And as far as I am concerned, MapInfo could can all those fancy 3D diagrams in favor of better cartographic tools for qualified printing. Mats.E -- ::: :Email/ [EMAIL PROTECTED] ICQ#9517386 : :-: :Mail/ GISKRAFT, Mats Elfstroem, Vaepplingv 21, SE-227 38 LUND, SWEDEN: :Phones: +46 46 145959, +46 70 595 3935 : ::: -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
FW: MI Desagregation Method
Knowing my luck the original email I sent will appear a few seconds after I
send this. However as I haven't (yet) seem this come through I will send it
again.
Cheers/Apologies
Martin
==
Martin Roundill
GIS Manager
Waitakere City Council
Private Bag 93109
Henderson
Waitakere City
New Zealand
-Original Message-
From: Martin Roundill
Sent: Thursday, 17 February 2000 15:13
To: 'Dyan Catamaran'
Cc: [EMAIL PROTECTED]
Subject: RE: MI Desagregation Method
Hi Dyan
I have had a look at this and come up with a solution that does not use
mapbasic it does however use the mapbasic window.
In the process that follows I have assumed that you have a table called
'mytable' with a field called 'MyData' that contains an integer value and
that you want to create objects that represent the overlap of the original
data with an attribute that is the sum of the data field of all polygons
that make up the overlap.
The process is as follows:
1) Create a copy of the table (say 'mydata_original')
2) create a blank mappable table (say 'mydata_final') with a column
(say 'data') to store the results
3) Split the objects based on the overlaps ('mydata')
4) get rid of slivers, save and pack the table
5) make a copy of this table (to say 'mydata_centroid') , convert
the objects to centroids and give them a unique identifier
6) update mydata table with the unique identifier of the
mydata_centroid where object within the shape
7) combine the objects in 'mydata' using the unique identifier
column (from 6) into the table 'mydata_final'
8) update the data column of mydata_final with the sum of the
values contained in the mydata_original table
9) QED
Right here goes in detail then:
(takes a deep breath...)
Steps 1 and 2 should be easy. It may be quicker with step 2 to save a copy
of the original table then delete the objects, save it and pack it.
Step 3
This is the longest process as it is dependent on the number of objects that
are in the database. Lets assume that you have 20 objects.
Type the following into the mapbasic window:
dim i as integer
i = 1
select * from mydata where rowid = i into temp set target on select * from
mydata where object intersects (select object from temp) into temp2 Objects
Split Into Target i = i+ 1
repeat the last statement from "Select * from.. " to "i = i + 1" for the
number of records in the table (a text editor and a bit of copy and past may
help here)
When this is completed you will have a table of the overlaps but this is
likely to contain slivers
step 4) The slivers will arise because the circles get converted to a series
of straight lines that represent the circle and the split function leaves
some small bits behind. You need to get rid of these. I would delete all
objects with an area of 0 and with an area smaller than you acceptable
tolerance. This will require a bit of trial and error but if you use the
command:
select area(obj,"sq m") from mydata where object into toCheck
Browse * from toCheck
you should soon be able to determine an appropriate area as a cut off.
Delete the small areas, save the table and pack it.
Step 5
straight forward use a command like:
update mydata_centroids set object =
createpoint(centroidx(obj),centroidy(obj)), col1 = rowid
The main thing is to end up with a table of point features that have a
unique identifier.
Step 6
Use the update column command to update a field in mydate with the unique
identifier of the point(s) in the mydata_centroids table. The command that
prints in the mapbasic window should look something like this:
Add Column "mydata" (data)From mydata_centroids Set To data Where
within
Step 7
use the table/combine objects using Column.. menu option taking the objects
from my_data grouped by the unique identifier calculated in 6 and store the
data in mydata_final table (the blank table created at the beginning)
Step 8
Use the table/update column command again but this time on the mydata_final
table and calculate the sum of the data column from the mydata_original
table where the original object contains the final object
phew..
All done. Of course it would be easier with mapbasic.
I have included two images of the results (original and final).
I have removed these from the forwarded email as they appear to stop the
email going through the MapInfo List server - if anyone wants to see them
please email me directly
[EMAIL PROTECTED]
I hope this is on track with what you want because my head is beginning to
spin. ;}
Cheers
Martin
-Original Message-
From: Dyan Catamaran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 February 2000 05:49
To: [EMAIL PROTECTED]
Subject: MI Desagregation Method
Hi
Thanks for all of you that answered my simple question on DELETE issue.
Here is another.
This problem is hunting me. I would like to have more
MI Re: [AV] SUM DATA - US Time Zones in DD NAD83
Tim, Looks like you managed to find some good sources of data. I must have missed your original thread as I would have pointed you to a recent feature we did on Time Zones and time zones data sources. Noetheless, you can check it out at http://www.spatialnews.com/features/timezones/ Regards Glenn Tim Keane wrote: ArcView - http://www.quantdec.com The follwing urls are all reported to have time zone data I downloaded a pretty good one for free at directionsmag.com http://www.stopwatchmaps.com www.directionsmag.com http://software.geocomm.com/data/intl_timezones.html http://www-atlas.usgs.gov/atlasftp.html Glenn Letham, Senior Editor The GeoCommunity SpatialNews.com [EMAIL PROTECTED] (850)897-0110 -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI SUM: PS / PDF output
This isn't really much of a summary, but I may be getting a bit closer to solving my problem; it seems to work under Win95, but not under NT. I hesitate say that with any certainty because there are so many variables, but I have tested it on two NT machines and one Win95 machine, using version of MapInfo from 4.1 thru 5.5. When I dial-up the paper size (11" x 17") or the resolution (2400DPI) MapInfo under NT crashes with a "divide by zero" error when I try to output a PDF (via Acrobat Distiller ver 4.0) of to a postscript file using the Adobe postscript driver and a generic PPD file. It does not appear to have anything to do with the content of the layout window (it could be as simple as a few lines, or 600MB of digital images). Could those of you using Acrobat Distiller tell me if you are using NT or 95 so that I might confirm, or disprove, my theory? Rich Richard W. Greenwood, PLS Greenwood Mapping, Inc. [EMAIL PROTECTED] (307) 733-0203 fax: 733-4018 http://www.GreenwoodMap.com -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Website Update: GIS Websites Rated
The RPM Information Network at http://rpmconsulting.com has just updated the GIS Website Ratings for February, 2000. This year, we have added a suite of format tests to help webmasters improve their document, table and form structure and image syntax. This makes pages load more correctly and faster. Virtually every site rated contains some type of error, and some are particularly sloppy. Most often the culprit is image syntax, usually the failure to place WIDTH, HEIGHT and ALT tags. When WIDTH and HEIGHT are not set, pages take longer to load because it takes time for the browser to recognize image layout. The ALT tag is important so that users who don't see the images can still know what they are. This effects not only users with older and non-graphical browsers and those with images turned off, but particularly those who are visually impaired or who are using cutting-edge technology to access the web by phone with a screen reader. Now, on to the fun part. Lycos (a Top 25 site) and MapQuest continue to lead the way. The Power of the Portal is much in evidence here -- while MapQuest has an astounding 159,000+ links in, it is not as popular as Lycos with a fraction as many links in. Lesson being, find a portal and marry it. Among the top 1,000 sites, two amazing map servers -- Microsoft Terraserver and the new National Geographics Map Machine -- are prominent. ESRI and Intergraph are more frequently visited than MapInfo or Bentley among the major GIS companies. The Census Bureau and the USGS continue to be the content kings. The Census site has regained a Top 2,500 position, and the USGS is now approaching 75,000 links in. Elsewhere of note, Directions Magazine has cracked the Top 100,000 sites. And in perhaps the biggest lesson of all, visits to our own site have dropped because we have not taken the time to tell people about it and invite them to visit. So, consider yourself invited to http://rpmconsulting.com where we always look forward to your visits, comments and contributions. -- Steve -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Converting .grc files
Hi all, If you read the question again, you will understand what he is asking! I believe there is a tool built into Vertical Mapper that will convert( or contour) a .grc to a polygon-based Tab file, not a grid file. The mbx you refer to will only allow for viewing the grid, not query or manipulate the underlaying data from the raster. Dion Duran GIS Systems Analyst Metricom, Inc. -Original Message- From: Thomas Misek [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 17, 2000 3:27 PM To: Mapinfo List (E-mail) Subject:RE: MI Converting .grc files Go to the Vertical Mapper web site and there is a MBX file that will allow reading the raster files by MapInfo. -Original Message- From: Bruce Blais [mailto: [EMAIL PROTECTED]] Sent: Thursday, February 17, 2000 1:23 PM To: Mapinfo List (E-mail) Subject: MI Converting .grc files Listers; Does anyone know of a way to convert .grc files produced by dB Planner into tables that can be opened in MapInfo? Any help would be greatly appreciated. Thanks, Bruce B. Blais Director - Network RF Engineering -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Managing file
Subject: RE: MI Managing file -- If your files are stored on a network drive and you run NT you can utilise the NT file security options to allow only certain people access to file. This can include different levels of security i.e.: allowing only certain people editable rights, others only viewable, and disallow others any sort of access. Another option is if you run a customised runtime version of MI you could include password access to certain files and or directories. I have implemented the first option here but we also utilise the second option in a few cases. Get back to me if you want to know more. Good Luck Unfortunately I have no administrator rights. what would be a generic schema in putting something like that so I can approach our IT guys Thanks __ Message sent by MyMail http://www.mymail.com.au/ -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Unable to save table from SQL select
Dear friends, I have created a query: select all from redtable, blue table where redtable . field1 = blue table . field1 which works fine, however I cannot save the query as a table, I get an "unable to save table" message. When I save the query it does not save all fields, as expected it relies on using the fields from the original tables. I'm sure its simple, any advice appreciated. Tia Laith -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI PS / PDF output
I have found that Distiller gives far better resolution than PDFWriter. Jo Ellen Brandmeyer -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
