[Gdal-dev] ogr2ogr more GML 3.1 compatible

[Frank Warmerdam]

On 1/27/06, Jørn Vegard Røsnes <jorn at spacetec.no> wrote:
> Sounds reasonable, may introduce some issues if element name contains
> underscore.
> Another solution is to have XML subelements as separate tables with foreign
> keys, for example:
>
> <gml:featureMember>
>                 <ais:feature>
>                         <ais:MMSI>123456</ais:MMSI>
>                         <ais:callsign>"CallMe"</ais:callsign>
>                         <ais:name>"MS Ship</ais:name>
>                         <ais:IMONumber>65432d1</ais:IMONumber>
>                         <ais:length>75.3</ais:length>
>                         <ais:beam>35.</ais:beam>
>                         <ais:wesselType>cargo</ais:wesselType>
>                         <ais:antennaLocation>aft of bow</ais:antennaLocation>
>                         <ais:draught>3.2</ais:draught>
>                         <ais:hazardousCargo>none</ais:hazardousCargo>
>                         <ais:destination>Rotterdam</ais:destination>
>                         <ais:expectedTimeOfArrival>2005-08-13T15:00:00</ais:expectedTimeOfArrival>
>                         <ais:extraInfo>none</ais:extraInfo>
>                         <ais:trackProperty>
>                                 <ais:track>
>                                         <ais:objectStatus>
>                                                 <gml:pos
> srsName="LL-WGS84">17.0 69.0</gml:pos>
>                                                 <ais:time>2005-08-13T04:37:15</ais:time>
>                                                 <ais:speedOverGround>11.</ais:speedOverGround>
>                                                 <ais:courseOverGround>17.3</ais:courseOverGround>
>                                                 <ais:heading>16.0</ais:heading>
>                                                 <ais:bearing>15.3</ais:bearing>
>                                                 <ais:rateOfTurn>2.14</ais:rateOfTurn>
>                                                 <ais:navigationalStatus>underway</ais:navigationalStatus>
>                                                 <ais:safetyMessage>none</ais:safetyMessage>
>                                                 <ais:dataSource>AIS transp.
> sys. x</ais:dataSource>
>                                         </ais:objectStatus>
>                                         <ais:objectStatus>
>                                                 <gml:pos>17.5 69.5</gml:pos>
>                                                 <ais:time>2005-08-13T04:38:00</ais:time>
>                                                 <ais:speedOverGround>11.</ais:speedOverGround>
>                                                 <ais:courseOverGround>17.3</ais:courseOverGround>
>                                         </ais:objectStatus>
>                                 </ais:track>
>                         </ais:trackProperty>
>                         <ais:time>1967-08-13T17:39:15</ais:time>
>                         <ais:dataSource>Kystverket</ais:dataSource>
>                         </ais:feature>
>         </gml:featureMember>
>
> would in PostGIS result in the following tables:
> ais:feature
> ais:trackProperty with foreign key (fk) to ais:feature
> ais:track with fk to ais:trackPropery
> ais:objectStatus with fk to ais:track

Jørn,

This is certainly the sort of complexity I *don't* want to
try and address.

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent