pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: centroid
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: centroid
Schema
Owner
jmartin
Tablespace
(default)
Descriptions
There is no description for table centroid
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
row.names |
text |
|
|
|
|
|
|
|
id |
text |
|
|
|
|
|
|
|
x |
double precision |
|
|
|
|
|
|
|
y |
double precision |
|
|
|
|
|
|
|
par_annee |
double precision |
|
|
|
|
|
|
|
pts_geom |
public.geometry |
|
|
|
|
|
|
|
prop_bois |
numeric |
|
|
|
|
|
|
|
prop_anthro |
numeric |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table centroid
Check Constraints
There are no check constraints for table centroid
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
gist |
|
pts_geom |
|
|
|
Triggers
There are no triggers for table centroid
Rules
There are no rules for table centroid
Policies
There are no policies for table centroid
Referenced
There are no tables referenced by table centroid
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
163 |
Pages |
8 |
System |
|
Temporary |
|
With OID |
|
Definition
"row.names" TEXT,
id TEXT,
x DOUBLE PRECISION,
y DOUBLE PRECISION,
par_annee DOUBLE PRECISION,
pts_geom public.geometry,
prop_bois NUMERIC,
prop_anthro NUMERIC
)
WITH (oids = false);
CREATE INDEX centroid_pts_geom_idx ON "analyse".centroid
USING gist (pts_geom public.gist_geometry_ops_2d);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|