[Volute] r4880 - trunk/projects/time-domain/time-series/note

Volute commit messages volutecommits at g-vo.org
Tue Apr 3 23:58:21 CEST 2018


Author: francois
Date: Tue Apr  3 23:58:21 2018
New Revision: 4880

Log:
new examples in full utype section and fixes in corresponding appendix

Modified:
   trunk/projects/time-domain/time-series/note/TSSerializationNote.pdf
   trunk/projects/time-domain/time-series/note/appendixFrancois.tex
   trunk/projects/time-domain/time-series/note/francois.tex

Modified: trunk/projects/time-domain/time-series/note/TSSerializationNote.pdf
==============================================================================
Binary file (source and/or target). No diff available.

Modified: trunk/projects/time-domain/time-series/note/appendixFrancois.tex
==============================================================================
--- trunk/projects/time-domain/time-series/note/appendixFrancois.tex	Tue Apr  3 18:05:35 2018	(r4879)
+++ trunk/projects/time-domain/time-series/note/appendixFrancois.tex	Tue Apr  3 23:58:21 2018	(r4880)
@@ -1,345 +1,324 @@
 \section{VODataservice tabular mapping of TimeSeries}
+\begin{small}
 \begin{lstlisting}[language=XML, caption= TAP schema in xml]                                                                               
 
 <?xml version="1.0" encoding="UTF-8"?>
 <vosi:tableset xmlns:vosi="http://www.ivoa.net/xml/VOSITables/v1.0" xmlns:vod="http://www.ivoa.net/xml/VODataService/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ivoa.net/xml/VODataService/v1.1 http://www.ivoa.net/xml/VODataService/v1.1 http://www.ivoa.net/xml/VOSITables/v1.0 http://vo.ari.uni-heidelberg.de/docs/schemata/VOSITables-v1.0.xsd">
-	<schema>
-		<name>VizieRSimpleTimeSeries</name>
-		<description>TimeSeries model schema restriction to Sipmlle Vizer case</description>
-		<table type="output">
-			<name>TimleSeries</name>
-			<description>instances of Entity class</description>
-			<column>
-				<name>productType</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-			
-				<utype>ts:TimeSeries.dataProductType</utype>  
-			</column>
-			<column>
-				<name>calibLevel</name>
-				<dataType xsi:type="vod:TAPType">INTEGER</dataType>
-				
-				<utype>ts:TimeSeries.calibLevel</utype> 
-			</column>
-			<column>
-				<name>pubDID</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-			
-				<utype>ts:Observation.observationID</utype> 
-			</column>
-			<column>
-				<name>creator</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				
-				<utype>ts:TimeSeries.DataID.creatorDID</utype>  
-			</column>
-			<column>
-				<name>contributor</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				
-				<utype>ts:TimeSeries.DataID.contributor</utype>
-			</column>
-			<column>
-				<name>Target</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-			
-				<utype>ts:Observation.Target.name</utype>
-			</column>
-
-			<foreignKey>
-				<targetTable>characterisation</targetTable>
-				<fkColumn>
-					<fromColumn>pubDID</fromColumn>
-					<targetColumn>pubDID</targetColumn>
-				</fkColumn>
-			</foreignKey>
-			<foreignKey>
-				<targetTable>coordsys</targetTable>
-				<fkColumn>
-					<fromColumn>pubDID</fromColumn>
-					<targetColumn>pubDID</targetColumn>
-				</fkColumn>
-			</foreignKey>
-			<foreignKey>
-				<targetTable>TimeSeriesData</targetTable>
-				<fkColumn>
-					<fromColumn>pubDID</fromColumn>
-					<targetColumn>pubDID</targetColumn>
-				</fkColumn>
-			</foreignKey>
-		</table>
-		<table type="output">
-			<name>characterisation</name>
-			<description>instances of Entity Description class</description>
-			<column>
-				<name>pubDID</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-			
-				<utype>ts:Observation.observationID</utype> 
-			</column>
-			<column>
-				<name>SpatLocationRA</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>pos.eq.ra</ucd>
-				<utype>cha:Char.SpatialAxis.Location.Coord.SpatialValue2D[0]</utype>  
-			</column>
-			<column>
-				<name>SpatLocationDec</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>pos.eq.dec</ucd>
-				<utype>cha:Char.SpatialAxis.Location.Coord.SpatialValue2D[1]</utype> 
-			</column>
-			<column>
-				<name>SpatBoundsSizeRA</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>pos.eq.ra;stat.length</ucd>
-				<utype>cha:Char.SpatialAxis.Bounds.CharBox.Size2[0]</utype>  
-			</column>
-			<column>
-				<name>SpatBoundsSizeDEC</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>pos.eq.dec;stat.length</ucd>
-				<utype>cha:Char.SpatialAxis.Bounds.CharBox.Size2[1]</utype>
-			</column>
-		        <column>
-                                <name>t_min</name>
-                                <ucd>time.start</ucd>
-                                <unit>d</unit>
-                                <utype>ts:Char.TimeAxis.Coverage.bounds.StartTime</utype>
-                                <dataType xsi:type="vod:TAPType">REAL</dataType>
-                       </column>
-		       <column>
-                                <name>t_max</name>
-                                <ucd>time.stop</ucd>
-                                <unit>d</unit>
-                                <utype>ts:Char.TimeAxis.Coverage.bounds.StopTime</utype>
-                                <dataType xsi:type="vod:TAPType">REAL</dataType>
-                       </column>
-                       <column>
-                                <name>t_mean</name>
-                                <ucd>time</ucd>
-                                <unit>d</unit>
-                                <utype>ts:Char.TimeAxis.Coverage.location.TimeInstant</utype>
-                                <dataType xsi:type="vod:TAPType">REAL</dataType>
-                       </column>
-                       <column>
-                                <name>t_exp_time</name>
-                                <ucd>time.duration</ucd>
-                                <unit>d</unit>
-                                <utype>ts:Char.TimeAxis.Coverage.supportExtent</utype>
-                                <dataType xsi:type="vod:TAPType">REAL</dataType>
-                       </column>
-                       <column>
-                                <name>t_resolution</name>
-                                <ucd>time.resolution</ucd>
-                                <unit>d</unit>
-                                <utype>ts:Char.TimeAxis.resolutionRefVal</utype>
-                                <dataType xsi:type="vod:TAPType">REAL</dataType>
-                       </column>
-                       <column>
-                                <name>delta_t_min</name>
-                                <ucd>time</ucd>
-                                <unit>d</unit>
-                                <utype>ts:Char.TimeAxis.sampling.bounds.SamplingPrecision.TimeStart</utype>
-                                <dataType xsi:type="vod:TAPType">REAL</dataType>
-                       </column>
-                       <column>
-                                <name>delta_t_max</name>
-                                <ucd>time</ucd>
-                                <unit>d</unit>
-                                <utype>ts:Char.TimeAxis.sampling.bounds.SamplingPrecision.TimeStop</utype>
-                                <dataType xsi:type="vod:TAPType">REAL</dataType>
-                       </column>
-                       <column>
-                                <name>em_min</name>
-                                <ucd>em.wl;stat.min</ucd>
-                                <unit>d</unit>
-                                <utype>ts:Char.TimeAxis.Coverage.bounds.Limits.LoLimit</utype>
-                                <dataType xsi:type="vod:TAPType">REAL</dataType>
-                       </column>
-                       <column>
-                                <name>em_max</name>
-                                <ucd>em.wl;stat.max</ucd>
-                                <unit>d</unit>
-                                <utype>ts:Char.TimeAxis.Coverage.bounds.Limits.HiLimit</utype>
-                                <dataType xsi:type="vod:TAPType">REAL</dataType>
-                       </column>
-		</table>
-		<table type="output">
-			<name>coordsys</name>
-			<description>instances of Coordinate systems and Photometry filter </description>
-                        <column>
-				<name>pubDID</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-			
-				<utype>ts:Observation.observationID</utype> 
-			</column> 
-			<column>
-				<name>TimeScale</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				<ucd>time.scale</ucd>
-				<utype>coord:coordsys.TimeFrame.TimeScale</utype>  
-			</column>
-			<column>
-				<name>refpositionT</name>
-				<dataType xsi:type="vod:TAPType" arraysize="2">DOUBLE</dataType>
-				<ucd>pos.eq</ucd>
-				<utype>coord:coordsys.TimeFrame.refPosition</utype> 
-			</column>
-
-			<column>
-				<name>SpaceRefFrame</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				<ucd>pos.frame</ucd>
-				<utype>coord:coordsys.SpaceFrame.spaceRefFrame</utype>  
-			</column>
-			<column>
-				<name>refPositionS</name>
-				<dataType xsi:type="vod:TAPType" arraysize="2">DOUBLE</dataType>
-				<ucd>pos.eq</ucd>
-				<utype>coord:coordsys.SpaceFrame.refPosition</utype>  
-			</column>
-			<column>
-				<name>wavelength1</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>em.wl</ucd>
-				<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
-			</column>
-			<column>
-				<name>filter1</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				<ucd>instr.filter</ucd>
-				<utype>photdm:PhotometryFilter.identifier</utype> 
-			</column>
-		
-			<column>
-				<name>wavelength2</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>em.wl</ucd>
-				<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
-			</column>
-			<column>
-				<name>filter2</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				<ucd>instr.filter</ucd>
-				<utype>photdm:PhotometryFilter.identifier</utype> 
-			</column>
-					<column>
-				<name>wavelength3</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>em.wl</ucd>
-				<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
-			</column>
-			<column>
-				<name>filter3</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				<ucd>instr.filter</ucd>
-				<utype>photdm:PhotometryFilter.identifier</utype> 
-			</column>
-					<column>
-				<name>wavelength4</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>em.wl</ucd>
-				<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
-			</column>
-			<column>
-				<name>filter4</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				<ucd>instr.filter</ucd>
-				<utype>photdm:PhotometryFilter.identifier</utype> 
-			</column>
-					<column>
-				<name>wavelength5</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>em.wl</ucd>
-				<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
-			</column>
-			<column>
-				<name>filter5</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				<ucd>instr.filter</ucd>
-				<utype>photdm:PhotometryFilter.identifier</utype> 
-			</column>
-
-			
-		</table>
-		<table type="output">
-			<name>coordsys</name>
-			<description>instances of Coordinate systems and Photometry filter </description>
-                        <column>
-				<name>pubDID</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-			
-				<utype>ts:Observation.observationID</utype> 
-			</column> 
-			<column>
-				<name>TimeScale</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				<ucd>time.scale</ucd>
-				<utype>coord:coordsys.TimeFrame.TimeScale</utype>  
-			</column>
-			<column>
-				<name>refpositionT</name>
-				<dataType xsi:type="vod:TAPType" arraysize="2">DOUBLE</dataType>
-				<ucd>pos.eq</ucd>
-				<utype>coord:coordsys.TimeFrame.refPosition</utype> 
-			</column>
-
-			<column>
-				<name>SpaceRefFrame</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				<ucd>pos.frame</ucd>
-				<utype>coord:coordsys.SpaceFrame.spaceRefFrame</utype>  
-			</column>
-			<column>
-				<name>refPositionS</name>
-				<dataType xsi:type="vod:TAPType" arraysize="2">DOUBLE</dataType>
-				<ucd>pos.eq</ucd>
-				<utype>coord:coordsys.SpaceFrame.refPosition</utype>  
-			</column>
-			<column>
-				<name>wavelength</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>em.wl</ucd>
-				<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
-			</column>
-			<column>
-				<name>filter</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-				<ucd>instr.filter</ucd>
-				<utype>photdm:PhotometryFilter.identifier</utype> 
-			</column>
-		
-
-		</table>
-		<table type="output">
-
-			<name>TimeSeriesData</name>
-			<description>instanceof TimeSeries Data Class</description>
-			<column>
-				<name>pubDID</name>
-				<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
-			
-				<utype>ts:Observation.observationID</utype> 
-			</column>
-
-			<column>
-				<name>JD</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>time;obs.exposure</ucd>
-				<utype>ts:TimeSeriesData.NDPoint.TimeObservable.TimeMeasure.MJD</utype>  
-			</column>
-			<column>
-				<name>MAGV</name>
-				<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
-				<ucd>phot.flux</ucd>
-				<utype>ts:TimeSeriesData.NDPoint.dependantObservedObject.CoordMeasure.PhotometryPoint</utype> 
-			</column>
-
-			
-		</table>
-
-	</schema>
+<schema>
+	<name>VizieRSimpleTimeSeries</name>
+	<description>TimeSeries model schema restriction to Sipmlle Vizer case</description>
+	<table type="output">
+		<name>TimleSeries</name>
+		<description>instances of Entity class</description>
+		<column>
+			<name>productType</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<utype>ts:TimeSeries.dataProductType</utype>  
+		</column>
+		<column>
+			<name>calibLevel</name>
+			<dataType xsi:type="vod:TAPType">INTEGER</dataType>
+			<utype>ts:TimeSeries.calibLevel</utype> 
+		</column>
+		<column>
+			<name>pubDID</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<utype>ts:Observation.observationID</utype> 
+		</column>
+		<column>
+			<name>creator</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<utype>ts:TimeSeries.DataID.creatorDID</utype>  
+		</column>
+		<column>
+			<name>contributor</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<utype>ts:TimeSeries.DataID.contributor</utype>
+		</column>
+		<column>
+			<name>Target</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<utype>ts:Observation.Target.name</utype>
+		</column>
+		<foreignKey>
+			<targetTable>characterisation</targetTable>
+			<fkColumn>
+				<fromColumn>pubDID</fromColumn>
+				<targetColumn>pubDID</targetColumn>
+			</fkColumn>
+		</foreignKey>
+		<foreignKey>
+			<targetTable>coordsys</targetTable>
+			<fkColumn>
+				<fromColumn>pubDID</fromColumn>
+				<targetColumn>pubDID</targetColumn>
+			</fkColumn>
+		</foreignKey>
+		<foreignKey>
+			<targetTable>TimeSeriesData</targetTable>
+			<fkColumn>
+				<fromColumn>pubDID</fromColumn>
+				<targetColumn>pubDID</targetColumn>
+			</fkColumn>
+		</foreignKey>
+	</table>
+	<table type="output">
+		<name>characterisation</name>
+		<description>instances of Entity Description class</description>
+		<column>
+			<name>pubDID</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<utype>ts:Observation.observationID</utype> 
+		</column>
+		<column>
+			<name>SpatLocationRA</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>pos.eq.ra</ucd>
+			<utype>cha:Char.SpatialAxis.Location.Coord.SpatialValue2D[0]</utype>  
+		</column>
+		<column>
+			<name>SpatLocationDec</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>pos.eq.dec</ucd>
+			<utype>cha:Char.SpatialAxis.Location.Coord.SpatialValue2D[1]</utype> 
+		</column>
+		<column>
+			<name>SpatBoundsSizeRA</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>pos.eq.ra;stat.length</ucd>
+			<utype>cha:Char.SpatialAxis.Bounds.CharBox.Size2[0]</utype>  
+		</column>
+		<column>
+			<name>SpatBoundsSizeDEC</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>pos.eq.dec;stat.length</ucd>
+			<utype>cha:Char.SpatialAxis.Bounds.CharBox.Size2[1]</utype>
+		</column>
+		<column>
+                       <name>t_min</name>
+                       <ucd>time.start</ucd>
+                       <unit>d</unit>
+                       <utype>ts:Char.TimeAxis.Coverage.bounds.StartTime</utype>
+                       <dataType xsi:type="vod:TAPType">REAL</dataType>
+                </column>
+		<column>
+                      <name>t_max</name>
+                      <ucd>time.stop</ucd>
+                      <unit>d</unit>
+                      <utype>ts:Char.TimeAxis.Coverage.bounds.StopTime</utype>
+                      <dataType xsi:type="vod:TAPType">REAL</dataType>
+               </column>
+               <column>
+                      <name>t_mean</name>
+                      <ucd>time</ucd>
+                      <unit>d</unit>
+                      <utype>ts:Char.TimeAxis.Coverage.location.TimeInstant</utype>
+                     <dataType xsi:type="vod:TAPType">REAL</dataType>
+               </column>
+               <column>
+                      <name>t_exp_time</name>
+                      <ucd>time.duration</ucd>
+                      <unit>d</unit>
+                      <utype>ts:Char.TimeAxis.Coverage.supportExtent</utype>
+                      <dataType xsi:type="vod:TAPType">REAL</dataType>
+                </column>
+                <column>
+                      <name>t_resolution</name>
+                      <ucd>time.resolution</ucd>
+                      <unit>d</unit>
+                      <utype>ts:Char.TimeAxis.resolutionRefVal</utype>
+                      <dataType xsi:type="vod:TAPType">REAL</dataType>
+                </column>
+                <column>
+                      <name>delta_t_min</name>
+                      <ucd>time</ucd>
+                      <unit>d</unit>
+                      <utype>ts:Char.TimeAxis.sampling.bounds.SamplingPrecision.TimeStart</utype>
+                      <dataType xsi:type="vod:TAPType">REAL</dataType>
+                </column>
+                <column>
+                      <name>delta_t_max</name>
+                      <ucd>time</ucd>
+                      <unit>d</unit>
+                      <utype>ts:Char.TimeAxis.sampling.bounds.SamplingPrecision.TimeStop</utype>
+                      <dataType xsi:type="vod:TAPType">REAL</dataType>
+                </column>
+                <column>
+                      <name>em_min</name>
+                      <ucd>em.wl;stat.min</ucd>
+                      <unit>d</unit>
+                      <utype>ts:Char.TimeAxis.Coverage.bounds.Limits.LoLimit</utype>
+                      <dataType xsi:type="vod:TAPType">REAL</dataType>
+                </column>
+                <column>
+                      <name>em_max</name>
+                      <ucd>em.wl;stat.max</ucd>
+                      <unit>d</unit>
+                      <utype>ts:Char.TimeAxis.Coverage.bounds.Limits.HiLimit</utype>
+                      <dataType xsi:type="vod:TAPType">REAL</dataType>
+                </column>
+	</table>
+	<table type="output">
+		<name>coordsys</name>
+		<description>instances of Coordinate systems and Photometry filter </description>
+                <column>
+			<name>pubDID</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<utype>ts:Observation.observationID</utype> 
+		</column> 
+		<column>
+			<name>TimeScale</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<ucd>time.scale</ucd>
+			<utype>coord:coordsys.TimeFrame.TimeScale</utype>  
+		</column>
+		<column>
+			<name>refpositionT</name>
+			<dataType xsi:type="vod:TAPType" arraysize="2">DOUBLE</dataType>
+			<ucd>pos.eq</ucd>
+			<utype>coord:coordsys.TimeFrame.refPosition</utype> 
+		</column>
+		<column>
+			<name>SpaceRefFrame</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<ucd>pos.frame</ucd>
+			<utype>coord:coordsys.SpaceFrame.spaceRefFrame</utype>  
+		</column>
+		<column>
+			<name>refPositionS</name>
+			<dataType xsi:type="vod:TAPType" arraysize="2">DOUBLE</dataType>
+			<ucd>pos.eq</ucd>
+			<utype>coord:coordsys.SpaceFrame.refPosition</utype>  
+		</column>
+		<column>
+			<name>wavelength1</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>em.wl</ucd>
+			<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
+		</column>
+		<column>
+			<name>filter1</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<ucd>instr.filter</ucd>
+			<utype>photdm:PhotometryFilter.identifier</utype> 
+		</column>
+		<column>
+			<name>wavelength2</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>em.wl</ucd>
+			<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
+		</column>
+		<column>
+			<name>filter2</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<ucd>instr.filter</ucd>
+			<utype>photdm:PhotometryFilter.identifier</utype> 
+		</column>
+		<column>
+			<name>wavelength3</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>em.wl</ucd>
+			<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
+		</column>
+		<column>
+			<name>filter3</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<ucd>instr.filter</ucd>
+			<utype>photdm:PhotometryFilter.identifier</utype> 
+		</column>
+		<column>
+			<name>wavelength4</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>em.wl</ucd>
+			<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
+		</column>
+		<column>
+			<name>filter4</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<ucd>instr.filter</ucd>
+			<utype>photdm:PhotometryFilter.identifier</utype> 
+		</column>
+		<column>
+			<name>wavelength5</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>em.wl</ucd>
+			<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
+		</column>
+		<column>
+			<name>filter5</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<ucd>instr.filter</ucd>
+			<utype>photdm:PhotometryFilter.identifier</utype> 
+		</column>
+	</table>
+	<table type="output">
+		<name>coordsys</name>
+		<description>instances of Coordinate systems and Photometry filter </description>
+                <column>
+			<name>pubDID</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<utype>ts:Observation.observationID</utype> 
+		</column> 
+		<column>
+			<name>TimeScale</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<ucd>time.scale</ucd>
+			<utype>coord:coordsys.TimeFrame.TimeScale</utype>  
+		</column>
+		<column>
+			<name>refpositionT</name>
+			<dataType xsi:type="vod:TAPType" arraysize="2">DOUBLE</dataType>
+			<ucd>pos.eq</ucd>
+			<utype>coord:coordsys.TimeFrame.refPosition</utype> 
+		</column>
+		<column>
+			<name>SpaceRefFrame</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<ucd>pos.frame</ucd>
+			<utype>coord:coordsys.SpaceFrame.spaceRefFrame</utype>  
+		</column>
+		<column>
+			<name>refPositionS</name>
+			<dataType xsi:type="vod:TAPType" arraysize="2">DOUBLE</dataType>
+			<ucd>pos.eq</ucd>
+			<utype>coord:coordsys.SpaceFrame.refPosition</utype>  
+		</column>
+		<column>
+			<name>wavelength</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>em.wl</ucd>
+			<utype>photdm:PhotometryFilter.SpectralAxis.Coverage.Location.Value</utype>
+		</column>
+		<column>
+			<name>filter</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<ucd>instr.filter</ucd>
+			<utype>photdm:PhotometryFilter.identifier</utype> 
+		</column>
+	</table>
+	<table type="output">
+		<name>TimeSeriesData</name>
+		<description>instanceof TimeSeries Data Class</description>
+		<column>
+			<name>pubDID</name>
+			<dataType xsi:type="vod:TAPType">VARCHAR</dataType>
+			<utype>ts:Observation.observationID</utype> 
+		</column>
+		<column>
+			<name>JD</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>time;obs.exposure</ucd>
+			<utype>ts:TimeSeriesData.NDPoint.TimeObservable.TimeMeasure.MJD</utype>  
+		</column>
+		<column>
+			<name>MAGV</name>
+			<dataType xsi:type="vod:TAPType">DOUBLE</dataType>
+			<ucd>phot.flux</ucd>
+			<utype>ts:TimeSeriesData.NDPoint.dependantObservedObject.CoordMeasure.PhotometryPoint</utype> 
+		</column>
+	</table>
+</schema>
 </vosi:tableset>
 \end{lstlisting}
+\end{small}
 

Modified: trunk/projects/time-domain/time-series/note/francois.tex
==============================================================================
--- trunk/projects/time-domain/time-series/note/francois.tex	Tue Apr  3 18:05:35 2018	(r4879)
+++ trunk/projects/time-domain/time-series/note/francois.tex	Tue Apr  3 23:58:21 2018	(r4880)
@@ -3,22 +3,40 @@
 In this approach, a relational view of the TimeSeries described above is provided. Hierarchies of classes showing 1 to 1 relationships are grouped in one single table. Table x shows the list of tables used to map the model with the full set of their columns metadata ( utype, datatype, ucd, unit and xtype).
 The VODataservice "table" representation of this set of tables is given in Appendix. 
 
-The structure is made of 4 "tables" number which seems to be a compromise to separate very differents groups of classes without have too much of them.
+The structure is made of 4 "tables" number which seems to be a compromise to separate very differents groups of classes without havng too much of them.
 
 The main "table" is the data table where the actual values of the independant variable (Time stamps) and of the "one to many" varying variables are stored.
 
-The three other tablesi, which we can call "generic TimeSeries metedata" tables gathers respectively
+The three other tables, which we can call "generic TimeSeries metadata" tables gathers respectively :
 
 \begin{itemize}
-\item Dataset, curation and dataid classes attributes. this is directly derived from similar concepts in ObsCore and Dataset metadata model. 
+\item Dataset, curation and dataid classes attributes. This is directly derived from similar concepts in ObsCore and Dataset metadata model. 
 \item Characterization describes where and how the the dataset is situated in the physical parameter space; most of the columns there should be redondant with what is in Obscore Char.
 \item Coordsys table. This table mainly serializes stc and gathers the coordinate frames (time, space, spectral) used in the TimeSeries as well as the different photometric filter descriptions, assimilated to "flux frames".  
 \end{itemize}
 
-Utypes are built by concatanating class and attributes names following a path from a top element to the actual considered leave. They don't desigante a class atrribute per se but a role of the attribute value with respet to the full model.
+Utypes are built by concatenating class and attributes names following a path from a top element to the actual considered leave. They don't desigante a class atrribute per se but a role of the attribute value with respet to the full model.
 
-The table in appendix is absolute reference for the utypes and should be reproduced in the timeSeries model specification.
+The table in appendix is an absolute reference for the utypes definition and should be reproduced in the timeSeries model specification.
 
 "Tables" mentionned here and described in the Appendix are not required to be serialized as TABLE elements in VOTable. In the case there is only one single TimeSeries in the VOTable document, "generic metadata tables" have only one single instance. They can be serialized as groups and their columns as PARAMS instead of using TABLES with one single row.
 
+The Appendix illustrates the background of the simplest example the serialization of which is provided at following URL : \\ 
+\begin{small}
+http://volute.g-vo.org/svn/trunk/projects/time-domain/time-series/standardized\_votables/\\
+/francois/SDSS\_J080434.20+510349.2\_VizieR\_complete\_utypes.xml \\
+\end{small}
+This TimeSeries is a light curve for a single SDSS object and his provided as full Catalog in VizieR. It has one single dependant variable : V magnitude.
+
+Of course most of the  use cases will be much more complex. 
+
+Example 2 
+ is an excerpt of table 3 of the VizieR catalog provided by Shenavrin and coworkers in 2011 (Shenavrin et al, Astronomicheskii Zhurnal, 2011, Vol. 88, No. 1, pp. 34-85.) where the rows present a basic time with a Time Shift for each photometric band.
+. It has a main time as independant variable and several magnitudes in different  bands for the same individual exposure. The exact measurement time is slightly varying according to the band (due to a shift of time for changing the filter) in such a way that several secondary times are given for each main TimeStamp as well.\\ 
+\begin{small}
+(http://volute.g-vo.org/svn/trunk/projects/time-domain/time-series/standardized\_votables/\\
+francois/BetaLyr\_Vizier\_complete\_utypes.xml) \\
+\end{small}
 
+
+In example 3 where exoplanet data are provided (GASP project) some columns provide flux or radial velocity measurements which have a specific utype. Some other don't have because the definition of the quatity is outside the scope of STC or photometric datamodel. In that case a genric "meausrement" utype is given and the flavor can be precised with help of the ucd. 


More information about the Volutecommits mailing list