geometry output NULL

[Tara]

Hello,

I am trying following query:

SELECT AsGeoJSON(ST_GeomFromText(a.geometry)) as geometry, a.name, a.node_id
        FROM my_points
        AS a
        WHERE Contains(Buffer(GeomFromText('POINT(1007069.1726977603 6194484.57197054)', 3857), 90), a.geometry);

However the output of my geometry column in NULL instead of getting an GeoJson geometry type. Does anyone now what do I have to do?

[mj10777]

The geometry column is null because because it is not a geometry (a.geometry is a geometry)

- ST_GeomFromText(a.geometry) : is a Text representation of a.geometry

- AsGeoJSON(ST_GeomFromText(a.geometry)) causes an error (your NULL)

Does anyone now what do I have to do?

- AsGeoJSON(a.geometry) will give the GeoJSON-Text representation of a.geometry

Hope this helps,

Mark

[Tara]

cool thanks it worked!