水曜日, 3月 31, 2010

SQLAlchemy and update data using ORM

SQLAlchemy and update data using ORM

Insert to database

cm = Some_Object()
cm.column1 = column1_data
cm.column2 = column2_data
cm.column3 = column3_data

Session.add(cm)
Session.commit()



Update database

cs = Session.query(Some_Object).filter(and_(Some_Object.id == some_id,Some_Object.other_id == some_other_id)).one()

cs.column1 = "abc"
cs.column2 = "qwe"
cs.column3 = "asd"

Session.add(cs)
Session.commit()

木曜日, 3月 11, 2010

GDAL2Tiles + MapTiler - Map Tile Cutter

MapTiler - Map Tile Cutter


Map Overlay Generator for Google Maps and Google Earth

MapTiler is graphical interface for GDAL2Tiles utility, which is part of GDAL.

Since GDAL 1.6 is not the primary GDAL version it is only put in C:\OSGeo4W\apps\gdal-16\bin which is only in the path after you run the gdal16.bat script.

MapTiles, Pyramids, and DeepEarth
Map Tile 切图小工具

水曜日, 3月 10, 2010

GeoWebCache is a cache for WMS tiles implemented in Java

GeoWebCache is a cache for WMS tiles implemented in Java

Tiles à la Google Maps: Coordinates, Tile Bounds and Projection

Tiles à la Google Maps: Coordinates, Tile Bounds and Projection

There are three main systems of tile adressing: Google XYZ, Microsoft QuadTree and from the open-source world comming TMS (Tile Map Service).


MapTiler - Map Tile Cutter
MapTiler is graphical interface for GDAL2Tiles utility, which is part of GDAL.