Upload a plugin


Plugin tags

3d accessibility accuracy accuracy assessment address analysis android animation api archaeology area asset atlas attribute attribute edit attribute table attributes azimuth basemap batch bing browser buffer cad cadastre calculator canvas catalog catastro circle classification click clip cloud cluster composer configuration convert converter coordinate copy crs csv d3 danmark dansk data database datasource delimitation dem densify development digitising digitize digitizing distance download download service downloader drainage draw dtm dxf ecology edit editing elevation ellipse epanet excel export extraction feature field filter flood flow forest generalization geocoding geodesic geojson geology geometry geopaparazzi georeference geotag gis gml google gps gpx grid grids histogram home range html hydraulic hydraulic modelling hydraulics hydrology ibama import index inspire interlis intersection join kmz labeling land cover landsat landscape layer layer tree layers leaflet legend lidar line lines load loader manholes map maps marxan mask mesh metadata model modelling mongo mongodb multiple network network analysis ogc open data openlayers openstreetmap ordnance survey orientation os osm pdf pdok photos pipes point points polygon polyline postgis postgresql print printing processing productivity profile project projection properties python query raster rectangle remote sensing report river road routing sample sar satellite scripts search select selection sentinel server service shape shapefile snap spain spatial spatial join spatialite split sql sqlite statistics stream street streetview style survey svg table terrain tiles time time series tms toc tool tools topography topology transformation translate trigger update utm vector vector layer visibility water wcs web webmap webmaps webservice webservices wfs wkt wms wps zoom

QGIS Python Plugins Repository

pgChainage Plugin icon

(2) votes 

plugin for chainage linestrings of a table directly in PostgreSQL/PostGIS

This plugin converts a layer of line strings into a chain of points. The main work takes place directly in the PostgreSQL-/PostGIS-database, i.e. big tables have not to be imported into QGIS before and during processing.
Usage: Fill in the parameters for establishing a connection to the database. The DBMS has to be PostgreSQL, and the extension PostGIS must created before starting the processing.
Press the "connect to database"-button. A Message Bar above the map window will appear and tells the user, whether a connection could established or not.
Choose the table (and schema), which should be used for the chainage. The table must have a geometry column of the type LINESTRING. Then fill in the other fields. The CRS can differ from the CRS of the choosed geometry. The PlugIn calls the PostGIS-function ST_Transform(...) to project the geometries into the specified CRS; to state the CRS of the geometry-column is not necessary. It is recommended to specify a metric CRS. If the checkbox "calculate last point/last substring of lines" is checked, the endpoint and/or the last substring of each line will be calculated by ignoring the specified equidistance (just for the end-geometries) and inserted into the database.
Their are three buttons to start the processing. The button "create points" just creates points along each line. The button "create substrings" just creates lines with the same specified distance from the input layer. The button "create points & substrings" starts both processings.
Important: The plugin has been developed and tested using PostgreSQL 10 and PostGIS 2.4. Maybe it will not work with older versions of the named products, e.g. the chainage is realized by using the PostGIS-function ST_LineInterpolatePoint, which has the name ST_line_interpolate_point e.g. in PostGIS 2.1.
Source of the icon: Webalys - Kameleon Icons (http://www.kameleon.pics)

Christoph Jung
Plugin home page
Browse and report bugs
Code repository
Latest stable version
Version Experimental Minimum QGIS version Downloads Uploaded by Date
1.1.0 no 2.0.0 113 jagodki March 13, 2018, 11:57 a.m.
1.0 no 2.0.0 283 jagodki Feb. 19, 2018, 10:32 p.m.