Databases > WideWorldImporters > Tables > Warehouse.VehicleTemperatures

WideWorldImporters

Warehouse.VehicleTemperatures

Created: 6/6/2016 Modified: 6/6/2016

Columns

VehicleTemperatureID

[bigint] IDENTITY (1,1) NOT NULL
VehicleRegistration

[nvarchar](20) NOT NULL
ChillerSensorNumber

[int] NOT NULL
RecordedWhen

[datetime2](8) NOT NULL
Temperature

[decimal](10, 2) NOT NULL
FullSensorData

[nvarchar](1000) NULL
IsCompressed

[bit] NOT NULL
CompressedSensorData

[varbinary](MAX) NULL

Indexes

PK_Warehouse_VehicleTemperatures

UNIQUE NONCLUSTERED

VehicleTemperatureID

Sample Data

VehicleTemperatureID

VehicleRegistration

ChillerSensorNumber

RecordedWhen

Temperature

FullSensorData

IsCompressed

CompressedSensorData

61889

WWI-321-A

5/22/2016

4.95

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-97.0631332,65.0193593] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T12:21:32","temp":4.95}} ]

NULL

[varbinary]

61890

WWI-321-A

5/22/2016

3.64

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-90.9886670,64.0785564] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-22T12:21:32","temp":3.64}} ]

NULL

[varbinary]

61893

WWI-321-A

5/22/2016

4.16

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-98.0693884,61.1627815] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T12:26:35","temp":4.16}} ]

NULL

[varbinary]

61894

WWI-321-A

5/22/2016

3.92

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-86.4187136,50.9575952] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-22T12:26:35","temp":3.92}} ]

NULL

[varbinary]

61911

WWI-321-A

5/22/2016

3.17

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-99.3270772,61.1804049] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T12:48:40","temp":3.17}} ]

NULL

[varbinary]

61912

WWI-321-A

5/22/2016

3.32

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-98.5133729,61.1902894] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-22T12:48:40","temp":3.32}} ]

NULL

[varbinary]

61913

WWI-321-A

5/22/2016

4.73

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-84.1115333,66.6767946] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T12:48:54","temp":4.73}} ]

NULL

[varbinary]

61914

WWI-321-A

5/22/2016

4.6

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-93.9596126,58.7025187] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-22T12:48:54","temp":4.60}} ]

NULL

[varbinary]

61915

WWI-321-A

5/22/2016

4.65

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-94.6840789,38.9680931] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T12:49:03","temp":4.65}} ]

NULL

[varbinary]

61918

WWI-321-A

5/22/2016

3.61

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-99.4412678,64.1536734] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-22T12:52:01","temp":3.61}} ]

NULL

[varbinary]

61920

WWI-321-A

5/22/2016

3.72

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-83.1475401,61.9604490] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-22T12:53:16","temp":3.72}} ]

NULL

[varbinary]

61921

WWI-321-A

5/22/2016

3.83

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-92.1039608,59.3256195] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T12:57:30","temp":3.83}} ]

NULL

[varbinary]

61924

WWI-321-A

5/22/2016

3.42

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-84.9157806,67.7488230] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-22T13:01:09","temp":3.42}} ]

NULL

[varbinary]

61791

WWI-321-A

5/22/2016

4.05

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-108.2555311,53.4834252] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T10:21:23","temp":4.05}} ]

NULL

[varbinary]

61792

WWI-321-A

5/22/2016

4.09

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-100.7901904,48.4734068] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-22T10:21:23","temp":4.09}} ]

NULL

[varbinary]

61793

WWI-321-A

5/22/2016

3.7

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-114.1916408,56.2457991] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T10:24:19","temp":3.70}} ]

NULL

[varbinary]

61795

WWI-321-A

5/22/2016

3.94

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-117.9087142,41.3619907] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T10:27:44","temp":3.94}} ]

NULL

[varbinary]

61796

WWI-321-A

5/22/2016

4.5

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-109.7357265,47.7664926] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-22T10:27:44","temp":4.50}} ]

NULL

[varbinary]

61799

WWI-321-A

5/22/2016

4.73

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-122.2039736,59.7203481] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T10:33:56","temp":4.73}} ]

NULL

[varbinary]

61801

WWI-321-A

5/22/2016

4.63

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-118.5708106,37.9992289] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T10:35:13","temp":4.63}} ]

NULL

[varbinary]

61803

WWI-321-A

5/22/2016

4.77

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-107.5302389,60.9198169] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T10:36:53","temp":4.77}} ]

NULL

[varbinary]

61807

WWI-321-A

5/22/2016

3.59

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-106.0718144,55.6999993] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T10:44:26","temp":3.59}} ]

NULL

[varbinary]

61809

WWI-321-A

5/22/2016

4.74

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-116.7509933,49.1748047] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T10:45:44","temp":4.74}} ]

NULL

[varbinary]

61811

WWI-321-A

5/22/2016

4.25

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-109.3482415,47.8734262] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-22T10:49:29","temp":4.25}} ]

NULL

[varbinary]

61812

WWI-321-A

5/22/2016

3.18

{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-119.0143930,47.0231514] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-22T10:49:29","temp":3.18}} ]

NULL

[varbinary]