http://www.openlayers.org/

Draw me, dear Lord;

Draw me today.

From everything else, dear Lord;

Draw me away.

O Lord, this whole world

Seems to weigh me down 

All the cares, the strife, the sin

Within me and all around.

But, Lord, I want to set my heart,

And Lord I want to stay with You,

‘Cause only when You’re near to me

Is everything ok.

Draw me, dear Lord;

Draw me today.

From everything else, dear Lord;

Draw me away.

And though everything may fall apart

Or everything go my way,

It doesn’t really matter, Lord,

As long as I gain You, today.

Create a map from a published Google Spreadsheet

we could treate the Google Spreadsheet as the database. Even if it is a lot difficult to store spatial data in to spreadsheet. at least, we can store the longlat or xy data. thay makes sense.

要说空间数据库SpatiaLite就要先讲SqLite。这几年，SqLite越来越流行。不光是因为它的速度和功能，更多的是，它满足了人们对特定功能的专项需求。就像大家很喜欢用lighttpd做web服务器一样。SQLite是一款轻型的数据库，它的设计目标是嵌入式的，而且目前已经在很多嵌入式产品中使用了它，它占用资源非常的低，在嵌入式设备中，可能只需要几百K的内存就够了。它能够支持Windows/Linux/Unix等等主流的操作系统，同时能够跟很多程序语言相结合，比如Tcl、PHP、Java等，还有ODBC接口，同样比起MySQL、PostgreSQL这两款开源世界著名的数据库管理系统来讲，它的处理速度比他们都快。同时它还支持事务处理功能等等。也有人说它象Microsoft的Access，有时候真的觉得有点象，但是事实上它们区别很大。比如SQLite支持跨平台，操作简单，能够使用很多语言直接创建数据库，而不象Access一样需要Office的支持。如果你是个很小型的应用，或者你想做嵌入式开发，没有合适的数据库系统，那么现在你可以考虑使用SQLite。目前它的最新版本是 3.2.2，它的官方网站是：http://www.sqlite.org，能在上面获得源代码和文档。同时因为数据库结构简单，系统源代码也不是很多，也适合想研究数据库系统开发的专业人士。

在SpatiaLite官网上搜到了一个SqLite和MySQL， PostgreSQL对比：

 对数据库的对比真是见仁见智，总的看来，SqLite的特性是，它的事务操作是原子，一致，孤立，并且持久的，即使在系统崩溃和电源故障之后。零配置（不需要安装和管理），实现了绝大多数SQL92标准。但是Sqlite的大小真的是无人能及。先不论这点，基于Sqlite的SpatiaLite在空间功能上可以满足用户最专项的需求。
以前老师讲长尾理论和吴国平老师讲计量地理学的时候，总是强调一点，我们在日常工作中80%的时间都在做设计一门知识或者功课20%难度的东西。我想，SpatiaLite的推出，正是基于这种考虑。首先，我承认，PostGIS+PostgreSQL功能着实强大，它结合了多个开源地理类库，最突出的一点，PostGIS可以支持地图投影变换，而SpatiaLite是不支持投影变换的。对于MySQL的spatial extension我没有用过，以前只是看到MySQL关于Spatial Extension的document，看完了document我对MySQL就已经没有了任何兴趣，在Geospatial方面， MySQL和PostGIS相比只是刚刚起步。
细读了SpatiaLite的Document，tutorial以及相关的文献。总的来看，由于捆绑了GEOS，所以对于基本的Spatial Analysis SpatiaLite可以完全胜任，这点和PostGIS很类似。只是说，SpatiaLite在地图投影的支持方面没有PostGIS那么强大，但是仔细一想，只要是WGS84的投影一般地图应用都会支持，并且这种数据投影转换的需求在实际使用中并不是很多。如果需要什么类型的投影可以使用Proj4在后台转换。SpatiaLite预留了SRID的定义，有利于使用Proj.4进行转换。同时SpatiaLite还支持数据检索，基于R-tree，这点对于地理数据这种数据量比较大的数据类型会有极快速的操作体验。
对我来说，SqLite的强大在于它的跨平台性能，和类似Access的文件管理，同时他很小，方便携带，要使用一个数据库只需要将其拷贝携带。SpatiaLite有强大的地理空间性能是大多数数据库无以匹敌的，同时可以将SptiaLite进行嵌入式开发、同时可以配合各种语言使用。
参考文献
1. PySqlite简明教程
2. http://www.phpsqlite.com.cn/
3. http://www.gaia-gis.it/spatialite-2.0/index.html
4. http://www.gaia-gis.it/spatialite-2.0/SpatiaLite2-tutorial.html#t1.2
5. http://www.gaia-gis.it/spatialite-2.0/spatialite2_sql.html
6. http://www.gaia-gis.it/spatialite-2.0/SpatiaLite-manual.html
7. http://zh.wikipedia.org/wiki/SQLite
(sqlite in C#)
9. http://blog.sina.com.cn/s/blog_49d619a301009kqj.html
10. http://lordhong.javaeye.com/blog/114055
11. http://www.diybl.com/course/4_webprogram/asp.net/netjs/2007101/75691.html
SQLite管理客户端
SQLite亦可以作为桌面数据库使用，以下为第三方SQLite的GUI软件。例如，
1. SQLite Manager, 以 火狐浏览器的扩展形式提供的SQLite客户端。
2. SQLiteSpy

by Bo Zhao. travel in St.Augustine.

亚特兰蒂斯的深蓝色，

用Ocarina吹奏着海盐和细沙，

从灯塔眺望你，

远在十六世纪的San Marcos城堡，

重读用贝壳书写着爱与恨。

那来自三重天外的光柱，

God speeds，

温暖的红色，

触在你的脸上，

赞美主——

Hallelujah!

灯塔

my shadow and the equips

先人用贝壳做的墙

reflection

to cheer me up to do my assignment…

where can I hide myself in this google world? Google Street View digs you out whereever you are.Google Street View provides panoramic 360 degree views from designated roads throughout the coverage area for Google Maps.Use of the Street View Panorama object requires support for the Flash plugin on the client’s browser.How to use this component? just follow the steps below,

1. Create a container (usually a <div> element) to hold the Street View Flash? viewer.
2. Create a GStreetviewPanorama object and place it within the container.
3. Initialize the Street View object to refer to a specific location and display an initial “point of view” (POV).
4. Handle unsupported browsers by checking for the 603 error value.

And then, google street view uses a view system named POV(Street View Points of View), which defines the placement of the camera locus for an image, but it does not define the orientation of the camera for that image. For that purpose, the GPov object literal defines three properties:

1. yaw defines the rotation angle around the camera locus in degrees relative from true north. Yaw angles are measured clockwise (90 degrees is true east).
2. pitch defines the angle variance “up” or “down” from the camera’s initial default pitch, which is often (but not always) flat horizontal. (For example, an image taken on a hill will likely exhibit a default pitch that is not horizontal.) Pitch angles are measured with negative values looking up (to -90 degrees straight up and orthogonal to the default pitch) and positive values looking down (to +90 degrees straight down and orthogonal to the default pitch).
3. zoom defines the zoom level of this view (effectively proscribing the “field of view”) with 0 being fully zoomed-out. Different Street View locations may provide higher or lower zoom levels.

By default, these values are all 0 and define a flat horizontal view directly north with the widest possible field of view.
I use Street View to display where I am. to access the streetview , goto http://plaza.ufl.edu/bo/where.htm. and here is the code below,

 var myPano = new GStreetviewPanorama(document.getElementById("pano"));
      spanishtrace = new GLatLng(29.647343, -82.341644);
      myPOV = {yaw:345,pitch:-10};
      myPano.setLocationAndPOV(spanishtrace, myPOV);
      GEvent.addListener(myPano, "error", handleNoFlash);
    }
 
    function handleNoFlash(errorCode) {
      if (errorCode == 603) {
        alert("Error: Flash doesn't appear to be supported by your browser");
        return;
      }