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
- Slides: 60