Skip to content

Instantly share code, notes, and snippets.

@ajdavis
Created March 12, 2017 21:32
Show Gist options
  • Save ajdavis/25cf03896888698f07afa007ddd405b9 to your computer and use it in GitHub Desktop.
Save ajdavis/25cf03896888698f07afa007ddd405b9 to your computer and use it in GitHub Desktop.
Field types file for "mongoimport" to import a CSV from the NYC Open Data set of 311 complaints.
Unique Key.int32()
Created Date.date(01/02/2006 03:04:05 PM)
Closed Date.date(01/02/2006 03:04:05 PM)
Agency.string()
Agency Name.string()
Complaint Type.string()
Descriptor.string()
Location Type.string()
Incident Zip.string()
Incident Address.string()
Street Name.string()
Cross Street 1.string()
Cross Street 2.string()
Intersection Street 1.string()
Intersection Street 2.string()
Address Type.string()
City.string()
Landmark.string()
Facility Type.string()
Status.string()
Due Date.date(01/02/2006 03:04:05 PM)
Resolution Description.string()
Resolution Action Updated Date.date(01/02/2006 03:04:05 PM)
Community Board.string()
Borough.string()
X Coordinate (State Plane).double()
Y Coordinate (State Plane).double()
Park Facility Name.string()
Park Borough.string()
School Name.string()
School Number.string()
School Region.string()
School Code.string()
School Phone Number.string()
School Address.string()
School City.string()
School State.string()
School Zip.string()
School Not Found.string()
School or Citywide Complaint.string()
Vehicle Type.string()
Taxi Company Borough.string()
Taxi Pick Up Location.string()
Bridge Highway Name.string()
Bridge Highway Direction.string()
Road Ramp.string()
Bridge Highway Segment.string()
Garage Lot Name.string()
Ferry Direction.string()
Ferry Terminal Name.string()
Latitude.double()
Longitude.double()
Location.string()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment