diff options
author | Christopher Baines <cb15g11@soton.ac.uk> | 2014-09-06 18:22:54 +0100 |
---|---|---|
committer | Christopher Baines <cb15g11@soton.ac.uk> | 2014-09-06 18:22:54 +0100 |
commit | 063c97feb6a9cafc822fab0b53e66ff1cd0c10a3 (patch) | |
tree | 78b1fb3f2d0b33507cda61d85e74ee0b30c0f3fb /create-data.js | |
parent | 6efe207d14c79229cb4c02ffd56270ad05f671ce (diff) | |
download | leaflet-soton-063c97feb6a9cafc822fab0b53e66ff1cd0c10a3.tar leaflet-soton-063c97feb6a9cafc822fab0b53e66ff1cd0c10a3.tar.gz |
Precalculate centers for buildings
Currently done because this is the simplist way of doing it.
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', |