InitSpatialMetaData()

[diplonics]

Hi, While I'm not new to spatial data and using PostGIS etc. I am new to node and this package. I'm trying to run this query: var query = "SELECT AsGeoJSON(ST_Transform(GeomFromText('LINESTRING(" + lineString + ")',4326), 3857), 6, 3) AS tbbox;";

but the ST_Transform is failing with the message: { [Error: SQLITE_ERROR: no such table: spatial_ref_sys] errno: 1, code: 'SQLITE_ ERROR' }

How to I enable/create the spatial_ref_table, is there something I missed during the installation?

Thanks in advance.

[zhm]

Can you paste a complete code snippet that reproduces it? It might be related to the setup code....

[diplonics]

No probs, here's the code but don't think anything fancy is being done here.

---

var sqlite = require('spatialite'); var db = new sqlite.Database(':memory:'); var query = "SELECT AsGeoJSON(ST_Transform(GeomFromText('LINESTRING(" + lineString + ")',4326), 3857), 6, 3) AS tbbox;"; db.spatialite(function(error){ db.each(query, function(error, row){ if(error){ console.log(error); } console.log(util.inspect(row, false, null)); //Other logic code to happen here based on the SQL transform result }); }); db.close();

---

For your info and might help. Removing the ST_Transform method and all runs fine. The platform I'm developing on is Windows 7 so followed your VS build instructions. This code will be deployed on a linux server but I don't have access to this to test this issue yet.

Thanks again.