db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr
Previous topic Chapter index Next topic

Table: geo_raster_france_90m_gsm

 

 

Schema

public

 

Owner

biljou_param

 

Tablespace

(default)

 

Descriptions

Raster basé sur le raster geotiff de Global Soil Map. Chaque pixel contient un identifiant généré unique appelé ID_MAILLE pour les pixels comportant au moins une donnée (basé sur la bande 1 du raster Depth_3couches_avec_0_V3.tif)

 

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_gsm

 

Check Constraints

Name

Condition

Description

enforce_height_rast

st_height(rast) = ANY (ARRAY[50, 2])

 

enforce_max_extent_rast

st_envelope(rast) @ '01030000206A08000001000000050000003C1807B09F66F8408C908008F05857413C1807B09F66F84000000000DF1F5B41A35168DCDEC8304100000000DF1F5B41A35168DCDEC830418C908008F05857413C1807B09F66F8408C908008F0585741'::geometry

 

enforce_num_bands_rast

st_numbands(rast) = 1

 

enforce_out_db_rast

_raster_constraint_out_db(rast) = '{f}'::boolean[]

 

enforce_pixel_types_rast

_raster_constraint_pixel_types(rast) = '{32BUI}'::text[]

 

enforce_same_alignment_rast

st_samealignment(rast, '01000000009D128C03D87F564018D71C3CC47F56C03C1807B09F66F84000000000DF1F5B41000000000000000000000000000000006A08000001000100'::raster)

 

enforce_scalex_rast

round((st_scalex(rast))::numeric, 10) = round(89.99755943945861, 10)

 

enforce_scaley_rast

round((st_scaley(rast))::numeric, 10) = round('-89.99635222259928'::numeric, 10)

 

enforce_srid_rast

st_srid(rast) = 2154

 

enforce_width_rast

st_width(rast) = ANY (ARRAY[50, 12])

 

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

convexhull_idx_gsm

gist

 

(st_convexhull(rast))

 

 

 

geo_raster_france_90m_gsm_pkey

btree

 

id

 

 

Triggers

There are no triggers for table geo_raster_france_90m_gsm

 

Rules

There are no rules for table geo_raster_france_90m_gsm

 

Policies

There are no policies for table geo_raster_france_90m_gsm

 

Referenced

There are no tables referenced by table geo_raster_france_90m_gsm

 

Properties

Property

Value

Inherited From

 

Rows

49283

Pages

842

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.geo_raster_france_90m_gsm (
 id BIGINT NOT NULL,
 rast public.raster,
 comment TEXT,
 CONSTRAINT geo_raster_france_90m_gsm_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) @ '01030000206A08000001000000050000003C1807B09F66F8408C908008F05857413C1807B09F66F84000000000DF1F5B41A35168DCDEC8304100000000DF1F5B41A35168DCDEC830418C908008F05857413C1807B09F66F8408C908008F0585741'::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, '01000000009D128C03D87F564018D71C3CC47F56C03C1807B09F66F84000000000DF1F5B41000000000000000000000000000000006A08000001000100'::raster)),
 CONSTRAINT enforce_scalex_rast CHECK (round((st_scalex(rast))::numeric, 10) = round(89.99755943945861, 10)),
 CONSTRAINT enforce_scaley_rast CHECK (round((st_scaley(rast))::numeric, 10) = round('-89.99635222259928'::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_gsm
IS 'Raster basé sur le raster geotiff de Global Soil Map. Chaque pixel contient un identifiant généré unique appelé ID_MAILLE pour les pixels comportant au moins une donnée (basé sur la bande 1 du raster Depth_3couches_avec_0_V3.tif)';

CREATE INDEX convexhull_idx_gsm ON public.geo_raster_france_90m_gsm
 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
Previous topic Chapter index Next topic