Vjylku

What is a term for a function that when called repeatedly, has the same effect as calling once?

What is better: yes / no radio, or simple checkbox?

If there are any 3nion, 5nion, 7nion, 9nion, 10nion, etc.

Can I cast a spell through the Invoke Duplicity clone while inside a Forcecage?

How does insurance birth control work?

Difference between 'stomach' and 'uterus'

PTIJ: Aharon, King of Egypt

Reason why dimensional travelling would be restricted

Can I solder 12/2 Romex to extend wire 5 ft?

What is the minimum amount of skill points per HD?

Why do phishing e-mails use faked e-mail addresses instead of the real one?

Is there a full canon version of Tyrion's jackass/honeycomb joke?

How to kill a localhost:8080

Do AL rules let me pick different starting equipment?

Are there other characters in the Star Wars universe who had damaged bodies and needed to wear an outfit like Darth Vader?

The need of reserving one's ability in job interviews

"seeing as you don't know anyone but me" meaning in this context

How can I be pwned if I'm not registered on the compromised site?

Being asked to review a paper in conference one has submitted to

Wardrobe above a wall with fuse boxes

Has Wakanda ever accepted refugees?

Formatting a table to look nice

How to mitigate "bandwagon attacking" from players?

Four buttons on a table

Aggregating census level data to county level in QGIS?

Using the US census to analyze data nationallyHow to compare 2000 Census block group data with 2010 block group data?US unemployment data by zip (or aggregating data up to county level)All US 2010 Census Data - Tract LevelHaving trouble matching up U.S. Census shapefiles in QGISDownloading US Census data?How to find income data by census tract or block?Joining Census block dataRenter Area Median Income?Comparing Tract-level data to State-level?

1

I'm trying to take census tract linked data (in the form of a CSV I joined to a census tract level map of Washington State) and create a county-level map with it. My census data also has the county listed as a separate variable for each census tract (so basically what county each census tract belongs to). How can I take these census data and aggregate them to a county level in QGIS? More specifically, I'm trying to aggregate median income and percent of unemployment from the census level to the county level.

I've tried spatially joining the census map with the data to a county level map however the new values in the attribute table do not appear to be correct.

qgis spatial-join census county

share|improve this question

edited 12 mins ago

PolyGeo♦

53.6k1781241

asked 4 hours ago

M. YatesM. Yates

61

New contributor

M. Yates is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  try join attributes by location (summary) instead of the simple join attributes by location
  
  – csk
  3 hours ago
  

  
  
  
  

add a comment | 

1

I'm trying to take census tract linked data (in the form of a CSV I joined to a census tract level map of Washington State) and create a county-level map with it. My census data also has the county listed as a separate variable for each census tract (so basically what county each census tract belongs to). How can I take these census data and aggregate them to a county level in QGIS? More specifically, I'm trying to aggregate median income and percent of unemployment from the census level to the county level.

I've tried spatially joining the census map with the data to a county level map however the new values in the attribute table do not appear to be correct.

qgis spatial-join census county

share|improve this question

edited 12 mins ago

PolyGeo♦

53.6k1781241

asked 4 hours ago

M. YatesM. Yates

61

New contributor

M. Yates is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  try join attributes by location (summary) instead of the simple join attributes by location
  
  – csk
  3 hours ago
  

  
  
  
  

add a comment | 

I'm trying to take census tract linked data (in the form of a CSV I joined to a census tract level map of Washington State) and create a county-level map with it. My census data also has the county listed as a separate variable for each census tract (so basically what county each census tract belongs to). How can I take these census data and aggregate them to a county level in QGIS? More specifically, I'm trying to aggregate median income and percent of unemployment from the census level to the county level.

I've tried spatially joining the census map with the data to a county level map however the new values in the attribute table do not appear to be correct.

qgis spatial-join census county

share|improve this question

edited 12 mins ago

PolyGeo♦

53.6k1781241

asked 4 hours ago

M. YatesM. Yates

61

New contributor

M. Yates is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 12 mins ago

PolyGeo♦

53.6k1781241

asked 4 hours ago

M. YatesM. Yates

61

New contributor

M. Yates is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 12 mins ago

PolyGeo♦

53.6k1781241

asked 4 hours ago

M. YatesM. Yates

61

New contributor

M. Yates is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 12 mins ago

PolyGeo♦

53.6k1781241

edited 12 mins ago

PolyGeo♦

53.6k1781241

asked 4 hours ago

M. YatesM. Yates

61

New contributor

M. Yates is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 hours ago

M. YatesM. Yates

61

2 Answers
2

active

oldest

votes

0

Try joining by attribute field instead of by location. Add a new vector join to your county layer:

• Join layer: census tract data


• Join field: county field of census tract data


• Target field: county field of county layer

From there, you should be able to properly aggregate the data.

share|improve this answer

answered 2 hours ago

jyinglingjyingling

114111

add a comment | 

0

As an aside, since you want to aggregate numbers that are ratios or otherwise not something that can be directly aggregated, you need to aggregate numerators and denominators independently. Consider two tracts:

A. median income 10 (from 0, 0, 10, 10, 50, 100, 10000)
B. median income 100 (from 0, 0, 0, 0, 100, 101, 102, 103, 104)

The overall median is (0, 0, 0, 0, 0, 0, 10, 10, 50, 100, 100, 101, 102, 103, 104, 10000) or interpolated between 10 and 10, or 10.

I'm not sure how you should do it, since you won't have the actual numbers. maybe an "average" median income and unemployment? You might be able to calculate the correct unemployment rate if you have the denominator for employment.

share|improve this answer

answered 1 hour ago

BryanBryan

1

New contributor

Bryan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

M. Yates is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f314616%2faggregating-census-level-data-to-county-level-in-qgis%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Try joining by attribute field instead of by location. Add a new vector join to your county layer:

• Join layer: census tract data


• Join field: county field of census tract data


• Target field: county field of county layer

From there, you should be able to properly aggregate the data.

share|improve this answer

answered 2 hours ago

jyinglingjyingling

114111

add a comment | 

0

Try joining by attribute field instead of by location. Add a new vector join to your county layer:

• Join layer: census tract data


• Join field: county field of census tract data


• Target field: county field of county layer

From there, you should be able to properly aggregate the data.

share|improve this answer

answered 2 hours ago

jyinglingjyingling

114111

add a comment | 

Try joining by attribute field instead of by location. Add a new vector join to your county layer:

• Join layer: census tract data


• Join field: county field of census tract data


• Target field: county field of county layer

From there, you should be able to properly aggregate the data.

share|improve this answer

answered 2 hours ago

jyinglingjyingling

114111

share|improve this answer

answered 2 hours ago

jyinglingjyingling

114111

answered 2 hours ago

jyinglingjyingling

114111

answered 2 hours ago

jyinglingjyingling

114111

0

As an aside, since you want to aggregate numbers that are ratios or otherwise not something that can be directly aggregated, you need to aggregate numerators and denominators independently. Consider two tracts:

A. median income 10 (from 0, 0, 10, 10, 50, 100, 10000)
B. median income 100 (from 0, 0, 0, 0, 100, 101, 102, 103, 104)

The overall median is (0, 0, 0, 0, 0, 0, 10, 10, 50, 100, 100, 101, 102, 103, 104, 10000) or interpolated between 10 and 10, or 10.

I'm not sure how you should do it, since you won't have the actual numbers. maybe an "average" median income and unemployment? You might be able to calculate the correct unemployment rate if you have the denominator for employment.

share|improve this answer

answered 1 hour ago

BryanBryan

1

New contributor

Bryan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

As an aside, since you want to aggregate numbers that are ratios or otherwise not something that can be directly aggregated, you need to aggregate numerators and denominators independently. Consider two tracts:

A. median income 10 (from 0, 0, 10, 10, 50, 100, 10000)
B. median income 100 (from 0, 0, 0, 0, 100, 101, 102, 103, 104)

The overall median is (0, 0, 0, 0, 0, 0, 10, 10, 50, 100, 100, 101, 102, 103, 104, 10000) or interpolated between 10 and 10, or 10.

I'm not sure how you should do it, since you won't have the actual numbers. maybe an "average" median income and unemployment? You might be able to calculate the correct unemployment rate if you have the denominator for employment.

share|improve this answer

answered 1 hour ago

BryanBryan

1

New contributor

Bryan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

As an aside, since you want to aggregate numbers that are ratios or otherwise not something that can be directly aggregated, you need to aggregate numerators and denominators independently. Consider two tracts:

A. median income 10 (from 0, 0, 10, 10, 50, 100, 10000)
B. median income 100 (from 0, 0, 0, 0, 100, 101, 102, 103, 104)

The overall median is (0, 0, 0, 0, 0, 0, 10, 10, 50, 100, 100, 101, 102, 103, 104, 10000) or interpolated between 10 and 10, or 10.

I'm not sure how you should do it, since you won't have the actual numbers. maybe an "average" median income and unemployment? You might be able to calculate the correct unemployment rate if you have the denominator for employment.

share|improve this answer

answered 1 hour ago

BryanBryan

1

New contributor

Bryan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this answer

answered 1 hour ago

BryanBryan

1

New contributor

Bryan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 1 hour ago

BryanBryan

1

New contributor

Bryan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 1 hour ago

BryanBryan

1