SpatialMatch

​

Overview

Use the SpatialMatch gem to find relationships between geometries from two different datasets. Common use cases include:

• Finding which stores are located within specific delivery zones
• Identifying roads that intersect with flood zones
• Matching customer locations to their nearest service areas

The gem uses spatial joins to compare geometries and returns only the pairs that have the spatial relationship you specify, such as shapes overlapping or shapes touching. It works with points, lines, and polygons in Well-Known Text (WKT) format.

​

Prerequisites

• Add ProphecyDatabricksSqlSpatial version 0.0.3 or higher to your project.

​

Input and Output

The SpatialMatch gem accepts the following inputs and output. You can use the same source for both in0 and in1 if you want to match geometries from the same dataset (self-join).

​

Parameters

Configure the SpatialMatch gem using the following parameters.

​

Match types

Review the following to understand the criteria to satisfy different match types. The SpatialMatch gem returns a row for each match condition that is met.

​

Match types diagram

The following diagram includes visualizations for each match type.

​

Example: Find stores within delivery zones

Assume you have two datasets:

• store_locations contains store locations as points.

  store_id	store_name	store_location	store_type
  1	Downtown Electronics	POINT(-74.0059 40.7128)	electronics
  2	Midtown Cafe	POINT(-73.9857 40.7489)	restaurant
  3	Brooklyn Bookstore	POINT(-73.9442 40.6782)	bookstore
  4	Queens Pharmacy	POINT(-73.7949 40.7282)	pharmacy
  5	Upper East Side Boutique	POINT(-73.9626 40.7831)	clothing

• delivery_zones contains delivery zones as polygons.

  zone_id	zone_name	zone_polygon	delivery_fee
  MANHATTAN_SOUTH	Lower Manhattan	POLYGON((-74.0200 40.7000, -74.0200 40.7300, -73.9800 40.7300, -73.9800 40.7000, -74.0200 40.7000))	5.99
  MANHATTAN_NORTH	Upper Manhattan	POLYGON((-73.9800 40.7700, -73.9800 40.8000, -73.9400 40.8000, -73.9400 40.7700, -73.9800 40.7700))	7.99
  BROOKLYN_WEST	Western Brooklyn	POLYGON((-74.0000 40.6500, -74.0000 40.7000, -73.9200 40.7000, -73.9200 40.6500, -74.0000 40.6500))	6.99
  QUEENS_CENTRAL	Central Queens	POLYGON((-73.8500 40.7000, -73.8500 40.7500, -73.7500 40.7500, -73.7500 40.7000, -73.8500 40.7000))	8.99

To find which delivery zones correspond to each store:

1. Add a SpatialMatch gem to your pipeline canvas.
2. Attach store_locations to the in0 port of the gem.
3. Attach delivery_zones to the in1 port of the gem.
4. Open the gem configuration interface.
5. For the Source field, select the store_location column from the store_locations table.
6. For the Target field, select the zone_polygon column from the delivery_zones table.
7. Under Select Match Type, select Source Within Target.
8. Save and run the gem.

​

Result

The SpatialMatch gem will return only the pairs of geometries that satisfy the selected match type. As a result:

• Downtown Electronics matches the MANHATTAN_SOUTH zone.
• Queens Pharmacy matches the QUEENS_CENTRAL zone.
• Upper East Side Boutique matches the MANHATTAN_NORTH zone.
• Midtown Cafe does not match any zone. This means that it is not in any delivery zone.