Campaign: Using Data

How to access state and metropolitan area data book?

Hi Team,

 

I would like to access the data(excel files) from the below location using any web service/file system.

 

http://www.census.gov/compendia/smadb/SMADBmetro.html

 

Can you please let me know if is is feasible? If so can you please share the details.

 

I'm looking for Housing Units and Building permits information

Thank you.

Submitted by

Voting

0 votes
0 up votes
0 down votes
Active

Campaign: Application Showcase

Affordable Housing Market Data

AffordableHousingOnline.com provides affordable rental housing market data on every city and county in the U.S. For example, here is the affordable rental housing market page for Washington, DC: http://affordablehousingonline.com/housing-search/District-of-Columbia/Washington/ AHO's own proprietary database of Federally assisted housing is mashed up with Census place data to provide an innovative look into rental ...more »

Submitted by (@dave001)

Voting

4 votes
4 up votes
0 down votes
Active

Campaign: Bugs / Problems

In 1990 sf1, H0240001 should be a stored as a big integer

In the 1990 sf1 data call, H0240001 (Spec Own-occ HUs:Agg Value) is currently returned as a regular integer. However, all the state values are the same - 2,147,483,647, which is the max value that can be stored in a regular integer, indicating that the variable should be stored as a big integer.

Submitted by (@egillingham)

Voting

0 votes
0 up votes
0 down votes
Active

Campaign: Bugs / Problems

In 1990 sf1, H0240001 should be a stored as a big integer

In the 1990 sf1 data call, H0240001 (Spec Own-occ HUs:Agg Value) is currently returned as a regular integer. However, all the state values are the same - 2,147,483,647, which is the max value that can be stored in a regular integer, indicating that the variable should be stored as a big integer.

Submitted by (@egillingham)

Voting

0 votes
0 up votes
0 down votes
Active

Campaign: Application Showcase

Community Profiles

We wanted to share our Community Profiles site. It was originally launched in Rhode Island. Our new design is also being rolled out in Pennsylvania. Site is designed to provide easy access to community data. The goal has been to combine Census API data with other community data! Current Version: http://profiles.provplan.org/ New (Beta) Version: http://pittsprofiles.provplan.org/ We looked to provide an easy way ...more »

Submitted by (@rkelly)

Voting

3 votes
3 up votes
0 down votes
Active

Campaign: Bugs / Problems

Duplicate (and incorrect) "Female 85 years and older" variable

I'm examining a tract in NYC. I found two different codes (P0120026 and P0120049) whose label and concept match exactly: "label": "Female: !! 85 years and over", "concept": "P12. Sex By Age [49]" Furthermore, they return VASTLY different values. See queries below: http://api.census.gov/data/2010/sf1?key=[key]&get=P0120049,NAME&for=block:*&in=state:36+county:061+tract:004200 http://api.census.gov/data/2010/sf1?key=[key]&get=P0120026,NAME&for=block:*&in=state:36+county:061+tract:004200 ...more »

Submitted by (@elizabeth.duncan)

Voting

2 votes
2 up votes
0 down votes
Active

Campaign: Application Ideas

Bizup – Business Data Mashup

Build an app that pulls the most useful variables for businesses from the Census API, with some user customization or drop down menus, and which easily ports into existing commercial software packages. This would allow commercial companies to easily use Census data and mash it up with their data to support new and existing business owners

Submitted by (@marie.t.jones)

Voting

0 votes
0 up votes
0 down votes
Active

Campaign: Application Ideas

Bizup – Business Data Mashup

Build an app that pulls the most useful variables for businesses from the Census API, with some user customization or drop down menus, and which easily ports into existing commercial software packages. This would allow commercial companies to easily use Census data and mash it up with their data to support new and existing business owners

Submitted by (@marie.t.jones)

Voting

0 votes
0 up votes
0 down votes
Active

Campaign: API Technical Discussions

How to decode the Variables?

I am looking at the examples of Request URL examples. I am wondering if the Variables follow any structure and if so were I can learn about it. In another words, can those variables be interpreted to what data is requested? If so, is there a document that describe it? Are the letters in the front has any significance/rules, and are the following digits follow any rules? P012D007, B02001_001E, PCT012A015 etc.... ...more »

Submitted by (@eitanbarazani)

Voting

0 votes
0 up votes
0 down votes
Active

Campaign: Application Ideas

Map Compare Tool

This tool is available in the AFF table view options, would a similar tool for comparing maps displaying data be a benefit for the community?

Submitted by (@rkased)

Voting

0 votes
0 up votes
0 down votes
Active

Campaign: Application Ideas

Map Compare Tool

This tool is available in the AFF table view options, would a similar tool for comparing maps displaying data be a benefit for the community?

Submitted by (@rkased)

Voting

0 votes
0 up votes
0 down votes
Active

Campaign: Application Showcase

Point Context

http://grahamimac.com/pointcontext/

 

Paste any point data into Point Context, and it presents a heatmap and provides basic Census data on the average neighborhood for your points.

 

I originally tried to use the API but found that for larger datasets I had to make way too many API calls to get all the tract data I needed. So I downloaded and stored the Census data in my own database.

Submitted by (@graham3333)

Voting

3 votes
3 up votes
0 down votes
Active