pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: datav
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: datav
Schema
Owner
jmartin
Tablespace
(default)
Descriptions
There is no description for table datav
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
row.names |
text |
|
|
|
|
|
|
|
x |
double precision |
|
|
|
|
|
|
|
y |
double precision |
|
|
|
|
|
|
|
date |
timestamptz |
|
|
|
|
|
|
|
dx |
double precision |
|
|
|
|
|
|
|
dy |
double precision |
|
|
|
|
|
|
|
dist |
double precision |
|
|
|
|
|
|
|
dt |
double precision |
|
|
|
|
|
|
|
R2n |
double precision |
|
|
|
|
|
|
|
abs.angle |
double precision |
|
|
|
|
|
|
|
rel.angle |
double precision |
|
|
|
|
|
|
|
id |
text |
|
|
|
|
|
|
|
burst |
text |
|
|
|
|
|
|
|
date.2 |
timestamptz |
|
|
|
|
|
|
|
cpos_id |
integer |
|
|
|
|
|
|
|
ani_id |
integer |
|
|
|
|
|
|
|
ani_sexe |
text |
|
|
|
|
|
|
|
cap_age |
text |
|
|
|
|
|
|
|
cap_age_corrige |
text |
|
|
|
|
|
|
|
cap_age_classe |
text |
|
|
|
|
|
|
|
cap_poids |
double precision |
|
|
|
|
|
|
|
the_geom |
text |
|
|
|
|
|
|
|
pos_x |
double precision |
|
|
|
|
|
|
|
pos_y |
double precision |
|
|
|
|
|
|
|
pos_systeme |
text |
|
|
|
|
|
|
|
pos_z |
double precision |
|
|
|
|
|
|
|
pos_x_corrige |
double precision |
|
|
|
|
|
|
|
pos_y_corrige |
double precision |
|
|
|
|
|
|
|
pos_z_corrige |
double precision |
|
|
|
|
|
|
|
pos_nb_sat |
integer |
|
|
|
|
|
|
|
pos_dop |
double precision |
|
|
|
|
|
|
|
pos_dop_corrige |
double precision |
|
|
|
|
|
|
|
cpos_date |
date |
|
|
|
|
|
|
|
cpos_heure |
text |
|
|
|
|
|
|
|
cpos_delta |
integer |
|
|
|
|
|
|
|
cpos_prog10minutes |
boolean |
|
|
|
|
|
|
|
par_os |
text |
|
|
|
|
|
|
|
par_grd_cat |
text |
|
|
|
|
|
|
|
par_annee |
integer |
|
|
|
|
|
|
|
distance_route |
double precision |
|
|
|
|
|
|
|
distance_bati |
double precision |
|
|
|
|
|
|
|
distance_bois |
double precision |
|
|
|
|
|
|
|
distance_haies |
double precision |
|
|
|
|
|
|
|
date.1 |
timestamptz |
|
|
|
|
|
|
|
saison |
text |
|
|
|
|
|
|
|
id.1 |
text |
|
|
|
|
|
|
|
habitat |
text |
|
|
|
|
|
|
|
speed |
double precision |
|
|
|
|
|
|
|
edges |
text |
|
|
|
|
|
|
|
dist_cereale |
numeric |
|
|
|
|
|
|
|
pts_geom |
public.geometry |
|
|
|
|
|
|
|
dist_prairie |
numeric |
|
|
|
|
|
|
|
dist_friche |
numeric |
|
|
|
|
|
|
|
dist_terre |
numeric |
|
|
|
|
|
|
|
dist_partif |
numeric |
|
|
|
|
|
|
|
dist_refuge |
numeric |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table datav
Check Constraints
There are no check constraints for table datav
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
gist |
|
pts_geom |
|
|
|
Triggers
There are no triggers for table datav
Rules
There are no rules for table datav
Policies
There are no policies for table datav
Referenced
There are no tables referenced by table datav
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
91107 |
Pages |
32126 |
System |
|
Temporary |
|
With OID |
|
Definition
"row.names" TEXT,
x DOUBLE PRECISION,
y DOUBLE PRECISION,
date TIMESTAMP WITH TIME ZONE,
dx DOUBLE PRECISION,
dy DOUBLE PRECISION,
dist DOUBLE PRECISION,
dt DOUBLE PRECISION,
"R2n" DOUBLE PRECISION,
"abs.angle" DOUBLE PRECISION,
"rel.angle" DOUBLE PRECISION,
id TEXT,
burst TEXT,
"date.2" TIMESTAMP WITH TIME ZONE,
cpos_id INTEGER,
ani_id INTEGER,
ani_sexe TEXT,
cap_age TEXT,
cap_age_corrige TEXT,
cap_age_classe TEXT,
cap_poids DOUBLE PRECISION,
the_geom TEXT,
pos_x DOUBLE PRECISION,
pos_y DOUBLE PRECISION,
pos_systeme TEXT,
pos_z DOUBLE PRECISION,
pos_x_corrige DOUBLE PRECISION,
pos_y_corrige DOUBLE PRECISION,
pos_z_corrige DOUBLE PRECISION,
pos_nb_sat INTEGER,
pos_dop DOUBLE PRECISION,
pos_dop_corrige DOUBLE PRECISION,
cpos_date DATE,
cpos_heure TEXT,
cpos_delta INTEGER,
cpos_prog10minutes BOOLEAN,
par_os TEXT,
par_grd_cat TEXT,
par_annee INTEGER,
distance_route DOUBLE PRECISION,
distance_bati DOUBLE PRECISION,
distance_bois DOUBLE PRECISION,
distance_haies DOUBLE PRECISION,
"date.1" TIMESTAMP WITH TIME ZONE,
saison TEXT,
"id.1" TEXT,
habitat TEXT,
speed DOUBLE PRECISION,
edges TEXT,
dist_cereale NUMERIC,
pts_geom public.geometry,
dist_prairie NUMERIC,
dist_friche NUMERIC,
dist_terre NUMERIC,
dist_partif NUMERIC,
dist_refuge NUMERIC
)
WITH (oids = false);
CREATE INDEX datav_pts_geom_idx ON "analyse".datav
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 |
|