Logo Alexandre Neto
  • Home
  • About
  • Services
  • Recent Posts
  • Posts
  • Plugins
  • English
    Português English
  • Dark Theme
    Light Theme Dark Theme System Theme
Logo Inverted Logo
  • Tags
  • ArcGIS
  • Atlas
  • Cartography
  • Composer
  • Conda
  • Conda-Forge
  • Gdal
  • Hint
  • Mamba
  • Map Composer
  • Open Source
  • Opinion
  • Postgis
  • Pyqgis
  • Python
  • QGIS
  • Recart
  • SQL
  • Tutorial
  • Vscode
Hero Image
Getting multipolygon vertexes using PostGIS

Today I needed to create a view in PostGIS that returned the vertexes of a multi-polygon layer. Besides, I needed that they were numerically ordered starting in 1, and with the respective XY coordinates. It seemed to be a trivial task – all I would need was to use the ST_DumpPoints() function to get all vertexes – if it wasn’t for the fact that PostGIS polygons have a duplicate vertex (the last vertex must be equal to the first one) that I have no interess in showing.

  • Postgis
Friday, November 6, 2015 | 2 minutes Read
Hero Image
Labels leading lines with QGIS and Postgis

Recently I had the need to add labels to features with very close geometries, resulting in their collision. Using data-defined override for label’s position (I have used layer to labeled layer plugin to set this really fast) and the QGIS tool to move labels, it was quite easy to relocate them to better places. However, in same cases, it was difficult to understand to which geometry they belonged.

  • Cartography
  • Hint
  • Postgis
  • QGIS
Monday, January 12, 2015 | 2 minutes Read
Navigation
  • About
  • Services
  • Recent Posts
  • Plugins
Contact me:
  • srnetochan
  • Alexandre Neto
  • @alexnetogeo
  • @alexnetogeo

Toha Theme Logo Toha
© 2022 Copyright. Globe icon created by Freepik - Flaticon
Powered by Hugo Logo