Fairfax County General :
Fairfax Underground
Welcome to Fairfax Underground, a project site designed to improve communication among residents of Fairfax County, VA. Feel free to post anything Northern Virginia residents would find interesting.
Welcome to Fairfax Underground, a project site designed to improve communication among residents of Fairfax County, VA. Feel free to post anything Northern Virginia residents would find interesting.
Arrest/Ticket search now active!
Posted by:
admin
()
Date: February 25, 2005 08:12PM
Although the interface is pretty crappy right now I am making the arrest search live.
I am reading up on perl and getting some good outside help to make this better.
Try searching for your street name or something and see what it pulls up. Goes back about 2 years.
*click the link below to go to the arrest list:
http://www.fairfaxunderground.com/arrests
Any comments or suggestions? Let me know.
- Admin
edit: i guess this doesn't have to be sticky anymore
Edited 4 time(s). Last edit at 04/01/2005 03:30AM by Cary.
I am reading up on perl and getting some good outside help to make this better.
Try searching for your street name or something and see what it pulls up. Goes back about 2 years.
*click the link below to go to the arrest list:
http://www.fairfaxunderground.com/arrests
Any comments or suggestions? Let me know.
- Admin
edit: i guess this doesn't have to be sticky anymore
Edited 4 time(s). Last edit at 04/01/2005 03:30AM by Cary.
Re: Arrest/Ticket search now active!
Posted by:
admin
()
Date: February 26, 2005 08:45PM
I got some questions about this so I'll answer them.
Yes, this database has all traffic tickets and arrests.
One of the really cool features is to search by street name. I, for example, didn't know my neighbor got a DUI. You can also search for last name, first name, etc. Let me know if there are any more questions.
Yes, this database has all traffic tickets and arrests.
One of the really cool features is to search by street name. I, for example, didn't know my neighbor got a DUI. You can also search for last name, first name, etc. Let me know if there are any more questions.
Re: Arrest/Ticket search now active!
Posted by:
anonymous coward
()
Date: February 28, 2005 07:15PM
wow very cool but when i search for my last name (charles) i get so many matches that i can't even see my speeding ticket. please get the new search up soon this is so cool.
- some slashhead
- some slashhead
Re: Arrest/Ticket search now active!
Posted by:
admin
()
Date: February 28, 2005 10:50PM
Yeah I know common names will overflow the list. Try searching for your street name instead. I wrote a perl script to do individual field matching (like search last name: charles) but it took so freaking long to go through the file that it wouldn't work. i'm trying it now with c++. if anyone has more skills than me please let me know. - admin
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: March 02, 2005 11:36PM
new feature added to count the amount of results found. this way if you search for something like "dwi" you will get a number of how many are found. unfortunately due to bandwidth constraints you will still only be able to see the first 100 matches. i am working on a way to make it so you can search for "dwi" and "vienna" and display the list that matches both. of course i would still love to be able to search each field individually, but this will have to do for now. questions? comments? throw em' at me
Edited 1 time(s). Last edit at 02/16/2006 07:55AM by Cary.
Edited 1 time(s). Last edit at 02/16/2006 07:55AM by Cary.
List UPDATED!
Posted by:
Cary
()
Date: March 05, 2005 03:52PM
You can now search for up to 3 strings at a time to narrow down your search. For example you can search for DWI and McLean to see the DWI arrests from McLean. Results are still limited to 100 lines.
Yes this is the same thing it says on the page because I'm lazy. Go click the link up top and go check it out.
- Cary
Yes this is the same thing it says on the page because I'm lazy. Go click the link up top and go check it out.
- Cary
Re: Arrest/Ticket search now active!
Posted by:
BK
()
Date: March 05, 2005 04:02PM
hey good job man this is awesome.
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: March 06, 2005 03:28PM
i've gotten some questions as to how up-to-date this list is. the answer is very up-to-date. this list automatically updates itself every wednesday night at 8:00pm EST. incidents occuring within the last week are usually reported. more serious incidents in which an investigation follows may take an additional week for the paperwork to go through and the arrest to appear on this list.
Re: Arrest/Ticket search now active!
Posted by:
johnyfitz
()
Date: March 08, 2005 10:31PM
just wondering, what do the R and T mean in the 3rd field and what does the number after that mean?
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: March 08, 2005 10:39PM
the third field is middle initial
the fourth is age at the time of arrest
the rest are pretty self explanatory
enjoy
the fourth is age at the time of arrest
the rest are pretty self explanatory
enjoy
Fairfax County - Out of Control!
Posted by:
Chip
()
Date: March 09, 2005 10:07AM
Fairfax County spending is out of control. I can't believe more individuals are not concerned with the amount of money they want for us for little services. Fairfax County has become a WELFARE DUMP and we are asked to pay for it. Connolly can only talk about affordable housing at our expense.
I would like to get your feed back.
I would like to get your feed back.
Re: Arrest/Ticket search now active!
Posted by:
sk8chik
()
Date: March 15, 2005 01:40PM
holy crap someone on my little court has a rape charge! i thought they had to register as a sex offender and tell us or something
Re: Arrest/Ticket search now active!
Posted by:
Nik
()
Date: March 18, 2005 11:12AM
thats just scary, sk8chik.
Re: Arrest/Ticket search now active!
Posted by:
Nik
()
Date: March 18, 2005 11:55AM
hey, how about a different font? something a little easier on the eyes?
----------------
WHERE'S THE BEEF
----------------
WHERE'S THE BEEF
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: March 18, 2005 04:46PM
i wish it was that easy. not sure how much you know about html but right now the raw text just gets dumped out with the < pre > tags. i need a little script to parse the output and display it nicely but haven't found one that's good enough yet.
Re: Arrest/Ticket search now active!
Posted by:
Nik
()
Date: March 18, 2005 10:49PM
that sucks. do you have any upcoming changes up your sleeve?
----------------
WHERE'S THE BEEF
----------------
WHERE'S THE BEEF
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: March 18, 2005 11:17PM
yeah all sorts of shit up my sleeve. just need the time for it. made the sight a little prettier earlier today, getting ride of that big ugly frame at the bottom and putting in new sections up top. any ideas?
Re: Arrest/Ticket search now active!
Posted by:
Nik
()
Date: March 19, 2005 01:56PM
How about a section of the forum devoted to events going on in FFX, like Halo 2 LAN parties and other fun stuff not involving drinking or hookah, so underage people like myself have somewhere to turn to find something to do.
----------------
WHERE'S THE BEEF
----------------
WHERE'S THE BEEF
Re: Arrest/Ticket search now active!
Posted by:
ben
()
Date: March 19, 2005 02:11PM
You're all about the Halo 2, aren't you?
Re: Arrest/Ticket search now active!
Posted by:
Nik
()
Date: March 19, 2005 03:27PM
Damn straight.
----------------
WHERE'S THE BEEF
----------------
WHERE'S THE BEEF
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: March 19, 2005 03:52PM
hahaha. start one! click New Topic on the forum list page and say like Halo 2 Lan party or something as the subject. I'm gonna change "New topic" to "Post new message" or something pretty soon so it's more clear.
post it here or it western fairfax.
of course be careful who you meet on this board, i'm sure there are some unsavory characters.
post it here or it western fairfax.
of course be careful who you meet on this board, i'm sure there are some unsavory characters.
Re: Arrest/Ticket search now active!
Posted by:
ben
()
Date: March 19, 2005 03:55PM
Yeah, like Cary. I wouldn't want to be alone with him in a dark alley.
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: March 19, 2005 04:04PM
lol me neither.
i wouldn't want to have to rob him.
i wouldn't want to have to rob him.
Re: Arrest/Ticket search now active!
Posted by:
Nik
()
Date: March 19, 2005 06:50PM
Of course I'll be careful.
*stashes rubber band gun in pocket*
/got nothing
----------------
WHERE'S THE BEEF
*stashes rubber band gun in pocket*
/got nothing
----------------
WHERE'S THE BEEF
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: April 01, 2005 03:30AM
de-stickyed this thread.
if you have any questions about anything post it here.
if you have any questions about anything post it here.
Re: Arrest/Ticket search now active!
Posted by:
mikehunt
()
Date: April 01, 2005 06:56PM
why dont i show up do you have to be 18 or something?
Re: Arrest/Ticket search now active!
Posted by:
mike
()
Date: April 03, 2005 09:59PM
how do i search for someones record
Re: Arrest/Ticket search now active!
Posted by:
sam
()
Date: April 03, 2005 10:02PM
click the ticket search up top foo
Re: Arrest/Ticket search now active!
Posted by:
mike
()
Date: April 03, 2005 10:18PM
what if im searching by name
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: April 05, 2005 01:05PM
wow, stupid aol users. i think it's pretty clear. read the text at the top of the arrest search page. it will answer everything for you.
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: April 08, 2005 03:15AM
Arrest list database updated! I dug up some weekly arrest lists from various machines around my house and filled in some gaps. In total 6 new weeks worth of arrests were added to the database. The database will continue to automatically update every wednesday night at 8:00pm with the latest information. This now brings the total number of arrests on file to 266,005!
There are still a few scattered holes in the database from the past several years, but I am actively trying to fill those as well. If you have any weekly arrest lists archived for some reason please run a couple names on it against the list on this site. If you think you have found a plug to one of the holes please let me know! Mad props is all I can offer. Thanks.
There are still a few scattered holes in the database from the past several years, but I am actively trying to fill those as well. If you have any weekly arrest lists archived for some reason please run a couple names on it against the list on this site. If you think you have found a plug to one of the holes please let me know! Mad props is all I can offer. Thanks.
taking it in another direction
Posted by:
jk
()
Date: April 20, 2005 02:44PM
It'd be interesting to map violations to identify where what types of violations occur. Might illustrate particular police tactics used in various spots to target specific violations.
Something like http://www.buzztracker.org but with a menu letting you choose which violations.
Just a thought. Awesome project as it is.
Something like http://www.buzztracker.org but with a menu letting you choose which violations.
Just a thought. Awesome project as it is.
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: April 20, 2005 02:56PM
Interesting thought jk.
Unfortunately the addresses on the ticket list show the place of residence, not the location of where the crime occured.
It would still be interesting to get a breakdown on where the majority of offenders live.
I'd have to create a map of the county with every street name embedded and figure out a way to transpose the arrests onto it.
Anyone work at mapquest and want to hook me up with your database? :)
Unfortunately the addresses on the ticket list show the place of residence, not the location of where the crime occured.
It would still be interesting to get a breakdown on where the majority of offenders live.
I'd have to create a map of the county with every street name embedded and figure out a way to transpose the arrests onto it.
Anyone work at mapquest and want to hook me up with your database? :)
Re: Arrest/Ticket search now active!
Posted by:
pgens
()
Date: April 21, 2005 07:27AM
Don't worry about street, zip code would be easier.
Re: Arrest/Ticket search now active!
Posted by:
Matt
()
Date: April 21, 2005 06:23PM
Great feature for your site! I was pointed here form Live Journal- I'd love to be able to set the amount of results I see, or even see all 4,000 results on multiple pages. It'd be great for research purposes.
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: April 21, 2005 06:44PM
I agree. Previously the only limitation was bandwidth, but now bandwidth is virtually unlimited. I will look into expanding the search result capability.
Re: Arrest/Ticket search now active!
Posted by:
barry
()
Date: April 22, 2005 12:16AM
xxx
Re: Arrest/Ticket search now active!
Posted by:
MrDoctor
()
Date: April 24, 2005 01:04PM
anyody know a good lawyer for possession charges in prince william county
Re: Arrest/Ticket search now active!
Posted by:
rstidman
()
Date: April 24, 2005 05:10PM
kevin wilson did some good work for me last year on a serious reckless charge in PWC
Re: Arrest/Ticket search now active!
Posted by:
MrDoctor
()
Date: April 24, 2005 09:44PM
nice, thanks ill pass the info along
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: April 25, 2005 12:14AM
kelly dennis never let me down in fairfax, and he's cheap! probably does pw too.
you might want to start a new thread, there's at least two lawyers that read this board that might be able to help
you might want to start a new thread, there's at least two lawyers that read this board that might be able to help
Re: Arrest/Ticket search now active!
Posted by:
dlee
()
Date: April 25, 2005 04:51PM
John O'Neill
703.807.5800
If I needed a criminal lawyer, he's the one I'd call.
703.807.5800
If I needed a criminal lawyer, he's the one I'd call.
Re: Arrest/Ticket search now active!
Posted by:
Layman
()
Date: May 27, 2005 09:39AM
Awesome tool.
Searching by zipcode would be a nice addition, and not too difficult to add.
Searching by zipcode would be a nice addition, and not too difficult to add.
Re: Arrest/Ticket search now active!
Posted by:
pgens
()
Date: May 27, 2005 01:06PM
Layman: this would be a bit difficult to add because the arrest listings don't list zip code.
Re: Arrest/Ticket search now active!
Posted by:
Victoria
()
Date: May 30, 2005 02:14PM
I am doing a project for school and need to cite your arrest/ticket search thingy in the bibliography... but first i need to make sure it's credible. how do you get your information about the tickets and arrests? where do you get it from? how accurate is it?
thanks
thanks
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: May 30, 2005 03:03PM
Victoria Wrote:
-------------------------------------------------------
> I am doing a project for school and need to cite
> your arrest/ticket search thingy in the
> bibliography... but first i need to make sure it's
> credible. how do you get your information about
> the tickets and arrests? where do you get it from?
> how accurate is it?
Victoria -
Very accurate. All information is pulled directly from the Fairfax County police website. You can always view the current weekly arrest list at on the official website at http://www.co.fairfax.va.us/ps/police/reports/Arrest.txt
All I have done is simply pull down this weekly arrest list once a week for the last couple years and made it into a database.
If you have any other questions let me know.
-------------------------------------------------------
> I am doing a project for school and need to cite
> your arrest/ticket search thingy in the
> bibliography... but first i need to make sure it's
> credible. how do you get your information about
> the tickets and arrests? where do you get it from?
> how accurate is it?
Victoria -
Very accurate. All information is pulled directly from the Fairfax County police website. You can always view the current weekly arrest list at on the official website at http://www.co.fairfax.va.us/ps/police/reports/Arrest.txt
All I have done is simply pull down this weekly arrest list once a week for the last couple years and made it into a database.
If you have any other questions let me know.
Re: Arrest/Ticket search now active!
Posted by:
Tim
()
Date: June 01, 2005 10:21PM
This tool is extremely cool. It's a little creepy that someone can pull down your unlisted home address if you've even gotten a speeding ticket. But it's cool to see that people I remember from long ago are still in the area.
Re: Arrest/Ticket search now active!
Posted by:
rstidman
()
Date: June 01, 2005 10:37PM
this tool is good but the VA pilot website has a much more advanced tool. You can look up by jurisdiction for the entire state. Cary has a link to it somewhere on here.
Cary's tool has the easy functionality that I wish the pilot website had. On the reverse, the pilot website obviously has a ton more data. Despite what that site may say, it has data going back to 98 for just about all jurisdictions listed.
Cary's tool has the easy functionality that I wish the pilot website had. On the reverse, the pilot website obviously has a ton more data. Despite what that site may say, it has data going back to 98 for just about all jurisdictions listed.
Re: Arrest/Ticket search now active!
Posted by:
darkfusion
()
Date: June 05, 2005 11:08AM
It would be nice to have the fields seperated and the data cleaned up a bit so I wrote a python script to do it. I hope the admin takes and uses it. If you need any help post back to this thread and I will see what I can do.
#!/usr/bin/python
import urllib
import re
import datetime
import time
data = urllib.urlopen("http://www.co.fairfax.va.us/ps/police/reports/Arrest.txt")
expr = re.compile("^\"(?P.*)\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P\d+)\",\"\s*(?P.*)\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P.*)\",\"(?P.*)\".*")
cleaned = []
for line in data:
m = expr.match(line)
firstName = m.group('First').strip().title()
middleInitial = m.group('MI').strip()
lastName = m.group('Last').strip().title()
if (middleInitial):
print "Name: %s %s. %s" % (firstName, middleInitial, lastName)
else:
print "Name: %s %s" % (firstName, lastName)
age = int(m.group("Age"))
print age
streetNumber = m.group("StNum").strip()
street = m.group("Street").strip().title()
streetPostfix = m.group("STP").strip().title()
city = m.group("City").strip().title()
state = m.group("State").strip()
print "Address: %s %s %s\n %s, %s" % (streetNumber, street, streetPostfix, city, state)
offenseDate = datetime.datetime.fromtimestamp(time.mktime(time.strptime(m.group("Date"),"%m/%d/%Y")))
offense = m.group("Violation").strip()
cleaned.append([(firstName, middleInitial, lastName), (city, state), offenseDate, offense])
#!/usr/bin/python
import urllib
import re
import datetime
import time
data = urllib.urlopen("http://www.co.fairfax.va.us/ps/police/reports/Arrest.txt")
expr = re.compile("^\"(?P.*)\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P\d+)\",\"\s*(?P.*)\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P.*)\",\"(?P.*)\".*")
cleaned = []
for line in data:
m = expr.match(line)
firstName = m.group('First').strip().title()
middleInitial = m.group('MI').strip()
lastName = m.group('Last').strip().title()
if (middleInitial):
print "Name: %s %s. %s" % (firstName, middleInitial, lastName)
else:
print "Name: %s %s" % (firstName, lastName)
age = int(m.group("Age"))
print age
streetNumber = m.group("StNum").strip()
street = m.group("Street").strip().title()
streetPostfix = m.group("STP").strip().title()
city = m.group("City").strip().title()
state = m.group("State").strip()
print "Address: %s %s %s\n %s, %s" % (streetNumber, street, streetPostfix, city, state)
offenseDate = datetime.datetime.fromtimestamp(time.mktime(time.strptime(m.group("Date"),"%m/%d/%Y")))
offense = m.group("Violation").strip()
cleaned.append([(firstName, middleInitial, lastName), (city, state), offenseDate, offense])
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: June 06, 2005 04:41PM
Nice. Thank you very much darkfusion, this will make the display much prettier. What I REALLY need is a script to search through the master text file by individual field instead of just grepping for strings like I do now. I whipped up something in perl a couple months ago but it was so god-awfully slow that I decided to keep this interface for now.
Anyway, I tried to run your code and got some errors:
Traceback (most recent call last):
File "./python.py", line 4, in ?
import datetime
ImportError: No module named datetime
commented out that line for the hell of it and got:
Traceback (most recent call last):
File "./python.py", line 9, in ?
expr = re.compile("^\"(?P.*)\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P\d+)\",\"\s*(?P.*)\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P.*)\",\"(?P.*)\".*")
File "/usr/lib/python2.2/sre.py", line 178, in compile
return _compile(pattern, flags)
File "/usr/lib/python2.2/sre.py", line 228, in _compile
raise error, v # invalid expression
sre_constants.error: unknown specifier: ?P.
Is my version of python too old? I'm running python-2.2.1-17
thanks again
Anyway, I tried to run your code and got some errors:
Traceback (most recent call last):
File "./python.py", line 4, in ?
import datetime
ImportError: No module named datetime
commented out that line for the hell of it and got:
Traceback (most recent call last):
File "./python.py", line 9, in ?
expr = re.compile("^\"(?P.*)\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P\d+)\",\"\s*(?P.*)\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P.*)\",\"(?P\w*)\s*\",\"(?P.*)\",\"(?P.*)\".*")
File "/usr/lib/python2.2/sre.py", line 178, in compile
return _compile(pattern, flags)
File "/usr/lib/python2.2/sre.py", line 228, in _compile
raise error, v # invalid expression
sre_constants.error: unknown specifier: ?P.
Is my version of python too old? I'm running python-2.2.1-17
thanks again
Re: Arrest/Ticket search now active!
Posted by:
Nik
()
Date: June 08, 2005 10:32AM
If there's an update to Python available, I'd guess that's the case. But what the hell do I know?
----------------
WHERE'S THE BEEF
----------------
WHERE'S THE BEEF
Re: Arrest/Ticket search now active!
Posted by:
darkfusion
()
Date: June 08, 2005 09:37PM
As for the field thing you probably want to use this script to get all of the data into a database. That should make it quicker and allow for searches on any of the fields. MySQL is the free database which I prefer. Interfacing the script should not be much work at all.
As for the python thing I thought datetime was a standard module. The version of python that I am running is 2.3 and that is actually a release behind. I would try upgrading it if you can. You should be able to run the script on your local machine without having to install it on the server.
If you run windows there is a great setup program available at: http://www.python.org/ftp/python/2.3.5/Python-2.3.5.exe
I breifly thought about an interface of the search results to google maps. I am not sure how people would feel about that.
As for the python thing I thought datetime was a standard module. The version of python that I am running is 2.3 and that is actually a release behind. I would try upgrading it if you can. You should be able to run the script on your local machine without having to install it on the server.
If you run windows there is a great setup program available at: http://www.python.org/ftp/python/2.3.5/Python-2.3.5.exe
I breifly thought about an interface of the search results to google maps. I am not sure how people would feel about that.
Re: Arrest/Ticket search now active!
Posted by:
johnnye
()
Date: June 13, 2005 08:31PM
I'm not sure where you're pulling your data from, but this is the site I use for my searches. Its all of VA, done by county, active and inactive.
http://208.210.219.132/vadistrict/select.jsp;jsessionid=00002LG1PYWOHNQ3KO2KQ3FEP3Y:ulnfn1uq
http://208.210.219.132/vadistrict/select.jsp;jsessionid=00002LG1PYWOHNQ3KO2KQ3FEP3Y:ulnfn1uq
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: June 14, 2005 05:55AM
The VA courts lookup is very useful. It's in the links section above.
The data for this list comes from: http://www.co.fairfax.va.us/ps/police/reports/Arrest.txt (warning 500k text file) which is released by the fairfax county police department every week.
The data for this list comes from: http://www.co.fairfax.va.us/ps/police/reports/Arrest.txt (warning 500k text file) which is released by the fairfax county police department every week.
Re: Arrest/Ticket search now active!
Posted by:
Quentusrex
()
Date: June 14, 2005 05:36PM
If you want to make searching easier, and queries much easier and faster set up a MySQL server. Then you can write a python script that downloads all the lists, and enters them into the database. The advantage is that you can query the MySQL database by certain values, like last name only, or street name only. And having the MySQL database would make it easy to add other attributes, like zip codes to the area the arrestee lives.
If you want more info about it just take an old computer with a decent hard drive, and use the Debian Net-Installer and tell it to set up a MySQL server(and workstation is advised for easy admin purposes). And that whole process would only take maybe 4-10 hours depending on how familiar you are with linux and your download rate.
Let me know if I can be of more help. I can code and I have experience as a Linux Admin.
If you want more info about it just take an old computer with a decent hard drive, and use the Debian Net-Installer and tell it to set up a MySQL server(and workstation is advised for easy admin purposes). And that whole process would only take maybe 4-10 hours depending on how familiar you are with linux and your download rate.
Let me know if I can be of more help. I can code and I have experience as a Linux Admin.
Re: Arrest/Ticket search now active!
Posted by:
jim
()
Date: July 13, 2005 02:10PM
It looks like you may be going to a MySQL database. I would like to offer my (free) services to help you build the database and create a web interface to query the database. Please cotact me if you would like my help
Re: Arrest/Ticket search now active!
Posted by:
The Drake
()
Date: July 14, 2005 03:57PM
I think it's important for people to remember that these are only arrest details, not convictions. How would you feel if people were judging you without knowing the facts? BTW - no I am not saying this because I am on there! :-)
As far as worring about privacy, if you bought a home that's public domain and your address is available. I went to something as simple as WP.com and found tons of pro athletes addresses based on a buyer search.
As far as worring about privacy, if you bought a home that's public domain and your address is available. I went to something as simple as WP.com and found tons of pro athletes addresses based on a buyer search.
Re: Arrest/Ticket search now active!
Posted by:
Gravis
()
Date: July 16, 2005 07:42AM
The Drake,
> "I think it's important for people to remember that these are only arrest details, not convictions. How would you feel if people were judging you without knowing the facts?"
but the system does judge you without knowing the facts... so why can't we? :)
"the wisdom of the wise will perish, the intelligence of the intelligent will vanish."
> "I think it's important for people to remember that these are only arrest details, not convictions. How would you feel if people were judging you without knowing the facts?"
but the system does judge you without knowing the facts... so why can't we? :)
"the wisdom of the wise will perish, the intelligence of the intelligent will vanish."
Re: Arrest/Ticket search now active!
Posted by:
darkfusion
()
Date: July 24, 2005 02:28PM
Hey Cary,
It was sweet meeting up at the party last night. I know you said you still had problems getting the python parsing script to run. If you post the output I might be able to try to figure it out.
It was sweet meeting up at the party last night. I know you said you still had problems getting the python parsing script to run. If you post the output I might be able to try to figure it out.
Re: Arrest/Ticket search now active!
Posted by:
FourFingerFreddy
()
Date: July 27, 2005 08:58PM
How come they ain't got don geranimos arrest for pot on here
Re: Arrest/Ticket search now active!
Posted by:
kklare
()
Date: July 27, 2005 09:30PM
here ya go, dummy:
"FERMAN ","GERONIMO ","B","037"," 6330","PHYLLIS ","LN","ALEXANDRIA ","VA","11/12/2001","FAIL PAY FULL TIME & ATTENTION "
by the way, what the hell kind of ticket is that? geez, if failing to pay attention warrants a citation, everyone would be ticketed!
"FERMAN ","GERONIMO ","B","037"," 6330","PHYLLIS ","LN","ALEXANDRIA ","VA","11/12/2001","FAIL PAY FULL TIME & ATTENTION "
by the way, what the hell kind of ticket is that? geez, if failing to pay attention warrants a citation, everyone would be ticketed!
Re: Arrest/Ticket search now active!
Posted by:
rstidman
()
Date: July 27, 2005 10:19PM
don's pot and coke arrests happened before 1997, Cary does not have the records for that far back AFAIK. If you look at the Virginia Courts Case information website, you can find his convictions there.
Re: Arrest/Ticket search now active!
Posted by:
kklare
()
Date: July 27, 2005 10:34PM
i know he was busted for pot, but when did they get him for coke?
Re: Arrest/Ticket search now active!
Posted by:
rstidman
()
Date: July 27, 2005 10:40PM
According to this article, just a year before the pot bust. Amazing he didn't do real time.
http://www.washingtonpost.com/wp-srv/sports/redskins/longterm/1998/camp98/articles/geronimo7.htm
Edited 1 time(s). Last edit at 07/27/2005 10:41PM by rstidman.
http://www.washingtonpost.com/wp-srv/sports/redskins/longterm/1998/camp98/articles/geronimo7.htm
Edited 1 time(s). Last edit at 07/27/2005 10:41PM by rstidman.
ticket for radar detector not received from officer
Posted by:
raymond c. obertone
()
Date: July 29, 2005 07:54PM
A fairfax county officer had me sign a ticket for having a not activated radar detector on the dash in my car. But after and I quote Educated Me and having me sign the tickett he failed to give it to me. What do I do now?
Re: Arrest/Ticket search now active!
Posted by:
rstidman
()
Date: July 29, 2005 11:19PM
Once you have signed it you are responsible for it. I have had this happen and the ticket was sent to me in the mail.
Re: ticket for radar detector not received from officer
Posted by:
SWweeman
()
Date: July 30, 2005 12:32PM
raymond c. obertone Wrote:
-------------------------------------------------------
> A fairfax county officer had me sign a ticket for
> having a not activated radar detector on the dash
> in my car. But after and I quote Educated Me and
> having me sign the tickett he failed to give it to
> me. What do I do now
Call the courthouse and find out if it has posted. In VA, a radar retector does not have to be plugged in to get a summons. You must ensure the device is in a location of your car that it cannot access a power source. In other words, put it in your trunk, not the glovebox.
Edited 1 time(s). Last edit at 07/30/2005 12:32PM by SWweeman.
-------------------------------------------------------
> A fairfax county officer had me sign a ticket for
> having a not activated radar detector on the dash
> in my car. But after and I quote Educated Me and
> having me sign the tickett he failed to give it to
> me. What do I do now
Call the courthouse and find out if it has posted. In VA, a radar retector does not have to be plugged in to get a summons. You must ensure the device is in a location of your car that it cannot access a power source. In other words, put it in your trunk, not the glovebox.
Edited 1 time(s). Last edit at 07/30/2005 12:32PM by SWweeman.
Re: Arrest/Ticket search now active!
Posted by:
jjjames
()
Date: August 15, 2005 09:07PM
Is the arrest/ticket search feature offered on any sites for other jurisdictions, ie.Arlington,Alexandria,Prince William?
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: August 15, 2005 09:21PM
No. Currently only fairfax county posts arrest information on their website.
you can find information about any VA criminal case on http://www.courts.state.va.us
you can find information about any VA criminal case on http://www.courts.state.va.us
Re: Arrest/Ticket search now active!
Posted by:
jjjames
()
Date: August 15, 2005 09:39PM
Thank You Cary! Unfortunately Alexandria and Prince William don't show up, but maybe it will soon.
Re: Arrest/Ticket search now active!
Posted by:
TJ Stevens
()
Date: August 18, 2005 09:53AM
Will this application find violations for minors under 18? I know that my daugther's friends have multiple moving violations, but they are not here.
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: August 18, 2005 05:42PM
No. Minors have no public records.
Re: Arrest/Ticket search now active!
Posted by:
TJ Stevens
()
Date: August 19, 2005 03:21PM
Even for moving violations? I know that a few of them have had pretty serious tickets and it would be great to know who the irresponsible drivers are and what they were charged with. Maybe it is not a surprise, but just about every one of them got a new car for the one they wrecked, even after causing their parents to spend multiple weekend days in driver improvement school.
Re: Arrest/Ticket search now active!
Posted by:
Cm
()
Date: August 19, 2005 05:08PM
Simply because they are under 18, you will most likely never see their ticket records on a public site.
<sarcasm>
That's because kids under 18 are so innocent and must be protected.
</sarcasm>
<sarcasm>
That's because kids under 18 are so innocent and must be protected.
</sarcasm>
Re: Arrest/Ticket search now active!
Posted by:
DCH
()
Date: August 19, 2005 06:00PM
There ARE some records for arrests under age 18, but it looks like they're cases where the minor was charged as an adult...the offenses listed go all the way down to age 14, and include:
"DRUNK IN PUBLIC" (" I was drunk in a BAR.....I was thrown INTO publick!")
"PTY LARC"
"SIMPLE ASSAULT"
"FORCIBLE SODOMY"
"ALCH POSS"
"DRUNK IN PUBLIC" (" I was drunk in a BAR.....I was thrown INTO publick!")
"PTY LARC"
"SIMPLE ASSAULT"
"FORCIBLE SODOMY"
"ALCH POSS"
Re: Arrest/Ticket search now active!
Posted by:
ben
()
Date: August 19, 2005 06:07PM
DCH Wrote:
-------------------------------------------------------
> "DRUNK IN PUBLIC" (" I was drunk in a BAR.....I
> was thrown INTO publick!")
I love Ron White.
-------------------------------------------------------
> "DRUNK IN PUBLIC" (" I was drunk in a BAR.....I
> was thrown INTO publick!")
I love Ron White.
Re: Arrest/Ticket search now active!
Posted by:
wanusmaximus
()
Date: September 13, 2005 05:00PM
Yo Cary, I'm working on this project for my database class. Do you think it would be possible to grab the arrest lists from you, or for you to point to me where past ones are archived? I only see the weekly arrest list, and I think they used to archive the previous weeks, but I couldn't find it. Basically, I just need a shitload of data to process and play around with. Help me out. Thanks! W_
Re: Arrest/Ticket search now active!
Posted by:
John
()
Date: October 07, 2005 04:47PM
How were you able to pull down data from previous weeks?
Re: Arrest/Ticket search now active!
Posted by:
wanusmaximus
()
Date: December 12, 2005 03:52PM
I got inspired by all the arrests made by FCPD, and made this website for class:
http://cs4604.cs.vt.edu/~wchiang
Check out the mapped query section. The amount of data in the database is probably about 4 weeks worth. W_
http://cs4604.cs.vt.edu/~wchiang
Check out the mapped query section. The amount of data in the database is probably about 4 weeks worth. W_
Re: Arrest/Ticket search now active!
Posted by:
RESton Peace
()
Date: December 12, 2005 06:59PM
cool work, someone did a similar thing for DC, needless to say there are more than few buildings there you should stay away from if you don't enjoy rape and murder
FUCK THE POLICE
Posted by:
Fairfax Pete
()
Date: January 26, 2006 11:06PM
"DAVEY ","PETER ","R","018"," 3614","DURADO ","CT","FAIRFAX ","VA","08/16/2005","FAIL STOP PRIOR ENT HWY FRM
THIS IS BULLSHIT. ...i dont have the best reputation in fairfax but honestly. i just pulled this up under tickets and this shit reminds me how gay fairfax is. I turned into a two lane road and there was a car in the lane nearist me. so we got in an accident. that fucker could have moved into another lane... so when the cops asked who's fault it was. i said NOT MINES. w/o even telling me the fucker gave ME a ticket. i was about ready to argue that shit in court.
i fucked up my pop's car in this accident, which was a week after i totalled my own.
after the "minor collision" me and my buddies went to their house and got belligerently drunk.
fuck driver improvement courses and the police
THIS IS BULLSHIT. ...i dont have the best reputation in fairfax but honestly. i just pulled this up under tickets and this shit reminds me how gay fairfax is. I turned into a two lane road and there was a car in the lane nearist me. so we got in an accident. that fucker could have moved into another lane... so when the cops asked who's fault it was. i said NOT MINES. w/o even telling me the fucker gave ME a ticket. i was about ready to argue that shit in court.
i fucked up my pop's car in this accident, which was a week after i totalled my own.
after the "minor collision" me and my buddies went to their house and got belligerently drunk.
fuck driver improvement courses and the police
Re: Arrest/Ticket search now active!
Posted by:
shitehead
()
Date: January 27, 2006 08:39AM
Hey Fairfax Pete,
I have just awarded you loser of the day. Not only did you just post your address but admitted to the fact that you suck as a driver.
Fucking tard.
I have just awarded you loser of the day. Not only did you just post your address but admitted to the fact that you suck as a driver.
Fucking tard.
Re: Arrest/Ticket search now active!
Posted by:
PaperPusher
()
Date: January 27, 2006 10:20AM
TOTAL IDIOT. There's a lot folks can figure out about this pete guy. anyone care to guess which type of people would say "NOT MINES"?
Re: Arrest/Ticket search now active!
Posted by:
§
()
Date: January 27, 2006 11:06AM
Vanilla Ice -- Eminem -- House of Pain
- §
- §
Re: Arrest/Ticket search now active!
Posted by:
PaperPusher
()
Date: January 27, 2006 11:11AM
exactly!
Re: Arrest/Ticket search now active!
Posted by:
RESton Peace
()
Date: January 27, 2006 07:05PM
what's wrong with house of pain? shamrocks and shenanigans and such
That Everlast sure can rap.
That Everlast sure can rap.
Re: Arrest/Ticket search now active!
Posted by:
RESton Peace
()
Date: January 27, 2006 09:15PM
Genevieve would like me to add he just admitted to drinking underage also...
Re: Arrest/Ticket search now active!
Posted by:
Nik
()
Date: April 15, 2006 05:10PM
Has this been in place for a while, and I just didn't know about it?
-------
12 matches for wiedemann and cary, up to first 100 displayed
Top Secret clearance required
-------
----------------
WHERE'S THE BEEF
-------
12 matches for wiedemann and cary, up to first 100 displayed
Top Secret clearance required
-------
----------------
WHERE'S THE BEEF
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: April 19, 2006 10:17PM
Nik -
I'm still on there, you just can't search by my last name. And yes, it has been in place forever.
I'm still on there, you just can't search by my last name. And yes, it has been in place forever.
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: April 19, 2006 10:19PM
Just a quick note. Previously the arrest list updated every wednesday night at 8:00pm. However for the past 3 weeks the new arrest list has not been available until Thursday. Therefore, I am changing the script to grab the newest arrest list and update the search utility every Thursday at 8:00pm.
I know a lot of researchers flood to it every wednesday night to get the latest scoop. You will have to wait until Thursday now.
I know a lot of researchers flood to it every wednesday night to get the latest scoop. You will have to wait until Thursday now.
Re: Arrest/Ticket search now active!
Posted by:
RESton Peace
()
Date: April 19, 2006 10:21PM
care to give us numbers? what is the flood like on those nights?
Re: Arrest/Ticket search now active!
Posted by:
amazed
()
Date: May 08, 2006 07:00PM
WOW! what a great tool! thanks!
Re: Arrest/Ticket search now active!
Posted by:
Nik
()
Date: August 28, 2006 08:12PM
Suggestion:
I'd like to be able to pin my search to a specific field.
Example: If I search for Newport (the street I live on - Newport Dr), it'll pull up everything from Newport Dr and Newport News, VA. Is there any way you might be able to add on a feature to search by a specific field?
I don't know any Python, but I'll see if I can translate it into Java pseudo-code.
String search1 = [user's search in the first box];
int field1 = [fields are assigned numbers - last name, first name, etc];
int recsFound = 0;
//if this hits 100 inside for-loop, the loop is cut off
for(int x = 0; x < numRecordsInDatabase; x++)
{
//assume each full line is parsed into String "record"
String thisField = record.substring(*,*);
//makes thisField equivalent to the chunk of text between the starting and ending "s of a field, since they're all a constant length
if(thisField.indexOf(search1) < -1)
//if the user's search is found within the field
{
System.out.println(record);
//spit out the record on the console window - probably different for the intarnets
recsFound++;
//increment records found number to limit at 100
}
if(recsFound == 100)
break;
}
This would need to be converted to Python, of course, but hopefully I've put the algorithm together well enough that you get it.
----------------
WHERE'S THE BEEF
I'd like to be able to pin my search to a specific field.
Example: If I search for Newport (the street I live on - Newport Dr), it'll pull up everything from Newport Dr and Newport News, VA. Is there any way you might be able to add on a feature to search by a specific field?
I don't know any Python, but I'll see if I can translate it into Java pseudo-code.
String search1 = [user's search in the first box];
int field1 = [fields are assigned numbers - last name, first name, etc];
int recsFound = 0;
//if this hits 100 inside for-loop, the loop is cut off
for(int x = 0; x < numRecordsInDatabase; x++)
{
//assume each full line is parsed into String "record"
String thisField = record.substring(*,*);
//makes thisField equivalent to the chunk of text between the starting and ending "s of a field, since they're all a constant length
if(thisField.indexOf(search1) < -1)
//if the user's search is found within the field
{
System.out.println(record);
//spit out the record on the console window - probably different for the intarnets
recsFound++;
//increment records found number to limit at 100
}
if(recsFound == 100)
break;
}
This would need to be converted to Python, of course, but hopefully I've put the algorithm together well enough that you get it.
----------------
WHERE'S THE BEEF
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: August 29, 2006 06:18PM
The arrest list has grown to the point where a lot of garbage data gets matched for a street name search. I cooked up a perl script to do field matching about a month ago but it was far too slow for production (~25 seconds for query execution as opposed to the current ~0.5 seconds).
In the next month or so I'll be bringing the whole database into MySQL and allowing specific field searching.
In the meantime, you can cut out all the crap by searching for "newport" and "chantilly" or similarly "street name" and "street's city" for any other location.
In the next month or so I'll be bringing the whole database into MySQL and allowing specific field searching.
In the meantime, you can cut out all the crap by searching for "newport" and "chantilly" or similarly "street name" and "street's city" for any other location.
Re: Arrest/Ticket search now active!
Posted by:
pgens
()
Date: August 29, 2006 06:57PM
Cary, do you keep an archive of past text files? I'm missing one.
Re: Arrest/Ticket search now active!
Posted by:
Paul
()
Date: September 23, 2006 06:07PM
In the arrest database, what merits the charge of "RUNNING AT LARGE DOGS"?
Re: Arrest/Ticket search now active!
Posted by:
Cary
()
Date: September 26, 2006 09:00PM
Paul Wrote:
-------------------------------------------------------
> In the arrest database, what merits the charge of
> "RUNNING AT LARGE DOGS"?
It should read "Running at large, dogs"
It means there was a leash violation.
I'll add this to the Ticket/Arrest search wiki
Edited 1 time(s). Last edit at 09/26/2006 10:05PM by Cary.
-------------------------------------------------------
> In the arrest database, what merits the charge of
> "RUNNING AT LARGE DOGS"?
It should read "Running at large, dogs"
It means there was a leash violation.
I'll add this to the Ticket/Arrest search wiki
Edited 1 time(s). Last edit at 09/26/2006 10:05PM by Cary.
Re: Arrest/Ticket search now active!
Posted by:
TheMeeper
()
Date: September 26, 2006 09:16PM
"RUNNING AT LARGE DOGS"
"You mess with the large dogs, you'll get the horns."
Attachments:
"You mess with the large dogs, you'll get the horns."
Attachments:
Re: Arrest/Ticket search now active!
Posted by:
Gravis
()
Date: September 27, 2006 05:24AM
"Running at large, dogs"
that reminds me of the title Geraldo At Large. lol.
"the wisdom of the wise will perish, the intelligence of the intelligent will vanish."
that reminds me of the title Geraldo At Large. lol.
"the wisdom of the wise will perish, the intelligence of the intelligent will vanish."