Mineral resources

Perm. Mineral resources owerview.

Google LatLong: How big is the Deepwater Horizon oil spill?

Google LatLong: How big is the Deepwater Horizon oil spill?

Crude oil from the Deepwater Horizon oil rig explosion continues to leak into the Gulf Coast. Official estimates state a rate of 200,000 gallons a day, while some private estimates think it could be over a million gallons each day. The spill covers an area of over 2,500 square miles, and shows no signs of slowing down.

Natural gas

Datapult in actions http://www.datapult.info/content/natural-gas



Natural gas
Industrial Commodity Statistics Database
Source: United Nations Statistics Division
The United Nations Industrial Commodity Statistics Database provides annual statistics on the production of major industrial commodities by country. Data are provided in terms of physical quantities as well as monetary value. The online database covers the years 1995 to 2007. Additional historical data is available on request, based on a different product list, for the years 1950-2003.
Last update in UNdata: 23 Feb 2010
Next update in UNdata: Feb 2011
Gases consisting mainly of methane occurring naturally in underground deposits. It includes both non-associated gas (originating from fields producing only hydrocarbons in gaseous form) and associated gas (originating from fields producing both liquid and gaseous hydrocarbons), as well as methane recovered from coal mines and sewage gas. Production of natural gas refers to dry marketable production, measured after purification and extraction of natural gas liquids and sulphur. Extraction losses and the amounts that have been reinjected, flared, and vented are excluded from the data on production.

Scripts in Google spreadsheets

Recently became available scripts in Google Spreadsheets for personal accounts (gmail).

http://googledocs.blogspot.com/2010/03/apps-script-gallery-for-google.html

Abstract

http://www.google.com/google-d-s/scripts/scripts.html

In addition, we can publish scripts in the gallery.
Now we can create scripts for Google Spreadsheets, upload, post, communicate with other users.

Scripts have a rich set of features. We can use all the management services available in Google.

http://www.google.com/google-d-s/scripts/overview.html

The result of the script, for example, may be:

• new function;
• value returned by the Web service, including, SOAP, WSDL, and others;
• management of other services, such as website, calendar, mailing;
• automatic filling of tables (direct control of our spreadsheets);
• creation of user interfaces (custom spreadsheets UI).

Examples of scripts in neogeography

Great Circle Distance between points

Copy Source | Copy HTML

1. function GCD1(lat1, lon1, lat2, lon2) {
2. // Return Great Circle Distance between points calculation
3. function radians(a) {
4. var outNum =Math.PI*a/180;
5. return outNum;
6. }
8. var R = 6372.795;
9. var d1=Math.sin(radians(lat1))*Math.sin(radians(lat2))+Math.cos(radians(lat1))*Math.cos(radians(lat2))*Math.cos(radians(lon2)-radians(lon1));
10. var d2=Math.cos(radians(lat2))*Math.sin(radians(lon2)-radians(lon1));
11. var d3=Math.cos(radians(lat1))*Math.sin(radians(lat2))-Math.sin(radians(lat1))*Math.cos(radians(lat2))*Math.cos(radians(lon2)-radians(lon1));
12. var len=R*Math.atan2(Math.sqrt(d2*d2+d3*d3),d1);
13. return len;
14. }​

Geocoding

Return KML by placename

Copy Source | Copy HTML

1. function getKML(placeName) {
2. // Return KML by placename
3. if (placeName == "") {
4. return "You have to write the name the place"
5. }
6. var url = "http://maps.google.com/maps/geo?q="+ placeName+"&output=kml";
7. var response = UrlFetchApp.fetch(url);
8. var str = response.getContentText();
9. return str;
10. }

Return Longitude and Latitude by placename

1. function getLngLat(placeName) {
2. // Return LngLatitude by placename
3. if (placeName == "") {
4. return "You have to write the name the place"
5. }
6. var url = "http://maps.google.com/maps/geo?q="+ placeName+"&output=json";
7. var response = UrlFetchApp.fetch(url);
8. var str=eval('(' + response.getContentText() + ')').Placemark[ 0].Point.coordinates;
9. return str;
10. }

Return Longitude by placename

1. function getLng(placeName) {
2. // Return Longitude by placename
3. if (placeName == "") {
4. return "You have to write the name the place"
5. }
6. var url = "http://maps.google.com/maps/geo?q="+ placeName+"&output=json";
7. var response = UrlFetchApp.fetch(url);
8. var str=eval('(' + response.getContentText() + ')').Placemark[ 0].Point.coordinates[ 0];
9. return str;
10. }

Return Latitude by placename

1. function getLat(placeName) {
2. // Return Latitude by placename
3. if (placeName == "") {
4. return "You have to write the name the place"
5. }
6. var url = "http://maps.google.com/maps/geo?q="+ placeName+"&output=json";
7. var response = UrlFetchApp.fetch(url);
8. var str=eval('(' + response.getContentText() + ')').Placemark[ 0].Point.coordinates[1];
9. return str;
10. }

Reverse geocoding

Return address by placename

1. function getAddress(placeCoord) {
2. // Return Address by placeCoord (reverse geocoding) placeCoord=lat,lng
3. if (placeCoord == "") {
4. return "You have to write the name the place"
5. }
6. var url = "http://maps.google.com/maps/geo?q="+ placeCoord+"&output=json";
7. var response = UrlFetchApp.fetch(url);
8. var str=eval('(' + response.getContentText() + ')').Placemark[ 0].address;
9. return str;
10. }

Example

My QR codes

My geolocation
My email


My phone number


Contact information

Create slideshow with Picnik

"Picnik Show"

Create a free slideshow with Picnik!