Project

General

Profile

Working with Gisaf » History » Version 4

« Previous - Version 4/5 (diff) - Next » - Current version
Giulio Di Anastasio, 06/05/2021 15:02


Working with Gisaf

Survey data

Raw survey data are contained in CSV files, typically downloaded from surveying instruments.

See more information of the process for the survey data (including a flow diagram) at Gisaf workflow

Survey data

Importing point data (TS and RTK) to GISAF - TO BE CHECKED

  1. Gisaf Admin > Basket > Survey data > "Project" > "surveyor" > TS/ RTK > upload > import.
  2. Auto import of Raw points data (changes from Raw to Shapefiles, the point files)
    In GISAF Admin > Other> Project > select the project for which you want to import the data > with selected > Auto import to GIS...

Import basket

Gisaf provides an "import basket" dedicated for raw survey data, which is generated by land survey equipment (Leica's Total Station and RTK).

These are CSV files, like:

100081,370633.969,1327742.157,51.187,,,
100083,370628.876,1327702.913,51.565,T52,,
100082,370628.729,1327720.019,51.261,T52,,
100081,370633.969,1327742.154,51.179,,,
100083,370628.876,1327702.913,51.565,T52,,
20800,370633.969,1327742.154,51.180,,,
20801,370618.795,1327713.172,52.817,E30,,
20802,370623.674,1327711.436,51.283,B35,,
20803,370619.314,1327713.407,51.383,B35,,

Each category (5th column) must be defined in the Category table (see Categories).

Organization of the raw survey data basket

The basket should be organized in a directory structure:

- Project name (these can be themselves put in a hierarchy of (sub)directories)

- Surveyor's organization

- Equipment (eg. TS, RTK)

- Survey files (eg. Our_project-Some_comment-2018-02-23.txt)

Format of the survey file names

Our_project-Some_comment-2018-02-23.txt

The date of the survey follows the ISO date standard: YYYY-MM-DD.

Import to the database

When importing raw survey data files to the database, Gisaf does 2 steps as described below.
It's worth noting that, in this process, no reprojection is done.

Feed the raw_survey table

Each point of the imported raw survey data file is inserted to the raw_survey table:

  1. Creation of a Point geometry: the raw_survey table has a geometry column for a single point (geom) with x,y and z coordinates
  2. Save the id of the original point to the orig_id column
  3. A unique id is computed from the following fields: id, project, equipment, date
  4. The project is saved in the project_id column
  5. The surveyor identification in srvyr_id
  6. The date of survey is saved in the date column
  7. The accuracy is tagged in the accur_id, according to a mapping defined in the accuracyequimentsurveyormapping table, which depends on the surveyor and equipment
  8. The category of the point

Feed the RAW_V_* tables

From the raw_survey table, each point is then copied to its respective RAW_V_ table, with basically the same information.

These tables (which should be created manually or with the admin notebook called create_tables, as of today's writing), only contain points.

The project is saved along: see below.

Import the points

For categories that define points (opposite to lines and polygons, which require line work carried over in CAD or in a GIS software, see Line work), the points can be imported automatically to their final destination: the V_* tables.

Note: in this process, the geometries are reprojected.

Auto import of the points

The points found in the RAW_V_* tables can be imported automatically, project per project, the project page of the admin interface.

Import of the line work (lines and polygons)

See Line work - to be written

The shapefiles generated manually (line work) should be put in the project's basket, and imported from it.

Documentation - Tags retained after re-import of same geometry

Documentation - Tags retained after re-import of same geometry
The linework for infrastructure survey carried out by Eric Chacra in May 2020 was originally imported with a problem of ambiguity in the "Accuracy" table and in the "Accuracy" table.
The result was that lines did not inherit the attributes survey date, accuracy, equipment, surveyor.
Nevertheless lines were displayed on the Gisaf map, without these attributes, and tags were given to some of these lines.

The values for the two tables ("Accuracy", "Accuracy") have been corrected, ambiguity resolved.
The lines in the layers V-ELEC-UGND------E and V-COMM-CABL------E have been then reimported, the attributes have been properly assigned, and the tags have been retained.

4 August 2020

Access to data

Connection to server directly from CSR

To connect to the server directly without going through Aurinoco server, the correct url is
http://gis.csr.av