Crime data

SF crime data

by mpmckenna8

HTML

<script src="//cdnjs.cloudflare.com/ajax/libs/lodash.js/2.4.1/lodash.js"></script>
<div class='maxD'></div>

JavaScript

var url = 'http://data.sfgov.org/resource/gxxq-x39z.json?$order=date ASC&$limit=5000'


//'http://data.sfgov.org/resource/tmnf-yvry.json?$order=:date&$limit='+ numbRes

d3.json(url,function(err, data){
  if(err){
    throw err
  }

  console.log('loading finished', data.length);

  d3.select('body')
    .append('div')
    .html('<p>In the past 3 months there have been a total of '+ data.length+' SFPD incidents reported in the following descriptions:</p>')


  var infoG = _.groupBy(data,'descript');

    var keys = Object.keys(infoG);
    
    
  data.map(function(d){
   d.readDate = new Date(d.date*1000)
  })

  var maxDay = d3.max(data,function(d){
  //  console.log(new Date(d.date*1000).toString())
    return d.date
  })
  
  var shouldMax = d3.max(data,function(d){
  //  console.log(new Date(d.date*1000).toString())
    return d.readDate
  })

  var minDay = d3.min(data,function(d){
    return d.date
  })

  var readMax = new Date(maxDay*1000)
  var readMin = new Date(minDay*1000)


  var perDay = _.groupBy(data,'date');

  var dayKeys = Object.keys(perDay);
    
    d3.select('body').append('p')
    .text('When I sort by the unix timestamp the max day is: ' +readMax);
    
       d3.select('body').append('p')
    .text('yet when I do d3.max with date object:' + shouldMax );
    
    
})