note เกี่ยวกับ GIS

convert kml to shapefile, using:
$ogr2ogr -f "ESRI Shapefile" shpBangkok.shp kmlBangkok2.kml

convert to database
ogr2ogr -f MySQL MySQL:Bangkok,user=root shpBangkok.shp -nln Bangkok -update -overwrite -lco GEOMETRY_NAME=SHAPE

ogr2ogr -f PostgreSQL PG:"host=localhost user=postgres dbname=postgis_ogr password=12345" Bangkok.shp

view information
ogrinfo MySQL:Bangkok,user=root Bangkok -so
ogrinfo -ro PG:"host=localhost user=postgres password=12345 dbname=postgis_ogr" bangkok