Re: [postgis-users] Create PostGIS point, line and polygon tables for PowerBI users

2020-09-18 Thread Shaozhong SHI
Hi, Mateusz, It seems that they use coding for areas. Have got point map and line map examples? Regards, Shao On Fri, 18 Sep 2020 at 20:13, Mateusz Loskot wrote: > On Fri, 18 Sep 2020 at 19:56, Shaozhong SHI > wrote: > > > > Hi, Mateusz, > > > > It sounds good. Any working example? > > C'm

Re: [postgis-users] Create PostGIS point, line and polygon tables for PowerBI users

2020-09-18 Thread Mateusz Loskot
On Fri, 18 Sep 2020 at 19:56, Shaozhong SHI wrote: > > Hi, Mateusz, > > It sounds good. Any working example? C'mon mate! https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map#use-custom-maps Best regards, -- Mateusz Loskot, http://mateusz.loskot.net _

Re: [postgis-users] Create PostGIS point, line and polygon tables for PowerBI users

2020-09-18 Thread Shaozhong SHI
Hi, Mateusz, It sounds good. Any working example? Regards, Shao On Friday, 18 September 2020, Mateusz Loskot wrote: > On Fri, 18 Sep 2020 at 13:51, Shaozhong SHI > wrote: > > > > Any working examples for creating PostGIS point, line and polygon tables > for PowerBI users? > > Namely, how be

Re: [postgis-users] Bytea data type and its application and uses

2020-09-18 Thread Giuseppe Broccolo
Hi Shao, I don't know how PowerBI works frankly. My idea is that they do not support direct access to bytea data, so maybe you need to put something in the middle to decode/encode. Giuseppe. Il giorno ven 18 set 2020 alle ore 11:17 Shaozhong SHI < shishaozh...@gmail.com> ha scritto: > Hi, Gius

Re: [postgis-users] Create PostGIS point, line and polygon tables for PowerBI users

2020-09-18 Thread Mateusz Loskot
On Fri, 18 Sep 2020 at 13:51, Shaozhong SHI wrote: > > Any working examples for creating PostGIS point, line and polygon tables for > PowerBI users? > Namely, how best to prepare map data sets in PostGIS for PowerBI users to > access and use. TopoJSON All you need is to refer to - Microsoft do

[postgis-users] Create PostGIS point, line and polygon tables for PowerBI users

2020-09-18 Thread Shaozhong SHI
Hi, Any working examples for creating PostGIS point, line and polygon tables for PowerBI users? Namely, how best to prepare map data sets in PostGIS for PowerBI users to access and use. Looking forward to hearing from you. Regards, Shao ___ postgis-us

Re: [postgis-users] Bytea data type and its application and uses

2020-09-18 Thread Shaozhong SHI
Hi, Giuseppe, Thank you for your reply. We know those literature. The issue is that there is a lack of working examples to demonstrate its use. Let's say that people are using PowerBI, Graphic Packages, GIS application users and etc. Can these packages access and retrieve image data (Bytea) f

Re: [postgis-users] Bytea data type and its application and uses

2020-09-18 Thread Giuseppe Broccolo
Hi Shao, What do you need to store, more specifically? Since this is a PostGIS related thread, is it about raster data, etc.? Anyway, as a general info about binary data: there are two general ways to insert binaries into a PostgreSQL database, the hex format and the escape format. I attach here