如何解决PHP地理数据处理的复杂问题？使用Composer和GeoPHP可以！

composer require itamair/geophp

<?php
include_once('geoPHP.inc');

// Polygon WKT 示例
$polygon = geoPHP::load('POLYGON((1 1,5 1,5 5,1 5,1 1),(2 2,2 3,3 3,3 2,2 2))','wkt');
$area = $polygon->getArea();
$centroid = $polygon->getCentroid();
$centX = $centroid->getX();
$centY = $centroid->getY();

print "这个多边形的面积是 ".$area."，中心点坐标为 X=".$centX." 和 Y=".$centY;

// MultiPoint JSON 示例
print "<br/>";
$json = 
'{
   "type": "MultiPoint",
   "coordinates": [
       [100.0, 0.0], [101.0, 1.0]
   ]
}';

$multipoint = geoPHP::load($json, 'json');
$multipoint_points = $multipoint->getComponents();
$first_wkt = $multipoint_points[0]->out('wkt');

print "这个多点几何包含 ".$multipoint->numGeometries()." 个点。第一个点的WKT表示为 ".$first_wkt;

<?php
include_once('geoPHP.inc');
$host =     'localhost';
$database = 'phayes';
$table =    'test';
$column =   'geom';
$user =     'phayes';
$pass =     'supersecret';

$connection = pg_connect("host=$host dbname=$database user=$user password=$pass");

// 使用PostGIS的asBinary和GeomFromWKB
$result = pg_fetch_all(pg_query($connection, "SELECT asBinary($column) as geom FROM $table"));
foreach ($result as $item) {
  $wkb = pg_unescape_bytea($item['geom']); // 确保解码十六进制数据块
  $geom = geoPHP::load($wkb, 'ewkb'); // 现在我们有一个完整的geoPHP几何对象

  // 将其插入回数据库
  $insert_string = pg_escape_bytea($geom->out('ewkb'));
  pg_query($connection, "INSERT INTO $table ($column) values (GeomFromWKB('$insert_string'))");
}