Questions tagged [projection]

A projection is the transformation of a set of data from one form into another.

Mathematically speaking a projection is a function that yields the same result if applied multiple times.

The term is used with this meaning in graphics when 'projecting' a 3D scene on a 2D canvas.

The same is often happening when analyzing data with many dimensions (age, gender, number of transactions, ...) and projecting it on fewer dimensions, in the simple case by just dropping dimensions or by creating new dimensions like (might commit fraud).

When dealing with typed languages the dimensions might be attributes of a class. So if I have one or multiple types with attributes (A, B, C, ...) and create from instances of those types instances of a type which has only the attributes (A, B) this is a projection too.

Another example are databases. A projection is an operation which discards some attributes of a tuple, in other words, which omits some columns of a relational database query result. For an object or document database a projection filters out some fields.

After all a database projection yields the same result if applied multiple times, too.

2017 questions
0
votes
0 answers

MongoDB match array based on document value

Let's say I have the following document structure: { "A": { "_id": "ID0" }, "B": [ "a": { "_id": "ID0", "field": "X" }, "b": { "_id": "ID1", "field": "Y" } ] } I want to project B matched with the…
CHRD
  • 1,917
  • 1
  • 15
  • 38
0
votes
1 answer

Combining an ImageLayer and VectorLayer in OpenLayers 6

I'm using OpenLayers 6.3.1, trying to create a VectorLayer with some basic shapes on top of a simple static ImageLayer. Basically, I'm trying to put the shapes from this example on top of this static image example. When I add the view's custom…
nnyby
  • 4,748
  • 10
  • 49
  • 105
0
votes
1 answer

Spring JPA projection problem with subquery

I'm using JPA projections but it fails when my query contains subquery. For exemple : public class Student { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "student_id") private Long id; private String…
z8manu8z
  • 15
  • 1
  • 6
0
votes
1 answer

How to query 3 tables in Grails Gorm

I am new to grails framework how to query 3 tables having association between them Class A{ static hasMany = [b:B] } enter code here class B{ long aId // Id of table A } class c{ B b //B reference } SQL…
Durgesh
  • 3
  • 2
0
votes
0 answers

Optimal way to use function for property in AutoMapper ProjectTo IQueryable tree

I'm using AutoMapper .ProjectTo() to map some Order to OrderDto. The original Order is a pretty big object with around 30 properties and 15 collections. For my OrderDto I have a property DisplayStatus with some custom logic based on 4…
0
votes
1 answer

rgl: draw plane spanned by two 3D vectors

I'm having trouble understanding the arguments for rgl::plane3d required to draw a plane spanned by two vectors (x0, x1), going through a given point (O=origin). This is for a diagram explaining projection. The rgl documentation doesn't provide…
user101089
  • 3,756
  • 1
  • 26
  • 53
0
votes
1 answer

Convert Cartesian (X,Y) to coordinates GPS (Latitude & Longitude)

I need to convert coordinates X, Y into Latitude and Longitude. I've read wikipedia map projections, similar stackoverflow forums, applied my custom solutions and still didn't work. The coordinates I get from my formula are wrong, Longitude is…
0
votes
1 answer

Unknown CRS in QGIS when projecting to EPSG:25833 in R

I want to project a spatial data frame to EPSG 25833 in R but QGIS does not seem to know it (for reproducibility, I use the code jazzurro created in his/her answer to this question with minor changes) library(rgdal) mydf <- structure(list(longitude…
Lutz
  • 223
  • 5
  • 15
0
votes
1 answer

how to convert milliseconds into HH:MM:SS format in mongodb(3.4 version)

I am projecting a field as i want the difference between DateOfOcurrance and current time. Then I want to compare the diff_time field with one time which is in String format(HH:MM:SS) as I want those documents which have less than 15mins diff_time,…
Swapna
  • 63
  • 4
0
votes
2 answers

Projecting an image onto a cylindrical surface in a way where the image appears flat

I'm trying to print out QR codes onto the surface of water bottles using matlab. However, the QR bottles cannot be recognized because of the curved surface of the bottle, and the therefore deformed shape of the QR codes. I was wondering what…
A. Rapoport
  • 113
  • 7
0
votes
1 answer

Matplotlib Basemap: Map Coordinates

I am looking for easy way to determine the how to extract lon lat coordinates for 'lcc' projection. I am trying to isolate Arabian Sea as shown in the following code but somehow what i get is zoomed out view. m = Basemap(projection='lcc',…
gfdsal
  • 651
  • 1
  • 8
  • 25
0
votes
1 answer

MongoDB Aggregation Sort Differently Depending on Projection

I have found an odd sorting behavior from MongoDB as I completed the MongDB Course M121. You can test out the collection in this cluster with mongo…
qvn
  • 78
  • 7
0
votes
1 answer

Right approach for aggregating data from multiple tables in Spring JPA

I have a Q&A section where each question and answer has a user profile card associated with it. It is very similar to how it is here on stack overflow. Data that makes up this user profile card is spread across multiple tables. I am fetching one or…
Meena Chaudhary
  • 9,909
  • 16
  • 60
  • 94
0
votes
0 answers

D3 - Project a single XY coordinate (Equirectangular) into a Orthographic coordinate

I'm trying to project a screen/pixel coordinate from an Equirectangular image into an Orthographic coordinate using D3 and it's projection tools (which I hardly understand). I've found an example that shows how to do this using an interpolation…
D4RKUL4
  • 1
  • 1
0
votes
0 answers

Camera 2D coords from 3D object coords

I am working on a geometry editor tool and I am dealing with the way how to get manipulators vector coordinates on the screen/camera plane so I can use these for mouse dragging. I've got access to vectors world coordinates matrix (or any objects…