[REQUEST] Law Enforcement Field Database Application
 

I am looking for any application (Freeware/Donation/Open Source/Commercial) that has similar features to this.

http://www.pocketgear.com/software_detail.asp?id=13719

Edit: Found another application that was similar, but it doesn't run on WM5+ either.
http://www.handango.com/catalog/Prod...roductId=72491

Another source for the first program, but this one has several reviews.
http://www.handango.com/catalog/Prod...oductId=119805


I have looked all over the web for an updated version of this that would run on WM5+, but it seems that the publisher has been pretty inactive for a while and I haven't been able to contact them. I have also looked for other applications with similar features but have only found corporate software apps that are part of large client/server report and citation applications.

If anyone knows of any software that could replace this outdated version or if any devs would be willing to design a new app please post here or pmsg me for further discussion.

I know many that could benefit from such an application and that would be willing to donate to the development of an app or be willing to purchase a copy.

Thanks in advance.

Re: [REQUEST] Law Enforcement Field Database Application
 

That can't be right.

Police databases are secured with encryption technology and can only be accessed from police computers

This may be for the Police member who wants it on his PC and knows the connection Info, but if you dont have access to the database this is useless

In reality, all it does is give you a way to view the database, not access one. it probably comes empty and is a waste.

Not to mention accessing such data is a violation of privacy policies and a federal crime.

Re: [REQUEST] Law Enforcement Field Database Application
 

This program is intended for the officer to build their own database from an "on contact" basis. This is for personal use of the officer to keep track of the information in the field and it be stored on the device. This isn't intended to access some pre-existing database.
However, being able to store this information remotely to a mysql database via a mobile vpn would be handy for multiple users.

Edit: Found another application that was similar, but it doesn't run on WM5+ either.

http://www.handango.com/catalog/Prod...roductId=72491

Another source for the first program, but this one has several reviews.
http://www.handango.com/catalog/Prod...oductId=119805

Re: [REQUEST] Law Enforcement Field Database Application
 

why not just write a php/mysql webpage on your own to store/secure this, and make it so that you could use one of the mobile browsers to access it from anywhere?

Re: [REQUEST] Law Enforcement Field Database Application
 

Haven't thought of that, doesn't sound like a bad idea to an extent. But many I know work in areas that have large holes in cellular coverage/data services and using an app would be much faster than having to open a browser and logging in. Would be handy if it was stored locally on the device and have a option to sync to a centralized database if wanted/needed or sync between devices via bluetooth?

Re: [REQUEST] Law Enforcement Field Database Application
 

Your asking for a very complex app, you migth have to wait a while. Once I am done with my current projects I migth give it a shot... but don't hold me to the fire.

Re: [REQUEST] Law Enforcement Field Database Application
 

Thats fine, I appreciate the consideration if nothing else.

One of these days I need to get around to learning .Net and get to making some of this stuff on my own, perhaps I could help others too.

All of what I have done has been in Linux or irc clients like mIRC and XChat.

Re: [REQUEST] Law Enforcement Field Database Application
 

yall don't have MDTs for this?

Re: [REQUEST] Law Enforcement Field Database Application
 

No one within less than 80 miles has MDTs (now that I think of it, there is one that has a system that is run off of laptops and cellular cards with a vpn and they can get dispatch information/gps), but they are the largest city between Memphis and Nashville. We (or anyone else in the county that I know of.) won't even be getting digital radios until 2013 (FCC Deadline). They haven't said if we will be getting MDTs then either, even then we won't be able to check in house records, only do registration/dl checks/ and (possibly) see dispatch information. Each program we use (reporting/records, CAD, agency terminal) are all totally different and are all seperate from each other. I don't think there is a suite that exists that could possibly tie them all together and our reporting software doesn't have the ability to store anything that isn't related to a specific offense. So storing information about family, work, hangouts, associated vehicles, wants/warrants, and character information isn't an option.

Re: [REQUEST] Law Enforcement Field Database Application
 

One idea you could consider for getting some software developed, if you are unable to find an acceptable solution. Would be to get in contact with whatever school in Tennessee has teh best Computer Science/Software Engineering programming and find out if they have a capstone or senior design project. My university has such a program and people outside of the university are allowed to submit project ideas. Then you could just submit the project and see if you get enough interest generated for people to choose it.

Re: [REQUEST] Law Enforcement Field Database Application
 

wow, i mean we are by no means a large city/county but we have MDTs for every crusier (even EMS and FIRE have them) as well as Digital (believe me, it isn't worth the extra, i Prefer Analog any day)....oh well, good luck, maybe they can get some federal grant money to get some gear later...

Re: [REQUEST] Law Enforcement Field Database Application
 

Not a bad idea, thanks for the suggestion.
I will take that into consideration if I don't have something else work out.

Yeah, just have to wait and see.... I'm not holding my breath though.

Re: [REQUEST] Law Enforcement Field Database Application
 

Keep in mind... if you want to implement your own system for this, you have to secure it like CRAZY. If any of the security isn't up to standards and information is leaked, your badge is on the line.

Re: [REQUEST] Law Enforcement Field Database Application
 

Well as security is an issue, most of this information is public record. Only the relation of key bits of information to each other is crucial to keep restricted.

Anyone can come to the office and pay $4 and get a copy of any offense report that we have in our system and get 80% or more of this information.

The only thing that is absent from a public copy of a report is stuff like social security numbers and phone numbers (I won't have any use to store social security numbers anyways). Of course the relational information of family and their addresses isn't stored in our system unless their information is related to a specific offense. Everything else is in one of our reports.

I would recommend using SSL for any mySQL server connections and perhaps go an extra step by tunneling it through a vpn ipsec, hamachi, openvpn, or one of the many other vpn setups out there. most support gzip compression along with various levels of encryption. I think that would be about as secure as you can get without putting a hefty load on the device.

As far as if the device is stolen or lost, there are several solutions to that too. lots of free stuff that could be cooked into a rom like Smartprotect, remotetracker, etc... or Flexillis Mobile Security, or several other solutions out that you could use to purge the device/format memory cards etc..

The local database could also be encrypted and unlocked on application startup with a pass key.

Re: [REQUEST] Law Enforcement Field Database Application
 

I found that Police Pro app for WM with just a 2 minute search... Isn't that what you're after?

Re: [REQUEST] Law Enforcement Field Database Application
 

Yes, but it doesn't run on WM5+.
It says for Pocket PC 2003 or at least all of the versions I have found.

I actually bought it from Handango and it fails to launch. I've tried it on WM5 [Palm Treo], WM6,6.1,6.5[HTC Titan], and now WM6.1 [HTC Rhodium]. It doesn't launch on any of them.

Re: [REQUEST] Law Enforcement Field Database Application
 

Interesting concept, but something you need to look at is whether you're compling a criminal justice database or criminal intelligence database. There are Federal regualtions which dictate how each type of database can be used, collected, and stored. Then, of course, you have the issue of how you're going to deal with discovery requests from defense counsel.

Law enforcement technology has certainly come along way since I started in 1988, so too have the attendant issues. I encourage you to seek out ways to leverage technology to make the job easier/safer/more effective, but you need to be aware of the hurdles that come with it.

Re: [REQUEST] Law Enforcement Field Database Application
 

I have an idea your talking about Jackson and there crocked cops(I'm from there). Huntington is a pretty small town and not to nice..lol(I hated tennessee when I lived there)(too much dope).

Your best bet would be to pick up a cheap PocketPC from ebay. You can prolly pick one up just for doing this for maybe under 100$(file it as a work expense)and you would be good to go.

Hope you get what you need man and good luck.


~Nerd

Re: [REQUEST] Law Enforcement Field Database Application
 

Yeah, I hear ya. The purpose for this is mostly for reference information so that we can look back be reminded of past encounters so that we can be aware of safety precautions, possible outstanding wants/warrants (not based off of this alone of course, but as something to look into further if this subject is encountered again), vehicles this subject has been seen in (so if we visually identify this subject in this vehicle and we confirm a warrant then we can act on it.). Just stuff like that, as far as discovery goes, any information directly related to a case is always put into a case file with a copy of the warrant, report, photographs etc.. This program wouldn't be used to replace field notes for any event.

Yeah, its Jackson.

Yes, there is a lot of dope around here, its sad just how much too. We have a lot of traffic from Jackson, Memphis, Brownsville, etc.. that manage to drift up here and bring trouble with them.

We do what we can to keep the noise to a minimum, but we know that we aren't winning the war. We just don't have the tools at our disposal to make an impact like the public wants us to. We have done a fairly good job of pushing most of the drug activity out of the public eye, but there is a lot of activity going on daily that we are currently unable to do anything about except when someone slips up.

I'd hate to go out and buy a antiquated device to use that program, but I suppose that is always an option to consider. I just got my new TP2 and I'm trying to find better and bigger uses for it :-)

Thanks for everyone's input. I've been dealing with a family emergency for the past few days and have been out of pocket, just managed to get the HSPL release and flash my TP2 on the day of the release and now i'm using Energy Rom which i'm pretty happy with so far.

Re: [REQUEST] Law Enforcement Field Database Application
 

Do you do HanDBase? There are a few there and one that I wrote and was able to post as a preliminary paid project - http://www.ddhsoftware.com/gallery.h...=/gallery.html is the link to the applet.

Description from the site:

Police was written using HanDBase version 3. This is the preliminary version of a paid project. Its purpose is to facilitate "on the go" documentation and is structured as a "starter" tracking system, allowing the user to add/delete "child" databases and fields as needed. The "calculated," "linked", "relationship," and "database popup" (DB popup) field types are used throughout the application. There are eleven databases.

Police was written using HanDBase version 3. This is the preliminary version of a paid project. Its purpose is to facilitate "on the go" documentation and is structured as a "starter" tracking system, allowing the user to add/delete "child" databases and fields as needed. The "calculated," "linked", "relationship," and "database popup" (DB popup) field types are used throughout the application. There are eleven databases. The primary database is "Police." It is used as a launching point to the "child" databases. The relationship used is "date." The relationship field type is used to enter/view information related to BOLOs, citations, contacts, field interviews, notes, service calls, subpoenas, time worked, to do, and vehicle unit. The "linked" field type is used to edit the "child" databases. The "child" databases use "time created" as their primary relationship with the "PoliceNotes" "child" database.

Re: [REQUEST] Law Enforcement Field Database Application
 

I haven't heard of HandBase before, this doesn't seem too bad... I would Just would like to see some screenshots or a video of the addon being used before I went out and bought HanDBase. It has a nice little list of available information that it stores. It doesn't say anything about being able to store images either, we deal with so many people who give you a line like "Nah, I was just coming from a friends house from watching a ball game and was going home." when you ask them if they have any identification. You run into several that you have encountered at one time or another but you can't always remember their names. Photo's are usefull if they give you false information because they know someone is looking for them.

Also, all of that tracking information like call length etc. isn't something that is needed, this DB addon is a bit overspread in relation to Police Pro etc.., one thing that does catch my eye however is a option for a child database, we have lots of runaways that show up in this area, would be nice to have a seperate tab or menu for Amber alerts, Missing children, etc..

Re: [REQUEST] Law Enforcement Field Database Application
 

google is a powerful friend.