CAN Telematics and Google Maps enhance compliance and keep mobile workers safe

Posted by Duncan Ford, CTO at CAN Telematics Editor's note: Our guest blogger today is Duncan Ford, CTO at CAN Telematics in Calgary, Alberta, Canada. CAN Telematics provides Mobile Resource Management solutions to a range of industries—notably, the oil and gas industry concentrated in western Canada. See what other organizations that have gone Google have to say and learn more about how Google Maps for Business can help businesses in the transportation industry.  Oil and gas companies face an unusual set of challenges in their everyday operations as a result of having a lot of equipment, assets and people spread throughout a large territory. These companies need to track the location and status of all their drill rigs, pipelines, trucks, crews and other assets. Our company, CAN Telematics, helps oil and gas companies address these challenges with solutions that track their assets, operating status, maintenance history, financial information and more. For example, one device monitors a well pump or a generator to sense the presence of certain gases or poll for other engine data. Another, mounted in a truck, logs location, speed, acceleration and braking habits. A third provides an “SOS” button for remote workers. Some devices incorporate accelerometers to detect falls or lack of movement. The data is collected by GPS-equipped monitoring and sensing devices, then stored in the cloud. Our solution is based on Google Maps and retrieves data from Google Maps Engine, offering a familiar interface for our users as well as huge scalability. We also save our customers time and money by making information more accessible, and immediately meaningful. This video about Trakopolis shows how the sensing devices and maps work together to help companies track their assets and related data. The benefits to companies are significant, starting with cost savings. They can add their privately built roads to the public roads in Google Maps, so it’s easier for them to determine which truck is closest to a facility that needs assistance. The maps also enable more efficient routing, saving time and fuel. These companies can also earn rebates on fuel taxes by easily determining the portion of their trucks’ travel that occurs on private roads -- with a fraction of the tedious, error-prone, manual record-keeping effort formerly required.  Driver’s history plotted on Can Telematics’  Trakopolis map interface. Dispatchers can enable Geofencing capabilities to  receive alerts when certain assets enter or leave an area. Even more savings can come from tracking average speeds and driving habits: once monitoring begins, truck drivers tend to slow down and drive more carefully, so there’s a big safety benefit along with fuel and vehicle maintenance savings. Our overall goal is an easier, more efficient and cost-effective way for far-flung companies to keep track of their extremely valuable assets. As we deploy our solutions to other continents and other industries, Google Maps is the natural choice for delivering critical information to the people who need it.

Stream your data into BigQuery in real-time Posted: 18 Sep 2013 09:31 AM PDT Posted by Ju-kay Kwek, BigQuery Product Manager Today, we live in a world where businesses are generating large amounts of real-time data from web applications that serve millions of users, online sales transactions, or customer activity created by an explosion of connected devices. Being able to react quickly to changes in the data being generated is critical to remain competitive. At the same time, businesses are gathering, storing and analyzing data -- sometimes 100s of gigabytes per day -- using legacy systems that struggle to keep up. We built Google BigQuery to enable businesses to tackle this problem without having to invest in costly and complex infrastructure. And today this gets even easier with two key new features:  Real-time data streaming: you can now stream events row-by-row into BigQuery via a simple new API call. This enables you to store data as it comes in, rather than building and maintaining systems just to cache and upload in batches. The best part? The new data is available for querying instantaneously. Streaming ingestion is free for an introductory period untilJanuary 1st, 2014. After that it will be billed at a flat rate of 1 cent per 10,000 rows inserted. The existing batch-based ingestion will continue to be free. Query portions of a table: you can now query a specific subset of a table using a simple new @<t> that we call a “table decorator” in your SQL statements. Though restricted to data inserted within the last 24 hours, this capability provides significant benefits beyond just cost efficiency -- for example, in conjunction with real-time data streaming, you can now use table decorators to monitor the last 30 minutes of user activity after a new change is pushed to your application. In addition to these features, we’ve also expanded BigQuery’s window functions to include SUM and COUNT -- statistical capabilities that many customers have asked for -- as well as regular analytic functions for calculating Correlation and Standard Deviation. And to make the entire querying experience smoother, the BigQuery user interface has also received numerous productivity-enhancing updates. These include an expanding information panel when clicking on a query, as well as action buttons at the bottom of the query box to make it easier to edit, run, save, and show results. You can get details about these new capabilities and examples from our Developer Blog and in our updated product documentation.  Whether it’s for capturing streams of application event logging or real-time user behavior analysis, we can’t wait to hear how you’re using BigQuery’s new features. And we hope you’ll share with our community via the #BigQuery tag on Google+. More information about Google Apps Indonesia visit our site SADA Systems Asia