gis tutorial 1 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
GIS Tutorial 1 PowerPoint Presentation
Download Presentation
GIS Tutorial 1

Loading in 2 Seconds...

play fullscreen
1 / 72

GIS Tutorial 1 - PowerPoint PPT Presentation


  • 297 Views
  • Uploaded on

GIS Tutorial 1. Lecture 4 Geodatabases. Outline. Data types Geodatabases Data table joins Spatial joins Field calculator Calculate geometry ArcCatalog functions. Lecture 4. Data types . Directly loadable data types. dBase (.dbf) Text with comma (.csv) or tab-separated values (.txt)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'GIS Tutorial 1' - ailsa


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
gis tutorial 1
GIS Tutorial 1

Lecture 4

Geodatabases

outline
Outline
  • Data types
  • Geodatabases
  • Data table joins
  • Spatial joins
  • Field calculator
  • Calculate geometry
  • ArcCatalog functions

GIS TUTORIAL 1 - Basic Workbook

data types
Lecture 4Data types

GIS TUTORIAL 1 - Basic Workbook

directly loadable data types
Directly loadable data types
  • dBase (.dbf)
  • Text with comma (.csv) or tab-separated values (.txt)
  • Microsoft Access (.mdb)
  • Microsoft Excel (.xls)

GIS TUTORIAL 1 - Basic Workbook

data table formats
Data table formats
  • First row must have attribute names with self-documenting labels
    • (e.g. Pop5To17, Area)
  • Usual naming convention
    • first character is a letter
    • remaining characters be any letters, digits, or the underscore character
  • All additional rows of a data table need to contain attribute values
  • None of the rows can be sums, averages, or other statistics of raw data rows

GIS TUTORIAL 1 - Basic Workbook

data table formats6
Data table formats
  • dBase field names
    • Maximum 10 characters

GIS TUTORIAL 1 - Basic Workbook

geodatabases
Lecture 4geodatabases

GIS TUTORIAL 1 - Basic Workbook

geodatabase types
Geodatabase types

Manages features and tables inside a

database management system

  • File geodatabase
    • stores datasets in a folder of files
    • each dataset a file up to 1 TB in size
    • can be used across platforms
    • can be compressed and encrypted for read-only, secure use
    • ESRI’s recommended choice

GIS TUTORIAL 1 - Basic Workbook

geodatabase types9
Geodatabase types
  • Personal geodatabase
    • stores datasets in a Microsoft Access .mdb file
    • storage sizes between 250 and 500 MB
    • limited to 2GB
    • only supported on Windows
    • some higher level GIS functions can only be

performed if a geodatabase is created

  • ArcSDE geodatabase
    • stores datasets in a number of optional DBMSs:
      • IBM DB2, IBM Informix , Microsoft SQL Server , Oracle, or PostgreSQL
    • unlimited size and users

GIS TUTORIAL 1 - Basic Workbook

geometric network in a geodatabase
Geometric Network in a Geodatabase
  • Example of
  • higher level
  • GIS Function

GIS TUTORIAL 1 - Basic Workbook

new file geodatabase
New file geodatabase

ArcCatalog: select File> New> File geodatabase or Personal geodatabase> type name of new geodatbase

GIS TUTORIAL 1 - Basic Workbook

import into geodatabase
Import into geodatabase

Shapefile features

GIS TUTORIAL 1 - Basic Workbook

import into geodatabase13
Import into geodatabase
  • Tables

GIS TUTORIAL 1 - Basic Workbook

export from geodatabase
Export from geodatabase

GIS TUTORIAL 1 - Basic Workbook

compact geodatabases
Compact geodatabases
  • File and personal geodatabases
    • Reduces size and improves performance
    • Compact personal geodatabases > 250 MB.
    • Geodatabases with frequent data entry, deletion, or general editing
    • Open geodatabases in ArcMap cannot be compacted
      • remove any layers with a source table or feature class in that database from the TOC

GIS TUTORIAL 1 - Basic Workbook

compress geodatabases
Compress geodatabases
  • File geodatabases
    • Once compressed, a feature class or table is read-only and cannot be edited
    • Compression is ideally suited to mature datasets that do not require further editing
    • Compressed dataset can be uncompressed to return it to its original, read-write format

GIS TUTORIAL 1 - Basic Workbook

view geodatabases
View geodatabases
  • Cannot identify names in Windows Explorer
  • Must use ArcCatalog

GIS TUTORIAL 1 - Basic Workbook

data table joins relates
Lecture 4Data table joins & Relates

GIS TUTORIAL 1 - Basic Workbook

data table joins
Data table joins
  • Putting two tables together to make one table
  • Join two tables one-to-one by row
  • Must have the same values and data types

GIS TUTORIAL 1 - Basic Workbook

slide20

Joins and Relates

  • Two methods to associate tables in ArcMap based on a common field
  • Join appends the attributes
  • from one on to the other table
  • Relate defines a relationship
  • between two tables

GIS TUTORIAL 1 - Basic Workbook

slide21

Join or Relates Usage:

  • Join- Assumes one-to-one or many-to-one cardinality
  • - Appends the attributes of the two tables
  • - i.e. parcel polygon table one unique permanent parcel
  • number (ppn) is matched to an Auditor attribute characteristic
  • table (property value) with one unique ppn
  • Relates- Assumes many-to-many or one-to-many cardinality
  • - Tables remain independent
  • - i.e. if you select a building, you can find all the tenants that
  • occupy that building. Similarly, if you select a tenant, you can find
  • what building he/she resides in (or several buildings, in the case of a
  • chain of stores in multiple shopping centers—a many-to-many
  • relationship).

GIS TUTORIAL 1 - Basic Workbook

join example
Join example
  • Housing heating fuel study for U.S. Counties
    • Source: U.S. Census
      • Data table: Census SF3 table for heating fuel by county
      • Map Features: County polygons

GIS TUTORIAL 1 - Basic Workbook

data table
Data table
  • Heating fuel table (Excel spreadsheet)

GIS TUTORIAL 1 - Basic Workbook

data table24
Data table
  • Heating fuel table data dictionary
    • H040001: Occupied housing units: House heating fuel; TOTAL Units
    • H040002: Occupied housing units: House heating fuel; Utility gas
    • H040003: Occupied housing units: House heating fuel; Bottled; tank; or LP gas
    • H040004: Occupied housing units: House heating fuel; Electricity
    • H040005: Occupied housing units: House heating fuel; Fuel oil; kerosene; etc.
    • H040006: Occupied housing units: House heating fuel; Coal or coke
    • H040007: Occupied housing units: House heating fuel; Wood
    • H040008: Occupied housing units: House heating fuel; Solar energy
    • H040009: Occupied housing units: House heating fuel; Other fuel
    • H040010: Occupied housing units: House heating fuel; No fuel used

GIS TUTORIAL 1 - Basic Workbook

feature class
Feature class
  • County polygons

GIS TUTORIAL 1 - Basic Workbook

add data and features to map
Add data and features to map

GIS TUTORIAL 1 - Basic Workbook

open attribute tables
Open attribute tables
  • Find common attribute to join

GIS TUTORIAL 1 - Basic Workbook

data problem
Data problem
  • FIPS has leading zero and is a TEXT field.
  • GEO_ID2 is a NUMBER fieldwith no leading zeros.

GIS TUTORIAL 1 - Basic Workbook

data solution
Data solution
  • Make a new NUMBER field in Counties attribute table and use field calculator to populate new field from old

GIS TUTORIAL 1 - Basic Workbook

data solution30
Data solution
  • New FIPS_NUM is same as GEO_ID2 and ready to join

GIS TUTORIAL 1 - Basic Workbook

join tables
Join tables

GIS TUTORIAL 1 - Basic Workbook

join result
Join result
  • Heating fuel data is now listed for every county in the USCounties feature attribute table

GIS TUTORIAL 1 - Basic Workbook

permanent joins
Permanent joins
  • Joins are temporary and can be removed
  • Export data to make joins permanent

GIS TUTORIAL 1 - Basic Workbook

choropleth map result
Choropleth map result

GIS TUTORIAL 1 - Basic Workbook

spatial joins
Lecture 4Spatial joins

GIS TUTORIAL 1 - Basic Workbook

spatial join example
Spatial join example
  • You have census block group centroids with housing fuel data
  • You want to know housing fuel data by neighborhoods
  • No attributes in common
  • Spatial join needed

GIS TUTORIAL 1 - Basic Workbook

spatial joins37
Spatial joins
  • Points to polygons
    • Spatially joins points (block centroids) within polygons (neighborhoods)
    • Joins using “shape” (not attribute field)

GIS TUTORIAL 1 - Basic Workbook

spatial joins38
Spatial joins
  • Right click polygon layer (neighborhoods)

GIS TUTORIAL 1 - Basic Workbook

join result39
Join result
  • New polygon feature

GIS TUTORIAL 1 - Basic Workbook

join result40
Join result
  • Counts and sums

GIS TUTORIAL 1 - Basic Workbook

count result
Count result
  • Number of points in each polygon

GIS TUTORIAL 1 - Basic Workbook

sum result
Sum result
  • Every block group centroid has associated data
    • (e.g. H040004, heating electricity shown in labels)

GIS TUTORIAL 1 - Basic Workbook

sum result43
Sum result
  • One neighborhood example
    • Central business district
      • 4 block groups
      • Housing units with electricity fuel (80 + 299 + 128 + 292 )
      • Sum = 799

GIS TUTORIAL 1 - Basic Workbook

choropleth map result sum
Choropleth map result (sum)

GIS TUTORIAL 1 - Basic Workbook

choropleth map result sum45
Choropleth map result (sum)

GIS TUTORIAL 1 - Basic Workbook

other spatial joins
Other spatial joins
  • Polygons to points
    • Example: ATM robberies (points) need neighborhood name

GIS TUTORIAL 1 - Basic Workbook

polygon to point join result
Polygon to point join result
  • Neighborhood name shows on each point

GIS TUTORIAL 1 - Basic Workbook

other spatial joins48
Other spatial joins
  • Points to points
    • Example: What is the distance of a burglary to the nearest commercial property?

GIS TUTORIAL 1 - Basic Workbook

point to point join result
Point to point join result
  • Distance to nearest commercial property shows on each burglary point

GIS TUTORIAL 1 - Basic Workbook

field calculator
Lecture 4Field calculator

GIS TUTORIAL 1 - Basic Workbook

sample functions
Sample functions
  • Performs numeric calculations
  • Populates field
  • Concatenates textdata

GIS TUTORIAL 1 - Basic Workbook

field calculator functions
Field calculator functions
  • Calculate acres to square miles

GIS TUTORIAL 1 - Basic Workbook

field calculator functions53
Field calculator functions
  • Populate field with county name

GIS TUTORIAL 1 - Basic Workbook

field calculator functions54
Field calculator functions
  • Concatenate house number and street fields

GIS TUTORIAL 1 - Basic Workbook

calculate geometry
Lecture 4CalculatE geometry

GIS TUTORIAL 1 - Basic Workbook

polygon point centroids
Polygon/point centroids
  • Advanced calculations for finding a polygon’s point centroid

GIS TUTORIAL 1 - Basic Workbook

calculate xy fields
Calculate XY fields
  • Add new X and Y fields in the attribute table

GIS TUTORIAL 1 - Basic Workbook

calculate xy fields58
Calculate XY fields
  • Calculate geometry for X field, repeat for Y

GIS TUTORIAL 1 - Basic Workbook

xy field results
XY field results
  • Results are X and Y values based on map properties (e.g. Long/Lat or XY feet)

GIS TUTORIAL 1 - Basic Workbook

export xy coordinates
Export XY coordinates

GIS TUTORIAL 1 - Basic Workbook

add xy data table
Add XY data table

GIS TUTORIAL 1 - Basic Workbook

export as shapefile
Export as shapefile
  • XY events should be exported as permanent shapefile or feature class

GIS TUTORIAL 1 - Basic Workbook

calculate area
Calculate area
  • Add area field and calculate geometry

GIS TUTORIAL 1 - Basic Workbook

calculate perimeter
Calculate perimeter
  • Add perimeter field and calculate script

GIS TUTORIAL 1 - Basic Workbook

calculate length
Calculate length
  • Add length field and calculate script

GIS TUTORIAL 1 - Basic Workbook

arccatalog functions
Lecture 4Arccatalog functions

GIS TUTORIAL 1 - Basic Workbook

basic functions
Basic functions
  • Copy, paste, rename, etc.

GIS TUTORIAL 1 - Basic Workbook

view and edit properties
View and edit properties
  • Projections, fields, etc.

GIS TUTORIAL 1 - Basic Workbook

view metadata
View metadata

GIS TUTORIAL 1 - Basic Workbook

edit metadata
Edit metadata

GIS TUTORIAL 1 - Basic Workbook

create new files
Create new files
  • Geodatabases, tables, features, etc.

GIS TUTORIAL 1 - Basic Workbook

summary
Summary
  • Data types
  • Geodatabases
  • Data table joins
  • Spatial joins
  • Field calculator
  • Calculate geometry
  • ArcCatalog functions

GIS TUTORIAL 1 - Basic Workbook