Regarding ESPN Shot Charts

[JohnHasADHD]

Not sure anyone here will know the answer to this question, but in parsing shot charts from ESPN I've run into an issue of 'identifying' three pointers. I thought at first that I could just rely on the description containing 3-pointer, but the shot description only contains 3-pointer on a made shot (so my first database try had everyone shooting 100% from the 3 line)

There is an x / y setting for each shot, but I don't really understand how the grid is set up - though I know if y=0, then the shot is a free throw. I can't use the distance but I'm guessing if I understood the x/y system of the shot file I could make it work.

Any advice?

[EvanZ]

- though I know if y=0, then the shot is a free throw.

Or a dunk (or even some layups).

[JohnHasADHD]

I tried to delete this post because upon more research, I realize the problem is mine, not the file, i mis interpreted the file and discovered that i was causing the data to be converted improperly and thus throwing my database insertion values off...(unsigned got me). Please feel free to delete and or lock this