Re: [postgis-users] PostGIS as a solution for non-geographic x-y or temporal data ?

2014-08-28 Thread RĂ©mi Cura
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

Re: [postgis-users] Elevation profiles from rasters

2014-08-28 Thread Pierre Racine
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

[postgis-users] Get a feature geojson from postgis

2014-08-28 Thread Max Demars
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

Re: [postgis-users] Get a feature geojson from postgis

2014-08-28 Thread Rasmus Aveskogh
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