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

[Stefan Wolf]

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/0835d948/attachment.html>