Break out parks and cemeteries separately on ui_proptype

[rpitingolo]

@ptatian @lhendey It looks like in order to make this happen we need to update two formats: $uiprtyp and $useuipt.

The current process for updating these formats is to update this spreadsheet and then read it in via DDE. L:\Libraries\Realprop\Doc\UseCode & UI_proptype.xls

I tested the program in an interactive session and the DDE worked fine, but I know DDE is not reliable anymore. I would like your take on whether I should:

1. Update the formats using the spreadsheet and use the program as-is.
2. Re-write the program to either read in the spreadsheet as a CSV or hard-code the formats into the program.

Option 1 is fastest in the short term. Option 2 is safer long-term.

This is the program in question: Prog\RealProp_formats.sas Thanks!

[ptatian]

@rpitingolo Since we won't likely need to update this format in the future, I think the faster route is probably OK. @lhendey

[rpitingolo]

@ptatian ok, thanks!

@lhendey do you have written down the definitions for parks and cemeteries from the previous work? I want to make sure I get it right.

[lhendey]

@rpitingolo no definitions on parks - used spatial join to national park layer and dc park layer. i didn't see any variable in the real prop data that indicates parks? Is there something you can identify?

cemeteries and rec-fields own by educational institutions are currently classified as "vacant" in the spreadsheet.

we used mix1txtype to pull them out of the vacant lots analysis we did. ("E2", "E7") I don't think we had all the definitions for the values in mix1txtype.

cc @ptatian