-
Notifications
You must be signed in to change notification settings - Fork 0
Installation
Willy Wong edited this page Aug 1, 2019
·
9 revisions
-
cd $YOUR_GIT_FOLDER
-
Make your CIL_Image_Viewer as the DocumentRoot in the Apache httpd.conf
-
Edit application/config/config.php
-
Create your own cil_annotation_service_config.json
Example:
{
"cil_annotation_pgsql_db":"host=*** port=5432 dbname=cil_image_annotation_db user=*** password=****",
"users":[
{
"username":"***",
"password":"****",
"salt": "*****"
}
]
}
- Create your PostgreSQL database
CREATE DATABASE cil_image_annotation_db
WITH OWNER = ccdbd_dev
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
CONNECTION LIMIT = -1;
- Create tables
CREATE TABLE images
(
id bigint NOT NULL,
image_id text,
max_z integer,
is_rgb boolean,
update_timestamp timestamp without time zone,
is_public boolean,
max_zoom integer,
init_lat integer,
init_lng integer,
init_zoom integer,
is_timeseries boolean DEFAULT false,
max_t integer,
x_pixel_offset bigint DEFAULT 0,
y_pixel_offset bigint DEFAULT 0,
original_file_location text,
max_x bigint,
max_y bigint,
CONSTRAINT image_id_pk PRIMARY KEY (id),
CONSTRAINT unique_image_id UNIQUE (image_id)
)
CREATE TABLE image_annotation_metadata
(
id bigint NOT NULL,
cil_id text,
zindex integer,
object_id text,
description text,
update_time timestamp without time zone,
CONSTRAINT i_annotation_metadata_pk PRIMARY KEY (id)
)
CREATE TABLE image_annotation
(
id bigint NOT NULL,
cil_id text,
z_index integer,
geo_json text,
update_timestamp timestamp without time zone,
CONSTRAINT image_annotation_pk PRIMARY KEY (id)
)