1. Welcome

1.1. Workshop Conventions

These sections conform to a number of conventions to make it easier to follow the conversation. This section gives a brief overview of what to expect in the way of typographic conventions, as well as a short overview of the structure of each workbook.

1.1.1. Directions

Directions for you, the workshop attendee, will be noted by bold font.

For example:

Click Next to continue.

1.1.2. Code

SQL query examples will be displayed in an offset box

SELECT postgis_full_version();

These examples can be entered into the query window or command line interface.

1.1.3. Notes

Notes are used to provide information that is useful but not critical to the overall understanding of the topic.


If you haven’t eaten an apple today, the doctor may be on the way.

1.1.4. Functions

Where function names are defined in the text, they will be rendered in a bold font.

For example:

ST_Touches(geometry A, geometry B) returns TRUE if either of the geometries’ boundaries intersect

1.1.5. Files, Tables and Column Names

File names, paths, table names and column names will be shown in fixed-width font.

For example:

Select the name column in the nyc_streets table.

1.1.7. Workflow

Sections are designed to be progressive. Each section will start with the assumption that you have completed and understood the previous section in the series and will build on that knowledge. A single section will progress through a handful of ideas and provide working examples wherever possible. At the end of a section, where appropriate, we have included a handful of exercises to allow you to try out the ideas we’ve presented. In some cases the section will include “Things To Try”. These tasks contain more complex problems than the exercises and is designed to challenge participants with advanced knowledge.