Hi Brent, Yes I think it's possible, simply playing with the TARGET COLUMNS clause of the pgloader command. Would you mind opening an issue on Github, where I track bug fixes and user requests, so that our conversation is then publicly archived and available to other PostGIS and pgloader users? Thanks, -- Dimitri Fontaine dim@xxxxxxxxxxx On Fri, Jun 29, 2018, at 04:33, Brent Wood wrote: > Hi, > > > I'm looking at pgloader to automate data loading into a Postgis enabled > Postgres database. > > > I have seen in the tutorial how the internal point type is supported, > and how the postgis extension can be pre-installed by pgloader if > necessary, but I can't see how I might take x & y values & save as a > postgis point. I guess I could do this via a trigger, but that is > hopefully an unnecessary workaround. > > > if I read data in (say from CSV): > > > 1,tan0104,1,173.567,-43.678 > > ... > > > to a Postgis table: > > create table station > > (id int primary key, > > trip char(7) > > station_no int, > > lon_s decimal(7,4), > > lat_s decimal(6,4), > > startp geometry(POINT,4326)); > > > > the startp column is populated by the SQL: > > startp=ST_SetSRID(ST_MakePoint(lon_s,lat_s),4326) > > > This creates a point feature from the x (lon) & y (lat) coordinates, > > and specifies the coordinate reference system as lat/lon degrees WGS84 > (EPSG:4326) to match the column specification. > > > How can I implement that in the pgloader command to load the CSV file? > > > > Thanks > > > Brent Wood > > Programme leader: Environmental Information Delivery > NIWA > DDI: +64 (4) 3860529 > > > > Brent Wood > Principal Technician - GIS and Spatial Data Management > Programme Leader - Environmental Information Delivery > +64-4-386-0529 | 301 Evans Bay Parade, Greta Point, Wellington | > www.niwa.co.nz<http://www.niwa.co.nz> > [NIWA]<http://www.niwa.co.nz> > To ensure compliance with legal requirements and to maintain cyber > security standards, NIWA's IT systems are subject to ongoing monitoring, > activity logging and auditing. This monitoring and auditing service may > be provided by third parties. Such third parties can access information > transmitted to, processed by and stored on NIWA's IT systems. > > > > Email had 1 attachment: > + image9c19a7.JPG > 28k (image/jpeg)
