db_biljou_carto on db.silva.inrae.fr
Previous topic Chapter index Next topic

Table: polygone_safran

 

 

Schema

public

 

Owner

biljoucarto

 

Tablespace

(default)

 

Descriptions

Polygones Safran 8x8KM avec l'identifiant point du centroide de la maille safran des fichiers biljou

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

gid

serial

 

nextval('polygone_safran_gid_seq'::regclass)

 

 

 

point

integer

 

 

 

 

 

 

 

xl2e

integer

 

 

 

 

 

 

 

yl2e

integer

 

 

 

 

 

 

 

geom

public.geometry

 

 

 

 

 

 

 

geom3857

public.geometry

 

 

 

 

 

 

Foreign Keys

There are no foreign keys for table polygone_safran

 

Check Constraints

There are no check constraints for table polygone_safran

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

polygonesafran_geom3857_idx

gist

 

geom3857

 

 

 

polygonesafran_geom_idx

gist

 

geom

 

 

 

polygonesafran_pkey

btree

 

gid

 

 

Triggers

There are no triggers for table polygone_safran

 

Rules

There are no rules for table polygone_safran

 

Policies

There are no policies for table polygone_safran

 

Referenced

There are no tables referenced by table polygone_safran

 

Properties

Property

Value

Inherited From

 

Rows

9892

Pages

354

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.polygone_safran (
 gid SERIAL,
 point INTEGER,
 xl2e INTEGER,
 yl2e INTEGER,
 geom public.geometry,
 geom3857 public.geometry,
 CONSTRAINT polygonesafran_pkey PRIMARY KEY(gid)
) ;

COMMENT ON TABLE public.polygone_safran
IS 'Polygones Safran 8x8KM avec l''identifiant point du centroide de la maille safran des fichiers biljou';

CREATE INDEX polygonesafran_geom3857_idx ON public.polygone_safran
 USING gist (geom3857 public.gist_geometry_ops_2d);

CREATE INDEX polygonesafran_geom_idx ON public.polygone_safran
 USING gist (geom 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