Documentation Index
Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
Use this file to discover all available pages before exploring further.
This gem runs in .
Overview
Use the CreatePoint gem to convert longitude and latitude coordinates into geographic points.Prerequisites
- Add
ProphecyDatabricksSqlSpatialversion 0.0.1 or higher to your project.
Input and Output
The CreatePoint gem accepts the following input and output.| Port | Description |
|---|---|
| in0 | Source dataset containing pairs of columns with longitude and latitude coordinates. |
| out | Output dataset containing one or more new columns with points in Well-known Text (WKT) geometric format. |
Parameters
The CreatePoint gem accepts longitude and latitude columns as parameters. In the Create Spatial Points section, you need to Click to Add a Point. For each point you add, fill in the following information.| Parameter | Description |
|---|---|
| Longitude Column Name | Input column that contains longitude values. |
| Latitude Column Name | Input column that contains latitude values. |
| Target Column Name | Column in the gem output that will contain resulting geo points. |
Example
Assume you have the following airline route table.start_city | start_lat | start_long | destination_city | destination_lat | destination_long |
|---|---|---|---|---|---|
| New York | 40.7128 | -74.0060 | Los Angeles | 34.0522 | -118.2437 |
| London | 51.5074 | -0.1278 | Paris | 48.8566 | 2.3522 |
| Tokyo | 35.6895 | 139.6917 | Sydney | -33.8688 | 151.2093 |
| Toronto | 43.6511 | -79.3470 | Chicago | 41.8781 | -87.6298 |
| Dubai | 25.2760 | 55.2962 | Mumbai | 19.0760 | 72.8777 |
Scroll horizontally to view the full table.
-
Create the first column pairing:
- Click Add a Point.
-
For Longitude Column Name, select the
start_longcolumn. -
For Latitude Column Name, select the
start_latcolumn. -
For the Target Column Name, type
source_point.
-
Create another column pairing:
- Click Add a Point.
-
For Longitude Column Name, select the
destination_longcolumn. -
For Latitude Column Name, select the
destination_latcolumn. -
For the Target Column Name, type
dest_point.
Result
The CreatePoint gem will produce the following output with two new columns:source_point and dest_point.
start_city | start_lat | start_long | destination_city | destination_lat | destination_long | source_point | dest_point |
|---|---|---|---|---|---|---|---|
| New York | 40.7128 | -74.0060 | Los Angeles | 34.0522 | -118.2437 | POINT (-74.0060 40.7128) | POINT (-118.2437 34.0522) |
| London | 51.5074 | -0.1278 | Paris | 48.8566 | 2.3522 | POINT (-0.1278 51.5074) | POINT (2.3522 48.8566) |
| Tokyo | 35.6895 | 139.6917 | Sydney | -33.8688 | 151.2093 | POINT (139.6917 35.6895) | POINT (151.2093 -33.8688) |
| Toronto | 43.6511 | -79.3470 | Chicago | 41.8781 | -87.6298 | POINT (-79.3470 43.6511) | POINT (-87.6298 41.8781) |
| Dubai | 25.2760 | 55.2962 | Mumbai | 19.0760 | 72.8777 | POINT (55.2962 25.2760) | POINT (72.8777 19.0760) |
Scroll horizontally to view the full table.