-
Book Overview & Buying
-
Table Of Contents
Geospatial Analysis with SQL
By :
To understand how to work with geospatial data and the functions available to answer data questions, we will explore different data types. Geospatial geometries are represented by polygons, points, and lines that indicate features and attributes such as census blocks, subway station locations, and roadways. They are vector models as they are representative of real-world areas (polygons), locations (points), or linear data such as transportation networks or drainage networks (lines).
Collectively, we call these different geometries vector data. Think of two-dimensional space as x- and y-coordinates when thinking about a specific geometry. Geography represents data on a round-earth coordinate system as latitude and longitude. I tend to use geometry as the convention across the board but will clarify when relevant. You will see actual data in this chapter, but it is simply illustrative. In later chapters, you will use a data resource, but until...