[postgis-users] Create Polygon from table columns

2014-07-01 Thread confugere
This post has NOT been accepted by the mailing list yet. Dear Community, I would like to create a polygon from a table containing landsat 8 corner coordinates in wgs84 CORNER_UL_LAT_PRODUCT DOUBLE PRECISION CORNER_UL_LON_PRODUCT DOUBLE PRECISION CORNER_UR_LAT_PRODUCT DOUBLE PRECISION

Re: [postgis-users] Create Polygon from table columns

2014-07-01 Thread Hugues François
Hello, I would have tried to achieve that in WKT using ST_GeomFromText(wkt,srid) : http://www.postgis.org/docs/ST_GeomFromText.html You can look at examples to format correctly the WKT string. But it could be easier to help you if you give us, at least the error message. Hugues.

Re: [postgis-users] Create Polygon from table columns

2014-07-01 Thread confugere
thanks a lot this worked fine. Greetings confugere -- View this message in context: http://postgis.17.x6.nabble.com/Create-Polygon-from-table-columns-tp5006584p5006589.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___

[postgis-users] Decoding canonical text of geometry(POINT) data

2014-07-01 Thread Dmitry Dzhus
I have a database table with a `geometry(POINT, 4326)` column. I need to decode its canonical text representation in the form of 010120E6108B20297D7CBF5440B2A19BFD81834B40 into its components 82.9919732, 55.0274045 *without* calling PostGIS functions like `st_x` and `st_y` (this is a

Re: [postgis-users] Decoding canonical text of geometry(POINT) data

2014-07-01 Thread Martijn Meijers
On 07/01/2014 02:30 PM, Dmitry Dzhus wrote: I have a database table with a `geometry(POINT, 4326)` column. I need to decode its canonical text representation in the form of 010120E6108B20297D7CBF5440B2A19BFD81834B40 into its components 82.9919732, 55.0274045 *without* calling PostGIS

Re: [postgis-users] Decoding canonical text of geometry(POINT) data

2014-07-01 Thread Rémi Cura
Or shapely, still in python. You can also use Geos I guess, in C. You can also go the command line way with ogr2ogr and gdal (there are python and R binding). I'm pretty sure you can find also web oriented parser. Cheers, Rémi-C 2014-07-01 14:38 GMT+02:00 Martijn Meijers

[postgis-users] SAP Claims Geospatial at Apache SPARK summit

2014-07-01 Thread maplabs
I am interested if anyone in the PostGIS community here, wants to discuss what this is and what it means.. (note I recently re-built a SOLR/Lucene Spatial and PostGIS benchmark also) http://databricks.com/blog/2014/07/01/integrating-spark-and-hana.html -- .. Much of the Big Data paradigm has