Wednesday, May 29, 2013

Dump LineString GEOM to Point GEOM (One Model To Another)

Is it possible, outside of using a raw SQL query (PostGIS/PostgreSQL) to do a GEOM dump.

I have a table (model) where 1 row is 1 LineString and I need to dump that table into another table (model) where 1 row is 1 point from the LineString.

Raw SQL would be something like:

SELECT geom AS points FROM ST_DumpPoints((SELECT fl_line FROM greenland.line_paths WHERE ...));
In this case line_paths is the LineString table and fl_line the LineString GEOM.

How can I do this within GeoDjango w/o using rawSQL and bypassing the models?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments:

Post a Comment