Schema
Owner
biljou_param
Tablespace
(default)
Descriptions
Raster basé sur la maille SAFRAN météo France. Chaque pixel contient l'identifiant de maille SAFRAN ou nodata.
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
id |
serial |
|
nextval('geo_raster_france_8km_safran_id_seq'::regclass) |
|
|||
|
|
rast |
public.raster |
|
|
|
|
|
|
|
comment |
text |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table geo_raster_france_8km_safran
Check Constraints
Name | Condition | Description |
---|---|---|
st_height(rast) = 50 |
|
|
st_envelope(rast) @ '0103000020B46B00000100000005000000000000000058EB4000000000C8A83641000000000058EB4000000000247C444100000000402A334100000000247C444100000000402A334100000000C8A83641000000000058EB4000000000C8A83641'::geometry |
|
|
_raster_constraint_nodata_values(rast) = '{0.0000000000}'::numeric[] |
|
|
st_numbands(rast) = 1 |
|
|
_raster_constraint_out_db(rast) = '{f}'::boolean[] |
|
|
_raster_constraint_pixel_types(rast) = '{16BUI}'::text[] |
|
|
st_samealignment(rast, '0100000000000000000040BF40000000000040BFC0000000000058EB4000000000247C444100000000000000000000000000000000B46B000001000100'::raster) |
|
|
round((st_scalex(rast))::numeric, 10) = round((8000)::numeric, 10) |
|
|
round((st_scaley(rast))::numeric, 10) = round((- (8000)::numeric), 10) |
|
|
st_srid(rast) = 27572 |
|
|
st_width(rast) = 50 |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
gist |
|
(st_convexhull(rast)) |
|
|
|
|
btree |
|
id |
|
Triggers
There are no triggers for table geo_raster_france_8km_safran
Rules
There are no rules for table geo_raster_france_8km_safran
Policies
There are no policies for table geo_raster_france_8km_safran
Referenced
There are no tables referenced by table geo_raster_france_8km_safran
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
9 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.geo_raster_france_8km_safran (
id SERIAL,
rast public.raster,
comment TEXT,
CONSTRAINT geo_raster_france_8km_safran_pkey PRIMARY KEY(id),
CONSTRAINT enforce_height_rast CHECK (st_height(rast) = 50),
CONSTRAINT enforce_max_extent_rast CHECK (st_envelope(rast) @ '0103000020B46B00000100000005000000000000000058EB4000000000C8A83641000000000058EB4000000000247C444100000000402A334100000000247C444100000000402A334100000000C8A83641000000000058EB4000000000C8A83641'::geometry) NOT VALID,
CONSTRAINT enforce_nodata_values_rast CHECK (_raster_constraint_nodata_values(rast) = '{0.0000000000}'::numeric[]),
CONSTRAINT enforce_num_bands_rast CHECK (st_numbands(rast) = 1),
CONSTRAINT enforce_out_db_rast CHECK (_raster_constraint_out_db(rast) = '{f}'::boolean[]),
CONSTRAINT enforce_pixel_types_rast CHECK (_raster_constraint_pixel_types(rast) = '{16BUI}'::text[]),
CONSTRAINT enforce_same_alignment_rast CHECK (st_samealignment(rast, '0100000000000000000040BF40000000000040BFC0000000000058EB4000000000247C444100000000000000000000000000000000B46B000001000100'::raster)),
CONSTRAINT enforce_scalex_rast CHECK (round((st_scalex(rast))::numeric, 10) = round((8000)::numeric, 10)),
CONSTRAINT enforce_scaley_rast CHECK (round((st_scaley(rast))::numeric, 10) = round((- (8000)::numeric), 10)),
CONSTRAINT enforce_srid_rast CHECK (st_srid(rast) = 27572),
CONSTRAINT enforce_width_rast CHECK (st_width(rast) = 50)
) ;
COMMENT ON TABLE public.geo_raster_france_8km_safran
IS 'Raster basé sur la maille SAFRAN météo France. Chaque pixel contient l''identifiant de maille SAFRAN ou nodata.';
CREATE INDEX geo_france_8km_idx ON public.geo_raster_france_8km_safran
USING gist ((st_convexhull(rast)) public.gist_geometry_ops_2d);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |