Tiêu đề Ma GSS 523 Final Report.pdf ✅

1. Introduction 1.1 Background Shelter Island is an island nestled between the North and South Forks of eastern Long Island, within Suffolk County. Shelter Island faces unique challenges related to its lack of water infrastructure and accessibility. The island’s geographic location, coupled with its severe issues concerning groundwater chloride contamination (Simmons 1986), in addition to some of its wells becoming susceptible to saltwater intrusion (Soren 1978), have resulted in a water crisis. 87% of Shelter Island’s population relies on tap water as its source of potable water, with the remaining 13% relying on purchased bottled water for their needs (Lane 2023). Furthermore, certain parts of the island are unable to access tap water during warmer and drier summer months (Land 2023). Efforts to enhance and develop water infrastructure on Shelter Island are often at odds with the prevailing land use, as a significant portion of the island is designated as a nature reserve. This designation imposes strict limitations on construction and development activities, presenting unique challenges for integrating essential water services without disrupting the ecological integrity of the area. This project aims to develop a geodatabase that organizes spatial data related to water sources, such as USGS monitored wells, elevation contours, and existing infrastructure such as streets and residential parcels. By integrating these datasets, this geodatabase can serve as a vital tool for urban planners on Shelter Island, as well as inform decisions based on improving and creating resilient water infrastructure. This project aims to visualize the impacts on populations dependent on vulnerable wells, identifying parcels situated in regions lacking accessible water, and pinpointing wells in areas prone to environmental risks. 1.2 Problem statement The primary geospatial problem facing Shelter Island is ensuring reliable access to clean water for all residents, especially given the challenges posed by its low-lying areas and the risks of saltwater intrusion. The geodatabase is designed to identify areas with inadequate water infrastructure coverage, such as parcels far removed from existing water wells or located in potentially flood-prone zones as indicated by their elevation. Utilizing a geodatabase allows for the application of spatial analyses and queries that can pinpoint which areas of the island are most vulnerable and which might be underserved by current infrastructure. This approach can be useful for understanding daily water supply logistics but also for strategic planning in response to emergency situations and long-term climate resilience initiatives. By consolidating and managing spatial data within a geodatabase, this geodatabase can assist stakeholders in visualizing, analyzing, and acting upon the critical issues impacting water access on Shelter Island.
2. Conceptual Design 2.1 UML Class Diagram Figure 1. Displays UML conceptual design document. Six feature classes are displayed: (1) Shelter Island Streets (2) Shelter Island Census Blocks (3) Shelter Island Parcels (4) USGS Monitored Wells (5) Well Service Areas (6) Elevation Contours. Utilize UML naming cardinality conventions to highlight relationships.
2.2 Conceptual word design template Table 1. Contains a list of feature classes used and specifies the data type. Class Name Spatial or non-spatial? If spatial, specify the type Well Service Areas Polygon USGS Monitored Wells Point Elevation Contours Polygon Shelter Island Streets Line Shelter Island Census Blocks Polygon Shelter Island Parcels Polygon Table 2. Contains attribute names, data types, and constraints for the Well Service Areas polygon feature class. Attribute Name Data Type Constraints ObjectID String Must be entered Well_ID String Must be entered Location Lat/Long Must be entered Shape_Length String Must be entered Shape_Area String Must be entered Shape String (ST_Geometry) Must be entered Table 3. Contains attribute names, data types, and constraints for the USGS Monitored Wells point feature class. Attribute Name Data Type Constraints FID String Must be entered Well_ID String Must be entered Location Lat/Long Must be entered Shape String (ST_Geometry) Must be entered Table 4. Contains attribute names, data types, and constraints for the Elevation Contours polygon feature class. Attribute Name Data Type Constraints Contour_ID String Must be entered Elevation Double Must be entered Closed_Con String (CODED) Must be entered Scale String Must be entered Shape String (ST_Geometry) Must be entered