Let us get our own geocoded data first, work with that, and then we can provide format details. That's hard to do without doing this ourselves first.
Bernie ************************************************************* Bernard S. Black Chabraja Professor, Northwestern University Pritzker Law School and Kellogg School of Management 375 East Chicago Ave., Chicago IL 60611 [email protected] tel: law: 312-503-2784; Kellogg 847-491-5049; cell: 847-807-9599 papers on SSRN at: http://ssrn.com/author=16042 ************************************************************ -----Original Message----- From: GPC Informatics [mailto:[email protected]] Sent: Thursday, February 02, 2017 3:07 PM To: [email protected]; [email protected] Cc: [email protected]; [email protected]; [email protected]; [email protected]; Bernard Black <[email protected]>; [email protected]; [email protected]; Lindsey Lynne Cook <[email protected]> Subject: Re: [gpc-informatics] #544: how to convert ACS raw variables to CAP variables (e.g. type of health insurance)? #544: how to convert ACS raw variables to CAP variables (e.g. type of health insurance)? --------------------------+--------------------------- Reporter: dconnolly | Owner: afurmanchuck Type: design-issue | Status: assigned Priority: minor | Milestone: next-d Component: data-stds | Resolution: Keywords: | Blocked By: Blocking: | --------------------------+--------------------------- Changes (by dconnolly): * cc: cgladfelter (removed) * cc: lindsey.cook@… (added) * owner: tmeyer => afurmanchuck * status: new => assigned Comment: Alona, The docs from Van Riper seem pretty clear to me. The only part that's left is the details of how you want the data formatted when we submit it. Would you please sketch an example file? Van Riper sent documentation and a link to data Wednesday, January 25, 2017 2:35 PM. The documentation is in the next-d "Geocoding and MPC" folder. The docs include an ER diagram and a pretty clear explanation: > The GPC group will need these Stata files and the new census crosswalk to > link the socioeconomic data in the Stata files with their patient geocodes. > The socioeconomic data is for a more recent version of the American > Community Survey than they currently have. Due to some changes in > geographic codes introduced by the Census Bureau, their existing census > crosswalk will not work with the codes in the Stata files. The data is in stata format, which I have never dealt with, but I see [https://urldefense.proofpoint.com/v2/url?u=http-3A__pandas.pydata.org_pandas-2D&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=vRN3S5fNmGKrlYCh7JoqhwYNrJ35CVAca1xs_MNr9g8&s=gevuNz8Bv-TIbqFv04Q7oAX04vgOjkp3KZ73GXLoaWQ&e= docs/stable/generated/pandas.read_stata.html read_stata support in pandas]. -- Ticket URL: <https://urldefense.proofpoint.com/v2/url?u=http-3A__informatics.gpcnetwork.org_trac_Project_ticket_544-23comment-3A4&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=vRN3S5fNmGKrlYCh7JoqhwYNrJ35CVAca1xs_MNr9g8&s=c_sORyaBRx9fbKUVXmhAa6MZyC0dephsWgBGu7jy9YI&e= > gpc-informatics <https://urldefense.proofpoint.com/v2/url?u=http-3A__informatics.gpcnetwork.org_&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=vRN3S5fNmGKrlYCh7JoqhwYNrJ35CVAca1xs_MNr9g8&s=KOI49qCZfMgh-kDk1WE7KSjd9T1whZGkDpk_VxDqKP0&e= > Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
