'TO' 태그의 글 목록

postgresql 8.2 text to boolean

[DB]/[PostgreSQL] 2016. 7. 9. 20:33

'[DB] > [PostgreSQL]' 카테고리의 다른 글

Pivotal Greenplum 설치 (0)	2022.08.28
postgresql 9.4, postgis 설치하기 (0)	2015.08.06
postgresql 에서 테이블 정보 추출하기 (0)	2015.03.03
pgadmin 설치 (0)	2015.02.23
PostgreSQL과 MySQL의 차이점 (0)	2015.02.23

Posted by FeliZ_하늘..

,

csv to shp csv2shp from gps

[프로그래밍]/[GIS] 2015. 12. 19. 13:28

네비게이션의 gps 좌표를 선으로 이은 shp 파일 만들기

gps 좌표를 가지고 있는 csv 파일을 불러와서

좌표를 이용하여 shp 파일과 shx 파일을 생성한다

import com.vividsolutions.jts.geom.Coordinate;
import com.vividsolutions.jts.geom.GeometryFactory;
import com.vividsolutions.jts.geom.LineString;
import com.vividsolutions.jts.geom.MultiLineString;
import org.geotools.data.shapefile.shp.ShapeType;
import org.geotools.data.shapefile.shp.ShapefileWriter;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

/**
 * shp & shx file write from gps coordinates.
 *
 * @author Haneul, Kim
 */
public class ShpWriterTest {

private ShapefileWriter writer;

@Before
    public void setUp() throws IOException {
        File shpFile = new File("/Users/hskimsky/Downloads/shp/GPRMC.shp");
        File shxFile = new File("/Users/hskimsky/Downloads/shp/GPRMC.shx");

FileOutputStream shpFOS = new FileOutputStream(shpFile);
        FileOutputStream shxFOS = new FileOutputStream(shxFile);

this.writer = new ShapefileWriter(shpFOS.getChannel(), shxFOS.getChannel());
    }

@After
    public void close() throws IOException {
        this.writer.close();
    }

@Test
    public void shpWrite() throws IOException {
        Scanner scanner = new Scanner(new File("/Users/hskimsky/Downloads/my_gps_GPRMC.txt"));
        List<Coordinate> coords = new ArrayList<>();
        while (scanner.hasNextLine()) {
            String line = scanner.nextLine();
            String[] values = line.split(",");
            double[] xy = {Double.parseDouble(values[1]), Double.parseDouble(values[2])};
            coords.add(new Coordinate(xy[0], xy[1]));
        }

GeometryFactory gf = new GeometryFactory();
        LineString lineString = gf.createLineString(coords.toArray(new Coordinate[coords.size()]));
        MultiLineString mls = gf.createMultiLineString(new LineString[]{lineString});
        System.out.println("mls = " + mls);

this.writer.writeHeaders(mls.getEnvelopeInternal(), ShapeType.ARC, mls.getNumGeometries(), 100);
        this.writer.writeGeometry(mls);
    }
}