[Mapbender-users] demo.sqlite data type srs

[Gal Zsolt]

Thank you Astrid
GÁL Zsolt

Satelit NT
0744384065


On 13 February 2023 at 10:05:01 +02:00, Astrid Emde (WhereGroup) <astrid.emde at wheregroup.com> wrote:

> Hello Gal,
> 
> what you see is serialize data.
> 
> Learn more about it through the following links.
> 
> <https://www.php.net/manual/en/language.oop5.serialization.php>
> <https://www.w3schools.com/php/func_var_serialize.asp>
> <https://www.php.net/manual/en/function.unserialize.php>
> 
> See you Astrid
> 
> Am 2023-02-12 07:21, schrieb Gal Zsolt:
> 
> > Hello List!
> > I have more than ten application in Mapbender. I like to make reports
> > from it as a start point for documenting it.
> > I download demo.sqlite to my computer and try/use i-net Clear Reports
> > Designer to make this reports. It works fine.
> > Some fields contains data like this:
> > a:5:{i:0;s:9:"EPSG:3844";i:1;s:10:"EPSG:31700";i:2;s:9:"EPSG:4326";i:3;s:9:"EPSG:3857";i:4;s:6:"CRS:84";}
> > (Example from table mb_wms_wmslayersource field _srs_)
> > I Google it to find out what is this without success.
> > I guess a:5 means array with 5 items, {…} means array content,
> > i:0;s:9:"EPSG:3844" means index 0, string of 9 characters, string:
> > EPSG:3844.
> > I plan to write a Python program wich access the downloaded
> > demo.sqlite database and transform all the fields in all tables.
> > Ex.:
> > from
> > a:5:{i:0;s:9:"EPSG:3844";i:1;s:10:"EPSG:31700";i:2;s:9:"EPSG:4326";i:3;s:9:"EPSG:3857";i:4;s:6:"CRS:84";}
> > make
> > EPSG:3844,"EPSG:31700,EPSG:4326,EPSG:3857,CRS:84
> > My questions: exist better solution? The a:5:{…….} string is a
> > result of PHP object to string conversion?
> > Thanks in advance for any answer.
> > GÁL Zsolt
> > _______________________________________________
> > Mapbender_users mailing list
> > Mapbender_users at lists.osgeo.org
> > <https://lists.osgeo.org/mailman/listinfo/mapbender_users>
> > 
> -- 
> Mit freundlichen Grüßen
> 
> Astrid Emde
> GIS-Consultant
> 
> **********************************************
> FOSSGIS Konferenz
> 15.-18. März 2023 in Berlin
> <https://fossgis-konferenz.de/2023/>
> 
> WhereGroup-Beiträge auf der FOSSGIS
> <https://wheregroup.com/unternehmen/aktuelles/>
> **********************************************
> 
> Astrid Emde
> WhereGroup GmbH
> Eifelstraße 7
> 53119 Bonn
> Germany
> 
> Tel: +49(0)228 90 90 38 - 22
> Fax: +49(0)228 90 90 38 - 11
> 
> <astrid.emde at wheregroup.com>
> <http://www.wheregroup.com>
> 
> Meinen PGP Public-Key können Sie unter pgp.mit.edu herunterladen:
> <https://keys.openpgp.org/vks/v1/by-fingerprint/01F8152D36FC07C25EADDE86C5084ACC1C287CCB>
> Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen
> 
> Folgen Sie der WhereGroup auf twitter:
> <http://twitter.com/WhereGroup_com>
> 
> Geschäftsführer:
> Olaf Knopp, Peter Stamm
> Amtsgericht Bonn, HRB 9885
> -------------------------------
> 
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> <https://lists.osgeo.org/mailman/listinfo/mapbender_users>
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20230213/d79b2fd5/attachment.htm>