Attribute Extraction GIS 1 Attribute query extraction You

Attribute Extraction GIS 1

Attribute query extraction You have tracts for an entire state, but want tracts for one county only GIS 2

Attribute query extraction Select tracts by County FIPS or ANSI ID • Cook County = 031 GIS 3

Attribute query extraction • Cook County tracts are selected • Export to new feature class or shapefile GIS 4

Export selected features GIS 5

Add new layer Cook County tracts GIS 6

Select by Location GIS 7

Select By Location City of Pittsburgh tracts within municipality GIS 8

Select by Location Select municipality of Pittsburgh first GIS 9

Select by Location GIS 10

Selected Features GIS 11

Other Proximity Queries GIS 12

Points Near Polygons Schools near parks GIS 13

Points Near Polygons View schools in attribute table GIS 14

Points Near Points Schools are near convenient stores GIS 15

Polygons Intersecting Lines Neighborhoods that Intersect Streets GIS 16

Lines Intersecting Polygons Streets or sidewalks that intersect floodplains GIS 17

Polygons Intersecting Polygons Buildings completely within zoning area GIS 18

Clipping Features GIS 19

Arc. Toolbox GIS 20

Clip Acts like a “cookie cutter” to create a subset of features. Input features (streets) Clip features (Central Business District) Output features (CBD streets) GIS 21

Clip vs Select By Location Clip • Clean edges • Looks good Select by Location • Dangling edges • Better for geocoding GIS 22

Clip vs Select by Location Penn Avenue – ranging from street segment 1000 -1098 GIS 23

Dissolving Features GIS 24

Arc. Toolbox GIS 25

Dissolve Create regions using U. S. States • Use SUB_REGION field to dissolve • Sum population GIS 26

Dissolve Results States dissolved to form regions Population summed for each region GIS 27

Appending Features GIS 28

Arc. Toolbox GIS 29

Appends one or more data sets into an existing data set • features must be of the same type • input datasets may overlap one another and/or the target dataset • TEST option: field definitions of the feature classes must be the same and in the same order for all appended features • NO TEST option: Input features schemas do not have to match the target feature classes's schema GIS 30

Append Du. Page and Cook County are combining public works and need a new single street centerline file GIS 31

Append will add Du. Page streets to Cook County Streets GIS 32

Resultant Layer One street layer (Cook County) with all records and field items GIS 33

Merging Features GIS 34

Arc. Toolbox GIS 35

Merge Combines multiple input datasets of the same data type into a single, new output dataset GIS 36

Resultant Layer New merged voting district layer GIS 37

Union Features GIS 38

Arc. Toolbox GIS 39

Union Overlays two polygon layers • resulting output layer has combined attribute data of the two inputs • contains all the polygons from the inputs, whether or not they overlap GIS 40

Union Neighborhoods and zip codes GIS 41

Union Better describes characteristics of a neighborhood. • Central business district 15222 vs 15219 GIS 42

Union Attributes tables contain different fields and data GIS 43

Union Results u New polygons with combined data GIS 44

Intersecting Features GIS 45

Arc. Toolbox GIS 46

Intersect Floodzones and buildings GIS 47

Intersect Result Only building polygons that intersect flood zones with combined data fields GIS 48

Model Builder GIS 49

Model builder overview Workflow processes can be complicated Models automate and string functions together Example • You have census tracts for a county and want to create neighborhoods for a city • Many steps are needed to create neighborhoods (join, dissolve, etc) GIS 50

Starting map TIGER census tracts and municipalities GIS 51

Final map Tracts dissolved to create neighborhoods GIS 52

Crosswalk table Neighborhood names are not included with the census tracts, so a crosswalk table was created with the name of neighborhood for each census tract Some neighborhoods are made of multiple tracts GIS 53

Set geoprocessing options Geoprocessing, geoprocessing options GIS 54

Create a new toolbox Catalog GIS 55

Create a new model Right-click new Toolbox GIS 56

Add tool to model Add Join Tool • To join crosswalk table to tracts… GIS 57

Set parameter for Join Tool Joins crosswalk table to census tracts GIS 58

Model steps Add Join Dissolve Remove join GIS 59

Finished model GIS 60