db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr |
|
Table: geo_raster_france_90m_fv2
db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr |
|
Table: geo_raster_france_90m_fv2
Schema
Owner
biljou_param
Tablespace
(default)
Descriptions
Raster basé sur le raster geotiff d'occupation du sol de la BD Foret version 2. Chaque pixel contient un identifiant généré unique appelé ID_MAILLE pour les pixels comportant au moins une donnée dans le fichier d'origine
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id |
bigint |
|
|
|
|
|
|
|
rast |
public.raster |
|
|
|
|
|
|
|
comment |
text |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table geo_raster_france_90m_fv2
Check Constraints
Name | Condition | Description |
|---|---|---|
st_height(rast) = ANY (ARRAY[50, 2]) |
|
|
st_envelope(rast) @ '01030000206A08000001000000050000003C1807B09F66F8408C908008F05857413C1807B09F66F84000000000DF1F5B41A25168DCDEC8304100000000DF1F5B41A25168DCDEC830418C908008F05857413C1807B09F66F8408C908008F0585741'::geometry |
|
|
st_numbands(rast) = 1 |
|
|
_raster_constraint_out_db(rast) = '{f}'::boolean[] |
|
|
_raster_constraint_pixel_types(rast) = '{32BUI}'::text[] |
|
|
st_samealignment(rast, '01000000009C128C03D87F564018D71C3CC47F56C03C1807B09F66F84000000000DF1F5B41000000000000000000000000000000006A08000001000100'::raster) |
|
|
round((st_scalex(rast))::numeric, 10) = round(89.9975594394586, 10) |
|
|
round((st_scaley(rast))::numeric, 10) = round('-89.9963522225993'::numeric, 10) |
|
|
st_srid(rast) = 2154 |
|
|
st_width(rast) = ANY (ARRAY[50, 12]) |
|
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_90m_fv2
Rules
There are no rules for table geo_raster_france_90m_fv2
Policies
There are no policies for table geo_raster_france_90m_fv2
Referenced
There are no tables referenced by table geo_raster_france_90m_fv2
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
49283 |
Pages |
1858 |
System |
|
Temporary |
|
With OID |
|
Definition
id BIGINT NOT NULL,
rast public.raster,
comment TEXT,
CONSTRAINT geo_raster_france_90m_foretv2_pkey PRIMARY KEY(id),
CONSTRAINT enforce_height_rast CHECK (st_height(rast) = ANY (ARRAY[50, 2])),
CONSTRAINT enforce_max_extent_rast CHECK (st_envelope(rast) @ '01030000206A08000001000000050000003C1807B09F66F8408C908008F05857413C1807B09F66F84000000000DF1F5B41A25168DCDEC8304100000000DF1F5B41A25168DCDEC830418C908008F05857413C1807B09F66F8408C908008F0585741'::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) = '{32BUI}'::text[]),
CONSTRAINT enforce_same_alignment_rast CHECK (st_samealignment(rast, '01000000009C128C03D87F564018D71C3CC47F56C03C1807B09F66F84000000000DF1F5B41000000000000000000000000000000006A08000001000100'::raster)),
CONSTRAINT enforce_scalex_rast CHECK (round((st_scalex(rast))::numeric, 10) = round(89.9975594394586, 10)),
CONSTRAINT enforce_scaley_rast CHECK (round((st_scaley(rast))::numeric, 10) = round('-89.9963522225993'::numeric, 10)),
CONSTRAINT enforce_srid_rast CHECK (st_srid(rast) = 2154),
CONSTRAINT enforce_width_rast CHECK (st_width(rast) = ANY (ARRAY[50, 12]))
) ;
COMMENT ON TABLE public.geo_raster_france_90m_fv2
IS 'Raster basé sur le raster geotiff d''occupation du sol de la BD Foret version 2. Chaque pixel contient un identifiant généré unique appelé ID_MAILLE pour les pixels comportant au moins une donnée dans le fichier d''origine';
CREATE INDEX convexhull_idx_foretv2 ON public.geo_raster_france_90m_fv2
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 |
|