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