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

Volute commit messages volutecommits at g-vo.org
Tue Apr 3 18:05:35 CEST 2018


Author: francois
Date: Tue Apr  3 18:05:35 2018
New Revision: 4879

Log:
adding francois appendix

Added:
   trunk/projects/time-domain/time-series/note/appendixFrancois.tex

Added: trunk/projects/time-domain/time-series/note/appendixFrancois.tex
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ trunk/projects/time-domain/time-series/note/appendixFrancois.tex	Tue Apr  3 18:05:35 2018	(r4879)
@@ -0,0 +1,345 @@
+\section{VODataservice tabular mapping of TimeSeries}
+\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>
+</vosi:tableset>
+\end{lstlisting}
+


More information about the Volutecommits mailing list