Mike's Wiki - census

highcharts

Anonymous (anonymous@undisclosed.example.com) — 2025-12-19T18:27:17+00:00

Installing HighCharts Highcharts offers a number of graph types, such as lines, bar, pie, etc. We'll be using highcharts to blend in with QGIS. On your webserver, change your directory to your “document_root” (ie. /var/www/html) * sudo su - root

qgis_example2

Anonymous (anonymous@undisclosed.example.com) — 2025-12-30T21:16:06+00:00

QGIS Data Layer - University Downloading * To download the shapefile for the IPEDS data of locations of Universities in the US: * * Click “Export” tab * Click the “CSV” file as the “shp” file was malformed Importing CSV File

qgis_install

Anonymous (anonymous@undisclosed.example.com) — 2025-12-19T20:17:29+00:00

Installing QGIS The following are instructions on installing and starting QGIS on Ubuntu/Mint22. Installing Qgis The following are instructions for Installing QGIS on Ubuntu/Mint and then loading Census Data * apt update * As user root: apt install qgis (this installed 3.22 which is a long term support version)

qgis_poverty_date

Anonymous (anonymous@undisclosed.example.com) — 2025-12-31T19:44:26+00:00

DRAFT Placeholder - Download the 2023 5 Year ACS. Variables are statefips, puma, household Income and foodstamps. Puma/State are the bridge between the shapefiles and the database create database puma_db; create user 'puma_user'@'%' identified by 'xxxxx'; grant all privileges on puma_db.* to 'puma_user'@'%'; mysql> create table temp ( year int(4), multi_year int(4), sample int(8), serial int(12), cbserial int, -- Serial number of the sample hh_weight float, -- number of hou…

qgis_using

Anonymous (anonymous@undisclosed.example.com) — 2025-12-22T19:15:11+00:00

QGIS First, let's get this over with and go with the basics. Shape Files What are shape files ? They are files that store polygons. An example of a shape is a triangle, which consists of 3 X,Y coordinates on a 2 dimensional plane. A square has 4, and so on. A state or a county can have hundreds of points. States like Colorado (basically a square)are much simpler compared to New York, New Jersey, etc.. or Wisconsin.

qgis

Anonymous (anonymous@undisclosed.example.com) — 2025-12-19T16:35:51+00:00

Download Census Data Downloading Census Data for PUMA (Names) The data can be found on the census site itself: * Scroll down until you see: 2020 PUMA Names File [<1.0 MB] * Download the file * Because the file is in acrobat, use Google Docs to open it.

state_codes

Anonymous (anonymous@undisclosed.example.com) — 2025-12-19T18:31:25+00:00

State Codes Used by QGIS 01 AL ALABAMA 02 AK ALASKA 04 AZ ARIZONA 05 AR ARKANSAS 06 CA CALIFORNIA 08 CO COLORADO 09 CT CONNECTICUT 10 DE DELAWARE 11 DC DISTRICT OF COLUMBIA 12 FL FLORIDA 13 GA GEORGIA 15 HI HAWAII 16 ID IDAHO 17 IL ILLINOIS 18 IN INDIANA 19 IA IOWA 20 KS KANSAS 21 KY KENTUCKY 22 LA LOUISIANA 23 ME MAINE 24 MD MARYLAND 25 MA MASSACHUSETTS 26 MI MICHIGAN 27 MN MINNESOTA 28 MS MISSISSIPPI 29 MO MISSOURI 30 MT MONTANA 31 NE NEBRASKA 32 NV NEVADA 33 NH NEW HAMPSHIRE 34 NJ NEW JERSE…

super_fund_sites

Anonymous (anonymous@undisclosed.example.com) — 2025-12-22T20:58:31+00:00

Data Overlay - Superfund Sites EPA Superfund sites shapes can be found here: * Download the file (.gz) from the above site and copy it to your data directory. * In my case, I will be placing it under /opt/qgis/SuperFund * Open QGIS and go to the toolbar or menu: Layer > Add Layer > Add Vector Layer.