Project

General

Profile

Feature #12646

Add and import new data from Johan for OFC

Added by Philippe May 3 months ago. Updated 3 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 3 months ago

Add model for OFC points (refs #12646)

History

#1 Updated by Philippe May 3 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