Skip to main content
Geographic Information Systems

Return to Answer

deleted 123 characters in body
Source Link
Abe
Abe
  • 1.9k
  • 3
  • 22
  • 29

A workflow used to generate county level shape file with mean(z) in each county from an xyz data table in ArcGIS

note this is based on @MLowry's suggestion, adding almost step-by-step instructions.

Open ArcCatalog##

  1. create new personal geodatabase (e.g. foo.mdb)
  2. file -> new -> personal geodatabase
  3. add data
  • right click on map.csv -> export to geodatabase (single) -> foo.mdb (note not clear if this needs to be exported to geodatabase, but this is how I made a table from the csv)
  • right click on counties.lyr -> export to geodatabase (single) -> foo.mdb
  • select map.csv file --> select output geodatabase --> ok
  1. create featureclass (.shp files) from xy table
  • open foo.mdb
  • right click map.csv table --> create featureclass from xytable
  • input fields x = lon, y = lat, z = yield
  • coordinate system of input coordinates import -> from counties.lyr (or, equivalently, -> geographic .. -> world -> wgs_1984 -> open -> ok)
  1. import feature classes to geodatabase (multiple)
  • select shp files created in prev. step -> add -> okay

Open ArcMap

  1. Add data
  • select foo.mdb -> CTL + select tables -> open
  1. Spatial Join
  • ArcToolbox -> Analysis Tools -> Overlay -> Spatial Join ->
  • Target Features: counties.lyr
  • Join Features: xyz table map
  • Output Feature Class: filename_spatialjoin
  • Join Operation: JOIN_ONE_TO_ONE
  • Match Option: Closest
  • Field Map of Join Features: remove unwanted fields (only STATE_FIPS, CNTY_FIPS, z-values required
  • Search Radius: 30km
  • click OK
  • Z value = yield; select 'mean' (or alternative statistic)

A workflow used to generate county level shape file with mean(z) in each county from an xyz data table in ArcGIS

note this is based on @MLowry's suggestion, adding almost step-by-step instructions.

Open ArcCatalog##

  1. create new personal geodatabase (e.g. foo.mdb)
  2. file -> new -> personal geodatabase
  3. add data
  • right click on map.csv -> export to geodatabase (single) -> foo.mdb (note not clear if this needs to be exported to geodatabase, but this is how I made a table from the csv)
  • right click on counties.lyr -> export to geodatabase (single) -> foo.mdb
  • select map.csv file --> select output geodatabase --> ok
  1. create featureclass (.shp files) from xy table
  • open foo.mdb
  • right click table
  • input fields x = lon, y = lat, z = yield
  • coordinate system of input coordinates import -> from counties.lyr (or, equivalently, -> geographic .. -> world -> wgs_1984 -> open -> ok)
  1. import feature classes to geodatabase (multiple)
  • select shp files created in prev. step -> add -> okay

Open ArcMap

  1. Add data
  • select foo.mdb -> CTL + select tables -> open
  1. Spatial Join
  • ArcToolbox -> Analysis Tools -> Overlay -> Spatial Join ->
  • Target Features: counties.lyr
  • Join Features: xyz table map
  • Output Feature Class: filename_spatialjoin
  • Join Operation: JOIN_ONE_TO_ONE
  • Match Option: Closest
  • Field Map of Join Features: remove unwanted fields (only STATE_FIPS, CNTY_FIPS, z-values required
  • Search Radius: 30km
  • click OK
  • Z value = yield; select 'mean' (or alternative statistic)

A workflow used to generate county level shape file with mean(z) in each county from an xyz data table in ArcGIS

note this is based on @MLowry's suggestion, adding almost step-by-step instructions.

Open ArcCatalog##

  1. create new personal geodatabase (e.g. foo.mdb)
  2. file -> new -> personal geodatabase
  3. add data
  • right click on map.csv -> export to geodatabase (single) -> foo.mdb
  • right click on counties.lyr -> export to geodatabase (single) -> foo.mdb
  1. create featureclass (.shp files) from xy table
  • open foo.mdb
  • right click map.csv table --> create featureclass from xytable
  • input fields x = lon, y = lat, z = yield
  • coordinate system of input coordinates import -> from counties.lyr (or, equivalently, -> geographic .. -> world -> wgs_1984 -> open -> ok)
  1. import feature classes to geodatabase (multiple)
  • select shp files created in prev. step -> add -> okay

Open ArcMap

  1. Add data
  • select foo.mdb -> CTL + select tables -> open
  1. Spatial Join
  • ArcToolbox -> Analysis Tools -> Overlay -> Spatial Join ->
  • Target Features: counties.lyr
  • Join Features: xyz table map
  • Output Feature Class: filename_spatialjoin
  • Join Operation: JOIN_ONE_TO_ONE
  • Match Option: Closest
  • Field Map of Join Features: remove unwanted fields (only STATE_FIPS, CNTY_FIPS, z-values required
  • Search Radius: 30km
  • click OK
  • Z value = yield; select 'mean' (or alternative statistic)
added 299 characters in body; edited body
Source Link
Abe
Abe
  • 1.9k
  • 3
  • 22
  • 29

A workflow used to generate county level shape file with mean(z) in each county from an xyz data table in ArcGIS

note this is based on @MLowry's suggestion, adding almost step-by-step instructions.

Open ArcCatalog##

  1. create new personal geodatabase (e.g. foo.mdb)
  2. file -> new -> personal geodatabase
  3. add data
  • right click on map.csv -> export to geodatabase (single) -> foo.mdb (note not clear if this needs to be exported to geodatabase, but this is how I made a table from the csv)
  • right click on counties.lyr -> export to geodatabase (single) -> foo.mdb
  • select map.csv file --> select output geodatabase --> ok
  1. create featureclass (.shp files) from xy table
  • open foo.mdb
  • right click table
  • input fields x = lon, y = lat, z = yield
  • coordinate system of input coordinates import -> from counties.lyr (or, equivalently, -> geographic .. -> world -> wgs_1984 -> open -> ok)
  1. import feature classes to geodatabase (multiple)
  • select shp files created in prev. step -> add -> okay

Open ArcMap

  1. Add data
  • select foo.mdb -> CTL + select tables -> open
  1. Spatial Join
  • ArcToolbox -> Spatial StatisticsAnalysis Tools -> Overlay -> Spatial Join -> Join
  • Target Features: counties.lyr to
  • Join Features: xyz table map
  • Output Feature Class: filename_spatialjoin
  • Join Operation: JOIN_ONE_TO_ONE
  • Match Option: Closest
  • Field Map of Join Features: remove unwanted fields (only STATE_FIPS, CNTY_FIPS, z-values required
  • Search Radius: 30km
  • click OK
  • Z value = yield; select 'mean' (or alternative statistic)

A workflow used to generate county level shape file with mean(z) in each county from an xyz data table in ArcGIS

note this is based on @MLowry's suggestion, adding almost step-by-step instructions.

Open ArcCatalog##

  1. create new personal geodatabase (e.g. foo.mdb)
  2. file -> new -> personal geodatabase
  3. add data
  • right click on map.csv -> export to geodatabase (single) -> foo.mdb (note not clear if this needs to be exported to geodatabase, but this is how I made a table from the csv)
  • right click on counties.lyr -> export to geodatabase (single) -> foo.mdb
  • select map.csv file --> select output geodatabase --> ok
  1. create featureclass (.shp files) from xy table
  • open foo.mdb
  • right click table
  • input fields x = lon, y = lat, z = yield
  • coordinate system of input coordinates import -> from counties.lyr (or, equivalently, -> geographic .. -> world -> wgs_1984 -> open -> ok)
  1. import feature classes to geodatabase (multiple)
  • select shp files created in prev. step -> add -> okay

Open ArcMap

  1. Add data
  • select foo.mdb -> CTL + select tables -> open
  1. Spatial Join
  • ArcToolbox -> Spatial Statistics -> Spatial Join -> Join counties.lyr to xyz table map
  • Z value = yield; select 'mean' (or alternative statistic)

A workflow used to generate county level shape file with mean(z) in each county from an xyz data table in ArcGIS

note this is based on @MLowry's suggestion, adding almost step-by-step instructions.

Open ArcCatalog##

  1. create new personal geodatabase (e.g. foo.mdb)
  2. file -> new -> personal geodatabase
  3. add data
  • right click on map.csv -> export to geodatabase (single) -> foo.mdb (note not clear if this needs to be exported to geodatabase, but this is how I made a table from the csv)
  • right click on counties.lyr -> export to geodatabase (single) -> foo.mdb
  • select map.csv file --> select output geodatabase --> ok
  1. create featureclass (.shp files) from xy table
  • open foo.mdb
  • right click table
  • input fields x = lon, y = lat, z = yield
  • coordinate system of input coordinates import -> from counties.lyr (or, equivalently, -> geographic .. -> world -> wgs_1984 -> open -> ok)
  1. import feature classes to geodatabase (multiple)
  • select shp files created in prev. step -> add -> okay

Open ArcMap

  1. Add data
  • select foo.mdb -> CTL + select tables -> open
  1. Spatial Join
  • ArcToolbox -> Analysis Tools -> Overlay -> Spatial Join ->
  • Target Features: counties.lyr
  • Join Features: xyz table map
  • Output Feature Class: filename_spatialjoin
  • Join Operation: JOIN_ONE_TO_ONE
  • Match Option: Closest
  • Field Map of Join Features: remove unwanted fields (only STATE_FIPS, CNTY_FIPS, z-values required
  • Search Radius: 30km
  • click OK
  • Z value = yield; select 'mean' (or alternative statistic)
added 107 characters in body; added 90 characters in body; added 20 characters in body
Source Link
David LeBauer
David LeBauer
  • 564
  • 3
  • 5
  • 19

A workflow used to generate raster layerscounty level shape file with mean(z) in each county from an xyz data table in ArcGIS

note this is based on @MLowry's suggestion, adding almost step-by-step instructions.

Open ArcCatalog##

  1. create new personal geodatabase (e.g. foo.mdb)
  2. file -> new -> personal geodatabase
  3. add data
  • right click on csvmap.csv -> export to geodatabase (multiplesingle) -> foo.mdb (note not clear if this needs to be exported to geodatabase, but this is how I made a table from the csv)
  • right click on counties.lyr -> export to geodatabase (single) -> foo.mdb
  • select csv filesmap.csv file --> select output geodatabase --> ok
  1. create featureclass (.shp files) from xy table
  • open foo.mdb
  • right click table
  • input fields x = lon, y = lat, z = yield
  • coordinate system of input coordinates selectimport -> coordinate systemsfrom counties.lyr (or, equivalently, -> geographic .. -> world -> wgs_1984 -> open -> ok)
  1. import feature classes to geodatabase (multiple)
  • select shp files created in prev. step -> add -> okay

Open ArcMap

  1. Add data
  • select foo.mdb -> CTL + select tables -> open
  1. Spatial Join
  • ArcToolbox -> Spatial Statistics -> Spatial Join -> Join counties.lyr to xyz table map
  • Z value = yield; select 'mean' (or alternative statistic)
  • repeat for each layer (will create three join files)

A workflow used to generate raster layers from xyz data in ArcGIS

Open ArcCatalog##

  1. create new personal geodatabase (e.g. foo.mdb)
  2. file -> new -> personal geodatabase
  3. add data
  • right click on csv -> export to geodatabase (multiple) -> foo.mdb
  • right click on counties.lyr -> export to geodatabase (single) -> foo.mdb
  • select csv files --> select output geodatabase --> ok
  1. create featureclass (.shp files) from xy table
  • open foo.mdb
  • right click table
  • input fields x = lon, y = lat, z = yield
  • coordinate system of input coordinates select -> coordinate systems -> geographic .. -> world -> wgs_1984 -> open -> ok
  1. import feature classes to geodatabase (multiple)
  • select shp files created in prev. step -> add -> okay

Open ArcMap

  1. Add data
  • select foo.mdb -> CTL + select tables -> open
  1. Spatial Join
  • ArcToolbox -> Spatial Statistics -> Spatial Join -> Join counties.lyr to xyz table
  • Z value = yield; select 'mean' (or alternative statistic)
  • repeat for each layer (will create three join files)

A workflow used to generate county level shape file with mean(z) in each county from an xyz data table in ArcGIS

note this is based on @MLowry's suggestion, adding almost step-by-step instructions.

Open ArcCatalog##

  1. create new personal geodatabase (e.g. foo.mdb)
  2. file -> new -> personal geodatabase
  3. add data
  • right click on map.csv -> export to geodatabase (single) -> foo.mdb (note not clear if this needs to be exported to geodatabase, but this is how I made a table from the csv)
  • right click on counties.lyr -> export to geodatabase (single) -> foo.mdb
  • select map.csv file --> select output geodatabase --> ok
  1. create featureclass (.shp files) from xy table
  • open foo.mdb
  • right click table
  • input fields x = lon, y = lat, z = yield
  • coordinate system of input coordinates import -> from counties.lyr (or, equivalently, -> geographic .. -> world -> wgs_1984 -> open -> ok)
  1. import feature classes to geodatabase (multiple)
  • select shp files created in prev. step -> add -> okay

Open ArcMap

  1. Add data
  • select foo.mdb -> CTL + select tables -> open
  1. Spatial Join
  • ArcToolbox -> Spatial Statistics -> Spatial Join -> Join counties.lyr to xyz table map
  • Z value = yield; select 'mean' (or alternative statistic)
fixex according to whuber's comments; added 56 characters in body
Source Link
David LeBauer
David LeBauer
  • 564
  • 3
  • 5
  • 19
Post Made Community Wiki
Source Link
David LeBauer
David LeBauer
  • 564
  • 3
  • 5
  • 19