I am obviously overlooking something. There must be a better way to determine a "Concept"/"Variable Name" than trudging through the xml file.
Can someone please point me in the correct direction?
Thanks
Rank51
Idea#65
I am obviously overlooking something. There must be a better way to determine a "Concept"/"Variable Name" than trudging through the xml file.
Can someone please point me in the correct direction?
Thanks
I believe the xml is our only source of variable name documentation for programmatically accessing api. If your looking for a specific variable, then the acs website will have more documantation: http://www.census.gov/acs/www/
For what it's worth, I've been developing an R package ("acs.R") to work with ACS data, and it includes a lookup feature to search for tables and variables based on keywords, using the XML files for each year. The results can be passed to another function along with geographic selections, to automates the API download.
I've been able to convert the XML format into a 3-column table containing the name of the dataset, the "concept" of that dataset, and lastly the description of the dataset, e.g. "Native Hawaiian and Other Pacific Islander alone or in combination with other races."
I did this by creating a C# web app...it doesn't do much other than what I described, but it made my life sane rather than trying to decipher the xml document.
If this is what you need, or if you simply need just the information contained in the table copied and pasted into a Word document, let me know.
Rock and roll Christian. Is it possible to put that up on github for us?
Hi all,
Just set up a github account. You can get the source code (in the zip file "Census_Api_Concepts.zip" at https://github.com/nickcamporillo/Census_Api
Have you looked at this site: http://www.socialexplorer.com/pub/ReportData/MetaBrowser.aspx
It seems to have aggregated the metadata in a useful manner. For example: http://www.socialexplorer.com/pub/ReportData/metabrowser.aspx?survey=ACS2011_5yr&ds=ACS11_5yr&var=B08126004&header=True explains what that category means, etc.
That site has more metadata than is available inn the census ACS API but I think it is a superset.
Hope that helps.
I also wrote a quick start tutorial based on my experiences: http://www.mooreds.com/wordpress/archives/963