Skip to main content
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

  • August 15, 2022
  • 1 reply
  • 19 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

JennaKAtSafe
Safer
Forum|alt.badge.img+7

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings