Power BI - DWH

Introduction

Purpose

The purpose of this guide is to explain how to access the DWH what data can be discovered

Note: The C-insight DWH is experimental and may change in it’s future versions

C-Insight Data Warehouse

The C-insight DWH data is stored in database called “VulcanDwhDB”.

The Data is updated in near Realtime. You can access this database information, filter it, link

views, and create reports using the Power BI Desktop tool.

Data Warehouse Views

Tis section described the basic views, fields and possible values available for analyzing the c-

insight DWH

dwh.ZonesView

List all zones that exists in the system, include the zones that are not active

Column	Type	Description
ZoneId	Integer	The Id of the zone
ZoneName	String	The name of the zone
Location	String	The Polygon of the zone, this is a WKT format
IsActive	Boolean	Is the zone active or not

dwh.SensorView

List all the sensors that exists in the system, include sensors that are not active.

Column	Type	Description
SensorId	Integer	The Id of the zone
SensorName	String	The name of the zone
SensorType	String	The type of the sensor: PtzCamera LPR Camera PublicTransportationCamera VideoAnalytics ResponderMobileSensor PanicButton PublicTransportationVehicle
Location	String	The Polygon of the zone, this is a WKT format
IsActive	Boolean	Is the zone active or not

dwh.EventsView

List the events that exists in the C-Insight system

Column	Type	Description
EventID	Integer	The Id of the Event
OrganizationId	Integer	The Id of the organization
OrganizationName	String	The name of the organization
EventGroupName	String	The event Group: CAD CShare_SOS VA LPR Face C-React ManualEvent
EventType_ES	String	The type of the event (e.g): Vehiculo sospechoso Persona sospechosa Transporte público
EventSubType_ES	String	The Sub Type of the event (e.g): Listado en LPR Merodeando Evento SOS / PTO
EventCreationTime	Datetime	The date & time that the event was created
EventClosedTime	Datetime	The date & time that the event was closed
LocationPoint	String	The location of the event in WKT format
Latitude	Float	The Latitude of the event
Longitude	Float	The Longitude of the
Severity	Int	The severity Of the event
IsClosed	Boolean	Is the Event is closed true/false
IsClosedAsFalseAlarm	Boolean	In case that the event is closed, was it closed as “False Alarm”
IsClosedAsUnhandled	Boolean	In case that the event is closed, was it closed as unhandled
IsManualEvent	Boolean	Is the event was created manually or by the system true(Manual)/false(System)
ZoneId	Integer	The ID of the zone
ZoneName	string	The name of the zone

dwh.EventsLPRDetectionsView

List the LPR Detections for each of the events of type LPR, each event can have multiple detections.

Column	Type	Description
EventID	Integer	The Id of the Event
OrganizationId	Integer	The Id of the organization
OrganizationName	String	The name of the organization
EventGroupName	String	The event Group: LPR
EventType_ES	String	The type of the event (e.g): Vehiculo sospechoso Persona sospechosa Transporte público
EventSubType_ES	String	The Sub Type of the event (e.g): Listado en LPR Merodeando Evento SOS / PTO
EventCreationTime	Datetime	The date & time that the event was created
EventClosedTime	Datetime	The date & time that the event was closed
LocationPoint	String	The location of the event in WKT format
Latitude	Float	The Latitude of the event
Longitude	Float	The Longitude of the
Severity	Int	The severity Of the event
IsClosed	Boolean	Is the Event is closed true/false
IsClosedAsFalseAlarm	Boolean	In case that the event is closed, was it closed as “False Alarm”
IsClosedAsUnhandled	Boolean	In case that the event is closed, was it closed as unhandled
IsManualEvent	Boolean	Is the event was created manually or by the system true(Manual)/false(System)
ZoneId	Integer	The ID of the zone
ZoneName	string	The name of the zone
DetectionID	Integer	The id of the detection
DetectionCreationTime	Dateime	The Date & time that the detection was created
SensorId	Integer	The ID of the sensor
SensorName	string	The name of the sensor
Make	string	The make of the vehicle
Model	String	The model of the vehicle
ModelYear	String	The Year that the model was manufactured
Color	String	The color of the vehicle
PlateNumber	String	The Plate Number of the vehicle
Speed	Integer	The Speed that the vehicle was driving
Direction	string
Confidence	Integer	The Confidence that of the vehicle information

dwh.FaceDetectionView

List the Volume (Count) of Face detections the system received from Face Sensor per day and hour

Column	Type	Description
[DetectionHour]	DateTime	The Id of the zone
[DetectionDate]	Date	The name of the zone
[SensorId]	INT	The ID of the sensor
[SensorName]	String	The name of the sensor
[Volume]	Integer	The number of detections

dwh.LPRDetectionView

List all the Volume (Count) of LPR detections the system received from LPR Sensor per day and hour

Column	Type	Description
[DetectionHour]	DateTime	The Id of the zone
[DetectionDate]	Date	The name of the zone
[SensorId]	INT	The ID of the sensor
[SensorName]	String	The name of the sensor
[Volume]	Integer	The number of detections