PHP tool to convert the KML / RGB colors

function rgbToKml($color, $aa="ff"){
$rr = substr($color, 0, 2);
$gg = substr($color, 2, 2);
$bb = substr($color, 4, 2);
return $aa.$bb.$gg.$rr;
}
function kmlToRgb($color){
$rr = substr($color, 6, 2);
$gg = substr($color, 4, 2);
$bb = substr($color, 2, 2);
return $rr.$gg.$bb;
}

KML TO PostGIS

C:\"Program Files"\FWTools2.4.7\bin\ogr2ogr -f "PostgreSQL" PG:"host=localhost user=postgres dbname=yota_db password=123456" lu_9.kml

การแปลง Shapefile เป็น KML ด้วย ogr2ogr

 shp2kml.bat
set GDAL_DATA=C:\Program Files\FWTools2.4.7\data
C:\"Program Files"\FWTools2.4.7\bin\ogr2ogr -f "KML" -s_srs "epsg:32647" -t_srs "epsg:4326" C:\nksw_index\index.kml C:\nksw_index\index.shp

Shape File to MySQL With ogr2ogr

ogr2ogr -f MySQL MySQL:my_database,user=root,password=mypassword TM_WORLD_BORDERS_SIMPL-0.1.shp -nln my_table -nlt MULTIPOLYGON -update -overwrite -lco GEOMETRY_NAME=my_polygon_column