What I meant about (time,[-88,88]) -- X,Y is that a tone is very similiar
to the same tone one octave up and one octave down.
This introduces problems because your tone space is not flat (like [1,88]).
Therefore you may want to models this using a third dimension.
However you can somehow only use
Try 100x100...
-Original Message-
From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-
boun...@lists.osgeo.org] On Behalf Of Rasmus Aveskogh
Sent: Wednesday, August 27, 2014 11:08 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Elevation profiles from
Hi list,
I would like to get a geojson feature with properties from PostGIS. I have
found an example
http://www.postgresonline.com/journal/archives/267-Creating-GeoJSON-Feature-Collections-with-JSON-and-PostGIS-functions.html
to have a feature collection but I can't make it works for just a
Example from my own application, you should be able to modify that to fit your
case.
SELECT row_to_json(f) As feature FROM (SELECT 'Feature' As type,
ST_AsGeoJSON(ST_Transform(l.geometry, 4326))::json As geometry,
row_to_json((SELECT l FROM (SELECT id, 'l' AS type, name, area) As l)) As