Dataloy Distance Table XML Queries (xmlDDT)

This set of services is designed so you can import Dataloy's ports and distances directly into your own shipping application.

Subscribers with more than 10 licenses of our Dataloy Distance Table (DDT) can utilise all services, clients with less than 10 licenses are limited to queries without waypoints (sailing route) in XML format.

The service is limited to 4000 distances/year/license.

NOTE: To be implemented by someone having basic XML knowledge.

Port and Distance Services

Available for all subscribers:

    Port Lookups

  • XmlPort Port lookup using port name
  • XmlPort UN Locode Port lookup using UNLOCODE
  • Distance Lookups

  • XmlDistance Distance lookup using two portIDs.
  • XmlDistance w/UNLocode Distance lookup using two UNLocodes
  • XmlDistance Point To PortDistance lookup using Point and PortID
  • XmlDistance Port To PointDistance lookup using PortID and Point

Distance Services With Sailing Route/Waypoint details

Available for subscribers with more than 10 licenes:

  • XmlDistance w/Waypoints Distance and sailing route lookup using PortIDs
  • XmlPortToPoint w/WaypointsDistance and sailing route lookup using PortID and Point
  • XmlPointToPort w/WaypointsDistance and sailing route lookup using Point and PortID

Detailed Descriptions:


Services Available For All Subscribers:

XmlPort

Query Example URL: http://dataloy.com/ddt-server/XmlPort?port=TOKYO&username=USERNAME&password=PASSWORD

Parameters:

  1. port, Port name e.g. TOKYO. You can also provide a search such as TOK, and the query will return first 10 ports that match this search criteria.
  2. username - same as your DDT login user name.
  3. password - same as your DDT login user name.

This XML returns information about the port including its port_id to be included as parameter to XmlDistance.

Query output:

                        <PORTS>
                        <PORT>
                        <PORT_ID>100430</PORT_ID>
                        <PORT_NAME>TOKYO</PORT_NAME>
                        <LATITUDE>35.637</LATITUDE>
                        <LONGITUDE>139.773</LONGITUDE>
                        <LOCATION_CODE>TYO</LOCATION_CODE>
                        <COUNTRY_NAME>JAPAN</COUNTRY_NAME>
                        </PORT>
                        </PORTS>
                        
                    

XmlPort UN Locode

Query Example URL: http://dataloy.com/ddt-server/XmlPortUNLocode?port=JPTYO&username=USERNAME&password=PASSWORD

Parameters:

  1. port, Port code (UN Locode) e.g. JPTYO.
  2. username - same as your DDT login user name.
  3. password - same as your DDT login user name.

This XML returns information about the port including its port_id to be included as parameter to XmlDistance.

Query output:

                        <PORTS>
                        <PORT>
                        <PORT_ID>100430</PORT_ID>
                        <PORT_NAME>TOKYO</PORT_NAME>
                        <LATITUDE>35.637</LATITUDE>
                        <LONGITUDE>139.773</LONGITUDE>
                        <LOCATION_CODE>TYO</LOCATION_CODE>
                        <COUNTRY_NAME>JAPAN</COUNTRY_NAME>
                        <UN_LOCODE>JPTYO</UN_LOCODE>
                        </PORT>
                        </PORTS>
                        
                    

XmlDistance

Query Example URL: http://dataloy.com/ddt-server/XmlDistance?from=104146&to=100430&username=USERNAME&password=PASSWORD

Parameters:

  1. from, PortID (retrieved by XmlPort).
  2. to, PortID (retrieved by XmlPort).
  3. username, - same as your DDT login user name.
  4. password, - same as your DDT login user name.

The XML this query returns the distance between the ports, and the main routing point it used when calculating the distance.

Query output:

                        <PORT_DISTANCE>
                        <DISTANCE>11718.0</DISTANCE>
                        <VIA>SUEZ CANAL</VIA>
                        </PORT_DISTANCE>
                    

XmlDistance w/UNLocode as parameter

Query Example URL: http://dataloy.com/ddt-server/XmlDistance?from=NOBGO&to=JPTYO&username=USERNAME&password=PASSWORD&unlocode=true

Parameters:

  1. from, UNLocode
  2. to, UNLocode
  3. username, - same as your DDT login user name.
  4. password, - same as your DDT login user name.

The XML this query returns the distance between the ports, and the main routing point it used when calculating the distance.

Query output:

                        <PORT_DISTANCE>
                        <DISTANCE>11718.0</DISTANCE>
                        <VIA>SUEZ CANAL</VIA>
                        </PORT_DISTANCE>
                    

XmlDistance Point To Port

Query Example URL: http://dataloy.com/ddt-server/XmlPointToPort?from=0100N 00100E&to=100430&username=USERNAME&password=PASSWORD

Parameters:

  1. from, Point (format: 0000x 00000x) eg. 0500N 06000E
  2. to, PortId (retrieved by XmlPort).
  3. username, - same as your DDT login user name.
  4. password, - same as your DDT login user name.

The XML this query returns the distance between the point and the port

Query output:

                        <PORT_DISTANCE>
                        <DISTANCE>10858</DISTANCE>
                        </PORT_DISTANCE>
                    

XmlDistance Port To Point

Query Example URL: http://dataloy.com/ddt-server/XmlPortToPoint?from=100430&to=0100N 00100E&username=USERNAME&password=PASSWORD

Parameters:

  1. from, PortId (retrieved by XmlPort).
  2. to, Point (format: 0000x 00000x) eg. 0500N 06000E
  3. username, - same as your DDT login user name.
  4. password, - same as your DDT login user name.

The XML this query returns the distance between the point and the port

Query output:

                        <PORT_DISTANCE>
                        <DISTANCE>10858</DISTANCE>
                        </PORT_DISTANCE>
                    

Services Available For Subscribers With More Than 10 Licenses:

XmlDistance w/Waypoints

Query Example URL: http://dataloy.com/ddt-server/XmlDistanceWithWp?from=104146&to=100430&username=USERNAME&password=PASSWORD

Parameters:

  1. from, PortID (retrieved by XmlPort).
  2. to, PortID (retrieved by XmlPort).
  3. username, - same as your DDT login user name.
  4. password, - same as your DDT login user name.

The XML this query returns the distance between the ports, and all waypoints between.

Query output:

                        <PORT_DISTANCE>
                        <TOTAL_DISTANCE>11718.0</TOTAL_DISTANCE>
                        <WAYPOINTS>
                            <WAYPOINT>
                                <ROUTING_SEQUENCE_NO>1</ROUTING_SEQUENCE_NO>
                                <WP_NAME>BERGEN</WP_NAME>
                                <LATITUDE>60.392039</LATITUDE>
                                <LONGITUDE>5.306605</LONGITUDE>
                                <SUB_DISTANCE>0.99822</SUB_DISTANCE>
                            </WAYPOINT>
                            
                            <WAYPOINT>
                                <ROUTING_SEQUENCE_NO>2</ROUTING_SEQUENCE_NO>
                                <WP_NAME>Bergen (Port)</WP_NAME>
                                <LATITUDE>60.403558</LATITUDE>
                                <LONGITUDE>5.282379</LONGITUDE>
                                <SUB_DISTANCE>1.22086</SUB_DISTANCE>
                            </WAYPOINT>
                            [...]
                        </WAYPOINTS>
                        </PORT_DISTANCE>
                            
                    

XmlPortToPoint w/Waypoints

Query Example URL: http://dataloy.com/ddt-server/XmlPortToPointWithWp?from=104146&to=100430&username=USERNAME&password=PASSWORD

Parameters:

  1. from, PortID (retrieved by XmlPort).
  2. to, Point (format: 0000x 00000x) eg. 0500N 06000E
  3. username, - same as your DDT login user name.
  4. password, - same as your DDT login user name.

The XML this query returns the distance between the ports, and all waypoints between.

Query output:

                        <PORT_DISTANCE>
                        <TOTAL_DISTANCE>11718.0</TOTAL_DISTANCE>
                        <WAYPOINTS>
                            <WAYPOINT>
                                <ROUTING_SEQUENCE_NO>1</ROUTING_SEQUENCE_NO>
                                <WP_NAME>BERGEN</WP_NAME>
                                <LATITUDE>60.392039</LATITUDE>
                                <LONGITUDE>5.306605</LONGITUDE>
                                <SUB_DISTANCE>0.99822</SUB_DISTANCE>
                            </WAYPOINT>
                            
                            <WAYPOINT>
                                <ROUTING_SEQUENCE_NO>2</ROUTING_SEQUENCE_NO>
                                <WP_NAME>Bergen (Port)</WP_NAME>
                                <LATITUDE>60.403558</LATITUDE>
                                <LONGITUDE>5.282379</LONGITUDE>
                                <SUB_DISTANCE>1.22086</SUB_DISTANCE>
                            </WAYPOINT>
                            [...]
                        </WAYPOINTS>
                        </PORT_DISTANCE>
                            
                    

XmlPointToPort w/Waypoints

Query Example URL: http://dataloy.com/ddt-server/XmlPointToPortWithWp?from=104146&to=100430&username=USERNAME&password=PASSWORD

Parameters:

  1. from, Point (format: 0000x 00000x) eg. 0500N 06000E
  2. to, PortID (retrieved by XmlPort).
  3. username, - same as your DDT login user name.
  4. password, - same as your DDT login user name.

The XML this query returns the distance between the ports, and all waypoints between.

Query output:

                        <PORT_DISTANCE>
                        <TOTAL_DISTANCE>11718.0</TOTAL_DISTANCE>
                        <WAYPOINTS>
                            <WAYPOINT>
                                <ROUTING_SEQUENCE_NO>1</ROUTING_SEQUENCE_NO>
                                <WP_NAME>BERGEN</WP_NAME>
                                <LATITUDE>60.392039</LATITUDE>
                                <LONGITUDE>5.306605</LONGITUDE>
                                <SUB_DISTANCE>0.99822</SUB_DISTANCE>
                            </WAYPOINT>
                            
                            <WAYPOINT>
                                <ROUTING_SEQUENCE_NO>2</ROUTING_SEQUENCE_NO>
                                <WP_NAME>Bergen (Port)</WP_NAME>
                                <LATITUDE>60.403558</LATITUDE>
                                <LONGITUDE>5.282379</LONGITUDE>
                                <SUB_DISTANCE>1.22086</SUB_DISTANCE>
                            </WAYPOINT>
                            [...]
                        </WAYPOINTS>
                        </PORT_DISTANCE>
                            
                    
All parameters must be written with lowercase letters. (See example URLs)