pgTrajDB2TempT: Insert relocations from a source table into the table...

Description Usage Arguments Author(s)

Description

If relocations are given as X,Y coordinates, they are converted into a POINT geometry in PostGIS.

Usage

1
2
3
pgTrajDB2TempT(conn, schema, relocations_table, pgtrajs, animals,
  bursts = NULL, relocations, timestamps, rids, srid, proj4string, note,
  clauses, time_zone)

Arguments

conn

Connection object created with RPostgreSQL

schema

String. Name of the schema that stores or will store the pgtraj data model.

relocations_table

String. Name of the table that stores the relocations, e.g. c("schema","relocations")

pgtrajs

String. Name of the pgtraj or name of the field that stores the pgtraj names.

animals

String. Name of the animal or name of the field that stores the animal names.

bursts

String. Name of the burst or name of the field that stores the burst names.

relocations

Vector of string(s). Name of the field(s) that contains the relocations in relocations_table. If relocations are stored as pairs of (X,Y) or (long, lat) coordinates, the coordinates should be separated in two fields and referenced accordingly.

timestamps

String. Name of the field in relocations_table that contains the timestamps.

rids

String. Name of the field in relocations_table that contains the numeric IDs of relocations.

srid

Numeric. The PostGIS SRID of the CRS of 'relocations'.

proj4string

String. The PROJ4 string to be inserted into pgtraj table.

note

String. Comment on the pgtraj. The comment is only used in the database and not transferred into an ltraj.

clauses

String. Additional SQL to modify select query from relocations_table

time_zone

String. Time zone to be inserted into pgtraj table.

Author(s)

Balázs Dukai


rpostgisLT documentation built on May 2, 2019, 3:04 a.m.