[postgis-devel] postgis_letters in project tree?

[Paul Ramsey]

Actually now that it's all one function, the possibility of feeding it an optional JSON map of an alternate font becomes something we could contemplate.


> On Jan 27, 2022, at 3:00 PM, Bruce Rindahl <bruce.rindahl at gmail.com> wrote:
> 
> Looking at the code I would propose the following as a process if someone wants a different font.
> Convert TTF to SVG via Batik 
> Run my python script to convert the SVG to SQL
> Using Regina's postgis_letters extension, load the SQL into the font table
> Using whatever Paul did to generate the function (I assume you did it with a single SELECT statement) generate the new function
> 
> If this sounds good just let me know where to add my python script.
> 
> On Thu, Jan 27, 2022 at 2:46 PM Paul Ramsey <pramsey at cleverelephant.ca> wrote:
> Challenge accepted, all just one function.
> 
> https://gist.github.com/pramsey/2020ef463a8880edc7e23c56420d7df8
> 
> > On Jan 27, 2022, at 2:08 PM, Darafei Komяpa Praliaskouski <me at komzpa.net> wrote:
> > 
> > I like this way. Believe we only need one function really.
> > 
> > (I called this ST_GeomFromText in my head for a bit...)
> > 
> > пт, 28 сту 2022, 00:38 карыстальнік Paul Ramsey <pramsey at cleverelephant.ca> напісаў:
> > Here's the two functions. I think putting these into the default postgis extension makes sense, they are small and then we have letter magic available for doco etc wherever we want.
> > 
> > https://gist.github.com/pramsey/2020ef463a8880edc7e23c56420d7df8
> > 
> > P
> > 
> > > On Jan 27, 2022, at 10:32 AM, Paul Ramsey <pramsey at cleverelephant.ca> wrote:
> > > 
> > > Using base64 encoded twkb, i can get the letters set down to a 22K function. So, I think maybe this just goes into the main postgis extension. (Assuming you're OK with my minimalist anglo no-special-font handling approach.)
> > > 
> > >> On Jan 27, 2022, at 9:29 AM, Martin Davis <mtnclimb at gmail.com> wrote:
> > >> 
> > >> 
> > >> On Thu, Jan 27, 2022 at 9:03 AM Paul Ramsey <pramsey at cleverelephant.ca> wrote:
> > >> I'm thinking of converting the letter/font table into a function with a fixed collection of letters, so that an install involves just two functions ST_GeomFromLetter(letter) and ST_GeomFromWord(text). ST_GeomFromLetter can be expanded over time to include additional letters for other language charsets. That matches the capabilities of the system to the needs.
> > >> 
> > >> That sounds like the simplest approach.  Nice to avoid needing a table.  
> > >> _______________________________________________
> > >> postgis-devel mailing list
> > >> postgis-devel at lists.osgeo.org
> > >> https://lists.osgeo.org/mailman/listinfo/postgis-devel
> > > 
> > 
> > _______________________________________________
> > postgis-devel mailing list
> > postgis-devel at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-devel
> > _______________________________________________
> > postgis-devel mailing list
> > postgis-devel at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-devel
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel