, 2 ) ELSE ST_ConcaveHull ( ST_MakeLine ( ST_Translate ( ST_Transform (foo.geom, 26986 ),x * random ( ) * 500,y * random ( ) * 500 ) ), 0. id, ST_AsPNG ( ST_AsRaster ( CASE WHEN id = 1 THEN ST_Buffer ( ST_MakeLine ( ST_Translate ( ST_Transform (foo.geom, 26986 ),x * random ( ) * 500,y * random ( ) * 500 ) ) What I really wanted to do was render a randomly complex query that returns images like this one. Using Ad-Hoc queries that return images in Base
My port is pretty non-standard since I've got like 20 different versions of PostgreSQL installed on my local pc for development. host=localhost port=5440 dbname=postgis20_sampler user=postgres password=whatever If you want to not be prompted for username and password, for newer odb, seems you have to include in the connection string like so. Connecting to a PostgreSQL databaseĪs said the native PostgreSQL driver in 3.5 just uses the SDBC syntax, so I was able to connect to my database by typing this in for the Database URL: host=localhost port=5440 dbname=postgis20_sampler Since I was installing new LibreOffice 3.5, I thought this might be a good test of its metal. I suspected Base was a capable option, but had never tested it to confirm. One of the frequently asked questions on the PostGIS list by folks using the new not yet officially released (alpha5 recently released) functionality in PostGIS 2.0 is how to render rasters As discussed in PSQL needs a better way of outputting bytea
What I really wanted to do with it is experiment with its graphical rendering capabilities.
The connection string syntax follows the old SBC native driver of prior OpenOffice versions we itemized in Using OpenOffice Base with PostgeSQL. I was excited to learn from Pasha Golub's blog LibreOffice Base 3.5 now comes packaged with native PostgreSQL driver so no separate configuration is required.
0 kommentar(er)
