MapInfo Professional Version 12.
Notices
Information in this document is subject to change without notice and does not represent a commitment on the part of the vendor or its representatives. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, without the written permission of Pitney Bowes Software Inc., One Global View, Troy, New York 12180-8399. © 2014 Pitney Bowes Software Inc. All rights reserved. Pitney Bowes Software Inc.
Copyright Products named herein may be trademarks of their respective manufacturers and are hereby recognized. Trademarked names are used editorially, to the benefit of the trademark owner, with no intent to infringe on the trademark.
Contents Chapter 1: Introduction.....................................................................................21 What is MapInfo Professional?..........................................................................22 Mapping at a Glance..................................................................................22 Using Your Own Data.................................................................................22 Reviewing the MapInfo Professional Features....................................
An Overview of the Toolbars.......................................................................37 Data - Where MapInfo Professional Begins......................................................41 What is a Database and Other Basic Terminology.....................................41 What Data Can I Use in MapInfo Professional?.........................................43 Support for Raster Images.........................................................................
Displaying Thematic Layers.......................................................................77 Converting Objects into Region Objects ....................................................78 Working with Raster and Grid Layers in Layer Control..............................78 Converting Grid Files to MapInfo Professional Grids (*.mig) .....................79 Working with Seamless Layers..........................................................................79 Features Available with Seamless Layers ....
Setting the Geocoding Server Preferences..............................................104 Setting the Routing Server Preferences...................................................105 Setting the Tile Server Preferences..........................................................105 Setting the Library Services Preferences.................................................106 Setting the Custom Proxy Server Preferences.........................................107 Setting up a Geocoding Server......................
3D Graphs................................................................................................144 Area Graphs.............................................................................................145 Bar Graphs...............................................................................................145 Bubble Graphs..........................................................................................145 Column Graphs..................................................................
Deciding to work with Linked or Live Access Tables....................................183 Comparing and Contrasting Live and Linked Access to a Table..............184 Opening a DBMS Table in MapInfo Professional...........................................185 Opening a DBMS Table............................................................................185 Creating a New DBMS Table ...................................................................187 Refreshing Live and Linked Remote Tables ................
Chapter 9: Selecting and Querying Data.......................................................223 Selecting Your Data in MapInfo Professional.................................................224 Characteristics of Selections....................................................................225 Selecting from the Screen........................................................................226 Selecting Tools.........................................................................................
Working with a Thematic Map Legend.....................................................277 Thematic Maps as Layers .......................................................................277 Changing the Display Parameters of a Map ..................................................278 Modifying a Thematic Map.......................................................................278 Using the Theme Templates.....................................................................278 Saving Your Thematic Settings.
Saving Labels...........................................................................................319 Adding an Adornment to the Map....................................................................319 Adding a Scale Bar to Represent Map Scale...........................................320 Working with Layouts.......................................................................................320 Opening a Layout Designer Window .......................................................
Raster Image Format Details....................................................................353 Opening a Raster Image...................................................................................354 Registering the Coordinates of a Raster Image.......................................355 Reprojecting a Raster Map.......................................................................355 Transferring Vector Map Coordinates Directly to a Raster Map...............
Selecting Records Not Geocoded............................................................382 Locating Newly Geocoded Points.............................................................382 Result Codes............................................................................................383 Ungeocoding a Table ...............................................................................383 Putting Latitude/Longitude Coordinates on a Map .......................................
Chapter 16: Working with Data from a Web Service....................................409 Introduction to Web Services...........................................................................410 Accessing Web Services in MapInfo Professional ..................................410 Web Service Authentication.....................................................................410 Enhancing Map Data using a Web Map Service (WMS).................................412 How Does MapInfo Professional Use WMS Servers?..
Constructing Simple Expressions.............................................................438 Constructing Complex Expressions..........................................................439 Entering Specific Values (Constants) into Expressions ...........................439 Using Mathematical Operators in Expressions ........................................440 Using String Operators in Expressions ....................................................440 Using Comparison Operators in Expressions .............
Coordinate System Origin........................................................................479 Standard Parallels (Conic Projections).....................................................479 Oblique Azimuth (Hotine Oblique Mercator).............................................479 Scale Factor (Transverse Mercator).........................................................479 False Northings and False Eastings.........................................................480 Range (Azimuthal Projections)........
Introduction Welcome to the Pitney Bowes Software Inc. family of products. As the field of computer mapping continues to expand, Pitney Bowes Software Inc. leads the way with new products that are designed to fulfill users' computer mapping needs from the most basic to the most specialized with MapMarker, our premier address matching product.
What is MapInfo Professional? What is MapInfo Professional? With MapInfo Professional, the power of computer mapping is at your complete disposal. You can display your data as points, as thematically shaded regions, as pie or bar charts, as districts, etc. You can perform geographic operations such as redistricting, combining and splitting objects, and buffering. You can also make queries against your data and access your remote data directly from MapInfo Professional.
Chapter 1: Introduction After you have organized your data visually, you will save the results to files, or send them to any of the dozens of printers and plotters MapInfo Professional recognizes. If you have your data on hand and you can read a map, you are just about ready to begin. Soon, we will show you an example of how easy it is to put MapInfo Professional's power to work for you. But first, install MapInfo Professional following the instructions in the MapInfo Professional Install Guide.
Getting Started Accessing Your Documentation MapInfo Professional Documentation Set The MapInfo Professional User Guide contains a subset of the information found in the MapInfo Professional Online Help system. If you cannot find the information you are looking for, refer to the Online Help system, which is installed with the product. Accessing MapInfo Professional Documentation You can access the MapInfo Professional files in the Documentation subfolder located in your installation directory.
Chapter 1: Introduction Figure 3: Map displaying three layers: capitol cities, country boundaries, and ocean layers. A Query Browser window displays a table with the results of a simple selection. Data is represented on a map as an object, such as a point to mark a location, a polygon to mark the boundaries of a region, or a line to mark a route. Figure 4: A simple map showing store locations as points, circles as sales territories, and lines as roads and railways.
Getting Support You are then ready to launch MapInfo Professional as described under Starting and Leaving MapInfo Professional. There is a lot of information under A Tour of the MapInfo Professional Desktop that describes how to work with MapInfo Professional. Review this section and the other sections in The Basics of MapInfo Professional to learn how to work with this product.
Chapter 1: Introduction • Use the Index feature to find a topic quickly. Type the first few letters of the word you are looking for. The index entry that most closely matches your entry is highlighted. Click the index entry you want to display. • Use the Favorites tab to collect and store topics you want to refer to frequently. • Context-Sensitive Feature: Press the F1 key to receive more information on any menu command or dialog box. The Help window for that item displays.
Getting Technical Support Tell Us What You Think! Want to give MapInfo Professional Engineers feedback? We have an option in the Help menu for you to provide direct product feedback to Pitney Bowes Software Inc. If you have a need for a new feature, or you need our product to do something it does not currently do, use this feature to write to us. Whether you want to complain or complement, let us know so we can meet your MapInfo Professional needs better.
What's New in MapInfo Professional Thank you for upgrading to the most advanced computer mapping product in the Pitney Bowes Software Inc. software family! As the field of computer mapping continues to expand, Pitney Bowes Software Inc. leads the way with new products that are designed to fulfill your computer mapping needs from the most basic to the most specialized.
New and Changed Features in MapInfo Professional New and Changed Features in MapInfo Professional You will notice the following licensing improvements: • Overdraft licenses are now available if you purchased distributable licenses. Overdraft licenses ensure that you do not have a service disruption if you lose a license during server migrations or failure.
Chapter 2: What's New in MapInfo Professional For details on how to set the concurrency as a software preference, see Setting your Performance Preferences. Use Your Microsoft Bing Maps License with MapInfo Professional MapInfo Professional now lets you use your own Microsoft Bing Maps license. Purchasing a new MapInfo Professional license or upgrading an existing license provides access to Microsoft Bing Maps, a web mapping service, for Bing Aerial and Bing Hybrid maps.
Data Access Features 2. Click System Settings to open the System Settings Preferences dialog box. 3. Clear the Enable True Color Cursors check box to use the 1-bit per pixel cursor, which displays in black and white. Selecting the check box enables the 32-bit per pixel cursor. Data Access Features MapInfo Professional now supports: • Oracle Spatial 11g R2 and 12c R1 For details about working with databases, see Working with Data in a DBMS.
Chapter 2: What's New in MapInfo Professional New and Existing Tools MapCAD Update This release updates the MapCAD tool to a new version. This product provides tools that work with MapInfo Professional to create maps that are appropriate for land development and surveying tasks. this update was for continued compatibility with MapInfo Professional and includes no new functionality. The MapCAD tool installs automatically with MapInfo Professional to a subfolder called MapCAD.
The Basics of MapInfo Professional Now that you have installed MapInfo Professional, you are probably anxious to get mapping. But, if you are new to MapInfo Professional, take a few minutes to read this chapter to familiarize yourself with the concepts, components, and tools for successful computer mapping. In this section: • • • • • • • • • • • • • Starting and Leaving MapInfo Professional . . . . . . . . . . .36 A Tour of the MapInfo Professional Desktop . . . . . . . . . .
Starting and Leaving MapInfo Professional Starting and Leaving MapInfo Professional In this section we cover the very basics of starting MapInfo Professional, using the STARTUP.WOR, and exiting the program. Since opening a table is basic to getting started in using MapInfo Professional, we cover that topic here, as well.
Chapter 3: The Basics of MapInfo Professional A Tour of the MapInfo Professional Desktop This section details the tools and commands that are available to you in the MapInfo Professional product. You may refer to these frequently as you familiarize yourself with MapInfo Professional. If your copy of MapInfo Professional includes introductory data, you may want to install it now, as described in the MapInfo Professional Install Guide.
A Tour of the MapInfo Professional Desktop Print To PDF New Browser Copy New Grapher Window Undo New Redistricter Window Reviewing the Main Toolbar The Main toolbar contains buttons for selecting objects, changing the view of the Map window, getting information about an object, and showing distances between objects. It also contains buttons that allow you to change attributes and open the floating thematic legend or Statistics windows.
Chapter 3: The Basics of MapInfo Professional Drag Map Window * Accesses the Drag Map Window button to drag a MapInfo Professional map into an OLE container application. Layer Control Accesses the Layer Control window so you can specify how the various tables in a Map window are layered and displayed. Ruler Accesses the Ruler tool to determine the distance between two points and the length of some path. Show/Hide Legend Accesses the floating Thematic Legend window.
A Tour of the MapInfo Professional Desktop Rectangle Accesses the Rectangle tool, which allows you to draw rectangles and squares. Rounded Rectangle Accesses the Rounded Rectangle tool, which allows you to draw rounded rectangles and squares. Text Accesses the Text tool, which allows you to add titles, labels, and annotation to maps and layouts. Frame Accesses the Frame tool, which allows you to create frames in the Layout window to display maps, graphs, browsers, and legends.
Chapter 3: The Basics of MapInfo Professional Disconnect DBMS Accesses the Close DBMS Disconnection dialog box, where you can close a connection to a remote database. Reviewing the Web Services Toolbar The Web Services Toolbar contains buttons and commands that are used to access web services. For more about accessing web services, see Working with Data from a Web Service. Open WMS Table Opens a Web Map Service table into the current map or into a new map.
Data - Where MapInfo Professional Begins Emergency medical calls thematically shaded by type of call and time of call, with response zones shaded by number of calls. To understand MapInfo Professional, you need a basic understanding of database organization, in particular, three fundamental concepts: record, field, index, and query.
Chapter 3: The Basics of MapInfo Professional A query is just another word for a question. You query data to collect a particular type of information from your database. For example, if you wanted to know how many customers live within a certain number of miles of your store, (and you had that kind of information in your database), you could query the database to find out that information. The result of the query is query data.
Data - Where MapInfo Professional Begins • Displaying your Excel (.XLS or .XLSX) Data • Displaying your Access (.MDB or .ACCDB) Data • Displaying your Comma Delimited Data • Displaying your dBase Data • Displaying your Lotus 1-2-3 Data • Displaying your ESRI Shapefile Data • Registering and Displaying your ASCII Data • Importing and Displaying GML File Data • Working with Data in a DBMS • Working with Data from a Web Service Support for Raster Images MapInfo Professional supports raster image display.
Chapter 3: The Basics of MapInfo Professional Your data may also contain graphic objects. Once you assign X and Y coordinates to your data records, your table will also contain graphic objects. In Geocoding - Assigning Coordinates to Records, you will learn how to assign X and Y coordinates to your data records so you can display them on a map. If you already have graphic objects in your table, there are two more files associated with the table: • .MAP: This file describes the graphic objects.
Data - Where MapInfo Professional Begins • Raster image files – (*.bil, *.sid, *.gen, *.adf, *.img, *.ntf, *.ecw, *.url, *.tif, *.grc, *.bmp, *.gif, *.tga, *.jpg, *.pcx, *. jp2, *.j2k, *.png, *.psd, *.wmf, *.emf, *.map) • SHP – ESRI Shapefiles • TXT – Delimited ASCII files • WKS – Lotus 1-2-3 files (*.wk1, *.wks, *.wk3, *.wk4) • WOR – MapInfo workspace files • MWS – apInfo workspace files • XLS – Microsoft Excel files • XLSX – Microsoft Excel 2007 or later files • Grid images – (*.adf, *.flt, *.txt, *.
Chapter 3: The Basics of MapInfo Professional • • • • • • • • • • • • • • • • • • • • • • • • • • • • filename.* – Controlled Image Base (CIB) format ECW – Enhanced Compression Wavlet (ECW) format handler by ER Mapper EMF – Enhanced Metafile Format FLT – Image Filter (FLT) GEN – ARC Digitized Raster Graphic (ADRG) format GEN – ARC Standard Raster Product to 1.2 (ASRP) 1.
Data - Where MapInfo Professional Begins • • • • • • • • • Autodesk AutoCAD DWG/DXF – Supports AutoCAD file versions up to and including 2010 Bentley MicroStation Design (V7) – Supports Intergraph Standard File Format (ISFF) Version 7 Bentley MicroStation Design (V8) – Supports Intergraph Standard File Format (ISFF) Version 8 ESRI ArcInfo Export (.e00) – Supports ArcGIS 10.x ESRI ArcSDE – Supports ArcSDE 10.x ESRI Geodatabase (MDB) – Supports ArcGIS 10.x Google Earth KML – Supports KML 2.
Chapter 3: The Basics of MapInfo Professional • Double click the file you want to open • Click the file you want to open to highlight it in the list and click Open. Using either method, MapInfo Professional opens the data file. When opening multiple tables, use Shift-click to select adjacent tables and Ctrl-click to select non-adjacent tables. Note that although a MapInfo Professional table consists of two or more component files (STATES.TAB, STATES.DAT, STATES.MAP, etc.), only the .
Data - Where MapInfo Professional Begins MapInfo Professional attempts to open the table as specified for Browser, Current Mapper, and New Mapper. If it cannot, it will open the table according to the following rules: • If Current Mapper is selected, and there is no Map window displayed, MapInfo Professional will attempt to open the table in a new Map window. • If Current Mapper or New Mapper is selected and the data is not mappable, MapInfo Professional will try to open the table in a Browser window.
Chapter 3: The Basics of MapInfo Professional use other spatial or non-spatial tools (MapInfo Professional, ArcView, Intergraph, Excel, Forte, Formida, etc.). For more about accessing remote data using ODBC connectivity, see Setting your Database Connection Preferences in the Help System. Using the MapInfo Places on Open Dialog Box The Open dialog box provides a quick way to look for maps you have created. The Places box. Select the Workspaces Directory option in the Places box, to display the Workspace (.
Understanding Your Data in MapInfo Professional Opening Special File Types There are additional file types that MapInfo Professional can read including rasters, grids, and shape files. For details about working with raster images, see Displaying a Raster Image and Registering the Coordinates of a Raster Image in the Help System. Opening a Grid Layer A grid layer is a type of thematic map that displays data as continuous color gradations across the map.
Chapter 3: The Basics of MapInfo Professional points, lines, and text. Additionally, the layer contains style overrides and zoom layering characteristics that you can add to give the layer more or less prominence in the Map window. Figure: Map Layers Example Map layers form the building blocks of maps in MapInfo Professional. Once you have created your layers, you can customize them in a variety of ways, add and delete layers, or reorder them.
Using Workspaces You also have options available to change the display and label settings; modify any thematic maps you have displayed; and reorder, add, or remove layers. • For instructions on accessing the Layer Control window, see Accessing Layer Control in the Help System. • For instructions on changing layer order in the Layer Control window, see Changing the Order of Contiguous Layers or Changing the Order of Random Layers topics in the Help System.
Chapter 3: The Basics of MapInfo Professional The Help System contains these related topics: • Opening Multiple Workspaces • Reading Labels from a MapInfo Workspace File (MWS) • Limitations opening a MWS Format Workspace • About Writing Label Overrides to a MapInfo Workspace File (MWS) • About Reading/Writing Translucency Settings for a Workspace File (MWS) How Renaming Tables Affects Workspaces When you change the name of a table listed in a workspace, you invalidate the workspace.
Reviewing the Windows in MapInfo Professional There are many different types of windows you can display your data in, depending upon what you need your data to communicate. This section covers the many ways you can display your data using MapInfo Professional. Each of these display methods: map, list, graph, and presentation give your information a different impact. How you display the information you have should depend upon what effect you want.
Chapter 3: The Basics of MapInfo Professional to move around a map left, right, up, and down. Moving selected objects in an editable layer is useful when you want to get your map right. You can zoom using the mouse wheel or using the keyboard. In addition to the usual zoom keys on your Main Toolbar ( , on the keyboard, to zoom in and out more precisely. , and ), you can use the + and - keys • When you press +, you zoom in by a factor of 2. • When you press -, you zoom out by a factor of .5.
Reviewing the Windows in MapInfo Professional Browser window title bar, appearing as headings. You select a row by single clicking the empty box appearing to the left of that row. The Status Bar appears at the bottom left of the MapInfo Professional window. This bar displays the range of records currently displayed within the Browser window out of the total number of records in the table.
Chapter 3: The Basics of MapInfo Professional The table must be editable to make changes to it—it cannot be read-only. • For more information, see Opening Multiple Browsers, Scrolling through a Table , and Using the Select Tool to Edit Browser Entries in the Help System. About Browser Window Tools and Menus Browser Window Toolbar The Browser window includes a toolbar of options that apply to the data in the Browser window.
Reviewing the Windows in MapInfo Professional Text Style Opens the Text Style Dialog Box where you select how to display the text in the Browser window. This option is the same as choosing the Text Style button from the Browser window toolbar menu. Pick Fields Use Pick Fields to choose which fields display in the active Browser window.
Chapter 3: The Basics of MapInfo Professional Sort Smallest to Largest Sorts the column containing numbers from the lowest (smallest) value to the highest (largest) value. Sort Largest to Smallest Sorts the column containing numbers from the highest (largest) value to the lowest (smallest) value. Filter Opens the Filter dialog box where you can set filter conditions for the column.
Reviewing the Windows in MapInfo Professional • • • • • Adding a Filtered View to a Map Creating a Default Browser View Choosing a Font for Your Browser Window Preserving Column and Expression Settings in a Browser Window Using the HotLink Tool in a Browser Window For information about setting the background color for Browser window rows and other preferences, see Setting your Browser Window Preferences.
Chapter 3: The Basics of MapInfo Professional Displaying Data in a Layout Window The Layout window allows you to combine Browser windows, Map windows, Graph windows, and other graphic objects into one layout which can then be sent to a printer or plotter. You use this type of window to create presentation graphics. Layout windows have scroll bars at the right and at the bottom like Map windows and Browser windows.
Working with Tables in the Table List Working with Tables in the Table List The Table List window lets you perform operations for open tables in MapInfo Professional using fewer clicks. You can organize tables into groups and sort them alphabetically and recently opened first. The Table List window is accessible on the Table menu by pointing toTable List. The Table List has the following features: • Modeless, so that you can open it and leave it open for the duration of your session.
Chapter 3: The Basics of MapInfo Professional Recently Opened First Click to sort tables based on the order they were opened. The most recently opened table displays first. In tree view mode, the table type nodes always display in ascending order. The sorting criteria persist across different MapInfo Professional sessions.
Working with Tables in the Table List • Close - Closing a table removes it from active use in your current session. When you close a table, you automatically close all views of that table. When closing a table that displays in a Map window with other tables, MapInfo Professional removes that table from the window and keeps the Map window open. For more information, see Closing a Table in the Help System.
Chapter 3: The Basics of MapInfo Professional Searching the Table List Searching Tables You can search for a table name in the Table List by typing characters in the Search text box. The Table List view refreshes itself to show only those tables that contain the search characters. Clear Search Typing in the Search text box causes the Search button to change to a Clear Search button. To clear the contents of the Search text box, click the Clear Search button.
Working with Layers in the Layer Control to the top. If you are dragging multiple layers, the arrow icon will display multiple layer icons at the top. If you select layers that cannot be dragged or if you are attempting to insert layers where they cannot be inserted, the cursor becomes a circle with a line through it. Note: A selection of layers that is out of sequence will become contiguous upon insertion. Use the Move Layers Up or Move Layers Down buttons to move one or more layers.
Chapter 3: The Basics of MapInfo Professional Each row represents a layer on the map. You can select the following for each layer: • Selecting the Visible check box displays a layer on the map. • Clicking the Layer Type icon lets you edit style properties for the items in the layer, such as: points lines regions • Clicking the Editable icon makes the layer editable. • Clicking the Selectable icon makes a layer selectable in the Map window.
Working with Layers in the Layer Control Graduated Symbol Theme Dot Density Theme Individual Theme Grid Theme • A map tile server layer or a raster layer displays the following icon: Raster Layer or Tile Server Layer • A group layer icon indicates a group of layers. You can drag to move layers in to or out of the group. Group Layer Note: Group layers are not preserved when you do a Save Workspace As to a .MWS file.
Chapter 3: The Basics of MapInfo Professional Modify Theme Click to open the Modify Thematic Map dialog box and set display attributes for a thematic layer. This button is only active after selecting a thematic layer. Hotlink Options Click to open the Hotlink Options dialog box where you can specify filename expression, file locations, what activates HotLink, and saving options to table metadata. See Creating Active Objects in the Help System.
Working with Layers in the Layer Control Reordering Map Layers Map layers display in the order that they are listed in the Layer Control window, with the bottom layer drawn first and the top layer (which is always the Cosmetic Layer) drawn last. It is important to order your layers correctly. For example, you have a layer of customer points and a layer of census tracts.
Chapter 3: The Basics of MapInfo Professional the street layer only when the zoom is set to a distance that allows you to see the street detail properly, for instance, less than 5 miles. The first map does not have zoom layering set for its street layer. At a zoom of 15 miles across, notice how difficult it is to see any detail. The second map has zoom layering set to display the streets when the zoom is less than five miles. Therefore, the streets layer does not display when the window is set at 15 miles.
Working with Layers in the Layer Control • Lines default to Below Center. • Points default to Right. Label Offset is how far away a label is from its anchor point. Specify the number of half spaces you want the label to be from the anchor point in the Label Offset box. 5. Click OK. The map redraws with your changes. Label Size Label size does not change with zoom or scale changes. Labels display at the size you specify at all zoom levels as well as on printed output.
Chapter 3: The Basics of MapInfo Professional Style commands from the Options menu. When the Cosmetic Layer is editable, you can access the style options from the Drawing Toolbar. The contents of the Cosmetic Layer are linked proportionally to the map. Map objects (except for symbols) and text in the Cosmetic Layer are proportionally linked to the zoom level of the map. If you draw objects in the Cosmetic Layer and then change the map's zoom from 30 to 100 miles, the size of the objects will appear smaller.
Working with Layers in the Layer Control Note: Use the Ctrl key with the Info button to toggle through all selectable layers and access overlapping objects. When you click a map location using the Info button where two or more selectable map objects overlap, the data tied to the objects on each layer display in the Info tool window. If you do not want the information for all layers to display, turn off Selectable for those layers in the Layer Control window.
Chapter 3: The Basics of MapInfo Professional For example, if you want to find all customers who live within a fifty kilometers radius of Paris, make the Street layer selectable. If the map also includes a layer of hospitals (which you do not want to include in the radius search), turn off the Selectable option for the hospital layer. The Editable or Selectable options only apply to the Map window itself.
Working with Thematic Layers The type of thematic map is noted first, followed by the list of variables used to create the map. For example, a pie thematic layer that uses commuting data is listed this way: Pies with ComAlone, ComCarpool... The variable list is truncated if there is not enough room to display each variable used in your thematic analysis. For more information about thematic mapping, see Using Thematic Mapping to Analyze Information.
Chapter 3: The Basics of MapInfo Professional • Changing the Display of a Raster Image Converting Grid Files to MapInfo Professional Grids (*.mig) The Grid Tools (Create MapInfo Grid from Table of Objects and Create MapInfo Grid from Other Grid Files) In MapInfo Professional allow you to convert Grid Files to MapInfo Professional Grids (*.mig). These tools convert any grid file for which there is a grid handler present with the output being in MapInfo Professional (*.mig) format.
Working with Seamless Layers • Select Tools - Select objects from the seamless layer. You can only select a group of objects if they reside in the same base table. Press the Shift key while clicking the Select Tool to do so. If you attempt to select several objects that reside in different base tables, MapInfo Professional will only select objects in one base table.
Chapter 3: The Basics of MapInfo Professional The structure of each seamless layer includes the path name of each base table plus a description that defaults to the table name (alias). To view the table structure, turn the seamless layer off and display the seamless table in a Browser. Refer to Turning Seamless Layers On and Off.
Working with Seamless Layers In the Layer Control window, you can add, remove, or reorder seamless layers as if they were conventional MapInfo Professional layers. You can also set Label and Display options for all the tables in the seamless layer as if they were one table. Notice the editable option for a seamless layer is grayed. Choose your seamless layer and experiment with order, display, and labeling options. To retrieve information from a seamless layer: 1.
Chapter 3: The Basics of MapInfo Professional Turning Seamless Layers On and Off Using the Tools in the Tool Manager Working with MapInfo Manager Library Services The Library Service lets you access the metadata records published in MapInfo Manager. You can access Library Services by selecting Options > Preferences > Web Services > Library Services. For enabling the Library Services, refer to Setting the Library Services Preferences.
Saving, Closing, and Exporting Your Work Saving, Closing, and Exporting Your Work Preserving your work is an important part of being productive. MapInfo Professional has a wide variety of ways you can save what you are working on, depending upon what needs to be saved and how you need to retrieve it. Saving a MapInfo Workspace If you work with the same tables repeatedly, you know that opening each one individually every time you use it can be tedious.
Chapter 3: The Basics of MapInfo Professional • The Map window's projection contains an EPSG code. Projections that do not have an EPSG code are not supported. • The Map window must not be rotated, or contain a raster image that causes a rotation. GeoTIFF Export Procedure To export a Map window to a GeoTIFF format file, do the following: 1. 2. 3. 4. 5. Open the desired layers in a Map window, if you do not have your map open already. Make the Map window active. Choose File > Save Window As.
Saving, Closing, and Exporting Your Work • Saving Changes Made to a DBMS Table • Saving a Copy of a Table to a DBMS Server Closing a Table Closing a table removes it from active use in your current session. Choose the Close command from the File menu to close tables. When you close a table, you automatically close all views of that table. If you close a table that is displayed in a Map window with other tables, MapInfo Professional removes that table from the window, but the Map window remains open.
Chapter 3: The Basics of MapInfo Professional Exporting Your Data to a New Format You can export your Map window to other file formats with the Save Window As command (on the File menu, click Save Window As). This enables you to use your map in another application, such as word processing, presentation, or computer publishing packages. Supported Export Formats You can save data in a number of formats in MapInfo Professional. Windows .bmp is the initial default.
Saving, Closing, and Exporting Your Work Other programs, such as word processing programs and spreadsheets, typically open files as one compound object, without trying to explode them into component objects. These programs usually honor the clipping information and clip the contents appropriately. For example, if you are exporting a Map window that displays part of Germany, but not all of it, the exported file contains the entire image of Germany.
Chapter 3: The Basics of MapInfo Professional You must either set a global preference for these anti-aliasing options or set them locally during the export process (using the Advanced button). • For specific instructions, see Smoothing Map Images during Export in the Help System.
Configuring MapInfo Professional Preferences Preferences allow you to change a number of default settings, enabling you to customize certain aspects of the program's behavior. Preference files are stored on a per-user basis. In this section: • • • • • • • • • • • • • • • • • • • Summary of Preferences . . . . . . . . . . . . . . . . . . . . . . . . . .92 Setting Your Preferences . . . . . . . . . . . . . . . . . . . . . . . . . .92 Setting Your System Preferences . . . . . . . . . . . . . . . . . . .
Summary of Preferences Summary of Preferences Here is a brief description of the preference categories. System • System Settings - Controls what information is copied to the clipboard, color defaults, aspect ratio, paper and layout units, the number of Undo objects permitted, how symbol types used prior to version 4.0 are drawn, and how MapInfo Professional handles 2-digit years. • Startup - Controls whether the program saves the MAPINFOW.
Chapter 4: Configuring MapInfo Professional Preferences 2. Click one of the buttons to open the dialog box of preferences. 3. Set your preferences and click OK to save them and return to the Preferences dialog box. 4. Click OK to close the Preferences dialog box. What follows in this section are details to assist you in setting your preferences.
Setting Your System Preferences 2. Select your system preferences for MapInfo Professional. 3. Click OK to close the dialogs and save your settings. Setting Your Default Units You can set the default paper and layout units, distance units, and area units as a software preference. To set your default units: 1. On the Options menu, point to Preferences, and then click System Settings to open the System Settings Preferences dialog box. 2.
Chapter 4: Configuring MapInfo Professional Preferences The default is 10 objects. You can set it from 0 to 800. Setting the number of objects to 0 deactivates the system. After you use the Undo option, the system toggles to Redo. Note: You cannot use the Undo capability for the following operations: Revert, Save, Save As, or Modify Table, or any operations whose effects are primarily cosmetic. • Memory Size for Undo - Indicates the memory size in bytes for Undo operations. Maximum is 10,000,000 bytes.
Setting Your System Preferences year for your data, then the years entered as 00-49 become 2000-2049 and years entered as 50-99 become 1950-1999. To turn on date windowing: 1. On the Options menu, point to Preferences and click System Settings to open the System Settings Preferences dialog box. 2. Select Set date window to and enter a number from 0-99 that will be the pivot year below which to use the previous century.
Chapter 4: Configuring MapInfo Professional Preferences 4. Click OK to close the dialogs and save your settings. Setting Your Image Resolution for Exporting You can control the resolution of a window when exporting it using a software preference. MapInfo Professional uses this preference whenever you copy windows to the Clipboard, export your work to metafile and raster formats, and use the Save Window As export process. If you do not set this resolution manually, the product assumes 96 dpi.
Setting Your Startup Preferences Size as the map size when you print your map, the printout of the map is smaller than it appears on the screen. To compensate, measure the display area of your screen and enter those dimensions in the Aspect Ratio Adjustment box. 1. On the Options menu, point to Preferences and click System Settings to open the System Settings Preferences dialog box. 2.
Chapter 4: Configuring MapInfo Professional Preferences Note: If this preference is turned off, or if the printer indicated is not available, the printer settings for the workspace revert back to the default printer set in the Printer preferences. • Default DBMS Connection - Select this check box to set a DBMS connection that will open each time you begin a MapInfo Professional session. Click Set to select the connection.
Setting Your Directory Preferences • If you select Oracle Spatial, the MapInfo Oracle Connect dialog box displays and you must enter the user name, password, and server name of the database you are adding. Click OK to save your entries and return to the Startup Preferences dialog box. After selecting a DBMS connection, it displays in the Default DBMS Connection field and is set to connect each time you open MapInfo Professional. 4. Click OK to close the dialogs and save your settings.
Chapter 4: Configuring MapInfo Professional Preferences 2. In the Initial Directories for File Dialogs list, select a preference and then click Modify. The Choose Directory dialog box opens. 3. Enter a new directory location and click OK. 4. Repeat this process until you have set all of the preferences that you need to. 5. If you are accessing your application data files and other configuration files (Mapinfow.
Setting the Web Services Preferences 2. To specify a search path, in the Search Directories for Tables group, click Add 3. Specify a drive and directory in the Choose Directory dialog box and click OK. You can set up to four paths. Use the Up and Down keys to change the search order. Use the Add and Remove buttons to add or remove paths from the list. 4. Click OK to close the dialogs and save your settings. For more information see Choosing the Directories in the Place Bar in the Help System.
Chapter 4: Configuring MapInfo Professional Preferences Setting the WFS Server Preferences MapInfo Professional has software preferences that let you: • Use a WFS Refresh option to retrieve updated GML information from the web feature service pertaining to the current layers. • Set the default WFS timeout values (in seconds) for the WFS servers you use. You can set per-server defaults based on particular WFS servers in the Override Timeout Values section of the WFS Services Preferences dialog box.
Setting the Web Services Preferences 3. Set your GetMap pixel limits: • Max Width - Max Width specifies the maximum number of pixels for a GetMap request in the X direction. • Max Height - Max Height specifies the maximum number of pixels for a GetMap request in the Y direction. The GetMap request is designed to retrieve the highest resolution map image as is necessary to render the image on the screen, for a printer, or for an export file.
Chapter 4: Configuring MapInfo Professional Preferences Note: When you set the time out values locally, you may want to keep in mind the size of your request. The more complicated your request, the more time may be required for connection/sending/receiving. • Connect Timeout - Use this setting to indicate the amount of time to establish an Internet connection to the service. If the request takes longer than this value, a timeout occurs. The default connect time out is 60 seconds.
Setting the Web Services Preferences Setting the Library Services Preferences To set your preferences for working with Library Services: 1. On the Options menu, point to Preferences and click Printer to open the Web Services Preferences dialog box. 2. Click the Library Services tab. 3. Click Server. 4. In the Library Service Preferences dialog box, set a new Server URL (and timeout values) to work with, or change the timeout values for the sever that you are currently working with.
Chapter 4: Configuring MapInfo Professional Preferences MapInfo Manager Authentication Handling within MapInfo Professional For setting up security and expected MapInfo Manager behavior, consult with your MapInfo Manager administrator and refer to the MapInfo Manager version 1.2 documentation at: http://reference.mapinfo.com/software/mapinfo_manager/en/1_2/?helpId=security Setting the Custom Proxy Server Preferences You can configure MapInfo Professional for proxy server use.
Setting up a Geocoding Server After you add geocoding servers to MapInfo Professional, this dialog box shows your default server. 2. Click Servers to open the Geocoding Servers List dialog box. This list is empty by default until you add a geocoding server either using the Servers button in the Geocode Using Server dialog box or in the geocoding web services preferences. Note: Set the server that you will use the most as your default, by highlighting it in the list and clicking Set Default.
Chapter 4: Configuring MapInfo Professional Preferences 4. Type the service URL and description in the fields provided. You can connect to either a MapMarker or Envinsa geocoding service by making a selection in the Type of Service drop-down list. When you select an Envinsa service, enter a user ID and password in the fields provided. Select the Remember Password check box to save the password in encrypted format in the server list. This option is selected by default.
Setting Your Performance Preferences needs to access the server. You need to enter this information only once per server. To set the routing server preferences, see Setting the Routing Server Preferences. To add a Routing server: 1. On the Options menu, point to Preferences and click Web Services to open the Web Services Preferences dialog box. 2. On the Routing tab, click Servers to open the Routing Servers List dialog box. 3. Click Add to open the Routing Server Information dialog box. 4.
Chapter 4: Configuring MapInfo Professional Preferences 3. Click OK to close the dialogs and save your settings. When concurrency is set, MapInfo Professional divides the processing to multiple cores that simultaneously perform the operation. Setting Your Style Preferences The Style preferences allow you to preset the look of your objects regions, text, and lines. To set the default style preferences: 1. In the Options menu, click Preferences and then Styles to open the Styles Preferences dialog box.
Setting Your Address Matching Preferences Click the Region, Symbol, Line, and Text buttons to set these style options. These selections will serve to create the default settings for these style elements. • Enhanced Rendering Defaults for New Windows Click this check box to apply anti-aliasing and object translucency options. Smooth Text & Labels - Use this drop-down list to select Anti-Aliasing to smooth your labels and text.
Chapter 4: Configuring MapInfo Professional Preferences To see the results of this setting, refer to Reprojecting a Raster based on a Vector Map in the Help System. To set the raster reprojection options for all registered raster files: 1. On the Options menu, point to Preferences and click Image Processing to open the Image Processing dialog box. You can also open the Image Processing dialog box by clicking Image Processing in the Map Options dialog box. 2.
Setting Your Map Window Preferences To set the frequency of product updates and notifications from MapInfo Professional: 1. On the Options menu, point to Preferences and click Notifications to open the Notifications dialog box. 2. Select from the following options: • Check for new maintenance patch once in – Select this check box and type a number (in days) to enable MapInfo Professional to check for maintenance patches and other updates. Clear this check box to disable checking for any new patches.
Chapter 4: Configuring MapInfo Professional Preferences There are several tabs of preferences: • Display tab - preferences for when resizing a Map window, applying clip region use, and various display settings. • Editing tab - a warning message before loss of map information, how to move duplicate nodes in layers, digitizing options, and find selection options.
Setting Your Map Window Preferences The Apply Clip Region Using choices sets how you want MapInfo Professional to clip regions. • Windows Device Clipping (all objects) - The clipping is controlled by the Windows Device Display. All objects (including points, labels, text, and raster and grid images) will be clipped at the Clip Region boundary. This is the default setting. • Windows Device Clipping (no points, text) - Use this method to emulate the Erase Outside clipping method.
Chapter 4: Configuring MapInfo Professional Preferences The Move Duplicate Nodes in group of choices specifies whether MapInfo Professional will move duplicate nodes when you use the Reshape command (on the Edit menu, click Reshape) to edit objects that are adjacent to each other, such as regions. • Choose None of the Layers to prohibit the product from moving duplicate nodes.
Setting Your Map Window Preferences • Military Grid Reference System - Choose this option to display your Map using the Military Grid Reference System format. Coordinates are converted to the Military Grid Reference System format using the World Geodetic System (WGS) of 1984 Ellipsoid. • US National Grid Reference (NAD 83/WGS 84) - Choose this option to display your map using the United States National Grid (USNG) reference system format.
Chapter 4: Configuring MapInfo Professional Preferences • Bar Type - Select a preset scale bar: Check Bar, Solid Bar, Line Bar, or Tick Bar. • Add Cartographic Scale - Check this check box to include a representative fraction (RF) with the scale bar. In MapInfo Professional, a map scale that does not include distance units, such as 1:63,360 or 1:1,000,000, is called a cartographic scale.
Setting Your Browser Window Preferences • Only when Layout window is active - Display the contents of a frame only when the Layout is the active window. • Never - Display only the file name and frame type even when the Layout is the active window. Choose this option when you are resizing and repositioning frames, so that the contents of the frames do not redraw when you make a change. 5.
Chapter 4: Configuring MapInfo Professional Preferences By default, the Title Pattern is "# Legend", where `#' is the name of the layer on which the frame is based. So, if the frame is based on the States layer, the default pattern title would be "States Legend." You can change this pattern to "Legend of #" or simply "#." To have no default pattern, leave the box blank. Note: When the # symbol is in the Title, Subtitle, or Style Name pattern, it is replaced with the layer name.
Setting Your Printer Preferences • Guideline Color - Select a color to display the guidelines within the Legend Designer canvas (guidelines are for aligning legend frames to a position of your choosing). The default color is Blue (RGB = 0, 0, 255). 5. Automatically save legends to workspaces, by checking the Prompt Save Workspace Prior to Close check box. Selecting this always saves legends to a workspace along with the rest of your work when closing MapInfo Professional. 6.
Chapter 4: Configuring MapInfo Professional Preferences 2. Choose either: • Windows Default - This displays the path to the default printer specified for your operating system. This is the default setting. • MapInfo Preferred - This lets you set a different default printer when printing while using MapInfo Professional. This can be a printer or a plotter. 3. If you chose MapInfo Preferred: • Select the name of the printer, from the Size drop-down list, to use as the default printer.
Setting Your Output Setting Preferences • On the File menu, point to Print. You can change the printer you are using in the Print dialog box, overriding the default printer settings. • On the File menu, point to Page Setup. In the Page Setup dialog box, click the printer to display the Preferences dialog box for the default printer. Select a different printer in the Name drop-down list. This will override the default printer set in the Printer preferences.
Chapter 4: Configuring MapInfo Professional Preferences The following sections explain the display settings, the printing options, and window export options in Output Preferences dialog box. Some of the options appear in more than one dialog so we have grouped all of the same explanations together. Display tab (Output Preferences) The Display tab sets the on-screen display options for raster or grid files.
Setting Your Output Setting Preferences or exporting. This check box is checked by default. Clear this check box to let the printer or Windows export functions handle this. • Scale Patterns - Select this check box to match the non-transparent fill patterns in your print output to more closely match what you see on your screen. This check box is checked by default. Clear this check box to let the printer driver have exclusive control over rendering the pattern fills.
Chapter 4: Configuring MapInfo Professional Preferences • Use ROP Method to Display Transparent Raster - When the ROP method is selected, the transparent image is rendered using a raster operation (ROP) to handle the transparent pixels. This method is used to draw transparent (non-translucent) images on-screen.
Understanding Your Data You cannot work for long in MapInfo Professional without wanting to add more or enhance your own data in some way. This chapter teaches you how to get the most from your MapInfo tables and how to create reports with your data. In this section: • • • • Working with MapInfo Tables . . . . . . . . . . . . . . . . . . . . .130 Creating a Report of your Data . . . . . . . . . . . . . . . . . . . .140 Opening an Existing Report . . . . . . . . . . . . . . . . . . . . . .
Working with MapInfo Tables Working with MapInfo Tables After you have brought your data into MapInfo and created .tab files, you can manage them within MapInfo Professional. You can view any database table in MapInfo Professional, once you have converted it to MapInfo format. Additionally you can add or remove fields, change the order, name, type, width, or index of any field. You can also specify or determine the projection of the table from this dialog box.
Chapter 5: Understanding Your Data In this case, the most likely descriptive field contains the state name or an abbreviation for the state name. Thus the STATES table might have a field called Abbr, containing the abbreviation of the state name, and SALES might have a field called State, that contains the state abbreviation.
Working with MapInfo Tables 6. Click OK. MapInfo Professional creates a query table of the southeastern states with the District column containing the value Southeast. 7. Save the table to preserve the new information. Appending Rows to a Table Use the Append Rows to Table command to attach the records from one table to another. The two tables should have the same set of columns in the same order. To append data to another table: 1. On the Table menu, click Append Rows to Table. The dialog box displays. 2.
Chapter 5: Understanding Your Data The column to update is LAST, and we get the Value from the column that has the full name in it. Remember we are only working with one table, so the Table to Update and Get Value From Table should be the same table. In the following example, the table is TABLE1 and the full name column is your_full_name_column. You should fill in your own values for these two items. 4. To parse the first name out of the full name column, choose the Table menu and click Update Column.
Working with MapInfo Tables The Column to update is: LAST The Value is: Right$(LAST, Len(LAST)-Instr(1,LAST," ")). 6. To parse the middle name out of the full name column, on the Table menu, click Update Column. Fill in the Update Column dialog box. Update the MIDDLE column with the Value: Left$(LAST, Instr(1,LAST," ")) 7. Then update the LAST column again by returning to the Table menu, clicking Update Column, and filling in the dialog box. 134 MapInfo Professional 12.
Chapter 5: Understanding Your Data The Value is: Right$(LAST, Len(LAST)-Instr(1,LAST," ")) 8. Click OK to update the column. Placing Graphic Information in Visible Columns Update Column is also useful to put graphic information into columns so that it is visible. Tables that contain map objects store the graphic information about these objects invisibly. Using Update Column, you can bring some of that information into a column so it can be viewed in a Browser.
Working with MapInfo Tables Creating a New Table You can bring in data tables from several outside sources: dBASE, Excel, Access, Lotus 1-2-3, shapefiles, Grid, comma delimited, and delimited ASCII. You can also create your own database directly in MapInfo Professional. These databases can be opened and displayed as maps (providing they contain graphic objects), Browsers, or graphs. To create a table in MapInfo Professional: 1. On the File menu, click New Table. The New Table dialog box displays. 2.
Chapter 5: Understanding Your Data 5. Choose Add Field to begin adding new fields to the database's structure. Give the field a name, type, width, and specify whether the field will be indexed. 6. Continue to add fields until you have the structure you want. 7. Use the Up and Down buttons to reorder the fields. Keep in mind that the order of fields in this dialog box (top to bottom) will actually display as columns (left to right) in the Browser window. 8. Choose Create.
Working with MapInfo Tables The Table is Mappable option in the Modify Table Structure dialog box allows you to modify a table so you can map it or, when left cleared, it will ungeocode your table. To change the structure of the table: 1. Choose Table > Maintenance > Table Structure. The View/Modify Table Structure dialog box displays. 2. Click the View/Modify Table drop-down list, a list of available tables displays. 3. Choose the table you want to modify. 4. Click OK.
Chapter 5: Understanding Your Data This option removes deleted records, making the table smaller, and increasing processing speed. Pack Graphic Data This option packs only graphic information. Pack Both Types Of Data Both graphic and textual information are packed. 4. Click OK. Note: Packing a table can corrupt customized labels saved to a workspace. If you are going to be working with customized labels, pack the table before you create the labels.
Creating a Report of your Data Browsing a Table There are times when viewing the tabular data in a table is necessary. In MapInfo Professional, this is called browsing the table. To browse a table: 1. On the Window menu, click New Browser Window. 2. Choose the table you wish to browse and click OK. The Browser shows the fields of the data table (column headings) and the records of data (rows). A Browse menu item gives you further functionality.
Chapter 5: Understanding Your Data Opening an Existing Report To open an existing report: 1. Choose Tools > Open Report. The Choose Crystal Report dialog box displays. 2. Select the report from the dialog box. Saving a Report When you save a report, an .rpt extension is assigned to the report. The report is assigned the default name: (tablename) report.rpt. You may rename the report using the Crystal Reports Save As feature. All .
Graphing Your Data The graphing feature in MapInfo Professional lets you create a myriad of different graphs from three-dimensional bar graphs to exploded pie graphs. Each type of graph has its own set of features that you can customize to emphasize a particular piece of information, or create the aesthetic look you want for your graph. These features, plus additional formatting options, give you full control over the look and content of the graph.
Selecting the Right Type of Graph Selecting the Right Type of Graph What do you need your graph to tell your audience? The answer to this question determines the type of graph you should select. In MapInfo Professional, you can choose from 10 different graph types. Each type of graph includes at least one graph template that you can use to create your graph. Each graph type, with a brief description of each template, is explained in the next section.
Chapter 6: Graphing Your Data • 3D Floating Cube - Each value being measured, such as population, is displayed as a cube. The value is indicated by the placement of the cube in the graph. Cubes that have higher values appear to float within the graph. • 3D Floating Sphere - This graph is the same as the 3D Floating Cube, except that each value being measured is displayed as a sphere.
Selecting the Right Type of Graph • Percent - The percent column graph is a column-graph representation of a pie graph. Each group calculates the percent of the total required for each series. The axis goes from 0 to 100%. • Stacked - The stacked column graph shows stacked groups of columns. Each stack is made up of all series in this group, added up to obtain a total. The axis is the total value of the cumulative points.
Chapter 6: Graphing Your Data • More than one independent variable. Surface Graphs Surface graphs display three dimensional data sets, where X and Y values determine the reference coordinates for Z values. • Surface - The surface graph displays all data points as a surface, like a rolling wave. • Surface with Sides - A variation of the surface graph, where the surfaces in the graph have solid sides.
Graphing Your Data 2. Click one of the graph types shown in the Graph group in the left pane. When you select a graph type, the templates for that graph type display in the Template group. 3. Choose a template from the right pane. Some graph types have several templates to choose from. Others, such as the bubble and scatter graph types, have only one template. 4. Click Next when you have selected a template. The Create Graph - Step 2 of 2 dialog box displays.
Chapter 6: Graphing Your Data graph and every item in the Graph window. The customizing options available depend on the graph type you have selected. Selecting Graph Objects To format a graph object, select it by clicking it. When you make a graph selection, you can also select related graph objects. For example, if you click a series bar in a column graph, then all the series bars and the corresponding legend marker are selected. If you select an axis label, all the labels on that axis are selected.
Graphing Your Data Layout and Display Go to the General Options command (on the Graph menu, point to General Options) to change the general options for the type of graph you are creating, as well as customize its display. The General tab displays options that enable you to customize the markers for the type of graph you selected. For 3D graphs, you can change the shape of the risers, and the gap between the risers.
Chapter 6: Graphing Your Data The Numeric Axis Grids & Scales dialog box (on the Graph menu, click Grids and Scales) is used to format graph axes, gridlines, and perform scaling. The tabs on the left of the dialog box indicate the available axes in the graph: Category Axis, Y1 Axis, Y2 Axis (for dual-axes graphs), X Axis (for bubble and scatter graphs), and Series Axis (for 3D graphs).
Graphing Your Data The text boxes next to those titles become available. You can use the default titles or create your own. Choose from these titles: • • • • • • • • Title - Displays the main title of the graph centered over the top of the graph. Subtitle - Displays the subtitle of the graph directly underneath the main title. Footnote - Displays a note at the bottom right hand corner of the graph.
Chapter 6: Graphing Your Data To format an individual series: 1. Click a riser (area, bar, line, marker, pie slice, etc.) or a legend marker to select a series. 2. On the Graph menu, click Series Options. The Series Options dialog box displays. 3. Make changes in each of the dialog box tabs and click OK. You can also apply changes as you go by clicking the Apply button. Apply saves your changes to the graph without closing the dialog box.
Working with Multi-Table and Multi-Variable Graphs Working with Multi-Table and Multi-Variable Graphs This section of the chapter provides some examples of ways you can customize your graphs. The first example illustrates some of the ways you can customize a pie graph. The second example demonstrates how you can customize a 3D graph using the 3D viewing angle feature. Exploding a Pie Graph Creating a basic pie graph is easy using the Graph wizard. Simply select the table and the fields you want to graph.
Chapter 6: Graphing Your Data 3D Graphs - Using the 3D Viewing Angle The 3D Viewing Angle feature displays your 3D graph at different angles, as well as customize other aspects of the graph's position, such as its rotation and position in the Graph window. The following 3D graph shows the same selection from the table that was used in the pie graph, but graphs different columns from the table. This example rotates the angle of the 3D graph and the changes the thickness of the walls of the 3D cube.
Working with Multi-Table and Multi-Variable Graphs Use the controls along the bottom of the graph preview to scroll through the preset viewing angles. You can also select one from the drop-down list. Rotating Your 3D Graph Use the options Rotate, Pan, Walls, and Move at the lower right of the dialog box to manipulate the graph. In the Rotate tab, you can click directly on the arrows to rotate your graph in the direction indicated by the arrow. A preview of the graph in its new position displays above.
Chapter 6: Graphing Your Data Customizing Cube Walls The Walls tab helps you change the dimensions of the 3D graph walls. You can alter the length and thickness of the walls directly using the arrow keys on the wall image on the left side of the tab, or use the X, Y, and Z buttons. Moving Your 3D Graph at an Angle The Move tab options are used to move the graph diagonally across the window.
Working with Multi-Table and Multi-Variable Graphs Above, the same graph that was shown earlier is displayed here using a different preset angle. The walls of the cube have also been removed, as well as the values for the Value Axis, in the Display Status tab of the General Options dialog box. All of the 3D Viewing Angle options have been used in this graph. The graph has been rotated about 90 degrees from the earlier example. The Pan and Move options have also been used to position the graph.
Chapter 6: Graphing Your Data The selection in the Graph window uses the same pen and brush styles that are used to highlight selected objects in the Map window. Using the Graph Select Tool When you select objects in a Graph window using the Graph Select tool, you also change the current selection in the graphed table. Your Graph window selection must correspond to a row in the table. Your Graph window selection will be reflected in the Map or Browser window. To select rows in the table being graphed: 1.
Using Graph Templates Each type of support file stored in the GraphSupport directory is listed in the next table, according to the name of the folder in which the files are stored: Folder Name File Description 3D Viewing Angles Files correspond to the preset viewing angles available in the 3D Viewing Angle dialog box (on the Graph menu, click 3D Viewing Angle).
Chapter 6: Graphing Your Data Note: You can save a template file to a location other than the GraphSupport\Templates directory; however, it will not be available unless you save it to a folder in the Templates directory.
Working with Data in a DBMS MapInfo Professional lets you access data where it lives, on your machine or on the network, in flat files, such as Microsoft Excel files or MapInfo Professional native (.tab) files, in a Database Management System (DBMS), or from a web service. This section addresses the special circumstances that surround accessing data from a SQL Server, Oracle Spatial, or PostgreSQL with PostGIS database for use with MapInfo Professional, which requires setting up a database connection.
Getting Started Getting Started To access data from a DBMS, you need to set up a connection to it. In addtion, any DBMS tables that contain spatial data that you want to see on a map must have a record created for them in a special table called the MapInfo Map Catalog. This record contains information about the spatial data. The process of creating this record is called "making the table mappable". An overview of the setup process is provided under Overview of the DBMS Access Setup Process.
Chapter 7: Working with Data in a DBMS 2. Creating a Map Catalog in the DBMS to Work with Data Your database administrator may need to grant you specific access privileges to the database to work with the data. The following section gives details: • Before you Begin Creating a Map Catalog Table. 3.
Creating a Data Source Connection version that MapInfo Professional supports. For non-Windows databases, such as Oracle and PostgreSQL with PostGIS, consult with your database administrator for information on how to obtain and install the driver provided with your database. You can create a data source connection: • Through MapInfo Professional's interface. • Through EasyLoader's interface, see the EasyLoader User Guide.
Chapter 7: Working with Data in a DBMS 4. In the Create New Data Source wizard: a. Select the type of data source to create: User Data Source or System Data Source. Make a selection to display the description for it in the wizard. Click Next to continue. b. From the driver name list, select the SQL Server driver you have installed for the database and then click Next. c. Click Finish. 5. In the Create a New Data Source to SQL Server wizard set the following.
Creating a Data Source Connection b. In the next screen, select how SQL Server will verify the authenticity of the login ID. Optionally select to connect to SQL Server to obtain default settings for more configuration options. Click Next. c. Keep the default settings (check with your database administrator) and click Next. d. Keep the default settings (check with your database administrator) and click Finish. 6. In the ODBC Microsoft SQL Server Setup dialog box, click Test Data Source. 7.
Chapter 7: Working with Data in a DBMS Creating a Data Source Connection to PostGIS Before you begin, you need a PostgreSQL ANSI ODBC driver (psqlODBC) installed on your machine. Check with your database administrator to install the driver for your database. Ensure that your database administrator adds your machine IP address to the pg_hba.conf file for the database you want to connect to.
Creating a Data Source Connection 4. In the Create New Data Source wizard: a. Select the type of data source to create: User Data Source or System Data Source. Make a selection to display the description for it in the wizard. Click Next to continue. b. From the driver name list, select the PostgreSQL ANSI driver and then click Next. c. Click Finish. 5. In the PostgreSQL ANSI ODBC Driver (psqlODBC) Setup dialog box, set the following.
Chapter 7: Working with Data in a DBMS Creating a Data Source Connection to Oracle Before you begin, you will need the following installed on your machine: • Oracle Client - connects to an Oracle database. • TCP\IP - a communications protocol required by Oracle Client to communicate on the network • Oracle SQL*Net - for performing SQL queries to the database (optional). Have your database administrator check that the: • tnsnames.
Reconnecting to your Data Source after Startup Creating a Data Source Connection to Microsoft Access You can work with your Microsoft Access database from MapInfo Professional through an ODBC connection. Microsoft Access does not allow spatial data, but you can display in MapInfo Professional data that has X and Y coordinate values associated with it.
Chapter 7: Working with Data in a DBMS To open a connection to your database: 1. From the File menu, select Open DBMS Connection. 2. If the Open DBMS Connection dialog box displays, select ODBC from the list and then click New. 3. In the Select Data Source dialog box: a. Select the Machine Data Source tab. b. From the Data Source name list, select your connection name. c. Click OK. You may see a login dialog box for your database connection.
Reconnecting to your Data Source after Startup 5. In the Open dialog box schema and tables in your database display. If you do not see this, then from the Files of type list, select your data source name. Select the table to open from the list and click Open. You are now ready to work with your table. Connecting to Oracle after Re-Starting MapInfo Professional To open a connection to your Oracle database: 1. From the File menu, select Open DBMS Connection. 2.
Chapter 7: Working with Data in a DBMS About Supported DBMS Data Types This section provides a list of supported data types and any data restrictions for SQL Server, PostGIS, and Oracle. SQL Server Data Support Read-Only Support for Spatial Objects in SQL Server with Z and M Values Spatial data that is stored in SQL Server Spatial Geometry and Geography field types may have Z and M values.
About Supported DBMS Data Types Oracle Data Support Working with Oracle Spatial Data MapInfo Professional uses Oracle Spatial for Oracle tables (XY is supported via OCI). MapInfo Professional does not support HH_CODE (and the old version of SDO index types).
Chapter 7: Working with Data in a DBMS From Oracle: GTYPES to MapInfo Professional 7 MULTIPOLYGON Geometry has multiple polygons (more than one exterior boundary). Region Geometry Conversions from Oracle Spatial to MapInfo Professional The following lists Oracle Spatial geometry types and what they convert to in MapInfo Professional.
Creating a Map Catalog in the DBMS to Work with Data The MAPINFO_MAPCATALOG is a registry table for databases that stores metadata about spatial tables and views in the database. Using the tablename and ownername as the key, the MAPINFO_MAPCATALOG identifies the spatial type, spatial columns (if there is more than one), projection, data bounds, and rendition information. The MAPINFO_MAPCATALOG is used by a number of MapInfo products, including MapInfo Professional, that access map data from databases.
Chapter 7: Working with Data in a DBMS • If there is no Map Catalog available for the current database, EasyLoader creates a MAPINFO user if one does not already exist and then creates the Map Catalog. This concludes the Map Catalog creation process. • If there is a Map Catalog, the Unregister tables from Map Catalog dialog box displays. Close this dialog box. There is already a map catalog in this database.
Adding a Spatial Primary Key to a DBMS Table If you want to convert your table to the MapInfo Professional native .TAB format to work with it, then use EasyLoader, which will also rename your geometry or point columns and add a spatial primary key column to the table. Adding a Spatial Primary Key Manually To have full control over renaming geometry or point columns and add a spatial primary key column to one or more tables, you can do this manually.
Chapter 7: Working with Data in a DBMS Making a DBMS Table Mappable to Display it on a Map After establishing a data source connection to your DBMS and adding a geometry reference to the tables you wish to work with, you can begin working with the data in MapInfo Professional in tabular form (in a Browser window). To view the data on a map in MapInfo Professional, you must correctly name the spatial data goemetry or X,Y columns and then make the table mappable.
Making a DBMS Table Mappable to Display it on a Map Index Type Select the spatial index type of the column that has the spatial information in the DBMS table. The spatial index provides a fast way for MapInfo Professional to access the spatial data in the table. The seven index types to choose from are SpatialWare, Oracle Spatial, Oracle Annotation Text, SQL Server Spatial, PostGIS Spatial, MapInfo Professional, and XY Coordinates. (You use the XY Coordinates option when there is no index.
Chapter 7: Working with Data in a DBMS If the Projection button is disabled, the application has read the projection information from the Oracle metadata and will use that projection to display the file. Table Bounds Opens the Set Table Bounds dialog box, which lets you choose the options that determine how your default view and your entire view table bounds are calculated. The bounds options you specify in this dialog box define both views.
Deciding to work with Linked or Live Access Tables area that is the initial map display. If the live access table is being added as a layer to an existing Map window, the layer will be fit to that Map window. MapInfo Professional stores information about a live access table in a TAB file. This information is known as metadata. MapInfo Professional uses metadata to store information about the live access table that is needed to manage transactions between MapInfo Professional and the server database.
Chapter 7: Working with Data in a DBMS For more information, see Improving Live Access Performance in the Help System. Opening a DBMS Table in MapInfo Professional After completing the instructions in the following sections: • Creating a Data Source Connection • Creating a Map Catalog in the DBMS to Work with Data • Making a DBMS Table Mappable to Display it on a Map you are ready to connect to your data sources and the database tables you want to work with.
Opening a DBMS Table in MapInfo Professional To open a database table: 1. Select File > Open. 2. In the Open dialog box, from the Files of type list, select the DBMS connection to work with. The DBMS connections that you created previously (as described under Creating a Data Source Connection) are at the bottom of the Files of type drop-down list. If you have more than one connection, then the connection name contains a sequential number indicating the order in which the connection was added.
Chapter 7: Working with Data in a DBMS Creating a New DBMS Table To create a new DBMS table: 1. Choose File > New Table. 2. In the New Table dialog box: a. Specify how you want the table opened: Browser, Mapper, or Current Mapper. b. Specify whether you want the table structure to be based on an existing table or you want MapInfo Professional to create a new table structure. c. Click Create. 3.
Opening a DBMS Table in MapInfo Professional If you are using the structure from another mappable table, then MapInfo Professional sets the new table projection to the projection of the source table. Collectively, this information is the structure of your database. Note: You indicate whether the table is mappable by associating graphic objects with records and, if so, whether the map is to be an earth or a non-earth map. 4.
Chapter 7: Working with Data in a DBMS • Index Column - Specify the primary spatial index column from the list. This option is always available, except when the index type is XY. • X Coordinate - Specify the X or longitude column in the database from the list. This is only available for MapInfo (MICODE) or XY types. You can either choose a float column that was specified in the New Table Structure dialog box or specify a new column by typing into the combo box's edit control.
Opening a DBMS Table in MapInfo Professional 1. On the Table menu, select Maintenance and then Unlink DBMS Table. 2. In the Unlink Table dialog box, select the name of the table to unlink and then click OK. The specified table unlinks. Saving a DBMS Table You save changes to a MapInfo Professional linked or live table the same way you save a regular MapInfo Professional table, with the Save Table menu option. Saving a linked or live table saves the records on the remote database.
Chapter 7: Working with Data in a DBMS Original DBMS Shows the original data as it appeared when extracted from the database. If the original data is too long and does not fit into the list box, a truncated representation will be shown instead. Its full value can be displayed in the Original field. Current MapInfo Professional Shows the data as it appears in the MapInfo Professional linked table you are trying to save.
Opening a DBMS Table in MapInfo Professional The Stop Commit button terminates the entire update. A second dialog box confirms that this is what you really want. Automatic The Automatic button causes the interactive conflict resolution to end. A dialog box displays to allow you to select the automatic conflict-resolution modes you want to use for the remainder of this update. You can select one two automatic modes from the dialog box.
Chapter 7: Working with Data in a DBMS 3. In the Change Table Object Style dialog box, specify new style attributes for the objects in the selected table. 4. Refresh the linked table for the style change to take effect. Working with Remote Tables from Specific Databases You can specify whether to load and work on an entire table or only specific columns or rows from a table.
Working with Remote Tables from Specific Databases Working with SQL Server with SpatialWare Tables SpatialWare is a Pitney Bowes Software Inc. Corporation product that helps users store, access, manage, and manipulate spatial data as a standard part of their business data. You can query both spatial and non-spatial data within a single SQL Server query using SpatialWare. All of the strengths of SQL Server as a relational database are extended to spatial data using SpatialWare.
Chapter 7: Working with Data in a DBMS • For Spatial Geometry types with Line Objects Only: If you have created a map that contains line objects only and you are trying to save to PostGIS, this message displays: Arc is an unsupported object. Convert to polylines? Click Yes to convert the unsupported objects to polylines; you would select No to decline to convert the unsupported objects. If you decline, you cannot save the map you have created to the SQL Server Spatial database.
Working with Remote Tables from Specific Databases Oracle Spatial Requirements To connect to Oracle Spatial within MapInfo Professional, you must have the Oracle Spatial or Oracle 9i and 9i release 2, or 10G client installed. See your Oracle documentation for detailed information. Primary Key used for New Table Creation or When Saving a Remote Copy An Unique key ensures that an entry does not match any other entry from a different record. If a record does not contain any value, no error is reported.
Chapter 7: Working with Data in a DBMS 1. Open a remote DBMS connection and select a live table for display. 2. From the Map menu, click Create Legend to display the Create Legend - Choose Layers dialog box. 3. Select a layer to create a legend from and click Next to display the Create Legend - Legend Default Properties dialog box. 4. Click Next to display the Create Legend - Frame Properties dialog box. 5. In the Styles from box, there are three options.
Working with Remote Tables from Specific Databases If you try to save a map with unsupported spatial geometry types in Oracle, these are the results: • Spatial Geometry Types with All Unsupported Objects: If you have created a map that might contain all of the unsupported objects and you are trying to save to Oracle, this message displays: Table has unsupported objects (rounded rectangles, rectangles, ellipses or arcs).
Chapter 7: Working with Data in a DBMS exists. If so, the user will connect. All references to a user authenticated by the Operating System must include the prefix, OPS$, as seen in the example OPS$tsmith. The default value of this parameter is OPS$ for backward compatibility with previous versions of Oracle databases. However, you might prefer to set the prefix value to some other string or a null string (an empty set of double quotes: " ").
Drawing and Editing Objects The drawing and editing capabilities in MapInfo Professional allow you to create and customize an unlimited variety of objects for your maps. Easy-to-use drawing tools and commands are accessible from the Drawing Toolbar. You can also display nodes, line directions and centroids to give you better control when editing objects. In this section: • • • • • Understanding the Drawing and Editing Tools . . . . . . .202 Drawing Objects . . . . . . . . . . . . . . . . . . . . . . . .
Understanding the Drawing and Editing Tools Understanding the Drawing and Editing Tools MapInfo Professional has a complete set of drawing tools and editing commands. These tools allow you to draw and modify objects on your map. You can also use these tools to customize the colors, fill patterns, line types, symbols, and text on your map. However, these tools and commands give you more than the ability to modify your map.
Chapter 8: Drawing and Editing Objects The maximum number of nodes for regions and polylines is 1,048,572 nodes for a single polygon region or polyline. The limit drops by seven nodes for every two additional polygons. To add a node: 1. 2. 3. 4. On the Drawing Toolbar, click the Add Node button. Move the cursor to the point on the segment where you want to add a node. Click to add the node. Press the Backspace key to delete the last node added. On the Edit menu, point to New Row.
Drawing Objects 1. Make the layer containing the map object editable. Choose Map > Layer Control and click the Editable icon to make the layer editable. 2. Select the map object. 3. Do one of the following: • Choose Edit > Get Info. • Double-click the map object with the Select tool. The Object Attributes dialog box displays. 4. Type in attributes as appropriate. 5. Click OK. Use the Help search option to locate information for a specific map object (for example, Arcs, Points, Polygons etc.).
Chapter 8: Drawing and Editing Objects Object Styles MapInfo Professional draws objects using the default color, fill pattern, line type, symbol, and text settings for the layer you are drawing on. The default style can be set in the Styles Preferences dialog box. To change the style of an existing object: 1. Choose Map > Layer Control and click the Editable icon to make the layer editable. 2. Select the object and choose the appropriate style command from the Options menu.
Drawing Polygons and Polylines You can delete the last node by pressing the Backspace key. Note: If there is only one node left in the object it will not be deleted. You can then use the Combine command to combine this region with another, reshape the region, etc. Polylines are made up of multiple line segments that are treated as one object. Unlike lines created with the Line tool, you can smooth polylines into a continuous curve using the Smooth command.
Chapter 8: Drawing and Editing Objects 5. Continue until you have traced the entire polygon/polyline and right-click to end. Note: Autotrace only one object at a time; clicking nodes in different objects will produce a straight line between the two nodes. Converting a Polyline to a Region To convert a polyline into a region: 1. Make the Map window active. 2. Choose Map > Layer Control and click the Editable icon to make the layer editable. 3. Select the polylines you want to convert to a region. 4.
Drawing Symbols Drawing Symbols Symbols on your maps make your map more expressive and easier to understand. This section explains how to change a style currently used by MapInfo Professional and create your own custom symbols. We also discuss in detail the rules governing symbols. To draw symbols, make the layer you want to draw the symbols to editable and choose the Symbol tool. Place the cursor where you want the symbol to be and click. The symbol displays using the default symbol style settings.
Chapter 8: Drawing and Editing Objects • • • • • • • • MapInfo Transportation MapInfo Real Estate MapInfo Miscellaneous MapInfo 3.0 Compatible Symbols (vector symbols, available as a True Type font in MapInfo Professional): the 36 shapes from the MapInfo symbol set MapInfo Oil & Gas MapInfo Weather MapInfo Arrows Installed font symbols: symbols available from the installed fonts that offer a symbol set • ERS Fonts (For more about these fonts, see Homeland Security Symbols in the Help System.
Working with Text on the Map The Dispersed Groups symbol font gives you a way to display symbols that represent different organizations, events, or services that occupy the same coordinate location without overlapping each other. When you zoom out from the coordinate point, these symbols display around the coordinate point side by side. This font is installed when you install MapInfo Professional.
Chapter 8: Drawing and Editing Objects Editing Objects 1. In all likelihood, you will need to change or edit some of the objects you have drawn or mapped. To begin this process, you need to make the layer that you want to change editable (on the Map menu, click Layer Control, and then click the Editable icon for the layer). To edit an object: 1. Select the object with the Select tool. If the object is a line, edit handles appear at either endpoint.
Working with Text on the Map 4.
Chapter 8: Drawing and Editing Objects When you click Cartesian, MapInfo Professional calculates the copy/move distance by considering the data to be projected to a flat surface and distances are measured using Cartesian distance calculations. 6.
Working with Text on the Map • Click the Pick from Map button and click the anchor point you want on the Map or Layout window. Click the mouse button only once to establish this point. Note: When the Pick from Map button is disabled, you can select locations directly from the open map. If a map is not open, you can select another tool (like the Select tool) and use that tool instead of the Pick from Map functionality. To return to the default anchor point, click the Reset Anchor button. 2.
Chapter 8: Drawing and Editing Objects If the layer is Selectable but not editable, you can only view these attributes. If the layer is also editable, then you can change these attributes by typing new values into the text boxes of the dialog box. The illustration above shows the Object Attribute dialog box for a region object in an editable layer. You can also access this dialog box on the Edit menu (click Get Info).
Working with Text on the Map 1 Select the object. Click Reshape mode to display the nodes. 2 Select the nodes you want to copy. 3 Choose Copy and Paste to display the new objects with edit handles (small squares). 4 Click and drag the object to move to another location. To reshape an object (such as the state of Kentucky): 1. Select Kentucky to enable Reshape mode. 2. Select the first node with the Select tool. Shift-click the last node to be copied.
Chapter 8: Drawing and Editing Objects objects, ellipses, and rounded rectangles. You set the Snap in one window at a time and can save it with your workspace. Snap to Nodes applies to all selectable layers-this is useful if you are drawing an object in one layer and want to attach it to an object in another layer. If you do not want to snap to objects in certain layers, make those layers unselectable.
Working with Text on the Map In most maps, nodes of various objects are usually connected, especially for adjoining streets and boundaries that share a common border. Using the Move Duplicate Nodes Option under Map Window Preferences, you can specify where MapInfo Professional looks for connected nodes in order to move them in unison. Choose the None of the Layers button to turn the option off. Choose the Same Layer button so that connected nodes in the same layer are moved when one of them is moved.
Chapter 8: Drawing and Editing Objects AutoTrace entry in Status Bar. Smoothing and Unsmoothing Lines You can use the Smooth command to convert polyline angles into polyline curves. To smooth a polyline angle into a polyline curve: • Click a polyline with the Select tool and on the Objects menu, click Smooth. MapInfo Professional smoothes the line so that it appears to be one continuous line with curves instead of angles.
Working with Text on the Map When you merge the layers from the source map on top of the destination map, the destination map settings take precedence. This means that the clip regions and coordinate systems, for example, are based on the settings in the destination map. If the destination map does not allow raster reprojection and the source map has a raster layer, the coordinate system of destination map could change. Consider this example of a vector map and a raster map.
Chapter 8: Drawing and Editing Objects • For more information, see Merging Maps using the Drag Map Window Tool and Merging Maps from Layer Control in the Help System.
Selecting and Querying Data This chapter presents the ins and outs of selecting records from tables. As you use MapInfo Professional you will find yourself selecting records quite often. This chapter covers an overview of selecting and querying methods using tools from the Main toolbar. In this section: • Selecting Your Data in MapInfo Professional . . . . . . . . .224 • Querying Your Data in MapInfo Professional . . . . . . . . .
Selecting Your Data in MapInfo Professional Selecting Your Data in MapInfo Professional While MapInfo Professional allows you to attach data to objects on a map, its true analytical power is its ability to group and organize data. Once your data is broken down into logical groups, you can analyze it based on one or more variables. For example, you have a basket of fruit.
Chapter 9: Selecting and Querying Data Characteristics of Selections Selections are temporary tables. When you make a selection, MapInfo Professional creates this temporary table (called a selection) to store the records you have selected. You can perform many of the tasks with a selection table that you can perform with a permanent (base) table such as: • View it in a Browser, a Map (if it has graphic objects), a Graph, classic Layout window, or a Layout Designer window.
Selecting Your Data in MapInfo Professional • Selecting with queries: Select, SQL Select. When you select records with either of these methods, you create a logical expression that MapInfo Professional uses to select the records. For example, the expression SALES > 20000 means that MapInfo Professional will select only those records with sales higher than $20,000. We discuss Select and SQL Select in more detail in Using Select to Create Queries and Using SQL Select to Query Data). To import a GML file: 1.
Chapter 9: Selecting and Querying Data 1. Click the Select 2. Click the object. button in the Main toolbar. The layer where the object is located has to be selectable in the Map window. When an object is selected it is highlighted according to the settings you specified in Options > Preferences. • When the layer is editable, the selected object is surrounded by edit handles and is colored and patterned as it was originally defined. • When you select another object, the first object is unselected.
Selecting Your Data in MapInfo Professional • An object or remove it from the selection in a Map window, press the Shift key while clicking on the object. When you click, the object is removed from the selection set. • All objects, on the Query menu point to Unselect All, or click on the map where there are no objects. For additional information, see Moving Selected Objects and Rotating Selected Objects in the Help System.
Chapter 9: Selecting and Querying Data Using the Marquee Select Tool The Marquee Select selects objects within a rectangle. By clicking and dragging using the Marquee tool, you create a dotted rectangle, or marquee box around objects you want to select. All Selectable objects in the topmost Selectable layer will be included in the marquee box. Note: To select objects from another layer, you must turn off selectable in Layer Control for the upper layers. Only objects from one layer at a time are selected.
Selecting Your Data in MapInfo Professional 2. Choose the Polygon Select tool from the Main toolbar. The cursor becomes a pointing hand when moved over the Map window. 3. Click the map location at which you want to place the first end point of the polygon. Move the cursor over your map in any direction. MapInfo Professional draws a line from the point where you clicked to the cursor. 4. Click to create another endpoint.
Chapter 9: Selecting and Querying Data To cancel the selection of all selected objects, you can either click the Map window where there are no objects or choose the Unselect All command from the Query menu. Querying Your Data in MapInfo Professional A query is a mathematical question that you pose to your database to collect information. In MapInfo Professional, there are two query builders available under the Query menu, Select and SQL Select.
Querying Your Data in MapInfo Professional For instance, by formulating queries with Select, you can ask MapInfo Professional to: • Show only postal code regions where the average household income is above $65,000. • Show only postal code regions where the median age is 42. • Show only the postal code regions where the household income is above $65,000 and the median age is 42. • Show only records for all orders received in July or September.
Chapter 9: Selecting and Querying Data 7. Type the name of the refining boundary in this box. If MapInfo Professional cannot find an exact match for the object you specified, it lists possible matches. 8. Click Up or Down to move to other pages and choose a specific entry from the list. 9. Click OK and the find is initiated. You can also use the Find command to locate street intersections.
Querying Your Data in MapInfo Professional Making Queries using the Select Command MapInfo Professional has two commands for selecting objects through querying: Select and SQL Select. Select is simpler and SQL Select is more powerful. To make a query: 1. Choose Query > Select. The Select dialog box displays. 2. Click on the Select records from table drop-down list and choose the table from which to select the records. 3.
Chapter 9: Selecting and Querying Data 1. Open the table you wish to query, if you have not already done so. The table that you query is known as the base table. If you use SQL Select to perform a query on the World table, the World table is your base table. 2. Choose Query > SQL Select. Fill in the portions of the SQL Select dialog box that meet your needs. When you click OK, MapInfo Professional performs the query.
Querying Your Data in MapInfo Professional The Find Results in Current Map Window check box displays in both dialog boxes. If there are no open Map windows, this check box is disabled. You cannot save this check box setting to a template. This option is cleared by default. 2. Create your query and verify that it is correct, selecting the open table that you want to query. 3. Select the Find Results in Current Map Window check box to display the results. Click OK. 4.
Chapter 9: Selecting and Querying Data 1. Choose Query > Select. 2. In the Select dialog box, click the Assist button. 3. In the Expression dialog box, type your expression directly into this box, or choose from the drop-down list selections to create an expression. 4. Click Verify to verify that your expression is valid. 5. Click OK to return to the Select dialog box. 6. Click OK to run the expression.
Querying Your Data in MapInfo Professional Verify This button reviews the expression you have created and verifies that it is valid. This is particularly helpful if you are new to writing expressions. Using Select to Create Queries In general the process for selecting objects using Select is: 1. On the Query menu, click Select to display the Select dialog box. • • • • Select Records from Table - Select the table from which to select records. that Satisfy - Create the expression to select records.
Chapter 9: Selecting and Querying Data Type 90. Click Verify to confirm the syntax of your expression. Click OK to close the Verify dialog box. 5. Click OK to close the Expression dialog box. The Select dialog box redisplays. 6. Select the Browse Results check box. 7. Click OK. MapInfo Professional creates a Browser that contains the selections. Notice that the selections display in both the World map and Browser.
Querying Your Data in MapInfo Professional 3. On the File menu, click Save Copy As and save the Selection table. The table can be saved with any filename. Using SQL Select to Query Data A selection is a subset of data rows in a table, chosen based on the contents of one or more columns from the table. You create selections by formulating questions, or queries, about your data.
Chapter 9: Selecting and Querying Data Note: Expanding the text controls is no guarantee that the resulting query can be handled by MapInfo Professional. You can still receive the Query too complex error when adding larger queries. Example 1 - Computing Population Density Using Area In this example, we will use the world map to create a table of all the countries that have a population density of over 500 people per square mile.
Querying Your Data in MapInfo Professional We have now built the expression "Select all countries whose population density (pop_1994/Area(obj, "sq mi")) is more than (>) 500 people per square mile." 12. Leave the Group by Columns box blank. 13. Tab to the Order by Columns box and select Country from the Columns list. The Order by Columns box allows you to specify the order the records in the query table will display.
Chapter 9: Selecting and Querying Data 18. Click OK to create the following table. The first column contains the country name. The second column contains the population density. Note that the countries are listed in alphabetical order (Order By: Country) and the population density for each country listed is over 500 people per square mile (pop_1994/ Area(obj, "sq mi") > 500).
Querying Your Data in MapInfo Professional Using Date- and Time-Based Data in Maps and Queries If you maintain time- or date/time-specific data, you may be interested in querying that information and displaying it visually in your maps. Time and DateTime data types let you display that data thematically and as part of a query analysis.
Chapter 9: Selecting and Querying Data If you have existing data and want to add Time or DateTime content to it, check the following table to ensure that the data is in a format that MapInfo Professional can recognize as Time or DateTime. Table 1: Time and DateTime Data Formats Enter To Format for Time To Format for DateTime Date Not Applicable. yyyyMMdd Sets value to the specified Date at midnight. Time DateTime HHmmssfff. HHmmssfff Can also use the locale settings for a Time string.
Querying Your Data in MapInfo Professional Converting Date Time DateTime Sets value to Date portion of Sets value to Time portion DateTime value. of DateTime value. DateTime No conversion Additional Notes for Converting a String * to a Date If the year is last in the current Date format, you can omit it and MapInfo Professional will assume the current year. If the data specifies a two-digit year, MapInfo Professional assigns the century based on the current Date Window.
Chapter 9: Selecting and Querying Data For more about using math expressions with Time and Date information, see Using Arithmetic Operators with Time and Time/Date Data Types. 1. Click OK to update the new column with the Date and Time information. Creating Thematic Maps using Time and Time/Date Data Types For ranged thematic maps, Time values will be able to be rounded by seconds, minutes, and hours. The default is seconds.
Querying Your Data in MapInfo Professional Using Arithmetic Operators with Time and Time/Date Data Types You can use the addition and subtraction operators with the Time and Time/Date data types as follows: Data type Operator Data type Result Notes Time minus (-) Time Number The number represents the number of seconds between two times as a floating point number. The fractional part of the result represents milliseconds.
Chapter 9: Selecting and Querying Data The comparison operators are =, <>, <, >, <=, >= and should all work as expected for the Time and DateTime values. For Time values, the smallest Time is "12:00:00.000 AM" while the largest Time is "11:59:59.999 PM". The "Between" operator works as expected for DateTime values. For Time values, we support wrap-around comparisons.
Querying Your Data in MapInfo Professional When you save a MapInfo table to dBase format, the .tab file maintains the Time and DateTime types so that when you reopen it the data displays as either Time or DateTime. If you attempt to open these .tab files using a non-MapInfo application, these fields display as character fields.
Chapter 9: Selecting and Querying Data limited to creating one derived column. You can create as many derived columns as you want. Note that the more derived columns you create, the longer it will take MapInfo Professional to execute the query. You can also create derived columns based on the aggregate functions count, sum, avg, wtavg, max, and min. For example: • sum(Population) would give you the population for the entire world. • sum(Area(obj), "sq mi") would give you the area for the entire world.
Querying Your Data in MapInfo Professional SALES_REP MONTH SALES Cathy June 1400 Julie June 600 John July 1200 Cathy July 700 Julie July 1000 MapInfo Professional could also compute the total sales for each representative by specifying in the SQL Select dialog box: • Select Columns: SALES_REP, sum(SALES) • Group by Columns: SALES_REP SALES_REP sum(SALES) John 3300 Cathy 3000 Julie 2700 or MapInfo Professional could compute the average sales for each representative: • Select Column
Chapter 9: Selecting and Querying Data • Average (expression): calculates the average of the values in for all the records in a group. • WtAvg (expression): calculates the weighted average of the values in for all the records in a group. • Max (expression): finds the highest value in for all records in a group. • Min (expression): finds the lowest value in for all records in a group. For more about grouping and ordering your data, see the Help System.
Querying Your Data in MapInfo Professional Us_custg.order_amt > 10000 Select * from Us_custg,States,City_125 where Us_custg.state = States.state and Us_custg.order_amt > 10000 and States.state = City_125.state Note: Some of the data used in this example is from the MapInfo Professional Tutorial, which is only available from the Pitney Bowes Software Inc. web site, http://go.pbinsight.com/webtutorials.
Chapter 9: Selecting and Querying Data Object A contains Object B Object A contains Object B Object B within Object A Object B within Object A Object A contains Entire Object B Object B entirely Within Object A Object A intersects Object B Object B intersects Object A In each case, object A contains object B because the centroid of object B is inside the boundary of object A. However, in the cases at the left and in the middle, part of object B is outside the boundary of object A.
Querying Your Data in MapInfo Professional CountyName Pop_1980 Pop_1990 Order # Customer County Foster 23,789 27,135 478001 Francis Foster Williamette 35,456 34,846 478002 James Foster Mason 147,101 151,201 478003 Wickwire Mason Counties Table Orders Table Within the SQL Select dialog box, you use the Where Condition field to tell MapInfo Professional how to join the two tables.
Chapter 9: Selecting and Querying Data • Order by Columns: 2 desc • into Table Named: Selection Substitute the name of your data column for ID_Num and the name of your table for EMPLOYEE. The number 1 in the Group By Columns box will group the row by ID_Num (the first column). The 2 Desc in the Order by Columns box will arrange the records in descending order based on the values in the count(*) field (the second column). This SQL Select statement returns a query table with two columns.
Creating Thematic and Other Themed Maps Thematic mapping is a powerful way to analyze and visualize your data. You give graphic form to your data so that you can see it on a map. Patterns and trends that are almost impossible to detect in lists of data reveal themselves clearly when you use thematic shading to display the data on a map.
MapInfo Professional in Action MapInfo Professional in Action Since you have all the tools you need to make effective and useful maps, it is time to talk about what makes a map effective and useful. Whatever you need your map to say, whether it is to convey information, calculate distances between health care providers and their patients, or get a count of the number of customers that live within a given radius of an outlet location, MapInfo Professional can help you do that.
Chapter 10: Creating Thematic and Other Themed Maps MapInfo Professional's thematic templates make it easy to start constructing a theme. Just choose a template that represents the type of thematic map you want. The templates are fully customizable and can be saved as new templates for future thematic mapping needs. More than 40 templates ship with MapInfo Professional. Figure: Comparison of Senior Population to Total U.S.
Using Thematic Mapping to Analyze Information Using Data from the Same Table If you are using data from the same table, choose the table and field on which you want to base your thematic map in the Create Thematic Map - Step 2 of 3 wizard panel. For example, you have a table of parking meters that contains the location of the parking meter and the last time the parking meter was emptied. Using Individual Values you want to shade the parking meter symbols according to the last time each meter was emptied.
Chapter 10: Creating Thematic and Other Themed Maps 4. Ranged (or Individual Value) thematic layer - where All Attributes are applied. 5. Major layer or base layer. 6. Grid thematic layer. When you create a new thematic layer, MapInfo Professional automatically inserts it into its proper place. Displaying Thematic Layers You can turn the display on and off for thematic layers the same way you can for other map layers.
Using Thematic Mapping to Analyze Information You are not limited to representing numeric values with thematic mapping. Nominal values also may be shaded thematically. For example, you have a table of underground cables. Those cables that have not been serviced in the past six months are labeled priority status. Using Individual Values, you can shade the cables according to their repair status. All records with the same value will be shaded the same.
Chapter 10: Creating Thematic and Other Themed Maps When using Equal Count (or any other range method), it's important to watch out for any extreme data values that might affect your thematic map (in statistics, these values are referred to as outliers).
Using Thematic Mapping to Analyze Information • Customizing Range Styles and Inflection Points • Customizing the Map Legend of a Range Map • Modifying a Thematic Map Bar Chart Maps Unlike thematic maps for single variables such as ranges of values or graduated symbols, a thematic bar chart map allows you to examine more than one variable per record at a time.
Chapter 10: Creating Thematic and Other Themed Maps • Customizing the Map Legend of a Bar Chart • Modifying a Thematic Map Pie Chart Maps Thematic maps using pie charts enables you to examine more than one variable per record at a time. Like comparing the height of the bars in bar charts, in pie charts you compare the wedges in a single pie, or examine a particular wedge across all pies. Pie charts enable you to compare parts of a whole.
Using Thematic Mapping to Analyze Information You can choose from graduated pies or half pies. Graduated pies graduate the size of the pies according to the sum of their components. Half pies distribute your data across half a pie instead. The Help System contains the following related topics: • Creating a Pie Chart • Customizing a Pie Chart • Customizing the Map Legend of a Pie Chart • Modifying a Thematic Map Graduated Symbol Maps Graduated symbol maps use symbols to represent different values.
Chapter 10: Creating Thematic and Other Themed Maps Graduated Symbol Map There are three attributes you can customize on a graduated symbols map: the color, type, and size of the symbol. To change the symbol's attributes in Create Thematic Map - Step 3 of 3, choose Customize Settings and click the symbol icon in the Customize Graduated Symbols dialog box to access the Symbol Style dialog box. The default symbol is a red circle.
Using Thematic Mapping to Analyze Information Dot density is particularly useful for showing raw data where one dot represents a large number of something: population, number of fast food restaurants, number of distributors who carry a brand of soda, etc. For example, if you have a table of age demographics broken down into postal codes, you could use the dot density option to show the concentration of small children in each postal code boundary. There are three customizing options for dot density maps.
Chapter 10: Creating Thematic and Other Themed Maps In the Create Thematic Map - Step 3 of 3 wizard panel, click Customize Settings. This opens the Customize Dot Density Setting dialog box. Here you can change the number of units that each dot represents, and also select the dot shape (square or circle) size, and color. You can specify a circle size from 2 to 25 pixels in width. For a square, the size can range from 1 to 25 pixels.
Using Thematic Mapping to Analyze Information 2. 3. 4. 5. 6. 7. Watching TV Taking a drive Reading Playing or watching sports Visiting museums or art galleries Going to the movies You want to shade each consumer point with the response for the favorite Sunday activity. The SUNDAY column of your table contains the number that corresponds to the consumer's favorite activity. However, the numbers in this column do not represent quantitative values.
Chapter 10: Creating Thematic and Other Themed Maps Creating a Thematic Map There are many kinds of thematic maps, but the process for creating each type of map is the same. In this section, we cover the creation of thematic maps in general terms. You can find more specific instructions for creating specific types of thematic maps in the Help System. Step 1 - Choosing a Type of Thematic Template Templates allow you to make a thematic map based on values and settings.
Creating a Thematic Map of units. That number, multiplied by the total number of dots in the region, equals the data value for that region. For instructions on creating a Dot Density thematic map, see Creating a Dot Density Map in the Help System. • Individual Values Template - Shades records according to individual data values. Individual value templates are multi-variable. Choose from shaded lines, points or regions.
Chapter 10: Creating Thematic and Other Themed Maps 4. Select the Ignore Zeroes or Blanks check box to ignore zero values and blank values in the table. Because you are creating a thematic map based on one field in a table, any zero or blank values in that field will cause the whole record to be ignored. If you are creating a grid map, you can choose a table of regions to clip the grid against. 5. Click Next to go on to Step 3 - Customizing Your Thematic Map.
Creating a Thematic Map • Styles - Enables you to customize style attributes such as color and size. This option is available for ranged, pie, bar, and individual value maps. • Legend - Enables you to customize your map legend. This option is available for all types of thematic maps. • Number of Columns - Use this field to indicate the number of columns in which you want the map legend entries to display.
Chapter 10: Creating Thematic and Other Themed Maps Working with a Thematic Map Legend Theme legends are created automatically when you create a thematic map. They provide a key of the colors, symbols, and styles used in the map. MapInfo Professional offers many types of themes for creating a thematic map, such as range, bar chart, pie chart, graduated, dot density, individual values, and grid themes.
Changing the Display Parameters of a Map Changing the Display Parameters of a Map Modifying a Thematic Map Once you create your theme, it is likely that you will want to change something about it. MapInfo Professional provides two ways to reach the Modify Thematic Map dialog box where you can customize a variety of settings, styles, and map legend components. To modify a thematic map, do one of the following: • On the Map menu, choose Modify Thematic Map.
Chapter 10: Creating Thematic and Other Themed Maps Diverging templates are useful when showing data that diverges more dramatically. An example might be world literacy rates: Figure: Divergent Theme Example The areas in green are areas we do not have data for. Saving Your Thematic Settings MapInfo Professional provides a way to save your themes and the templates from which you created them. Saving Thematic Map Layers To save your thematic maps, on the File menu, click Save Workspace.
Updating Columns using Thematic Mapping To save individual categories in a theme template when creating a new thematic map or for an existing thematic map, from the Modify Thematic Map dialog box choose Save As and specify a template Name. Select the Save Individual Value Categories check box and choose OK. A template is saved that can be used to apply the stored individual categories to a second table.
Chapter 10: Creating Thematic and Other Themed Maps 3. Click Ranges and select a template name from the list. This is the style of the thematic map you are creating. 4. Click Next. The Create Thematic Map - Step 2 of 3 wizard panel opens. 5. Click USA, this is the table you want to shade. 6. In the Field drop-down list, select Join. The Update Column for Thematic dialog box opens.
Updating Columns using Thematic Mapping Table to Update is already set to STATES and Column to Update is automatically set to Add new temporary column. 7. In the Get Value From Table box, select CITY_125. If that is the only other table open, MapInfo Professional automatically displays its title in the list box. Note: When you create a temporary column for a thematic map, the field must be a numeric field. This is true for all thematic maps except individual values.
Chapter 10: Creating Thematic and Other Themed Maps When you choose Join in the Update Column for Thematic dialog box, you can see that MapInfo Professional has already set up the Specify Join dialog box with the STATE fields from both tables. If the join were not calculated automatically it would be necessary to specify the matching fields or geographic join. 11. Choose OK. MapInfo Professional calculates the sum and returns you to the Thematic - Step 2 of 3 dialog box.
Updating Columns using Thematic Mapping 16. Click Ranges and choose either Equal Count or Equal Ranges to customize the ranges, whichever gives you the best representation of your data. Use Round By to round to a decimal place or whole number. Customize the styles to best illustrate your analysis by clicking the Styles button. Customize your map legend by clicking the Legend button. 17. Click OK The Map window redraws with your thematic. 284 MapInfo Professional 12.
Chapter 10: Creating Thematic and Other Themed Maps For details about using point or line objects to represent thematic variables, see Bivariate Thematic Mapping in the MapInfo Professional Help System. Adding Temporary Columns Use Update Column to add temporary columns to a table by using data from another table. To add a temporary column: 1. Open at least two tables. 2. Choose Table > Update Column. The Update Column dialog box opens. 3.
Working with Grid Surface Maps • Setting the Default Behavior of the Replace Layer Style Check Box • Example of Bivariate Thematic Mapping • Using an Inflection Point to Show Distinction • Example of an Inflection Point Map • Controlling the Number of Inflection Values • Applying Rounding Factors to Inflection Values • Spreading Inflections by Equal Cell Count Working with Grid Surface Maps The thematic maps we have discussed are based on vector layers.
Chapter 10: Creating Thematic and Other Themed Maps handler formats depend on what grid handlers have been installed. Changing the default grid handler will change the default file extension of the grid file name. Grid files are stored by default in the data directory specified as a preference. Grid files can be opened from the File menu, click Open command like other MapInfo Professional supported file types.
Working with Grid Surface Maps • TIN Interpolator • Grid Appearance • Inflection Methods • Relief Shading • Grid Translucency • Final Adjustments • Zoom Layering 288 MapInfo Professional 12.
Buffering and Working with Objects Two of the most important features in MapInfo Professional are buffers and the tools we provide to work with objects. Buffers allow you to create grouping areas around objects, lines and regions, which is important for providing a visual analysis. You can edit and manipulate objects in a wide variety of ways. The Set Target editing model allows you to apply a wide range of editing operations to an object or a series of objects.
Buffering Your Data Buffering Your Data If you would like to search for all underground cable wires that are buried within 440 yards of Interstate 490 or you would like to contact all families with pre-school age children who live within five miles of a proposed school district, buffering is the tool for you. Understanding Buffers A buffer is a region that surrounds a line object, another region, symbol, or any other object in a Map window.
Chapter 11: Buffering and Working with Objects • One buffer of all objects - Select this option to create one buffer for all of the objects you have selected. For example, if you are buffering Pennsylvania, New York and New Hampshire, one buffer will be created for all three of these objects. • One buffer for each object - Select this option to create one buffer for each object you have selected.
Buffering Your Data Table Variables If the table containing the selected table and the editable table are either the same table, or contain the exact same table structure (same number of columns with each column in both tables having the same name and data type), then the Sum and Average radio buttons do not display. The data is taken from the current selection, and the results are placed in the editable layer.
Chapter 11: Buffering and Working with Objects The number of segments per circle determines the level of detail in the buffer region. The more segments per circle, the higher the level of detail. The default level is 12 segments per circle. Buffer Width Distance MapInfo Professional's buffering feature calculates the buffer width to create a buffer that is some measured distance from the outline of the object. This distance is calculated using either the Spherical or Cartesian method.
Buffering Your Data • Concentric ring buffers allow you to create circles around map object(s) or point(s) and compute aggregated values for underlying data that occur within each ring. You would use concentric ring buffers to determine the number of customers within a certain radius of a store or other location. • Convex hull buffers create a region object that represents a polygon based on the nodes from the input object.
Chapter 11: Buffering and Working with Objects list, and use the style buttons to change the fill pattern and line style for the buffer. You can also collect data within each buffer ring using the Calculate Ring Statistics button. Convex Hull Buffers The Convex Hull command provides another means of creating a polygon around a selected object or objects. Convex Hull is similar to creating a buffer in several ways.
Editing Objects using the Set Target Model The Set Target model for editing map objects can be broadly described as a three-step process: 1. Set the object you want to edit as the target. 2. Choose and select another object or objects to act as the modifying object for the editing operation. You can also create a new object. 3. Perform the edit operation (combine, split, erase, erase outside, or overlay nodes). A new object (or objects) is created in place of the target object.
Chapter 11: Buffering and Working with Objects Many customers use the contouring process to create signal coverage maps, which requires large object sizes to create highly detailed coverage areas. To accommodate this need, we have increased the limit on number of nodes and the number of polygons or polylines that can be stored in objects.
Editing Objects using the Set Target Model Clipping a Region of a Map You can use Map > Set Clip Region to isolate a region of a map for display and/or printing. The clipped region may be a pre-defined map region, such as a state, or you can use a drawing tool to define a region. Use the Select tool to select a pre-defined region or a region that you defined. Thematic maps and seamless layers, labels, and points displayed on the map will be included in the clipped region.
Chapter 11: Buffering and Working with Objects 3. Select (or create and select) one or more map objects from any layer in the Map window. This is the modifying object. 4. On the Objects menu, click Combine. The Data Aggregation dialog box displays. 5. Choose the appropriate aggregation method (or No Data) for each field in the Destination list. See the definitions for these methods in Aggregating and Disaggregating Data.
Editing Objects using the Set Target Model • For more information, see Combining Points, Linear, and Closed Objects into a Single Object and Specifying Collection Object Attributes in the Help System. Default Data Aggregation Methods When the Data Aggregation dialog box first appears, MapInfo Professional automatically assigns a default aggregation method to every column in the table.
Chapter 11: Buffering and Working with Objects The Area Proportion radio button is active if the selected field is numeric. Also the Value entry field is enabled when you select the Value radio button and the drop-down list contains "none". Splitting Objects Splitting Objects allows you to divide the target object into smaller objects, using another object as a cutter. You can also combine objects into territories using redistricting.
Creating Territories by Combining Objects 2. The second method, Combine Objects Using Column, is used to combine objects into groups based on a specified column. 3. The third method, Redistricting, is covered in Redistricting-Grouping Map Objects into Districts. Most frequently, the Combine Regions options are your easiest and quickest options for combining regions and creating territories.
Chapter 11: Buffering and Working with Objects • AVG_SALES: Average the amount spent per customer in the sales territory When performing a Combine Objects Using Column operation, you must specify which column contains the grouping information. In the preceding example, the grouping information is located in the SALES_REP column. We want to combine all of Benita's individual territories into one large territory. 2. Choose the appropriate column from the Group Objects by Column popup.
Creating and Manipulating Objects Grouping Objects using Multipoint and Collection Object Types The Multipoint and Collection object types allow you to group multiple objects into a single object. One way to create multipoints and collections is by using the Combine command (on the Objects menu, click Combine). These object types aid in the translation and live access of other GIS data formats, such as ArcView Shape Files, and are more compatible with GIS standards.
Stylizing Your Map for Presentations and Publishing Most of us do not get to make maps solely for our own use. We use the maps we create in MapInfo Professional to create presentations, to publish them on the web, or to include as part of another document. This chapter will help you create presentation quality maps and prepare you for printing and exporting your work. In this section: • • • • • • • Changing a Map's Style . . . . . . . . . . . . . . . . . . . . . . . . . .306 Labeling Your Map . . . . . .
Changing a Map's Style Changing a Map's Style Changing the look of the map is an important part of making it more effective. In this section, we review how to change the way your map looks one piece at a time. For a more comprehensive change in your map's appearance, see Create Thematic Maps in the Help System. Changing a Region's Style To change the style of a region: 1.
Chapter 12: Stylizing Your Map for Presentations and Publishing • Color - Choose a color for the object(s)' foreground. The Sample box displays the pattern using the foreground color you chose. The foreground color is applied to the part of the pattern that displays as black. Therefore, to make the object a solid color, choose the solid black pattern in the Fill Pattern palette and a color from the Foreground Color palette. The color you chose displays in the Sample box as a solid-colored region.
Changing a Map's Style The Interleaved option is not activated for borders The Interleaved option is not appropriate for all multiple pass lines Changing a Symbol's Style To change the style of a symbol: 1. Do one of the following: • To change the style of one symbol, click the symbol and on the Options menu, click Symbol Style from the main menu. • To change the style of all symbols in the same layer, choose Map > Layer Control and click the layer's Style Override swatch.
Chapter 12: Stylizing Your Map for Presentations and Publishing None: Click this option to display no background. Halo: Click this option to display the symbol with a white border outline. Border: Click this option to display the symbol with a black border outline. • Effects - In this box, you can specify special effects for the symbol. Not all of these options display all the time. You can select one or more of these: Bold: Click this check box to draw the symbol in boldface.
Labeling Your Map • Background - In this box, you can specify background options for the selected text. You can select only one of these options: None - Set no specific background for the selected text. Halo - Display the text outlined in a designated color. Box - Surround the text with a box in a designated color. Color - Display the color palette; select a color to halo or box the text. • Effects - In this box, you can specify special effects for the selected text.
Chapter 12: Stylizing Your Map for Presentations and Publishing Saving labels is easy. Because labels are attributes of the map object, you do not have to remember to save them to a separate table. Any label edits you have pending, or changes you have made to the Layer Properties settings, are easily saved to a workspace.
Labeling Your Map The content of labels is controlled in the Label with drop-down list in the Layer Properties dialog box. You can label an object with any column from its associated table. For example, you can label the STATES table with the state name, abbreviation, 1990 population, or any other field in the STATES table. Simply choose a column from the list, and the objects in that layer will be labeled with the information contained in that column.
Chapter 12: Stylizing Your Map for Presentations and Publishing Controlling Label Display The Auto Label attribute in Layer Control is off by default for all map layers. To activate labels for a layer: • Select one or more layers in the Layer Control window and then click the Automatic Labels The map redraws with labels for your layer selections. icon. You can easily turn the display of automatic labels on or off in Layer Control window by clicking Automatic Labels.
Labeling Your Map Label Display tab Options on the Label Display tab include: • Label with - Choose the column that you want reflected in the label. You can only set a Label with expression on a single layer. After selecting multiple layers in the Layer list, the Label with list disables and shows a message that says Mixed. • Expression - Click to open the Expression dialog box and create an expression query of your data.
Chapter 12: Stylizing Your Map for Presentations and Publishing Anchor Point Button Position Description Upper Left Places the label above and to the left of the anchor point. Upper Center Centers the label directly above the anchor point. Upper Right Places the label above and to the right of the anchor point. Left Places the label directly to the left of the anchor point. Center Centers the label at the anchor point. Right Places the label directly to the right of the anchor point.
Labeling Your Map • Auto position label within region - If you select this, MapInfo Professional ignores the Label Position setting for region labels and instead calculates each region's ideal label position based on the shape of that region. The Label Position setting still affects point or line labels in the same layer, and MapInfo Professional places these labels around their centroid.
Chapter 12: Stylizing Your Map for Presentations and Publishing 3. Click OK. 4. Create labels for your map layer. You can either create automatic labels, by clicking the Automatic Labels icon in the layer list, or place labels by hand by selecting the Label clicking on objects in your map layer. tool and then 5. On the Main toolbar, click the Select tool. 6. In the Map window, select a label and drag it away from its location. A callout line connects the label to the label's original location.
Labeling Your Map Labeling Interactively Although you will probably do most of your labeling automatically, you will need interactive labeling to edit and create individual labels. Editing Labels It is very easy to edit individual labels, either those you have displayed automatically or those you have created interactively with the Label tool. Using the Select tool, double-click the label. The Label Style dialog box displays. The changes you make in Label Style dialog box apply only to the selected label.
Chapter 12: Stylizing Your Map for Presentations and Publishing • Draw text objects one at a time using the Text Label button. This allows you to create multiple annotations for a single map feature, which is something you cannot do using labels. Creating Labels with the Labeler Tool To use the Labeler tool, choose Tools > Tool Manager, and then locate Labeler Tool in the list of available tools. Select the Loaded checkbox and/or the Autoload checkbox, and then click OK.
Working with Layouts You can pre-set adornment properties, such as the default position and style, in the Map Preferences dialog box under the Adornments tab (on the Options menu, point to Preferences and then click Map Window). Adding a Scale Bar to Represent Map Scale The map scale bar shows the scale of map representation relative to the portion of the Earth's surface it displays. The scale bar also has the option to show the cartographic scale of the map.
Chapter 12: Stylizing Your Map for Presentations and Publishing Note: You can continue to use the classic Layout window, but there will be no new work or updates made to it in future releases. Instead, future releases of MapInfo Professional will focus on improving and adding to the Layout Designer window. Opening a Layout Designer Window To open a Layout Designer window, either: • On the Standard toolbar, click the Layout Designer tool. • On the Window menu, point to New Layout Designer Window.
Working with Layouts You can also drag a map from a Map window in to your layout. To do this, select Drag Map Window from the Main toolbar. Click on the map in your Map window and then drag it in to the Layout Designer window. If the Map window has a legend, then the legend copies into a frame in the Layout Designer window as well. You will see the map frame listed in the Layer Control window with a Map Frame in Layout Designer icon beside it. Note: Closing the open Map windows does not affect your layout.
Chapter 12: Stylizing Your Map for Presentations and Publishing • Double-click on the layer name to change the display style and labels for the layer. This opens the Layouer Properties dialog box. For more details, click on the dialog's Help button or see Changing how a Layer Displays on the Map. The changes you make to the map in your layout does not affect the contents of the Map window and vica versa.
Working with Layouts Refreshing the Contents of a Legend Frame You can edit object styles on the map by adding new styles and removing existing styles, which may affect what the styles look like in the legend. A legend does not update automatically except when overriding, changing, or removing an existing style. For other style changes made to a layer, you must refresh that layer's legend frame. You cannot refresh a thematic legend frame. Instead, you must recreate it.
Chapter 12: Stylizing Your Map for Presentations and Publishing The table is in a browser frame in the Layout Designer window. Note: Closing the open Browser window does not affect your layout. However, closing a table (on the File menu pointing to Close Table) closes it in all windows including the Layout Designer window. Editing the Contents of a Browser Frame Activating a browser frame in your layout gives you access the Browser context (right-click) menu.
Working with Layouts The Layout Designer maintains the image aspect ratio (ratio between width and height) as you resize it, so that the image does not look distorted. When replacing an image, the image frame resizes to match the aspect ratio of the new image. Image Not Found A message displays in a Layout Designer image frame when the image file that the frame references cannot be found. The message includes the path to the file that is missing.
Chapter 12: Stylizing Your Map for Presentations and Publishing 3. Click OK to apply your changes. To change the style for text in multiple frames, press the Ctrl key while selecting text frames, right-click on one of the frames, and then select Text Style. Changing Text Alignment and Spacing You can control the horizontal alignment of the text within a text frame. The alignment determines the appearance and orientation of the edges of the text as left-aligned, right-aligned, or centered.
Working with Layouts Saving a Layout in the Layout Designer Window You can save a layout in a Layout Designer window by saving to a workspace. To save your layout to a workspace: 1. On the File menu, point to Save Workspace to open the Save Workspace dialog box. 2. Select a location to save the workspace to, give the file a name, and then click Save. The workspace does not save with image files. If the layout includes images, then the workspace saves the references to the images.
Chapter 12: Stylizing Your Map for Presentations and Publishing Resizing Frames The contents of a frame scales to fit within the frame. To resize a frame either: • Select the frame and then drag an edge or corner to a new size. • Specify width and height values for the frame. To do this, right-click on the frame and select Frame Properties. In the Frame Properties dialog box, enter new Width and Height values. When resizing image frames, you can only drag a corner.
Working with Layouts 2. Click on the guideline and drag it to where you want to position it in the layout. 3. Select one or more layout frames (frame borders display to indicate your selections). 4. On the Grids & Guidelines menu, point to one of the following options to snap the edge of the frame border to the nearest guideline. Snap to Closest Left Guideline Aligns all selected frames to the nearest guideline located to the left of the frame.
Chapter 12: Stylizing Your Map for Presentations and Publishing Printing Your Layout Before printing, ensure that you are happy with how your print settings affect your layout. Changing printer information can change the labels that display in a layout. This includes changing the resolution of the printer, which can be done when printing to the MapInfo PDF Printer. Note: Grids and guidelines in the Layout Designer window do not display in printouts or exported images. To print your layout: 1.
Working with Layouts You can override the default setting, by setting paper size, margins, and page orientation (portrait or landscape) for a Layout Designer window. To do this, click Page Setup window to open the Page Setup dialog box. on the Layout Designer Print OSBM and Subdivide Printing Off-Screen Bitmap (OSBM) automatically applies when printing a map frame that contains items or options that require OSBM to preserve their appearance in print. Using OSBM processes each print tile as a raster.
Chapter 12: Stylizing Your Map for Presentations and Publishing Working with the Classic Layout Window Using the classic Layout window, you can create and customize a page layout that shows off your maps, browsers, and graphs. The classic Layout window lets you add complicated geometry to your layouts and lets you work with the Redistrict window, which the Layout Designer window does not. It also offers layout templates, which are not yet available with the Layout Designer window.
Working with the Classic Layout Window When you add your windows to the Layout window, MapInfo Professional places them inside layout frames. Using frames to hold your maps and browsers allows you to resize and reposition your windows with ease. The contents of the frame match the contents of the corresponding Map, Browser or Graph window. The Layout window provides dynamic linking between it and a parent window.
Chapter 12: Stylizing Your Map for Presentations and Publishing not the zoom of individual windows in frames. (If you want to change the zoom level on a frame containing a Map window, change the zoom for the Map window itself.) There are four ways to change the zoom level of the Layout window: • Use the Zoom-in and Zoom-out tools. These tools work exactly as they do in the Map window. You can click the Layout window with the tools or draw a marquee box around the areas of the Layout window.
Working with the Classic Layout Window 2. Choose the area you want to show in detail and zoom in on it. The Map window contains the detailed view. 3. As stated previously, there must be a separate Map window for each view you want to include in a layout. Instead of re-opening the tables to re-create the Map window, on the Map menu, point to Clone View to create a duplicate Map window. 4. A new Map window displays. Zoom out on this map to create the overview map.
Chapter 12: Stylizing Your Map for Presentations and Publishing in their own layer for future use or editing. To create labels that can be easily saved, use AUTOLABEL.MBX or LABELER.MBX. These MapBasic applications allow you to create labels that can be saved to a separate layer for future use. For instructions on using the AutoLabeler tool, see the Tools section of the Help System.
Working with the Classic Layout Window When you later open that layout when the printer setup is different, the layout uses the page size and orientation for that printer setup. The sizes and positions of objects in the layout are the same, but the way the layout is broken into pages is different. After you create a layout, that layout is the currently active window. MapInfo Professional places the Layout menu item on the menu bar. Use the Layout menu to choose your layout options.
Chapter 12: Stylizing Your Map for Presentations and Publishing Note: The Fill Frame check box does not display for Browser, Legend Designer, and Graph windows. The Frame Object dialog box allows you to change the width, height, and center of the frame and to set a specific scale for a map. When there are several windows open on the screen, MapInfo Professional displays its choice in the Window drop-down list. This list allows you to choose which window you would like in your frame. 5.
Working with the Classic Layout Window Using Map Legends in a Layout You can use map legends in your layout. The Legend Designer window display in the layout at the same size as on the MapInfo Professional desktop. When you resize a map legend frame to make it smaller, it crops the map legend rather than shrinking it to fit. The text styles (for example, font, size) used in the Legend Designer window are preserved in the layout.
Chapter 12: Stylizing Your Map for Presentations and Publishing If you want to align objects with respect to each other, the objects are aligned with respect to an imaginary rectangle, called the bounding rectangle, that completely encloses the objects. The horizontal and vertical settings you choose position the objects at the top, bottom, left, right, and horizontal or vertical center lines of the bounding rectangle, rather than at the edges of the layout.
Creating a Legend for your Map For example, you need to make a map that will be in a scale of 1:24000 and fit in an eight inch frame. You need to determine the zoom level that will accommodate the map scale and frame width. Calculate the following: ((8 * 24000) / 12) / 5280) = 3.03 On the Map menu, point to Change View and enter 3.03 miles as your new zoom level.
Chapter 12: Stylizing Your Map for Presentations and Publishing associated with these that you wish to show. It generalizes this information to make it easier to understand the information being shown. After designing your map presentation, you will want to design a legend to help your readers understand what they are looking at. The following example shows a map with two legends: one for map symbols and one for the ranged theme.
Creating a Legend for your Map Note: A layer must contain style attributes to appear in the Legend Frames list; therefore, raster layers are not included in the list. 3. Click Finish to create the Legend. The Legend Designer window opens with legend frames for each layer that you chose to include in the legend. Legend frames will display default settings for their titles and symbol style names will be the same as those on the map layer.
Chapter 12: Stylizing Your Map for Presentations and Publishing Modify Thematic Map Opens the Modify Thematic Map dialog box for changing thematic display properties. This button enables after selecting a legend frame in the Legend Designer window. Toggle Grid Lines Shows or hides an equally spaced grid of lightly marked lines to align legend frames to. Change Grid Size A slider bar that changes the size of the grid to make it smaller or larger.
Printing and Exporting Your Results allows you to modify the legend frame. For a theme legend, it launches the Modify Thematic Map dialog box. If there is no legend selected in the Legend Designer window, then this option is disabled.
Chapter 12: Stylizing Your Map for Presentations and Publishing 3. Click the Name drop-down list in the Print dialog box to select a printer. All of the printers available on your system display in the list. You can specify printer properties here as well, plus specify whether to print to a file. 4. To use the advanced print settings to take advantage of additional output options that help you control transparency and color, particularly for raster images, click the Advanced button.
Printing and Exporting Your Results Note: The Print Border for Map Window check box is not available for layout windows. You can control the border for each frame by selecting the frame and setting by selecting the Options menu, clicking Region Style. d. Click OK to return to the Print dialog box. 5. Click OK to print. More and more often, users want to export their maps electronically to files rather than print them.
Chapter 12: Stylizing Your Map for Presentations and Publishing Smoothing the Edges of Images during Export To give you more control over map images when exporting MapInfo Professional maps, you can use anti-aliasing methods. This is particularly important when you are saving maps created in MapInfo Professional for use in other Windows-based applications, in particular in slide presentations or for web pages. We have added the ability to smooth or anti-alias images during the export process.
Printing and Exporting Your Results 2. Type the name and indicate the path of the file you are saving in this dialog box. Click Save to continue. The Save Window As dialog box displays. If you are exporting an EMF or WMF image, the Use Anti-Aliasing check box is disabled. 3.
Registering Raster Images Raster images can provide context to your maps by giving them detail and definition. This chapter reviews the details of registering and working with raster image files. In this section: • Working with Raster Images . . . . . . . . . . . . . . . . . . . . . .352 • Opening a Raster Image . . . . . . . . . . . . . . . . . . . . . . . . . .354 • Printing/Exporting Translucent Raster Images . . . . . . .
Working with Raster Images Working with Raster Images There are a number of ways you can obtain raster image files. If you have a scanner and scanner software, you can use the scanner to create raster image files. MapInfo Professional can read and display the raster image files created with the scanner software. Some graphics software packages let you save or export images into raster file formats, such as TIFF (Tagged Image File Format).
Chapter 13: Registering Raster Images Understanding Raster Images in MapInfo Professional Using raster image files, you can bring paper maps, photographs, and other graphic images into MapInfo Professional. For example, if you work with paper maps, you probably want to use those paper maps as the foundation for the maps you create in MapInfo Professional. Once you scan your paper map into a raster image file, you then can display it in a Map window.
Opening a Raster Image • filename.PNG (Portable Network Graphics format) • filename.PSD (Photoshop 3.0) • filename.SID (MrSID format) • filename.TIF (Tagged Image File Format) • filename.TXT (Text) • filename.TGA (Targa) • filename.WMF (Windows Metafile format) For a complete list, see the Raster image file formats MapInfo Professional supports at MapInfo Professional Data File Support. MapInfo Professional also supports: • Map Tile Server raster images.
Chapter 13: Registering Raster Images • Opening a Registered Raster Image • Opening an Unregistered Raster Image • Opening a Georeferenced Raster Image Registering the Coordinates of a Raster Image Before you can overlay vector data on top of a raster image, you must first register the raster image so that MapInfo Professional can position it properly in a Map window.
Opening a Raster Image Due to this feature, these are the precedence rules for Map window projection. Both vector and raster layers have "equal rights", that is, every new layer (without regard for type) is reprojected into the current Map window's projection. That is, which ever map is opened first takes precedence for projection. Note: You can change the projection of a Map window containing a mix of raster and vector layers by setting the image processing reprojection preference to Always or Optimized.
Chapter 13: Registering Raster Images Modifying Control Points for Raster Images If you must adjust the coordinates of a control point because the error is unacceptable, highlight the point in the Image Registration dialog box and choose another location for it in the Map window. To delete control points, click the point and choose the Delete button. Raster Image Display Options You can display more than one raster image in a window at a time. This is limited only by your computer's memory.
Opening a Raster Image If you change an image's display style and choose OK, the new display style is applied immediately. It will also affect all Map windows in which the image is displayed if you select the Table menu, and point to Raster and click Adjust Image Styles. You do not need to choose Save to save the changes. Style Override for Raster Images MapInfo Professional provides the ability to change the display style for raster and grid images on a per-layer basis through the Layer Control window.
Chapter 13: Registering Raster Images Printing/Exporting Translucent Raster Images When printing or exporting a translucent raster image, take advantage of Advanced options. To print a translucent raster image: 1. Do one of the following: • On the File menu, click Print • On the File menu, click Save Window As 2. Click Advanced and choose from the following settings according to your printing and exporting requirements. • Print/Export Border - Select to include the black rectangle border when exporting.
Putting Your Data on the Map As we saw in Data - Where MapInfo Professional Begins, you can convert your existing data to a format that MapInfo Professional can use to display it on a map. Now you are getting somewhere! But how does MapInfo Professional know where to put the information on a map? That is the subject of this section. In this section: • • • • • • • • • • • • • • • • • How Do I Get My Data on the Map? . . . . . . . . . . . . . . . . .362 Displaying your Excel (.XLS or .XLSX) Data . . . . .
How Do I Get My Data on the Map? How Do I Get My Data on the Map? There are three steps to putting your organization's data on a map: • Creating a MapInfo .tab file of your data • Geocoding or creating points for the data • Displaying your points on a map Creating a MapInfo .tab File of Your Data The first step in using your data in MapInfo Professional is to create that .tab file from your data.
Chapter 14: Putting Your Data on the Map During Geocoding, MapInfo Professional reads data such as street data, postal code data, and other non-coordinate information from your database and matches it against street or postal code information on a MapInfo data table. During the Create Points process, MapInfo Professional reads X and Y coordinate data (such as longitude and latitude data from a Global Positioning System) and plots data using those coordinates.
Displaying your Access (.MDB or .ACCDB) Data • If you clear the Use Row Above Selected Range for Column Titles check box, both the Named Range and Current Value fields revert to their previous values on the Entire Worksheet. 4. Click OK to display the Set Field Properties dialog box. This dialog box allows you to reset the name, type and properties of any field (column) that you import from the Excel table.
Chapter 14: Putting Your Data on the Map 3. Choose an Access database to open. If security is turned on, you will be prompted to give user and password information to open the database. 4. The Open Access Table dialog box displays the tables for the opened database. 5. Choose an Access table or tables to open. The table or tables are opened in MapInfo Professional.
Displaying your Comma Delimited CSV Data Opening SQLite Tables MapInfo Professional lets you select which tables in a SQLite database to open, and gives you the option to set display styles, and column and row filters for the tables. MapInfo Professional works with existing SQLite databases and it lets you create new SQLite databases. You can open a table in a SQLite database and save your edits, and you can save your new or existing MapInfo tables to a SQLite Database (*.sqlite).
Chapter 14: Putting Your Data on the Map Opening Comma Delimited CSV Files in MapInfo Professional You can open .csv files by selecting the File > Open option. To open a comma delimited file: 1. 2. 3. 4. From the File menu, click Open to display the Open dialog box. In the Open dialog box, from the Files of type box, select Comma delimited CSV (.csv). Navigate to the folder that contains the file you want to open and click it to select it.
Displaying your Lotus 1-2-3 Data 1. On the File menu, click Open to display the Open dialog box. 2. In the Files of Type list, select the format (.DBF), navigate to your data, and click Open. 3. Select the appropriate character set for your MapInfo data table. Windows U.S. and Western Europe ("ANSI") is the default option. 4. Click OK to convert your selected data to a MapInfo table (.tab) format. 5. On the File menu, click Save Copy As to make an editable copy of your table.
Chapter 14: Putting Your Data on the Map • If the application does not detect the Shapefile's native projection, or there is no matching supported projection in the MAPINFOW.PRJ file, click Projection to select one and click OK. • If the application detects a supported projection, MapInfo Professional selects the Use Projection in Source File radio button and the Projection button is disabled.
Registering and Displaying your ASCII Data Registering and Displaying your ASCII Data When you are working with ASCII data in MapInfo Professional, you do not actually create the table as you would in the other file formats we have discussed. MapInfo Professional registers your ASCII table by creating a MapInfo (.tab) file that points to the fields in the original file. Note: Registering your data using MapInfo does not change the original data in any way.
Chapter 14: Putting Your Data on the Map For more specific instructions, see Importing and Displaying GML 2.1 Files in the Help System. Using Universal Data Directly You can open AutoCAD, Microstation Design, ESRI ArcSDE, Personal Geodatabase and Google Earth KML data directly to avoid having to translate it separately and work with copies of the data in .tab format. This functionality ensures that you will have more flexibility when working with your data. Pitney Bowes Software Inc.
Using Universal Data Directly 3. In the Formats Gallery, select the format for the data you wish to open and click OK. To obtain a free trial of the FME Suite and add more formats to this list, click More Formats. Note: Personal Geodatabase and ArcSDE always display in the Formats Gallery but they may be grayed out if you do not have the appropriate client DLL or applications installed.
Chapter 14: Putting Your Data on the Map Some data contains the coordinate system information in it and others do not, so you may need to specify the coordinate system projection for the data you are opening. 9. Click OK. 10. In the Select Layers dialog box, select which layers you want to include in the output. By default all layers are selected. To set display characteristics for one or all of the layers, see Changing Display Settings for Universal Data in the Help System. 11.
Opening MapInfo Professional Grid Files as being part of the Topography complex or Structuring Layer. There is a feature type in the GML Import dialog box called LandformArea, which allows the creation of the LandformArea table. See Importing and Displaying GML File Data for a clearer picture of this process in action. Opening MapInfo Professional Grid Files To open MapInfo Professional Grid Files: 1. Choose File > Open to display the Open Table dialog box. 2. Choose Grid Image (*.grd, *.
Chapter 14: Putting Your Data on the Map What Do I Need to Know Before Geocoding? It is important to know your data and what you want to use it for before you select a method of geocoding.
Geocoding - Assigning Coordinates to Records The dialog box also offers you the option of geocoding your data in two modes: automatically or interactively. When you geocode a table automatically, MapInfo Professional geocodes exact matches only and ignores all other records. It is the faster method, since MapInfo Professional requires no user interaction once the geocoding process begins.
Chapter 14: Putting Your Data on the Map • Street name • Apartment, Suite, Floor, Room number or some other piece of information. Many addresses do not have this component MapInfo Professional has one procedure for dealing with the street number and another procedure for dealing with the street name. MapInfo Professional deals with the third component, if present, as though it were a part of the street name.
Geocoding - Assigning Coordinates to Records matching is not case sensitive; upper and lower case letters are successfully matched with one another. MapInfo Professional does not get an exact match in many cases and uses a file of abbreviation equivalences to improve its "hit rate". Once you understand the various ways in which a match can fail, you are in a better position to understand what you can do to improve things. The next table illustrates exact matching.
Chapter 14: Putting Your Data on the Map Target Address Source Address Comment Correctable with Abbreviation File? 10th Av Tenth Av "10th" and "Tenth" do not match. Yes Saint John's Lane St John's Lane "Saint" and "St" do not match. Yes MapInfo Professional's matching process is not case-sensitive; it does not care whether a letter is upper case or lower case. This means that MapInfo Professional treats the following as the same: Main, MAIN, main, maIN.
Geocoding - Assigning Coordinates to Records At this point MapInfo Professional will have done the best it can at identifying street names. The next step is to deal with address numbers for those addresses where it has matched a name. Matching Address Numbers Given that MapInfo Professional has identified a street, it has to deal with street numbers. MapInfo Professional stores address ranges with each street segment.
Chapter 14: Putting Your Data on the Map You could use any one of several different region types, including county name, town name, and postal code. Since almost all addresses contain postal codes, this is the most reliable way to refine your search. When you set MapInfo Professional to use postal codes to refine its address matching, MapInfo Professional will match the postal code of the target address against the postal code of the various matching source addresses.
Geocoding - Assigning Coordinates to Records Selecting Records Not Geocoded Your geocoded table may have records that did not geocode, or you may have added new data to your table that have yet to be geocoded. There is a simple selection that can be performed to get a Browser list of the records not geocoded. 1. Open your table if it is not open already, and on the Query menu, click Select. 2. Fill in the Select dialog box. The expression used is "NOT OBJ.
Chapter 14: Putting Your Data on the Map Result Codes When you are using the result code option (in Geocode Options dialog box) MapInfo Professional will generate a code for each record. These codes indicate the steps MapInfo Professional took to geocode the record, whether or not the geocoding was successful, and whether or not the match was exact. You can use return codes to diagnose MapInfo Professional's geocoding performance.
Putting Latitude/Longitude Coordinates on a Map Putting Latitude/Longitude Coordinates on a Map You may have a file that already contains X and Y coordinates, but not the point objects themselves that you want to display in MapInfo Professional. While the geographic information exists in the table, MapInfo Professional needs to create points to represent these coordinates before displaying them in a Map window.
Chapter 14: Putting Your Data on the Map multiple equal close results, the geocoding server can present you with interactive options so you can select among possible matches or change your input. Further, these web services allow you to set multiple matching conditions when more than one record matches the records you are geocoding and set offsets for placing points right in the geocode properties.
Displaying Your Data on the Map The Find Selection in All Windows command allows you to locate the selection in all open windows (including a Browser window) that are currently open. To access Find Selection in Current Map Window: 1. Perform the Query > Find or Query > Find Selection. 2. Choose Query > Find > Selection > In Current Map Window. Note: Choosing the In Current Map Window option shortens the search time. To access Find Selection in All Windows: 1.
Chapter 14: Putting Your Data on the Map • Select Options > Show Statistics Window • Click the Statistics tool . To copy the contents of the Statistics window to the clipboard, press and hold the Ctrl key and press C. Go to the application you want to paste the Statistics data to and do one of the following: • Right-click to display the shortcut men, click Paste. • Hold down the Ctrl key and press Insert. You cannot select particular contents of the Statistics window.
Printing Your Results • Advanced Printing Options • Graph/Redistrict/3DMap Printing Options • Overriding the Default Printer • Printing Maps to PDF Files Printing Your Map When you have your page set up the way you want, you are ready to print. To print your map: 1. On the File menu, click Print. 2. In the Print dialog box, specify printer properties, such as a page range for printing and the number of copies to print.
Chapter 14: Putting Your Data on the Map Text Size in classic Layout windows In the Layout window, the point size of the text is specified relative to the actual size of the page (that is, the size in which it will print), just as it is in word processing and desktop publishing programs. When you zoom in and out on a Layout window, the text will be larger or smaller on the screen, but its specified point size (as indicated in its attributes box) remains the same.
Printing Your Results Translucent Raster Maps/Grids and Windows 9X Do Not Mix You cannot print a translucent raster map or grid on Windows 9X platforms or export them to EMF or WMF file formats. You need to use a non-metafile (for example, .BMP or .GIF) format to export raster images on Windows 9X. Customers printing large images (such as destination page size D, E, or A0) no longer have the 28,000 pixel limitation.
Working with Coordinate Systems and Projections Maps at their base are a visual representation in two dimensions of a section of the three-dimensional Earth. Being able to use maps in an electronic format in many ways frees us from the constrictions of the two-dimensional map because we can use mathematical formulas to compensate for the curvature of the Earth.
Working with Coordinate Systems Working with Coordinate Systems The terms "projection" and "coordinate system" are often used interchangeably, however they do not mean the same thing. Projection - An equation or set of equations that contain mathematical parameters for a map. The exact number and nature of the parameters depends upon the type of projection.
Chapter 15: Working with Coordinate Systems and Projections Understanding Coordinate Systems You can make a map out of any globe without distorting the points on the surface by placing the globe into an imaginary cylinder. Globe with Longitude/Latitude Projection If you transfer the touch points from the globe surface onto the cylinder and roll out the cylinder onto graph paper, the result is a map as in the figure below.
Working with Coordinate Systems the cylinder so that it touches the Prime Meridian instead (or any line of longitude, 90 degrees away from the Equator) you have a Transverse Projection. The closer you are to the place the cylinder touches the globe, the more accurate the measurements are.
Chapter 15: Working with Coordinate Systems and Projections Globe with Conic Projection This type of projection is much more accurate for large regions or countries that are wider in the East-West direction than in the North-South direction. There is much less distortion regionally because the touch points of a cone are closer to the map surface than those of a cylinder. Brazilian Polyconic Projection Map As you can see from the previous figure, the conic maps are best for small regional areas.
Working with Coordinate Systems Lambert Azimuthal Projection Map You can use more than one projection that rotates a cylinder slightly along the Equator. This style is used in the Universal Transverse Mercator (UTM) projection. UTM maps the Earth with a transverse cylinder projection to create standard "UTM Zones". By rotating the cylinder around the globe in six degree increments, the UTM assures that all spots on the Earth are within 3 degrees of the center line.
Chapter 15: Working with Coordinate Systems and Projections Almost all projections you will use are one of these types. They are either cylindrical (regular or transverse), conic, or azimuthal projections and are customized by slightly different projection parameters. Projection parameters are options that describe how the projection is arranged. You can further customize projections by specifying different parameters for the projection you want to use.
Building Blocks of a Coordinate System Specifying the Bounds for Coordinate Systems You can specify the bounds for coordinate systems in the Mapinfo Professional .PRJ file. To do so, add 2000 to the projection number and list the bounds after the projection parameters.
Chapter 15: Working with Coordinate Systems and Projections To supply explicit bounds to the coordinate system (x1, y1, x2, y2)=(-500000, 0, 500000, 1000000), the required line entries would be: "UTM Zone 1 (NAD 83) - bounded", 2008, 74, 7, -177, 0, 0.
Building Blocks of a Coordinate System the Molodensky general-purpose method; NADCON is accurate to about 0.1 meter, and Molodensky is accurate to only 10-30 meters. Most U.S. government agencies, including the Census Bureau, have standardized on NADCON for converting between NAD 27 and NAD 83. The NADCON algorithm is used to convert coordinates between NAD 27 and NAD 83 if those coordinates lie within the areas covered by NADCON (United States, Puerto Rico, and the Virgin Islands).
Chapter 15: Working with Coordinate Systems and Projections recessing the cylinder into the earth so that it has two lines of intersection. Scale is true along these lines of intersection. You may see the scale factor expressed as a ratio, such as 1:25000. In this case it is generally called the scale reduction. The relationship between scale factor and scale reduction is: scale factor = 1-scale reduction In this case the scale factor would be 1-(1/25000) or 0.99996.
Adding Projections to the MAPINFOW.PRJ File "UTM Zone 9 (NAD 27 for Canada)", 8, 66, 7, -129, 0, 0.9996, 500000, 0 This is a basic list of the elements of a coordinate system, for review. There are some projections that do not require all of the elements in the list. Following this list, you can see some entries from the .PRJ file. 1. The first element in each list is the name of the projection in quotes. 2.
Chapter 15: Working with Coordinate Systems and Projections For example, to add a new Universal Transverse Mercator projection (Australian Map Grid using AGD66 datum), scroll down to that entry and type the new projection at the end of the list. Adding a Line in the MAPINFOW.PRJ File 4. On a new line, type the new parameter entries based on the required parameters described for that projection type in the table Projections and Their Parameters.
Understanding Precision in MapInfo Professional 1. Select the new projection from the list and click OK to confirm. The Map Options dialog redisplays. 2. Click OK to implement the new projection in the Map window. Entering a New Coordinate System (Example) To illustrate this process in another way, create the following coordinate system using these parameters by adding a new entry to the MAPINFOW.
Chapter 15: Working with Coordinate Systems and Projections What is Precision? The most basic component of any GIS is the spatial data that defines the map features. This spatial data could not exist without the coordinate systems that are used to specify the location information. Coordinate precision is a measure of storing spatial data as accurately as possible. Of course, this can be no more precise than the original data provided.
Understanding Affine Transformations The difference between these two images is the translation. The rotation factor of a transformation indicates that the image turns on a particular point. The next figure shows a 25-degree rotation of the map around the 0,0 point. The difference between these two images is not the scale, because the size of each image is the same. The difference is the rotation of the derived image (B).
Chapter 15: Working with Coordinate Systems and Projections The difference between these two images is that the derived image (B) is a reflection of the base image (A) along the x-axis. Using Earth and Non-Earth Maps Earth maps and non-earth maps generally require different treatment. The following section on projections apply only to earth maps. An earth map contains objects that have a particular location on the earth's surface. All maps that MapInfo Professional sells are earth maps.
Using Earth and Non-Earth Maps 2. 3. 4. 5. Choose File > Save Copy As. In the Save Copy of Table As dialog box, click the Projection button. In the Choose Projection dialog box, choose Non-Earth from the Category drop-down list. Choose a unit from the Category Members drop-down list to specify the bounds and units for your non-earth coordinate system. 6. Click OK. The Non-Earth Coordinate Bounds dialog box displays.
Working with Data from a Web Service A web service is a software system that is accessible using an intranet or Internet connection. MapInfo Professional supports the Web Map Service (WFS) and Web Feature Service (WFS), which allow you to retrieve data that others are sharing internally or world-wide. The power of web services is that you can use them to create more powerful maps or in the case of geocoding services get more accurate and precise results using the same data.
Introduction to Web Services Introduction to Web Services MapInfo Professional web services can add detail and precision to the maps you are creating and analyzing. Currently, you can use the following web services from within MapInfo Professional: • • • • • Web Map Service (WMS) Web Feature Service (WFS) Geocoding Service Routing or Driving Region Service Mapping Tile Service Accessing Web Services in MapInfo Professional To make it easier to access web services, there is a Web Services toolbar.
Chapter 16: Working with Data from a Web Service threat of theft of sensitive data. If you try to connect to a server and you have a valid SSL certificate, you should be able to connect to the web site. Proxy Server Authentication Your local LAN may use a proxy server to connect to the internet. Web client applications such as internet browsers provide a mechanism for specifying a proxy server, and MapInfo Professional does as well.
Enhancing Map Data using a Web Map Service (WMS) Enhancing Map Data using a Web Map Service (WMS) Web Services can provide more data for you to work with in MapInfo Professional. A Web Map Service (WMS) allows you to access maps and data through your local intranet or the Internet. This innovation is based on a specification from the Open GIS Consortium (OGC) that allows you to use raster map images from servers that also comply with the specification.
Chapter 16: Working with Data from a Web Service The OGC WMS specification supports transparent pixel definition for image formats. This allows you to use the images you retrieve as overlays and not solely as the bottom layer of your map. To set the background to transparent, click the Transparent check box in the Open WMS Table or the WMS Table Properties dialog boxes.
Enhancing Map Data using a Web Feature Service (WFS) Error Message Description and Explanation of Message format. The specified address may not be a WMS Server or the server could not process the request: message from server The server you are accessing may not be a WMS server. You may see this message after accessing a WFS server and seeing a list of WFS layers.
Chapter 16: Working with Data from a Web Service The WFS client supports GML2 (OGC GML V2.1.1). The OGS WFS Specification states that all servers should support GML2, but may also support other formats. The server provides information on the formats available, and the client makes the request for the data in the format it can use. If the server does not support GML2, it will not be supported by the MapInfo WFS client. GML2 does not contain any style information.
Enhancing Map Data using a Web Feature Service (WFS) necessary information cannot be found. In other cases, MapInfo Professional may miss functionality that the server is trying to provide, such as filters. • Support HTTP GET and/or HTTP Post for the DescribeFeatureType and GetFeature requests. The MapInfo Professional client supports both HTTP GET and HTTP POST. The server should advertise what it accepts for each request in its GetCapabilities response.
Chapter 16: Working with Data from a Web Service If a MapInfo WFS table is open, the user interface automatically enables the refresh process. During the refresh process, users can not change the query that is sent to the WFS server. The data will be refetched from the server using the original query. This refreshed information can then be saved to the table.
Geocoding using a Geocoding Server available in MapInfo Professional mapping software to perform querying, create thematic maps, create territories, and perform many other types of geographic analysis. Using the MapMarker and Envinsa Web Services, you have more choices for geocoding. For example, you can choose to geocode your records by street address or by postal code centroid, or by geographic centroids.
Chapter 16: Working with Data from a Web Service Geocoding a Single Address using a Geocoding Service The process for geocoding a single address for an Envinsa or MapMarker service. Keep in mind that you must set up a geocoding service before you can use this type of geocoding.
Creating Routing Distance and Time Buffers S matched to street suffix C matched to city name Z matched to ZIP Code A or U match came from MapMarker Address Dictionary (A) or customized user dictionary (U) Z Category: Postal Code Match Z6 Postal Code centroid match Z3 Secondary Postal Code centroid match Z2 Primary Postal Code centroid match Z1 Postal Code centroid match Z0 Postal Code match, no coordinates available M Category: Multiple Automatic Matches M1 multiple matches, point located
Chapter 16: Working with Data from a Web Service You can only access this Drivetime data and calculation functionality on an Envinsa 4.0 routing server. The Driving Regions web service helps you create isochrone and isodistance buffers using points in your own data. An isochrone or a time buffer is a region that shows the area that a driver can reach from a starting point in a specific amount of time based on the speeds specified in the routing network.
Enhancing Map Data using a Mapping Tile Server If you think of these speed limits and distances in spatial terms, starting from a particular point, the region the web service could create along a highway would be longer and narrower than the region you would create using a more local road based on the same amount of time or distance request. That is the concept behind the Driving Region functionality.
Chapter 16: Working with Data from a Web Service MapInfo Professional has a table for tile servers that consists of a TAB file and XML file. These files contain the information necessary to communicate with a tile server and retrieve tiles correctly. This information includes server URL, coordinate system and bounds, and other parameters for retrieving the proper tiles. After opening a tile server table in MapInfo Professional, you can add it as a layer to a map.
Enhancing Map Data using a Mapping Tile Server Adding a Layer to your Map from a Map Tile Server With a single click, you can add a Microsoft Bing layer to your map. You do not need to open the table prior to adding it to the map. If the current window is a map, MapInfo Professional adds the Bing layer to it. If the current window is not a map or there are no windows open, then MapInfo Professional creates a new map with the Bing layer.
Chapter 16: Working with Data from a Web Service To set the type of distance and area calculation to use: 1. Select Options > Preferences > Map Window. 2. In the Map Preferences dialog box, select the Projection tab. 3. In the Distance/Area using pane, either of the following: • Spherical - The Spherical calculations measure distance according to the curved surface of the Earth. Spherical is the default. The data is first converted to Latitude/Longitude and then a calculation is produced.
Enhancing Map Data using a Mapping Tile Server To resolve these errors, re-enter a valid Bing license key to the Bing Tile Services. To enter the valid key credentials: 1. On the Help menu, point to Licensing and click Bing Key to display the Bing Key Credential dialog box. 2. Type a valid value in the Enter valid key field and click Ok. The Bing Roads tile server also may require that you have a valid license for them.
Chapter 16: Working with Data from a Web Service Changing the Map Zoom to the Nearest Tile Server Level Based on a selected zoom level, a tile server provides various types of information. In MapInfo Professional, you can zoom on a tile server layer to any specified scale. In doing so, the tile server images may stretch making them appear fuzzy and pixilated. To correct for this, you can select to display tile server images at an optimal zoom level based on the tile server and current screen resolution.
Specialized Topics in MapInfo Professional The topics in this chapter cover the advanced use of MapInfo Professional. In this section: • • • • • Embedding MapInfo Professional Maps . . . . . . . . . . . . .430 Internet Connectivity and MapInfo Professional . . . . . .432 Redistricting-Grouping Map Objects into Districts . . . .433 Creating Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . .437 Working with the MapBasic Window . . . . . . . . . . . . . . .
Embedding MapInfo Professional Maps Embedding MapInfo Professional Maps MapInfo Professional brings its power of map display, creation and editing right into your favorite application so that you may build a map where you need it. This chapter covers the basics of OLE and the MapInfo Professional features that you may use in other applications to create dynamic maps.
Chapter 17: Specialized Topics in MapInfo Professional Limitations of OLE Although MapInfo Map enables you to build a map very easily in your container application, not all of MapInfo Professional's features are available in the context of map embedding. Among them are editing map objects such as regions or polylines, querying a table for further analysis, geocoding to a table in the Map window, or displaying tables in Browser windows.
Internet Connectivity and MapInfo Professional Using MapInfo Tables with Data Map Data Map uses MapInfo Professional tables. All of the sample maps provided with Data Map are actually MapInfo Professional tables. If you have created your own MapInfo Professional tables, you can use your tables in Data Map. However, before you can display your table in Data Map, you must set up your table using the Data Map Data Installer. To launch the Data Installer, double-click the file DATAINST.EXE.
Chapter 17: Specialized Topics in MapInfo Professional The active object in this map (red triangle) is linked to a webcam web site that displays an erupting volcano.
Redistricting-Grouping Map Objects into Districts districts, all the while doing calculations of the attached data on the fly for instant analysis and decision-making. What is Redistricting and How Can I Use It? Redistricting is the process of assigning map objects to groups. As you assign map objects to groups, MapInfo Professional automatically calculates totals for each group of objects, and displays the totals in a special Browser window called the Districts Browser.
Chapter 17: Specialized Topics in MapInfo Professional Note: The STATES table used in this example is from the MapInfo Professional Tutorial data, which is available from the Pitney Bowes Software Inc. web site, http://go.pbinsight.com/webtutorials. But that is only one part of the redistricting process. The real power lies in the Districts Browser where you can see on-the-fly updates of district record counts and data totals when you click a map object and assign it to another district.
Redistricting-Grouping Map Objects into Districts • For more instructions about creating and adding redistricting features and other related topics, see the Help System. For additional topics in Redistricting, see Setting up the Target District in the Help System. Using Redistricting When you calculate the percentage of partial columns (such as population columns that cite income, gender, age, ethnic background, or religious affiliation) you have two calculation methods available.
Chapter 17: Specialized Topics in MapInfo Professional Changing the display of your districts is simple. Click the fill pattern, line style, or symbol in the Districts Browser that represents the district. The Region Style, Line Style, or Symbol Style dialog box displays, where you can change the tools used to display the district. To save the style changes, you must save the redistricting session as a workspace. Save Table will only save the district assignment changes.
Creating Expressions Expressions that simply calculate some value never have a comparison operator and generally do not have multiple clauses. Use these expressions to calculate values for Thematic Mapping, Update Column, and Label With Column in Layer Settings. Constructing Simple Expressions You formulate expressions using column (field) names and constants (for example, specific data values), on the one hand, and functions and operators, on the other.
Chapter 17: Specialized Topics in MapInfo Professional Filter criteria can use any column in your base table(s), regardless of whether you included the column in the Select Columns field. Columns can be referred to by name or by number, where the number designates the order the column has in Select Columns. Thus, "col1" and "col6" refer to the first and sixth columns, respectively. The number must be preceded by the letters "col".
Creating Expressions System Order What MapInfo Professional Expects M/d/yy 02/28/2005 M/d/yyyy 02/28/2005 MM/dd/yy 02/28/2005 MM/dd/yyyy 02/28/2005 yy/MM/dd 2005/02/28 dd-MMM-yy 02-28-2005 Using Mathematical Operators in Expressions Use the Expression dialog box to formulate mathematical and alphanumeric expressions in several MapInfo Professional dialog boxes. Mathematical operators are often used in creating expressions.
Chapter 17: Specialized Topics in MapInfo Professional & (can be used if preceded by a space) Strings must be enclosed in double quotes. Consider the following example: "Ms." + Last_Name When MapInfo Professional evaluates this as part of an expression it places "Ms. "in front of each last name. Note that the string constant ("Ms. ") is in quotes. Similarly, "Hello," + "world" gives you "Hello, world." And "4"+"5" gives you "45.
Creating Expressions The following expression gives you better results: 1. Round(MED_AGE, 1)=42 Comment: The function "round(somenumber, somenumber)" rounds the first number in the way specified by the second. In this example, the first number is the median age (MED_AGE) and the second is 1, indicating that median age is to be rounded to the nearest whole number. English: All rows where the amount does not equal $23,000. 1.
Chapter 17: Specialized Topics in MapInfo Professional Comment: The column "Shipped" is a logical column. It contains "T" for true, or yes, and "F" for false, or no. When an order is shipped, it is marked "T". Otherwise, it is not shipped. For orders that are shipped, expression 28 evaluates to true. For orders not shipped it evaluates to false. English: All that have not shipped. 1. Str$(Shipped)="F" 2.
Creating Expressions Using Logical Operators in Expressions "And", "or", and "not" are logical operators. You use them to combine expressions in Select and the Where Condition clause of SQL Select. MapInfo Professional treats each such an expression as a test, which it applies to each record in the table. For each test it gets a yes/no (true/false) answer.
Chapter 17: Specialized Topics in MapInfo Professional In formulating expressions using logical operators you have to be careful how you use them. The following expression, while it seems OK, does not work: 1. COUNTY="Columbia" or "Greene" Judging from its English translation-COUNTY equals Columbia or Greene-this expression should operate just like expression 36 and give us any record containing Columbia County or Greene County.
Working with the MapBasic Window And Lowest Priority: Or For example, the expression 3+4*2 produces a result of 11. That is because multiplication has a higher precedence than addition and is performed first, in effect: 3+4*2= 3+8= 11 We can add parenthesis to force MapInfo Professional to do the addition first: (3+4)*2= 7*2= 14 Now consider expression 60, which is intended to select all records July or September of 1989. 1.
Chapter 17: Specialized Topics in MapInfo Professional that the MapBasic window is also a useful tool to MapInfo Professional users for doing certain tasks such as complex selections and queries based on object information. The MapBasic window is limited to selected commands from the MapBasic programming language. The MapBasic window can take commands line by line. It does not include the capability for looping, interapplication communication, and other more complex commands.
Working with the MapBasic Window • Overview application (OVERVIEW.MBX). Opens a second Map window that displays an overview of the current map (also referred to as an area detail map). To run a MapBasic application: 1. 2. 3. 4. Choose Tools > Run MapBasic Program. The Run MapBasic Program dialog box displays. Choose a directory. Choose an application from the list (MapBasic applications have an .mbx extension). Click OK. MapInfo Professional then runs the MapBasic application.
Keyboard Shortcuts This section contains a comprehensive list of the shortcuts available in the MapInfo Professional application. You can create custom shortcuts by editing the MAPINFOW.MNU file using a text editor. Caution: Making changes to the MAPINFOW.MNU file may cause the default shortcuts you change to stop working. Make these changes carefully and record your changes so you can change them back, if necessary. In this section: • • • • • • • • • • • • • Shortcuts for File Menu Items . . . . . . . .
Shortcuts for File Menu Items Shortcuts for File Menu Items Menu Item Keystrokes File > New Table Ctrl+N File > Open Ctrl+O File > Save Table Ctrl+S File > Save Workspace Ctrl+K File > Print Ctrl+P File > Exit Alt+F4 Shortcuts for Edit Menu Items Menu Item Keystrokes Edit > Undo Ctrl+Z Edit > Cut Ctrl+X Edit > Copy Ctrl+C Edit > Paste Ctrl+V Edit > Clear Del Edit > Reshape Ctrl+R Edit > New Row Ctrl+E Edit > Get Info F7 Shortcut to Tools Menu Items 450 Menu Item Keystroke
Appendix A: Keyboard Shortcuts Shortcuts to Objects Menu Items Menu Item Keystrokes Objects > Set Target Ctrl+T Objects > Clear Target Ctrl+Delete Shortcuts for Query Menu Items Menu Item Keystrokes Query > Unselect All Ctrl+W Query > Find Ctrl+F Query > Find Selection > In Current Map Window Ctrl+G Query > Find Selection > In All Windows Ctrl+A Shortcuts for Options Menu Items Menu Item Keystrokes Options > Line Style Shift+F8 Options > Region Style Ctrl+F8 Options > Symbol Style Al
Shortcuts for Window Menu Items Menu Item Keystrokes Map > Modify Thematic Map Alt+F9 Map > Previous View Alt+Left Arrow Shortcuts for Window Menu Items Menu Item Keystrokes Window > New Browser F2 Window > New Mapper F3 Window > New Grapher F4 Window > New Layout F5 Window > Redraw Window Ctrl+D Window > Tile Windows Shift+F4 Window > Cascade Windows Shift+F5 Shortcuts by Keystroke 452 Menu Items Keystrokes File > Exit Alt+F4 Options > Symbol Style Alt+F8 Map > Modify Themati
Appendix A: Keyboard Shortcuts Menu Items Keystrokes File > Save Workspace Ctrl+K Map > Layer Control Ctrl+L File > New Table Ctrl+N File > Open Ctrl+O File > Print Ctrl+P Edit > Reshape Ctrl+R File > Save Table Ctrl+S Objects > Set Target Ctrl+T Tools > Run MapBasic Program Ctrl+U Edit > Paste Ctrl+V Query > Unselect All Ctrl+W Edit > Cut Ctrl+X Edit > Undo Ctrl+Z Edit > Clear Del Cancel a dialog box Esc Window > New Browser F2 Window > New Mapper F3 Window > New Graphe
Shortcuts for the Map or Layout Window Shortcuts for the Map or Layout Window When the Map or Classic Layout is Active Action Keystroke Layout > Previous View and Map > Previous View Alt+Left Arrow Toggle a Large Crosshair On/Off C This shortcut switches between the standard cursor and the full-window cursor (lines extend to the edge of the window).
Appendix A: Keyboard Shortcuts Action Keystroke Trace the Long Way Around a Polyline or Region Snap mode+Ctrl in Terms of the Number of Nodes Toggle Autotrace On/Off. T When Autotrace is on, you will see "AUTOTRACE" in the statusbar at the bottom of the screen.
Shortcuts for the Browser Window Shortcuts for the Browser Window When the Browser is Active Action Keystroke Switch between open windows Ctrl+Tab Ctrl+F6 Switch between open windows in reverse order Ctrl+Shift+Tab Ctrl+Shift+F6 When Navigating between Cells in the Browser Window Action Keystroke Move current cell one cell to the left Left arrow Shift-Tab Move current cell one cell to the right Right arrow Tab Move current cell up one line Up arrow Shift+Enter Move current cell down one line
Appendix A: Keyboard Shortcuts Action Keystroke Move current cell to bottom row Ctrl+Down arrow Move to the first cell in the row Home Move to the last cell in the row End Move to the first cell in the table Ctrl+Home Move to the last cell in the table Ctrl+End When Editing Text within the Browser Window Action Keystroke Select cell content and place into edit mode Insert Exit edit mode on a cell and cancel any changes made Esc Refresh contents of window with data source Ctrl+D Add a ne
Shortcuts for the Browser Window Action Keystroke Move the cursor left to right one character at a time Right arrow Move the cursor right to left one word or group of characters at a time Ctrl+Left arrow Move the cursor left to right one word or group of characters at a time Ctrl+Right arrow Move the cursor to the left-most position of the current line Ctrl+Up arrow Home Page Up Move the cursor to the right-most position of the current line Ctrl+Down arrow End Page Down Move the cursor to the be
Appendix A: Keyboard Shortcuts Action Keystroke Select one character at a time from left to right Shift+Right arrow Select one word or group of characters at a time Ctrl+Shift+Left arrow from right to left (includes the space at the end of a word or group) Select one word or group of characters at a time Ctrl+Shift+Right arrow from left to right (includes the space at the end of a word or group Select everything from the cursor to the start of the Shift+Home line (in multi-line text) Select everything
Shortcuts for the Legend Designer Window When Selecting One or More Frames in a Legend Designer Window To select multiple legend frames in a Legend Designer window, click and drag the mouse over the legend frames. To add more legend frames to your selection, press Ctrl (or press Shift) while you click and drag the mouse over the legend frames to add to the previous selection.
Appendix A: Keyboard Shortcuts Action Keystroke Move selected legend frames down one increment Shift+Down arrow on the grid Shift+Ctrl+Down arrow Shortcuts for MapInfo Professional Action Keystroke Open the Control Menu (top left corner) Alt+Space Bar Switch Between Windows Ctrl+Tab Interrupt Query Process and Window Redraw Esc Access the Help Topic for a menu option or a dialog F1 box Toggle mouse cursor type for Label, Info, and Drawing tools MapInfo Professional User Guide X 461
Elements of a Coordinate System In this section: • Projections and Their Parameters . . . . . . . . . . . . . . . . . .464 • For More Information on Projections . . . . . . . . . . . . . . .
Projections and Their Parameters Projections and Their Parameters The next tables indicate the parameters applicable to each projection, which are listed in the order they appear in the relevant coordinate system lines in the MAPINFOW.PRJ file (the first table lists the first six parameters and the second table lists the next six parameters). The projection type is the equation or equations used by a coordinate system.
Appendix B: Elements of a Coordinate System Projection Name Projection Type Datum Units Origin, Longitude Origin, Latitude Lambert Azimuthal Equal-Area 29 X X X X† Lambert 4 Azimuthal Equal-Area (polar aspect only) X X X X† Lambert Conformal Conic X X X X X Lambert 19 Conformal Conic (Modified for Belgium 1972) X X X X X Longitude-Latitude 1 X Mercator 10 X X X Miller 11 X X X Mollweide 13 X X X New Zealand Map Grid 18 X X X X Polyconic 27 X X X X R
Projections and Their Parameters Projection Name Projection Type Datum Units Origin, Longitude Origin, Latitude Tranverse Mercator, (Modified for Danish System 34 Sjaelland) 22 X X X X Tranverse Mercator, (Modified for Danish System 34 /45 Bornholm) 23 X X X X Tranverse Mercator, (Modified for Finnish KKJ) 24 X X X X Projection Name Standard Parallel 2 Azimuth Scale Factor False Easting Albers Equal-Area Conic X Standard Parallel 1 System 34 Jylland-Fyn) X False Northing R
Appendix B: Elements of a Coordinate System Projection Name Standard Parallel 2 Azimuth Scale Factor False Easting Equidistant Cylindrical Extended Transverse Mercator False Northing X X X X X X X X X X Range Gall Hotine Oblique Mercator X Krovak Oblique Conformal Conic (JTSKc) X Lambert Azimuthal Equal-Area X Lambert Azimuthal Equal-Area (polar aspect only) X Lambert Conformal Conic X X X Lambert X Conformal Conic (Modified for Belgium 1972) X X New Zealand Map Grid X X
Projections and Their Parameters Projection Name Standard Parallel 2 Azimuth Scale Factor False Easting False Northing X X X X X Range Robinson Sinusoidal Stereographic Swiss Oblique Mercator Transverse Mercator X X X Tranverse Mercator, (Modified for Danish System 34 Jylland-Fyn) X X X Tranverse Mercator, (Modified for Danish System 34 Sjaelland) X X X Tranverse Mercator, (Modified for Danish System 34 /45 Bornholm) X X X Tranverse Mercator, (Modified for Finnish KKJ) X X X
Appendix B: Elements of a Coordinate System Number Projection Type 9 Albers Equal-Area Conic 28 Azimuthal Equidistant (all origin latitudes) 5 Azimuthal Equidistant (polar aspect only) 30 Cassini-Soldner 2 Cylindrical Equal-Area 31 Double Stereographic 14 Eckert IV 15 Eckert VI 6 Equidistant Conic, also known as Simple Conic 33 Equidistant Cylindrical 34 Extended Transverse Mercator 17 Gall 7 Hotine Oblique Mercator 32 Krovak Oblique Conformal Conic (JTSKc) 4 Lambert Azimutha
Projections and Their Parameters Number Projection Type 22 Transverse Mercator, (modified for Danish System 34 Sjaelland) 23 Transverse Mercator, (modified for Danish System 34/45 Bornholm) 24 Transverse Mercator, (modified for Finnish KKJ) Projection numbers in the MAPINFOW.PRJ may be modified by the addition of a constant value to the base number listed in the Projection table, above.
Appendix B: Elements of a Coordinate System Number Datum Name Area of Coverage Ellipsoid 1 Adindan Ethiopia, Mali, Senegal, Sudan Clarke 1880 2 Afgooye Somalia Krassovsky 1007 AGD 66, 7 parameter Australia, A.C.T.
Projections and Their Parameters 472 Number Datum Name Area of Coverage Ellipsoid 121 Bukit Rimpah Bangka and Belitung Islands (Indonesia) Bessel 1841 17 Campo Inchauspe Argentina International 18 Canton Astro 1966 Phoenix Islands International 19 Cape South Africa Clarke 1880 20 Cape Canaveral Florida and Bahama Islands Clarke 1866 1005 Cape, 7 parameter South Africa WGS 84 21 Carthage Tunisia Clarke 1880 158 CH1903+ datum for Switzerland Switzerland Bessel 22 Chatham
Appendix B: Elements of a Coordinate System Number Datum Name Area of Coverage Ellipsoid 125 Fort Thomas 1955 Nevis, St.
Projections and Their Parameters 474 Number Datum Name Area of Coverage Ellipsoid 43 ISTS 073 Astro 1969 Diego Garcia International 152 JGD2000 Japan Bessel 1841 44 Johnston Island 1961 Johnston Island International 45 Kandawala Sri Lanka Everest (India 1830) 46 Kerguelen Island Kerguelen Island International 47 Kertau 1948 West Malaysia and Singapore Everest (W.
Appendix B: Elements of a Coordinate System Number Datum Name Area of Coverage Ellipsoid 109 Netherlands Netherlands Bessel 1010 New Zealand Geodetic Datum 194, 7 parameter New Zealand International 31 New Zealand Geodetic Datum 1949 (NZGD 49) New Zealand International 62 North American 1927 (NAD Continental U.S.
Projections and Their Parameters 476 Number Datum Name Area of Coverage Ellipsoid 1002 Nouvelle Triangulation Francaise (NTF) Paris Prime Meridian France Modified Clarke 1880 111 NWGL 10 Worldwide WGS 72 117 NZGD 2000 New Zealand GRS 80 75 Observatorio 1966 Corvo and Flores Islands (Azores) International 140 Observatorio Meteorologico Corvo and Flores Islands 1939 (Azores) International 1924 76 Old Egyptian Egypt Helmert 1906 77 Old Hawaiian Hawaii Clarke 1866 78 Oman Oman
Appendix B: Elements of a Coordinate System Number Datum Name Area of Coverage Ellipsoid 112 Rikets Triangulering 1990 (RT 90) Sweden Bessel 1011 Rikets Triangulering 1990 (RT 90), 7 parameter Sweden Bessel 87 Rome 1940 Sardinia Island International 1012 Russia PZ90 Russia PZ90 1012 Russia PZ90 Russia PZ90 1013 Russia SK42 Russia SK95 1014 Russia SK95 Russia PZ90 88 Santo (DOS) Espirito Santo Island International 89 São Braz São Miguel, Santa Maria Islands (Azores) In
Projections and Their Parameters Number Datum Name Area of Coverage Ellipsoid 96 Timbalai 1948 Brunei and East Malaysia (Sarawak and Sabah) Everest (India 1830) 97 Tokyo Japan, Korea, Okinawa Bessel 1841 1015 Tokyo97 Japan Bessel 1841 98 Tristan Astro 1968 Tristan da Cunha International 99 Viti Levu 1916 Viti Levu Island (Fiji Islands) Clarke 1880 148 Voirol 1874 Tunisia/Algeria Clarke 1880 149 Voirol 1960 Algeria Clarke 1880 100 Wake-Eniwetok 1960 Marshall Islands Hough
Appendix B: Elements of a Coordinate System Number Units 5 Millimeters 9 Nautical Miles 32 Rods 8 US Survey Feet (used for 1927 State Plane) 4 Yards 2 3 1 One International Foot equals exactly 30.48 cm. 2 One Nautical Mile equals exactly 1852 meters. 3 One US Survey Foot equals exactly 12/39.37 meters, or approximately 30.48006 cm. Coordinate System Origin The origin is the point specified in longitude and latitude from which all coordinates are referenced.
Projections and Their Parameters False Northings and False Eastings Calculating coordinates is easier if negative numbers are not involved. To eliminate this problem in calculating State Plane and Universal Transverse Mercator coordinates, it is common to add measurement offsets to the northings and eastings. These offsets are called False Northings and False Eastings. They are expressed in coordinate units, not degrees. (The coordinate units are specified by the Units parameter.
Appendix B: Elements of a Coordinate System For More Information on Projections The first three publications listed are relatively short pamphlets. The last two are substantial books. We have also given addresses and phone numbers for the American Congress of Surveying and Mapping (the pamphlets) and the U.S. Geological Survey (the books). American Cartographic Association. Choosing a World Map-Attributes, Distortions, Classes, Aspects. Falls Church, VA: American Congress on Surveying and Mapping.
Manually Creating a MapInfo_MapCatalog These instructions are for manually creating a MapInfo Map Catalog and making a remote table mappable, two procedures that are necessary for geocoding remote tables. This information is designed for users who do not have access to MapInfo Professional. MapInfo Professional users would create a MapInfo Map Catalog automatically.
Manually Creating a MapInfo_MapCatalog Manually Creating a MapInfo_MapCatalog To create a MAPINFO_MAPCATALOG manually: 1. If the RDBMS requires owners and users, then create the user MAPINFO with the PASSWORD MAPINFO in the specific database where the mappable tables are located. 2. Create the table MAPINFO_MAPCATALOG in the database.
Appendix C: Manually Creating a MapInfo_MapCatalog Spatial Index Type Type Number Oracle Spatial Annotation Text 16 SQL Server Spatial (for geometry) 17 SQL Server Spatial (for geography) 18 PostGIS for PostgreSQL 19 SQL Server Spatial with M and Z values (for geometry) 20 SQL Server Spatial with M and Z values (for geography) 21 You use the XY Coordinates option when there is no index Manually Making a Remote Table Mappable For each spatial table in the remote database that you want to acce
Manually Making a Remote Table Mappable Column Name Values to Assign Example COORDINATESYSTEM as defined by MapInfo Professional. VIEW_Y_LL Lower left bounding Y value. -90 VIEW_X_UR Upper right bounding X value. 360 VIEW_Y_UR Upper right bounding Y value. 90 Earth COORDINATESYSTEM A string representing a MapInfo-supported coordinate system that specifies a map projection, Projection 1,0 coordinate units, etc.
MapInfo Map Interchange Format To ensure file format backward compatibility we provide a file version comparison in this Appendix. In this section: • File Versions and TAB, MIF/MID, and WOR Support . . .
File Versions and TAB, MIF/MID, and WOR Support File Versions and TAB, MIF/MID, and WOR Support The following table lists changes (and their implications) to versions in .tab, workspace, and other files used by MapInfo Professional.
Appendix D: MapInfo Map Interchange Format TAB X MIF-MID WOR Action X Workspaces that specify dot density color (shade ... density... color). X Workspaces that specify interleaved line style, width in points (Pen (1,2,x)). X Table uses a Datum or ellipsoid released in a specific version. :Version 4.5.2 (452) : TAB MIF-MID X X WOR Action Regional Mercator projection - number 26. Version 5.0.0 (500) : TAB MIF-MID X X WOR Action Table specifies a 'grid' file (*.
File Versions and TAB, MIF/MID, and WOR Support TAB MIF-MID WOR Action X Save a workspace with a 3D Map. X X Azimuthal Equidistant projection, Oblique aspect number 28. X X Everest (Pakistan) ellipsoid - number 50. X X ATS 77 ellipsoid - number 51. New Datums introduced in Version 6.0. Their numbers are in a range 115-150 (115 and 150 included) and 1004-1011 (1004 and 1011 included).
Appendix D: MapInfo Map Interchange Format TAB MIF-MID WOR Action X Lambert Azimuthal Equal-Area projection (Oblique aspect) for the map window. X New object types (Multipoint and Collection) created in a cosmetic layer or in a layout. X Save a workspace with a Prism Map. WOR Action Version 7.0.0 (700) : TAB MIF-MID X X TAB file linked to a shapefile. X X • #152 - JGD2000 datum used in Japan. • #1012 - PZ90 datum based on PZ90 ellipsoid. This datum is used in Russia.
File Versions and TAB, MIF/MID, and WOR Support TAB MIF-MID WOR Action X TAB files can include Web Feature Service (WFS) data. X Workspaces can include cartographic legends. The workspace will always include a clause for swatch size that cannot be parsed by earlier versions of MapInfo Professional. X Workspaces can include mappers with dot-density thematics. The workspace will always include a clause for dot size that cannot be parsed by earlier versions of MapInfo Professional.
Appendix D: MapInfo Map Interchange Format : TAB MIF-MID WOR Action X Open Table as VMGrid or VMRaster. X Raster Image Reprojection, Image Resampling. X Export with Anti-Aliasing. X Redistricting with Percentages. Version 9.0.0 (900) : TAB MIF-MID WOR Action X X X DateTime type. X X X JTSK Projection #32. X X Datum# 1020 Name: S-JTSK (Ferro Prime Meridian).
File Versions and TAB, MIF/MID, and WOR Support TAB MIF-MID WOR Action Datum#: 156 Name: Dealul Piscului 1970 - Used in Romania X Addition to Create Text statement for Pen clause for callout lines X X WFS-T X X X Popular Visualization Ellipsoid #54 X X X Popular Visualization Datum #157 X Oracle's Annotation Text type Version 10.0.
Appendix D: MapInfo Map Interchange Format TAB MIF-MID WOR Action X Any Browser that is sorted via the Browser Context menu MIF-MID WOR Action X X MGI 1901 Datum #1021 X X CH1903 Datum #158 X X Schwarzeck (updated) datum for Namibia #159 X X North Sahara #1022 X Browser window with Filter conditions (Set Browse Filter statement) X Browser window with hidden toolbar (Set Window FrontWindow( ) Toolbar Off statement) X Legend Designer legend windows (Create Designer Legend statement)
File Versions and TAB, MIF/MID, and WOR Support TAB MIF-MID WOR Action X X X Extended Transverse Mercator projection. In MapBasic, using CSYS_TM_EXTENDED (34). X Saving a Map window with a Cartographic scale, and calling the MapBasic Set Map statement with the Display Scale Cartographic clause. X Auto position turned on for polygon labels. X Auto position along line or fallback position turned on for curved labels. X Abbreviations turned on for labels.
Appendix D: MapInfo Map Interchange Format character sets, you can determine the correct syntax for your character set by exporting a table and examining the .MIF file in a text editor. Delimiter Specify the delimiting character in quotation marks, for example: DELIMITER ";" The default delimiter is Tab; if you are using the default, you do not need the DELIMITER line. Unique Specify a number. This number refers to a database column; 3 is the third column, 7 is the seventh column, and so forth.
File Versions and TAB, MIF/MID, and WOR Support Syntax3 CoordSys Layout Units paperunitname Syntax4 CoordSys Table tablename Syntax5 CoordSys Window window_id type is a positive integer value representing which coordinate system to use datum is a positive integer value identifying which datum to reference unitname is a string representing a distance unit of measure (for example, ¯m" for meters); for a list of unit names, see Set Distance Units origin_longitude is a float longitude value, in degrees origin_l
Appendix D: MapInfo Map Interchange Format To transform quadrant 2 data into quadrant 1 data, use the following transform clause: TRANSFORM -1,0,0,0 The zeroes instruct MapInfo Professional to ignore that parameter.
Glossary of Terms In this section: • Glossary of Terms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Glossary of Terms Glossary of Terms 502 Term Definition 3DMap A window that allows you to view your maps containing continuous grids from various viewpoints in 3D Format. Add Node button Use the Add Node button to add a node to regions, polylines, and arcs. You can add nodes when the Reshape tool is in effect. Adding nodes can give more precision to your object. address dictionary The search dictionary used for matching addresses during geocoding.
Appendix E: Glossary of Terms Term Definition convention the X-axis is horizontal, the Y-axis is vertical. bar chart A type of thematic map that displays a bar chart of thematic variables for each record in a table from which the map is based. base map Usually the dominant or underlying layer in a given map. (These are typically the data layers that Pitney Bowes Software Inc. offers as ready products.
Glossary of Terms Term Definition assessment roles, and tax maps comprise the cadastre. Cancel button A command button for closing a dialog box without making changes. Cartesian A coordinate system using an x,y scale not tied to any "real-world" system. Most CAD drawing uses this method of registering objects (for example, a drawing of a ball-bearing assembly, floor plans). If a drawing uses Cartesian coordinates, one corner of the drawing probably has coordinates 0, 0.
Appendix E: Glossary of Terms Term Definition forth. The information for each object is listed on a row in the Browser. command A word or phrase, usually found in a menu, that displays a dialog box and/or carries out an action. conflict resolution When conflicts exist between the data residing on a remote database and new data that you want to upload to the remote database via a MapInfo Professional linked table.
Glossary of Terms 506 Term Definition data disaggregation A process that occurs when splitting a map object(s) into smaller parts where MapInfo Professional splits the data associated with the map object(s) into smaller parts to match the new map objects. data sources An ODBC data source is an SQL database and the information you need to access that database. For example, an SQL Server data source is the SQL Server database, the server on which it resides, and the network used to access that server.
Appendix E: Glossary of Terms Term Definition digitizer, digitizing tablet An electronic device that lets you trace a paper map into a GIS or CAD package. The digitizer consists of a table (or tablet) onto which you attach a paper map. You then can trace the map by moving a hand-held, mouse-like device known as a cursor, or puck, across the surface. Digitizing a map produces vector data as the end result. districts browser A special browser that displays when redistricting.
Glossary of Terms 508 Term Definition fill pattern The design and color used to fill a closed object. FLEXNet Operations module (FNO) The Pitney Bowes Software database that maintains product entitlements and information about their activation. font A character set based on a particular style used for text characters. Frame button The Frame button allows you to create frames in a classic Layout window.
Appendix E: Glossary of Terms Term Definition Grid Surface map A type of thematic map that displays data as continuous color gradations across the map. This type of thematic map is produced by an interpolation of point data from the source table. A grid file from the data interpolation is generated and is displays as a raster image in a Map window. heads-up digitizing A method of digitizing where the user creates vector objects by tracing over a raster image displayed on the screen.
Glossary of Terms Term Definition a list of all objects at that location. You can then choose an object from the list and view the tabular data for that object. 510 islands Small areas outside the main boundary that can be reached within the specified time or distance. IsoChrone An IsoChrone is a polygon or set of points representing an area that can be traversed from a starting point in a given amount of time along a given road network.
Appendix E: Glossary of Terms Term Definition legend The part of a map, which explains the meaning of different colors, shapes, or fill patterns used on the map. See also What is a Legend?. legend frames Each Legend Designer window contains one or more legend frames each corresponding to a style or theme layer in the Map window. Legend Designer window A window containing legend frames. You can create more than one Legend Designer window for each map.
Glossary of Terms Term Definition Main toolbar A window containing buttons for choosing tools, accessing dialog boxes, and showing or hiding windows. MapBasic The programming language used to customize and/or automate MapInfo Professional. To create MapBasic applications, you need the MapBasic compiler, which is a separate product. However, you do not need the MapBasic compiler to run a compiled MapBasic application.
Appendix E: Glossary of Terms Term Definition Military Grid Reference System The U.S. Military Grid Reference System (MGRS) is a grid reference system that MapInfo Professional supports when displaying maps in a Map window. It is the military version of the civilian-use Universal Transverse Mercator (UTM) grid system. Military grid references are very similar to the mathematical Cartesian x,y system in which coordinates are giving in terms of x (easting) and y (northing).
Glossary of Terms Term Definition We maintain support for these features and add support for Cartographic Text and Departed Features. MapInfo Professional will continue to support GML files as the OSGB updates the schema that underlies the GML technology. As the GML format gets more sophisticated in its support of additional layers, feature types, and attributes, we will continue to provide full support for those changes.
Appendix E: Glossary of Terms Term Definition a boundary can consist of more than one polygon). The Polygon tool creates a single polygon. Polygon button The Polygon button allows you to access the Polygon tool. Use the Polygon tool to draw polygons one side at a time. polygon overlay A spatial operation that merges overlapping polygons from two layers to analyze those intersected areas or to create a third layer of new polygons.
Glossary of Terms 516 Term Definition raster image A type of computerized picture consisting of row after row of tiny dots (pixels). Raster images are sometimes known as bitmaps. Aerial photographs and satellite imagery are common types of raster data found in GIS. A computer image can be represented in raster format or in vector format. See scanning and vector image. record All the information about one object in a database or table. A record in a table corresponds to a row in a Browser.
Appendix E: Glossary of Terms Term Definition polylines, lines, and points by moving, adding, and deleting nodes that define line segments. You can also copy and paste selected nodes to create new polylines. Reshape is very useful when you are creating sales territories or other merged boundaries. For example, you are merging ZIP Code boundaries to create school districts. Some ZIP Code boundaries fall into more than one school district.
Glossary of Terms 518 Term Definition selection A data item or set of data items chosen for inspection and/or analysis. Regardless of the kinds of windows on the screen, selections can be made using the Select and SQL Select Query commands in MapInfo Professional's Query menu. In Browsers and Map windows, items can be placed in the selection set by clicking on them individually. Map windows also have special tools for selecting multiple items on a spatial basis.
Appendix E: Glossary of Terms Term Definition commands or with MapBasic commands in the MapBasic window. stacked style A list of styles drawn on top of each other to create a more complex or interesting map feature. Stacked styles apply to points, polylines, and polygon features. standard deviation A measurement of the variation of a set of data values around the mean. Standard toolbar A window containing buttons for quick access to the most commonly used menu commands such as Cut, Copy, and Paste.
Glossary of Terms Term Definition represent a point object (for example, a customer location). 520 Symbol button The Symbol button allows you to access the Symbol tool. Use the Symbol tool to place point symbols (push pins) on your map. Symbol Style button Use the Symbol Style button to access the Symbol Style dialog box. The Symbol Style dialog box allows you to display symbols and specify attributes for symbols. The attributes you can specify are size, color, and symbol type.
Appendix E: Glossary of Terms Term Definition another region in very pale red (to indicate the region has relatively few customers). thematic shading Map objects - points, lines, regions - that have been shaded, using a pattern and/or color, according to some point of information about the object, or theme (population, size, annual rainfall, date, and so forth). thematic variable The data values displayed on a thematic map. A thematic variable can be a field or expression.
Glossary of Terms Term Definition precision by specifying the use of those coordinates within the grid system defined by the Military Grid Reference System (MGRS). Additionally, it addresses specific presentation issues such as grid spacing. The UTM coordinate representation, the MGRS grid, and the specific grid presentation requirements together define the USNG. vector image A coordinate-based data structure commonly used to represent map features.
Appendix E: Glossary of Terms Term Definition web services is that you can use them to create more powerful maps or in the case of geocoding or drive region services get more accurate and precise results using the same data. weighted average An average that gives more weight to one value over another when averaging. A method of averaging that uses a separate column of information to define the relative importance of each data value.
Index *.pcx files 353 raster format 353 3D graphs 144, 155–158 choosing a 3D graph viewing angle 158 customizing cube walls 157 moving at an angle 157–158 panning 156 rotating 156 templates 144 using the 3D viewing angle 155–156 3DMaps 115, 502 defined 502 setting hardware acceleration defaults 115 A Access tables 45, 364 creating .
automatic 312–313, 315, 317 labeling 312–313, 315, 317 autotrace 218 tracing existing objects 218 axis, defined 502 Azimuthal projections, range 401, 480 B bar charts 266, 273, 503 defined 503 maps 266 template 273 bar graphs 145 base maps, defined 503 base tables, defined 503 BIL files, raster format 353 Bing Aerial tile server 424 adding layer to map 424 Bing Hybrid tile server 424 adding layer to map 424 Bing Roads tile server 424 adding layer to map 424 bitmap (*.
convex hull 295 buffers 295 coordinate systems 397–400, 403–405, 468, 470, 479, 505 converting from one datum to another 399 creating 404 defined 505 elements of 405 entering a new projection for 404 origin point 400, 479 parameters of 397 projection types 468, 470 projections 397–398 specifying the bounds in 398 using a new projection in 403 coordinates 117, 352, 355, 374, 392, 407, 423, 505 defined 505 determining map 352 displaying 392 geocoding 374 raster image control points 355 setting display default
decimal degrees 117, 506 defined 506 setting display coordinate defaults 117 default, defined 506 degrees latitude defined 506 degrees longitude defined 506 degrees/minutes/seconds 117 setting default coordinate display 117 Delete Selected Frames menu option 346 deleting 138, 203, 328 frames in Layout Designer 328 nodes 203 tables 138 derived columns 241, 250, 506 defined 506 described 241 using 250 digitizer 507 defined 507 digitizing 357, 507 raster images 357 tablet 507 directory preferences 92, 100 defi
exporting 332 layout 332 exporting files 84, 87, 126, 348, 359, 367, 507 export defined 507 GeoTIFF format 84 layouts 348 setting output preferences 126 supported file formats 87 supported formats 87 to comma delimited (csv format) 367 translucent images 359 expressions 236–237, 312, 437–439, 442, 445, 507 character strings in 439 creating 236–237, 438 date values in 439 defined 507 entering specific values (constants) 439 labeling with 312 numbers in 439 operator precedence 445 operators 442 where you can
Grid Converter 79 specifying inflection values 79 grid image files 100, 125, 286 setting default display 125 setting default open and save directories 100 using 286 grid layers 52, 78, 115 opening 52 setting zoom layering defaults 115 using layer control with 78 grid surface maps 79, 115, 286–287, 509 adjusting translucency 79 defined 509 specifying default handlers 115 uses 286 vertical mapper grid handler 287 grouping by columns 243 creating subtotals 243 guidelines 330 removing in a layout 330 show or hi
layers (continued) characteristics of seamless 81 creating buffer 292 defined 52 displaying layer of current selection 26 displaying object attributes 74 making layers selectable 76 objects in 53 opening seamless 80 reordering using layer control 72 saving thematic map 279 seamless 80–81 search paths for seamless map tables 82 selecting for map legends 343 selecting objects in 76 thematic 262–263 with Info tool 75 working with thematic 77 layout 226, 328, 331–332 bringing objects to the front 328 moving 328
longitude/latitude coordinates (continued) longitude/latitude, defined 511 Longitude/Latitude Projection, map example 393 Lotus 1-2-3 tables 368 creating .
measure new frame location 328 menu 450 shortcuts 450 menu shortcuts 451–453 meridian, defined 512 message URL http 365 //fdo.osgeo.org 365 //www.sqlite.
opening 43, 45, 48, 50, 52, 56, 58, 63, 86, 141, 321, 324, 354, 368, 374 an existing report 141 ASCII files (.txt) 45 data files 45 dbase (.dbf) files 45 ESRI shapefiles 368 Excel (.xls, .
preferences (continued) Style 92, 111 System Settings 92 Web Services 92 print OSBM 332 layouts 332 Printer preferences 55, 92, 122 defined 92 specifying 122 storing information in workspaces 55 printing 125, 205, 331, 346, 359, 387–389 fill patterns 205 layout 331 Layout windows 346 map windows 388 page setup 387 setting defaults 125 text 388 translucent images 359 troubleshooting 389 prism maps 388 viewing a previous prism map 388 projections 358, 397, 399–402, 464, 468–481, 515 additional resources 481 c
region styles 202, 306 change styles tool button 202 regions 79, 159 saving a clipped region 159 specifying transparent fill patterns 79 registering 370, 430 ASCII data 370 OLE objects with containers 430 registering a raster image 355, 357, 516 control point coordinates 355 modifying control points 357 registration, defined 516 remote database tables 50, 100, 164–165, 178, 183, 185, 190–192, 484 conflict resolution 190–191 disconnecting from 192 disconnecting from database 192 linked tables 185 mapinfo_map
selecting from the screen (continued) making layers selectable 226 multiple nodes 215 selectable layers 226 tool buttons 227 Selection menu button 59 selection tools 81 seamless layers 81 selections 111, 158–159, 224, 230 cancelling 230 defined 224 in graphed tables 158–159 inverting 230 specifying map highlighting 111 Send to Back command 335 server authentication 410 web services 410 servers 415–416 web feature service 415–416 setting 331 margins for a layout when printing 331 shapefiles 100, 368 opening
subselect, defined 519 support 27 technical support 27 supported file formats 353, 362 opening files in MapInfo Professional 362 raster images 353 surface graphs 147 Symbol button, defined 520 Symbol Style button, defined 520 symbol styles 192, 202, 208, 308 changing 208, 308 mappable DBMS tables 192 style change tool button 202 symbols 208–209, 519 custom 209 defined 519 drawing 208 supported fonts 208 system requirements 196, 430 MapInfo Map application 430 Oracle Spatial 196 system settings preferences 9
text objects 210, 318 using text in maps 210 with labels 318 Text Style button 520 Text Style button, Browser window 59 Text Style menu option, Browser menu 59 text styles 202, 309 Text tool 439 entering text using 439 TGA files, raster format 354 thematic layers 77 setting order using layer control 77 using with layer control 77 thematic maps 260–263, 273–275, 277–280, 286, 324, 520–521 as layers 277 defined 520 expressions with 261 grid surface 286 joining tables in 262 layers 262–263, 520 modifying 278 m
US National Grid Reference, setting default 117 US_ZIPS.