Feature Requests

ACS XML

I have used an XML reader to put the ACS variables into a tree structure. However, because the variables in the XML file are not in order (after the first level), it is not particularly easy to find the variable you want--particularly when there are over 60,000. Am I missing something?

Tags

Submitted by

Stage: Active

Feedback Score

2 votes
2 up votes
0 down votes
Idea#32

Idea Details

Vote Activity

  1. Upvoted
  2. Upvoted

Similar Ideas [ 4 ]

Events

  1. The idea was posted

Comments

  1. Comment
    Community Member

    Yes, they are not in order nor is the list complete. You might refer to the ACS 5 year summary file documentation available www.census.gov/acs. The list in the tech docn and related xls table shells are not sorted either.

  2. Comment
    christian.c.borillo

    I'm a novice at working with xml, but can't you use an XSLT transformation? There's a sort feature in it, e.g (adapted from WROX "Professional XSL", pg 07):

    [xsl:template match="yadda"]

    [xsl:sort select="Sort_on_field_1"/]

    [xsl:sort select="Sort_on_field_2"/]

    [/xsl:template]

    //Note: I'm substituting brackets for the carets because posting using HTML tags is not allowed

    If you're using Java or C# you can serialize your xml dataset and your xslt transformation. Once there, I don't know how you apply the serialized xslt to the xml datasource, but that might be an avenue for you to pursue. This should make it easier to find the hard-to-find variable.

    But I wouldn't even go this route. How are you transforming the dataset to XML? Why not sort the dataset before transforming to XML? Because you're going have a performance hit with so much data to do the xslt transforamtion?

  3. Comment
    gio ( Idea Submitter )

    Thanks everyone for the good suggestions....now that I know that the ACS variables are not limited to those in the XML file, and now that I have figured out the coding scheme I am using the table shells for the ACS data and constructing my variable tree from them...

  4. Comment
    Lisa W
    ( Moderator )

    The xml file has been updated.

Add your comment