I am executing this query with cartodb.js. I am moving the markers radomnly to generate a new layer.
cartodb.createLayer(map, { user_name: 'mickemr', type: 'cartodb', sublayers: [{ sql: "SELECT cartodb_id, user_email, apo_about_me,apo_headshot_url,apo_member_number, first_name, user_nicename, ST_Transform(ST_Project(the_geom, 300*random(), random()*(3*pi()/2))::geometry , 3857) AS the_geom_webmercator FROM users", cartocss: "#users {marker-fill: red;marker-width:20px; } "}] }) My problem is that the tiles generated are not properly created, they are cut in the middle: Tile: http://screencast.com/t/5WFESgZkrG3 Chunk of map: http://screencast.com/t/g7RVmIujvye
If I don't use the random function is working properly. Anybody what can be happening? The SQL query is wrong?
Thanks!!!
أكثر...
cartodb.createLayer(map, { user_name: 'mickemr', type: 'cartodb', sublayers: [{ sql: "SELECT cartodb_id, user_email, apo_about_me,apo_headshot_url,apo_member_number, first_name, user_nicename, ST_Transform(ST_Project(the_geom, 300*random(), random()*(3*pi()/2))::geometry , 3857) AS the_geom_webmercator FROM users", cartocss: "#users {marker-fill: red;marker-width:20px; } "}] }) My problem is that the tiles generated are not properly created, they are cut in the middle: Tile: http://screencast.com/t/5WFESgZkrG3 Chunk of map: http://screencast.com/t/g7RVmIujvye
If I don't use the random function is working properly. Anybody what can be happening? The SQL query is wrong?
Thanks!!!
أكثر...