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
In a previous article we covered working with value extractors and simplifying queries in Oracle Coherence 3.5. We will take the discussion further by seeing how to obtain query results. We will also talk about indexes and the impact they have on query performance.
In this article by Aleksandar Seovic, Mark Falco and Patrick Peralta, authors of Oracle Coherence 3.5, we will cover:
- Obtaining query results
- Using indexes to improve query performance
- Coherence query limitations
Alexandre Prokoudine - Alexandre has been involved with the Inkscape project since 2004 as a Russian translator, and later as technical support team member and website maintainer. Professionally Alexandre specializes in documentation, software localization and internationalization which he's been doing for numerous free graphic design and sound tools since early 2000s. Alexandre is currently employed by ALT Linux and works on educational projects.
Read Questions & Answers with Inkscape's Alexandre Prokoudine in full
Michael “Monty” Widenius - Monty was the Main Developer of the MySQL database and the Founder of MySQL AB. Currently he is the CEO of Monty Program, a company founded by him. Monty Program is a center of engineering excellence for a database server called MariaDB, the Aria storage engine, MySQL®, and other associated technologies.
Monty is also a partner in the venture capital company Open Ocean. Monty’s experience and knowledge is highly regarded, which has resulted in many board memberships. He is currently active in the board of IT Mill Ltd, Finsor, Web of Trust by Against Intuition Inc. and several others.
Read Questions & Answers with MariaDB's Michael "Monty" Widenius- Founder of MySQL AB in full
James Pearce - James is a technologist, writer, developer & practitioner who has been working with the mobile web for over a decade. He is Senior Director of Developer Relations at Sencha. Previously he was the CTO at dotMobi and has a background in mobile startups, telecoms infrastructure and management consultancy. He speaks extensively on the topic of mobile web development, and has written books for both Wiley and Wrox.
James led the development of mobiForge, DeviceAtlas and ready.mobi, and is the creator of tinySrc, the WordPress Mobile Pack, WhitherApps, modernizr-server and confess.js.
Read Questions & Answers with Sencha's James Pearce in full
In this article by Limoke Oscar, authors of Instant Google Map Maker Starter [Instant], we will show you how to perform one of the core tasks of Google Map Maker—mapping the places you love and know. Follow the steps to create your own map features, which will be the basis of most of your work in Google Map Maker.Read Quick start in full
This article created by Joe Yates author of Instant Sinatra Starter [Instant], puts together the basics of a simple address book application and deploy it. We'll be handling requests and returning a dynamically created page.Read Quick start - your first Sinatra application in full
In this article by Unmesh Gundecha, author of Instant Selenium Testing Tools Starter, we will show you how to record a test using Selenium IDE. During the recording, we will add some additional commands to the test and run the recorded test.
A test is a basic building block in Selenium IDE. It contains commands for navigation, test steps, and checks for expected versus the actual state of the application. In this article we will show you how to create your first test and execute this test with Selenium IDE.Read Quick Start into Selenium Tests in full
In this article by Gabriel Manricks, author of Instant jqGrid, we will learn how to customize jqGrid and set it up the way you like. There is a little bit of tweaking necessary in order to customize jqGrid and get it set up the way you like. The good news is, you can use that folder as a template and every time you want to make a new project with jqGrid you can just make a copy of that folder.Read Quick start – creating your first grid in full
In this article created by Vivek Mishra, the author of Instant Apache Cassandra for Developers Starter, we will discuss about the Cassandra storage architecture and its different components, followed by the Cassandra query language (CQL) command-line exercises.Read Quick start – Creating your first Java application in full
In this article by Gabriel Manricks, author of the book Instant Handlebars.js, we will learn how to create template. Let's start from the beginning. The purpose of using a templating engine such as Handlebars is to generate some kind of viewable content (usually HTML pages), dynamically. This encompasses a really broad range of uses, from e-mail newsletters, web apps, and really any other kind of output format around.
In this quick start, we will take a brief look at the process of creating a template with both placeholders and helper tags, and then how to run and output the contents to the page.Read Quick start – creating your first template in full
Firebug is not about fixing the bugs and tweaking CSS (cascade style sheet), it consists of many tools that can be of great help to a web developer and designer. Firebug is similar golf club bag. Each club (panel) in Firebug is a powerful weapon for web developers. Like a golf player, a web developer has to choose a club (panel) for different situations.
In this article by Chandan Luthra, the author of Instant Firebug Starter, we will learn
This article by Charles McColm, the author of Instant XBMC , covers the quick start of XMBC. XBMC can be set up to look up the metadata for movies, television shows, music videos, and music; but before lookups are possible, XBMC needs a way to recognize what to look up. For movies, music, and television shows XBMC uses the filename and date as a basis for the lookup. Music needs to be tagged properly with a tag editor for XBMC to be able to understand what to look up. You also need a way to get your media files from your computer to your XBMCbuntu system. We'll be sending files over a network using FileZilla, an FTP/SFTP program, and by using Samba (drag-and-drop) shares. Lastly, we'll add your copied data to your movie, TV show, or music library.Read Quick start – media files and XBMC in full
In this article by Mike Guthrie, author of Instant Nagios Starter, we will see how to monitor hosts and services. The logic of Nagios as a monitoring engine is determined by a set of object conﬁguration ﬁles, which are located under the etc directory of the Nagios tree. For a source installation, this directory is located at /usr/local/nagios/etc. From the conﬁguration ﬁles in this directory, Nagios knows what to monitor, when to monitor, who to notify, and how to respond to events. Interaction with these ﬁles is required in order to set up monitoring with Nagios, so understanding how to work with them is essential. This article will be an introduction to the basics of adding new hosts, services, contacts, and templates. A complete reference for all the Nagios conﬁguration ﬁles is available in the Nagios core manual on sourceforge.net, and it is by far the best reference for a complete understanding of Nagios conﬁguration ﬁles. It can be found at the following link:Read Quick start – Monitoring hosts and services in full
In this article by Luca Carettoni, author of Instant Burp Suite Starter, we will give you a sneak peek into using Burp Proxy, Burp Proxy is a crucial component of the entire Burp Suite. This tool allows you to intercept the web traffic between the browser (client) and the target application (server). Thanks to the setup described in the previous section, we are now able to look under the hood and discover how web applications work.Read Quick start – Using Burp Proxy in full
Foundation 4 provides a set of UI elements to construct our websites. In this article by Jorge Arévalo and Carlos Azaustre, the authors of the book Instant Zurb Foundation 4, we will show you how to use some of them in our websites. Specifically, we will see the following two elements:
- The Grid
- The navigation Bar
This article by Jo Rhett, author of Instant Puppet 3 Starter, will show you how to use the core resource types included within Puppet to reduce the amount of manual work and rework you do every day. By the end of this section, you'll have puppet maintaining some services in your system.Read Quick start – Using the core Puppet resource types in full
In this article by Nicholas Emond, the author of the book Instant MDX Queries for SQL Server 2012, it is explained that a MDX query is coded and executed against a cube to have a result in a specific format return to the client application.Read Quick start – writing your first MDX query in full