[Geoserver-users] Geotools (PostGIS): insert Geometry and Geography in one table by feature builder

Hi,

my problem is to find the Geotools way to perform the PostGIS function "ST_GeographyFromText".

SimpleFeatureCollection featureCollection = FeatureCollections.newCollection();
Point geom = JTSFactoryFinder.getGeometryFactory(null).createPoint(new Coordinate(longitude, latitude));

featureBuilder.add(geom);

featureBuilder.add(geog); ???

featureCollection.add(featureBuilder.buildFeature(null));

my table:

CREATE TABLE points
(
fid serial NOT NULL,

wkb_geometry geometry NOT NULL,
wkb_geography geography(PointZ,4326) NOT NULL

CONSTRAINT fid_pkey PRIMARY KEY (fid)
)

Thanks in advance,
Daniel


Daniel Tuerk, Software Architect
Phone: +49 89 45 23 47 - 214
PGP-Fingerprint: F530B24F06047CE967BE739F15DD03CB4E9E400B

jambit GmbH
Erika-Mann-Str. 63, 80636 München
Phone: +49 89 45 23 47 - 0 Fax: +49 89 45 23 47 - 70

http://www.jambit.com where innovation works

Geschäftsführer: Peter F. Fellinger, Markus Hartinger
Sitz: München; Registergericht: München, HRB 129139