Feature #12646
Add and import new data from Johan for OFC
Start date:
01/08/2021
Due date:
% Done:
0%
Description
Mail received the 31/7/2021.
Johan sent a zip with 2 sets of "shapefiles": for lines (same format than before, no issue), and for points (new model, to be defined).
Associated revisions
Add model for OFC points (refs #12646)
History
#1 Updated by Philippe May over 3 years ago
Added the model in the code - see associated commit.
For the database:
CREATE TABLE avsm_misc.optical_fiber_point ( id serial primary key, code VARCHAR(10), type VARCHAR(6));
SELECT AddGeometryColumn('avsm_misc', 'optical_fiber_point','geom',4326,'POINT',3);
GRANT ALL ON SEQUENCE avsm_misc.optical_fiber_point_id_seq to avgis;
GRANT ALL ON TABLE avsm_misc.optical_fiber_point to avgis;