GEOJSON_PARSE_ERROR error class

SQLSTATE: 22023

Error parsing GeoJSON: <parseError> at position <pos>

Parameters

• parseError: Description of the encountered parse error.
• pos: The 1-based position in the GeoJSON string where the parse error occurred.

Explanation

Some geospatial functions can return this error when parsing the input that must be in GeoJSON format. Learn more about the GeoJSON format.

Examples

SQL

-- Feeding an empty point in GeoJSON format into the h3_polyfillash3 function (as opposed to a polygon or multipolygon).
> SELECT h3_polyfillash3('{"type":"Point","coordinates":[]}', 2)
  [GEOJSON_PARSE_ERROR] Error parsing GeoJSON: Invalid or unsupported type '"Point"' at position 9

-- Feeding an polygon with invalid GeoJSON (missing closing } at the end)
> SELECT H3_PolyfillAsH3('{"type":"Polygon","coordinates":[[[-122.4194,37.7749],[-118.2437,34.0522],[-74.0060,40.7128],[-122.4194,37.7749]]]', 2)
  [GEOJSON_PARSE_ERROR] Error parsing GeoJSON: Unexpected end of GeoJSON string at position 115

Functions emitting the error class

• h3_coverash3 function
• h3_coverash3string function
• h3_pointash3 function
• h3_pointash3string function
• h3_polyfillash3 function
• h3_polyfillash3string function
• h3_tessellateaswkb function

Related

• WKB_PARSE_ERROR error condition
• WKT_PARSE_ERROR error condition