07-09-2014 12:38 PM
I've got an app with a mapview and I'm looking to add the polyline feature, but I'm a little confused as to how I would add all the geographic points into my database? Do they all get pasted and appended into one column? Or do I need to keep adding columns for each set of points?
Right now my DB is setup to save one point location and I'm wondering if I have to make any drastic changes to accomodate Polylines.
All help is appreciated in will be liked and marked as solved if it solves the question.
Solved! Go to Solution.
07-10-2014 03:01 AM
07-10-2014 10:10 AM - edited 07-10-2014 10:14 AM
I didn't even think about writing a PolyLineID to group the points by. How would the function know to set PolyLineID = 3 instead. Could I query the db to search for the max under column PolyLineID and then take that number +1 ? Is this even possible?
I'm also wondering how I'd be able to fetch the data to be used to display a polyline afterwards?
I could probably do something like select polyLineID from locations group by polylineID for the main listview to show each set as one object. But for actually pulling that information, correct me if I'm wrong, I'd have to pull all the Lon/Lats for each PolyLineID = 3 and pull them based on the record ID number so that they are ordered correctly. Right?
07-10-2014 10:34 AM
07-10-2014 10:37 AM - edited 07-10-2014 10:43 AM
Awesome. Thanks for the insights. FYI, PolyLine is the feature in maps that draws a line on a map based on movement. Sometimes I have a hard time thinking out the logic. Will check out the firefox plugin.