Upload a plugin

Plugins

Plugin tags

3d accessibility accuracy accuracy assessment address agriculture analysis android angle animation api append archaeology area asset atlas attribute attribute edit attribute table attributes azimuth basemap batch bing biodiversity borehole bounding box brasileiro browser buffer cad cadastre calculator canvas capture catalog catastro chm circle classification click clip clipboard cloud cluster composer configuration connector contour conversion convert converter coordinate coordinates copy cross section crs csv d3 danmark dansk data database datasource delimitation dem denmark densify density development digitising digitize digitizing diretoria distance distribution download download service downloader drainage draw dsg dsm dtm dxf ecology edit editing elevation ellipse epanet españa excel export expression extraction exército feature field fields filter find flood flow forest forms france generalization geocode geocoder geocoding geodesic geographic mcda geográfico geojson geology geometry geopackage geopaparazzi georeference gis gml google google earth gps gpx graph grib grid grids groundwater group here histogram home range html hydraulic hydraulic modelling hydraulics hydrology ibama imagery images import index inp inspection inspire interlis interpolation intersection javascript join kmz labeling land land cover landsat landscape las layer layer tree layers laz leaflet legend lidar line linear referencing lines load loader location locator manholes map maps marxan mask mesh metadata model modelling mongo mongodb multiple nederland netcdf network network analysis nominatim ogc open data openlayers openstreetmap ordnance survey orientation osm paste pdf pdok photos pie pipes plot plugin poi point point cloud pointcloud pointclouds points polygon polygons polyline postgis postgresql print printing processing productivity profile project projection properties python qgis qml query raster rectangle remote sensing report river road route routing sample sar satellite scale scripts search section seismic hazard select selection sentinel server service services serviço shape shapefile shortest path sld snap spain spatial spatial join spatialite split sql sqlite statistics stats stream street street view streetview style survey svg table terrain tile tiles time time series tms toc tool tools topography topology traffic transformation translate transport trigger uav update urban morphology utm vector vector layer video view viewer visibility vn2000 water wcs web web services webmap webmaps webservice webservices wfs wkt wms wps zoom

QGIS Python Plugins Repository

pgChainage Plugin icon

(4) 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)

Author
Christoph Jung
Maintainer
jagodki
Tags
postgislinepostgresqlchainagevectorpoints
Plugin home page
https://github.com/jagodki/pgChainage
Tracker
Browse and report bugs
Code repository
https://github.com/jagodki/pgChainage
Latest stable version
2.0.0
Version Experimental Minimum QGIS version Downloads Uploaded by Date
2.0.0 no 3.0.0 2150 jagodki May 20, 2018, 3:43 a.m.
1.1.0 no 2.0.0 885 jagodki March 13, 2018, 11:57 a.m.
1.0 no 2.0.0 572 jagodki Feb. 19, 2018, 10:32 p.m.

Sponsors