This is QGIS spam! :)

classic Classic list List threaded Threaded
17 messages Options
Reply | Threaded
Open this post in threaded view
|

This is QGIS spam! :)

Raymond Nijssen
Hi Everyone!

New QGIS goodies have been added to our shop. So if you want to look
cool AND sponsor QGIS a bit, order an item in your favorite colour!

http://shop.qgis.org/en/site/about/shop_goodies.html

If you have any remarks about the stores or maybe difficulties ordering
from your location, please send me an email. It is hard to test the
spreadshirt website being in only 1 country.

Kind regards,
Raymond
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: This is QGIS spam! :)

jmckenna
Administrator
Thanks for this spam Raymond, very fun! Will share, thanks! :)  -jeff





On 2017-11-12 3:18 PM, Raymond Nijssen wrote:

> Hi Everyone!
>
> New QGIS goodies have been added to our shop. So if you want to look
> cool AND sponsor QGIS a bit, order an item in your favorite colour!
>
> http://shop.qgis.org/en/site/about/shop_goodies.html
>
> If you have any remarks about the stores or maybe difficulties ordering
> from your location, please send me an email. It is hard to test the
> spreadshirt website being in only 1 country.
>
> Kind regards,
> Raymond
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: This is QGIS spam! :)

alberto.grava
In reply to this post by Raymond Nijssen
Hi all hi Raymond!
can i suggest to add water bottles in the qgis shop?
we have to push for a plastic free world!
...and i think it will be a nice gadget to share qgis image around the
world!

thank you!
Alberto

PS: maybe  some stickers too...



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: This is QGIS spam! :)

Raymond Nijssen
Hi Alberto,

Good idea! I just put it there:

https://shop.spreadshirt.net/qgis/qgis+text+transp+bg+300dpi-A5d231d26e0c0832f787fbafb?productType=757&sellable=nOxxG3ELGjudeG3gyAxj-757-39&appearance=37&size=29

They don't sell stickers at spreadshirt, but there are many online
places where you can order them. The files for stickers I once ordered
in The Netherlands are here on github:

https://github.com/qgis/QGIS-Promotion


@ all users: Please send me a picture (and some comment) of the products
you receive since I can only know them virtually and I wouldn't want
people to spend money on crappy products. (Or tweet it using #qgis)

Kind regards,
Raymond



On 16-09-19 11:36, alberto.grava wrote:

> Hi all hi Raymond!
> can i suggest to add water bottles in the qgis shop?
> we have to push for a plastic free world!
> ...and i think it will be a nice gadget to share qgis image around the
> world!
>
> thank you!
> Alberto
>
> PS: maybe  some stickers too...
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> _______________________________________________
> Qgis-user mailing list
> [hidden email]
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

QGIS 3 copy style form from one attribute table to another (both no geometry) does not seem to work

Janneke van Dijk
Dear List,

I have prepared a drag and drop designer form with several containers,
and I would like to use the same form for another table with the same
structure. Both tables do not contain geometry and are layers in two
different geopackage files. I thought it should be possible to click
Style>copy>all on the layer containing the correct form, then
Style>paste>all on the layer where I would like to have the drag and
drop form. When I do it, nothing seems to happen - the form remains
'autogenerate' with all attributes listed.

Should this work? Should I do something else? File a bug report? Is
there a work around?

Thanks for thinking along,

Janneke

_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: QGIS 3 copy style form from one attribute table to another (both no geometry) does not seem to work

Janneke van Dijk
Dear List,
The work around seems to be to save the style as .qml and then load it
for the other layer. I would still like to know if it is expected that
copy style does not work in this case or that this is a bug.
thanks,
Janneke

On 18/09/2019 15:56, Janneke van Dijk wrote:

> Dear List,
>
> I have prepared a drag and drop designer form with several containers,
> and I would like to use the same form for another table with the same
> structure. Both tables do not contain geometry and are layers in two
> different geopackage files. I thought it should be possible to click
> Style>copy>all on the layer containing the correct form, then
> Style>paste>all on the layer where I would like to have the drag and
> drop form. When I do it, nothing seems to happen - the form remains
> 'autogenerate' with all attributes listed.
>
> Should this work? Should I do something else? File a bug report? Is
> there a work around?
>
> Thanks for thinking along,
>
> Janneke
>
>

_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: QGIS 3 copy style form from one attribute table to another (both no geometry) does not seem to work

Matthias Kuhn 🌍
Hi Janneke,

Sounds very much like a bug to me (or a very desirable feature,
depending on the point of view). Can you open a ticket for that?

Thanks a lot

Matthias

On 9/18/19 3:00 PM, Janneke van Dijk wrote:

> Dear List,
> The work around seems to be to save the style as .qml and then load it
> for the other layer. I would still like to know if it is expected that
> copy style does not work in this case or that this is a bug.
> thanks,
> Janneke
>
> On 18/09/2019 15:56, Janneke van Dijk wrote:
>> Dear List,
>>
>> I have prepared a drag and drop designer form with several
>> containers, and I would like to use the same form for another table
>> with the same structure. Both tables do not contain geometry and are
>> layers in two different geopackage files. I thought it should be
>> possible to click Style>copy>all on the layer containing the correct
>> form, then Style>paste>all on the layer where I would like to have
>> the drag and drop form. When I do it, nothing seems to happen - the
>> form remains 'autogenerate' with all attributes listed.
>>
>> Should this work? Should I do something else? File a bug report? Is
>> there a work around?
>>
>> Thanks for thinking along,
>>
>> Janneke
>>
>>
>
> _______________________________________________
> Qgis-user mailing list
> [hidden email]
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: QGIS 3 copy style form from one attribute table to another (both no geometry) does not seem to work

Janneke van Dijk
Thanks for confirming, Matthias (and bummer - I was hoping I had
overlooked something :-) ). Will open a ticket.
Janneke

On 18/09/2019 16:38, Matthias Kuhn wrote:

> Hi Janneke,
>
> Sounds very much like a bug to me (or a very desirable feature,
> depending on the point of view). Can you open a ticket for that?
>
> Thanks a lot
>
> Matthias
>
> On 9/18/19 3:00 PM, Janneke van Dijk wrote:
>> Dear List,
>> The work around seems to be to save the style as .qml and then load
>> it for the other layer. I would still like to know if it is expected
>> that copy style does not work in this case or that this is a bug.
>> thanks,
>> Janneke
>>
>> On 18/09/2019 15:56, Janneke van Dijk wrote:
>>> Dear List,
>>>
>>> I have prepared a drag and drop designer form with several
>>> containers, and I would like to use the same form for another table
>>> with the same structure. Both tables do not contain geometry and are
>>> layers in two different geopackage files. I thought it should be
>>> possible to click Style>copy>all on the layer containing the correct
>>> form, then Style>paste>all on the layer where I would like to have
>>> the drag and drop form. When I do it, nothing seems to happen - the
>>> form remains 'autogenerate' with all attributes listed.
>>>
>>> Should this work? Should I do something else? File a bug report? Is
>>> there a work around?
>>>
>>> Thanks for thinking along,
>>>
>>> Janneke
>>>
>>>
>>
>> _______________________________________________
>> Qgis-user mailing list
>> [hidden email]
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
> _______________________________________________
> Qgis-user mailing list
> [hidden email]
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

1 to many relationship does not allow to display the many

Janneke van Dijk
In reply to this post by Matthias Kuhn 🌍
Dear list,

I have a parent - child relationship set up between a table location (1,
the parent) and a table assets (many, the child). The location table
contains geometry, the asset table does not. I would like to be able to
display each record in the asset table with the corresponding geometry
of the location table - so if there are 3 assets at a certain location,
I would like to display 3 points (each with identical geometry).

What I can do with the DB manager is:

select location_point.geom, asset_point.assetid, location_point.fid 
from asset_point cross join location_point on asset_point.locationid =
location_point.fid

this query yields 170 records, corresponding with the number of records
in the assets table. When I load as a new layer, the result is a table
with 170 records, but 100 filtered (the total number of locations). I
chose assetid to be the unique id (which it is).

Is that expected behaviour? How else can I display all the records in
the assets table (instead of only the 100 that are filtered now)? I know
I can do it in Postgres but for my purpose now I don't want to go there.

Any insights deeply appreciated!

Janneke


_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: 1 to many relationship does not allow to display the many

DelazJ
Hi Janneke,

Maybe you need a field that would uniquely identify the 170 asset rows (their primary key). You can use an ID field of your asset layer or construct one with row_number function?


Regards,
Harrissou

Le jeu. 19 sept. 2019 à 16:10, Janneke van Dijk <[hidden email]> a écrit :
Dear list,

I have a parent - child relationship set up between a table location (1,
the parent) and a table assets (many, the child). The location table
contains geometry, the asset table does not. I would like to be able to
display each record in the asset table with the corresponding geometry
of the location table - so if there are 3 assets at a certain location,
I would like to display 3 points (each with identical geometry).

What I can do with the DB manager is:

select location_point.geom, asset_point.assetid, location_point.fid 
from asset_point cross join location_point on asset_point.locationid =
location_point.fid

this query yields 170 records, corresponding with the number of records
in the assets table. When I load as a new layer, the result is a table
with 170 records, but 100 filtered (the total number of locations). I
chose assetid to be the unique id (which it is).

Is that expected behaviour? How else can I display all the records in
the assets table (instead of only the 100 that are filtered now)? I know
I can do it in Postgres but for my purpose now I don't want to go there.

Any insights deeply appreciated!

Janneke


_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: 1 to many relationship does not allow to display the many

Alexandre Neto
In reply to this post by Janneke van Dijk
Hi


On Thu, Sep 19, 2019 at 3:10 PM Janneke van Dijk <[hidden email]> wrote:

What I can do with the DB manager is:

select location_point.geom, asset_point.assetid, location_point.fid 
from asset_point cross join location_point on asset_point.locationid =
location_point.fid


This should work, but why the CROSS JOIN? a simple join should be enough.
 
this query yields 170 records, corresponding with the number of records
in the assets table. When I load as a new layer, the result is a table
with 170 records, but 100 filtered (the total number of locations). I
chose assetid to be the unique id (which it is).

Is that expected behaviour? How else can I display all the records in
the assets table (instead of only the 100 that are filtered now)? I know
I can do it in Postgres but for my purpose now I don't want to go there.


An alternative is to create a relation between the two tables, the assets will show in the location feature form. You can even add more assets to a certain location.


Hope it helps.

Alexandre Neto
 


_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: 1 to many relationship does not allow to display the many

Janneke van Dijk
In reply to this post by DelazJ
Hi Harrissou,
Thanks for the quick response - indeed, I indicated the assetid which is a unique value. That did not solve the problem, alas...
Janneke

On 19/09/2019 17:31, DelazJ wrote:
Hi Janneke,

Maybe you need a field that would uniquely identify the 170 asset rows (their primary key). You can use an ID field of your asset layer or construct one with row_number function?


Regards,
Harrissou

Le jeu. 19 sept. 2019 à 16:10, Janneke van Dijk <[hidden email]> a écrit :
Dear list,

I have a parent - child relationship set up between a table location (1,
the parent) and a table assets (many, the child). The location table
contains geometry, the asset table does not. I would like to be able to
display each record in the asset table with the corresponding geometry
of the location table - so if there are 3 assets at a certain location,
I would like to display 3 points (each with identical geometry).

What I can do with the DB manager is:

select location_point.geom, asset_point.assetid, location_point.fid 
from asset_point cross join location_point on asset_point.locationid =
location_point.fid

this query yields 170 records, corresponding with the number of records
in the assets table. When I load as a new layer, the result is a table
with 170 records, but 100 filtered (the total number of locations). I
chose assetid to be the unique id (which it is).

Is that expected behaviour? How else can I display all the records in
the assets table (instead of only the 100 that are filtered now)? I know
I can do it in Postgres but for my purpose now I don't want to go there.

Any insights deeply appreciated!

Janneke


_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: 1 to many relationship does not allow to display the many

DelazJ
You mean, it's the selected field in the primary key drop-down menu in DB manager when you want to add the layer?

Le jeu. 19 sept. 2019 à 16:42, Janneke van Dijk <[hidden email]> a écrit :
Hi Harrissou,
Thanks for the quick response - indeed, I indicated the assetid which is a unique value. That did not solve the problem, alas...
Janneke

On 19/09/2019 17:31, DelazJ wrote:
Hi Janneke,

Maybe you need a field that would uniquely identify the 170 asset rows (their primary key). You can use an ID field of your asset layer or construct one with row_number function?


Regards,
Harrissou

Le jeu. 19 sept. 2019 à 16:10, Janneke van Dijk <[hidden email]> a écrit :
Dear list,

I have a parent - child relationship set up between a table location (1,
the parent) and a table assets (many, the child). The location table
contains geometry, the asset table does not. I would like to be able to
display each record in the asset table with the corresponding geometry
of the location table - so if there are 3 assets at a certain location,
I would like to display 3 points (each with identical geometry).

What I can do with the DB manager is:

select location_point.geom, asset_point.assetid, location_point.fid 
from asset_point cross join location_point on asset_point.locationid =
location_point.fid

this query yields 170 records, corresponding with the number of records
in the assets table. When I load as a new layer, the result is a table
with 170 records, but 100 filtered (the total number of locations). I
chose assetid to be the unique id (which it is).

Is that expected behaviour? How else can I display all the records in
the assets table (instead of only the 100 that are filtered now)? I know
I can do it in Postgres but for my purpose now I don't want to go there.

Any insights deeply appreciated!

Janneke


_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: 1 to many relationship does not allow to display the many

Janneke van Dijk
In reply to this post by Alexandre Neto
Hi Alexandre,
Also thanks for the quick response!

What I can do with the DB manager is:

select location_point.geom, asset_point.assetid, location_point.fid 
from asset_point cross join location_point on asset_point.locationid =
location_point.fid


This should work, but why the CROSS JOIN? a simple join should be enough.
I first had a simple join, then saw an example of a cross join and tried that in the hope that that would make a difference.
 
this query yields 170 records, corresponding with the number of records
in the assets table. When I load as a new layer, the result is a table
with 170 records, but 100 filtered (the total number of locations). I
chose assetid to be the unique id (which it is).

Is that expected behaviour? How else can I display all the records in
the assets table (instead of only the 100 that are filtered now)? I know
I can do it in Postgres but for my purpose now I don't want to go there.


An alternative is to create a relation between the two tables, the assets will show in the location feature form. You can even add more assets to a certain location.
I have a relationship, and the assets will show up in the form of the location when you click on the location (including locations with several). However, it doesn't allow me to label the location with information from the assets, or create symbology based on asset information.

What puzzles me is that the query results in 170 records, I would have expected the geometry to be joined to each of the 170 attribute records and then be displayed - so where does the filter with a 100 suddenly come from? (Is this a bug?)

As a work around I think I could get xy coordinates of the location, then join them to the assets, export to csv and import again as a delimited text layer for display purposes.

I was hoping someone could either explain why this result makes sense, or that I just made a mistake somewhere...any more thoughts?

Thanks for sharing your thoughts!

Janneke


Alexandre Neto
 



_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: 1 to many relationship does not allow to display the many

Janneke van Dijk
In reply to this post by DelazJ
Indeed

On 19/09/2019 17:56, DelazJ wrote:
You mean, it's the selected field in the primary key drop-down menu in DB manager when you want to add the layer?

Le jeu. 19 sept. 2019 à 16:42, Janneke van Dijk <[hidden email]> a écrit :
Hi Harrissou,
Thanks for the quick response - indeed, I indicated the assetid which is a unique value. That did not solve the problem, alas...
Janneke

On 19/09/2019 17:31, DelazJ wrote:
Hi Janneke,

Maybe you need a field that would uniquely identify the 170 asset rows (their primary key). You can use an ID field of your asset layer or construct one with row_number function?


Regards,
Harrissou

Le jeu. 19 sept. 2019 à 16:10, Janneke van Dijk <[hidden email]> a écrit :
Dear list,

I have a parent - child relationship set up between a table location (1,
the parent) and a table assets (many, the child). The location table
contains geometry, the asset table does not. I would like to be able to
display each record in the asset table with the corresponding geometry
of the location table - so if there are 3 assets at a certain location,
I would like to display 3 points (each with identical geometry).

What I can do with the DB manager is:

select location_point.geom, asset_point.assetid, location_point.fid 
from asset_point cross join location_point on asset_point.locationid =
location_point.fid

this query yields 170 records, corresponding with the number of records
in the assets table. When I load as a new layer, the result is a table
with 170 records, but 100 filtered (the total number of locations). I
chose assetid to be the unique id (which it is).

Is that expected behaviour? How else can I display all the records in
the assets table (instead of only the 100 that are filtered now)? I know
I can do it in Postgres but for my purpose now I don't want to go there.

Any insights deeply appreciated!

Janneke


_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: 1 to many relationship does not allow to display the many

Alexandre Neto
In reply to this post by Janneke van Dijk
It sounds like a bug...
Can you provide a data sample and project. Also, what QGIS version are you using?

Alexandre Neto

On Thu, Sep 19, 2019 at 3:57 PM Janneke van Dijk <[hidden email]> wrote:
Hi Alexandre,
Also thanks for the quick response!

What I can do with the DB manager is:

select location_point.geom, asset_point.assetid, location_point.fid 
from asset_point cross join location_point on asset_point.locationid =
location_point.fid


This should work, but why the CROSS JOIN? a simple join should be enough.
I first had a simple join, then saw an example of a cross join and tried that in the hope that that would make a difference.
 
this query yields 170 records, corresponding with the number of records
in the assets table. When I load as a new layer, the result is a table
with 170 records, but 100 filtered (the total number of locations). I
chose assetid to be the unique id (which it is).

Is that expected behaviour? How else can I display all the records in
the assets table (instead of only the 100 that are filtered now)? I know
I can do it in Postgres but for my purpose now I don't want to go there.


An alternative is to create a relation between the two tables, the assets will show in the location feature form. You can even add more assets to a certain location.
I have a relationship, and the assets will show up in the form of the location when you click on the location (including locations with several). However, it doesn't allow me to label the location with information from the assets, or create symbology based on asset information.

What puzzles me is that the query results in 170 records, I would have expected the geometry to be joined to each of the 170 attribute records and then be displayed - so where does the filter with a 100 suddenly come from? (Is this a bug?)

As a work around I think I could get xy coordinates of the location, then join them to the assets, export to csv and import again as a delimited text layer for display purposes.

I was hoping someone could either explain why this result makes sense, or that I just made a mistake somewhere...any more thoughts?

Thanks for sharing your thoughts!

Janneke


Alexandre Neto
 



_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: 1 to many relationship does not allow to display the many

Janneke van Dijk
3.6, but will check when I have time later tonight and see if other versions show the same issue. And will create a sample project with bug report.
Thanks!
Janneke

On 19/09/2019 18:04, Alexandre Neto wrote:
It sounds like a bug...
Can you provide a data sample and project. Also, what QGIS version are you using?

Alexandre Neto

On Thu, Sep 19, 2019 at 3:57 PM Janneke van Dijk <[hidden email]> wrote:
Hi Alexandre,
Also thanks for the quick response!

What I can do with the DB manager is:

select location_point.geom, asset_point.assetid, location_point.fid 
from asset_point cross join location_point on asset_point.locationid =
location_point.fid


This should work, but why the CROSS JOIN? a simple join should be enough.
I first had a simple join, then saw an example of a cross join and tried that in the hope that that would make a difference.
 
this query yields 170 records, corresponding with the number of records
in the assets table. When I load as a new layer, the result is a table
with 170 records, but 100 filtered (the total number of locations). I
chose assetid to be the unique id (which it is).

Is that expected behaviour? How else can I display all the records in
the assets table (instead of only the 100 that are filtered now)? I know
I can do it in Postgres but for my purpose now I don't want to go there.


An alternative is to create a relation between the two tables, the assets will show in the location feature form. You can even add more assets to a certain location.
I have a relationship, and the assets will show up in the form of the location when you click on the location (including locations with several). However, it doesn't allow me to label the location with information from the assets, or create symbology based on asset information.

What puzzles me is that the query results in 170 records, I would have expected the geometry to be joined to each of the 170 attribute records and then be displayed - so where does the filter with a 100 suddenly come from? (Is this a bug?)

As a work around I think I could get xy coordinates of the location, then join them to the assets, export to csv and import again as a delimited text layer for display purposes.

I was hoping someone could either explain why this result makes sense, or that I just made a mistake somewhere...any more thoughts?

Thanks for sharing your thoughts!

Janneke


Alexandre Neto
 




_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user