Re: [postgis-users] Can PostgreSQL/PostGIS store and serve pictures andsounds?

Hi, Il giorno ven 6 nov 2020 alle ore 12:44 Shaozhong SHI < shishaozh...@gmail.com> ha scritto: > Any showcases of desktop applications such as Word, Excel, Power Point, > Adobe Illustrator, Graphic packages loading data from PostgreSQL/PostGIS? > About Microsoft applications: potentially you co

Re: [postgis-users] raster intersecting geometry

You don't need to use ST_GeomFromText if it's already a geometry, if you need to set the SRID to 4326 then use ST_SetSRID(geom, 4326), but I don't think you need that either. Couple of other things I see as issues with this query 1) ST_Buffer is missing an amount to buffer by, if your coo

[postgis-users] raster intersecting geometry

Hi all, could anyone help me with the below query? I'm trying to find the geometries from a table (ch04.newpoint) which intersect the raster (ch04.dumprastval). However I can't seem to get it to work! Thanks. SELECT CAST((gval).val As integer) AS val, ST_Union((gval).geom) As geom FROM ( SELE

Re: [postgis-users] Can PostgreSQL/PostGIS store and serve pictures andsounds?

Any showcases of desktop applications such as Word, Excel, Power Point, Adobe Illustrator, Graphic packages loading data from PostgreSQL/PostGIS? Regards, David On Fri, 6 Nov 2020 at 12:07, p Valdés wrote: > see blobs and bytea > > https://www.postgresql.org/docs/9.1/datatype-binary.html > > E

Re: [postgis-users] Can PostgreSQL/PostGIS store and serve pictures andsounds?

see blobs and bytea https://www.postgresql.org/docs/9.1/datatype-binary.html El vie., 6 de nov. de 2020 a la(s) 11:42, Shaozhong SHI ( shishaozh...@gmail.com) escribió: > Hi, Karsten, > > Can PowerPoint or a desktop application load in a picture from PostgreSQL? > > Regards, > > Shao > > On Fri,

Re: [postgis-users] Can PostgreSQL/PostGIS store and serve pictures andsounds?

Hi, Karsten, Can PowerPoint or a desktop application load in a picture from PostgreSQL? Regards, Shao On Fri, 6 Nov 2020 at 08:57, karsten wrote: > Hi David, > > it certainly can be used to store pictures . I have for example stored > jpeg pictures taken via an ODK app and then stored in post

Re: [postgis-users] Can PostgreSQL/PostGIS store and serve pictures andsounds?

Hi, I'd suggest having a look as well at `bytea` data type, which has been introduced after blobs. Here an useful link to understand which is more suitable depending on your use case: https://wiki.postgresql.org/wiki/BinaryFilesInDB Cheers, Giuseppe. Il giorno ven 6 nov 20

Re: [postgis-users] Problem raster2pgsql on Centos 8 - postgres 12 / postgis

From: "Regina Obe" mailto:l...@pcorp.us>> Sounds from the below thread the issue is with proj and the interaction with GDAL. Can both of you let me know what the output of SELECT postgis_full_version() Gives - and also do an ldd raster2pgsql ldd postgis-2.5.s

Re: [postgis-users] Can PostgreSQL/PostGIS store and serve pictures andsounds?

Hi David, it certainly can be used to store pictures . I have for example stored jpeg pictures taken via an ODK app and then stored in postgres used the data type bytea for the picture itself. It also is possible to store audio or other file types as a blob see e.g. https://www.postgresql.org/do

[postgis-users] Can PostgreSQL/PostGIS store and serve pictures and sounds?

It is interesting to know the range and types of data PostgreSQL/PostGIS can store and serve. We know that it can deal with GIS data. We wonder whether it can be used for general purposes like storing and serving pictures and sounds? Regards, David __