Export Sample NRC Data

[ezys]

Please export about 100 rows of NRC reports from incidents from the Alerts Database so I can compare against the NRC raw spreadsheets.

Because there are two different data streams, could you give me two sets?

• 100 records from 2013, preferably from the Taylor MC20 area.
• 100 records from 2014, preferably from the Taylor MC20 area.

[pwoods25443]

@ezys do you have a lat/lon box I should use for extracting records around Taylor?

[pwoods25443]

@ezys and what do you mean by "two different data streams" ?

[ezys]

@pwoods25443 Will this do for bounding box?

http://alerts.skytruth.org/subscribe?l=28.9096,-89.0009,28.9584,-88.9408#RSS

[ezys]

@pwoods25443 Will this do for bounding box?

http://alerts.skytruth.org/subscribe?l=28.9096,-89.0009,28.9584,-88.9408#RSS

And by "two datastreams" I mean the public-facing server from before Heartbleed (or whatever) took the NRC offline in February 2014 and then the excel dumps afterwards. I just want to make sure the resulting data is consistent across the board.

[pwoods25443]

Ok - here is an export joining 3 of the NRC scraped tables

select  *
from "NrcScrapedReport" r join "NrcParsedReport" p on r.reportnum = p.reportnum 
join "NrcAnalysis" a on r.reportnum = a.reportnum
where latitude > 28.9 and latitude < 28.96 and longitude > -89 and longitude < -88.95 
order by incident_datetime

taylor-nrc-scraped-2016-06-27.csv.zip

[pwoods25443]

And here is an export of the alerts

select  *
from feedentry 
where lat > 28.9 and lat < 28.96 and lng > -89 and lng < -88.95 
order by incident_datetime

taylor-nrc-alerts-2016-06-27.csv.zip