Data issues

[ran-codes]

@jlkephart sorry really just had time to look through the data you sent today. This isn't a priority issue as we can draft the app but perhaps next iteration we can revisit these things. Just making an issue now while its fresh on my mind.

Datasets don't have SALID

Both 'App Data All Ages' and 'App Data 65 Plus' don't have SALID in the data. Which makes it hard to use (linking to the figures and spatial files). For now I name-matched to a SALURBAL L1 crosswalk 'l1names_11_3_17.sas7bdat'; fortunately i was able to match most of your cities but there were three not present in the crosswalk I used:

• "Panama City"
• "Colon"
• "David"

Eventually need figure out which version of the crosswalk was used by Jeff/Brisa.

One city is missing the PNG figures

City name: Leon (SALID1: 205103) is in the datasets but is missing the PNG figures.

[jlkephart]

Leon should be SALID1: 204131, which is in the PNG figures. Is this problem fixed when you use the new crosswalk?

[ran-codes]

Everything is good now! 👍

going to close this issue.

[ran-codes]

@jlkephart another question about the data. For the 'Map of RR at P99' what column in the data is this 'RR at P99"?

here is what I see in the CSV's:

[jlkephart]

Hmm you're right, it's not there. I will create and send to you the vars via email.

[ran-codes]

Thanks ! got it!

two quick questions.

• the variables that should be mapped are 'rrcat_99' and 'rrcat_p1'? or just 'rrcat_99'
• or are there two different variables for hot and cold.

[jlkephart]

rcat_99 is for the hot map (P99 temperature), rrcar_p1 is for the cold map (P1 temp)

On Thu, Nov 11, 2021 at 11:03 AM Ran Li @.***> wrote:

Thanks ! got it!

[image: image] https://user-images.githubusercontent.com/45013044/141329297-9f99e604-3d83-4239-b469-14d0131562c5.png

two quick questions.

• the variables that should be mapped are 'rrcat_99' and 'rrcat_p1'? or just 'rrcat_99'
• or are there two different variables for hot and cold.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/Drexel-UHC/SALURBAL-Heat-Study-App/issues/2#issuecomment-966422375, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5DGKB76EKYPZAP3GY2YJLULPSMVANCNFSM5HYY4Y2A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[jlkephart]

See comment I left in App Design earlier today

[ran-codes]

I assume 'heat_app_rr.csv is for age overall. When you have time can you send another version of 'heat_app_rr.csv' with 65+ data?

[jlkephart]

Yes, sending now.

[ran-codes]

got it thanks! 👍