San Francisco Fire Calls(Python)

Import Notebook

San Francisco Fire Calls

This notebook is the end-to-end example, showing how to use DataFrame and Spark SQL for common data analytics patterns and operations on a San Francisco Fire Department Calls dataset.

!wget -q --show-progress https://github.com/datalaker/data-engineering-shared/raw/main/data/sf-fire-calls.csv.gz -O /tmp/sf-fire-calls.csv.gz
!gunzip -v /tmp/sf-fire-calls.csv.gz
dbutils.fs.mv("file:/tmp/sf-fire-calls.csv", "dbfs:/tmp/sf-fire-calls.csv")
Out[2]: True
%fs ls /tmp/sf-fire-calls.csv
 
path
name
size
modificationTime
1
dbfs:/tmp/sf-fire-calls.csv
sf-fire-calls.csv
44530123
1665836902000

Showing all 1 rows.

from pyspark.sql.types import *
from pyspark.sql.functions import *
 
sf_fire_file = "/tmp/sf-fire-calls.csv"

Inspect the data looks like before defining a schema

%fs head /tmp/sf-fire-calls.csv
[Truncated to first 65536 bytes] CallNumber,UnitID,IncidentNumber,CallType,CallDate,WatchDate,CallFinalDisposition,AvailableDtTm,Address,City,Zipcode,Battalion,StationArea,Box,OriginalPriority,Priority,FinalPriority,ALSUnit,CallTypeGroup,NumAlarms,UnitType,UnitSequenceInCallDispatch,FirePreventionDistrict,SupervisorDistrict,Neighborhood,Location,RowID,Delay 20110016,T13,2003235,Structure Fire,01/11/2002,01/10/2002,Other,01/11/2002 01:51:44 AM,2000 Block of CALIFORNIA ST,SF,94109,B04,38,3362,3,3,3,false,"",1,TRUCK,2,4,5,Pacific Heights,"(37.7895840679362, -122.428071912459)",020110016-T13,2.95 20110022,M17,2003241,Medical Incident,01/11/2002,01/10/2002,Other,01/11/2002 03:01:18 AM,0 Block of SILVERVIEW DR,SF,94124,B10,42,6495,3,3,3,true,"",1,MEDIC,1,10,10,Bayview Hunters Point,"(37.7337623673897, -122.396113802632)",020110022-M17,4.7 20110023,M41,2003242,Medical Incident,01/11/2002,01/10/2002,Other,01/11/2002 02:39:50 AM,MARKET ST/MCALLISTER ST,SF,94102,B03,01,1455,3,3,3,true,"",1,MEDIC,2,3,6,Tenderloin,"(37.7811772186856, -122.411699931232)",020110023-M41,2.4333334 20110032,E11,2003250,Vehicle Fire,01/11/2002,01/10/2002,Other,01/11/2002 04:16:46 AM,APPLETON AV/MISSION ST,SF,94110,B06,32,5626,3,3,3,false,"",1,ENGINE,1,6,9,Bernal Heights,"(37.7388432849018, -122.423948785199)",020110032-E11,1.5 20110043,B04,2003259,Alarms,01/11/2002,01/10/2002,Other,01/11/2002 06:01:58 AM,1400 Block of SUTTER ST,SF,94109,B04,03,3223,3,3,3,false,"",1,CHIEF,2,4,2,Western Addition,"(37.7872890372638, -122.424236212664)",020110043-B04,3.4833333 20110072,T08,2003279,Structure Fire,01/11/2002,01/11/2002,Other,01/11/2002 08:03:26 AM,BEALE ST/FOLSOM ST,SF,94105,B03,35,2122,3,3,3,false,"",1,TRUCK,2,3,6,Financial District/South Beach,"(37.7886866619654, -122.392722833778)",020110072-T08,1.75 20110125,E33,2003301,Alarms,01/11/2002,01/11/2002,Other,01/11/2002 09:46:44 AM,0 Block of FARALLONES ST,SF,94112,B09,33,8324,3,3,3,false,"",1,ENGINE,2,9,11,Oceanview/Merced/Ingleside,"(37.7140353531157, -122.454117149916)",020110125-E33,2.7166667 20110130,E36,2003304,Alarms,01/11/2002,01/11/2002,Other,01/11/2002 09:58:53 AM,600 Block of POLK ST,SF,94102,B02,03,3114,3,3,3,false,"",1,ENGINE,1,2,6,Tenderloin,"(37.7826266328595, -122.41915582123)",020110130-E36,1.7833333 20110197,E05,2003343,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 12:06:57 PM,1500 Block of WEBSTER ST,SF,94115,B04,05,3513,3,3,3,false,"",1,ENGINE,1,4,5,Japantown,"(37.784958590666, -122.431435274503)",020110197-E05,1.5166667 20110215,E06,2003348,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 01:08:40 PM,DIAMOND ST/MARKET ST,SF,94114,B05,06,5415,3,3,3,false,"",1,ENGINE,1,5,8,Castro/Upper Market,"(37.7618954753708, -122.437298717721)",020110215-E06,2.7666667 20110274,M07,2003381,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 03:31:02 PM,2700 Block of MISSION ST,SF,94110,B06,11,5525,1,1,2,true,"",1,MEDIC,1,6,9,Mission,"(37.7530339738059, -122.418588598473)",020110274-M07,2.1833334 20110275,T15,2003382,Structure Fire,01/11/2002,01/11/2002,Other,01/11/2002 02:59:04 PM,BRUNSWICK ST/GUTTENBERG ST,SF,94112,B09,43,6218,3,3,3,false,"",1,TRUCK,1,9,11,Excelsior,"(37.7105545807996, -122.443335369545)",020110275-T15,2.5 20110304,E03,2003399,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 04:22:49 PM,1000 Block of SUTTER ST,SF,94109,B04,03,1557,3,3,3,false,"",1,ENGINE,1,4,3,Nob Hill,"(37.7881263034393, -122.417657214041)",020110304-E03,2.4166667 20110308,E14,2003403,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 04:18:33 PM,100 Block of 21ST AVE,SF,94121,B07,14,7173,3,3,3,false,"",1,ENGINE,1,7,1,Outer Richmond,"(37.7850084431077, -122.480723607753)",020110308-E14,4.95 20110313,B10,2003408,Structure Fire,01/11/2002,01/11/2002,Other,01/11/2002 04:09:08 PM,700 Block of CAPP ST,SF,94110,B06,07,5472,3,3,3,false,"",1,CHIEF,6,6,9,Mission,"(37.7547064357942, -122.417513465479)",020110313-B10,1.4166666 20110313,D3,2003408,Structure Fire,01/11/2002,01/11/2002,Other,01/11/2002 04:09:08 PM,700 Block of CAPP ST,SF,94110,B06,07,5472,3,3,3,false,"",1,CHIEF,4,6,9,Mission,"(37.7547064357942, -122.417513465479)",020110313-D3,2.5333333 20110313,E32,2003408,Structure Fire,01/11/2002,01/11/2002,Other,01/11/2002 04:09:08 PM,700 Block of CAPP ST,SF,94110,B06,07,5472,3,3,3,true,"",1,ENGINE,8,6,9,Mission,"(37.7547064357942, -122.417513465479)",020110313-E32,1.8833333 20110315,RC2,2003409,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 04:34:23 PM,200 Block of LAGUNA HONDA BLVD,SF,94116,B08,20,8635,3,3,3,true,"",1,RESCUE CAPTAIN,2,8,7,West of Twin Peaks,"(37.7501117393668, -122.460819155469)",020110315-RC2,5.35 20110330,E14,2003417,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 04:51:31 PM,BALBOA ST/PARK PRESIDIO BL,SF,94118,B07,31,7145,3,3,3,false,"",1,ENGINE,1,7,1,Inner Richmond,"(37.7768682293368, -122.472039541478)",020110330-E14,2.0 20110330,M12,2003417,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 04:51:12 PM,BALBOA ST/PARK PRESIDIO BL,SF,94118,B07,31,7145,3,3,3,true,"",1,MEDIC,2,7,1,Inner Richmond,"(37.7768682293368, -122.472039541478)",020110330-M12,1.8166667 20110344,T06,2003429,Odor (Strange / Unknown),01/11/2002,01/11/2002,Other,01/11/2002 05:17:15 PM,2300 Block of MARKET ST,SF,94114,B05,06,5233,3,3,3,false,"",1,TRUCK,2,5,8,Castro/Upper Market,"(37.7635007029742, -122.434209629009)",020110344-T06,2.0833333 20110350,M41,2003435,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 05:46:30 PM,500 Block of BROADWAY,SF,94133,B01,02,1311,2,2,2,true,"",1,MEDIC,1,1,3,North Beach,"(37.7980228452184, -122.405863212632)",020110350-M41,4.4666667 20110375,B05,2003453,Alarms,01/11/2002,01/11/2002,Other,01/11/2002 06:48:01 PM,100 Block of JOHNSTONE DR,SF,94131,B05,20,5278,3,3,3,false,"",1,CHIEF,3,5,7,Inner Sunset,"(37.7585821585787, -122.453613744703)",020110375-B05,1.8 20110425,B01,2003497,Structure Fire,01/11/2002,01/11/2002,Other,01/11/2002 09:03:17 PM,600 Block of OFARRELL ST,SF,94109,B04,03,1544,3,3,3,false,"",1,CHIEF,4,4,6,Tenderloin,"(37.7854670505017, -122.415977627827)",020110425-B01,2.5666666 20110428,M28,2003500,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 10:08:48 PM,1000 Block of BATTERY ST,SF,94111,B01,13,1153,3,3,3,true,"",1,MEDIC,2,1,3,Financial District/South Beach,"(37.8006802692983, -122.401542794883)",020110428-M28,3.8833334 20110467,T19,2003529,Medical Incident,01/11/2002,01/11/2002,Other,01/11/2002 10:56:59 PM,3000 Block of 23RD AVE,SF,94132,B08,19,8734,3,3,3,false,"",1,TRUCK,1,8,7,Sunset/Parkside,"(37.7318470441445, -122.479112654493)",020110467-T19,3.3 20120016,E43,2003550,Medical Incident,01/12/2002,01/11/2002,Other,01/12/2002 02:04:06 AM,0 Block of BLYTHDALE AVE,SF,94134,B09,43,6244,3,3,3,true,"",1,ENGINE,2,9,10,Visitacion Valley,"(37.7106587183839, -122.417699843965)",020120016-E43,3.1 20120020,E36,2003554,Structure Fire,01/12/2002,01/11/2002,Other,01/12/2002 01:56:32 AM,9TH ST/HOWARD ST,SF,94103,B02,36,2335,3,3,3,false,"",1,ENGINE,1,2,6,South of Market,"(37.7749917496069, -122.413161109659)",020120020-E36,3.3333333 20120044,M10,2003576,Medical Incident,01/12/2002,01/11/2002,Other,01/12/2002 04:17:22 AM,3800 Block of GEARY BLVD,SF,94118,B07,31,7113,3,3,3,true,"",1,MEDIC,2,7,1,Inner Richmond,"(37.7813145272908, -122.460540716843)",020120044-M10,3.9666667 20120045,E21,2003577,Medical Incident,01/12/2002,01/11/2002,Other,01/12/2002 04:23:31 AM,300 Block of BAKER ST,SF,94117,B05,21,4252,3,3,3,false,"",1,ENGINE,1,5,5,Lone Mountain/USF,"(37.7740926787047, -122.44108442597)",020120045-E21,3.25 20120052,M36,2003584,Medical Incident,01/12/2002,01/11/2002,Other,01/12/2002 06:27:31 AM,400 Block of VALENCIA ST,SF,94103,B02,06,5226,3,3,3,true,"",1,MEDIC,2,2,9,Mission,"(37.7661343875141, -122.421935077177)",020120052-M36,4.2833333 20120061,M10,2003593,Medical Incident,01/12/2002,01/11/2002,Other,"",0 Block of TERRA VISTA AVE,SF,94115,B05,21,4256,3,3,3,true,"",1,MEDIC,1,5,2,Lone Mountain/USF,"(37.7814248717141, -122.441695636568)",020120061-M10,2.3 20120111,E18,2003618,Odor (Strange / Unknown),01/12/2002,01/12/2002,Other,01/12/2002 11:07:36 AM,2000 Block of 34TH AVE,SF,94116,B08,18,7556,3,3,3,false,"",1,ENGINE,2,8,4,Sunset/Parkside,"(37.7488650921071, -122.492289492253)",020120111-E18,2.8 20120127,M38,2003630,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 11:28:40 AM,LAGUNA ST/WASHINGTON ST,SF,94109,B04,38,3361,3,3,3,true,"",1,MEDIC,1,4,2,Pacific Heights,"(37.7922168970615, -122.429447193304)",020120127-M38,2.3833334 20120142,E07,2003639,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 12:15:25 PM,600 Block of SOUTH VAN NESS AVE,SF,94110,B02,07,5246,3,3,3,false,"",1,ENGINE,1,2,9,Mission,"(37.7627737268131, -122.417186682545)",020120142-E07,2.45 20120147,M38,2003642,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 01:23:04 PM,1300 Block of HYDE ST,SF,94109,B01,41,1564,1,1,2,true,"",1,MEDIC,1,1,3,Russian Hill,"(37.793235074749, -122.417915793747)",020120147-M38,6.25 20120149,M01,2003643,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 01:05:52 PM,16TH ST/MISSION ST,SF,94103,B02,07,5236,1,1,2,true,"",1,MEDIC,1,2,9,Mission,"(37.7650513381945, -122.419668973861)",020120149-M01,3.6166666 20120153,M41,2003647,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 02:20:25 PM,500 Block of 30TH AVE,SF,94121,B07,14,0722,3,3,3,true,"",1,MEDIC,2,7,1,Outer Richmond,"(37.7788847355525, -122.48995472763)",020120153-M41,4.65 20120155,B08,2003649,Odor (Strange / Unknown),01/12/2002,01/12/2002,Other,01/12/2002 01:03:10 PM,1500 Block of 5TH AVE,SF,94122,B08,12,7328,3,3,3,false,"",1,CHIEF,3,8,7,Inner Sunset,"(37.7598374406709, -122.46094294867)",020120155-B08,4.1833334 20120166,E01,2003656,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 01:22:58 PM,4TH ST/MISSION ST,SF,94103,B03,01,2213,3,3,3,false,"",1,ENGINE,1,3,6,South of Market,"(37.7844787439707, -122.404266872501)",020120166-E01,1.95 20120210,E44,2003688,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 04:25:35 PM,0 Block of AQUAVISTA WAY,SF,94131,B09,20,5362,3,3,3,true,"",1,ENGINE,1,8,7,Twin Peaks,"(37.752557468944, -122.449351606127)",020120210-E44,3.55 20120217,M03,2003695,Structure Fire,01/12/2002,01/12/2002,Other,01/12/2002 04:46:59 PM,400 Block of TURK ST,SF,94102,B02,03,1554,3,3,3,true,"",1,MEDIC,3,2,6,Tenderloin,"(37.7825569563078, -122.416349428183)",020120217-M03,1.5666667 20120254,M17,2003724,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 07:15:23 PM,0 Block of REARDON RD,SF,94124,B10,17,6625,3,3,3,true,"",1,MEDIC,2,10,10,Bayview Hunters Point,"(37.7294407135003, -122.377026608239)",020120254-M17,2.7833333 20120268,M07,2003735,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 07:26:52 PM,1800 Block of SILLIMAN ST,SF,94134,B09,43,6153,3,3,3,true,"",1,MEDIC,2,9,9,Excelsior,"(37.7264150130988, -122.423317090957)",020120268-M07,4.5333333 20120295,B05,2003756,Alarms,01/12/2002,01/12/2002,Other,01/12/2002 07:54:42 PM,500 Block of STEINER ST,SF,94117,B05,21,3632,3,3,3,false,"",1,CHIEF,2,5,5,Hayes Valley,"(37.7742331365027, -122.432492947831)",020120295-B05,2.0833333 20120309,M05,2003769,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 09:14:35 PM,OAK ST/WEBSTER ST,SF,94102,B02,05,3523,3,3,3,true,"",1,MEDIC,2,2,5,Hayes Valley,"(37.774181421555, -122.429178343494)",020120309-M05,1.25 20120311,E07,2003770,Smoke Investigation (Outside),01/12/2002,01/12/2002,Other,01/12/2002 08:44:01 PM,900 Block of SHOTWELL ST,SF,94110,B06,07,0544,3,3,3,false,"",1,ENGINE,1,6,9,Mission,"(37.7532406253685, -122.415177223195)",020120311-E07,2.1166666 20120322,D2,2003777,Structure Fire,01/12/2002,01/12/2002,Other,01/12/2002 09:14:13 PM,0 Block of JONES ST,SF,94102,B03,01,1455,3,3,3,false,"",1,CHIEF,6,2,6,Tenderloin,"(37.7815955871561, -122.412190669917)",020120322-D2,1.9333333 20120350,E03,2003800,Medical Incident,01/12/2002,01/12/2002,Other,01/12/2002 11:19:49 PM,400 Block of EDDY ST,SF,94102,B02,03,1545,3,3,3,false,"",1,ENGINE,2,2,6,Tenderloin,"(37.7835654755497, -122.415051136249)",020120350-E03,3.1666667 20130009,E37,2003814,Medical Incident,01/13/2002,01/12/2002,Other,01/13/2002 01:05:26 AM,1000 Block of DE HARO ST,SF,94107,B10,37,2561,3,3,3,true,"",1,ENGINE,1,10,10,Potrero Hill,"(37.7559025882179, -122.400816594989)",020130009-E37,4.766667 20130010,E18,2003815,Medical Incident,01/13/2002,01/12/2002,Other,01/13/2002 01:08:57 AM,2700 Block of 38TH AVE,SF,94116,B08,18,7616,3,3,3,false,"",1,ENGINE,2,8,4,Sunset/Parkside,"(37.7356360325796, -122.495526420481)",020130010-E18,3.45 20130013,M03,2003818,Medical Incident,01/13/2002,01/12/2002,Other,01/13/2002 01:51:15 AM,800 Block of LARKIN ST,SF,94109,B04,03,1642,2,2,2,true,"",1,MEDIC,1,4,6,Tenderloin,"(37.7858627664608, -122.418110537872)",020130013-M03,5.2 20130040,E35,2003843,Medical Incident,01/13/2002,01/12/2002,Other,01/13/2002 03:35:33 AM,500 Block of HARRISON ST,SF,94105,B03,35,2136,3,3,3,false,"",1,ENGINE,1,3,6,Financial District/South Beach,"(37.7855694880471, -122.393469162416)",020130040-E35,3.5333333 20130045,RS1,2003848,Medical Incident,01/13/2002,01/12/2002,Other,01/13/2002 03:56:48 AM,300 Block of CLEMENTINA ST,SF,94103,B03,01,2215,3,3,3,false,"",1,RESCUE SQUAD,2,3,6,South of Market,"(37.7820387146172, -122.40232147638)",020130045-RS1,4.6666665 20130086,T11,2003876,Medical Incident,01/13/2002,01/13/2002,Other,01/13/2002 08:35:01 AM,2900 Block of MISSION ST,SF,94110,B06,11,5613,3,3,3,true,"",1,TRUCK,2,6,9,Mission,"(37.7498446220826, -122.418142583283)",020130086-T11,1.55 20130095,M43,2003880,Medical Incident,01/13/2002,01/13/2002,Other,01/13/2002 10:01:39 AM,0 Block of NAPLES ST,SF,94112,B09,32,6143,3,3,3,true,"",1,MEDIC,2,9,11,Excelsior,"(37.7278485543492, -122.425837521286)",020130095-M43,1.4666667 20130106,RS2,2003887,Structure Fire,01/13/2002,01/13/2002,Other,01/13/2002 09:38:41 AM,22ND ST/CHURCH ST,SF,94114,B06,11,5467,3,3,3,false,"",1,RESCUE SQUAD,8,6,8,Noe Valley,"(37.7548967204015, -122.427735561494)",020130106-RS2,3.05 20130142,E08,2003916,Other,01/13/2002,01/13/2002,Other,01/13/2002 12:34:42 PM,800 Block of HARRISON ST,SF,94107,B03,08,2243,3,3,3,false,"",1,ENGINE,1,3,6,South of Market,"(37.7799507434806, -122.400778586916)",020130142-E08,4.9333334 20130149,B01,2003922,Alarms,01/13/2002,01/13/2002,Other,01/13/2002 12:39:23 PM,400 Block of LEAVENWORTH ST,SF,94109,B04,03,1544,3,3,3,false,"",1,CHIEF,2,2,6,Tenderloin,"(37.7851111081788, -122.414592038343)",020130149-B01,1.8 20130154,E03,2003926,Alarms,01/13/2002,01/13/2002,Other,01/13/2002 01:01:31 PM,400 Block of LEAVENWORTH ST,SF,94109,B04,03,1544,3,3,3,false,"",1,ENGINE,1,2,6,Tenderloin,"(37.7851111081788, -122.414592038343)",020130154-E03,3.0166667 20130204,T05,2003962,Alarms,01/13/2002,01/13/2002,Other,01/13/2002 02:42:42 PM,500 Block of OAK ST,SF,94102,B02,05,3523,3,3,3,false,"",1,TRUCK,2,2,5,Hayes Valley,"(37.7742307091945, -122.428351459261)",020130204-T05,1.9833333 20130208,M17,2003965,Medical Incident,01/13/2002,01/13/2002,Other,01/13/2002 03:22:02 PM,BOYLSTON ST/HALE ST,SF,94134,B10,42,6365,3,3,3,true,"",1,MEDIC,3,9,9,Portola,"(37.7314787762164, -122.410756537883)",020130208-M17,1.7 20130210,M28,2003967,Medical Incident,01/13/2002,01/13/2002,Other,01/13/2002 03:07:57 PM,700 Block of BROADWAY,SF,94133,B01,02,1353,3,3,3,true,"",1,MEDIC,2,1,3,Chinatown,"(37.7976146082072, -122.409164766852)",020130210-M28,2.5 20130223,T01,2003979,Alarms,01/13/2002,01/13/2002,Other,01/13/2002 03:39:49 PM,700 Block of MARKET ST,SF,94103,B03,01,2211,3,3,3,false,"",1,TRUCK,3,3,6,Financial District/South Beach,"(37.7871160984672, -122.403919148357)",020130223-T01,2.3333333 20130252,M36,2004003,Medical Incident,01/13/2002,01/13/2002,Other,01/13/2002 04:50:08 PM,HAIGHT ST/OCTAVIA ST,SF,94102,B02,36,3313,3,3,3,true,"",1,MEDIC,2,2,5,Hayes Valley,"(37.772957392567, -122.423758380219)",020130252-M36,1.8 20130255,M07,2004006,Medical Incident,01/13/2002,01/13/2002,Other,01/13/2002 05:13:24 PM,24TH ST/ALABAMA ST,SF,94110,B06,07,5527,3,3,3,true,"",1,MEDIC,1,6,9,Mission,"(37.7526848900219, -122.410962662832)",020130255-M07,1.8 20130258,RC4,2004009,Medical Incident,01/13/2002,01/13/2002,Other,01/13/2002 05:16:07 PM,200 Block of CRESTA VISTA DR,SF,94127,B09,39,8256,E,E,3,true,"",1,RESCUE CAPTAIN,4,9,7,West of Twin Peaks,"(37.735631914703, -122.454282422725)",020130258-RC4,3.1 20130330,B08,2004070,Structure Fire,01/13/2002,01/13/2002,Other,01/13/2002 09:10:07 PM,6300 Block of CALIFORNIA ST,SF,94121,B07,14,7214,3,3,3,false,"",1,CHIEF,7,7,1,Outer Richmond,"(37.7838030202773, -122.485545885783)",020130330-B08,4.55 20130330,T14,2004070,Structure Fire,01/13/2002,01/13/2002,Other,01/13/2002 09:22:34 PM,6300 Block of CALIFORNIA ST,SF,94121,B07,14,7214,3,3,3,false,"",1,TRUCK,4,7,1,Outer Richmond,"(37.7838030202773, -122.485545885783)",020130330-T14,2.8666666 20130331,T11,2004071,Medical Incident,01/13/2002,01/13/2002,Other,01/13/2002 09:23:49 PM,900 Block of DIAMOND ST,SF,94114,B06,24,5521,3,3,3,true,"",1,TRUCK,1,6,8,Noe Valley,"(37.7499583474478, -122.436241579612)",020130331-T11,3.3333333 20130352,B05,2004089,Alarms,01/13/2002,01/13/2002,Other,01/13/2002 11:00:13 PM,1800 Block of GOLDEN GATE AVE,SF,94115,B05,21,4242,3,3,3,false,"",1,CHIEF,2,5,5,Western Addition,"(37.7783512875178, -122.44102844941)",020130352-B05,1.7333333 20130354,E14,2004091,Outside Fire,01/13/2002,01/13/2002,Other,01/13/2002 11:16:07 PM,28TH AV/BALBOA ST,SF,94121,B07,14,7225,3,3,3,false,"",1,ENGINE,1,7,1,Outer Richmond,"(37.7761552340808, -122.487669439804)",020130354-E14,1.2166667 20140010,E33,2004108,Medical Incident,01/14/2002,01/13/2002,Other,01/14/2002 01:32:59 AM,500 Block of GARFIELD ST,SF,94132,B09,33,8432,3,3,3,false,"",1,ENGINE,1,9,11,Oceanview/Merced/Ingleside,"(37.7197236320858, -122.467603096548)",020140010-E33,3.6333334 20140023,M38,2004119,Medical Incident,01/14/2002,01/13/2002,Other,01/14/2002 03:42:52 AM,1200 Block of FILLMORE ST,SF,94115,B05,05,3535,3,3,3,true,"",1,MEDIC,2,5,5,Western Addition,"(37.7809710233586, -122.432166356881)",020140023-M38,3.9166667 20140065,E02,2004151,Medical Incident,01/14/2002,01/13/2002,Other,01/14/2002 08:09:18 AM,BROADWAY/COLUMBUS AV,SF,94133,B01,02,1311,3,3,3,false,"",1,ENGINE,1,1,3,Chinatown,"(37.7978646128064, -122.406667932419)",020140065-E02,3.2666667 20140067,T19,2004152,Citizen Assist / Service Call,01/14/2002,01/14/2002,Other,01/14/2002 08:16:54 AM,2900 Block of 22ND AVE,SF,94132,B08,19,8732,3,3,3,false,"",1,TRUCK,1,8,7,Sunset/Parkside,"(37.7335645188552, -122.477843526592)",020140067-T19,5.6 20140082,T10,2004160,Structure Fire,01/14/2002,01/14/2002,Other,01/14/2002 08:47:46 AM,BEATRICE LN/ESPANOLA ST,SF,94124,B10,17,6641,3,3,3,false,"",1,TRUCK,2,10,10,Bayview Hunters Point,"(37.7309011761712, -122.380149049067)",020140082-T10,1.1666666 20140085,M36,2004161,Medical Incident,01/14/2002,01/14/2002,Other,01/14/2002 10:16:50 AM,600 Block of SOUTH VAN NESS AVE,SF,94110,B02,07,5246,3,3,3,true,"",1,MEDIC,1,2,9,Mission,"(37.7627737268131, -122.417186682545)",020140085-M36,2.85 20140089,E06,2004162,Medical Incident,01/14/2002,01/14/2002,Other,01/14/2002 09:13:47 AM,100 Block of JULIAN AVE,SF,94103,B02,06,5226,3,3,3,false,"",1,ENGINE,1,2,9,Mission,"(37.7657838960434, -122.421047942224)",020140089-E06,2.3166666 20140125,M41,2004181,Medical Incident,01/14/2002,01/14/2002,Other,01/14/2002 11:14:38 AM,400 Block of GREEN ST,SF,94133,B01,28,1266,3,3,3,true,"",1,MEDIC,2,1,3,North Beach,"(37.7997732125206, -122.406404327326)",020140125-M41,2.7333333 20140170,T01,2004214,Alarms,01/14/2002,01/14/2002,Other,01/14/2002 12:17:13 PM,600 Block of MISSION ST,SF,94105,B03,01,2178,3,3,3,false,"",1,TRUCK,1,3,6,Financial District/South Beach,"(37.7865888590763, -122.401692292616)",020140170-T01,2.0 20140177,E35,2004216,Medical Incident,01/14/2002,01/14/2002,Other,01/14/2002 12:26:19 PM,MONTGOMERY ST/SUTTER ST,SF,94104,B01,13,1164,3,3,3,false,"",1,ENGINE,3,1,3,Financial District/South Beach,"(37.7900390948551, -122.40218964437)",020140177-E35,2.8 20140177,RS1,2004216,Medical Incident,01/14/2002,01/14/2002,Other,01/14/2002 12:27:03 PM,MONTGOMERY ST/SUTTER ST,SF,94104,B01,13,1164,3,3,3,false,"",1,RESCUE SQUAD,2,1,3,Financial District/South Beach,"(37.7900390948551, -122.40218964437)",020140177-RS1,7.25 20140180,E33,2004218,Structure Fire,01/14/2002,01/14/2002,Other,01/14/2002 12:38:50 PM,MISSION ST/SICKLES AV,SF,94112,B09,33,6213,3,3,3,false,"",1,ENGINE,1,9,11,Outer Mission,"(37.7088063383308, -122.452664722246)",020140180-E33,1.3166667 20140209,T13,2004233,Alarms,01/14/2002,01/14/2002,Other,01/14/2002 01:52:42 PM,2300 Block of FILLMORE ST,SF,94115,B04,38,3545,3,3,3,true,"",1,TRUCK,3,4,2,Pacific Heights,"(37.791142743319, -122.434360166236)",020140209-T13,2.8833334 20140216,E22,2004238,Structure Fire,01/14/2002,01/14/2002,Other,01/14/2002 02:39:09 PM,1500 Block of 26TH AVE,SF,94122,B08,18,7475,3,3,3,true,"",1,ENGINE,1,8,4,Sunset/Parkside,"(37.7585658388793, -122.48436889714)",020140216-E22,2.3 20140253,E36,2004265,Structure Fire,01/14/2002,01/14/2002,Other,01/14/2002 04:37:18 PM,0 Block of LARKIN ST,SF,94102,B02,36,1646,3,3,3,false,"",1,ENGINE,1,2,6,Tenderloin,"(37.7775888205813, -122.416411092393)",020140253-E36,1.8166667 20140254,M01,2004266,Medical Incident,01/14/2002,01/14/2002,Other,01/14/2002 05:13:49 PM,100 Block of TURK ST,SF,94102,B03,01,1456,3,3,3,true,"",1,MEDIC,2,3,6,Tenderloin,"(37.7830549681708, -122.411577299279)",020140254-M01,3.5166667 20140276,M36,2004286,Medical Incident,01/14/2002,01/14/2002,Other,01/14/2002 05:34:32 PM,CALL BOX: BUCHANAN ST/GROVE ST,SF,94102,B02,05,3424,2,2,2,true,"",1,MEDIC,1,2,5,Hayes Valley,"(37.7772298314861, -122.428128039144)",020140276-M36,4.5333333 20140291,E43,2004297,Electrical Hazard,01/14/2002,01/14/2002,Other,01/14/2002 05:42:50 PM,900 Block of PRAGUE ST,SF,94112,B09,43,0622,3,3,3,true,"",1,ENGINE,1,9,11,Excelsior,"(37.7100115797557, -122.435814381727)",020140291-E43,2.0666666 20140297,E07,2004303,Structure Fire,01/14/2002,01/14/2002,Other,01/14/2002 05:54:19 PM,22ND ST/MISSION ST,SF,94110,B06,07,5472,3,3,3,false,"",1,ENGINE,1,6,9,Mission,"(37.7554369366673, -122.41874757536)",020140297-E07,0.81666666 20140306,E34,2004308,Medical Incident,01/14/2002,01/14/2002,Other,01/14/2002 06:34:26 PM,800 Block of LA PLAYA,SF,94121,B07,34,7311,3,3,3,false,"",1,ENGINE,1,7,1,Outer Richmond,"(37.7723244294895, -122.510034921211)",020140306-E34,4.2833333 20140352,M07,2004340,Medical Incident,01/14/2002,01/14/2002,Other,01/14/2002 09:31:53 PM,24TH ST/POTRERO AV,SF,94110,B10,37,2554,3,3,3,true,"",1,MEDIC,1,10,9,Mission,"(37.7530040313925, -122.406336240587)",020140352-M07,1.5166667 20140364,M07,2004350,Medical Incident,01/14/2002,01/14/2002,Other,01/14/2002 10:37:55 PM,2700 Block of 16TH ST,SF,94110,B02,07,5237,3,3,3,true,"",1,MEDIC,1,2,9,Mission,"(37.7653263612606, -122.414201573327)",020140364-M07,2.1666667 20150001,M36,2004368,Medical Incident,01/15/2002,01/14/2002,Other,01/15/2002 12:30:37 AM,DUBOCE AV/NOE ST,SF,94114,B05,06,5131,3,3,3,true,"",1,MEDIC,1,5,8,Haight Ashbury,"(37.7691783700971, -122.433572207997)",020150001-M36,2.9833333 20150004,94,2004370,Medical Incident,01/15/2002,01/14/2002,Other,01/15/2002 01:26:45 AM,5TH ST/MARKET ST,SF,94103,B03,01,1364,1,1,2,true,"",1,MEDIC,1,3,6,South of Market,"(37.7839914857614, -122.408066547804)",020150004-94,1.25 20150048,RC2,2004404,Structure Fire,01/15/2002,01/14/2002,Other,01/15/2002 06:31:24 AM,700 Block of 35TH AVE,SF,94121,B07,34,7252,3,3,3,true,"",1,RESCUE CAPTAIN,10,7,1,Outer Richmond,"(37.7748832270511, -122.495037870754)",020150048-RC2,3.5333333 20150048,RS1,2004404,Structure Fire,01/15/2002,01/14/2002,Other,01/15/2002 06:31:24 AM,700 Block of 35TH AVE,SF,94121,B07,34,7252,3,3,3,false,"",1,RESCUE SQUAD,11,7,1,Outer Richmond,"(37.7748832270511, -122.495037870754)",020150048-RS1,1.9333333 20150056,E35,2004408,Medical Incident,01/15/2002,01/14/2002,Other,01/15/2002 06:53:38 AM,100 Block of 7TH ST,SF,94103,B03,08,2312,3,3,3,false,"",1,ENGINE,2,3,6,South of Market,"(37.7790372933741, -122.41062000696)",020150056-E35,11.916667 20150062,B01,2004412,Alarms,01/15/2002,01/14/2002,Other,01/15/2002 07:21:10 AM,100 Block of FRANCISCO ST,SF,94133,B01,28,1225,3,3,3,false,"",1,CHIEF,2,1,3,North Beach,"(37.8054738067872, -122.407570127181)",020150062-B01,1.8833333 20150075,94,2004418,Medical Incident,01/15/2002,01/15/2002,Other,01/15/2002 09:19:38 AM,DAVIS ST/SACRAMENTO ST,SF,94111,B01,13,1133,3,3,3,true,"",1,MEDIC,1,1,3,Financial District/South Beach,"(37.7944340060268, -122.397796258543)",020150075-94,1.95 20150117,E03,2004430,Odor (Strange / Unknown),01/15/2002,01/15/2002,Other,01/15/2002 09:40:37 AM,700 Block of VAN NESS AVE,SF,94102,B02,03,3163,3,3,3,true,"",1,ENGINE,1,2,6,Tenderloin,"(37.7824440383404, -122.420574545604)",020150117-E03,1.2666667 20150118,M03,2004431,Medical Incident,01/15/2002,01/15/2002,Other,01/15/2002 10:24:17 AM,300 Block of EDDY ST,SF,94102,B02,03,1545,3,3,3,true,"",1,MEDIC,1,2,6,Tenderloin,"(37.78373004094, -122.413753670487)",020150118-M03,2.2 20150164,M17,2004458,Medical Incident,01/15/2002,01/15/2002,Other,01/15/2002 12:15:07 PM,1700 Block of YOSEMITE AVE,SF,94124,B10,17,6512,3,3,3,true,"",1,MEDIC,2,10,10,Bayview Hunters Point,"(37.7284996658469, -122.39444320706)",020150164-M17,1.9166666 *** WARNING: skipped 15644 bytes of output *** 20190010,E21,2005552,Structure Fire,01/19/2002,01/18/2002,Other,01/19/2002 01:16:44 AM,HAIGHT ST/SCOTT ST,SF,94117,B05,21,4142,3,3,3,false,"",1,ENGINE,1,5,5,Haight Ashbury,"(37.7714794846228, -122.435372980594)",020190010-E21,3.0166667 20190012,T03,2005554,Structure Fire,01/19/2002,01/18/2002,Other,01/19/2002 01:31:44 AM,HYDE ST/PINE ST,SF,94109,B04,41,1562,3,3,3,false,"",1,TRUCK,2,4,3,Nob Hill,"(37.7900451404237, -122.417204800959)",020190012-T03,2.7666667 20190027,E21,2005569,Structure Fire,01/19/2002,01/18/2002,Other,01/19/2002 02:21:52 AM,1500 Block of SUTTER ST,SF,94109,B04,38,3324,3,3,3,false,"",1,ENGINE,4,4,5,Japantown,"(37.7869733159879, -122.425845942974)",020190027-E21,4.45 20190032,M36,2005574,Medical Incident,01/19/2002,01/18/2002,Other,01/19/2002 02:45:20 AM,FOLSOM ST/NORFOLK ST,SF,94103,B02,36,5121,1,1,2,true,"",1,MEDIC,1,2,6,Mission,"(37.7714046505588, -122.414526089287)",020190032-M36,3.7666667 20190044,E31,2005584,Smoke Investigation (Outside),01/19/2002,01/18/2002,Other,01/19/2002 03:44:43 AM,500 Block of BALBOA ST,SF,94118,B07,31,7123,3,3,3,false,"",1,ENGINE,1,7,1,Inner Richmond,"(37.7772648752234, -122.464543600448)",020190044-E31,2.6166666 20190062,E14,2005599,Medical Incident,01/19/2002,01/18/2002,Other,01/19/2002 06:14:56 AM,400 Block of 20TH AVE,SF,94121,B07,14,7172,3,3,3,false,"",1,ENGINE,2,7,1,Outer Richmond,"(37.7793747233139, -122.479242794814)",020190062-E14,5.15 20190097,RS1,2005623,Structure Fire,01/19/2002,01/19/2002,Other,01/19/2002 10:50:41 AM,100 Block of 2ND ST,SF,94105,B03,01,2146,3,3,3,true,"",1,RESCUE SQUAD,2,3,6,Financial District/South Beach,"(37.787352867216, -122.399071684966)",020190097-RS1,13.583333 20190174,E28,2005674,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 12:46:48 PM,0 Block of VALPARAISO ST,SF,94133,B01,28,1423,3,3,3,false,"",1,ENGINE,1,1,3,Russian Hill,"(37.8013817875401, -122.413586887199)",020190174-E28,1.9666667 20190186,E37,2005685,Citizen Assist / Service Call,01/19/2002,01/19/2002,Other,01/19/2002 01:06:21 PM,0 Block of SOUTHERN HEIGHTS AVE,SF,94107,B10,37,2544,3,3,3,false,"",1,ENGINE,1,10,10,Potrero Hill,"(37.7579182258081, -122.400359378447)",020190186-E37,3.6333334 20190200,E22,2005693,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 01:30:27 PM,1200 Block of 21ST AVE,SF,94122,B08,22,7425,3,3,3,true,"",1,ENGINE,1,8,4,Sunset/Parkside,"(37.7644061550986, -122.479401555026)",020190200-E22,3.5166667 20190211,M29,2005700,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 01:45:31 PM,CESAR CHAVEZ ST/FLORIDA ST,SF,94110,B06,09,5621,3,3,3,true,"",1,MEDIC,1,6,9,Mission,"(37.7483343921069, -122.40964638878)",020190211-M29,1.65 20190231,M03,2005716,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 02:59:53 PM,1000 Block of POLK ST,SF,94109,B04,03,3121,3,3,3,true,"",1,MEDIC,1,4,6,Tenderloin,"(37.7861172118379, -122.419854245692)",020190231-M03,3.55 20190242,E03,2005722,Structure Fire,01/19/2002,01/19/2002,Other,01/19/2002 03:15:40 PM,EDDY ST/LEAVENWORTH ST,SF,94102,B02,03,1545,3,3,3,false,"",1,ENGINE,1,2,6,Tenderloin,"(37.7837237829964, -122.414241575227)",020190242-E03,0.8 20190255,E02,2005734,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 04:09:23 PM,1400 Block of POWELL ST,SF,94133,B01,02,1353,3,3,3,false,"",1,ENGINE,1,1,3,Chinatown,"(37.7979051468547, -122.410291496741)",020190255-E02,3.45 20190256,M10,2005737,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 04:39:13 PM,3300 Block of CALIFORNIA ST,SF,94118,B04,10,4421,1,1,2,false,"",1,MEDIC,1,4,2,Presidio Heights,"(37.7869977461494, -122.449304455831)",020190256-M10,6.5333333 20190259,M08,2005740,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 05:21:15 PM,900 Block of ILLINOIS ST,SF,94107,B10,37,2665,3,3,3,true,"",1,MEDIC,2,10,10,Potrero Hill,"(37.7592707238905, -122.387509703036)",020190259-M08,5.25 20190276,M05,2005753,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 05:22:51 PM,0 Block of FELL ST,SF,94102,B02,36,3111,1,1,2,true,"",1,MEDIC,1,2,6,Tenderloin,"(37.7764405100838, -122.418481123408)",020190276-M05,5.0333333 20190282,E05,2005758,Outside Fire,01/19/2002,01/19/2002,Other,01/19/2002 05:23:25 PM,800 Block of BUCHANAN ST,SF,94102,B02,05,3424,3,3,3,false,"",1,ENGINE,1,2,5,Hayes Valley,"(37.777656834818, -122.428127179839)",020190282-E05,0.8666667 20190318,E36,2005780,Structure Fire,01/19/2002,01/19/2002,Other,01/19/2002 07:27:19 PM,0 Block of LARKIN ST,SF,94102,B02,36,1646,3,3,3,false,"",1,ENGINE,1,2,6,Tenderloin,"(37.7775888205813, -122.416411092393)",020190318-E36,0.93333334 20190334,E03,2005795,Structure Fire,01/19/2002,01/19/2002,Other,01/19/2002 08:37:53 PM,EDDY ST/LEAVENWORTH ST,SF,94102,B02,03,1545,3,3,3,false,"",1,ENGINE,1,2,6,Tenderloin,"(37.7837237829964, -122.414241575227)",020190334-E03,1.5333333 20190339,M10,2005800,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 09:02:22 PM,DIVISADERO ST/LOMBARD ST,SF,94123,B04,16,4223,3,3,3,false,"",1,MEDIC,2,4,2,Marina,"(37.7990000491389, -122.442647897011)",020190339-M10,1.75 20190343,M10,2005804,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 10:39:02 PM,3800 Block of JACKSON ST,SF,94118,B07,10,4443,3,3,3,false,"",1,MEDIC,1,7,2,Presidio Heights,"(37.7894851681319, -122.458443263209)",020190343-M10,1.9666667 20190349,M12,2005809,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 11:04:19 PM,200 Block of JUANITA WAY,SF,94127,B09,39,8672,3,3,3,true,"",1,MEDIC,2,9,7,West of Twin Peaks,"(37.7395810341573, -122.457730792716)",020190349-M12,1.6 20190363,M29,2005821,Medical Incident,01/19/2002,01/19/2002,Other,01/19/2002 10:56:38 PM,24TH ST/FOLSOM ST,SF,94110,B06,07,5526,2,2,2,true,"",1,MEDIC,1,6,9,Mission,"(37.7525060662321, -122.414086032423)",020190363-M29,3.0666666 20200031,E26,2005863,Alarms,01/20/2002,01/19/2002,Other,01/20/2002 02:44:12 AM,0 Block of MATEO ST,SF,94131,B06,26,8127,3,3,3,false,"",1,ENGINE,1,6,8,Glen Park,"(37.7371489789891, -122.429851654373)",020200031-E26,2.9166667 20200037,E08,2005869,Medical Incident,01/20/2002,01/19/2002,Other,01/20/2002 03:16:51 AM,100 Block of TOWNSEND ST,SF,94107,B03,08,2172,3,3,3,false,"",1,ENGINE,1,3,6,Mission Bay,"(37.7796910137658, -122.391588816975)",020200037-E08,3.4 20200046,M29,2005874,Medical Incident,01/20/2002,01/19/2002,Other,01/20/2002 04:17:35 AM,3200 Block of 26TH ST,SF,94110,B06,11,5613,1,1,2,true,"",1,MEDIC,1,6,9,Mission,"(37.7491990535295, -122.414593171104)",020200046-M29,2.8833334 20200060,M01,2005887,Medical Incident,01/20/2002,01/19/2002,Other,01/20/2002 05:34:54 AM,200 Block of EDDY ST,SF,94102,B03,01,1453,3,3,3,true,"",1,MEDIC,2,3,6,Tenderloin,"(37.7839825587491, -122.411762530716)",020200060-M01,2.3333333 20200093,B09,2005912,Structure Fire,01/20/2002,01/20/2002,Other,01/20/2002 09:38:37 AM,CLAREMONT BL/ULLOA ST,SF,94127,B08,39,8573,3,3,3,false,"",1,CHIEF,6,8,7,West of Twin Peaks,"(37.7406508984156, -122.465036130555)",020200093-B09,1.7666667 20200093,E20,2005912,Structure Fire,01/20/2002,01/20/2002,Other,01/20/2002 09:34:08 AM,CLAREMONT BL/ULLOA ST,SF,94127,B08,39,8573,3,3,3,false,"",1,ENGINE,8,8,7,West of Twin Peaks,"(37.7406508984156, -122.465036130555)",020200093-E20,2.2833333 20200105,E29,2005923,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 10:22:11 AM,16TH ST/HARRISON ST,SF,94110,B02,29,5217,3,3,3,true,"",1,ENGINE,2,2,9,Mission,"(37.7654476102712, -122.413105244954)",020200105-E29,3.0166667 20200111,E22,2005928,Structure Fire,01/20/2002,01/20/2002,Other,01/20/2002 10:42:07 AM,17TH AV/JUDAH ST,SF,94122,B08,22,7371,3,3,3,false,"",1,ENGINE,1,8,5,Inner Sunset,"(37.7617941453273, -122.47485493193)",020200111-E22,0.85 20200115,B03,2005932,Structure Fire,01/20/2002,01/20/2002,Other,01/20/2002 11:10:22 AM,1000 Block of MINNESOTA ST,SF,94107,B10,37,2535,3,3,3,false,"",1,CHIEF,4,10,10,Potrero Hill,"(37.7575682943289, -122.390114015913)",020200115-B03,2.2833333 20200135,E07,2005948,Structure Fire,01/20/2002,01/20/2002,Other,01/20/2002 12:12:28 PM,22ND ST/MISSION ST,SF,94110,B06,07,5472,3,3,3,false,"",1,ENGINE,1,6,9,Mission,"(37.7554369366673, -122.41874757536)",020200135-E07,2.0 20200156,E01,2005967,Structure Fire,01/20/2002,01/20/2002,Other,01/20/2002 01:20:40 PM,7TH ST/FOLSOM ST,SF,94103,B03,01,2313,3,3,3,false,"",1,ENGINE,1,2,6,South of Market,"(37.7767461078644, -122.407842061292)",020200156-E01,3.3 20200168,E37,2005974,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 02:14:39 PM,0 Block of SOUTHERN HEIGHTS AVE,SF,94107,B10,37,2544,3,3,3,false,"",1,ENGINE,1,10,10,Potrero Hill,"(37.7579182258081, -122.400359378447)",020200168-E37,2.0 20200201,M38,2005997,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 03:46:53 PM,400 Block of EDDY ST,SF,94109,B02,03,1545,3,3,3,true,"",1,MEDIC,2,2,6,Tenderloin,"(37.7836739523567, -122.415072980803)",020200201-M38,4.5833335 20200208,E22,2006003,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 04:25:10 PM,1400 Block of 6TH AVE,SF,94122,B08,22,7331,3,3,3,false,"",1,ENGINE,1,8,5,Inner Sunset,"(37.7613809736145, -122.462976036817)",020200208-E22,2.05 20200213,M36,2006007,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 05:37:55 PM,1800 Block of 15TH ST,SF,94103,B02,06,5227,3,3,3,true,"",1,MEDIC,2,2,8,Mission,"(37.7662536102334, -122.425864046062)",020200213-M36,3.1666667 20200220,M17,2006013,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 05:53:07 PM,1000 Block of PALOU AVE,SF,94124,B10,17,6647,E,E,3,true,"",1,MEDIC,1,10,10,Bayview Hunters Point,"(37.7281870279805, -122.380818341183)",020200220-M17,2.8833334 20200226,RS1,2006018,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 05:28:14 PM,0 Block of HARRIET ST,SF,94103,B03,01,2252,3,3,3,false,"",1,RESCUE SQUAD,1,3,6,South of Market,"(37.7787390527615, -122.406871551052)",020200226-RS1,3.5666666 20200235,E12,2006025,Alarms,01/20/2002,01/20/2002,Other,01/20/2002 05:50:14 PM,500 Block of BELVEDERE ST,SF,94117,B05,12,5163,3,3,3,false,"",1,ENGINE,1,5,5,Haight Ashbury,"(37.7621967171759, -122.447945796961)",020200235-E12,1.4333333 20200249,M13,2006036,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 06:59:31 PM,500 Block of OFARRELL ST,SF,94102,B04,03,1544,3,3,3,true,"",1,MEDIC,2,1,6,Tenderloin,"(37.7857402818673, -122.413804267911)",020200249-M13,4.4666667 20200281,E03,2006061,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 08:16:57 PM,500 Block of HYDE ST,SF,94109,B04,03,1556,3,3,3,false,"",1,ENGINE,2,4,6,Tenderloin,"(37.7855599708748, -122.416226912302)",020200281-E03,3.7833333 20200287,E02,2006066,Structure Fire,01/20/2002,01/20/2002,Other,01/20/2002 08:40:19 PM,CLAY ST/GRANT AV,SF,94108,B01,13,1313,3,3,3,false,"",1,ENGINE,1,1,3,Chinatown,"(37.7942636257508, -122.406304988112)",020200287-E02,1.65 20200289,E17,2006068,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 08:53:25 PM,0 Block of CAMERON WAY,SF,94124,B10,17,6573,3,3,3,true,"",1,ENGINE,1,10,10,Bayview Hunters Point,"(37.7202829536688, -122.3858679491)",020200289-E17,2.6833334 20200292,B08,2006071,Alarms,01/20/2002,01/20/2002,Other,01/20/2002 09:24:36 PM,500 Block of SKYLINE BLVD,SF,94132,B08,19,8772,3,3,3,false,"",1,CHIEF,3,8,7,Lakeshore,"(37.7145772172019, -122.498098202551)",020200292-B08,1.8166667 20200297,T09,2006076,Other,01/20/2002,01/20/2002,Other,01/20/2002 09:21:18 PM,900 Block of CONNECTICUT ST,SF,94107,B10,37,2615,3,3,3,true,"",1,TRUCK,3,10,10,Potrero Hill,"(37.7536098398255, -122.397099082289)",020200297-T09,4.266667 20200317,T09,2006094,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 10:39:34 PM,900 Block of CONNECTICUT ST,SF,94107,B10,37,2615,3,3,3,true,"",1,TRUCK,1,10,10,Potrero Hill,"(37.7536098398255, -122.397099082289)",020200317-T09,3.8666666 20200324,E06,2006099,Medical Incident,01/20/2002,01/20/2002,Other,01/20/2002 11:06:19 PM,100 Block of GUERRERO ST,SF,94103,B02,06,5214,3,3,3,false,"",1,ENGINE,1,2,8,Mission,"(37.7688930095544, -122.42438060559)",020200324-E06,2.3833334 20210014,M29,2006124,Medical Incident,01/21/2002,01/20/2002,Other,01/21/2002 02:00:52 AM,300 Block of BALTIMORE WAY,SF,94112,B09,43,6228,2,2,2,true,"",1,MEDIC,1,9,11,Excelsior,"(37.7087981055096, -122.437985362628)",020210014-M29,8.15 20210027,T05,2006135,Medical Incident,01/21/2002,01/20/2002,Other,01/21/2002 01:36:56 AM,700 Block of LAGUNA ST,SF,94102,B02,05,3412,3,3,3,false,"",1,TRUCK,1,2,5,Hayes Valley,"(37.7776339847429, -122.426431627648)",020210027-T05,2.4166667 20210046,E01,2006152,Structure Fire,01/21/2002,01/20/2002,Other,01/21/2002 04:07:39 AM,500 Block of MARKET ST,SF,94105,B03,01,2144,3,3,3,false,"",1,ENGINE,1,3,6,Financial District/South Beach,"(37.790069767129, -122.400173175725)",020210046-E01,2.4833333 20210126,E22,2006199,Alarms,01/21/2002,01/21/2002,Other,01/21/2002 10:12:52 AM,1700 Block of OCTAVIA ST,SF,94109,B04,38,3325,3,3,3,false,"",1,ENGINE,1,4,5,Pacific Heights,"(37.7885483761334, -122.427079528565)",020210126-E22,2.95 20210135,E08,2006204,Structure Fire,01/21/2002,01/21/2002,Other,01/21/2002 10:37:06 AM,6TH ST/HARRISON ST,SF,94103,B03,08,2254,3,3,3,false,"",1,ENGINE,2,3,6,South of Market,"(37.7772727011897, -122.404070256526)",020210135-E08,1.9166666 20210158,E31,2006223,Medical Incident,01/21/2002,01/21/2002,Other,01/21/2002 11:56:31 AM,CALL BOX: ACADEMY OF SCIENCES,SF,94118,B07,22,7744,3,3,3,false,"",1,ENGINE,1,7,1,Golden Gate Park,"(37.7697349025049, -122.464357975669)",020210158-E31,4.1 20210159,M41,2006224,Medical Incident,01/21/2002,01/21/2002,Other,01/21/2002 12:30:24 PM,0 Block of JONES ST,SF,94102,B03,01,1455,3,3,3,true,"",1,MEDIC,2,2,6,Tenderloin,"(37.7815955871561, -122.412190669917)",020210159-M41,3.6333334 20210176,M17,2006236,Medical Incident,01/21/2002,01/21/2002,Other,01/21/2002 01:37:16 PM,1200 Block of SHAFTER AVE,SF,94124,B10,17,6634,3,3,3,true,"",1,MEDIC,2,10,10,Bayview Hunters Point,"(37.7273738403389, -122.384143344423)",020210176-M17,2.7833333 20210203,M01,2006251,Medical Incident,01/21/2002,01/21/2002,Other,01/21/2002 02:48:19 PM,9TH ST/MARKET ST,SF,94103,B02,01,2317,3,3,3,true,"",1,MEDIC,2,2,6,South of Market,"(37.7774938436091, -122.41629170277)",020210203-M01,2.3333333 20210210,M07,2006256,Medical Incident,01/21/2002,01/21/2002,Other,01/21/2002 02:31:19 PM,3800 Block of CESAR CHAVEZ ST,SF,94131,B06,11,5556,1,1,2,true,"",1,MEDIC,1,6,8,Noe Valley,"(37.747817860479, -122.425912009382)",020210210-M07,2.55 20210226,E01,2006269,Medical Incident,01/21/2002,01/21/2002,Other,01/21/2002 03:15:23 PM,1000 Block of MISSION ST,SF,94103,B03,01,2251,3,3,3,false,"",1,ENGINE,2,3,6,South of Market,"(37.7801303744947, -122.409871449933)",020210226-E01,4.85 20210227,B05,2006270,Alarms,01/21/2002,01/21/2002,Other,01/21/2002 03:20:07 PM,500 Block of PARNASSUS AVE,SF,94131,B05,12,7323,3,3,3,false,"",1,CHIEF,2,5,7,Inner Sunset,"(37.7633165969878, -122.458205988587)",020210227-B05,4.1666665 20210235,M38,2006275,Structure Fire,01/21/2002,01/21/2002,Other,01/21/2002 03:41:24 PM,300 Block of FILLMORE ST,SF,94117,B05,06,3531,3,3,3,true,"",1,MEDIC,4,2,5,Hayes Valley,"(37.7725827938566, -122.430463244213)",020210235-M38,1.6166667 20210260,M05,2006297,Medical Incident,01/21/2002,01/21/2002,Other,01/21/2002 04:50:04 PM,GEARY BL/SCOTT ST,SF,94115,B05,10,4154,3,3,3,true,"",1,MEDIC,3,5,5,Western Addition,"(37.7837176369493, -122.437847942301)",020210260-M05,3.3666666 20210263,T01,2006302,Alarms,01/21/2002,01/21/2002,Other,01/21/2002 05:10:01 PM,100 Block of JONES ST,SF,94102,B03,01,1456,3,3,3,false,"",1,TRUCK,1,3,6,Tenderloin,"(37.7825474000421, -122.412247935495)",020210263-T01,3.0166667 20210339,E17,2006351,Outside Fire,01/21/2002,01/21/2002,Other,01/21/2002 09:26:05 PM,1600 Block of QUESADA AVE,SF,94124,B10,17,6535,3,3,3,true,"",1,ENGINE,1,10,10,Bayview Hunters Point,"(37.7328013002788, -122.390382322364)",020210339-E17,2.5166667 20210343,M38,2006354,Medical Incident,01/21/2002,01/21/2002,Other,01/21/2002 09:53:28 PM,3200 Block of STEINER ST,SF,94123,B04,16,3566,1,1,2,true,"",1,MEDIC,1,4,2,Marina,"(37.7994129801196, -122.437720116029)",020210343-M38,2.1166666 20210352,M03,2006359,Medical Incident,01/21/2002,01/21/2002,Other,01/21/2002 11:00:03 PM,200 Block of GOLDEN GATE AVE,SF,94102,B02,01,1548,1,1,2,true,"",1,MEDIC,1,2,6,Tenderloin,"(37.7817609081004, -122.415105135014)",020210352-M03,1.6166667 20220020,M05,2006388,Medical Incident,01/22/2002,01/21/2002,Other,01/22/2002 04:12:36 AM,1000 Block of FILLMORE ST,SF,94115,B05,05,3534,3,3,3,true,"",1,MEDIC,1,5,5,Western Addition,"(37.7790893832209, -122.431925839018)",020220020-M05,2.8166666 20220078,M15,2006423,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 09:23:43 AM,800 Block of ULLOA ST,SF,94127,B08,39,8619,3,3,3,false,"",1,MEDIC,2,8,7,West of Twin Peaks,"(37.7409217122072, -122.466013598224)",020220078-M15,2.15 20220088,E36,2006426,Citizen Assist / Service Call,01/22/2002,01/22/2002,Other,01/22/2002 09:39:52 AM,700 Block of EDDY ST,SF,94102,B02,03,3163,3,3,3,false,"",1,ENGINE,1,2,6,Tenderloin,"(37.782943523582, -122.419988441304)",020220088-E36,6.6 20220147,E28,2006461,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 10:37:00 AM,900 Block of GREEN ST,SF,94133,B01,02,1441,3,3,3,false,"",1,ENGINE,5,1,3,Nob Hill,"(37.798689014807, -122.415061918203)",020220147-E28,7.0666666 20220151,M01,2006464,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 10:15:43 AM,0 Block of UNITED NATIONS PLZ,SF,94102,B02,01,1551,2,2,2,true,"",1,MEDIC,1,2,6,Tenderloin,"(37.7799444052046, -122.414317857881)",020220151-M01,5.766667 20220167,E09,2006470,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 10:36:11 AM,1600 Block of LA SALLE AVE,SF,94124,B10,25,6467,3,3,3,false,"",1,ENGINE,1,10,10,Bayview Hunters Point,"(37.7373109218109, -122.390232962318)",020220167-E09,4.516667 20220174,E35,2006474,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 10:44:04 AM,0 Block of FRONT ST,SF,94111,B01,13,1136,3,3,3,false,"",1,ENGINE,1,1,3,Financial District/South Beach,"(37.7920192720524, -122.39857867407)",020220174-E35,4.4333334 20220175,E06,2006475,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 10:45:02 AM,2300 Block of MARKET ST,SF,94114,B05,06,5233,3,3,3,false,"",1,ENGINE,1,5,8,Castro/Upper Market,"(37.7635007029742, -122.434209629009)",020220175-E06,1.6166667 20220181,T07,2006480,Structure Fire,01/22/2002,01/22/2002,Other,01/22/2002 10:50:57 AM,1800 Block of FOLSOM ST,SF,94103,B02,07,0527,3,3,3,false,"",1,TRUCK,3,2,9,Mission,"(37.7677413424145, -122.415468956066)",020220181-T07,3.1833334 20220182,E05,2006481,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 11:00:54 AM,1800 Block of SUTTER ST,SF,94115,B04,38,3433,3,3,3,false,"",1,ENGINE,2,4,5,Pacific Heights,"(37.7864581478384, -122.43077642338)",020220182-E05,2.6166666 20220185,M41,2006483,Medical Incident,01/22/2002,01/22/2002,Other,"",0 Block of BRYANT ST,SF,94105,B03,35,2121,3,3,3,true,"",1,MEDIC,3,3,6,Financial District/South Beach,"(37.787159183952, -122.388331283356)",020220185-M41,3.4833333 20220189,E01,2006485,Citizen Assist / Service Call,01/22/2002,01/22/2002,Other,01/22/2002 11:45:16 AM,GOLDEN GATE AV/JONES ST,SF,94102,B03,01,1454,3,3,3,false,"",1,ENGINE,1,2,6,Tenderloin,"(37.7820730668609, -122.412220736854)",020220189-E01,1.8 20220195,E09,2006487,Structure Fire,01/22/2002,01/22/2002,Other,01/22/2002 11:12:46 AM,24TH ST/UTAH ST,SF,94110,B10,09,2562,3,3,3,false,"",1,ENGINE,1,10,10,Mission,"(37.7530638329046, -122.405331103731)",020220195-E09,1.0333333 20220217,M14,2006513,Medical Incident,01/22/2002,01/22/2002,Other,"",2300 Block of 24TH AVE,SF,94116,B08,40,7461,1,1,2,true,"",1,MEDIC,2,8,4,Sunset/Parkside,"(37.7437447222589, -122.481184434413)",020220217-M14,13.4 20220263,T02,2006538,Alarms,01/22/2002,01/22/2002,Other,01/22/2002 01:08:57 PM,300 Block of JEFFERSON ST,SF,94133,B01,28,0947,3,3,3,false,"",1,TRUCK,3,1,3,North Beach,"(37.8079624466014, -122.418277044979)",020220263-T02,2.3166666 20220267,E14,2006540,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 01:18:21 PM,200 Block of 27TH AVE,SF,94121,B07,14,7217,3,3,3,false,"",1,ENGINE,2,7,2,Outer Richmond,"(37.7847203010506, -122.487149444624)",020220267-E14,4.4333334 20220282,E28,2006551,Structure Fire,01/22/2002,01/22/2002,Other,01/22/2002 02:13:53 PM,CALL BOX: PIER 39,SF,94133,B01,28,0939,3,3,3,false,"",1,ENGINE,2,1,3,North Beach,"(37.8080886373444, -122.408981679869)",020220282-E28,2.8 20220293,E23,2006558,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 02:45:08 PM,1200 Block of 39TH AVE,SF,94122,B08,23,7626,3,3,3,false,"",1,ENGINE,1,8,4,Sunset/Parkside,"(37.7635527078831, -122.498690380377)",020220293-E23,4.45 20220309,E07,2006571,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 02:31:08 PM,2200 Block of HARRISON ST,SF,94110,B06,07,5432,3,3,3,false,"",1,ENGINE,2,6,9,Mission,"(37.7604820180908, -122.412593383429)",020220309-E07,4.2166667 20220326,M05,2006582,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 04:06:15 PM,2200 Block of GEARY BLVD,SF,94115,B05,10,4154,3,3,3,true,"",1,MEDIC,2,5,5,Japantown,"(37.7833263288474, -122.44032487616)",020220326-M05,3.6833334 20220332,B03,2006587,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 03:25:20 PM,0 Block of CONNECTICUT ST,SF,94107,B03,29,2425,3,3,3,false,"",1,CHIEF,3,3,10,Mission Bay,"(37.7657165510162, -122.397869370472)",020220332-B03,5.983333 20220356,E11,2006604,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 04:24:15 PM,2800 Block of MISSION ST,SF,94110,B06,11,5525,2,2,2,false,"",1,ENGINE,1,6,9,Mission,"(37.7514438314246, -122.41829760412)",020220356-E11,8.716666 20220357,T07,2006605,Structure Fire,01/22/2002,01/22/2002,Other,01/22/2002 04:16:40 PM,200 Block of POTRERO AVE,SF,94103,B02,29,2874,3,3,3,false,"",1,TRUCK,2,2,10,Mission,"(37.7664376828612, -122.407540732549)",020220357-T07,1.0666667 20220362,E05,2006610,Structure Fire,01/22/2002,01/22/2002,Other,01/22/2002 04:40:39 PM,MCALLISTER ST/PIERCE ST,SF,94115,B05,05,3642,3,3,3,false,"",1,ENGINE,1,5,5,Western Addition,"(37.7782127709463, -122.435052389241)",020220362-E05,0.95 20220371,B10,2006617,Alarms,01/22/2002,01/22/2002,Other,01/22/2002 04:58:36 PM,2600 Block of 18TH ST,SF,94110,B10,07,5427,3,3,3,false,"",1,CHIEF,2,2,10,Mission,"(37.7619012948729, -122.408676893067)",020220371-B10,2.3666666 20220376,E23,2006620,Structure Fire,01/22/2002,01/22/2002,Other,01/22/2002 07:55:19 PM,1500 Block of 46TH AVE,SF,94122,B08,23,7717,3,3,3,false,"",1,ENGINE,1,8,4,Sunset/Parkside,"(37.7576293648633, -122.50566208801)",020220376-E23,2.7833333 20220379,T03,2006623,Alarms,01/22/2002,01/22/2002,Other,01/22/2002 05:16:36 PM,1400 Block of PINE ST,SF,94109,B04,03,3122,3,3,3,false,"",1,TRUCK,3,4,3,Nob Hill,"(37.7897794249332, -122.419678979482)",020220379-T03,4.2 20220383,B06,2006627,Structure Fire,01/22/2002,01/22/2002,Other,01/22/2002 05:59:26 PM,100 Block of GUERRERO ST,SF,94103,B02,06,5214,3,3,3,false,"",1,CHIEF,2,2,8,Mission,"(37.7685615589203, -122.42458408581)",020220383-B06,2.0833333 20220391,E38,2006634,Alarms,01/22/2002,01/22/2002,Other,01/22/2002 05:50:57 PM,1200 Block of WEBSTER ST,SF,94115,B05,05,3515,3,3,3,false,"",1,ENGINE,2,5,5,Western Addition,"(37.7820874529721, -122.430855608926)",020220391-E38,2.3333333 20220399,E16,2006642,Alarms,01/22/2002,01/22/2002,Other,01/22/2002 06:18:37 PM,1500 Block of FILBERT ST,SF,94123,B04,16,3146,3,3,3,false,"",1,ENGINE,1,4,2,Marina,"(37.7993258680494, -122.424981100027)",020220399-E16,2.0 20220410,E36,2006647,Structure Fire,01/22/2002,01/22/2002,Other,01/22/2002 06:33:49 PM,10TH ST/MARKET ST,SF,94103,B02,36,2338,3,3,3,false,"",1,ENGINE,1,2,6,Tenderloin,"(37.7765408927183, -122.417501464907)",020220410-E36,1.3833333 20220439,E15,2006673,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 08:18:00 PM,900 Block of ATHENS ST,SF,94112,B09,43,6173,3,3,3,true,"",1,ENGINE,1,9,11,Excelsior,"(37.7140870276364, -122.434029836081)",020220439-E15,2.8 20220443,RC2,2006675,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 08:50:26 PM,1100 Block of MCALLISTER ST,SF,94115,B05,05,3534,3,3,3,true,"",1,RESCUE CAPTAIN,3,5,5,Western Addition,"(37.7787412233251, -122.431343410204)",020220443-RC2,2.4 20220444,T13,2006676,Structure Fire,01/22/2002,01/22/2002,Other,01/22/2002 08:40:19 PM,2800 Block of SACRAMENTO ST,SF,94115,B04,10,4161,3,3,3,false,"",1,TRUCK,9,4,2,Pacific Heights,"(37.7890476085359, -122.439780968949)",020220444-T13,1.4 20220459,RC4,2006689,Medical Incident,01/22/2002,01/22/2002,Other,01/22/2002 09:25:03 PM,HOLLISTER AV/INGALLS ST,SF,94124,B10,17,6612,3,3,3,true,"",1,RESCUE CAPTAIN,4,10,10,Bayview Hunters Point,"(37.719739950078, -122.392418231567)",020220459-RC4,1.7166667 20220477,B02,2006703,Alarms,01/22/2002,01/22/2002,Other,01/22/2002 11:58:06 PM,100 Block of JONES ST,SF,94102,B03,01,1456,3,3,3,false,"",1,CHIEF,3,2,6,Tenderloin,"(37.7825297445725, -122.412384547628)",020220477-B02,2.6 20230017,M07,2006727,Medical Incident,01/23/2002,01/22/2002,Other,01/23/2002 04:09:48 AM,100 Block of COLERIDGE ST,SF,94110,B06,11,5662,3,3,3,true,"",1,MEDI

Define our schema as the file has 4 million records. Inferring the schema is expensive for large files.

fire_schema = StructType([StructField('CallNumber', IntegerType(), True),
                     StructField('UnitID', StringType(), True),
                     StructField('IncidentNumber', IntegerType(), True),
                     StructField('CallType', StringType(), True),                  
                     StructField('CallDate', StringType(), True),      
                     StructField('WatchDate', StringType(), True),
                     StructField('CallFinalDisposition', StringType(), True),
                     StructField('AvailableDtTm', StringType(), True),
                     StructField('Address', StringType(), True),       
                     StructField('City', StringType(), True),       
                     StructField('Zipcode', IntegerType(), True),       
                     StructField('Battalion', StringType(), True),                 
                     StructField('StationArea', StringType(), True),       
                     StructField('Box', StringType(), True),       
                     StructField('OriginalPriority', StringType(), True),       
                     StructField('Priority', StringType(), True),       
                     StructField('FinalPriority', IntegerType(), True),       
                     StructField('ALSUnit', BooleanType(), True),       
                     StructField('CallTypeGroup', StringType(), True),
                     StructField('NumAlarms', IntegerType(), True),
                     StructField('UnitType', StringType(), True),
                     StructField('UnitSequenceInCallDispatch', IntegerType(), True),
                     StructField('FirePreventionDistrict', StringType(), True),
                     StructField('SupervisorDistrict', StringType(), True),
                     StructField('Neighborhood', StringType(), True),
                     StructField('Location', StringType(), True),
                     StructField('RowID', StringType(), True),
                     StructField('Delay', FloatType(), True)])
fire_df = spark.read.csv(sf_fire_file, header=True, schema=fire_schema)

Cache the DataFrame since we will be performing some operations on it.

fire_df.cache()
Out[6]: DataFrame[CallNumber: int, UnitID: string, IncidentNumber: int, CallType: string, CallDate: string, WatchDate: string, CallFinalDisposition: string, AvailableDtTm: string, Address: string, City: string, Zipcode: int, Battalion: string, StationArea: string, Box: string, OriginalPriority: string, Priority: string, FinalPriority: int, ALSUnit: boolean, CallTypeGroup: string, NumAlarms: int, UnitType: string, UnitSequenceInCallDispatch: int, FirePreventionDistrict: string, SupervisorDistrict: string, Neighborhood: string, Location: string, RowID: string, Delay: float]
fire_df.count()
Out[7]: 175296
fire_df.printSchema()
root |-- CallNumber: integer (nullable = true) |-- UnitID: string (nullable = true) |-- IncidentNumber: integer (nullable = true) |-- CallType: string (nullable = true) |-- CallDate: string (nullable = true) |-- WatchDate: string (nullable = true) |-- CallFinalDisposition: string (nullable = true) |-- AvailableDtTm: string (nullable = true) |-- Address: string (nullable = true) |-- City: string (nullable = true) |-- Zipcode: integer (nullable = true) |-- Battalion: string (nullable = true) |-- StationArea: string (nullable = true) |-- Box: string (nullable = true) |-- OriginalPriority: string (nullable = true) |-- Priority: string (nullable = true) |-- FinalPriority: integer (nullable = true) |-- ALSUnit: boolean (nullable = true) |-- CallTypeGroup: string (nullable = true) |-- NumAlarms: integer (nullable = true) |-- UnitType: string (nullable = true) |-- UnitSequenceInCallDispatch: integer (nullable = true) |-- FirePreventionDistrict: string (nullable = true) |-- SupervisorDistrict: string (nullable = true) |-- Neighborhood: string (nullable = true) |-- Location: string (nullable = true) |-- RowID: string (nullable = true) |-- Delay: float (nullable = true) 
display(fire_df.limit(5))
 
CallNumber
UnitID
IncidentNumber
CallType
CallDate
WatchDate
CallFinalDisposition
AvailableDtTm
Address
City
Zipcode
Battalion
StationArea
Box
OriginalPriority
Priority
FinalPriority
ALSUnit
CallTypeGroup
NumAlarms
UnitType
UnitSequenceInCallDispatch
FirePreventionDistrict
SupervisorDistrict
Neighborhood
Location
RowID
Delay
1
2
3
4
5
20110016
T13
2003235
Structure Fire
01/11/2002
01/10/2002
Other
01/11/2002 01:51:44 AM
2000 Block of CALIFORNIA ST
SF
94109
B04
38
3362
3
3
3
false
null
1
TRUCK
2
4
5
Pacific Heights
(37.7895840679362, -122.428071912459)
020110016-T13
2.95
20110022
M17
2003241
Medical Incident
01/11/2002
01/10/2002
Other
01/11/2002 03:01:18 AM
0 Block of SILVERVIEW DR
SF
94124
B10
42
6495
3
3
3
true
null
1
MEDIC
1
10
10
Bayview Hunters Point
(37.7337623673897, -122.396113802632)
020110022-M17
4.7
20110023
M41
2003242
Medical Incident
01/11/2002
01/10/2002
Other
01/11/2002 02:39:50 AM
MARKET ST/MCALLISTER ST
SF
94102
B03
01
1455
3
3
3
true
null
1
MEDIC
2
3
6
Tenderloin
(37.7811772186856, -122.411699931232)
020110023-M41
2.4333334
20110032
E11
2003250
Vehicle Fire
01/11/2002
01/10/2002
Other
01/11/2002 04:16:46 AM
APPLETON AV/MISSION ST
SF
94110
B06
32
5626
3
3
3
false
null
1
ENGINE
1
6
9
Bernal Heights
(37.7388432849018, -122.423948785199)
020110032-E11
1.5
20110043
B04
2003259
Alarms
01/11/2002
01/10/2002
Other
01/11/2002 06:01:58 AM
1400 Block of SUTTER ST
SF
94109
B04
03
3223
3
3
3
false
null
1
CHIEF
2
4
2
Western Addition
(37.7872890372638, -122.424236212664)
020110043-B04
3.4833333

Showing all 5 rows.

Filter out "Medical Incident" call types

Note that filter() and where() methods on the DataFrame are similar. Check relevant documentation for their respective argument types.

few_fire_df = (fire_df
               .select("IncidentNumber", "AvailableDtTm", "CallType")
               .where(col("CallType") != "Medical Incident"))

few_fire_df.show(5, truncate=False)
+--------------+----------------------+--------------+ |IncidentNumber|AvailableDtTm |CallType | +--------------+----------------------+--------------+ |2003235 |01/11/2002 01:51:44 AM|Structure Fire| |2003250 |01/11/2002 04:16:46 AM|Vehicle Fire | |2003259 |01/11/2002 06:01:58 AM|Alarms | |2003279 |01/11/2002 08:03:26 AM|Structure Fire| |2003301 |01/11/2002 09:46:44 AM|Alarms | +--------------+----------------------+--------------+ only showing top 5 rows

Q-1) How many distinct types of calls were made to the Fire Department?

To be sure, let's not count "null" strings in that column.

fire_df.select("CallType").where(col("CallType").isNotNull()).distinct().count()
Out[11]: 30

Q-2) What are distinct types of calls were made to the Fire Department?

These are all the distinct type of call to the SF Fire Department

fire_df.select("CallType").where(col("CallType").isNotNull()).distinct().show(10, False)
+-----------------------------+ |CallType | +-----------------------------+ |Elevator / Escalator Rescue | |Alarms | |Odor (Strange / Unknown) | |Citizen Assist / Service Call| |Vehicle Fire | |Other | |Outside Fire | |Electrical Hazard | |Structure Fire | |Medical Incident | +-----------------------------+ only showing top 10 rows

Q-3) Find out all response or delayed times greater than 5 mins?

  1. Rename the column Delay - > ReponseDelayedinMins
  2. Returns a new DataFrame
  3. Find out all calls where the response time to the fire site was delayed for more than 5 mins
new_fire_df = fire_df.withColumnRenamed("Delay", "ResponseDelayedinMins")
new_fire_df.select("ResponseDelayedinMins").where(col("ResponseDelayedinMins") > 5).show(5, False)
+---------------------+ |ResponseDelayedinMins| +---------------------+ |5.35 | |6.25 | |5.2 | |5.6 | |7.25 | +---------------------+ only showing top 5 rows

Let's do some ETL:

  1. Transform the string dates to Spark Timestamp data type so we can make some time-based queries later
  2. Returns a transformed query
  3. Cache the new DataFrame
fire_ts_df = (new_fire_df
              .withColumn("IncidentDate", to_timestamp(col("CallDate"), "MM/dd/yyyy")).drop("CallDate") 
              .withColumn("OnWatchDate",   to_timestamp(col("WatchDate"), "MM/dd/yyyy")).drop("WatchDate")
              .withColumn("AvailableDtTS", to_timestamp(col("AvailableDtTm"), "MM/dd/yyyy hh:mm:ss a")).drop("AvailableDtTm"))          
fire_ts_df.cache()
fire_ts_df.columns
Out[15]: ['CallNumber', 'UnitID', 'IncidentNumber', 'CallType', 'CallFinalDisposition', 'Address', 'City', 'Zipcode', 'Battalion', 'StationArea', 'Box', 'OriginalPriority', 'Priority', 'FinalPriority', 'ALSUnit', 'CallTypeGroup', 'NumAlarms', 'UnitType', 'UnitSequenceInCallDispatch', 'FirePreventionDistrict', 'SupervisorDistrict', 'Neighborhood', 'Location', 'RowID', 'ResponseDelayedinMins', 'IncidentDate', 'OnWatchDate', 'AvailableDtTS']

Check the transformed columns with Spark Timestamp type

fire_ts_df.select("IncidentDate", "OnWatchDate", "AvailableDtTS").show(5, False)
+-------------------+-------------------+-------------------+ |IncidentDate |OnWatchDate |AvailableDtTS | +-------------------+-------------------+-------------------+ |2002-01-11 00:00:00|2002-01-10 00:00:00|2002-01-11 01:51:44| |2002-01-11 00:00:00|2002-01-10 00:00:00|2002-01-11 03:01:18| |2002-01-11 00:00:00|2002-01-10 00:00:00|2002-01-11 02:39:50| |2002-01-11 00:00:00|2002-01-10 00:00:00|2002-01-11 04:16:46| |2002-01-11 00:00:00|2002-01-10 00:00:00|2002-01-11 06:01:58| +-------------------+-------------------+-------------------+ only showing top 5 rows

Q-4) What were the most common call types?

List them in descending order

(fire_ts_df
 .select("CallType").where(col("CallType").isNotNull())
 .groupBy("CallType")
 .count()
 .orderBy("count", ascending=False)
 .show(n=10, truncate=False))
+-------------------------------+------+ |CallType |count | +-------------------------------+------+ |Medical Incident |113794| |Structure Fire |23319 | |Alarms |19406 | |Traffic Collision |7013 | |Citizen Assist / Service Call |2524 | |Other |2166 | |Outside Fire |2094 | |Vehicle Fire |854 | |Gas Leak (Natural and LP Gases)|764 | |Water Rescue |755 | +-------------------------------+------+ only showing top 10 rows

Q-4a) What zip codes accounted for most common calls?

Let's investigate what zip codes in San Francisco accounted for most fire calls and what type where they.

  1. Filter out by CallType
  2. Group them by CallType and Zip code
  3. Count them and display them in descending order

It seems like the most common calls were all related to Medical Incident, and the two zip codes are 94102 and 94103.

(fire_ts_df
 .select("CallType", "ZipCode")
 .where(col("CallType").isNotNull())
 .groupBy("CallType", "Zipcode")
 .count()
 .orderBy("count", ascending=False)
 .show(10, truncate=False))
+----------------+-------+-----+ |CallType |Zipcode|count| +----------------+-------+-----+ |Medical Incident|94102 |16130| |Medical Incident|94103 |14775| |Medical Incident|94110 |9995 | |Medical Incident|94109 |9479 | |Medical Incident|94124 |5885 | |Medical Incident|94112 |5630 | |Medical Incident|94115 |4785 | |Medical Incident|94122 |4323 | |Medical Incident|94107 |4284 | |Medical Incident|94133 |3977 | +----------------+-------+-----+ only showing top 10 rows

Q-4b) What San Francisco neighborhoods are in the zip codes 94102 and 94103

Let's find out the neighborhoods associated with these two zip codes. In all likelihood, these are some of the contested neighborhood with high reported crimes.

fire_ts_df.select("Neighborhood", "Zipcode").where((col("Zipcode") == 94102) | (col("Zipcode") == 94103)).distinct().show(10, truncate=False)
+------------------------------+-------+ |Neighborhood |Zipcode| +------------------------------+-------+ |Western Addition |94102 | |Tenderloin |94102 | |Nob Hill |94102 | |South of Market |94102 | |South of Market |94103 | |Financial District/South Beach|94102 | |Mission Bay |94103 | |Tenderloin |94103 | |Financial District/South Beach|94103 | |Hayes Valley |94102 | +------------------------------+-------+ only showing top 10 rows

Q-5) What was the sum of all calls, average, min and max of the response times for calls?

Let's use the built-in Spark SQL functions to compute the sum, avg, min, and max of few columns:

  • Number of Total Alarms
  • What were the min and max the delay in response time before the Fire Dept arrived at the scene of the call
fire_ts_df.select(sum("NumAlarms"), avg("ResponseDelayedinMins"), min("ResponseDelayedinMins"), max("ResponseDelayedinMins")).show()
+--------------+--------------------------+--------------------------+--------------------------+ |sum(NumAlarms)|avg(ResponseDelayedinMins)|min(ResponseDelayedinMins)|max(ResponseDelayedinMins)| +--------------+--------------------------+--------------------------+--------------------------+ | 176170| 3.892364154521585| 0.016666668| 1844.55| +--------------+--------------------------+--------------------------+--------------------------+

Q-6a) How many distinct years of data is in the CSV file?

We can use the year() SQL Spark function off the Timestamp column data type IncidentDate.

In all, we have fire calls from years 2000-2018

fire_ts_df.select(year("IncidentDate")).distinct().orderBy(year("IncidentDate")).show()
+------------------+ |year(IncidentDate)| +------------------+ | 2000| | 2001| | 2002| | 2003| | 2004| | 2005| | 2006| | 2007| | 2008| | 2009| | 2010| | 2011| | 2012| | 2013| | 2014| | 2015| | 2016| | 2017| | 2018| +------------------+

Q-6b) What week of the year in 2018 had the most fire calls?

Note: Week 1 is the New Years' week and week 25 is the July 4 the week. Loads of fireworks, so it makes sense the higher number of calls.

fire_ts_df.filter(year("IncidentDate") == 2018).groupBy(weekofyear("IncidentDate")).count().orderBy("count", ascending=False).show()
+------------------------+-----+ |weekofyear(IncidentDate)|count| +------------------------+-----+ | 22| 259| | 40| 255| | 43| 250| | 25| 249| | 1| 246| | 44| 244| | 13| 243| | 32| 243| | 11| 240| | 5| 236| | 18| 236| | 23| 235| | 31| 234| | 2| 234| | 42| 234| | 19| 233| | 34| 232| | 8| 232| | 10| 232| | 21| 231| +------------------------+-----+ only showing top 20 rows

Q-7) What neighborhoods in San Francisco had the worst response time in 2018?

It appears that if you living in Presidio Heights, the Fire Dept arrived in less than 3 mins, while Mission Bay took more than 6 mins.

fire_ts_df.select("Neighborhood", "ResponseDelayedinMins").filter(year("IncidentDate") == 2018).show(10, False)
+------------------------------+---------------------+ |Neighborhood |ResponseDelayedinMins| +------------------------------+---------------------+ |Presidio Heights |2.8833334 | |Mission Bay |6.3333335 | |Chinatown |2.65 | |Financial District/South Beach|3.5333333 | |Tenderloin |1.1 | |Bayview Hunters Point |4.05 | |Inner Richmond |2.5666666 | |Inner Sunset |1.4 | |Sunset/Parkside |2.6666667 | |South of Market |1.7666667 | +------------------------------+---------------------+ only showing top 10 rows

Q-8a) How can we use Parquet files or SQL table to store data and read it back?

fire_ts_df.write.format("parquet").mode("overwrite").save("/tmp/fireServiceParquet/")
%fs ls /tmp/fireServiceParquet/
 
path
name
size
modificationTime
1
2
3
4
5
6
7
8
9
10
11
dbfs:/tmp/fireServiceParquet/_SUCCESS
_SUCCESS
0
1665837155000
dbfs:/tmp/fireServiceParquet/_committed_133726782968115141
_committed_133726782968115141
816
1665837154000
dbfs:/tmp/fireServiceParquet/_started_133726782968115141
_started_133726782968115141
0
1665837145000
dbfs:/tmp/fireServiceParquet/part-00000-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-138-1-c000.snappy.parquet
part-00000-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-138-1-c000.snappy.parquet
1319583
1665837153000
dbfs:/tmp/fireServiceParquet/part-00001-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-139-1-c000.snappy.parquet
part-00001-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-139-1-c000.snappy.parquet
1297851
1665837153000
dbfs:/tmp/fireServiceParquet/part-00002-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-140-1-c000.snappy.parquet
part-00002-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-140-1-c000.snappy.parquet
1220732
1665837153000
dbfs:/tmp/fireServiceParquet/part-00003-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-141-1-c000.snappy.parquet
part-00003-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-141-1-c000.snappy.parquet
1236622
1665837153000
dbfs:/tmp/fireServiceParquet/part-00004-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-142-1-c000.snappy.parquet
part-00004-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-142-1-c000.snappy.parquet
1270542
1665837153000
dbfs:/tmp/fireServiceParquet/part-00005-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-143-1-c000.snappy.parquet
part-00005-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-143-1-c000.snappy.parquet
1318273
1665837153000
dbfs:/tmp/fireServiceParquet/part-00006-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-144-1-c000.snappy.parquet
part-00006-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-144-1-c000.snappy.parquet
1353616
1665837153000
dbfs:/tmp/fireServiceParquet/part-00007-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-145-1-c000.snappy.parquet
part-00007-tid-133726782968115141-32b7e143-a36c-4497-8fe8-9e09fb92fc90-145-1-c000.snappy.parquet
437445
1665837153000

Showing all 11 rows.

Q-8b) How can we use Parquet SQL table to store data and read it back?

fire_ts_df.write.format("parquet").mode("overwrite").saveAsTable("FireServiceCalls")
%sql
CACHE TABLE FireServiceCalls
OK
%sql
SELECT * FROM FireServiceCalls LIMIT 10
 
CallNumber
UnitID
IncidentNumber
CallType
CallFinalDisposition
Address
City
Zipcode
Battalion
StationArea
Box
OriginalPriority
Priority
FinalPriority
ALSUnit
CallTypeGroup
NumAlarms
UnitType
UnitSequenceInCallDispatch
FirePreventionDistrict
SupervisorDistrict
Neighborhood
Location
RowID
ResponseDelayedinMins
IncidentDate
OnWatchDate
AvailableDtTS
1
2
3
4
5
6
7
8
9
10
110660238
60
11021821
Medical Incident
Fire
0 Block of BORICA ST
SF
94127
B09
19
8442
3
2
2
true
null
1
MEDIC
1
9
7
West of Twin Peaks
(37.7225922041408, -122.468227979374)
110660238-60
2.9
2011-03-07T00:00:00.000+0000
2011-03-07T00:00:00.000+0000
2011-03-07T16:23:05.000+0000
110660253
B03
11021831
Alarms
Fire
1000 Block of HOWARD ST
SF
94103
B03
01
2252
3
3
3
false
null
1
CHIEF
3
3
6
South of Market
(37.7795675906982, -122.407474134289)
110660253-B03
2.3833334
2011-03-07T00:00:00.000+0000
2011-03-07T00:00:00.000+0000
2011-03-07T17:13:21.000+0000
110660282
E43
11021856
Medical Incident
Other
PERSIA AV/MADRID ST
SF
94112
B09
43
6134
3
3
3
true
null
1
ENGINE
1
9
11
Excelsior
(37.7216187707613, -122.432805977203)
110660282-E43
1.65
2011-03-07T00:00:00.000+0000
2011-03-07T00:00:00.000+0000
2011-03-07T18:55:52.000+0000
110660322
94
11021888
Medical Incident
Other
1100 Block of HOWARD ST
SF
94103
B03
01
2314
3
3
3
true
null
1
MEDIC
3
2
6
South of Market
(37.7768521020734, -122.410711239368)
110660322-94
1.5666667
2011-03-07T00:00:00.000+0000
2011-03-07T00:00:00.000+0000
2011-03-07T20:49:25.000+0000
110670051
B09
11021963
Alarms
Fire
5800 Block of MISSION ST
SF
94112
B09
33
6213
3
3
3
false
null
1
CHIEF
3
9
11
Outer Mission
(37.709160030699, -122.451801431228)
110670051-B09
2.8
2011-03-08T00:00:00.000+0000
2011-03-07T00:00:00.000+0000
2011-03-08T07:36:00.000+0000
110670076
B06
11021980
Alarms
Fire
3600 Block of 20TH ST
SF
94110
B06
07
5445
3
3
3
false
null
1
CHIEF
2
6
8
Mission
(37.7584863037287, -122.422385383463)
110670076-B06
2.5
2011-03-08T00:00:00.000+0000
2011-03-08T00:00:00.000+0000
2011-03-08T08:52:16.000+0000
110670077
E44
11021981
Alarms
Other
1700 Block of VISITACION AVE
SF
94134
B09
44
6263
3
3
3
true
null
1
ENGINE
1
9
10
McLaren Park
(37.7162666820869, -122.414215025813)
110670077-E44
1.6166667
2011-03-08T00:00:00.000+0000
2011-03-08T00:00:00.000+0000
2011-03-08T09:15:07.000+0000
110670082
92
11021988
Medical Incident
Code 2 Transport
100 Block of GOLDEN GATE AVE
SF
94102
B02
01
1546
1
1
2
true
null
1
MEDIC
2
2
6
Tenderloin
(37.7820224371777, -122.413054148253)
110670082-92
13.416667
2011-03-08T00:00:00.000+0000
2011-03-08T00:00:00.000+0000
2011-03-08T10:23:19.000+0000
110670089
E01
11021993
Medical Incident
Other
200 Block of EDDY ST
SF
94102
B03
01
1453
3
3
3
true
null
1
ENGINE
1
3
6
Tenderloin
(37.7840910361755, -122.411784369455)
110670089-E01
3.55
2011-03-08T00:00:00.000+0000
2011-03-08T00:00:00.000+0000
2011-03-08T09:48:55.000+0000
110670101
84
11021998
Medical Incident
Code 2 Transport
CALL BOX: SAN JOSE AV/SANTA YNEZ AV
SF
94112
B09
15
8276
2
2
2
true
null
1
MEDIC
1
9
11
Outer Mission
(37.7258249736518, -122.442324422614)
110670101-84
4.55
2011-03-08T00:00:00.000+0000
2011-03-08T00:00:00.000+0000
2011-03-08T11:13:38.000+0000

Showing all 10 rows.

Q-8c) How can read data from Parquet file?

Note we don't have to specify the schema here since it's stored as part of the Parquet metadata

file_parquet_df = spark.read.format("parquet").load("/tmp/fireServiceParquet/")
display(file_parquet_df.limit(10))
 
CallNumber
UnitID
IncidentNumber
CallType
CallFinalDisposition
Address
City
Zipcode
Battalion
StationArea
Box
OriginalPriority
Priority
FinalPriority
ALSUnit
CallTypeGroup
NumAlarms
UnitType
UnitSequenceInCallDispatch
FirePreventionDistrict
SupervisorDistrict
Neighborhood
Location
RowID
ResponseDelayedinMins
IncidentDate
OnWatchDate
AvailableDtTS
1
2
3
4
5
6
7
8
9
10
110660238
60
11021821
Medical Incident
Fire
0 Block of BORICA ST
SF
94127
B09
19
8442
3
2
2
true
null
1
MEDIC
1
9
7
West of Twin Peaks
(37.7225922041408, -122.468227979374)
110660238-60
2.9
2011-03-07T00:00:00.000+0000
2011-03-07T00:00:00.000+0000
2011-03-07T16:23:05.000+0000
110660253
B03
11021831
Alarms
Fire
1000 Block of HOWARD ST
SF
94103
B03
01
2252
3
3
3
false
null
1
CHIEF
3
3
6
South of Market
(37.7795675906982, -122.407474134289)
110660253-B03
2.3833334
2011-03-07T00:00:00.000+0000
2011-03-07T00:00:00.000+0000
2011-03-07T17:13:21.000+0000
110660282
E43
11021856
Medical Incident
Other
PERSIA AV/MADRID ST
SF
94112
B09
43
6134
3
3
3
true
null
1
ENGINE
1
9
11
Excelsior
(37.7216187707613, -122.432805977203)
110660282-E43
1.65
2011-03-07T00:00:00.000+0000
2011-03-07T00:00:00.000+0000
2011-03-07T18:55:52.000+0000
110660322
94
11021888
Medical Incident
Other
1100 Block of HOWARD ST
SF
94103
B03
01
2314
3
3
3
true
null
1
MEDIC
3
2
6
South of Market
(37.7768521020734, -122.410711239368)
110660322-94
1.5666667
2011-03-07T00:00:00.000+0000
2011-03-07T00:00:00.000+0000
2011-03-07T20:49:25.000+0000
110670051
B09
11021963
Alarms
Fire
5800 Block of MISSION ST
SF
94112
B09
33
6213
3
3
3
false
null
1
CHIEF
3
9
11
Outer Mission
(37.709160030699, -122.451801431228)
110670051-B09
2.8
2011-03-08T00:00:00.000+0000
2011-03-07T00:00:00.000+0000
2011-03-08T07:36:00.000+0000
110670076
B06
11021980
Alarms
Fire
3600 Block of 20TH ST
SF
94110
B06
07
5445
3
3
3
false
null
1
CHIEF
2
6
8
Mission
(37.7584863037287, -122.422385383463)
110670076-B06
2.5
2011-03-08T00:00:00.000+0000
2011-03-08T00:00:00.000+0000
2011-03-08T08:52:16.000+0000
110670077
E44
11021981
Alarms
Other
1700 Block of VISITACION AVE
SF
94134
B09
44
6263
3
3
3
true
null
1
ENGINE
1
9
10
McLaren Park
(37.7162666820869, -122.414215025813)
110670077-E44
1.6166667
2011-03-08T00:00:00.000+0000
2011-03-08T00:00:00.000+0000
2011-03-08T09:15:07.000+0000
110670082
92
11021988
Medical Incident
Code 2 Transport
100 Block of GOLDEN GATE AVE
SF
94102
B02
01
1546
1
1
2
true
null
1
MEDIC
2
2
6
Tenderloin
(37.7820224371777, -122.413054148253)
110670082-92
13.416667
2011-03-08T00:00:00.000+0000
2011-03-08T00:00:00.000+0000
2011-03-08T10:23:19.000+0000
110670089
E01
11021993
Medical Incident
Other
200 Block of EDDY ST
SF
94102
B03
01
1453
3
3
3
true
null
1
ENGINE
1
3
6
Tenderloin
(37.7840910361755, -122.411784369455)
110670089-E01
3.55
2011-03-08T00:00:00.000+0000
2011-03-08T00:00:00.000+0000
2011-03-08T09:48:55.000+0000
110670101
84
11021998
Medical Incident
Code 2 Transport
CALL BOX: SAN JOSE AV/SANTA YNEZ AV
SF
94112
B09
15
8276
2
2
2
true
null
1
MEDIC
1
9
11
Outer Mission
(37.7258249736518, -122.442324422614)
110670101-84
4.55
2011-03-08T00:00:00.000+0000
2011-03-08T00:00:00.000+0000
2011-03-08T11:13:38.000+0000

Showing all 10 rows.