FlowingData Forums » Data Visualization

Showing Multi-phase Data on Map (Paid Gig)

Started 2 years ago by qaid / 11 posts

  1. Hey folks!

    So, I think I might have made up the term Multi-phase, but it seems to describe what I am trying to find out.

    I work with the Center for Constitutional Rights (ccrjustice.org); we recently got a massive amount of data from the NY Police Department that details 10 years of Stop and Frisk Data within the 5 boroughs of NYC. In this data are all kinds of variables including location, times, and nature of incident.

    I am looking for a person/firm/software that will help me to display this data and derived statistics over a map. GIS style, but something that looks good as well.

    Any hints, tips, references, or actual solutions? I would be grateful and excited to receive. We have institutional funding for this type of project as well, so scope and resources are open and flexible.

    Thanks FlowingData community, I'm new (as a FlowingData member - not as a data geek tho), but looking forward to being a contributing member.

  2. hey quaid, that sounds like a fun one. Did you see this thread?

    http://forums.flowingdata.com/topic/do-you-do-data-visualization-freelance-work

    I haven't gotten around to organizing all of 'em yet, but in case no one replies, you might check out someone from there.

  3. Ah, cool Nathany. I wasn't aware of that string. I will repost if I don't get too many responses.

    And by the way, LOVE the site. Thank you for your hard work and great vision.

  4. hi qaid
    10 years of Stop and Frisk Data sounds very interesting.
    i'd be interested to visualize this.
    is there a way to get a glimpse at the data ?
    can you make it public or is it confidential ?
    i think it's important to see the structure and size of your dataset, so we can estimate what might fit to visualize it.
    however, i'd be interested to give this a try.

    lennyjpg
    gmail
    com

  5. Hi Qaid -

    Our firm has in-house expertise in building interactive maps using the R statistical language. I've attached a screen shot that illustrates work done with environmental monitoring in the San Francisco Bay.

    Please contact us if we can be of assistance.

    Michael E. Driscoll, Ph.D.
    http://www.dataspora.com

    [attachment=409,88]

  6. @lennyjpg
    The data set is pretty vast with each year containing more than 500,000 records with perhaps 50 or so columns.
    Perhaps on Monday I can prepare a smaller subset that is downloadable / uploadable as I now see that people will need to see how this data is shaped.

    @dataspora
    That map looks interesting. On Monday, I will reach out to you to discuss this further.

    Thanks for the replies!

  7. @quaid

    I've worked with similar data for another state and unfortunately the political interests over racial issues outweighed the desire to produce anything truly valuable.

    Where I ended up (for internal use only) was a web presentation that simultaneously displayed a set of six time-series animated .gifs arranged in 2 columns with 3 .gifs in each column; each base map had a frequency chart nested next to the map.

    The 2-columns represented :
    1. all traffic stops
    2. traffic stops that progressed to vehicle search.

    The 3-rows reflected:
    1. white driver
    2. black driver
    3. other

    All of the traffic stop data were geocoded (given lat/long coordinates) divided into 3 data sets (white/black/other) and then each subdivided into 12 sets with each set reflecting the 2-hr time-of-day bucket into which the traffic stopped occurred.

    Then a hi-res density map (i.e stops per sq. mi.) of each subset was created (6 subjects x 12 2-hr time-of-day buckets = 72 surface layer files) and saved to .gif

    The .gifs were brought into photoshop - 1 at a time and updated with the time, count by time-period, and total count for each of the 6 col/row combinations and the 6 animation .gifs were created showing surface density of stops by race with/without searches in 2-hr increments.

    I'm sure flash action script can do this better/faster now -- then it was still Macromedia and wasn't an option for my office at that time.

    The density layers were created with ArcGIS software with a spatial analyst extension. I would look at CrimeStat3, GeoDa (?), or GRASS and the R-project for the similar function if ArcGIS is not available. The model builder function in ArcGIS could automate the entire process much faster than a manual process.

    There are so many ways to slice and dice this type of data - by season, by day of week, by ordinal class of car, etc --- then there is the correlation analysis with the area population in which the traffic stop was initiated ...

    It's dubious if any of this may be of value :-) - but rest assured, someone out here feels your a)joy at having such a rich data set b)the inevitable pain of finding the best way to present the data that makes someone else happy.

  8. Phases belong in discrete layers with variable transparency to assist in comparisons and animations, so that visualizing differences in growth and recession of attribute data can be more intuitive. Thus you need someone with strength in GIS and graphical process representation. Once this stage of visualization is operational, it then becomes possible to ask the right questions.

  9. @pd3244
    It's hard for me to visualize exactly what you are describing, but it sounds very much like what I am aiming for.

    @RichReader
    Thank you for your feedback as well. I am not familiar with the functionality of GIS or the required formatting of the data that will go into it, so this is good advice.

  10. Hi, Qa'id. I work at the Vera Institute of Justice (a few subway stops south of CCR). We've done a good deal of research and policy work on policing, both in and out of NYC, and use ArcView and MapInfo for GIS and Tableau for data visualization. I'd be interested in talking further with you about the stop and frisk data and was also wondering if you were still planning on making a small sample of that available for this group to eyeball.

    Tina Chiu
    tchiu@vera.org

  11. @quaid

    If you're still following this string, you should really look into the association "GISMO-NYC". They are local GIS professionals who can help to point you in the right direction.

    Good luck.
    Jo


Reply

You must log in to post.

About this Topic