Based on the following code block:
var SphericalMercator = require('sphericalmercator');var mercator = new SphericalMercator({ size: 256})var bbox = mercator.bbox( +req.params.x, +req.params.y, +req.params.z, false, '4326');var test_query = 'SELECT st_asgeojson(wkb_geometry) AS feature FROM ogrgeojson where ST_INTERSECTS(wkb_geometry, ' + bbox + ')';I run this as a query and get the following error:
error: function st_intersects(geometry, numeric, numeric, numeric, numeric) does not exist]hint: 'No function matches the given name and argument types. You might need to add explicit type casts.'I am not sure how I should be wrapping the bbox. Additionally things that I have tried have resulted in column errors.
أكثر...
var SphericalMercator = require('sphericalmercator');var mercator = new SphericalMercator({ size: 256})var bbox = mercator.bbox( +req.params.x, +req.params.y, +req.params.z, false, '4326');var test_query = 'SELECT st_asgeojson(wkb_geometry) AS feature FROM ogrgeojson where ST_INTERSECTS(wkb_geometry, ' + bbox + ')';I run this as a query and get the following error:
error: function st_intersects(geometry, numeric, numeric, numeric, numeric) does not exist]hint: 'No function matches the given name and argument types. You might need to add explicit type casts.'I am not sure how I should be wrapping the bbox. Additionally things that I have tried have resulted in column errors.
أكثر...