1.
Chapter 3 - Setting up
1.1.
3.4 Installing docker-postgis
2.
Chapter 4 - Thinking in SQL
2.1.
4.3 Database organization and design
2.2.
4.5 Projections
2.3.
4.6 Thinking in SQL
2.4.
4.7 Optimizing our queries and other tips
2.5.
4.8 Using pseudo-code and "rubber ducking"
3.
Chapter 5 - SQL basics
3.1.
5.2 ogr2ogr
3.2.
5.3 SQL Data Types
3.3.
5.4 Characters
3.4.
5.5 Numeric
3.5.
5.6 Dates and Times
3.6.
5.7 Other data types
3.7.
5.8 Basic SQL Operators
3.8.
5.9 Aggregates and GROUP BY
4.
Chapter 6 - Advanced topics for spatial SQL
4.1.
6.1 CASE/WHEN Conditionals
4.2.
6.2 Common Table Expressions (CTEs) and Subqueries
4.3.
6.3 CRUD: Create, Read, Update, and Delete
4.4.
6.4 Statistical functions
4.5.
6.5 Windows
4.6.
6.6 Joins
4.7.
6.7 Lateral joins
4.8.
6.8 Triggers joins
4.9.
6.9 UDFs joins
5.
Chapter 7 - Using the GEOMETRY
5.1.
7.2 GEOMETRY Types
5.2.
7.3 Size of GEOMETRY data
5.3.
7.4 A note on PostGIS documentation
5.4.
7.6 Constructors
5.5.
7.7 Accessors
5.6.
7.9 Validators
5.7.
7.10 Inputs
5.8.
7.11 Outputs
5.9.
7.12 Measurements in spatial SQL
6.
Chapter 8 - Spatial relationships
6.1.
8.2 Ways to use spatial relationship functions
6.2.
8.3 Spatial relationship functions
6.3.
8.4 Distance Relationship Functions
6.4.
8.5 Spatial Joins
6.5.
8.6 Overlay Functions
6.6.
8.7 Cluster Functions
6.7.
8.8 Special Operators
7.
Chapter 9 - Spatial analysis
7.1.
9.1 Analyses we have already seen
7.2.
9.2 New analyses
7.3.
9.3 Lines to polygons, and polygons to lines
7.4.
9.4 Snap points to grid
7.5.
9.5 Tessellate triangles
7.6.
9.6 Tapered buffers
8.
Chapter 10 - Advanced spatial analysis
8.1.
10.1 Spatial data enrichment or area weighted interpolation
8.2.
10.2 Nearest neighbor in report format
8.3.
10.3 Flat line of sight
8.4.
10.4 3D line of sight
8.5.
10.5 Calculate polygons that share a border
8.6.
10.6 Finding the most isolated feature
8.7.
10.7 Kernel density estimation (KDE)
8.8.
10.8 Isovist
9.
Chapter 11 - Suitability analysis
9.1.
11.1 Market expansion potential
9.2.
11.2 Similarity search or twin areas
9.3.
11.3 Suitability or composite score
9.4.
11.4 Mergers and acquisitions
10.
Chapter 12 - Working with raster data in PostGIS
10.1.
12.1 Raster Ingest
10.2.
12.2 Interpolation
10.3.
12.3 Raster to H3
11.
Chapter 13 - Routing and networks with pgRouting
11.1.
13.1 Prepare data to use in pgRouting
11.2.
13.2 Create a simple route in pgRouting
11.3.
13.3 Building an origin-destination matrix
11.4.
13.4 Traveling salesman problem
11.5.
13.5 Creating travel time polygons or isochones
12.
Chapter 14 - Spatial autocorrelation and optimization with Python and PySAL
12.1.
14.1 Spatial autocorrelation
12.2.
14.2 Location allocation
12.3.
14.3 Build balanced territories
Light
Rust
Coal
Navy
Ayu
Spatial SQL: Code Reference
7.10 Inputs
7.39
select st_geomfromtext('POINT(-73.9772294 40.7527262)', 4326) as geom