Hot answers tagged

5

A unique constraint creates a unique index to implement the constraint. The only index type in PostgreSQL that supports unique indexes is the default b-tree index type; you can't make a unique GIN or GiST index, e.g.: regress=> create unique index indexname on test USING GiST(id) ; ERROR: access method "gist" does not support unique indexes Data types ...


4

As Craig explained very well, you cannot create a unique index on the type raster without all the necessary operators. Your second best bet to enforce uniqueness is to create a functional index on the text representation: CREATE UNIQUE INDEX us_tmin_enforce_scalex_rast ON chp05.us_tmin (cast(rast as text)) Note that this cannot be implemented as ...


3

So you have some basic data. SELECT timestamp::timestamp, level, lat, long FROM ( VALUES (now(), 7, 1, 9) ) AS t(timestamp, level, lat, long); timestamp | level | lat | long ----------------------------+-------+-----+------ 2017-02-08 15:38:54.903155 | 7 | 1 | 9 What you want to do is create a point with lat, and long... ...


2

Since you are asking about Postgtresql, you should install postgis. It will give you the geography type and all nice operators which will simplify your location-related conditions. Then you will be able to define a table for each variable, with column types geography, datetime, whatever is appropriate for level and value, and maybe a serial integer to ...


1

I'm not sure that you want a database. Like other tools, databases have strengths and weaknesses. The NetCDF format is designed to be more compact and lightweight than a database, to be portable across computer systems that may represent numbers differently, and to allow very fast random access to subsets of hierarchical data sets. There are some very ...


1

As your data is already multi dimensional i would create a schema that follows along those lines using a datawarehouse star schema with a central fact table. In your example the fact table would have the lat, long, pressure, timestamp, observed value and attributes. If you wanted to extend your model to use an olap cube you could add a time dimension and ...


1

It seems likely that you're not using PostGIS 2.2. Pay special attention to postgis.enable_outdb_rasters. Taken from my answer on GIS.SE As explained in the PostGIS blog, This has been an issue since our release of 2.0.6/2.13 PostGIS security patches that by default disabled all raster drivers and out-of-db raster storage. Raster is much less useful if ...


Only top voted, non community-wiki answers of a minimum length are eligible