Defining boundary areas by using SQL

You might want to define a boundary area type data source that has many boundary areas. Instead of drawing each boundary area polygon individually on the map, you can define the boundary area polygons by using an SQL table. Then, create a data source that connects to a database to acquire the boundary area data from the SQL table.

About this task

For the boundary areas to be created successfully, you must do the following steps in order. You must insert the boundary area polygon data into the SQL table before you create the data source that acquires the data from the SQL table. SQL data for a boundary area type data source is acquired only when the data source is created. A boundary area type data source is not polled for updated data after the data source is created.

1. Log on to the IBM® Intelligent Operations Center data server, and then connect to a database.
2. Create a boundary area data source table. Ensure that the lengths of the properties in the table are large enough to contain the values of the well-known text (WKT) format for the polygons that define your boundary areas. If the properties are not large enough to contain the polygon values, the boundary areas will not be created. For example, the following SQL commands create a table that is named SAMPLE.NAMED_AREA.

    drop table SAMPLE.NAMED_AREA;
    create table SAMPLE.NAMED_AREA (
     StartDateTime TIMESTAMP,
     EndDateTime TIMESTAMP,
     LOCATION VARCHAR(500), 
     NAME VARCHAR(30),
     LastUpdateDateTime   TIMESTAMP,
     TIMEZONEOFFSET   INTEGER,
     INCIDENT_NUMBER VARCHAR(100), 
     PROBLEM  VARCHAR(100), 
     CALL_DISPOSITION  VARCHAR(100), 
     PRIORITY_NUMBER  INTEGER
     )
   DATA CAPTURE NONE; 

3. Insert the boundary area data into the boundary area table. The following example inserts a single polygon into the table:

    INSERT INTO SAMPLE.NAMED_AREA (
     STARTDATETIME, 
     ENDDATETIME, 
     LOCATION, 
     NAME, 
     LASTUPDATEDATETIME, 
     TIMEZONEOFFSET, 
     INCIDENT_NUMBER, 
     PROBLEM, 
     CALL_DISPOSITION, 
     PRIORITY_NUMBER)
    VALUES (
     CURRENT_TIMESTAMP,
     CURRENT_TIMESTAMP,
     'POLYGON((-93.64833644901181 45.07616323264413,-93.54259304081118 
               45.0732538434894,-93.55083278690229 45.012607882373146,
               -93.64970974003148 45.02037415319953,-93.64833644901181 
               45.07616323264413))',
     'Polygon_001',
     CURRENT_TIMESTAMP,
     0,'10021',
     'problem',
     'call_dispostion',
     '2'); 

4. Log on to IBM Intelligent Operations Center, and create a data source by following the instructions in the Configuring a data source section. Note the following points:
   • On the Acquire tab, for the data source acquisition method, select Connect to a database.
   • On the Basics tab, for Data for boundary, select Yes.

Results

In the Operations view, in the Where pane in the filter, the boundary area that you defined in the SQL file is displayed in the list of boundary areas for the data source.