<div dir="ltr"><div>A little history might help.<br></div><div><div>In the early 2000's before Google Maps, I built a mapping interface for the State of Colorado called AquaMap. It had WMS backgrounds and SVG for all the vector elements and was based on the work done by Andreas Nueman and others. The client wanted to put a legal definition of a parcel into a spreadsheet, upload it to a web map in SVG, and then allow the user to manipulate the coordinates (snapping, rotation, etc.) via the browser over existing parcels and the WMS background. Then, and most importantly, they wanted to save the altered SVG shape into the spatial database (PostGIS). I wrote the javascript functions to convert SVG into a WKT format that was then uploaded to the database. It worked very well for years but the slow adoption of SVG (Microsoft) meant the interface was eventually replaced by other technologies.</div><div><br></div><div>My code lay dormant until Regina wanted to do letters :</div><div><a href="https://www.postgresonline.com/journal/archives/293-Saying-Happy-Valentine-in-PostGIS.html">https://www.postgresonline.com/journal/archives/293-Saying-Happy-Valentine-in-PostGIS.html</a><br></div><div>and</div><div><a href="https://www.postgresonline.com/journal/archives/302-Word-Play-with-Spatial-SQL.html">https://www.postgresonline.com/journal/archives/302-Word-Play-with-Spatial-SQL.html</a><br></div><div><br></div><div>I tweaked my code enough to give her the SQL commands to store the glyphs in PostGIS. Since then based on some requests from others I converted the javascript to python.</div><div><br></div><div>Maybe the discussion should be about implementing a ST_GeomFomSVG function instead</div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jan 27, 2022 at 5:09 AM Greg Troxel <<a href="mailto:gdt@lexort.com">gdt@lexort.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>
Sandro Santilli <<a href="mailto:strk@kbt.io" target="_blank">strk@kbt.io</a>> writes:<br>
<br>
> On Wed, Jan 26, 2022 at 04:22:40PM -0500, Regina Obe wrote:<br>
>> Might be too big to throw into main (data wise), but as included as a<br>
>> separate extension in repo would be nice.<br>
><br>
> What advantage would this be compared to separate extension in<br>
> separate repository as it is now ? Just wondering...<br>
<br>
I had no idea postgis_letters existed, so a few questions/comments:<br>
<br>
There is talk of big, but how much are we talking about? Currently on<br>
my system package sizes are:<br>
postgis: 29 MB<br>
server: 20 MB<br>
client: 16 MB<br>
So if we're talking 500 kB, it's not a big deal, but doubling the<br>
package size for something only makes senes if most users want it. I<br>
can't see that more than a few would want it.<br>
<br>
Different packaging systems have different approaches to splitting<br>
packages that are from a single upstream release. In general, if<br>
things are supposed to be packaged separately, it's nicer/cleaner to<br>
have them separate upstream.<br>
<br>
I don't understand what postgis_letters is for, and why people would<br>
want it. Fonts don't really exist in space like most objects people<br>
represent in postgis. I suppose a few people might do this to be able<br>
to shift/scale to coordinates to stake out a garden that makes a word<br>
when viewed from the air. So what's it for? Is it just test code? A<br>
neat hack for fun? Somehow helpful for map rendering? The repo<br>
doesn't explain; the linked example supports "this is test data for a<br>
tutorial/exploration of what the functions do'.<br>
<br>
It seems that the extension should come with code to process fonts in<br>
standard representations, rather than preprocessed fonts. It could<br>
then just use fonts already on the system, and it would be both more<br>
powerful and smaller.<br>
_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-devel" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a><br>
</blockquote></div>