db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr |
|
Table: geo_raster_france_1pixel
db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr |
|
Table: geo_raster_france_1pixel
Schema
Owner
albenard
Tablespace
(default)
Descriptions
Raster basé sur le raster geo_raster_france_90m_clc et ne contenant qu'un unique pixel de très grande taille représentant la France entière
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id |
integer |
|
|
|
|
|
|
|
rast |
public.raster |
|
|
|
|
|
|
|
comment |
text |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table geo_raster_france_1pixel
Check Constraints
Name | Condition | Description |
|---|---|---|
st_height(rast) = 1 |
|
|
st_envelope(rast) @ '01030000206A08000001000000050000003C1807B09F66F840000000005C1057413C1807B09F66F84000000000A3295B41847100FB4A6E334100000000A3295B41847100FB4A6E3341000000005C1057413C1807B09F66F840000000005C105741'::geometry |
|
|
st_numbands(rast) = 1 |
|
|
_raster_constraint_out_db(rast) = '{f}'::boolean[] |
|
|
_raster_constraint_pixel_types(rast) = '{8BUI}'::text[] |
|
|
st_samealignment(rast, '010000000000000000E1E73141000000001C6530C13C1807B09F66F84000000000A3295B41000000000000000000000000000000006A08000001000100'::raster) |
|
|
round((st_scalex(rast))::numeric, 10) = round((1173473)::numeric, 10) |
|
|
round((st_scaley(rast))::numeric, 10) = round((- (1074460)::numeric), 10) |
|
|
st_srid(rast) = 2154 |
|
|
st_width(rast) = 1 |
|
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_1pixel
Rules
There are no rules for table geo_raster_france_1pixel
Policies
There are no policies for table geo_raster_france_1pixel
Referenced
There are no tables referenced by table geo_raster_france_1pixel
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
1 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
id INTEGER NOT NULL,
rast public.raster,
comment TEXT,
CONSTRAINT geo_raster_france_1pixel_pkey PRIMARY KEY(id),
CONSTRAINT enforce_height_rast CHECK (st_height(rast) = 1),
CONSTRAINT enforce_max_extent_rast CHECK (st_envelope(rast) @ '01030000206A08000001000000050000003C1807B09F66F840000000005C1057413C1807B09F66F84000000000A3295B41847100FB4A6E334100000000A3295B41847100FB4A6E3341000000005C1057413C1807B09F66F840000000005C105741'::geometry) NOT VALID,
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) = '{8BUI}'::text[]),
CONSTRAINT enforce_same_alignment_rast CHECK (st_samealignment(rast, '010000000000000000E1E73141000000001C6530C13C1807B09F66F84000000000A3295B41000000000000000000000000000000006A08000001000100'::raster)),
CONSTRAINT enforce_scalex_rast CHECK (round((st_scalex(rast))::numeric, 10) = round((1173473)::numeric, 10)),
CONSTRAINT enforce_scaley_rast CHECK (round((st_scaley(rast))::numeric, 10) = round((- (1074460)::numeric), 10)),
CONSTRAINT enforce_srid_rast CHECK (st_srid(rast) = 2154),
CONSTRAINT enforce_width_rast CHECK (st_width(rast) = 1)
) ;
COMMENT ON TABLE public.geo_raster_france_1pixel
IS 'Raster basé sur le raster geo_raster_france_90m_clc et ne contenant qu''un unique pixel de très grande taille représentant la France entière ';
CREATE INDEX convexhull_idx_franceunpixel ON public.geo_raster_france_1pixel
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 |
|