IsoChrone - Spectrum_Routing_for_Big_Data - 5.1

Description

An isochrone is a polygon connecting points that take the same amount of time to reach from a particular point. The IsoChrone function returns an isochrone connecting a set of points that can be reached from the specified starting location in the given duration.

The IsoChrone UDF uses the GetTravelBoundary operation of the Global Routing API to generate an isochrone. The GetTravelBoundary operation helps determine the drive or walk time or the distance boundary from a given location. This function generates polygons corresponding to an isochrone calculation. For more information, see the Global Routing SDK User Guide, which is also available on the Spectrum Spatial for Big Data documentation landing page.

Function Registration

create function IsoChrone as 'com.pb.bigdata.spatial.routing.hive.IsoChrone';

Syntax

IsoChrone(WriteableGeometry startPoint, Number|String cost, 
          Map<String, String> options, Map<String, String> ambientOptions)

IsoChrone(WriteableGeometry startPoint, Array<Number|String> costs, 
          Map<String, String> options,  Map<String, String> ambientOptions)

Parameters

Syntax

IsoChrone(Number|String startX, Number|String startY, Number|String cost, 
          Map<String, String> options, Map<String, String> ambientOptions)

IsoChrone(Number|String startX, Number|String startY, Array<Number|String> costs, 
          Map<String, String> options, Map<String, String> ambientOptions)

Parameters

Options

The options and ambientOptions keys cannot be derived from a column in the table that the UDF is executed on. The keys of the options and ambient-options maps must also be of type String or convertible to String, and the values should be convertible to a type appropriate for the key’s value (typically this means that all values must be of type String). Keys and values of any type can be enclosed in either double or single quotes; a number or Boolean value will be processed correctly with or without quotes. For information on options that affect the calculation of the route, see Engine Options.

Ambient Road Type Options

This option lets you adjust the distance traveled when going off-network

Return Values

This function returns struct values described in the table below. In the case where a single cost is input, a single struct is returned. In the case where an array of multiple cost values are input, then an array of structs are returned.

Examples

SELECT ToWKT(IsoChrone(ST_Point(-77.088217, 38.937072), 600, map('pb.routing.timeUnit', 'second')).geometry);

SELECT ToWKT(IsoChrone(Geocode('485A Watervliet Shaker Rd, Latham, NY 12110','usa').geometry, 600).geometry);

SELECT ToWKT(IsoChrone(x, y, cost, map(pb.routing.engine.timeout, 300)).geometry) FROM <table_name>;

The previous example had the time-out specified as an number. It can also be specified as a string:

SELECT ToWKT(IsoChrone(x, y, cost, map(pb.routing.engine.timeout, '300')).geometry) FROM <table_name>; 

SELECT ToWKT(IsoChrone(x, y, cost, map(pb.routing.engine.timeout, '300', 'pb.routing.allowFallback', 'false')).geometry) FROM <table_name>;

SELECT ToWKT(IsoChrone(ST_Point(-77.088217, 38.937072), 3, null, map('footpath', '5')).geometry);

Example with both options and ambient-options set:

SELECT ToWKT(IsoChrone(ST_Point(-77.088217, 38.937072), 3, map('pb.routing.timeUnit', 'minute'), map('footpath', '5')).geometry);

Example showing multiple costs specified in an array for an input point. Hive requires that all values in an array must be of the same type:

SELECT costs[costidx] cost, ToWKT(iso.geometry) wkt, iso.error 
FROM points
LATERAL VIEW explode(array(array(5,10,20))) c as costs
LATERAL VIEW OUTER posexplode(IsoChrone(points.longitude,points.latitude,costs)) isoresult as costidx, iso;