Project

General

Profile

Feature #13968

Create layers and all for the LB records

Added by Philippe May over 2 years ago. Updated over 2 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Start date:
26/04/2022
Due date:
% Done:

0%

Close

Description

Follow up of discussions with Land Board Helena and Cleo.

Associated revisions

Revision 2cce957b (diff)
Added by Philippe May over 2 years ago

Add layers for cadastral LB (Refs #13968)

History

#1 Updated by Philippe May over 2 years ago

Updating the "cadastral" model file. In addition to that:

Database

Create schema (as postgres):

avgis=# create schema other_lb AUTHORIZATION avgis;

Copy table (as avgis):

avgis=> CREATE TABLE other_lb.cadastral_lb AS TABLE other_avf.cadastral_avf;
SELECT 10562
avgis=> CREATE TABLE other_lb.cadastral_lb_dissolved AS TABLE other_avf.cadastral_avf_dissolved ;
SELECT 587

Style

insert into gisaf_map.qml (model_name, mapbox_paint ) VALUES ( 'CadastralLB', '{"fill-outline-color": ["rgba", 80, 100, 100, 0.4], "fill-color": ["match", ["get", "class"], "AVF", ["rgba", 150, 220, 150, 0.6], "B-Memo-Av", ["rgba", 150, 200, 100, 0.4], "Puramboke", ["rgba", 80, 20, 160, 0.4], "Temple", ["rgba", 20, 80, 150, 0.4], "Govt-land", ["rgba", 20, 80, 150, 0.4], "AV-Long-term-lease", ["rgba", 200, 230, 100, 0.6], "Access", ["rgba", 200, 130, 100, 0.6], "Exchanged", ["rgba", 150, 220, 150, 0.2], "Sea-erosion", ["rgba", 150, 150, 20, 0.5], "Private", ["rgba", 200, 200, 200, 0.1], ["rgba", 200, 200, 200, 0.4]]}');
insert into gisaf_map.qml (model_name, mapbox_paint ) VALUES ( 'CadastralLBDissolved', '{"fill-outline-color": ["rgba", 80, 100, 100, 0.4], "fill-color": ["match", ["get", "class"], "AVF", ["rgba", 150, 220, 150, 0.6], "B-Memo-Av", ["rgba", 150, 200, 100, 0.4], "Puramboke", ["rgba", 80, 20, 160, 0.4], "Temple", ["rgba", 20, 80, 150, 0.4], "Govt-land", ["rgba", 20, 80, 150, 0.4], "AV-Long-term-lease", ["rgba", 200, 230, 100, 0.6], "Access", ["rgba", 200, 130, 100, 0.6], "Exchanged", ["rgba", 150, 220, 150, 0.2], "Sea-erosion", ["rgba", 150, 150, 20, 0.5], "Private", ["rgba", 200, 200, 200, 0.1], ["rgba", 200, 200, 200, 0.4]]}');

#2 Updated by Philippe May over 2 years ago

  • Status changed from New to Resolved

Also available in: Atom PDF