pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: datasp
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: datasp
Schema
Owner
jmartin
Tablespace
(default)
Descriptions
There is no description for table datasp
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
row.names |
text |
|
|
|
|
|
|
|
row_names |
text |
|
|
|
|
|
|
|
par_annee |
integer |
|
|
|
|
|
|
|
bincase |
double precision |
|
|
|
|
|
|
|
strata |
integer |
|
|
|
|
|
|
|
id |
text |
|
|
|
|
|
|
|
burst |
text |
|
|
|
|
|
|
|
date |
timestamptz |
|
|
|
|
|
|
|
x |
double precision |
|
|
|
|
|
|
|
y |
double precision |
|
|
|
|
|
|
|
speed |
double precision |
|
|
|
|
|
|
|
rel_angle |
double precision |
|
|
|
|
|
|
|
ani_sexe |
text |
|
|
|
|
|
|
|
cap_age_classe |
text |
|
|
|
|
|
|
|
saison |
text |
|
|
|
|
|
|
|
period2 |
text |
|
|
|
|
|
|
|
dist_bois |
double precision |
|
|
|
|
|
|
|
dist_haies |
double precision |
|
|
|
|
|
|
|
dist_culture |
double precision |
|
|
|
|
|
|
|
dist_prairie |
double precision |
|
|
|
|
|
|
|
dist_routes |
double precision |
|
|
|
|
|
|
|
dist_batis |
double precision |
|
|
|
|
|
|
|
pts_geom |
public.geometry |
|
|
|
|
|
|
|
dist_cereale |
numeric |
|
|
|
|
|
|
|
dist_foret |
numeric |
|
|
|
|
|
|
|
dist_bosquet |
numeric |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table datasp
Check Constraints
There are no check constraints for table datasp
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
gist |
|
pts_geom |
|
|
|
Triggers
There are no triggers for table datasp
Rules
There are no rules for table datasp
Policies
There are no policies for table datasp
Referenced
There are no tables referenced by table datasp
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
605186 |
Pages |
91892 |
System |
|
Temporary |
|
With OID |
|
Definition
"row.names" TEXT,
row_names TEXT,
par_annee INTEGER,
bincase DOUBLE PRECISION,
strata INTEGER,
id TEXT,
burst TEXT,
date TIMESTAMP WITH TIME ZONE,
x DOUBLE PRECISION,
y DOUBLE PRECISION,
speed DOUBLE PRECISION,
rel_angle DOUBLE PRECISION,
ani_sexe TEXT,
cap_age_classe TEXT,
saison TEXT,
period2 TEXT,
dist_bois DOUBLE PRECISION,
dist_haies DOUBLE PRECISION,
dist_culture DOUBLE PRECISION,
dist_prairie DOUBLE PRECISION,
dist_routes DOUBLE PRECISION,
dist_batis DOUBLE PRECISION,
pts_geom public.geometry,
dist_cereale NUMERIC,
dist_foret NUMERIC,
dist_bosquet NUMERIC
)
WITH (oids = false);
CREATE INDEX datasp_pts_geom_idx ON "analyse".datasp
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 |
|