Shapefiles and Label files provided for R2017Q3 production run

[heathhayward]

This will require an updated label_geography.csv, label_geography_al.csv, and lehd_shp_gw.zip file in whatever schema version that QWI vintage uses. Does a data change require iterating the schema?

[larsvilhuber]

label_geography.csv is created dynamically from all label_geography_XX.csv files. You will provide lehd_shp_gw.zip. This will be V4.1.2 or V4.1.3 (if other changes affect R2017Q2).

[heathhayward]

shapefiles and label files for R2017Q3 QWI release are provided below:

lehd_shp_gs.zip
lehd_shp_gw.zip
lehd_shp_gb.zip
lehd_shp_gc.zip
lehd_shp_gm.zip
label_geography.zip

[larsvilhuber]

Camille suggests ignoring label_geography.zip and using the attached CSV files instead.
Re%3a_label_geography_files_and_shapefiles_for_LEHD_Schema_update_associated_with_R2017Q3_QWI_release.zip

[larsvilhuber]

@heathhayward : notes:

• AL file: State-wide label is not quoted
• AL file: The new WIA definitions are not quoted.
• AL file: The "0199999" MSA definition is missing
• LA file: State-wide label is not quoted
• LA file: The new WIA definitions are not quoted.
• LA file: The "0199999" MSA definition is missing

[heathhayward]

I thought we were using Camille's label files (created from Production) because of they do not have these issues? Looking at her email from 9:19am on 5/3, those files do not appear to be from Production. I'll look for Production-created label files and add them here. In terms of my files, here are my comments on these two issues, one of which I can fix:

• AL/LA Quotations: Python doesn't let me force quotes around columns that don't need them (i.e. don't have commas within). Quotes are inconsistent because I'm creating each geography separately and then stacking them (and States and WIBs don't have any internal commas in the "label" field). I've messed with this quite a bit and am tired of fiddling with it. Is this an aesthetic issue or will users have trouble reading in these files if quotes are not consistently included?

• AL/LA MSA state remainders: Yea, since those areas are not actual features in the shapefiles, these remainders are not included as rows in the shapefile and I forgot to manually add them in. I can update the code to do that now.

[heathhayward]

Can't add zip or csv files to this ticket. very frustrating.

[heathhayward]

I emailed the correct "production" version of the label files to the group (the ones created during my devg testing, which should be identical to Camille's files). I've also updated my code to create the CBSA state remainder rows. So only remaining issue is the quotation inconsistency - please to comment on whether that is an actual deal-breaker.

[larsvilhuber]

There will be situations, users, where this inconsistency binds. If python is the issue, I can have a separate look at it.

…

-- Sent from my mobile device

-------- Original message -------- From: heathhayward <notifications@github.com> Date: 6/19/17 11:25 (GMT-05:00) To: labordynamicsinstitute/qwi_schemas <qwi_schemas@noreply.github.com> Cc: Lars Vilhuber <lars.vilhuber@cornell.edu>, Assign <assign@noreply.github.com> Subject: Re: [labordynamicsinstitute/qwi_schemas] Shapefiles and Label files provided for R2017Q3 production run (#51) I emailed the correct "production" version of the label files to the group (the ones created during my devg testing, which should be identical to Camille's files). I've also updated my code to create the CBSA state remainder rows. So only remaining issue is the quotation inconsistency - please to comment on whether that is an actual deal-breaker. — You are receiving this because you were assigned. Reply to this email directly, view it on GitHub<#51 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AGsoeG7FUARCYzF2kHknRZ6_P_DkyVLbks5sFpLQgaJpZM4MVp2i>.