Project

General

Profile

Feature #12646

Add and import new data from Johan for OFC

Added by Philippe May 10 months ago. Updated 10 months ago.

Status:
New
Priority:
Normal
Assignee:
Start date:
01/08/2021
Due date:
% Done:

0%

Close

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

Revision bdbbf7db (diff)
Added by Philippe May 10 months ago

Add model for OFC points (refs #12646)

History

#1 Updated by Philippe May 10 months 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;

Also available in: Atom PDF