Is it possible to change the projection used in OSM2PO? I used the following command to generate a
SQL file which I loaded into my database:
java -jar osm2po-core-4.2.30-signed.jar prefix=at "filename.osm.pbf.pbf"
This produce the file
at_2po_4pgr.sql. I then loaded this file into my postgres database:
psql -U postgres -d routing -a -f at_2po_4pgr.sql
As this table is based on SRID:4326, I wondered if there was any way of changing it so that I can use a different projection system. The columns in the table are as follows:
id integer NOT NULL, osm_id bigint, osm_name character varying, osm_source_id bigint, osm_target_id bigint, clazz integer, flags integer, source integer, target integer, km double precision, kmh integer, cost double precision, reverse_cost double precision, x1 double precision, y1 double precision, x2 double precision, y2 double precision, geom_way geometry(LineString,4326), CONSTRAINT pkey_at_2po_4pgr PRIMARY KEY (id)
I know that I can use
ST_Transform to convertgeom_way` into a different projection but I was unsure how to update any of the other values as I presumed some were based on the initial projection.