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

Add abilitiy to 'Save Raster style in Postgis database', just like is possible for Vector styles #56870

Open
rduivenvoorde opened this issue Mar 15, 2024 · 0 comments

Comments

@rduivenvoorde
Copy link
Contributor

Feature description

More and more public (raster) data in the Netherlands also have QGIS style files in the zip.

When loading such files in a central Postgis database, it would be very cool to be able to save the/a style in the database as 'default style', just like is possible with Vectordata.
In that way, users would have an immediate styled view of the data.

For example the '5x5meter Land-use dataset':

image

is provided as geotiff, but accompanied with a qml style.

It seems not so difficult (???) to mimic the same behaviour as for vectors?

Though I see now that the public.layer_styles actually has a 'f_GEOMETRY_column'... not sure if it is wise to put a raster column in that one...

CREATE TABLE public.layer_styles (
	id serial4 NOT NULL,
	f_table_catalog varchar NULL,
	f_table_schema varchar NULL,
	f_table_name varchar NULL,
	f_geometry_column varchar NULL,
	stylename text NULL,
	styleqml xml NULL,
	stylesld xml NULL,
	useasdefault bool NULL,
	description text NULL,
	"owner" varchar(63) DEFAULT CURRENT_USER NULL,
	ui xml NULL,
	update_time timestamp DEFAULT CURRENT_TIMESTAMP NULL,
	"type" varchar NULL,
	CONSTRAINT layer_styles_pkey PRIMARY KEY (id)
);

Additional context

No response

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

No branches or pull requests

1 participant