Loading ...
Sorry, an error occurred while loading the content.

Obtaining the weekly/monthly crime summaries as a file

Expand Messages
  • arodeojock@comcast.net
    This was posted on the 1D site and looked like it would be of interest for this group as well. --Patrick
    Message 1 of 1 , Oct 29, 2007
    • 0 Attachment
      This was posted on the 1D site and looked like it would be of interest for this group as well.
       
      --Patrick

      +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=++=+=+=+=+=+=+=+=+=+=+=+=+

      �Those who would renegotiate the boundaries between church and state must therefore answer a difficult question: Why would we trade a system that has served us so well for one that has served others so poorly?�
      - Sandra Day O'Connor, Van Orden v. Perry and McCreary County v. ACLU
       
      -------------- Forwarded Message: --------------
      From: "bobdc2" <bobdc2@...>
      To: MPD-1D@yahoogroups.com
      Subject: [MPD-1D] Obtaining the weekly/monthly crime summaries as a file
      Date: Mon, 29 Oct 2007 14:01:07 +0000


      Obtaining the weekly crime map summaries below now has the new feature that you can download the crime summaries into files with a "Narrative".

      However, there is a little work involved to put data into rich-text-format that preserves the columns of data for posting here.

      To obtain these crime summaries, go to the MPD crime map website:

      http://crimemap. dc.gov 

      "To examine crime in a specific area of interest, enter now. "

      Takes you here:

      "Search for Crimes"

      http://crimemap. dc.gov/presentat ion/query. asp 

      Option is for:

      MPD PSA or District  Other Geographic Area     
       
      Select:  "Police District" then

      Then the pull down menu changes and select MPD1

      You can select whatever time increment of crime you wish. You can view the crime stats compared to same period last year for 30 days. Note that for the last month, burglaries are up 81% [from 32 (for Oct. 06)  to 58 (Oct. 07) as are some other crimes in MPD-1D. The crimes may also be viewed as icons superimposed on a street map.

      You can also select to "download crime data" as a file within your web browser.
      The excel spreadsheet option is best I've found, since it preserves the columns that get lost/scrambled if you do "text-comma separated". You can add lots of different information to the file, but I find these options to be plenty [i.e., Report_Date, Shift, Offense, Block, PSA, CCN (criminal complaint number), and Narrative.] The crime data should then be displayed in your web browser with these options as the column title.

      Note, the program still has a few quirks, and sometimes hangs when you ask for the data file. Also, the PSAs and dates are somewhat out of order, something else that could be fixed. You can save the f ile to your hard drive using the "save as" option in your web browser, the saved file name with extension is "crime_data. xls.htm", so it has both the Excel spreadsheet extension and the htm extension. I delete the "htm" extension, and the file is now a MS Excel spreadsheet. To post on this listserve with  the columns preserved, I pull this into MS Word, and save as RTF-rich text format, and cut and paste below. Also, you can rename the file extension *.doc and your computer should directly convert to RTF provided you have MS Word. I will interact with the webpage folks to see if this can be simplified/streamli ned.

      Below is just a very small sample of all the crime for the last 2 weeks I cut and pasted by hand.  Its just the more violent armed robberies that appeared to involve people who did not know each other. Also, one of the Hill arsons is thrown in.

      Hope this is useful. A complete list is to follow.

      Bob

      PS When I actually went to post this message, I lost the column format anyway. Oh well, some of that discussion for nothing, though the selection of crimes reads well enough for now.
      ============ ========= ========= ========= ========= ========= ========= ========= ========= =

      10/15/2007    MID    ARSON    200 B/O 10TH ST SE    106    7141673    R-1 REPORTS THAT A FIRE WAS IGNITED IN AN UNKNOWN MANNER CAUSING DAMAGE TO THE REAR EXTERIOR WALL AND TRASH CANS.    

      10/15/2007    DAY    ROBBERY    1000 B/O 1ST ST NE    101    7141667    C-1 REPORTSS-1 EXITED HIS VEHICLE PRODUCED A GUN AND STATED TO C-1 GIVE ME YOUR CHANGE OR YOUR WALLET C-1 STATED I DO NOT HAVE ANY. S-1 THEN TOOK C-1 BAGS. S-1 GOT BACK INTO HIS VEHICLE. S-1 THRU S-3 FLED SOUTHBOUND ON FIRST STREET NE.     

      10/16/2007    DAY    ROBBERY    1300 B/O CORBIN PL NE    103    7142279    C1 STATES S1 APPROACHED ARMED WITH A SILVER .38 HANDGUN. S1 SAID GIVE ME YOUR MONEY C1 RESPONDED HE DID NOT HAVE ANYTHING. S1 SAID WALK TOWARD THE ALLEY WHERE S2 WAS STANDING. C1 REFUSED. S1 AND S2 FLED NORTH THROUGH THE ALLEY.   
       
      10/16/2007    EVN    ROBBERY    400 B/O 12TH ST NE    103    7142560    C-1 REPORTS THAT S-1 APPROACHED HIM IN THE REAR OF THE LISTED LOCATION AND STATED GIVE ME YOUR WALLET GIVE ME YOUR WALLET WHILE POINTING A BLACK HANDGUN AT HIM C-1 ADVISED S-1 THAT HE HAD NOTHING ON HIM.    

      10/17/2007    EVN    ROBBERY    900 B/O G ST SE    106    7143106 &nb sp;  C-1 RPTS THAT SHE WAS APPROACHED BY S-1 WHO STATED DO YOU KNOW WHAT TIME IT IS ? THEN SNATCHED HER HOUSE KEYS AND MADE GOOD HIS ESCAPE.    
       
      10/17/2007    EVN    BURGLARY    1100 B/O 8TH ST NE    102    7142633    C1 STATES HE AND C2 WERE INSIDE THE LISTED ADDRESS WHEN HE HEARD A KNOCK AT THE BACK DOOR. C1 OPENED THE DOOR AND WAS STRUCK IN THE HEAD WITH A DARK COLORED HANDGUN. S1-S5 THEN ENTERED THE ADDRESS. C1 AND C2 WERE ABLE TO FLEE.    

      10/17/2007    EVN    ADW    1200 B/O 4TH ST NW    101    7143081    C-1 REPORTS WHILE WALKING TO HIS VEHICLE HE WAS APPROACHED BY S-1 THRU S-3. S-1 PRODUCED A HANDGUN AND STATED GET ON THE GROUND. AS C-1 COMPLIED C-1 DEFENDED HIMSELF BY KNOCKING S-1 OFF BALANCE. C-1 CHASED S-1 SOUTH ON 4TH ST NW.    

      10/18/2007    EVN    ROBBERY    300 B/O 8TH ST SE    106    7143560    C-1 STATES THAT SHE WAS APPROACHED BY S-1 WHO STATED GIVE ME YOUR BAG OR I''M GOING TO KILL YOU . C-1 COMPLIED AND S-1 FLED THE SCENE IN A GRAY SEDAN.    

      10/20/2007    MID    ROBBERY    UNIT B/O M ST NE    101    7144227    C-1 WAS APPROACHED BY S-1 WHO STATED GIVE ME YOUR WALLET I''M NOT PLAYING. AS C-1 WAS REACHING FOR HIS WALLET HE WAS STRUCK IN THE HEAD BY S-1 WITH A BLACK HANDGUN AND THE LISTED PROPERTY WAS OBTAINED. S-1 FLED THE SCENE.    
       
      10/20/2007    MID    ROBBERY    600 B/O H ST NW    101    7144245    C1 REPORTS WHILE THEY WERE PARKED AT THE LISTED LOCATION THEY WERE APPROACHED BY THREE SUSPECTS. S1 PRODUCED A HANDGUN AND STATED YOU KNOW WHAT THIS IS GIVE IT UP THE MONEY . S1 THEN TOOK THE LISTED PROPERTY.    

      10/22/2007    UNK    ROBBERY    800 B/O 5TH ST NW    101    7145648    C1 REPORTS WHILE WALKING NORTH IN THE 800 BLK OF 5TH ST NW SHE WAS APPROACHED BY S1 FROM THE FRONT. S1 THEN PRODUCED A SEMI AUTOMATIC HAND GUN AND STATED TO C1 JUST LET IT GO . C1 COMPLIED WITH S1 DEMANDS AND HANDED OVER THE LISTED ITEMS.       
      10/23/2007    EVN    ROBBERY    400 B/O I ST SW    104    7146210    C1 STATES HE WAS WALKING THROUGH THE PARKING LOT AT I. ST. SW WHEN S1 AND S2 APPROACHED HIM FROM THE REAR. STATED GIVE IT UP GIVE IT UP AND C1 THEN TURNED AROUND AND S1 STRUCK HIM IN THE HEAD WITH A BLACK HANDGUN.    

      10/23/2007    DAY    BURGLARY    600 B/O F ST NE    102    7145851    C1 REPORTS WHILE SHE WAS HOME UPSTAIRS ON THE 2ND FLOOR SUSPECTS(S) UNKNOWN ENTERED HER BACKYARD IN A UNKNOWN MANNER. THEY ENTERED THE GARAGE THROUGH THE UNLOCKED DOOR AND ENTERED THE LISTED AUTO THROUGH THE UNLOCKED DRIVERS DOOR.    

      10/22/2007    MID    ROBBERY    100 B/O 19TH ST SE    107    7145768    C1 C2 & C3 STATES THEY WERE APPROACHED BY S1 - S5. S1 WAS ARMED WITH A LARGE HUNTING KNIFE AND SAID GIVE IT UP . C1 C2 AND C3 COMPLIED AND GAVE S1 THE LISTED PROPERTY.    

      10/23/2007    DAY    ROBBERY    400 B/O 15TH ST SE    107    7145937    C1 STATES HE WAS APPROACHED BY S1 AND S2. S1 S AID WHAT''S UP YOU GOT THE TIME? I HAVE A GUN GIVE ME YOUR WATCH AND WALLET . C1 GAVE S1 THE LISTED PROPERTY AND FLED SOUTH ON 15TH ST SE.    

      10/24/2007    MID    ADW    400 B/O 18TH ST NE    103    7146292    C1 STATES HE HEARD SOMEONE COUGH AND TURNED TO SEE WHO IT WAS WHEN HE TURNED HE WAS APPROACHED BY S1 AND S2. S1 POINTED A SHOTGUN AT C1 AND FIRED 3 TIMES. C1 FLED AFTER BEING SHOT IN THE CHEST AND LEFT ARM. S1 AND S2 FLED EAST BOUND.    

    Your message has been successfully submitted and would be delivered to recipients shortly.