Hi Nikhil, Here is 5 lines of python code that will help to visualize the routes on google maps like this..
http://www.darrinward.com/lat-long/?id=1958126 As per your disclaimer this is not .NET code nor hi-fi server required. Anyone can visualize lat-lon data Using the 2 tables mentioned in phase 1 and 2. # Downloaded routes and stops from the sheets !wget https://s3.amazonaws.com/oksoft/routes.csv !wget https://s3.amazonaws.com/oksoft/stops.csv # imported the csv data into python pandas dataFrame import pandas as pd routes = pd.read_csv('routes.csv',usecols=["Route Num", "StopNo", "StopEN", "StopCode"]) stops = pd.read_csv('stops.csv',usecols=["stop_id", "stop_name", "stop_desc","stop_lat", "stop_lon"]) # Merge these 2 frames on stop code - id this is one to many relation # one stop_id from stops table can be in many routes df=pd.merge(routes, stops, left_on='StopCode', right_on='stop_id') # Find co-ordinates of all stops of a given route for e.g. 1000XD and export the data to csv file df.loc[df['Route Num'] == '1000XD'][['stop_lat', 'stop_lon']].to_csv('myroute.csv', index=False) # open the csv and pass the values to google map !cat myroute.csv This can also be achieved using php+mysql but using python-pandas makes it extensible and easy to integrate. -- Shantanu Oak On Friday, 13 May 2016 10:03:16 UTC+5:30, Nikhil VJ wrote: > > Hi Friends, > > Please connect with anyone who would like to do some fundoo > coding-for-public: > > Design document: (a ppt slideshow) : Bus Route Information Management > System > <https://docs.google.com/presentation/d/1FuLHS84uHuxQEsEquiWxcuiUdkv7Z8l29ImsYay5SHc/pub?start=false&loop=true&delayms=30000> > > (lots of things ironed out since the last time I spammed you about this, > and I've now broken it down to phases where initial ones would be fairly > simple to implement) > > Specific detail: As far as possible I want to pull this off on > PHP/SQL/Javascript platform. > > If you could connect me with a pune-based college's computer science > department it would be heavenly! > > Sharing a few of the slides to stoke your imagination.. > > [image: Inline image 9] > > [image: Inline image 10] > > [image: Inline image 11] > > [image: Inline image 12] > > (please see the link shared at top for seeing all the slides) > > > [image: Inline image 6] [image: Inline image 7] [image: Inline image 8] > > > Disclaimer note: If you believe you're a .NET-only developer then this is > not for you. And, absolutely no hi-fi advanced server/stack based solutions > allowed which require complicated command-line installations on server side > and need to be maintained as if they're some freakin' nuclear power plant. > This whole thing can run off just 2 tables in its most basic form (phase > 1&2), so let's keep things simple. Aur copyright / IPR ki baat ki toh > chappal khayegaa. > > > Read *some FAQs here > <http://nikhilsheth.blogspot.in/2016/05/faqs-about-bus-routes-management-system.html>.* > > Thanks for your time! Do connect if interested! > > Link for sharing this article on FB/twitter/etc > <http://nikhilsheth.blogspot.in/2016/05/project-to-make-managing-bus-routes.html> > or share my FB post > <https://www.facebook.com/permalink.php?story_fbid=239268519773446&id=100010708982322> > > > -- > Cheers, > Nikhil > +91-966-583-1250 > Pune, India > Self-designed learner at Swaraj University < > http://www.swarajuniversity.org> > http://nikhilsheth.blogspot.in > -- Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org --- You received this message because you are subscribed to the Google Groups "datameet" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
