Create GeoPoint from coordinate system

Supported in: Batch, Streaming

Takes a pair of coordinates from a source coordinate system and transforms them into WGS 84 latitude/longitude values. Coordinate systems (also know as coordinate reference systems or spatial reference systems) represent different systems for identifying the location of a point on the globe and are often identified by key in standardized databases such as EPSG. If the given projection is not supported or either coordinate is null, returns null.

Expression categories: Geospatial

Declared arguments

  • Source coordinate system - Coordinate system identifier formatted as "authority". For example, UTM zone 18N could be identified by EPSG:32618.
    Literal<String>
  • X coordinate - X coordinate (often "easting") in the source coordinate system.
    Expression<Numeric>
  • Y coordinate - Y coordinate (often "northing") in the source coordinate system.
    Expression<Numeric>

Output type: GeoPoint

Examples

Example 1: Base case

Argument values:

  • Source coordinate system: EPSG:32618
  • X coordinate: x_coordinate
  • Y coordinate: y_coordinate
x_coordinatey_coordinateOutput
322190.22339529654306505.703879281{
 latitude -> 38.88944258,
 longitude -> -77.05014581,
}
323243.13615360594318298.06539618{
 latitude -> 38.99585379643137,
 longitude -> -77.04105678275415,
}
407063.634653000164764873.719585404{
 latitude -> 43.03086518778498,
 longitude -> -76.14077251822197,
}

Example 2: Base case

Argument values:

  • Source coordinate system: EPSG:28992
  • X coordinate: x_coordinate
  • Y coordinate: y_coordinate
x_coordinatey_coordinateOutput
142735.75470715.91{
 latitude -> 52.22438577,
 longitude -> 5.20771293,
}
92891.44163437357.50015{
 latitude -> 51.9212285,
 longitude -> 4.4843492,
}
81047.96352454913.24287{
 latitude -> 52.0775512,
 longitude -> 4.3084213,
}