pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Table: bad_geom_notclosed

 

 

Schema

analyse

 

Owner

albenard

 

Tablespace

(default)

 

Descriptions

There is no description for table bad_geom_notclosed

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

 

par_id

integer

 

 

 

 

 

 

 

par_annee

integer

 

 

 

 

 

 

 

par_recno

double precision

 

 

 

 

 

 

 

geom

public.geometry

 

 

 

 

 

 

 

geom_corrige

public.geometry

 

 

 

 

 

 

 

st_isvalidreason

text

 

 

 

 

 

 

 

diff_surface

double precision

 

 

 

 

 

 

 

poly_avt

integer

 

 

 

 

 

 

 

anneaux_avt

integer

 

 

 

 

 

 

 

points_avt

integer

 

 

 

 

 

 

 

nouv_poly

integer

 

 

 

 

 

 

 

nouv_anneaux

integer

 

 

 

 

 

 

 

nouv_points

integer

 

 

 

 

 

 

 

analysefine

varchar(32)

 

 

 

 

Résultat de la fonction ps_correction_geom

 

Foreign Keys

There are no foreign keys for table bad_geom_notclosed

 

Check Constraints

There are no check constraints for table bad_geom_notclosed

 

Indices

There are no indices for table bad_geom_notclosed

 

Triggers

There are no triggers for table bad_geom_notclosed

 

Rules

There are no rules for table bad_geom_notclosed

 

Policies

There are no policies for table bad_geom_notclosed

 

Referenced

There are no tables referenced by table bad_geom_notclosed

 

Properties

Property

Value

Inherited From

 

Rows

52275

Pages

15037

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE "analyse".bad_geom_notclosed (
 par_id INTEGER,
 par_annee INTEGER,
 par_recno DOUBLE PRECISION,
 geom public.geometry,
 geom_corrige public.geometry,
 st_isvalidreason TEXT,
 diff_surface DOUBLE PRECISION,
 poly_avt INTEGER,
 anneaux_avt INTEGER,
 points_avt INTEGER,
 nouv_poly INTEGER,
 nouv_anneaux INTEGER,
 nouv_points INTEGER,
 analysefine VARCHAR(32)
)
WITH (oids = false);

COMMENT ON COLUMN "analyse".bad_geom_notclosed.analysefine
IS 'Résultat de la fonction ps_correction_geom';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23
Previous topic Chapter index Next topic