{"id":7720,"date":"2026-09-29T22:07:03","date_gmt":"2026-09-30T03:07:03","guid":{"rendered":"https:\/\/sites.owu.edu\/geog-291\/?p=7720"},"modified":"2026-09-29T22:07:03","modified_gmt":"2026-09-30T03:07:03","slug":"jan-week-5","status":"publish","type":"post","link":"https:\/\/sites.owu.edu\/geog-291\/2026\/09\/29\/jan-week-5\/","title":{"rendered":"Jan Week 5"},"content":{"rendered":"<p dir=\"ltr\"><span style=\"text-decoration: underline\"><em><strong>Chapter 4: File Geodatabases<\/strong><\/em><\/span><\/p>\n<ul dir=\"ltr\">\n<li><em>A file geodatabase (.gdb) is Esri&#8217;s preferred way to store feature classes and tables, so shapefiles and CSVs get imported into it first.<\/em><\/li>\n<li><em>A join only works when both key fields are the same data type, which is why the text GEOID has to be turned into a number before joining census data.<\/em><\/li>\n<li><em>Spatial Join counts points inside polygons, such as burglaries per neighborhood.<br \/>\n<\/em><em><em>.<\/em><\/em><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7721\" src=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tunc-300x169.jpeg\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tunc-300x169.jpeg 300w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tunc-1024x576.jpeg 1024w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tunc-768x432.jpeg 768w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tunc-1536x864.jpeg 1536w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tunc-2048x1152.jpeg 2048w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<\/ul>\n<p dir=\"ltr\"><em>Question: Why does SQL run AND before OR, and how often do missing parentheses give wrong results without anyone noticing?<\/em><\/p>\n<p dir=\"ltr\"><span style=\"text-decoration: underline\"><em><strong>Chapter 5: Spatial Data<\/strong><\/em><\/span><\/p>\n<ul dir=\"ltr\">\n<li><em>In raw latitude\/longitude, the poles stretch into lines and Greenland and Antarctica look huge. Switching the map to Robinson fixes most of that.<\/em><\/li>\n<li><em>For the US I used Albers Equal Area Conic, the standard projection for USGS and Census maps, because it keeps areas accurate.<\/em><\/li>\n<li><em>Local maps use State Plane. Adding the Municipalities layer switched the whole map to PA South, and the lat\/long Tracts layer was projected on the fly.<\/em><\/li>\n<li><em>Turned a table of NYC library X\/Y coordinates into points. My first two tries came out empty because no coordinate system was set. Setting State Plane NY Long Island (3104) fixed it.<\/em><\/li>\n<\/ul>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-7722\" src=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-spib-300x169.png\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-spib-300x169.png 300w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-spib-1024x576.png 1024w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-spib-768x432.png 768w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-spib-1536x864.png 1536w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-spib-2048x1152.png 2048w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-7723\" src=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-sxau-300x169.png\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-sxau-300x169.png 300w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-sxau-1024x576.png 1024w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-sxau-768x432.png 768w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-sxau-1536x864.png 1536w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-sxau-2048x1152.png 2048w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7724\" src=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-syno-300x169.jpeg\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-syno-300x169.jpeg 300w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-syno-1024x576.jpeg 1024w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-syno-768x432.jpeg 768w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-syno-1536x864.jpeg 1536w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-syno-2048x1152.jpeg 2048w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p dir=\"ltr\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7725\" src=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-teca-300x169.jpeg\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-teca-300x169.jpeg 300w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-teca-1024x576.jpeg 1024w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-teca-768x432.jpeg 768w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-teca-1536x864.jpeg 1536w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-teca-2048x1152.jpeg 2048w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p dir=\"ltr\">\n<p dir=\"ltr\"><em>Question: If layers get projected on the fly anyway, when does it actually matter which coordinate system the data is stored in?<\/em><\/p>\n<p dir=\"ltr\"><span style=\"text-decoration: underline\"><em><strong>Chapter 6: Geoprocessing<\/strong><\/em><\/span><\/p>\n<ul dir=\"ltr\">\n<li><em>Pairwise Dissolve merged Manhattan block groups into neighborhoods by name and removed the inner boundaries.<\/em><\/li>\n<li><em>For the Upper West Side, I exported the neighborhood, used Select By Location on the streets, then clipped them so they stop exactly at the boundary.<\/em><\/li>\n<li><em><em>Merge combined five separate borough water layers into one NYC water layer.<br \/>\n<\/em><\/em><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7726\" src=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tfst-300x169.jpeg\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tfst-300x169.jpeg 300w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tfst-1024x576.jpeg 1024w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tfst-768x432.jpeg 768w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tfst-1536x864.jpeg 1536w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tfst-2048x1152.jpeg 2048w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7727\" src=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tixe-300x169.jpeg\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tixe-300x169.jpeg 300w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tixe-1024x576.jpeg 1024w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tixe-768x432.jpeg 768w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tixe-1536x864.jpeg 1536w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tixe-2048x1152.jpeg 2048w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7728\" src=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tked-300x169.jpeg\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tked-300x169.jpeg 300w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tked-1024x576.jpeg 1024w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tked-768x432.jpeg 768w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tked-1536x864.jpeg 1536w, https:\/\/sites.owu.edu\/geog-291\/wp-content\/uploads\/sites\/208\/2026\/09\/SCR-20260929-tked-2048x1152.jpeg 2048w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p dir=\"ltr\">\n<p dir=\"ltr\"><em>Question: Clip, Intersect, and Tabulate Intersection all overlay two layers. How do you decide which one fits a question?<\/em><\/p>\n<p dir=\"ltr\">\n","protected":false},"excerpt":{"rendered":"<p>Chapter 4: File Geodatabases A file geodatabase (.gdb) is Esri&#8217;s preferred way to store feature classes and tables, so shapefiles and CSVs get imported into it first. A join only works when both key fields are the same data type, which is why the text GEOID has to be turned into a number before joining census data. Spatial Join counts points inside polygons, such as burglaries per neighborhood. . Question: Why does SQL run AND before OR, and how often do missing parentheses give wrong results without anyone noticing? Chapter 5: Spatial Data In raw latitude\/longitude, the poles stretch into lines and Greenland and Antarctica look huge. Switching the map to Robinson fixes most of that. For the US I used Albers Equal Area Conic, the standard projection for USGS and Census maps, because it keeps areas accurate. Local maps use State Plane. Adding the Municipalities layer switched the whole map to PA South, and the lat\/long Tracts layer was projected on the fly. Turned a table of NYC library X\/Y coordinates into points. My first two tries came out empty because no coordinate system was set. Setting State Plane NY Long Island (3104) fixed it. Question: If layers get projected on the fly anyway, when does it actually matter which coordinate system the data is stored in? Chapter 6: Geoprocessing Pairwise Dissolve merged Manhattan block groups into neighborhoods by name and removed the inner boundaries. For the Upper West Side, I exported the neighborhood, used Select By Location on the streets, then clipped them so they stop exactly at the boundary. Merge combined five separate borough water layers into one NYC water layer. Question: Clip, Intersect, and Tabulate Intersection all overlay two layers. How do you decide which one fits a question?<\/p>\n","protected":false},"author":2362,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-7720","post","type-post","status-publish","format-standard","hentry","category-course-student-work"],"_links":{"self":[{"href":"https:\/\/sites.owu.edu\/geog-291\/wp-json\/wp\/v2\/posts\/7720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.owu.edu\/geog-291\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.owu.edu\/geog-291\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-291\/wp-json\/wp\/v2\/users\/2362"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-291\/wp-json\/wp\/v2\/comments?post=7720"}],"version-history":[{"count":1,"href":"https:\/\/sites.owu.edu\/geog-291\/wp-json\/wp\/v2\/posts\/7720\/revisions"}],"predecessor-version":[{"id":7730,"href":"https:\/\/sites.owu.edu\/geog-291\/wp-json\/wp\/v2\/posts\/7720\/revisions\/7730"}],"wp:attachment":[{"href":"https:\/\/sites.owu.edu\/geog-291\/wp-json\/wp\/v2\/media?parent=7720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-291\/wp-json\/wp\/v2\/categories?post=7720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-291\/wp-json\/wp\/v2\/tags?post=7720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}