We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Geo-Infographics created dynamically from PostGIS using ST_AsSVG

Formale Metadaten

Titel
Geo-Infographics created dynamically from PostGIS using ST_AsSVG
Serientitel
Anzahl der Teile
351
Autor
Lizenz
CC-Namensnennung 3.0 Unported:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen.
Identifikatoren
Herausgeber
Erscheinungsjahr
Sprache
Produktionsjahr2022

Inhaltliche Metadaten

Fachgebiet
Genre
Abstract
## The Problem Let's assume you have an attribute-focused table, but you would still like to see a thumbnail of the associated geometry. Or more generally: How to dynamically render polygon geometries in a HTML page without any mapping library. *Enter ST_AsSVG (PostGIS function)!* ## Context Last year I showed how we display geo data in our webapps using vector tiles (ST_AsMVT) (YouTube: watch?v=s_dWBOiuFiY&t=139s). This year I will explain how we apply ST_AsSVG of PostGIS on database records to *create beautiful geo-infographics* in pure HTML. The result is a geo-visualization similar to this one: Comparison maps of Australian Cities (Size, Population) (imgur.com/OQClpbc). The trickiest part will be the sizing of the SVG objects (viewport vs. viewBox (webdesign.tutsplus.com/tutorials/svg-viewport-and-viewbox-for-beginners--cms-30844)). ## Content The talk will contain some theory on SVG. It will then show basic setups for FastAPI, SQLModel, Jinja2 and, of course, PostGIS. All code will be made available via GitHub. ## Aim After the talk you will master sizing of SVG and be capable of creating your own dynamic geo-infographics directly from data stored in your PostGIS database.
Schlagwörter