Pitney-bowes MapInfo Professional Uživatelský manuál Strana 251
- Strana / 540
- Tabulka s obsahem
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
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.
Creating Column Aliases
When MapInfo Professional creates a derived column, it uses the expression itself as the name for that
derived column, which can be awkward. You can, however, specify an alias for the column. For example,
the population density column in our DENSITY Browser was titled:
• Population / Area(obj, "sq mi")
To rename the column, add the new name to the Select Columns box when listing the columns.
The alias must follow the expression. It must also be separated from the expression by a blank space
and enclosed in quotes. For example:
• Country, Population / Area(obj, "sq mi") "POP_DENSITY"
When MapInfo Professional creates the temporary query table, the population density column will now
be named POP_DENSITY.
You can use aliases to rename any column in a table, not just derived columns. For example, if each
country in your table is a separate sales territory for your corporation, you might want to rename the
Country column "TERRITORY". The procedure is identical:
• Country "TERRITORY", Population / Area(obj, "sq mi") "POP_DENSITY"
For another example, see Example - Computing Total World Population Density in the Help System.
Aggregating Data
When you aggregate data, you perform a mathematical operation on all of a column's values in all of
the records in your table. Unlike the Select command, which only allows you to perform mathematical
functions on individual records, SQL allows you to aggregate (or summarize) data across records.
MapInfo Professional looks for each unique set of data values in the specified column or columns and
creates one row for each such unique set. When you aggregate data, you need to specify:
• How the records will be grouped.
• How the data will be aggregated (summarized).
For example, you have a table of sales representatives and their sales figures for the past three months:
SALESMONTHSALES_REP
1200MayJohn
900MayCathy
1100MayJulie
900JuneJohn
251MapInfo Professional User Guide
Chapter 9: Selecting and Querying Data
- MapInfo Professional 1
- Copyright 5
- Contents 7
- MapInfo Professional 12.58 8
- MapInfo Professional 12.510 10
- MapInfo Professional 12.512 12
- MapInfo Professional 12.514 14
- MapInfo Professional 12.516 16
- MapInfo Professional 12.518 18
- MapInfo Professional 12.520 20
- Introduction 21
- What is MapInfo Professional? 22
- Getting Support 26
- Getting Technical Support 27
- Tell Us What You Think! 28
- What's New in MapInfo 29
- Professional 29
- New Layout Designer Window 30
- Data Access Features 32
- Sample Data Enhancements 32
- New and Existing Tools 33
- The Basics of MapInfo 35
- Starting MapInfo Professional 36
- Exiting MapInfo Professional 36
- Working with Toolbars 37
- An Overview of the Toolbars 37
- Support for Raster Images 44
- Opening MapInfo Tables 48
- Opening Data in Remote Tables 50
- What is a Layer? 52
- Map Objects as Part of Layers 53
- Managing a Map's Layers 53
- Using Workspaces 54
- About the Browser Format 57
- Accessing the Table List 64
- About the Table List Window 64
- Sorting in the Table List 66
- Searching the Table List 67
- Accessing Layer Control 68
- Adding Layers to the Map 71
- Reordering Map Layers 72
- Setting the Zoom Layering 72
- Positioning and Sizing Labels 73
- Getting Layer Information 75
- Selecting Objects in a Layer 76
- Working with Thematic Layers 77
- Working with Seamless Layers 79
- Add to Library 83
- Saving a MapInfo Workspace 84
- Closing a Table 86
- Opening vs. Importing 86
- Cropping Images 87
- Exporting to ASCII Format 88
- Configuring MapInfo 91
- Professional Preferences 91
- Summary of Preferences 92
- Setting Your Preferences 92
- Setting Your Default Units 94
- Setting Your Undo Options 94
- Setting Your Color Defaults 95
- Creating a Startup Workspace 99
- Using Search Directories 101
- Setting up a Geocoding Server 107
- Setting up a Routing Server 109
- Printing Caveats 123
- Understanding Your Data 129
- Working with MapInfo Tables 130
- Updating a Table 131
- Appending Rows to a Table 132
- Creating a New Table 136
- Copying and Renaming a Table 138
- Deleting a Table 138
- Packing a Table 138
- Browsing a Table 140
- Opening an Existing Report 141
- Saving a Report 141
- Graphing Your Data 143
- Graphing Terms 144
- 3D Graphs 144
- Area Graphs 145
- Bar Graphs 145
- Bubble Graphs 145
- Column Graphs 145
- Histogram Graphs 146
- Line Graphs 146
- Pie Graphs 146
- Scatter Graphs 146
- Editing a Graph 148
- Exploding a Pie Graph 154
- Saving a Graph 159
- Using Graph Templates 159
- Location Preferences 160
- Saving a Graph Template 160
- Chapter 6: Graphing Your Data 161
- Working with Data in a 163
- Getting Started 164
- Requirements 165
- SQL Server Data Support 175
- PostGIS Data Support 175
- Oracle Data Support 176
- Making a Table Mappable 181
- Opening a DBMS Table 185
- Creating a New DBMS Table 187
- Saving a DBMS Table 190
- Databases 193
- Working with PostGIS Tables 194
- Drawing and Editing Objects 201
- Drawing Objects 203
- Object Styles 205
- Printing Fill Patterns 205
- Drawing Symbols 208
- Working with Custom Symbols 209
- Working with Text on the Map 210
- Editing Objects 211
- Reshaping Map Objects 215
- Autotracing Objects 218
- Merging One Map into Another 219
- Selecting and Querying Data 223
- Characteristics of Selections 225
- Selecting from the Screen 226
- Selecting Tools 227
- Using the Radius Select Tool 228
- Using the Marquee Select Tool 229
- Using the Polygon Select Tool 229
- Selecting and Using Queries 231
- Creating Query Expressions 236
- Saving Queries 243
- Using Templates for Queries 250
- Deriving Columns 250
- Creating Column Aliases 251
- Aggregating Data 251
- Joining Two or More Tables 255
- Creating Thematic and Other 259
- Themed Maps 259
- Planning Your Thematic Map 261
- Methods of Thematic Mapping 262
- Types of Thematic Maps 263
- Ranged Maps 264
- Bar Chart Maps 266
- Pie Chart Maps 267
- Graduated Symbol Maps 268
- Dot Density Maps 269
- Individual Value Maps 271
- Grid Surface Maps 272
- Creating a Thematic Map 273
- Thematic Maps as Layers 277
- Modifying a Thematic Map 278
- Using the Theme Templates 278
- Saving Your Thematic Settings 279
- Adding Temporary Columns 285
- Working with Grid Handlers 287
- Buffering and Working with 289
- Buffering Your Data 290
- Buffer Methods 293
- Types of Buffers 293
- Clipping a Region of a Map 298
- Clearing a Target 300
- Splitting Objects 301
- Combining Selected Objects 302
- Creating a Voronoi Polygon 303
- Stylizing Your Map for 305
- Presentations and 305
- Publishing 305
- Changing a Map's Style 306
- Changing a Line's Style 307
- Changing the Text Style 309
- Labeling Your Map 310
- Choosing the Label Content 311
- Using AutoLabeling 312
- Creating Callouts 316
- Label Styles 317
- Labeling Interactively 318
- Using Text Objects as Labels 318
- Saving Labels 319
- Working with Layouts 320
- Editing the Map Display Style 322
- Image Not Found 326
- Moving Frames 328
- Resizing Frames 329
- Printing Your Layout 331
- Exporting Your Layout 332
- What is a Layout Window? 333
- Working in the Layout Window 334
- Before You Create a Layout 335
- Creating a Layout Window 337
- Using Map Legends in a Layout 340
- Cloning a Map View 342
- What is a Legend? 342
- Creating a Map Legend 343
- Printing Your Project 346
- Exporting a Layout 348
- Registering Raster Images 351
- Working with Raster Images 352
- Raster Image Format Details 353
- Opening a Raster Image 354
- Reprojecting a Raster Map 355
- Putting Your Data on the 361
- Displaying your SQLite Data 365
- Opening SQLite Tables 366
- Displaying your dBase Data 367
- Using Universal Data Directly 371
- Working with the FME Suite 373
- Importing Graphic Files 374
- Modes of Geocoding 376
- Methods of Geocoding 376
- Finding an Exact Street Match 377
- Placing Geocoded Points 379
- Matching Street Names 379
- Matching Address Numbers 380
- Matching to Region 380
- Result Codes 383
- Ungeocoding a Table 383
- Geocoding Data using a Server 384
- Finding Data on your Map 385
- Viewing a List of Open Tables 386
- Printing Your Results 387
- Printing Your Map 388
- Viewing and Printing Text 388
- Working with Coordinate 391
- Systems and Projections 391
- Displaying Coordinates 392
- Projection Types 397
- Coordinate System Origin 400
- Range (Azimuthal Projections) 401
- What is Precision? 405
- Working with Data from a 409
- Web Service 409
- Introduction to Web Services 410
- WFS Server Requirements 415
- Tile Server Authentication 423
- Bing Licensing 425
- Working with Tile Servers 426
- Specialized Topics in 429
- What You Should Know First 430
- Limitations of OLE 431
- Working with Embedded Maps 431
- What Are Active Objects? 432
- HTML Landing Pages 433
- Using the Districts Browser 435
- Using Redistricting 436
- Options in Redistricting 436
- Creating Expressions 437
- Accessing the MapBasic Window 447
- Running a MapBasic Program 447
- Keyboard Shortcuts 449
- Shortcuts for File Menu Items 450
- Shortcuts for Edit Menu Items 450
- Shortcut to Tools Menu Items 450
- Shortcuts for Map Menu Items 451
- Shortcuts by Keystroke 452
- When the Browser is Active 456
- Elements of a Coordinate 463
- Projection Types List 468
- Projection Datums 470
- Polyconic Projection 480
- Contact Information 481
- Manually Creating a 483
- MapInfo_MapCatalog 483
- MapInfo Map Interchange 487
- Delimiter 497
- CoordSys Clause 497
- Transform Clause 498
- Glossary of Terms 501
Související produkty a manuály pro Software Pitney-bowes MapInfo Professional
Software Pitney-bowes MapMarker USA Uživatelský manuál
(334 stránky)
(334 stránky)
Zanussi F1032 manuales
Manuales del propietario y guías del usuario para Lavadoras Zanussi F1032.
Ofrecemos 1 manuales en pdf Zanussi F1032 para descargar gratis por tipos de documentos: Manual de usuario
Zanussi F1032 Manual de usuario (21 paginas)
Marca: Zanussi | Categoria: Washing machines | Tamaño: 0.83 MB |
Tabla de contenidos
Más productos y manuales para Lavadoras Zanussi
| Modelos | Tipo de documento |
|---|---|
| FLS472 |
Manual de usuario
ZANUSSI FLS472 Manuale utente,
19 paginas
|
| ZWH3125 |
Manual de usuario
ZANUSSI ZWH3105 User Manual,
25 paginas
|
| ZWG6165 |
Manual de usuario
ZANUSSI ZWG6165 Manuel utilisateur,
60 paginas
|
| ZAFFIRO1400 |
Manual de usuario
ZANUSSI ZAFFIRO1400 Benutzerhandbuch,
24 paginas
|
| FI1073 |
Manual de usuario
ZANUSSI FI873 User Manual,
23 paginas
|
| FLS1386W |
Manual de usuario
ZANUSSI FLS1386W User Manual,
27 paginas
|
| WDI1003 |
Manual de usuario
ZANUSSI WDI1003 User Manual,
27 paginas
|
| ZWG1140M |
Manual de usuario
ZANUSSI ZWG1140M User Manual,
20 paginas
|
| FLS874CN |
Manual de usuario
ZANUSSI FLS874CN User Manual,
19 paginas
|
| FLS572 |
Manual de usuario
ZANUSSI FLS572 User Manual,
19 paginas
|
| ZT102 |
Manual de usuario
ZANUSSI ZT102 User Manual,
24 paginas
|
| FLS1383W |
Manual de usuario
ZANUSSI FLS1383W User Manual,
27 paginas
|
| ZDIS102W |
Manual de usuario
ZANUSSI ZDIS102W Handleiding,
48 paginas
|
| FL12INPUT |
Manual de usuario
ZANUSSI FL12INPUT Benutzerhandbuch,
28 paginas
|
| ZJ124 |
Manual de usuario
ZANUSSI ZJ124 User Manual,
24 paginas
|
| IZ1600 |
Manual de usuario
ZANUSSI IZ1600 User Manual,
24 paginas
|
| ZWF365 |
Manual de usuario
ZANUSSI ZWF365 User Manual,
55 paginas
|
| FLS572C |
Manual de usuario
ZANUSSI FLS572C User Manual,
19 paginas
|
| FLS1383W |
Manual de usuario
ZANUSSI FLS1383W User Manual [en] ,
27 paginas
|
© 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.083 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce