database,table,projection,relational-algebra

If I remember relational algebra correctly it should be something like this: π name (σ age = 34 (Person)) where π is projection and σ is selection. This would be equal to select name from Person where age = 34in SQL and can be read as from Person select relations...

c++,math,matrix,graphics,projection

As in the original post: "So I came back to this project after quite some break and I realised that my projection divide (aka /w) was only dividing the xyz coords. So when I applied the screenspace matrix the translate column was being multiplied by the 'greater than one' W...

Okay, i have looked at your code again and i think there is something wrong with your projection matrix calculation. I have replaced that m3d_getPerspective method with the definition from gluPerspective and added a printMatrix (pm) method. For some example points the results seem reasonable now (code below). I have...

matlab,machine-learning,data-mining,projection,pca

Oops, now I see my mistake. First of all, COEFF is orthogonal (not sure) so inv(COEFF) == COEFF' and the projection is found by proj = COEFF' * (x-m) ...

matrix,vector,opengl-es,transformation,projection

You can certainly use 3x3 matrices to apply affine transformations in 2D. You just have to be careful that you're consistent about it. From a look at the code fragments you posted, there are two things that look problematic: Matrices need to be column major OpenGL expects matrices to be...

Will vertica retain this order by in the new superprojection? It will retain the order by specified in the initial CREATE TABLE statement. Also, will it also include the column 'd' to this order by? Vertica will only add new columns to the super projection (this is the default...

ios,camera,projection,scenekit

Easy! What you are looking for is the field of view. It's available as a property of the camera and is pretty much equal to the Zoom on its real life counterpart. A low field of view means your camera is very zoomed in. That way, there will be very...

opengl,math,graphics,projection

I think you created a bit of confusion by putting this question under the "opengl" tag. The problem is that in computer graphics, the term projection is not understood in a strictly mathematical sense. In maths, a projection is defined (and the following is not the exact mathematical definiton, but...

c++,matrix,projection,perspective

Just found out why this happens: In my Perspective Matrix the FOV is 0°. That's why it looks like that. So better use a Perspective FOV Matrix....

c#,nhibernate,projection,nhibernate-projections

This should be the way "p.class": criteria.SetProjection(Projections.ProjectionList() .Add(Projections.Property("p.Property1")) .Add(Projections.Property("p.class")) ); 17.1.4.1. Alias and property references Description Syntax Example ... Discriminator of an entity {[aliasname].class} DISC as {item.class} .... ...

c++,opengl,projection,vertices,glu

Part of my problem here was poorly describing it. I accidentally left residual code from frantically testing, resulting in bits of "read Pixel" functions and related nonsense which wasn't useful for solving the problem. The rest of my problem was due to inconsistent data types for the matrices, and trying...

If you want the world space coordinates for the frustum corners, all you need to do is project the 8 corner points from NDC space (which is going from -1 to 1 in every dimension, so the corner points are easy to enumerate) back to world space. But do not...

c#,linq,entity-framework,projection

Alternative 1 If you don't worry about using dynamics mixed with regular typed C# code you could make a utility method like... public static dynamic PrepareForMusiciansView(IQuerable<Musician> musicians) { return musicians.Select(m => new { musicianId = m.MusicianId, name = m.Name, instrument = new { instrumentId = m.instrument.InstrumentId, model = m.instrument.Model }...

The easiest solution is to use the scissor test. It allows you to render only pixels within a specified rectangular sub-region of your window. For example, to limit your rendering to 3x3 pixels centered at pixel (x, y): glScissor(x - 1, y - 1, 3, 3); glEnable(GL_SCISSOR_TEST); glDraw...(...); glDisable(GL_SCISSOR_TEST); Note...

javascript,camera,three.js,projection

I figured out the answer myself for anyone that checks this question later on. To get my screen coordinates I needed to convert some input data from a gyroscope, and didn't realize that I still needed to do the following to my calculated screen coordinates: this.reticlePos.x = ( this.reticlePos.x /...

c#,nhibernate,properties,projection,queryover

What we can do is to use different than default result transformer, e.g. DeepTransformer. In that case, the query must use Alias similar to the DTO model. So, if we have domain property ei.FirstName belonging to JoinAlias - j.EmployeeInfo - the alias must be reflecting the DTO ContactInfo - "EmployeeInfo.FirstName"...

Use aggregation framework. The aggregation pipeline would simply have a $group operation where the $addToSet operator adds the values to an array. For instance, with a collection which has sample documents: /* 1 */ { "_id" : ObjectId("553c0101dddf8dcf96bdcdea"), "color" : "red" } /* 2 */ { "_id" : ObjectId("553c0101dddf8dcf96bdcdeb"), "color"...

three.js,textures,projection,texture-mapping,decal

You'd need to do some tricky stuff to convert from the model geometry space into UV coordinate space so you could draw the new pixels into the texture map. If you want to be able to use more than one material that way, you'd also probably need to implement some...

spring-data-jpa,projection,spring-data-rest

That's a bug in ProxyProjectionFactory. I've filed and fixed DATACMNS-722 for you scheduled to be in the upcoming services releases (mid next week).

math,matrix,3d,projection,matrix-inverse

To define the ray you need a start point (which is the camera/eye position) and a direction vector, which can be calculated using any point on the ray. For a given pixel in the image, you have a projected X and Y (zeroed at the center of the image) but...

mongodb,database-performance,projection,query-performance

Nesting is better. fewer documents = higher performance. For the best performance, I'd break your settings into 22 categories with 22 keys in each, that way accessing one property would take a maximum of 22+22=44 steps instead of 500. Of course, only break them into sensible groups, if at all....

java,mysql,hibernate,projection

I have found the answer by myself and i will post here to be able to help somebody. Projections.sqlGroupProjection("sum({alias}.discriminatorValue) as rowCount","hibernateAlias.discriminatorColumn having rowCount>0",new String[]{"rowCount"},Helper.HIBERNATE_INTEGER_INSTANCE) Seems the rowCount aliasing in new String[]{"rowCount"} is just for mysql syntax or is just ignore by Criteria engine is you need to use a alias...

java,hibernate,criteria,projection

You can do that with sqlProjection .setProjection(Projections.sqlProjection("sum(A + B) as sumAB", new String[] {"sumAB"} , new Type[] {Hibernate.DOUBLE})); ...

c++,camera,direct3d,projection,movement

You will need to create a rotation matrix based on the rotation, transform the target into that rotation matrix and add that new vector to the eyes position. Here is an example of how I do it, this will move the camera forward or back based on the delta value...

This is because XNA knows nothing of your Windows Forms window. This means that it doesn't know how to scale it, so naturally it will just scale it to be 1x1 The easiest way to accomplish what you're asking, would be to render everything to a RenderTarget of say 1920x1080,...

javascript,three.js,projection

In three.js, the renderer calls camera.updateMatrixWorld() for you every render loop. If you modify the camera position, rotation, or quaternion, and you then use a method that relies on camera.matrixWorld, and if that method does not update camera.matrixWorld itself, you have to update the matrix manually. camera.updateMatrixWorld(); three.js r.71...

c++,opengl,3d,projection,qglwidget

Here, I think I had a series of problems. I should have used -1 for my near plane, not 0 I had differing data types for my matrices (QT ones specifically,), making me unable to directly plug them into the unproject function. I solved these by doing the following: I...

python,api,matrix,projection,maya

So I think i got a solution for this: import maya.OpenMaya as OpenMaya def projectPoint(worldPnt, camPnt, depth): ''' @param worldPnt - MPoint of point to project. (WorldSpace) @param camPnt - MPoint of camera position. (WorldSpace) @param depth - Float value of distance. Returns list of 3 floats. ''' #Get vector...

math,graphics,camera,projection

It might help to draw a diagram. You can make things simpler by ignoring the x coordinate which puts everything in 2D. In this simpler diagram to find the projection of a point t, onto the plane PP simply draw a line from the position of the pinhole to the...

c#,.net,mongodb,mongodb-csharp,projection

You would want to use IFindFluent.Find and then use IFindFluent.Projection and Builders.Projection.Exclude to exclude this property: var query = collection. Find(filter). Project(Builders<Document>.Projection.Exclude(doc => doc.HugeBlob)); var results = await query.ToListAsync(); ...

I think that you have to declare your projection first (EPSG:2100). You can use proj4js Library to do that. I tried your code and this is what it shown to me:` "NetworkError: 404 Not Found - http://localhost:19614/JSLib/proj4js/lib/defs/EPSG2100.js" This happens when your projection is not known from your Library. And something...

The question did not specify how w is provided but if w is a matrix with full rank spanning the space w then Z <- w %*% solve(crossprod(w), t(w)) If w has orthogonal columns then the above line reduces to: Z <- tcrossprod(w) Another possibility is to use the pracma...

c++,opengl,math,matrix,projection

So I came back to this project after quite some break and I realised that my projection divide (aka /w) was only dividing the xyz coords. So when I applied the screenspace matrix the translate column was being multiplied by the 'greater than one' W value causing the triangle to...

performance,sql-server-2012,projection

Try with Left Join instead: SELECT * INTO #temp FROM source T010T LEFT JOIN destination P510T ON WH_CD = T010T.WH_CD AND POS_NO = T010T.POS_NO AND SLIP_NO = T010T.TRAN_NO AND OPE_DATE = T010T.SL_REC_DATE WHERE P510T.WH_CD IS NULL ...

ios,unity3d,mapping,projection

Its obviously need extensive research but i have an idea in my mind. Match real model and a 3d model in unity. Your virtual camera need to be positioned exactly same way your real life projector is positioned. Your FOV need to be same as your projector Virtual camera is...

Here's some workarounds to avoid the white space and to add the axis labels. Since both maps are in metres, it's not easy to plot lat-lon labels. library(raster) # for xmin, ymin etc. # plot raster without axes and box plot(r, asp=1, axes=F, box=F) # add polygons plot(wbuf, add=TRUE, axes=F)...

You can access fields inside an embedded document using the dot notation. Don't forget to quote the field name though. > db.collection.find() { "_id" : 1, "semester" : 1, "grades" : { "student1" : 70, "student2" : 85 } } { "_id" : 2, "semester" : 2, "grades" : {...

That can be achieved using aggregation $project, and now Morphia supports aggregation (since 0.110). Here you have some examples about aggregation and group&projection.

First assuming your countries' borders are given with geographic (φ,λ) coordinates – if they are (x,y) in some cartographic projection, you'd have to transform them back to the geographic system. Choose one vertex, possibly the northernmost: V(φ0, λ0) and decide where it shall finally land in the amazonian region: (φ1,λ1)...

You should try something like this: library(raster) library(sp) library(rgdal) #work wd wd <- "C:/Users/...../data" #get raster files from work wd files <- list.raster.files(path = wd, pattern = ".tif$", recursive =FALSE, return_rasters = FALSE, return_bbox = FALSE) #create rasterStack mystack <- stack(files$raster_files) proj4string(mystack) <- CRS("+init=epsg:3857") # OSM Mercator projection ...

javascript,json,d3.js,projection,qgis

I'm just using an own projection now: +proj=eqc +a=1790493.11 +lat_ts=0 +lon_0=0 +rf=800 +units=m +no_defs With that projection all is fine....

java,spring,rest,projection,spring-data-rest

I verfied this working with Spring Data REST 2.2.1, so please update it. Make sure your client actually sends the the requested parameters as you intend. While debugging, I found out that e.g. cURL drops query parameters if you do not explicitly quote the URI. So this: curl http://localhost:8080/orders/search/findByApplicant?applicant=5&projection=details will...

My summary is it takes results (or a subset of results) and allows you to quickly restructure it for use in the local context. The select clause produces the results of the query and specifies the "shape" or type of each returned element. For example, you can specify whether your...

You can use a regular expression: select regexp_replace(the_column, 'always.*', '') this will replace everything after (and including) the word always with nothing, but won't replace anything if the word is not found. If you also want to "catch" the same word in upper case or mixed case, just pass a...