Skip to content

Instantly share code, notes, and snippets.

View pborissow's full-sized avatar

Peter B pborissow

3 followers · 1 following
View GitHub Profile
@pborissow
pborissow / JTS.md
Last active July 23, 2020 14:02
How to create PostGIS HEXEWKB formatted geometry

How to create PostGIS HEXEWKB formatted geometry

When copying geometry data into PostgreSQL using COPY FROM STDIN it is a good idea to use the PostGIS HEXEWKB format. Here's how to create HEXEWKB using Java and JTS:

import com.vividsolutions.jts.geom.*;
import com.vividsolutions.jts.io.WKBWriter;
import com.vividsolutions.jts.io.WKTReader;
import com.vividsolutions.jts.io.ByteOrderValues;