Re: MI RE: About DiaBuilder
Hello all,I got delayed in setting up DiaBuilder2000 with its own home.www.DiaBuilder2000.com is alive and well...including the download for the demo.DiaBuilder is still in both places and so I'm ITrey Pattillo[EMAIL PROTECTED] [EMAIL PROTECTED]http://www.wap3.com www.diabuilder2000.com - Original Message - From: MAGS (Mapping Global Solutions) To: Bill Thoen Cc: MapInfo-L Sent: Monday, 25 September, 2000 13:32 Subject: MI RE: About DiaBuilder Bill> Try http://wap3.com/DiaBuilder2000/diabuilder2000.htmThis page run, but not when you press Download fully functional Demo item todo the downloadThanks--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 ad or else?
Nothing is really free, so everyone needs to "ante up" here.sponsors, vars, and readers. There are enough business users [MapInfo/MapBasic not general GIS] here, whether large "corporate" or individuals like me, to support this effort. My List History folder contains about 6100 entries since 11/1998 -- minus some ads and rants 6000 / 24 = 250 posts per month If $25 per month [$125 for 5 + 1 free] for this type of ad is going to break me then I'm in the wrong business... SUGGESTIONS: One-liner add to the end of all posts with a link to a page with this months sponsors which gives them more space and options on how their ad would look and work >>>> >>>> PLEASE SUPPORT THIS MONTH'S SPONSORS --- www.someserver.com/sponsors.htm >>>> Two-liner with product/company and link, rotated thru current sponsor list, added to end of post THIS POSTING SUPPORTED BY: DiaBuilder2000 -- Visual MapBasic Development www.wap3.com/diabuilder2000.htm ==== OOPS was that an adMy US$0.02 Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI FYI: Coordinates, Datum and Transformations
Hello, Following the link on Aviation Formulary http://www.best.com/~williams/avform.htm for Javascript calculator with elliptical earth models you end up here http://users.netonecom.net/~rburtch/geodesy/datums.html Strange way to get to all the info. List of links to finding out "how little we know" on coordinates, datum and transformations. WGS84, Australian Surveying and Land Information Group, Finnish National Grid, Glonass SGS85, NGS just to name a few. Trey Pattillo [EMAIL PROTECTED] http://www.wap3.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 MB: How to extend a line using MapBasic
Hello All, In response to Michelle...If all the little quirks don't kick you the math sure will. Here's a great site I found a long while back about "Greate Circle" calcs. It's geared to aviation but the formulas are all there. It can at least make a contribution to the "porcelein reading room". Trey Pattillo [EMAIL PROTECTED] http://www.wap3.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 Opening multiple files
Hello all, To open ALL files in a folder you can use MB and WinAPI. I you goto my website under WinAPI>Files, I have an example of getting all the files in a folder, which you could then open, populate a listbox or whatever. Trey PattilloOperations & GISCoastal Bend 911 Network2910 Leopard StCorpus Christi, TX 78408ph: 1.361.881.9911pg: 1.361.270.3908 [enter ph#]fx: 1.361.883.5749em: [EMAIL PROTECTED]
Re: MI - Phriday Philosophy
I think Bill does a great job and diversity has been a big key to this list's success. Things like viruses and other trash are part of the game and are the user's responsiblity, whether they send/receive on this list. Even finding out that after being with MapInfo since v3.0 came out and the stock has done at least 2 splits, that I remember recently, plus growth I STILL DON'T HAVE ANY STOCK BEFORE THE 8 Sept DEADLINE :=( Any one want to trade DiaBuilder2000 for stock.[kidding] Thanks Bill and keep it up. Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI Ready for release
Hello all, DiaBuilder2000 for MapBasic is now available. *Visually* build you MapBasic dialogs. Multiple selections for snap, align, size, space your controls Set the tab order [how use moves from control-control] without rewriting the dialog Fully WYSIWYGso dialogs can be designed without the need of MapBasic on the machine then copy the project where MB resides to compile and run Go to the website www.wap3.com and it is right in the middle under "Just Added:" to get the Demo/Lite version. Allows up to 4 controls at a time. Full version is unlimited. Full Version is still releasing at $20us... Better Coding to all.... Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
Re: MI Re: calling a WWW page from MapInfo
+/v8APAAh-DOCTYPE HTML PUBLIC +ACI--//W3C//DTD HTML 4.0 Transitional//EN+ACIAPg- +ADw-HTML+AD4APA-HEAD+AD4- +ADw-META content+AD0AIg-text/html+ADs- charset+AD0-utf-7+ACI- http-equiv+AD0-Content-Type+AD4- +ADw-META content+AD0AIg-MSHTML 5.00.3105.105+ACI- name+AD0-GENERATOR+AD4- +ADw-STYLE+AD4APA-/STYLE+AD4- +ADw-/HEAD+AD4- +ADw-BODY bgColor+AD0AIw-ff+AD4- +ADw-DIV+AD4APA-FONT face+AD0-Arial size+AD0-2+AD4-Hello all,+ADw-/FONT+AD4APA-/DIV+AD4- +ADw-DIV+AD4AJg-nbsp+ADsAPA-/DIV+AD4- +ADw-DIV+AD4APA-FONT face+AD0-Arial size+AD0-2+AD4-Anyone wanting better HTML control+ACY-nbsp+ADs-in MapBasic+ACY-nbsp+ADs-can get HTMLview that is a small Delphi application+ADw-/FONT+AD4APA-/DIV+AD4- +ADw-DIV+AD4APA-FONT face+AD0-Arial size+AD0-2+AD4-Allows controlling what the user can and can not do, like removing the address entry and buttons+ADw-/FONT+AD4APA-/DIV+AD4- +ADw-DIV+AD4APA-FONT face+AD0-Arial size+AD0-2+AD4-Since it is an exe it can be launched from any application+ADw-/FONT+AD4APA-/DIV+AD4- +ADw-DIV+AD4AJg-nbsp+ADsAPA-/DIV+AD4- +ADw-DIV+AD4APA-FONT face+AD0-Arial size+AD0-2+AD4-Get it from the Download section of the web site+ADw-/FONT+AD4APA-/DIV+AD4- +ADw-DIV+AD4AJg-nbsp+ADsAPA-/DIV+AD4- +ADw-DIV+AD4-Trey Pattillo+ADw-BR+AD4APA-A href+AD0AIg-mailto:wap3+AEA-wap3.com+ACIAPg-wap3+AEA-wap3.com+ADw-/A+AD4APA-BR+AD4APA-A href+AD0AIg-http://www.wap3.com+ACIAPg-http://www.wap3.com+ADw-/A+AD4APA-BR+AD4APA-/DIV+AD4- +ADw-BLOCKQUOTE style+AD0AIg-BORDER-LEFT: +ACM-00 2px solid+ADs- MARGIN-LEFT: 5px+ADs- MARGIN-RIGHT: 0px+ADs- PADDING-LEFT: 5px+ADs- PADDING-RIGHT: 0px+ACIAPg- +ADw-DIV style+AD0AIg-FONT: 10pt arial+ACIAPg-- Original Message - +ADw-/DIV+AD4- +ADw-DIV style+AD0AIg-BACKGROUND: +ACM-e4e4e4+ADs- FONT: 10pt arial+ADs- font-color: black+ACIAPgA8-B+AD4-From:+ADw-/B+AD4- +ADw-A href+AD0AIg-mailto:d.haycraft+AEA-acslink.aone.net.au+ACI- title+AD0-d.haycraft+AEA-acslink.aone.net.au+AD4-David M Haycraft+ADw-/A+AD4- +ADw-/DIV+AD4- +ADw-DIV style+AD0AIg-FONT: 10pt arial+ACIAPgA8-B+AD4-To:+ADw-/B+AD4- +ADw-A href+AD0AIg-mailto:mapinfo-l+AEA-csn.net+ACI- title+AD0-mapinfo-l+AEA-csn.net+AD4-mapinfo-l+AEA-csn.net+ADw-/A+AD4- +ADw-/DIV+AD4- +ADw-DIV style+AD0AIg-FONT: 10pt arial+ACIAPgA8-B+AD4-Sent:+ADw-/B+AD4- Wednesday, 09 August, 2000 17:24+ADw-/DIV+AD4- +ADw-DIV style+AD0AIg-FONT: 10pt arial+ACIAPgA8-B+AD4-Subject:+ADw-/B+AD4- MI Re: calling a WWW page from MapInfo+ADw-/DIV+AD4- +ADw-DIV+AD4APA-BR+AD4APA-/DIV+AD4-To Mapbasic programmers:+ADw-BR+AD4APA-BR+AD4-In his recent e-mail on the subject +ACI-Re: MI calling a WWW page from MapInfo+ACIAPA-BR+AD4-Mr Dressel kindly provided a neat Mapbasic sub called LaunchURL().+ADw-BR+AD4APA-BR+AD4-With a MapBasic program containing LaunchURL()+ACY-nbsp+ADs- you can now start your+ADw-BR+AD4-desktop browser in a new window and display any WWW document, for example+ADw-BR+AD4APA-A href+AD0AIg-http://www.mapinfo.com+ACIAPg-http://www.mapinfo.com+ADw-/A+AD4-.+ACY-nbsp+ADs- You can also display local HTML documents (like+ADw-BR+AD4AIg-e:+AFw-actaa+AFw-html+AFw-index.htm+ACI- ).+ACY-nbsp+ADs- This second option could be an effective way+ADw-BR+AD4-to provide +ACI-Help+ACI- text for your mapping app.+ADw-BR+AD4APA-BR+AD4-LaunchURL()+ACY-nbsp+ADs- calls the function ShellExecute() to start your default+ADw-BR+AD4-browser.+ACY-nbsp+ADsAJg-nbsp+ADsAJg-nbsp+ADs- Because ShellExecute is not a Mapbasic function but a Windows+ADw-BR+AD4-API function, you will need to pre-declare it.+ADw-BR+AD4APA-BR+AD4-You must include a statement like the following in the declaration section+ADw-BR+AD4-of your Mapbasic program.+ADw-BR+AD4APA-BR+AD4-Declare Function ShellExecute Lib +ACI-shell32.dll+ACI- Alias +ACI-ShellExecuteA+ACIAPA-BR+AD4AJg-nbsp+ADs-(ByVal hwnd As Integer, ByVal lpOperation As String, ByVal lpFile As+ADw-BR+AD4-String,+ADw-BR+AD4AJg-nbsp+ADs- ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd+ADw-BR+AD4-As Integer)+ADw-BR+AD4AJg-nbsp+ADsAJg-nbsp+ADsAJg-nbsp+ADs- As Integer+ADw-BR+AD4APA-BR+AD4-Regards+ADw-BR+AD4APA-BR+AD4-David M Haycraft+ADw-BR+AD4-Information Analysis Associates+ACY-nbsp+ADs- Pty Ltd+ADw-BR+AD4-ABN 47 085 516 105+ADw-BR+AD4-1 Cumming Place, Wanniassa, 2903+ADw-BR+AD4-Aust Capital Territory,+ACY-nbsp+ADs- Australia+ADw-BR+AD4-Phone/Fax:+ACY-nbsp+ADs- 61 +- 2 +- 6231 8104+ADw-BR+AD4-Mobile: 0412 001 134+ADw-BR+AD4-Email:+ACY-nbsp+ADs- +ADw-A href+AD0AIg-mailto:d.haycraft+AEA-acslink.aone.net.au+ACIAPg-d.haycraft+AEA-acslink.aone.net.au+ADw-/A+AD4APA-BR+AD4-Web :+ACY-nbsp+ADs- +ADw-A href+AD0AIg-http://www.acslink.aone.net.au/actaa/iaa.htm+ACIAPg-www.acslink.aone.net.au/actaa/iaa.htm+ADw-/A+AD4APA-BR+AD4-A MapInfo Technology Partner+ADw-BR+AD4APA-BR+AD4APA-BR+AD4---+ADw-BR+AD4-To unsubscribe from this list, send e-mail to +ADw-A href+AD0AIg
VIRUS ALERT--KAK.HTA: Does MI 5.5 work well with Windows 2000?
The post from Walt Kelly Does MI 5.5 work well with Windows 2000? is carring the KAK.HTA virus. Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI Re: Auto printing to Adobe
Hello, A project for *automation* so that you can *post message* to the adobe window and make it do what you want. Take a look at some of the *free* PDF writers a good start is http://www.over.to/freepdf/ I use a free one from a long while back that is just a printer. Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com - Original Message - From: PERRY Chris To: MapInfo-L (E-mail) Sent: Sunday, 06 August, 2000 20:11 Subject: MI: Auto printing to Adobe Hi all,I tried posting this on the Adobe forums, but couldn't get the answer. Ithought someone might have already done this, so not strictly a pure MapInfoquestion, I thought I would try here.I want to write an application to cycle through a number of workspaces andautomatically print each map to a PDF file. I don't mind if the applicationuses Distiller or PDF Writer - the quality is not that much of an issue. Theproblem at present, is that Adobe always wants a file name for each print.Does anyone have a solution?Thanks,Chris PerrySystems Development CoOrdinatorParks VictoriaMelbourne, AustraliaPh: 61 3 9816 6800Fax: 61 3 9816 9876[EMAIL PROTECTED]**This message and any files transmitted with it are intended only for the addressee. This message may contain confidential or privileged information. If you are not the addressee of this message you must not read, copy, distribute this information or take an action in reliance on it.If you have received this message in error you are requested to immediately contact the sender or Parks Victoria at [EMAIL PROTECTED] and delete the original and any copies of this message and any files transmitted with it. The views expressed in this message are those of the individual sender, except where the sender has the authority and specifically states them to be the views of Parks Victoria. Parks Victoria accepts no liability for any damage caused in the transmission, receipt or opening of this message and anyfiles transmitted with it.**--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 MB getting info on default printer
The Windoze API does everything, if you can find it and figure it out It's all based on C++ structures, but can be ported to MB, the most common difference being in numbers C++ LONG MB Integer The following code below will return the default printer. Getting the installed list is called ENUM_PRINTERS and is somewhat more complex and then you have Win9X and NT differences. A work around for enum would be to read the windoze profile using GetSectionValues and then parsing the returned string. Declare Function GetProfileString Lib "kernel32" Alias "GetProfileStringA" ( ByVal lpSectionName As String, ByVal lpKeyName As String, ByVal lpDefault As String, lpReturnedString As String, ByVal nSize As Integer) As Integer ' RETURNS number of characters read DIM sSize AS INTEGERDIM PrnInfo AS STRING x=512 '' initialize size for return stringPrnInfo=string$(sSize," ") '' initialize place for return string x=GetProfileString("windows","device","No Printer Installed",PrnInfo,sSize) print "Name,Spooler,Port"print PrnInfo Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com - Original Message - From: Doug Pease To: '[EMAIL PROTECTED]' Sent: Wednesday, 02 August, 2000 01:57 Subject: MI MB getting info on default printer MB / MI gurus,I am writing a mapbasic application which will need to find out which one ofa number of networked printers is the default on the machine it is being runfrom. Does any one have a function which accesses a Windows library file toget this info, that they might be able to share with me? Any assistance would be much appreciated. Thanks in advance. Doug PeaseGISOLivingstone Shire councilP.O. Box 600YEPPOON 4703Ph 49399957--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 select by color, then change
Hello, For batch operations, if you goto the website, WinAPI section, I have an explaination and example code to get all the files from a directory, just use *.TAB instead of *.*. Trey Pattillo [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: Justusson Christer <[EMAIL PROTECTED]> To: 'Dupler, Phillip' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, 20 July, 2000 01:04 Subject: RE: MI select by color, then change > Hi! > > There is a free mbx called stylist by Dave Smith ([EMAIL PROTECTED]) and > the code is included. You can find it att http://www.directionsmag.com/ I > use either sql-queries or mapbasic window, something like e g > "StyleAttr(ObjectInfo(obj,2),4)=16711680" in the where clause to select all > red, a little thicker, lines. But I can only do it for one file at a time. > Therefore I'm intrested to know how you do it in a batch. > > Hope it is of any help > Regards Christer > > -Original Message- > From: Dupler, Phillip [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 19, 2000 11:38 PM > To: '[EMAIL PROTECTED]' > Subject: MI select by color, then change > > > I need to select all thin yellow lines and change them to a thicker, darker > color. I need to do this for 171 files. I'm the most novice of programmers > so is there any sample MB code someone could share that could help? I have > only MBv4.0. Thanks. > > Phil Dupler > Senior Planner > > -- > 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: virus alert --- MI Antigen found JS/Kak.Worm virus
HELLO ALL.. Was also looking at the archieve... at least part of the virus code appears below the signature Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI MapBasic Visual Dialog Builder -- Just Released
Hello all, I just finished the beta for DiaBuilder for visually building MB Dialogs. The beta/demo is fully functional, with the exception of only accepting one of each control, something of a individual use The full registered version will handle all you need, more of a developers use. Written in Delphi, so no install, registry or other baggage. Will be posting on the web in the next day Send me a mail if you want a copy.. Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
RE: MI GIS and Elections
Hello Tim and all, THE BEST SEARCH ENGINE...www.alltheweb.com Example of Tim's post > I'm looking for resources on the use of GIS in election campaigns, and would> appreciate pointers to favourite websites, etc. Use the advanced search [click link under FAST Search button] DO NOT put any thing in Section 1 *Search For* has the FAST Search button Pick a language In the *Word Filter* first group select from dropdown *Must Include* and enter GIS In the second group *Must Include* and enter election Pick the number of returns per page Click FAST Search Returned 10,056 documents in 0.2121 seconds THAT'S FAST You can click the + and - buttons to add even more choices to the list and also filter by include/exclude domains, such as only finding the word *election* on *dot GOV* sites Trey PattilloOperations & GISCoastal Bend 911 Network2910 Leopard StCorpus Christi, TX 78408ph: 1.361.881.9911pg: 1.361.270.3908 [enter ph#]fx: 1.361.883.5749em: [EMAIL PROTECTED]
MI NEW TOOL -- Thread Safe Timer
Hello all, I completed MI_TIMER for beta testing. Thread safe, written in Delphi. Just copy and run, no registry junk or other baggage. Send the same commands that you use in the MapBasic Window. [no loops, ifthen, etc] Works with custom menus and buttons for complex processing Intervals from 1 second to hours Change the interval and commands *on the fly* Resides as Tray Icon, clicking shows remaining time and manual shut down. Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
RE: MI Problem with data sharing in MapInfo pro 5.5 -- MY FIX
Hello all, I been working with MI since v3, and stopped upgrades at v4.5 for our 911 system. This has always been the *migraine* of the day, but this system [work around] went into place over a year ago and works perfect. By running integration [MB included], only the functionality that the user needs is included, thus having a lower *training curve* with near 100% data integrity. Plenty of Dropdowns/Check boxes/radios minimize user boo-boos, along with full validation before posting the data. Over performance is increases by working the data in DBF format and using native code tools to perform validation and changes that do not disrupt the linking of the data to the graphical objects. Anyone wishing to contact me on setting this up, altering my application, via Delphi Integration [no installation, single exe] or just as a consultant to your project, let me know. Here's some of the scope and core, a little *techy* but that's what work arounds are about. MI DOES NOT SUPPORT *TRUE* NETWORKED FUNCTIONALLITY ! ! EACH USER RUNS A *Local* COPY OF *The Map(s)* You MUST be familiar [proficient] with MapBasic or an Integrated Language, preferrable DELPHI, but c++, vb, etc will do. 1) The local application will run a 1 minute timer [typical max for languages 60,000 milliseconds] Could be less depending on PC, complexity of update [large region with lots of data], and records in file. 2) Upon timer expiration, application will check a folder for any existing files [updates] to process File names are not relevant, just the existance of the file and the system can open it [file writes completed] May be local or on a fileserver with a folder for each user -- something like mailboxes for email systems 3) Updates from the *update folder* will be processed on a local copy of map, then the file is removed from the folder by move [to an archieve folder] or deletion [destructive--no history] 4) Changes made by the user to the local copy will be placed in a file according to item #2 The file name could be simply *update* but in an archieving system this causes problems. Suggest using a *long file name* based on GUID which maintains a history of changes. 5) Each record MUST contain a *Globally Unique IDentifier* [GUID] to avoid duplicate entries at ALL times 6) GUID is based on the format u.d. where u=user id, d=day number since 1/1/1900, t=time expressed as decimal of 24 hours [0.25=6am 0.5=noon 0.75=6pm]. Row numbers are not acceptable as the number of rows in the table can become less, after packing, which then duplicates the id's [row number] by the amount of deleted records. 7) Update file is text based in the following format Status GUID TABLE DATA Terminator Status is ADD, CHANGE, DELETE GUID is from Item #6 TABLE is the table name [or alias name] -- no path or extension DATA is the full *mapbasic command* to perform the update, on per line including graphic [lines, points, etc] and data Terminator is a unique line to indicate the end of the processing for that record, must not be in data section 8) Integrety Checking Retrieve GUID and table, then process SQL [select from table where GUID=guid] test returned table record count, should be 0 or 1, if >1 then show error and abort For DELETE the record(s) deleted For CHANGE if count=0 then ADD is applied otherwise the new data is applied [update] For ADD, if no records found then insert data, otherwise process CHANGE 9) Creation of update files can either be upon completion of user input or as a batch which can be integrated with the timer function, by user activation, or by application termination but must not be duplicated by any of the these processes KNOWN ISSUES It is still possible to have *cyclic exchanges* whereby 2 users change the same record, before appling the other's chagnes, of which each will pass to the other their changes and therefore a full record update is not performed. The occurance of this is extremely low, but none the less still exists. By having good policy and procedures concerning what data being updated by each user this should not happen. Hope this helps.. SEND RESPONSES TO: [footer is official office use] Trey Pattillo [EMAIL PROTECTED] == Trey PattilloOperations & GISCoastal Bend 911 Network2910 Leopard StCorpus Christi, TX 78408ph: 1.361.881.9911pg: 1.361.270.3908 [enter ph#]fx: 1.361.883.5749em: [EMAIL PROTECTED]
Re: MI Combining regions with common attributes
Hello, This can be done in the mapbasic window, although it will be a bit tedious and time consuming MAKE A BACK UP COPY TO WORK WITH 1) do a query and set the following Select Columns: PU_id From Tables: [table name] Group By: PU_id Order By: PU_id [ this is optional ] Into Table: ID_LIST [ us a unique name -- NOT *SELECTION* ] This will give you a list of all of the unique id's open MB Window 2) enter these lines [ use Ctrl+Enter or you will run each line individually, 2nd time DIM runs is will give error] DIM TheID AS STRING '''''''' if ID is number then change STRING to be INTEGER FETCH First FROM ID_List TheID=ID_List.COL1 3) highlight both lines and hit Enter 4) delete both lines 5) Enter the following lines changing the columns and values to what you need SELECT * FROM YourTable WHERE PU_id=TheID INTO Work OBJECTS COMBINE DATA PU_id=PU_id,PU_area=sum(PU_area).the rest of your fields FETCH Next FROM ID_List TheID=ID_List.COL1 Replace .rest of fields. with what to do with each fieldyou MUST do for every field Notice SUM() will sum total the combined *area* for your table, also AVG() will do averages, Nothing just put the first objects value into the data 6) Highlight all the lines and hit Enter 7) Just keep hitting Enter until you get an error [gone past end of ID_List] 8) Delete the lines 9) Enter UNDIM TheID and hit enter.this removes the variable from memory [can now be DIM'ed again] You can save the MB Window to a text file. MI *convienently* forgot to include a *load from text*, so to reuse you will have to open the file in notepad and copy/paste the lines into the mb window You can save the entire set of lines and then just highlight the lines for each of the processes..2-3 / 5-7 / 9 If this is a continuing process, you might consider purchasing MB, or I do custom programming [reasonable charge] and can create a mbx program for you. Trey Pattillo [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: Kim Greenham <[EMAIL PROTECTED]> To: Mapinfo-L <[EMAIL PROTECTED]> Sent: Saturday, 24 June, 2000 22:11 Subject: MI Combining regions with common attributes > Dear listers, > I have a situation where I need to combine different regions which have a > common identifier. For example, I have a Plantation Unit browser listing > PU_id, PU_Area. Some plantation units have the same PU_id (and are spatially > different regions) which I need to combine into one region with the same > PU_id and sum of PU_Area. Of course I can do this manually using the menu > Objects/Combine, but I would like to avoid the tedious process of locating > the duplicate PU_id's then manually selecting and combining each set. > Hopefully some sort of SQL that I can run in the Map Basic window. Any > assistance would be greatly appreciated. > Kim Greenham > Watershed Digital Mapping > [EMAIL PROTECTED] > RMB 1015 Denmark Western Australia 6333 > Ph 61 (08) 9848 2428 Fax 61 (08) 9848 2458 > > > -- > 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 GREP libraries for MapBasic
Hello, I don't know of anyone writing true grep in MB. You might try what I didwww.alltheweb.com and enter GREP got back 150381 documents in 0.0701 seconds..THAT'S F-A-S-T The first one on the list S&R by Funduc www.funduc.com I can tell was written in Delphi Happy Searching [pun]....... Trey Pattillo [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: Scott Fagg <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 20 June, 2000 18:37 Subject: MI GREP libraries for MapBasic > Anyone know where i can get grep libraries for MapBasic? > > > > -- > 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 RE RE RE: MI Info
My $0.02 1/2 US. I VOTE FOR MAINTENANCE UPGRADE... Doing mapping for 9-1-1 I've bitched long and hard about the *marketing* only concerns of the ivory tower. We needed exact [more relatively speaking than it is] about v3.5. I even wrote MB app to convert all polylines to lines, with addressing, and then calculate extending the lines from 0 to 15% to overcome then geocoding problem. Of course, then that layer must the hidden below everything else and use for the searchs while the real layer is only for *visual* purposes. As far a 3-D and HTML, it will be along time before a cell phone use calls 911 from the top of the Ivory Tower and shoots and e-mail to the dispatcher that they need helpand the map can pin point where they are ! ! Have a good weekend all, I have to go fix some uses who say my 911 mapping programming does not work after the trashed the addressed field out...24/7/52 life of 911 Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
RE: Sending MI event Info to VB
Hello, I quit using VB about 2 years ago, v5 and MI v4.5, and use Delphi [pascal] exclusively The power is far beyond VB [especially WinAPI], not to mention 20 times faster, and no baggage to distribute -- just the EXE. This is from my Delphi code but will give you the idea, Quotes around strings are ' [single] in Delphi so sending commands is easier than VB where you have to do the something [multi-quote] trick HELPER CONVERSION NOTES: Lines don't end until ; semi-colon is encountered Equal is := colon and equal Multiple commands for IF-THEN FOR-NEXT DO-LOOP etc are always contained inside begin/end Hope this helps... == USING THE MapInfo SEARCH POINT IN AUTOMATION 1) Create a tool button [invisible in ole anyway] Place this right after starting MI and passing it any global DIM statements MIStr:='Create ButtonPad "Searcher" As ToolButton '+ 'Calling OLE "SrchPnt" '+ 'ID 1900'+ 'Icon '+MI_ICON_ARROW+ 'Cursor '+MI_CURSOR_FINGER_UP+ 'DrawMode '+DM_CUSTOM_POINT; MIMap.DO(MIStr); 2) Create in VB a procedure called "SrchPnt" [I think this is a CLASS defination] This needs to take a "wide string" procedure SrchPnt(Const sPnt: WideString);safecall; 3) The procedure is as follows// get the Lat/Lon where user clicked and number of objects found // ClickX:=MIMap.Eval('format$(CommandInfo('+CMD_INFO_X+'),".")'); ClickY:=MIMap.Eval('format$(CommandInfo('+CMD_INFO_Y+'),".")'); nFound:=MIMap.Eval('SearchPoint('+MapID+','+ClickX+','+ClickY+')');// if nothing found for the MapID and Lat/Lon then show message// otherwise get the information about where the user clicked if nFound='0' then begin showmessage('No Objects Found At '+ClickX+' '+ClickY); end else begin // get table name from MI // sTable:=MIMap.Eval('SearchInfo(1,'+SEARCH_INFO_TABLE+')'); // must be from the Street Layer// if sTable='BaseFile' then begin // get the RowID from MI // SrchRec:=MIMap.Eval('SearchInfo(1,'+SEARCH_INFO_ROW+')'); // have MI select the record to SEL and paste it to WinClipBoard // MIStr:='Select * from '+sTable+' where RowID='+SrchRec+' into Sel '+ 'Fetch First From Sel '+ 'Run Menu Command '+M_EDIT_COPY; MIMap.DO(MIStr); // clear the text edit // Form1.GetClipBoard.Clear; // paste text from clipboard to text edit // Form1.GetClipBoard.PasteFromClipboard; // get the text from the text edit // Trash:=Form1.GetClipBoard.Text; Junk:=''; // clear the clipboard // Form1.GetClipBoard.Clear; // update the info text boxes by parsing out the tab [#9] delimited text // for x := 0 to (Form1.sbDataBase.ComponentCount-1) do begin if x mod 2 = 1 then begin // when no more tabs [#9] just get data [last field] // if pos(#9,Trash)>0 then begin Junk:=copy(Trash,1,Pos(#9,Trash)-1); Trash:=copy(Trash,pos(#9,Trash)+1,length(Trash)); end else begin Junk:=Trash; end; // put text in appropriate edit box // tsEdit(Form1.sbDataBase.Components[x]).text:=Junk; end; end; end; end; Trey PattilloOperations & GISCoastal Bend 911 Network2910 Leopard StCorpus Christi, TX 78408ph: 1.361.881.9911pg: 1.361.270.3908 [enter ph#]fx: 1.361.883.5749em: [EMAIL PROTECTED]
Re: MI Creating a MapInfo Editor in VB
Hello Aine, 1) You need to use GetObject [ole] which will connect to a currently running application - MI CreateObject will create a *new* instance of the app. 2) A little know trick [well over one app is over 10,000 lines of Delphi plus many other apps] TELL MI TO COPY TO THE CLIPBOARD -- MIMap.RunMenuCommand(M_EDIT_COPY) Defined as ID 203 This will *paste* the current record data [tab delimited] and the graphic [object] to the text and graphic areas of the clipboard The use the PasteFromClipBoard procedure of VB [or WinAPI] to put data into a string or edit box You can then parse out each field which is *much* quicker than all the EVAL calls Also you can dynamically create a scroll box with the correct number [field count from MI] edit boxes and labels I haven' t done an VB in about 3 years but it's all there Hope this helps...check the website for a VB example of calling MI plus WinAPI and other goodies Trey Pattillo [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: Aine Deery <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, 22 May, 2000 08:40 Subject: MI Creating a MapInfo Editor in VB > Hi there, > > I am attempting to create an editor in VB to view/edit point data from > MapInfo. I want this editor to be an add-on to my core MapInfo application > as oppose to an integrated mapping solution. Any ideas? I would like to use > VB as I require some dialog controls that are not available in MapBasic. I > have a few questions that I would appreciate help on: > > 1. As part of the editor I wish to display the attribute information of the > currently selected row of the MapInfo .tab file (similar to the info tool) > what is the most efficient way to access this data from VB. As my first > attempt I havethe following (where TSG holds the tablename) This works but I > am wondering is there a better approach than calling Eval for each > individual attribute. > FrmSignEditor.Text1.Text = mi.Eval(TSG + ".SignGroupID") > FrmSignEditor.Text2.Text = mi.Eval(TSG + ".NoOfPosts") > FrmSignEditor.Text3.Text = mi.Eval(TSG + ".PostHeight") > FrmSignEditor.Text4.Text = mi.Eval(TSG + ".PostType") > FrmSignEditor.Text6.Text = mi.Eval(TSG + ".Terrain") > FrmSignEditor.Text7.Text = mi.Eval(TSG + ".Comment") > > 2. Any ideas on where I can locate some good VB/MapInfo Resources. > > I am currently running VB5 and MapInfo Prof.5 and MapBasic5. Any help is > greatly appreciated. > > thank -you, > > Aine Deery > > -- > 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 UnZip Multiple Files in Multiple Folders??
Hello All, In reply to Robert's post about unarchiving multiple files in multiple folders I upload a my *ShareWare* application MultiArc to the download section of the website. Easy to use, supports PK-Zip, GZ, TAR, GZ/TAR, RAR, LHA, CAB [others upon request including SFX - self-executing exe's]. Unarchiving is fully automatic to keep the file size down [can't open and select files]. Archiving allows selecting individual files, groups of files, exclusions [zip up zips without including the original file] and creating a new folder to put the archives in. Network support included. This is newly developed and somewhat beta...do look at the _readme.txt file ! download www.wap3.com/download.htm Trey Pattillo [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: Robert Karr <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, 12 May, 2000 14:56 Subject: MI UnZip Multiple Files in Multiple Folders?? > Greetings All: I have thousands of compressed files (ZIP and LHA) that live in a directory structure that has hundreds of folders with many subfolders. > > I want to selectively start in just one folder anywhere in the system, then uncompress all files in that folder and all of its' subfolders to the end of the folder system emanating from the original, starting folder. The option to have it automatically delete the compress file might be useful, too. > > Anyone know of software that will do that??? > > Robert Karr Phone: 517-373-3028 > Science Research AssistantFAX: 517-373-0171 > Science and Technology Division > Legislative Service Bureau > Michigan State Legislature > 124 West Allegan Street, 4th Floor > pob 30036 > Lansing, MI 48909-7536 > USA > > -- > 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 Accurate distances around the world
Hello, Everyone should bookmark this, or atleast download it. The best piece of work I have found is the *Aviation Fomulary* by Ed Williams www.best.com/~williams/index.html In the first part click the link for *Aviation Formulary* in html or the link to download the text version. If Mr.Casio [calculator] gives you trouble this may be a bit deep, but he does cover Pathagum's theory, and even has examples of how far you would miss Los Angles when leaving New York by several of the different formulas [Rhumb Line, Great Circleetc]. There is even conversion factors for Ellipsoids: Name Major axis, a (km)Flattening (f) WGS84 6378.137001/298.257223563 GRS80/NAD836378.137001/298.257222101 WGS66 6378.1451/298.25 GRS67/IAU686378.16000 1/298.2472 WGS72 6378.1351/298.26 Krasovsky 6378.2451/298.3 Clarke66/NAD27 6378.2064 1/294.9786982138 Trey Pattillo [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: Bob Young - www.bydesignwales.demon.co.uk <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, 11 May, 2000 06:23 Subject: MI Accurate distances around the world > Dear List > > This is a general GIS question rather than MI specific. > > Does anybody know where I can find a formula for measuring the distance > from one long, lat to another long, lat anywhere in the world? > > I am not worried about the complexity of the formula. I am more > concerned about the accuracy of the answers obtainable from the formula. > > ALSO:- > > Does anybody have any experiences ( good or bad ) on the accuracy of the > answers from MapInfo Professional on distance measurement? Does anybody > know the method employed within MI Pro? > > Thanks, > > > Bob Young > www.mapsbydesign.co.uk > > > > -- > Bob Young - www.bydesignwales.demon.co.uk > -- > 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 zip
Hello, PLEASE SEND ALL BET PROCEEDS TO ME. Take a zip polygon table and index the zip-code field. Use Query>Find [Ctrl+F] select the zip-code field and magic the centroid of the zip. You can also do this on point tables. If you are working in MapBasic, you will not get a 1 or 2 for the return code but 411 [I think--I'll have to dig the 10k lines of Delphi code, it is positive and greater than 2 which puts a twist on the code -- negative is failed ] *Find Using* and *Find* then getting L/L and center/zoom map does work for *non-address* fields. Trey Pattillo - 7 years MI-MB development and integration [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: James Marlow <[EMAIL PROTECTED]> To: 'Dyan Catamaran' <[EMAIL PROTECTED]>; Mapinfo-L (E-mail) <[EMAIL PROTECTED]> Sent: Tuesday, 09 May, 2000 18:39 Subject: RE: MI zip > Hi Dyan > > I hope you have money riding on this one! There is no function built into > Mapinfo that will look for a specific zip code. If you have a zip code table > open you can query it and then, in a mapper window, select Query | Find > Selection to center the map on the zip code that was found (provide one > _was_ found). You could certainly write such a functon using Mapbasic, but > there is nothing "built in" that works like this specificially for zip > codes. > > Regards, > > James > > James L Marlow > Director, Geographic Information Systems > Channel Marketing Corporation > 15032 Beltway Drive > Addison, Texas 75001 > > Telephone 1 (972) 858-9600 extension 331 > Facsimile 1 (972) 858-9601 > email: [EMAIL PROTECTED] > www: http://cmcus.com > > > -Original Message- > > From: Dyan Catamaran [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 09, 2000 5:47 PM > > To: [EMAIL PROTECTED] > > Subject: MI zip > > > > > > This must be a simple question. > > > > Is there any automatic function in MI that shows where a ZIP > > code is located? Meaning that given a particular ZIP (US) > > code - enter- "abracadabra" - here it is located. > > > > I understand about the geocoding procedure but I have someone > > here saying that this feature is for sure automatic for MI. > > I don't buy it) > > > > Any help? > > > > Thanks > > > > Dyan C. Catamaran > > Phero Tech Inc. > > -- > > 604-940-9944 > > 604-940-9433 > > > > -- > > 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: Any one using MII 6.0 again,again,again............
Hello all, Just my $0.02US, We, Coastal Bend 9-1-1 Network, started with MI3.0 at the beginning, on my recommendation. Well, I'm waiting for my Delphi5 VCL development license for CartoMap to get here to finally put together a package that won't need DLL's, MBX's, RunTime, or anything else, not to mention 40% fast screen redraw of 22,000 line segment [county] with the 6800 structures [file totals 18+meg] and *double-precision* coordinates [ that's -97.1234567890123] in real time. We have some 40 license of MI. We only upgraded everone to 4.0 and then only 6 people to 4.5. Why 40*$500 [used to be $800] = $20,000 v3.0>4.0 $20,000 v4.0>4.5 $20,000 v4.5>5.0 $20,000 v5.0>5.5 $20,000 v5.5>6.0 Wish our government would be be a percent bonus on yearly saving of $40,000 2 upgrades @ months == full copy yearly..not exactly rocket science and I just finished the two-es last month. OK, v6.0 now has controlable geocoding [pullback/offset].waiting all along for that v5.x introduced have dms display but it sounds like that is another piece of vaporware crippled upgrade v4.0 BROKE THE PRINTING --- with the micro-display I could repostion labels on a full display of a county ...we still have 3.0 around to do labeling and printing HTML, WWW It wouldn't be long before a someone goofball sends a WIndoze email and takes down our entire 911 system because it Web-Centric [buzz word of vaporware] - AIN'T GONNA HAPPEN... Any lawyers [choke] out there want to investigate the *lemon law* on software.. ...'NUFF SAID -- gotta drive 90 miles to train one of our users, again... Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI Fix_WOR ----- SoftWare Glitch -------- FIXED
APOLOGIES TO ALLespecially if you used Fix_WOR without backing up [ I warned you ] There was a problem with the RichEdit control .. it saved the file with *formatting codes* I use the Windoze RichEdit because a memo has a limit on the number of character [32k] where the RE is what is used internally by M$. A note on the RE control you can use Ctrl+X +C +V to do cut/copy/paste also Shft+Insert to paste, anything else like Alt+E Paste are menu command that I'd have to write in... I have uploaded the revision [220k in pkzip ] to the website -- click here to get it -- www.wap3.com/download/Fix_WOR.zip Added a button to *LOAD* files -- you can now preview the files then use DO ALL or process each individually Added Extension to filter on --- default is WOR --> can now be used on TAB or any other *text* file == CORRECT -- If you do not have backup 1) get new version 2) do the same search for files -- start folder and extension 3) click on each file in the list to view it 4) the first 3 lines look like below delete everything up to !Workspace is should start the line {\rtf1\ansi\deff0\deftab720{\fonttbl{\f0\fswiss MS Sans Serif;}{\f1\froman\fcharset2 Symbol;}{\f2\fswiss\fcharset1 MS Sans Serif;}{\f3\fswiss\fcharset1 MS Sans Serif;}}{\colortbl\red0\green0\blue0;}\deflang1033\pard\plain\f3\fs16 !Workspace 5) set the search for "\par " with out quotes and include a space at the end 6) click the individual search/replace [binoculars] 7) goto the end of the text 8) delete the } squirley brace at the end SORRY FOR ANY INCONVIENCE.. IF YOU HAVE NOT TRIED THIS IT IS WORTH THE DOWNLOAD....Trey Pattillo Trey Pattillo -- 7yr MapInfo Developer[EMAIL PROTECTED]http://www.wap3.com
RE: MI Workspace Editor ------ AND RANT-----
Hello y'all, In response to Natalie's post about a workspace editor, I just put Fix_WOR up on the download section. AUTOMATION - YES ! [ Several additions lately --- so drop by ] A Delphi5 application, so just unzip [pkzip] somewhere and 2click it -- make a shortcut if you want -- no install baggage or registry poop. The status bar has mouse-over help hints, but basically1) enter the start folder, NO END \ , or click on the button on the right for dialog box2) enter the string to search for, this is not case sensitive or whole words, so it will dig up any and all occurrances3) enter the text to replace with4) uncheck *sub-folders* if you don't want to use them5) click start6) the *checked* list entries show files that were changed7) click on a list entry to view it8) you can directly make changes to the viewer and then click on the save button9) you can change the search/replace and click on the find button [binoculars] to apply it to the view window and then save10) creates an optional backup of the changed files [initial run only then unchecks] Great for moving around wors from one machine to another or creating CD projects. Sometimes the rant fire is a little warm but it's better than the crap on the boob-tube, and gets up to the Sunday Comics at times. For those of you who are whining about the *mails* then do what I have to at the office --- read the archive and respond to what you want..when I get home --- 65 mails from list, plus the spam is up again, plus tech-news --- plus replies--- there goes 2hrs. :-) ENOUGH SAID ...GET A CLUE ! ! ==== Trey Pattillo -- 7 years of MapInfo Development, 20 years programming[EMAIL PROTECTED]http://www.wap3.com
RE: HTML in MI > HTML View
Hello all, I have reworked my website and think there might be problems with the *Outlook* menu bar in left frame using Netscrap, if so please drop me a mail. After I read Mats post I saw that I also had reference using *run application* WRONG HTML View read me has been updated to add the following example DIM sHtml AS String sHtml="c:\htmlview.exe /f="+chr$(34)+"c:\webdoc.htm"+chr$(34)+" /navshow" RUN PROGRAM sHtml UNDIM sHtml Also added Move Map [mbx] allows moving a map that does not align with other maps and Move Raster which re-registers the raster appling the needed offset, great if you don't want to hassle with re-registering or monkeying with projections to use just as a reference. Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI RE: MapInfo Newsgroup
Hi all, My $0.02us...TOO MUCH TRASH THERE ! ! ! Want to crash you drive the just click on "want see my %^*&$#" [body parts] or who knows what else Newsgroups are some of the most notorious propogators of viruses, etc.. Although I run the best virus checker on *auto* --- InoculateIT from Computer Associates www.cai.com [and it's free] I don't need the worry of what's on the list.. At least with *the L* there is something of a buffer Question for Bill Thoen, What happened to the *thread levels* format that used to be on the list? MI: Question RE: Question.. RE to RE Was it just a real pain to manange or a majordodo problem? Could that be what someone is missing compared to a news reader? It was really handy instead of reading through everything that comes in. Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI Help with Universal Translator
Hi all, Usually I give out the maps not get them. I just got a file from our wonderfully archaic Tex. Dept of Trans. in Microstation 5.0 DGN format UT will open and process it I know the problem it is the Projections but what is the setting or the postprocess AFFINE that I need The file came with the top of the county at 34d and the west at -100d Well, I tried a couple of variations that ended up actually as a speck of dust on the monitor Should be about S 27.8 N 28.0 W 97.9 E 97.0 [a rough/estimated MBR of the county] I don't find Labert/Clarke/1927 in the projections Here is what the *hand typed* metadata sheet reads: Projection: Labert Conformal Conic Ellipsoid: Clarke 1866 Datum: North American 1927 Longitude of Origin: 100 degrees west(-100) Latitude of Origin: 31 degrees 10 minutes north Standard Parallel #1: 27 degrees 25 minutes north latitude Standard Parallel #2: 34 degrees 66 minutes north latitude False Easting: 3,000,000 feet False Northing: 3,000,000 feet Unit of Measure: Feet (International) If you email me between 8-5cst please send a copy to the office at: [EMAIL PROTECTED] attn: Trey Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI Help with Universal Translator
Hi all, Usually I give out the maps not get them. I just got a file from our wonderfully archaic Tex. Dept of Trans. in Microstation 5.0 DGN format UT will open and process it I know the problem it is the Projections but what is the setting or the postprocess AFFINE that I need The file came with the top of the county at 34d and the west at -100d Well, I tried a couple of variations that ended up actually as a speck of dust on the monitor Should be about S 27.8 N 28.0 W 97.9 E 97.0 [a rough/estimated MBR of the county] I don't find Labert/Clarke/1927 in the projections Here is what the *hand typed* metadata sheet reads: Projection: Labert Conformal Conic Ellipsoid: Clarke 1866 Datum: North American 1927 Longitude of Origin: 100 degrees west(-100) Latitude of Origin: 31 degrees 10 minutes north Standard Parallel #1: 27 degrees 25 minutes north latitude Standard Parallel #2: 34 degrees 66 minutes north latitude False Easting: 3,000,000 feet False Northing: 3,000,000 feet Unit of Measure: Feet (International) If you email me between 8-5cst please send a copy to the office at: [EMAIL PROTECTED] attn: Trey Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI TEST
JUST A TEST I didn't receive any mail today from list or others Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI HTML inside Maps --- JUST SOLVED
Hello all,In response to Colin's question "will MapInfo do HTML".. I just put HtmlView on the website www.wap3.com/download/HtmlView.zip Use Launch.App www.wap3.com/download/Launch.zip or on of the other fine launchers available in the list download to let you user click on the map and then "take them to the web" or use it in your "help" menu to take them directly to your site. Will also work with any other application that can launch a program. HtmlView is just a simple browser instead of the usual *pig-ware*Since it is written in Delphi, just put the files in a folder and your ready to go. Give your user only the functionality you want Features:1) Work with local files or get page from the web2) You can hide/show the basic NavBar [back,forward,refresh,stop and url entry]3) Stop user from jumping to links [java & scripts will still work - on the wish list]4) Keep user from closing window/app [then close it yourself with /QUIT parameter]5) Hide Min/Max window buttons and menu6) Set initial top/left/width/height default is 1/4 of screen centered [works with any resolution]7) Use your own title in the window caption8) Set window for *Stay On Top* [like Windoze Task Mgr or some find/search boxes]9) Reset default parameters10) Gets new pages into the same window - won't muck up the users screen11) Small compact and clean code 168kExample for MapBasicTo The Web:Run Application "c:\HtmlView\HtmlView.exe /F=www.wap3.com"Local:Run Application "c:\HtmlView\HtmlView.exe /F=c:\webpages\index.html /topon /linkoff /x=0 /y=0 /w=320 h=240 /closeoff" Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
Re: MI SQL Select
Martin Sprenz asked: > I'm looking for a Query that would select all the polygons that border a > selected or given polygon. Is there a function that could achieve this result? The answer you need is select * from My_Table where obj intersects (select obj from selection) The operator for geographic selection [from MapBasic help] are defined as follows objectA Contains objectB first object contains the centroid of second object objectA Contains Part objectB first object contains part of second object objectA Contains Entire objectB first object contains all of second object objectA Within objectB first object's centroid is within the second object objectA Partly Within objectB part of the first object is within the second object objectA Entirely Within objectB the first object is entirely inside the second object objectA Intersects objectB the two objects intersect at some point [my defination is "touch" at some point" Trey Pattillo [EMAIL PROTECTED] http://www.wa3.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 Viewing a Map without MapInfo on a machine
Hello, Just a note about: > 2. Looked at a few viewers to download from the web, including ones from > the Spatial News list of viewers. I looked at the Proviewer and it has to > many options and allows users to change data in tables. Have you installed ProViewer on "clean" machine? I found that it's behavior is dependent on whether or not MapInfo is installed on the machine ( editing data ) On a clean machine, pan/zoom is about it. Yes other "windows" can be opened and closed [map and browser independently] but it doesn't even have "layers" a layers control, something I want my users to have. My real problem is that " I " have to build the Workspaces and distribute them to the users, scattered across 12,000 sq.mi of south Texas. To the rescue, I developed ProDesigner that without [at this point] any graphical interface [working on a 3rd party map interface] allows more advanced users to create their own workspaces [data mining]. Just about everything is there except for "thematics" --- they're a real pain in integrated apps. This is Delphi EXE and INI only so distribution is just a copy away. Trey Pattillo [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: Christy Noonan <[EMAIL PROTECTED]> To: MapInfo-L (E-mail) <[EMAIL PROTECTED]> Sent: Monday, 31 January, 2000 17:16 Subject: MI Viewing a Map without MapInfo on a machine > Hi Listers, > The main problem, allowing another person in the company to view my maps. > Finding something simple enough for them to use and not giving them the > ability to change the data. I would like to be able to display a map, zoom > in/out and pan. It must be simple to use. > > These are some of the things I have tried. > 1. Imbedding the map in Excel, it locks up some machines and many in my > company don't even have excel. > 2. Looked at a few viewers to download from the web, including ones from > the Spatial News list of viewers. I looked at the Proviewer and it has to > many options and allows users to change data in tables. > > Questions? > 1. How do you imbed a map into Word, or do you save it as a *mif file, > and then how do you import it? > 2. Is there a utility to save a workspace as a bitmap? > 3. Is there a utility to save a workspace as a *pdf (Acrobat file)? > 4. Am I just missing something, is there a utility already out there to > let someone just view, zoom and pan a map? > > Any advice would be appreciated. > Thanks, Cn > > Christy Noonan > ERAC > [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 Id question thanks
Hi all, Just a note to Fran's using the RowID as an "identifier" >Thanks to all who responded to my MI ID question. The solution of creating >an ID column and updating column with ROWID was perfect. Got that project >done in short order! I really appreciate the help. DON'T EVER PACK THE TABLE.ESPECIALLY IF YOU HAVE DELETES. 1) initially 100 records 2) id's = 1...100 3) delete every 10th record 1..9, 11..19, 20..29 4) pack the table 5) now there are 90 records 6) add 10 records and use RowID ..you just duplicted 90...99 I have use a GUID [Globally Unique IDentifier] in my "multi-user/multi-location" 911 system something like "User ID" [5 char] the date, the time to 12 digits I get the actual clock date/time as a floating point number but the "TIMER" function will work [ticks since midnight] So, you have a 30 char field as TP.2120.123465789012 The chances of 2 people with the same ID, on the same day, at the "exact" time [calculating PC difference] ..you do the math. This works great as "select * from table where GUID=aguid into work" if no records then do an add other wise do an "update" You could probably drop the User ID if you want to... Besides you know who and when the record was worked in for later reference. Trey Pattillo [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: Fran Peck <[EMAIL PROTECTED]> To: Mapinfo List (E-mail) <[EMAIL PROTECTED]> Sent: Thursday, 20 January, 2000 15:36 Subject: MI Id question thanks > Thanks to all who responded to my MI ID question. The solution of creating > an ID column and updating column with ROWID was perfect. Got that project > done in short order! I really appreciate the help. > > Fran Peck > Peoria Unified School District > 6330 W Thunderbird Rd > Glendale, AZ 85306 > Voice: 623-486-6099 > Fax: 623-486-6111 > Email: [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 Perto Rico Census Data
Title: Perto Rico Census Data Hello, I've gotten a lot of stuff for - ugh - AkeView. There is census - down to block - , school districts, . One note if you get the school districts it has some 460 fields and you will need to open the dbf in some database and drop the last 400 or so. link to them: http://www.esri.com/data/online/index.html Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com - Original Message - From: Landis, Bill @ Phoenix To: MapInfo Mail List 1 (E-mail) Cc: Swiatkowski, Tricia @ Chicago DT Sent: Wednesday, 19 January, 2000 11:57 Subject: MI Perto Rico Census Data Can anyone direct me to a site where I can get 1990 Census data including Census Tracts? Free is good. Thanks, Bill Landis... Director of Information Management, Global Mapping Services CB Richard Ellis P 602 735 5233 F 703 783 7605
MI MapInfo's E-Commerce - Reported By AndOverNews
Just a bit of FYI for all Today's AndOverNews included the following article about MI's E-Commerce with NearMe.com link to the article: http://www.andovernews.com/cgi-bin/news_story.pl?102407/topstories Andover has a great daily report on about everything to do with technology telephony [PAC Bell problems] to Bubba Bill to web page design and free stuff .. I read it right after the list... :-) You can get a M-F email at http://subscribe.andover.net/modify.html ANSWER TO EARLIER POST ON Millennium 1/1/2000 or 1/1/2001.. The centuries are 0 [zero] based, programmers know how that warps anyone's thinking. The date 12/31/0099 was in the 1st Century A.D. [ 1/1/000 to 12/31/100 ] not the Zero Century therefore 0..99 1st century 100..199 second 1900...1999 20th and 1/1/2000...12/31/2000 21st century ...now think about the astronomical event - Crab Nebula Explosion ( I think ) - that was recorded in all know history which could be the "Start of the East" and factor in the inaccuracies and changes to the calendar system and the millennium actually changed in Nov 1994. HAPPY HOLIDAYS TO ALL. Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI get
index mapinfo-l end Trey Pattillo [EMAIL PROTECTED] http://www.wap3.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 Integrated mapping with Delphi
If you go to my website www.wap3.com and then to the downloads area you can get the source code and examples for using D4 and MapInfo. This is all based on MI v4.x, can't afford the upgrades. === "Creating and Calling Delphi DLL's" This is the full source for Delphi 4 [may work in 3] to create a DLL Includes an example MB showing how to call DLLs. CONCEPTS 1) passing strings and numbers in functions and procedures 2) "modal" dialogs [having D4 create a "input dialog"] [MB goes to sleep] 3) "modeless" dialogs which is a "form" The example uses a memo box with OK & Cancel buttons. There should be enough info to really get you going with Delphi. = "Integrated Callback" Delphi 4 and Visual Basic 5 These are example programs [with source code] on how to do "call backs" using Delphi 4 and VisualBasic 5. There is a file named "_HowTo.txt" that explains the steps required to build the call back from scratch. You can do it the hard way or modify the source code, which ever you're more inclined to do. VB5 is a snap, 3 lines of code. D4 was a bit more difficult, after 7 weeks of surfin' and reworkin' I finally gave birth to this puppy! FOLLOW THE DIRECTIONS ! ! ! This is modified from D3 so it should be fully compatible, except that the menu names etc. are a little different and located in different places. Don't ask for help on D3 I missed D2 & D3 upgrades. === "OLE Automation for Delphi 4" This zip contains full source for use Delphi as an OLE Automation Server. I created from a request on the MapInfo-L Mailing List and to show how to accomplish this method. The last examples I had, MI4.5, said to use a "picture box" which is not correct, at least for Delphi. Hope this helps..drop an email if I can be of help [when I have time] Trey Pattillo [EMAIL PROTECTED] http://www.wap3.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 not spam...AOL instant messaging for Mapinfo-l
Hello, Sounds like a work able idea to me. I haven't played *chat* but several people I know - work related - do and it's works great for them. JUST ONE THOUGHT.some how a *post* reference should be extracted and put on this list for all to benefit. Nothing lengthy just the question and valid answers. This will probably help me since trying to figure out what someone is trying to ask, send and answer, getting more info, sending another answer. Since I just installed AIM35 if anyone wants to contact me using AIM, Yahoo Messangeer drop me a personal mail Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
RE: MI-creating a hotlink
Hello all, I have example of *hotlinking* anything you want on my web site. The file is in pk-zip format and contains source and an example table that will use Notepad to edit Test.TAB, use M$-Paint to open a bitmap [globe[1].bmp], and connect to my website using M$ Internet Exploder. The _HowTO.zip explains the needed fields and what they do, including using a different browser. A lot could be done such as adding variable references and an INI [see WinAPI] so that the users entries will become more *global* in nature. {Maps}StateCap.tab opens *c:\program files\MapInfo Professional\Data\USA\StateCap.tab*. Download it now: www.wap3.com/download/Launch.zip Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
RE: MI - number of columns
Hello, Is compatible or comparable ? MI limits each record to 4,000 bytes in any combination of types and up to 250 columns SmallInt 2 bytes, Integer 4 bytes, float 8 bytes So it is NOT dBase compatible but comparable as dBase allows over 255 columns and I think 8192 bytes, if not then 4096 bytes I got a *free* download from ESRI of School District Boundaries..just what I wanted to add to the collection but it would not convert into MI using UT [ yes it has problems but ] ==>> Error can't open table..M$ style cryptic message [ WHY NOT ? ] After opening with Paradox I found that the *.db had over 750 fields ! ! ! Only the first 20 or so had any *real* information then it began with numeric data and column names like MW01, MW02,MW12, FW01, FW02FW12, MH01, MH02,MH12, MW01.. Logic jumped in >> Male White 1st grade...12 grade Female White.Male HispanicFemale Hispanic Got any ideas how many of these fields were the *big goose egg* and what year was the data from anyway ! Some of it appeared to even be the cultural breakout of the teachers in each grade As a programmer [using Delphi *anit-bloatware*] and data person I learned years ago from M$ that BIGGER IS NOT BETTER, and government still has not caught on that concept either, not to mention a *certain* group of programmer we all kind know -- MI. Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
RE: MI MapBasic - Multiple Files (Gordon.Stenhouse@noswa.co.uk 09/17/99)
If you go to my web site www.wap3.com then to Win32 APIthen select Get a list of the files in folderI have an MB example using the FindFirst and FindNext functions, it's much easier than you thinkHope this helpsTrey Pattillo[EMAIL PROTECTED]http://www.wap3.com Original Message From:[EMAIL PROTECTED] on 09/17/99 01:42 PM GMTRecipients:[EMAIL PROTECTED]Subject:MI MapBasic - Multiple FilesHi Folks,I've written a small MapBasic program which imports only a few layers froma DXF fileinto a TAB file. Unfortunately there are about 700 files I need to do thiswith andmy program only lets me choose one at a time.Could anyone give me any hints as to how to get a list of files so I canstick them inan array and use a For..Next Loop to do all the files in a directory (ifthat's the correctway to do it)?Thanks in advanceGordon StenhouseNorth of Scotland Water Authority
RE: MI mapinfo tick marks
Mike, You can download my mbx app PermaTIC from www.wap3.com\download\PermaTIC.zip The _ReadME.txt explains how to change the settings It's also available on the MapInfo ClearingHouse http://www.directionsmag.com/mapinfo-l/IndexFiles.htm hope this helps Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
RE: MI MapInfo 5.5 Crash
Here's what I have found 1) be sure that you declare all queries INTO a named result > select * from table where a=b INTO TEMP 2) close TEMP as soon as you done with it 3) keep tables closed as much as you can...reopening slows down app but the time is worth it 4) use variables as much as possible including "object" -- really helps control memory usage MOST of all if you using Win9x you were already in trouble ! ! It uses resources just link 3.x and can't decide if it's 16/32 bit or better put a 32 bit display of a 16 bit program built with a 8 bit compiler for a 4 bit processor by a 2 bit company that can't stand 1 bit of competition The 911 app that I wrote with Delphi 4 runs 24/7, reading the phone/address [like caller id], looks it up, creates "pushpins" at the location, allows a far superior user query for failures or general purpose lookups, has 10 additional tables [subdivision, water, etc] and has no problems. Of course it runs on NT4w SP5 with 64meg on a P-200mmx using MI4.1. I have noticed that after 1500 to 2000 hrs [about 2.5-3 months NT gets a bit tired, no matter what your doing, including my "crash & burn" development cycles -- reboot time]. Yesterday I was at a location that is still using the old PowerBuilder/Paradox database app [the version of PB is a 16 bit app] and it had gone blind, lost all it "edit boxes" and labels but the window was still there, after about 800 hrs [back to the "resource" issue]. Hope this helps. Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
MI Eye Of The Storm
Hello all, I'm going to sign off to save my mail server. As the weather looks at 21:20cdt 08/21/1999 for Corpus Christi, TX we may get a direct hit I've got lots to prepare for at 911 and at home. We hope for the best but will just have to see Back when the storm is over and everything working.... Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com
Re: MI Strange Behavior in 5.5
I don't have v5.5 but about 2 weeks ago there was discussion about 1) make a selection from MyTable into TEMP 2) make a selection of TEMP into Temp1 3) do close all, or back track the table, [temp1, query1, Temp, MyTable] POOF ~ ~ MI is gone 4) also happens when exiting MI I had the last laugh that Friday night when I went back into my Delphi Application and ran though that scenario of code [was a problem in my app] and v4.5 died and the chokes Delphi because MI link is gone. To keep it short "Totally" wiping out registry and all of v4.5 and reloading still had same problem. So I had to go back to v4.1.2 and all is OK The only change was on 4 July I installed a CD Rewrite and it's software, other than that no changes in P2-266, NT4w-sp4, 128meg I have lately loaded SP5 but don't have time to retest problem... Trey Pattillo [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: Steve Wallace <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, 19 August, 1999 10:46 Subject: MI Strange Behavior in 5.5 > Anyone else seen a problem (that has happened to me more than once) where > you go to File > Close Table and MapInfo itself just shuts down? > > > > 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] -- 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 Selection control query
Hello I do all my work via integration with Delphi4, soon to be 5, and found that at various times I strange happenings. It took a while to even get the error message to the front of the processess. Then to figure out what was wrong. By calling the WinAPI GetAsyncKeyState it will flush out the keys/messges about the ESC key being pressed. What bugs me is that I never actually pressed the ESC key until I started the testing how to fix it... You might have to have this is your process loop in VB/MB I haven't tested the actual call in MB and stopped using VB awhile back so just how and where you place it will be up to trial and error IN DELPHI EscKey: Integer; EscKey:=getasynckeystate(27); IN VB / MB Declare Function GetAsyncKeyState Lib "user32" Alias "GetAsyncKeyState" (ByVal vKey As Integer) As Integer DIM EscKey as Integer EscKey = GetAsyncKeyState(27) Hope this helps...it worked for me Trey Pattillo [EMAIL PROTECTED] http://www.wap3.com - Original Message - From: Sean Richards <[EMAIL PROTECTED]> To: 'MapInfo List' <[EMAIL PROTECTED]> Sent: Wednesday, 28 July, 1999 17:43 Subject: MI Selection control query >Hi all, > >I have a little query, about queries actually. Does anyone know if there is >some way to protect a selection in progress from user intervention. I am >referring to the (good) facility within MapInfo that allows a user to push >ESC and halt the selection procedure. I have a case here where that ability >is undesirable - automated procedures. > >The best I have come up with is removing the ESC key from all of the >keyboards in the office (lateral concept). Anyone got any better ideas? > >Input appreciated. > >Thanks > >Sean Richards >ERSIS Australia >Level 2 436 St Kilda Rd, PO Box 3055. Telephone +61 3 986 77322 >Melbourne. VIC. 3004. Australia. Facsimile +61 3 986 77422 >Email: [EMAIL PROTECTED] > >On the web at http:\\www.ersis.com.au >__ >The views expressed in this message do not necessarily >reflect the views of ERSIS Australia. > > >-- >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 : window size dependency
Hello Jacques and all, If you go to my website, then to WinAPI, you will find the source code you copy into you MB app that stops the user from closing, moving, min, and max. The "resize" is removed from the menu command [top left of window] but the window still has "drag" [at least on WinNT] capability. Languages like VB MB Delphi C etc, are just an easy way [sometimes not the best way] to control Windozebut the WinAPI "IS" Windoze. I have a prologue that lists a few books that popped up on the results at Amazon.com [notice no link, check you favorite book outlet] of about 130+ when I entered "WinAPI' in the search..I'm not promoting anything but look into the author's integration with VisualBasic [that's the first listing and pub'd 1999] as very little is different from MB [API uses "long" as an integer where MI is just "Integer"] which will make understanding how to setup the call a bit easier. The books should have the calls listed [or maybe CD] which will help. All the stuff I have came with developer software [Delphi/VB] and is extremely difficult to understand as most of it references the C++ structures. Here's what is currently on available [more as get the time] FILE FUNCTIONS Get a list of the files in a folder Get the "Windows" folder Get the "Windows System" folder Get the "System Temp" folder Get the current folder Set the current folder Create New Folder WINDOW FUNCTIONS Get the handle of the current focused window [blue title bar] Disable Min/Max/Close on a window [can be any window] Your own Message Dialog SYSTEM FUNCTIONS [date/time, etc] Get the System TIME [also for creating Globally Unique Identifiers Guide's] Delay without code loops Get the "User" Name [network log-in] Use you own INI File ENJOY... Trey Pattillo[EMAIL PROTECTED]http://www.wap3.com