This is my second attempt to post this question since the answers to my first question were not as useful as I had hoped. The link to my first question is here: first question attempt
I am trying to solve a problem at a national level but am starting with Rhode Island to solidify my approach. Thus, everything in this question will be focused on the state of Rhode Island.
I’d like to figure out the following: For each census tract in Rhode Island, what percent of land area is covered by a certain company (total of 3 companies). Making sure that water area is not included in the calculations.
And just as an FYI, I am extremely new to GIS in general and have been going at this problem for a few days now. I am using QGIS 2.18.9.
I have 3 input files:
- The 2010 Census Tract shapefile (RI_Tracts) for Rhode Island with edited fields for simplicity:
- A CSV file (RI_Tract_Tiers) that classifies each census tract into tiers 1-5:
- A CSV file (RI_Offices) for office locations with the following fields:
What I've Tried
- Join the RI_Tracts table with the RI_Tract_Tiers table to classify the Tracts into tiers
- Color code the census tracts by Tract_Tier
- Import and buffer the company locations in the RI_Offices file
- Buffer distance is 10,000ft (3048 meters), so I enter “0.030480” into the distance field of the Fixed Distance Buffer tool
- Dissolve the company locations by Office_Category to get rid of any overlaps b/w the same company
- Color code the company locations by Office_Category
This is where I get stuck. I have tried using the following tools to analyze the map and get the output I want (with no success):
- Statistics by Categories