Milki-way: A GIS enabled web-interface for Supply chain management used in Commodity Distribution Presented By: Ashok Philip Verghese Deepu R.S. Shabeerali Thomas Emmanuel
15/11/06
Contents • • • • • • • • • • • •
Introduction Why milki-way ? Problem solution Our approach Database Design Implementation Work status Tools & Technologies used Features of Geoserver Further enhancements Acknowledgment References
Introduction • A web-based system developed with the help of GIS and database that helps commodity manufactures and distributors retrieve information for decision making and deliver products efficiently and cost-effectively.
3/22
Why milki-way….? • Distribution network configuration and Distribution Strategy:Number and Location of retailers. • Information: Integrate systems and processes through the supply chain to share valuable information, including demand signals, forecasts, inventory and transportation.
4/22
Why milki-way….?(contd) • Difficulty to analyze tabular-data in information system • And visualize the optimum path
5/22
Web + GIS ... what we can do to solve these problems • A Web enabled GIS can play a major role in real time monitoring and decision support for effectively tackling problems associated with supply chain logistics such as production scheduling ,cost and transportation. • This system can be implemented by using a centralized database which stores upto date information on all retailers from various geographical locations. 6/22
Web + GIS ... what we can do to solve those problems(contd) • Using a Web enabled GIS we could calculate the optimum path for transportation at the lowest cost in the given time.
7/22
Our approach to solving the problem The communities who use this system are classified into two • 1) Central Supplier • 2) Retailers
8/22
Our approach to solving the problem(contd) • Central suppliers are the major users of all the functionalities • They can view all the orders for various commodities from various retailers spread across different locations
9/22
Our approach to solving the problem(contd) • The interface for the central suppliers will provide a powerful map with layered information of retailers. • They can also generate reports based on different criteria. • We maintain a centralized database for keeping all information related to these communities. 10/22
milki-way System model
11/22
Database Design
12/22
Database Design(contd)
13/22
IMPLEMENTATION
Tools &Technologies used • • • • •
Geoserver PostGIS+ PostgreSQL Tomcat Eclipse JSP,Servlet,HTML
15/22
Work done so far…. • • • •
User Login Interface for retailer for product ordering Generated shape files from postgis data Designed spatial relationships to calculate shortest path
16/22
Work yet to be implemented • Bringing multiple thematic layers into a single view. • Producing dynamic layers by querying We think this can be done using WFS (web feature service) component of geoserver. 17/22
Work to be done (contd) • Finding the shortest path With the help of the package pgdijkstra developed by cartoweb we can find routing solutions using their library functions. 1) assign_vertex_id(’roads’, 1) 2)create_graph_tables(’roads’, ‘int4′) 3)update_cost_from_distance(’roads’) 4)shortest_path_as_geometry(’roads’, 179551, 179681); 18/22
Features of Geoserver • Fully compliant to WMS and WFS specifications • Support for PostGIS, Shapefile, ArcSDE, DB2 and Oracle • Full SLD support, both user defined (POST and GET), as well as used in styling configuration. • Java (J2EE) servlet-based, can run in any servlet container • Embedded MapBuilder, a web mapping client, for instant visualization
19/22
Further enhancements • Mobile interface for retailers • Extending to multiple suppliers
20/22
Acknowledgment • • • •
Dr. Venkatesh Chopella Mr. T Radhakrishnan Chris Tweedie Friends
21/22
References:• • • • • • •
http://docs.codehaus.org/display/GEOS/ http://postgis.refractions.net/ http://www.postgresql.org/ http://cartoweb.org/contribs.html http://tomcat.apache.org/ http://en.wikipedia.org/wiki/Supply_Chain_Management http://chris.narx.net/
22/22