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
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.
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.
___
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
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
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
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