ST_AsGeoJSON - Wherobots

This method is not recommended. Please use Sedona GeoJSON data source to write GeoJSON files. Return the GeoJSON string representation of a geometry The type parameter (Since: v1.6.1) takes the following options -

“Simple” (default): Returns a simple GeoJSON geometry.
“Feature”: Wraps the geometry in a GeoJSON Feature.
“FeatureCollection”: Wraps the Feature in a GeoJSON FeatureCollection.

Signatures

ST_AsGeoJSON (A: Geometry)

ST_AsGeoJSON (A: Geometry, type: String)

Parameters

Geometry

required

The input geometry.

String

The output type.

Return type

A string representation.

Examples

Simple GeoJSON

SELECT ST_AsGeoJSON(ST_GeomFromWKT('POLYGON((1 1, 8 1, 8 8, 1 8, 1 1))'))

{
  "type":"Polygon",
  "coordinates":[
    [[1.0,1.0],
      [8.0,1.0],
      [8.0,8.0],
      [1.0,8.0],
      [1.0,1.0]]
  ]
}

Feature GeoJSON

{
  "type":"Feature",
  "geometry": {
      "type":"Polygon",
      "coordinates":[
        [[1.0,1.0],
          [8.0,1.0],
          [8.0,8.0],
          [1.0,8.0],
          [1.0,1.0]]
      ]
  }
}

FeatureCollection GeoJSON

{
  "type":"FeatureCollection",
  "features": [{
      "type":"Feature",
      "geometry": {
          "type":"Polygon",
          "coordinates":[
            [[1.0,1.0],
              [8.0,1.0],
              [8.0,8.0],
              [1.0,8.0],
              [1.0,1.0]]
          ]
      }
    }
  ]
}

​Signatures

​Parameters

​Return type

​Examples

​Simple GeoJSON

​Feature GeoJSON

​FeatureCollection GeoJSON