Re: [postgis-users] postgis logo (vector : svg, pdf)?

[Mike Toews]

On 2 March 2016 at 13:43, Saulteau Don  wrote:
> There's some at http://download.osgeo.org/postgis/logo_suite/
>
> The folders have eps, and psd files. Are these the ones?

Unfortunately none of the files are true vector files, for instance
the EPS contains bitmaps, not vectors.

The README says the artwork was made with Macromedia Fireworks, but
these source files are absent from that location. (And they may not be
useful, as the software was abandoned years ago).
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] postgis logo (vector : svg, pdf)?

[Saulteau Don]

There's some at http://download.osgeo.org/postgis/logo_suite/

The folders have eps, and psd files. Are these the ones?



Donovan

On Tue, Mar 1, 2016 at 6:12 AM, Rémi Cura  wrote:

> Hey dear list,
> looking for a vector version of the postgis official logo.
>
> I know I could reverse vectorize it from image,
> but anybody has it somewhere?
>
> Cheers,
> Rémi-C
>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] Create raster from row-col table

[Etienne B. Racine]

Many thanks Pierre,

I can create a 100 x 200 x 1000 raster in about 30 seconds. That's quite a
lot of pixels organized !

For the archives, here's the complete code:
--
CREATE SCHEMA test;

CREATE TABLE test.measure AS
SELECT r as rowy, c as colx, b as band, round(random() * 100)::float as v
FROM generate_series(1, 100) as r
  CROSS JOIN LATERAL generate_series(1, 200) as c
  CROSS JOIN LATERAL generate_series(1, 1000) as b;

CREATE TABLE test.rasters AS
SELECT 1 as rid, ST_AddBand(ST_MakeEmptyRaster(200, 100, 1, 1, 1, 1, 0, 0,
0), --width, height
  ARRAY[ ROW(NULL, '32BF', -, -) -- 1 ]::addbandarg[]) as rast;

CREATE TABLE test.the_raster AS
WITH rw AS (
  SELECT band, rowy, array_agg(v ORDER BY colx) a
  FROM test.measure GROUP BY band, rowy ),
valarray AS (
  SELECT band, array_agg_mult(ARRAY[a] ORDER BY rowy) a
  FROM rw GROUP BY band ),
raster AS (
  SELECT rast FROM test.rasters
  WHERE rid=1 ),
newraster AS (
  SELECT ST_AddBand(NULL, array_agg(ST_SetValues(rast, 1, 1, 1, valarray.a)
  ORDER BY band), 1) As rast
  FROM valarray, raster )
SELECT rast FROM newraster;

Etienne

Le lun. 29 févr. 2016 à 10:31, Pierre Racine 
a écrit :

> Hi Etienne,
>
> > Still, I can't figure how to load an arbitrary number of bands using your
> > snippet. If I remove WHERE band=1 I still get a unique band.
>
> This query will work for many bands and will aggregate all of them in a
> single raster:
>
> WITH rows AS (
>   SELECT band, colx, array_agg(v ORDER BY rowy) a
>   FROM test.measure
>   GROUP BY band, colx
> ), valarray AS (
>   SELECT band, array_agg_mult(ARRAY[a] ORDER BY colx) a
>   FROM rows
>   GROUP BY band
> ), raster AS (
>   SELECT rast FROM test.rasters WHERE rid=1
> ), newraster AS (
>   SELECT ST_AddBand(NULL, array_agg(ST_SetValues(rast, 1, 1, 1,
> valarray.a) ORDER BY band), 1) As rast
>   FROM valarray, raster
> )
> SELECT band, (ST_PixelAsPolygons(rast, band)).*
> FROM newraster, generate_series(1,2) band;
>
> this will work only if they all have the same width/height.
>
> Pierre
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] postgis logo (vector : svg, pdf)?

[Rémi Cura]

Hey dear list,
looking for a vector version of the postgis official logo.

I know I could reverse vectorize it from image,
but anybody has it somewhere?

Cheers,
Rémi-C
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users