Page tree
Skip to end of metadata
Go to start of metadata

Three approaches are taken to build the p2irc data dictionary described as follows:

Formats:

Date: The Government of Canada recommends the yyyy-MM-dd HH:mm:ss format for writing numeric dates and times following ISO 8601. Local Time Zone should be used. For us it is (GMT-06:00) Central Time - Regina.


Automatically Extracted keys from P2IRC DEV Database Schema.

 

Entities

Attributes

Key-value  Atrributes Key-value  Description
Sensor_type {1}Sensor_type_added_date{"cql_collection":"singleton","type":"date"}    
 Sensor_type_description{"cql_collection":"singleton","type":"keyword"}    
 Sensor_type_guid{"type":"keyword"}    
 Sensor_type_id{"cql_collection":"singleton","type":"keyword"}    
 Sensor_type_metadata{"cql_udt_name":"sensor_type_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"}},"type":"nested"}  
 Sensor_type_name{"cql_collection":"singleton","type":"keyword"}    
Drone {0}      
Channel {3}_parent{"type":"trial"}    
 _routing{"required":true}    
 Channel_added_data{"type":"date"}    
 Channel_added_date{"cql_collection":"singleton","type":"date"}    
 Channel_description{"cql_collection":"singleton","type":"keyword"}    
 Channel_guid{"type":"keyword"}    
 Channel_id{"cql_collection":"singleton","type":"keyword"}    
 Channel_metadata{"cql_udt_name":"channel_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"}},"type":"nested"}  
 Channel_name{"cql_collection":"singleton","type":"keyword"}    
 Trial_id{"cql_collection":"singleton","type":"keyword"}    
Range {3}_parent{"type":"trial"}    
 _routing{"required":true}    
 Range_added_date{"cql_collection":"singleton","type":"date"}    
 Range_description{"cql_collection":"singleton","type":"keyword"}    
 Range_guid{"type":"keyword"}    
 Range_id{"cql_collection":"singleton","type":"keyword"}    
 Range_metadata{"cql_udt_name":"range_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"}},"type":"nested"}  
 Range_name{"cql_collection":"singleton","type":"keyword"}    
 Range_number{"cql_collection":"singleton","type":"long"}    
 Trial_id{"cql_collection":"singleton","type":"keyword"}    
Sensor {3}_parent{"type":"sensor_type"}    
 _routing{"required":true}    
 Sensor_added_date{"cql_collection":"singleton","type":"date"}    
 Sensor_description{"cql_collection":"singleton","type":"keyword"}    
 Sensor_guid{"type":"keyword"}    
 Sensor_id{"cql_collection":"singleton","type":"keyword"}    
 Sensor_metadata{"cql_udt_name":"sensor_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"}},"type":"nested"}  
 Sensor_name{"cql_collection":"singleton","type":"keyword"}    
 Sensor_type_id{"cql_collection":"singleton","type":"keyword"}    
Plot {3}_parent{"type":"range"}    
 _routing{"required":true}    
 Crop_id{"cql_collection":"singleton","type":"keyword"}    
 Plot_added_data{"type":"date"}    
 Plot_added_date{"cql_collection":"singleton","type":"date"}    
 Plot_description{"cql_collection":"singleton","type":"keyword"}    
 Plot_guid{"type":"keyword"}    
 Plot_id{"cql_collection":"singleton","type":"keyword"}    
 Plot_metadata{"cql_udt_name":"plot_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"},"is_plot_destructively_sampled":{"type":"boolean"}},"type":"nested"}  
 Plot_name{"cql_collection":"singleton","type":"keyword"}    
 Plot_number{"cql_collection":"singleton","type":"integer"}    
 Range_id{"cql_collection":"singleton","type":"keyword"}    
 Strain_id{"cql_collection":"singleton","type":"keyword"}    
Orthomosaic {3}_parent{"type":"channel"}    
 _routing{"required":true}    
 Channel_id{"cql_collection":"singleton","type":"keyword"}    
 Ortho_added_data{"type":"date"}    
 Ortho_added_date{"cql_collection":"singleton","type":"date"}    
 Ortho_description{"cql_collection":"singleton","type":"keyword"}    
 Ortho_guid{"type":"keyword"}    
 Ortho_hash{"cql_collection":"singleton","type":"keyword"}    
 Ortho_id{"cql_collection":"singleton","type":"keyword"}    
 Ortho_metadata{"cql_udt_name":"ortho_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"},"bounding_polygon_utm":{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}},"processing_package_name":{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}}},"type":"nested"}
 Ortho_name{"cql_collection":"singleton","type":"keyword"}    
 Ortho_number{"cql_collection":"singleton","type":"long"}    
 Ortho_type{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}}   
 Sensor_id{"cql_collection":"singleton","type":"keyword"}    
Trial {3}_parent{"type":"field"}    
 _routing{"required":true}    
 Field_id{"cql_collection":"singleton","type":"keyword"}    
 Trial_added_date{"cql_collection":"singleton","type":"date"}    
 Trial_crop_id{"cql_collection":"singleton","type":"keyword"}    
 Trial_description{"cql_collection":"singleton","type":"keyword"}    
 Trial_flight_date{"cql_collection":"singleton","type":"date"}    
 Trial_guid{"type":"keyword"}    
 Trial_id{"cql_collection":"singleton","type":"keyword"}    
 Trial_metadata{"cql_udt_name":"trial_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"},"altitud":{"type":"long"}},"type":"nested"}  
 Trial_name{"cql_collection":"singleton","type":"keyword"}    
 Trial_year{"cql_collection":"singleton","type":"integer"}    
Plant {3}_parent{"type":"row"}    
 _routing{"required":true}    
 Plant_added_date{"cql_collection":"singleton","type":"date"}    
 Plant_description{"cql_collection":"singleton","type":"keyword"}    
 Plant_guid{"type":"keyword"}    
 Plant_id{"cql_collection":"singleton","type":"keyword"}    
 Plant_metadata{"cql_udt_name":"plant_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"}},"type":"nested"}   
 Plant_name{"cql_collection":"singleton","type":"keyword"}    
 Row_id{"cql_collection":"singleton","type":"keyword"}    
Field {1}Field_added_data{"type":"date"}    
 Field_added_date{"cql_collection":"singleton","type":"date"}    
 Field_description{"cql_collection":"singleton","type":"keyword"}    
 Field_guid{"type":"keyword"}    
 Field_id{"cql_collection":"singleton","type":"keyword"}    
 Field_metadata{"cql_udt_name":"field_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"},"field_height_px":{"type":"long"},"field_width_px":{"type":"long"}},"type":"nested"}  
 Field_name{"cql_collection":"singleton","type":"keyword"}    
Crop {1}Crop_added_data{"type":"date"}    
 Crop_added_date{"cql_collection":"singleton","type":"date"}    
 Crop_description{"cql_collection":"singleton","type":"keyword"}    
 Crop_guid{"type":"keyword"}    
 Crop_id{"cql_collection":"singleton","type":"keyword"}    
 Crop_metadata{"cql_udt_name":"crop_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"}},"type":"nested"}   
 Crop_name{"cql_collection":"singleton","type":"keyword"}    
Row {3}_parent{"type":"plot"}    
 _routing{"required":true}    
 Plot_id{"cql_collection":"singleton","type":"keyword"}    
 Row_added_date{"cql_collection":"singleton","type":"date"}    
 Row_description{"cql_collection":"singleton","type":"keyword"}    
 Row_guid{"type":"keyword"}    
 Row_id{"cql_collection":"singleton","type":"keyword"}    
 Row_metadata{"cql_udt_name":"row_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"}},"type":"nested"}   
 Row_name{"cql_collection":"singleton","type":"keyword"}    
Strain {1}Strain_added_date{"cql_collection":"singleton","type":"date"}    
 Strain_description{"cql_collection":"singleton","type":"keyword"}    
 Strain_id{"cql_collection":"singleton","type":"keyword"}    
 Strain_metadata{"cql_udt_name":"strain_metadata","properties":{"id":{"cql_collection":"singleton","type":"keyword"}},"type":"nested"}  
 Strain_name{"cql_collection":"singleton","type":"keyword"}    
file {1}doc{1}file metadata {1}Properties {63}BitsPerSample{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ColorComponents{"type":"long"} 
    Compression{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    EncodingProcess{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ExifByteOrder{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ExifToolVersion{"type":"float"} 
    ExtraSamples{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileAccessDate{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileInodeChangeDate{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileModifyDate{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileSize{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileTypeExtension{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GDALNoData{"type":"long"} 
    GTCitation{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GTModelType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GTRasterType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeoTiffAsciiParams{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeoTiffDirectory{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeoTiffDoubleParams{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeoTiffVersion{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogAngularUnitSize{"type":"float"} 
    GeogAngularUnits{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogCitation{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogEllipsoid{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogGeodeticDatum{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogInvFlattening{"type":"float"} 
    GeogPrimeMeridian{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogPrimeMeridianLong{"type":"long"} 
    GeogSemiMajorAxis{"type":"long"} 
    GeographicType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ImageDescription{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ImageHeight{"type":"long"} 
    ImageSize{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ImageWidth{"type":"long"} 
    JFIFVersion{"type":"float"} 
    MIMEType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    Megapixels{"type":"float"} 
    ModelTiePoint{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ModifyDate{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    PhotometricInterpretation{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    PixelScale{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    PlanarConfiguration{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    Predictor{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ProjLinearUnits{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ProjectedCSType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ResolutionUnit{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    RowsPerStrip{"type":"long"} 
    SampleFormat{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    SamplesPerPixel{"type":"long"} 
    Software{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    StripByteCounts{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    StripOffsets{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    SubfileType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    TileByteCounts{"type":"long"} 
    TileLength{"type":"long"} 
    TileOffsets{"type":"long"} 
    TileWidth{"type":"long"} 
    VerticalUnits{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    Warning{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    XResolution{"type":"long"} 
    YCbCrSubSampling{"type":"text","fields":{"keyword": {"ignore_above":256,"type":"keyword"}}} 
    YResolution{"type":"long"} 
 File_added_date{"cql_collection":"singleton","type":"date"}    
 File_description{"cql_collection":"singleton","type":"keyword"}    
 File_extension{"cql_collection":"singleton","type":"keyword"}    
 File_guid{"cql_collection":"singleton","type":"keyword"}    
 File_id{"cql_collection":"singleton","type":"keyword"}    
 File_mime_type{"cql_collection":"singleton","type":"keyword"}    
 File_name{"cql_collection":"singleton","type":"keyword"}    
 File_path{"cql_collection":"singleton","type":"keyword"}    
 File_size{"cql_collection":"singleton","type":"long"}    
 File_type{"cql_collection":"singleton","type":"keyword"}    
 file metadata {1}Properties {77} About{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    BitDepth{"type":"long"} 
    BitsPerSample{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ColorComponents{"type":"long"} 
    ColorSpace{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ColorType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    Compression{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    CreatorTool{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    CurrentIPTCDigest{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    EncodingProcess{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ExifByteOrder{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ExifImageHeight{"type":"long"} 
    ExifImageWidth{"type":"long"} 
    ExifToolVersion{"type":"float"} 
    ExtraSamples{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileAccessDate{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileInodeChangeDate{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileModifyDate{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileSize{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    FileTypeExtension{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    Filter{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GDALNoData{"type":"long"} 
    GTCitation{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GTModelType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GTRasterType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeoTiffAsciiParams{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeoTiffDirectory{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeoTiffDoubleParams{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeoTiffVersion{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogAngularUnitSize{"type":"float"} 
    GeogAngularUnits{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogCitation{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogEllipsoid{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogGeodeticDatum{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogInvFlattening{"type":"float"} 
    GeogPrimeMeridian{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    GeogPrimeMeridianLong{"type":"long"} 
    GeogSemiMajorAxis{"type":"long"} 
    GeographicType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    IPTCDigest{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ImageDescription{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ImageHeight{"type":"long"} 
    ImageSize{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ImageWidth{"type":"long"} 
    Interlace{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    JFIFVersion{"type":"float"} 
    MIMEType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    Megapixels{"type":"float"} 
    ModelTiePoint{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ModifyDate{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    Orientation{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    Padding{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    PhotometricInterpretation{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    PixelScale{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    PlanarConfiguration{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    Predictor{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ProjLinearUnits{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ProjectedCSType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    ResolutionUnit{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    RowsPerStrip{"type":"long"} 
    SampleFormat{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    SamplesPerPixel{"type":"long"} 
    Software{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    StripByteCounts{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    StripOffsets{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    SubfileType{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    TileByteCounts{"type":"long"} 
    TileLength{"type":"long"} 
    TileOffsets{"type":"long"} 
    TileWidth{"type":"long"} 
    VerticalUnits{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    Warning{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    XResolution{"type":"long"} 
    YCbCrSubSampling{"type":"text","fields":{"keyword":{"ignore_above":256,"type":"keyword"}}} 
    YResolution{"type":"long"} 
    Id{"cql_collection":"singleton","type":"keyword"} 
       
 

Manually Extracted Keys from P2IRC DEV Database Schema

Keys Title/ LabelKeys Name
[Sensor type] 
Senson typesensor_type
Datesensor_type_added_date
Descriptionsensor_type_description
Guidsensor_type_guid
Sensor IDsensor_type_id
Metadatasensor_type_metadata
Namesensor_type_name
  
[drone]drone
  
[channel] 
datechannel_added_date
descriptionchannel_description
guidchannel_guid
idchannel_id
metadatachannel_metadata
namechannel_name
  
[Range] 
Rangerange
descriptionrange_description
Guidrange_guid
IDrange_id
metadatarange_metadata
namerange_name
numberrange_number
  
[Plot] 
Plotplot
dataplot_added_data
dateplot_added_date
desciptionplot_description
Guidplot_guid
IDplot_id
metadataplot_metadata
nameplot_name
numberplot_number
  
[Orthomosaic]orthomosaic
dataortho_added_data
dateortho_added_date
descriptionortho_description
Guidortho_guid
hashortho_hash
IDortho_id
metadataortho_metadata
nameortho_name
numberortho_number
typeortho_type
  
[Trial]trial
datetrial_added_date
Crop IDtrial_crop_id
descriptiontrial_description
flight_datetrial_flight_date
Guidtrial_guid
IDtrial_id
metadatatrial_metadata
nametrial_name
yeartrial_year
  
[plant]plant
descriptionplant_description
Guidplant_Guid
idplant_id
metadataplant_metadata
nameplant_name
  
[Field]field
Datafield_added_data
Datefield_added_date
Descriptionfield_description
Guidfield_guid
IDfield_id
metadatafield_metadata
[properties] 
heightfield_height_px
widthfield_width_px
IDid
Namefield_name
  
[Crop]crop
datecrop_added_date
descriptioncrop_description
Guidcrop_guid
IDcrop_ID
metadatacrop_metadata
namecrop_name
  
[row]row
daterow_added_date
descriptionrow_description
Guidrow_guid
idrow_id
metadatarow_metadata
namerow_name
  
[Strain]strain
datestrain_added_date
descriptionstrain_added_description
IDstrain_id
metadatastrain_metadata
namestrain_name
  
[File]file
[doc]doc
[file metadata]file_metadata
Bits per SampleBitsPerSample
Color ComponentsColorComponents
CompressionCompression
Encoding ProcessEncodingProcess
Exit byte orderExitByteOrder
Exit tool versionExitToolVersion
Extra samplesExtraSamples
File access dateFileAccessDate
File node change dateFileNodeChangeDate
File modify dateFileModifyDate
sizeFileSize
typeFileType
file type extesionFileTypeExtension
GDALNoDataGDALNoData
GT CitationGTCitation
GT Model TypeGTModelType
GT Raster TypeGTRasterType
Geo Tiff Ascii ParamsGeoTiffAsciiParams
Geo Tiff DirectoryGeoTiffDirectory
Geo Tiff Double ParamsGeoTiffDoubleParams
Geo Tiff VersionGeoTiffVersion
Geog Angular Unit SizeGeogAngularUnitSize
Geog Angular UnitsGeogAngularUnits
GeogCitationGeogCitation
Geog EllipsoidGeogEllipsoid
Geog Geodetic DatumGeogGeodeticDatum
Geog Inv FlatteningGeogInvFlattening
Geog Prime MeridianGeogPrimeMeridian
Geog Prime Meridian LongGeogPrimeMeridianLong
Geog Semi Major AxisGeogSemiMajorAxis
Geographic TypeGeographicType
Image DescriptionImageDescription
Image HeightImageHeight
Image SizeImageSize
Image WidthImageWidth
JFIFVersionJFIFVersion
MIMEtypeMIMEType
Mega pixelsMegapixels
Model Tie PointModelTiePoint
Modify DateModifyDate
Photometric InterpretationPhotometricInterpretation
Pixel ScalePixelScale
Planar ConfigurationPlanarConfiguration
PredictorPredictor
Projected Linear UnitsProjLinearUnits
Projected CS TypeProjectedCSType
Resolution UnitResolutionUnit
RowsPerStripRowsPerStrip
Samples Per PixelSamplesPerPixel
SoftwareSoftware
Strip Byte CountsStripByteCounts
Strip OffsetsStripOffsets
Subfile typeSubfileType
Tile Byte CountsTileByteCounts
Tile LengthTileLength
Tile OffsetsTileOffsets
TileWidthTileWidth
Vertical UnitsVerticalUnits
WarningWarning
XResolutionXResolution
YCbCrSubSamplingYCbCrSubSampling
YResolutionYResolution
  
file datefile_added_date
descriptionfile_description
extentionsfile_extension
Guidfile_guid
IDfile_id
  
[file_metadata]file_metadata
Bit DepthBitDepth
Bits per SampleBitsPerSample
Color ComponentsColorComponents
Color SpaceColorSpace
Color TypeColorType
CompressionCreatorTool
CurrentIPTCDigestCurrentIPTCDigest
Encoding ProcessExifByteOrder
Exif Image HeightExifImageHeight
Exif Image WidthExifImageWidth
Exif Tool VersionExifToolVersion
Extra SamplesExtraSamples
File Access DateFileAccessDate
FileInode Change DateFileInodeChangeDate
File Modify DateFileModifyDate
File SizeFileSize
File TypeFileType
File Type ExtensionFileTypeExtension
FilterFilter
GDALNoDataGDALNoData
GTCitationGTCitation
GTModelTypeGTModelType
GTRasterTypeGTRasterType
GeoTiffAsciiParamsGeoTiffAsciiParams
GeoTiffDirectoryGeoTiffDirectory
GeoTiffDoubleParamsGeoTiffDoubleParams
GeoTiffVersionGeoTiffVersion
GeogAngularUnitSizeGeogAngularUnitSize
GeogAngularUnitsGeogAngularUnits
GeogCitationGeogCitation
GeogEllipsoidGeogEllipsoid
GeogGeodeticDatumGeogGeodeticDatum
GeogInvFlatteningGeogInvFlattening
GeogPrimeMeridianGeogPrimeMeridian
GeogPrimeMeridianLongGeogPrimeMeridianLong
GeogSemiMajorAxisGeogSemiMajorAxis
GeographicTypeGeographicType
IPTCDigestIPTCDigest
Image DescriptionImageDescription
Image HeightImageHeight
Image SizeImageSize
Image WidthImageWidth
InterlaceInterlace
JFIFVersionJFIFVersion
MIMETypeMIMEType
MegapixelsMegapixels
ModelTiePointModelTiePoint
ModifyDateModifyDate
OrientationOrientation
PaddingPadding
PhotometricInterpretationPhotometricInterpretation
PixelScalePixelScale
PlanarConfigurationPlanarConfiguration
PredictorPredictor
ProjLinearUnitsProjLinearUnits
ProjectedCSTypeProjectedCSType
ResolutionUnitResolutionUnit
RowsPerStripRowsPerStrip
SampleFormatSampleFormat
SamplesPerPixelSamplesPerPixel
SoftwareSoftware
StripByteCountsStripByteCounts
StripOffsetsStripOffsets
SubfileTypeSubfileType
TileByteCountsTileByteCounts
TileLengthTileLength
TileOffsetsTileOffsets
TileWidthTileWidth
VerticalUnitsVerticalUnits
WarningWarning
XResolutionXResolution
YCbCrSubSamplingYCbCrSubSampling
YResolutionYResolution
file_mime_typefile_mime_type
file namefile_name
file pathfile_path
file sizefile_size
file typefile_type

 

 

 

Keys collected from various developers

 

Keys Title/ LabelKeys NamePossible ValuesData TypeDescriptionSource 
* these keys are a brainstorm mixture of existing ideas & foreseeable ideas for what might be required by each record in the future
      
       
[Field]    Brittany 
Field IDfield_id  unique identifier for a field (I am unaware of any official identifiers)  
Name (Display)name  display name  
Locationlocation  position coordinates in the real world (GPS? position coordinates refer to TL?)  
Widthwidth  width in the real world?  
Heightheight  height in the real world?  
Yearyear  year the field was captured  
List of Associated Trials ?trials  list of trial IDs associated with this field  
List of Associated Trials' Locations & Dims ?trial_shapes  list of trial locations & dimensions (trial shape?) of all associated trials  
       
[Trial]    Brittany 
Test IDtest_id  unique identifier for a trial ("Test ID" originates from the Agriculture fieldbooks)  
Namename  display name  
Number of Rangesn_ranges  number of ranges in this trial's field map  
Number of Rowsn_rows  number of rows in this trial's field map  
Numner of Rows Per Plotn_rows_per_plot  number of rows that constitute a plot within this trial  
Field Map/Plot Layoutfield_map  2D array/list of lists describing the layout/order of ranges and plots within each range/plot  
Locationlocation  position coordinates in the real world (GPS? position coordinates refer to TL?)  
Widthwidth  width in the real world?  
Heightheight  height in the real world?  
Capture Datescapture_dates  
list of dates when the trial had raw image data captured for it (need to differentiate the different sensors capturing different dates- see William's stuff for this)
  
List of Associated Ranges ?ranges  list of ranges associated with this trial  
List of Asosciated Plots ?plots  list of plots associated with this trial  
Range Orthomosaic Availabilityavailable_ranges  
some kind of mapping that describes what capture dates/ranges have "good" range images that can be used for segmentation, display, etc.
  
* William noted that a trial may be conducted across multiple fields, something not covered here but probably worth a point of discussion
      
** available_ranges or some way of accessing only viable orthomosaic/stitched images is important as not every image is suitable for analysis, web display, etc.
      
       
[Range]    Brittany 
Range IDrange_id  unique identifier for a range within a trial  
Range Indexrange_index  index for identifying the position of this range within its corresponding trial  
Range Numberrange_number  index number used by Agriculture fieldbook to uniquely identify this range from [1,number_ranges]  
Associated Trialtest_id  identifier of trial this range is associated with  
List of Associated Plots ?plots  list of plots associated with this trial  
Image(s) ?image  (link to) image associated with this range (generated orthomosaic)  
Source Image Sets ?source_images  (link to) source images used to create the range's image  
* range_index & range_number should refer to the same thing here, they are both included here for completeness
      
       
[Plot]    Brittany 
Plot IDplot_id  unique identifier for a plot within a trial  
Plot Indexplot_index1 (zero-based e.g.) index for identifying this plot's position within its corresponding range or trial  
Plot Numberplot_number101, (empty for some guards) 
index number used by Agriculture fieldbook to uniquely identifty this plot's position within its corresponding range or trial
  
Associated Trial IDtest_id  identifier of trial assocated with this plot  
Associated Range IDrange_id  identifier of range associated with this plot  
Row Number(s)rows[3,4] (zero-based e.g.) list of row indices/identifiers that constitute this plot  
Reprep1 (empty for some guards) repitition number  
Barcodebarcode
"17VNC6041R1", (empty for some guards)
 Agriculture identification code ? Possibly a unique identifier for a plot across all trials and not just within a trial  
Field Codefield_code
6041, "Barley" (empty for some guards)
 Agriculture identification code for different experimental designs  
Namename"NAM-65", "Guard", "Barley" display name  
Sourcesource  ? Agriculture fieldbook entry  
Pedigreepedigree  ? Agriculture fieldbook entry  
Entryentry
(empty for some guards, DNE for some trials)
 Agriculture identification code for different experimental designs  
Image(s)?image  (link to) image associated with this plot (generated orthomosaic, segmentation, etc.)  
Source Image Sets?source_images  (link to) source images used to create the plot's image ?  
* Guard plots (extreme & non-extreme)-- should they be implicitly worked into the plot structure (i.e. absence or specific markup of certain fields implies it is a guard plot) or should they be a special plot entity? These plots are important for field map/layout positioning.
      
       
[GrowPro Image Set Capture Metadata]    Brittany 
Image Setimage_set  associated image set of raw images  
Datecapture_date  when the raw images where captured  
Camera Operatorcamera_operator  who captured the data (for reference/contact?)  
Field Element Captured/Pass Definitionpass"range", "plot", "rows of plots" what was captured by each pass made by the operator; defines what a pass is  
Pass Typepass_type"one pass", "two pass" how each pass is recorded by the operator  
Pass Walking Methodpass_walking_method"linear", "snake" how the transition between passes occurs (does the operator always go W to E or alternate W to E, E to W?)  
Mapping Of Pass IDs To Field Element Captured   
some way to associate each pass with its specific captured data element, especially since not every field element may be captured, even from capture date to capture date
  
* This metadata corresponds to data pertaining to a particular set of passes made in a single day for a specific trial
      
Key Title/ LabelKey namePossible ValuesData TypeDescription  
[Plot]    William 
 range_id     
 trial_id     
 strain_id     
 field_id     
 number     
 
is_aafc_sampling_plot
     
 is_guard     
 rep_number     
 crop_id     
       
[Range]    William 
 number     
 trial_id     
       
 [Trial]     
 name     
 year     
       
[Sensor]    William 
 name     
 sensor_type_id     
       
 [Sensor Type]     
 name     
       
[Sensor Position]    William 
 starttime_utc     
 stoptime_utc     
 sensor_id     
 plot_id     
 pos_longlat     
 
height_above_ground_m
     
 
altitude_above_sea_level_m
     
 pitch     
 roll     
 yaw     
       
[Image]    William 
 exif_metadata     
       
 
[Overhead Image Set]
     
 experiment_id     
 timestamp_utc     
 
specified_altitude_m
     
 drone_id     
 sensor_id     
 range_id     
 plot_id     
       
[Overhead Image]    William 
 timestamp_utc     
 image_id     
 
raw_image_set_id
     
 
pos_camera_longlat
     
 
pos_camera_altitude_above_sea_level_m
     
 
multi_file_image_id
     
 channel_id     
       
[Orthomosaic]    William 
 run_id     
 image_id     
 
raw_image_set_id
     
 channel_id     
 
processing_package_id
     
       
[Timelapse Image]    William 
 timestamp_utc     
 sensor_id     
 image_id     
       
[Plot Bounding Box]    William 
 run_id     
 plot_id     
 
bounding_polygon_utm
     
       
       
[Image Bounding Box]    William 
 run_id     
 image_id     
 
bounding_polygon_utm
     
       
[Plot Image]    William 
 
img_polygon_coords
     
 image_id     
 image_source_id     
 plot_id     
 run_id     
 
extent_in_img_src
     
       
[Plot Image Result]      
 plot_image_id     
 run_id     
Key Title/ LabelKeys NamePossible ValuesData TypeDescription Source 
[for all binary object]    Steven 
Object Pathpath stringobject location on datastore  
Object Sizesize integersize of the object; in bytes  
Object TypetypeImage/PNG, Image/TIFF, Image/JPG etc.stringtype of the object  
Object Namename stringname of the object  
       
       
  • No labels