Working with Gisaf¶
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
Importing point data (TS and RTK) to GISAF - TO BE CHECKED¶
- Gisaf Admin > Basket > Survey data > "Project" > "surveyor" > TS/ RTK > upload > import.
- 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...
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.
Format of the survey file names¶
The date of the survey follows the ISO date standard:
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:
- Creation of a Point geometry: the raw_survey table has a geometry column for a single point (
geom) with x,y and z coordinates
- Save the
idof the original point to the
- A unique
idis computed from the following fields:
- The project is saved in the
- The surveyor identification in
- The date of survey is saved in the
- The accuracy is tagged in the
accur_id, according to a mapping defined in the
accuracyequimentsurveyormappingtable, which depends on the surveyor and equipment
- The category of the point
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
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)¶
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
URL for showing information of a feature¶
Gisaf can show information about a feature when it loads. This allows other softwares (Redmine, etc) to create links that bring their users to the feature on the map, and display the information related to it.
When Gisaf finds that the URL matches a certain pattern, it tries to load the layer of that feature, find the feature, zoom to it and open the information panel.
URLs can be crafted according to this template:
- <layerName>: name of the layer (store). Example:
- buildings from the "old" TDC building layer:
- cadastral plots:
- buildings from the "old" TDC building layer:
- <field>: field name. Example:
- <value>: value of that field