[postgis-users] Looking for information for allowing Office 365 Excel to access and use map data stored on PostGIS.

[Shaozhong SHI]

Thanks, Stefan, excel has geography as a new data type.  How to supply from
postgis?

Regards, shao

On Tuesday, 12 November 2019, Stefan Wolf <sw at zpmt.de> wrote:

>
>
> That’s right – PostGIS itself doesn‘t produce any maps – only GEOMETRIES
> as POINTs, POLYGONs etc.
>
>
>
> PostGIS can produce the Query-Result “AsGeoJSON“ (an open Standard-Format).
>
>
>
> Bing Maps (and others) can “read” and disply this GeoJSON …
>
>
>
> Regards
>
> -Stefan-
>
>
>
>
>
>
>
>
>
> *Von:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] *Im
> Auftrag von *Shaozhong SHI
> *Gesendet:* Dienstag, 12. November 2019 16:43
> *An:* PostGIS Users Discussion
> *Betreff:* Re: [postgis-users] Looking for information for allowing
> Office 365 Excel to access and use map data stored on PostGIS.
>
>
>
> Thanks, Stefan,
>
>
>
> I can load in tables, but geometry column contains codes only.  It does
> not show up as a map.
>
>
>
> Regards,
>
>
>
> Shao
>
>
>
> On Tue, 12 Nov 2019 at 13:10, Stefan Wolf <sw at zpmt.de> wrote:
>
> Google for: odbc pass through query
>
>
>
> SQL *pass*-*through queries* are used to send commands directly to an
> *ODBC* database server. By *using* an SQL *pass*-*through query*, you
> work directly with the server tables instead of having the Microsoft Jet
> database engine process the data.
>
>
>
> You can use “normal” PostgreSQL-SQL syntax like in pgAdmin…
>
>
>
> Regards
>
> -Stefan-
>
>
>
>
>
>
>
> *Von:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] *Im
> Auftrag von *Shaozhong SHI
> *Gesendet:* Dienstag, 12. November 2019 13:26
> *An:* PostGIS Users Discussion
> *Betreff:* [postgis-users] Looking for information for allowing Office
> 365 Excel to access and use map data stored on PostGIS.
>
>
>
> Has anyone got such information?
>
>
>
> Looking forward to hearing from you.
>
>
>
> Regards,
>
>
>
> Shao
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20191112/a332d33f/attachment.html>