ScraperWiki Classic is now read-only.

But don’t worry! You can transfer this scraper to Morph.io if you want to continue editing it.

Transfer to Morph.io

Current status

Idle – not scheduled to run

Last run

1 year ago

Scraped 113 pages from www.stpaul.gov

About this scraper

A project done as part of the Twin Cities Code For America Hackathon
See The Meetup for more details on the event.

The short term goal was to extract crime data from the weekly Excel file produced by the St Paul police department. See our map for a map of this data displayed on the CartoDB service. Ultimately, we want to provide this as a data feed for timely crime alerts and maps.

There is a separate scraperwiki project that combs through the St Paul web site and finds the URL for all of the spreadsheets. This list is the basis for the processing done by the StPaulCrimeStat scraperwiki.

We did not get time to deal with two data quality issues. First, some addresses have street names that we can't geocode because there are missing spaces, such as "OLDHUDSON RD". Second, some address are an intersection and only the first part is shown in the report, such as "MARION ST &"

Update: Google's geocoding service seems to handle these better than the arcgisonline geocoding service we were trying. If you take the data and import them into a Google Fusion table, it seems to handle most of the strange addresses.

There is a java application hosted on GitHub that illustrates how to query the fusion table and provide the user with a list of crimes near an address.

This scraper is public

Anyone can see this scraper, and any registered user can edit it.

Users who have contributed to this scraper:

DISP CODE DESCRIPTION INCIDENT_DESCRIPTION DC RAWADDRESS GRID ADDRESS DATE CN NEIGH_
A 1800 Narcotics Narcotics 1.0 36X PEDERSEN ST 120 360 PEDERSEN ST , St Paul, MN 2011-02-17T10:45:06 11031987 None
A 1800 Narcotics Narcotics 1.0 215X WILSON AV 120 2150 WILSON AV , St Paul, MN 2011-02-17T16:15:45 11032218 None
RR 710 Auto Theft Motor Vehicle Theft, Automobile 1.0 206X MARGARET ST 100 2060 MARGARET ST , St Paul, MN 2011-02-18T04:00:00 11032589 None
RR 861 Other Asasult Dom. Assault, Domestic, Opposite Sex 1.0 29X BIRMINGHAM ST 117 290 BIRMINGHAM ST , St Paul, MN 2011-02-18T16:00:00 11032915 None
RR 631 Theft Theft, Shoplifting, Under $500 1.0 213X OLDHUDSON RD 120 2130 OLDHUDSON RD , St Paul, MN 2011-02-18T17:20:00 11032969 None
R 1400 Vandalism Criminal Damage to Property 1.0 177X OLDHUDSON RD 118 1770 OLDHUDSON RD , St Paul, MN 2011-02-18T18:02:17 11033002 None
RR 651 Theft Theft, Auto Accessories, Under $500 1.0 17X MCKNIGHT RD N 140 170 MCKNIGHT RD N, St Paul, MN 2011-02-18T18:33:00 11033026 None
RR 430 Agg. Assault Aggravated Assault, Other Dangerous Weapons 1.0 215X WILSON AV 120 2150 WILSON AV , St Paul, MN 2011-02-18T18:47:00 11033042 None
RR 861 Other Asasult Dom. Assault, Domestic, Opposite Sex 1.0 47X HAZEL ST N 119 470 HAZEL ST N, St Paul, MN 2011-02-18T19:14:00 11033061 None
RR 210 Rape Rape, By Force 1.0 2XX KIPLING ST 160 200 KIPLING ST , St Paul, MN 2011-02-19T03:00:00 11033337 None
RR 862 Other Asasult Dom. Assault, Domestic, Family/Child 1.0 215X WILSON AV 120 2150 WILSON AV , St Paul, MN 2011-02-19T16:31:00 11033581 None
RR 643 Theft Theft, From Auto, Over $1000 1.0 21X MCKNIGHT RD S 160 210 MCKNIGHT RD S, St Paul, MN 2011-02-19T21:20:00 11033955 None
RR 691 Theft Theft, All Other, Under $500 1.0 149X 3 ST E 98 1490 3 ST E, St Paul, MN 2011-02-18T20:00:00 11034076 None
RR 971 Arson Arson, Motor Vehicle 1.0 HAZEL ST N & OLDHUDSON 119 HAZEL ST N & OLDHUDSON, St Paul, MN 2011-02-20T23:30:00 11034247 None
RR 971 Arson Arson, Motor Vehicle 1.0 27X WINTHROP ST N 120 270 WINTHROP ST N, St Paul, MN 2011-02-21T05:44:00 11034322 None
A 600 Theft Theft, Except Auto Theft 1.0 199X SUBURBAN AV 119 1990 SUBURBAN AV , St Paul, MN 2011-02-21T15:39:14 11034555 None
G 300 Robbery Robbery 1.0 181X WILSON AV 119 1810 WILSON AV , St Paul, MN 2011-02-21T19:14:11 11034675 None
RR 693 Theft Theft, All Other, Over $1000 1.0 219X OLDHUDSON RD 120 2190 OLDHUDSON RD , St Paul, MN 2011-02-18T13:19:00 11034753 None
RR 1410 Vandalism Criminal Damage to Property (Misdemeanor, Under $250) 1.0 191X BURNS AV 138 1910 BURNS AV , St Paul, MN 2011-02-22T06:34:00 11034881 None
G 600 Theft Theft, Except Auto Theft 1.0 184X OLDHUDSON RD 119 1840 OLDHUDSON RD , St Paul, MN 2011-02-22T10:51:59 11035053 None
A 600 Theft Theft, Except Auto Theft 1.0 194X OLDHUDSON RD 119 1940 OLDHUDSON RD , St Paul, MN 2011-02-22T10:56:47 11035055 None
A 1400 Vandalism Criminal Damage to Property 1.0 214X OLDHUDSON RD 120 2140 OLDHUDSON RD , St Paul, MN 2011-02-22T15:58:11 11035248 None
RR 861 Other Asasult Dom. Assault, Domestic, Opposite Sex 1.0 30X RUTH ST 120 300 RUTH ST , St Paul, MN 2011-02-22T21:44:00 11035480 None
A 600 Theft Theft, Except Auto Theft 1.0 215X WILSON AV 120 2150 WILSON AV , St Paul, MN 2011-02-22T23:09:34 11035520 None
RR 642 Theft Theft, From Auto, $501 to $1000 1.0 7X WINTHROP ST S 140 70 WINTHROP ST S, St Paul, MN 2011-02-22T07:30:00 11035695 None
A 1400 Vandalism Criminal Damage to Property 1.0 20X WINTHROP ST S 160 200 WINTHROP ST S, St Paul, MN 2011-02-23T23:08:49 11036278 None
RR 1410 Vandalism Criminal Damage to Property (Misdemeanor, Under $250) 2.0 172X HYACINTH AV E 38 1720 HYACINTH AV E, St Paul, MN 2011-02-17T12:00:00 11032169 None
RR 711 Auto Theft Motor Vehicle Theft, Trucks and Buses 2.0 148X 7 ST E 77 1480 7 ST E, St Paul, MN 2011-02-18 11032651 None
RR 861 Other Asasult Dom. Assault, Domestic, Opposite Sex 2.0 117X BARCLAY ST 57 1170 BARCLAY ST , St Paul, MN 2011-02-18T07:40:00 11032677 None
RR 710 Auto Theft Motor Vehicle Theft, Automobile 2.0 148X 7 ST E 77 1480 7 ST E, St Paul, MN 2011-02-18 11032754 None
RR 861 Other Asasult Dom. Assault, Domestic, Opposite Sex 2.0 185X BUSH AV 79 1850 BUSH AV , St Paul, MN 2011-02-18T21:30:00 11033181 None
RR 1410 Vandalism Criminal Damage to Property (Misdemeanor, Under $250) 2.0 176X 7 ST E 78 1760 7 ST E, St Paul, MN 2011-02-19T02:41:00 11033318 None
RR 1813 Narcotics Narcotics, Possession of Methamphetamine 2.0 87X JOHNSON PA 77 870 JOHNSON PA , St Paul, MN 2011-02-19T11:37:00 11033462 None
RR 710 Auto Theft Motor Vehicle Theft, Automobile 2.0 84X JOHNSON PA 77 840 JOHNSON PA , St Paul, MN 2011-02-19T14:34:00 11033528 None
RR 641 Theft Theft, From Auto, Under $500 2.0 180X AMES AV 59 1800 AMES AV , St Paul, MN 2011-02-19T16:07:00 11033570 None
RR 1835 Narcotics Narcotics, Possession of Marijuana 2.0 CASE AV & FLANDRAU 58 CASE AV & FLANDRAU, St Paul, MN 2011-02-19T16:43:00 11033591 None
RR 431 Agg. Assault Dom. Aggravated Assault, Domestic 2.0 117X BARCLAY ST 57 1170 BARCLAY ST , St Paul, MN 2011-02-19T17:08:00 11033609 None
R 1400 Vandalism Criminal Damage to Property 2.0 155X MCAFEE ST 17 1550 MCAFEE ST , St Paul, MN 2011-02-20T03:08:19 11033921 None
A 1400 Vandalism Criminal Damage to Property 2.0 159X MCAFEE ST 17 1590 MCAFEE ST , St Paul, MN 2011-02-20T03:32:17 11033927 None
RR 451 Agg. Assault Dom. Aggravated Assault, Domestic 2.0 144X 7 ST E 77 1440 7 ST E, St Paul, MN 2011-02-20T10:00:00 11033991 None
RR 710 Auto Theft Motor Vehicle Theft, Automobile 2.0 165X ARLINGTON AV E 38 1650 ARLINGTON AV E, St Paul, MN 2011-02-18T08:00:00 11034455 None
RR 442 Agg. Assault Dom. Aggravated Assault, Domestic 2.0 123X HERBERT ST 38 1230 HERBERT ST , St Paul, MN 2011-02-21T19:45:00 11034629 None
RR 862 Other Asasult Dom. Assault, Domestic, Family/Child 2.0 98X RUTH ST 59 980 RUTH ST , St Paul, MN 2011-02-22T13:00:00 11035070 None
RR 210 Rape Rape, By Force 2.0 HAZEL ST N & MAGNOLIA 59 HAZEL ST N & MAGNOLIA, St Paul, MN 2011-02-22T21:00:00 11035505 None
A 700 Auto Theft Motor Vehicle Theft 2.0 153X DIETER ST 17 1530 DIETER ST , St Paul, MN 2011-02-23T07:52:19 11035663 None
RR 1410 Vandalism Criminal Damage to Property (Misdemeanor, Under $250) 2.0 159X GARY PL 19 1590 GARY PL , St Paul, MN 2011-02-23 11035677 None
RR 1410 Vandalism Criminal Damage to Property (Misdemeanor, Under $250) 2.0 104X HAZELWOOD ST 57 1040 HAZELWOOD ST , St Paul, MN 2011-02-22T16:00:00 11036471 None
RR 862 Other Asasult Dom. Assault, Domestic, Family/Child 3.0 7X STEVENS ST W 193 70 STEVENS ST W, St Paul, MN 2011-02-17T09:30:00 11031940 None
A 1401 Graffiti Graffiti 3.0 23X ROBIE ST E 194 230 ROBIE ST E, St Paul, MN 2011-02-17T09:53:16 11031954 None
RR 861 Other Asasult Dom. Assault, Domestic, Opposite Sex 3.0 6X GEORGE ST W 193 60 GEORGE ST W, St Paul, MN 2011-02-18T00:36:00 11032522 None
R 1400 Vandalism Criminal Damage to Property 3.0 56X STRYKER AV 193 560 STRYKER AV , St Paul, MN 2011-02-18T02:07:29 11032565 None
A 1400 Vandalism Criminal Damage to Property 3.0 56X STRYKER AV 193 560 STRYKER AV , St Paul, MN 2011-02-18T02:39:06 11032575 None
RR 1410 Vandalism Criminal Damage to Property (Misdemeanor, Under $250) 3.0 64X OAKDALE AV 194 640 OAKDALE AV , St Paul, MN 2011-02-18T09:53:00 11032685 None
RR 1410 Vandalism Criminal Damage to Property (Misdemeanor, Under $250) 3.0 21X BAKER ST E 194 210 BAKER ST E, St Paul, MN 2011-02-18T13:00:00 11032762 None
RR 1410 Vandalism Criminal Damage to Property (Misdemeanor, Under $250) 3.0 CESAR CHAVEZ ST & WABASHA 193 CESAR CHAVEZ ST & WABASHA, St Paul, MN 2011-02-19T09:07:00 11033412 None
RR 1420 Vandalism Criminal Damage to Property (Gross Mis., $250-$500) 3.0 61X ORLEANS ST 192 610 ORLEANS ST , St Paul, MN 2011-02-19T20:32:00 11033733 None
RR 410 Agg. Assault Aggravated Assault, Firearm 3.0 CLINTON AV & CONGRESS 194 CLINTON AV & CONGRESS, St Paul, MN 2011-02-19T22:00:00 11033768 None
RR 510 Burglary Burglary, Forced Entry, Night, Residence 3.0 26X SIDNEY ST E 214 260 SIDNEY ST E, St Paul, MN 2011-02-19T23:15:00 11033902 None
A 600 Theft Theft, Except Auto Theft 3.0 50X OHIO ST 192 500 OHIO ST , St Paul, MN 2011-02-20T11:20:57 11034015 None
RR 543 Burglary Burglary, No Forced Entry, Day, Garage 3.0 64X DELAWARE AV 211 640 DELAWARE AV , St Paul, MN 2011-02-21T05:30:00 11034621 None
A 1401 Graffiti Graffiti 3.0 56X STATE ST 194 560 STATE ST , St Paul, MN 2011-02-21T20:46:21 11034722 None
R 1400 Vandalism Criminal Damage to Property 3.0 45X ROBERT ST S 173 450 ROBERT ST S, St Paul, MN 2011-02-22T08:39:19 11034956 None
R 500 Burglary Burglary 3.0 43X ROBERT ST S 173 430 ROBERT ST S, St Paul, MN 2011-02-22T09:44:09 11035000 None
RR 631 Theft Theft, Shoplifting, Under $500 3.0 46X ANITA ST 194 460 ANITA ST , St Paul, MN 2011-02-22T12:13:00 11035105 None
RR 1415 Graffiti Graffiti (Misdemeanor, Under $250) 3.0 56X STATE ST 194 560 STATE ST , St Paul, MN 2011-02-21T20:00:00 11035172 None
A 1401 Graffiti Graffiti 3.0 3X BAKER ST E 213 30 BAKER ST E, St Paul, MN 2011-02-22T14:03:12 11035175 None
RR 641 Theft Theft, From Auto, Under $500 3.0 34X PLATO BD 174 340 PLATO BD , St Paul, MN 2011-02-22T10:00:00 11035197 None
G 1800 Narcotics Narcotics 3.0 83X BARGECHANNEL RD 175 830 BARGECHANNEL RD , St Paul, MN 2011-02-22T15:37:02 11035236 None
RR 861 Other Asasult Dom. Assault, Domestic, Opposite Sex 3.0 12X WYOMING ST E 214 120 WYOMING ST E, St Paul, MN 2011-02-23T07:48:00 11035659 None
RR 1835 Narcotics Narcotics, Possession of Marijuana 3.0 3X BAKER ST E 213 30 BAKER ST E, St Paul, MN 2011-02-23T10:00:00 11035742 None
RR 1420 Vandalism Criminal Damage to Property (Gross Mis., $250-$500) 3.0 25X WABASHA ST S 193 250 WABASHA ST S, St Paul, MN 2011-02-23T09:55:00 11035745 None
RR 1835 Narcotics Narcotics, Possession of Marijuana 3.0 3X BAKER ST E 213 30 BAKER ST E, St Paul, MN 2011-02-23T10:00:00 11035775 None
RR 560 Burglary Att. Burglary, Forced Entry, Day, Residence 3.0 57X CHEROKEE AV 211 570 CHEROKEE AV , St Paul, MN 2011-02-23T11:52:00 11035824 None
R 640 Theft Theft, From Auto 3.0 4X ISABEL ST E 193 40 ISABEL ST E, St Paul, MN 2011-02-23T22:47:27 11036260 None
RR 1813 Narcotics Narcotics, Possession of Methamphetamine 4.0 EARL ST & MARGARET 96 EARL ST & MARGARET, St Paul, MN 2011-02-17T01:07:00 11031768 None
A 1400 Vandalism Criminal Damage to Property 4.0 127X WILSON AV 117 1270 WILSON AV , St Paul, MN 2011-02-17T08:49:21 11031913 None
A 600 Theft Theft, Except Auto Theft 4.0 115X BUSH AV 76 1150 BUSH AV , St Paul, MN 2011-02-17T09:13:19 11031929 None
A 600 Theft Theft, Except Auto Theft 4.0 34X MARIA AV 94 340 MARIA AV , St Paul, MN 2011-02-17T12:31:33 11032063 None
RR 530 Burglary Burglary, Forced Entry, Day, Residence 4.0 103X BUSH AV 75 1030 BUSH AV , St Paul, MN 2011-02-17T06:30:00 11032225 None
RR 1420 Vandalism Criminal Damage to Property (Gross Mis., $250-$500) 4.0 30X EARL ST 115 300 EARL ST , St Paul, MN 2011-02-17T16:15:00 11032231 None
RR 691 Theft Theft, All Other, Under $500 4.0 26X BATES AV 114 260 BATES AV , St Paul, MN 2011-02-17T15:30:00 11032270 None
A 500 Burglary Burglary 4.0 112X BEECH ST 96 1120 BEECH ST , St Paul, MN 2011-02-19T14:46:37 11033535 None
RR 710 Auto Theft Motor Vehicle Theft, Automobile 4.0 100X JOHNSON PA 56 1000 JOHNSON PA , St Paul, MN 2011-02-19T17:30:00 11033691 None
RR 2619 Discharge Weapons, Discharging a Firearm in the City Limits 4.0 DULUTH ST & ROSS 76 DULUTH ST & ROSS, St Paul, MN 2011-02-19T19:46:00 11033710 None
RR 861 Other Asasult Dom. Assault, Domestic, Opposite Sex 4.0 65X NORTH ST 94 650 NORTH ST , St Paul, MN 2011-02-20T05:35:00 11033941 None
RR 692 Theft Theft, All Other, $501 to $1000 4.0 131X CONWAY ST 117 1310 CONWAY ST , St Paul, MN 2011-02-20T04:00:00 11033976 None
RR 530 Burglary Burglary, Forced Entry, Day, Residence 4.0 104X BUSH AV 75 1040 BUSH AV , St Paul, MN 2011-02-20T10:05:00 11033984 None
RR 642 Theft Theft, From Auto, $501 to $1000 4.0 65X NORTH ST 94 650 NORTH ST , St Paul, MN 2011-02-17T20:00:00 11033986 None
RR 511 Burglary Burglary, Forced Entry, Night, Residence, Occupied 4.0 114X HUDSON RD 117 1140 HUDSON RD , St Paul, MN 2011-02-22T02:03:00 11034912 None
RR 862 Other Asasult Dom. Assault, Domestic, Family/Child 4.0 26X MARIA AV 114 260 MARIA AV , St Paul, MN 2011-02-18 11035181 None
RR 1835 Narcotics Narcotics, Possession of Marijuana 4.0 97X BEECH ST 95 970 BEECH ST , St Paul, MN 2011-02-22T21:11:00 11035384 None
RR 441 Agg. Assault Dom. Aggravated Assault, Domestic 4.0 73X 3 ST E 114 730 3 ST E, St Paul, MN 2011-02-23T01:45:00 11035582 None
RR 710 Auto Theft Motor Vehicle Theft, Automobile 4.0 102X BUSH AV 75 1020 BUSH AV , St Paul, MN 2011-02-23T07:30:00 11035650 None
A 640 Theft Theft, From Auto 4.0 114X BUSH AV 76 1140 BUSH AV , St Paul, MN 2011-02-23T12:09:56 11035833 None
RR 1420 Vandalism Criminal Damage to Property (Gross Mis., $250-$500) 4.0 110X MARGARET ST 96 1100 MARGARET ST , St Paul, MN 2011-02-23T18:00:00 11036233 None
RR 513 Burglary Burglary, Forced Entry, Night, Garage 5.0 64X IVY AV E 34 640 IVY AV E, St Paul, MN 2011-02-17T00:14:00 11031746 None
A 700 Auto Theft Motor Vehicle Theft 5.0 76X ROSE AV E 54 760 ROSE AV E, St Paul, MN 2011-02-17T06:11:15 11031838 None
RR 691 Theft Theft, All Other, Under $500 5.0 32X COOK AV E 53 320 COOK AV E, St Paul, MN 2011-02-17T08:22:00 11031893 None
A 600 Theft Theft, Except Auto Theft 5.0 98X PAYNE AV 54 980 PAYNE AV , St Paul, MN 2011-02-17T09:22:02 11031937 None
RR 862 Other Asasult Dom. Assault, Domestic, Family/Child 5.0 40X CASE AV 53 400 CASE AV , St Paul, MN 2011-02-17T12:54:00 11032023 None
March 2013
Permalink Hide details Show details 1362956449.541528_2064e6ef-54d5-4675-ba67-303f126659e5 23:08, 10 March 2013 1362955631.794032_c592d4c1-0795-498a-a996-a144b0f10ff5 22:55, 10 March 2013
Run succeeded: - ran 2 times, most recently for 2523 seconds (113 scraped pages, 54878 records) 23:08, 10 March 2013

Loading...


          
Permalink Hide details Show details 1362955609.617689_37bf5278-d187-405e-b338-997f1e241b31 22:46, 10 March 2013
Run failed: SqliteError: sqliteexecute: sqlite3.Error: no such table: swdata - ran for 0 seconds (0 scraped pages, 0 records) 22:46, 10 March 2013

Loading...


          
Permalink Hide details Show details 1362941904.081133_a44fbafc-0d29-47c9-a5cf-1032b87409bb 18:59, 10 March 2013 1362941789.145012_90047939-d0df-4b20-a3bd-4ea68b2653bd 18:56, 10 March 2013
Run succeeded: - ran 2 times, most recently for 2532 seconds (0 scraped pages, 54878 records) 18:59, 10 March 2013

Loading...


          
Permalink Hide details Show details 1362941764.590894_bd39f568-1be1-4ef1-a7f9-057dcbea2010 18:56, 10 March 2013
Run failed: NameError: global name 'zeros' is not defined - ran for 0 seconds (0 scraped pages, 0 records) 18:56, 10 March 2013

Loading...


          
Permalink Hide details Show details 1362941679.094001_ad5d3a3e-d3b8-4a71-83a0-0f3f730c27b6 18:54, 10 March 2013
Run failed: TypeError: list indices must be integers, not str - ran for 1 seconds (0 scraped pages, 0 records) 18:54, 10 March 2013

Loading...


          
Permalink Hide details Show details 1362941645.349060_e50ea511-91b9-4f0d-b584-42ca91743fe4 18:54, 10 March 2013 1362941587.732111_d74b5c19-2f60-4366-87b0-6ed3a499a32f 18:53, 10 March 2013
Run failed: KeyError: 'values' - ran for 0 seconds (0 scraped pages, 0 records) 18:54, 10 March 2013

Loading...


          
Permalink Hide details Show details 1362941581.095843_c1d34f85-a68c-498a-af1d-4620815592eb 18:53, 10 March 2013
Run failed: SyntaxError: invalid syntax (<string>, line 119) - ran for 0 seconds (0 scraped pages, 0 records) 18:53, 10 March 2013

Loading...


          
February 2013
Hide changes Show changes 9 19:56, 23 February 2013 8 8 19:56, 23 February 2013 7 7 19:56, 23 February 2013 6 6 19:54, 23 February 2013 5 5 19:54, 23 February 2013 4 4 19:53, 23 February 2013 3 3 19:52, 23 February 2013 2 2 19:52, 23 February 2013 1 1 19:52, 23 February 2013 0
Edited by Michael Altmann 9 times 19:56, 23 February 2013

Loading...

Difference between, revision and previous revision


            
Hide first version Show first version 0 19:48, 23 February 2013
Edited by Michael Altmann 19:48, 23 February 2013

Loading...

Difference between, revision and previous revision