Question

I am attempting to load a GML file into PostGIS via FME and get the following error: Bulk copy failed on table 'public.physical_oceanographic_map' using delimiter ':'. Error was 'ERROR: extra data after last expected column

  • 16 August 2022
  • 1 reply
  • 4 views

Sample data from the gml file:

` <gml:featureMember>

  <nzodn:physical_oceanographic_map fid="physical_oceanographic_map.fid-4332c03c_1829f0e6782_-2349">

   <nzodn:stationName>U3693</nzodn:stationName>

   <nzodn:url>https://nzodn.nz/data/physical_oceanographic/sage/SAGE_CTD_data_U3693.txt</nzodn:url>

   <nzodn:time_coverage_start>2004-04-07T10:50:00</nzodn:time_coverage_start>

   <nzodn:time_coverage_end>2004-04-07T10:50:00</nzodn:time_coverage_end>

   <nzodn:hasTemperature>true</nzodn:hasTemperature>

   <nzodn:hasSalinity>true</nzodn:hasSalinity>

   <nzodn:hasChlorophyllFluorescence>false</nzodn:hasChlorophyllFluorescence>

   <nzodn:hasTransmissionOfLight>false</nzodn:hasTransmissionOfLight>

   <nzodn:hasFluorescence>false</nzodn:hasFluorescence>

   <nzodn:hasPressure>true</nzodn:hasPressure>

   <nzodn:hasDissolvedOxygen>true</nzodn:hasDissolvedOxygen>

   <nzodn:hasComment>false</nzodn:hasComment>

   <nzodn:geom>

    <gml:Point srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">

     <gml:coordinates xmlns:gml="http://www.opengis.net/gml" decimal="." cs="," ts=" ">172.693333,-46.236333</gml:coordinates>

    </gml:Point>

   </nzodn:geom>

  </nzodn:physical_oceanographic_map>

 </gml:featureMember>

 <gml:featureMember>

  <nzodn:physical_oceanographic_map fid="physical_oceanographic_map.fid-4332c03c_1829f0e6782_-2348">

   <nzodn:stationName>U3691</nzodn:stationName>

   <nzodn:url>https://nzodn.nz/data/physical_oceanographic/sage/SAGE_CTD_data_U3691.txt</nzodn:url>

   <nzodn:time_coverage_start>2004-04-07T08:58:00</nzodn:time_coverage_start>

   <nzodn:time_coverage_end>2004-04-07T08:58:00</nzodn:time_coverage_end>

   <nzodn:hasTemperature>true</nzodn:hasTemperature>

   <nzodn:hasSalinity>true</nzodn:hasSalinity>

   <nzodn:hasChlorophyllFluorescence>false</nzodn:hasChlorophyllFluorescence>

   <nzodn:hasTransmissionOfLight>false</nzodn:hasTransmissionOfLight>

   <nzodn:hasFluorescence>false</nzodn:hasFluorescence>

   <nzodn:hasPressure>true</nzodn:hasPressure>

   <nzodn:hasDissolvedOxygen>true</nzodn:hasDissolvedOxygen>

   <nzodn:hasComment>false</nzodn:hasComment>

   <nzodn:geom>

    <gml:Point srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">

     <gml:coordinates xmlns:gml="http://www.opengis.net/gml" decimal="." cs="," ts=" ">172.695667,-46.235</gml:coordinates>

    </gml:Point>

   </nzodn:geom>

  </nzodn:physical_oceanographic_map>

 </gml:featureMember>

'​


1 reply

Badge +6

Hi @byroncinnz​ it sounds like your GML may have some syntax errors. How are you reading in your GML? Would you be able to share a sample workspace?

Reply