How to translate attribute headings in CEJST shapefile

[Forest Replogle]

I'm sure this conversation has been had somewhere here before, but I can't find anything by searching "translate" or "attribute."  What I'm trying to find is a table connecting the encoded headings in the attribute table of the downloadable CEJST 1.0 shapefile to the descriptions and labels in the 1.0-codebook.xls file so I can translate what I'm looking at in GIS. 

For instance, when I open the attribute table in ESRI ArcPro, after SF and CF for State name and County name, I see DF_PFS, AF_PFS, HDF_PFS... And none of these attribute headings are found anywhere in the technical support document or codebook tables, so I don't know to make this data comprehensible and useful for offline regional analysis.

If the labels and descriptions in the codebook were in the same order top to bottom as left to right in the attribute table, that might be something to go on, but they're immediately out of order, with County Name coming before the State/Territory, so I have no way of knowing if the rest of the table rows line up with the attribute table columns.  

I don't yet know how to code or use GitHub, so maybe this code key is buried somewhere in the files available there, but I don't see why such crucial information is missing from the documentation or why it should be so difficult to find. 

Any assistance would be much appreciated.

[Kerger, Kameron N. EOP/OMB]

Hi Forest,

 

Sorry about that. I hope the attached file is what you are looking for / helpful. If not, feel free to reach back out and we can try to assist you further.
We are working to improve the CEJST documentation.

 

Thanks,
Kameron

--
You received this message because you are subscribed to the Google Groups "justice40-open-source" group.
To unsubscribe from this group and stop receiving emails from it, send an email to justice40-open-s...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/justice40-open-source/74582b24-50e7-4470-9d2e-6970dfd07aafn%40googlegroups.com.

[Manuel Salgado (WE ACT)]

Forest,

When I downloaded the shapefile data it came with a columns CSV that gave all the column heading information.  I'm not sure if it'll come through on the listserv, but I've attached it to this email (if not check where you unzipped the shapefile).  I do believe there are some headings that are not listed in the file (for example green space was omitted for some reason - but it IS in the shapefile) but for the vast majority of the column it should work.  In any event that should solve your problem.

Manuel Salgado / he, him, his

Environmental Justice Research Analyst

Federal Policy Office

WE ACT for Environmental Justice | WE ACT por la Justica Ambiental

Phone | Teléfono: 929.618.7194 (Work Cell)

manuel....@weact.org

http://www.weact.org/

[Forest Replogle]

Thanks so much for the prompt response!  This is exactly what I was looking for.