Skip to content

Instantly share code, notes, and snippets.

@prestonparris
Created March 21, 2012 00:04
Show Gist options
  • Save prestonparris/2142792 to your computer and use it in GitHub Desktop.
Save prestonparris/2142792 to your computer and use it in GitHub Desktop.
json scrape
request = require 'request'
mongoose = require 'mongoose'
ItemModel = mongoose.model 'ItemModel', new mongoose.Schema {
title: String
description: String
latitude: Number
longitude: Number
}
exports.migrate = (req, res) ->
request {url:'http://nycopendata.socrata.com/api/views/ev6s-hj49/rows.json',json:true}, (err, data) ->
if err
console.log err
if data
#itemModel = {}
#itemModel.category = data.body.meta.view.category
for item in data.body.data
model = {}
model.title = item[8]
model.description = item[13]
model.latitude = item[16]
model.longitude = item[17]
itemModel = new ItemModel(model)
itemModel.save (err, result)->
if err
console.log "error = ", err
else
console.log "result = ", result
return false
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment