坐标转换-使用geotools读取和转换地理空间表的坐标系（sqlserver、postgresql）

在使用GeoTools进行坐标转换时，你可以使用AffinePlacement来转换空间表的坐标系。以下是一个简化的代码示例，展示了如何在SQL Server和PostgreSQL数据库中读取和转换坐标系：

import org.geotools.data.FeatureSource;
import org.geotools.data.postgis.PostGISDataStore;
import org.geotools.data.postgis.PostGISDataStoreFactory;
import org.geotools.data.shapefile.ShapefileDataStore;
import org.geotools.data.shapefile.ShapefileDataStoreFactory;
import org.geotools.feature.FeatureCollection;
import org.geotools.feature.FeatureIterator;
import org.geotools.geometry.jts.Reproject;
import org.geotools.referencing.CRS;
import org.opengis.feature.Feature;
import org.opengis.referencing.crs.CoordinateReferenceSystem;
 
import java.io.File;
import java.nio.charset.Charset;
import java.util.HashMap;
import java.util.Map;
 
public class CoordinateConversionExample {
 
    public void convertCoordinates(String sourceCRS, String targetCRS) throws Exception {
        // 读取数据源
        FeatureSource<FeatureType> featureSource = ...; // 获取你的数据源
        CoordinateReferenceSystem sourceCrs = CRS.decode(sourceCRS);
        CoordinateReferenceSystem targetCrs = CRS.decode(targetCRS);
 
        FeatureCollection<FeatureType> features = featureSource.getFeatures();
        FeatureIterator<FeatureType> itr = features.features();
 
        while (itr.hasNext()) {
            Feature feature = itr.next();
            // 转换坐标系
            feature.setGeometry(JTS.transform(feature.getGeometry(), targetCrs));
            // 处理转换后的要素
            // ...
        }
        itr.close();
    }
 
    public void readShapefileAndConvert(File shapefile, String targetCRS) throws Exception {
        // 读取Shapefile
        ShapefileDataStore shpDataStore = new ShapefileDataStore(shapefile.toURI().toURL());
        String typeName = shpDataStore.getTypeNames()[0];
        FeatureSource<SimpleFeatureType, SimpleFeature> featureSource = 
            dataStore.getFeatureSource(typeName);
 
        // 转换坐标系
        convertCoordinates(shpDataStore.getSchema(typeName).getCoordinateReferenceSystem(), targetCRS);
    }
 
    public void readPostGISAndConvert(String dbURL, String user, String password, String schema, String table, String targetCRS) throws Exception {
        // 读取PostGIS数据库
        Map<String, Object> params = new HashMap<>();
        params.put(PostGISDataStoreFactory.DBURL.key, dbURL);
        par