Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote -2 down vote favorite

expalin about ST_Makeline and its syntyax and forms. how we can store the resiltant line string into spatial table?

share|improve this question
3  
Your question is very generic. The documentation for ST_MakeLine is here: postgis.org/docs/ST_MakeLine.html - your question doesn't give much to go on beyond that. – GIS-Jonathan Nov 1 '12 at 10:32
This question simply asks for generic information about ST_Makeline. It does not have any specifics that would not be answered by reading the documentation. – Stevetech Nov 3 '12 at 10:24

closed as not a real question by iant♦, Get Spatial, djq, whuber♦ Nov 4 '12 at 20:56

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

up vote 0 down vote

In general, you would create a new spatial table in the normal way:

CREATE TABLE line_table ...;
SELECT AddGemetryColumn(...);

then run an insert query to add rows to the table:

INSERT INTO line_table ... SELECT MakeLine(p.geom) as geom,...
FROM points_tables AS p;
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.