Create Table

The minimum requirements are four columns ‘id’, ‘location’, ‘latlngalt’, and ‘timestamp’

Create the table in PostgreSQL:

CREATE TABLE mytable (
id integer DEFAULT nextval('public.my_id_seq'::regclass) NOT NULL,
location point,
latlngalt json,
"timestamp" timestamp without time zone
);

AcuGIS Scout is programmed to ignore Primary auto-incremented key when creating forms.

So create an appropriate sequence

CREATE SEQUENCE public.my_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

In the next section, we’ll look at optional field data types.

Mandatory Columns

id

Primary key with autoincrement. Does not appear on rendered form

location

Stores location as lat/lon point

latlngalt

Stores altitude, along with lat/lon as json

timestamp

Stores date and time