#CitobsDB input for Calvalus #CitobsDB ver 1.0 #20180206 timo.pyhalahti@ymparisto.fi #For info: kansalaishavainnot@ymparisto.fi # #Notes: # #Calvalus Automatic Definitions (start with 4 standards, repeat to override in input) # latColumn=NorthCoordinate # lonColumn=EastCoordinate # timeColumns=ObservationTimeDATEUTC,ObservationTimeTIMEUTC # dateFormat=dd.MM.yyyy,HH:mm:SS # citobsdbServiceCode=service_code_20180207114202 # citobsdbDataExtractTimeStart=18.01.2010,10:30:00 # citobsdbDataExtractTimeEnd=18.01.2015,10:30:00 # citobsdbDataExtractionTime=07.02.2018,07:30:00 # citobsdbDataExtractionHeaderURL=http://eo.ymparisto.fi/data/citobs/co_koe/calvalus_input/esimerkit/Calvalus_Header_CitobsDB_20180206a.txt # x=singlevaluelist_20180207114619 # x=singlevaluelist_20180207115004 # x=singlevaluelist_20180207115608 # x=datetime_20180207120632 Valid Open311_ObservationID Open311_Service_Code ObservationTimeDATEUTC ObservationTimeTIMEUTC NorthCoordinate EastCoordinate CoordinateInfo ObservationQuestionnaireStatus Open311_Hashtags singlevaluelist_20180207114619 singlevaluelist_20180207115004 singlevaluelist_20180207115608 datetime_20180207120632 numbersortext1 service_code_20180207114202 01.01.2018 12:00:01 60.93392 27.38729 """digitalcoordinates;example""" Production """#talviseuranta #lumi #lumensyvyys""" 1 5 1 """01.11.2017T00:00:00+02:00""" numbersortext2 service_code_20180207114202 02.01.2018 15:05:02 60.93393 27.38730 """digitalcoordinates;example""" Production """#talviseuranta #lumi #lumensyvyys #talviseuranta #lumi""" 2 1 5 """01.11.2017T00:00:00+02:00""" # numbersortext3 service_code_20180207114202 01.01.2010 00:01:01 60.93394 27.38731 """digitalcoordinates;example""" Production """#talviseuranta #lumi #lumensyvyys""" 1 2 3 """02.12.2009T00:00:00+02:00""" numbersortext4 service_code_20180207114202 31.01.2018 07:30:11 60.93395 27.38732 """digitalcoordinates;example""" Production """#talviseuranta #lumi #lumensyvyys""" 1 3 3 """01.11.2017T00:00:00+02:00"""