BIA4100 - Project 1 - V1

docx

School

Middle Tennessee State University *

*We aren’t endorsed by this school

Course

4100

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

6

Uploaded by MagistrateLightningApe33

Report
BIA4100 Project 1 Tennessee GeoSMART: Crafting a Bespoke Geospatial Layer In this assignment, you will contribute to the Tennessee GeoSMART geospatial model by creating a new layer that aligns with your interests or research focus. You’ll make a brand-new layer about something you’re passionate about or curious to explore. Ideally, you will use this layer when doing Project 2 later in the term. This layer must use Census tract-level data and have a clear and specific role in the GeoSMART model. Assignment STEP 1 - Pick a Personal Interest: Choose a topic that interests you or a question you’d love to answer. It could be anything from analyzing healthcare accessibility to studying transportation patterns, environmental factors, or socio-economic dynamics. I’ve provided a variety of potential data sources at the end of this document. This is a solo project; your research interest/question should be different than those of your classmates. STEP 2 - Data Adventure: Collect data about your chosen topic, especially Census tract-level data. Make sure it’s something you can use in QGIS or a Jupyter Notebook. If you cannot find the data, you may need to revise Step 1. Note: This step will take a considerable amount of time so plan ahead. You may need to scape websites or copy text, convert (geocode) addresses, etc. STEP 3 - Data Processing: In Excel, QGIS, or Jupyter Notebook, process and prepare the data for integration into the GeoSMART model. You will probably need to tidy up the data, make it easier to work with, or combine different pieces. Your ideal layer will include the census tract polygons with new attributes you calculated – you must add at least two new attributes . Be creative in your solution. Note – if you are using global data or United States data – I recommend that you clip the data source to Tennessee for improved performance. Note: You will be making assumption when creating your new layer. It is important to document your assumptions carefully. STEP 4 - Layer Creation and Documentation: Create your very own geospatial layer, and don’t forget to explain what it’s all about. Tell us why you’re making it and where your data came from. Embed this information in the Jupyter Notebook or a separate MS Word document if using QGIS. Deliverables & Scoring Artifacts (20% of the Project Grade – 20 Points): Your final layer should be a GeoPackage (a Shapefile or GeoTIFF will be accepted, but not preferred). Geospatial layer must use be at the census tract level for the state of Tennessee. The attribute table must include the tract GeoIDs and at least two NEW attributes. NOTE: Projects
that do not adhere to these minimum standards will not be accepted/graded. So, for example, if you source data are points, you must convert them to counts, percentages, Booleans, or other at the tract level. Your GeoPackage should only include the census tract polygons aling with the attribute table. Include a ZIP file of your source files. If using QGIS, include your project file. If using Jupyter, include your notebook. Documentation (80% of the Project Grade - 80 Points): If using QGIS – draft a comprehensive and professional MS Word Document (12-point font, Times New Roman) that describes the purpose of your layer, the data sources, and the steps you took to create the layer. The narrative should be very clear and concise. The MS Word file should include at least two map presentations. For example, if you added two attribute columns (e.g., number of assisted living facilities and number of healthcare workers in each census tract) each could be presented using a thematic map (using relevant classifications). If using Jupyter – include professional-level documentation in your notebook using the criteria defined above. Do not submit a separate MS Word file or QGIS project file. Presentation (100 Points): I recommend that your presentation mention the steps you took to create your project, the assumptions you made, and a description of your findings. Be specific. Note: If using Jupyter, you may simply walk through the notebook. Upload your presentation to YouTube and share in the separate discussion area. Keep it interesting and explain why you decided to create your particular layer! Reflection (50 Points): Reflect on the assignment in the sperate discussion area. Remember: If you run into any questions or bumps, feel free to reach out for help. Good luck with your GeoSMART adventure!
Potential Data Sources Note: The following links will help guide your Data Adventure (see Step 2 above). You may have your own ideas, but do explore what is available and what makes sense from an analytic perspective. Document everything that you do when modifying your data. TN Tracts https://catalog.data.gov/dataset/tiger-line-shapefile-2016-state-tennessee-current-census- tract-state-based https://catalog.data.gov/dataset/tiger-line-shapefile-2019-2010-state-tennessee-2010-census- block-state-based << USE THIS https://www2.census.gov/geo/tiger/TIGER_RD18/STATE/47_TENNESSEE/47/ https://www2.census.gov/geo/tiger/TIGER_DP/2021ACS/ https://tigerweb.geo.census.gov/tigerweb/ https://dot.ca.gov/-/media/dot-media/programs/local- assistance/documents/atp/cy5/findingcensustractnumbers.pdf TIGER Definitions: https://www2.census.gov/geo/tiger/TIGER2020/2020_TL_Shapefiles_File_Name_Definitions.pd f TN PPE Per Pupil Expenditures https://oese.ed.gov/ppe/tennessee/ << USE THIS, look for Excel Download A Primer on STEM Designation https://www.tnstemdesignation.org/wp-content/uploads/Reimaging-School-Culture.pdf STEM Designated Schools << USE THIS, may need to be scraped. https://www.tnstemdesignation.org/current-designated-schools/ TN Census Data Downloads Instructions: https://www.fcc.gov/sites/default/files/instructions_for_looking_up_census_tracts.pdf https://tnsdc.utk.edu/data-and-tools/2020-census/
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Website for Custom Data Tables https://www.census.gov/data/tables/2023/dec/2020-census-demographic-profile.html#data Census Data filtered for Tracts in TN (this query result links might not work without building a new query): <<<< USE THIS https://data.census.gov/table? q=Employment&g=040XX00US47$1400000&tid=ACSST5Y2021.S2401 Census Data filtered for TN (this query result links might not work without building a new query): https://data.census.gov/table?g=040XX00US47&d=ACS+1- Year+Estimates+Detailed+Tables&tid=ACSDT1Y2021.B03001 https://data.census.gov/table?g=040XX00US47&d=ACS+1- Year+Estimates+Detailed+Tables&tid=ACSDT1Y2021.B03001 https://www.census.gov/data/tables/2023/dec/2020-census-demographic-profile.html FEMA Flood Maps: https://www.fema.gov/flood-maps/national-flood-hazard-layer https://msc.fema.gov/portal/availabilitySearch? addcommunity=470165&communityName=RUTHERFORD%20COUNTY%20UNINCORPORATED %20AREAS#searchresultsanchor https://hazards-fema.maps.arcgis.com/apps/webappviewer/index.html? id=8b0adb51996444d4879338b5529aa9cd TN Health Data https://www.tn.gov/health/cedep/environmental/healthy-places/healthy-places/tools-and- resources/tr/data-and-indicators.html OSM Regional https://download.geofabrik.de/north-america/us-south.html# http://download.openstreetmap.fr/extracts/north-america/ OSM Overview (we can do this using a Pyton library)
https://mdl.library.utoronto.ca/technology/tutorials/exporting-map-data- openstreetmap#:~:text=Go%20to%20openstreetmap.org%20and,the%20visible%20extent%2C %20click%20Export . Census County Business Patterns: https://www.census.gov/data/datasets/2021/econ/cbp/2021-cbp.html Census Quality Map https://mtgis-portal.geo.census.gov/arcgis/apps/MapSeries/index.html? appid=7be530aad3e44457bac5736a3ee3f91b A note about ZCTA: https://www.census.gov/programs-surveys/geography/guidance/geo-areas/zctas.html Hospitals: https://www.ahd.com/states/hospital_TN.html Fish and Wildlife Biodata: https://gis-fws.opendata.arcgis.com/ USGS Species Data Download: https://www.usgs.gov/programs/gap-analysis-project/science/species-data-download TN Clearninghouse: https://www.tngis.org/ TN Map Portal https://tnmap.tn.gov/ Animal Tracking: https://www.movebank.org/cms/movebank-main USFS Tree Canopy Data: https://data.fs.usda.gov/geodata/rastergateway/treecanopycover/ UTK Tennessee Data: https://libguides.utk.edu/tngis/health SAMHSA Substate Data: https://www.samhsa.gov/data/report/2016-2018-nsduh-substate-region-shapefile TN MTB Trails: https://www.mtbproject.com/directory/8010292/tennessee
TN Crash Data: https://www.tn.gov/safety/stats/crashdata.html TN Navigable Waterways: https://www.lrn.usace.army.mil/Missions/Regulatory/Navigable-Waters-List/
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

Palermo - Part 5.docx
GuidedStudy.docx
Memo.docx
TrainingGuide.docx
RadhikaRaghuwanshi_HW7.pdf
figure 11.docx
Final Exam Review - Part 1.pdf
M03 - Part 2- Case Project 6-3- Lightweight Cryptography (3).docx
HW4 - Clustering & Association.docx
Lab04.html
lab2_dataTypes_new.html
lab03_tables.html
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
SEE MORE TEXTBOOKS