Question

Write a program called EventManager, that allows a user to search for 9-1-1 incidents recorded in Seattle The data is given to you in file Seattle_911_Incidents.csv which contains 500 records (a subset of the approximately 53,000 911 calls made in Seattle in the years 2015-2017). This dataset is the Police responses to 9-1-1 calls within the city during the 2015-2017 years. You can get the full data set from http://data.seattle.gov. The data consists of 500 rows, where each row is an event. Each event has the following data: ID: The event ID 2. Type: The event type (e.g., THEFT, DISTURBANCES, etc.) Clearance Date: The date and time Location: The address where the event took place. 5. District/Sector: The district/sector code. 6. Zone/Beat: The zone/beat code. 1. 3. 4. Seattle is divided into five geographic areas. Within those areas are the 5 precincts or police stations: North, East, South, West and Southwest. Precinct boundaries were determined through consideration of neighborhood boundaries, geographic and other natural boundaries. Each precinct contains smaller geographic areas called sectors. There are 17 sectors in the city. Each of these sectors is divided into between 3 smaller sections called Zone/Beats. These are the areas that individual patrol officers are assigned responsibility for. See the figures below. What should your program do? Read file Seattle_911_Incidents.csv from the file path passed to your program as a 1. command- line argument. That is, I will execute you program in a way like this: java EventManager C:\Temp\Seattle_911_Incidents.csv So args[0] in your main method will have the full path of file Seattle_911_Incidents.csv. You need this path to be able to open and read the file content 2. Continuously instruct the user with the following sentence until the user enters q: Search by event type (-t type) or district (-d code) (or q to quit): 3. If the user enters q, then print "Thank you for using our search program" and stop. Otherwise, determine what the user typed (-t followed by a type, or -d followed by a district 4. code) Search the data and output the number of events like this: 5. Number of events having type X: nnn or Number of events in district X: nnn If the user types something other than -t type or -d district, you should print that the entry is 6. invalid: Invalid entry: expecting -t type or-d code In this case you should not end the program. Continue asking the user as indicated in step 1 Here is an example output (NOTE that the output numbers circled in blue are not correct here. This is just a dummy example. Its purpose is to just show you the output format and what to check for):

Answer 1

I have taken Seattle_Real_Time_Fire_911_Calls.csv file which contains 1.37M rows. The second column is Type and eighth column is (Seattle Police Department Micro Community Policing Plan Areas). I have used eighth column as district code because there is not district code in data sample I have taken. (change the index values according to your csv file)

Code :

package controller;

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.util.Scanner;

public class EventHandler {

   public static void main(String[] args) throws IOException {
       // TODO Auto-generated method stub
       int count=0;
       Scanner sc = new Scanner(System.in);
       while(true){
           // Read file from command line argument variable
           FileReader fr = new FileReader(args[0]);
           BufferedReader br = new BufferedReader(fr);
           System.out.println("Search By Event Type (-t type) or District (-d district) or q to quit");
           String input = sc.nextLine();
           // Check for search
           // if starts with -t
           if(input.startsWith("-t")){
               // Extract the type to search
               String type = input.substring(3);
               System.out.println(type);
               String line;
               br.readLine();
               while ( (line = br.readLine()) != null ) {
                   String[] values = line.split(",");
                   try{
                       // Type at second column so values[1]
                       if(values[1].equals(type)){
                           count++;
                       }}catch(ArrayIndexOutOfBoundsException e){

                       }
               }
               System.out.println(count);
               count=0;
           }
           // If starts with -d
           else if(input.startsWith("-d")){
               String district = input.substring(3);
               System.out.println(district);
               String line;
               br.readLine();
               while ( (line = br.readLine()) != null ) {
                   String[] values = line.split(",");
                   try{
                       if(values[7].equals(district)){
                           count++;
                       }}catch(ArrayIndexOutOfBoundsException e){
                       }
               }
               System.out.println(count);
               count=0;          
           }else if(input.equals("q")){
               break;
           }else{
               System.out.println("Please Enter Correct Input");
           }
           br.close();
       }
       sc.close();
   }
}

Output:

Search By Event Type (-t type) or District (-d district) or q to quit
-t Aid Response
Aid Response
662502
Search By Event Type (-t type) or District (-d district) or q to quit
-d 14
14
119462
Search By Event Type (-t type) or District (-d district) or q to quit
-u
Please Enter Correct Input
Search By Event Type (-t type) or District (-d district) or q to quit
q