1 / 19

Applied GIS - 4215

Applied GIS - 4215. Project 3: Database Management Exercise Geodatabase and Topology. By Stephanie Wilkie. Topology. Part I As an employee in the GIS department of a forestry company, my current task is to check topological errors in and between layers. Topology. In Arc GIS…

eara
Download Presentation

Applied GIS - 4215

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Applied GIS - 4215 Project 3: Database Management Exercise Geodatabase and Topology By Stephanie Wilkie

  2. Topology Part I As an employee in the GIS department of a forestry company, my current task is to check topological errors in and between layers.

  3. Topology • In Arc GIS… • Topological rules were created • These rules were checked within and between specified layers to reveal errors • Errors were fixed using the editor tool in Arc Map • Fixed errors were then validated

  4. Topology

  5. Subtype and Attribute Domain Creation Part II New fields and attribute descriptions must be added to the FRI GIS files due to recent changes in forest management policies.

  6. Subtype and Attribute Domain Creation • Attribute domains for the new fields and attributes were created using subtypes based on the STYPE field. • Three or more records were chosen from each of the existing stand types. Attribute domains where created and specified for three selected fields.

  7. Subtype and Attribute Domain Creation

  8. Subtype and Attribute Domain Creation

  9. For the birds… Part III A series of queries were performed in the bird survey database to obtain solutions for the following scenarios…

  10. Scenario 1 A peer thinks there are more ravens in her operating area than mine. I think she’s wrong. We decide to check the database for raven sightings in stands 20 years of age or older that fall within a 100 metre radius of the plot.

  11. Scenario 1 To determine who has the most ravens in their operating area we ran 2 queries: one for my operating area and another for my peer’s operating area. For my operating area (3 and 4) we ran the following query: ("SPECIES_CO" = 'CORA') AND ("POINT_IN" >= 1) AND ("CLUSTER_NU" = 3 OR "CLUSTER_NU" = 4) AND ("AGE" >=20) For my peer’s operating area we ran a similar query, but for operating areas 1 and 2: ("SPECIES_CO" = 'CORA') AND ("POINT_IN" >= 1) AND ("CLUSTER_NU" = 1 OR "CLUSTER_NU" = 2) AND ("AGE" >=20) We found no ravens sightings in the database for either operating area

  12. Scenario 2 A local birder believes that harvest operations are creating negative long-term impacts on yellow-bellied sap sucker habitat. We decide to check the bird survey database for yellow-bellied sap sucker sightings in poplar and balsam fir stands with and without stumps.

  13. Scenario 2 To determine whether yellow-bellied sap suckers have been affected by harvesting operations, two queries were run: one for sightings in areas that have been logged and another for sightings in areas that have no visible signs of past logging operations (i.e. cut stumps) Query for presence of stumps: ("SPECIES_CO" = 'YBSA') AND ("WG" = 33 OR "WG" = 13) AND ("CUT_STUMPS" = 1) Query for no presence of stumps: ("SPECIES_CO" = 'YBSA') AND ("WG" = 33 OR "WG" = 13) AND ("CUT_STUMPS" = 0) The results of the query showed that 6 yellow-bellied sap suckers had been sighted in areas where old stumps were present, and only 3 had been sighted in areas without stumps.

  14. Scenario 3 The company I work for wants to post signs identifying the types of birds that may be found in certain areas along a demonstration trail. It is my job to post a sign at the conifer site. I must determine which birds have been observed in stands that are at least 20 years old and are composed of at least 50% jack pine, black spruce or white spruce.

  15. Scenario 3 To determine which bird species have found to be present in these conditions, I devise the following query: ("PJ" >=5 OR "SW" >=5 OR "SB" >=5) AND ("AGE" >=20) The results of the query are presented in the following table:

  16. Scenario 4 A wildlife researcher wants to know how many observations of magnolia warblers occurred between 5:30 am and 8:00 am in white birch or poplar stands. I think she’s nuts for wanting this information, but I look it up for her anyway.

  17. Scenario 4 To determine the number of magnolia warbler sightings for the biologist, I develop the following query in the bird survey database: ("SPECIES_CO" = 'MAWA') AND ("START_TIME" <=800 AND "START_TIME" >=530) AND ("WG" =33) AND ("AGE" >=20) The results of the query showed there were three magnolia warbler sightings between 5:30 am and 8:00 am in poplar stands at least 20 years of age.

  18. The End

More Related