db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr |
|
Table: geo_raster_agri4cast
db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr |
|
Table: geo_raster_agri4cast
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table geo_raster_agri4cast
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id |
serial |
|
|
|
nextval('geo_raster_agri4cast_id_seq'::regclass) |
|
|
|
rast |
public.raster |
|
|
|
|
|
|
|
comment |
text |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table geo_raster_agri4cast
Check Constraints
Name | Condition | Description |
|---|---|---|
st_height(rast) = 50 |
|
|
st_envelope(rast) @ '0103000020DB0B0000010000000500000000000000006A384100000000904A11C100000000006A384100000000DBC256410000000004F25D4100000000DBC256410000000004F25D4100000000904A11C100000000006A384100000000904A11C1'::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) = '{32BUI}'::text[] |
|
|
st_samealignment(rast, '010000000000000000006AD84000000000006AD8C000000000006A384100000000DBC2564100000000000000000000000000000000DB0B000001000100'::raster) |
|
|
round((st_scalex(rast))::numeric, 10) = round((25000)::numeric, 10) |
|
|
round((st_scaley(rast))::numeric, 10) = round((- (25000)::numeric), 10) |
|
|
st_srid(rast) = 3035 |
|
|
st_width(rast) = 50 |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
id |
|
|
|
Triggers
There are no triggers for table geo_raster_agri4cast
Rules
There are no rules for table geo_raster_agri4cast
Policies
There are no policies for table geo_raster_agri4cast
Referenced
There are no tables referenced by table geo_raster_agri4cast
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
25 |
Pages |
2 |
System |
|
Temporary |
|
With OID |
|
Definition
id SERIAL,
rast public.raster,
comment TEXT,
CONSTRAINT geo_raster_agri4cast_pkey PRIMARY KEY(id),
CONSTRAINT enforce_height_rast CHECK (st_height(rast) = 50),
CONSTRAINT enforce_max_extent_rast CHECK (st_envelope(rast) @ '0103000020DB0B0000010000000500000000000000006A384100000000904A11C100000000006A384100000000DBC256410000000004F25D4100000000DBC256410000000004F25D4100000000904A11C100000000006A384100000000904A11C1'::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) = '{32BUI}'::text[]),
CONSTRAINT enforce_same_alignment_rast CHECK (st_samealignment(rast, '010000000000000000006AD84000000000006AD8C000000000006A384100000000DBC2564100000000000000000000000000000000DB0B000001000100'::raster)),
CONSTRAINT enforce_scalex_rast CHECK (round((st_scalex(rast))::numeric, 10) = round((25000)::numeric, 10)),
CONSTRAINT enforce_scaley_rast CHECK (round((st_scaley(rast))::numeric, 10) = round((- (25000)::numeric), 10)),
CONSTRAINT enforce_srid_rast CHECK (st_srid(rast) = 3035),
CONSTRAINT enforce_width_rast CHECK (st_width(rast) = 50)
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|