Using insheetjson on New York City pedestrian injury data

[Fabian Eckert]

Hi All

I am trying to get the new york city pedestrian injury data into stata:

http://www.nyc.gov/html/dot/download...ry_yearly.json

I am unclear how I have to specify the "columns" function of the insheetjson command to make this work.

A line from the file looks like this:
{"type":"FeatureCollection","features":[{"geometry": {"type": "Point", "coordinates": [-73.92834752578327, 40.64219748869916]}, "type": "Feature", "id": 0, "properties": {"BikeInjuri": 0, "YR": "2016", "MVOInjurie": 9, "PedInjurie": 0, "Injuries": 9}}

and using

insheetjson stringA stringB (etc) using ".../Pedestrian Injuries/fatality_yearly.json", col("coordinates")"

gives no results.

Help is much appreciated!

Best

Fabian

[William Lisowski]

Welcome to Statalist, Fabian.

You have accidentally posted your topic in Statalist's Mata Forum, which is used for discussions of Stata's Mata language. Your question will see a much larger audience if you post it in Statalist's General Forum.

Also, if you have not already done so, take a look at the Statalist FAQ linked to at the top of this page for posting guidelines and suggestions.