Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Query question, schemas #5

Open
apiszcz opened this issue Jun 14, 2022 · 2 comments
Open

Query question, schemas #5

apiszcz opened this issue Jun 14, 2022 · 2 comments

Comments

@apiszcz
Copy link

apiszcz commented Jun 14, 2022

Database table has 1 trip, which I copied to a new schema, it appears there is an insert requirement or trigger? Since the 'public' schema is referenced but the query specifies 's1'

car_id trip_id trip
1 1 [010100000000000000000000000000000000000000@2012-01-01 08:00:00+00, 010100000000000000000000400000000000000000@2012-01-01 08:10:00+00, 01010000000000000000000040666666666666FEBF@2012-01-01 08:15:00+00]

Query #1
select trip from s1.trips_test_001

Log message
2022-06-14T10:57:41 INFO Running Query: select trip from s1.trips_test_001
2022-06-14T10:57:41 INFO Query return types: tgeompoint

General log
2022-06-14T10:57:43 WARNING Feature type or srid for geom of "public"."move__tpoint_0_4ee6b0e8377344cc9c730e74772a096c" could not be determined or was not requested.

@mschoema
Copy link
Owner

Hi,

To visualize tgeompoint objects, the plugin creates materialized views that contain PostGIS geometries, and these are then loaded as a layer.
Currently, these materialized views are always created on the 'public' schema as I did not account for different schemas yet.
However, the layer should still appear as normal.
Is that the case, or is the visualization not working?

If there is a need to create these materialized views in a specific schema, I could look into it, but this is currently not handled by the plugin.

@apiszcz
Copy link
Author

apiszcz commented Aug 19, 2022

1 Current status is query runs, layer appears in TOC
2 Temporal Controller working.
3 Any estimates to handle different schemas? Thanks.
4 Animated GIF attached, also showing you the MITRE Time Data Controller in save animated GI
20220819064421798
F

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants