A procedure of systematically acquiring and recording information about all the members of a given population.

learn more… | top users | synonyms

6
votes
2answers
799 views

PostGIS - area-weighted calculation on an intersection

I'm trying to learn postgis sql by performing some familiar operations from ArcGIS. Here, I want to perform an area-weighted calculation of certain populations on the intersection of a set of parcels ...
4
votes
2answers
870 views

What's the difference between US Census DMA and MMA?

DMA and MMA are commonly used to denote a large, metropolitan municipal entity. Is there a difference between the two? Is there a certified definition to these terms? Google is a bit inconclusive ...
3
votes
2answers
392 views

merging block group data that uses 2000 geography with 2010 geography

I would like to combine data sets from 2010 which use 2000 geography with 2011 data that use 2010 census geography. The data is from the contiguous US and is either at block or block group level. I am ...
3
votes
1answer
2k views

How to compare 2000 Census block group data with 2010 block group data?

I want to calculate the percent change for median household income in Los Angeles at the block group level from 2000 to 2010. Someone told me I have to reaggregate 2000 block data to 2010 block group ...
10
votes
3answers
460 views

How can I handle tables with 256+ variables?

I'm working with census data and downloaded several CSV files, each with with 600ish columns/variables. I'd like to store them all in a query-able database, but everything I've tried so far (MS ...
4
votes
1answer
617 views

Joining Census Data

I have collected census data for a county in Pennsylvania. Data varies from 1999-2010. For my data before 2010, a significant number of blocks do not match up (image below) when I join the data ...
2
votes
1answer
68 views

Is it possible for me to perform a map of New Mexico where deaf person lives in a county from the US Census database?

I would like to get some feedback from those who have been doing or perform on US Census. Map. My question here is there a way for me to get information on Deaf person living in New Mexico. Would US ...
7
votes
2answers
2k views

What is the SRID of census.gov shapfiles?

I downloaded the county files from: http://www.census.gov/cgi-bin/geo/shapefiles2011/main I cannot figure out what SRID to use with them. When I am trying to generate a class file from ./manage.py ...
0
votes
0answers
28 views

How to get 2010 Census Block Housing Unit Data for the entire US for 15-digit FIPS blocks [duplicate]

Possible Duplicate: Where can I find the finest granularity of 2010 US census population information? I'm working on a little data munging project and I need to find 2010 US Census data for ...
3
votes
3answers
887 views

Where can I find the finest granularity of 2010 US census population information?

I am writing a re-districting application where I want to be able to create US voting districts based on geographic coordinate population data. In a perfect world, I would have the population for each ...
1
vote
4answers
218 views

Looking for Cities population datasets for the state of Arizona

Looking for cities in Arizona especially I'd like to have them with that has population attributes. I've checked Arizona's geospatial websites and none of them I have found. Does anyone know where I ...
1
vote
2answers
138 views

How to get city data only and not county?

Most of the data I've come across only comes in state/county/block group/block format. However, I'd like to pare down the shapefile to only observe the block groups within a city, not the county of ...
1
vote
0answers
45 views

Level of data available on FactFinder

I am trying to find data at the block level or even block group level for the SF1 files and ACS 2010 or 2009. Just recently, two months ago, I was able to get this data but for some reason I am now ...
1
vote
1answer
979 views

How to get 2010 Census Block Data on Race and Age?

I'm interested in observing racial segregation in public & charter elementary schools in San Diego city (not county). I believe the best way to analyze this would be at the block level and have ...
3
votes
4answers
4k views

Free api to reverse geocode latitude, longitude to census tract?

I have a bunch of latitude,longitude coordinates (mostly city/town centroids) in the United States for which I'd like to find the containing census tract. For instance, input => nn.nnn, -nn.nnn ...
5
votes
2answers
1k views

US Tiger or Open Street Map Route Data: One Way Street & Intersection Data

We're building a U.S. street routing application (finding paths for cars between two or more locations using public roads) and would like to use open source data US Tiger Data or Open Street Map or ...
1
vote
1answer
183 views

Demographic Info within 3 miles of longitude and latitude

I want to get demographic information within three or five miles of a location given its longitude and latitude. The demographic info I am looking for include number of people, age distribution, ...
2
votes
2answers
805 views

Gathering data for a large number of census block groups

I would like to collect some census data for every block group in New England. I'm primarily interested in median income and median age, and ideally I'd like a large .csv file with one row per census ...
6
votes
1answer
3k views

What does the code RTTYP represent in the USA Tiger road files?

I'm trying to figure out what a particular code represents in the US Census Tiger Line files for roads. I downloaded roads for the US from here. I've searched the documentation (link to large pdf) and ...
6
votes
3answers
855 views

How to convert factfinder2.census.gov map data to KML?

I've downloaded a map from http://factfinder2.census.gov/faces/tableservices/jsf/pages/productview.xhtml?pid=DEC_10_SF1_P1 (limited to San Francisco census tracts), and I'd like to convert it to KML ...
6
votes
2answers
1k views

Using the US census to analyze data nationally

I'm trying to make a table to relate the STFID and LOGRECNO values for the US 2000 census at the block group level, nationally. I realize that the LOGRECNO value is a state specific unique variable, ...
6
votes
1answer
759 views

Help using the US American Community Survey Data

I want to use the USA American Community Survey Data for spatial analysis, but I'm having difficulty understanding how the survey tables are constructed so that I can relate them to block-group ...
1
vote
3answers
870 views

How to match Census Block Groups from different decades to show percent change?

I know for Census Tracts and Blocks there are Relationship files, but what is the best way to match Census Block Groups from different decades to compare change?
5
votes
4answers
1k views

What is a best practice way to display/feed US census/tiger data into Google Maps API?

Let's say I want to display age, income, etc based on census block groups on Google maps. What is the best practice or recommended way to do so and also to allow to do simple queries?
3
votes
1answer
182 views

Get points in point file to write into new field the census tract each is in (from another shapefile)

I have points that represent day care centers which have address and lat-long. I am using lat-long to display. Now I need to sort, count, etc. these points in conjunction with new census data. To be ...
9
votes
2answers
412 views

How would one geocode historical US census records?

I want to geocode census records from the U.S. Here is one example from 1870. This particular census page is from the 6th election district, 8th ward of New York County. Here's one from the 1910 ...
2
votes
1answer
126 views

Where is the pdf of the US Census data stored that contains all the codes?

I'm working with US census data and I can't locate the documentation that explains all of the codes (e.g. P01001 etc) that is used to describe the attribute tables in the shapefiles. I haven't been ...