[Mapbender-users] demo.sqlite data type srs

[Astrid Emde (WhereGroup)]

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
   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
-------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0x1C287CCB.asc
Type: application/pgp-keys
Size: 1574 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20230213/9308b371/attachment.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20230213/9308b371/attachment.sig>