I have a spatial data table in PostGIS 2.1 that looks like this:
Geom | type | cost
POLYGON(0 0,1 1,2 2)| A | 123POLYGON(3 3,4 4,5 5)| b | 123
I am trying to create a view of this table that looks like this for a system that does not support spatial data natively:
vertexorder | x | y | type | Cost
1 | 0 | 0 | A | 1232 | 1 | 1 | A | 1233 | 2 | 2 | A | 1231 | 3 | 3 | b | 1232 | 4 | 4 | b | 1233 | 5 | 5 | b | 123
Is there anyway to query for vertex like this?
Many thanks
أكثر...
Geom | type | cost
POLYGON(0 0,1 1,2 2)| A | 123POLYGON(3 3,4 4,5 5)| b | 123
I am trying to create a view of this table that looks like this for a system that does not support spatial data natively:
vertexorder | x | y | type | Cost
1 | 0 | 0 | A | 1232 | 1 | 1 | A | 1233 | 2 | 2 | A | 1231 | 3 | 3 | b | 1232 | 4 | 4 | b | 1233 | 5 | 5 | b | 123
Is there anyway to query for vertex like this?
Many thanks
أكثر...