Querying and Selecting Data

Selecting features from a geographic layer or rows from a standalone attribute table is one of the most common GIS operations. Queries are created to enable these selections, and can be either attribute or spatial queries. Attribute queries use SQL statements to select features or rows through the use of one or more fields or columns in a dataset. An example attribute query would be "Select all land parcels with a property value greater than $500,000". Spatial queries are used to select features based on some type of spatial relationship. An example might be "Select all land parcels that intersect a 100 year floodplain" or perhaps "Select all streets that are completely within Travis County, Texas". It is also possible to combine attribute and spatial queries. An example might be "Select all land parcels that intersect the 100 year floodplain and have a property value greater than $500,000".

In this article by Eric Pimpler, author of Programming ArcGIS 10.1 with Python Cookbook, we will cover the following recipes:

• Constructing proper attribute query syntax

• Creating feature layers and table views

• Selecting features and rows with the Select Layer by Attribute tool

• Selecting features with the Select by Location tool

• Combining spatial and attribute queries with the Select by Location tool

Getting Started with PrimeFaces

The purpose of the article, PrimeFaces—the rapidly evolving, JSF component suite, is to address a wide audience interested in modern, trend-setting Java or JEE web development. In this article by Mert Çalışkan and Oleg Varaksin, authors of PrimeFaces Cookbook, we will be provided with a sneak preview on some of the prime features of PrimeFaces, such as the AJAX processing mechanism and resource handling with Internationalization and Localizaiton, along with the necessary steps to implement a simple web application using PrimeFaces, which will give a head start to the user.

In this article  we will cover:

• Setting up and configuring the PrimeFaces library

• AJAX basics with Process and Update

• Internationalization (i18n) and Localization (L10n)

• Improved resource ordering

• PrimeFaces scaffolding with Spring Roo

Learning to Fly with Force.com

In this article by Ankit Arora and Abhinav Gupta, the authors of the book Force.com Tips and Tricks, we will focus on the basics of cloud computing and briefly go over the following:

• Principles and constructs of Force.com

• Benefits and building blocks of Force.com

• When to choose this platform

• Which edition is right for you?

• A cursory overview of how to manage your Salesforce.com org

Advanced Hadoop MapReduce Administration

In this article by Srinath Perera and Thilina Gunarathne, authors of Hadoop MapReduce Cookbook, we will cover:

• Tuning Hadoop configurations for cluster deployments

• Running benchmarks to verify the Hadoop installation

• Reusing Java VMs to improve the performance

• Fault tolerance and speculative execution

• Debug scripts – analyzing task failures

• Setting failure percentages and skipping bad records

• Shared-user Hadoop clusters – using fair and other schedulers

• Hadoop security – integrating with Kerberos

• Using the Hadoop Tool interface

Creating weapons for your game using UnrealScript

In this article by Dave Voyles, author of UnrealScript Game Programming Cookbook, we will learn how we can create a gun that fires homing missiles, a gun that heals pawns, and a weapon that can damage over time.

Creating a Custom HUD

In this article by John P. Doran, the author of the book, Mastering UDK Game Development, we will guide us in creating a HUD that can be used within a Medieval RPG and will fit nicely into the provided Epic Citadel map making use of Scaleform and ActionScript 3.0 using Adobe Flash CS6.

We can have the most fun game in the world, but if the player has no idea what's going on it is next to impossible for that fun to be experienced by anyone other than the creator. One of the main tools that we use within the game industry to pass on information to the user is a heads—up display, more commonly referred to as a HUD.

The tool that most modern—day games use for doing user—interface (UI) work, such as HUDs, is Scaleform. Scaleform has been used with great success in Unreal games such as Borderlands 2, Mass Effect 3, XCOM: Enemy Unknown, and Bioshock Infinite.

Scaleform allows users to bring in Flash animation files to UDK to be rendered directly on the screen or rendered onto textures that can be used within the game world. We can interact with these movies using both Kismet and UnrealScript to create whatever kind of interface you can dream of.

Inventorying Servers with PowerShell

This article explains how to inventory the hardware and software configurations of Windows 8 Servers and create a detailed inventory and configuration report. Additionally, this article will cover methods to track configuration changes over time, export the configuration report via Word. This article should cover everything necessary to create a centralized hardware and software inventory of all servers in the enterprise.

This article by Ed Goad, author of Windows Server 2012 Automation with PowerShell Cookbook, covers the following topics:

• Inventorying hardware with PowerShell

• Inventorying the installed software

• Inventorying system configuration

• Reporting on system security

• Creating a change report

• Exporting a configuration report to Word

Creating your first VM using vCloud technology

This article by Daniel Langenhan, author of Instant VMware vCloud Starter [Instant] explains how we can create our first VM in vCloud using VMware vCloud Director.

We first have to get vCloud Director installed then we can start playing with it. Our first aim is obviously to deploy a VM inside our vCloud. To do that, we have to assign resources (CPU memory and disk) to vCD for consumption. In step 1 we will learn about all the different types of resources, and in steps 2 to 5, we will build them. Step 6 finally builds a vApp. Last but not least, I will give you some ideas about what to explore next.

Basic use of Local Storage

In this article by Alex Libby, the author of the book, Instant HTML5 Local Storage How-to, we will discuss about HTML5 Local Storage.

When using HTML5 Local Storage, there are two types that you can use—local storage and session storage. We'll begin by looking at the former first, using a simple form as the basis for our article.

Creating and optimizing your first Retina image

This article by Kyle Larson, author of Website Optimization for Retina Display How-to, will help you create a high-density image and implement it using the HTML <img> tag. You will also learn the importance of consistent file names. It also explains techniques for optimizing images, what tools are available, and why it matters for speed. and using Photoshop and GIMP to edit images

Content Switching using Citrix Security

In this article by Carmel Jacob, author of Citrix Security How-to, we will cover the implementation of content switching.

CS is the ability to redirect traffic based on content file extensions and, going a step further, in redirecting based on geographical locations. Multiple hostnames can be mapped to the same CS VIP using the server name indication feature from NetScaler 9.2 onwards. Starting with the NetScaler version 10 software, the version of MySQL software can be set for content switching virtual servers (this is to avoid compatibility problems between the client and server).

Migrating Data

Microsoft Dynamics NAV 2013 is an Enterprise Resource Planning ( ERP ) system targeted at small and medium-sized companies. In this article by Laura Nicolàs Lorente and Cristina Nicolàs Lorente from the book Implementing Microsoft Dynamics NAV 2013, we will see which tools can be used in Dynamics NAV to migrate data into the system and how to convert data to meet NAV requirements. We will look at tools such as:

• RapidStart Services

• XMLport

• User defined tools

We will also see what kind of data is commonly migrated to Dynamics NAV and which strategies can be used to migrate it. The kind of data and strategies are listed as follows:

• Master data

• Open entries

• Historical data

• Open documents

Follow the Money

This article prepared by Stephen D. Kelly, author of Oracle Primavera Contract Management, Business Intelligence Publisher Edition v14 , In this we will look into the details of managing the money side of your project. These are the nuts and bolts of the core of PCM.

The money is at the core of PCM. All documents in PCM related to money are also related to a specific contractual relationship defined in PCM (trends being a possible exception). And since the contractual relationship is the center of the universe as far as PCM is concerned, it follows that managing the money is at the core of the system. If you understand the information in this article you will be far ahead of most users of PCM, and all the other articles will make more sense.

So, what is Django?

In this article written by Mauro Rocco, authors of Instant Django 1.5 Application Development Starter , you will find out what Django actually is, what you can do with it, and why it's so great.

Examining the Oracle Architecture

In this article by Steve Ries author of OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide, we will explore what Oracle has to offer. It covers the Oracle architecture and how it operates to provide data integrity and high performance in an Oracle system.

In this article we will:

• Understand the distinction between a database and an instance

• Explore the Oracle instance

• Understand Oracle's process architecture

• Examine the Oracle memory cache architecture

• Explore the Oracle database

• Investigate Oracle's datafile structure

Installing and Setting up Sure Step

The article, Microsoft Dynamics AX 2012 with Sure Step 2012, provides a comprehensive guide to implementing Microsoft Dynamics AX 2012 with Sure Step 2012, and is the prefect accompaniment for project team members of all levels. In this article by Keith Dunkinson and Andrew Birch, authors of Implementing Microsoft Dynamics AX 2012 with Sure Step 2012, provides complete information on installation of Sure Step and the setup of projects, and also discusses the project offerings within it.

In this article, we will examine the installation of Sure Step and setting it up for a specific project including some of the key choices we need to make, and activities that should be undertaken at this time. After reading this article, we should be able to: download and install the Sure Step client, create an appropriate Sure Step project, and initiate key activities for our Dynamics AX project.

Liferay, its Installation and setup

Liferay is an open source portal solution.  In this article by Sandeep Nair, author of Instant Liferay Portal 6 Starter, we will understand a little about portals.

Creating a file server (Samba)

This article by Rick Golden, author of Raspberry Pi Networking Cookbook, shows how the Raspberry Pi can be configured to become a file server on the local network.

Improving Performance with Parallel Programming

The recipes in this article focus on leveraging multiple cores by showing different ways to parallelize Clojure programs.

In this article by Eric Rochester, the author of Clojure Data Analysis Cookbook, we will cover:

• Parallelizing processing with pmap

• Parallelizing processing with Incanter

• Partitioning Monte Carlo simulations for better pmap performance

• Finding the optimal partition size with simulated annealing

• Parallelizing with reducers

• Generating online summary statistics with reducers

• Harnessing your GPU with OpenCL and Calx

Show/hide rows and Highlighting cells

In this article by Charlie Griefer, author of Instant jQuery 2.0 Table Manipulation How-to [Instant], we will see two recipes Show/hide rows and Highlighting cells.

Getting Started with ZeroMQ

This article by Faruk Akgul, author of ZeroMQ explains what a message queuing system is, discusses the importance of message queuing, and introduces ZeroMQ to the reader.

Before we start digging into ZeroMQ, let's first have a brief introduction on the general concept of message queues.

Building a Custom Version of jQuery

With the 1.8 release of jQuery, something new was introduced that the development community as a whole had been wanting for a while – the ability to build custom versions of jQuery that contained only the functionality that was required for a given task.

In this article by Dan Wellman, author of jQuery Hotshot, we'll set up the environment we need in order to use jQuery's build tool. We'll see what other software we need to use, how to run the build tool itself, and what we can expect as output of the build tool.

Customizing your IBM Lotus Notes 8.5.3 experience

The article, IBM Lotus Notes 8.5.3, helps you master the IBM Lotus Notes 8.5.3 client to become an expert at e-mail, calendaring and scheduling, contacts, to dos, and much more. This article by Barry Max Rosen, author of Instant IBM Lotus Notes 8.5.3 How-to, explains how IBM Lotus Notes 8.5.3 is highly customizable and works the way you want it to work.