README

快速开始

在此下载OSM XML文件 https://download.bbbike.org/

示例 1

将OSM转换为SQL文件

1. 从文件创建数据库表 resources/mysql.sql

2. 将OSM转换为SQL插入语句

    ini_set('memory_limit', '10M');
    // This class read big osm file
    $largeXmlReader = new LargeXmlReader();
    $largeXmlReader->setFilePath('/path/to/very/big/osm/xml/file.osm');
    
    // This class listens reader class and write data into file
    $listener = new FileReaderListener('/path/to/new/sql/file.sql');
    
    // Insert 500 rows in one operation
    $listener->setInsertSize(500);
    // Use INSERT IGNORE ...
    $listener->setInsertIgnore(true);
    $largeXmlReader->setListener($listener);
    $largeXmlReader->setProgressListener(function($readSize, $totalSize) use ($progress) {
        echo 'Completed ' . $readSize . ' Mb of ' . $totalSize . " Mb\n";
    });
    // Start parsing
    $largeXmlReader->parse();
   

3. 将sql文件导入到数据库

    mysql -u username -p database_name < /path/to/new/sql/file.sql
   

示例 2

您可以创建自己的ReaderListener并将数据直接写入数据库

class DbReaderListener extends AbstractReaderListener
{
    // ...
    protected function write($table, $sql)
    {
        $this->myDbConnection->query($sql);
    }
}

// ...
$largeXmlReader->setListener(new DbReaderListener());
// ...

示例 3

直接写入数据库并计算建筑物、公路、地点表

ini_set('memory_limit', '100M');

include 'vendor/autoload.php';

$file = '/path/to/very/big/osm/xml/file.osm';

// This class read big osm file
$largeXmlReader = new \osm2sql\LargeXmlReader();

// This class listens reader class and write data into database
$listener = new \osm2sql\mysql\PdoDbBuilder('mysql:host=localhost;dbname=osm;port=3306', 'user', 'password');
// Insert 100 rows in one operation
$listener->setInsertSize(100);
// Use INSERT IGNORE ...
$listener->setInsertIgnore(true);
$listener->setProgressListener(function ($size, $total) {
    echo 'Update DB ' . $size . ' row of ' . $total . " rows\n";
});
$listener->setExceptionListener(function($e, $sqlStr) {
    echo $sqlStr . "\n";
    echo $e . "\n";
});
// Delete all relations, way, node in database
$listener->deleteRelation();
$listener->deleteWay();
$listener->deleteNode();

$largeXmlReader->setFilePath($file);
$largeXmlReader->setListener($listener);
$largeXmlReader->setProgressListener(function($readSize, $totalSize) {
    echo  'Read file ' . $readSize . ' Mb of ' . $totalSize . " Mb\n";
});
// Insert new relations, way, node from osm file to database
$largeXmlReader->parse();

// Clear and calculate highway, building, place
$listener->deleteHighway();
$listener->calculateHighway();
$listener->deleteBuilding();
$listener->calculateBuilding();
$listener->deletePlace();
$listener->calculatePlace();

echo 'Done';

您可以创建自己的DbBuilder类并在框架中使用数据库连接

class MyDbBuilder extends \osm2sql\mysql\AbstractDbBuilder
{
    // ...
    protected function querySelect($sqlStr)
    {
        $rows = $this->myDbConnection->query($sqlStr);
        $r = [];
        foreach ($rows as $row) {
            $r[] = (array) $row;
        }
        return $r;
    }

    protected function queryUpdate($sqlStr)
    {
        return (int) $this->myDbConnection->exec($sqlStr);
    }
}