Data Points and Geocoding

 



This week's exercise focused on creating our own spatial data using tables instead of the "ready-made" shapefiles or feature classes. In other words, we used Excel tables to organize and clean up data we collected from other websites. This exercise used Manatee County's school names and address data from the Florida Department of Education, which needed to be cleaned up before it could be used in ArcGIS, and data from the U.S. Census Bureau about Florida Counties and Manatee County. Why did we need the U.S Census Bureau information? We needed the street names in Manatee County (tl_2020_12081_edges that was projected to NAD1983 (2011) Harn State Plane Florida West FIPS 0902 Feet and renamed Edges_HarnSP) recorded in the U.S.C.B. shapefile. With that information, we were able to set up an address locator in order to geocode known school locations based on their address and zip codes.

The screenshot above shows the results of the Excel Table clean-up and geocoding in order to view these locations on the map. Since not all addresses could be matched, we had to manually pick the locations based on Google Maps as well as the help of the BaseMap. Overall, this was a really fun assignment, and I really enjoyed using Excel again and creating a web map of the school locations.

The link to the web map: https://arcg.is/00KTyz 

Comments

Post a Comment

Popular posts from this blog

M1 - Python Environments & Flowcharts

Image
  Python Module 1 Recap: From Scripts to Flowcharts and Zen Principles Converting 3 Radians to Degrees To convert 3 radians to degrees, we use a simple formula: degrees = radians * 180 / pi Below is the flowchart illustrating the conversion process: Running the calculations in IDLE gives us:  ≈ 171.887 Interpretation of the Zen of Python The "Zen of Python" showcases the philosophy and guiding principles of Python programming. It emphasizes simplicity, readability, and clarity in code. In other words, “Zen of Python” promotes straightforward and elegant solutions over complicated ones. By valuing explicitness over implicitness, the basis of Python encourages clear and understandable code. Moreover, The principles highlight the importance of practicality and avoiding unnecessary complexity— why use 4 lines of code when 1 will do the same thing? This mentality helps to balance between purity and practicality. Overall, the “Zen of Python” advocates for writing code that is easy
Read more

GIS Map Projections

Image
  This week's lab exercise looked at the importance of map projections in GIS, especially when using multiple datasets. The map above shows four counties in Florida that are displayed using the Albers Conical Equal Area, NAD 1983 UTM Zone 16N, and NAD 1983 HARN State Plane Florida North FIPS 0903 (US Feet) map projections. As the table within the map shows, the areas of the counties vary depending on the map projections. The best map projections are ones that shows the least distortion between map features. For example, The UTM projection is best when used the map features fit within one UTM zone, which is not the case for showing the entire state of Florida. The same can be said for the Florida State Plane that is dependent on the region of interest. Therefore, the map projection would need to be Albers since it minimizes distortion between its standard parallels.  Overall, this lab illustrates how important it is to use accurate map projections since it can cause distortions betw
Read more

ArcGIS Pro Orientation

Image
  Module 1 Lab Assignment This first lab assignment's objective is to prepare and show what is expected for future lab assignments. The primary learning outcomes involved: Getting familiar with accessing the ArcGIS software through Argo Apps. Assessing data storage drives. Preparing project folders for each project. The map shown above is a visualization of the Cities and World Countries data files found in the OverviewArcGIS file in the R drive. In order to view the shapefiles in a way that is informative, we had to add a Folder Connection to the data we downloaded as well as update the symbology to show graduated colors for the field POP_2007 with Natural Breaks and 7 classes. It is important to use a single color from light to dark when using sequential data. While I wish this had been a smooth and uncomplicated process, I struggled with learning UWF's Argo Apps since that is how we access ArcGIS Pro without downloading it to our personal computers. While I am familiar with
Read more