diff options
Diffstat (limited to 'create-data.js')
| -rwxr-xr-x | create-data.js | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/create-data.js b/create-data.js index d97092c..d0e8202 100755 --- a/create-data.js +++ b/create-data.js @@ -209,8 +209,9 @@ function createTable(name, query, callback) { function createCollections(callback) { var collectionQueries = { - buildings: 'select ST_AsGeoJSON(ST_Transform(way, 4326), 10) as \ - polygon,name,loc_ref,uri,leisure,height \ + buildings: 'select ST_AsGeoJSON(ST_Transform(way, 4326), 10) as polygon,\ + ST_AsText(ST_Transform(ST_Centroid(way), 4326)) as center,\ + name,loc_ref,uri,leisure,height \ from uni_building where uri is not null', parking: 'select ST_AsGeoJSON(ST_Transform(way, 4326), 10) as polygon,\ name,access,capacity,"capacity:disabled",fee from uni_parking', |